Re: IIS 500 - Internal Server Error

2006-09-08 Thread Robertson-Ravo, Neil (RX)
Isn't the theoretical limit supposed to be 2GB with the actual limit somewhere in the region of 1.8? I know I have seen a JVM start with at least 1.5GB - could have been more, I can't remember. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL,

ColdFusion and the Pre-packed JDK Problems

2006-09-08 Thread Jerky San Pedro
ColdFusion MX 6.1 comes with a bundled JDK of its own, right? Now does that JDK bypass the JDK already installed with your OS when it executes your .jar files? I just wanna be sure, in case my assumption is wrong (though it appears logical enough that the OS JDK is bypassed). I'm asking

Re: CF5 Download

2006-09-08 Thread Jerky San Pedro
I also have CF-5 installers for Linux and Windows prepared for backup purposes. I don't know if I can mail it to you, it's a huge chunk. Also, I'm not very sure about the EULA of CF5. If I am right, it will only install if you have a serial number, so I don't think there's no developer mode to

Re: ColdFusion and the Pre-packed JDK Problems

2006-09-08 Thread Robertson-Ravo, Neil (RX)
By default, I think it uses it's own JRE (not JDK) when it is a vanilla install. depending on your install type this would be either in the JRun folder or the CFusionMX one. It does this as your system level install may not be supported by AllaMadobe. you will need to go in and change it to your

RE: IIS 500 - Internal Server Error

2006-09-08 Thread Snake
I have generally read that you can't set it much over 1gb, maybe 1.2 or 1.3 Obviously this requires tweaks elsewhere as I have tried using values greater than 1GB and JRUN will not start -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 08 September 2006

RE: IIS 500 - Internal Server Error

2006-09-08 Thread David Low
I'd go along with that - the maximum I've been able to start the service with, was 1.3. It depends on other settings as well. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 08 September 2006 09:35 To: CF-Talk Subject: RE: IIS 500 - Internal Server Error I have

Re: ColdFusion and the Pre-packed JDK Problems

2006-09-08 Thread Jochem van Dieten
Jerky San Pedro wrote: ColdFusion MX 6.1 comes with a bundled JDK of its own, right? Now does that JDK bypass the JDK already installed with your OS when it executes your .jar files? I just wanna be sure, in case my assumption is wrong (though it appears logical enough that the OS JDK is

Re: ColdFusion and the Pre-packed JDK Problems

2006-09-08 Thread Jerky San Pedro
Thanks, Jochem. I am aware of that, and that's why it stumps me. Thing is, the error encounters come in random. Sometimes, when I restart the CFServer I get the error. Sometimes, I don't. Sometimes, I get it 8 restarts in a row: like today. And that troubles me, because that should not happen

neverendingcart.cfc finally comes thru

2006-09-08 Thread Will Tomlinson
Just wanted to let everyone know my neverendingcart.cfc project has produced its first sale! I'd like to thank everyone for helping me test it, and your input. I'm bouncing from some of the bugs you reported, to building the order admin. I'm building all kinds of stats and whizbang features

RE: IIS 500 - Internal Server Error

2006-09-08 Thread Robertson-Ravo, Neil (RX)
I just started a JVM with a value of 1.5GB started fine. I think the limit is more like 1.8 according to the Adobe Technote. http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19359 -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 08 September 2006 09:35 To:

Re: IIS 500 - Internal Server Error

2006-09-08 Thread Andy Allan
The maximum size is 1.8 but the actual value, as David says, does depend on other factors. On 08/09/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I just started a JVM with a value of 1.5GB started fine. I think the limit is more like 1.8 according to the Adobe Technote.

Re: ColdFusion and the Pre-packed JDK Problems

2006-09-08 Thread Jochem van Dieten
Jerky San Pedro wrote: Thanks, Jochem. I am aware of that, and that's why it stumps me. Thing is, the error encounters come in random. Sometimes, when I restart the CFServer I get the error. Sometimes, I don't. Sometimes, I get it 8 restarts in a row: like today. And that troubles me,

RE: neverendingcart.cfc finally comes thru

2006-09-08 Thread Jenny Gavin-Wear
Nice work Will ! -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 08 September 2006 10:59 To: CF-Talk Subject: neverendingcart.cfc finally comes thru Just wanted to let everyone know my neverendingcart.cfc project has produced its first sale! I'd like to thank

Re: CFEclipse - FTP???

2006-09-08 Thread Casey Dougall
I do like cfe but that ftp really sucks, im sure even fp had something better than what eclipse has. Even if it only did one file at a time, hell id love that and dw would be gone. Something to note, Microsoft Expressions Web Designer is still free in the beta. Even highlights coldfusion

Hosting companies

2006-09-08 Thread Doug Brown
Was wondering who the best hosting companies were. Need to support mySql. Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to

Re: Hosting companies

2006-09-08 Thread Tom King
In which country? T On 8 Sep 2006, at 13:24, Doug Brown wrote: Was wondering who the best hosting companies were. Need to support mySql. Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

Re: Hosting companies

2006-09-08 Thread Doug Brown
united states. - Original Message - From: Tom King [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 08, 2006 6:27 AM Subject: Re: Hosting companies In which country? T On 8 Sep 2006, at 13:24, Doug Brown wrote: Was wondering who the best

RE: Hosting companies

2006-09-08 Thread Rick
I signed up with HosTek.com a few months ago and it's been great. They Reseller package is only $25/m for 5 domains. It comes with lots of features and MySQL. For $10 more you can get MS SQL Server. http://hostek.com/web-hosting-reseller.asp Or if that's more than you want to pay get with me

RE: Locking Theory

2006-09-08 Thread Doug Bezona
Please, I'm not that dumb, I know what an application is compared to a simple web page. Never suggested you were dumb, just pointing out the root of the issue. All the same, we coldFusion developpers, are able to create complete multi-user true applications and work around THE HTTP

Integrating w/ Credit Reporting Agencies

2006-09-08 Thread Rey Bango
I have a client that would like to be able to offer payment plans to customers for some of their products. They'd like to do a pre-approval process based on credit scores. Has anyone integrated with the credit reporting agencies to do this? If so, which ones and which services? Is there a

RE: Hosting companies

2006-09-08 Thread Adkins, Randy
http://www.coldfusion-mx-hosting.com/ Support and Prices are excellent -Original Message- From: Rick [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006 8:38 AM To: CF-Talk Subject: RE: Hosting companies I signed up with HosTek.com a few months ago and it's been great. They

Re: Hosting companies

2006-09-08 Thread Casey Dougall
On 9/8/06, Adkins, Randy [EMAIL PROTECTED] wrote: http://www.coldfusion-mx-hosting.com/ Support and Prices are excellent That price sucks! 35 / month for: 750 MB Disk Space 12 GB Transfer Up to 10 Websites For 35 a month I better get 5 plus gig of space

CF5 to CFMX (Was: Hosting companies)

2006-09-08 Thread Doug Brown
Ok, looks like a couple of good ones. I have always used CF5 and I guess I am just an old goat that does not want to change. What issues has people had running there CF5 apps on CFMX machines? It does not look like very many hosting companies out there are still using version 5 - Original

RE: Hosting companies

2006-09-08 Thread Andy Matthews
My company offers CF hosting: www.icglink.net Currently CFMX/mySQL4 but supposedly we're planning on upgrading in the next few months. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737

Re: Hosting companies

2006-09-08 Thread James Holmes
Hostmysite. http://www.hostmysite.com/ On 9/8/06, Doug Brown [EMAIL PROTECTED] wrote: Was wondering who the best hosting companies were. Need to support mySql. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/

Re: Hosting companies

2006-09-08 Thread Neil Middleton
hostmysite.com? On 9/8/06, Andy Matthews [EMAIL PROTECTED] wrote: My company offers CF hosting: www.icglink.net Currently CFMX/mySQL4 but supposedly we're planning on upgrading in the next few months. !//-- andy matthews web developer certified advanced coldfusion

Re: Locking Theory

2006-09-08 Thread Tom Kitta
How about solving it with AJAX or using Flash forms that use sockets to check whatever the current user is still editing? You could even popup a message like You are taking a long time to edit or Someone else wants to edit this data - please either release it or finish your work ASAP. TK

Re: Hosting companies

2006-09-08 Thread Mike Tangorre
From: Doug Brown [EMAIL PROTECTED] Was wondering who the best hosting companies were. Need to support mySql. Search the archives at houseoffusion.com. This is a popular question that pops up about once a month... lots of good info in the archives.

Re: Locking Theory

2006-09-08 Thread Jochem van Dieten
Claude Schneegans wrote: This what so simple in 1980's, with dBase, clipper, Foxpro you name it, under DOS. All had Rlock() and Flock() functions. Rlock() was used when editing a record, Flock() locked the whole file, for instance while indexing a table. You had to lock a table to index

Re: Locking Theory

2006-09-08 Thread Jochem van Dieten
Claude Schneegans wrote: For example, many databases do have the kind of locking you are talking about - for example in Oracle you can do select...for update, which locks the selected record until the update is completed by the session that initiated the select. Actually, until the

Re: Hosting companies

2006-09-08 Thread Scott_A . _Stewart
They rule, I just turned my boss on to them... Scott A. Stewart REAC/PASS-IT (202)-475-8875 James Holmes [EMAIL PROTECTED] 09/08/2006 09:29 AM Please respond to cf-talk To: CF-Talk cf-talk@houseoffusion.com cc: (bcc: Scott A. Stewart/REAC/HHQ/HUD) Subject:

Re: CF5 to CFMX (Was: Hosting companies)

2006-09-08 Thread Scott_A . _Stewart
i've had many apps that would run straight away from 5 to 6, There are a few tags that have been retired. I believ ethe complete list is in the MX6 documentation. Scott A. Stewart REAC/PASS-IT (202)-475-8875 Doug Brown [EMAIL PROTECTED] 09/08/2006 09:17 AM Please respond to cf-talk

Re: Locking Theory

2006-09-08 Thread Jochem van Dieten
Claude Schneegans wrote: For my applications, I have no problem presently as few people are working in the same time, but in general, how would you lock a certain record in a table while some one is working on it ? I wouldn't. I would refuse an update to an old row version and present

Re: Hosting companies

2006-09-08 Thread Mingo Hagen
Another nice C3 topic, James ;) Mike Tangorre wrote: From: Doug Brown [EMAIL PROTECTED] Was wondering who the best hosting companies were. Need to support mySql. Search the archives at houseoffusion.com. This is a popular question that pops up about once a month... lots of good

Re: cfoutput timeout

2006-09-08 Thread Mary Jo Sminkey
The java directory stuff might work quite well in this case. Yes, you can tell it to only grab directories, and so long as you don't need file sizes and whatnot, it should be TONs faster than a cfdirectory call... theoretically... I went ahead and coded this so it would be available for

Re: Locking Theory

2006-09-08 Thread Jochem van Dieten
Tom Kitta wrote: Just remember that CF only *suggests* isolation levels and the DB actually does the isolation. There are four isolation levels, with most DB using read committed as the default level. If the database does not support the requested isolation level it is required to upgrade

Re: CFEclipse - FTP???

2006-09-08 Thread Douglas Knudsen
On 9/8/06, Dave Lyons [EMAIL PROTECTED] wrote: no worries, plus i have no idea what ur talking bout anyways lol and I have spent my $$ on dw and i like it just fine, my concern is that everything really seems to be going towards eclipse so I wanna get comfy with it, plus I like it! except

RE: another mySql question...

2006-09-08 Thread Ken Ferguson
That is a false statement. I'm currently using the ODBC drivers with MySQL 4.1 and MySQL 5 and CF works fine with both. The only thing is that you can't use the MySQL ODBC driver that CF has built in to the admin, as it is only for 4.x versions. Thanks, Ken Ferguson 214.636.6126

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
Making a web app retain some idea of a cohesive session across HTTP requests is a work around of the inherent statelessness of the protocol. Ok, but workaround or not, we are able to have sessions and keep track of them. All a session is is knowing that two distinct requests within a given

Re: Locking Theory

2006-09-08 Thread Mingo Hagen
Hey Jochem, That's the kind of stuff more people need to know about. Do you have any tips on good advanced SQL books? (Or should I have seen this in the basic SQL books that are out there and did I just skip this bit.) Thanks, Mingo. Jochem van Dieten wrote: SELECT * FROM table WHERE id =

Re: Hosting companies

2006-09-08 Thread Jim Wright
Search the archives at houseoffusion.com. This is a popular question that pops up about once a month... lots of good info in the archives. While it does pop up once a month, I'm not sure that is a bad thing. Hosting these days is mostly a commodity business, and with all the

Re: Hosting companies

2006-09-08 Thread Larry Lyons
Was wondering who the best hosting companies were. Need to support mySql. I've had a lot of good experience with CFDynamic's shared hosting. For around $16 a month (1 year prepay) you get CF5/CFMX 7/BD 6.2, MySQL or SQL Server, about 5 gig transfer, etc. You can look at the full details of all

Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Ali Majdzadeh
Hi everybody: I am want to test some of my coldfusion codes and show them to some of my freinds in some other countries before I buy the hosting so I need a free coldfusion hosting. It doesn't matter if it gives subdomain or some advertisement are shown there... I need it just to let me test my

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
Then I have news for you: the feature is implemented in both ODBC and JDBC and is standard in SQL. Ok, so it should be possible to make some CFX or CFC to handle locks. SELECT * FROM table WHERE id = blah FOR UPDATE Ok, but I think this syntax is proper to Oracle. - I don't see it documented

RE: Hosting companies

2006-09-08 Thread Adkins, Randy
Hostmysite prices are per domain correct? Unless of course you have a VPS or Dedicated account -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006 9:07 AM To: CF-Talk Subject: Re: Hosting companies On 9/8/06, Adkins, Randy [EMAIL

RE: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Andy Matthews
Why not just pay for the hosting for one month? You can find it for as cheap as $10 or so. You're not going to get free Coldfusion hosting because the Coldfusion server costs money. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Charlie Griefer
the trial version of CFMX will work for 30 days uncrippled. after 30 days it reverts to the developer edition (which is still fully featured...just crippled in that it only accepts requests from 2 external IP addresses). Would that not work? On 9/8/06, Ali Majdzadeh [EMAIL PROTECTED] wrote: Hi

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
Where'd you use row level locking? A real life example? This example has already been described in this thread: « 1. Bob opens a web page and goes to an edit tool and selects jenny to edit. 2. Sally opens a web page and goet to an edit tool and also selects jenny to edit. 3. Bob updates jenny

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
You had to lock a table to index it? That is soo 80'ies Yeah, after 25 years, the only difference is that the lock is handled automatically by the database engine. Not a big deal ;-) -- ___ REUSE CODE! Use custom tags; See

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Ali Majdzadeh
Hi Thanks for the reply. As a matter of fact I need a hosting. Just a free coldfusion hosting. I found many many ASP free hostings but no real coldfusion hosting!!! Please help me Thanks ~| Introducing the Fusion Authority

Re: Locking Theory

2006-09-08 Thread Tom Kitta
MS SQL locking is implemented as set of hints, for example: SELECT au_lname FROM authors WITH (NOLOCK) (dirty read - fast but dirty :) or for update as in SELECT au_lname FROM authors WITH (UPDLOCK) (data will not change till you do an update yourself) TK - Original Message - From:

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
SQL is simply a language that can be used to interact with the database at a high level of abstraction. Concurrency management is handled by the database engine, and there are many ways this can be done. It, like database-specific physical data storage, is below the level of SQL. I don't see

SOT: Ajax, Javascript, and UTC Time

2006-09-08 Thread Rick Root
So I'm trying to add timestamps to the join/leave announcements in my chat room Coldfusion inserts a UTC timestamp into the database which is returned with the content of the chat room for each line. However, javascript sees these dates as Eastern Daylight time (GMT-400). The coldfusion

Re: another mySql question...

2006-09-08 Thread Rick Root
Ken Ferguson wrote: That is a false statement. I'm currently using the ODBC drivers with MySQL 4.1 and MySQL 5 and CF works fine with both. The only thing is that you can't use the MySQL ODBC driver that CF has built in to the admin, as it is only for 4.x versions. (coldfusion doesn't come

RE: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Adkins, Randy
Not sure why you could not do it yourself since it is only temporary. CFMX 30day trial (full CF Server) You can setup the ODBC using Access And when your done, blow it away.. Easy as pie. -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006

Re: Locking Theory

2006-09-08 Thread Jochem van Dieten
Claude Schneegans wrote: SELECT * FROM table WHERE id = blah FOR UPDATE Ok, but I think this syntax is proper to Oracle. It may have originated there, but it has been in the SQL standard since at least 1992. - I don't see it documented in Access, SQL Server MS calls it WITH updlock. You

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Charlie Griefer
well, the fact of the matter is that there is no free CF hosting (AFAIK). there is one in the works that i know of (http://www.freecoldfusionhosting.com), but i'm not sure what the timeline is to get that up and running. There's also a company that i've been using for my personal site at

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
How on earth would such a tool work, in a disconnected environment? By keeping the environment connected. A CFX is a dll written in C that can stay resident, keep ODBC connections opened keep user handles in memory, and handle time limits. If the CFX locks a row in the database, CF will not be

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
A row-level lock isn't going to come even close to that. Why not ? With a row locked, it is not the update by another user which will be refused, but his own lock for editing before he can read the record. The system will not tell him who has locked the row, but may be it is better like this

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
MS SQL locking is implemented as set of hints, for example: Ah ok, so row locks are possible with MS SQL and Oracle. That covers most of the market. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send

Re: CF5 to CFMX (Was: Hosting companies)

2006-09-08 Thread Rick Root
Doug Brown wrote: Ok, looks like a couple of good ones. I have always used CF5 and I guess I am just an old goat that does not want to change. What issues has people had running there CF5 apps on CFMX machines? It does not look like very many hosting companies out there are still using version

RE: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread David Low
From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 08 September 2006 15:52 To: CF-Talk Subject: Re: Free Coldfusion Hosting that lets me connect to MS Access Database well, the fact of the matter is that there is no free CF hosting (AFAIK). Erm... http://www.cfdeveloper.co.uk might do

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread RichL
It may do but I have a feeling that this is only being offered to UK based people at the moment but I may be wrong ! On 9/8/06, David Low [EMAIL PROTECTED] wrote: From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 08 September 2006 15:52 To: CF-Talk Subject: Re: Free Coldfusion Hosting

Re: Hosting companies

2006-09-08 Thread Casey Dougall
On 9/8/06, Adkins, Randy [EMAIL PROTECTED] wrote: Hostmysite prices are per domain correct? Unless of course you have a VPS or Dedicated account Correct. No one except myself I guess still use viux.com, I've been with them for a few years with my reseller account and haven't had any real big

Re: Locking Theory

2006-09-08 Thread Tom Kitta
So what happens when a user has made all his or her updates just to be told We are sorry but the record you are trying to edit is locked ... maybe there needs to be a bit more user friendly mechanism there, that would allow informing the user of someone else using the record etc. After all I

RE: Flash Remoting problem

2006-09-08 Thread Kevin Aebig
and C, C++, php and all other ECMA languages. That part of CF really messed me up a few times. I always wondered why they didn't 0 index Coldfusion... !k -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 4:33 PM To:

Re: Locking Theory

2006-09-08 Thread Jochem van Dieten
Claude Schneegans wrote: You had to lock a table to index it? That is soo 80'ies Yeah, after 25 years, the only difference is that the lock is handled automatically by the database engine. Not a big deal ;-) In a current database you can continue to insert, update and delete while you

Re: Hosting companies

2006-09-08 Thread James Holmes
Yeah I'm collecting C3 topics as I go. On 9/8/06, Mingo Hagen [EMAIL PROTECTED] wrote: Another nice C3 topic, James -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
So what happens when a user has made all his or her updates just to be told We are sorry but the record you are trying to edit is locked Actually, this is not the way it works. When a user reads a record for editing, the record is locked until he updates. During that time, when another user

coldfusion.document.DocumentProcessTimeOutException

2006-09-08 Thread Ben Nadel
I am trying to create a PDF via CFDocument. It works fine on the local server, but it crapping out on the live server with the following error: An exception occurred when performing document processing. The cause of this exception was that: coldfusion.document.DocumentProcessTimeOutException: The

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Ali Majdzadeh
Hi: Thanks for the reply. Did u try http://www.hostingatoz.com ?!!! Cause it looks very very cheap. I wonder if it is possible. It offers CCF7 and for 1 year only 8$! How is the service. You know I don't expect a perfect but I need it not to be down all the time or doesn't work fine. Please let

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Charlie Griefer
On 9/8/06, David Low [EMAIL PROTECTED] wrote: From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 08 September 2006 15:52 To: CF-Talk Subject: Re: Free Coldfusion Hosting that lets me connect to MS Access Database well, the fact of the matter is that there is no free CF hosting

RE: Locking Theory

2006-09-08 Thread Dave Watts
How on earth would such a tool work, in a disconnected environment? By keeping the environment connected. A CFX is a dll written in C that can stay resident, keep ODBC connections opened keep user handles in memory, and handle time limits. If the CFX locks a row in the database, CF

Re: Locking Theory

2006-09-08 Thread Tom Kitta
What you are describing would need additional functionality since the updlock with SQL server doesn't prevent data reads occurring when lock is in place. There are about a dozen ways to implement what you suggest and definitely something like that had to be done. I would even add messaging to

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread Charlie Griefer
I signed up for their $69 a year plan. It's CFMX 7 Enterprise and SQL Server 2k5 (not sure about mySQL...but i'm pretty sure it's there). Like you, I didn't expect perfection for that price...just wanted a cheap place to host a personal site. However, early on they exceeded my expectations by

Re: SOT: Ajax, Javascript, and UTC Time

2006-09-08 Thread Rey Bango
Take a look at this Rick to see if this helps: http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt157.htm Rey... Rick Root wrote: So I'm trying to add timestamps to the join/leave announcements in my chat room Coldfusion inserts a UTC timestamp into the database

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
the updlock with SQL server doesn't prevent data reads occurring when lock is in place. Sure, and no one wants to prevent reading during that time. BUT it will certainly prevent another updlock on the same record, thus prevent someone to read it for editing also. --

Re: SOT: Ajax, Javascript, and UTC Time

2006-09-08 Thread Paul Hastings
Rick Root wrote: Coldfusion inserts a UTC timestamp into the database which is returned is the server tz UTC? if notm then i bet you it doesn't ;-) well at least a couple of times a year it doesn't. So the question is... how do I get the browser to consider the timestamp returned to be

Re: Locking Theory

2006-09-08 Thread Claude Schneegans
But the environment isn't connected. It sure is: when I am in MY C program, I can create an ODBC connection to a datasource, and keep that connection open as long as the program is running. And a CFX dll can be kept running in memory as long as the CF server itself is running. From that

RE: Locking Theory

2006-09-08 Thread Dave Watts
I don't see your point here. - race condition is a concurrency problem involving the database, - Concurrency management is handled by the database engine, - SQL is simply a language that can be used to interact with the database, - then, why SQL shouldn't provide tools to help the

Re: CF5 to CFMX (Was: Hosting companies)

2006-09-08 Thread Doug Brown
Well, I have actually found a few that others have mentioned that do still support version 5. I prefer to use version 5 due to the fact that all the bugs have been worked out, and I really do not have the use for java in my applications. I develop for my own personal use versus for others.

Re: Locking Theory

2006-09-08 Thread Jochem van Dieten
Mingo Hagen wrote: That's the kind of stuff more people need to know about. Do you have any tips on good advanced SQL books? (Or should I have seen this in the basic SQL books that are out there and did I just skip this bit.) There are few advanced SQL books that do not focus on one

Re: SOT: Ajax, Javascript, and UTC Time

2006-09-08 Thread Rey Bango
You might also want to take a look at this page: http://www.elated.com/tutorials/programming/javascript/dates/ Search for the phrase About UTC. HTH. Rey... Rick Root wrote: So I'm trying to add timestamps to the join/leave announcements in my chat room Coldfusion inserts a UTC

Re: Locking Theory

2006-09-08 Thread Tom Kitta
Ooops forgot about that ... :) TK - Original Message - From: Claude Schneegans [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 08, 2006 12:03 PM Subject: Re: Locking Theory the updlock with SQL server doesn't prevent data reads occurring when lock is

Using CachedWithin

2006-09-08 Thread Chad McCue
I am trying to use the CachedWithin attribute of my cfquery but will not allow me to do this because I am using cfqueryparam in my Where clause. What is the reason for this? ~| Introducing the Fusion Authority Quarterly

RE: Locking Theory

2006-09-08 Thread Dave Watts
But the environment isn't connected. It sure is: when I am in MY C program, I can create an ODBC connection to a datasource, and keep that connection open as long as the program is running. And a CFX dll can be kept running in memory as long as the CF server itself is running. From that

Re: Locking Theory

2006-09-08 Thread Matt Robertson
On 9/8/06, Claude Schneegans [EMAIL PROTECTED] wrote: the updlock with SQL server doesn't prevent data reads occurring when lock is in place. Sure, and no one wants to prevent reading during that time. BUT it will certainly prevent another updlock on the same record, thus prevent someone

Re: Locking Theory

2006-09-08 Thread Matt Robertson
As an aside, all of what I am saying is meant to apply exclusively to the stateless web environment. When I do client/server stuff I use locks and handle things entirely differently, but that environment is not stateless so I have different tools available. -- [EMAIL PROTECTED] Janitor, MSB Web

SOT: testing: continuous integration

2006-09-08 Thread Michael Traher
I'm looking to set this up. So I will have something to run ANT based build scripts which in turn run a series of cfcunit tests. anthill and cruisecontrol seem to be the two big opensource contenders. Anyone have experience of either/both? or some other method? Cheers! -- Mike T Blog

RE: Using CachedWithin

2006-09-08 Thread Ben Nadel
This is my limited knowledge. The user of queryparam does not allow the prepared sql statement to be statically cached because it does not have a set structure (used to cached the query values). The queryparam makes the statement dynamic. ... Ben Nadel www.bennadel.com

Re: Using CachedWithin

2006-09-08 Thread Jochem van Dieten
Chad McCue wrote: I am trying to use the CachedWithin attribute of my cfquery but will not allow me to do this because I am using cfqueryparam in my Where clause. What is the reason for this? History :) I am sure that if enough people tell Adobe we want to use automatic caching with

RE: Locking Theory

2006-09-08 Thread Mark A Kruger
Jochem, Ok you threw me To summarize what you are saying: FIRST: User A does the following: SELECT * FROM users WHERE username = 'bob' WITH (updlock) Presumably User A is now looking at Bob's information for editing on a web page SECOND: Meanwhile User B runs

Re: another mySql question...

2006-09-08 Thread Dan Plesse
I think Ken means JDBC and I think its just namespace conflict problem with jLog for which a good classloader will resolve and you can not use a pageContext based classloader for this. ODBC is a Microsoft technology for windows only. myODBC is something else altogether. A classloader can put the

Re: Using CachedWithin

2006-09-08 Thread Tom Kitta
Until that time you can just implement you own in memory caching of result set using session/application/server scopes, TK - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 08, 2006 12:29 PM Subject: Re: Using

Re: cfoutput timeout

2006-09-08 Thread Dan Plesse
Try isDirectory() Example cfset java_io_File = CreateObject(java, java.io.File ).init(C:/CFusionMX7/runtime/lib/cfusion.jar) cfset listFiles = java_io_File.listFiles() cfloop from=1 to=#arraylen(java_io_File.listFiles())# index=x cfoutput#listFiles[x].getName()#

OT: Coldfusion based insider trading monitor

2006-09-08 Thread Dan Plesse
I made this insider trading monitor to test out hsqldb with zero pooling based dsnless connection in coldfusion. It's an ugly page and it only returns data if insider holding changes, so you might get a blank page. The interesting thing is how many insiders trade. For example Orchid Cellmark

Re: OT: Coldfusion based insider trading monitor

2006-09-08 Thread Casey Dougall
So, If company emplayees start buying stock than it's good news, if they sell it's bad news? For example Orchid Cellmark went from 0 to 15% insider controlled. Casey ~| Introducing the Fusion Authority Quarterly Update. 80

setting info for an application

2006-09-08 Thread daniel kessler
I have a directory without an application file where there is a form to register for an event. I have a directory within that that has an application file and that's set up to keep out people that aren't logged in because it contains all the reports or other interactions with the database. I

Re: SOT: Ajax, Javascript, and UTC Time

2006-09-08 Thread Rick Root
Paul Hastings wrote: Rick Root wrote: Coldfusion inserts a UTC timestamp into the database which is returned is the server tz UTC? if notm then i bet you it doesn't ;-) well at least a couple of times a year it doesn't. It does when you use dateConvert('local2utc',Now()) Doesn't it?

I18N and money

2006-09-08 Thread Richard Kroll
We have just picked up our first international clients and are beginning down the road of I18N. Initially we were planning to just support locale specific dates and money, which we would store in US dollars and in a US date format within our database. We offer a software solution that is a sales

  1   2   >