texte = I just tried adding the extra set of [ ] and got the same results. :(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/
Associated Messages, from the most recent to the oldest:
I just tried adding the extra set of [ ] and got the same results. :(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/
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:
Re1000002: Setting up shop (1997)
Shopping Cart Directory (2000)
Running _every_ page through WebCat ? (1997)
creating a ShipCosts database (1997)
Database Changes (2000)
Re:quit command on NT (1997)
WebCat/CyberStudio Compatibility (1998)
WebCatalog and Macromedia Flash (1998)
Show shoppingcart after remove last item (1997)
WebCommerce: Folder organization ? (1997)
Include error (2000)
[WebDNA] SEARCH question - SHOWIF - HIDEIF question (2011)
Re(4): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
WebCatalog can't find database (1997)
Calculating multiple shipping... (1997)
summarizing date search by month... (2000)
Protect (1997)
Newbie trouble with [url] & [foundItems] (2000)
Ok here is a question? (1997)
Need some Java Script Code (2003)