W
wildt
I'm trying to Update my mdate field (date/time) data type
i broke the mdate into date (mm/dd/yyy) with name="MYdate"
and time with name="Tdate"
<select name="Tdate" >
<option value="<%=rs("mdate")%>">
<%=FormatDateTime(RS.Fields("mdate"),"3")%>
<input type="text" name="MYdate" value="
<%=FormatDateTime(RS.Fields("mdate"),"2")%>">
SQLstmt = "UPDATE courses SET "
SQLstmt = SQLstmt & "mdate='" & TRIM(Request.Form("MYdate")) & "', "'
& " & TRIM(Request.Form("Tdate")) & "'"
the update only works for "MYdate" the "Tdate"is remains the same
it's probably has to do with the SQLstmt.
Need help.
Thanks
i broke the mdate into date (mm/dd/yyy) with name="MYdate"
and time with name="Tdate"
<select name="Tdate" >
<option value="<%=rs("mdate")%>">
<%=FormatDateTime(RS.Fields("mdate"),"3")%>
<input type="text" name="MYdate" value="
<%=FormatDateTime(RS.Fields("mdate"),"2")%>">
SQLstmt = "UPDATE courses SET "
SQLstmt = SQLstmt & "mdate='" & TRIM(Request.Form("MYdate")) & "', "'
& " & TRIM(Request.Form("Tdate")) & "'"
the update only works for "MYdate" the "Tdate"is remains the same
it's probably has to do with the SQLstmt.
Need help.
Thanks