Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why my SQL statement doesn't work?

Data Access

Why my SQL statement doesn't work?

by  JuanjoZun  Posted    (Edited  )
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.

It's a simple way to make your own querys.

Due to a lot of posts asking for SQL statements.

Juanjo
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top