Re: Syntax Question?

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

Article #431

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

#431

From: Chad Gough
Date: Tue, 06 Apr 1999 00:00

33 lines
1953 bytes

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: <9bdO2.5837$033.1800@news.rdc1.il.home.com>

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>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1477ed,27ae79593ba8da5c
X-Google-Attributes: gid1477ed,public
X-Google-Thread: 108db9,27ae79593ba8da5c
X-Google-Attributes: gid108db9,public
X-Google-Thread: 110e3b,27ae79593ba8da5c
X-Google-Attributes: gid110e3b,public
X-Google-Thread: fdea5,27ae79593ba8da5c
X-Google-Attributes: gidfdea5,public
X-Google-Thread: 10ce47,27ae79593ba8da5c
X-Google-Attributes: gid10ce47,public
From: "Chad Gough" <chad131@home.com>
Subject: Re: Syntax Question?
Date: 1999/04/06
Message-ID: <9bdO2.5837$033.1800@news.rdc1.il.home.com>
X-Deja-AN: 463070791
References: <ambO2.5836$033.1763@news.rdc1.il.home.com> <xtcO2.572$l5.2625@news1.online.no>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Complaints-To: abuse@home.net
X-Trace: news.rdc1.il.home.com 923361093 24.2.195.246 (Mon, 05 Apr 1999 18:11:33 PDT)
Organization: @Home Network
X-MSMail-Priority: Normal
NNTP-Posting-Date: Mon, 05 Apr 1999 18:11:33 PDT
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