Hello, I want to return a string color based on these 4 calculations. X = 25% 5.0% >= X >= -5.0% blue +15.0% >= X > +5.0% and -5.0% > X >= -15.0% yellow +25.0% >= X > +15.0% and -15.0% > X >= -25% green X > +25.0% and X < -25.0% red I am having trouble forming the logic. Thank you for the help.

Hello needs some help with this one: I have a 384 days of rates a rate price and date. I am trying to fill a graph by day of rates. I am allowing the user to select 30, 60 or 90 days of rates within a start and end date of choosing. I am trying to use linq to return only 30, 60 or 90 days of rates based on the start and end dates. The issue is the start and end date range could be less then let's say 30 days so I still want to return 30 days of rates. I have not been very successful. Thanks so much for the help.

Hello, I am trying to understand the easiest way to rename a parent directory and the sub directory at the same time. Thank you for the help.

I tried your suggestion and that did not change anything. I am using MS SQL 2008 and the NVL function does not appear to be avaible so I tried the ISNULL function. I believe it does the same thing. Thanks again.

Thank you. I am not sure what to change and that is why I asked for help.

Hello, And thanks in advance for the help. I am using this query to group exams and count: SELECT BPG.[GroupName], COUNT(A.[ProcedureID]) AS [Count] FROM [DB].[dbo].[Accessions] A INNER JOIN [DB].[dbo].[table1] BP ON A.[ProcedureID] = BP.[ProcedureID] INNER JOIN [DB].[dbo].[table2] BPG ON BP.[ProcedureGroup] = BPG.[ProcedureGroupID] INNER JOIN [DB].[dbo].[table3] O ON A.[OrderID] = O.[OrderID] INNER JOIN [DB].[dbo].[table4] F ON O.[OrderingFacilityID] = F.[FacilityID] WHERE --XRAY,US,PICC,EKG (BPG.[GroupName] IN ('XRAY','EKG','US','PICC')) AND (F.[Name] LIKE '%' + @Facility + '%') AND (A.[ExamDate] >= CONVERT(DATETIME, @StartDate + @Year) AND A.[ExamDate] < CONVERT(DATETIME, @EndDate + @Year) AND (A.[Status] != 'Cancelled' AND A.[Status] != 'ADMIN CANCEL' AND A.[Status] != 'Cancelled - Dry Run')) GROUP BY BPG.[GroupName] Let's say the query only returns 'XRAY' and 'EKG' with a count. How can I also return that 'US' and 'PICC' have zero count. :doh: Thanks for the help.

Hello, I would like to call a method multiple times by a count. For example: If count = 6 call method 6 times. Thank you so much for the help. RB

Hello, I need some help with a SQL query. Example table: Table myTable Columns myId, myDate If I have rows in the table with the same id like this: myid mydate ---- -------- 1 01/01/1999 1 blank 1 01/01/1999 2 01/02/1999 I would like to filter out the id completely if I find the id has a record with a date and a record with a blank date. If the filter works my results should be: myid mydate ---- -------- 2 01/02/1999 Id 2 remains because it does not have records with a blank date. Thank you so much for the help.

Hello, Does anyone know of a way to set the below authenication mode programatically? Thank you for the help. RB

Thank you very much for the information. Very helpful. :-D

Hello, I was wondering 'if this is even possible' what is the "right" way to perform caching and state management within WebServices with ASP.Net 2.0? Or should you just use System.IO.MemoryStream? :doh: My Scenario is: UI will hit WebService lets say every 10 min and request data. However I don't want every user hitting the WebService to make a call to SQL. Just need to be pointed in the right direction. Thank you for the help. RB

Thank you.. I have been doing it this way as well. I just did not see my new LogName.evt showing up in my \System32\config directory. However I restarted my system and the file appeared. Go figure. Thank you. RB

Hello, I have created a CustomEventLog. I am using the EventLogInstaller class and using Installutil.exe to install my log. However I notice that the MyCustomLog.Evt file is not being generated? Does anyone know how the .Evt file gets generated? Thanks so much for the help. RB

Hello, I am using a TextBox, Button and DataList. When I submit a value from the TextBox adding the value to a row in my DataTable binding the DataTable to my DataList. I would like to be able to keep clicking the button adding new rows to the DataTable keeping the state. Example. Submit 1: Add row value 23413 Submit 2: Add row value 99999 DataList Shows: 23413 99999 Thank you so much for the help. RB

Hello, I am using the basic export to Word code for my GridView below. I am trying to figure out how to remove the hidden input field that gets added to the output from the StringWriter. Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=TheFile" + FileDateTime("doc")); Response.Buffer = true; Response.ContentType = "application/vnd.word"; Response.Charset = ""; this.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); HtmlForm fakeForm = new HtmlForm(); this.Controls.Add(fakeForm); fakeForm.Controls.Add(gvMine); fakeForm.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Thanks for the help. RB

Hello, I have a need after every 8 rows in a Repeater I make a visible. Is this even possible? If so, how would I go about it. Thank so much for the help. RB

Just in case anyone else runs into this problem. Just use: window.parent.document.getElementById('myiframe').src = 'http://www.mysite.com' Worked perfect. RB

Yes I agree that, but for IE to work that is how I had to do it for some reason. However I have tested Firefox as well with the example you provided. I was doing some reading and even tried: window.parent.frames["myiframe"].location.href = 'http://www.mysite.com'; and that did not work either. It's almost like Firefox is ignoring window.parent

Hello, Can anyone tell me why this does not work in FireFox? window.parent["myiframe"].location.href = window.parent["myiframe"].location.href = 'http://www.mysite.com'; This script is being called from LinkButton in another IFRAME window. It's works prefectly in IE and I don't like that. X| Thank you for the help. RB

Thanks for the tip. You got my wheels spinning and I figured it out. Thanks again. RB;P