Do an if on the word prior to the add or update .... if there then don't do
it

-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 7:18 PM
To: CF-Talk
Subject: Filtering an Insert


Hi,

I'm inserting some values into a DB, but want to exclude a certain word from
being entered.

At the moment, immediately after the Insert Query, I'm running a DELETE FROM
table WHERE field = 'word' which works, but doesn't seem very effecient.

Any pointers would be appreciated.

Will

--
Coming soon: http://www.LocalBounty.com
Local Classified Advertising for the UK

----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to