| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 672 人关注过本帖
标题:第5句错误?insert 哪错了?
只看楼主 加入收藏
cmd2007
Rank: 1
等 级:新手上路
帖 子:55
专家分:0
注 册:2006-12-20
收藏
 问题点数:0 回复次数:2 
第5句错误?insert 哪错了?
<!--#include file="conn.asp"-->
<%
aa=request.form("aa")
bb=request.form("bb")
exec="insert into test(aa,bb)values("+aa+",'"+bb+"')"
conn.execute exec
conn.close
set conn=nothing
response.redirect "list.asp"
%>

[[it] 本帖最后由 cmd2007 于 2008-4-16 14:32 编辑 [/it]]
搜索更多相关主题的帖子: insert 
2008-04-15 21:55
不惑
Rank: 2
等 级:论坛游民
威 望:2
帖 子:569
专家分:13
注 册:2007-3-22
收藏
得分:0 
使用JS可以实现。去JS问吧
2008-04-15 23:30
不惑
Rank: 2
等 级:论坛游民
威 望:2
帖 子:569
专家分:13
注 册:2007-3-22
收藏
得分:0 
<script language="JavaScript">
<!--
<!--
function statusMessageObject(p,d) {
  this.msg = MESSAGE
  this.out = " "
  this.pos = POSITION
  this.delay = DELAY
  this.i     = 0
  this.reset = clearMessage
}
function clearMessage() {
  this.pos = POSITION
}
var POSITION = 300
var DELAY    = 50
 var MESSAGE  = "*奇豪门业欢迎您!*                                     "
var scroll = new statusMessageObject()
function scroller() {
  for (scroll.i = 0; scroll.i < scroll.pos; scroll.i++) {
    scroll.out += " "
  }
  if (scroll.pos >= 0)
   scroll.out += scroll.msg
  else scroll.out = scroll.msg.substring(-scroll.pos,scroll.msg.length)
  window.status = scroll.out
  scroll.out = " "
  scroll.pos--
  if (scroll.pos < -(scroll.msg.length)) {
   scroll.reset()
  }
  setTimeout ('scroller()',scroll.delay)
}
function snapIn(jumpSpaces,position) {
  var msg = scroll.msg
  var out = ""
  for (var i=0; i<position; i++)
    {out += msg.charAt(i)}
  for (i=1;i<jumpSpaces;i++)
    {out += " "}
  out += msg.charAt(position)
  window.status = out
  if (jumpSpaces <= 1) {
    position++
    if (msg.charAt(position) == ' ')
      {position++ }
    jumpSpaces = 100-position
  } else if (jumpSpaces >  3)
       {jumpSpaces *= .75}
  else
    {jumpSpaces--}
  if (position != msg.length) {
    var cmd = "snapIn(" + jumpSpaces + "," + position + ")";
    scrollID = window.setTimeout(cmd,scroll.delay);
  } else {
    window.status=""
    jumpSpaces=0
    position=0
    cmd = "snapIn(" + jumpSpaces + "," + position + ")";
    scrollID = window.setTimeout(cmd,scroll.delay);
    return false
  }
  return true
}
snapIn(100,0);
// -->
</script><meta http-equiv=Content-Type content="text/html; charset=gb2312">

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
<!--

if (window.Event)
  document.captureEvents(Event.MOUSEUP);

function nocontextmenu()
{
event.cancelBubble = true
event.returnValue = false;

return false;
}

function norightclick(e)
{
if (window.Event)
{
  if (e.which == 2 || e.which == 3)
   return false;
}
else
  if (event.button == 2 || event.button == 3)
  {
   event.cancelBubble = true
   event.returnValue = false;
   return false;
  }

}

document.oncontextmenu = nocontextmenu;  // for IE5+
document.onmousedown = norightclick;  // for all others
//-->
</script>
<style type="text/css">
<!--
.unnamed5 {
    font-size: 12px;
    line-height: 150%;
    color: #cc6699;
}
-->
</style>

<meta name="keywords" content="奇豪集团|奇豪|奇豪集团|奇豪">
<meta name="description" content="奇豪集团|奇豪|奇豪集团|奇豪">
<style type="text/css">
<!--
body {
    margin-left: 0px;
    margin-top: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
    background-image: url();
    background-color: #FFFFFF;
}
-->
</style>
<script language="JavaScript">
function openwindow(url,name,h,w,t,l)
{
window.open(url,name,'height='+h+',scrollbars=yes,width='+w+',top='+t+',left='+l);
}
</script>
<SCRIPT LANGUAGE="JavaScript" src="flash_script.js"></SCRIPT>
<title>奇豪门业</title>
<link href="1.css" rel="stylesheet" type="text/css">
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="585" height="77"><img src="top_02.jpg" width="485" height="63" /></td>
    <td width="191"><a href="default.asp">首 页</a>&nbsp; |&nbsp;&nbsp;<a href="default.asp">中文版</a>&nbsp; | &nbsp;<a href="default.asp"><span class="style1">ENGLISH</span></a> </td>
  </tr>
</table>
<table width="776" height="232" border="0" align="center" cellpadding="0" cellspacing="0" background="top1_03.jpg">
  <tr>
    <td valign="top">
    <script language="JavaScript" type="text/javascript">
    <!--
var ff = diplayFlash("top.swf","","630","68","high","transparent","","","");
documentWrite(ff);
//-->
</script><script language="JavaScript" type="text/javascript">
    <!--
var ff = diplayFlash("21[1].swf","","776","168","high","transparent","","","");
documentWrite(ff);
//-->
</script></td>
  </tr>
</table>
<table width="776" height="28" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="7"><img src="../images/top1_05.jpg" width="7" height="29"></td>
    <td background="../images/top1_07.jpg" width="760"><table width="760" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td align="center"> <a href=wddd.asp>我的订单</a> | <a href=tjdd.asp>添加订单</a> | <a href=fwsq.asp>服务申请</a> | <a href=ts.asp>投诉</a> | <a href=xxck.asp>反馈信息</a> | <a href=cxsq.asp>促销申请</a> | <a href=jxgl.asp>进销管理</a> | <a href=yhxg.asp>用户修改</a></td>
      </tr>
    </table></td>
    <td width="9"><img src="../images/top1_09.jpg" width="9" height="29"></td>
  </tr>
</table>

<link rel="stylesheet" href="../images/jck.css" type="text/css">
<meta http-equiv="Content-Language" content="gb2312">
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<script type="text/javascript" src="../images/calendar.js"></script>
<script language="javascript">var CalendarWebControl = new atCalendarControl();</script>

<SCRIPT language=JavaScript>
<!--
   function check()
   {
     if (form1.cpbm1.value!="")
     {
      if (form1.dhsl1.value =="")
      {
          alert("您需要多少数量?");
          form1.dhsl1.focus();
          return false;
      }
     }
     if (form1.cpbm2.value!="")
     {
      if (form1.dhsl2.value =="")
      {
          alert("您需要多少数量?");
          form1.dhsl2.focus();
          return false;
      }
     }
     if (form1.cpbm3.value!="")
     {
      if (form1.dhsl3.value =="")
      {
          alert("您需要多少数量?");
          form1.dhsl3.focus();
          return false;
      }
     }
     if (form1.cpbm4.value!="")
     {
      if (form1.dhsl4.value =="")
      {
          alert("您需要多少数量?");
          form1.dhsl4.focus();
          return false;
      }
     }
     if (form1.cpbm5.value!="")
     {
      if (form1.dhsl5.value =="")
      {
          alert("您需要多少数量?");
          form1.dhsl5.focus();
          return false;
      }
     }
     if (form1.cpbm6.value!="")
     {
      if (form1.dhsl6.value =="")
      {
          alert("您需要多少数量?");
          form1.dhsl6.focus();
          return false;
      }
     }
     if (form1.cpbm7.value!="")
     {
      if (form1.dhsl7.value =="")
      {
          alert("您需要多少数量?");
          form1.dhsl7.focus();
          return false;
      }
     }
 
      if (form1.cpbm1.value+form1.cpbm2.value+form1.cpbm3.value+form1.cpbm4.value+form1.cpbm5.value+form1.cpbm6.value+form1.cpbm7.value =="")
      {
          alert("您至少要订一种货物!");
          return false;
      }
      if (form1.jfrq.value =="")
      {
          alert("您期望何时交货?");
          form1.jfrq.focus();
          return false;
      }
}


function opennewE()
{
if (navigator.appName!="Microsoft Internet Explorer")
   alert("此功能 Netscape 用户不能使用!")
else
   {window.location.href='tjdd.asp?jm='+self.form1.jm.value;
   }
}
function sc1(mm)
{
if (navigator.appName!="Microsoft Internet Explorer")
   alert("此功能 Netscape 用户不能使用!")
else
   {
    newwin=window.open('scbh.asp?mm='+mm,'newwindow','width=780,height=380,left=100,top=100,location=0,directories=0,status=0,menubar=0,scrollbars=0,resizable=0');
    newwin.focus();
   }
}
function Pos2(){
 send_request("sess.asp")
}
function load(){
  interval = setInterval('Pos2()', 90000);
}



  var http_request=false;
function CreateHttpRequest(){
try{return new ActiveXObject('MSXML2.XMLHTTP.4.0');}
catch(e){
try{return new ActiveXObject('MSXML2.XMLHTTP.3.0');}
catch(e){
try{return new ActiveXObject('MSXML2.XMLHTTP.2.6');}
catch(e){
try{return new ActiveXObject('MSXML2.XMLHTTP');}
catch(e){
try{return new ActiveXObject('Microsoft.XMLHTTP');}
catch(e){
try{return new XMLHttpRequest();}
catch(e){return null;}}}}}}}


  function send_request(url){
    http_request=false;
    if (window.XMLHttpRequest){
       http_request=new CreateHttpRequest();
       if(http_request.overrideMimeType){
           http_request.overrideMimeType("text/xml");
       }
    }else if(window.ActiveXObject){
        try{
           http_request=new ActiveXObject("Microsoft.XMlHTTP");
           }catch(e){
    }
  }
  if (!http_request){
     window.alert("不能创建XMLHttpRequest对象实例!");
     return false;
  }
  http_request.onreadystatechange=processRequest;
  http_request.open("GET",url,true);
  http_request.send(null);
}
  function processRequest(){
     if(http_request.readystate==4){
        if (http_request.status==200){
          if (http_request.responseText!=""){  //有请求内容
            //alert(http_request.responseText)
          }else{
            alert("您已经超时,请重新登陆!");
            window.location.href="index2.asp"
          }
        }else{
           alert("您所请求的页面有异常!");
        }
      }
   }

//-->
</SCRIPT>

<body onLoad="load();">
<FORM action="savedd.asp" method="POST" name="form1" onSubmit="return check();">
<center>
<span style='font-size:18.0pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'><b>添加我的订单</b></span><br><br>
<TABLE border="0" width="780" id="tab1">
<tr>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;产品编码: <INPUT type="text" name="cpbm1" maxlength="50" value="" size=10 > <font color="#FF0000">*</font> <input type=button value="生成" onClick="sc1(1);"> </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;定货数量: <INPUT type="text" name="dhsl1" maxlength="50" value="" size=10> <font color="#FF0000">*</font>  </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;单&nbsp;&nbsp;&nbsp;&nbsp;价: <INPUT type="text" name="dj1" maxlength="50" value="" size=10> 可不填</TD>
</TR>
<TR>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;产品编码: <INPUT type="text" name="cpbm2" maxlength="50" value="" size=10> <font color="#FF0000">*</font> <input type=button value="生成" onClick="sc1(2);"> </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;定货数量: <INPUT type="text" name="dhsl2" maxlength="50" value="" size=10> <font color="#FF0000">*</font>  </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;单&nbsp;&nbsp;&nbsp;&nbsp;价: <INPUT type="text" name="dj2" maxlength="50" value="" size=10> 可不填</TD>
</TR>
<TR>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;产品编码: <INPUT type="text" name="cpbm3" maxlength="50" value="" size=10> <font color="#FF0000">*</font> <input type=button value="生成" onClick="sc1(3);"> </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;定货数量: <INPUT type="text" name="dhsl3" maxlength="50" value="" size=10> <font color="#FF0000">*</font>  </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;单&nbsp;&nbsp;&nbsp;&nbsp;价: <INPUT type="text" name="dj3" maxlength="50" value="" size=10> 可不填</TD>
</TR>
<TR>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;产品编码: <INPUT type="text" name="cpbm4" maxlength="50" value="" size=10> <font color="#FF0000">*</font> <input type=button value="生成" onClick="sc1(4);"> </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;定货数量: <INPUT type="text" name="dhsl4" maxlength="50" value="" size=10> <font color="#FF0000">*</font>  </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;单&nbsp;&nbsp;&nbsp;&nbsp;价: <INPUT type="text" name="dj4" maxlength="50" value="" size=10> 可不填</TD>
</TR>
<TR>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;产品编码: <INPUT type="text" name="cpbm5" maxlength="50" value="" size=10> <font color="#FF0000">*</font> <input type=button value="生成" onClick="sc1(5);"> </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;定货数量: <INPUT type="text" name="dhsl5" maxlength="50" value="" size=10> <font color="#FF0000">*</font>  </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;单&nbsp;&nbsp;&nbsp;&nbsp;价: <INPUT type="text" name="dj5" maxlength="50" value="" size=10> 可不填</TD>
</TR>
<TR>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;产品编码: <INPUT type="text" name="cpbm6" maxlength="50" value="" size=10> <font color="#FF0000">*</font> <input type=button value="生成" onClick="sc1(6);"> </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;定货数量: <INPUT type="text" name="dhsl6" maxlength="50" value="" size=10> <font color="#FF0000">*</font>  </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;单&nbsp;&nbsp;&nbsp;&nbsp;价: <INPUT type="text" name="dj6" maxlength="50" value="" size=10> 可不填</TD>
</TR>
<TR>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;产品编码: <INPUT type="text" name="cpbm7" maxlength="50" value="" size=10> <font color="#FF0000">*</font> <input type=button value="生成" onClick="sc1(7);"> </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;定货数量: <INPUT type="text" name="dhsl7" maxlength="50" value="" size=10> <font color="#FF0000">*</font>  </TD>
<TD width="260" align="left">&nbsp;&nbsp;&nbsp;&nbsp;单&nbsp;&nbsp;&nbsp;&nbsp;价: <INPUT type="text" name="dj7" maxlength="50" value="" size=10> 可不填</TD>
</TR>
<INPUT type=hidden name="xt" maxlength="50" value="" size=30>
<INPUT type=hidden name="a" maxlength="50" value="" size=30>
<INPUT type=hidden name="b" maxlength="50" value="" size=30>
<INPUT type=hidden name="c" maxlength="50" value="" size=30>
</table>
<input type=button value="添加产品输入格" onClick="intd();">
<TABLE border="0" width="780">
<TR><TD width="390" align="left">要求交付日期: <INPUT type="text" name="jfrq" maxlength="50" value="" onClick="CalendarWebControl.show(this,this.value)" size=30> <font color="#FF0000">*</font></TD>
<TD width="390" align="left">&nbsp;&nbsp;&nbsp;&nbsp;收货单位: <INPUT type="text" name="shdw" maxlength="50" value="" size=30> <input type=button value="自收" style="WIDTH:10%" onClick="opennewE4();"></TD></TD></TR>
<TR><TD width="390" align="left">&nbsp;&nbsp;&nbsp;&nbsp;收货地址: <INPUT type="text" name="shdz" maxlength="50" value="" size=30></TD>
<TD width="390" align="left">&nbsp;&nbsp;&nbsp;&nbsp;收货电话: <INPUT type="text" name="shdh" maxlength="50" value="" size=30></TD></TR>
<TR><TD width="390" align="left">&nbsp;&nbsp;指定收货人: <INPUT type="text" name="shr" maxlength="50" value="" size=30></TD>
<TD width="390" align="left">收货人证件号: <INPUT type="text" name="zjh" maxlength="50" value="" size=30></TD></TR>
<TR><TD width="390" align="left">&nbsp;&nbsp;&nbsp;&nbsp;付款单位: <INPUT type="text" name="fkdw" maxlength="50" value="" size=30></TD>
<TD width="390" align="left">开具增值票否: <input type="radio" name="zzsp" value="1">是 <input type="radio" name="zzsp" checked value="0">否</TD></TR>
<TR><TD width="780" colspan="2" align="left"><nobr>&nbsp;&nbsp;&nbsp;&nbsp;备&nbsp;&nbsp;&nbsp;&nbsp;注: <TEXTAREA id=TEXTAREA1 name=bz rows=1 style="height: 50; width:610 " cols="20" onFocus="javascript:this.focus();this.select();"></TEXTAREA>        
</nobr></TD></TR>
</table><br><br>
<INPUT type="submit" value="提    交" name=submit1>
<input type="reset"  value="重新填写" name="B12" >
<input type="button" value="查看我的订单" onclick="window.location.href='wddd.asp';" style="cursor: hand; TEXT-ALIGN: center;WIDTH: 105px">
<input type="button" name="fanhui" value="返回上页"  onclick="javascript:history.back(-1);" style="HEIGHT: 24px; WIDTH: 60px"> </form>   
<br><br><font color=red>注:如果您的订单中有非标类的门,请您在备注中详细说明您的非标准内容,以便我们能正确地组织生产。</font>
<br><br>

<SCRIPT language=JavaScript>
<!--
var p=7
function opennewE4()
{
       self.form1.shdw.value='皖北地级代理'
       self.form1.shdz.value=''
       self.form1.shdh.value='13955735688'
       self.form1.shr.value='许兰'
       self.form1.fkdw.value='皖北地级代理'
}


function intd()
{
   p=p+1;
var ad=document.getElementById("tab1")
oTR=ad.insertRow(ad.rows.length);
 tmpNum=oTR.rowIndex;
  oTD1=oTR.insertCell(0);
  oTD1.innerText="    产品编码: "
   var inp=document.createElement('input');
   inp.type='text';
   inp.name='cpbm8';
   inp.maxlength=50
   inp.size=10;
  oinp=oTD1.appendChild(inp);
   var fon=document.createElement('font');
   fon.color='#FF0000'
   fon.innerText=" * "
   ofon=oTD1.appendChild(fon)
  oTD2=oTR.insertCell(1);
  oTD2.innerText="    定货数量: "
   var inp=document.createElement('input');
   inp.type='text';
   inp.name='dhsl8';
   inp.maxlength=50
   inp.size=10;
  oinp=oTD2.appendChild(inp);
   var fon=document.createElement('font');
   fon.color='#FF0000'
   fon.innerText=" * "
   ofon=oTD2.appendChild(fon)
  oTD3=oTR.insertCell(2);
  oTD3.innerText="       价: "
   var inp=document.createElement('input');
   inp.type='text';
   inp.name='dj8';
   inp.value=0;
   inp.maxlength=50
   inp.size=10;
   oinp=oTD3.appendChild(inp);
   sc1(p);
//  oTD.innerText+=" 可不填 "
//  oTD.innerHTML="<input type='text' name='txt"+tmpNum+"'>";//要在该格添加的HTML代码填在这里,因为这里是text,注意不要重名了。
//  idLast.innerText=ad.rows.length;
}
//-->
</SCRIPT>
</center></body>

还是给你一个例子吧,自己研究去。因为它不是完整的程序,运行它可能会出错,但你说的功能只要点击“添加产品输入格”就可以多出一行格子。这个功能在。你可以看一下。

[[it] 本帖最后由 不惑 于 2008-4-15 23:37 编辑 [/it]]
2008-04-15 23:34
快速回复:第5句错误?insert 哪错了?
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.061581 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved