The Honey House Buzz - Databases

Goodby CFUnited, Perhaps next year

Sat, 07 Aug 2010 17:36:00 -0600

I have planned unsuccessfully to get to CFUnited. But the for last 6+ years, other obligations have interfered for that week..... So, I get my oxes out of the ditch (which included a funeral, a few surgeries to repair cycling injuries, mom-in-law getting 2 hip replacements...you get the picture) to clear July-August 2011 to attend Next Year -- 2011... (sigh) My friend Gene Godsey broke that news to me, no next year.... (sigh). So Here's My VOTE: Have it somewhere, somehow, someway and Honey House Web Designs WILL be there! PLease, please (please)....

Coldfusion Support Help -- Ongoing support & Maintenance

Fri, 27 Jun 2008 08:33:00 -0600

HHWD is turning over the reins of a project to a new developer to provide onging development and support of a large international website project (entertainment based). The client has immediate needs and prefers a male developer, readily available for future project development. If you are well versed in Coldfusion 8, CFIMAGE & CFCs Project Seven MySQL 5 SoThink DHTML menu Paypal Processing CSS based design Please contact HHWD at 803-648-8556 or email us at hhd - at - honeyhousedesigns (you know the schpeal). HHWD will assist in providing turnover of the project and provide the new developer with any technical questions regarding design and development. The new developer will become the primary contact with the client and will NOT be in a sub-contract relationship. The pay is nice, the project in very interesting. It simply no longer fits our business model for projects.

Select Random Records in MySQl, SQL Server & Oracle, etc

Thu, 24 Jan 2008 09:02:00 -0600

Quite often a user will want a random display of items from his database. Ads, Thumbnails, Topics... whatever.... Here are some quick queries that can perform just that task for you: Scenario: I want to select 5 records from my famous-foo table in no particular order, and I have no idea how many records are there.... In MySQL:


select * from famous-foo order by rand() limit 5

In SQL Server (7, 2000+):


select top 5 * from famous-foo order by newid()

In Oracle:


select * from famous-foo sample(5)

(note this returns 5% of records, so you'll have to handle potentially extra records in your code, but is a tad quicker than creating an inline view as below:)


select * from (select * from famous-foo order by dbms_random.value) where rownum = 5

In PostreSQL


select * from famous-foo order by random() limit 5

Beware maintaining Customer Balance Information in Coldfusion's Traditional Sessions

Wed, 24 Oct 2007 09:54:00 -0600

If you are working with logged in users, Coldfusion has an excellent method of maintaining client information in session variables. Typically, However, beware of session independence between different types of browsers when using traditional ColdFusion session variables (CFID & CFSESSION). When a session variable is updated in one browser, it is not automatically in other browsers. While not a big deal if the variable doesn't change much, such as the user's email or name, or even ID number. On the other hand, if the variable contains information that would be business critical or updated frequently, such as account balances, or time logged, using CF 'vanilla' session variables (where the session ID are determined by CF administrator) may not be the proper place to store the information to be relied upon. If a user uses two computers both logged in at the same time, or two different user log in with the same account information simultaneously, we already realize that frequently updated information may lag and not reflect actual values due to activity in the different sessions updating the session variables without regard to the other session. This same phenomena occurs [More]

Converting CF Queries from MS SQL to MySQL

Tue, 07 Aug 2007 19:29:00 -0600

MySQL has really come along as a database product from when I first began working with it over 10 years ago. It is so good, that HHWD now recommends using it for most new client database applications. We have even migrated some older MS SQL database applications that didn't really need all the beef MSSQL offered (and weren't thrilled with the extra hosting cost). One of the best product to migrate from one db to another is MySQL's own MySQL Migration Tool . This does a great job of transferring over table structures and data, with only nominal updating of Views, and some keys. However, what do you do when you have the database successfully migrated and in your CF Administrator but still have many select statements that are MSSQL compliant, but not MySQL? Here is a list of quick search/replaces that can be performed on your CFCs and queries that should get your Coldfusion app running successfully with your new MySQL database: For All < cfquery> select...< /cfquery> Simple Find & Replace:
MSSQL's Getdate() is MySQL's curdate() (or now() )
Newid() is rand()
Len() is length() (NOT to be confused with CFMX len() function, this is only a database query 'length') Table Structure:
Money datatype is decimal (9,2)
Bit datatype needs to be changed. HHWD uses TINYINT Other items:
Select TOP n * from table is now
select * from table LIMIT n Be aware that Multiple timestamp fields in the same table also do not get automatically 'stamped' in MySQL. You may have to manually save a timestamp in your query Also some correlated subqueries will not behave the same, so be sure to test them out in MySQL