I am combining a date and time to enter into a DATETIME field in mysql database.
When I response.write the variable it displays correctly. The issue is it is not getting updated in the database.
However, when I response.write the strSQL it shows the correct combined variable, but still doesn't update in the database.
Here is the code:
idate = request.form("idate") itime = request.form("itime") id = request.form("id") vdate = idate &" "&itime strSQL = "update tourney_info set tdate = '"&idate&"' where tid = "&id&"" conn.execute (strSQL) ''response.redirect "start2.asp"
Any help would be appreciated