Re: problem 'building' field names

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34553
interpreted = N
texte = 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/ 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)
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/ 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:

Redirect (2000) quantity minimum problem (1997) Word search (1997) Re:2nd WebCatalog2 Feature Request (1996) how to check for no value while using [URL] to prevent cr (1999) append=T problem (1998) [lookup] [search] Issue (2005) type 2 errors with ssl server (1997) Error Lob.db records error message not name (1997) Introduction/Tutorial/QuickStart (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) PCS Frames-Default page is solution! (1997) [ShowIf] and empty fields (1997) WebCatalog can't find database (1997) WebDelivery (1998) [WebDNA] Email time bug? YES, it's a bug! (2011) flushdatabases (1997) multiple product databases (1997) WebDNA Partner edition .. (2002) WC Database Format (1997)