This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C24F48.2A871290
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello everyone,
I'm new to the list and CF. I've recently installed CFMX Pro and have =
run into a problem using Stored Procedures in Dreamweaver MX.=20
None of my stored procedures will produce a recordset when I use .cfm =
pages. For example, I have a simple SP on an SQL 2000 server. Here is =
the SP:=20
CREATE PROCEDURE dbo.sp_Counties AS=20
SELECT *=20
FROM dbo.counties=20
ORDER BY county_ID=20
GO=20
If I try to work with this SP from a .cfm page in DWMX, the actual =
fields do not appear in the Bindings Window. I get a 404 Error saying=20
1. "There is no testing server running on the server machine"=20
or=20
2. "The testing server specified for this site does not map to the =
http://mysite:8500/_mmServerScriptsMMHTTPDB.cfm URL. Verify that the URL =
Prefix maps to the root of the site."=20
Now if I just use <cfdump>, it grabs the list from the SP just fine. If =
I create a recordset rather than use an SP, it works. If I call the SP =
from the recordset window everything works. I know the SQL server and SP =
are fine, they work within ASP and JSP pages fine on other servers. This =
is occurring on both CFMX servers. Any ideas???? As I said earlier, this =
is with any SP that I try to return a recordset?=20
Thanks for any help you can give.
Matthew E. Mooney
Arizona Area Health Education Center
University of Arizona
140 N. Tucson Blvd.
Tucson, AZ 85716-4740
(520) 318-7151 ext 220
[EMAIL PROTECTED]
------=_NextPart_000_0007_01C24F48.2A871290
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hello everyone,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm new to the list and CF. I've =
recently installed=20
CFMX Pro and have run into a problem using Stored Procedures in =
Dreamweaver MX.=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>None of my stored procedures will =
produce a=20
recordset when I use .cfm pages. For example, I have a simple SP on an =
SQL 2000=20
server. Here is the SP: <BR><BR>CREATE PROCEDURE dbo.sp_Counties AS =
<BR>SELECT *=20
<BR>FROM dbo.counties <BR>ORDER BY county_ID <BR>GO <BR><BR>If I try to =
work=20
with this SP from a .cfm page in DWMX, the actual fields do not appear =
in the=20
Bindings Window. I get a 404 Error saying <BR>1. "There is no testing =
server=20
running on the server machine" <BR>or <BR>2. "The testing server =
specified for=20
this site does not map to the =
http://mysite:8500/_mmServerScriptsMMHTTPDB.cfm=20
URL. Verify that the URL Prefix maps to the root of the site." =
<BR><BR>Now if I=20
just use <cfdump>, <CFDUMP>it grabs the list from the SP =
just fine.=20
If I create a recordset rather than use an SP, it works. If I call the =
SP=20
from the recordset window everything works. I know the SQL server =
and SP=20
are fine, they work within ASP and JSP pages fine on other servers. This =
is=20
occurring on both CFMX servers. Any ideas???? As I said earlier, this is =
with=20
any SP that I try to return a recordset? </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for any help you can =
give.</FONT></DIV>
<DIV><BR><FONT face=3DArial size=3D2>Matthew E. Mooney<BR>Arizona Area =
Health=20
Education Center<BR>University of Arizona<BR>140 N. Tucson =
Blvd.<BR>Tucson, AZ=20
85716-4740<BR>(520) 318-7151 ext 220<BR></FONT><A=20
href=3D"mailto:[EMAIL PROTECTED]";><FONT face=3DArial=20
size=3D2>[EMAIL PROTECTED]</FONT></A></DIV></BODY></HTML>
------=_NextPart_000_0007_01C24F48.2A871290--
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
