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 On Wed, 09 Mar 2005 11:41:20 -0000 "madfriedrich" <[EMAIL PROTECTED]> wrote: > > > > Web Master, > > Mau nanya sedikit, kenapa kalo saya pakai UNION SQL, >ketika dicount > jumlah recordnya, hasilnya selalu -1. Padahal saat saya >coba test > query ke Query Analizer, resultnya dapat beberapa >record. Sebagai > informasi, saya menggunakan MSSQL 2000 dan ASP. Ada ndak >dari kawan- > kawan yang bisa memberikan solusi? > > Salam > > > > > > > > > > > ---------------------------------------------------------- > 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 > > > > > > > ======================================================================================== Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah Jawa Timur. Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN (467826) ======================================================================================== ---------------------------------------------------------- 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/
