mysql stored procedure in Dreamweaver 8

Stored procedures are normally stored in the DBMS. So if you are using MySQL 5 then you need to create your SP in MySQL.

i think that is only for calling the stored procedure within the application. It has to be created within the database or GUI.

I got this message when i click on stored procedure in the recordset dialog.
Error calling GetProcedures:Stored Procedures For mysql/5.0.18-nt are not supported

does this mean i am using a version that does not support procedures?

Also when i click the stored procedures under server behaviours to open up the dialog box, it displays the parameters but does not list any procedures under the drop down menu.

In the application panel, under Server behaviors, there is a plus sign. Click on that and you will see Stored Procedure in the menu.

Actually I am not very familiar with stored procedures. I only require it to navigate through indivudual recordsets on the detail page of a master-detail setup. The detail page will display the each record in detail from the database.

I was going through a certain article regarding this and it uses stored procedures.

However i did manage to hand code it within coldfusion but it still shows error.
Below is the code in detail1.cfm

<CFSTOREDPROC procedure="nextandprevious" datasource="976evil_db">
<CFPROCPARAM type="IN" dbvarname="@id" value="#url.recordID#" cfsqltype="CF_SQL_INTEGER">
<CFPROCPARAM type="OUT" dbvarname="@prev" variable="out_prev" cfsqltype="CF_SQL_INTEGER">
<CFPROCPARAM type="OUT" dbvarname="@next" variable="out_next" cfsqltype="CF_SQL_INTEGER">
</CFSTOREDPROC>

On running the page, when i click any record on master page, I get the following error.
Error Executing Database Query.
Result consisted of more than one row

Exceptions

21:19:04.004 - Database Exception - in C:\CFusionMX\wwwroot\Previous_and_Next_Links_for_Details_Page_Stored_Procedure\detail1.cfm : line 4

Error Executing Database Query.

Code for the previous link on page is shown below.
<a href="detail1.cfm?<cfoutput>#Recordset1.blog_item_id#</cfoutput>=<cfoutput>#out_prev#</cfoutput>">PREVIOUS </a>

Where am i going wrong? also u stated that stored procedures can be created within dreamweaver!!! do you mean by hand coding or through wizard?

If you didn't use dreamweaver to create your stored procedure it is not likely to show in the list.