What do you mean search on date values? inside a text or just a
dedicated date column? in case of the date column you can just say (with
cfqueryparams ofcourse):
WHERE YEAR( myDate ) = #year( myCFDate )#
AND MONTH( myDate ) = #month( myCFDate )#
AND DAY( myDate ) = #day( myCFDate )#
in case of searching for a date inside a text column, i'm less sure. if
you know how the date is formatted, you could use LIKE '%dateFormat()%'.
I wouldn't use verity unless it's an insane ammount of records or
word/pdf files.
[EMAIL PROTECTED] wrote:
> Does anyone know how to search on odbc date values? I really need help.
>
> I've searched all over the internet and Adobe.com and found nothing
>
> Does Verity let you search on date values from a column in a db?
> Should the date values be stored in separate columns, month, day and year?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:248385
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
