I have a MS SQL database and I have a stored procedure I'm trying to
call with the following code..
<cfset FutureTime=DateAdd('yyyy', 3, Now())>
<cfoutput>#futureTime#</cfoutput>
<cfstoredproc procedure="GetDate" dataSource="#datasource#">
<cfprocparam type="IN" CFSQLType="CF_SQL_DATE" value="#FutureTime#"
dbVarName="@Future">
<cfprocparam type="IN" CFSQLType="CF_SQL_VARCHAR"
value="#session.UserID#" dbVarName="@UserID">
<cfprocresult name="GetDate">
</cfstoredproc>
Here is the Stored Procedure....
ALTER PROCEDURE [dbo].[GetDate]
@UserID varchar(50),
@Future Datetime
AS
BEGIN
SET NOCOUNT ON;
SELECT [DateTaken]
, [DateExpire]
from TestResults
Where UserID = @UserID
and DateExpire < @Future
Order by Score DESC
END
Here's the kicker... It works perfect on Firefox... IE and Opera, I
get the following coldfusion error...
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data
type varchar to datetime.
First of all... Wha???
Second of all, if there is error in the code, why isn't firefox having
a problem displaying it. My boss (who knows a bit about coldfusion
says that firefox may be ignoring the error.... But that doesn't seem
logical to me..
Can someone shed some light on this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308430
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
