Simple Stored Procedure Error

[ism]

CREATE PROCEDURE sp_magazine_sections

@magazine_id INT, @magazine_section_id INT

as


IF @magazine_section_id is not null
BEGIN
SELECT TblMagazine_Sections.magazine_section_name,
TblMagazine_Sections.magazine_section_id,
TblMagazine_Sections_LK.magazine_section_id_fk,
TblMagazine_Sections_LK.magazine_id_fk,
TblMagazine_Sections_LK.magazine_section_photo ,
TblMagazine_Sections_LK.magazine_section_desc
FROM TblMagazine_Sections_LK INNER JOIN
TblMagazine_Sections ON
TblMagazine_Sections_LK.magazine_section_id_fk =
TblMagazine_Sections.magazine_section_id
WHERE TblMagazine_Sections_LK.magazine_id_fk = @magazine_id AND
TblMagazine_Sections_LK.magazine_section_id_fk =@magazine_section_id
ORDER BY magazine_section_order
END

ELSE
BEGIN
SELECT TblMagazine_Sections.magazine_section_name,
TblMagazine_Sections.magazine_section_id,
TblMagazine_Sections_LK.magazine_section_id_fk,
TblMagazine_Sections_LK.magazine_id_fk,
TblMagazine_Sections_LK.magazine_section_photo ,
TblMagazine_Sections_LK.magazine_section_desc
FROM TblMagazine_Sections_LK INNER JOIN
TblMagazine_Sections ON
TblMagazine_Sections_LK.magazine_section_id_fk =
TblMagazine_Sections.magazine_section_id
WHERE TblMagazine_Sections_LK.magazine_id_fk = @magazine_id
ORDER BY magazine_section_order
END

[paross1]

What does your CFSTOREDPROC call look like in CF? (CFPROCPARAM for magazine_section_id, etc.)

Phil

[sdwebguy99]

And just as a practice, you may wish to consider renaming your stored
procedures to not begin with sp_. Usually, sp_ stored procedures are system
stored procedures and using an alternate naming convention will help in the
long run. I agree with paross1 that it looks like the issue is in the
CFSTOREDPROC call.