Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Using JavaScript to check field entry against database


Message #1 by "Mitten" <mittenshah@h...> on Wed, 15 Aug 2001 17:54:28
Hello everyone, I have a form in which the users have to enter an latexID  

on a web page, now what i want to do is that, if a user enters an ID that 

already exists in the database, then i want a message displayed 

saying "This ID already exists -please re-enter". Here is part of my code, 

could you tell me where i could insert the Javascript code.



Set objComm1 = Server.CreateObject("ADODB.Command")



objComm1.ActiveConnection = strConnect

objComm1.CommandText = "qryArticle1"

objComm1.CommandType= adCmdStoredProc



Set objParam1 = _

objComm1.CreateParameter("latexID",adVarChar,adParamInput,50)

objComm1.Parameters.Append objParam1



strlatexID = Request.Form("latexID")

objComm1.Parameters("latexID") = strlatexID



Set objRS1 = objComm1.Execute

Set objComm1 = Nothing

Set objParam1 = Nothing





Thanks



Mitten


  Return to Index