Calling in a SQL Query using ASP

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Calling in a SQL Query using ASP

Author

Topic

starydynamo
Starting Member

12 Posts

Posted - 2011-06-09 : 05:21:19

Hi all,

I have been trying, trying, trying to do this but to no avail. So thought I would start a thread.

All I want to do is call in an existing query that I have saved onto a database server that sorts a table alphabetically.

I ALREADY have access to the database and the query ready (called 'ALPHASORT') I just need help on the ASP code to call it in.

I would really appreciate some help on this.

Thanks in advance.

chris_cs
Posting Yak Master

223 Posts

Posted - 2011-06-09 : 06:30:24

There is loads of information about this on the internet.

This link will give you some clues:

http://www.w3schools.com/ado/met_conn_execute.asp

If this doesn't help you then you should post this query on an ASP forum.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources