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

[Michele Foster]

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