In order to help developers like myself get better at filtering data, my son is named Robert'); DROP TABLE Students;-- Pierson.
http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM To: [email protected] Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza <[email protected]<mailto:[email protected]>> wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement ==> select count(*) from <view name> Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -----Original Message----- From: [email protected]<mailto:[email protected]> Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry(r) from Vodafone _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
