Hi Mandy,
What errors are you getting? What is the content of the variables?
Keep in mind that if you are instructing SQL to place a file in a non-existent subdirectory, SQL will fail--it will not automatically create the subdirectory. Your syntax looks fine and what you are trying to do should work. Your error is probably in the contents of your variables. I suggest halting the execution of the program just before the SQL Select statement and examining the contents of the variables. That will probably point you to the problem.
Regards, Chaim