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:

lineitems are gone (1998) Summary search -- speed (1997) WC Host Needed (2000) Rollback capabilities (2002) Help- Linux Install Serial number not taling. (2000) Cleaning up all the shopping carts (2000) IRC Channel (2003) Some Questions (1997) WebDNA 5.0 Enterprise Edition (2003) ups quickcost [repost] (1999) [WebDNA] SEARCH question (2011) Pirated WebCat? NOT... (2003) WebMerchant crashing and other WebMerchant problem (2000) Repeating Fields (1997) SMSI FTP - calander system (2002) Search context not finding recent entries (1998) post (1997) Setting up shop (1997) When to Commitdatabase? (2004) Customer (1998)