trying to pass var from asp page

[davefederici]

I need help I have a web app that when a user clicks a button it sends
the jobid number to crystal report but in the querry area under datbase expert under command where the querry is I am trying to pull data from a
table with the jobid number how do I write the var
example
select jobid, jobaddress from job where jobid = ::jobid::
this doesnt work also how do I get crystal report writer to see the var

thanks