I have an active server page using an ADO recordset. When the SQL command is
a join of two tables with a count/group by there are no records being
returned (RS.EOF is true).
code snippet:
dbConn = "DSN=dbTestCases"
sqlVar = "Select " & _
"TestCases.TestCaseId, Count(*)" & _
" from TestCaseProjects,TestCases where " & _
" TestCases.TestCaseId=TestCaseProjects.TestCaseId group by 1"
Set rsTree = Server.CreateObject("adodb.Recordset")
Response.write "sqlVar =" & sqlVar & rsTree.fields.count
rsTree.open sqlVar, dbConn
do while not rsTree.eof
response.write "<BR>" & rsTree(0) & rsTree(1)
rsTree.Movenext
loop
If I do the same query from from MS Access using the same ODBC DSN, I get
results. So it is not an ODBC problem. If I do the query without the
count(*)/group by joing the two tables then it is ok. If I do a
count(*)/group by on a single table it is ok.
MSQL Database is version:3.23.49
Web Server is Win2K IIS
MySQLODBC - latest version
Help- this is driving me crazy and can't figure out a workaround.
Rob Galvin
http://www.xanboo.com
Be there when you are not
---------------------------------------------------------------------
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
