ASP & ADO



ASP & ADO

I have a msaccess database with following fields & datatype

ID AutoNumber
Name Text(100)
PWD OLE Data -- This is to Protect password field.

im using two routines ( in ASP)

1) to find the name exists --
2) add new user -- using INSERT INTO to input data into
table

:::sample code:::

if userfound(xyz)=no
'open ado connection
' insert data
else
'show error [User Found]
end if

Problem:
When i execute the code, new user is getting added into table,
simultaneously [user found] error popping up.
how to control this.


Thanks


.



Relevant Pages

  • Re: Connection from ASP- ODBC vs. SQLOLEDB
    ... The ASP code is already using ADO (adodb.connection, ... The new provider is better than ODBC isn't it, ... SQL Server Client Network Utility- "Enable Shared Memory": ... ASP, ASP.NET as well as Microsoft Content Management Server 2002 SP1a. ...
    (microsoft.public.sqlserver.server)
  • Re: default values for Oracle stored procedure
    ... When the parameter isn't define in the asp page, an error message ... The names used in the parameters collection in ADO are not the ...
    (microsoft.public.data.ado)
  • Re: default values for Oracle stored procedure
    ... When the parameter isn't define in the asp page, an error message ... The names used in the parameters collection in ADO are not the actual names ...
    (microsoft.public.data.ado)
  • Re: auf Access-mdb im Internet zugreifen
    ... ASP Seiten erstellen, die deine "Kommandos" aus der lokalen Anwendung ... per ADO auf die mdb Datei zugreifen. ... des Users deiner Anwendung. ...
    (microsoft.public.de.vb.datenbank)
  • Re: Which wireless database software for Pocket PC ?
    ... If I get the ADO part working and split ... or do I need to write ASP code? ... It has some terrible reviews but I don't know if the reviews are ...
    (microsoft.public.pocketpc.wireless)