Cameron D's Q&A profile
SQL Server Grouping Data
Hi Exports I have a simple question, but I can't seem to get around it. Please help. I have a table like this: [select * from Enrollment] Course ID PersonID Role BCC110 123 Student BCC110 321 Student BCC110 456 teacher BCC123 457 Student and I want to have a report like Course ID Total Students Total Teachers BCC110 2 1 BCC123 1 0 How do I achieve this Sam This will be more efficient, as it should only 1 table read instead of 3: select e.CourseCode, sum(case when role ='Student' then 1 else 0 end) as TotalStudent, sum(case when role ='Teacher' then 1 else 0 end) as TotalTeacher ...Show All
Visual Studio Team System Validation Rules
Hi, I am running webtests against a portal. <td align="right"><label for="ctl00_Dashboard_MainLogin_UserName">User Name:</label></td><td><input name="ctl00$Dashboard$MainLogin$UserName" type="text" id="ctl00_Dashboard_MainLogin_UserName" /> <span id="ctl00_Dashboard_MainLogin_UserNameRequired" title="User Name is required." style="color:Red;visibility:hidden;">*</span></td> Trying to use the Required attribute Value validation rule to check for the * - using Expected Value - * Match Attribute Name - title Matche Attribute Value - User Name is required. Tag Name - span This fails eve ...Show All
SQL Server Initializing a Merge Subscription Without a Snapshot - doesn't operate correctly
Hi! I do the backup from the publisher, next I restore it at the subscriber using *pure* database. next I attempt to create subscription using this db. of course, I use SubscriptionSyncType .None for SyncType propery of the subscription. But, 1. nevertheless the merge agent downloads whole snapshot! both data (bcp files) and the schema. 2. I get the *strange* error. below thelines from the log: Applying the snapshot to the Subscriber A dynamic snapshot will be applied from 'C:\DOCUME~1\...\LOCALS~1\Temp\DB$MAIN_DB1_Main_testReplFromBackup\' Preparing table '__UserSyncOptions' for merge replication Applied script '__UserSyncOptions_2.cft' {call sp_MSsetconflicttable (N'__UserSyncOptions', N'MSmerge_con ...Show All
.NET Development Parameter name: Policy 'XataClientPolicy' is not configured in the system
Hello. I'm developing a VS2005(VB), ASP.NET 2.0, .Net Framwwork 2.0, WSE 3.0, Web Application. In the following code i'm getting an error on the SetPolicy line. The error is : "Parameter name: Policy 'XataClientPolicy' is not configured in the system" Dim proxy As New xatanetconduitwebservice.XataNetConduitWebServiceWse proxy.Url = " https://www.xatanet.net/XataNetWebService/XataNetConduitWebService.asmx " Dim user As New UsernameToken(txtCompany & "\" & txtUserName, txtPassword, PasswordOption.SendHashed) proxy.SetClientCredential(Of UsernameToken)(user) proxy.SetPolicy("XataClientPolicy") I have 'XataClientPolicy' as an application policy on the policy tab of the WSE3.0 settings. The wse ...Show All
Visual C++ formatting output to a file
The problem i am having is trying to format a double type output to show the thousand comma. Meaning ##,###,###.## . The number is of double type with 2 decimal points. 1111111.11 How would i be able to change the output to show the thousand comma just before printing to an output file i am using sprintf to output to file. thank you, mike i guess i forgot to mention that the value of the number changes and therefore the location of the array changes .. unless theres another way i dont know about. the number can be from 11.11 to 111111.11 mike ...Show All
Internet Explorer Development IE 7 - scrolling jumps
Is there a default setting I can change in IE7 that will stop the jumping when I try to scroll using a mouse wheel It's almost as bad as what I see when I'm connected remotely to another machine. Thanks, R. Hill I have the same problem! I just hate this feature and I don't know how to change it either. Have you figured it out yet Let me know. Thanks Jackie ...Show All
Visual Studio Update
I've been native VC++ debugging for weeks with VS2005, and after several debug sessions this morning, suddenly I can no longer debug my local apps - I'm given this message: Unable to connect to the Microsoft Visual Studio Remote Debugging Monitor name <myMachine>. The binding handle is invalid. ...but in the first place, I'm not trying to do remote debugging. This appears to be the same problem as discussed here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=65188&SiteID=1 ...but that solution depended on a project property found only in the beta VS2005, which does not exist in the GA/RTM release of VS2005. The property is called "Enable Visual Studio Hosting Process," and ...Show All
Visual Studio DataGridView wrapper - additional property-combobox fill up
Hi All, I have made a datagridview wrapper, in wich I add properties to grid for the developer to see at the design time in properties window of the grid . The properties in which developer has to type in a value, those are easy to do. But now I have to make a property as such which appears as a combobox and has 2 values(same as autoscroll property of datagridview -where we have true and false as two default values, and false is default) which are strings and appear in dropdown. I have been able to make a property appear as combobox, but I am nto able to fill up the dropdown list. The code to make property as combobox is here below: ComboBox formManagerMode; public ComboBox FormManagerMode { get { ...Show All
Visual Basic Opening .vbp in Visual Studio .Net 2003
Hi I don't know if this is a silly question or not - I have v.little experience. I am trying to open a VB6 vbp in Visual Studio .Net 2003 and it just opens as text. Is there something special I should be doing or do I need to open the vbp in an older version of Visual Studio. I am not looking to upgrade the code - just read it. Thanks in advance If you are wanting VS to auto open all of the project files then you will have to use an older version of VS or tell VS to upgrade the current project...Otherwise you can open the actual code files one at a time (in any text viewer)inorder to just read them! ...Show All
Microsoft ISV Community Center Forums Object Browser
I find the object browser very useful for finding out what objects are available to me. However, it would be more useful if I new what the small symbols or icons denote just to the left of each object/class (e.g. an easy one to describe would be a hand holding what looks like a card and another a green object with what looks like motion lines coming off of it). Would anyone who knows what I am referring to be able to list what they mean Cheers! No worries Keithyboy, The grey square with the red, green and yellow blocks on it is a class. (i.e. Application) The green moving thing represents a method of the class (i.e. Application.SetDefaultChart()) The finger pointing represents a property of ...Show All
Smart Device Development Cannot connect Windows CE 6.0 DeviceEmulator via Activesync
Hello, When I clicked "Cradle" in Device Emulator Manager, the ActiveSync tried to connect but finally showed the dialog window "Microsoft ActiveSync cannot recognize this device for one of two reasons: *The deicve was not connected properly. *The device is not a Smartphone or Pocket PC." Some background: 1. Catalog item "ActiveSync" is added in OSDesigns for building the run-time image. 2. DMA support in enabled ActiveSync (v4.2). Thanks. My Senior pointed me to following things that could possibly be happening. 1. You might have built your image with KITL-over-DMA enabled. If this is the case, possibly it could be interfering with Activesync transport which happens to be ...Show All
SQL Server Sql Sever Job Steps
I am trying to create a SQL Agent job with 3 steps. I want to delete three tables. Step 1 ...delete table "X" Step 2 ...delete table "X" Step 3 ...delete table "X" problem is that afer i create the three steps and start the job it never seems to finish the first steps and non of the other steps run, the job looks like is executing and never finishes. I break the job into three jobs each completes fine. I need this to runs one job, any ideas perplexed for sure..... You might want to have a look at the way each of te steps is configured, you might find that the step is configured to finish at completion, you need to make sure that the step is configured to move onto the next step aft ...Show All
Internet Explorer Development BHO sample code?
Hi, all! I've found the BHO article on MSDN (the browser the way you want it)...but it mentions source code and provides no link. I need to make a BHO for a school project, and in this class it's perfectly acceptable to modify sample code. Can someone point me toward either a C++ or a C# sample of a BHO I'm writing something that will add to the right-click menu and also, hopefully, pop an extra window into the browser that will use the Amazon API to display data about books based on ISBNs that are displayed on the current page. Thanks, William If you are specifically interested in just extending IE's context menu, you might also want to check out http://msdn.microsoft.com/library/default.asp url=/work ...Show All
.NET Development Installation freezes
I have been attempting to install the .NET framework on an XP Pro machine, but it continues to freeze. First I attempted to install v2, but now have been directed to use v1.1 for work. I was given a cleanup tool, but this has not helped. There appears to be registries for v2 in my system. The installation cointinues to freeze and now my CPU is cranking at 100% all of the time (plus Norton has identified a common .dll as a virus). Any thoughts One thing to try is to get your original copy of .NET Framework 2.0 ( http://msdn2.microsoft.com/en-us/netframework/aa731542.aspx ) and reexecute it. You will be given the options of repair and uninstall. Choose repair. Then run again and choose uninstall. ...Show All
SQL Server RS.exe and date-type parameter.
Hi All, I have a report with 4 parameters, 2 of them are date-type parameter. I intend to run this report via RS.exe by passing different parameters for different scenario. The issue that I have at the moment is passing date-type parameter via the VB Script file. In my report I use "dd-mm-yy" format. I tried many ways to assign date value to my parameters, but I am always getting the following error: "Unhandled exception: Default value or value provided for the report parameter 'myParam' is not a valid value". Syntax that I use: myParam = "01-01-1900" myParam = DateTime.Parse("01-01-1900") myParam = DateTime.Parse("#01-01-1900#") All of them didn't work. My questi ...Show All