Users who certification go up in smoke. This is what I changed the code plots verify whether the user name, I called the database "data.mdb" Field called "u_id", but I put page which is not, help us to see, thank you <% Name = request ( "u_id") Sgl = "select * from member where [u_id]= '" &u_id& "'" Rs.open sgl, conn,1,3 If not (rs.bof and rs.EOF) then Response.Write ( "" SCRIPT language=JavaScript>alert ( 'the users who had registered'); ") Response.Write ( "javascript:history.go (1)" /SCRIPT> ") Rs.close Set rs=nothing End if Rs.addnew () Rs ＝ ( "u_id") = u_id Rs.update () Rs.close Set rs ＝ = nothing %>

[html]<% Name = request ( "u_id") Sgl = "select * from member where u_id= '" &u_id& "'" Rs.open sgl, conn,1,3 If not (rs.bof and rs.eof) then Response.Write ( "" SCRIPT language=JavaScript>alert ( 'the users who had registered'); " Response.Write ( "javascript:history.go (1)" /SCRIPT> " End if Rs.addnew () Rs ＝ ( "u_id") = u_id Rs.update () Rs.close Set rs ＝ = nothing %>[/html]

This code Lane rs ＝ What does this mean? Rs.open sgl, conn,1,3 //conn behind 1,3 do not quite understand the meaning given to explain this code? Thank you

Response.end response.write two sentences after the sentence must be coupled with, or will be implemented at all.

I changed after I suggested : Microsoft VBScript operational error mistake '800a01a8' Lack of targets : 'rs ＝' /03ds/regist_do.asp, 143 firms This is why

You response.end rs=nothing increase in the first set after incorrect.

You have no [code]set rs=server.createobject ( "adodb.recordset") [/code] sentence Rs ＝ targeted so there is no lack of targets rs ＝ We are operating normally do ms access [code] <% Set cn=server.createobject ( "adodb.connection") Cn.open "provider=microsoft.jet.oledb.4.0;data source=" &server.mappath ( "data.mdb") Set rs=server.createobject ( "adodb.recordset") 'object creation connecton Name = request ( "u_id") Sgl = "select * from member where u_id= '" &u_id& "'" 'SQL Rs.open sgl, cn,1,3 * SQL implementation of the above parameters 1,1 representative reading; Representative parameters 1,3 revised record If not (rs.bof and rs.eof) then Response.Write ( "" SCRIPT language=JavaScript>alert ( 'the users who had registered'); " Response.Write ( "javascript:history.go (1)" /SCRIPT> " Reponse.end End if Rs.addnew () Rs ＝ ( "u_id") = u_id Rs.update () Rs.close Set rs ＝ = nothing Cn.close Set cn=nothing %> [/code]

I suggested that after the correction, not the database, look this way, thank you Microsoft JET Database Engine error '80040e21' Required to set up its true nature (True), Fields' users.u_id 'not contain Null values. A numerical input in this field. /03ds/regist_do.asp, 154 firms

Name = request ( "u_id") Sgl = "select * from member where [u_id]= '" &u_id& "'" ---------------------------------------------------------------------------- Name = request ( "u_id" Sgl = "select * from member where [u_id]= '" &name& "'"

Or not, please give pointers! !

What?

Estimate your question is not recorded in the database, if there is no record, then you say the problem

I have a database record ah

Look at the help

Look at the help

<% Name = request ( "u_id") Set rs=server.createobject ( "adodb.connection") Sgl = "select * from member where u_id= '" &u_id& "'" Rs.open sgl, conn,1,3 If not (rs.bof and rs.EOF) then Response.Write ( "" SCRIPT language=JavaScript>alert ( 'the users who had registered'); ") Response.Write ( "javascript:history.go (1)" /SCRIPT> ") Response.end Else Rs.addnew () Rs ＝ ( "u_id") = u_id Rs.update () Rs.close Set rs ＝ = nothing %> PS : If you U_id Secretary of the above SQL is used for character, and used the following phrase : Sgl = "select * from member where u_id=" &u_id

[ Closed window ]