In your search, populate the results to an array variable.
<@ASSIGN NAME="ua_product" VALUE="@@resultset" SCOPE="LOCAL">
In your dropdown, use this:
<SELECT NAME="product" SIZE=1>
<OPTION VALUE="">
<@ROWS START=1 STEP=1 ARRAY="ua_product">
<OPTION VALUE="<@COL NUM='1'>"><@COL NUM='2'>
</@ROWS>
</SELECT>
Just before your insert use this:
<@ASSIGN NAME="la_tempproduct" VALUE=<@FILTER ARRAY="ua_product" EXPR="#1 =
<@ARG product"> SCOPE="LOCAL">
and for your insert use these:
<@VAR NAME=local$la_tempproduct[1,2]> (for size)
<@VAR NAME=local$la_tempproduct[1,3]> (for price)
Hope this helps,
Steve Smith
Skadt Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: [EMAIL PROTECTED]
Web: http://www.skadt.com
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Web Dude
> Sent: August 29, 2002 1:37 PM
> To: Multiple recipients of list witango-talk
> Subject: Witango-Talk: Two Inserts from a Drop Down
>
>
> I've seen this posted before, but can't seem to find it.
>
> I have a table that has size and price info. Example:
>
> ID Size Price
> 1 S 10.00
> 2 L 11.00
> 3 XL 12.00
> 4 XXL 13.00
>
> I do a db call to load a dropdown. I would like to display the size
> in the dropdown and insert BOTH the size and the price from the
> dropdown.
>
> I realize I could do a search on the ID before the insert and then
> insert from the results, but is there a slicker way of doing this
> with just an insert?
>
> Thanks!
> --
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
