On Tue, Jun 8, 2010 at 9:15 PM, Mike Kear afpwebwo...@gmail.com wrote:
This is generated by the Rooibos code written by P Farrell
Just saw this so ignore my other post (about naming the guilty code generator).
Thanx.
--
Sean A Corfield -- (904) 302-SEAN
Railo Technologies, Inc. --
Sean, I'm not sure characterising it as guilty is very fair. This
generator has worked just fine for me without any problems in about a
hundred applications. This is the first time it's given me any issues.
It's been so reliable I didnt suspect it might be anything to do with this
issue for a
Yes quite so, Sean. I'm just saying that it's worked a treat for me for a
long time, and I didn't want there to be any sense of criticism of this code
generator, or the two people who wrote it.
When I look at the code behind the generator, I see that there's logic in
the routine that writes
IMO, Set Langauge seems a bit... obtuse?
SET LANGUAGE DMY seems more appropriate, especially if you are giong to enter
it into every sproc.
cheers,
Mike Kear afpwebwo...@gmail.com 08/06/2010 2:27 pm
Thanks everyone for your help with this. I dont have it solved yet but i'm
on the right
Believe it or not, I'm still worrying away at this date issue.I dont
understand ColdFusion's insistence that we have to use American dates.
(This is CF9 Enterprise by the way)
I create a date object, using the following:
createdate(2010,10,06) which is supposed to be year, month, day in
Oh jeezz. Ever had those moments when you wish you'd just taken a breath
first???
Forget that.If i do it properly without the code error, i get the right
result.
hides his head in shame!@
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
Of Mike Kear
Sent: Wednesday, 9 June 2010 10:30 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
Believe it or not, I'm still worrying away at this date issue.I dont
understand ColdFusion's insistence that we have to use American dates
But thats correct isnt it? October is the 10th month
_
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Wednesday, 9 June 2010 10:30 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
Believe it or not, I'm still worrying away
: Wednesday, 9 June 2010 10:30 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour -
CF9/SQLServer2005
Believe it or not, I'm still worrying away at this date issue. I
dont understand ColdFusion's insistence that we have to use American
dates. (This is CF9
Kear
*Sent:* Wednesday, 9 June 2010 10:30 AM
*To:* cfaussie@googlegroups.com
*Subject:* Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
Believe it or not, I'm still worrying away at this date issue.I dont
understand ColdFusion's insistence that we have to use American dates
do you have a return type set on the function of the cfc ?
_
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Wednesday, 9 June 2010 11:13 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
Well i had to suck that back again
ds
Dale Fraser
http://dale.fraser.id.au
http://cfmldocs.com
http://learncf.com
http://flexcf.com
*From:* cf
I have found i can specifically set a date using numerical values rather
than variables, to make absolutely certain i know what the value of the date
being inserted is.
If i set a variable which is a date object using the createdate() function,
it reads the date properly. If I use that same
What do the methods setTransDate() and getTransDate() look like? Is
there a declared property behind them? If so, what does that look
like?
On Tue, Jun 8, 2010 at 9:02 PM, Mike Kear afpwebwo...@gmail.com wrote:
I have found i can specifically set a date using numerical values rather
than
This is the code for the getter and setter involved:
cffunction name=setTransDate access=public returntype=void
output=false
cfargument name=TransDate type=string required=true /
cfif isDate(arguments.TransDate)
cfset arguments.TransDate = dateformat(arguments.TransDate,DD/MM/) /
/cfif
cfset
On 9/06/2010 14:02, Mike Kear wrote:
If i set a variable which is a date object using the createdate()
function, it reads the date properly. If I use that same function to
set a setter in a bean, it doesnt. Here's the specifics:
cfset testdate = createdate(2010,06,10)
pDay:
2:15 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
This is the code for the getter and setter involved:
cffunction name=setTransDate access=public returntype=void
output=false
cfargument name=TransDate type
] On Behalf
Of Mike Kear
Sent: Wednesday, 9 June 2010 2:15 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
This is the code for the getter and setter involved:
cffunction name=setTransDate access=public returntype=void
output=false
, 9 June 2010 2:15 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
This is the code for the getter and setter involved:
cffunction name=setTransDate access=public returntype=void
output=false
cfargument name=TransDate type=string required=true
If I remove the date formatting stuff from the setter, it seems to work ok.
But I've been using the Rooibos bean generator without problems for ages.
I have never had this problem with dates before.So i'm not sure what's
so different about this app. Anyway, if i do this with the
Mike,
This generated code looks like it is causing you problems. As the bean
converts the date to a string for storage, when it retrieves it back CF
does a String Date conversion which is something i've always seen
problems with.
A quick hack would be to alter the cfreturn from
cfreturn
the thing is the function is messing around with the date object when it
doesnt need to be.
_
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Wednesday, 9 June 2010 2:26 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
If I
http://cfmldocs.com http://cfmldocs.com/
http://learncf.com
http://flexcf.com
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Mike Kear
Sent: Wednesday, 9 June 2010 2:26 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: Odd date behaviour - CF9
Try this -
http://blog.sqlauthority.com/2007/08/30/sql-server-2005-find-database-collation-using-t-sql-and-ssms/
- it has instructions for getting the collation value. What is it?
On 8/06/2010 1:14 PM, Gavin Baumanis wrote:
We had this error at RMIT and it took forever to work out what
@mgk: I'm doing the updates using ColdFusion. The only property I can find
that's remotely associated with language or nationality or locale is the
collation = SQL_Latin1_General_CP1_CI_AS
Can this be set to something else? Does it set the default date format
property?
Cheers
Mike Kear
In management studio it's security logins
[right click for properties] and there's a default language setting for
that login.
I guess if you have some tables that work and this one that doesn't
compare the collation between the two and these login settings and see
if they differ?
I found
Hi,
pretty sure that collation refers to sort order.
Language refers to date format however, but I could not find a server wide
setting to change it.
SELECT @@LANGUAGE AS 'Language Name' returns us_english in my SQL 2005 server.
If the language was British it would default to dmy
select *
Thanks everyone for your help with this. I dont have it solved yet but i'm
on the right track now I think.
I dont have this problem with any of the code I've written from scratch, but
in this case I'm inheriting a lot of code written in CF5 years ago, and
moved to a new server and database
28 matches
Mail list logo
