VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 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

4266 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