<% uid=request( "uid ") pwd=REQUEST( "pwd ") uname=REQUEST( "uname ") xb=REQUEST( "xb ") sfz=REQUEST( "sfz ") email=REQUEST( "email ") tel=REQUEST( "tel ") tishi=REQUEST( "tishi ") tsda=REQUEST( "tsda ")
set rs=conn.execute( "select * from puser where uid= ' "& uid & " ' ") if rs.eof then sql= "insert into puser(uid,pwd,uname,xb,sfz,email,tel,tishi,tsda) v alues ( ' "& uid & " ', ' "& pwd & " ', ' "& uname & " ', ' "& xb & " ', ' "& sfz & " ', ' "& email & " ', ' "& tel & " ', ' "& tishi & " ', ' "& tsda & " ') " & Chr(13) & "insert into huiyuan(mingzi,mima) v alues ( ' "& uid & " ', ' "& pwd & " ') " conn.execute(sql) Response.Write " <script language=J avascript> " Response.Write "alert( " "恭喜!您已注册成功!请进行登陆! " "); " Response.Write "window.location= 'index.asp ' " Response.Write " <script> " else Response.Write " <script language=J avascript> " Response.Write "alert( " "对不起!此用户名已经存在,请更换用户名再进行注册! " "); " Response.Write "window.history.go(-1); " Response.Write " <script> " end if %> 这样试试吧。
set rs=conn.execute( "select * from puser where uid= ' "& uid & " ' ") if rs.eof then sql= "insert into puser(uid,pwd,uname,xb,sfz,email,tel,tishi,tsda) v alues ( ' "& uid & " ', ' "& pwd & " ', ' "& uname & " ', ' "& xb & " ', ' "& sfz & " ', ' "& email & " ', ' "& tel & " ', ' "& tishi & " ', ' "& tsda & " ') " & Chr(13) & "insert into huiyuan(mingzi,mima) v alues ( ' "& uid & " ', ' "& pwd & " ') " conn.execute(sql) Response.Write " <script language=J avascript> " Response.Write "alert( " "恭喜!您已注册成功!请进行登陆! " "); " Response.Write "window.location= 'index.asp ' " Response.Write " <script> " else Response.Write " <script language=J avascript> " Response.Write "alert( " "对不起!此用户名已经存在,请更换用户名再进行注册! " "); " Response.Write "window.history.go(-1); " Response.Write " <script> " end if %> 这样试试吧。
解决方案 »
- 在c#中teechart如何完成柱形图的绘制方法,X坐标由自己定义,应如何定义,如何实现打印功能?
- 怎么绑定radio到页面
- repeater 表头固定数据上下滚动+拖动改变列宽
- 一个很奇怪的现像kls=document.getElementById("imgsdaohan").getElementsByTagName("img");必须alert才有值:
- [玻璃鱼V]关于"验证视图状态 MAC 失败"的问题
- 学习页面布局,希望大家给点学习意见,来者有分!
- asp.net饼状图形控件
- 动态添加Gridview中的行,回发后消失了,要如何保持?(类似viewstate)
- ie9.0浏览器中下拉框没有了
- 我用vs.net写asp.net程序,如何在服务器控件按钮的点击事件里使用messagebox或者alert函数?
- 用JS获得2个或以上的参数的函数
- 服务器 把文字 tts变成 发音传给客户端
错误类型:
Microsoft JET Database Engine (0x80040E14)
SQL 语句的结束位置缺少分号 (;)。
/飞飞/zccg.asp, 第 15 行
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/飞飞/zccg.asp, line 15, column 17
conn.execute(sql);
----------------^