OK cheers Craig.
Will
----- Original Message -----
From: "Craig Newitt" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Thursday, October 19, 2000 11:24 AM
Subject: RE: Filtering an Insert
> 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/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
