[thelist] Doh! question for MySQL

[walker]

Thanks Rudy,

I was hoping there was another way to do it, without having to query the 
table beforehand to find out the max row number of the table.

back to work. Do I owe a tip for this? I'll give one anyway.

<tip type="cold fusion & saved queries" author="walker">
If you have queries that should only be run once, and don't change for all 
users in your application (like a query that pulls the states for your 
contact form drop down list) - then save the entire query as an application 
variable....

For example:
in your application.cfm

(initialize the application variable)
<cfparam name="application.initialize" default="0">

(this is to make sure the query only runs once)
<cfif application.initialize is 0>

         (here is the query)
         <cfquery name="get_states" datasource="yourdb">
         select * from states
         </cfquery>

         (save the query)
         <cfset application.states=get_states>

         <cfset application.initialize=1>
</cfif>

then in your contact form (or elsewhere):

<select class="formbody" name="state">
<cfoutput query=application.states>
<option value=#state_id#>#state_name#</option> (where state_id and 
state_name are columns in the states table)
</cfoutput>
</select>


This also works with session variables - if you want to save all of the 
information about a user, etc....

For example, after a login has been validated:

         (here is the query)
         <cfquery name="get_user_info" datasource="yourdb">
         select * from users where user_id=#user_id#
         </cfquery>

         (save the query)
         <cfset session.user=get_user_info>

and then in your application:

You are logged in as: #session.user.username# (username can be swapped with 
any other column in the users table)

</tip>

_________________________________________
walker fenton
walker at sdproductions.com
303.722.5473