Re: FN-FORUM SQL Syntax

date posted 11th January 2002 22:50

Well, thanks for that but I was actually looking for something a little more
in-depth:

When using a statement such as

SELECT * FROM tblTable WHERE fldCounty = 'Cornwall' AND

This is where it gets tricky and I know it's not right coz it isn't working

fldCaravan = True OR fldTent = TRUE

I want the returned record set to contain everything in Cornwall that's a
caravan or a tent, not everything in Cornwall that's a caravan and
everything that's a tent wherever it is.

Catch my drift?

Dave

----- Original Message -----
From: "Ian Turner" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, January 11, 2002 7:19 PM
Subject: RE: FN-FORUM SQL Syntax


> 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
>
>
> ============================================================
>
> * 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]
>