Advertisement

10.04.2007 at 11:11AM PDT, ID: 22872852 | Points: 500
[x]
Attachment Details

Stored Procedure issue in SQL Server 2005, Dreamweaver and Coldfusion

Asked by thinkwelldesigns in SQL Server 2005, Macromedia Dreamweaver, Cold Fusion Markup Language

Tags: stored, procedure, sql, dreamweaver, 2005

I'm having a problem with SQL Server 2005 stored procedures using Dreamweaver CS3 and Coldfusion 8.

I am using rather simple SQL in the stored procedure as a test:
SELECT     Prod_Category.category_name AS Category, Prod_Category.category_ID AS [Category ID]
FROM         Prod_Category INNER JOIN
                      Products ON Prod_Category.category_ID = Products.category
WHERE     (Products.online = 1)
GROUP BY Prod_Category.category_name, Prod_Category.category_ID
ORDER BY Category

This SQL executes as expected in SQL 2005 as well as in a standard Dreamweaver recordset.

I'm using  this CFML to call the recordset which is just standard code using the Bindings Panel:

<CFSTOREDPROC procedure="dbo.Categories_Online" datasource="#sDSN#">
  <CFPROCRESULT name="Categories">
</CFSTOREDPROC>

But I get this lovely error when trying to test the recordset in Dreamweaver:

http://www.thinkwelldesigns.com/Dreamweaver.jpg

Start Free Trial
[+][-]10.04.2007 at 12:09PM PDT, ID: 20016823

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.04.2007 at 12:44PM PDT, ID: 20017157

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.04.2007 at 02:39PM PDT, ID: 20018116

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.05.2007 at 03:04AM PDT, ID: 20020588

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.05.2007 at 06:03AM PDT, ID: 20021450

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.05.2007 at 06:14AM PDT, ID: 20021539

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.05.2007 at 10:48AM PDT, ID: 20023980

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628