Hi all, i have a question concerning stored procedures in Sybase...
CREATE PROCEDURE dbo.pass_mnt_scorepush_getind_insp
@pha_id char(6),
@in_source_fiscal_year int,
@pihproj char
as
SELECT phy_assess_queue_inspection.pih_project_number,
phy_assess_queue_inspection.property_name,
phy_assess_queue_inspection.legacy_inspection_number
FROM phy_assess_queue_inspection
INNER JOIN participant_assessment
ON phy_assess_queue_inspection.assessment_id =
participant_assessment.assessment_id
WHERE participant_assessment.pha_id = @pha_id AND
participant_assessment.fiscal_year = @in_source_fiscal_year AND
phy_assess_queue_inspection.pih_project_number = @pihproj AND
phy_assess_queue_inspection.delete_dt is null
Order By phy_assess_queue_inspection.pih_project_number
if I run the query on it's own it'll return records with the right params
fed to it.
If I run the stored procedure with the same params it returns no records.
exec pass_mnt_scorepush_getind_insp
@pihproj='#qry_getPropFrom.pih_project_number#',@in_source_fiscal_year=#url.year_to#,@pha_id='#url.pha_id#'
Is this a permissions issue?
Scott A. Stewart
REAC/PASS-IT
(202)-475-8875
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256344
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
