re: cfqueryparam question
Thanks John! Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam question
DatePart will return an integer so CF_SQL_INTEGER On Mon, Aug 9, 2010 at 10:46 AM, Eric Roberts < ow...@threeravensconsulting.com> wrote: > > We are putting a cfqueryparam aound all of our sql vars...I am not sure how > to handle this one: > > Here's the line: > > * > > AND* DatePart(m,inv_date)= cfsqltype= > "CF_SQL_date" null="false" list="false"> > > > > Should that be date or varchar since it is looking at the part of the date > (which I am assuming returns a char or varchar value). The actual column > in > the DB, inv_date is of type datetime. > > > > Thanks! > > Eric > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfqueryparam question
We are putting a cfqueryparam aound all of our sql vars...I am not sure how to handle this one: Here's the line: * AND* DatePart(m,inv_date)= Should that be date or varchar since it is looking at the part of the date (which I am assuming returns a char or varchar value). The actual column in the DB, inv_date is of type datetime. Thanks! Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQueryParam question
> The list="yes" parameter of CFQUERYPARAM will properly wrap the single quotes
> around each list element.
That's not quite right. What it will do is create a parameter for
every element in the list and map it to the database type you supply.
Even with character data, no single quotes are used when using
cfqueryparam. Indeed, it may be important to know that you are sending
a different kind of request to the db when you use cfqueryparam. Ie.
SELECT foo
FROM bar
WHERE foo IN ()
gets translated by ColdFusion, which then sends something like the
following to the database server:
SQL Statement: SELECT foo FROM bar WHERE foo IN (?,?,?)
SQL Parameters:
* param 1 (varchar) = 'Hello mum'
* param 2 (varchar) = 'Hello world'
* param 3 (varchar) = 'I love chocolate'
Without using cfqueryparam, you would send the following to the db:
SQL Statement: SELECT foo FROM bar WHERE foo IN ('Hello mum','Hello
world','I love chocolate').
Further, better and useful quick reading:
http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html
HTH
Dominic
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQueryParam question
Try this: Thanks, Eric Cobb Scott Stewart wrote: > I have a variable passed though a URL that looks like this > > index.cfm?a=1,2,3 > > The variable "a" is passed to a SQL statement WHERE clause as > part of an "IN" operator > > IE: WHERE b in (#url.a#). > > How would I encapsulate "url.a" in a CFQueryParam properly, is this a > case where I wouldn't define the cfsqltype? > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFQueryParam question
cfqp has a list attribute. Adrian Building a database of ColdFusion errors at http://cferror.org/ -Original Message- From: Scott Stewart Sent: 28 October 2008 17:13 To: cf-talk Subject: CFQueryParam question I have a variable passed though a URL that looks like this index.cfm?a=1,2,3 The variable "a" is passed to a SQL statement WHERE clause as part of an "IN" operator IE: WHERE b in (#url.a#). How would I encapsulate "url.a" in a CFQueryParam properly, is this a case where I wouldn't define the cfsqltype? -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQueryParam question
WHERE b IN ( ) The list="yes" parameter of CFQUERYPARAM will properly wrap the single quotes around each list element. -Jason >I have a variable passed though a URL that looks like this > >index.cfm?a=1,2,3 > >The variable "a" is passed to a SQL statement WHERE clause as >part of an "IN" operator > >IE: WHERE b in (#url.a#). > >How would I encapsulate "url.a" in a CFQueryParam properly, is this a >case where I wouldn't define the cfsqltype? > >-- >Scott Stewart >ColdFusion Developer > >Office of Research Information Systems >Research & Economic Development >University of North Carolina at Chapel Hill > >Phone:(919)843-2408 >Fax: (919)962-3600 >Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQueryParam question
Obviously you would need to change the sqltype to what your sql type is. On Tue, Oct 28, 2008 at 10:13 AM, Scott Stewart <[EMAIL PROTECTED]>wrote: > I have a variable passed though a URL that looks like this > > index.cfm?a=1,2,3 > > The variable "a" is passed to a SQL statement WHERE clause as > part of an "IN" operator > > IE: WHERE b in (#url.a#). > > How would I encapsulate "url.a" in a CFQueryParam properly, is this a > case where I wouldn't define the cfsqltype? > > -- > Scott Stewart > ColdFusion Developer > > Office of Research Information Systems > Research & Economic Development > University of North Carolina at Chapel Hill > > Phone:(919)843-2408 > Fax: (919)962-3600 > Email: [EMAIL PROTECTED] > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFQueryParam question
I have a variable passed though a URL that looks like this index.cfm?a=1,2,3 The variable "a" is passed to a SQL statement WHERE clause as part of an "IN" operator IE: WHERE b in (#url.a#). How would I encapsulate "url.a" in a CFQueryParam properly, is this a case where I wouldn't define the cfsqltype? -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQUERYPARAM Question
Sorry forgot to mention. we are only storing text, HTML and wddx information in these fields. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFQUERYPARAM Question
I have to modify my MSSQL database and change some of my fields from varchars to text fields. The question I have is that i have a bunch of querys that we are using the function and we are binding with the cfsqltype="varchar". Do I need to go through the entire site and change this to CF_SQL_LONGVARCHAR or will this work fine. I ran some initial test and it looks good, but I am wondering if I am opening a can of worms. we are on CF 7. Thanks. Matt Friedman ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam question
I believe with Oracle in later than CF5 you could insert/update more than 4000 characters into a clob when using CF_SQL_CLOB. Not sure for CF5 though, for some reason I recall it failing beyond 4000 and requiring work arounds. On Tue, 22 Mar 2005 10:44:53 -0700, Scott Brady <[EMAIL PROTECTED]> wrote: > On Sun, 13 Mar 2005 11:06:58 -0500, S. Isaac Dealey wrote: > > specifically I believe cfsqltype="cf_sql_longvarchar" > > CF_SQL_CLOB is an undocumented type that is, I believe, more > specifically designed for the "text" field, though longvarchar also > works. I'm not sure if there's a significant difference between the > two. > > Scott > -- > - > Scott Brady > http://www.scottbrady.net/ > > ~| 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:199677 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: cfqueryparam question
On Sun, 13 Mar 2005 11:06:58 -0500, S. Isaac Dealey wrote: > specifically I believe cfsqltype="cf_sql_longvarchar" CF_SQL_CLOB is an undocumented type that is, I believe, more specifically designed for the "text" field, though longvarchar also works. I'm not sure if there's a significant difference between the two. Scott -- - Scott Brady http://www.scottbrady.net/ ~| 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:199675 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: cfqueryparam question
specifically I believe cfsqltype="cf_sql_longvarchar" > Long varchar > Ade > -Original Message- > From: Dave Francis [mailto:[EMAIL PROTECTED] > Sent: 13 March 2005 12:50 > To: CF-Talk > Subject: cfqueryparam question > Brain-dead. What's the cfqueryparam cfsqltype for a > text column? - SQL > Server 2k. CF5.0 s. isaac dealey 954.522.6080 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/author/?id=4806 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:198593 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: cfqueryparam question
Long varchar Ade -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 13 March 2005 12:50 To: CF-Talk Subject: cfqueryparam question Brain-dead. What's the cfqueryparam cfsqltype for a text column? - SQL Server 2k. CF5.0 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 ~| 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:198586 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
cfqueryparam question
Brain-dead. What's the cfqueryparam cfsqltype for a text column? - SQL Server 2k. CF5.0 ~| 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:198585 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: CFQUERYPARAM question
>>Yes, that is correct. Ok, I understand, the null must be specify by program, because CFQUERYPARAM has no way to distinguish an empty string from a true null. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:193517 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: CFQUERYPARAM question
> Do you mean that if NULL="yes" null will be passed to the > database, even if the VALUE attributes contains a valid value? Yes, that is correct. 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! ~| 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:193508 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: CFQUERYPARAM question
>>That'll pass the number in the database, unless the value isn't >>numeric, in which case it will pass NULL. Do you mean that if NULL="yes" null will be passed to the database, even if the VALUE attributes contains a valid value ? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:193505 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: CFQUERYPARAM question
> I'm not too sure I accurately understand the role of > attribute null in the CFQUERYPARAM tag. > Does it mean that if it is YES, when the VALUE attribute is > empty, the query will use NULL instead of the empty string? Yes. You can use inline conditional logic to determine whether to specify a value of "yes" or "no" for it at runtime. 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:193494 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: CFQUERYPARAM question
If the NULL atributes is set to true, then NULL will be passed to the database. If the NULL attributes is set to false (or omitted), then the value of the VALUE attribute will be passed to the database. Here's a 'typical' usage: That'll pass the number in the database, unless the value isn't numeric, in which case it will pass NULL. cheers, barneyb On Mon, 07 Feb 2005 18:53:53 -0500, Claude Schneegans <[EMAIL PROTECTED]> wrote: > Hi, > > I'm not too sure I accurately understand the role of attribute null in > the CFQUERYPARAM tag. > Does it mean that if it is YES, when the VALUE attribute is empty, the > query will use NULL instead of the empty string? > > For instance, these two quries are about the same? > INSERT INTO Clients (ClientName) > VALUES ( > > null) > or... > INSERT INTO Clients (ClientName) > VALUES ( VALUE="#ClientName#">) > > -- -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:193493 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
CFQUERYPARAM question
Hi, I'm not too sure I accurately understand the role of attribute null in the CFQUERYPARAM tag. Does it mean that if it is YES, when the VALUE attribute is empty, the query will use NULL instead of the empty string? For instance, these two quries are about the same? INSERT INTO Clients (ClientName) VALUES ( null) or... INSERT INTO Clients (ClientName) VALUES () -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:193492 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: cfqueryparam question (errors)
I'd swear I just answered this question. Invalid Parameter Binding probably means the CFSQLTYPE is not right. Try using a different CFSQLTYPE. Like INTEGER. Better yet, store zip code as a string, because if you store it as a number, you'll have to format it on the output if the zipcode is 00150. It'll get stored and returned as "150". Also, the query doesn't need the ' characters. - Rick Jeff Fongemie wrote: > Sadly, I'm just learning to use cfqueryparam in my querys. However, I get an error > every time! > > "[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). " > > For the life of me I can't understand why I get this. Query works great without. > > ColdFusion MX. > > > SELECT* > FROM mytable > WHERE '(zip < > value="#variables.LatN#"> ) ' > > > Anyone see a problem?? > > Jeff > > ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182755 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: cfqueryparam question (errors)
SELECT * FROM mytable WHERE zip < Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182745 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: cfqueryparam question (errors)
why the parenthesis? That might be it Ray At 02:37 PM 10/27/2004, you wrote: >Sadly, I'm just learning to use cfqueryparam in my querys. However, I get >an error every time! > >"[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). " > >For the life of me I can't understand why I get this. Query works great >without. > >ColdFusion MX. > > >SELECT * >FROM mytable >WHERE '(zip < >value="#variables.LatN#"> ) ' > > >Anyone see a problem?? > >Jeff > > ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182743 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: cfqueryparam question (errors)
Why do you have a single quote after the WHERE statement? WHERE '(zip < -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:37 PM To: CF-Talk Subject: cfqueryparam question (errors) Sadly, I'm just learning to use cfqueryparam in my querys. However, I get an error every time! "[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). " For the life of me I can't understand why I get this. Query works great without. ColdFusion MX. SELECT * FROM mytable WHERE '(zip < ) ' Anyone see a problem?? Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182742 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
cfqueryparam question (errors)
Sadly, I'm just learning to use cfqueryparam in my querys. However, I get an error every time! "[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). " For the life of me I can't understand why I get this. Query works great without. ColdFusion MX. SELECT * FROM mytable WHERE '(zip < ) ' Anyone see a problem?? Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182740 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: Quick CFQueryParam Question
No -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 12:55 PM To: CF-Talk Subject: Quick CFQueryParam Question Howdy, When using the CFQueryParam tag to insert string form values (cfsqltype="CF_SQL_VARCHAR"), does this automatically "Trim" the value? Thanks. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Quick CFQueryParam Question
Howdy, When using the CFQueryParam tag to insert string form values (cfsqltype="CF_SQL_VARCHAR"), does this automatically "Trim" the value? Thanks. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: cfqueryparam question
David Collie (itndac) wrote: > > > SELECT AS >QUESTION > FROM > WHERE= > > > > > Not actually looked at if there has been any major performance increase cause of >this but can anybody explain why it doesn't accpet it in the FROM clause, but it does >in the SELECT or WHERE? Typecasting. A table does not have the type VARCHAR. You might get lucky with some other type (IDENTIFIER? NAME? TABLE?), but I don't think this behaviour is fully standardized. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfqueryparam question
It's a database limitation. You can't bind variables for table names, just column values. > > SELECT >AS QUESTION > FROM > WHERE= > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam question
Ooops... doesn't work at all actually, the last statement doesn't return any errors but doesn't return the required rows anyway... -Original Message- From: David Collie (itndac) Sent: 21 February 2003 15:09 To: CF-Talk Subject: cfqueryparam question Was mucking about trying to optomise a reports template and noticed I had the following code (obvious dynamic variables)... SELECT #sColName# AS QUESTION FROM#sTableName# WHERE #sPKCol# = Lead webdev suggested trying cfqueryparam's like so SELECT AS QUESTION FROM WHERE= The above gave an error of Database table not found (dynamic table name given is correct though) When I take the cfqueryparam out ot the TABLE bit so it looks like this... it works!!! SELECT AS QUESTION FROM WHERE= Not actually looked at if there has been any major performance increase cause of this but can anybody explain why it doesn't accpet it in the FROM clause, but it does in the SELECT or WHERE? cheers, DC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfqueryparam question
Was mucking about trying to optomise a reports template and noticed I had the following code (obvious dynamic variables)... SELECT #sColName# AS QUESTION FROM#sTableName# WHERE #sPKCol# = Lead webdev suggested trying cfqueryparam's like so SELECT AS QUESTION FROM WHERE= The above gave an error of Database table not found (dynamic table name given is correct though) When I take the cfqueryparam out ot the TABLE bit so it looks like this... it works!!! SELECT AS QUESTION FROM WHERE= Not actually looked at if there has been any major performance increase cause of this but can anybody explain why it doesn't accpet it in the FROM clause, but it does in the SELECT or WHERE? cheers, DC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam question
Has any one had any memory leak problems with cfx_image tag? I haven't been able to pin our server issues on the tag yet with 100% certainty, but it seems as though making about 3-4 consecutive calls to the tag is causing the cfserver to become unresponsive (timeout). Anybody have any similar experiences? Brook __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam question
This AND title LIKE Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jen Perkins [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:08 PM To: CF-Talk Subject: cfqueryparam question When you are doing a sql query with a LIKE statement: .AND title LIKE '%#TRIM(FORM.criteria)#%' Should you do this: .AND title LIKE OR this? .AND title LIKE '%%' Many thanks in advance. Jen Perkins Macromedia Certified ColdFusion Developer Carol/Trevelyan Strategy Group Phone: 925.432.4574 Fax: 925.427.5572 http://www.ctsg.com/ Kumbaya, Dammit! http://www.kumbayadammit.com/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfqueryparam question
When you are doing a sql query with a LIKE statement: ..AND title LIKE '%#TRIM(FORM.criteria)#%' Should you do this: ..AND title LIKE OR this? ..AND title LIKE '%%' Many thanks in advance. Jen Perkins Macromedia Certified ColdFusion Developer Carol/Trevelyan Strategy Group Phone: 925.432.4574 Fax: 925.427.5572 http://www.ctsg.com/ Kumbaya, Dammit! http://www.kumbayadammit.com/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfqueryparam question - [WAS: CLOBS in Oracle]
I thought couldn't/shouldn't be used in INSERT statements? (I don't remember where I heard this. I think from a thread months ago on this list.) Where are people using them in their code? I use them in every SELECT statement I make, but not in INSERT, UPDATE, and DELETE. Any thoughts? > -Original Message- > From: Peter Stolz [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 8:25 AM > To: CF-Talk > Subject: RE: CLOBS in Oracle > > > Yes it does. > It worked for me on CF 4.5 Solaris and CF 4.52 Win2k using native > drivers > and with the 'Enable retrieval of long text' checked in the CF admin. > > Selects work by default, here's the syntax for inserts and updates. > > > INSERT INTO CLOB_TABLE( > ID, > CLOB_TEXT > ) > VALUES( > > > ) > > > > > UPDATE CLOB_TABLE > SETCLOB_TEXT = CFSQLTYPE="CF_SQL_CLOB"> > WHERE ID = CFSQLTYPE="CF_SQL_INTEGER> > > > > HTH > > P. > > -Original Message- > From: "Smit [mailto:"Smit] > Sent: Wednesday, July 18, 2001 2:25 AM > To: CF-Talk > Subject: CLOBS in Oracle > > > Hi, > > Can you please inform me if ColdFusion supports the CLOB datatype in > Oracle. > If yes, what is the proper code for querying CLOB data. > Also, where can I find a resource on writing queries in ColdFusion > for an > Oracle DB. > > Thanks > > Francois > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
