Re: server side scripting???

Shoot, the sql string is actually on one line on the page, not two like
below.

mickey


"mickey" <newslists (AT) micnap (DOT) com> wrote

Howdy,

I've got a recordset going in a site. Odd thing is, everything works fine
in IE but I get the following error in Netscape:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)
in
query expression 'Test.ID ='.
/design1.asp, line 17

Here's the code:

11 Set Recordset1 = Server.CreateObject("ADODB.Recordset")
12 Recordset1.ActiveConnection = MM_micnap1_STRING
13 Recordset1.Source = "SELECT Test.* FROM Test WHERE Test.ID = " &
Request("PageID") & ";"
14 Recordset1.CursorType = 0
15 Recordset1.CursorLocation = 2
16 Recordset1.LockType = 1
17 Recordset1.Open()

If this is server side, what the heck is going on? What is the missing
operator?

Thanks,
mickey