Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Problems and bugs
 Supplier login???
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

thunderhawk
Starting Member

Norway
33 Posts

Posted - April 18 2007 :  07:24:40  Show Profile  Visit thunderhawk's Homepage  Reply with Quote
Hello!

I have done this before in all versions before 6.50, but now it will not work????

I am talking about supplier login and their permissions.
Whatever I do, there is always message

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
/shopheaders.asp, line 698

I can login as administrator without any problems.
I have tried everything with the supplier - restricted admin, super admin, just few of the tables, all of the tables.

I do not have a clue what to do, since this worked before perfectly!

Thanks in advance!

Edited by - thunderhawk on April 18 2007 07:25:41

support
Administrator

4679 Posts

Posted - April 18 2007 :  08:22:45  Show Profile  Visit support's Homepage  Reply with Quote
Hi Randy,

Try the following. Some may already have been added:

Locate the following -

Userid=getsess("shopadmin")
usertype=getsess("Admintype")
if ucase(usertype)="SUPPLIER" then
userid="supplier"
end if

Move to be above the following line -

AdminPageHeaderFull

Also change the following -

if ucase(usertype)="SUPPLIER" then
userid="supplier"
end if

To -


if ucase(usertype)="SUPPLIER" then
userid="supplier"
setsess "shopadmin", "supplier"
end if

Hope this helps.

Thanks
Cam

VP-ASP Support
Go to Top of Page

thunderhawk
Starting Member

Norway
33 Posts

Posted - April 19 2007 :  04:17:09  Show Profile  Visit thunderhawk's Homepage  Reply with Quote
It is working perfectly now
Thanks!
Go to Top of Page

robertof
Starting Member

Italy
22 Posts

Posted - April 20 2007 :  02:57:17  Show Profile  Reply with Quote
I hope that this correct will be include in the next service pack ;)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00