[RESOLVED] CreateTextFile Not Creating File Where Needed

[nbcrockett]

I've written a script that exports records from a database and creates an XML file from those records. The script works fine if I'm creating the file in that websites directory, but if I want to create it else where on that server it won't write. Can anyone tell me what I'm doing wrong?

Works: Site 1 writing to folder in Site 1's directory.

Set strCreate = fso.CreateTextFile(server.mappath("/Exported Files/File.xml"), true)


Doesn't Work: Site 1 writing to folder in Site 2's directory.

Set strCreate = fso.CreateTextFile(server.mappath("D:Websites/Site2/Exported Files/File.xml"), true)

[Kuriyama]

I've written a script that exports records from a database and creates an XML file from those records. The script works fine if I'm creating the file in that websites directory, but if I want to create it else where on that server it won't write. Can anyone tell me what I'm doing wrong?

Works: Site 1 writing to folder in Site 1's directory.

Set strCreate = fso.CreateTextFile(server.mappath("/Exported Files/File.xml"), true)


Doesn't Work: Site 1 writing to folder in Site 2's directory.

Set strCreate = fso.CreateTextFile(server.mappath("D:Websites/Site2/Exported Files/File.xml"), true)



Why do you need server.mappath if you already have the file path? Try this. . .

Set strCreate = fso.CreateTextFile("D:Websites/Site2/Exported Files/File.xml", true)

[nbcrockett]

Thanks for the help. The server.mappath thing was copied over from something else and it didn't even cross my mind to remove it. In the words of Carlos Mancia "dee dee dee"