Ask a Question related to Dreamweaver AppDev, Design and Development.
-
cutigerfan #1
Stored Procedures in Dreamweaver
I am trying to set up a "Callable (Stored Procedure)" under bindings. I have
been using Dreamweaver since the days of Ultra Dev 4 and think I am fairly
familiar with using the recordset queries, updates and inserts. What I'm
trying to say is that my problem might be in my enviroment or perhaps the rate
bug in Dreamweaver. I setup a very small database with only one or two stored
procedures just to try and figure this out. Here are my steps.
In the Application Window, Bindings Tab I click on the +. Then select
Callable (Stored Procedure). I click the box to return a recordset, and fill
in other data fields. Instead of typing the Callable Text I use the Database
Items window to select the stored procedure (trying to avoid user errors).
Clicking on the Add Procedure button puts this text in the Callable Text field:
{?= call dbo.adminlevel()} and adds on row of Variables. The return variable
only. It does not give a variable for the required input, @level. I try to
add this line manually:
Name = @level, Type = varchar, Direction = in, Default value = ad, Run-time
Value = level
Note my GUI does not have a column for size.
When I hit okay I get "While executing findServerBehaviors in Callable.htm,
the following Javascript error(s) occurred:
At line 183 of the file "C:\Program Files .. . \JSP\Callable.js":
TypeError: ssRec.ParaArray[pIndex - 1] has no properties.
The IDE is unpredictable at this point and I have to stop it and start it.
A little about my enviroment. I am using Windows 2000, ODBC, with SYBASE 12
drivers connecting to SYBASE 12.0 running on Solaris 8. I use the ODBC in
developement, and sun.jdbc.odbc.JdbcOdbcDriver in runtime on the Server. And
the server is Tomcat.
Any help would be greatly appreciated.
Thanks,
Gene Forney
cutigerfan Guest
-
Stored Procedures
Hi all, I'm a little confused about how to obtain a result set from a stored procedure (stored in a Visual FoxPro 8.0 database) from an ASP.NET... -
Cannot view Oracle Stored Procedures in Dreamweaver XP
Does anyone know how to get round this? I've defined and tested the connection to the Oracle database and everything seems to work OK, but when I... -
dt_ Stored Procedures
Please could you tell me if it is safe to remove the dt_ stored procedures from my database? I have spent some time searching the web/groups for... -
New to ASP and Stored Procedures
Hi I have some experince with ASP and databases in General, however Stored Procedures are new. I need to call a stored procedure and have bene... -
Stored Procedures and 4GL
Hello, I am using Informix 7 se database. Is it possible to call a 4GL program from a stored procedure? Thanks Ahmer



Reply With Quote

