devshb
Senior Member
United Kingdom
1904 Posts |
Posted - October 10 2005 : 12:25:47
|
yes, it's possible to put things inside a box; you'd just change the template which you use for it to have the box in it. You can create/use whatever template files you like for any call to it (ie there's not just a single "frontpage" template; you can create/use as many different templates as you want, and use whichever template you want for any call.
The way that it finds the relevant product(s) is completely up to you, so you could have a hard-coded id in it, or you could use a flag field etc. I think your best bet would be to use a flag so that you don't have to keep changing the asps each time you change the product-featured.
So, just pick any "pother" column which you're not already using, and then use that. You can either use "is this populated (not-null)?" or you can say "is this set to "FEATUREDWEEK" ?" etc.
The readme document which comes with it explains all the arguments, so along with that and the sample calls you should be able to create a call to it for what you're after.
It's called with these arguments:
BYZShowCaseProducts _ "mandatorycolumnname", _ "mandatorycolumnbitflag", _ "matchingcolumnname", _ "matchingcolumntype", _ "matchingcondition", _ "matchingvalue", _ "extrasqlwhereclausetext", _ "templatefilename", _ "orderingcolumns", _ "randomizeresultsflag", _ "maximum_columns", _ "maximum_records", _ "header_html", _ "trailer_html", _ "odd_row_start_html", _ "odd_row_end_html", _ "even_row_start_html", _ "even_row_end_html", _ "odd_column_start_html", _ "odd_column_end_html", _ "even_column_start_html", _ "even_column_end_html" %>
where most of them are optional and just left as default to use the default config values.
so, a featured product call might be like this:
BYZShowCaseProducts _ "pother3", _ "N", _ "", _ "", _ "", _ "", _ "", _ "tmp_featuredproductoftheweek.htm", _ "", _ "", _ "2", _ "4", _ "", _ "", _ "", _ "", _ "", _ "", _ "", _ "", _ "", _ ""
Note that there's a extrasqlwhereclausetext argument, so you can also specify any other search criteria in there too if you want. Also, you can use the optional "*html" arguments to specify things like header/trailer/title displays etc.
Simon Barnaby Developer [email protected] www.BigYellowZone.com Web Design, Online Marketing and VPASP addons
Edited by - devshb on October 10 2005 12:27:59
Edited by - devshb on October 10 2005 12:30:03
Edited by - devshb on October 10 2005 12:44:29 |
|
|