Cfquery dates help needed
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 = cfqueryPARAM value = mydatetime CFSQLType = 'CF_SQL_VARCHAR' cfoutput#data.RecordCount#/cfoutput Thanks, barry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Cfquery dates help needed
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 a recordcount but it is not working. cfset mydatetime= DateFormat(Now(), '-mm-dd') cfquery name=data datasource=mydata SELECT EXPIRATIONDATE FROM COUPONS WHERE EXPIRATIONDATE = cfqueryPARAM value = mydatetime CFSQLType = 'CF_SQL_VARCHAR' cfoutput#data.RecordCount#/cfoutput Thanks, barry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFinclude issues
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: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Tags
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. / Normally I don't use custom tags if I can help it (at times crawling 100 yards over ground glass is easier) but you may find this helpful http://www.forta.com/books/0321292693/0321292693_chapter30.pdf Hi All, I am having a challenge getting to my CF administrator page. CF 9.01, Windows 2008. I've been working on it for a bit with no solution. My question is, I have to install a custom tag. Is there any way to install a custom tag without using CF Administrator page? Thanks in advance! Greg ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Cfquery dates help needed
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 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
JSON Encoding Bug
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 hoakiness(?), and this bug has been around for so long - its now officially annoying. Sorry, I know, I'm just ranting. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm