Posted by Ron on 11/09/06 16:50

I have a table in SQL, that I know how to connect to using ADO, but I
need help on how to read records from that table.

So on a form I have a listbox where I want to populate that and i have
a textbox with a userid.


Here is an example of the table:
USER ID TYPE PAYMENT
=====================
0001 CARD 150.00
0001 CASH 250.00
0002 CASH 175.00


If I have 0001 in the txtuserid textbox, I then want to display in
the listbox:
CARD 150.00
CASH 250.00


How would I do this?


thanks

• Next in forum: WHERE columnName = 'this' AND anotherColumnName IS NOT NULL
• Prev in forum: select records between dates - query works in VS 2005 but it doesn't in asp 3
• Thread view: How to loop through this sql table and display in ms access listbox

[Reply to this message]