Re: cfinsert and cfqueryparam

2006-12-08 Thread Jochem van Dieten
** Private ** wrote: > > Does using cfinsert remove the need for cfqueryparam, or is it unsafe, and I > should switch code to a cfquery using queryparams? In recent versions it does. Don't know about older versions (hook up a query monitor if you need to

Re: cfinsert and cfqueryparam

2006-12-08 Thread Zaphod Beeblebrox
it > seems like he answers just about every other question that pops up. > > > -Original Message- > > From: G Money [mailto:[EMAIL PROTECTED] > > Sent: Friday, December 08, 2006 10:38 AM > > To: CF-Community > > Subject: Re: cfinsert and cfqueryparam > &

RE: cfinsert and cfqueryparam

2006-12-08 Thread Ray Champagne
TECTED] > Sent: Friday, December 08, 2006 10:38 AM > To: CF-Community > Subject: Re: cfinsert and cfqueryparam > Importance: High > > That's a name I hadn't heard in awhile (haven't been on CF-Talk for some > time now). > > When i was active on cf-talk, I fi

Re: cfinsert and cfqueryparam

2006-12-08 Thread G Money
06, Ray Champagne <[EMAIL PROTECTED]> wrote: > > I think Dave Watts said the other day in cf-talk that it eliminates the > need > for cfqueryparam. > > Might wanna ask over there, though. I know this just came up a few days > ago. > > > -Original Message---

RE: cfinsert and cfqueryparam

2006-12-08 Thread Ray Champagne
I think Dave Watts said the other day in cf-talk that it eliminates the need for cfqueryparam. Might wanna ask over there, though. I know this just came up a few days ago. > -Original Message- > From: Jerry Johnson [mailto:[EMAIL PROTECTED] > Sent: Friday, December 08, 2006

cfinsert and cfqueryparam

2006-12-08 Thread Jerry Johnson
I have some legacy code using a cfinsert. Does using cfinsert remove the need for cfqueryparam, or is it unsafe, and I should switch code to a cfquery using queryparams? Jerry ~| Create robust enterprise, web RIAs. Upgrade

Re: cfqueryparam

2006-01-19 Thread Jochem van Dieten
Jillian Koskie wrote: > As a test I ran a few of my more sustantial SQL commands with and > without cfqueryparam and it was faster without. How many repetitions? How does the parsing, planning and execution time break down?

Re: cfqueryparam

2006-01-18 Thread Michael Dinowitz
Counts on the code. Passing a list in should be slower. A date should be faster. > As a test I ran a few of my more sustantial SQL commands with and without > cfqueryparam and it was faster without. > > I thought it was supposed to be fa

RE: cfqueryparam

2006-01-18 Thread Ian Skinner
Usually, but not always. Most of us use it for It's security and defense against sql injection attack. The speed improvement is sometimes a small bonus. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA ┌─┬─┐ │1│ │ ├─┼─┤ │ │

cfqueryparam

2006-01-18 Thread Jillian Koskie
As a test I ran a few of my more sustantial SQL commands with and without cfqueryparam and it was faster without. I thought it was supposed to be faster WITH it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5

cfqueryparam - useful info

2004-01-07 Thread S . Isaac Dealey
Hi all, I just wanted to let everyone know that I posted some information about cfqueryparam that some of you may find useful on my blog today. http://www.turnkey.to/ontap/blog/?20040107 Thanks, s. isaac dealey    214-823-9345 team macromedia volunteer  http

Oracel cfqueryparam binding on linux glitch? Xpost to cfdjlist

2002-12-05 Thread Andre Turrettini
I got zero response on cfdj so I figured I'd post here. Perhaps someone here can help. I've got a very odd problem. Running mx on linux redhad 7.2 against oracle 8.1.5. Soon to be 8.1.7. Were replacing an application written in omnis which is annoyingly blazingly fast-compiled and talking dire