I'm not figuring out the cause of this error ...
Here's my stored proc:
CREATE PROCEDURE arc_find_daily
@ARCHIVE_ID bigint OUTPUT,
@NB_ID char OUTPUT,
@PUB_DATE datetime OUTPUT,
@P_SECTION varchar OUTPUT,
@PAGE char OUTPUT,
@WORD_COUNT char OUTPUT,
@HEADLINE varchar OUTPUT
AS SELECT ARCHIVE_ID,
NB_ID,
COPYRIGHT,
PUB_DATE,
P_SECTION,
PAGE,
WORD_COUNT,
HEADLINE
FROM story_archive
WHERE PUB_DATE = '@PUB_DATE'
ORDER BY P_SECTION, PAGE, HEADLINE
Here's my tag:
<cfstoredproc procedure="arc_find_daily"
datasource="#request.gldsn#"
returncode="yes">
<cfprocparam type="INOUT"
cfsqltype="CF_SQL_TIMESTAMP"
dbvarname="PUB_DATE"
variable="PUB_DATE"
VALUE="#createODBCDate(search_date)#"
null="#YesNoFormat(NOT IsDate(search_date))#">
<cfprocresult name="daily_stories"
resultset="1">
</cfstoredproc>
Here's my error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data
type datetime to bigint is not allowed. Use the CONVERT function to run this
query.
But I can't see where I'm passing anything but a datetime and not a bigint
(except where expected).
H.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
