Recent content by Kendo

Yeah - I'd love to have MSDE or SQL Server. Or MySQL. But really, my only option is Access. Thanks!

Thank you for your response, MG. As with all ColdFusion programmers who are stuck using Access, it's always frustrating. But that's the problem - I don't have the budget to go for anything else. :( Thanks for your answer on the queueing front...at least I know that if I go for that option I...

Hi all, I'm using Access on what will potentially be a very busy site. I have previously had problems with using Access on a busy site and the DB locking up. I've looked all over and I'm yet to see any discussion of this, even though a lot of people know of this common Access problem. Am I...

Sorry to have perhaps given you the wrong impression. From my reading I've found that OLE-DB is not a faster way of conncting to an Access database, but it is more a debate of connectivity and scalability. Macromedia's article suggests exactly this...

Microsoft and Macromedia both agree that Access is not a particularly good database to use for web applications...especially for high-use sites. They also both agree that if you're forced to use Access (like most of us are), OLE-DB is at least better to use than ODBC with Access databases. My...

Hi y'all, About 6 months ago I was a hosting a site that started to pick up a fair amount of traffic...not too hot, maybe 500 visitors / day. However, the Access database I'm using seemed to randomly 'lock up' giving the error (I'm paraphrasing from memory): "too many client tasks&quot...

You can append a URL variable called requesttimeout to your query string, eg. http://www.test.com/file.cfm?requesttimeout=120 There is a limit, which I can't remember off the top of my head, but it's large enough to not worry about. Kendo.

The best way to do it is to make a temporary coldfusion file that tries to select data from a table that doesn't exist... <cfquery name=&quot;temp&quot; datasource=&quot;[Your datasource]&quot;> SELECT nothing FROM none </cfquery> Upload this file to your live server, and view it. The .ldb...

Just wondering how other people get around pulling out random entries from a database. This is how I'm currently doing it (but it has a major flaw (for my purposes), which I'll mention later...) : For example, we'll use tblNews and NewsID 1/ Query DB to get NewsIDs from tblNews 2/ Loop through...

The problem with your suggestion of using the application.cfm for a 404 is that, since there is a 404, no page is being loaded. And therefore, application.cfm will not be loaded. If that makes sense. Since application.cfm prepends any .cfm file, since no .cfm is being accessed in the first...

I've heard from numerous sources that CFMAIL is not good for batch emailing. Don't get me wrong, I trust those sources...:D However, I would like to know what the basic limitation is on CFMAIL. Say I have a mailing list of 1000 users, would it be a bad thing to try to send them all at once? Or...

Hi all, Ugh! Regular expressions...no matter how many people say &quot;Oh, they're okay once you get used to them...&quot; I can't seem to get used to them. To be honest, I'm struggling to find any CF based tutorials. Basically what I want to do is replace content between two quotation marks...

Okay then, well in that case, how fast is PHP at reading from a text file? Perhaps I could just drop what I need in a text file and have it read on every page? Not ideal perhaps, but a possibility. I would assume for something simple that storing it in a text file would be quicker than storing...

PHP Newbie. Sorry. Application variables are available in ColdFusion and I think ASP too...is there an equivalent in PHP? In case you're not familiar with these types of variables, or possibly just not familiar with 'application' as a scope name for them, I'll describe what I need: I need a...

Ah...suddenly it all becomes clear. Right...I suppose I was hoping to avoid making an extra database hit on each page, but I suppose it won't really make an noticeable difference. It adds another layer of security too, to not only check that $sessionID exists and has a value, but also to check...