[search >db=/dbs/pollnames.db&gePoll_IDData=1&Poll_IDsmm=t&Poll_IDsort=1&poll_idsdir=as]>numfound=[numfound] [search >db=/dbs/pollnames.db&gePoll_IDData=1&Poll_IDsmm=t&Poll_IDsort=1&poll_idsdir=as]>numfound=[numfound] DOWNLOAD WEBDNA NOW! 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...
>[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
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]>>
>[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
Top Articles:
Talk List
Related Readings:
Re[2]: Re[2]: WebCatalog keeps quiting on Solaris, and suppo (2000)
Alternating BGColors in Table Rows (1998)
Frames and WebCat (1997)
YACBQ.....(Yet another checkbox question) (2000)
[WebDNA] Search on a database (2012)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Mauthcapture vs mauthonly (2002)
Trouble with carts (2000)
[WebDNA] Sandbox question (2009)
Cookies (1999)
WebCat2 - storing unformatted date data? (1997)
send mail problem? (1997)
Image editing in browser (2005)
carriage returns in data (1997)
Securing/hiding database file (2000)
Search with Special Chars (1997)
Hiccup ***** (1998)
Math (1997)
WebDNA 6 (2004)
[/application] error? (1997)