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:
Grouping Fields (2006)
WebCat2b12plugin - [search] is broken ... not! (1997)
ErrorMessages.db (2004)
help needed: Non-english characters in WebCatalog (1997)
email code (1998)
Problem with pull down menu (1998)
More on the email templates (1997)
Document Contains No Data msg (1997)
[WebDNA] WebDNA Sciprt for Zipping files? (2012)
SERIOUS Problem (1998)
NumFound (1999)
Performance Issue (2000)
Need help with search title (1998)
No luck with taxes (1997)
Help with searching dates from mysql dump & searching (2006)
[OT] : Chat Room on OSX (2003)
Append (1999)
Commas in search (1998)
Part 2 - [showif] if variable exists (1998)
CommandSecurity? (1997)