Search results for query: *

Creating files on the clients machine through a web app is generally a nono. Couldnt you simply output text and then open the text file on the server side? Algorithm: 1. Create dataset to ouput 2. Use ASP FileSystemObject to write to txt file 3. Response.Redirect to newly created text file 4...

You want to hear something funny? If you set the ID to only go to 127, of course it wont read the whole file! Silly me. The auto increment index key field was a tinyint(3) and could not go beyond 127, so it dropped out and didnt bring in the rest of the file. Well silly me! At least the client...

Here: 510000003758,126,* 510000004098,138.75,* 510000003860,184.5,* 510000003720,140.75,* 510000004134,151.5,* 510000003740,59.75,* 510000003723,90,* 510000003786,109.75,* 510000004082,290.5,* 510000003878,193.25,* 510000003797,143.5,* 510000003795,145.5,* 510000003821,19,* 510000004141,0,*...

about 6K, does the size of the file affect the number of records mySQL reads in? Thanks in advance! Seth Juarez Tech Consultant

Here are the two sql commands: CREATE TABLE Drop_5_18_2002 (ID TINYINT (3) DEFAULT '0' NOT NULL AUTO_INCREMENT, BBID DOUBLE, BBval FLOAT DEFAULT '0', UNIQUE(ID)) LOAD DATA LOCAL INFILE 'C:/WebContent/Primm/DataFiles/DropData/B5_18_2002.txt' INTO TABLE StateLine.Drop_5_18_2002 FIELDS...

Is there a way to retrieve an array of items (in a ListView Cntrl) to drag over to another ListView control using OLE Drag Drop? The actual data that I want ported over is the Tags on the items selected from the source. I am having trouble understanding how to do this. Your help would be...

Is it possible to execute a Data Transformation Package from a sql store procedure? Say the local package name is ImportData, what would the sql syntax be to execute that package. I have seen the use of running a shell that runs dtsrun.exe but I want to know if there is a better way. Seth

What is the difference between Meta Data Services Package and Local Package anyways while we are on the subject?

Can a SQL server local package be run from a stored procedure? If this is possible, what would the syntax look like? Thanks a bunch! -sjuarez1979

I guess I was confused by an article found @ http://www.4guysfromrolla.com/webtech/020600-1.shtml which discusses dynamic stored procedures. Is this a deprecated article? RoberT687, your update procedure works perfectly. Any comments on the article about stored procedures?

This is what I put in: CREATE PROCEDURE wo_EditContact @ContactID int, @FirstName char(10), @LastName char(10), @Address1 char(10), @Address2 char(10), @City char(10), @State char(10), @Zip int, @Email char(50), @PhoneNumber...

TWillard, thanks so much for the help!! Unfortunately, I checked the Form Name and it is exactly the same. I tried using document.UpdateNonPic.submit(); and it did not work! :( I am not exactly quite sure why this error would occur. Thanks for your help!

I wrote a little function that takes information and populates a hidden field before form submission. For some reason it gives me this error: Object doesn't support this property or method Here is the Code: function SubmitIt() { UpdateNonPic.f_P1CenterText.value =...

Ok, so I guess I'm smarter than I thought. I guess the little help menu works. This is how it works: SELECT @NowDate = GetDate() Is there a good place where all of the functions of that sort are listed? sjuarez1979

Is there a way to have a variable (IE @Var) in a stored procedure acquire the current date? sjuarez1979

Thanks! It worked wonderfully! sjuarez1979

I am creating a stored procedure that Inserts data into one table and using the new ID of the previously inserted record, Inserts data into another table. How is this acheived most efficiently? The ID of the first inserted set of data is server generated using autonumber. Thanks for the help...

There's a script that I'm running off the localhost using IIS in WinXP which I think is IIS v 5.1 that works perfectly alright. As soon as I transferred the files and set it up on a Win2K Box, the script does not work. I have no idea why that would be the case. It involves shooting a semi-largey...

I think perhaps I've been misunderstood. The problem you identified was the following: "Javascript validation functions in pages generated from ASP could be 'by-passed' by user by saving the ASP page and removing the Javascript validation and then submitting from form." If the...

Well, there is something you can do about errors. It might be cheesy, but it seems to work for me. Heres the synonyms (IMHO) try{bla}catch(exception e){blah} is roughly the same as On Error Resume Next 'like try i guess 'heres the cheesy catch If Err.Number <> 0 Then strOutcome =...