«

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

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

Response.Write SQLStmt

That way you can debug it much easily.

--
Manohar Kamath
Editor, .netBooks
www.dotnetbooks.com


"wildt" <> wrote in message
news: m...
> 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