Vista - HELP! fileExist function always return 'FALSE'

HI all,

I have a problem when trying to pass a string into the fileExist
function.
the code will get the filename from sql database, and pass into the
fileExist function.
then i use: filename=rs('field')
if fs.fileExist(filename) then
fs.Deletefile(filename)
end

I've tried to write out the filename, it show me a correct path and
filename to the path, whille i changed the filename to string "C:\path
\file" it works fine. however when i use a variable: filename, the
fileExist always return "false"

anyone can tell me how to solve the problem?
thank you.

<youu917@xxxxxx> wrote in message
news:afee6132-be4f-45c2-ae0d-94447793ef52@xxxxxxYour code fragment looks like pseudo-code, not like the real thing. Is it
supposed to be VB Script? Let's have the actual fragment from your program!

youu917@xxxxxx schrieb:change this:to:
filename = rs( "field" )
MsgBox ">" & filename & "<"
If fs.FileExists( filename ) Then
fs.DeleteFile filename
End If

to check for whitespace. If there are leading or trailing blanks, use

filename = Trim( rs( "field" ) )

for other whitespace use (or ask for) a RegExp.

"ekkehard.horner" <ekkehard.horner@xxxxxx> wrote in message
news:4a2e42fc$0$32676$9b4e6d93@xxxxxx-online.net...Interestingly enough, I found that trailing white space does not matter but
leading white space does. Also, it seems the .FileExists method does not
like the filespec to be quoted.

filename = Trim(Replace(filename, Chr(34), ""))

--
Todd Vargo
(Post questions to group only. Remove "z" to email personal messages)