Re: problem 'building' field names
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34552
interpreted = N
texte = oops, in the code I posted below, I had tried using the [Interpret] tag, normally it isn't in there. But I am grasping right now.ThanksOn Wednesday, July 12, 2000, Dale
wrote:>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/>-------------------------------------------------------------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:
oops, in the code I posted below, I had tried using the [interpret] tag, normally it isn't in there. But I am grasping right now.ThanksOn Wednesday, July 12, 2000, Dale wrote:>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/>-------------------------------------------------------------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:2nd WebCatalog2 Feature Request (1996)
Summary search -- speed (1997)
WCS Newbie question (1997)
RE:It just Does't add up!!! (1997)
[date] problem with %d%m%Y (1998)
inconsistent webcat calculation? (1997)
OT Cookie limit (2001)
Almost a there but..bye bye NetCloak (1997)
Summing fields (1997)
WebCat Emailer & Liststar (1997)
Multi Colonns (1998)
Where is f2? (1997)
Whats wrong with this code? (1998)
Sorting by highest number of matches unique to a field (2003)
Using Applescript to process WebCatalog functions (1998)
service stop and restart (1997)
Pithy questions on webcommerce & siteedit (1997)
Weird NT mail (1998)
TaxTotal Problem (1997)
WebDNA Intranet Edition public demo (2002)