🚀 go-pugleaf

What are you looking to find - an exact match or an approximate match on:
1.  is art a variable or
2.  is art three exact letters

Basically, what is art?
If it's a field name, that's even different than the two above and you are
going in the wrong direction - in your select statement, where compares a
fieldname (songs.artist) to whatever art is. So in that context, art should
be exact text or a variable.

sql="Select DISTINCT Songs.song from songs Where songs.artist Like '%art%'"
The above statement will give you any artist with the letters 'art'
somewhere it it - Like Bart, Art, Martin, etc.
Notice the Percent signs instead of ampersands...

If art is a variable, that's different.
--
David Wier
http://www.aspexpress.com
http://www.augustwind.com
Designer of the Best ASP Editor in the Galaxy

Chad Gough wrote in message ...
>Still having problems!
>
>    sql = "SELECT DISTINCT songs.Song  FROM songs  WHERE songs.artist
>='"&art&"'"
>(quotes after songs.artist = are single, double, variable, double, single,
>double)
>
>and i still get:
>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 52
>
>If i use:
><%=art%>
>anywhere else on the page, it displays the right info !?!?
>
>Ideas?
>
>
>
>David Wier <dwier@home.com> wrote in message
>news:H7dO2.29152$SZ5.9745@news.rdc1.tx.home.com...
>> I have a tutorial on using Quotes in ASP at my site...check it out.
>> --
>> David Wier
>> http://www.aspexpress.com
>> http://www.augustwind.com
>> Designer of the Best ASP Editor in the Galaxy
>>
>> Chad Gough wrote in message ...
>> >I have a VB script in an ASP page running a query.
>> >
>> >The SQL code looks like:
>> >sql = "SELECT DISTINCT songs.Song  FROM songs  WHERE songs.artist =
>'????'
>> "
>> >
>> >What is the syntax to put a variable where ???? is?
>> >The query works fine if I replace ???? with a value from the
database!?!?
>> >
>> >Any help would be appreciated.
>> >
>> >Thanks
>> >
>> >
>>
>>
>
>