<g>
Richard Marshall
http://www.marshall.net
-----Original Message-----
From: Dale E. Reed Jr. [SMTP:daler@iea-software.com]
Sent: Thursday, February 12, 1998 3:56 PM
To: ntisp@emerald.iea.com
Subject: Re: NEED a web page to check username!!!
John Lange wrote:
>
> I have absolutely "NO" ability to write this and am begging some one to
do
> this for me....
>
> I need a web page that people can check to see if a username is being
used
> on our Emerald server. It "HAS" to run on NT and WebSite Pro 1.1h with
> perl or CF or something.
>
> All it has to do is check to see if a visitor name entered is already in
> use and return a friendly answer.
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---------------------------------------------------------- NTISP Mailing List listserver@emerald.iea.com