RE: NEED a web page to check username!!!

rkm ( rkm@marshall.net )
Thu, 12 Feb 1998 17:40:58 -0500

Gee Dale... I didn't realize you worked so cheap! Let me look here at my
TO-DO list..... Tell the boss (or your partners) that you need a raise.
That's SUPPORT!

<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