Re: in conversions.db crashes unix webcat
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25636
interpreted = N
texte = 1- What happens when you remove the convertchars context from around the [title] tag? Does it still crash?2- What happens when you use the standard default convertchars syntax instead, like this:[convertchars][Title][/convertchars]Does this still cause a crash?By the way, Netscape properly displays a double quote on the web page even when you do not use " in your html, and maybe IE does the same thing. If so, this means you probably don't even need convertchars in this situation, unless you're converting values other than double quotes as well.3- I don't see anything wrong with the html you posted below. Can you post the append/replace form that creates the [title] value? >See replies to several questions below. >:-) >-John > >Kenneth 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: >> >from
to >> >" >> > >> >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. >
> > | SKU | > Department | > Dept. Category | > ItemType | > Title | > Unit Ship Weight | > $Price1 | > Is a Special? | > Edit | > Manufactorer | > Popularity | > Needs Webmaster? | > NumInStock setup | > Remove | >
> [foundItems] > | [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]=]COLOR=#EE1C04> Colors?[/showif][/showif] > [showif [URL][hasColors][/URL]=F][hideif [URL][colorHTML][/URL]=]COLOR=#EE1C04> Colors?[/hideif][/showif] > [showif [URL][hasColors][/URL]=] Colors?[/showif] > [showif [URL][hasColors][/URL]=[URL][raw][hasColors][/raw][/URL]]COLOR=#EE1C04> Colors?[/showif] | > Delete | >
[/foundItems] >
[/Search] > >Create a new product > >
> > > >[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 ================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- 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- What happens when you remove the convertchars context from around the [title] tag? Does it still crash?2- What happens when you use the standard default convertchars syntax instead, like this:[convertchars][Title][/convertchars]Does this still cause a crash?By the way, Netscape properly displays a double quote on the web page even when you do not use " in your html, and maybe IE does the same thing. If so, this means you probably don't even need convertchars in this situation, unless you're converting values other than double quotes as well.3- I don't see anything wrong with the html you posted below. Can you post the append/replace form that creates the [title] value? >See replies to several questions below. >:-) >-John > >Kenneth 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. >
> > | SKU | > Department | > Dept. Category | > ItemType | > Title | > Unit Ship Weight | > $Price1 | > Is a Special? | > Edit | > Manufactorer | > Popularity | > Needs Webmaster? | > NumInStock setup | > Remove | >
> [founditems] > | [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]=]COLOR=#EE1C04> Colors?[/showif][/showif] > [showif [url][hasColors][/URL]=F][hideif [url][colorHTML][/URL]=]COLOR=#EE1C04> Colors?[/hideif][/showif] > [showif [url][hasColors][/URL]=] Colors?[/showif] > [showif [url][hasColors][/URL]=[url][raw][hasColors][/raw][/URL]]COLOR=#EE1C04> Colors?[/showif] | > [url][SKU][/url]>Delete | >
[/foundItems] >
[/Search] > >Create a new product > >
> > > >[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 ================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- 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
Kenneth Grome
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:
WebDNA / Java Chat (2004)
WebCat b15 Mac plug-in (1997)
Emailer setup (1997)
Q: for those who use Cookies for sessions? (2004)
WebCat2: Items xx to xx shown, etc. (1997)
Location of Browser Info.txt file (1997)
Multiple Pulldowns/Gary (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
[movefile] create stationery files (1998)
Assigning Serialized Customer Numbers (1997)
Forumulas.db & Variables (2002)
Feature Request: DB Field manipulation (1998)
New Mac Emailer... (1997)
More DateMath problems (1997)
Sort Order on a page search (1997)
Still Stumped on ShowNext...HELP! (1997)
Weird error/limit - something amiss? (1997)
Showif, Hideif reverse logic ? (1997)
combine search (1998)
5.0 feature request: (2001)