Spigot's Q&A profile
SQL Server Accessing previous row in Asynch Script Component
I have a series of records that are timestamped and ordered by time ascending. i.e. Time TimeToNext 02/07/2007 11:38:22 0:00:21 <--- Need to calculate these 02/07/2007 11:38:43 0:00:22 <--- Need to calculate these 02/07/2007 11:39:06 0:00:00 <--- Need to calculate these 02/07/2007 11:39:06 0:00:36 <--- Need to calculate these 02/07/2007 11:39:42 0:00:28 <--- Need to calculate these 02/07/2007 11:40:10 0:00:26 <--- Need to calculate these 02/07/2007 11:40:36 Last Record <--- Need to calculate these I need to calculate the difference in time between each of these records. The flow ...Show All
Visual Studio 2008 (Pre-release) TransactionIsolationLevel and multiple service contracts
I have a service which implements several contracts, which works fine, e.g. class MyService : IMyContract1, IMyContract2 { // Implement both interfaces in here } This works fine, but in my case IMyContract2 has an operation where I want to flow a transaction, so I use an attribute to set this on the operation: [OperationBehavior(TransactionAutoComplete=true, TransactionScopeRequired=true)] I want to set the isolation level for this, so I add this attribute to the Service: [ServiceBehavior(TransactionIsolationLevel=IsolationLevel.ReadCommitted)] The problem is, when I try to host this service, I get the following exception: Unhandled Exception: System.InvalidOperationException: The service 'MyService' is configured wi ...Show All
Software Development for Windows Vista Ask about user and group policy?
I a little bit confuse about Vista user and group policy. After installation, the installer ask about creating an user but not setup password for administrator like XP does. So I think after installation the user will be under administrators group, and it does, I have check it on Computer Management. But the question is even my user that I usually use to logon under Administrators group, why cannot login to SQL Server 2005, it said the user is invalid user. Then I try to login with sa and check security the group Administrators have been registered. Then the next one is when I "Configure Web Synchronization" the user cannot do that (even the user under Administrators group), so I must right click on the Configure Web Synchronizat ...Show All
.NET Development .NET Framework 2 install hanging on Windows 2003
I'm trying to install the .NET Framework 2.0 on a Windows Server 2003 SP1 machine. The progress bar on the "Setup is configuring the install. This may take a minute or two." screen gets to 100%, but it just sits there...no hard drive activity and no CPU usage; it never completes. The text in the dd_* log is below. Can someone help point me in the right direction on how to get this installed Thanks, Justin [12/04/06,10:21:58] ========== Logging started ========== [12/04/06,10:21:58] ===================================== [12/04/06,10:21:58] No language specified in ini file default to OS language [12/04/06,10:21:58] Set lang to 1033 [12/04/06,10:21:58] Pending Reboot Table state : Logging start [12/04/06,10:21:58] _____________ ...Show All
Visual Basic Listview change item fontstyle
I everyone... i'm having some problems when i'm trying to change a item fontstyle in a listview (details view). Code: frmMain.FeedsList.Items( CInt (id1)).Font.Style = FontStyle.Regular The problem is the property FontStyle is read-only. Can anyone help me with this please Thanks I've got the solution... frmMain.FeedsList.Items( CInt (b(1))).Font = New Font(frmMain.FeedsList.Font, FontStyle.Regular ...Show All
.NET Development problem reading xml data
Hello, I probally am doing something wrong, please note that this xml data can be read with xml notepad 2007 fine. I have the following code: Dim UPS_BILL As New System.Xml.XmlDocument UPS_BILL.Load( "C:/UPSXML.XML" ) TextBox1.Text = "UPS XML DATA:" & vbCrLf If IsDBNull(UPS_BILL.SelectSingleNode( "UPS_EBR_BILL/XMLBillFileVersion" )) Then <--- Errors here Else TextBox1.Text = TextBox1.Text & UPS_BILL.SelectSingleNode( "UPS_EBR_BILL/XMLBillFileVersion" ).InnerText.ToString End If i get the following error: System.NullReferenceException was unhandled Message="Object reference not set to an instance of an object." Source="UPS_XML_WEEK ...Show All
Windows Live Developer Forums not well-formed (invalid token) error
I keep getting this error that crashes my program: not well-formed (invalid token) at line 1, column 1945, byte 2017 at /usr/local/lib/perl5/site_perl/5.8.7/i686-linux/XML/Parser.pm line 187 What does this error mean and is there a workaround Looking at my log files, my initial impression is that the api chokes on special characters in html, and this in turn crashes the api. Thanks for any help. I have found an explanation for the "invalid-token" error when trying to parse certain documents. The underlying principle is that the XML::Parser module does not accept certain characters in the text: & (ampersand, must be encoded as & ) < (left angle bracket, must be encoded as &l ...Show All
Visual C# best way to do file watcher/file validator
I need to create a program that will watch a directory to see when a new file is placed in it. When there is a new file, certain error checking will be done and certain fields will be populated in a SQL table. The error checking will be done in C#. Then the file will be moved to another directory to signify that it has been validated. I am just wondering what the best way to do this is - can the file watching be done in C# or is SSIS the best way to do this Is there something that can watch the directory up until a certain time - say I want to do all checking from 8-9am and then stop. Would I need to schedule something, or can this be programmed in code Thanks for any help. Saeed I'm not an expert on t ...Show All
Visual Studio 2008 (Pre-release) Application.GetRemoteStream() break in RC1
just moved an XBAP app from June CTP to RC1. the app is making an Application.GetRemoteStream() call to download a file to parse on the client (with a relative Uri). this used to work in June CTP, but RC1 returns a null (not a SecurityException). in fact, it fails in both partial trust and full trust. any idea what has changed Thanks, casey i think that explains why it's not working for RC1 ... the project has -DebugSecurityZoneUrl set so that an external WS call can be made. then later on we call GetRemoteStream(), thinking that it would grab from the application base directory; because the bar.xml file is not yet deployed to the -DebugSecurityZoneUrl setting. GetRemoteStream() gets an inter ...Show All
SQL Server Accessing lower level members
Hi All, I have used .Children function to retrieve members of dimension at one level below the current level of dimension. For example (using FoodMart 2000 and AS 2000) Select NON EMPTY ( { [Measures].[Unit Sales] } ) ON COLUMNS, NON EMPTY ( [Customers].[Country].[USA].Children ) on rows >From sales This query returns me Children of member Country which is USA. It returns all members of State Provinces which have USA as its parent. Can I access or retrieve all members of City with Country member being USA I am building a web application where user applies filters. This is necessary because if user wants to view sales data about City which belongs to country USA. Many thanks in advance. Raghu Hi Raghu. Ye ...Show All
Smart Device Development Help regarding creating the views in MFC
Hi, I m new with MFC. I want to create more than 1 view in the main frame. I dnt knw how to do it. And also create custom listbox and display it on the frame window.Plz help. MDI isn't a nice usage model for devices and isn't recommended either. We are restricted to SDI applications. But you may consider using splitter window class that was added with VS2005 SP1. Using it you shall be able to split the screen between multiple views. Property sheets may also be a reasonable option. Hope this helps. Thanks ...Show All
Visual C++ Can't get Csv format for clipboad to work with unicode
I have been struggling with writting a comma seperated string to the clipboard with the intention of pasting the string into excel. The code below works fine for all three character sets (ANSI, MBCS, and UNICODE) when using appropriate standard formats CF_TEXT or CF_UNICODETEXT. When I add the Csv format everything works ok for ANSI and MBCS but does not distribute the values seperated by the commas in the text strings into individual cells in UNICODE. In fact, when I paste special and select Csv, all I get with UNICODE is the first value in the first cell as opposed to 1 in first cell, 2 in second cell, 3 in third cell, and 4 in forth cell. I get the Csv in seperate cell with my project set to ANSI or MBCS. What am I doing wrong I use ...Show All
SQL Server Bulk insert
I m a newbie in Stored Proc. Here I m working with some stuff for importing the csv files then write those inside to MSSQL Server. However I get confused what steps I shoud take. Here's the Stored Proc I've written. Instead of running execute proc_TestIT '11113333', 'V', 'Tony Jones , those records would be kept in a csv file instead with at least 100 records per each csv file. I am wondering if I should use bulk insert and what I should do with the SP I 've written. As only 10 out of all the 20 columns in the interface file would be required for the updates/inserts. I m wondering where I should start. ---execute proc_TestIT '11113333', 'V', 'Tony Jones' CREATE Procedure proc_TestIT @Locker_No Varchar(10), @Locker_Type ...Show All
Visual C# VS2005 Startup
Hi, Just got a new PC and installed VS 2005 on it. Works fine but everytime I start VS2005 it acts like it is the first time it ever started. Get a dialog that says, "Microsoft Visual Studio is configuring the enviroment for first time use." Not sure what to make of this Any thoughts Thanks Jeff Hi there. This is interesting. Can you see if resetting the settings will work Be warned that when you do this, that dialog will come up again but hopefully it won't after. To do so: open the visual studio command prompt (from the start menu, all programs, visual studio 2005, tools) then: devenv /resetSettings does this work Some AV software tracks changes made but ...Show All
Visual Basic Long Numbers
Hi, I would like to write applications, such as calculating pi, generating Mandelbrot Sets, factoring large numbers or prime hunts, which use extremely long numbers. I'm not talking about the measly 32 decimal places of the Decimal variable. I'm talking about two or three thousand decimal places. I've written a couple long number calculators which are, quite frankly, crude, cumbersome and slow. My approach has been to create arrays of byte characters, assign one digit to each byte, and then try to program the whole thing to handle addition, subtraction, multiplication and division; all the while trying to keep track of decimal places and polarities. It seems to me that there has to be a better way. Anyone know if it is possible to ...Show All