You are the Man!! This is what I have searched the doc the last 4 hours for!!!
Kevin
----- Original Message -----
<cfquery name="checkforrecord" datasource="....">
SELECT ID
FROM MyTable
WHERE Field = mycriteria
</cfquery>
<cfif checkforrecord.recordcount IS 0>
<!--- Insert a record here--->
<cfelse>
<!--- update a record here or ignore the insert request --->
</cfif>
Paul
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]