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)....

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.

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:

In SQL Server (7, 2000+):

In Oracle:

(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:)

In PostreSQL

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]