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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
