Weird bug, or is there something amiss?

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 11413
interpreted = N
texte = This one has me stumped. I'm trying to pass customer data input from the invoice.tmpl into an two external databases. In the invoice.tmpl I have the following form (similar to the other field inputs):In the final_invoice.tmpl, I display that input and have the following two forms below:[LineItems][Append db=subfolder/whatwasordered.db]CART=[cart]&SKU=[sku]&Quantity=[quantity]&TITLE=[title]&PRICE=[PRICE]&CATEGORY=[category]&SUBTOTAL=[math][quantity]*[PRICE][/math][/append][/LineItems][Append db=subfolder/trackInvoice.db]CART=[cart]&GenDate=[Date]&Accepted=P&Name=[name]&company=[company]&add1=[address1]&add2=[address2]&city=[city]&State=[state]&country=[country]&Zipcode=[zip]&EMail=[email]&Phone=[phone]&FAX=[shiptofax]&ShipToName=[ShipToName]&ShipTocompany=[ShipTocompany]&ShipToAdd1=[ShipToAddress1]&ShipToAdd2=[ShipToAddress2]&ShipToCity=[ShipToCity]&ShipToState=[ShipToState]&ShipToCountry=[ShipToCountry]&ShipToZip=[ShipToZip]&ShipToPhone=[ShipToPhone]&PayMethod=[PayMethod]&CardNum=[accountNum]&ExpMonth=[ExpMonth]/[expYear]&SubTotal=[subTotal]&TotalWeight=[format .2f][totalWeight][/format]&ShipCost=[shipCost]&Tax=[taxtotal]&Total=[GrandTotal][/append]In the whatwasordered.db I have the head with the field names tab-delimited and it gets new records with all of the data just fine. In the trackInvoice.db I have the following header of fields tab separatedCART GenDate Accepted ProcessDate PO Name Company Add1 Add2 City State Country Zipcode EMail Phone FAX ShipToName ShipTocompany ShipToAdd1 ShipToAdd2 ShipToCity ShipToState ShipToCountry ShipToZip ShipToPhone PayMethod CardNum ExpMonth SubTotal TotalWeight ShipCost Tax TotalNow, what is weird is the fact that all of the above fields get added to the new record, EXCEPT State (it gets nothing). Even though on the final_invoice.tmpl I'm able to display [state] and pass it on in a [sendemail] form!Have I hit some weird bug/limit?... thanks for any suggestions.Curt----------------------------------------------------------------------| William Curt Eggemeyer Curt@mail.bzzzzzz.com || BeeHive Technologies, Inc. || http://www.bzzzzzz.com with a WebCam in Pasadena, California |---------------------------------------------------------------------- Associated Messages, from the most recent to the oldest:

Weird bug, or is there something amiss? (w curt eggemeyer 1997)

This one has me stumped. I'm trying to pass customer data input from the invoice.tmpl into an two external databases. In the invoice.tmpl I have the following form (similar to the other field inputs):In the final_invoice.tmpl, I display that input and have the following two forms below:[lineitems][Append db=subfolder/whatwasordered.db]CART=[cart]&SKU=[sku]&Quantity=[quantity]&TITLE=[title]&PRICE=[PRICE]&CATEGORY=[category]&SUBTOTAL=[math][quantity]*[PRICE][/math][/append][/LineItems][Append db=subfolder/trackInvoice.db]CART=[cart]&GenDate=[date]&Accepted=P&Name=[name]&company=[company]&add1=[address1]&add2=[address2]&city=[city]&State=[state]&country=[country]&Zipcode=[zip]&EMail=[email]&Phone=[phone]&FAX=[shiptofax]&ShipToName=[ShipToName]&ShipTocompany=[ShipTocompany]&ShipToAdd1=[ShipToAddress1]&ShipToAdd2=[ShipToAddress2]&ShipToCity=[ShipToCity]&ShipToState=[ShipToState]&ShipToCountry=[ShipToCountry]&ShipToZip=[ShipToZip]&ShipToPhone=[ShipToPhone]&PayMethod=[PayMethod]&CardNum=[accountNum]&ExpMonth=[ExpMonth]/[expYear]&SubTotal=[subTotal]&TotalWeight=[format .2f][totalWeight][/format]&ShipCost=[shipCost]&Tax=[taxtotal]&Total=[GrandTotal][/append]In the whatwasordered.db I have the head with the field names tab-delimited and it gets new records with all of the data just fine. In the trackInvoice.db I have the following header of fields tab separatedCART GenDate Accepted ProcessDate PO Name Company Add1 Add2 City State Country Zipcode EMail Phone FAX ShipToName ShipTocompany ShipToAdd1 ShipToAdd2 ShipToCity ShipToState ShipToCountry ShipToZip ShipToPhone PayMethod CardNum ExpMonth SubTotal TotalWeight ShipCost Tax TotalNow, what is weird is the fact that all of the above fields get added to the new record, EXCEPT State (it gets nothing). Even though on the final_invoice.tmpl I'm able to display [state] and pass it on in a [sendemail] form!Have I hit some weird bug/limit?... thanks for any suggestions.Curt----------------------------------------------------------------------| William Curt Eggemeyer Curt@mail.bzzzzzz.com || BeeHive Technologies, Inc. || http://www.bzzzzzz.com with a WebCam in Pasadena, California |---------------------------------------------------------------------- w curt eggemeyer

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

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...

Related Readings:

Date search and sendmail (1997) search form problem.. (1997) Security Issues and WebCommerce Solution (1997) Nesting Search Within Tag? (1997) Carts & cookies (1999) Ok here is a question? (1997) multiple prices (1998) Many $WebCat.exe processes (1998) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Multiple Pulldowns (1997) Include a big block of text (1997) looking for some paid WebCatalog help (2000) [WebDNA] WebDNA Alive! (2012) add line item context and showitems (1998) Looking up two prices in Formulas.db (1997) help needed: Non-english characters in WebCatalog (1997) new cart IDs being assigned somehow (1997) Remote administration (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) OK, here goes... (1997)