|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 27th, 2004, 03:18 PM
|
|||
|
|||
|
hi i m having problem
i m using MSDE i m trying to use session object to
work with it. i dont know how to do it can someone help.....here is what i have written: ALTER PROCEDURE reportjobposted ( @emuser varchar (20) ) AS SELECT Jobs.jid, Jobs.joposted, Jobs.jocutoff, Jobs.jotitle, Jobs.jostatus, count(Applications.causer) as "# of Applicants" FROM Jobs, Applications WHERE Jobs.jid=Applications.jid and @emuser="Session("EmployerName")" group by jobs.jid, jobs.joposted, jobs.jocutoff, jobs.jotitle, jobs.jostatus order by Jobs.jid i have passed the value in the "EmployerName" in the session from a text box in another page. i m trying to diplay in a data grid all the above fields where table jobs and table applications jid is equal and the emuser field in Jobs table = to what the session holds. Please help me Thank you Shams
|
|
#2
July 27th, 2004, 04:59 PM
|
||||
|
||||
|
You should be passing the session value to the procedure, like this (I am assuming this is a stored procedure)
Code:
CREATE PROCEDURE stp_ReportJobPosted @emuser varchar (20) AS SELECT A.jid, A.joposted, A.jocutoff, A.jotitle, A.jostatus, COUNT(B.causer) As '# of Applicants' FROM Jobs As A INNER JOIN Applications As B On (A.jid = B.jid) WHERE emuser = @emuser GROUP BY A.jid, A.joposted, A.jocutoff, A.jotitle, A.jostatus ORDER BY A.jid
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > hi i m having problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
