coba dibuat seperti ini, ... select [mid] ....
regards, Arlis -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Doni Rahadian Sent: Saturday, September 22, 2007 2:35 PM To: [email protected] Subject: [indoprog-vb] invalid column name 'MID' Dear vb-ers need help guys untuk case berikut : saya mau bikin code untuk pencarian data Private Sub Txt_MID_Change() Set rs_merchantdebit = cn.Execute("select MID, nama_merchant, mso, nama_persh, " & _ "alamat, kota, nama_pemilik, contact_person " & _ "no_telp, fax, open_date, mcc, no_rekening " & _ "nama_bank, status, jml_edc where mid like '" & Text11.Text & "%'") Set DataGrid1.DataSource = rs_merchantdebit End Sub ketika txt_mid saya input, keluar error message invalid column name 'mid' sedangakan colom mid tsb jelas² ada di sql servernya , apakah ada salah penulisan code nya???? mohon pencerahan !!!!!!!!!!!!!!!!!!! IMPORTANT NOTICE: The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by American International Group, Inc. or its subsidiaries or affiliates either jointly or severally, for any loss or damage arising in any way from its use. [Non-text portions of this message have been removed]
