Becky, this is what i do. the user submits their info and i do a check in
the database on the processing page for the info they have just submitted.
if it exists, i CFINCLUDE the previous page but display error messages as
needed and pre-populate the fields they have filled out. if they don't
exist, then i process the next query which adds them to the DB and then
displays a confirmation. all you need is an if/else block where you check
the record count of the select based on username/email/whatever. HTH.
david
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:27 PM
To: CF-Talk
Subject: validation
i want to have a form where i can insert a new user into my database. and i
have that form but i want to be able to validate it before it submits this
new user into my database. i want to check to make sure the person doesnt
already exist. (it wont be me entering the data, so i dont want to have user
input errors if they dont search thru the drop down list before adding a new
person...resulting in duplicate people).
someone told me to look thru the custom tags and i did...but i really dont
see what i am looking for.
can anyone give me any ideas or some direction?
thanks for all your help,
bec.
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
