Keith Levenson wrote:
>
> 68: <cfquery name="getData" dbtype="query">
> 69: SELECT * from myQuery
> 70: WHERE myStart BETWEEN
> 71: (<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP"
> value="#DateAdd('D',iCount-1,startDate)#"> and
> 72: <cfqueryparam cfsqltype="CF_SQL_TIMESTAMP"
> value="#DateAdd('D',iCount,startDate)#">)
> 73: AND myStart >=
> #createDateTime(Year(getEarlierData.skedDate),Month(getEarlierData.skedDate)
> ,Day (getEarlierData.WScdDate),0,0,1)#
> 74: </cfquery>
>
> ***Here's the error I get:
>
> Query Of Queries syntax error.
> Encountered "myStart >= {" at line 0, column 0. Incorrect conditional
> expression, Expected one of [like|null|between|in|comparison] condition,
Remove the extra brackets around the BETWEEN condition.
However, since you are doing 2 date conditions on myStart, the
query could be reduced to:
<cfquery name="getData" dbtype="query">
SELECT *
FROM myQuery
WHERE myStart >=
<cfqueryparam
cfsqltype="CF_SQL_TIMESTAMP"
value="#Max(DateAdd('D',iCount-1,startDate),
createDateTime(Year(getEarlierData.skedDate),Month(getEarlierData.skedDate)
,Day(getEarlierData.WScdDate),0,0,1))#">
AND
myStart <=
<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP"
value="#DateAdd('D',iCount,startDate)#">
</cfquery>
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
