Hi,
I'm looking for someone who can port some spelling algorithm to MS SQL 2005.
I have some spell checkers working in ColdFusion, but the application we are
working on is high traffic and I am looking to save milliseconds on
requests.
Thinking that porting the algorithm to SQL will give me
hi al
I have the following date that I need to specify in my code cfset
payment_from_date=10-01-07
however I cannot seem to display it in correct date format using the
dateformat function it keeps returning 1-oct-07 when I am using
dateformat(payment_date, dd-mmm-yy)
I look forward to your
try using
lsdateformat(payment_date, dd-mmm-yy)
this relies on the region setting of the server been set to Australia
or you can use setLocal
On 1/28/07, claude raiola [EMAIL PROTECTED] wrote:
hi al
I have the following date that I need to specify in my code cfset
Hi Claude,
Try dateformat(lsParseDateTime(payment_date), dd-mmm-yy)
Cheers,
Adam
_
From: claude raiola [mailto:[EMAIL PROTECTED]
Sent: Monday, 29 January 2007 12:52 AM
To: cfaussie@googlegroups.com; cfaussie@googlegroups.com
Subject: [cfaussie] working with dates in CF
I have tried that , that is why the date is displaying with the month as
OCT, however the date value I am using is 10-1-07 yet it outputs it as
1-Oct-07
cfset payment_from_date=10-01-07
#dateformat(payment_from_date, 'dd-mmm-yy')# outputs the date as 1-Oct-07
rather than 10-Jan-07
what is the locale on the server? If it's US it will think the digits are
the month, if it's AU then it will think the first digits are a day. It
looks like your locale is set to US. You can set the locale with setLocale
see http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functa80.htm
try
As others have said lsDateFormat( date ) and also use setLocale to make sure
that the date is displayed and stored as an Australian date.
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
_
From:
Hello Claude,
you wrote:
hi al
I have the following date that I need to specify in my code cfset
payment_from_date=10-01-07
however I cannot seem to display it in correct date format using the
dateformat function it keeps returning 1-oct-07 when I am using
dateformat(payment_date,
and to follow on from Kym's thoughts...
it's worth working out exactly where you convert your date *string*
from a form/input to your dateTime *object* as far as the archetecture
of your site
for me, it's part of the server-side form validation routines (ie: as
soon as I can**). from then on
Grant, we often get led off into concerns that arent anything to do with
us. If you work for Adobe, and your job is to promote ColdFusion over
competing products, then you would be watching anything Microsoft does and
would want to one-up them whenever you can. Great. That's now the
I'd likely be interested in coming along to something like this. Especially
if it's free. ;) I spent the last few months seriously under-employed, so
there isn't a great deal of spare cash around if I want to keep being able
to pay my rent. *sigh*
Cheers,
Seona.
We are working on an application that will receive high traffic.
All queries are Stored Procedures (MS SQL 2005) and I was thinking of
putting all the calls to those SPs in a CFC, only to keep all the SQL in one
place. But since I am more concerned about speed than anything else, I am
thinking
Mike,
Product evangelist is basically a fancy name for technical sales
person, I've never meet an Adobe evangelist who wasn't trying to sell
me something and I'm sure Microsoft evangelists are the same. I guess
my issue is that reading when Scott is saying (I have no issues with
Scott as a
13 matches
Mail list logo