2. ASPRunnerPro General questions
  3. Security error
This topic is locked

Security error

 		3/6/2005 4:20:02 AM
ASPRunnerPro General questions
jmisson author

Hi,
Thanks in advance.
I am getting a type mismatch error, with the following SQL, when trying to access a page for individual users (works OK for Admin)
select [EnquiryID], [EnquiryDate], [AssignedConsultant], [Status], [LoanType], [LoanAmount], [Surname], [FirstName], [HomePhone], [Mobile], [Email], [CurrentSuburb], [Referral] From [tblEnquiry] where [AssignedConsultant] = 6
The bold above is I am sure where the error is because 'Assigned Consultant' is a text field i.e. jmisson
In the advanced security section I have set the AssignedConsultant = UserName, both text, but for some reason the ID field is being picked up instead. I thought I made a mistake, so rebuilt the pages, making sure I included the correct fields. I then overwrote the xxxlist.asp and xxxasp_functions.asp pages - do I need to overwrite any other pages?
Do you have any suggestions.
Many thanks
Julie
Sergey Kornilov admin 3/7/2005

Julie,
make sure you put all updated files to the Web server. OwnerID field is assigned on the login.asp.
If this doesn't help send your files to support@xlinesoft.com for investigation.
jmisson author 3/16/2005

Many thanks for the reply.
I sorted out the error, on one page I had UserName as the check field for security purposes and another userID, thus messed everything up. Once I made a choice and was persistant with that choice for all the pages everything worked fine.
Regards
Julie