CFML duplicate entries

[Guest]

Hello,

I am having trouble, I can't get the CFML to not duplicate the Users in my table. Except the user at the top of my table. but it won’t validate the rest of the users I have on my Database just the one at the top.

<cfquery name="checkusers" datasource="ukgl.co.uk">
SELECT UserName
FROM users
</cfquery>

<cfif #Form.Username# is "#checkusers.Username#"><cfoutput>#Form.Username# is already in use by another User</cfoutput><cfoutput>#checkusers.Username#</cfoutput><cfelse>

! Insert Code !

</cfif>

There’s the code I have.

Any help is greatly appreciated.

Thanks

[Guest]

*bump* someone help ... please

[Newsgroup_User · Accepted solution]

You are grabbing your entire membership list with the query but then not
using a cfoutput hence you are getting only the first record.

Change the SQL statement to

SELECT UserName
FROM users
WHERE UserName = '#Form.Username#'

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Hugh Neale" <webforumsuser@macromedia.com> wrote in message
news:e8bcii$im1$1@forums.macromedia.com...
> Hello,
>
> I am having trouble, I can't get the CFML to not duplicate the Users in my
> table. Except the user at the top of my table. but it won?t validate the
> rest
> of the users I have on my Database just the one at the top.
>
> <cfquery name="checkusers" datasource="ukgl.co.uk">
> SELECT UserName
> FROM users
> </cfquery>
>
> <cfif #Form.Username# is "#checkusers.Username#"><cfoutput>#Form.Username#
> is
> already in use by another
> User</cfoutput><cfoutput>#checkusers.Username#</cfoutput><cfelse>
>
> There?s the code I have so far.
>
> Any help is greatly appreciated.
>
> Thanks
>
>

[Guest]

god im stupid