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

[Ken Kogler]

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