numero = 29269
interpreted = N
texte = so I looked harder at your code and I think it was better before, you are returning thefield explicitly named Inv, not a variable [Inv]. Sorry about that. But you aremissing the ¬Found=xxx in the [lookup]. maybe that is all it needs. Youoriginally had the [replace] inside a [lineitems]? Make sure that all the variablevalues you think are available to you within the [replace] actually are available. Dosome simple tests with hard coded values then add variables back one at a time to seewhere it is breaking.-JohnGlenn Busbin wrote:> on 03/19/00 4:20 PM, John Butler at john@feeling-goods.com wrote:>> > Inv is missing a [> >> > should be-> > &returnfield=[Inv]> >> > no?>> John,> I think so. But adding the [ somehow stops anything on the page below that> code from being processed. Even the html below that won't display after I> added the [.>> In any event, the database field Inv is still not being adjusted.>> I moved the code to the very bottom of the ThankYou.tpl page so that> everything gets processed and displayed before the Replace kicks in, but> there's still no inventory adjustment.>> I also tried moving the code> [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup> db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r> eplace]>> from the ThankYou.tpl page to the Invoice.tpl page and inserted it as> follows:>> > [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup> db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r> eplace]> >> I'd hoped that whenever the Submit Your Order button was hit, the Replace> context would be activated. Everything seems to work OK, but the INV field> is still not adjusted.>> Thanks for trying, though.> Glenn>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
so I looked harder at your code and I think it was better before, you are returning thefield explicitly named Inv, not a variable [Inv]. Sorry about that. But you aremissing the ¬Found=xxx in the [lookup]. maybe that is all it needs. Youoriginally had the [replace] inside a [lineitems]? Make sure that all the variablevalues you think are available to you within the [replace] actually are available. Dosome simple tests with hard coded values then add variables back one at a time to seewhere it is breaking.-JohnGlenn Busbin wrote:> on 03/19/00 4:20 PM, John Butler at john@feeling-goods.com wrote:>> > Inv is missing a [> >> > should be-> > &returnfield=[Inv]> >> > no?>> John,> I think so. But adding the [ somehow stops anything on the page below that> code from being processed. Even the html below that won't display after I> added the [.>> In any event, the database field Inv is still not being adjusted.>> I moved the code to the very bottom of the ThankYou.tpl page so that> everything gets processed and displayed before the Replace kicks in, but> there's still no inventory adjustment.>> I also tried moving the code> [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup> db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r> eplace]>> from the ThankYou.tpl page to the Invoice.tpl page and inserted it as> follows:>> > [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup> db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r> eplace]> >> I'd hoped that whenever the Submit Your Order button was hit, the Replace> context would be activated. Everything seems to work OK, but the INV field> is still not adjusted.>> Thanks for trying, though.> Glenn>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to John Butler
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...