Tried multiple combinations of createOBDCdate() and CFQUERYPARAM with
CF_SQL_VARCHAR and it still does not work...I am missing something
elementary...removed the between clause and replaced it with 2 statements <=
and >=
<cfset startdate=#DateFormat(rsGetCustOrders.order_Date,'yyyy-mm-dd')#>
<cfset
enddate=#DateFormat(DateAdd("d",90,rsGetCustOrders.order_Date),'yyyy-mm-dd')#>
<cfquery name="Recordset1" datasource="#request.dsn#">
SELECT * FROM tbl_picks
Where LEFT(tbl_picks.Pick_SKU,4) != "0000" and tbl_picks.Pick_SKU != "FREE"
and and ("LEFT(tbl_picks.Pick_SKU,10)" >= #createODBCDate(startdate)# and
"LEFT(tbl_picks.Pick_SKU,10)" <= #createODBCDate(enddate)#)
</cfquery>
The Pick_SKU the first 10 char are the DATE 2006-11-03 followed by the event
and it is a string of up to 16 characters. Someone mentioned using Convert() on
the sql side and I am wondering if you can give me an example...since
everytime I tried it gave me an error.
Any other ideas?
Cornel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259215
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
