Thanks for the help with the storedproc, guys ... I'm making progress, but
now have a new problem ...
Here's how my tags look now:
<cfstoredproc procedure="findDateRange"
datasource="#request.gldsn#"
returncode="yes">
<cfprocparam type="Out"
cfsqltype="CF_SQL_TIMESTAMP"
dbvarname="start_date"
variable="start_date"
value="#request.start_date#"
null="#YesNoFormat(NOT IsDate(request.start_date))#">
<cfprocparam type="Out"
cfsqltype="CF_SQL_TIMESTAMP"
dbvarname="end_date"
variable="end_date"
value="#request.end_date#"
null="#YesNoFormat(NOT IsDate(request.end_date))#">
<cfprocresult name="ArchiveDates"
resultset="1">
</cfstoredproc>
Here is my storedproc query:
CREATE PROCEDURE findDateRange
@start_date datetime OUTPUT,
@end_date datetime OUTPUT
AS SELECT MAX(PUB_DATE) as end_date,
MIN(PUB_DATE) as start_date
FROM vcs_story_archive
My problem: the output is shooting blanks ... even though the query runs
fine, I'm not getting the output dates I expect ... just blanks (no errors).
Why?
H.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
