Re: Syntax Question?

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

Article #432

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

#432

From: Stig Joar Sanden
Date: Tue, 06 Apr 1999 00:00

51 lines
2392 bytes

Try this (I didn't mean it should be spaces between quotes, just to
illustrate for you :)
But there is to be spaces after/before quotes and &

sql = "SELECT DISTINCT songs.Song  FROM songs  WHERE songs.artist LIKE '" &
art & "'"

Stig Joar Sanden
sandman@online.no
ICQ: 13557997




Chad Gough skrev i meldingen <9bdO2.5837$033.1800@news.rdc1.il.home.com>...
>I tried
>
>sql = "SELECT DISTINCT songs.Song  FROM songs  WHERE songs.artist LIKE '
>"&art&" ' "
>
>
>but got:
>
>ADODB.Field error '800a0bcd'
>
>Either BOF or EOF is True, or the current record has been deleted; the
>operation requested by the application requires a current record.
>
>/file.asp, line 55
>
>
>
>Stig Joar Sanden <sandman@online.no> wrote in message
>news:xtcO2.572$l5.2625@news1.online.no...
>> This is written with the eyes almost closed, but i think it will work :)
>>
>> sql = "SELECT DISTINCT songs.Song  FROM songs  WHERE songs.artist LIKE '"
>&
>> Variable & "'"
>>
>> Remark that after songs.artist LIKE  there is  '  "
>> after Variable & there is  "   '  "
>>
>> HTH :)
>> Stig Joar Sanden
>> sandman@online.no
>> ICQ: 13557997
>>
>
>
>

Technical Details

Message-ID: <QodO2.578$l5.3382@news1.online.no>

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

References:

<ambO2.5836$033.1763@news.rdc1.il.home.com> <xtcO2.572$l5.2625@news1.online.no> <9bdO2.5837$033.1800@news.rdc1.il.home.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 110e3b,27ae79593ba8da5c
X-Google-Attributes: gid110e3b,public
X-Google-Thread: 10ce47,27ae79593ba8da5c
X-Google-Attributes: gid10ce47,public
X-Google-Thread: 108db9,27ae79593ba8da5c
X-Google-Attributes: gid108db9,public
X-Google-Thread: 1477ed,27ae79593ba8da5c
X-Google-Attributes: gid1477ed,public
X-Google-Thread: fdea5,27ae79593ba8da5c
X-Google-Attributes: gidfdea5,public
From: "Stig Joar Sanden" <sandman@online.no>
Subject: Re: Syntax Question?
Date: 1999/04/06
Message-ID: <QodO2.578$l5.3382@news1.online.no>
X-Deja-AN: 463076270
References: <ambO2.5836$033.1763@news.rdc1.il.home.com> <xtcO2.572$l5.2625@news1.online.no> <9bdO2.5837$033.1800@news.rdc1.il.home.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: news-abuse@online.no
X-Trace: news1.online.no 923361968 130.67.36.193 (Tue, 06 Apr 1999 03:26:08 MET DST)
Organization: Telenor Online Public Access
NNTP-Posting-Date: Tue, 06 Apr 1999 03:26:08 MET DST
Newsgroups: comp.lang.basic.visual.misc,cz.comp.microsoft.asp,fidonet.asp,microsoft.public.inetexplorer.ie5beta.programming.dhtml.authoring,microsoft.public.inetserver.iis.activeserverpages

Reply to Parent Message