Re: QofQ and dates...(FIXED)
Smith, Matthew P -CONT(DYN) wrote: > Does cfqueryparam speed up QofQ as it does with a normal db query? I would > think not, but it would be cool if it did. Just curios if anyone knows... Probably no significant difference. The difference it makes is that one implicit type casting is replaced by one explicit type casting for each variable. To be honest, I can't imagine that CF MX actually caches execution plans. While in a real database (at least the ones I know of) the difference is mainly in the generation of the execution plan, and not the parsing of the statement. But it should be easy to test :) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: QofQ and dates...(FIXED)
Does cfqueryparam speed up QofQ as it does with a normal db query? I would
think not, but it would be cool if it did. Just curios if anyone knows...
Matthew P. Smith
Web Developer, Object Oriented
Naval Education & Training Professional
Development & Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
>>-Original Message-
>>From: John Beynon [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, October 01, 2002 9:57 AM
>>To: CF-Talk
>>Subject: RE: QofQ and dates...(FIXED)
>>
>>Using CFQUERYPARAM fixed the problem,
>>
>>Query becomes:
>>
>>
>> Select * from BlogArticles
>> where (articledate >= >value="#CreateODBCDate(targetdate)#">)
>> order by articledate DESC
>>
>>
>>-Original Message-
>>From: John Beynon [mailto:[EMAIL PROTECTED]]
>>Sent: 01 October 2002 15:29
>>To: CF-Talk
>>Subject: RE: QofQ and dates...
>>
>>
>>Still bitchessame error message - but the SQL at the bottom of the
>>page
>>changes to:
>>SQLSelect * from BlogArticles where articledate >= {d
>>'2002-09-24'} order by articledate DESC
>>
>>What's with the ' stuff?
>>
>>-Original Message-
>>From: Mike Townend [mailto:[EMAIL PROTECTED]]
>>Sent: 01 October 2002 15:25
>>To: CF-Talk
>>Subject: RE: QofQ and dates...
>>
>>
>>Try adding a createodcdate around it...
>>
>>>now())>
>>
>> Select * from BlogArticles
>> where articledate >= #CreateODBCDate(FilterDate)#
>> order by articledate DESC
>>
>>
>>HTH
>>
>>
>>
>>
>>-Original Message-
>>From: John Beynon [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, October 1, 2002 15:19
>>To: CF-Talk
>>Subject: QofQ and dates...
>>
>>
>>should i be able to do date comparisons in a QofQ?
>>
>>i'm using:
>> >now())#>
>>
>>
>>
>> Select * from BlogArticles
>> where articledate >= #FilterDate#
>> order by articledate DESC
>>
>>
>>and getting:
>>Query Of Queries syntax error.
>>Encountered "articledate >= {" at line 3, column 31. Incorrect conditional
>>expression, Expected one of [like|null|between|in|comparison] condition,
>>
>>returned. Also just noticed:
>>
>>
>>SQL Select * from BlogArticles where articledate >= {ts
>>'2002-09-24 15:12:35'} order by articledate DESC
>>Please try the following:
>>
>>tucked away at the bottom of the page
>>
>>thanks for the help,
>>
>>jb.
>>
>>* [EMAIL PROTECTED] * +44 (0)1372 367147 * <http://www.era.co.uk/>
>>http://www.era.co.uk/
>>
>>
>>
>>
>>
>>*
>>Copyright ERA Technology Ltd. 2002. (www.era.co.uk). All rights reserved.
>>The information supplied in this email should be treated in confidence. No
>>liability whatsoever is accepted for any loss or damage
>>suffered as a result of accessing this message or any attachments.
>>
>>
>>
>>
>>
>>
>>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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
RE: QofQ and dates...(FIXED)
I sort of got pushed in the right direction by this post in the forums: "http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7&threadid =364061&highlight_key=y&keyword1=query%20of%20queries" HTH, John. -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 16:13 To: CF-Talk Subject: Re: QofQ and dates...(FIXED) Howdy John, Tuesday, October 1, 2002, 9:56:44 AM, John Beynon wrote: JB> Using CFQUERYPARAM fixed the problem, Good to know you found the solution! Now I can fix mine. :) Thanks! Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 __ 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
Re: QofQ and dates...(FIXED)
Howdy John, Tuesday, October 1, 2002, 9:56:44 AM, John Beynon wrote: JB> Using CFQUERYPARAM fixed the problem, Good to know you found the solution! Now I can fix mine. :) Thanks! Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 __ 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: QofQ and dates...(FIXED)
Using CFQUERYPARAM fixed the problem,
Query becomes:
Select * from BlogArticles
where (articledate >= )
order by articledate DESC
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: 01 October 2002 15:29
To: CF-Talk
Subject: RE: QofQ and dates...
Still bitchessame error message - but the SQL at the bottom of the page
changes to:
SQLSelect * from BlogArticles where articledate >= {d
'2002-09-24'} order by articledate DESC
What's with the ' stuff?
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 01 October 2002 15:25
To: CF-Talk
Subject: RE: QofQ and dates...
Try adding a createodcdate around it...
Select * from BlogArticles
where articledate >= #CreateODBCDate(FilterDate)#
order by articledate DESC
HTH
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 1, 2002 15:19
To: CF-Talk
Subject: QofQ and dates...
should i be able to do date comparisons in a QofQ?
i'm using:
Select * from BlogArticles
where articledate >= #FilterDate#
order by articledate DESC
and getting:
Query Of Queries syntax error.
Encountered "articledate >= {" at line 3, column 31. Incorrect conditional
expression, Expected one of [like|null|between|in|comparison] condition,
returned. Also just noticed:
SQL Select * from BlogArticles where articledate >= {ts
'2002-09-24 15:12:35'} order by articledate DESC
Please try the following:
tucked away at the bottom of the page
thanks for the help,
jb.
* [EMAIL PROTECTED] * +44 (0)1372 367147 *
