Could it be that either stop_time or start_time is NULL. In that case the result would be NULL. The need to optimize rises from a bad design. My articles[^]

You can't delete using a pattern, you need to identify each file and delete it individually. Use the directoryinfo getfiles method with a pattern filter, loop and delete each file. Never underestimate the power of human stupidity RAH

Can you tell what class or function I need to use to get the "Save As" dialog box to pop up when the save button is press in ASP.Net using C#? Thanks.

Does this helps? http://www.codeguru.com/Cpp/controls/listview/backgroundcolorandimage/article.php/c4181/[^] Saurabh

Hi try to accomodate your page at any resolution, this is the best way to persent your pages, if you have any complicated design, use screen.availHeight, screen.availWidth, best way to keep the resolution in the server side, in the login screen, send this height and width as comma separated values by hidden control. once you authenticated the page, you will keep some user information in the session, same time keep this height and width in your session, Note: if the user resize the screen, server side values can't updated. Regards Elayaraja.S

The real question is, why do you want to ? I mean, there are limited ways in which that can help in ASP.NET because the class is generated on a postback and is gone when the page is sent back. Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

You would need to write a web windows service that uses a timer to run some code to generate a file at hourly intervals. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush modified on Friday, December 21, 2007 3:17:10 PM

Sometimes when I am stepping through the code and find a problem, I like to start fixing it there.

Is there a C/C++ funciton that will remove a character from a string? I want to remove the decimal from the input string. If someone enter 1.23, I want to use only 1.2, remove the decimal making it 12.

Please don't ask questions unrelated to Managed C++/CLI on this message board.  Use the Visual C++/MFC board instead. To set the color(s) of edit controls, you can respond to the WM_CTLCOLOREDIT message in the parent's windowproc and set the text and background colors. Mark Mark Salsbery Microsoft MVP - Visual C++ :java:

FYI... I recommend keeping a link to this:  Control Library[^] or the equivalent link in your local development MSDN library. It's the documentation for all the Windows common controls, including messages, notifications, and APIs. Mark Mark Salsbery Microsoft MVP - Visual C++ :java:

Ok.  The point was, you can use custom draw to achieve this.  It's no different with MFC than without MFC, except where you handle the messages. Mark Mark Salsbery Microsoft MVP - Visual C++ :java:

Sql Server has a huge number of tools and features that goes with it. It brings huge ammounts of value beyond simple database functionality. With 2005 it now also supports .Net stored procedures, triggers and datatypes, although these are for use where the traditional TSQL falls short rthaer than as a replacement. TSQL is very nice to use and also has a mass of powerful features. I've never personally use MySQL but I've never really heard anything good about it, all I've ever heard is developers complaining about it being broken or lacking. But then again I don't hang around in very pro-MySQL places ;) I think most people use it because it'll run on Linux and isn't made by the evil empire. Personally I think the evil empire is so big because it makes some great products, especially Sql Server :P

and what is valid ?

Do you want to check for the ID of the PK column or the order of the record? in the first case: Select *,case (ID % 2) when 1 then 'Odd' Else 'Even' End from items in the second case (SQL Server 2005 only): Select *,case (row_number() over (order by ID) % 2) when 1 then 'Odd' Else 'Even' End from items Hesham A. Amin blog

The Contains method, I believe. If not, it's FirstIndexOf or something like that. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

may u can use triggers like this: CREATE TRIGGER myTrigger ON myTable FOR INSERT AS /* here check the count of rows and delete smaller id*/ BEGIN DECLARE @count int; SELECT @count = COUNT(*) FROM myTable IF(@count>60) BEGIN DECLARE @first int; SELECT @first = MIN(ID) FROM myTable DELETE FROM myTable WHERE ID=@first END END and if you want to have your ID column Identity and only from 1-60 use IDENTITY_INSERT check msdn and web for more I Wish the Life Had CTRL-Z

Awww thanks man! :)

This will return all of the tables from the db the query is running under... select * from sysobjects where xtype = 'u'