[thelist] ASP / SQL .. so close ;(
Michele Foster
michele at wordpro.on.ca
Mon Feb 17 21:07:01 CST 2003
Bingo!!!
Thanks!! :)
Didn't realize I needed to alias the duplicates like that .. seems oh so
very odd to me.
Mich
----- Original Message -----
From: "Ken Kogler" <ken.kogler at curf.edu>
> 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
More information about the thelist
mailing list