Internationalization of Week() function in CF - Last resort to Java

2010-12-22 Thread Nando
I'm developing a scheduling application in CF. While doing so, I've discovered that there are a variety of different methods for determining the week number, and that depending on the locale, a week can begin on Saturday, Sunday or Monday. The first week of the year can be determined in a variety

More rewrite rule fun

2010-12-22 Thread Mark A. Kruger
Ok regex gurus. here's what I have. I'm using IsapiRewrite (Helicon) on an IIS server. I have links like the following: http://domain/model/parts/subcat1/subcat2/subcat3/subcat4/subcat5 From 1 to 6 levels of sub categories. My rule finds parts and the model .. So I need a rule

Re: More rewrite rule fun

2010-12-22 Thread Nathan Strutz
Mark, If your regex ^([^/]*)/parts(/)?$ captures anything after the parts/, you have a bad regex engine. You probably want something like this: ^.*/parts/([\w/]+)$ Using the same replace pattern, you will end up with

RE: More rewrite rule fun

2010-12-22 Thread Mark A. Kruger
Nate ok... what's the \w/ for? I'm not seeing that in my list of stuff I can use in the docs. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Nathan Strutz

RE: More rewrite rule fun

2010-12-22 Thread Mark A. Kruger
Nate... that worked I think... here's what I got.. [domain][***] (2) rewrite 'camaro/parts/brakes/pads/' - '/controllerscript.cfm? type=productaction=displayProductCategoriesmodel=camarosubcatpath=brakes/ pads/ I think that will work great... I just have to unpack the path and I'm good eh?

Re: More rewrite rule fun

2010-12-22 Thread Wil Genovese
The \w typically means match any word. I think it's allowed in mod_rewrite rules. So this rule says look for /part/ and any word ending in / and find 1 or more of those words ending in / Nate, is that right? Wil Genovese Sr. Web Application Developer/ Systems Administrator 651-894-4238

RE: More rewrite rule fun

2010-12-22 Thread Mark A. Kruger
Excellent... thanks Wil. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Wil Genovese [mailto:jugg...@trunkful.com] Sent: Wednesday, December 22, 2010 9:11 AM To: cf-talk Subject:

Re: More rewrite rule fun

2010-12-22 Thread Nathan Strutz
Will, that's right. The \w switch is roughly equivalent to [A-Za-z0-9_], aka, letters, numbers and underscores. I put \w/ in there to capture the \w words and / forward slashes. This regex just captures any words slashes after /parts/, which is pretty good because it makes the ending slash

Re: More rewrite rule fun

2010-12-22 Thread Wil Genovese
Thanks Nate - I have to add '-' and account for ''. Wil Genovese Sr. Web Application Developer/ Systems Administrator wilg...@trunkful.com www.trunkful.com On Dec 22, 2010, at 10:41 AM, Nathan Strutz wrote: Will, that's right. The \w switch is roughly equivalent to [A-Za-z0-9_], aka,

Re: Internationalization of Week() function in CF - Last resort to Java [spamtrap heur]

2010-12-22 Thread Paul Hastings
On 12/22/2010 8:41 PM, Nando wrote: numbers are often used in calenders and agendas. A question such as Can we arrange a meeting during week 43? can be rather common. The question, for actually i think that's rather an uncommon datepart to use. in fact in all my years nobody's ever asked for

Trapping entityDelete() errors

2010-12-22 Thread Ryan Heldt
Working with ColdFusion 9 ORM, is there a way to trap entityDelete() errors when there's a constraint violation. I have my delete setup like so: try { entityDelete(local.objSongCategory); // report success } catch (Any e) { transaction action=rollback; // report fail

RE: Webservice error after CF 8.01 update

2010-12-22 Thread Brook Davies
Hi Mack, Just wondering if you filed this as a bug. My webservice continually throws the duplicate class error message after running for some time. I have resorted now to running the following code every 1 hour to clear the template cache and hopefully avoid this error: !--- login --- cftry

CF 8.01 Services freezing up

2010-12-22 Thread David Moore
I have seen where others have posted this question, but no resolution. CF keeps restarting and sometimes will lock up so badly that i have to restart the server? Here is the error message: The description for Event ID 0 from source ColdFusion 8 ODBC Server cannot be found. Either the

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
I have seen where others have posted this question, but no resolution. CF keeps restarting and sometimes will lock up so badly that i have to restart the server? Here is the error message: The description for Event ID 0 from source ColdFusion 8 ODBC Server cannot be found. Either the

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
I am using MS Access and assigning the Datasource using CF Administrator as MS Access with Unicode. Does that help? ~| Order the Adobe Coldfusion Anthology now!

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
I am using MS Access and assigning the Datasource using CF Administrator as MS Access with Unicode. Does that help? The MS Access with Unicode driver doesn't use ODBC. So, you can disable the ODBC services and see if that fixes your problem. Dave Watts, CTO, Fig Leaf Software

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
The MS Access with Unicode driver doesn't use ODBC. So, you can disable the ODBC services and see if that fixes your problem. I am using 2 websites with SQL Server Express. If I stop this, will it affect those. And what is the ODBC Services for if not to manage database connections? In what

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
I am using 2 websites with SQL Server Express. If I stop this, will it affect those. No. And what is the ODBC Services for if not to manage database connections? In what situation would I use the ODBC Services? The ODBC services act as a bridge from your JDBC client (CF) to databases that

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
The ODBC service is really only used by people with MSACCESS DSN's, it you don't have any of these, and are not using the ODBC bridge, then your not using the ODBC service. Russ -Original Message- From: David Moore [mailto:dgmoor...@hotmail.com] Sent: 22 December 2010 21:31 To: cf-talk

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
Thank you Dan and Russ. You have been a tremendous help. I have turned the ODBC Service off and will report back if this resolves the issue so others may benefit from this post. ~| Order the Adobe Coldfusion Anthology now!

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
If you have checked Maintain connections across client requests, stopping ColdFusion 8 ODBC Server shuts down the websites? I had some sites stop working while others didn't. After investigating their datasource settings, this is what I found. So, do you recommend removing the selection for

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
They must have been ODBC data sources then, a JDBC Data source uses JDBC and not ODBC. Russ -Original Message- From: David Moore [mailto:dgmoor...@hotmail.com] Sent: 22 December 2010 22:22 To: cf-talk Subject: Re: CF 8.01 Services freezing up If you have checked Maintain connections

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
They must have been ODBC data sources then, a JDBC Data source uses JDBC and not ODBC. I guess then, what you are telling me, is I should be using a JDBC Data source. Any place to get directions on how to do this? David ~|

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
As has been mentioned already the MSACCESS with Unicode DSN does not use JDBC, so you can use that instead for your Access DSN's Russ From: David Moore [mailto:dgmoor...@hotmail.com] Sent: 22 December 2010 22:56 To: cf-talk Subject: Re: CF 8.01 Services freezing up They must have been ODBC

Care to Beta test new ColdFusion Exception Manager App?

2010-12-22 Thread Saman Jayasekara
I just posted Kakapo: Enhanced ColdFusion Exception/error Manager App. Care to Beta test anyone? http://cflove.org/2010/11/coldfusion-error-handler.cfm ~| Order the Adobe Coldfusion Anthology now!

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
If you have checked Maintain connections across client requests, stopping ColdFusion 8 ODBC Server shuts down the websites? I had some sites stop working while others didn't. After investigating their datasource settings, this is what I found. Are you sure you're not using any ODBC data

RE: Internationalization of Week() function in CF - Last resort to Java

2010-12-22 Thread Jason Durham
Thanks for sharing. -Original Message- From: Nando [mailto:d.na...@gmail.com] Sent: Wednesday, December 22, 2010 7:42 AM To: cf-talk Subject: Internationalization of Week() function in CF - Last resort to Java I'm developing a scheduling application in CF. While doing so, I've

Re: CF 8.01 Services freezing up

2010-12-22 Thread rex
In CFAdmin, if I go into SERVER SETTINGS Settings Summary, in the Database Data Sources section, it lists all my data sources. So, if I see everything using a JDBC URL, does that mean that I don't use ODBC data sources? On 12/22/2010 3:51 PM, Dave Watts wrote: If you have checked Maintain

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
In CFAdmin, if I go into SERVER SETTINGS Settings Summary, in the Database Data Sources section, it lists all my data sources.  So, if I see everything using a JDBC URL, does that mean that I don't use ODBC data sources? I'm not in front of a machine running CF, so I'm not sure exactly what

RE: CF 8.01 Services freezing up

2010-12-22 Thread Mark A. Kruger
No... when you are using odbc you are still using a JDBC Bridge driver. In the case of CF it's from sequelink and you can see it running in the task list as swsoc.exe it's what get's fired off with the Coldfusion ODBC Service. Whats really happening under the hood is that a JDBC driver is

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
In CFAdmin, if I go into SERVER SETTINGS Settings Summary, in the Database Data Sources section, it lists all my data sources. So, if I see everything using a JDBC URL, does that mean that I don't use ODBC data sources? All of mine look like the following: JDBC URL

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
All of mine look like the following: JDBC URL  jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Inetpub\\wwwroot\\domain\\mydatabases\\database.mdb;Izm JdbcEsc=yes;IzmReleaseOnClose= no Those are using the Access with Unicode driver, which isn't an ODBC driver. It's a

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
Those are using the Access with Unicode driver, which isn't an ODBC driver. It's a JDBC-to-JET driver. It doesn't rely on the ODBC services. Then that is what I am doing, but as I stated earlier, if I have the Maintain connections checked and stop Coldfusion 8 ODBC Server, the websites stop

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
David, Stopping these services should not stop your websites working, at worst it would result in database errors on those sites saying they were unable to connect to the database, but if the website completely stops working then there is some other issue at work here. What EXACTLY happens to

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
Stopping these services should not stop your websites working, at worst it would result in database errors on those sites saying they were unable to connect to the database, but if the website completely stops working then there is some other issue at work here. What EXACTLY happens to the site,

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
Then that is what I am doing, but as I stated earlier, if I have the Maintain connections checked and stop Coldfusion 8 ODBC Server, the websites stop working. Any suggestions from this, other than the obvious as Mark Kruger has told me many times stop using Access. I suggest that you stop

Re: Internationalization of Week() function in CF - Last resort to Java [spamtrap heur]

2010-12-22 Thread denstar
On Wed, Dec 22, 2010 at 10:19 AM, Paul Hastings wrote: ... supplying a user's locale will ensure you get their week numbers correct without having to resort to universalities that aren't. +1! final bit of advice, if you want to get the best/latest locale data, use the icu4j lib instead of

Re: Care to Beta test new ColdFusion Exception Manager App?

2010-12-22 Thread denstar
On Wed, Dec 22, 2010 at 3:57 PM, Saman Jayasekara wrote: I just posted Kakapo: Enhanced ColdFusion Exception/error Manager App. Care to Beta test anyone? http://cflove.org/2010/11/coldfusion-error-handler.cfm Seems nifty! No time to test ATM, but does it have a throttle, so you don't

Re: Internationalization of Week() function in CF - Last resort to Java [spamtrap heur] [spamtrap bayes][spamtrap heur]

2010-12-22 Thread Paul Hastings
On 12/23/2010 11:19 AM, denstar wrote: Joda seems pretty swell too. always thought joda was kind of like swatting a fly w/a battleship specific to this case it don't know no steenking locales ;-) icu4j is almost always the best choice when it comes to i18n functionality.

Re: Internationalization of Week() function in CF - Last resort to Java [spamtrap heur] [spamtrap bayes][spamtrap heur]

2010-12-22 Thread denstar
On Wed, Dec 22, 2010 at 10:26 PM, Paul Hastings wrote: On 12/23/2010 11:19 AM, denstar wrote: Joda seems pretty swell too. always thought joda was kind of like swatting a fly w/a battleship specific to this case it don't know no steenking locales ;-) Heh! =)p I am partial to