Multiple fields in DRW dropdown (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

jeffmetcalf -> Multiple fields in DRW dropdown (5/25/2007 22:12:15)

Is it possible to show multiple fields in a DRW dropdown if you put it on the diet?

I have a dropdown that lists the adrscode (address code) for a customer ID.

I'd like for the drop down to show the adrscode, city and state in the list, but just post the adrscode to the next form page.

ie, right now it shows

Corp HQ
Warehouse1
Warehouse2

and I'd like for it to show

Corp HQ, Greenville SC
Warehouse1, Sumnter SC
Warehouse2, Orlando FL

All values are stored in the same table.

TIA



rdouglass -> RE: Multiple fields in DRW dropdown (5/25/2007 22:50:10)

I envision the line that looks like this:

<option><%=FP_FieldVal(fp_rs,"adrscode")%></option>

to look something like this:

<option VALUE="<%=FP_FieldVal(fp_rs,"adrscode")%>"><%=FP_FieldVal(fp_rs,"adrscode")%>, <%=FP_FieldVal(fp_rs,"city")%> <%=FP_FieldVal(fp_rs,"state")%></option>

Something like that help any?



jeffmetcalf -> RE: Multiple fields in DRW dropdown (5/26/2007 20:38:47)

Thanks, I'll give it a try tonight.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875