Search results for query: *

Tim, Is my question above really dumb? I keep thinking that if Stored Procs do everything else (and I did get them to update a field without the population - it was just a blank text field and I entered information), then this shouldn't be a problem. However, I've also confused misleading...

I've read over your e-mail so many times I think I can quote it by heart (four score and seven years, oops. wrong one) and I'm still not sure what I want can even be done. It's not the Stored Proc that I want to have update the fields - it's the user who edits it. If you go to...

Tim, I think it worked perfectly and I sent you a star post. That is, the form came up without any errors and was populated. When I attempted to edit the populated form, I naturally received the error of Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure...

Tim, Wow! It worked! The field was actually populated. I'm so excited. Yesterday I had begun to believe that doing this was mainly theoretical like third normal form. Everybody else around here does CFML for updates. I'm the only one who's tried Stored Procs. Could I trouble you to borrow code...

Pigsie, Thanks for your reply. I'm getting a fairly consistent Element COMPANYNAME is undefined in RECORDSET_TO_POPULATE_FORM. but as you can see, I have defined it in the CFQUERY (unless I am supposed to define it in a CFPROCRESUT which didn't work either when I tried it). I enclosed my...

Falconseye, Thanks for your reply. No luck. Probably something basic I'm doing wrong. Don't blame you if you don't want to review this (I tried it using the SQL Server Northwinds databas) but I just wanted to get back to you. Ceal This is my Stored Proc CREATE PROCEDURE...

Has anyone successfully created a Stored Procedure which populates a web form using Macromedia's Studio MX (ColdFusion and Dreameweaver MX? (The end result should be an web Edit screen which the user can edit and then pass the changes back to SQL Server.).

ABS200 I was using the wrong template in SQL Server. I used the cursor output rather than just output. Anyway, it works now. I can see my Stored Proc output in SQL Server Query Analyzer Results Pane. This is the code I used for the Northwinds database that comes with SQL Server (in case...

abs2003 Thanks very much for your reply. I replaced the ALTER with EXEC and that didn't work. There is a template in SQL Server with cursor output but I couldn't get it to work and it seemed a lot more complicated than I needed. Do I need to use the template or was there something else you did...

In your post, you stated, "I can use SQL Query Analyzer to test it. It works fine. When call it from my ASP.NET, it returns nothing." When I use my Stored Proc in Query Analyzer, all I get is "command was completed succesfully". If I use a regular query, I get output but with Stored Procs...