If QID is numeric don't use single quotes --- kala12_2002 <[EMAIL PROTECTED]> wrote:
> > kala here > Hey it's not working giving a vb compilation error > Error Type: > Microsoft _VBScript compilation (0x800A03F3) > Expected '=' > > > --- In [email protected], > 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] > > > > 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/
