checking names in a database

[William E Hatto]

Hi all,

I have an asp page that accesses a database. The code below checks to make
sure that a username and their full names do not already exist in the
database. I am relatively new to ADO.

The first group returns an answer, the second code group, when inserted
causes an error.
What is a better alternative to this?

(ps watch wrap)

strSQL = "SELECT UserName FROM tblUser WHERE ((UserName='" & Name & "') AND
(ID<>" & FormID & "))"
MyRS.Open strSQL, MyCN, 3
If MyRS.RecordCount > 0 Then Exist = True: EMode = True

strSQL = "SELECT FullName FROM tblUser WHERE ((FullName='" & FName & "')
AND (ID<>" & FormID & "))"
MyRS.Open strSQL, MyCN, 3
If MyRS.RecordCount > 0 Then Exist = True: EMode = True


Cheers, Bill.

[Ray at]

What error?

How about:

strSQL = "SELECT UserName FROM tblUser WHERE (((UserName='" & Name & "' OR
Fullname='" & FName & "') AND
(ID<>" & FormID & "))"
Set MyRS = MyCN.Execute(strSQL)
EMode = Not MyRS.EOF
MyRS.Close : Set MyRS = Nothing


Not tested!

Ray at work

"William E Hatto" <xxnospamxxweh@bigpond.net.au> wrote in message
news:eZnMEmvIEHA.364@TK2MSFTNGP11.phx.gbl...

> Hi all,
>
> I have an asp page that accesses a database. The code below checks to make
> sure that a username and their full names do not already exist in the
> database. I am relatively new to ADO.
>
> The first group returns an answer, the second code group, when inserted
> causes an error.
> What is a better alternative to this?
>
> (ps watch wrap)
>
> strSQL = "SELECT UserName FROM tblUser WHERE ((UserName='" & Name & "')

AND

> (ID<>" & FormID & "))"
> MyRS.Open strSQL, MyCN, 3
> If MyRS.RecordCount > 0 Then Exist = True: EMode = True
>
> strSQL = "SELECT FullName FROM tblUser WHERE ((FullName='" & FName & "')
> AND (ID<>" & FormID & "))"
> MyRS.Open strSQL, MyCN, 3
> If MyRS.RecordCount > 0 Then Exist = True: EMode = True
>
>
> Cheers, Bill.
>
>

[Ray at]

P.S. Do you really expect to never have two people with the same name?
There are many, many John Smiths in the world. Be careful with how you're
doing this, because you may wind up mixing data together that belong to
different people...

Ray at work

"William E Hatto" <xxnospamxxweh@bigpond.net.au> wrote in message
news:eZnMEmvIEHA.364@TK2MSFTNGP11.phx.gbl...

> Hi all,
>
> I have an asp page that accesses a database. The code below checks to make
> sure that a username and their full names do not already exist in the
> database. I am relatively new to ADO.
>
> The first group returns an answer, the second code group, when inserted
> causes an error.
> What is a better alternative to this?
>
> (ps watch wrap)
>
> strSQL = "SELECT UserName FROM tblUser WHERE ((UserName='" & Name & "')

AND

> (ID<>" & FormID & "))"
> MyRS.Open strSQL, MyCN, 3
> If MyRS.RecordCount > 0 Then Exist = True: EMode = True
>
> strSQL = "SELECT FullName FROM tblUser WHERE ((FullName='" & FName & "')
> AND (ID<>" & FormID & "))"
> MyRS.Open strSQL, MyCN, 3
> If MyRS.RecordCount > 0 Then Exist = True: EMode = True
>
>
> Cheers, Bill.
>
>

[Jeff Cochran]

On Thu, 15 Apr 2004 22:53:50 +0800, "William E Hatto"
<xxnospamxxweh@bigpond.net.au> wrote:

>Hi all,
>
>I have an asp page that accesses a database. The code below checks to make
>sure that a username and their full names do not already exist in the
>database. I am relatively new to ADO.
>
>The first group returns an answer, the second code group, when inserted
>causes an error.

And the error is...?

Jeff

>What is a better alternative to this?
>
>(ps watch wrap)
>
> strSQL = "SELECT UserName FROM tblUser WHERE ((UserName='" & Name & "') AND
>(ID<>" & FormID & "))"
> MyRS.Open strSQL, MyCN, 3
> If MyRS.RecordCount > 0 Then Exist = True: EMode = True
>
> strSQL = "SELECT FullName FROM tblUser WHERE ((FullName='" & FName & "')
>AND (ID<>" & FormID & "))"
> MyRS.Open strSQL, MyCN, 3
> If MyRS.RecordCount > 0 Then Exist = True: EMode = True
>
>
>Cheers, Bill.
>

[+FarmerPickles]

I am thinking that the only time i would check for a duplicate name, is if
this was something that someone created a user name.. ie: nickname
FP

"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:407eb3f1.12290002@msnews.microsoft.com...

> On Thu, 15 Apr 2004 22:53:50 +0800, "William E Hatto"
> <xxnospamxxweh@bigpond.net.au> wrote:
>

> >Hi all,
> >
> >I have an asp page that accesses a database. The code below checks to

make

> >sure that a username and their full names do not already exist in the
> >database. I am relatively new to ADO.
> >
> >The first group returns an answer, the second code group, when inserted
> >causes an error.

>
> And the error is...?
>
> Jeff
>

> >What is a better alternative to this?
> >
> >(ps watch wrap)
> >
> > strSQL = "SELECT UserName FROM tblUser WHERE ((UserName='" & Name & "')

AND

> >(ID<>" & FormID & "))"
> > MyRS.Open strSQL, MyCN, 3
> > If MyRS.RecordCount > 0 Then Exist = True: EMode = True
> >
> > strSQL = "SELECT FullName FROM tblUser WHERE ((FullName='" & FName & "')
> >AND (ID<>" & FormID & "))"
> > MyRS.Open strSQL, MyCN, 3
> > If MyRS.RecordCount > 0 Then Exist = True: EMode = True
> >
> >
> >Cheers, Bill.
> >

>