Re: fresh eyes needed. Append won't work.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35142
interpreted = N
texte = You have to wrap each field that could have non-printable characters in[url]. The reason you need to do this is that your data could have characters which will confuse WebCatalog; it matters not one whit thatyou are passing form variables.For example, just assume that one of the fields contains an ampersand;this will immediately break the rest of the append. I would suggest taking things slowly and break it down to one field at a time. Justadd one field and make sure it worked. Note that fieldnames like [Date] are a bad idea, because that conflictswith existing WebCat contexts. I don't know if you will have problemswith [referrer] and [grandtotal], but it is always a good idea to makeall of your variables something other than built-in WebCat fields. Youcan always prefix _ or my_ for each variable.HTHJohn PeacockRobert McPeak wrote:> > I wrapped the whole thing (inside the append context) in [url] but still no> luck.> > I'm passing the values as form variables, not in a url, so why should they> have to be urled?> > Still stumped.> > Thanks Kenneth.> > >From: Kenneth Grome
> >Reply-To: (WebCatalog Talk)> >To: (WebCatalog Talk)> >Subject: Re: fresh eyes needed. Append won't work.> >Date: Mon, 24 Jul 2000 23:34:04 -1000> >> > >Can anybody see what's wrong with this append. I can't get it to work.> >I'm> > >passing the values to the tpl this on with a form. I'm able to display> >the> > >passed values on the page but the append won't update the db issp.db.> > >> > >Thanks for taking a look.> > >> > >[Append> > >db=issp.db]date=[date]&referrer=[referrer]&firstname=[firstname]&middlename=[middlename]&lastname=[lastname]&dob=[dob]&instit=[instit]&dept=[dept]&city=[city]&state=[state]&country=[country]&ctrycode=[countrycode]&homestreet=[homestreet]&homecity=[homecity]&homestate=[homestate]&homecountry=[homecountry]&homectrycode=[homectrycode]&email=[email]&fax=[fax]&telex=[telex]&homephone=[homephone]&workphone=[workphone]&academicstatus=[academicstatus]&occupation=[occupation]&research=[research]&membertype=[membertype]&years=[years]&duestotal=[duestotal]&subscription1=[subscription1]&subscription1duration=[subsription1duration]&subscription2=[subscription2]&subscription2duration=[subscription2duration]&subscription1total=[subscription1total]&subscription2total=[subscription2total]&backissues=[backissues]&grandtotal=[grandtotal]&payment=[payment]&cardtype=[cardtype]&ccnumber=[ccnumber]&expdate=> >[ex> > >pdate][/Append]> >> >You haven't urled any of the values you're appending, and they should> >ALL be urled ...> >> >> >================================> >Kenneth Grome, WebDNA Consultant> >808-737-6499 http://webdna.net> >================================> >> >> >> >-------------------------------------------------------------> >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/> > ________________________________________________________________________> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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:
You have to wrap each field that could have non-printable characters in[url]. The reason you need to do this is that your data could have characters which will confuse WebCatalog; it matters not one whit thatyou are passing form variables.For example, just assume that one of the fields contains an ampersand;this will immediately break the rest of the append. I would suggest taking things slowly and break it down to one field at a time. Justadd one field and make sure it worked. Note that fieldnames like [date] are a bad idea, because that conflictswith existing WebCat contexts. I don't know if you will have problemswith [referrer] and [grandtotal], but it is always a good idea to makeall of your variables something other than built-in WebCat fields. Youcan always prefix _ or my_ for each variable.HTHJohn PeacockRobert McPeak wrote:> > I wrapped the whole thing (inside the append context) in [url] but still no> luck.> > I'm passing the values as form variables, not in a url, so why should they> have to be urled?> > Still stumped.> > Thanks Kenneth.> > >From: Kenneth Grome > >Reply-To: (WebCatalog Talk)> >To: (WebCatalog Talk)> >Subject: Re: fresh eyes needed. Append won't work.> >Date: Mon, 24 Jul 2000 23:34:04 -1000> >> > >Can anybody see what's wrong with this append. I can't get it to work.> >I'm> > >passing the values to the tpl this on with a form. I'm able to display> >the> > >passed values on the page but the append won't update the db issp.db.> > >> > >Thanks for taking a look.> > >> > >[Append> > >db=issp.db]date=[date]&referrer=[referrer]&firstname=[firstname]&middlename=[middlename]&lastname=[lastname]&dob=[dob]&instit=[instit]&dept=[dept]&city=[city]&state=[state]&country=[country]&ctrycode=[countrycode]&homestreet=[homestreet]&homecity=[homecity]&homestate=[homestate]&homecountry=[homecountry]&homectrycode=[homectrycode]&email=[email]&fax=[fax]&telex=[telex]&homephone=[homephone]&workphone=[workphone]&academicstatus=[academicstatus]&occupation=[occupation]&research=[research]&membertype=[membertype]&years=[years]&duestotal=[duestotal]&subscription1=[subscription1]&subscription1duration=[subsription1duration]&subscription2=[subscription2]&subscription2duration=[subscription2duration]&subscription1total=[subscription1total]&subscription2total=[subscription2total]&backissues=[backissues]&grandtotal=[grandtotal]&payment=[payment]&cardtype=[cardtype]&ccnumber=[ccnumber]&expdate=> >[ex> > >pdate][/Append]> >> >You haven't urled any of the values you're appending, and they should> >ALL be urled ...> >> >> >================================> >Kenneth Grome, WebDNA Consultant> >808-737-6499 http://webdna.net> >================================> >> >> >> >-------------------------------------------------------------> >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/> > ________________________________________________________________________> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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/
John Peacock
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:
Web Delivery Page concept (1997)
[ConvertChars] problem (1997)
bug in listwords? (1998)
Search and sort (2001)
RE: Emailer prefs in two places ... (1997)
Duplicate Carts (2006)
[ot] Webserver monitoring (2001)
TeaRoom Order fields email account remain empty even though thewy are filled. (1997)
Great product and great job ! (1997)
Resume Catalog ? (1997)
ssl and invoic.tpl and back bttn (2002)
[shownext max=?] armed (1997)
Re:What file? (1997)
Navigator 4.0 & tables (1997)
Ken's Data Manager (was dbQuickView 2.0) (2005)
Bulk Email >>>>Any ideas? (2001)
Nested tags count question (1997)
carriage returns in data (1997)
checksum for Discover credit cards (1999)
Server Problem (2004)