SQL input

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Hamlet Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Hamlet Report Post Thanks(0) Quote Reply 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.)

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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

Hamlet Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Hamlet Report Post Thanks(0) Quote Reply Posted: 27-November-2005 at 7:37pm
	I am not sure I understand how using access or EM will have less room for error.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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

Hamlet Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Hamlet Report Post Thanks(0) Quote Reply 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).

geoff Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-January-2006 Status: Offline Points: 2	Post Options Post Reply Quote geoff Report Post Thanks(0) Quote Reply 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.....

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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

geoff Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-January-2006 Status: Offline Points: 2	Post Options Post Reply Quote geoff Report Post Thanks(0) Quote Reply Posted: 16-January-2006 at 8:00pm
	Thanks for the quick posted reply

Hamlet Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Hamlet Report Post Thanks(0) Quote Reply 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.

geoff Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-January-2006 Status: Offline Points: 2	Post Options Post Reply Quote geoff Report Post Thanks(0) Quote Reply 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.