Problema query ADODB-MySQL

Article View: free.it.visual-basic

Article #3468

Back to free.it.visual-basic Previous Next

#3468

From: TWINS
Date: Mon, 17 Jun 2002 23:52

11 lines
1419 bytes

Salve a tutti, non riesco a far eseguire la query:

SELECT services.*, count(userID) as count_users from services left join 
service_subscr on id=userID group by id

tramite una connessione ADODB ad un database MySQL. Il risultato � 
sempre un recordset vuoto. La stessa query funziona benissimo in 
PHPMyAdmin, quindi penso sia corretta.
Grazie per l'aiuto.

STEFANO

Technical Details

Message-ID: <3D0E76E3.9040206@inwind.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!iad-peer.news.verio.net!news.verio.net!news.maxwell.syr.edu!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,77bea777fcbdf364,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-06-17 16:52:33 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!iad-peer.news.verio.net!news.verio.net!news.maxwell.syr.edu!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail
Message-ID: <3D0E76E3.9040206@inwind.it>
From: TWINS <dsmtwins@inwind.it>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:0.9.4.1) Gecko/20020314 Netscape6/6.2.2
X-Accept-Language: en-us
MIME-Version: 1.0
Newsgroups: free.it.visual-basic
Subject: Problema query ADODB-MySQL
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Lines: 12
Date: Mon, 17 Jun 2002 23:52:03 GMT
NNTP-Posting-Host: 62.98.209.97
X-Complaints-To: abuse@inwind.it
X-Trace: twister2.libero.it 1024357923 62.98.209.97 (Tue, 18 Jun 2002 01:52:03 MET DST)
NNTP-Posting-Date: Tue, 18 Jun 2002 01:52:03 MET DST
Organization: [Infostrada]