Hi,
If you can hook it up as a View Form, you can just as well create a
Filter-Table-Loop to fill create the result. No external program would be
needed.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Mark,
> If you have a view form set up in ARS to access the table in the external
> DB, there is an old utility from ESP (Elegant Software Producers) called
> ESP
> "Query List" that you could use to return the results of the query to a
> character field (see attached for description). ESP hasn't been around
> for
> quite some time now, but I was able to archive the web site and all of the
> free utilities before it was taken down. If you would like to give it a
> try, let me know.
>
> Regards,
>
> Thomas
>
> ----- Original Message -----
> From: "Brittain, Mark" <[EMAIL PROTECTED]>
> Newsgroups: gmane.comp.crm.arsystem.general
> To: <[email protected]>
> Sent: Friday, June 13, 2008 2:08 PM
> Subject: Get all results from a SQL call
>
>
>> Hi All & TGIF,
>>
>> I need to do a SQL query to a database outside of Remedy and gets all of
>> the contact records for a customer and drop them into a field in a
>> ticket. Of course I can get the first or display a list if there are
>> multiple. There has to be a way to get all records that meet the
>> criteria.
>>
>> ARS 6.3 patch 20
>> Oracle 9.2
>> SunOS 5.9
>>
>> Any ideas?
>>
>> Thanks
>> Mark
>>
>> Mark Brittain
>> Remedy Developer
>> NaviSite ESM Operations
>> 315-453-2912 x5418 (Office)
>> 315-317-2897 (Cell)
>>
>>
>> This e-mail is the property of NaviSite, Inc. It is intended only
>> for the person or entity to which it is addressed and may contain
>> information that is privileged, confidential, or otherwise protected
>> from disclosure. Distribution or copying of this e-mail, or the
>> information contained herein, to anyone other than the intended
>> recipient is prohibited.
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
