From: "botax"
> tapi yang search berdasarkan tanggal masih kagak bisa tuh.
> searchnya: rs.open "select * from customer where tgl like '%"
> & request.form("cari") & "%' "
> taro tanda # nya dimana yah? dah dicoba diberbagai tempat masih
> kagak bisa tuh.
tanggal bukan pake LIKE, tapi '='. querynya seperti ini:
SELECT * FROM customer WHERE tgl=#01/05/2005#
> Guys, kalo kita mau nampilin data ke dalam halaman tapi kalo
> ada data yang sama kagak muncul gimana yah? jadi misalnya user:
> botax dah belanja 5 kali, tapi ketika ditampilin dihalamanya cuma
> keluar 1 botax.
SELECT DISCTINCT(userid) FROM customer
(untuk ini agak ragu, di Access bisa apa ngga)
atau
SELECT * FROM customer GROUP BY userid
--
shgyn
---
Arsip milis : http://groups.yahoo.com/group/toekangweb/messages
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toekangweb/
<*> 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/
