Thanks. All good ideas. I will give them a try...
>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
--
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
