selamat malam semua rekan2

saya mau bertanay gmana caranya mengatasi error saat pencarian data 

dengan SQL command 

contoh :

 

 

SQL="Select * from Table_1 where judul =' "&text1.text&" ' order by code asc"

 

rs.open  sql,con

 

jika didalam text1.text (textbox) value nya = " hari jum'at " maka akan muncul 
error karena tanda petik ( ' ) 

gmana cara mengatasi nya ya

 

trimakasih


[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/zCsqlB/TM
--------------------------------------------------------------------~-> 

Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]

Ikuti juga forum diskusi VB.net dengan 
mengirim email kosong ke [EMAIL PROTECTED]
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indoprog-vb/

<*> 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/
 


Kirim email ke