ASP与数据库-请问在对access数据库进行更新时，我如何把日期字段里修改过的值赋回去？

ASP与数据库-请问在对access数据库进行更新时，我如何把日期字段里修改过的值赋回去？

wsgjhy
wsgjhy
等级:

发表于：2008-03-26 21:50:14 楼主

从access中取出内容：

<table width = "42%" border = "1" bordercolordark = #9CC7EF bordercolorlight = #145AA0 cellspacing = "0" cellpadding = "4" align = "center">
<tbody>
<tr>
<td colspan = 2 height = "18" bgcolor = "#4296E7">
<p align = "center"> <font color = "#ffffff">修改 </font> </p> </td>
</tr>
<tr>
<td width = 84 align = "right" height = "25" nowrap>
<div align = "right">ID： </div> </td>
<td width = "361" height = "25"> <input type = "text" name = "ID" size = "20" value = " <%=rsObj("ID")%>" > </td>
</tr>
<tr>
<td width = 84 align = "right" height = "25" nowrap>
<div align = "right">购买日期： </div> </td>
<td width = "361" height = "25">
<input type = "text" name = "gmrq" size = "20" value = " <%=rsObj("gmrq")%>" > </td>
<tr>
<td width = 84 align = "right" height = "25" nowrap>
<div align = "right">图片名： </div> </td>
<td width = "361" height = "25">
<input type = "text" name = "photoname" size = "20" value = " <%=rsObj("photoname")%>" > </td>
</tr>

<tr>
<td colspan = "2" align = "right" height = "26" nowrap bgcolor = "#4296E7">
<div align = "center">
<input type = "submit" name = "Submit2" value = "修改">
<input type = "button" name = "Submit3" value = "返回" onClick = "window.location = photo.asp">
</div> </td>
</tr>
</tbody>
</table>

修改日期后

<%
dim strSQL, cmdObj, rsObj
dim id
id = Request.Form("id")

Set cmdObj = Server.CreateObject("ADODB.Command")
Set rsObj = Server.CreateObject("ADODB.RecordSet")

cmdObj.CommandText = "SELECT * FROM spb WHERE id=" & id & ""
cmdObj.CommandType = 1
Set cmdObj.ActiveConnection = conn
rsObj.Open cmdObj, , 2,3
rsObj("gmrq") = Request.Form("gmrq")
rsObj("photoname") = Request.Form("photoname")
rsObj("id") = Request.Form("id")
rsObj.Update
rsObj.Close
set rsObj = nothing
set cmdObj = nothing

' CloseConn()
%>
<script language = Javascript>

</script>

问题：用空格代替gmrq字段值更新出错
gmrq字段在access中为日期/时间类型
请教：如何修改？

问题点数：20 回复次数：7 修改删除举报引用回复