The Solution is set RS = Conn.Execute "SELECT * FROM [questions] WHERE [QID]='" & curpage & "'"
kala12_2002 <[EMAIL PROTECTED]> wrote: 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 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 the Yahoo! Terms of Service. kapil dev __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] 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/
