Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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