Community Member Profile

Recent Blog Comments By Will TOmlinson

• Turning On Multiple Statements In ColdFusion 8 MySQL 4/5 Datasource

  Posted on Jul 27, 2009 at 5:43 PM

  Ben, I figured out how to fix it. I simply deleted the existing DSN, then recreated it using the connection setting. That seemed to fix it. Thanks!... read more »

• Turning On Multiple Statements In ColdFusion 8 MySQL 4/5 Datasource

  Posted on Jul 25, 2009 at 9:14 AM

  Ben, this works fine on my production server, but one weird thing I'm running into is it won't work on my development machine. I'm using CF8/MySQl5. I set the connection string just like on production, and it errors out on my multi statement. Weird! Thanks!... read more »

• MySQL 3/4 - com.mysql.jdbc.Driver And allowMultiQueries=true

  Posted on Mar 27, 2009 at 10:58 PM

  The incrementing ID is just for the customer to use. Sometimes they call to inquire about an order. They can give my client the four digit ID instead of some long UUID.... read more »

• MySQL 3/4 - com.mysql.jdbc.Driver And allowMultiQueries=true

  Posted on Mar 27, 2009 at 5:20 PM

  The UUID is used much like an unlock key. You need the UUID in order to do anything with the record. No one can tamper with it because it's nearly impossible to guess someone's UUID.... read more »

• MySQL 3/4 - com.mysql.jdbc.Driver And allowMultiQueries=true

  Posted on Mar 27, 2009 at 3:49 PM

  That's why I use a UUID in another field in the orders table - not as the PK ID. Then I use the UUID in combination with the PK ID, for any viewing, editing, deletions, etc. Now, my customer has a nice, short order ID, and UUID that prevents tampering.... read more »

• MySQL 3/4 - com.mysql.jdbc.Driver And allowMultiQueries=true

  Posted on Mar 27, 2009 at 2:52 PM

  Try using UUID's as order ID's, and you'll have some pissed customers. :)... read more »

• Project HUGE: Adding Caffeine For Health And Performance Benefits

  Posted on Dec 27, 2008 at 8:43 PM

  Coffee worsened my prostate problems, but sticking with Bigelow Green Tea seems to do the trick. I believe it has Querticin in it, which aids prostate health. And yeah, the caffeine gives me a boost at work. :)... read more »

• Learning ColdFusion 8: REMatch() For Regular Expression Matching

  Posted on Jul 3, 2008 at 4:49 PM

  Ben, Will this function work with re lookarounds? Thanks, Will... read more »

• Translate Microsoft SQL (MSSQL) To MySQL

  Posted on Apr 19, 2008 at 4:16 PM

  @david It actually ain't that bad. :) As blogged by Ben himself. http://www.bennadel.com/blog/464-ColdFusion-CFQuery-MaxRows-Not-A-Bad-Compromi... read more »

• Translate Microsoft SQL (MSSQL) To MySQL

  Posted on Apr 18, 2008 at 11:32 PM

  @ Tom, Dan Using maxRows in the cfquery tag itself totally eliminates the need for TOP or LIMIT.... read more »

• Custom User Agents For ColdFusion Debugging

  Posted on Mar 9, 2008 at 12:23 AM

  I never have any bugs so I don't need any tricks. <cough cough> :)... read more »

• ColdFusion POIUtility.cfc Updates And Bug Fixes

  Posted on Jan 24, 2008 at 3:09 PM

  Works fine on CF8 for me..... read more »

• Ask Ben: Uploading Multiple Files Using ColdFusion

  Posted on Jan 8, 2008 at 11:02 PM

  A nice addition for the beginners out there might be to use the result attribute and show'em how it can be used to interact with the db. Great post! Will... read more »

• I Am Legend Starring Will Smith

  Posted on Dec 27, 2007 at 3:13 PM

  I guess ... majestic Colorado as the backdrop makes it worth seeing. just be warned... there's lotsa DRIVING RAIN in the fight scenes. Will... read more »

• I Am Legend Starring Will Smith

  Posted on Dec 27, 2007 at 2:25 PM

  Unfortunately, AVP-R sucks as well. Just saw it last night. You couldn't even tell what was happening because they filmed it in the pouring rain to drowned out details. Oh well....... read more »

• I Am Legend Starring Will Smith

  Posted on Dec 24, 2007 at 9:48 PM

  The previews got me all pumped to see this movie. I have to say I was let down after seeing it. Yeah there were some tense moments, and I gripped my chair during a a few parts, but I never really got INTO it. I was just detached from most of the movie. Next up, Alien VS. Pred... read more »

• ColdFusion Query of Queries: Uses NULL Values, Returns Empty Strings

  Posted on Jul 19, 2007 at 4:50 PM

  Already sent it. Thanks! And I doubt it's a bug. It usually turns out being me. :)... read more »

• ColdFusion Query of Queries: Uses NULL Values, Returns Empty Strings

  Posted on Jul 19, 2007 at 4:43 PM

  Heck, I dunno dude. But a user tried uploading a typical spreadsheet and it bombed out on me. After testing, I noticed my bad data query was building those rows of empty strings. If you upload a different spreadsheet, all is fine. Somethin weird is up with the spreadsheet I gu... read more »

• ColdFusion Query of Queries: Uses NULL Values, Returns Empty Strings

  Posted on Jul 19, 2007 at 4:30 PM

  I think another situation can cause it. I tested a spreadsheet with one row of data. For some reason, it's reading 3 additional rows and spitting out those 3 rows of empty strings in my bad data query. Strange!... read more »

• ColdFusion Query of Queries: Uses NULL Values, Returns Empty Strings

  Posted on Jul 19, 2007 at 1:10 PM

  Ben, I've run into an issue dealing with these empty strings and your POI Utility. I'm building a query in memory of bad data from a spreadsheet. This bad data is basically just columns of empty data. The problem is, my bad data query builds rows of entire empty strings. Then... read more »