I have a ms sql db with stored procedures on it, I have followed the tutorials to the letter and can display the output in test mode, but when I want to put onto a page I only get the first record ,,top line.. Any idea what I am doing wrong as this is very frustrating.. Deving pages in coldfusion dreamweaver.
All I want to do is read a record not write not update just read the stored procedure into a page.
I think that you may have an error in the stored procedure. Without seeing the code, it is very hard for us to pinpoint the problem.
You could also try the CF forum or a dedicated MSSql forum to help you out.