Klo yang pernah saya alami seh masalahnya karena data yang ada tidak masuk dalam range tanggal yang dimaksud Misal data sprti berikut : no_trx tgl_trx 000001 27/12/2004 16:30:55
Klo diretrieve menggunakan date 27/12/2004 s/d 27/12/2004 , kmungkinan data g akan muncul. N jalan keluarnya saya convert aja semua data kedalam DATE Cth: Date(tgl_trx) >= Date(:d_Mulai) AND Date(tgl_trx) <= Date(:d_Akhir) atau Date(tgl_trx) between Date(:d_Mulai) and Date(:d_Akhir) Mudah2an bs memberikan sedikit gambaran... --- Allin <[EMAIL PROTECTED]> wrote: > coba dengan > convert(char(8), field1, 103) >= :argument1 > > argument1 : data type string > > > -----Original Message----- > From: Eko Heru Prasetyo edp-at-wanaarthalife.com > Sent: Tuesday, December 21, 2004 4:54 PM > Subject: RE: [indopb] Retrieve MS SQL2000 > > > > Saya sudah coba satu persatu, pada awalnya untuk > kondisi Field1 >= > :argument1 -> data keluar namun setelah saya tambah > kondisi ke 2 untuk > Field1 <= :argument2 -> data malah tidak keluar > Eg : :argument1 = '06/12/2004' :argument2 = > '06/12/2004' > > > Salam, > Eko Heru Prasetyo [Lemper] > System Support MIS Dept, IT Div. > > > -----Original Message----- > From: M. Santosa [mailto:[EMAIL PROTECTED] > Sent: 21 Desember 2004 16:39 > To: [email protected] > Subject: RE: [indopb] Retrieve MS SQL2000 > > > Coba cek type date nya ? > cocokin dengan yg di database MDY ata DMY .. > > Coba dulu dengan 1 parameter dengan menggunakan >= > stelah keluar baru masukin lagi parameter lainya. > > > -----Original Message----- > From: Eko Heru Prasetyo > [mailto:[EMAIL PROTECTED] > > > Udah dicoba mas, itu berlaku buat Oracle bukan MS > SQL 2000. > > Salam, > Eko Heru Prasetyo [Lemper] > System Support MIS Dept, IT Div. > > > > > > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: > [EMAIL PROTECTED] > > > > Yahoo! Groups Sponsor > > ADVERTISEMENT > > <http://us.ard.yahoo.com/SIG=12938e0n2/M=294855.5468653.6549235.3001176/ > D=groups/S=1705007181:HM/EXP=1103708386/A=2455396/R=0/SIG=119u9qmi7/*htt > p://smallbusiness.yahoo.com/domains/> click here > > <http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group > s/S=:HM/A=2455396/rand=503603164> > > > _____ > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > http://groups.yahoo.com/group/indopb/ > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > > * Your use of Yahoo! Groups is subject to the Yahoo! > Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > > > [Non-text portions of this message have been > removed] > > > > > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: > [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > > > > CAUTIONARY NOTE: > This communication is confidential and privileged > and may not be read, copied or disclosed or used by > any person other than the stated addressee. Any > unauthorized use, copying or disclosure is strictly > prohibited and may be unlawful. If you have received > this email in error or by mistake, please notify us > immediately and delete it from your system. Any > confidentiality and privilege of this email is not > waived because the email has been sent to you due to > such error or mistake. > > > __________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> 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/
