Off the top of my head - untested! :) int x = 25; Color c = GetColor (x); public Color GetColor (int x) { if ((x <= 5) && (x >= -5)) return Color.Blue; if ((x <= 15) && (x >= -15)) return Color.Yellow; if ((x <= 25) && (x >= -25)) return Color.Green; return Color.Red; } /ravi My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

You will need to adjust the start, or end, dates before making your query. If the start date is outside the range of the available data-days: 1. if it's before the first day, then return #n data-days beginning on the first day ... or return an error. 2. if it's after the last day, then return the last #n data-days from the data ... or throw an error. 3. if the start date is in the valid range, but the user wants more data-days than are possible, decrease the start date so you can return the required data-days data. You don't specify how exactly, given valid start and end dates you let the user choose which 30,60,90 day chunk to return, so can't comment on that. «I'm asked why doesn't C# implement feature X all the time. The answer's always the same: because no one ever designed, specified, implemented, tested, documented, shipped that feature. All six of those things are necessary to make a feature happen. They all cost huge amounts of time, effort and money.» Eric Lippert, Microsoft, 2009

Why at the same time? Just rename the current and then jump to the parent and do the same? There is no magic button for this type of thing. I wasn't, now I am, then I won't be anymore.

Connect to the BPG table and all of its inner joins first. Then do a LEFT OUTER JOIN to your Accessions (A) table and it's joins. This will give you all of the group names and the 0's if there is nothing for that group. SELECT BPG.[GroupName], COUNT(A.[ProcedureID]) AS [Count] FROM [DB].[dbo].[table2] BPG LEFT OUTER JOIN ([DB].[dbo].[Accessions] A INNER JOIN [DB].[dbo].[table1] BP ON A.[ProcedureID] = BP.[ProcedureID] INNER JOIN [DB].[dbo].[table3] O ON A.[OrderID] = O.[OrderID] INNER JOIN [DB].[dbo].[table4] F ON O.[OrderingFacilityID] = F.[FacilityID] ) ON BP.[ProcedureGroup] = BPG.[ProcedureGroupID] WHERE ..... GROUP BY BPG.[GroupName] Brent

Hmm, I'm sure you could fit some XML in there, keep the counter in a database table, or even create a custom CountNotYetAchieved Exception class. I'd even settle for a string counter and Int32.Parse it on each iteration. Come on guys, integer counters are soooo yesterday! Here's my real version: while(count-- > 0) MyMethod(); One other thing is the else technically is unnecessary in the Whiskey label... Last, you could spice it up with if(!(control != 0)), that would make it really nice! Keep It Simple Stupid! (KISS)

Try SELECT myid, mydate FROM myTable mt1 WHERE not exists (select 1 from myTable mt2 where mt2.myID = mt1.myid and mt2.mydate is null) Assuming the table is properly indexed this should execute quicker as a not exists is quicker than a not in. Bob Ashfield Consultants Ltd

If you are using .net 2.0 you could do: // Get the Web application configuration. System.Configuration.Configuration configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration( "/aspnetTest"); // Get the section. AuthenticationSection authenticationSection = (AuthenticationSection)configuration.GetSection( "system.web/authentication"); Ben

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

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

Odds are this is homework, but check ViewState/Cache/Session

You can use the regular expression with the Regex class to get rid of the hidden html markup in the output result (oStringWriter.ToString()) before sending out to the output stream of the Response object.

Where do you define the tr element? I guess that you may use the ItemCreated/ItemDataBound events to count the RepeaterItem, then you can make the tr visible/invisible in the way you want.

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

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

Well thanks for the tip. I did try no width and height specification and that did not work. It seems the calendar control does have a default fixed width and height. RB -- modified at 17:02 Monday 24th April, 2006

RadioButton wrote: Is there any easy way to fix this? Don't use IE? ;P As near as i can tell, Firefox is doing the "Right Thing" here - spans are inline elements, width and height attributes do not apply. So... You can use a div (or other block element), you can add the display:block; attribute to the span, or you can float or absolutely position the span. ---- Scripts i've known... CPhog 0.9.9 - make CP better. Forum Bookmark 0.2.1 - bookmark forum posts on Pensieve Print forum 0.1.2 - printer-friendly forums

javascript can set a timer. I dont remember, because I find other ways to do these things, but its like window.setTimer and window.setTimeout that will do your page refresh. This will also force a postback. Maybe you should keep a flag in the session and the refresh page can check it in the postback and query if necessary 1 line of code equals many bugs. So don't write any!! -- modified at 15:47 Friday 30th December, 2005

I just dont understand. IE has a timer refresh function, if thats what you need. It would be better to force a postback, at least it makes it easier to read. Back tracking javascript is annoying. And it you keep the data in a viewstate as long is its not to big it would be fine. Or create a new Web Server Control of the page. Then you can call and set properties and just do a page refresh, without an ugly IFRAME. It would be easier maitain. And maintenance is more important. Nick 1 line of code equals many bugs. So don't write any!!

IMO, You cannot. Cause the web server will serve if client sends a request to him... So, for me, the work around for this issue is that you make your web page is refreshed itself after an interval time...to detect if the record is added... Just an idead.. << >>

Better yet :-D daniero