I've got a column called time with the datatype time. When querying the
column from asp/ado the values are the current date with a vartype of date.
query browser: select time from syslog.mailinfo limit 1
result:
"time"
"03:18:26"
asp/ado:
<%set conn=server.createobject("adodb.connection")
conn.connectionstring="dsn=mysql2"
conn.open
set rs=server.createobject("adodb.recordset")
rs.open "select time from syslog.mailinfo limit
1",conn%><%=rs("time")%><%rs.close
conn.close%>
result:
8/16/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
