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]
