I think you can buffer the output. So, the server will hold back on dishing anything out until it has run the entire script. I think that will allow you to pull of your script.
<%response.Buffer=true%> needs to go at the beging of your page.
I'm using MS SQL Server. I been pulling my hair out on this one. I did come up with a soution, although it makes no sense to me.
I iterated through the input parameters in the same order that I created the stored procedure in. Example:
CREATE PROCEDURE NoneYaBusiness.sp_ModAssetManufactures (...
Yes, I understand that, thanks. I just used that to show you the date value in the format that is being passed to the parameter.
Just noticed that I enter "Date" in the parameter. I actually used "strDate" in my code. Then I changed the value of strDate to what I thought it reqired i.e...
I really want to use parameterized queries in my web site. But sometimes, Id rather eat a can of worms than use these typoe queries.
Here is my latest nightmare.
##################################
date = 2/20/2013
cmdStoredProc.parameters.append...
gmmastros,
Worked on the first execution. Yes, I can see how the rows with a Rowid=1 are the latest invoice. I need to get the last invoices where the customer BillCurrent column = 'Yes'. I don't care about the customers that now longer subscribe to the service. The magic line you added scares me.
I just cant seem to get the results I want. I tried going from simple to complex and its just killing me. Can you please help.
I have two tables:
Customers, Invoices
my invoices are for service so I only have one entry per invoice.
I want to get the total revenues. That is the total of each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.