Try using a recordset:
Set con = Server.CreateObject ("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open "SELECT ID FROM Items", con, 3, 3
' Use de results of the recordset here
rst.Close
Nuno A. S. Gonçalves
[EMAIL PROTECTED]
----- Original Message -----
From: "Peter Bremer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 24, 2002 9:42 AM
Subject: Help! Problems with ASP
> Can anybody please help me with this? Some queries I try in ASP don't
> return any result! Executing them in the EMS MySQL Manager show that
> they all should return something...
>
> <%
>
> Set con = Server.CreateObject ("ADODB.Connection")
> con.Open ("Driver=MySQL;SERVER=peter;DATABASE=ppm3;UID=root")
>
> set rst = con.Execute ("SELECT ID FROM Items")
> Response.Write (rst.EOF & "<br>")
> ' --> False
>
> set rst = con.Execute ("SELECT IFNULL('a','') FROM Items")
> Response.Write (rst.EOF & "<br>")
> ' --> False
>
> set rst = con.Execute ("SELECT IFNULL(ID,'') FROM Items")
> Response.Write (rst.EOF & "<br>")
> ' --> True
> ?!?!?!?!
>
> set rst = con.Execute ("SELECT IF(ID,ID,'') FROM Items")
> Response.Write (rst.EOF & "<br>")
> ' --> False
>
> set rst = con.Execute ("SELECT COALESCE(ID,'') FROM Items")
> Response.Write (rst.EOF & "<br>")
> ' --> True
> ?!?!?!?!
>
> set rst = con.Execute ("SELECT CONCAT('1','2') AS Result")
> Response.Write (rst.EOF & "<br>")
> ' --> False
>
> set rst = con.Execute ("SELECT 1+1 AS Result")
> Response.Write (rst.EOF & "<br>")
> ' --> True
> ?!?!?!?!
>
> %>
>
> Please help! I'm new to MySQL, and I'm beginning to fear that it was
> not a good choice...
>
> Regards,
> Peter Bremer
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
