Hello, I use OpenXML SDK 2.0 to generate Excel file with large amount of data, appox. 1000000 rows, and I need to optimize memory usage because my machine slow down very fast. I want to solve this issue by flushing part of generated DOM tree into file in runtime. I make my own buffering for data. E.g I have 100000 records to write an...
I have a stored procedure where i am passing a simple XML : '<Products><ProductId>1</ProductId><ProductId>2</ProductId></Products>' I have a @temp table in SQL which has a ProductId Column: DECLARE @Temp TABLE( ProductId NVARCHAR(10) ) I need to write an insert statement which will loop through the ProductId's in the ...
I want to open a file on my VB6 application by pressing a command. The file is a filetype read by another program. I want it to open it and the program that reads the filetype should open as well because when it finds that filetype it opens automatically. Can anyone help me with this I'm kind of a newb at VB6 (just got it yesterday). ...
Hi, I'm working on the following code below, (edited for clarity), that is giving me a few problems with open cursors in Oracle. Basically I am trying to select data from the DB and for each row returned there is 0 or more rows of sub data to be selected and appended to the record. This is currently being achieved by calling out to anot...
Let's say write a C library, and I want all versions of the source to carry my copyright/license, but I want users of the library distributing executable code, static or dynamically linked library to be a able to do so without restriction (including making reference to my particular license). Does such an open source license exist? Tha...
I have some code that is using mechanize and a password protected site. I can login just fine and get the results I expect. However, once I log in I don't want to "click" links I want to iterate through a list of URLs. Unfortunately each .open() call simply gets a re-direct to the login page, which is the behaviour I would expect if I ha...
i need to open a viewer for a given mime type. how to do that in linux. i suppose the method would be specific to desktop environment in use. i want to do this through a C program. ...
Is there any easy to understand open source asp.net project related to HRMS ? ...
Hi, I'm new to mac and Cocoa so I'm sorry if this is a stupid question.. I need to read all the lines I wrote on a file I saved on my desktop. The file format is .txt; I tried with stringWithContentsOfFile but the program freezes. I tried with GDB and I noticed that, while the path is correct, the string which is supposed to contain the...
Is there a free open source Twitter Threading script/platform? ...
hello frnds I want to create a login class which will allow user to login with my site login details or any 3rd party Social Networking sites like Facebook connect ,google friend,twitter oauth,open id,yahoo. how to start with it i dont want to use rpx. ...
I'm facing a strange issue when trying to open an excel sheet through a C# application. it uses something like the following while the templatePath is "C:\template.xls" for example. Workbook excel_workbook = this.excel.Workbooks.Open(templatePath, mMissingValue, false, mMissingValue, mMissingValue, mMissingValue, mMissingValue, mMissing...
Hello. I have a Ruby on Rails application running on localhost:3000. I would like to make it available world-wide, using x.x.x.x:3000 (my IP address). I'm on Windows XP SP3. Thank you. ...
I just noticed that not all icons in the dock allows you to drag files to them. For example, I can drag a file to textedit but not finder. What exactly is it that decides whether or not an application supports an action like that? Just curious. ...
Hi, In my OpenSocial application i have stored the orkut user id, user name, thumbnail url to my db. I can show the user profile by using these fields. Is there any way to show the user profile by using the stored user id only? ...
I'm doing a case study (well, hoping to) on a migration from Win/ASP/SQLServer to a Linux/Pylons/Pgsql codebase. I was just wondering if anyone has any thoughts, pointers or experience in making such a dramatic shift. ...
All the code below works. My device responds, C,7 is a reset. When I run this the second time it doesn't respond. If I manually turn my device off and on, then run this script again it works. But not if I press the button to run the script the second time. RS232: 57600,8,N,1 Any ideas?? Is there any more information needed to solve thi...
I was wondering how databases are managed in open source projects which are usually hosted in repositories like CVS or SVN. Placing codes in the SVN is very logical as it allows different team members to get updated pieces of code but how about databases? Are their schemas and contents (.sql files I assume) placed inside the SVN too? In...
Is it possible that win32's _open() return valid FD that is negative ? In other words, is comparison if( (fd=_open(...)) < 0) error...; as safe as form if( (fd=_open(...)) == -1) error...; ? I am asking because all msdn examples are in form if(fd == -1 ), and never form if( fd < 0). ...
In Perl, how do I test if a file of open by another Perl program? I need the first program to be done before the second program can start. ...