Kebetulan countnya pake object recordset. Sekarang aku coba pakai
COUNT via T-SQL. Makasih mas Tri :)
Salam
--- In [email protected], "Tri-Mardiono" <[EMAIL PROTECTED]>
wrote:
Countnya pake apa mas? pake obyek recordset atau COUNT()
nya T-SQL?
Saran saya lgs pake COUNT-nya T-SQL. kl COUNT() outputnya
minimal 0.
Misalnya..
SELECT COUNT(<field>)
FROM Table X
UNION
SELECT COUNT(<field>)
FROM Table Y
Catatan: bila masing2 query menghasilkan jumlah record yg
sama.. hasil UNION hanya menampilkan 1 record
kalau setiap query ingin ditampilkan jml recordnya satu2
pake UNION ALL
Cheers
----------------------------------------------------------
Komunitas MasterWeb Indonesia http://www.master.web.id
----------------------------------------------------------
MWN, Masternya WEBHOSTING di Indonesia, Indo/USA Servers,
Customer Support 24 jam http://www.masterwebnet.com
----------------------------------------------------------
WebDevelopment,Designing/Programming http://www.dlanet.com
----------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/milis-masterweb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
