Software Search
or: browse all software/services
Categories
SEO (19)
WebSite Software (71)
E-Commerce (69)
Database Tools (13)
Security Tools (6)
Image Tools (6)
Developer Tools (24)
Data Management Tools (18)
Admin Tools (29)
WebSite Visitor Experience (32)
B-2-Customer Interaction (6)
Services (Points) (6)
Subscriptions (5)
Shopping Carts »
    AspDotNetStorefront (8)
    Magento (8)
    VPASP (69)
Vendors »
    Big Yellow Zone (78)
Web Design Services (6)
Web Development Services (8)
 
(all products/services(78))
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: 7/30/2011 11:50:00 PM
We've now got 4 maillists you can signup to, eg "My BYZ Updates" for personalized upgrade info on your products so that you get informed as soon as a new version of *your products* come out. click here for more info.
Released: 4/12/2011 6:00:00 AM
Twitter: You can now keep up with BigYellowKey developments/news using twitter: http://twitter.com/bigyellowkey If you're a Twitter user, Click the "Follow" link on http://twitter.com/bigyellowkey to keep up to date.
Released: 4/9/2011 2:05:00 PM
Do you sell website tools/applications? We are currently looking for developers and software vendors to help beta-test the new system. Want to sell your own stuff via this site? Contact us and beta-test the system and see what you think.
Released: 3/26/2011 2:05:00 PM
Our software has now been categorized on the right-panel of the site, so you can get a quick/easy overview of what's available.
Released: 3/10/2010 2:05:00 PM
Twitter: You can now keep up with BigYellowZone releases and news using twitter: http://twitter.com/bigyellowzone If you're a Twitter user, Click the "Follow" link on http://twitter.com/bigyellowzone to keep up to date.
Released: 12/14/2009 2:45:00 PM
VPASP V7 status for BigYellowZone Addons:
click here for details
Released: 8/25/2009 2:05:00 PM
We've decided to extend the discounting of the BYZ subscription services, where the initial fee element is reduced by the cost of BYZ Addons that you've purchased in the last 12 months. This relates to the subscription services of BYZ147, BYZ148, and BYZ149. The reduced price will be shown when you get to the confirm-order page (ie after you have entered your domain).
Released: 4/25/2009 10:45:00 AM
BYZ Subscription Services added! You can now subscribe to get addons, or hosting, or both. For people who have bought BYZ addons in the last 12 months, you can trade-in what you've spent on addons in the last 12 months against a reduction in the relevant initial-fee element of the subscription service. This trade-in offer will only last for the next 30 days, so trade-in now! This trade-in relates to BYZ147, BYZ148, and BYZ149. See "subscription services" in the right-panel above or click on "services list" at the top. You'll get/see your discounted price of the subscription when you get to the final "confirm order" page (ie before you make payment, but after you've chosen your domain(s)). For example, if you've spent £120 on BYZ addons in the last 12 months, then you can get BYZ147 for just £37. If you've spent £200 on BYZ addons in the last 12 months then BYZ147 would only cost you £7. The prices concerned relate to prices excluding vat/tax and do not include installation cover/services. PLEASE NOTE: If you already have BYZ072/02 (Installation Cover) then that installation cover becomes invalid after you subscribe.
Released: 4/14/2009 2:00:05 PM
The My-Software screen has been changed to show a traffic-light system which shows a red cross for any modules which need upgrading, and a green tick for any modules which are up to date, which allows you to see at a glance if you need upgrades. NOTE: Please check your my-software screen regularly to see if upgrades are available.
Released: 4/14/2009 2:00:00 PM
Upgrade protection has been added which you can optionally purchase whenever you buy new modules, domains, or upgrade. It will give you permanent cover against the cost of future software upgrades for your module/domain. This is a major change to the bigyellowkey.com system; please let us know if you have any problems/questions.
Released: 2/23/2009 11:05:00 PM
**Notice: There was a temporary glitch with the bigyellowkey.com checkout process today; we have now investigated/fixed the problem. Apologies for any inconvenience this may have caused.
Released: 12/1/2008 12:00:01 AM
VAT Reduced to 15% - Following the recent government announcements in the UK, VAT (only payable on orders placed from the EU) has now been reduced from 17.5% to 15% with immediate effect from Midnight 1st December 2008, and will remain at 15% for 13 months. All of the bigyellowkey.com ordering and payment processes have been changed to accommodate this. Customers outside the EU do not pay any VAT. Customers from the UK always pay VAT. Customers from the EU (but outside the UK) who have a valid VAT/Tax number do not pay vat. Customers from the EU (but outside the UK) who do not have a valid VAT/Tax number pay VAT.
Released: 11/10/2008 1:05:00 PM
FAQs (Frequently Asked Questions) section has been added. Click on the Help link at the top of the page, or click on the FAQs link on the right panel help section.
Released: 10/17/2008 5:05:00 PM
What's New Link added to the top of the BYK screens. This allows you to see all new software released, and all new versions (upgrades) released, in descending date order. Want to know what's been happening on the software front? Just click on "what's new?" at the top of the screen.
Released: 9/2/2008 6:00:00 PM
New Software Vendor! SQLInjectionScanner.com (a sister company of BigYellowZone) is now using the BigYellowKey.com site to distribute anti-hacker tools and other products/services which site owners will find very useful. Visit SQLInjectionScanner.com for more info. If you previously bought the BYZ "hack checker", then check your my-software screen to grab the latest update; it has now become the "SQLInjectionScanner.com Scanner" and the new version has lots more features. A data cleaner is also available, as are check/fix services.
Released: 11/22/2007 4:29:00 PM
Mail-Lists (with discounts) added. Your profile now has a mail-list option at the bottom where you can optionally sign up to mail-lists. Some mail-lists will give you discounts (these discounts will be explained on the mail-list description). Default will always be "no sign up" for any customer, either historic or new customers. You will need to explicitly tick the sign-up box and save the changes to get added to the mail-list (and receive the relevant discount).
Released: 10/16/2007 11:57:00 AM
Live/Archived radio buttons fixed - the live/archived/all radio buttons at the top of your "My Software" (and other "My") screens have now been fixed. They were previously one-step behind what you pressed, but are now correct and automatically refresh as soon as you click on one of the radio buttons.
Released: 10/16/2007 11:56:00 AM
localhost assigned for free - you can now add localhost to any of your licenses during purchases/upgrades, or via your "My Domains" tab, and it will automatically give you the localhost key for free.
Released: 10/16/2007 11:55:00 AM
New version of byk released - if your customer control panel shows you the login screen, then please login again. Once logged in you will no longer need to login again.
Released: 10/11/2007 12:30:00 PM
Upgrade fix applied. There was a problem when upgrading Backfilled BYZ licences, this has now been fixed, but if you upgraded on BYK prior to this news item being added then go into your "My Software" screen, and check if you have multiple versions of a given product for a given domain; if you have multiple versions then press the archive link on the old versions, then go to your license keys page and create a new license key file, then download that key file and upload it to your site.
Released: 10/8/2007 11:50:00 PM
Sub-Modules added to your software lists - We have now ensured that all of your sub-modules are now listed for your main modules on your software screen. This means that you can now upgrade/download either the main module, and/or the sub-modules. Our upgrading and purchasing procedures use "intelligent" bundling, whereby if you've upgraded/bought all the corresponding sub-modules then you'd automatically also be assigned all appropriate parent bundls, and if you buy/upgrade a bundle then it will automatically assign access to all the sub-modules as well. Checkout your "My Software" screen, as it may now be showing you additional/new sub-modules.
Released: 9/28/2007 8:15:00 AM
BYZ Interface Improved - We have now changed our sister site (bigyellowzone.com) so that you will only get directed to bigyellowkey when you checkout, and not each time you add an item to your cart. This means that you can continue freely shopping/browsing on bigyellowzone.com without having to jump between byk/byz sites for each item. Note that for upgrades you should always use bigyellowkey.com for browsing/purchasing, and not bigyellowzone.com.
Released: 9/25/2007 11:45:00 PM
Version History Displays - We've added a link on the product-codes on your "My Software" screen which will popup a printer-friendly page that displays all the product details and the full version history (ie all the release notes of all versions) so that you can now see if you want/need to upgrade specific modules.
Released: 9/23/2007 2:05:00 PM
We're Live ! - BigYellowKey.com has now become a live system. There might be some teething questions/problems following its release, so if you have any questions/problems then please do let us know.

VP-ASP Template Fields Addon - 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



VP-ASP Template Fields Addon - BYZ033
Latest version:14/23-FEB-2012
From vendor:Big Yellow Zone
Price:£20.00
add to cart


Compatibility, Bundling, and Status Notes:
Compatible with VPASP V4.5 to V7
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 VP-ASP's formatcurrency special-field) to format specific values, or use them with no arguments (as per VP-ASP'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.




For further information from the vendor about this product, please visit:


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)