coba bantu,
pastikan object sudah bernama txtid and ada field ID di table orders.
select * from orders where id = '" & txtID.text & "'", conn,1,3
(\__/)
(='.'=) Agus Sudana
(")_(")
----- Original Message ----
From: Christopher Rodjito <[EMAIL PROTECTED]>
To: indoprog-vb <[email protected]>
Sent: Monday, May 12, 2008 5:56:33 PM
Subject: [indoprog-vb] Query SQL di VB
Temans, jikalau saya inging men-query table di DB SQL.
Maka saya menggunakan syntax
"select * from orders where id = 001". Benar kan?
Nah..menjadi masalah bagi saya, ketika saya ingin mengambil nilai ID dari
textbox
bagaimanakah coding query nya yang benar?
semalam saya mencoba dengan
"select * from orders where id = " + txtID.text + ", conn,1,3 "
tapi pesannya malah "OBJECT REQUIRED".
Di mana yah kesalahan saya?
____________ _________ _________ _________ _________ _________ _
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs. yahoo.com/ nowyoucan. html
[Non-text portions of this message have been removed]
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
