rizzlasrus
Posts: 8
|
| Posted: 07/19/2007, 3:37 AM |
|
hello i'm getting the following error msg
Microsoft VBScript runtime error '800a01a8'
Object required
/cgi-bin/maketimeCD.asp, line 118
this is line 18:
rs.Open "SELECT * FROM Payments WHERE payments='CD',db,,adLockOptimistic,adCmdText"
i really am getting a bad head trying to solve this any help greatly recieved. thanks in advance
|
 |
 |
dstrickland
Posts: 1
|
| Posted: 07/19/2007, 11:31 PM |
|
To me it looks like you need to separate your SQL from the connection string.
So instead of tis
rs.Open "SELECT * FROM Payments WHERE payments='CD',db,,adLockOptimistic,adCmdText"
Try this
rs.Open "SELECT * FROM Payments WHERE payments='CD'", db,,adLockOptimistic,adCmdText
I hope it works.
Darryl
|
|
|
|
rizzlasrus
Posts: 8
|
| Posted: 07/20/2007, 1:46 AM |
|
no sorry that didnt work. 
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 07/23/2007, 6:17 PM |
|
Altjhough this is where the error is located, there is not enough code in
that line to tell us WHERE your rpoblem is located.
However, it is indicating that a recordset onblect does not exist.
Look above and make sure you have instantiated a recordset object named
"rs", and that you have adtabase connection object called "db".
Thiose are the 2 things which could be the source of your problem.
"rizzlasrus" <rizzlasrus@forum.codecharge> wrote in message
news:6469f3f0674285@news.codecharge.com...
> hello i'm getting the following error msg
>
> Microsoft VBScript runtime error '800a01a8'
>
> Object required
>
> /cgi-bin/maketimeCD.asp, line 118
>
> this is line 18:
>
> rs.Open "SELECT * FROM Payments WHERE
> payments='CD',db,,adLockOptimistic,adCmdText"
>
> i really am getting a bad head trying to solve this any help greatly
> recieved.
> thanks in advance
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
