meldrape
Starting Member
37 Posts |
Posted - May 31 2004 : 08:23:22
|
Hi all, I don't even know how to search for the answer so forgive me if it's already been answered. I have a group of products, all products start with "aura" so when I do a search on aura all of the products are fetched, works just great. I'm doing a mailing and would like to include a link that only pulls products that start with aura but the search link on says "yes" in the querystring. What link do I use to single out certain products for display? Many thanks in advance for your thoughts and ideas.
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
Posted - May 31 2004 : 11:09:55
|
your link would be:
shopdisplayproducts.asp?product=aura
and in shopproductcreatesql.asp, you'll need to correct/change the line:
sql = sql & "p.cname like '"& productname & "%'"
to:
sql = sql & " UPPER(p.cname) like '%"& UCase(productname) & "%'" (for sqlserver)
sql = sql & " UCASE(p.cname) like '%"& UCase(productname) & "%'" (for access)
(note the extra space in front of UPPER/UCASE; that's a bug-fix).
Simon Barnaby Developer www.BigYellowZone.com Web Design, Online Marketing and VPASP addons |
|
|