DyngoMan's Q&A profile

• SQL Server how if esle statement works??

  hi, everybody! I have some problems with understanding how if esle statment in sql works. I'm trying to write my own count() -function and its not working with if else :(( I've already implemented it with case : select sum(case (hiredate) when (null) then 0 else 1 end) as 'Count' from emp It's working perfect. Now I want to have the same but using if else : select sum( if( hiredate is null) begin 0 end else 1) as 'Count' from emp the error message is: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'if'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '0'. What is wrong here In SQL Server, IF - Else is a control flow statement that allows you to conditiona ...Show All

• Windows Live Developer Forums Messenger Command Line

  Greetings :) Maybe this question has been asked before. I tried searching but there were no hits :) Is there a command line tool where I can say msmsgs.exe \startchat <user_name> (we can assume the messenger is already logged onto the exchange server & running in the background). Thanks. Brick IM, this is again no answer to the question, but just spamming your url . I'm sorry, but as far as I know there aren't such command line options. If you wanted to use it to make shortcuts on your desktop for certain contacts, I advice you to search the internet, I know such a plugin exists. I thought it was something with Msg Plus!, but I can't find it at the moment... ...Show All

• Visual Studio Express Editions process invisible

  Hello, I have designed a program with VB express that when run from the .exe file, it runs as a process. I have prevented the program from showing in the taskbar when running minimised as I want the program to be invisible to the user. I used the form properties to do this. But now when I run it it shows up as a tab down near the start button on the desktop. How do I make it invisible when running in the background Note: I still want it to be seen in the Task Manager so I can shut it down from there. Also: Why is my program showing in the Task Manager as a process and not as an application Thank you for any help. Harvs. ShowInTaskBar should be False - Hides the application. How ar ...Show All

• SQL Server Using ASP.NET Session State in SQL 2005 with a Mirror

  I have SQL 2005 mmirroring sucessfully working in an ASP.NET 2.0 web application. I also have session state being maintained in SQL Server using the built-in functionality in ASP.NET. The problem is, even with "allowCustomSqlDatabase=True" and specifying a failover partner in the DSN, it appears that ASP.NET does not work with the failover partner. It always tries to get the session info from the "data source" server specified in the DSN. Is there a way to get the session state to fail over to the mirrored server without writing a custom session state provider Hello Todd. I am having a similar problem. We have two Web Servers which are configured for database Mirroring. I am tryi ...Show All

• Windows Live Developer Forums Anyone else having zoom issues when using multiple tile layers with adjustable opacity?

    I'm loading multiple tile layers and a VEcollection into my map at http://thecascadian.com/ for my blog entries. That all works fine, but when you select a layer in the dropdown, and then double click on that tile layer, it zooms to the highest detail view instead of just one step "in". I see this effect on the first layer selection from the dropdown when it's the 3rd of 3 loaded layers for the entry (murky waters entry) and I see it on the 2nd layer selection from the dropdown for the first 2 layers loaded if there's 3 layers total (murky waters entry), or on the 2nd layer selection if there's just 2 tile layers loaded (welcome entry).  I'm not capturing the dbl click event (or single click) in any way in my scr ...Show All

• Windows Forms Just Use Setup.exe

  I have an app i wrote in vb .net to handle installations, its called Install.exe I read that when VS creates an installer with the 2.0 framework as a depenency it generates a setup.exe and a setup.msi can i instead of having setup.exe calling setup.msi when the framework is setup, have it call data/Installer.exe (my app, in a sub-directory called "data") ...Show All

• Visual C# Visual Studio 2005 Locks / Freezes with devenv 100% - CSS Problem?

  I spent a few hours trying to figure out this issue and I narrowed it down to VS 2005 having a problems with CSS. In a project I started recently I have an ASP.NET page that anytime I go into design mode and drop a control on the page VS 2005 will freeze with devenv going to 100% and sometimesy VS 2005 crashes if it does not I have to kill the devenv process. This happens anytime I go to design view or drop a control on the page. I found that when I removed my references to my .css file the problem stopped and I could add controls and go into design view. Then if I add my css link back in the IDE freezes again. This code is no different that what I would have done in VS 2003. Can anyone help me out on this issue Thank you, Patrick Her ...Show All

• Visual Studio 2008 (Pre-release) UIElement containing another application's window?

  Hello, I've seen the description (in MSDN docs) of UIElement that says: " UIElement can be considered roughly equivalent to a window handle in Microsoft Win32 programming". Maybe I'm taking this too literally, but *could* a UIElement contain another application's window For example, if you've seen the puzzle sample in the Windows SDK (v6.0\Samples\Demos\15Puzzle\Csharp), they do something pretty cool by splitting up different UIElement objects across the pieces of a puzzle, and scrambling the pieces. They have it working for video, some vector (svg-like) animation, 3D cube animation, and a windows form. I was wondering if it was possible to take this a bit further and show, for example, Microsoft Word or even the command-li ...Show All

• Visual Studio 2008 (Pre-release) where the XamlPad is?

  i have just my WPF&WF Extensions for Visual Studio 2005 installed, but unfortunately no XamlPad found in my program list! Why XamlPad is not installed by default Or, if you can use my silly XamlHack instead. Sheva ...Show All

• SQL Server Need help with a sp

  Hello, I am writing a stored procedure that is supposed to get info out of a table. E.g TABLE FRUITS Id Value1 Value2 1 Apple Banana 1 Apple null 1 grape null 2 Plum Melon 2 Plum null 3 berry null As you see there are six items with three ids but different info. If I select * From fruits WHere id =1 I get three rows. 1 Apple Banana 1 Apple null 1 grape null But In this case I just want to return two rows, namely: 1 Apple Banana 1 grape null Thankful for any suggestions, preferably in codeexamples. Best Regards, L Surely that' ...Show All

• Visual Studio Express Editions How do I print Ascii characters?

  Visual Basic 2005 Express Edition: I want to print arrow characters - up, down, right, left. I see them them in the Wingding font, but, how do I find out which key to use to select those characters Or, how do I know which ascii character number it is I tried the following code: For i As Integer = 0 To 255 RichTextBox1.Text = RichTextBox1.Text & i & " " RichTextBox1.Text = RichTextBox1.Text & Chr(i) & vbCrLf Next But, I need to switch fonts somehow in order to display i as a number, then chr(i) as a Wingding. For the left arrow in the Wingding font it tells me that the character code is 0xDF. I don't know what to do with that. I wish that it would ...Show All

• Visual C++ Why ATL contorl got WM_DESTROY mesage when it's loaded from a form in MDI App?

  I have an ATL activeX control, and I want to put that control into a child form in my C# MDI App. When I click "show child" menu, my child form should show up correctly. But my ATL control receives WM_DESTROY when it's loaded, and this is only happend in C# MDI enviroment. I trid to load it from MFC MDI app, it's fine. In my WM_DESTROY message handling, I want to do some final clean up,and I don't want it to be done when it is just loaded. Thanks for any help! I am using Visual Studio.Net 2003, and here is my code: ATL: created from "Visual C++ Projects--> ATL --> ATL Project" and the control typ is just a "Standard control". LRESULT CMyAtlControl::OnDestroy(UINT /*uMsg*/ , WPARAM / ...Show All

• Visual C++ How to start a console application hidden?

  Hello, I have some scheduled tasks on my computer that are executed through a PHP interpreter. PHP is invoked through a helper .bat file which always opens a console window in the middle of my screen. This is very annoying while working on the computer, especially over VNC where screen updates always take a little longer. I've tried to write a small Win32 main() application that just spawns the new process detached and then quits again, after the WinMain() function couldn't give me the command line arguments in a reasonable way (argc/argv) to pass them to an execv/spwanv function. But this has no effect, the new console process (a .bat file) is started but not only that redirection into a file works only in some of the cases, it also ...Show All

• .NET Development Using a MS Access database

  Hello, I look for some articels and examples about read and write to a MS Acess database(on my website). Diii The following should get you started: Walkthrough: Creating a Web Page to Display Access Database Data ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. My new game running on Beta 2 (Dr. Popper)

  Just wanted to let everyone know now that I have migrated my game to XNA Beta 2, and have put it up for download at http://www.bluerosegames.com . It's called Dr. Popper and it's a puzzle game similar to Pop'em, Jawbreaker, and Bubblet. I will post full source code for the game in a few days, but for now if you have any questions feel free to ask. Thanks, Bill Jim Perry wrote: I'll have to wait until lunch to try it out since I'm at work, but it looks good. Thanks Jim, hope you like it. I'd like to hear what you think. Bill ...Show All