Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 VP-Cart 8.00 Issues
 ERR_TOO_MANY_REDIRECTS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vaheh
VP-CART New User

USA
115 Posts

Posted - October 15 2018 :  15:01:39  Show Profile  Visit vaheh's Homepage  Reply with Quote
Hi,

Cart version is: 8.1.0.14

If I search for EWS I want only list items starting with EWS. So if Item code is EWS1 it should be listed but if item code is MEWS it should not be listed.

I am trying to change line 763 in shopproduccreatesql.asp to search for a word starting with instead of included so I am changing:
SQL = SQL & withpflagstr & searchfields(j) & " Like "& sqlserverprefixn &"''%" & tosql(tword,"Text") & "%'' "

to THIS:
SQL = SQL & withpflagstr & searchfields(j) & " Like "& sqlserverprefixn &"''" & tosql(tword,"Text") & "%'' "

If I remove first % from the query this causes infinite loop and ERR_TOO_MANY_REDIRECTS.

Any help and tips is appreciated.

Best,
Vaheh

Edited by - vaheh on October 15 2018 15:38:15

diegomilito
VP-CART Expert

Argentina
766 Posts

Posted - October 16 2018 :  00:31:22  Show Profile  Reply with Quote
try my solution but i dont give you warranty if not work. coz my site and your site maybe different version. i am talking about v8 files.

1. entire search on file shopproductcreatesql.asp for the following:

"''%" & tosql

and try replacing with

"''" & tosql

my file got about 4 replacement.

2. next is file shopdisplayproducts.asp , if you can locate line 516

if len(request("Template")) <= 0 then

just before that line, you will enter a new code

SQL = GetSess("SQL")

and it should be working.

Diego
Go to Top of Page

vaheh
VP-CART New User

USA
115 Posts

Posted - October 16 2018 :  12:20:29  Show Profile  Visit vaheh's Homepage  Reply with Quote
Hi Diego,

Looks like it is working. thanks for the tip.

Best,
Vaheh
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