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. ------------------------ 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/
