something like
<cftranaction>
<cfquery>
Insert into Table
</cfquery>
<cfquery>
SELECT MAX(id) FROM Table
</cfquery>
</cftransation>
> ugh..that's right...i was hoping i could limit it within a single query
> field
Not sure what you mean
HTH J
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.