Visual Basic and SQL

Article View: comp.lang.basic.visual.misc

Article #376

Back to comp.lang.basic.visual.misc Previous Next

#376

From: Road Runner News
Date: Sat, 24 Jul 1999 00:00

13 lines
1557 bytes

Alright i need some serious help quick.... when using an SQL statement in
VB... how can i use a variable with the "where" clause in a select
statement??? like this:

adoLeague.Open "select Name, LeagueID from League Where Name =
strleaguename", db, adOpenStatic, adLockOptimistic

where "strleaguename" is a variable

I've tried enclosing it in ' ', " ", ( ), { },[ ], < >... I just can't get
ti to work... how do i do it...

thanks... phil

Technical Details

Message-ID: <p2lm3.862$dM.23089@newse3.tampabay.rr.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1053fc,51e6611c37fa7e82,start
X-Google-Attributes: gid1053fc,public
X-Google-Thread: ffb5a,51e6611c37fa7e82,start
X-Google-Attributes: gidffb5a,public
X-Google-Thread: fb992,51e6611c37fa7e82,start
X-Google-Attributes: gidfb992,public
X-Google-Thread: 108062,51e6611c37fa7e82,start
X-Google-Attributes: gid108062,public
X-Google-Thread: 110e3b,f215963d4b03f357
X-Google-Attributes: gid110e3b,public
From: "Road Runner News" <pmorrow1@tampabay.rr.com>
Subject: Visual Basic and SQL
Date: 1999/07/24
Message-ID: <p2lm3.862$dM.23089@newse3.tampabay.rr.com>
X-Deja-AN: 504763628
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@rr.com
X-Trace: newse3.tampabay.rr.com 932830485 24.92.183.59 (Sat, 24 Jul 1999 11:34:45 EDT)
Organization: RoadRunner - TampaBay
X-MSMail-Priority: Normal
NNTP-Posting-Date: Sat, 24 Jul 1999 11:34:45 EDT
Newsgroups: comp.lang.basic.visual.misc,comp.lang.visual.basic,comp.lang.visual.basic.misc,cz.comp.lang.basic.visual,es.comp.lenguajes.visual-basic