I seem to remember something about dates are diff in mysql
the db the date fiels is set to int
and here is some code
<!--- set form variables --->
<cfset title=trim(form.title)>
<cfset content=trim(form.content)>
<cfset date=#Now()#>
<!--- do insert now --->
<CFQUERY NAME="qnews" DATASOURCE="#dsn#" USERNAME="#un#" PASSWORD="#pw#">
INSERT INTO guide (title, content, update)
VALUES ('#title#', '#content#', '#date#' )
</CFQUERY>
any suggestions?
stupid me
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
