Coba di cek, Jangan2 nama field "type" merupakan nama field yg di reserve oleh VB, jd ngga bs pake J Coba ganti nama fieldnya -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rony Wijaya Sent: Tuesday, January 30, 2007 6:45 PM To: [email protected] Subject: Re: [Programmer-VB] SQL query like '%' Saya sudah coba dan berhasil, saya coba dengan memakai table lain yg saya punya dengan logika SQL yg sama ex: SELECT * FROM INVENTTABLE WHERE (ITEMID LIKE '003%' OR ITEMID LIKE '004%' OR ITEMID LIKE '005%') AND (DATAAREAID ='C05') Sama kan dengan Logika yg dipakai di Sintax SQL ini : select * from tabel where (type like 'RFS%' or type like 'TWS%' or type like 'SFS%' or type like 'CRSFS%') and (lokasi='C-FOND')" ----- Original Message ----- From: Agus Sudana <mailto:[EMAIL PROTECTED]> To: Programmer-VB@ <mailto:[email protected]> yahoogroups.com Sent: Tuesday, January 30, 2007 7:58 PM Subject: Re: [Programmer-VB] SQL query like '%' masih blm bisa mncl nii.. yg mncl, msh byk lain lokasi, ky "C-SGPS" dll.. apa krn like-nya di pake-in "or" yah..??
--- Rony Wijaya <rony.wijaya. <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]> wrote: > Kalau dikasih kurung gimana? > > "select * from tabel where (type like 'RFS%' or > type like 'TWS%' or > type like 'SFS%' or > type like 'CRSFS%') and > (lokasi='C-FOND')" > > > > ----- Original Message ----- > From: Agus Sudana > To: Programmer-VB@ <mailto:Programmer-VB%40yahoogroups.com> yahoogroups.com > Sent: Tuesday, January 30, 2007 6:47 PM > Subject: Re: [Programmer-VB] SQL query like '%' > > > alow, slm kenal jg. > udh sy coba,tp kog yg mncl lokasinya g cuma di "C-FOND" yah..? muncul jg > "WH-G". > ada yg slh..? > thanx > > agus > > --- Rony Wijaya <rony.wijaya. <mailto:rony.wijaya.er80%40gmail.com> [EMAIL PROTECTED]> wrote: > > > Salam kenal, > > Setahu saya di SQL pake perintah like, kalau pake perintah in maka isi yg > > didalamnya harus lengkap dan tanpa % > > maka jadinya seperti ini : > > > > "select * from tabel where type like 'RFS%' or > > type like 'TWS%' or > > type like 'SFS%' or > > type like 'CRSFS%' and > > lokasi='C-FOND'" > > > > Selamat mencoba !!!! > > > > __________________________________________________________ > Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it > now. > > > __________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase. <http://farechase.yahoo.com/promo-generic-14795097> yahoo.com/promo-generic-14795097 _____ ** **
