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)

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.

Released: 6/16/2014 2:05:00 PM
Full list of Demos Now Available in one place! Click Here to see our new Demo area/list, or click on the "Demos" link at the top/right of the screen.

Released: 3/9/2014 2:05:00 PM
New modules released:
Speed Tester
Error Logger
SQLServer Space Clearer
Click Here to See What Other New Modules we have
or click here to see newly released enhancements/fixes

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 within the next day or so.

Template Fields for VPCart - BYZ033

<< back to previous screen

Use this handy addon to show related info from connected tables.
Or for when you want to add if-statements or any other dynamic logic to your html templates



Template Fields for VPCart - BYZ033
Latest version:20/01-APR-2015
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:£20.00
add to cart


Compatibility, Bundling, and Status Notes:
Compatible with VPCart V4.5 to V8
Before installing, you must have installed:
BYZ038
BYZ036

This product includes:
BYZ038
BYZ036

Some (but not all) BigYellowZone modules which use extra-template fields automatically have this product included, please check the compatibility notes of individual modules to see if a given module that you want already has BYZ033 included.

We've found it massively useful; we now use it for almost every site that we do work on as it saves so much time and trouble and is so reliable. We also use this for all of our template field addons that are for sale. Once installed, adding extra logic for formatting your templates is fantastically simple and flexible.

Either use them with arguments (as per VPCart's formatcurrency special-field) to format specific values, or use them with no arguments (as per VPCart's add_crossselling special-field) to create straight-forward non-order/product-specific html.

These functions work in any/all of the templates (html and text), including product templates, order templates, and email templates.

The "Related/Connected Info" usage - WOW! No coding required, just simple template-file changes, and shows whatever you want:

It would often be useful to display a field value from a different table than the template is being run for, and this special template field allows you to do that.

For example, on a product template, you might want to "drill-down" to the supplier table of that product's supplierid and display the supplier name on the product page.

Or, on an order-items (oitems) template you might want to drill-down to the products table for that oitem's catalogid and display the product's manufacturer.

Or maybe you want to show the customer's userid/pwd on their order confirmation email.

There are lots of times when this kind of drill-down would be useful to do, and this special template field will allow you to drill-down to any other table from any template and return any column value without you having to manually delve into the asp files and without needing any programming knowledge.

The possibilities are endless as this applies to any template (customers, orders, products etc) and allows you to connect from-anything to-anything.

To display a column value from a related table, you would use the following special template field with the relevant arguments in your template file:

[BYZ_SUB_COLVAL "{a}{b}{@@c@@}{d}{e}"]

Where:
a) Is the name of the sub/related table that you want to drill-down to.
b) Is the name of the column on the sub/related table that you want to display.
c) Is the name of the column on the template-driving table that is the key/match column to the sub/related table.
d) Is the name of the column on the sub/related table that you want (c) to match to.
e) Is the type of column on the sub/related table that you have named in (d), use "number" or "text".

Please note that the 3rd argument has 2 @'s ("at" signs) around it, this is because the internal processing then knows to process that value as a dynamic column value and not a literal value and so that it can eliminate hackers from using this template-field logic as a way to gain access to unauthorised data. Double at signs are automatically cleaned/stripped from any data that users enter, so they will never be able to use this logic against your site. This is a very powerful function and so has been secured by using the double at signs around it in the internal code which hackers will never be able to replicate by other means. The file structure/logic of BYZ033 means that hackers won't be able to "call" this function anyway, but the @@ logic adds that extra bit of security.

Examples:

1. Display the supplier name for a given product's supplierid on a product template:

[BYZ_SUB_COLVAL "{suppliers}{name}{@@supplierid@@}{supplierid}{number}"]

would produce a query like: select suppliers.name from suppliers where suppliers.supplierid=[currentproducts.supplierid]

2. Display the current Mail-List Flag for a given customer's contactid on an order template:

[BYZ_SUB_COLVAL "{customers}{maillist}{@@ocustomerid@@}{contactid}{number}"]

would produce a query like: select customers.maillist from customers where customers.contactid=[currentorders.ocustomerid]

3. Display the Manufacturer for a given oitems' catalogid on an oitems (order-items) template:

[BYZ_SUB_COLVAL "{products}{mfg}{@@catalogid@@}{catalogid}{number}"]

would produce a query like: select products.mfg from products where products.catalogid=[currentoitems.catalogid]


Technical/Developer Information:
It comes with very detailed instructions on how to install it, how to use it, and how to build functions/fields, and it also comes with example functions/fields that you can use as a base for your own.

It also allows you to have arguments that are literal values (eg "10", "Test" etc instead of column names) if you want, and to have more than one argument for a given template field.


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 04-OCT-2004 Initial version - Big Yellow Zone Template Codes Addon for VP-ASP.
02 16-DEC-2004 Added product/order cursor to inward arguments to functions.
03 21-DEC-2005 Changed to be compatible with VP-ASP V6. No core changes made; only documentation changed.
Files changed:
byz033_install.asp
README.htm
04 04-MAR-2007 Added new logic to cater for literal template-field arguments.
Added example and library function to cater for multiple-values in arguments.
Clarified the installation notes.
Upgraded BYZ038 (Licensing) module to cater for VP-ASP V6.5.
Effected files:
byz033_install.asp (changed file)
README.htm (changed file)
example4.asp (changed file)
example_tmp_productformat.htm (changed file)
example_tmp_product.htm (changed file)
byz_template_codes$includes_functions.asp (changed file)
byz_template_codes$includes_codes.asp (changed file)
byz_template_codes_sys.asp (changed file)
byz_template_codes_sys_findfieldsetupchk50_inc.asp (new file)
byz_template_codes_sys_findfieldsetupchk45_inc.asp (new file)
byz_template_codes_sys_findfieldsetup_inc.asp (new file)
byz_template_codes_sys_findtokens_inc.asp (new file)
byz_template_codes_codes_example5.asp (new file)
byz_template_codes_functions_example5.asp (new file)
05 09-NOV-2007 Upgraded BYZ038 (from V07 to V08)
Upgraded BYZ036 (from V02 to V04)
Changed instructions to be compatible with bigyellowkey.com licensing notes.
Split out the history, installation, and usage notes into separate readme files.
Adjusted the installation notes to use commenting-out instead of replacements for code-changes.
Effected files:
README.htm (changed file)
README_history.htm (new file)
README_installation.htm (new file)
README_usage_main.htm (new file)
byz033_install.asp (deleted file)
06 16-JAN-2009 Upgraded BYZ038 (from V08 to V10).
Upgraded BYZ036 (from V04 to V05).
Clarified installation notes.
Created version file for reference/info.
Effected Files:
README.htm (changed file)
README_history.htm (changed file)
README_installation.htm (changed file)
README_usage_main.htm (changed file)
byz$033_version.asp (new file)
07 11-DEC-2009 Made compliant with VPASP V7.
Upgraded BYZ038 (from V10 to V11).
Upgraded BYZ036 (from V05 to V06).
Added a new built-in special template field to allow drill-down (sub/related tables) arguments/logic (for example to display the supplier name for a given catalogid on a product template; see the usage instructions readme doc for more info).
Effected files:
README.htm (changed file)
README_history.htm (changed file)
README_installation.htm (changed file)
README_usage_developers.htm (new file)
README_usage_main.htm (changed file)
byz$033_version.asp (changed file)
byz_template_codes_codes_subtables.asp (new file)
byz_template_codes_functions_example3.asp (changed file for vpaspv7+ only)
byz_template_codes_functions_example4.asp (changed file for vpaspv7+ only)
byz_template_codes_functions_subtables.asp (new file)
byz_template_codes_sys.asp (changed file)
byz_template_codes_sys_var_inc.asp (new file)
example4.asp (deleted file)
08 18-JAN-2010 Added array to function calls (see the readme developer notes for technical details).
PLEASE NOTE: If upgrading, please make sure that you apply the new argument in steps 9 and 10 of the readme installation file to your shopfileio.asp file (parsearray for VPASP5.0 upwards, FieldNames for VPASP4.5), and if using VPASP V7.0 or above then also apply that change to your admin/adminfileio.asp file.
Effected Files:
README*.htm (changed files)
byz$033_version.asp (changed file)
byz_template_codes_sys.asp (changed file)
admin/byz$033_version.asp (changed file for vpaspv7+ only)
admin/byz_template_codes_sys.asp (changed file for vpaspv7+ only)
09 09-FEB-2010 Upgraded BYZ038 (from V11 to V12).
Upgraded BYZ036 (from V06 to V07).
Effected files:
README* (changed files)
byz$033_version.asp (changed file for all vpasp versions)
admin/byz$033_version.asp (changed file for vpasp v7+ only)
10 27-MAR-2011 Upgraded BYZ038 (from V12 to V13).
Upgraded BYZ036 (from V07 to V08).
Effected files:
README* (changed files)
byz$033_version.asp (changed file for all vpasp versions)
admin/byz$033_version.asp (changed file for vpasp v7+ only)
11 11-APR-2011 Changed examples (and the subtables function) to use arrays instead of using cursors directly (to help avoid the 8k/memo problems where some values get blanked-out in cursors).
Brought the vpaspv7 files into line with the relevant latest generic vpasp v7 patches.
Split installation documentation into separate files for different vpasp versions, deleted unused files.
If upgrading to BYZ033 V11 or above on vpasp v7 or above, then please note that the Sub FindField change in the Add literal arguments to shopfileio.asp (and admin/adminfileio.asp) installation step has changed, please revert your Sub FindField function back to its normal (non-byz) state first, and then apply the new step (which renames the function and adds a new include above the function name).
(for list of effected files, see the version history in the byz033 modules docs folder)
12 13-SEP-2011 Upgraded BYZ038 (from V13 to V14).
Upgraded BYZ036 (from V08 to V09).
Effected files:
README* (changed files)
vpasp4.5/byz$033_version.asp (changed file)
vpaspv5.0to6.5/byz$033_version.asp (changed file)
vpaspv7.0andabove/byz$033_version.asp (changed file)
vpaspv7.0andabove/admin/byz$033_version.asp (changed file)
13 01-NOV-2011 Upgraded BYZ038 (from V14 to V15).
Upgraded BYZ036 (from V09 to V10).
Effected files:
README* (changed files)
vpasp4.5/byz$033_version.asp (changed file)
vpaspv5.0to6.5/byz$033_version.asp (changed file)
vpaspv7.0andabove/byz$033_version.asp (changed file)
vpaspv7.0andabove/admin/byz$033_version.asp (changed file)
14 23-FEB-2012 Changed to use the new BYZ038 functions where appropriate.
Upgraded BYZ038 (from V15 to V16).
Upgraded BYZ036 (from V10 to V11).
Please Note: You must be using V16 or later of BYZ038 before upgrading to V14 or later of BYZ033.
BYZ033 V14 or later will not work with V15 or below of BYZ038.
(for list of effected files, see the version history in the byz033 modules docs folder)
15 07-JUL-2012 Changed the vpasp 4.5 system file to not use the UCaseFieldnames variable as its not defined on some older versions of vpasp.
Upgraded BYZ038 (from V16 to V17).
Upgraded BYZ036 (from V11 to V12).
Effected files:
README* (changed files)
vpasp4.5/byz$033_version.asp (changed file)
vpasp4.5/byz_template_codes_sys.asp (changed file)
vpaspv5.0to6.5/byz$033_version.asp (changed file)
vpaspv7.0andabove/byz$033_version.asp (changed file)
vpaspv7.0andabove/admin/byz$033_version.asp (changed file)
16 17-JUL-2012 Upgraded BYZ038 (from V17 to V18).
Upgraded BYZ036 (from V12 to V13).
Effected files:
README* (changed files)
vpasp4.5/byz$033_version.asp (changed file)
vpaspv5.0to6.5/byz$033_version.asp (changed file)
vpaspv7.0andabove/byz$033_version.asp (changed file)
vpaspv7.0andabove/admin/byz$033_version.asp (changed file)
17 10-OCT-2012 Upgraded BYZ038 (from V18 to V19).
Upgraded BYZ036 (from V13 to V14).
Added live version/upgrade checks to the documentation documents.
Effected files:
README* (changed files)
vpasp4.5/byz$033_version.asp (changed file)
vpaspv5.0to6.5/byz$033_version.asp (changed file)
vpaspv7.0andabove/byz$033_version.asp (changed file)
vpaspv7.0andabove/admin/byz$033_version.asp (changed file)
18 04-MAR-2013 Upgraded BYZ038 (from V19 to V23).
Upgraded BYZ036 (from V14 to V16).
Effected files:
README* (changed files)
vpasp4.5/byz$033_version.asp (changed file)
vpaspv5.0to6.5/byz$033_version.asp (changed file)
vpaspv7.0andabove/byz$033_version.asp (changed file)
vpaspv7.0andabove/admin/byz$033_version.asp (changed file)
19 01-JAN-2014 Upgraded BYZ038 (from V23 to V28).
Upgraded BYZ036 (from V16 to V17).
Created core system template fields/functions for use by other BYZ modules and available for general site customizations.
Please Note: You must be using V28 or later of BYZ038 before upgrading to V19 or later of BYZ033.
BYZ033 V19 or later will not work with V27 or below of BYZ038.
Effected files:
README* (changed files)
vpasp4.5/byz$033_version.asp (changed file)
vpasp4.5/byz_template_codes_codes_syscodes.asp (new file)
vpasp4.5/byz_template_codes_functions_syscodes.asp (new file)
vpasp4.5/byz_template_codes_sys.asp (changed file)
vpasp4.5/byz_template_codes_sys_tools.asp (new file)
vpaspv5.0to6.5/byz$033_version.asp (changed file)
vpaspv5.0to6.5/byz_template_codes_codes_syscodes.asp (new file)
vpaspv5.0to6.5/byz_template_codes_functions_syscodes.asp (new file)
vpaspv5.0to6.5/byz_template_codes_sys.asp (changed file)
vpaspv5.0to6.5/byz_template_codes_sys_tools.asp (new file)
vpaspv7.0andabove/byz$033_version.asp (changed file)
vpaspv7.0andabove/byz_template_codes_codes_syscodes.asp (new file)
vpaspv7.0andabove/byz_template_codes_functions_syscodes.asp (new file)
vpaspv7.0andabove/byz_template_codes_sys.asp (changed file)
vpaspv7.0andabove/byz_template_codes_sys_tools.asp (new file)
vpaspv7.0andabove/admin/byz$033_version.asp (changed file)
vpaspv7.0andabove/admin/byz_template_codes_codes_syscodes.asp (new file)
vpaspv7.0andabove/admin/byz_template_codes_functions_syscodes.asp (new file)
vpaspv7.0andabove/admin/byz_template_codes_sys.asp (changed file)
vpaspv7.0andabove/admin/byz_template_codes_sys_tools.asp (new file)
20 01-APR-2015 Upgraded BYZ038 (from V28 to V31).
Upgraded BYZ036 (from V17 to V18).
Enhanced/changed to cater for VPCart V8.
Changed instances of VP-ASP/VPASP to VPCart as VPASP has now been rebranded/renamed.
Effected files:
README* (changed files)
vpcartv4.5/byz$033_version.asp (changed file)
vpcartv4.5/byz_template_codes_codes_example5.asp (changed file)
vpcartv4.5/byz_template_codes_functions_example5.asp (changed file)
vpcartv5.0to6.5/byz$033_version.asp (changed file)
vpcartv5.0to6.5/byz_template_codes_codes_example5.asp (changed file)
vpcartv5.0to6.5/byz_template_codes_functions_example5.asp (changed file)
vpcartv7/byz$033_version.asp (changed file)
vpcartv7/byz_template_codes_codes_example5.asp (changed file)
vpcartv7/byz_template_codes_functions_example5.asp (changed file)
vpcartv7/admin/byz$033_version.asp (changed file) vpcartv7/admin/byz_template_codes_codes_example5.asp (changed file)
vpcartv7/admin/byz_template_codes_functions_example5.asp (changed file)
vpcartv8andabove* (new folders/files)