date:20100512


I'm having trouble figuring out why my database is storing dates in a way i
dont want.  I hope someone can help.

If I run an insert statement, and the dateentered  = cfqueryparam
value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought that
it would store the value '2010-03-31  00:00:00'   but it doesnt.   When i
run a select query on the table the value has been stored as '2010-31-03
 00:00:00'   (month and day in American format)

This means my reports dont find results for the last day of March and all
other days are screwed up too.I can't change the reports for a whole lot
of reasons,  not the least of which is there are bazillions of them.   I'd
rather force the database to store the date in the format i want.

Does anyone know now I can force SQLServer2005 to behave like a good
Australian server not an American one  and store the dates how we use them?


I have also tried using dateentered=#createodbcdate(dateentered)#  and that
gives the same result.

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


~|
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:333593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: SQLServer2005 and European dates


Mike,

SQL Server doesn't actually save the date in either format.  It saves it
as seconds (milliseconds maybe) from a certain date (I believe
1/1/1900).

The way it is displaying is based on the collation setting of the
Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates
back like this: 2010-05-12 08:25:15.670 Notice its Year-Month-Day.
You noted that the format of Year-Day-Month was American format, that is
incorrect. It is European format.  US Format is Year Month Day and most
people in the US write their dates as Month/Day/Year.

If you want a date in a specific format, you can return it as a string
in the format you want. Select cast(year(getDate()) as varchar) + '-' +
right('0' + cast(month(getDate()) as varchar), 2) + '-' + right('0' +
cast(day(getDate()) as varchar), 2) as properlyFormatedDate

Either way cfqueryparam should be handling the conversions correctly.
If you aren't picking up the 31st, then I would guess that there is
another issue.

If you did something like select * from someTable where mydate between
'05-01-2010' and '05-31-2010'; and it didn't return the record for the
31st that you were expecting then my guess is that there is time data
for that record.

In general when I'm doing something like that I do this:
Select *
From someTable
Where myDate = '05-01-2010'
And myDate  dateAdd(d, -1, dateAdd(m, 1, '05-01-2010'));

That way you get everything from 05-01-2010 00:00:00.000 to 05-31-2010
23:59:59.999.

Steve


-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Wednesday, May 12, 2010 9:20 AM
To: cf-talk
Subject: SQLServer2005 and european dates


I'm having trouble figuring out why my database is storing dates in a
way i
dont want.  I hope someone can help.

If I run an insert statement, and the dateentered  = cfqueryparam
value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought
that
it would store the value '2010-03-31  00:00:00'   but it doesnt.   When
i
run a select query on the table the value has been stored as '2010-31-03
 00:00:00'   (month and day in American format)

This means my reports dont find results for the last day of March and
all
other days are screwed up too.I can't change the reports for a whole
lot
of reasons,  not the least of which is there are bazillions of them.
I'd
rather force the database to store the date in the format i want.

Does anyone know now I can force SQLServer2005 to behave like a good
Australian server not an American one  and store the dates how we use
them?


I have also tried using dateentered=#createodbcdate(dateentered)#  and
that
gives the same result.

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month




~|
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:333594
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: SQLServer2005 and European dates

Thanks Steve, but the problem is we're in Australia. We use European format
dates. All the reports and queries are already written as

select * from someTable where mydate between '01-05-2010' and '31-05-2010';

But they dont select any May records unless i re-write the query using cast(
) etc.

That is simply impractical - the client is not going to pay me to rewrite
hundreds of queries, and anyway I'm not going to be able to do that inside
the time available.

And anyway, we already have historical data stored the way we want, from the
previous server where this site came from. We brought it over to this
server and now we have the problem. Maybe what I have to do is figure out
how to change the collation. Do you think that would get at the issue?

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month

On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT)
sd1...@att.com wrote:

Mike,

SQL Server doesn't actually save the date in either format. It saves it
as seconds (milliseconds maybe) from a certain date (I believe
1/1/1900).

The way it is displaying is based on the collation setting of the
Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates
back like this: 2010-05-12 08:25:15.670 Notice its Year-Month-Day.
You noted that the format of Year-Day-Month was American format, that is
incorrect. It is European format. US Format is Year Month Day and most
people in the US write their dates as Month/Day/Year.

If you want a date in a specific format, you can return it as a string
in the format you want. Select cast(year(getDate()) as varchar) + '-' +
right('0' + cast(month(getDate()) as varchar), 2) + '-' + right('0' +
cast(day(getDate()) as varchar), 2) as properlyFormatedDate

Either way cfqueryparam should be handling the conversions correctly.
If you aren't picking up the 31st, then I would guess that there is
another issue.

If you did something like select * from someTable where mydate between
'05-01-2010' and '05-31-2010'; and it didn't return the record for the
31st that you were expecting then my guess is that there is time data
for that record.

In general when I'm doing something like that I do this:
Select *
From someTable
Where myDate = '05-01-2010'
And myDate dateAdd(d, -1, dateAdd(m, 1, '05-01-2010'));

That way you get everything from 05-01-2010 00:00:00.000 to 05-31-2010
23:59:59.999.

Steve

-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Wednesday, May 12, 2010 9:20 AM
To: cf-talk
Subject: SQLServer2005 and european dates

I'm having trouble figuring out why my database is storing dates in a
way i
dont want. I hope someone can help.

If I run an insert statement, and the dateentered = cfqueryparam
value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought
that
it would store the value '2010-03-31 00:00:00' but it doesnt. When
i
run a select query on the table the value has been stored as '2010-31-03
00:00:00' (month and day in American format)

This means my reports dont find results for the last day of March and
all
other days are screwed up too.I can't change the reports for a whole
lot
of reasons, not the least of which is there are bazillions of them.
I'd
rather force the database to store the date in the format i want.

Does anyone know now I can force SQLServer2005 to behave like a good
Australian server not an American one and store the dates how we use
them?

I have also tried using dateentered=#createodbcdate(dateentered)# and
that
gives the same result.

--
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month

~|
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:333595
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: SQLServer2005 and European dates


Ok, so I made a mistake in my code...

Here is the correction:

Select *
From someTable
Where myDate = '05-01-2010'
And myDate  dateAdd(m, 1, '05-01-2010');

That code gets everything greater than or equal to 2010-05-01
00:00:00.000 and less than 2010-06-01 00:00:00.000

Steve


-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) 
Sent: Wednesday, May 12, 2010 9:35 AM
To: cf-talk
Subject: RE: SQLServer2005 and European dates


Mike,

SQL Server doesn't actually save the date in either format.  It saves it
as seconds (milliseconds maybe) from a certain date (I believe
1/1/1900).

The way it is displaying is based on the collation setting of the
Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates
back like this: 2010-05-12 08:25:15.670 Notice its Year-Month-Day.
You noted that the format of Year-Day-Month was American format, that is
incorrect. It is European format.  US Format is Year Month Day and most
people in the US write their dates as Month/Day/Year.

If you want a date in a specific format, you can return it as a string
in the format you want. Select cast(year(getDate()) as varchar) + '-' +
right('0' + cast(month(getDate()) as varchar), 2) + '-' + right('0' +
cast(day(getDate()) as varchar), 2) as properlyFormatedDate

Either way cfqueryparam should be handling the conversions correctly.
If you aren't picking up the 31st, then I would guess that there is
another issue.

If you did something like select * from someTable where mydate between
'05-01-2010' and '05-31-2010'; and it didn't return the record for the
31st that you were expecting then my guess is that there is time data
for that record.

In general when I'm doing something like that I do this:
Select *
From someTable
Where myDate = '05-01-2010'
And myDate  dateAdd(d, -1, dateAdd(m, 1, '05-01-2010'));

That way you get everything from 05-01-2010 00:00:00.000 to 05-31-2010
23:59:59.999.

Steve


-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Wednesday, May 12, 2010 9:20 AM
To: cf-talk
Subject: SQLServer2005 and european dates


I'm having trouble figuring out why my database is storing dates in a
way i
dont want.  I hope someone can help.

If I run an insert statement, and the dateentered  = cfqueryparam
value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought
that
it would store the value '2010-03-31  00:00:00'   but it doesnt.   When
i
run a select query on the table the value has been stored as '2010-31-03
 00:00:00'   (month and day in American format)

This means my reports dont find results for the last day of March and
all
other days are screwed up too.I can't change the reports for a whole
lot
of reasons,  not the least of which is there are bazillions of them.
I'd
rather force the database to store the date in the format i want.

Does anyone know now I can force SQLServer2005 to behave like a good
Australian server not an American one  and store the dates how we use
them?


I have also tried using dateentered=#createodbcdate(dateentered)#  and
that
gives the same result.

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month






~|
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:333596
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: SQLServer2005 and European dates


Yes, check the old database and the new one and compare the collation.
What versions of SQL server are you using?

Steve


-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Wednesday, May 12, 2010 9:42 AM
To: cf-talk
Subject: Re: SQLServer2005 and European dates


Thanks Steve, but the problem is we're in Australia.  We use European
format
dates.   All the reports and queries are already written as

select * from someTable where mydate between '01-05-2010' and
'31-05-2010';

But they dont select any May records unless i re-write the query using
cast(
)   etc.

 That is simply impractical - the client is not going to pay me to
rewrite
hundreds of queries, and anyway I'm not going to be able to do that
inside
the time available.

And anyway, we already have historical data stored the way we want, from
the
previous server where this site came from.  We brought it over to this
server and now we have the problem.   Maybe what I have to do is figure
out
how to change the collation.  Do you think that would get at the issue?

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT) 
sd1...@att.com wrote:


 Mike,

 SQL Server doesn't actually save the date in either format.  It saves
it
 as seconds (milliseconds maybe) from a certain date (I believe
 1/1/1900).

 The way it is displaying is based on the collation setting of the
 Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates
 back like this: 2010-05-12 08:25:15.670 Notice its Year-Month-Day.
 You noted that the format of Year-Day-Month was American format, that
is
 incorrect. It is European format.  US Format is Year Month Day and
most
 people in the US write their dates as Month/Day/Year.

 If you want a date in a specific format, you can return it as a string
 in the format you want. Select cast(year(getDate()) as varchar) + '-'
+
 right('0' + cast(month(getDate()) as varchar), 2) + '-' + right('0' +
 cast(day(getDate()) as varchar), 2) as properlyFormatedDate

 Either way cfqueryparam should be handling the conversions correctly.
 If you aren't picking up the 31st, then I would guess that there is
 another issue.

 If you did something like select * from someTable where mydate between
 '05-01-2010' and '05-31-2010'; and it didn't return the record for the
 31st that you were expecting then my guess is that there is time data
 for that record.

 In general when I'm doing something like that I do this:
 Select *
 From someTable
 Where myDate = '05-01-2010'
 And myDate  dateAdd(d, -1, dateAdd(m, 1, '05-01-2010'));

 That way you get everything from 05-01-2010 00:00:00.000 to 05-31-2010
 23:59:59.999.

 Steve


 -Original Message-
 From: Mike Kear [mailto:afpwebwo...@gmail.com]
 Sent: Wednesday, May 12, 2010 9:20 AM
 To: cf-talk
 Subject: SQLServer2005 and european dates


 I'm having trouble figuring out why my database is storing dates in a
 way i
 dont want.  I hope someone can help.

 If I run an insert statement, and the dateentered  = cfqueryparam
 value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought
 that
 it would store the value '2010-03-31  00:00:00'   but it doesnt.
When
 i
 run a select query on the table the value has been stored as
'2010-31-03
  00:00:00'   (month and day in American format)

 This means my reports dont find results for the last day of March and
 all
 other days are screwed up too.I can't change the reports for a
whole
 lot
 of reasons,  not the least of which is there are bazillions of them.
 I'd
 rather force the database to store the date in the format i want.

 Does anyone know now I can force SQLServer2005 to behave like a good
 Australian server not an American one  and store the dates how we use
 them?


 I have also tried using dateentered=#createodbcdate(dateentered)#  and
 that
 gives the same result.

 --
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month




 



~|
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:333597
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: SQLServer2005 and European dates


It is SQLServer2005.  The old server was SQLServer2000.Rewriting
hundreds of queries is not an option.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month



On Wed, May 12, 2010 at 11:44 PM, DURETTE, STEVEN J (ATTASIAIT) 
sd1...@att.com wrote:


 Yes, check the old database and the new one and compare the collation.
 What versions of SQL server are you using?

 Steve





~|
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:333599
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: SQLServer2005 and European dates


Mike,

This article tells how to change the default collation for a database
and includes a script to change the collation for objects that have
already been created in the database.

http://www.db-staff.com/index.php/microsoft-sql-server/69-change-collati
on

Just remember to make sure you have the right collation! :)

Steve



-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Wednesday, May 12, 2010 9:42 AM
To: cf-talk
Subject: Re: SQLServer2005 and European dates


Thanks Steve, but the problem is we're in Australia.  We use European
format
dates.   All the reports and queries are already written as

select * from someTable where mydate between '01-05-2010' and
'31-05-2010';

But they dont select any May records unless i re-write the query using
cast(
)   etc.

 That is simply impractical - the client is not going to pay me to
rewrite
hundreds of queries, and anyway I'm not going to be able to do that
inside
the time available.

And anyway, we already have historical data stored the way we want, from
the
previous server where this site came from.  We brought it over to this
server and now we have the problem.   Maybe what I have to do is figure
out
how to change the collation.  Do you think that would get at the issue?

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT) 
sd1...@att.com wrote:


 Mike,

 SQL Server doesn't actually save the date in either format.  It saves
it
 as seconds (milliseconds maybe) from a certain date (I believe
 1/1/1900).

 The way it is displaying is based on the collation setting of the
 Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates
 back like this: 2010-05-12 08:25:15.670 Notice its Year-Month-Day.
 You noted that the format of Year-Day-Month was American format, that
is
 incorrect. It is European format.  US Format is Year Month Day and
most
 people in the US write their dates as Month/Day/Year.

 If you want a date in a specific format, you can return it as a string
 in the format you want. Select cast(year(getDate()) as varchar) + '-'
+
 right('0' + cast(month(getDate()) as varchar), 2) + '-' + right('0' +
 cast(day(getDate()) as varchar), 2) as properlyFormatedDate

 Either way cfqueryparam should be handling the conversions correctly.
 If you aren't picking up the 31st, then I would guess that there is
 another issue.

 If you did something like select * from someTable where mydate between
 '05-01-2010' and '05-31-2010'; and it didn't return the record for the
 31st that you were expecting then my guess is that there is time data
 for that record.

 In general when I'm doing something like that I do this:
 Select *
 From someTable
 Where myDate = '05-01-2010'
 And myDate  dateAdd(d, -1, dateAdd(m, 1, '05-01-2010'));

 That way you get everything from 05-01-2010 00:00:00.000 to 05-31-2010
 23:59:59.999.

 Steve


 -Original Message-
 From: Mike Kear [mailto:afpwebwo...@gmail.com]
 Sent: Wednesday, May 12, 2010 9:20 AM
 To: cf-talk
 Subject: SQLServer2005 and european dates


 I'm having trouble figuring out why my database is storing dates in a
 way i
 dont want.  I hope someone can help.

 If I run an insert statement, and the dateentered  = cfqueryparam
 value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought
 that
 it would store the value '2010-03-31  00:00:00'   but it doesnt.
When
 i
 run a select query on the table the value has been stored as
'2010-31-03
  00:00:00'   (month and day in American format)

 This means my reports dont find results for the last day of March and
 all
 other days are screwed up too.I can't change the reports for a
whole
 lot
 of reasons,  not the least of which is there are bazillions of them.
 I'd
 rather force the database to store the date in the format i want.

 Does anyone know now I can force SQLServer2005 to behave like a good
 Australian server not an American one  and store the dates how we use
 them?


 I have also tried using dateentered=#createodbcdate(dateentered)#  and
 that
 gives the same result.

 --
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month




 



~|
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:333598
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Substitute/conversion for Flash Interactive Menus for iPad?

2010-05-12 Thread Scott Brady


On Mon, May 10, 2010 at 11:45 PM, Judah McAuley ju...@wiredotter.comwrote:


 Apple has thrown their chips in and laid a bet firmly on one side.
 Thus far the other big boys have yet to place their bets.


A few more demos of Flash on Android like they had recently and the other
big guys might be on the same side as Apple.

http://jeffcroft.com/blog/2010/may/08/android-flash-demo-flashcamp-seattle/

Scott


-- 
-
Scott Brady
http://www.scottbrady.net/


~|
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:333600
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: SQLServer2005 and European dates


Thank you Steve, but I dont think you've seen the point.   The query you
wrote isnt the one I'm using.

you wrote:
Select *
From someTable
Where myDate = '05-01-2010'
And myDate  dateAdd(m, 1, '05-01-2010');

and that gets all the May results.

We're sending:
Select *
From someTable
Where myDate = '01-05-2010'
And myDate  '31-05-2010';

and it gets NO May results.

As i said, re-writing hundreds of queries throughout the application is NOT
an option.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


On Wed, May 12, 2010 at 11:42 PM, DURETTE, STEVEN J (ATTASIAIT) 
sd1...@att.com wrote:


 Ok, so I made a mistake in my code...

 Here is the correction:

 Select *
 From someTable
 Where myDate = '05-01-2010'
 And myDate  dateAdd(m, 1, '05-01-2010');

 That code gets everything greater than or equal to 2010-05-01
 00:00:00.000 and less than 2010-06-01 00:00:00.000

 Steve





~|
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:333601
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: SQLServer2005 and European dates


Mike,

I sent out another email with a link to an article about changing the
database collation.

Steve

-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Wednesday, May 12, 2010 10:10 AM
To: cf-talk
Subject: Re: SQLServer2005 and European dates


Thank you Steve, but I dont think you've seen the point.   The query you
wrote isnt the one I'm using.

you wrote:
Select *
From someTable
Where myDate = '05-01-2010'
And myDate  dateAdd(m, 1, '05-01-2010');

and that gets all the May results.

We're sending:
Select *
From someTable
Where myDate = '01-05-2010'
And myDate  '31-05-2010';

and it gets NO May results.

As i said, re-writing hundreds of queries throughout the application is
NOT
an option.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


~|
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:333602
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: SQLServer2005 and European dates


Ok here's a puzzle.   I changed my insert query, and now it's changed the
way the date is stored.  Does anyone know if this is a bug?

For example   if I have this in the insert query:

cfqueryparam value=#PLUTotal.getdateentered()#
cfsqltype=CF_SQL_TIMESTAMP /,

then the date is stored in the American format of '2010-31-03 00:00:00'

But if i get rid of the CFQUERYPARAM and have the same info inserted as
follows;

#createodbcdate(PLUTotal.getdateentered())#,

then the date shows in a query as ''2010-03-31 00:00:00'

So . the solution for my issue is to do away with CFQUERYPARAM at least for
date fields in insert/update queries.   But why would that make this
difference?

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


~|
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:333603
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: SQLServer2005 and European dates

2010-05-12 Thread John M Bliss


Perhaps a stupid question...but have you double-checked the SQL data type of
the column in question?  Is it, perhaps, a varchar instead of a datetime?

On Wed, May 12, 2010 at 9:34 AM, Mike Kear afpwebwo...@gmail.com wrote:


 Ok here's a puzzle.   I changed my insert query, and now it's changed the
 way the date is stored.  Does anyone know if this is a bug?

 For example   if I have this in the insert query:

 cfqueryparam value=#PLUTotal.getdateentered()#
 cfsqltype=CF_SQL_TIMESTAMP /,

 then the date is stored in the American format of '2010-31-03 00:00:00'

 But if i get rid of the CFQUERYPARAM and have the same info inserted as
 follows;

 #createodbcdate(PLUTotal.getdateentered())#,

 then the date shows in a query as ''2010-03-31 00:00:00'

 So . the solution for my issue is to do away with CFQUERYPARAM at least for
 date fields in insert/update queries.   But why would that make this
 difference?

 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


 

~|
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:333604
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: SQLServer2005 and European dates

2010-05-12 Thread Richard Meredith-Hardy


I suspect you are not giving the db a date in an unambiguous format from CF,
ie {ts '2010-05-12 15:45:00} 

You can sometimes give a date in 'native' format to a db and it will accept
it, but it is essentially ambiguous ie 1/5/2010 - is this 1 may or 5th Jan?
The createodbcDate() or createodbcdatetime() functions are your friend.

Richard


 -Original Message-
 From: Mike Kear [mailto:afpwebwo...@gmail.com]
 Sent: 12 May 2010 15:10
 To: cf-talk
 Subject: Re: SQLServer2005 and European dates
 
 
 Thank you Steve, but I dont think you've seen the point.   The query you
 wrote isnt the one I'm using.
 
 you wrote:
 Select *
 From someTable
 Where myDate = '05-01-2010'
 And myDate  dateAdd(m, 1, '05-01-2010');
 
 and that gets all the May results.
 
 We're sending:
 Select *
 From someTable
 Where myDate = '01-05-2010'
 And myDate  '31-05-2010';
 
 and it gets NO May results.
 
 As i said, re-writing hundreds of queries throughout the application is
 NOT
 an option.
 
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
 
 
 On Wed, May 12, 2010 at 11:42 PM, DURETTE, STEVEN J (ATTASIAIT) 
 sd1...@att.com wrote:
 
 
  Ok, so I made a mistake in my code...
 
  Here is the correction:
 
  Select *
  From someTable
  Where myDate = '05-01-2010'
  And myDate  dateAdd(m, 1, '05-01-2010');
 
  That code gets everything greater than or equal to 2010-05-01
  00:00:00.000 and less than 2010-06-01 00:00:00.000
 
  Steve
 
 
 
 
 
 

~|
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:333605
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: SQLServer2005 and european dates

2010-05-12 Thread Maureen


http://msdn.microsoft.com/en-us/library/bb330962%28SQL.90%29.aspx

Midway down the page is a table of regarding internationalization of
dates.  There is also a default setting in the database configuration
for the date format.

On Wed, May 12, 2010 at 6:19 AM, Mike Kear afpwebwo...@gmail.com wrote:

 I'm having trouble figuring out why my database is storing dates in a way i
 dont want.  I hope someone can help.

 If I run an insert statement, and the dateentered  = cfqueryparam
 value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought that
 it would store the value '2010-03-31  00:00:00'   but it doesnt.   When i
 run a select query on the table the value has been stored as '2010-31-03
  00:00:00'   (month and day in American format)

 This means my reports dont find results for the last day of March and all
 other days are screwed up too.    I can't change the reports for a whole lot
 of reasons,  not the least of which is there are bazillions of them.   I'd
 rather force the database to store the date in the format i want.

 Does anyone know now I can force SQLServer2005 to behave like a good
 Australian server not an American one  and store the dates how we use them?


 I have also tried using dateentered=#createodbcdate(dateentered)#  and that
 gives the same result.

 --
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


 

~|
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:333606
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: SQLServer2005 and European dates [spamtrap bayes][spamtrap heur]

2010-05-12 Thread Paul Hastings


On 5/12/2010 9:48 PM, Richard Meredith-Hardy wrote:
 You can sometimes give a date in 'native' format to a db and it will accept
 it, but it is essentially ambiguous ie 1/5/2010 - is this 1 may or 5th Jan?
 The createodbcDate() or createodbcdatetime() functions are your friend.

in that case, your friend for sql server is SET DATEFORMAT, ie

SET DATEFORMAT mdy

tells the server that following that statement, date data will be in the
month-day-year format.

~|
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:333607
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

ColdFusion Session Variables in Distributed Config

2010-05-12 Thread Donnie Carvajal


Does anyone know where the session variables are stored if Coldfusion is 
running in a distributed configuration?  My assumption is the session variables 
are stored on the server running ColdFusion and not the web server, but you 
know what they say about assuming.

Thanks,

Donnie 

~|
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:333608
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ColdFusion Session Variables in Distributed Config

2010-05-12 Thread Mike Chabot


Sessions are stored on the server running ColdFusion.

-Mike Chabot

On Wed, May 12, 2010 at 1:07 PM, Donnie Carvajal
donnie.carva...@transformyx.com wrote:

 Does anyone know where the session variables are stored if Coldfusion is 
 running in a distributed configuration?  My assumption is the session 
 variables are stored on the server running ColdFusion and not the web server, 
 but you know what they say about assuming.

 Thanks,

 Donnie

 

~|
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:333609
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ColdFusion Session Variables in Distributed Config

2010-05-12 Thread Wil Genovese


The session variable are stored in the JVM memory of each ColdFusion  
instance.  if session replication is enable then the session  
information is shared among the enable CF instances.  Each instance  
keeping a copy of the session information in the JVM memory.

Wil Genovese

One man with courage makes a majority. - Andrew Jackson


On May 12, 2010, at 12:07 PM, Donnie Carvajal donnie.carva...@transformyx.com 
  wrote:


 Does anyone know where the session variables are stored if  
 Coldfusion is running in a distributed configuration? My assumption  
 is the session variables are stored on the server running ColdFusion  
 and not the web server, but you know what they say about assuming.

 Thanks,

 Donnie

 

~|
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:333610
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ColdFusion Session Variables in Distributed Config

2010-05-12 Thread Maureen


On the server running ColdFusion, but you can have some serious issues
on load-balanced servers with session variables.

On Wed, May 12, 2010 at 10:07 AM, Donnie Carvajal
donnie.carva...@transformyx.com wrote:

 Does anyone know where the session variables are stored if Coldfusion is 
 running in a distributed configuration?  My assumption is the session 
 variables are stored on the server running ColdFusion and not the web server, 
 but you know what they say about assuming.

 Thanks,

 Donni

~|
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:333611
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: ColdFusion Session Variables in Distributed Config

2010-05-12 Thread Paul Alkema


ColdFusion stores the session variables in the web server local RAM, however
when using ColdFusion with distributed configuration you should store the
sessions in the database because you don't know which machine will serve the
next page causing inconsistent sessions.

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com] 
Sent: Wednesday, May 12, 2010 1:46 PM
To: cf-talk
Subject: Re: ColdFusion Session Variables in Distributed Config


Sessions are stored on the server running ColdFusion.

-Mike Chabot

On Wed, May 12, 2010 at 1:07 PM, Donnie Carvajal
donnie.carva...@transformyx.com wrote:

 Does anyone know where the session variables are stored if Coldfusion is
running in a distributed configuration?  My assumption is the session
variables are stored on the server running ColdFusion and not the web
server, but you know what they say about assuming.

 Thanks,

 Donnie

 



~|
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:333612
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: New CF security bulletin


Just a note to let people know that several of us have had trouble with this 
hot fix.

http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Released#comments
 

~|
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:333613
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ColdFusion Session Variables in Distributed Config

2010-05-12 Thread Dave Watts


 ColdFusion stores the session variables in the web server local RAM, however
 when using ColdFusion with distributed configuration you should store the
 sessions in the database because you don't know which machine will serve the
 next page causing inconsistent sessions.

I suspect that the original poster is referring to CF's distributed
mode, where you have CF and the web server on separate machines. In
this case, variables are not stored in the web server's memory, but in
the CF server's memory. Also, distributed mode doesn't mean that you'd
have multiple CF instances, although you could. If you did have
multiple CF instances within a load-balanced configuration - with or
without distributed mode - you'd have to either enable session
replication between instances, use the sticky session option of your
load balancer to ensure that a user only visited a single instance, or
abandon session variables in favor of client variables stored in a
database accessible by both instances.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
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:333614
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: New CF security bulletin

2010-05-12 Thread Gerald Guido


Just a note to let people know that several of us have had trouble with
this hot fix.

Problems how? I am just about to patch my dev box.

Curious,
G?


On Wed, May 12, 2010 at 2:21 PM, Jason Fisher ja...@wanax.com wrote:


 Just a note to let people know that several of us have had trouble with
 this hot fix.


 http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Released#comments

 

~|
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:333615
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: New CF security bulletin

2010-05-12 Thread Dave Watts


  Just a note to let people know that several of us have had trouble with
  this hot fix.

 Problems how? I am just about to patch my dev box.

Jason included this link, which describes problems with datasources:

http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Released#comments

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
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:333616
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: New CF security bulletin

2010-05-12 Thread Ben Forta


The majority of users who applied the hotfix did not run into issues, but
several have. So please make backups BEFORE applying the hotfix.

The CF team is looking into this one.

--- Ben


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, May 12, 2010 2:57 PM
To: cf-talk
Subject: Re: New CF security bulletin


  Just a note to let people know that several of us have had trouble 
  with this hot fix.

 Problems how? I am just about to patch my dev box.

Jason included this link, which describes problems with datasources:

http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Release
d#comments

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.



~|
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:333617
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: New CF security bulletin

2010-05-12 Thread Gerald Guido


Me = Slaps forehead.

Running on autopilot today.

Thanx
G!

On Wed, May 12, 2010 at 2:56 PM, Dave Watts dwa...@figleaf.com wrote:


   Just a note to let people know that several of us have had trouble with
   this hot fix.
 
  Problems how? I am just about to patch my dev box.

 Jason included this link, which describes problems with datasources:


 http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Released#comments

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
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:333618
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: New CF security bulletin

2010-05-12 Thread Ben Forta


Looks like there is an issue with CF8.0.1 64-bit with Hotfix 4 applied,
where it doesn't like the filename convention of the security update. It
appears that only CF8.0.1 64-bit with Hotfix 4 is impacted, so if you're
using that version don't apply the update yet.

--- Ben



-Original Message-
From: Ben Forta [mailto:b...@forta.com] 
Sent: Wednesday, May 12, 2010 3:01 PM
To: cf-talk
Subject: RE: New CF security bulletin


The majority of users who applied the hotfix did not run into issues, but
several have. So please make backups BEFORE applying the hotfix.

The CF team is looking into this one.

--- Ben


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Wednesday, May 12, 2010 2:57 PM
To: cf-talk
Subject: Re: New CF security bulletin


  Just a note to let people know that several of us have had trouble 
  with this hot fix.

 Problems how? I am just about to patch my dev box.

Jason included this link, which describes problems with datasources:

http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Release
d#comments

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.





~|
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:333619
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Editing files directly from search interface

2010-05-12 Thread Dave Watts


Per our discussion, I've put together a search interface that allows
users to edit files found through search. It's a bit clunky, as it
spawns a new browser window when the user clicks on a search result,
then allows the user to edit the document through Office within that
browser window - it may be possible to change this.

To view/test this interface, simply run a search against any documents
on the filesystem, then change your search results page URL by
replacing client=default_frontend with
client=test_smbpath_frontend and replacing
proxystylesheet=default_frontend with
proxystylesheet=test_smbpath_frontend.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
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:333620
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: New CF security bulletin

2010-05-12 Thread Ben Forta


Ugh. Engineering team was able to recreate the issue on 64bit CF, but some
are seeing it on 32bit CF, too. They are working on a fix right now. If you
have yet to apply the patch, I'd suggest waiting a little longer.

--- Ben


-Original Message-
From: Ben Forta [mailto:b...@forta.com] 
Sent: Wednesday, May 12, 2010 3:32 PM
To: cf-talk
Subject: RE: New CF security bulletin


Looks like there is an issue with CF8.0.1 64-bit with Hotfix 4 applied,
where it doesn't like the filename convention of the security update. It
appears that only CF8.0.1 64-bit with Hotfix 4 is impacted, so if you're
using that version don't apply the update yet.

--- Ben



-Original Message-
From: Ben Forta [mailto:b...@forta.com]
Sent: Wednesday, May 12, 2010 3:01 PM
To: cf-talk
Subject: RE: New CF security bulletin


The majority of users who applied the hotfix did not run into issues, but
several have. So please make backups BEFORE applying the hotfix.

The CF team is looking into this one.

--- Ben


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Wednesday, May 12, 2010 2:57 PM
To: cf-talk
Subject: Re: New CF security bulletin


  Just a note to let people know that several of us have had trouble 
  with this hot fix.

 Problems how? I am just about to patch my dev box.

Jason included this link, which describes problems with datasources:

http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Release
d#comments

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.







~|
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:333621
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: New CF security bulletin


Cross-posted from the comments on Ben's blog, but I saw it on my development 
machine at work, Windows XP, still 32-bit, so don't count on it being only 
64-bit ...


~|
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:333622
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: New CF security bulletin

Ben, thanks for the updates and glad to hear they're working on it.

- Jason

On 5/12/2010 4:01 PM, Ben Forta wrote:
Ugh. Engineering team was able to recreate the issue on 64bit CF, but some
are seeing it on 32bit CF, too. They are working on a fix right now. If you
have yet to apply the patch, I'd suggest waiting a little longer.

--- Ben

-Original Message-
From: Ben Forta [mailto:b...@forta.com]
Sent: Wednesday, May 12, 2010 3:32 PM
To: cf-talk
Subject: RE: New CF security bulletin

Looks like there is an issue with CF8.0.1 64-bit with Hotfix 4 applied,
where it doesn't like the filename convention of the security update. It
appears that only CF8.0.1 64-bit with Hotfix 4 is impacted, so if you're
using that version don't apply the update yet.

--- Ben

-Original Message-
From: Ben Forta [mailto:b...@forta.com]
Sent: Wednesday, May 12, 2010 3:01 PM
To: cf-talk
Subject: RE: New CF security bulletin

The majority of users who applied the hotfix did not run into issues, but
several have. So please make backups BEFORE applying the hotfix.

The CF team is looking into this one.

--- Ben

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Wednesday, May 12, 2010 2:57 PM
To: cf-talk
Subject: Re: New CF security bulletin

Just a note to let people know that several of us have had trouble
with this hot fix.

Problems how? I am just about to patch my dev box.

Jason included this link, which describes problems with datasources:

http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Release
d#comments

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.

~|
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:333623
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

What is the version of Java SDK CF should use?

2010-05-12 Thread Nathan Chen


All:

 

I am using CF 8 and the System Info page shows the Java Version is
1.6.0_01 and Java VM Version is 1.6.0_01b-06. Is that the latest java CF
should use? If not, what's the latest one?  Is it the Version 6 Update
20 on java.com?

 

 

Nathan Chen



~|
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:333624
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: What is the version of Java SDK CF should use?

2010-05-12 Thread brad

I would recommend anything later than updater 10.  Just make sure you
get the JDK and not just the JRE.
I'm using 1.6.0_12 on my CF8 servers.  

~Brad

 Original Message 
Subject: What is the version of Java SDK CF should use?
From: Nathan Chen nathan.c...@cu.edu
Date: Wed, May 12, 2010 4:08 pm
To: cf-talk cf-talk@houseoffusion.com

I am using CF 8 and the System Info page shows the Java Version is
1.6.0_01 and Java VM Version is 1.6.0_01b-06. Is that the latest java CF
should use? If not, what's the latest one? Is it the Version 6 Update
20 on java.com?

~|
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:333625
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

best tools

2010-05-12 Thread bill turner


I've been away from CF for a couple years. My searches have so far not come up 
with any code coverage or static analysis tools. Are there any? Preferably open 
source.

Also, I was using CFUnit, but I understand this has been superseded with MXUnit 
and/or CFCUnit. Can anyone shed some light on this as well?

Thanks! 

~|
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:333626
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

coldbox 3

2010-05-12 Thread bill turner


we are migrating to both cf9 and coldbox. we have not used any framework 
previously. when i look at the coldbox site, it appears that version 3 is the 
one to go with. however, since this is not yet an official release, i have 
concerns. does anyone have experience with it? is it stable enough for prod? i 
think we'd be okay if there are changes, just not okay if it isn't stable. any 
experiences or advice welcome!


~|
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:333627
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: coldbox 3

2010-05-12 Thread Dorioo


M releases are stable for production use. But expect changes before 3.0.

I've hunkered down with M5. Planning to move past that once 3.0 and CF9
updater 1 are released.

- Gabriel

On Wed, May 12, 2010 at 6:39 PM, bill turner
bill.tur...@selectcomfort.comwrote:


 we are migrating to both cf9 and coldbox. we have not used any framework
 previously. when i look at the coldbox site, it appears that version 3 is
 the one to go with. however, since this is not yet an official release, i
 have concerns. does anyone have experience with it? is it stable enough for
 prod? i think we'd be okay if there are changes, just not okay if it isn't
 stable. any experiences or advice welcome!


 

~|
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:333628
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

How to show a work-in-progress icon while waiting for a web service

2010-05-12 Thread John Pullam


I have an app which calls a web service on a different computer to do work on 
its behalf and sometimes my users are impatient and hit the invocation button a 
second time, which causes problems. I'd like to pop some kind of 
work-in-progress or busy icon on the web page while this service is executing 
but am drawing a blank on how to do that. I can envision a hidden div with some 
kind of animated gif but am not sure of exactly how to activate it and then 
deactivate it when the service returns.

Would appreciate any ideas on how to do this. 

~|
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:333629
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: best tools

2010-05-12 Thread Brian Kotek


No code coverage tools yet, as that would need to work at the compiler level
(trying to parse the raw CFML would be next to impossible). MXUnit is pretty
much the standard unit testing framework.

Hope that helps,

Brian

On Wed, May 12, 2010 at 5:58 PM, bill turner
bill.tur...@selectcomfort.comwrote:


 I've been away from CF for a couple years. My searches have so far not come
 up with any code coverage or static analysis tools. Are there any?
 Preferably open source.

 Also, I was using CFUnit, but I understand this has been superseded with
 MXUnit and/or CFCUnit. Can anyone shed some light on this as well?

 Thanks!

 

~|
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:333630
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: How to show a work-in-progress icon while waiting for a web service

2010-05-12 Thread andy matthews


One simple way to do it is just to disable the submit button and change it's
text to something like Loading data That way you give instant feedback
to the user and it's someplace they're already looking.


andy

-Original Message-
From: John Pullam [mailto:jpul...@mcleansystems.com] 
Sent: Wednesday, May 12, 2010 5:55 PM
To: cf-talk
Subject: How to show a work-in-progress icon while waiting for a web service


I have an app which calls a web service on a different computer to do work
on its behalf and sometimes my users are impatient and hit the invocation
button a second time, which causes problems. I'd like to pop some kind of
work-in-progress or busy icon on the web page while this service is
executing but am drawing a blank on how to do that. I can envision a hidden
div with some kind of animated gif but am not sure of exactly how to
activate it and then deactivate it when the service returns.

Would appreciate any ideas on how to do this. 



~|
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:333631
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: What is the version of Java SDK CF should use?