Search results for query: *

Hi, I am trying to figure this brain-bender out... How to split an ArrayList of > 2500 items into seperate ArrayLists of <= 2500 items. The size of the initial ArrayList may be anywhere from 2501 to 40,000 items. But i need to dynamically loop through and separate the list into <=2500...

Hi, I am at the point where I need to implement use of additional networked machines ("slaves") to perform processes that are called from one central "master" machine. The current build running local provides arguments to a local "worker.exe" through process.startinfo. How can I perform a...

Hi, I am working on a file processor that relies on the db to feed file records to different machines for processing. The problem I am having is the same file record (row) is being sent to 2 different machines simultaneously. In the db I have a "processing" column that flags the file record...

Hi, I have a SP that I am trying to achieve simultaneous select and update of the same (Top 30) IDs within a table. SELECT TOP 30 [ID] FROM Incoming WHERE Processing = 'N' UPDATE Incoming set Processing = 'Y' where Incoming.[ID] in (SELECT TOP 30 [ID] FROM Incoming WHERE Processing...

Hi - I am having a sick time trying to spawn a separate process independent of pageLoad Background: I have a site where files are requested from. Upon hitting "submit" requested files are written to db and file.copied to the storage location where the user will return to download (at a later...

Hi - I am attempting to upload files to ftp via the .NET FtpWebRequest. I can upload the file to the ftp via a stream method, but cannot figure out how to specify the "target file name" on the ftp. Dim Ftp As System.Net.FtpWebRequest = DirectCast(System.Net.WebRequest.Create(Host)...

I am stumped with trying to trigger a page load in a button click event. I would like to display a "processing" statement prior to a redirect using the code below. If someone could let me know how to trigger the page load and make the processingtxt.Visible = true that would be super! Here is...

I am having a problem with exporting to CSV from sql report server 2003. Each time I do this it will omit the first row of values returned...(works fine to excel). Instead of displaying the first row of values from the Group, it returns the names of the textboxes of the Details_Group ex...

I am looking for a way to retrieve the timing/duration of a .wav file to String or Integer through VB. I have a file scanning application that scans contents of a dir and returns file info using the FileInfo method of the System.IO class - but retrieving the duration/timing of a media file is...

This is a strange thing... when I apply an exslt transformation to an xml doc I get 3 leading HEX bits before the <?xml/> doc declaration. this reads "EF BB BF" in hex editor... and only shows up in a hex editor text - as asii - i (with two dots), >> , and an (upside down question mark) But...

I am trying to find a way to get the sum (hh:mm:ss) of all descendant <time> element's values (mm:ss) in the XML. The values of the descendant<time> elements are in mm:ss format, and I would like to be able to add all descendant <time> elements and rely on the XSLT processor to provide the...

Here is what I am trying to do - create a table or view that has an auto incrementing ID column that begins with 1018. I have tried this - but it does not like (Start WITH ###) CREATE TABLE MyTable ( IDCode INTEGER IDENTITY (START WITH 1018), Column2 VARCHAR (255), PRIMARY KEY (SongCode)...

I have several SQL rows of varchar data that have articles such as (A), (The) etc. placed at the end of the string. ex: "String Mover (The)" However, I would like to have this displayed as "The String Mover" However, a general rule of anything in () to the front of the string will not...

I am having problems with this logic... I am trying to update a table with new data from another table, but only where the values from the new table are not in the old table. UPDATE Table SET Table.Row1 = AnotherTable.Row1, Table.Row2 = AnotherTable.Row2 FROM AnotherTable Where Table.Row1 <>...

I am trying to weed out invalid characters from my data. I am having problems with characters that look like a square, I thought I could do something like an RTRIM() to eliminate them, but this did not work...?? Does anyone know what the "square" looking character represents? And how to...

I am attempting to create a well formed XML representation of my database using the FOR XML EXPLICIT function. However, after creating a UNION statement for just 4 of tables I need to export, it has practically slowed to a halt! I am sure some of this has to do with the UNION of the 4 select...

I am trying to find a way to DELETE or TRIM the word 'Track' from a column of values where the values look like: Track 01 Track 02 Track 03... etc. I would like to delete the word Track from this column. I am aware of the SELECT SUBSTRING(string,start_char,len) function... but I really want...

I am trying to insert new values into an established table. However, each time I try to do this it just appends the values at the end of the table. I need to be able to do something like the following... Insert INTO ImageFile.HiResPath SELECT HiResPath FROM ImageDIR WHERE...

I am attempting to create multiple XML files based upon records in SQL. I have a combined XML that contains a Parent <Item> for each item in the SQL DB... How can I parse each <Item> out as the <ROOT> of it's own XML file? -Thanks! ben

I need to reference terra bytes of data files that correspond with my SQL data, however I do not know how to load this data/ reference this data from SQL? How can I load the reference to each file into a table in SQL?