Hello T�m�,

Wednesday, October 11, 2000, 5:47:54 PM, you wrote:

emang rada nyebelin maen2an tanggal di access ... tapi udah dicoba
dijalanin di accessnya belum ? kalo gak salah harus ditambah # didepan
dan dibelakang tanggalnya ... jadi

sqlTampil = "SELECT * from BreakingNews where tanggal='#"
&DateAdd("d", -1, date) & "#';"


T��> Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

T��> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
T��> expression.

T��> /kemarin.asp, line 8

T��> 8 sqlTampil = "SELECT * from BreakingNews where tanggal='" &
T��> DateAdd("d", -1, date) & "';"
T��> 9 Set objRS   = Koneksi.Execute(sqlTampil)



Best regards,
 Agung                            mailto:[EMAIL PROTECTED]




### FREE DOMAIN [.COM|.NET|.ORG *] >> http://www.indoglobal.com << ###
Berhenti langganan kirim email ke [EMAIL PROTECTED]
Arsip di http://www.mail-archive.com/[email protected]/

Kirim email ke