Dear Sir,
	
	I got your email address from the file notice.txt of pub/odbc/
	I've problem with getting output from database via ODBC
my query is -->
	select s.account,sum(dround(date_part('epoch',s.stop-s.start)/36.0)/100) as
usage,sum(date_part('epoch',s.stop-s.start)/3600*s.rate/t.rate) as charge
from session s,ticket t
where s.stop >= '1999/06/10' and s.stop < '1999/06/21' and
s.ticket = t.id and not t.free and s.nas = '203.151.66.7' group by
s.account;

I use MS Access 97 as frontend application and 
ODBC : postodbc 6.4.7 
Database : PostgreSQL 6.5.1 on i386-unknown-freebsd2.2.8, compiled by cc

	I sent the passthrough query to the postgres backend. it always
return only the first field and the second (account,usage). and I noticed 
that the backend always return only some other fields and only 1 sum field
(it's wierd).
	with the same query I tried run it on the database promt it return
the complete result. 

	Please help.

Regards,

-----------------------------------------
Nuchanach  Klinjun
R&D Project. Internet Thailand
Email: nuchk@inet.co.th





Wed, 29 Sep 1999 10:31:00 +0700 (GMT+0700)
Nuchanach Klinjun <nuchk@inet.co.th>
Returned Result via ODBC!