|
 |
asp_databases thread: Problems with SQL Server (select *)
Message #1 by Mark Eckeard <meckeard2000@y...> on Tue, 20 Mar 2001 20:04:25 -0800 (PST)
|
|
Hi,
I seem to have a problem with come of my code.
I am trying to get all info from my SQL Server DB.
Here is the sql code:
rsofmdb.open "select * from markscoolwebsite"
Here is my output code:
Response.write rsofmdb("FirstName")
Response.write rsofmdb("LastName")
And, here is my error msg:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/pages/view_guests.asp, line 23
Line 23 is the SQL line. Can anyone see the problem?
Thanks,
Mark
Message #2 by "Daniel O'Dorisio" <dodorisio@h...> on Wed, 21 Mar 2001 08:06:34 -0500
|
|
I have a prob too..... that one 800x0ABCD The user didnt supply enough code
:-) (ok so i stole the line)
Did you set rsofmdb as a recordset?
Daniel
-----Original Message-----
From: Mark Eckeard [mailto:meckeard2000@y...]
Sent: Tuesday, March 20, 2001 11:04 PM
To: ASP Databases
Subject: [asp_databases] Problems with SQL Server (select *)
Hi,
I seem to have a problem with come of my code.
I am trying to get all info from my SQL Server DB.
Here is the sql code:
rsofmdb.open "select * from markscoolwebsite"
Here is my output code:
Response.write rsofmdb("FirstName")
Response.write rsofmdb("LastName")
And, here is my error msg:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/pages/view_guests.asp, line 23
Line 23 is the SQL line. Can anyone see the problem?
Thanks,
Mark
---
SoftArtisans helps developers build robust, scalable Web applications!
Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
File uploads: http://www.softartisans.com/saf.html
Transactional file management: http://www.softartisans.com/saf1.html
Scalability: http://www.softartisans.com/saxsession.html
ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
$subst('Email.Unsub')
Message #3 by "Blake, Shane" <Shane.Blake@p...> on Wed, 21 Mar 2001 09:13:32 -0500
|
|
did you create the rsofmdb object?
we need to see more code...
shane
-----Original Message-----
From: Mark Eckeard [mailto:meckeard2000@y...]
Sent: Tuesday, March 20, 2001 11:04 PM
To: ASP Databases
Subject: [asp_databases] Problems with SQL Server (select *)
Hi,
I seem to have a problem with come of my code.
I am trying to get all info from my SQL Server DB.
Here is the sql code:
rsofmdb.open "select * from markscoolwebsite"
Here is my output code:
Response.write rsofmdb("FirstName")
Response.write rsofmdb("LastName")
And, here is my error msg:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/pages/view_guests.asp, line 23
Line 23 is the SQL line. Can anyone see the problem?
Thanks,
Mark
---
SoftArtisans helps developers build robust, scalable Web applications!
Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
File uploads: http://www.softartisans.com/saf.html
Transactional file management: http://www.softartisans.com/saf1.html
Scalability: http://www.softartisans.com/saxsession.html
ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
$subst('Email.Unsub')
Message #4 by "Rebecca Emerson" <emerson@u...> on Wed, 21 Mar 2001 18:33:39 -0500
|
|
You need a connection string after your SELECT statement.
Mark Eckeard
<meckeard2000@ To: "ASP Databases"
yahoo.com> <asp_databases@p...>
cc:
20/03/2001 Subject: [asp_databases] Problems with SQL
11:04 PM Server (select *)
Please respond
to "ASP
Databases"
Hi,
I seem to have a problem with come of my code.
I am trying to get all info from my SQL Server DB.
Here is the sql code:
rsofmdb.open "select * from markscoolwebsite"
Here is my output code:
Response.write rsofmdb("FirstName")
Response.write rsofmdb("LastName")
And, here is my error msg:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/pages/view_guests.asp, line 23
Line 23 is the SQL line. Can anyone see the problem?
Thanks,
Mark
|
|
|
View Cart
