Re: Get all results from a SQL call

2008-08-13 Thread Brittain, Mark
: Re: Get all results from a SQL call ** 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

Re: Get all results from a SQL call

2008-08-13 Thread Darrell Reading
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark Sent: Wednesday, August 13, 2008 13:59 To: arslist@ARSLIST.ORG Subject: Re: Get all results from a SQL call ** Hi Frank, Thanks for your help. Now I have run into something

Re: Get all results from a SQL call

2008-08-13 Thread Frank Caruso
-- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Frank Caruso *Sent:* Friday, June 13, 2008 3:26 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Get all results from a SQL call ** 1. Create SQL view of the data from your Remedy

Re: Get all results from a SQL call

2008-06-17 Thread Misi Mladoniczky
, 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

Re: Get all results from a SQL call

2008-06-17 Thread Chris Woyton
in the format 01;02;3... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Misi Mladoniczky Sent: Tuesday, June 17, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Get all results from a SQL call Hi

Re: Get all results from a SQL call

2008-06-16 Thread Dwayne Martin
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: arslist@ARSLIST.ORG ** 1. Create SQL view of the data from your Remedy

Re: Get all results from a SQL call

2008-06-16 Thread Axton
Caruso [EMAIL PROTECTED] Subject: Re: Get all results from a SQL call To: arslist@ARSLIST.ORG ** 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

Re: Get all results from a SQL call

2008-06-16 Thread Grooms, Frederick W
discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark Sent: Friday, June 13, 2008 2:09 PM To: arslist@ARSLIST.ORG 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

Re: Get all results from a SQL call

2008-06-16 Thread Dwayne Martin
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: arslist@ARSLIST.ORG You do realize, with this approach, that you are pulling a record set

Get all results from a SQL call

2008-06-13 Thread Brittain, Mark
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.

Re: Get all results from a SQL call

2008-06-13 Thread Frank Caruso
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,