The following new message has been posted on Phorm Support Forum at <http://www.phorm.com/support/>. *************************************************************************** MESSAGE: (#4209) Re: More stupid questions ... Now it's MySQL EXIST <http://www.phorm.com/support/?rev=4209> AUTHOR: Holotech DATE: July 26, 2004 at 8:06 a.m. EST Reply To: (#4201) More stupid questions ... Now it's MySQL EXISTS Author: Richard Prisco Date: July 22, 2004 at 7:27 p.m. EST > Now if i take this out of rules.txt, the dbase updates > the data perfectly to MySQL. But I want to check if > there is another user using that same name the new > user is trying to use. I know there is not another and > it's not letting the rule pass. You want the UNIQUE criterion. EXISTS checks that the entry *does* exist; UNIQUE checks that it *doesn't*. *************************************************************************** This is an automatically-generated notice. If you'd like to be removed from the mailing list, please visit Phorm Support Forum at <http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx If you wish to respond to this message, please post your response directly to the board. Thank you! ------------------------------------------------- You are receiving this message because you are subscribed to the Phorm mailing list. To send messages to the mailing list, simply send email to phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe from the list by sending email to phorm-request@xxxxxxxxxxxxx with 'unsubscribe' in the SUBJECT field.