🚀 go-pugleaf

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
> >
> >
>
>