Hi, I have been trying for 4 days but I can't solve this problem and I
don't know why.
It's a bug?
I have a table (children) which has a field called borough; I have to
extract the sum of the children of each borough so I use this simple
query:
select count(*) , borough from children group by borough order by
borough
that works.
If I try to call this query from a VB6 project it doesn't work, that is,
it returns an empty recordset.
This is the code that I'm using
Dim rec As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
Dim GlConnString as String
Dim strSQL As String
Set rec = New ADODB.Recordset
Set cnn = New ADODB.Connection
Set cmd = New ADODB.Command
strSQL = select count(*) , borough from children group by borough order
by borough
GlConnString =
"server=localhost;db=MyDB;driver={MySQL};uid=root;pwd=MyPwd;OPTION=35"
cnn.CursorLocation = adUseClient
cnn.ConnectionString = GlConnString
cnn.Open
cmd.CommandType = adCmdText
cmd.CommandText = STRsql
Set cmd.ActiveConnection = cnn
Set rec = cmd.Execute
---at this point I have an empty recordset
If I try with this query
select borough from children group by borough order by borough
that is, removing count(*) works!
I'm using
Windows 2000
MySQL 3.23.49
MyODBC 2.50.39
ADO 2.52.6019.1
Help me, please!
Thanks
Teo
---------------------------------------------------------------------
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
