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
 VP-ASP 6.00 Questions
 shopquery.asp
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

baseline
VP-ASP New User

United Kingdom
60 Posts

Posted - May 03 2007 :  10:38:44  Show Profile  Reply with Quote
I'm trying to build a simple 'search by brand' link in 6.50 by using

/shopquery.asp/mfg=sony

The mfg field is fully populated. However it does not seem to work in the shoppageheader.htm file where I need it.

Can you run shopquery.asp from html files? I don't understand why it doesn't work.

Thanks,
Andy

devshb
Senior Member

United Kingdom
1898 Posts

Posted - May 03 2007 :  11:48:25  Show Profile  Visit devshb's Homepage  Reply with Quote
it'll work; all you need to do is add:

&search=Yes

to the end, and change your second slash to a question mark, eg:

shopquery.asp?mfg=sony&search=Yes

even though it's in shoppageheader.htm, that htm file isn't parsed as an html file as it's embedded within vbscript functions at a higher level, so it's still treated like an asp file despite it's extension being html

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on May 03 2007 11:49:28
Go to Top of Page

baseline
VP-ASP New User

United Kingdom
60 Posts

Posted - May 04 2007 :  05:09:37  Show Profile  Reply with Quote
Ok, I've tried adding the '&search=Yes', so the link is:

shopquery.asp?mfg=sony&search=Yes

But the result is the same, no products returned.

We have a set up where all of our real products are child products of a parent product (which you cannot buy) - http://www.baselinemarine.com.

Would this be the reason it doesn't work? Btw, the top sellers and featured products do not link properly either. I wonder if its the same reason?

Thanks,
Andy
Go to Top of Page

Kidd
VP-ASP Super User

Australia
373 Posts

Posted - May 04 2007 :  06:16:55  Show Profile  Reply with Quote
have you include mfg on the xsearchfields?

Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - May 04 2007 :  08:39:24  Show Profile  Visit devshb's Homepage  Reply with Quote
I think that'd be the case, ie that you need to add the mfg values to the parent product too because shopdisplayproducts.asp won't search on sub-products from what I remember (although I might be wrong)

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

baseline
VP-ASP New User

United Kingdom
60 Posts

Posted - May 04 2007 :  09:12:17  Show Profile  Reply with Quote
Yep, it is. I've just gone into the database and checked the field type, etc. and that all looks fine.

I've tried various tests and used other fields but still it either returns nothing or all of the products in the database.

Tearing my hair out now..

Cheers,
Andy
Go to Top of Page

Scooter
VP-ASP New User

USA
102 Posts

Posted - May 04 2007 :  10:22:21  Show Profile  Reply with Quote
Hi

Are you using default vp database? From your other posts I think maybe you have something upgrade? Have you spke with hosts about looking at their settings?

I check my machine and it work ok.

Maybe support help out for this one?

Sorry I not able to help but tests with my 6.00 version work ok. Maybe 6.50 work differently? I will download copy and have a look. Maybe something simple?

S.
Go to Top of Page

baseline
VP-ASP New User

United Kingdom
60 Posts

Posted - May 09 2007 :  06:11:25  Show Profile  Reply with Quote
Turns out the products table had upgraded incorrectly, most of the fields had been set to 'nvarchar', which is not searchable.

I changed the fields to 'varchar' and now shopquery.asp works fine.

However, the topsellers and advanced search do not work. Try searching for anything and I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Like'.

/shop$db.asp, line 615

To replicate the error: http://www.baselinemarine.com/shopsearch.asp

Best wishes,
Andy
Go to Top of Page

k-otic
Starting Member

49 Posts

Posted - May 09 2007 :  07:27:15  Show Profile  Reply with Quote
Hey Andy,

How did u do the upgrade? Did u use the VPASP upgrade scripts? pretty sure there shouldn't be any data type changes if the convert650 tool is used properly.

Maybe try adding a response.write in shop$db.asp before the line that your getting an error on to see what the sql query is...

Might be able to help if we know what query your trying to run.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000