Re: in conversions.db crashes unix webcat

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25623
interpreted = N
texte = See replies to several questions below. :-) -JohnKenneth Grome wrote:> >I just figured out... Here's what was causing webcat on Linux to crash- > > > >a template with this- > >[convertchars db=MyConversions.db][Title][/convertchars] > > > >where the title field may contain a character, depending on the record found. > > > >and the contents of 'MyConversions.db' are: > >fromto > >" > > > >If I replace that mark in the from field in that solo record with anything else, > >even an &, then it does not crash. > > > >Does this seem like normal behaviour? Could someone try it on a mac and/or NT, and > >someone also try it on unix and tell me if you get the same results. > > Where in your template are you using your convertchars context?inside a [founditems] that finds all the records in the product.db> > In the web page itself? Or inside an append or replace context?in the HTML itself to make sure any marks (and other chars when they come up later) are converted to " before being sent as source HTML.> > Or in a form field that needs to be surrounded by quotes?no, then I use [input], as you told me a while back ;-)> > How was the value added to the db in the first place?via pass-protected admin template (form), where she adds/edits all the products> > By an [append] or [replace] with [url] surrounding the value?yes, exactly; a [replace... &append=T]...title=[URL][title]...[/URL][/replace]> > Or by exporting the data from a desktop db program? > > Can post the actual code for this template? > If so, maybe someone will see an obvious solution ...Here is the template-********* [include file=FGinc-protect.txt&raw=F&groups=ADMIN] catalog listing [showif [URL][add-mod_submitted][/URL]=T] [hideif [URL][SKU][/URL]^%] [!]------------------------START WebmstrE-Note SENDMAIL------------------------------[/!] [showif [URL][AlertWebmstr][/URL]=yes] [sendmail to=[WebmstrE-Addy]&from=Geri@foo.com&Subject=[date]- Check on product# [SKU]] __________________ [WebmstrE-Note] __________________ http://www.foo.com/1test/ProductCatalog.tmpl http://www.foo.com/1test/ProductAdd-Mod.tmpl?SKU=[interpret][UnURL][SKEW][/UnURL][/interpret]&prodmod=T[/sendmail] [/showif] [!]------------------------END WebmstrE-Note SENDMAIL--------------------------------[/!] [!]------------------------START replace/append product record--------------------------------[/!] [showif [URL][add-mod_submitted][/URL]=T] [Replace db=products.db&eqSKUdatarq=[SKU]&Append=T]SKU=[SKU]&DayAdded=[DayAdded]&MainDept=[MainDept]&Title=[URL][Title][/URL]&Manufactorer=[Manufactorer]&Popularity=[Popularity]&ArticleType=[ArticleType]&RetailPrice=[RetailPrice]&price1=[price1]&price2=[price2]&price3=[price3]&price4=[price4]&price5=[price5]&price6=[price6]&price7=[price7]&price8=[price8]&WhsalePrice=[WhsalePrice]&MomsPrice=[MomsPrice]&NumInStock=[NumInStock]&ShipExpect=[URL][ShipExpect][/URL]&Material=[URL][Material][/URL]&AgeUse=[AgeUse]&SexUse=[SexUse]&hasSizes=[hasSizes]&sizeHTML=[sizeHTML]&hasColors=[hasColors]&colorHTML=[colorHTML]&Dimensions=[URL][Dimensions][/URL]&taxable=[taxable]&canEmail=[canEmail]&UnitShipCost=[UnitShipCost]&UnitShipWght=[UnitShipWght]&HasThumb1=[HasThumb1]&HasDetail1=[HasDetail1]&HasDetail2=[HasDetail2]&Thumb1Name=[Thumb1Name]&Detail1Name=[Detail1Name]&Detail2Name=[Detail2Name]&Thumb1Width=[Thumb1Width]&Thumb1Height=[Thumb1Height]&Detail1Width=[Detail1Width]&Detail1Hght=[Detail1Hght]&Detail2Width=[Detail2Width]&Detail2Hght=[Detail2Hght]&Specials=[Specials]&SpclImgName=[SpclImgName]&SpecialWidth=[SpecialWidth]&SpecialHght=[SpecialHght]&SpclAltTag=[SpclAltTag]&SpclDescript=[URL][SpclDescript][/URL]&ShortDescrip=[URL][ShortDescrip][/URL]&LongDescrip=[URL][LongDescrip][/URL]&Description3=[URL][Description3][/URL]&Category1=[Category1]&Category2=[Category2]&Category3=[Category3]&Category4=[Category4]&Category5=[Category5]&Category6=[Category6]&Category7=[Category7]&HasItemOpt1=[HasItemOpt1]&HasItemOpt2=[HasItemOpt2]&HasItemOpt3=[HasItemOpt3]&ItemOpt1HTML=[ItemOpt1HTML]&ItemOpt2HTML=[ItemOpt2HTML]&ItemOpt3HTML=[ItemOpt3HTML]&HasTestimony=[HasTestimony]&TestimonHTML=[URL][TestimonHTML][/URL]&HasWarranty=[HasWarranty]&Warranty=[URL][Warranty][/URL]&ProductNotes=[URL][ProductNotes][/URL]&NeedsWebmstr=[NeedsWebmstr]&WebmstrE-Note=[URL][WebmstrE-Note][/URL][/Replace][/showif] [!]------------------------END replace/append product record--------------------------------[/!] [/hideif] [showif [URL][SKU][/URL]^%]

Product# [URL][SKU][/URL] has an illegal character in the SKU!! (see the "%xx"? - that's the culprit.) Please use only letters, numbers, hyphens, and underscores!! (NO spaces allowed!) Please hit the back button and correct that BEFORE proceeding!

[/showif] [/showif] [!]------------------------START Browser feed--------------------------------[/!] Modified 28 Nov 4:21 pm

Create a new product[Search db=products.db&neSKUdata=NadaAmingo&SKUsort=1&max=100]

We have [numFound] products in the store now.

[foundItems] [/foundItems]
SKUDepartmentDept. CategoryItemTypeTitleUnit Ship Weight$Price1Is a Special?EditManufactorerPopularityNeeds Webmaster?NumInStock setupRemove
[sku][MainDept][Category3][ArticleType][convertchars db=MyConversions.db][Title][/convertchars][UnitShipWght] oz.$[price1][Specials]Edit[Manufactorer][Popularity][hideif [URL][NeedsWebmstr][/URL]=[URL][raw][NeedsWebmstr][/raw][/URL]] [showif [URL][NeedsWebmstr][/URL]=yes][NeedsWebmstr] [showif [URL][WebmstrE-Note][/URL]=]
??? You fergot the note ???[/showif] [showif [URL][WebmstrE-Note][/URL]=%5bWebmstrE-Note%5d]
??? You forgot the note ???[/showif] [/showif] [showif [URL][NeedsWebmstr][/URL]=no][NeedsWebmstr][/showif] [/hideif]		setup [showif [URL][hasSizes][/URL]=T][showif [URL][sizeHTML][/URL]=] Sizes?[/showif][/showif] [showif [URL][hasSizes][/URL]=F][hideif [URL][sizeHTML][/URL]=] Sizes?[/hideif][/showif] [showif [URL][hasSizes][/URL]=] Sizes?[/showif] [showif [URL][hasSizes][/URL]=[URL][raw][hasSizes][/raw][/URL]] Sizes?[/showif]
adjust [showif [URL][hasColors][/URL]=T][showif [URL][colorHTML][/URL]=] Colors?[/showif][/showif] [showif [URL][hasColors][/URL]=F][hideif [URL][colorHTML][/URL]=] Colors?[/hideif][/showif] [showif [URL][hasColors][/URL]=] Colors?[/showif] [showif [URL][hasColors][/URL]=[URL][raw][hasColors][/raw][/URL]] Colors?[/showif]		Delete
[/Search]

Create a new product

Back to switchboard

[COMMITDATABASE products.db]************ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  2. Re: in conversions.db crashes unix webcat (Anup Setty 1999)
  3. Re: in conversions.db crashes unix webcat (Anup Setty 1999)
  4. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  5. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  6. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  7. Re: in conversions.db crashes unix webcat (John Butler 1999)
  8. Re: in conversions.db crashes unix webcat (John Butler 1999)
  9. Re: in conversions.db crashes unix webcat (John Butler 1999)
  10. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  11. in conversions.db crashes unix webcat (John Butler 1999)
See replies to several questions below. :-) -JohnKenneth Grome wrote:> >I just figured out... Here's what was causing webcat on Linux to crash- > > > >a template with this- > >[convertchars db=MyConversions.db][Title][/convertchars] > > > >where the title field may contain a character, depending on the record found. > > > >and the contents of 'MyConversions.db' are: > >fromto > >" > > > >If I replace that mark in the from field in that solo record with anything else, > >even an &, then it does not crash. > > > >Does this seem like normal behaviour? Could someone try it on a mac and/or NT, and > >someone also try it on unix and tell me if you get the same results. > > Where in your template are you using your convertchars context?inside a [founditems] that finds all the records in the product.db> > In the web page itself? Or inside an append or replace context?in the HTML itself to make sure any marks (and other chars when they come up later) are converted to " before being sent as source HTML.> > Or in a form field that needs to be surrounded by quotes?no, then I use [input], as you told me a while back ;-)> > How was the value added to the db in the first place?via pass-protected admin template (form), where she adds/edits all the products> > By an [append] or [replace] with [url] surrounding the value?yes, exactly; a [replace... &append=T]...title=[url][title]...[/URL][/replace]> > Or by exporting the data from a desktop db program? > > Can post the actual code for this template? > If so, maybe someone will see an obvious solution ...Here is the template-********* [include file=FGinc-protect.txt&raw=F&groups=ADMIN] catalog listing [showif [url][add-mod_submitted][/URL]=T] [hideif [url][SKU][/URL]^%] [!]------------------------START WebmstrE-Note SENDMAIL------------------------------[/!] [showif [url][AlertWebmstr][/URL]=yes] [sendmail to=[WebmstrE-Addy]&from=Geri@foo.com&Subject=[date]- Check on product# [SKU]] __________________ [WebmstrE-Note] __________________ http://www.foo.com/1test/ProductCatalog.tmpl http://www.foo.com/1test/ProductAdd-Mod.tmpl?SKU=[interpret][unurl][SKEW][/UnURL][/interpret]&prodmod=T[/sendmail] [/showif] [!]------------------------END WebmstrE-Note SENDMAIL--------------------------------[/!] [!]------------------------START replace/append product record--------------------------------[/!] [showif [url][add-mod_submitted][/URL]=T] [Replace db=products.db&eqSKUdatarq=[SKU]&Append=T]SKU=[SKU]&DayAdded=[DayAdded]&MainDept=[MainDept]&Title=[url][Title][/URL]&Manufactorer=[Manufactorer]&Popularity=[Popularity]&ArticleType=[ArticleType]&RetailPrice=[RetailPrice]&price1=[price1]&price2=[price2]&price3=[price3]&price4=[price4]&price5=[price5]&price6=[price6]&price7=[price7]&price8=[price8]&WhsalePrice=[WhsalePrice]&MomsPrice=[MomsPrice]&NumInStock=[NumInStock]&ShipExpect=[url][ShipExpect][/URL]&Material=[url][Material][/URL]&AgeUse=[AgeUse]&SexUse=[SexUse]&hasSizes=[hasSizes]&sizeHTML=[sizeHTML]&hasColors=[hasColors]&colorHTML=[colorHTML]&Dimensions=[url][Dimensions][/URL]&taxable=[taxable]&canEmail=[canEmail]&UnitShipCost=[UnitShipCost]&UnitShipWght=[UnitShipWght]&HasThumb1=[HasThumb1]&HasDetail1=[HasDetail1]&HasDetail2=[HasDetail2]&Thumb1Name=[Thumb1Name]&Detail1Name=[Detail1Name]&Detail2Name=[Detail2Name]&Thumb1Width=[Thumb1Width]&Thumb1Height=[Thumb1Height]&Detail1Width=[Detail1Width]&Detail1Hght=[Detail1Hght]&Detail2Width=[Detail2Width]&Detail2Hght=[Detail2Hght]&Specials=[Specials]&SpclImgName=[SpclImgName]&SpecialWidth=[SpecialWidth]&SpecialHght=[SpecialHght]&SpclAltTag=[SpclAltTag]&SpclDescript=[url][SpclDescript][/URL]&ShortDescrip=[url][ShortDescrip][/URL]&LongDescrip=[url][LongDescrip][/URL]&Description3=[url][Description3][/URL]&Category1=[Category1]&Category2=[Category2]&Category3=[Category3]&Category4=[Category4]&Category5=[Category5]&Category6=[Category6]&Category7=[Category7]&HasItemOpt1=[HasItemOpt1]&HasItemOpt2=[HasItemOpt2]&HasItemOpt3=[HasItemOpt3]&ItemOpt1HTML=[ItemOpt1HTML]&ItemOpt2HTML=[ItemOpt2HTML]&ItemOpt3HTML=[ItemOpt3HTML]&HasTestimony=[HasTestimony]&TestimonHTML=[url][TestimonHTML][/URL]&HasWarranty=[HasWarranty]&Warranty=[url][Warranty][/URL]&ProductNotes=[url][ProductNotes][/URL]&NeedsWebmstr=[NeedsWebmstr]&WebmstrE-Note=[url][WebmstrE-Note][/URL][/Replace][/showif] [!]------------------------END replace/append product record--------------------------------[/!] [/hideif] [showif [url][SKU][/URL]^%]

Product# [url][SKU][/URL] has an illegal character in the SKU!! (see the "%xx"? - that's the culprit.) Please use only letters, numbers, hyphens, and underscores!! (NO spaces allowed!) Please hit the back button and correct that BEFORE proceeding!

[/showif] [/showif] [!]------------------------START Browser feed--------------------------------[/!] Modified 28 Nov 4:21 pm

Create a new product[Search db=products.db&neSKUdata=NadaAmingo&SKUsort=1&max=100]

We have [numFound] products in the store now.

[founditems] [/foundItems]
SKUDepartmentDept. CategoryItemTypeTitleUnit Ship Weight$Price1Is a Special?EditManufactorerPopularityNeeds Webmaster?NumInStock setupRemove
[sku][MainDept][Category3][ArticleType][convertchars db=MyConversions.db][Title][/convertchars][UnitShipWght] oz.$[price1][Specials][url][SKU][/url]&prodmod=T>Edit[Manufactorer][Popularity][hideif [url][NeedsWebmstr][/URL]=[url][raw][NeedsWebmstr][/raw][/URL]] [showif [url][NeedsWebmstr][/URL]=yes][NeedsWebmstr] [showif [url][WebmstrE-Note][/URL]=]
??? You fergot the note ???[/showif] [showif [url][WebmstrE-Note][/URL]=%5bWebmstrE-Note%5d]
??? You forgot the note ???[/showif] [/showif] [showif [url][NeedsWebmstr][/URL]=no][NeedsWebmstr][/showif] [/hideif]		[url][SKU][/url]>setup [showif [url][hasSizes][/URL]=T][showif [url][sizeHTML][/URL]=] Sizes?[/showif][/showif] [showif [url][hasSizes][/URL]=F][hideif [url][sizeHTML][/URL]=] Sizes?[/hideif][/showif] [showif [url][hasSizes][/URL]=] Sizes?[/showif] [showif [url][hasSizes][/URL]=[url][raw][hasSizes][/raw][/URL]] Sizes?[/showif]
adjust [showif [url][hasColors][/URL]=T][showif [url][colorHTML][/URL]=] Colors?[/showif][/showif] [showif [url][hasColors][/URL]=F][hideif [url][colorHTML][/URL]=] Colors?[/hideif][/showif] [showif [url][hasColors][/URL]=] Colors?[/showif] [showif [url][hasColors][/URL]=[url][raw][hasColors][/raw][/URL]] Colors?[/showif]		[url][SKU][/url]>Delete
[/Search]

Create a new product

Back to switchboard

[COMMITDATABASE products.db]************ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 John Butler

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:

slowness (1998) problems with WebCat-Plugin (1997) CyberCash problem in OS9/4.5 -> OSX/5.1 transition (2003) Secure Server (1997) [WebDNA] [switch] [case] only works with "=" comparisons.. true? (2009) Re[2]: WebCat is different user (1999) WebCat/CyberStudio Compatibility (1998) WCS Newbie question (1997) Bannerad Demo (1998) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) RAM variables (1997) [format 40s]text[/format] doesn't work (1997) Referrer field to header field conversion (1997) Fun with dates (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Hiding HTML and breaking the page (1997) still having shipCost.db Problem (1997) Re:no [search] with NT (1997) Cool new site (1996)