problem 'building' field names

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34551
interpreted = N
texte = Hello,On my form results page I am trying to build the fields names to append to my database. I do this as I am trying to append a single record for each of 7 different sets of information from my form page.The form vaiables display fine on the results page, however when I try to dynamically 'build' the fieldnames (to make the system automatic), I get he text of the form field names in the database instead of the value or the form variables.In the code below, I have the append commented out while I try to figure this out. If I enter the actual form field name e.g. [usd/jpy_Q3] then I properly get the value for this orm variable. However, when building the same name, I only get the text in the database, e.g. usd/jpy_Q3 instead of the value of this field. Here is the code.[text show=t]period1=[LOOKUP db=/dbs/period.db&value=1&lookInField=period_id&returnField=periodValue¬Found=error][/text] [text show=t]period2=[LOOKUP db=/dbs/period.db&value=2&lookInField=period_id&returnField=periodValue¬Found=error][/text]

[search db=/dbs/pollnames.db&gePoll_IDData=1&Poll_IDsmm=t&Poll_IDsort=1&poll_idsdir=as] numfound=[numfound]
[founditems]-- these lines for testing / debugging only [poll_id] - [pollname]
[pollname]_[period1]
[pollname]_[period2]
--- end of debugging[!][append db=/dbs/votes.db]poll_id=[poll_id]&vote_id=[cart]-[index]&value1=[Interpret][pollname]_[period1][/Interpret]&value2=[pollname]_[period2]&start_date=[start]&end=[math][expire][/math]&vote_date=[math][date][/math]&ip=[ipaddress]&business=[business] [/append][/!][/founditems] [/search] ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: problem 'building' field names (Charles Kline 2000)
  2. Re: problem 'building' field names (Dale 2000)
  3. Re: problem 'building' field names (Dale 2000)
  4. Re: problem 'building' field names (Charles Kline 2000)
  5. Re: problem 'building' field names (Dale 2000)
  6. problem 'building' field names (Dale 2000)
Hello,On my form results page I am trying to build the fields names to append to my database. I do this as I am trying to append a single record for each of 7 different sets of information from my form page.The form vaiables display fine on the results page, however when I try to dynamically 'build' the fieldnames (to make the system automatic), I get he text of the form field names in the database instead of the value or the form variables.In the code below, I have the append commented out while I try to figure this out. If I enter the actual form field name e.g. [usd/jpy_Q3] then I properly get the value for this orm variable. However, when building the same name, I only get the text in the database, e.g. usd/jpy_Q3 instead of the value of this field. Here is the code.[text show=t]period1=[LOOKUP db=/dbs/period.db&value=1&lookInField=period_id&returnField=periodValue¬Found=error][/text] [text show=t]period2=[LOOKUP db=/dbs/period.db&value=2&lookInField=period_id&returnField=periodValue¬Found=error][/text]

[search db=/dbs/pollnames.db&gePoll_IDData=1&Poll_IDsmm=t&Poll_IDsort=1&poll_idsdir=as] numfound=[numfound]
[founditems]-- these lines for testing / debugging only [poll_id] - [pollname]
[pollname]_[period1]
[pollname]_[period2]
--- end of debugging[!][append db=/dbs/votes.db]poll_id=[poll_id]&vote_id=[cart]-[index]&value1=[interpret][pollname]_[period1][/Interpret]&value2=[pollname]_[period2]&start_date=[start]&end=[math][expire][/math]&vote_date=[math][date][/math]&ip=[ipaddress]&business=[business] [/append][/!][/founditems] [/search] ------------------------------------------------------------- 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://search.smithmicro.com/ Dale

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:

Re:multiple digests, please stop (1997) [WebDNA] can webdna's [grep] find and replace ONLY the literal (2012) [ShowNext] (1997) "Advanced" Search Algorithm (2008) % (mod) was looping table rows (1999) shown next / show prev (1998) JavaScript question (2001) WebCat cannot handle compatible search parameters? (1997) PIXO with cometsite ... and/or other plugins (1998) RE: Can a database get stomped by simultaneous access? (1997) RE: Nesting [ListFiles] (1998) Generating unique SKU from [cart] (1997) Can't get appendfile to work (1997) Web Catalog Instability (2000) absolute paths for databases? (1997) RE: WebCat: Access denied, but why? - The solution. (1997) WebCat2 - [SendNews] (1997) math on date? (1997) Modify instead of Add (2000) Field name-subcategory (1997)