[thelist] CF: Query naming tip

[Frank]

<tip type="Cold Fusion" Author="Frank Marion">

Including a field name in a query's name will cause an exception.

Example:

    <cfquery name="GetFirstName" datasource="#datasource#">
       SELECT FirstName, LastName, PhoneNumber
       FROM AddressBook
       WHERE 1=1
       </cfquery>

The query title 'GetAName' would correct the problem.

</tip>
-- 

Where there's a will, there's a way.

Frank Marion                      Loofah Communications
frank at loofahcom.com               http://www.loofahcom.com