Re: Escaping regexp control characters
>>Um, did you search CFLib? Hmmm I searched for something else one hour ago, didn't find it so I decided to make it myself, needed this reEscape() function and forgot to search again :-( Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping regexp control characters
Um, did you search CFLib? http://www.cflib.org/udf/REEscape On Thu, Feb 7, 2013 at 12:50 PM, <> wrote: > > Hi, > CF10 provides a new function: reEscape() which as it says escapes regexp > control characters in a string. > I would need such a function but I'm uder CF9. > Has any one heard of a function that would do the same thing? > Thanks. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Escaping #
All forms are in the form scope... It's always a good idea to scope your variables for security reasons. It ensures that you know exactly where the data is coming from and not potentially from a misnamed variable that is higher up in the scope order of precendence... Eric -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Wednesday, February 01, 2012 12:03 PM To: cf-talk Subject: Re: Escaping # Hi Dave My forms up until this time have been very simple and I have never defined or specified the scope or structure of variables. Is there a syntax for the cfloop if no structure is defined or is that when i would need to use evaluate? Thanks Rob On 1 Feb 2012 at 12:46, Dave Watts wrote: > > > What you had suggested didn't work as I hadn't scoped the > variables so I got a > > not defined error message when I tried > > #variables["namefirst" & i]# > > You can use whatever scope the variables are in, though: > > #form["namefirst" & i]# > > > I tried #["namefirst" & i]# but that didn't > > work. > > Right. The brackets indicate membership in a structure, but you didn't > specify the structure > > structure[key] > > Variable scopes are exposed as structures. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA > Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > > ~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= > houseoffusion > Archive: > http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 > 9719 > Subscription: > http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: > http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
> Is there a syntax for the cfloop if no structure is defined or is that when i > would > need to use evaluate? When you create variables, they are in one scope or another. Those structures are always defined. Just use the one that happens to contain your variables. If you submit a form, variables from that form are in the Form scope. If you have variables retrieved from a URL, they're URL variables. Etc, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
A variable will *always* live in a scope. If you POST a form to your server, the form's inputs will be available in the FORM scope. If you send the form using GET or if you hit a page with URL parameters (in effect the same thing), the form inputs / url parameters will be available in the URL scope. Now, the fun part. If you don't specify a scope when addressing variables, ColdFusion will search all the scopes until it finds your variable. Addressing variables without scope can lead to unexpected behaviour should you have the same variable name in different scopes. This seems to explain it well: http://www.garyrgilbert.com/tutorials/coldfusion/beginner/scope.cfm In short though, it is good practice to always declare the scope of your variables when accessing them. You should never need to use Eval() in this situation. HTH Dominic On 1 February 2012 18:03, Rob Voyle wrote: > > Hi Dave > > My forms up until this time have been very simple and I have never defined or > specified the scope or structure of variables. > > Is there a syntax for the cfloop if no structure is defined or is that when i > would > need to use evaluate? > > Thanks > > Rob > > On 1 Feb 2012 at 12:46, Dave Watts wrote: > >> >> > What you had suggested didn't work as I hadn't scoped the >> variables so I got a >> > not defined error message when I tried >> > #variables["namefirst" & i]# >> >> You can use whatever scope the variables are in, though: >> >> #form["namefirst" & i]# >> >> > I tried #["namefirst" & i]# >> > but that didn't work. >> >> Right. The brackets indicate membership in a structure, but you >> didn't >> specify the structure >> >> structure[key] >> >> Variable scopes are exposed as structures. >> >> Dave Watts, CTO, Fig Leaf Software >> http://www.figleaf.com/ >> http://training.figleaf.com/ >> >> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on >> GSA Schedule, and provides the highest caliber vendor-authorized >> instruction at our training centers, online, or onsite. >> >> >> ~| >> Order the Adobe Coldfusion Anthology now! >> http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= >> houseoffusion >> Archive: >> http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 >> 9719 >> Subscription: >> http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm >> Unsubscribe: >> http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm >> > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
Hi Dave My forms up until this time have been very simple and I have never defined or specified the scope or structure of variables. Is there a syntax for the cfloop if no structure is defined or is that when i would need to use evaluate? Thanks Rob On 1 Feb 2012 at 12:46, Dave Watts wrote: > > > What you had suggested didn't work as I hadn't scoped the > variables so I got a > > not defined error message when I tried > > #variables["namefirst" & i]# > > You can use whatever scope the variables are in, though: > > #form["namefirst" & i]# > > > I tried #["namefirst" & i]# > > but that didn't work. > > Right. The brackets indicate membership in a structure, but you > didn't > specify the structure > > structure[key] > > Variable scopes are exposed as structures. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > > ~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= > houseoffusion > Archive: > http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 > 9719 > Subscription: > http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: > http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
> What you had suggested didn't work as I hadn't scoped the variables so I got a > not defined error message when I tried > #variables["namefirst" & i]# You can use whatever scope the variables are in, though: #form["namefirst" & i]# > I tried #["namefirst" & i]# > but that didn't work. Right. The brackets indicate membership in a structure, but you didn't specify the structure structure[key] Variable scopes are exposed as structures. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
Hi Dave What you had suggested didn't work as I hadn't scoped the variables so I got a not defined error message when I tried #variables["namefirst" & i]# I tried #["namefirst" & i]# but that didn't work. Rob On 1 Feb 2012 at 11:39, Dave Watts wrote: > > > Here is what I got to work > > > > > > > > > value="#Evaluate('namefirst' & i)#" /> > > > > > > > > I needed the tag because it wasn't reading the > name=namefirst#i# > > and then needed to evaluate the variable which gets rid of the > multiple ## . > > That will work as well, but in general it's more expensive to use > evaluate (which has to do more work under the covers, to convert > an > arbitrary string to executable code) than the solution I proposed, > which looks for a key within a structure. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
> Here is what I got to work > > > > value="#Evaluate('namefirst' & i)#" /> > > > > I needed the tag because it wasn't reading the name=namefirst#i# > and then needed to evaluate the variable which gets rid of the multiple ## . That will work as well, but in general it's more expensive to use evaluate (which has to do more work under the covers, to convert an arbitrary string to executable code) than the solution I proposed, which looks for a key within a structure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
Hi Dave and Steve Thanks for the help What I am doing is creating a series of pages to register students for a class. I have a set of variables namefirst1 namefirst2 namefirst3 etc. which yield names such as Fred, Sam, Mary etc. that evenutally get passed by hidden input to a confirmation page after the person pays Here is what I got to work I needed the tag because it wasn't reading the name=namefirst#i# and then needed to evaluate the variable which gets rid of the multiple ## . Thanks for your help. Rob On 1 Feb 2012 at 10:10, Dave Watts wrote: > > > I can't get the loop to work > > > > > > > value="#'namefirst' & i#" /> > > > > What is this supposed to output? > > #'namefirst' & i# > > If you want to output the value contained in a variable whose name > consists of the string "namefirst1", "namefirst2", etc, here's one > way > to do it: > > #variables["namefirst" & i]# > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Escaping #
I agree, but I flipped it out quickly without knowing what he really wanted to do with value. However it did fix his issue with not having cfoutputs around #i# in name. Well it would have if I had typed i instead of 1. As always, I defer to the Master! Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, February 01, 2012 10:18 AM To: cf-talk Subject: Re: Escaping # > Try this: > > > > value="#namefirst##i#" /> > > I don't think that's going to get the value of a variable called, say, "namefirst1". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, on ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
> Try this: > > > > value="#namefirst##i#" /> > > I don't think that's going to get the value of a variable called, say, "namefirst1". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, on ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Escaping #
Try this: -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Wednesday, February 01, 2012 10:04 AM To: cf-talk Subject: Re: Escaping # Hi thanks to all the guys who have helped on this project. Most of it is working but... I am passing hidden variables to a confirmation page this line of code works: I can't get the loop to work Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
> I can't get the loop to work > > > value="#'namefirst' & i#" /> > What is this supposed to output? #'namefirst' & i# If you want to output the value contained in a variable whose name consists of the string "namefirst1", "namefirst2", etc, here's one way to do it: #variables["namefirst" & i]# Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
Hi thanks to all the guys who have helped on this project. Most of it is working but... I am passing hidden variables to a confirmation page this line of code works: I can't get the loop to work Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
The error message is because your cfset is invalid. You cannot add a default attribute to a cfset. Try John's solution, or a valid cfset, like this: Or, if you're actually meaning to create an cfparam... HTH Sent from my Samsung Galaxy SII On Jan 23, 2012 6:14 AM, "Rob Voyle" wrote: > > I'm still having trouble with basic cfloop syntax. > > For example: > > > > > > I get an invalid construct message. > > Thanks for the help > > Rob > Robert J. Voyle, Psy.D. > Director, Clergy Leadership Institute > For Coaching and Training in Appreciative Inquiry > Author: Restoring Hope: Appreciative Strategies > to Resolve Grief and Resentment > http://www.appreciativeway.com/ > 503-647-2378 or 503-647-2382 > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
Try: On Mon, Jan 23, 2012 at 6:14 AM, Rob Voyle wrote: > > I'm still having trouble with basic cfloop syntax. > > For example: > > > > > > I get an invalid construct message. > > Thanks for the help > > Rob > Robert J. Voyle, Psy.D. > Director, Clergy Leadership Institute > For Coaching and Training in Appreciative Inquiry > Author: Restoring Hope: Appreciative Strategies > to Resolve Grief and Resentment > http://www.appreciativeway.com/ > 503-647-2378 or 503-647-2382 > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
I'm still having trouble with basic cfloop syntax. For example: I get an invalid construct message. Thanks for the help Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
>>/* note: your cfparam needs "form.namefirst" not just "namefirst" */ Furthermore, if they are text fields, you don't need to set default values. Only for checkboxes or radios ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
/* note: your cfparam needs "form.namefirst" not just "namefirst" */ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
Hi Claude Thanks I still have a problem The value comes from the form itself. The first time the form is read the values are set to default with: In the form I use but I get the error message Element nameFirst1 is undefined in a Java object of type class coldfusion.filter.FormScope. Rob On 21 Jan 2012 at 17:20, =?ISO-8859-1?Q?Claude_Schn=E9 wrote: > > I suppose the namefirst variables come from some Query? > > > value="#evaluate ('nameFirst' & i)#" /> /> > > > However, if the variables namefirst come from a form or some other > structure, there might be a better way. > > value="#form['nameFirst' & i]#" /> > > > > > ~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= > houseoffusion > Archive: > http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 > 9589 > Subscription: > http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: > http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Escaping #
I suppose the namefirst variables come from some Query? However, if the variables namefirst come from a form or some other structure, there might be a better way. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: escaping # in a password...
yeh cfftp worked just fine. but now i cant read the file. keep getting "Incorrect number of columns in row." http://theserver/theFile.04.08.08.txt"; name="gettheFile" firstrowasheaders="no" file="theFile.04.08.08.txt" delimiter="|" > grrr... getting frustrated.. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: escaping # in a password...
> ftp://server/FILE"; port="21" username="jahdata" > password='[EMAIL PROTECTED]' name="getdata" resolveurl="no" > firstrowasheaders="no" delimiter="|"> > > ok... the file i am trying to read has no file extension. > just filename. > also it is only located in a ftp directory.. Use CFFTP to fetch files via FTP, not CFHTTP. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: escaping # in a password...
ftp://server/FILE"; port="21" username="jahdata" password='[EMAIL PROTECTED]' name="getdata" resolveurl="no" firstrowasheaders="no" delimiter="|"> ok... the file i am trying to read has no file extension. just filename. also it is only located in a ftp directory.. could the Pipe '|" as a deliminator be causing problems? if i do a dump i get no info on the file... i should be able to get column_1 - 20 some thing... no even sure if i am truely logged in, since i am only seeing an error when i try to out put results... can i use CFHTTP to retrieve the file info from ftp? i looked at cfftp but couldnt understand how to turn it into a query... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: escaping # in a password...
double it up? On Tue, Apr 8, 2008 at 8:56 AM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > ok... some one is using a # in a ftp password. > how do i escape it in this tag? > ftp://sername"; port="21" username="jahdata" > password='[EMAIL PROTECTED]' name="getdata" resolveurl="no" > firstrowasheaders="no" delimiter="|"> > thanks > -paul > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302960 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: escaping # in a password...
Add 2 more # symbols? -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 08, 2008 11:56 AM To: CF-Talk Subject: escaping # in a password... ok... some one is using a # in a ftp password. how do i escape it in this tag? ftp://sername"; port="21" username="jahdata" password='[EMAIL PROTECTED]' name="getdata" resolveurl="no" firstrowasheaders="no" delimiter="|"> thanks -paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: escaping # in a password...
password='[EMAIL PROTECTED]' -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 08, 2008 10:56 AM To: CF-Talk Subject: escaping # in a password... ok... some one is using a # in a ftp password. how do i escape it in this tag? ftp://sername"; port="21" username="jahdata" password='[EMAIL PROTECTED]' name="getdata" resolveurl="no" firstrowasheaders="no" delimiter="|"> thanks -paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: escaping # in a password...
double it, as one usually does with #? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: > ok... some one is using a # in a ftp password. > how do i escape it in this tag? > ftp://sername"; port="21" username="jahdata" > password='[EMAIL PROTECTED]' name="getdata" resolveurl="no" > firstrowasheaders="no" delimiter="|"> > thanks > -paul > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302957 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: escaping # signs in image file names
Maybe replace the # with %23? On Nov 30, 2007 12:22 PM, Charlie Griefer <[EMAIL PROTECTED]> wrote: > width="164" height="140" border="0" /> ? > > (might need 4 # there in the 3rd arg) > > On Nov 30, 2007 8:54 AM, Crow T. Robot <[EMAIL PROTECTED]> wrote: > > Is there a way to do this that anyone can think of? I have a page that I > > inherited that is outputting user-uploaded images, and just today, the user > > decided to upload images with #'s in the names. The images are not showing > > up because of this. Any way around this other than renaming the images? > > > > code: > > > > > border=0> > > > > > > > > ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: escaping # signs in image file names
there's your answer folks. thanks jerry. On Nov 30, 2007 11:55 AM, Jerry Johnson <[EMAIL PROTECTED]> wrote: > Maybe replace the # with %23? > > > > On Nov 30, 2007 12:22 PM, Charlie Griefer <[EMAIL PROTECTED]> > wrote: > > > width="164" height="140" border="0" /> ? > > > > (might need 4 # there in the 3rd arg) > > > > On Nov 30, 2007 8:54 AM, Crow T. Robot <[EMAIL PROTECTED]> wrote: > > > Is there a way to do this that anyone can think of? I have a page > that I > > > inherited that is outputting user-uploaded images, and just today, the > user > > > decided to upload images with #'s in the names. The images are not > showing > > > up because of this. Any way around this other than renaming the > images? > > > > > > code: > > > > > > > > border=0> > > > > > > > > > > > > > > > ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: escaping # signs in image file names
? (might need 4 # there in the 3rd arg) On Nov 30, 2007 8:54 AM, Crow T. Robot <[EMAIL PROTECTED]> wrote: > Is there a way to do this that anyone can think of? I have a page that I > inherited that is outputting user-uploaded images, and just today, the user > decided to upload images with #'s in the names. The images are not showing > up because of this. Any way around this other than renaming the images? > > code: > > border=0> > > > ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: escaping # signs in image file names
> Is there a way to do this that anyone can think of? I have a > page that I inherited that is outputting user-uploaded > images, and just today, the user decided to upload images > with #'s in the names. The images are not showing up because > of this. Any way around this other than renaming the images? Wrap the filename in URLEncodedFormat()? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping ampersands
> Where JREReplace is a handy function by Ben Nadel which allows use of > regex callback functions. ( See http://www.bennadel.com/index. > cfm?dax=blog:191.view ) That's some pretty neat stuff, I definitely will bookmark that for the future. I've found a work-around for my particular application so I don't have to do a regex replace, I didn't want it getting too complex as it's going to run pretty frequently under load. MJS ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping ampersands
Hmmm, in that case I'd probably replace out any JS ones first, then run the above, then swap back in the JS ones. And the easiest way of doing that would probably be something like this: ]*>).*?(?=)",RemoveJsAmp,"all")/> [code from above] ]*>).*?(?=)",RestoreJsAmp,"all")/> Where JREReplace is a handy function by Ben Nadel which allows use of regex callback functions. ( See http://www.bennadel.com/index.cfm?dax=blog:191.view ) And the two callback functions mentioned above would be along the lines of: > > Assuming what you're actually asking is how to escape any ampersands > > > that are not part of an existing entity, try this... > > Hhm, yeah that might work. I really don't need to worry too much about > any ampersands outside links (without getting too into detail, they > are generally escaped earlier) but wouldn't mind making sure they are > all done. Problem is if the text block has any javascript code > embedded, which is possible, I don't want to replace ampersands in > there too. > > --- Mary Jo > > ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping ampersands
> Assuming what you're actually asking is how to escape any ampersands > that are not part of an existing entity, try this... Hhm, yeah that might work. I really don't need to worry too much about any ampersands outside links (without getting too into detail, they are generally escaped earlier) but wouldn't mind making sure they are all done. Problem is if the text block has any javascript code embedded, which is possible, I don't want to replace ampersands in there too. --- Mary Jo ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping ampersands
Hmm, the result argument is displaying as just "[ampersand]", but I definitely put "[ampersand]amp;" in it. :/ > Assuming what you're actually asking is how to escape any ampersands > that are not part of an existing entity, try this... > > REReplace(Text,"&(?!([##A-Za-z0-9]{2,6};))","&","all") > > > (because any non-entity ampersands must be escaped everywhere, not > just in links) > > > > Okay, I can usually figure out my regular expressions when needed, > but > > this one has me a bit stumped. Basically I have an unknown chunk of > > > text in which I need to make sure any URLs are XHTML-compliant...i.e. > > > any ampersands are escaped, if not already. I need to be sure to > only > > replace within the tags, not the rest of the text, and to not > > replace any ampersands that are already escaped. Anyone want to take > a > > stab at it? > > > > --- Mary Jo ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping ampersands
Assuming what you're actually asking is how to escape any ampersands that are not part of an existing entity, try this... REReplace(Text,"&(?!([##A-Za-z0-9]{2,6};))","&","all") (because any non-entity ampersands must be escaped everywhere, not just in links) > Okay, I can usually figure out my regular expressions when needed, but > this one has me a bit stumped. Basically I have an unknown chunk of > text in which I need to make sure any URLs are XHTML-compliant...i.e. > any ampersands are escaped, if not already. I need to be sure to only > replace within the tags, not the rest of the text, and to not > replace any ampersands that are already escaped. Anyone want to take a > stab at it? > > --- Mary Jo ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: escaping Semi Colons
That is not the problem after all. I sent another email today with the actual issue. On 12/27/06, Ken Wexel <[EMAIL PROTECTED]> wrote: > > If you don't want them in the content at all, is there any reason you > can't strip them out using Replace or ReplaceNoCase? > > > > On 12/26/06, Bruce Sorge <[EMAIL PROTECTED]> wrote: > > Hello list, > > I have a form that contains some free text fields, and users sometimes > put > > semi-colons in the field. I am outputting the information using the > > ParagraphFormat function. What is happening though is that the output > fields > > formatting ( Tag) ends at the semi-colon rather than retain the > > format for the entire field. So other than tell the users to stop using > > semi-colons, how do I work around this? > > > > Thanks, > > > > -- > > Bruce Sorge > > > > > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: escaping Semi Colons
If you don't want them in the content at all, is there any reason you can't strip them out using Replace or ReplaceNoCase? On 12/26/06, Bruce Sorge <[EMAIL PROTECTED]> wrote: > Hello list, > I have a form that contains some free text fields, and users sometimes put > semi-colons in the field. I am outputting the information using the > ParagraphFormat function. What is happening though is that the output fields > formatting ( Tag) ends at the semi-colon rather than retain the > format for the entire field. So other than tell the users to stop using > semi-colons, how do I work around this? > > Thanks, > > -- > Bruce Sorge > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
>> > Jim Write Wrote: Did you do an grave accent (ascii 96), not a single > quote? That works in a local version of Access. > > Yeah, I used the `. Unfortunately, what works *in* Access doesn't > necessarily work from CF. For instance (it's been a while since I've > used Access from CF, so don't quote me on this), * is the wildcard > while *in* Access, but from, say CF, you need to use the normal %. > > Thanks, > Jamie What version of CF are you using? I just did a test in my local install of CF7, and the ` syntax worked fine (with both the Access driver and the ODBC Socket). Are you sure that you are working with a table here? Looking back at your previous message, the error "Undefined function 'FormatNumber' in expression." seems more like something you would see from a query. I'm betting that this is a query that has a field using the vba formatnumber function. That function is available to Access, but it doesn't seem to be available through ODBC or JDBC. I just tested this by creating a view that uses the FormatNumber function, and sure enough, I get that error when I try to pull data through CF. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
Prob the best thing is just to rename the things!! Should be easy in access and then of course you know search and replace is your best friend in studio or dreamweaver :) - Original Message - From: "Jim Wright" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, September 26, 2006 4:50 PM Subject: Re: Escaping parentheses in table names (querying MS Access DB) > Perhaps you could just create a query in Access with a friendly name > that just selects all from the oddly named table. Then use that query > name in CF. > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
Perhaps you could just create a query in Access with a friendly name that just selects all from the oddly named table. Then use that query name in CF. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
Not real familiar with access, and not sure if access has the "ESCAPE" function or if the escape function will work on table names. IE: select * from mytable(1) ESCAPE '(' ESCAPE ')' - Original Message - From: "Jamie Jackson" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, September 26, 2006 4:34 PM Subject: Re: Escaping parentheses in table names (querying MS Access DB) > I don't think this is going to be possible. I think the tables will > have to be renamed. I hate Access for (among other things) allowing > such odd, non-interoperable entity names. I was hoping not to have to > dig into this ugly, inherited DB. > > However, I hope I'm wrong, and that someone knows a workaround > > Jamie > > On 9/26/06, Jamie Jackson <[EMAIL PROTECTED]> wrote: > > The table name is "qry 1(1)" (everything between the quotes). > > > > SELECT > > * > > FROM > > [qry 1(1)] > > > > I tried the above, but it yields: > > > > Error Executing Database Query. > > Undefined function 'FormatNumber' in expression. > > > > Any ideas? > > > > Thanks, > > Jamie > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
I don't think this is going to be possible. I think the tables will have to be renamed. I hate Access for (among other things) allowing such odd, non-interoperable entity names. I was hoping not to have to dig into this ugly, inherited DB. However, I hope I'm wrong, and that someone knows a workaround Jamie On 9/26/06, Jamie Jackson <[EMAIL PROTECTED]> wrote: > The table name is "qry 1(1)" (everything between the quotes). > > SELECT > * > FROM > [qry 1(1)] > > I tried the above, but it yields: > > Error Executing Database Query. > Undefined function 'FormatNumber' in expression. > > Any ideas? > > Thanks, > Jamie > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping parentheses in table names (querying MS Access DB)
On 9/26/06, Jamie Jackson <[EMAIL PROTECTED]> wrote: > On 9/26/06, Jamie Jackson <[EMAIL PROTECTED]> wrote: > > The table name is "qry 1(1)" (everything between the quotes). > > > > SELECT > > * > > FROM > > [qry 1(1)] > > > > I tried the above, but it yields: > > > > Error Executing Database Query. > > Undefined function 'FormatNumber' in expression. > > > > Any ideas? > > > > Thanks, > > Jamie > > Jim Wright Wrote: SELECT * FROM `qry 1(1)` > > Thanks, but same issue with that syntax. > > Jamie > Jim Write Wrote: Did you do an grave accent (ascii 96), not a single quote? That works in a local version of Access. Yeah, I used the `. Unfortunately, what works *in* Access doesn't necessarily work from CF. For instance (it's been a while since I've used Access from CF, so don't quote me on this), * is the wildcard while *in* Access, but from, say CF, you need to use the normal %. Thanks, Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
> > Jim Wright Wrote: SELECT * FROM `qry 1(1)` > > Thanks, but same issue with that syntax. > > Jamie Did you do an grave accent (ascii 96), not a single quote? That works in a local version of Access. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
On 9/26/06, Jamie Jackson <[EMAIL PROTECTED]> wrote: > The table name is "qry 1(1)" (everything between the quotes). > > SELECT > * > FROM > [qry 1(1)] > > I tried the above, but it yields: > > Error Executing Database Query. > Undefined function 'FormatNumber' in expression. > > Any ideas? > > Thanks, > Jamie > Claude Schneegans wrote: Shoot the moron who created such a stupid table name! ;-) Interesting approach, but that's frowned upon in my workplace. ;-) Thanks, Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
On 9/26/06, Jamie Jackson <[EMAIL PROTECTED]> wrote: > The table name is "qry 1(1)" (everything between the quotes). > > SELECT > * > FROM > [qry 1(1)] > > I tried the above, but it yields: > > Error Executing Database Query. > Undefined function 'FormatNumber' in expression. > > Any ideas? > > Thanks, > Jamie Jim Wright Wrote: SELECT * FROM `qry 1(1)` Thanks, but same issue with that syntax. Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping parentheses in table names (querying MS Access DB)
>>Any ideas? Shoot the moron who created such a stupid table name! ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
Jamie Jackson wrote: > The table name is "qry 1(1)" (everything between the quotes). > > SELECT > * > FROM > [qry 1(1)] > > I tried the above, but it yields: > > Error Executing Database Query. > Undefined function 'FormatNumber' in expression. > > Any ideas? > SELECT * FROM `qry 1(1)` ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Escaping a : character
Just a guess without testing but I'm pretty sure #XMLContent.rss.channel.item['yweather:condition'].text.xmlText# will work -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 10:36 AM To: CF-Talk Subject: Escaping a : character Hi How do you escape the : character within the following line #XMLContent.rss.channel.item.yweather:condition.text.xmlText# I am getting the following error, I have tried escaping it with \: and :: and ":" but I am still getting the same error Invalid CFML construct found on line 41 at column 38. ColdFusion was looking at the following text: : ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping a : character
I'm pretty sure it's #: Ian Vaughan wrote: > Hi > > How do you escape the : character within the following line > > #XMLContent.rss.channel.item.yweather:condition.text.xmlText# > > I am getting the following error, I have tried escaping it with \: and > :: and ":" but I am still getting the same error > > Invalid CFML construct found on line 41 at column 38. > ColdFusion was looking at the following text: > : > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Escaping #'s in outputting a CSS
You can use rgb(rr,gg,bb) instead of Hex numbers in CSS. Sandra Clark == http://www.shayna.com Training in Cascading Style Sheets and Accessibility -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 12:52 PM To: CF-Talk Subject: Escaping #'s in outputting a CSS Stupid beginner question I know but it's been a long time since I've done any REAL CF coding. I am trying to create an HTML code generator for a client and am having problems escaping the #'s in the CSS. I tried the good ole ## but that's not working. It throws an error. If I just remove the #'s then the colors don't get set the way they're supposed to. I can provide code samples if needed. TIA, Katrina Chapman ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238153 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Escaping #'s in outputting a CSS
What is the error being thrown?? ... Ben Nadel www.bennadel.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 12:52 PM To: CF-Talk Subject: Escaping #'s in outputting a CSS Stupid beginner question I know but it's been a long time since I've done any REAL CF coding. I am trying to create an HTML code generator for a client and am having problems escaping the #'s in the CSS. I tried the good ole ## but that's not working. It throws an error. If I just remove the #'s then the colors don't get set the way they're supposed to. I can provide code samples if needed. TIA, Katrina Chapman ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238146 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Escaping #'s in outputting a CSS
Are you trying to replace "#" with "##"? If so, you might need to replace "##" with "". Maybe a code sample of what you're attempting will help. Is the CSS embedded or inline? If it's linked, then of course there's no need to escape the #'s On 4/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Stupid beginner question I know but it's been a long time since I've done any > REAL CF coding. > > I am trying to create an HTML code generator for a client and am having > problems escaping the #'s in the CSS. I tried the good ole ## but that's not > working. It throws an error. If I just remove the #'s then the colors don't > get set the way they're supposed to. > > I can provide code samples if needed. > > TIA, > Katrina Chapman > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238141 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: escaping reserved words in flash forms
does nobody know this problem? I thought it's very usual.. -- Sebastian Mork [EMAIL PROTECTED] -- On Mon, 25 Apr 2005 20:59:16 +0200 Sebastian Mork <[EMAIL PROTECTED]> wrote: > Hi, > > hmm, but I don't get it working. e.g. > > throws an error; trying to escape it this way: \delete doesn't work,too. > > or, how is this done?? (strangely) > > -- > Sebastian Mork > [EMAIL PROTECTED] > -- > > On Mon, 25 Apr 2005 14:45:57 -0400 > Dave Watts <[EMAIL PROTECTED]> wrote: > > > > But, how does escaping in actionscript work, some kind of > > > using backslashes as in regEx&js? > > > > Yes, the backslash character is the escape metacharacter in ECMAScript > > languages. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > > > Fig Leaf Software provides the highest caliber vendor-authorized > > instruction at our training centers in Washington DC, Atlanta, > > Chicago, Baltimore, Northern Virginia, or on-site at your location. > > Visit http://training.figleaf.com/ for more information! > > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: escaping reserved words in flash forms
Hi, hmm, but I don't get it working. e.g. throws an error; trying to escape it this way: \delete doesn't work,too. or, how is this done?? (strangely) -- Sebastian Mork [EMAIL PROTECTED] -- On Mon, 25 Apr 2005 14:45:57 -0400 Dave Watts <[EMAIL PROTECTED]> wrote: > > But, how does escaping in actionscript work, some kind of > > using backslashes as in regEx&js? > > Yes, the backslash character is the escape metacharacter in ECMAScript > languages. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: escaping reserved words in flash forms
> But, how does escaping in actionscript work, some kind of > using backslashes as in regEx&js? Yes, the backslash character is the escape metacharacter in ECMAScript languages. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Escaping ##
Try: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201955 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Escaping #
Try ## > -Original Message- > From: Richard Crawford [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 07, 2005 1:20 PM > To: CF-Talk > Subject: Escaping # > > > I have to do something like this: > > replace "bob #1" with "bob \#1" > > I tried, > > > > But that only gave me an error; I suspect that CF is still trying to > process the octothorpe as a variable delimiter. Is there a way to > escape the # so that I can include a literal # in my replace function? > > > -- > Richard S. Crawford > Programmer III > UC Davis Extension Distance Education Group > (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C > Sacramento, CA 95816 (916)327-7793 > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Escaping for javascript
Yes and no... I would assume that if you said, to pass a string to a js function, that you would mean the entire string, regardless of what the string contains. The fact that it might not be used very often is irrespective of the context of jsstringformat() being to format a string, regardless of what the string contains... If a bug is encountered rarely that doesn't change the condition, except perhaps in the most existential sense... I don't work with CORBA therefore CORBA bugs are not bugs _to_me_. :) The ability to safely (key word) pass a string to a javascript literal value isn't given by jsstringformat() alone. It succeeds in most but not all cases, hence the bug. In particular this is an issue if you create generic UDFs or Custom Tags intended for general consumption by other developers and which are expected to receive unknown variables which would then be placed in javascript string arguments. If the tag uses jsstringformat() to populate the title of an article and a user enters "the Perils of web programming" (a cute title for a technical article), the expected behavior of the tag (populating the title) will be replaced with a javascript error on the page. Personally I'd call that a bug. That being said, I still occasionally use jsstringformat() unmodified when I expect that a variable might contain a \ but don't ever expect it to contain , for isntance when escaping a file path. > i don't think i'd see that as a bug...i think the function > exists to > safely format content being passed to a JS function. > this, it does. > i'm sure i'll be corrected if i'm wrong...but i don't > think > '' as a string is often passed as an argument to > a function. > I would say that escaping that string would be beyond the > defined > scope of the jsStringFormat() function, and therefore not > in and of > itself, a bug. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193953 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Escaping for javascript
i don't think i'd see that as a bug...i think the function exists to safely format content being passed to a JS function. this, it does. i'm sure i'll be corrected if i'm wrong...but i don't think '' as a string is often passed as an argument to a function. I would say that escaping that string would be beyond the defined scope of the jsStringFormat() function, and therefore not in and of itself, a bug. On Wed, 9 Feb 2005 14:43:45 -0500, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > Works a treat as long as the string doesn't contain the value > "" in it anywhere... which essentially means that while > jsstringformat is great for most applications, it's not bulletproof > (has a bug). If you need to bulletproof it, you have to add the > replacement of / with \/, i.e. > replace(jsstringformat(mystring),"/","\/","ALL"); I put this in a > function myself -- and I _think_ I submitted it to cflib.org as > jsformat() > > function jsformat(str) { return > replace(jsstringformat(str),"/","\/","ALL"); } > > just fyi > > > jsStringFormat() > > > On Wed, 09 Feb 2005 11:02:30 -0400, G. Brown > > <[EMAIL PROTECTED]> wrote: > >> Simple question... > >> > >> Is there an easy way to escape strings passed to > >> javascript in Cold Fusion, aside from using the replace > >> function? > >> > >> whateverFunc('#myvar#'); > >> > >> Just curious. > >> Thanks > >> G- > > s. isaac dealey 954.927.5117 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://macromedia.breezecentral.com/p49777853/ > http://www.sys-con.com/story/?storyid=44477&DE=1 > http://www.sys-con.com/story/?storyid=45569&DE=1 > http://www.fusiontap.com > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193930 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Escaping for javascript
Works a treat as long as the string doesn't contain the value "" in it anywhere... which essentially means that while jsstringformat is great for most applications, it's not bulletproof (has a bug). If you need to bulletproof it, you have to add the replacement of / with \/, i.e. replace(jsstringformat(mystring),"/","\/","ALL"); I put this in a function myself -- and I _think_ I submitted it to cflib.org as jsformat() function jsformat(str) { return replace(jsstringformat(str),"/","\/","ALL"); } just fyi > jsStringFormat() > On Wed, 09 Feb 2005 11:02:30 -0400, G. Brown > <[EMAIL PROTECTED]> wrote: >> Simple question... >> >> Is there an easy way to escape strings passed to >> javascript in Cold Fusion, aside from using the replace >> function? >> >> whateverFunc('#myvar#'); >> >> Just curious. >> Thanks >> G- s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193926 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Escaping for javascript
jsStringFormat() On Wed, 09 Feb 2005 11:02:30 -0400, G. Brown <[EMAIL PROTECTED]> wrote: > Simple question... > > Is there an easy way to escape strings passed to javascript in Cold Fusion, > aside from using the replace function? > > whateverFunc('#myvar#'); > > Just curious. > Thanks > G- > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193857 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Escaping for javascript
jsStringFormat() -Original Message- From: G. Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 10:03 AM To: CF-Talk Subject: Escaping for javascript Simple question... Is there an easy way to escape strings passed to javascript in Cold Fusion, aside from using the replace function? whateverFunc('#myvar#'); Just curious. Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193853 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: escaping " character
> I am really lost here - I have read through the livedocs > article on cfqueryparam and it seems that it is meant to go > to the right of a where clause in a cfquery statement. I am > really not sure how/why to use it. You simply use it anywhere you would otherwise use a CF variable within your SQL statement. For example: WHERE MyID = #Form.MyID# becomes: WHERE MyID = Note that you don't use single quotes around CFQUERYPARAM, even when working with string or date values. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Yeah it is! In case you haven't seen it. http://www.macromedia.com/devnet/mx/coldfusion/articles/ben_forta_faster.htm l _ From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 4:26 p.m. To: CF-Talk Subject: RE: escaping " character OK great - I will give this a go, it seems a bit painstaking though Kind Regards, Brant Winter _ From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 1:54 PM To: CF-Talk Subject: RE: escaping " character VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Worked beautifully ! Had to change name= to value= though :) _ From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 1:54 PM To: CF-Talk Subject: RE: escaping " character VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. _ From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 3:56 p.m. To: CF-Talk Subject: RE: escaping " character I am really lost here - I have read through the livedocs article on cfqueryparam and it seems that it is meant to go to the right of a where clause in a cfquery statement. I am really not sure how/why to use it. Use !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 13:26 > To: CF-Talk > Subject: RE: escaping " character > > What am i doing wrong here ? Sorry about the huge post, but I just cant > see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
OK great - I will give this a go, it seems a bit painstaking though Kind Regards, Brant Winter _ From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 1:54 PM To: CF-Talk Subject: RE: escaping " character VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. _ From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 3:56 p.m. To: CF-Talk Subject: RE: escaping " character I am really lost here - I have read through the livedocs article on cfqueryparam and it seems that it is meant to go to the right of a where clause in a cfquery statement. I am really not sure how/why to use it. Use !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 13:26 > To: CF-Talk > Subject: RE: escaping " character > > What am i doing wrong here ? Sorry about the huge post, but I just cant > see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
I am really lost here - I have read through the livedocs article on cfqueryparam and it seems that it is meant to go to the right of a where clause in a cfquery statement. I am really not sure how/why to use it. Use !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 13:26 > To: CF-Talk > Subject: RE: escaping " character > > What am i doing wrong here ? Sorry about the huge post, but I just cant > see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping " character
Mark, Don't quote me on this, you'll have to double check, but in reference to item 'a' of your list I think I remember seeing a UDF function library at cflib.org for handling CSV files. If that wasn't it then I may have seen a CFC somewhere (cfczone.org maybe). There are resources out there... Cutter Mark Drew wrote: > With regards to this thread, > I am about to embark on doing alittle functionality to a site where > people will be able to upload CSV files. There will be different CSV > types for different data and I wondered if > a) there are some good CSV functions out there for parsing into db or > query (different delimiters, text qualifiers etc) > b) if anyone has done a "template" to check a CSV against? What I mean > is "this CSV should have x number of columns" and they are "x, y, z" > etc > > Regards > > Mark Drew > > > On Mon, 06 Sep 2004 13:47:39 +0200, Jochem van Dieten > <[EMAIL PROTECTED]> wrote: > > Brant Winter wrote: > > > > > Just for testing I made a simple access db and made all the fields text > > > fields. I tried putting single quotes around all of the #qData.xxx# > and all > > > I ended up with was qData.xxx in the resulting error message. > > > > If you choose to go the way of the single quotes, you should only > > add them around text fields, not around numbers and dates. > > However, it is *highly* recommended to use cfqueryparam. > > > > Jochem > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping " character
With regards to this thread, I am about to embark on doing alittle functionality to a site where people will be able to upload CSV files. There will be different CSV types for different data and I wondered if a) there are some good CSV functions out there for parsing into db or query (different delimiters, text qualifiers etc) b) if anyone has done a "template" to check a CSV against? What I mean is "this CSV should have x number of columns" and they are "x, y, z" etc Regards Mark Drew On Mon, 06 Sep 2004 13:47:39 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Brant Winter wrote: > > > Just for testing I made a simple access db and made all the fields text > > fields. I tried putting single quotes around all of the #qData.xxx# and all > > I ended up with was qData.xxx in the resulting error message. > > If you choose to go the way of the single quotes, you should only > add them around text fields, not around numbers and dates. > However, it is *highly* recommended to use cfqueryparam. > > Jochem > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping " character
Brant Winter wrote: > Just for testing I made a simple access db and made all the fields text > fields. I tried putting single quotes around all of the #qData.xxx# and all > I ended up with was qData.xxx in the resulting error message. If you choose to go the way of the single quotes, you should only add them around text fields, not around numbers and dates. However, it is *highly* recommended to use cfqueryparam. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Use !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 13:26 > To: CF-Talk > Subject: RE: escaping " character > > What am i doing wrong here ? Sorry about the huge post, but I just cant > see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Just for testing I made a simple access db and made all the fields text fields. I tried putting single quotes around all of the #qData.xxx# and all I ended up with was qData.xxx in the resulting error message. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping " character
Brant Winter wrote: > What am i doing wrong here ? Sorry about the huge post, but I just > cant see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > > > > resolveurl="no" timeout="20"> > > > > INSERT INTO scripts ( SRXNO, SDISPDATE, PTITLE, PFIRSTNAME, > PSURNAME, PADDRESS, PSUBURB, PPOSTCODE, PMEDICARE, PMEDICDATE, > PCONCTYPE, PCONCNO, PCONCVDATE, PSAFENTNO, PREPATNO, SDOCPRESNO, > SDOCNAME, SDRUGDESC, SALTDESC, SQTY, SAUTHORITY, SSIGS, SWARDNO ) > VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#, > #qData.PFIRSTNAME#, #qData.PSURNAME#, #qData.PADDRESS#, > #qData.PSUBURB#, #qData.PPOSTCODE#, #qData.PMEDICARE#, > #qData.PMEDICDATE#, #qData.PCONCTYPE#, #qData.PCONCNO#, > #qData.PCONCVDATE#, #qData.PSAFENTNO#, #qData.PREPATNO#, > #qData.SDOCPRESNO#, #qData.SDOCNAME#, #qData.SDRUGDESC#, > #qData.SALTDESC#, #qData.SQTY#, #qData.SAUTHORITY#, #qData.SSIGS#, > #qData.SWARDNO# ) > > You need single quotes around your text and dates must in an appropriate format for your database. You should look into using CFQueryParam and possibly CreateODBCDateTime et al. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
What am i doing wrong here ? Sorry about the huge post, but I just cant see what I am missing now ? The error in line 57 refers to a different field than the exception message showing an address "Syntax error (missing operator) in query _expression_ '2 HOLBOURN CRES'." Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query _expression_ '2 HOLBOURN CRES'. The error occurred in C:\Inetpub\wwwroot\HOCACF\pharma\test.cfm: line 57 55 : #qData.SAUTHORITY#, 56 : #qData.SSIGS#, 57 : #qData.SWARDNO# ) 58 : 59 : resolveurl="no" timeout="20"> INSERT INTO scripts ( SRXNO, SDISPDATE, PTITLE, PFIRSTNAME, PSURNAME, PADDRESS, PSUBURB, PPOSTCODE, PMEDICARE, PMEDICDATE, PCONCTYPE, PCONCNO, PCONCVDATE, PSAFENTNO, PREPATNO, SDOCPRESNO, SDOCNAME, SDRUGDESC, SALTDESC, SQTY, SAUTHORITY, SSIGS, SWARDNO ) VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#, #qData.PFIRSTNAME#, #qData.PSURNAME#, #qData.PADDRESS#, #qData.PSUBURB#, #qData.PPOSTCODE#, #qData.PMEDICARE#, #qData.PMEDICDATE#, #qData.PCONCTYPE#, #qData.PCONCNO#, #qData.PCONCVDATE#, #qData.PSAFENTNO#, #qData.PREPATNO#, #qData.SDOCPRESNO#, #qData.SDOCNAME#, #qData.SDRUGDESC#, #qData.SALTDESC#, #qData.SQTY#, #qData.SAUTHORITY#, #qData.SSIGS#, #qData.SWARDNO# ) The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
I think " is the default qualifier. You can even drop the delimiter (I think , is the default). Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 12:53 > To: CF-Talk > Subject: RE: escaping " character > > Wo - why does that work ? I specify the delimiter only ( as > the > data didn't have a text qualifier ) and the query output is spot on now > ??? > > > > > > resolveurl="no" timeout="20"> > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. It is the responsibility of the recipient to ensure that the > onward transmission, opening or use of this message and any attachments > will not adversely affect its systems or data. Please carry out such virus > and other checks, as you consider appropriate. To the fullest extent > allowed by law, no responsibility is accepted by Haematology & Oncology > Clinics of Australasia for any virus damage caused by this message. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Wo - why does that work ? I specify the delimiter only ( as the data didn't have a text qualifier ) and the query output is spot on now ??? resolveurl="no" timeout="20"> The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping " character
A simple solution would be to see if your data supplier can use a different delimiter. Instead of a comma, if they can use a '|' (pipe symbol found to left of 'Z' on keyboard) or a ~ (tilda) character then these tend not to crop up in 'ordinary text'. You could 'parse' the data yourself. That is look for the text qualified " using the find function, mark this character position as the start of a text field and look for the closing ", mark this as the end, now for the characters within this region strip out any delimiter characters. Repeat for rest of string. - Original Message - From: Brant Winter <[EMAIL PROTECTED]> Date: Mon, 6 Sep 2004 19:31:09 +1000 Subject: RE: escaping " character To: CF-Talk <[EMAIL PROTECTED]> It will be a regular transfer, almost on a daily basis. I am not sure if I am going to be able to get the other party to supply the data with double quotes and commas as in a text qualifier. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Yes, it would read the data as if it came from a database table using cfquery. resolveurl="no" timeout="20" charset="charset of the page"> Replace the values with your own and test to see the result. The csv file must be accessible from the web (using a fully qualified url). Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 11:20 > To: CF-Talk > Subject: RE: escaping " character > > So when you say to read the csv as a query object what exactly do you mean > ?Do you mean treat the data as if it came straight out of a > statement ? I am confused ! > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
It will be a regular transfer, almost on a daily basis. I am not sure if I am going to be able to get the other party to supply the data with double quotes and commas as in a text qualifier. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping " character
Brant Winter wrote: > So when you say to read the csv as a query object what exactly do you mean > ?Do you mean treat the data as if it came straight out of a > statement ? I am confused ! Pascal made a minor typo. "A query object in cf is what you would get as a result from a cfquery." should read " A query object in cf is what you would get as a result from a cfhttp." CFFILE will read your file into a variable in one big block. If you use CFHTTP to read your file in, it is possible to put your CSV data straight into a cfquery object. You can then loop through your query object and insert the data into the database. You should find this easier than trying to parse your CSV file manually. Have a read up on CFHTTP and you should see what Pascal is trying to say to you. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
So when you say to read the csv as a query object what exactly do you mean ?Do you mean treat the data as if it came straight out of a statement ? I am confused ! The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping " character
Hi Brant, Is this a one-off import or will this be a regular part of the system? - Original Message - From: Brant Winter <[EMAIL PROTECTED]> Date: Mon, 6 Sep 2004 18:41:36 +1000 Subject: RE: escaping " character To: CF-Talk <[EMAIL PROTECTED]> I am not too sure what a "proper csv parser" is ? I assumed that the code: variable="csvData"> was properly parsing csv data ? I am also a bit shady on exactly what is a text qualifier. I will look into CFHTTP but I don't know what you mean by reading the csv as a query object ? I will Google on ! _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 6:08 PM To: CF-Talk Subject: RE: escaping " character Your problem is with how cf treats lists. The delimiter can't be present in a value, or it will be treated as separate elements. You will need to use a proper csv parser that allows a text qualifier ("). Have you considered CFHTTP to read the csv into a query object? In a recent tread, someone suggested a Java csv parser, but I don't remember which one. Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 05:55 > To: CF-Talk > Subject: RE: escaping " character > > Actually - I have just found the issue. I am using the listfix udf :- > http://www.cflib.org/udf.cfm/listfix > > > > The problem is that, the string I was trying to insert actually has a > single > comma in the csv file:- > > > > BLEOMYCIN (BL) INJ 15,000 i.u. > > > > Is there anyway to exclude listfix from picking this up as a separate > field > ?? > > > > My code is: > > > > > > variable="csvData"> > > > > > > > > > > > > Should I be using the commented code instead > > > > Thanks again > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. It is the responsibility of the recipient to ensure that the > onward transmission, opening or use of this message and any attachments > will not adversely affect its systems or data. Please carry out such virus > and other checks, as you consider appropriate. To the fullest extent > allowed by law, no responsibility is accepted by Haematology & Oncology > Clinics of Australasia for any virus damage caused by this message. > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
The cffile just reads the file, it doesn't parse anything. A text qualifier is a character you place around text in a csv (usually "). When you have a comma in the text (surrounded by quotes), it means it is just a comma, not a delimiter. A,B,C,D ==> 4 elements A B C D A,"B,C",D ==> 3 elements A B,C D A query object in cf is what you would get as a result from a cfquery. Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 10:42 > To: CF-Talk > Subject: RE: escaping " character > > I am not too sure what a "proper csv parser" is ? I assumed that the code: > > > > > > variable="csvData"> > > > > was properly parsing csv data ? I am also a bit shady on exactly what is a > text qualifier. I will look into CFHTTP but I don't know what you mean by > reading the csv as a query object ? > > I will Google on ! > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
I am not too sure what a "proper csv parser" is ? I assumed that the code: variable="csvData"> was properly parsing csv data ? I am also a bit shady on exactly what is a text qualifier. I will look into CFHTTP but I don't know what you mean by reading the csv as a query object ? I will Google on ! _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 6:08 PM To: CF-Talk Subject: RE: escaping " character Your problem is with how cf treats lists. The delimiter can't be present in a value, or it will be treated as separate elements. You will need to use a proper csv parser that allows a text qualifier ("). Have you considered CFHTTP to read the csv into a query object? In a recent tread, someone suggested a Java csv parser, but I don't remember which one. Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 05:55 > To: CF-Talk > Subject: RE: escaping " character > > Actually - I have just found the issue. I am using the listfix udf :- > http://www.cflib.org/udf.cfm/listfix > > > > The problem is that, the string I was trying to insert actually has a > single > comma in the csv file:- > > > > BLEOMYCIN (BL) INJ 15,000 i.u. > > > > Is there anyway to exclude listfix from picking this up as a separate > field > ?? > > > > My code is: > > > > > > variable="csvData"> > > > > > > > > > > > > Should I be using the commented code instead > > > > Thanks again > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. It is the responsibility of the recipient to ensure that the > onward transmission, opening or use of this message and any attachments > will not adversely affect its systems or data. Please carry out such virus > and other checks, as you consider appropriate. To the fullest extent > allowed by law, no responsibility is accepted by Haematology & Oncology > Clinics of Australasia for any virus damage caused by this message. > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Your problem is with how cf treats lists. The delimiter can't be present in a value, or it will be treated as separate elements. You will need to use a proper csv parser that allows a text qualifier ("). Have you considered CFHTTP to read the csv into a query object? In a recent tread, someone suggested a Java csv parser, but I don't remember which one. Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 05:55 > To: CF-Talk > Subject: RE: escaping " character > > Actually - I have just found the issue. I am using the listfix udf :- > http://www.cflib.org/udf.cfm/listfix > > > > The problem is that, the string I was trying to insert actually has a > single > comma in the csv file:- > > > > BLEOMYCIN (BL) INJ 15,000 i.u. > > > > Is there anyway to exclude listfix from picking this up as a separate > field > ?? > > > > My code is: > > > > > > variable="csvData"> > > > > > > > > > > > > Should I be using the commented code instead > > > > Thanks again > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. It is the responsibility of the recipient to ensure that the > onward transmission, opening or use of this message and any attachments > will not adversely affect its systems or data. Please carry out such virus > and other checks, as you consider appropriate. To the fullest extent > allowed by law, no responsibility is accepted by Haematology & Oncology > Clinics of Australasia for any virus damage caused by this message. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Actually - I have just found the issue. I am using the listfix udf :- http://www.cflib.org/udf.cfm/listfix The problem is that, the string I was trying to insert actually has a single comma in the csv file:- BLEOMYCIN (BL) INJ 15,000 i.u. Is there anyway to exclude listfix from picking this up as a separate field ?? My code is: variable="csvData"> Should I be using the commented code instead Thanks again The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping apostrphee in a select statement
I use JSStringFormat a lot when playing with JS in my ColdFusion, try that.. On Thu, 19 Aug 2004 09:04:33 -0400, Ewok <[EMAIL PROTECTED]> wrote: > what's a "you clown" ; ) > - Original Message - > From: cf coder > To: CF-Talk > Sent: Thursday, August 19, 2004 8:10 AM > Subject: Re: escaping apostrphee in a select statement > > you what? what's your problem? are you a you clown or something? > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping apostrphee in a select statement
what's a "you clown" ; ) - Original Message - From: cf coder To: CF-Talk Sent: Thursday, August 19, 2004 8:10 AM Subject: Re: escaping apostrphee in a select statement you what? what's your problem? are you a you clown or something? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping apostrphee in a select statement
>>VALUE="#URLDecode(url.text)#" You don't have to URLDecode a string passed by URL, it is supposed to be decoded by the HTTP server when it receives the request. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping apostrphee in a select statement
ok, I'm passing the url variable to the stored procedure page two --- VALUE="#URLDecode(url.text)#" DBVARNAME="@db_txt" CFSQLTYPE="cf_sql_char"> This is when the error occurrs. When I execute the query in query analyser this is what the text looks like @db_txt = 'it''s a test' [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping apostrphee in a select statement
Try: mytext = "It's a test" window.location.href = ""> If you need to escape a ' inside of a string surrounded by ' marks, use \ (standard for ECMA escaping), i.e., 'This is Joe\'s example' -joe - Original Message - From: cf coder <[EMAIL PROTECTED]> Date: Thu, 19 Aug 2004 07:51:19 -0400 Subject: escaping apostrphee in a select statement To: CF-Talk <[EMAIL PROTECTED]> Hi Guys, I'm passing a url variable a string/text that has a apostrphee in it. Ex: mytext = It's a test I'm escaping it like this: window.location.href = ""> I'm passing this url varialbe, url.txt to the select statement, I get an error: Incorrect syntax near 's'. Can someone show me how to get round this please. Best regards cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping apostrphee in a select statement
>>Incorrect syntax near 's'. This is weird, normally the escape function escapes characters as hexadecimals, not in HTML code. You should have get %27s%27 here. Are you sure your _javascript_ code does not redefine the escape function for something to escape characters as HTML codes? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping apostrphee in a select statement
Your original post wasn't very informative was it? It looks like you have -- page one - var myText = "Show's some example code please"; window.location.href = ''#URL.text#') I'm guessing here... but you then get the error message that you have quoted cos the apostrophe is in the (escaped) _javascript_ url Here's what _javascript_ escape does ... http://www.devguru.com/Technologies/ecmascript/quickref/escape.html And you will probably find URLDecode or something or other a help If you gave us the actual code we could help further. as Micha was trying to. Well I better get back to my own work. -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping apostrphee in a select statement
Can you provide is with example code so we can find out what is happening? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping apostrphee in a select statement
you what? what's your problem? are you a clown or something? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]