reFindNoCase() only returns the first match; it does not return an
array of all matches.
When you pass the returnsubexpressions=true argument, it does what it
says on the box: it returns an array of any subexpressions *of the
regex*.
http://livedocs.adobe.com/coldfusion/7/htmldocs/0607.htm
I think its to do with the binding or the caching of the query plan
but when we change a table in the DB, like remove a column or change
the length of a varchar, all the queries that use that table and have
a queryparam break.
We get messages like
[Macromedia][SQLServer JDBC Driver]Value can
Duncan,
The query is only cached when you tell it to be cached. But are you using
any other framework like reactor or transfer or even MG:U, or even have this
in a cfc that might be stored in a session or application scope.
One other thing I would like to point out that a lot of people do not
Andrew,
I disagree.
Although cfqueryparam performs vailidation, it is not the reason you should be
using it.
cfqueryparam makes the database engine use parameter binding on your queries.
For example your query below would look different to the db engine every time
it is run
eg:
Select *
Andrew,
No that's not correct, it's not part of the message it's just the email
address to the group after a couple replies. And google groups does not show
this on their web version. As it's a simple email address, steve could
simply apply a regex before the cfoutput of the content to ensure
Thanks for bringing it up anyway
All email addresses have been removed from the output now and have been
replaced with [EMAIL PROTECTED]
Steve
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Friday, 2 March 2007 1:35 PM
To:
Scott,
Well although I know what you said, I see no reason to add overhead to my
application to provide a stop measure for SQL injection when I have already
taken care of it before my code ever reaches there in a cffunction. As far
as making sure it is an integer instead of numeric, I couldn't
Thanks Steve.
Regards
Dale Fraser
http://dale.fraser.id.au/blog/
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Friday, 2 March 2007 1:47 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFCENTRAL Still Show my Email
Dale,
Actually you are wrong it is part of the message, the person who was
replying to your message has that setup in their email client to add it to
reply. I know I switched that off on outlook as it used to be on by default
when replying to an email.
Dale here is an example of
I should add to this that the queries are not using any caching, they
are not in a cfc, and are not loaded into any scopes like the
application. Simple, inline, straightforward queries.
On 3/2/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott - thats precisely why we use cfqueryparam - and
Yes, as Scott later said, Andrew, you don't want to confuse caching of the
query with what Duncan said, which was caching of the query plan.
And as Scott clarified, you definitely don't want to spread the
misconception that cfqueryparam is just for security. The value in query
plan caching can
Goodness, too many caches! Now you're talking about cached templates,
Duncan. It sure seems to me that Andrew was referring to query caching,
since he said, The query is only cached when you tell it to be cached and
later mentioned storing data in shared scopes. And then of course Scott was
The suggestions I had mentioned, I didnt think of Trusted Cache but I never
have that ticked for development but that might cause it and the other is
Save Class Files but you will also need to delete the class files that are
generated there as well.
The other option is Maximum number of cache
Did you delete any cached templates in the CFIDE folder?
On 02/03/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott - thats precisely why we use cfqueryparam - and the performance
increase is marked, especially on inserts. There is a performance hit
on the first time the query is put
Must admit I like googles approach to emails that are inside email messages.
But Steve I would not expect you to go to those lengths.
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
Charlie,
I didnt think that would be affecting it, I am more than aware that
its bad practice, and as it happens the queries in question do have *,
column1, column2 etc in them.
I know that you are pulling more data than necessary with a *
therefore slowing down processing with data processing
Hi,
I have been using
FindNoCase(x,'OPPO,OPSNC,OPVAN,OPGEN,INP') gt 0 for a while but only noticed
today that if the value of x is OPVA it would match on the value OPVAN. Not
what I was expecting.
I have changed the statement to use multiple comparison eg x=oppo or x=opsnc
and so on, but
Scott,
Well that is a doosy, but maybe you should be looking at contains and not
FindNoCase. Because x = opva will always return true as will x=op
I suggest using cfif StringToCompareAgainst contains
'OPPO,OPSNC,OPVAN,OPGEN,INP'
Of you could do something like this
cfswitch expression=#x#
oops.
I have used both in the application.
ta.
Adam Chapman [EMAIL PROTECTED] 02/03/2007 3:03 pm
ListFindNoCase('OPPO,OPSNC,OPVAN,OPGEN,INP', x) gt 0
Cheers,
Adam
-Original Message-
From: Scott Thornton [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 March 2007 2:48 PM
To:
ListFindNoCase('OPPO,OPSNC,OPVAN,OPGEN,INP', x) gt 0
Cheers,
Adam
-Original Message-
From: Scott Thornton [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 March 2007 2:48 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] FineNoCase Problem
Hi,
I have been using
Thanks Steve - works like a charm.
On 3/1/07, Steve Onnis [EMAIL PROTECTED] wrote:
Here you go Duncan
cfsavecontent variable=str
digging around in sitebr#11245 - ant build scripts
cfeclipse w/garrybrticketing tixbradd job drop box to ticketing #11249
working according to #12345, #99587,
thanks.
Andrew Scott [EMAIL PROTECTED] 02/03/2007 3:01 pm
Scott,
Well that is a doosy, but maybe you should be looking at contains and not
FindNoCase. Because x = opva will always return true as will x=op
I suggest using cfif StringToCompareAgainst contains
'OPPO,OPSNC,OPVAN,OPGEN,INP'
Of
thanks.
Andrew Scott [EMAIL PROTECTED] 02/03/2007 3:01 pm
Scott,
Well that is a doosy, but maybe you should be looking at contains and not
FindNoCase. Because x = opva will always return true as will x=op
I suggest using cfif StringToCompareAgainst contains
'OPPO,OPSNC,OPVAN,OPGEN,INP'
Of
What's your budget, I have a site hosted with http://www.hostingatoz.com/
technically not Australian as the servers are hosted offshore but have found
them to be not too bad and reasonably cheap for what they offer.
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Check out http://www.fasthit.com.au/
They have been good for me.
On 3/2/07, Allan Browning [EMAIL PROTECTED] wrote:
HI,
Are there any recomendations for coldfusion (MX 7) hosting in
Australia.
--
If you are not living on the edge,
You are taking up too much space.
Alan
We can do your CF7 hosting for around $35 a month including a MSSQL
database. Servers are local (Melbourne)
Need to know any more just let me know ([EMAIL PROTECTED]) or have a
look at www.inevative.com.au
Steve
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL
Mike Kear (www.apwebworks.com) offers great deals too. Servers are
based in Washington so if most of your traffic is from US then even
better.
On 02/03/07, Steve Onnis [EMAIL PROTECTED] wrote:
Alan
We can do your CF7 hosting for around $35 a month including a MSSQL
database. Servers are
Try AFPWebworks.com. I hear the person running the show is a great guy.
We are directed at ColdFusion developers. The only things you pay for are
disk space and bandwidth - anything else comes in teh deal. you can have as
many email accounts, domains, sub domains, domain aliases etc as you
oops
On 02/03/07, Mike Kear [EMAIL PROTECTED] wrote:
Try AFPWebworks.com. I hear the person running the show is a great guy.
We are directed at ColdFusion developers. The only things you pay for are
disk space and bandwidth - anything else comes in teh deal. you can have as
many email
Steve,
I personally think it's not worth your efforts given it's already available
online through the new Google Groups interface which is quite nice.
I guess you will know what kind of traffic it gets and if it's worth
maintaining. I can understand it's benefits back in the daemon days.
30 matches
Mail list logo
