Author |
Topic |
|
baseline
VP-CART New User
United Kingdom
60 Posts |
Posted - May 03 2007 : 10:38:44
|
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
1904 Posts |
Posted - May 03 2007 : 11:48:25
|
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 |
|
|
baseline
VP-CART New User
United Kingdom
60 Posts |
Posted - May 04 2007 : 05:09:37
|
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 |
|
|
Kidd
VP-CART Super User
Australia
373 Posts |
Posted - May 04 2007 : 06:16:55
|
have you include mfg on the xsearchfields?
|
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
Posted - May 04 2007 : 08:39:24
|
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 |
|
|
baseline
VP-CART New User
United Kingdom
60 Posts |
Posted - May 04 2007 : 09:12:17
|
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
|
|
|
Scooter
VP-CART New User
USA
102 Posts |
Posted - May 04 2007 : 10:22:21
|
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. |
|
|
baseline
VP-CART New User
United Kingdom
60 Posts |
Posted - May 09 2007 : 06:11:25
|
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
|
|
|
k-otic
Starting Member
49 Posts |
Posted - May 09 2007 : 07:27:15
|
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.
|
|
|
|
Topic |
|