Advanced SQL Execution Tool for VP-ASP (BYZ097/02) by BigYellowZone

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.

Subscription Services

BYZ Member Plan Subscription
add to cart

£157.00
more...

Points system now available!
Want something done? Installation, upgrade of addons? Customisation? From tiny-tweaks to large scale projects,
click here for info on BigYellowZone points.

Money Saving Bundles

Image Processing Mega-Bundle for VPASP add to cart	£75.00 more...

Google-Base and Yahoo Feed Bundle for VP-ASP add to cart	£45.00 more...

FREE Downloads!

Free Trial Admin Category Tree for VP-ASP
add to cart

free!
more...

BigYellowKey News

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.

BYZ097 - Advanced SQL Execution Tool for VP-ASP

<< back to previous screen

Call this handy admin screen to execute advanced SQL commands in your vpasp admin area directly, such as insert, update, delete, create, drop, alter etc.

Compatibility, Bundling, and Status Notes:

Compatible with VPASP V4.5 to V7
(no other sub-modules are needed for this software)

Latest version:		02/15-DEC-2009
From vendor:		BigYellowZone
Price:		£2.75
(already in cart)

It's a very simple idea/screen, but very effective/useful (and only costs a very small nominal fee!)

Works on any type of database (SQLServer, MySQL, Access).

SQLServer/MySQL users: How often have you wanted to run a simple update statement (eg "update products set cprice=cprice*1.1") or a simple command to add a new column, and had to go to all the hassle of logging into your raw sql database to do it even though you're already in vpasp admin? Well, you no longer need to login to your raw database (or your host's web-based sql front-end if they have one) as you can execute your command directly from your vpasp admin area instead with this addon.

Access users: Same kind of benefits as SQLServer/MySQL users but with the added benefit that you don't need to bother downloading/re-uploading your access database file to perform your sql change.

Technical/Developer Information:
If you like this, have a look at our Bulk Product Update tool (BYZ089).

For further information from the vendor about this product, please visit:
http://www.bigyellowzone.com/shopexd.asp?id=114

Full Version History:

VerNo	Version Date	Release Notes
01	29-MAR-2006	Initial version - Big Yellow Zone Advanced SQL Execution Tool for VP-ASP
02	15-DEC-2009	Changed installation notes and program files to cater for VPASP V7 and tidied-up html etc. Effected Files: byz097_install.asp (deleted file) byz$097_version.asp (new file) shopa_doexecutesql$config.asp (new file) shopa_doexecutesql.asp (changed file)