Software Search
HELP/FAQs?

Got questions/problems? Take a look through our FAQs (frequently asked questions), or email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly.

Want Discounts?

Are your prices for multiple domains too large? Are you trying to get licences for test domains but being asked to pay full cost? Don't worry; we can add test domains to your licences manually. Just purchase a single domain addon/upgrade for what it is that you need, and then email us about your situation regarding the remaining domains and we'll liaise with you over the options. email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly. click here for more information regarding multiple domains, upgrades, and discount policies.

BigYellowKey News
(click here to view all BYK news)

Imminent: 4/1/2016 4:05:00 PM
BYZ Development Points have been changed
Click Here for details.
The new BYZ Development Points (BYZ192) replace all previous BYZ Points which are now no longer available.

Released: 4/1/2016 3:05:00 PM
BYZ Annual Pass Now Available!
Click Here for details.
The BYZ Annual Pass replaces the BYZ addon subscription service.

Released: 4/1/2016 2:05:00 PM
The BYZ Terms and Conditions have been changed.
Click Here for details.

Apologies, but online Payments are temporary unavailable as we are in the process of changing our payment gateway.
Please contact us if you wish to place an order and we will organize a manual payment process for you.
We hope/expect online payments to be available again soon.

Product ShowCase (Enhanced Front-Page) Functions for VP-ASP - BYZ093

<< back to previous screen

This tool is a highly enhanced version of the VPASP Front Page functions which gives a lot more flexibility so that you can show your product showcases wherever you want in whatever format you want.



Compatibility, Bundling, and Status Notes:
Compatible with VPASP V4.5 to V7
Before installing, you must have installed:
BYZ038
BYZ036
BYZ033
BYZ162 (relevant to VPASP V7+ ONLY)

This product includes:
BYZ038
BYZ036
BYZ033
BYZ162 (relevant to VPASP V7+ ONLY)
Latest version:15/12-MAY-2011
From vendor:Big Yellow Zone
For Terms and Conditions, click here
Please do not purchase any BigYellowZone
products/services or request technical
support until you have read and agree with
the terms and conditions.
Price:£30.00
add to cart

Demos/Samples:
(click on a link below to see the corresponding demo/sample)
Sample Showcases


VPASP has features which allow you to display things like your top selling products easily. Often you want to use the VP-ASP "Front Page" functions to showcase/display a set of your products, but maybe it doesn't do exactly what you want it to do, or maybe you want to use different sets of products in different pages?

This tool is a highly enhanced version of the VPASP "Front Page" functions which gives a lot more flexibility so that you can show your product showcases wherever you want in whatever format you want.

You can also call showcasing using a special template field, for example you can show different sets of products on different content urls.


Technical/Developer Information:
It also includes some demo / examples so that you can get up and running quickly.

Here's a list of some of the options that you can use on a Per-Call/Per-Use basis:
Top-Selling Products Listing
Alternate (Odd/Even) Column/Row Definitions (eg different colours)
Maximum Number of Records to show
Number of Columns to Show on each Row
Record Ordering
Randomize Results Flag
Template File To Use
Header Text/HTML
Trailer Text/HTML
Mandatory Column Check
Matching Value Logic
Additional SQL Query Restrictions (extra where clause)
Context-Sensitive Displays


Terms and Conditions:
For terms, conditions, and licensing information for all BigYellowZone products/services, please click here.
Please do not purchase any BigYellowZone products/services or request technical support until you have read and agree with the terms and conditions.


Full Version History:
VerNo Version Date Release Notes
01 02-SEP-2005 Initial version - Product ShowCase (Enhanced Front-Page) Functions For VP-ASP
02 22-NOV-2005 Enhanced to use hide and stock flags as extra arguments. When upgrading from previous version, ensure you add 2 new (blank) arguments to the front of all your BYZShowCaseProducts and BYZShowCaseProductsTopSellers function calls that you already have applied to your site.
Effected files:
README.htm
byz093_install.asp
byz_default.asp
byz_showcase_products.asp
byz_showcase_products_top_sellers.asp
03 23-NOV-2005 Added global variables so that merchants can check if any records have been shown in the call that theyve just made to the top-seller or showcase function. No changes made to any of the function arguments, so to upgrade from previous version just upload the new files mentioned below (apart from README.htm) and run byz093_install.asp.
Effected files:
README.htm
byz093_install.asp
byz_showcase_products.asp
byz_showcase_products_top_sellers.asp

The new variables which you can use to check if the top-seller/showcase function has just displayed any records are:
byz_showcase_products_just_shown_flag (will be set to Y or N)
byz_showcase_products_just_shown_count (will be the count of products just shown)
04 17-APR-2006 Added new usingsalestype argument to top-sellers function, and made extra template-fields/values available to be used in top-sellers templates. When upgrading from previous version, ensure you add 1 new (blank) argument to the front of all your BYZShowCaseProductsTopSellers function calls that you already have applied to your site.
Effected files:
README.htm
byz093_install.asp
byz_default.asp
byz_showcase_products_top_sellers.asp
tmp_byz_showcase_top_sellers_narrow.htm (in both sample template directories)
05 25-MAY-2006 Swapped the maximum_columns and maximum_records arguments around in the internal code for the top-seller function (BYZShowCaseProductsTopSellers) as it was previously the wrong-way around and didnt follow the readme notes.
Enhanced to allow for various MySQL shortfalls on older MySQL versions.
Created more sample functions/templates for top-sellers.
Effected files:
README.htm (changed)
byz093_install.asp (changed)
byz_default.asp (changed)
byz_showcase_products.asp (changed)
byz_showcase_products_top_sellers.asp (changed)
tmp_byz_showcase_top_sellers_side_panel.htm (new)
tmp_byz_showcase_top_sellers_side_panel_sized.htm (new)
tmp_byz_showcase_top_sellers_side_panel_nothumbs.htm (new)

IMPORTANT NOTE: If upgrading from a previous version, then for any calls to the BYZShowCaseProductsTopSellers that you have already placed on your pages/panels you should check/change the maximum_columns and maximum_records arguments in your call to the function as they have been swapped around back to their correct order in this new version.
06 12-JUN-2006 Added context-sensitive (by category) functions/examples. Effected files:
README.htm (changed file)
byz093_install.asp (changed file)
byz_showcase_products.asp (changed file)
byz_showcase_products_config.asp (new file)
byz_showcase_products_context_sensitive_new_products.asp (new file)
byz_showcase_products_context_sensitive_showcase_products.asp (new file)
byz_showcase_products_context_sensitive_top_sellers.asp (new file)
07 07-OCT-2006 Corrected top-seller context-sensitive (by category) functions. Effected files:
README.htm (changed file)
byz093_install.asp (changed file)
byz_showcase_products_context_sensitive_top_sellers.asp (changed file)
08 08-APR-2007 Changed to be compatible with VPASP V6.5.
Clarified/separated installation and usage instructions.
Upgraded BYZ038 (Licensing) module to cater for VP-ASP V6.5.
Changed sample templates and example function calls.
Changed top sellers and showcase functions to accept context-sensitive flag arguments instead of having to use separate functions; this now allows context-sensitive calls to be as flexible as other calls.

NOTE: The top-sellers and showcase functions now have 2 additional arguments at the end for the context-sensitive flags.

NOTE: The following functions are no longer used, as the generic showcase/top-seller functions can/should now be used to achieve the same results instead:

BYZ_SHOWCASE_SHOW_CATEGORY_SENSITIVE*:

_SHOWCASE_PRODUCTS*:
_THIS_CATEGORY
_ANY_CATEGORIES
_GET_HIGHER_CATEGORYID

_TOP_SELLERS*:
_THIS_CATEGORY
_ANY_CATEGORIES
_GET_HIGHER_CATEGORYID

_NEW_PRODUCTS*:
_THIS_CATEGORY
_ANY_CATEGORIES
_GET_HIGHER_CATEGORYID

Effected files:
README.htm (changed file)
README_history.htm (new file)
README_installation.htm (new file)
README_usage_main.htm (new file)
README_usage_newitems.htm (new file)
README_usage_notes.htm (new file)
README_usage_topsellers.htm (new file)
byz093_install.asp (changed file)
byz_default.asp (changed file)
byz_showcase_products.asp (changed file)
byz_showcase_products_config.asp (changed file)
byz_showcase_products_context_sensitive_new_products.asp (deleted file)
byz_showcase_products_context_sensitive_showcase_products.asp (deleted file)
byz_showcase_products_context_sensitive_top_sellers.asp (deleted file)
byz_showcase_products_top_sellers.asp (changed file)
tmp_byz_showcase_top_sellers_side_panel_nothumbs.htm (changed file)
09 28-OCT-2009 Upgraded BYZ038 (from V07 to V10).
Upgraded BYZ036 (from V02 to V05).
Added BYZ033 (V06).
Added template fields so you can call product-showcases within any existing template (eg content pages) for a given search criteria which is specified in the data. For example, to show products which are in different categories in different content urls.
Effected files:
README.htm (changed file)
README_history.htm (changed file)
README_installation.htm (changed file)
README_usage_main.htm (changed file)
README_usage_newitems.htm (changed file)
README_usage_notes.htm (changed file)
README_usage_templatefields.htm (new file)
README_usage_topsellers.htm (changed file)
byz$093_version.asp (new file)
byz093_install.asp (deleted file)
byz_showcase_products.asp (changed file)
byz_template_codes_codes_showcase.asp (new file)
byz_template_codes_functions_showcase.asp (new file)
10 18-JAN-2010 Added randomize_from_top_x_candidates argument to the BYZShowCaseProducts function for use when randomizing results. See the usage readme file for more information.
PLEASE NOTE: If upgrading, make sure you add an extra argument to any BYZShowCaseProducts functions that youve called in your own pages/panels where the new randomize_from_top_x_candidates argument is (just after the maximum_records argument).
This new argument is only relevant to the BYZShowCaseProducts function, not to the BYZShowCaseProductsTopSellers argument.
Added top x (for sqlserver/access) and limit x (for mysql) to the showcase query logic as appropriate to help minimise memory and speed up the queries.
Effected files:
README*.htm (changed files)
byz$093_version.asp (changed file)
byz_default.asp (changed file; only used to illustrate example/demo calls)
byz_showcase_products.asp (changed file)
byz_template_codes_functions_showcase.asp (changed file)
11 27-JAN-2010 Added new arguments to the end of the BYZShowCaseProducts and BYZShowCaseProductsTopSellers functions:
first_row_start_html
first_row_end_html
first_column_start_html
first_column_end_html
last_row_start_html
last_row_end_html
last_column_start_html
last_column_end_html
See the usage readme files for more information.
PLEASE NOTE: If upgrading, make sure you add extra arguments to any BYZShowCaseProducts and BYZShowCaseProductsTopSellers functions that youve called in your own pages/panels where the new first... and last... arguments are.
If you dont want to use different first/last column/row html to what youve already specified in your other arguments for the call then you can just add this to the end of your existing BYZShowCaseProducts and BYZShowCaseProductsTopSellers calls arguments:
,,,,,,,,
(ie there are 8 new arguments added to the end of the calls, all of which can be blank () but which do need to be added to the function call). Using blank values will mean that your existing functions will end up doing the same as they did before.
Effected files:
README*.htm (changed files)
byz$093_version.asp (changed file)
byz_default.asp (changed file; only used to illustrate example/demo calls)
byz_showcase_products.asp (changed file)
byz_showcase_products_top_sellers.asp (changed file)
byz_template_codes_functions_showcase.asp (changed file)
12 09-FEB-2010 Changed to be compatible with VPASP V7.
Upgraded BYZ038 (from V10 to V12).
Upgraded BYZ036 (from V05 to V07).
Upgraded BYZ033 (from V06 to V09).
NOTE: If upgrading, please read installation steps 7 and 8 as the includes are now in a different place and you need 2 of them instead of just one.
Effected files:
README* (changed files)
byz$093_version.asp (changed file for all vpasp versions)
byz_default.asp (changed file for vpasp v7+ only)
byz_showcase_products_top_sellers.asp (changed file for vpasp v7+ only)
byz_showcase_products_vars_inc.asp (new file for all vpasp versions)
byz_showcase_products.asp (changed file for all vpasp versions)
13 20-FEB-2010 Added BYZ162 (V01).
NOTE: BYZ162 is only relevant to VP-ASP V7 or above.
Effected files:
README* (changed files)
byz$093_version.asp (changed file for all vpasp versions)
14 23-NOV-2010 Upgraded BYZ162 (from V01 to V02).
Effected Files:
README* (changed files)
byz$093_version.asp (changed file for all vpasp versions)
15 12-MAY-2011 Upgraded BYZ038 (from V12 to V13).
Upgraded BYZ036 (from V07 to V08).
Upgraded BYZ033 (from V09 to V11).
Upgraded BYZ162 (from V02 to V03).
Changed sample template fields to take across the array and not just the cursor.
Effected Files:
README* (changed files)
byz$093_version.asp (changed file for all vpasp versions)
byz_template_codes_codes_showcase.asp (changed file for all vpasp versions)
byz_template_codes_functions_showcase.asp (changed file for all vpasp versions)