I have made something since I programming in Visual Basic...
When I need to use a SQL statement to open a recordset, I check first my Query in Access. You can see it too in SQL Server, MySQL, etc. Go to 'Querys' select my conditions and when the Data is shown as I want, select te SQL view and copy the SQL st. and paste into the ASP page.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.