rizzlasrus
Posts: 8
|
| Posted: 06/05/2007, 1:46 PM |
|
i am getting this error can any body advise pleae?
Microsoft VBScript runtime error '800a01a8'
Object required
/cgi-bin/maketimeCD.asp, line 118
this is line 118
rs.Open "SELECT * FROM Payments WHERE payments=CD", db,, adLockOptimistic, adCmdText
thanks in advance for any help
|
 |
 |
Benjamin Krajmalnik
|
| Posted: 06/05/2007, 3:08 PM |
|
FIrst, it appers your select is wrong.
payments=CD should be payments='CD'
Try that. If you still have an error, then make sure you have instantiated
a recordset object.
"rizzlasrus" <rizzlasrus@forum.codecharge> wrote in message
news:64665cb928fda9@news.codecharge.com...
>i am getting this error can any body advise pleae?
>
>
> Microsoft VBScript runtime error '800a01a8'
>
> Object required
>
> /cgi-bin/maketimeCD.asp, line 118
>
>
> this is line 118
>
> rs.Open "SELECT * FROM Payments WHERE payments=CD", db,, adLockOptimistic,
> adCmdText
>
> thanks in advance for any help
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
rizzlasrus
Posts: 8
|
| Posted: 06/06/2007, 5:40 AM |
|
Thank you very much for your help.
that got rid of that problem but has now created the following error any ideas?
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/cgi-bin/maketimeCD.asp, line 118
rs.Open "SELECT * FROM Payments WHERE payments='CD', db,, adLockOptimistic, adCmdText
------------------------------------------------------------------------------------------------------------------------------------^
thank you
|
|
|
|
ReneS
Posts: 225
|
| Posted: 06/06/2007, 7:16 AM |
|
Hi,
Unterminated string constant:
You did not end your string constant with a closing quotation mark. String constants must be enclosed within a pair of quotation marks.
To correct this error
Add the closing quotation mark to the end of the string.
Google for: Unterminated string constant
Rene
|
|
|
|
rizzlasrus
Posts: 8
|
| Posted: 06/06/2007, 11:06 AM |
|
Hi Thanks for the help ( sorry i'm a bit thick at this)
i think i added the closing statment thingy.
but know i get this
Microsoft VBScript runtime error '800a01a8'
Object required
/cgi-bin/maketimeCD.asp, line 118
again this is the line.
rs.Open "SELECT * FROM Payments WHERE payments='CD', db,, adLockOptimistic, adCmdText"
|
|
|
|
wkempees
|
| Posted: 06/06/2007, 12:47 PM |
|
rs.Open "SELECT * FROM Payments WHERE payments='CD'", db,,
adLockOptimistic,adCmdText"
|
|
|
|
|
