Re: fresh eyes needed. Append won't work.

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35148
interpreted = N
texte = I am having some trouble with this list. I can reply to any message but I can no longer send a new message to the list. Very strange. Is this happening to anyone else?Thanks,Dave. ----- Original Message ----- From: Daventab - Dave Jones To: WebCatalog Talk Sent: Tuesday, July 25, 2000 12:46 PM Subject: Re: fresh eyes needed. Append won't work. > test > ----- Original Message ----- > From: John Peacock > To: WebCatalog Talk > Sent: Tuesday, July 25, 2000 12:31 PM > Subject: Re: fresh eyes needed. Append won't work. > > > > 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 that > > you 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. Just > > add one field and make sure it worked. > > > > Note that fieldnames like [Date] are a bad idea, because that conflicts > > with existing WebCat contexts. I don't know if you will have problems > > with [referrer] and [grandtotal], but it is always a good idea to make > > all of your variables something other than built-in WebCat fields. You > > can always prefix _ or my_ for each variable. > > > > HTH > > > > John Peacock > > > > Robert 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=[h > omestreet]&homecity=[homecity]&homestate=[homestate]&homecountry=[homecountr > y]&homectrycode=[homectrycode]&email=[email]&fax=[fax]&telex=[telex]&homepho > ne=[homephone]&workphone=[workphone]&academicstatus=[academicstatus]&occupat > ion=[occupation]&research=[research]&membertype=[membertype]&years=[years]&d > uestotal=[duestotal]&subscription1=[subscription1]&subscription1duration=[su > bsription1duration]&subscription2=[subscription2]&subscription2duration=[sub > scription2duration]&subscription1total=[subscription1total]&subscription2tot > al=[subscription2total]&backissues=[backissues]&grandtotal=[grandtotal]&paym > ent=[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/ > > > > > ------------------------------------------------------------- > 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: fresh eyes needed. Append won't work. (Robert McPeak 2000)
  2. Re: fresh eyes needed. Append won't work. (Daventab - Dave Jones 2000)
  3. Re: fresh eyes needed. Append won't work. (Daventab - Dave Jones 2000)
  4. Re: fresh eyes needed. Append won't work. (Kim Ingram 2000)
  5. Re: fresh eyes needed. Append won't work. (Robert McPeak 2000)
  6. Re: fresh eyes needed. Append won't work. (Kim Ingram 2000)
  7. Re: fresh eyes needed. Append won't work. (John Peacock 2000)
  8. Re: fresh eyes needed. Append won't work. (Sally 2000)
  9. Re: fresh eyes needed. Append won't work. (Robert McPeak 2000)
I am having some trouble with this list. I can reply to any message but I can no longer send a new message to the list. Very strange. Is this happening to anyone else?Thanks,Dave. ----- Original Message ----- From: Daventab - Dave Jones To: WebCatalog Talk Sent: Tuesday, July 25, 2000 12:46 PM Subject: Re: fresh eyes needed. Append won't work. > test > ----- Original Message ----- > From: John Peacock > To: WebCatalog Talk > Sent: Tuesday, July 25, 2000 12:31 PM > Subject: Re: fresh eyes needed. Append won't work. > > > > 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 that > > you 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. Just > > add one field and make sure it worked. > > > > Note that fieldnames like [date] are a bad idea, because that conflicts > > with existing WebCat contexts. I don't know if you will have problems > > with [referrer] and [grandtotal], but it is always a good idea to make > > all of your variables something other than built-in WebCat fields. You > > can always prefix _ or my_ for each variable. > > > > HTH > > > > John Peacock > > > > Robert 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=[h > omestreet]&homecity=[homecity]&homestate=[homestate]&homecountry=[homecountr > y]&homectrycode=[homectrycode]&email=[email]&fax=[fax]&telex=[telex]&homepho > ne=[homephone]&workphone=[workphone]&academicstatus=[academicstatus]&occupat > ion=[occupation]&research=[research]&membertype=[membertype]&years=[years]&d > uestotal=[duestotal]&subscription1=[subscription1]&subscription1duration=[su > bsription1duration]&subscription2=[subscription2]&subscription2duration=[sub > scription2duration]&subscription1total=[subscription1total]&subscription2tot > al=[subscription2total]&backissues=[backissues]&grandtotal=[grandtotal]&paym > ent=[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/ > > > > > ------------------------------------------------------------- > 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/ Daventab - Dave Jones

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:

Linux vs Jaguar (OSX) (2002) IE-caching (1998) Nested vs conditional (1997) [include] affect on filepaths for links? (1997) Authenticate (1997) [WebDNA] Bug in 6.2? (2009) Email and name capture (1999) Shipcost lookup? (1997) Mystery authentication (1997) Calculating multiple shipping... (1997) too many nested tags ... (1997) Showif, Hideif reverse logic ? (1997) Installation Woes (2003) How About Credit Card Transactions (1998) autosensing lanague selection (1997) PCS Frames (1997) Clearing orders and database help! (1997) WebTEN vs webSTARtopic (1998) WebMerchant 1.6 and SHTML (1997) [shownext max=?] armed (1997)