ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Suggestions
  New Posts New Posts RSS Feed - SQL input
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL input
 Post Reply Post Reply Page  12>
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
Hamlet View Drop Down
Newbie
Newbie


Joined: 19-November-2005
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamlet Quote  Post ReplyReply Direct Link To This Post Topic: SQL input
    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.)

 
Back to Top
ProductCart View Drop Down
Admin Group
Admin Group

ProductCart Team

Joined: 01-October-2003
Status: Offline
Points: 135 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ProductCart Quote  Post ReplyReply Direct Link To This Post 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 shopping cart software
Back to Top
Hamlet View Drop Down
Newbie
Newbie


Joined: 19-November-2005
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamlet Quote  Post ReplyReply Direct Link To This Post Posted: 27-November-2005 at 7:37pm
I am not sure I understand how using access or EM will have less room for error.
Back to Top
ProductCart View Drop Down
Admin Group
Admin Group

ProductCart Team

Joined: 01-October-2003
Status: Offline
Points: 135 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ProductCart Quote  Post ReplyReply Direct Link To This Post 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 shopping cart software
Back to Top
Hamlet View Drop Down
Newbie
Newbie


Joined: 19-November-2005
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamlet Quote  Post ReplyReply Direct Link To This Post 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).
Back to Top
geoff View Drop Down
Newbie
Newbie


Joined: 15-January-2006
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote geoff Quote  Post ReplyReply Direct Link To This Post 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.....
Back to Top
ProductCart View Drop Down
Admin Group
Admin Group

ProductCart Team

Joined: 01-October-2003
Status: Offline
Points: 135 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ProductCart Quote  Post ReplyReply Direct Link To This Post 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!

2006-01-16_192352_AdminRunQuery.zip
The ProductCart Team

Home of ProductCart shopping cart software
Back to Top
geoff View Drop Down
Newbie
Newbie


Joined: 15-January-2006
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote geoff Quote  Post ReplyReply Direct Link To This Post Posted: 16-January-2006 at 8:00pm
Thanks for the quick posted reply
Back to Top
Hamlet View Drop Down
Newbie
Newbie


Joined: 19-November-2005
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamlet Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
geoff View Drop Down
Newbie
Newbie


Joined: 15-January-2006
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote geoff Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.102 seconds.