RE: FN-FORUM SQL Syntax

date posted 11th January 2002 19:28

SQL = "select * from Options"
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open Application("DSN")
Set rs = cn.Execute(SQL)

That is a basic connection.

I have others if you need any help

-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of David McEwen
Sent: 11 January 2002 17:35
To: FN-FORUM
Subject: FN-FORUM SQL Syntax


Hi all

I'm looking for an amazing online resource that details syntax for SQL
queries within ASP.

Anyone got any idea?

Dave




============================================================

* Free listing for freelancers
* Free to advertise jobs
* Free jobs distribution service
* Free database of 5000 freelancers

Freelancers and Freelance Jobs:
http://www.freelancers.net

Forum FAQs:
http://freelancers.netrickery.com

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/2002