DatePart will return an integer so CF_SQL_INTEGER On Mon, Aug 9, 2010 at 10:46 AM, Eric Roberts < [email protected]> wrote:
> > We are putting a cfqueryparam aound all of our sql vars...I am not sure how > to handle this one: > > Here's the line: > > * > > AND* DatePart(m,inv_date)=<CFQUERYPARAM Value="#variables.month#" > cfsqltype= > "CF_SQL_date" null="false" list="false"> > > > > Should that be date or varchar since it is looking at the part of the date > (which I am assuming returns a char or varchar value). The actual column > in > the DB, inv_date is of type datetime. > > > > Thanks! > > Eric > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
