Profile value + Sql Value, a login problem

Hi all. Quick question. I'm using VS2005, C#, aspx page.

I'm creating a Profile to store login and password. That part is working... I can call the values (and display them) using this code <%= Profile.login %> and <%=Profile.password %
Now I want to create a Grid View that will connect to the SQL db, see if the login and password value stored in the Profile match that of ones in the SQL db.

So if the profile is login: bob password: dog, the grid view will output all application ID numbers associated with the bob and dog. Here is the SQL code...trying to use the <%=Profile.login %> as a filter on the login and password doesn't seem to work...

Can anyone tell me what I'm doing wrong? How can I reference a value in the Profile within an SQL statement?

SELECT ApplicationStatus.Description, Customer.CustomerName, Application.ApplicationDate
FROM Application INNER JOIN
ApplicationStatus ON Application.ApplicationStatusID = ApplicationStatus.ApplicationStatusID INNER JOIN
Customer ON Application.ApplicationID = Customer.ApplicationID INNER JOIN
[User] ON Application.DealerId = [User].UserId
WHERE ([User].LoginId = '<%= Profile.login %>') AND ([User].LoginPwd = '<%= Profile.password %>') AND (ApplicationStatus.Description = 'Pending')

Try getting the value into a variable and use the variable in the SQL.

SELECT ApplicationStatus.Description, Customer.CustomerName, Application.ApplicationDate
FROM Application INNER JOIN
ApplicationStatus ON Application.ApplicationStatusID = ApplicationStatus.ApplicationStatusID INNER JOIN
Customer ON Application.ApplicationID = Customer.ApplicationID INNER JOIN
[User] ON Application.DealerId = [User].UserId
WHERE ([User].LoginId = @.login) AND ([User].LoginPwd = @.pwd) AND (ApplicationStatus.Description = 'Pending')

Then add the parameters to the command object and set their values appropriately.

|||I agree with ndinakar.

Proclarity Installation

Hello all. I am having the hardest item installing proclarity on my machines. The installation goes through fine but when I login to the site I do not see an option (should be a drop down) to select web vs pro edition. When I check for downloads, it shows none available. I did install the web professional from the main installation window, and the files are on the drive itself.

On a different note, I have read most of proclarity's documentation, but cannot seem to find how to have web pro (well std until I have the pro option) connect to an existing cube and allow data browsing/drill down, etc. Any link or doc you can point to for this will be very helpful.

Thank you in advance for your help.

Hello. You manage the access to web professional in the administration console for PAS(Analytics Server).

Each role you create there would have to be allowed to download web professional.

ProClarity is currently in a "no mans land" because it is owned by Microsoft and the ProClarity Platform will be part of PerformancePoint.

HTH

Thomas Ivarsson

|||

Thank you for your answer. I was able to solve the mystery and it is just like you said. I just want to clarify the solution a bit more for other folks who may face the same road block.

Fireup the proclarity administration tool, click on users node and for each user/group right click and choose properties. There you can provide permission to access proclarity professional.

sql