SELECT * FROM questions WHERE [QID] = '" & curpage & "'"
There ya go................. -----Original Message----- From: kala12_2002 [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 7:26 PM To: [email protected] Subject: [AspClassicAnyQuestionIsOk] (unknown) Please help me on this How to append an variable value in a sql statement in ado eg set RS = Conn.Execute "SELECT * FROM [questions] WHERE [QID]=" & curpage this curpage is a no which the user will be inputting. I am getting an error.pls someone help me out on this Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
