Cfquery dates help needed

2012-03-04 Thread Barry Mcconaghey
Hello. I'm trying to get this cfquery to match a database field EXPIRATIONDATE(date) 2012-3-04 and do a recordcount but it is not working. cfset mydatetime= DateFormat(Now(), '-mm-dd') cfquery name=data datasource=mydata SELECT EXPIRATIONDATE FROM COUPONS WHERE EXPIRATIONDATE =

Re: Cfquery dates help needed

2012-03-04 Thread Matt Quackenbush
WHERE EXPIRATIONDATE = cfqueryPARAM value = #mydatetime # CFSQLType = 'CF_SQL_VARCHAR' Sent from my Samsung Galaxy SII On Mar 4, 2012 7:54 AM, Barry Mcconaghey bmcconag...@gmail.com wrote: Hello. I'm trying to get this cfquery to match a database field EXPIRATIONDATE(date) 2012-3-04 and do

Re: CFinclude issues

2012-03-04 Thread Larry Lyons
include a file that includes the file you're including. CF_Inception! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Custom Tags

2012-03-04 Thread Larry Lyons
Short question, is this a CF custom tag or a CFX type tag. Custom tags don't have to be installed as others have said, to add to the prior comments, you can also use cfmodule and specify the exact path to the file as in cfmodule name = Name of the Tag template = /path/to/custom/tag etc. /

Re: Cfquery dates help needed

2012-03-04 Thread Leigh
CFSQLType ='CF_SQL_VARCHAR' Also for date columns use a date/time type instead of varchar.  If the column contains dates (only) you can use cf_sql_date, which truncates the time portion. WHERE EXPIRATIONDATE = cfqueryparam value = #now()#    CFSQLType

JSON Encoding Bug

2012-03-04 Thread Brook Davies
I just want to say I think that it is seriously lame that Adobe has not fixed the encoding issues with serializeJSON() converting 'yes' / 'no' to true/false. Yes, you can append as string and then convert it back afterwards and all that, but that's just adding extra processing overhead and