akula{at}sssnet.com (Chrisb) wrote in message
news:...
> I need a little help with an sql query and a listbox.
> My query is basically this:
> 
> Dim conn as New connection
> Dim strsql as new recordset
> Dim sql as string
> Conn.Open (database stuff) <<<---just for simplicty here
> sql = "Select fname, lname, id from ppl"
> set strSQL=Conn.Execute (sql)
>   list1.additem strSQL   <<<< 
> I would like the output to go into a 3 columned listbox.
> Column1 > fname
> Column2 > lname
> Column3 > id
> 
> Thanks in advance!


Hi.
I had a same problem as you and finally i realized that listbox couldn't do that.
Instead; use listview. it's the Solution!

Behzad
---
þ RIMEGate(tm)/RGXPost V1.14 at BBSWORLD * Info{at}bbsworld.com

---
 * RIMEGate(tm)V10.2áÿ* RelayNet(tm) NNTP Gateway * MoonDog BBS
 * RgateImp.MoonDog.BBS at 5/22/04 8:35:57 PM