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!

Register Log in
  • Congratulations derfloh 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. tigerjade

    Why can't I use CTEs inside transactions?

    Hmmm. I guess I'll go back to my code; so long as it's happy for you, that's a pretty strong indicator that it's not the TRANSACTION but a PEBCAK issue. :) Thanks! "Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin...
  2. tigerjade

    Why can't I use CTEs inside transactions?

    Anyone know why I can't use a CTE inside a transaction? Every time I try, it throws a non-sensical error message (usually complaining about a syntax error near BEGIN TRY or END TRY) but as soon as I comment out the transaction statements it's perfectly happy. I can't find anything in the MSDN...
  3. tigerjade

    Syntax Error Where None Exists

    Okay, more googling (done by a co-worker with superior google fu to mine) shows that it is indeed the HAVING clause combined with the UPDATE that is giving SQL fits. I'll need to use a CTE or something. Thanks! "Always code as if the person who ends up maintaining your code will be a violent...
  4. tigerjade

    Syntax Error Where None Exists

    Okay, let's see. I added in one more condition (thanks for that catch) that ensures that it always returns one value (because of the hierarchy, it's one parent-one child, so there'll always be one RateId to come out of the query) and pulled the subquery into a 'regular' query, but it still...
  5. tigerjade

    Syntax Error Where None Exists

    I'm getting a syntax error on this query and no one here (including yours truly) can figure out what SQL is REALLY trying to say. Here's the code: declare @VarKey int set @VarKey = 3 UPDATE Schema1.Table SET Rate = gl.Rate FROM dbo.RateView gl WHERE gl.RateId = (SELECT RateId FROM...
  6. tigerjade

    Get excluded rows?

    That'll work! Unfortunately, I have data coming from a flat file and a database server, so joins have to be in the system. I'm pushing as much as I can to the query, though. :) "Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you...
  7. tigerjade

    Get excluded rows?

    Any idea how I can get rows that did not meet the criteria in a merge join? "Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding
  8. tigerjade

    One file, multiple SSIS packages: problem?

    Okay, duly noted. Thank you! "Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding
  9. tigerjade

    One file, multiple SSIS packages: problem?

    I'm trying to design an app that will monitor a folder for delivered files (via FTP, from external sources), and then kick off associated SSIS packages. My question is (and I'm asking now, so I can determine the best way to build this thing) is, if a file is required by more than one package...
  10. tigerjade

    Problem with Office 2003 PIA in ASP.Net

    Thanks for the responses! Oh my yes; the .Net programmability support has been installed and re-installed. I've also gotten the same errors on my test box that has a new install of Office 2003 with all the goodies. That one is Win2k3 standard. The PIAs are in the GAC like they're s'posed to...
  11. tigerjade

    Problem with Office 2003 PIA in ASP.Net

    I'm trying to display some Outlook data (current appts, tasks & number of unread in inbox) for users on an intranet. There's no problem if I view the site via Cassini, but if I open it in IIS, I get the following error: Retrieving the COM class factory for component with CLSID...
  12. tigerjade

    Retreive items from a datalist...

    I've had the same problem with labels before. Try putting the label in like this: <asp:Label Runat="server" ID="ProductName" Text='<%# DataBinder.Eval(Container.DataItem, "Brand")%>'></asp:Label> Hopefully, that should allow you to retrieve the .text value. :) hth tigerjade "Always code...
  13. tigerjade

    Retreive items from a datalist...

    I'd suggest using foreach to step through the items: foreach (DataListItem dlItem in ThisDataList.Items) { TextBox thisTB = dlItem.FindControl("TextboxName") as TextBox; // do what you need with each item here } hth tigerjade "Always code as if the person who ends up maintaining your...
  14. tigerjade

    Open newly-created PDF in new browser instance

    I found something; now I just have to figure out how to get the application to release the PDF so that the AddHeader can get 'hold of it. Thanks again! tigerjade "Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin...
  15. tigerjade

    Open newly-created PDF in new browser instance

    Thanks, Brian! Can you point me to an example? MSDN documentation is pretty light on using AddHeader. :( thanks! tigerjade "Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding
  16. tigerjade

    Open newly-created PDF in new browser instance

    I'm using iTextSharp to create PDFs with this application. It'll write the PDF just fine, but doesn't open it. How can I use code-behind ('cause this is a class that doesn't interact with the user past their initial request) to open the newly-created PDF in a new browser instance? Thanks...
  17. tigerjade

    Problem getting print to show variable

    That WAS it, vongrunt! I was mistaking output with variable assignment, apparently. Guess that's what happens when you learn these things on the fly. Thanks, guys! tigerjade :) "Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you...
  18. tigerjade

    Problem getting print to show variable

    No, it's not. :) If I use SELECT @Quantity = CONVERT(int, Quantity) FROM Item WHERE ID = @ItemID I don't get a return at all. That's why I figured it wasn't working. Am I wrong? Is it working if it DOESN'T show up in the QA window? tigerjade :) "Always code as if the person who ends up...
  19. tigerjade

    Problem getting print to show variable

    vongrunt, when I try what you suggest, I don't get a value returned at all. I had left some test code in that when I posted; here's what I'm trying currently: ALTER PROCEDURE sp_addItemsAccounting @ItemID int ,@Received int ,@UserID int ,@InvoiceID int ,@Success int Output AS DECLARE...
  20. tigerjade

    Problem getting print to show variable

    I have an SP that, among other things, needs to sum some values and play with it. It seems to be dying, because all I get is the two selected values at the top: ALTER PROCEDURE sp_addItemsAccounting @ItemID int ,@Received int ,@UserID int ,@InvoiceID int ,@Success int Output AS DECLARE...

Part and Inventory Search

Back
Top