That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn <shawn.pier...@sug.com>wrote:
> ** > > 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: > arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller > *Sent:* Thursday, April 26, 2012 1:44 PM > *To:* arslist@ARSLIST.ORG > *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 <jdso...@shyle.net> > 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: remedyarl...@gmail.com > Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: > public.remedy.arsystem.general**** > > > To: arslist@ARSLIST.ORG > 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® from Vodafone > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 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 hyperlink, please e-mail sender. > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"