Suggestions - SQL input

Print Page | Close Window

SQL input

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Suggestions
Forum Description: ProductCart Suggestions
URL: https://forum.productcart.com/forum_posts.asp?TID=53
Printed Date: 24-November-2024 at 10:18am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: SQL input

Posted By: Hamlet
Subject: SQL input
Date Posted: 27-November-2005 at 2:30pm

I would like to see a page where you can type in an SQL string and have it execute.

For instance, I could type in Select EMail from Users where Newsletter = Yes;

And the resulting page would show all of the users who have requested a newsletter. (I realize that sql syntax is not correct for product cart, but that was an example.)

Replies:

Posted By: ProductCart
Date Posted: 27-November-2005 at 7:29pm

This is something that we have considered, but which we have decided not to add to the system up to this point. The main concern is that it provides too much room for error, and could easily lead to disruptive results if used improperly. For now, we ask you that you use MS Access or a MS SQL tool such as Enterprise Manager to run custom queries.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: Hamlet
Date Posted: 27-November-2005 at 7:37pm

I am not sure I understand how using access or EM will have less room for error.

Posted By: ProductCart
Date Posted: 27-November-2005 at 7:48pm

There is a big difference between the two. If you run a query directly using MS Access or EM, then you are operating outside ProductCart. In that scenario, ProductCart is clearly not involved, as it is in no way "enabling" you to perform that task. It is something that you are doing at your own risk.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: Hamlet
Date Posted: 27-November-2005 at 8:01pm

You could limit the querys to "select" statements and not allow Create, Update or Insert Statements (or others that you think would be disruptive).

Posted By: geoff
Date Posted: 15-January-2006 at 7:22pm

I agree with Hamlet.

Having to go outside of Productcart for custom queries is a quiet abstract.
Also when the MS SQL is hosted on a shared server, it is a fair amount of trouble to configure Enterprise manager. You have at least two customers who are interested.....

Posted By: ProductCart
Date Posted: 16-January-2006 at 7:24pm

Here is a file that can perform this task. As you know, database changes cannot be undone. Be careful and backup the database!

http://www.earlyimpact.com/forum/uploaded_files/earlyimp/2006-01-16_192352_AdminRunQuery.zip - 2006-01-16_192352_AdminRunQuery.zip

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: geoff
Date Posted: 16-January-2006 at 8:00pm

Thanks for the quick posted reply

Posted By: Hamlet
Date Posted: 16-January-2006 at 8:12pm

Thanks.

I will have to give it a try.

For me, I really just want to run select statements - but it will be nice to be able to run the others as well.

Posted By: geoff
Date Posted: 16-January-2006 at 8:21pm

Hamlet
Could you post back your experience. I would like to know what you experienced. I'll do the same but this isn't something that I specifically am working on currently.

Posted By: Hamlet
Date Posted: 16-January-2006 at 8:29pm

No problem.