web.config as far as I know .. you could test it easily yourself if you want to be more sure .. in global.asax, write some code in session_start and session_end to save the current time in a log file .. For example, in global.asax: void Session_Start(object sender, EventArgs e) { using (StreamWriter sw = File.AppendText(Server.MapPath("/session.log"))) { sw.WriteLine(String.Format("Session started at {0}", DateTime.Now.ToString())); } } void Session_End(object sender, EventArgs e) { using (StreamWriter sw = File.AppendText(Server.MapPath("/session.log"))) { sw.WriteLine(String.Format("Session ended at {0}", DateTime.Now.ToString())); } } and don't forget to add this at the top of the global.asax file (just below <%@ Application Language= ...): <%@ Import Namespace="System.IO" %> Waleed Eissa .NET Software Developer in Sydney modified on Wednesday, December 26, 2007 12:16:37 AM

VK-Cadec wrote: is anything off with the syntax? Yes, if you do division using integers the result is an integer (as you've found). Double i_decel_rate = ((Convert.ToDouble(textbox1.Text) * 10000.0) / Convert.ToDouble(textbox2.Text));

Either format is okay! However, the format without breaks loads and parses faster, saves disk space, and possibly some memory. By the way, if you want to make your XML file even smaller, use attributes wherever possible. "We make a living by what we get, we make a life by what we give." --Winston Churchill

In that case, putting them in a config file or being able to accept them as command line parameters would be the right way to go. ----------------------------- In just two days, tomorrow will be yesterday. http://geekswithblogs.net/sdorman

XML configuration files, there are plenty of articles here at CP on the topic I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

VK-Cadec wrote: I want to convert my app to run from command line. Any application can be run from the command line. Do you mean you want it to be a Console Application and output to the console you ran it from? Do you mean you want it to run as a Windows Forms Application and just take some command line arguments? If you do just want to use command line arguments did you bother to google[^]?

PadRight will not limit the length it will only pad it. You example is not correct, but if you did: String1.ToString.PadRight(6) = "Traile1" you would still get all seven characters. If you want to get only six characters you will need to substring after the padright String1.ToString.PadRight(6).Substring(0,6) Hope that helps. Ben

That'll work just fine, as well. "The clue train passed his station without stopping." - John Simmons / outlaw programmer

It is comma delimited csv file that is being read. To change the comma to a tilda(~) delimited file, would changing in those two places a comma occurs to tilda work? Thanks.

You need to use ## for a global temporary table. A temporary table whose name begins with a single # is a local temporary table and is local to the connection. SQL Server 2005 documentation says: "There are two types of temporary tables: local and global. They differ from each other in their names, their visibility, and their availability. Local temporary tables have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user, and they are deleted when the user disconnects from the instance of SQL Server. Global temporary tables have two number signs (##) as the first characters of their names; they are visible to any user after they are created, and they are deleted when all users referencing the table disconnect from the instance of SQL Server." Stability. What an interesting concept. -- Chris Maunder

From what i remember you can just specify the command you want it to execute. Brad Australian - Christian Graus on "Best books for VBscript" A big thick one, so you can whack yourself on the head with it.

In my stored proc, changed a DML "truncate" to use "delete" - it is now working.

Never mind - found it. select * from sys.indexes

Put it in a transaction. Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

The only way to know which file was written to last is to get the LastAccess time for every file in the folder, sort the list and get the filename off the top of the sorted list. The LastWriteTime of the Directory is a change in the directory entries for that folder, not the last write to a file in that directory. Also, The FileInfo class constructor takes a filename as a string as an argument. You're supplying a DateTime object (_direct.LastWriteTime) as the argument, which won't work. Dave Kreskowiak Microsoft MVP - Visual Basic

VK-Cadec wrote: Is there a way we could return the result in above format - know of hours, minutes, seconds. DateDiff returns the result in an internal format. It is merely the rendering of that data on the screen that gives it a format. The formatting of data should be the function of your application's presentation layer, not the database. Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

Verify each item outside the UDF. That way you will see if it actually returns data.

Make a function: CREATE FUNCTION [dbo].[RoundMinutes] (@dDateTime datetime) RETURNS DateTime AS BEGIN declare @minutes int set @minutes = datepart(n,@dDateTime) set @minutes = case when @minutes < 7 then -@minutes when @minutes < 23 then -@minutes+15 when @minutes < 37 then -@minutes+30 when @minutes < 52 then -@minutes+45 else 60-@minutes end return(dateadd(n,@minutes,@dDateTime)) END Call it like this: select dbo.roundminutes(datefield) as RoundedDateField from mytesttable --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

Here is an example of what I was talking about using the if elseif then statement. This assumes you have two labels on a form named Label2 and Label3. Private Sub Load_Time() 'calculates the rounded time Dim newtime As DateTime Dim min As Integer = Now.Minute Label2.Text = Now.ToShortTimeString If min >= 0 And min <= 15 Then 'First Quarter If min > 7 Then 'move up newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, 15, Now.Second) Label3.Text = newtime.ToShortTimeString Else 'move down newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, 0, Now.Second) Label3.Text = newtime.ToShortTimeString End If ElseIf min > 15 And min <= 30 Then 'Second Quarter If min > 22 Then 'move up newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, 30, Now.Second) Label3.Text = newtime.ToShortTimeString Else 'move down newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, 15, Now.Second) Label3.Text = newtime.ToShortTimeString End If ElseIf min > 30 And min <= 45 Then 'Third Quarter If min > 37 Then 'move up newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, 45, Now.Second) Label3.Text = newtime.ToShortTimeString Else 'move down newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, 30, Now.Second) Label3.Text = newtime.ToShortTimeString End If ElseIf min > 45 And min <= 59 Then 'Fourth Quarter If min > 52 Then 'move up newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour + 1, 0, 0) Label3.Text = newtime.ToShortTimeString Else 'move down newtime = New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, 45, Now.Second) Label3.Text = newtime.ToShortTimeString End If End If newtime = Nothing min = Nothing End Sub Recreating the wheel is the best way to appreciate what the previous coders have gone through to get you where you are now.