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 =
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
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:
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. /
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
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
6 matches
Mail list logo