Software Search
or: browse all software/services
Categories
SEO (19)
WebSite Software (66)
Desktop Software (1)
E-Commerce (66)
Database Tools (14)
Security Tools (5)
Image Tools (7)
Developer Tools (25)
Data Management Tools (19)
Admin Tools (32)
WebSite Visitor Experience (34)
B-2-Customer Interaction (8)
Services (Points) (1)
Passes/Subscriptions (1)
Shopping Carts »
    AspDotNetStorefront (5)
    Magento (5)
    VPCart (66)
Vendors »
    Big Yellow Zone (67)
Web Design Services (1)
Web Development Services (1)
 
(all products/services(67))
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.

Advanced SQL Execution for VPCart - BYZ097

<< back to previous screen

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



Advanced SQL Execution for VPCart - BYZ097
Latest version:04/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:£10.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

It's a very simple idea/screen, but very effective/useful.

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 VPCart 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 VPCart admin area instead with this addon.

After submission, it shows you the SQL Statement that it tried to execute, and if your SQL Statement failed then it'll show you the failure message that SQL produced and let you try again.

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).


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 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)
03 12-OCT-2012 Added BYZ038 (V19).
Added BYZ036 (V14).
Enhanced to deal with special characters.
Added a results block which shows success/failure of the execution and corresponding error message received if there was one (ie it no longer just fails to load the screen if the SQL statement fails, instead it shows you the failure message that the SQL generated and lets you try again).
Tidied up the html.
Made the textbox for the SQL statement bigger.
Added message explaining the current database type being used on the site (MySQL, Access, SQLServer).
Changed to use BYZ038 functions where appropriate.
Split the documentation into separate files for each section and clarified/simplified the installation instructions.
Added live version/upgrade checks to the documentation documents.
Please Note: If upgrading from a previous version of BYZ097, you must make sure you are using V19 or above of BYZ038 before upgrading to BYZ097 V03 or above.
Please Note: If upgrading from a previous version of BYZ097, you must make sure you are using V14 or above of BYZ036 before upgrading to BYZ097 V03 or above.
Effected Files:
byz$097_version.asp (changed file)
shopa_doexecutesql.asp (changed file)
shopa_doexecutesql$config.asp (deleted file)
04 01-APR-2015 Upgraded BYZ038 (from V19 to V31).
Upgraded BYZ036 (from V14 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)
byz$097_version.asp (changed file)
shopa_doexecutesql.asp (changed file)