Time fra ASP til mySql
Jeg har følgende ASP-side (med tak til soerenlyn og w13):<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<%
Dim my_conn, rs, strSQL
Set my_conn = createobject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
my_conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=alsvik_dk;"_
& "UID=bruger; PWD=password; OPTION=35;"
strSQL = "SELECT * FROM blog ORDER BY [time] DESC"
my_conn.Execute("INSERT INTO blog (id, name, email, comments, time) values('(id)','"& Request.Form("name") & "', '"& Request.Form("email") &"', '"& Request.Form ("comments") &"', '(time)')")
%>
<form name="write" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="11%">name:</td>
<td width="89%"><input name="name" type="text" id="name" size="100"></td>
</tr>
<tr>
<td valign="top">comments:</td>
<td><textarea name="comments" cols="100" rows="20" id="comments"></textarea></td>
</tr>
<tr>
<td valign="top">email:</td>
<td><input name="email" type="text" id="email" value="" size="100"></td>
</tr>
<tr>
<td> </td>
<td>
<div align="center">
<input type="submit" name="submit" value="Send">
</div></td>
</tr>
</table>
</form>
Og det virker fint - pånær TIME.
Der er ikke angivet nogen tid ud for denne "entry" i databasen. Den står til:
0000-00-00 00:00:00
Hvordan kalder jeg aktuel tid og definerer format yyyy-mm-dd hh:mm:ss
