Update my mdate

[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

 

[Manohar Kamath [MVP]]

Write out the SQL statement to see what it looks like.

Response.Write SQLStmt

That way you can debug it much easily.