You are right! Your way is more effecient. Dwayne
---- Original message ---- >Date: Mon, 16 Jun 2008 09:22:19 -0400 >From: Axton <[EMAIL PROTECTED]> >Subject: Re: Get all results from a SQL call >To: [email protected] > >You do realize, with this approach, that you are pulling a record set >for every record, right? If you have 1000 records, you will perform >1000 queries against the db table. A filter table walk would be much >more efficient. Alternatively, you could write a stored procedure >that returned the entire record set as a single string, which would be >even more efficient. > >Axton Grams > >On Mon, Jun 16, 2008 at 8:15 AM, Dwayne Martin <[EMAIL PROTECTED]> wrote: >> Here's my algorithm. There may be better ones. >> >> You have an Active Link Guide: "FormName:Find Records" with these ALs and >> Label: >> >> "FormName:Find:INNER 10 Initial get first record" >> Select a from c order by a >> result = $1$ >> >> "FormName:Find:INNER 20 add first record, error if empty" >> If result != NULL >> add it to the field >> else >> Send Message saying that there are no records >> Exit guide >> >> Label: "Again" >> >> "FormName:Find:INNER 30 get next record" >> Select a from c where a > $result$ order by a >> result = $1$ >> >> "FormName:Find:INNER 40 add record, go to again" >> If 'result' != NULL >> Add result to field, go to "Again" >> (No Else needed, the guide will exit when there are no more records) >> >> You should be able to do without the first to ALs. Just set "result" to "" >> to start out. But it seems like I ran into trouble doing it that way. >> (It's been a while since I tried it.) >> >> Good luck, >> Dwayne Martin >> James Madison University >> >> ---- Original message ---- >>>Date: Fri, 13 Jun 2008 15:26:27 -0400 >>>From: Frank Caruso <[EMAIL PROTECTED]> >>>Subject: Re: Get all results from a SQL call >>>To: [email protected] >>> >>> ** 1. Create SQL view of the data from your Remedy >>> database. >>> 2. Create a View form in Remedy using that SQL view >>> 3. Create a table field using that new View. Now >>> when the table refreshes it will have a local copy >>> of all of the records and you can table walk it. >>> >>> On Fri, Jun 13, 2008 at 3:08 PM, Brittain, Mark >>> <[EMAIL PROTECTED]> wrote: >>> >>> 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" >>> >>> __Platinum Sponsor: www.rmsportal.com ARSlist: >>> "Where the Answers Are" html___ >> > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

