Re: Escaping regexp control characters

2013-02-07 Thread Claude Schnéegans
>>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

Re: Escaping regexp control characters

2013-02-07 Thread Raymond Camden
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

RE: Escaping #

2012-02-01 Thread Eric Roberts
ginal 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 fo

Re: Escaping #

2012-02-01 Thread Dave Watts
> 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, variab

Re: Escaping #

2012-02-01 Thread Dominic Watson
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 scop

Re: Escaping #

2012-02-01 Thread Rob Voyle
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 wro

Re: Escaping #

2012-02-01 Thread Dave Watts
> 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.

Re: Escaping #

2012-02-01 Thread Rob Voyle
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 > > >

Re: Escaping #

2012-02-01 Thread Dave Watts
> 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

Re: Escaping #

2012-02-01 Thread Rob Voyle
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

RE: Escaping #

2012-02-01 Thread DURETTE, STEVEN J
: 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

Re: Escaping #

2012-02-01 Thread Dave Watts
> 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 S

RE: Escaping #

2012-02-01 Thread DURETTE, STEVEN J
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

Re: Escaping #

2012-02-01 Thread Dave Watts
> 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"

Re: Escaping #

2012-02-01 Thread Rob Voyle
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

Re: Escaping #

2012-01-23 Thread Matt Quackenbush
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

Re: Escaping #

2012-01-23 Thread John M Bliss
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 >

Re: Escaping #

2012-01-23 Thread Rob Voyle
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 S

Re: Escaping #

2012-01-22 Thread Claude Schnéegans
>>/* 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:

Re: Escaping #

2012-01-22 Thread Captain Obvious
/* 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:

Re: Escaping #

2012-01-22 Thread Rob Voyle
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.filt

Re: Escaping #

2012-01-21 Thread Claude Schnéegans
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.

Re: escaping # in a password...

2008-04-08 Thread Paul Ihrig
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.. ~~

RE: escaping # in a password...

2008-04-08 Thread Dave Watts
> 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

Re: escaping # in a password...

2008-04-08 Thread Paul Ihrig
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 delimina

Re: escaping # in a password...

2008-04-08 Thread Charlie Griefer
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" > firstrowasheader

RE: escaping # in a password...

2008-04-08 Thread Che Vilnonis
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="

RE: escaping # in a password...

2008-04-08 Thread Brad Wood
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" user

Re: escaping # in a password...

2008-04-08 Thread Azadi Saryev
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" resolveur

Re: escaping # signs in image file names

2007-11-30 Thread Jerry Johnson
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 anyon

Re: escaping # signs in image file names

2007-11-30 Thread Crow T. Robot
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 # ther

Re: escaping # signs in image file names

2007-11-30 Thread Charlie Griefer
? (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

RE: escaping # signs in image file names

2007-11-30 Thread Dave Watts
> 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 renamin

Re: Escaping ampersands

2007-03-11 Thread Mary Jo Sminkey
> 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

Re: Escaping ampersands

2007-03-11 Thread Peter Boughton
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

Re: Escaping ampersands

2007-03-11 Thread Mary Jo Sminkey
> 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)

Re: Escaping ampersands

2007-03-11 Thread Peter Boughton
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")

Re: Escaping ampersands

2007-03-11 Thread Peter Boughton
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

Re: escaping Semi Colons

2006-12-27 Thread Bruce Sorge
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 <

Re: escaping Semi Colons

2006-12-27 Thread Ken Wexel
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

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jim Wright
>> > 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

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Doug Brown
y, 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.

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jim Wright
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-hitti

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Doug Brown
D]> 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) allow

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jamie Jackson
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 workar

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jamie Jackson
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

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jim Wright
> > 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 Fus

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jamie Jackson
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

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jamie Jackson
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

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Claude Schneegans
>>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. ~~~

Re: Escaping parentheses in table names (querying MS Access DB)

2006-09-26 Thread Jim Wright
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

RE: Escaping a : character

2006-08-24 Thread Sean Coyne
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 e

Re: Escaping a : character

2006-08-24 Thread Jake Churchill
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

RE: Escaping #'s in outputting a CSS

2006-04-19 Thread Sandra Clark
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

RE: Escaping #'s in outputting a CSS

2006-04-19 Thread Ben Nadel
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 i

Re: Escaping #'s in outputting a CSS

2006-04-19 Thread Rob Wilkerson
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]>

Re: escaping reserved words in flash forms

2005-04-25 Thread Sebastian Mork
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,

Re: escaping reserved words in flash forms

2005-04-25 Thread Sebastian Mork
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 a

RE: escaping reserved words in flash forms

2005-04-25 Thread Dave Watts
> 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-auth

Re: Escaping ##

2005-04-07 Thread Larry White
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 acco

RE: Escaping #

2005-04-07 Thread Jeff Waris
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 er

Re: Escaping for javascript

2005-02-09 Thread S . Isaac Dealey
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 w

Re: Escaping for javascript

2005-02-09 Thread Charlie Griefer
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

Re: Escaping for javascript

2005-02-09 Thread S . Isaac Dealey
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(jsstringfo

Re: Escaping for javascript

2005-02-09 Thread Charlie Griefer
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- >

RE: Escaping for javascript

2005-02-09 Thread Bryan F. Hogan
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 repla

RE: escaping " character

2004-09-08 Thread Dave Watts
> 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 you

RE: escaping " character

2004-09-07 Thread Matthew Walker
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

RE: escaping " character

2004-09-07 Thread Brant Winter
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

RE: escaping " character

2004-09-07 Thread Brant Winter
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.SDIS

RE: escaping " character

2004-09-07 Thread Matthew Walker
-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

RE: escaping " character

2004-09-07 Thread Brant Winter
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 mi

Re: escaping " character

2004-09-06 Thread Cutter (CF related)
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...

Re: escaping " character

2004-09-06 Thread Mark Drew
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 de

Re: escaping " character

2004-09-06 Thread Jochem van Dieten
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

RE: escaping " character

2004-09-06 Thread Pascal Peters
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

RE: escaping " character

2004-09-06 Thread Brant Winter
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 transmi

Re: escaping " character

2004-09-06 Thread Stephen Moretti (cfmaster)
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'

RE: escaping " character

2004-09-06 Thread Brant Winter
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 Dat

RE: escaping " character

2004-09-06 Thread Pascal Peters
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 >

RE: escaping " character

2004-09-06 Thread Brant Winter
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

Re: escaping " character

2004-09-06 Thread Michael Traher
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 b

RE: escaping " character

2004-09-06 Thread Pascal Peters
g 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 &g

RE: escaping " character

2004-09-06 Thread Brant Winter
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 o

Re: escaping " character

2004-09-06 Thread Stephen Moretti (cfmaster)
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

RE: escaping " character

2004-09-06 Thread Brant Winter
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 enti

Re: escaping " character

2004-09-06 Thread Michael Traher
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 &

RE: escaping " character

2004-09-06 Thread Pascal Peters
",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 &g

RE: escaping " character

2004-09-06 Thread Brant Winter
uery 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 s

RE: escaping " character

2004-09-06 Thread Pascal Peters
d, 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 fo

RE: escaping " character

2004-09-05 Thread Brant Winter
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 a

Re: escaping apostrphee in a select statement

2004-08-19 Thread Greg Morphis
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, Au

Re: escaping apostrphee in a select statement

2004-08-19 Thread Ewok
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 Thre

Re: escaping apostrphee in a select statement

2004-08-19 Thread Claude Schneegans
>>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 (P

Re: escaping apostrphee in a select statement

2004-08-19 Thread cf coder
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

Re: escaping apostrphee in a select statement

2004-08-19 Thread Joe Rinehart
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 -04

Re: escaping apostrphee in a select statement

2004-08-19 Thread Claude Schneegans
>>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? -- _

RE: escaping apostrphee in a select statement

2004-08-19 Thread d.a.collie
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

RE: escaping apostrphee in a select statement

2004-08-19 Thread Micha Schopman
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] [F

Re: escaping apostrphee in a select statement

2004-08-19 Thread cf coder
you what? what's your problem? are you a clown or something? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

  1   2   >