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

[John Beima]

I am not even sure this one deserves an answer....

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


Quoting Carlc Internet Services <mvu@carlc.com>:

> Hello,
> 
> 	I've got an interesting problem, just a matter of syntax I bet...
> This is on a Minivend 4.04a setup.
> 
> 	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:
> 
> <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_order_item VALUE=[ data table=vpa-lookup
> field='[value mv_order_widthacross]' key='[value
> mv_order_lengthdown]' ]>
> <INPUT TYPE=submit VALUE="Click here to calculate cost">    </FORM>
> 
> 	Alright, now you can tell me how badly I messed up....8^)
> 	Thanks,
> 	Carl
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
> 



John Beima
jbeima@palb.com, support@alocalagent.com, and support@alocalchurch.com

P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6

Affordable Web Pages - Phone: (888)932-9990 - Fax: (256)351-7297
2713B Spring Place SW, Decatur, Alabama, United States, 35603