select case uCase(fieldType) case "NUM" vStr = vStr & fieldData & ", " 把不明类型按文本型处理 case else vStr = vStr & "" & fieldData & ", " end select end if end if end if next
把结尾的", " 从我们建立的字符串中去掉 vStr = left(vStr, len(vStr) - 2) & ")" nStr = left(nStr, len(nStr) - 2) & ") "
把SQL语句整合起来 buildSQLInsert = iStr & nStr & vStr end function
if trim(request("fName")&request("lname")&request("age")) <> "" then response.write( buildSQLInsert("") & "<BR<") response.write( buildSQLInsert("NUM_AGE") & "<BR>") response.write( buildSQLInsert("lname,fname") & "<BR>") response.write( buildSQLInsert("mycheckbox,fname") & =<"<BR<") else %>
<html> <body>上一页 [1] [2] [3] [4] [5] [6] 下一页
|