asp EOF - but query executes in mysql

[thompom]

Hi,

i dont think this is a sql syntax prob as when i execute the query from mysql it runs fine and displays a recordset.

However when i run the query from my asp page it returns eof.

this is because of this part of the statment

sum(TO_DAYS(CBB.bookend) - TO_DAYS(CBB.bookst) + 1) AS holcount

i am opening the rs like this

Set rsside = Server.CreateObject("ADODB.Recordset")
rsside.Open sqlside, conn

and have tried

set rsside = conn.execute(sqlside)

the sql looks like

SELECT CC.code, sum(TO_DAYS(CBB.bookend) - TO_DAYS(CBB.bookst) + 1) AS holcount, CC.holtype FROM holtype AS CC LEFT JOIN (SELECT CB.bookst, CB.bookend, CB.userholid, CB.holbookid, CB.holtypeid, CB.deptid FROM holbook AS CB WHERE CB.userholid = '46' AND ((cb.bookst BETWEEN '20070101' AND '20071231') OR (cb.bookend BETWEEN '20070101' AND '20071231') OR (cb.bookst <= '20070101') AND (cb.bookend >= '20071231'))) AS CBB ON CC.holtypeid = CBB.holtypeid GROUP BY CC.holtypeid ORDER BY CC.holtypeid

if you have an idea of what i could try next please let me know

 

[elsenorjose]

Have you tried posting the question in the ASP forum? Since you state that the SQL query works fine in MySQL, it's not a MySQL problem

Best of luck!

 

[thompom]

will do thanks