hi kapil please write as set RS = Conn.Execute "SELECT * FROM [questions] > WHERE [QID]='" & variable name&"'
regards arun --- kapil dev <[EMAIL PROTECTED]> wrote: > 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] > > __________________________________ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250 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/
