|
 |
asp_databases thread: Object required?
Message #1 by "Wang, Julia" <Julia.Wang@R...> on Fri, 30 Nov 2001 11:38:19 -0600
|
|
Hi all,
I was trying to run the script:
<%
Dim mySQL, myRS
mySQL = "SELECT * FROM Customers ORDER BY LName"
Set myRS = myConn.Execute(mySQL)
Response.Write "<b>Customer names are:</b><BR><BR>"
While Not myRS.EOF
Response.Write myRS("FName") & " " & myRS("LName") & "<br>"
myRS.MoveNext
Wend
%>
It gives me an error message:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/wangj/asp1/execute.asp, line 27
Could some one try to figure out what is wrong?
Thanks!
<*><*><*><*><*><*><*><*><*><*>
Julia Wang
Message #2 by "S. Sridhar" <oesridhar@e...> on Fri, 30 Nov 2001 12:45:02 -0500
|
|
What you have set myConn to? You don't show that here. It should be
something like:
myConn = Server.CreateObject(ADODB.Connection)
....and then set the connection string etc....
If you try to execute myConn.Execute, myConn should be an object. Is it? You
don't show it in your code fragment. So I can't tell.
--sridhar
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, November 30, 2001 12:38 PM
Subject: [asp_databases] Object required?
> Hi all,
> I was trying to run the script:
> <%
> Dim mySQL, myRS
> mySQL = "SELECT * FROM Customers ORDER BY LName"
> Set myRS = myConn.Execute(mySQL)
> Response.Write "<b>Customer names are:</b><BR><BR>"
> While Not myRS.EOF
> Response.Write myRS("FName") & " " & myRS("LName") & "<br>"
> myRS.MoveNext
> Wend
> %>
>
> It gives me an error message:
> Microsoft VBScript runtime error '800a01a8'
>
> Object required: ''
>
> /wangj/asp1/execute.asp, line 27
>
> Could some one try to figure out what is wrong?
>
> Thanks!
> <*><*><*><*><*><*><*><*><*><*>
> Julia Wang
>
>
>
>
>
$subst('Email.Unsub')
>
> Read the future with ebooks at B&N
>
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
>
Message #3 by "Daniel O'Dorisio" <daniel@o...> on Fri, 30 Nov 2001 12:37:04 -0500
|
|
what is myconn? is that allready set to a connection?
daniel
p.s. figuring out the problem is the developers problem..:-) lol
--
-----------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
-----------------------------
"Wang, Julia" <Julia.Wang@R...> wrote in message
news:124990@a..._databases...
:
: Hi all,
: I was trying to run the script:
: <%
: Dim mySQL, myRS
: mySQL = "SELECT * FROM Customers ORDER BY LName"
: Set myRS = myConn.Execute(mySQL)
: Response.Write "<b>Customer names are:</b><BR><BR>"
: While Not myRS.EOF
: Response.Write myRS("FName") & " " & myRS("LName") & "<br>"
: myRS.MoveNext
: Wend
: %>
:
: It gives me an error message:
: Microsoft VBScript runtime error '800a01a8'
:
: Object required: ''
:
: /wangj/asp1/execute.asp, line 27
:
: Could some one try to figure out what is wrong?
:
: Thanks!
: <*><*><*><*><*><*><*><*><*><*>
: Julia Wang
:
:
:
:
:
Message #4 by "Wang, Julia" <Julia.Wang@R...> on Fri, 30 Nov 2001 11:49:05 -0600
|
|
Yes, I included this files:
dbconx.asp--
<%
Dim myConn
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "Student"
%>
<*><*><*><*><*><*><*><*><*><*>
Julia Wang
-----Original Message-----
From: Daniel O'Dorisio [mailto:daniel@o...]
Sent: Friday, November 30, 2001 11:37 AM
To: ASP Databases
Subject: [asp_databases] Re: Object required?
what is myconn? is that allready set to a connection?
daniel
p.s. figuring out the problem is the developers problem..:-) lol
--
-----------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
-----------------------------
"Wang, Julia" <Julia.Wang@R...> wrote in message
news:124990@a..._databases...
:
: Hi all,
: I was trying to run the script:
: <%
: Dim mySQL, myRS
: mySQL = "SELECT * FROM Customers ORDER BY LName"
: Set myRS = myConn.Execute(mySQL)
: Response.Write "<b>Customer names are:</b><BR><BR>"
: While Not myRS.EOF
: Response.Write myRS("FName") & " " & myRS("LName") & "<br>"
: myRS.MoveNext
: Wend
: %>
:
: It gives me an error message:
: Microsoft VBScript runtime error '800a01a8'
:
: Object required: ''
:
: /wangj/asp1/execute.asp, line 27
:
: Could some one try to figure out what is wrong?
:
: Thanks!
: <*><*><*><*><*><*><*><*><*><*>
: Julia Wang
:
:
:
:
:
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
Message #5 by "Peter Foti (PeterF)" <PeterF@S...> on Fri, 30 Nov 2001 12:57:50 -0500
|
|
Is myConn defined elsewhere?
> -----Original Message-----
> From: Wang, Julia [mailto:Julia.Wang@R...]
> Sent: Friday, November 30, 2001 12:38 PM
> To: ASP Databases
> Subject: [asp_databases] Object required?
>
>
> Hi all,
> I was trying to run the script:
> <%
> Dim mySQL, myRS
> mySQL = "SELECT * FROM Customers ORDER BY LName"
> Set myRS = myConn.Execute(mySQL)
> Response.Write "<b>Customer names are:</b><BR><BR>"
> While Not myRS.EOF
> Response.Write myRS("FName") & " " & myRS("LName") & "<br>"
> myRS.MoveNext
> Wend
> %>
>
> It gives me an error message:
> Microsoft VBScript runtime error '800a01a8'
>
> Object required: ''
>
> /wangj/asp1/execute.asp, line 27
>
> Could some one try to figure out what is wrong?
>
> Thanks!
> <*><*><*><*><*><*><*><*><*><*>
> Julia Wang
>
>
>
>
>
> PeterF@S...
> $subst('Email.Unsub')
>
> Read the future with ebooks at B&N
> http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934
667&categoryid=rn_ebooks
Message #6 by Sam Clohesy <sam@e...> on Fri, 30 Nov 2001 18:07:25 -0000
|
|
Do you have something like this (possibly in includ file to open coneection
(myConn)
set objConn = server.createobject("ADODB.Connection")
strConn
"PROVIDER=SQLOLEDB;Server=myserver;DATABASE=mydbase;UID=myuname;PWD=password
"
objConn.open strConn
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk
-----Original Message-----
From: Peter Foti (PeterF) [mailto:PeterF@S...]
Sent: 30 November 2001 17:58
To: ASP Databases
Subject: [asp_databases] RE: Object required?
Is myConn defined elsewhere?
> -----Original Message-----
> From: Wang, Julia [mailto:Julia.Wang@R...]
> Sent: Friday, November 30, 2001 12:38 PM
> To: ASP Databases
> Subject: [asp_databases] Object required?
>
>
> Hi all,
> I was trying to run the script:
> <%
> Dim mySQL, myRS
> mySQL = "SELECT * FROM Customers ORDER BY LName"
> Set myRS = myConn.Execute(mySQL)
> Response.Write "<b>Customer names are:</b><BR><BR>"
> While Not myRS.EOF
> Response.Write myRS("FName") & " " & myRS("LName") & "<br>"
> myRS.MoveNext
> Wend
> %>
>
> It gives me an error message:
> Microsoft VBScript runtime error '800a01a8'
>
> Object required: ''
>
> /wangj/asp1/execute.asp, line 27
>
> Could some one try to figure out what is wrong?
>
> Thanks!
> <*><*><*><*><*><*><*><*><*><*>
> Julia Wang
>
>
>
>
>
> PeterF@S...
> $subst('Email.Unsub')
>
> Read the future with ebooks at B&N
> http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934
667&categoryid=rn_ebooks
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
Message #7 by "Wang, Julia" <Julia.Wang@R...> on Fri, 30 Nov 2001 14:39:14 -0600
|
|
Thanks everybody that responded. With your help, I was able to figure out
that the include file should not be put after the myRS script. After lifting
it above, now it works fine. :-)
<*><*><*><*><*><*><*><*><*><*>
Julia Wang
-----Original Message-----
From: Sam Clohesy [mailto:sam@e...]
Sent: Friday, November 30, 2001 12:07 PM
To: ASP Databases
Subject: [asp_databases] RE: Object required?
Do you have something like this (possibly in includ file to open coneection
(myConn)
set objConn = server.createobject("ADODB.Connection")
strConn
"PROVIDER=SQLOLEDB;Server=myserver;DATABASE=mydbase;UID=myuname;PWD=password
"
objConn.open strConn
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk
-----Original Message-----
From: Peter Foti (PeterF) [mailto:PeterF@S...]
Sent: 30 November 2001 17:58
To: ASP Databases
Subject: [asp_databases] RE: Object required?
Is myConn defined elsewhere?
> -----Original Message-----
> From: Wang, Julia [mailto:Julia.Wang@R...]
> Sent: Friday, November 30, 2001 12:38 PM
> To: ASP Databases
> Subject: [asp_databases] Object required?
>
>
> Hi all,
> I was trying to run the script:
> <%
> Dim mySQL, myRS
> mySQL = "SELECT * FROM Customers ORDER BY LName"
> Set myRS = myConn.Execute(mySQL)
> Response.Write "<b>Customer names are:</b><BR><BR>"
> While Not myRS.EOF
> Response.Write myRS("FName") & " " & myRS("LName") & "<br>"
> myRS.MoveNext
> Wend
> %>
>
> It gives me an error message:
> Microsoft VBScript runtime error '800a01a8'
>
> Object required: ''
>
> /wangj/asp1/execute.asp, line 27
>
> Could some one try to figure out what is wrong?
>
> Thanks!
> <*><*><*><*><*><*><*><*><*><*>
> Julia Wang
>
>
>
>
>
> PeterF@S...
> $subst('Email.Unsub')
>
> Read the future with ebooks at B&N
> http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934
667&categoryid=rn_ebooks
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
|
|
|
View Cart
