Here's the code
31 uid=Request.QueryString("ID")
32 Set oConnection=Server.CreateObject("ADODB.Connection" )
33 Set rs1=Server.CreateObject("ADODB.Recordset")
34 oConnection.Open sConnString
35 sSQL="SELECT * FROM users WHERE uid=" & uid & ""
36 rs1.open sSQL, oConnection

 heres the error

Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'uid='.
/refferal/Default.asp, line 36
I need some help asap

sounds like you're getting nothing from Request.QueryString("ID")

Thanks so much i needed some help to stepback
the answer was
uid = Request.QueryString("uid")
not
uid = Request.QueryString("ID")

31 uid=Request.QueryString("ID")
32 Set oConnection=Server.CreateObject("ADODB.Connection" )
33 Set rs1=Server.CreateObject("ADODB.Recordset")
34 oConnection.Open sConnString
35 sSQL="SELECT * FROM users WHERE id=" & uid & ""
36 rs1.open sSQL, oConnection


surendran
(Anything is Possible)

Hi,

If uid is declared as string in DB then the syntax will be :

  sSQL="SELECT * FROM users WHERE uid='" & uid & "'"

If uid is declared as int in DB then the syntax will be :
   sSQL="SELECT * FROM users WHERE uid=" & uid



Hope It Helps !!
Bhaskar Ghosh