M
matt shudy
Hi,
I have a page were db results are displayed... I am
using a sql statement,
strSQL = "SELECT * FROM Schools ORDER BY Year ASC, Month
ASC, Day ASC"
I want to add a WHERE to the statement. I have tried
adding this right after Schools
WHERE School = '" & Request.Form("School") & "'
but it didn't work. I am using a mySQL database, and am
using asp code to get records from the db. Does anyone
know what i did wrong?
Thanks,
Matt Shudy
I have a page were db results are displayed... I am
using a sql statement,
strSQL = "SELECT * FROM Schools ORDER BY Year ASC, Month
ASC, Day ASC"
I want to add a WHERE to the statement. I have tried
adding this right after Schools
WHERE School = '" & Request.Form("School") & "'
but it didn't work. I am using a mySQL database, and am
using asp code to get records from the db. Does anyone
know what i did wrong?
Thanks,
Matt Shudy