How do you get the full session trail?

[nomis23uk]

I am using: sqltempVar = SessionVar.Get("%sqltempfolder%");

in my %sqltempfolder% session I have: %ProgramFilesFolder%\Your Product\sqltemp

When I use the sqltempVar it will output exactually the above in my output result.

How do I get it to include the %ProgramFilesFolder% also? i.e C:\ProgramFiles etc rather than the %ProgramFilesFolder% text.

Do I need to concatenate the session vars some how?

thanks for any help in advance.

[Ulrich]

Use SessionVar.Expand() instead of SessionVar.Get().

Ulrich

[nomis23uk]

works like a charm. thank you.