[ic] Attempting to lookup a SKU/Code number from another database...

[Carl C.]

>From: John Beima <jbeima@palb.com>
>To: interchange-users@developer.akopia.com
>Subject: Re: [ic] Attempting to lookup a SKU/Code number from another database...
>Date: Wed, 06 Jun 2001 21:42:19 -0600 (MDT)
>Reply-To: interchange-users@lists.akopia.com
>
>I am not even sure this one deserves an answer....

Yes it does <grin>... And you helped! Thank you John.

>But here is your problem... The [value] tag retrieves values from the LAST form
>posted, not the current one being posted...

My original description:

>>I have shop that sells a products that's based on a Width x Length form.
>>I've created a database to lookup the SKU (CODE). The database is called
>>vpa-lookup . I am trying to use that lookup to send the SKU (example:VPA-1-1)
>>to the basket and checkout page:


Alright, Based on John's idea, I've split the work between 2 pages... 
The first page is set as follows:

<FORM ACTION="[process-target]" METHOD=POST>
....
<select name="mv_order_quantity">
....
<select name="mv_order_widthacross">
....
<select name="mv_order_lengthdown">
....
<INPUT TYPE=hidden NAME=mv_doit          VALUE=refresh>
<INPUT TYPE=hidden NAME=mv_nextpage      VALUE=cat44a.html>
<INPUT TYPE=submit VALUE="Click here to calculate cost">    </FORM>

This does a great job of sending the values to the "cat44a.html" page. But
I still can't get the SKU number out of my "vpa-lookup" database. Here's
the second page:

<FORM ACTION="[process-target]" METHOD=POST>
.....
    <INPUT TYPE=hidden NAME=mv_todo value=refresh>
<INPUT TYPE=hidden NAME=mv_order_item VALUE="[value [ data table=vpa-lookup fiel
d='[value mv_order_widthacross]' key='[value mv_order_lengthdown]' ]]">
    <INPUT TYPE=submit VALUE="Click here to Order this product">    </FORM>

When I look at the HTML source thats generated, I get this:

<INPUT TYPE=hidden NAME=mv_order_item VALUE="' key='26' ]]">

I can see where some of parts are getting replace....

Many thanks in advance!
Carl

=====================
http://www.carlc.com/

          "Price, Performance, Quality.  Choose any two you like."