How to call a session variable into sql?

[Guest]

for example, I have a coldfusion session variable - session.testvar

I am writing a Stored procedure in sql server 2000. The query within my stored procedure needs to insert a value into a table. The value needs to be my CF session variable. I have no idea how this is done, does anyone else have a hunch?

I am using coldfusion 8 and sql server 2000.

[Reed_Powell-ttnmOb · Accepted solution]

Pass it to the SP as a variable

- there are examples in the cf docs

[Guest]

Thanks, found what Ineeded there!