[thelist] ASP / SQL .. so close ;(

Ken Kogler thelist at lists.evolt.org
Mon Feb 17 20:59:01 2003


In your SQL, you'd want:

> sql = "SELECT Address.AddressID, Address.AddressContactID,
> Address.AddressType, Categories.ID, Categories.Options AS CatOptions,

Then:

> <%=Address_RS("CatOptions")%>

Should do it. My SQL is a bit rusty but I think this should work...

HTH!
--ken