[thelist] ASP/TSQL/UID
Anthony Johnston . Antix
tech at antix.co.uk
Wed Oct 2 11:41:01 CDT 2002
try
if not(objRS.BOF And objRS.EOF) then
Ant.
>
> I am having a peculiar problem executing some SQL through an
> ASP script.
> The statement is:
>
> strSQL = "SELECT agendasinfo_text, agendasinfo_isheading FROM
> agendasinfo WHERE agendasinfo_agenda_id = '" &
> Request.QueryString("id")
> & "'"
>
> Response.Write this to a web page, and I have:
>
> SELECT agendasinfo_text, agendasinfo_isheading FROM agendasinfo WHERE
> agendasinfo_agenda_id = '{1A2B6434-F383-4F18-A25D-C5F2FBBCB433}'
>
> Copy this and paste to Query Analyser and I get the expected (and
> required) output. However, run it from the ASP script...
>
> If Not objRS.BOF And objRS.EOF Then
> While Not objRS.EOF
> ...
> Wend
> End If
>
> ...and it doesn't make it past the initial condition, as the recordset
> contains no data. From what I've said, am I making a stupid
> error, or is
> there more to it?
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list