Create a form that has a text field called "name" and then
call a file with this in it (you'll need to add contents around it).
<CFQUERY NAME="CheckName" DATASOURCE="Emerald">
SELECT Login From SubAccounts Where Login='#Form.Name#' or Shell='#Form.Name#'
</CFQUERY>
<CFOUTPUT>
<h2>User #Form.Name#
<CFIF #CheckName.RecordCount# IS 0>
Available.
<CFELSE>
Not Available. Please Select Another
</CFIF>
</H2>
</CFOUTPUT>
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com