dhotchin — Wed, 01 Jun 2005 12:39:05 +0000

Well if you look at that..... Didnt even see that and guess what, IT WORKS!!!

Cheers for all your help

chrishirst — Wed, 01 Jun 2005 12:02:08 +0000

Look at the error carefully.

you will that now you have an extra bit of code

set f=fs.GetFile("

at the beginning

errors are not always what they say.

dhotchin — Wed, 01 Jun 2005 10:55:24 +0000

Hi,

I still get this error:

Microsoft VBScript compilation error '800a03ee'

Expected ')'

/CoursePages/YourPersonal_MoreDetails.asp, line 204

set f=fs.GetFile("set f=fs.GetFile(server.mappath("\SchoolsIntranet\Uploader\UploadedFiles\" & Recordset1.Fields("FilePath")))
------------------------------------------------------------------------------------------------------------------^

I know its not the Recordset Field because it works fine as

<?php
=(Recordset1.Fields.Item("FilePath").Value)
?>

Also just so that you know by "FilePath" is not the main path to the file, it is just the file name. That is why i have the "\SchoolsIntranet\Uploader\UploaderFiles\"

Any ideas? Cheers

chrishirst — Wed, 01 Jun 2005 10:24:15 +0000

lose both of the last quotes They were only in my post as seperators

... ("filepath")))

dhotchin — Wed, 01 Jun 2005 10:12:02 +0000

set f=fs.GetFile("set f=fs.GetFile(server.mappath("\SchoolsIntranet\Uploader\UploadedFiles\" & Recordset1.Fields("FilePath") "))"'

It doesnt like me at all... I may of ending the code wrong, but ever event that i do it still shows an error at this point ("FilePath").

chrishirst — Wed, 01 Jun 2005 09:40:18 +0000

it should be "))" at the end.
one to close server.mappath and one to close GetFile

dhotchin — Wed, 01 Jun 2005 09:27:25 +0000

Hi, I'm still having problems with this one line:

set f=fs.GetFile(server.mappath("../Uploader/UploadedFiles/" & Recordset1.Fields("FilePath") )'

I keep geting this error message and i can not resolve it.

Microsoft VBScript compilation error '800a0409'

Unterminated string constant

set f=fs.GetFile(server.mappath("../Uploader/UploadedFiles/" & Recordset1.Fields("FilePath") ")
------------------------------------------------------------------------------------------------^

I have tried to remove the ") at the end, kept only the ) and it still dont work.

Any ideas?

dhotchin — Tue, 31 May 2005 22:09:46 +0000

Cheers for that... I will try it later on, and tell you what i have done (if it works or not)

chrishirst — Tue, 31 May 2005 06:03:46 +0000

set f=fs.GetFile(server.mappath("\uploader\uploadedfiles\" & Recordset1.Fields("filepath") & "\" & Recordset1.Fields("filename") )

'
assuming;
"\uploader\uploadedfiles\" is the path in the site where the files are and filepath & filename are in the database.

the error in your code is probably due to a script delimiter "<%" inside a script and a shorthand response.write "=" where it should probably be a concatenation "&"

so this ... UploadedFiles/<%=(Recordset1.Fields.Item("FilePath") ...should be

... UploadedFiles/" & (Recordset1.Fields.Item("FilePath") ...

BTW there is no need to write out Recordset1.Fields.Item("FILENAME").Value each time

In the recordset collection,

Value is the default of item
Item is the default of fields
Fields is the default of Recordset

so it can be written as
Recordset1.Fields.Item("FILENAME") or
Recordset1.Fields("FILENAME") or
Recordset1("FILENAME")

And all would be equally correct