kduan even thou SQL and ISS on the same box is considered bad to do it does not matter where they exist in relation to each other. If it gave...

Andy is right with using the ADO stream to handle it and is almost as efficient as storing on the drive. However when deciding where to place (DB or filesystem)...

When you submit your value use

REPLACE(valuehere,"'","''")

Since we do this a lot we created a function and call on the page.

Ex.

Function FixStr(ValFix)

FixStr = REPLACE(ValFix,"'","'')

End Function

Then we call in our insert

SQLStr...

Just so I understand the error what does "A800" have to do with the query? Your output looks fine so mush be something I am missing here, although I would...

quote:

---

i was told only data having mon/day/yr format can be used with getdate

---

Actually this is...

I may be misunderstanding you.

Are you saying you have a file and the data is 8000 characters long like so.

BOB THOMPSON11232 MAIN ST.......02/22/1904

(....... is data in middle of the ends.)

And...

Just keep in mind the security issues you need to cover. If the box is not on the same domain you may not be able to access the remote machine....

msdb..sp_start_job is to start a SQLAgednt job to running. These can be found by using EM to drill thru the server to Management/SQLServerAgent/Jobs (or something like, sorry no EM in...

1) Use when you want to make sure no other process is touching the data you are working with.

2) You have set all your queries during the session to work...

It is a known issue they addressed in SP3 for SQL 7 I do believe. And if I remeber correctly it is related to the way they encrypt the packages,...

Couple of different possible ways.

SELECT

products.shorsku,

products.[name],

products.title,

products.heading,

products.subheading,

products.regularprice,

products.productdescription,

products.imagepath

FROM

Products

WHERE

productid IN (SELECT MAX(productid) FROM Products isub WHERE isub.shorsku = Products.shorsku)

Should do the trick by giving the highest productid number for each shorsku, so you...

You have to use the 2 part name Owner.Function

For instance if I create a function name fn_CalcFirstDay and don't change the owner from dbo then I use like so

SELECT dbo.fn_CalcFirstDay(HireDate)...

1. The appraoch in SQL is in fact the same as ADO except some of the work is being done by the ADO library where SQL is a simpler and...

Thru ASP on the remote side the client will not be able to export directly to an MDB or XLS file.

The CSV is possible as long as you output...

Are you saying for select or for input you only wnt uniqeus allowed?

If for insert then change like so.

CREATE TABLE [Products] (

[productid] [int] PRIMARY KEY NOT NULL ,

[sku] [varchar] (50)...