TIP: Click on subject to list as thread! ANSI
echo: visual_basic
to: All
from: Chrisb
date: 2004-05-21 22:17:00
subject: Newbie help with Listbox

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   <<<< fname
Column2 > lname
Column3 > id

Thanks in advance!
---
þ 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/21/04 10:17:01 PM
* Origin: MoonDog BBS, Brooklyn,NY, 718 692-2498, 1:278/230 (1:278/230)
SEEN-BY: 633/267 270
@PATH: 278/230 10/345 106/1 2000 633/267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.