Hi Guys! Can anybody figure out why I get a date time field overflow on this:
<CFQUERY NAME="CheckProcedure" DATASOURCE="#MyDSN#" DBTYPE="ODBC"> SELECT * FROM sysobjects WHERE (OBJECTPROPERTY(id, N'IsProcedure') = 1) AND (name = N'sp_UpdateTimeOut') </CFQUERY> <CFIF NOT CheckProcedure.RecordCount><CFQUERY NAME="CreateProcedure" DATASOURCE="#MyDSN#" DBTYPE="ODBC"> CREATE PROCEDURE sp_UpdateTimeOut @UserID [int] ,@TimeOutVarChar [varchar] AS SET @RowsEffected = 0 UPDATE Time_Actual SET Time_Out = CAST(@TimeOutVarChar AS datetime) WHERE Users_ID = @UserID AND Time_Out IS NULL </CFQUERY></CFIF> <!--- Ensure the user is clocked out if they are trying to clock in ---> <CFSTOREDPROC PROCEDURE="sp_UpdateTimeOut" DATASOURCE="#MyDSN#"> <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" DBVARNAME="@UserID" VALUE="18"> <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@TimeOutVarChar" VALUE="2001-10-22 21:41:02"> </CFSTOREDPROC> Thanx Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists