Q & A, by Bruce Van Horn
Volume 3, Issue 6

Listing 1
<CFOUTPUT>
       <A HREF="index.cfm?#Session.URLToken#">Home Page</A><BR>
       <A HREF="index.cfm?CFID=#Session.CFID#&CFTOKEN=#Session.
  CFTOKEN#">Home Page</A>
</CFOUTPUT>


<b>Listing 2</b>
<CFOUTPUT>
       <FORM ACTION="form_action.cfm?#Session.URLToken#"
  METHOD="post">
</CFOUTPUT>


Listing 3
<CFQUERY DATASOURCE="Coffee_Valley">
         INSERT INTO Beans (Bean_Name,Bean_Description)
         VALUES ('#Form.Bean_Name#','#Form.Bean_Description#')
</CFQUERY>
<CFQUERY NAME="qNewID" DATASOURCE="Coffee_Valley">
         SELECT MAX(Bean_ID) AS NewID
         FROM   Beans
</CFQUERY>


Listing 4
<CFLOCK TIMEOUT="10" NAME="AddNewBean" TYPE="EXCLUSIVE">
       <CFQUERY DATASOURCE="Coffee_Valley">
               INSERT INTO Beans (Bean_Name,Bean_Description)
               VALUES ('#Form.Bean_Name#','#Form.Bean_Description#')
       </CFQUERY>
       <CFQUERY NAME="qNewID" DATASOURCE="Coffee_Valley">
                     SELECT MAX(Bean_ID) AS NewID
               FROM   Beans
       </CFQUERY>
</CFLOCK>


Listing 5
<CFSET UUID = CreateUUID()>


<CFQUERY DATASOURCE="Coffee_Valley">
       INSERT INTO Beans (Bean_Name,Bean_Description,UUID)
       VALUES   ('#Form.Bean_Name#','#Form.Bean_Description#',
'#Variables.UUID#')
</CFQUERY>
<CFQUERY NAME="qNewID" DATASOURCE="Coffee_Valley">
       SELECT Bean_ID
       WHERE  UUID = '#Variables.UUID#'
       FROM   Beans
</CFQUERY>