dear all, aku dah coba semu cara dari bos² semua ...but ups sorry it doesnt work ...
ternyata bos, codingnya ada yg kurang, yaitu kurang nambahain "from (nama tabel)" heheh .. jalan deh programnya...padahal seharusnya ngga perlu pake "from juga harusnya jalan programnya. anyway ...thanks all ... ur so kind ... On 9/23/07, denny ardian <[EMAIL PROTECTED]> wrote: > > Dear all > Nambahin pak arlis. MID kan salah satu fungsi di SQL server jadi dianggap > tidak ada fieldnya. > Coba gunakan [MID]. Atau Fieldnya direname saja. > > semoga manpangat > Thx > > On 9/22/07, Celes Victoria <[EMAIL > PROTECTED]<celesvictoria2005%40yahoo.com.sg>> > wrote: > > > > coba > > ...select `mid`... > > > > ----- Original Message ---- > > From: "Kurniawan, Arlis" <[EMAIL PROTECTED]<Arlis.Kurniawan%40AIG.com> > <Arlis.Kurniawan%40AIG.com> > > > > > To: [email protected] > > <indoprog-vb%40yahoogroups.com><indoprog-vb%40yahoogroups.com> > > Sent: Saturday, 22 September 2007 12:51:34 > > Subject: RE: [indoprog-vb] invalid column name 'MID' > > > > coba dibuat seperti ini, > > > > ... select [mid] .... > > > > regards, > > > > Arlis > > > > -----Original Message----- > > From: indoprog-vb@ yahoogroups. com [mailto:indoprog-vb@ yahoogroups. > > com]On > > Behalf Of Doni Rahadian > > Sent: Saturday, September 22, 2007 2:35 PM > > To: indoprog-vb@ yahoogroups. com > > 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.DataSourc e = 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] > > > > <!-- #ygrp-mkp{ border:1px solid #d8d8d8;font-family:Arial;margin:14px > > 0px;padding:0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} > #ygrp-mkp > > #hd{ > > > color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px > > 0px;} #ygrp-mkp #ads{ margin-bottom:10px;} #ygrp-mkp .ad{ padding:0 0;} > > #ygrp-mkp .ad a{ color:#0000ff;text-decoration:none;} --> <!-- > #ygrp-sponsor > > #ygrp-lc{ font-family:Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px > > 0px;font-weight:bold;font-size:78%;line-height:122%;} #ygrp-sponsor > #ygrp-lc > > .ad{ margin-bottom:10px;padding:0 0;} --> <!-- #ygrp-mlmsg > > {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} > > #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, > input, > > textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg > pre, > > code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} > > #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} > > #ygrp-tpmsgs{ > > font-family:Arial; clear:both;} #ygrp-vitnav{ > > padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} > #ygrp-vitnav > > a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px > > 0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ > > float:left;white-space:nowrap;} .bld{font-weight:bold;} #ygrp-grft{ > > font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ > > font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px > 0; > > } #ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ > > background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} > > #ygrp-vital #vithd{ > > > font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} > > #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ > > list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital > ul > > li .ct{ > > > font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} > > #ygrp-vital ul li .cat{ font-weight:bold;} > > #ygrp-vital a{ text-decoration:none;} #ygrp-vital a:hover{ > > text-decoration:underline;} #ygrp-sponsor #hd{ > color:#999;font-size:77%;} > > #ygrp-sponsor #ov{ padding:6px > > 13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ > > padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ > > list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov > li a{ > > text-decoration:none;font-size:130%;} #ygrp-sponsor #nc{ > > background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor > .ad{ > > padding:8px 0;} #ygrp-sponsor .ad #hd1{ > > > font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} > > #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ > > text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} > o{font-size:0;} > > .MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} > > blockquote{margin:0 0 0 4px;} .replbq{margin:4;} --> > > > > __________________________________________________________ > > Yahoo! Singapore Answers > > Real people. Real questions. Real answers. Share what you know at > > http://answers.yahoo.com.sg > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
