Re: problem 'building' field names
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34556
interpreted = N
texte = Cool!>Charles,>>Between your post and a colleague in the office, this is what worked >for this case:>>--- fixed 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]>>[text show=f]poll1=[raw][[/raw][pollname]_[period1][raw]][/raw][/text]>[text show=f]poll2=[raw][[/raw][pollname]_[period2][raw]][/raw][/text]>>[append >db=/dbs/votes.db]poll_id=[poll_id]&vote_id=[cart]-[index]&value1=[interpret][poll1][/interpret]&value2=[interpret][poll2][/interpret]&start_date=[start]&end=[math][expire][/math]&vote_date=[math][date][/math]&ip=[ipaddress]&business=[business]>[/append]>>[/founditems]>[/search]>--- end fixed code --->>Basically I needed an additional step between setting the variable >and interpreting it for storage into the database.>>On Wednesday, July 12, 2000, Charles Kline wrote:>>I do something similar (I think) like this:>>>>[search>>db=/databases/databasetouse.db&eqlisttypedatarq=sell&eqdealeriddatarq=[__dealerid]]>>[founditems]>>[replace>>db=/databases/mwlisting_off.db&eqlistingiddata=[listingid]&append=t][listfields>>db=/databases/mwlisting.db][fieldname]=[url][interpret][[fieldname]][/interpret][/url]&[/listfields][/replace]>>[/founditems]>>[/search]>>>>Notice the use of the [interpret][/interpret] and the extra set>>of []>>>>Hope that helps.>>>>Charles>>>>>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/>>>>>------------------------------------------------------------->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:
Cool!>Charles,>>Between your post and a colleague in the office, this is what worked >for this case:>>--- fixed 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]>>[text show=f]poll1=[raw][[/raw][pollname]_[period1][raw]][/raw][/text]>[text show=f]poll2=[raw][[/raw][pollname]_[period2][raw]][/raw][/text]>>[append >db=/dbs/votes.db]poll_id=[poll_id]&vote_id=[cart]-[index]&value1=[interpret][poll1][/interpret]&value2=[interpret][poll2][/interpret]&start_date=[start]&end=[math][expire][/math]&vote_date=[math][date][/math]&ip=[ipaddress]&business=[business]>[/append]>>[/founditems]>[/search]>--- end fixed code --->>Basically I needed an additional step between setting the variable >and interpreting it for storage into the database.>>On Wednesday, July 12, 2000, Charles Kline wrote:>>I do something similar (I think) like this:>>>>[search>>db=/databases/databasetouse.db&eqlisttypedatarq=sell&eqdealeriddatarq=[__dealerid]]>>[founditems]>>[replace>>db=/databases/mwlisting_off.db&eqlistingiddata=[listingid]&append=t][listfields>>db=/databases/mwlisting.db][fieldname]=[url][interpret][[fieldname]][/interpret][/url]&[/listfields][/replace]>>[/founditems]>>[/search]>>>>Notice the use of the [interpret][/interpret] and the extra set>>of []>>>>Hope that helps.>>>>Charles>>>>>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/>>>>>------------------------------------------------------------->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/
Charles Kline
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:
PIXO support (1997)
message forum question (2005)
Expiration of Carts (1997)
Order not created error (1997)
[SHOWIF AND/OR] (1997)
[OT] MacOs IE5 topmargin and leftmargin bug (2000)
To Err or Not Custom Error (1999)
Moment of Thanks (1997)
Email notification to one of multiple vendors ? (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Doing VALIDCARD right? (1998)
attachment stupidity... (2001)
Emailer setup (1997)
WebCat2 - storing unformatted date data? (1997)
Problem with [isFile] [isFolder] (wc 3.0.4, iis 4) (1999)
Authenticate (1997)
Site Builder & IE Mac (2004)
WebCat for Unix?? (1997)
Re:Variable Math (1998)
WebCat for Site Search? (1997)