Maybe I'm missing something, but shouldn't this work? var matches = from request in RequestTable             where request.MessageId == 2 and request.State == State.Completed             select request; Life, family, faith: Give me a visit. From my latest post: "How differently the psalmist saw it! How blessed -- how truly happy with real joy! -- is the man who delights in the Law of the Lord." Judah Himango

Dario Solera wrote: Wasn't he[^] who deleted all his messages and articles and just went away because of some discussion about something quite irrelevant in the SB? Looks like Micael may have had two log ins Michael P Butler[^] With respect, I must disagree. A quick look at middle management in just about any corporation shows that the dodo not only survived, it's reproducing in record numbers. Christopher Duncan

It depends on how the apps need to talk. You can communicate directly with the database which will pass the data back and forth. Otherwise, script whatever is needed. The VBScript will allow you to do anything with windows.

If they aren't sealed then it shouldn't be that difficult. Just derive classes from windowsidentity and windowsPrincipal. On the Application_Authenticated event. Construct a new identity and principal of your type from the existing windows objects and then replace both Thread.CurrentPrincipal and HttpContext.User and you should be good to go. If they are sealed, then just encapsulate them instead of derive from them. I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

Not unless they allow it, through properties on the command line. Christian Graus - Microsoft MVP - C++

Ya know, Fire and Ice would be cool for RedvsBlue.:-D Top 10 Geek Resulutions: 5. To decipher what that big room is, which has the blue ceiling and poor climate control.

Looks like it's the only solution My Blog

Here is something to get you started. It really needs to be wrapped in a transaction with a 'SERIALIZABLE' isolation level. Brutal if you have a lot of users. DECLARE PROCEDURE DeletePage ( DECLARE @PageID INTEGER ) AS DECLARE @MaxPageNumber INTEGER SELECT @MaxPageNumber = MAX(PageNumber) FROM Pages DECLARE @PageNumber INTEGER SELECT @PageNumber = PageNumber FROM Pages WHERE PageID = @PageID IF @PageNumber IS NULL BEGIN -- Deal with Bad PageId RAISERROR('Bad PageID',16,1) RETURN 1 END DELETE FROM Pages WHERE PageID = @PageID IF @MaxPageNumber <> @PageNumber BEGIN UPDATE Pages SET PageNumber = @PageNumber WHERE PageNumber = @MaxPageNumber END RETURN 0

Hi there. It looks like you might want to use the HttpResponse.AppendToLog[^] method. Since the Page object gives you the Response property, you can use the following line anywhere in your page code to append to the IIS log: Response.AppendToLog("String of text to append.") This article, Tracking Visitors with ASP.NET[^] on 15seconds.com shows this type of logging with an in depth example.

Hi Sebastien. Well, I'm gleaning from your question that you may be interested in the SQL Server CASE function, which you can put in the SELECT statement for the view. Look it up in the SQL Server books online (specifically the T/SQL documentation) and see if that's what you're looking for. Here's an article about using the CASE statement: http://www.4guysfromrolla.com/webtech/102704-1.shtml[^]

Sebastien_Lachance wrote: My english is not so great That's okay - I read some of your blog and it looks like your English is very good. I guess you were just typing in a hurry. Sebastien_Lachance wrote: I have a Select statement that select some records. Then I want to send those record on another database. So I wanted to generate a Insert Script, that "Insert" those record. If the two tables have the same columns then the easiest thing is: INSERT INTO [DestinationDatabase].[dbo].[DestinationTableName] SELECT * FROM [SourceDatabase].[dbo].[SourceTableName] You can, of course, use any select statement that returns the data you need. Does this help? Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums Upcoming talk: SELECT UserName, Password FROM Users -- Getting unauthorised access to a SQL Server, and how to prevent it.

You can do this if you use linked servers. Affordable and reliable hosting? Click here!

Great, thank you very much.:)

Great, The Pragmatic Programmer was in my list and for the other i was thinking about Refactoring: Improving the Design of Existing Code . Heard about it ? Well.. later

I have, in that result, an Sorry. Well.. later

Hi, Are you using OLE DB for the db connection or SQL Server? I've researched this error and it appears to be tied with OLE DB. You can read more about the IErrorInfo.GetDescription method here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbierrorinfo__getdescription.asp[^] From the docs, it says the following about DB_E_NOLOCALE error code: DB_E_NOLOCALE The locale ID specified by the lcid parameter in IErrorRecords::GetErrorInfo was not supported by the provider. If you are trying to use the OleDbConnection object, check the connection string to see if there's something missing. For more info on the connection string, go here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassconnectionstringtopic.asp[^] If you are using the SqlConnection object, read the connection settings here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassconnectionstringtopic.asp[^] If you need more help, don't hesitate to ask. ~javier lozano (blog)

You helped me find the solution. I have used base.Text and it finnally work, thank you so much.;) Well.. later