Expert: Ujjwal - 8/25/2004

Question
dear sir,

how to add in 'where' clause after this sql statement?
sql="select  *  from pay" & month(now)

i tried this but fail, please help, thanks...
sql="select  *  from pay '" & month(now) & "' where empid='" & session("userid") & "'"


Answer
Hi Callisto,

If you have seperate object called pay8, pay9, pay10 for respective 8th, 9th, 10th months in your database and

EmpID field being integer. Your query goes like this:

sql="select * from pay" & month(now) & " where empid=" & session("userid") & ""

EmpID field being char/varchar. Your query goes like this:

sql="select * from pay" & month(now) & " where empid='" & session("userid") & "'"

Regards