Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. madiaz91911

    How to use Session.Abandon?

    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.
  2. madiaz91911

    Parameterized query :(

    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 (...
  3. madiaz91911

    Parameterized query :(

    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...
  4. madiaz91911

    Parameterized query :(

    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...
  5. madiaz91911

    Max() query problem

    Awsome! Thank you very much. I'll now read up on partions to learn more about it. I've run into that before. Thanks agian, you were very helpfull.
  6. madiaz91911

    Max() query problem

    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.
  7. madiaz91911

    Max() query problem

    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...

Part and Inventory Search

Back
Top