Forms-2 actions

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 51894
interpreted = N
texte = I have the below .tpl file with a .inc file which is a form. There is one form field that does not update unless I hit the button twice. Can anyone see anything wrong with this? The field is called "sections". It relates to categories in the store builder, I would like the form to automatically specify a category without going to the Cat. Selection Page. Here is the text for the tpl file: [SETMIMEHEADER name=Pragma&value=no-cache] [SETMIMEHEADER name=Expires&value=Thu, 01 Dec 1994 16:00:00 GMT] [SETMIMEHEADER name=Cache-Control&value=max-age=0] [Text]SelectOne=No Graphic[/Text] [include body_tag.inc] [showif [action]=New] [math show=f]sku=[search db=products.db&neSKUdatarq=find_all&deSKUsort=1&SKUtype=number&max=1][foundi tems][SKU][/founditems][/search]+1[/math] [/showif] [!]---------------------------------------------------------------------[/!] [!] Coming from Pick Category [/!] [!]---------------------------------------------------------------------[/!] [showif [FromPickCategory]=Yes] [Text]selectedCategory=+[/Text] [formvariables name=CatID_&exact=f] [Text]selectedCategory=[selectedCategory][value]+[/Text] [/formvariables] [Replace db=products.db&eqSKUdata=[sku]]sections=[Url][selectedCategory][/Url][/Repla ce] [Search db=related.db&eqR_SKUdatarq=[sku]&eqR_CTYPEdatarq=S] [Showif [numFound]=0] [text]related_id=[/text] [/Showif] [Showif [numFound]!0] [Founditems] [Text]related_id=[R_ID][/Text] [/Founditems] [/Showif] [/Search] [Showif [related_id]=] [Search db=related.db&neR_IDdata=Find_All&deR_IDsort=1&R_IDtype=num&max=1] [Showif [numFound]=0] [text]NewID=1[/text] [/Showif] [Showif [numFound]!0] [Founditems] [math show=f]NewID=[R_ID]+1[/math] [Text]related_id=[NewID][/Text] [/Founditems] [/Showif] [/Search] [/Showif] [Replace db=related.db&eqR_IDdata=[related_id]&append=T]R_ID=[related_id]&R_SKU=[sku] &R_NAME=[Url][selectedCategory][/Url]&R_CTYPE=S[/Replace] [/showif] [showif [action]=New] [text]page_title=Add New Product[/text] [text]helpid=product_add[/text] [include banner.inc] [include file=products.inc&SKU=[url][sku][/url]&[listfields db=products.db][fieldname]=&[/listfields]] ---------------------------------------------------------------------------- ---- [/showif] [showif [action]=Edit] [search db=products.db&eqSKUdatarq=[url][SKU][/url]] [showif [numfound]=0] SKU "[SKU]" not found in database. [/showif] [founditems] [text]page_title=Edit Product[/text] [text]helpid=product_edit[/text] [include banner.inc] [include file=products.inc] ---------------------------------------------------------------------------- ---- [!] Protection needs to be fixed [hideif [include file=protection.inc&owner=[url][OWNER][/url]]^N] [/hideif][/!] [/founditems][/search] [/showif] Thank You, Dan Braley Thank You, Dan Braley Graphics Art Manager Fabri-Kal Corporation 570-454-6672 ext.5375 dbraley@hazleton.f-k.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Forms-2 actions ( Dan Braley 2003)
I have the below .tpl file with a .inc file which is a form. There is one form field that does not update unless I hit the button twice. Can anyone see anything wrong with this? The field is called "sections". It relates to categories in the store builder, I would like the form to automatically specify a category without going to the Cat. Selection Page. Here is the text for the tpl file: [SETMIMEHEADER name=Pragma&value=no-cache] [SETMIMEHEADER name=Expires&value=Thu, 01 Dec 1994 16:00:00 GMT] [SETMIMEHEADER name=Cache-Control&value=max-age=0] [text]SelectOne=No Graphic[/Text] [include body_tag.inc] [showif [action]=New] [math show=f]sku=[search db=products.db&neSKUdatarq=find_all&deSKUsort=1&SKUtype=number&max=1][foundi tems][SKU][/founditems][/search]+1[/math] [/showif] [!]---------------------------------------------------------------------[/!] [!] Coming from Pick Category [/!] [!]---------------------------------------------------------------------[/!] [showif [FromPickCategory]=Yes] [text]selectedCategory=+[/Text] [formvariables name=CatID_&exact=f] [text]selectedCategory=[selectedCategory][value]+[/Text] [/formvariables] [Replace db=products.db&eqSKUdata=[sku]]sections=[url][selectedCategory][/Url][/Repla ce] [Search db=related.db&eqR_SKUdatarq=[sku]&eqR_CTYPEdatarq=S] [Showif [numFound]=0] [text]related_id=[/text] [/Showif] [Showif [numFound]!0] [founditems] [text]related_id=[R_ID][/Text] [/Founditems] [/Showif] [/Search] [Showif [related_id]=] [Search db=related.db&neR_IDdata=Find_All&deR_IDsort=1&R_IDtype=num&max=1] [Showif [numFound]=0] [text]NewID=1[/text] [/Showif] [Showif [numFound]!0] [founditems] [math show=f]NewID=[R_ID]+1[/math] [text]related_id=[NewID][/Text] [/Founditems] [/Showif] [/Search] [/Showif] [Replace db=related.db&eqR_IDdata=[related_id]&append=T]R_ID=[related_id]&R_SKU=[sku] &R_NAME=[url][selectedCategory][/Url]&R_CTYPE=S[/Replace] [/showif] [showif [action]=New] [text]page_title=Add New Product[/text] [text]helpid=product_add[/text] [include banner.inc] [include file=products.inc&SKU=[url][sku][/url]&[listfields db=products.db][fieldname]=&[/listfields]] ---------------------------------------------------------------------------- ---- [/showif] [showif [action]=Edit] [search db=products.db&eqSKUdatarq=[url][SKU][/url]] [showif [numfound]=0] SKU "[SKU]" not found in database. [/showif] [founditems] [text]page_title=Edit Product[/text] [text]helpid=product_edit[/text] [include banner.inc] [include file=products.inc] ---------------------------------------------------------------------------- ---- [!] Protection needs to be fixed [hideif [include file=protection.inc&owner=[url][OWNER][/url]]^N] [/hideif][/!] [/founditems][/search] [/showif] Thank You, Dan Braley Thank You, Dan Braley Graphics Art Manager Fabri-Kal Corporation 570-454-6672 ext.5375 dbraley@hazleton.f-k.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Dan Braley

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:

PCS Emailer's role ? (1997) Database Structure? (1998) Trigger alternatives please ... (2004) Re:WebCatalog f2 Installation (1997) LetterRip and WebCat (1998) FlushDatabase Suggestion (1998) Links inside of Text Areas (2000) Need relative path explanation (1997) generator prob (2001) More than one db with the same namn (was: WC2f3) (1997) Converting SQL Microtime to Date and Time (2003) simple answer? [hideif] (1997) WebCatalog can't find database (1997) trouble updating records in database (1998) emailer error type 103 (1997) Web*3 virtual hosting Webcatalog problem (1998) RequiredFields notes ... (1997) Fun with dates (1997) [WebDNA] GREP problem (2011) [Sum] function? (1997)