Skip to main content
A
Anonymous
March 31, 2011
Question

cfqueryparam

  • March 31, 2011
  • 3 replies
  • 1641 views

Have read cfqueryparam can cause problems when table structure is changed.

Has anybody seen this ?

If so, is there a way to use cfqueryparam but avoid the problem ?

This topic has been closed for replies.

3 replies

D
Dan_Bracuk
Inspiring
March 31, 2011

Is there a problem that you are actually having?  Is there clear evidence that it is being caused by cfqueryparam?

A
Anonymous
March 31, 2011

I'm not having the problem, so can't blame cfqueryparam.

No cfqueryparams except in testing so far. Hoping to use them soon.

ecobb
ecobb
Inspiring
March 31, 2011

The only thing I can think of that would possibly break something is if you changed a column's datatype.  For example, if you had a varchar column that you decided to make numeric, in which case that would break a query without cfqueryparam as well. 


Thanks,

Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
http://www.cfgears.com
Owainnorth
Owainnorth
Inspiring
March 31, 2011

I have never once had an issue with cfqueryparams at all, certainly not on change of a table structure - as all they do is create bind variables I can't imagine they have anything to do with the column order. Queryparams are used for sending data *to* the database server, CF wouldn't even know the structure had changed until the data comes back.

Are you actually having an issue?

A
Anonymous
March 31, 2011

I'm not having the issue but have read about it.

A
Adam Cameron.
Inspiring
March 31, 2011

I'm not having the issue but have read about it.

Can you post a citation of this?

--

Adam

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices