Search results for query: *

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

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

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...

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 =...

Is there a way to have a variable (IE @Var) in a stored procedure acquire the current date? 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 need to develop a program that periodically chekcs a folder and opens any new TIF Image files that are shot in there and prints them. All i need is to create a TIF object and have it printed. Is there any idea on how this is done?