My guess would be that the e_mail_address is bigger than 255 chars which cannot be included in a table field.
On Wed, Aug 13, 2008 at 2:59 PM, Brittain, Mark <[EMAIL PROTECTED]>wrote: > ** > > Hi Frank, > > > > Thanks for your help. Now I have run into something interesting. I have a > few from the database, and a view form in Remedy. When I do to build the > table field, I can select any of the field in the view form and put it in > the table except the one I want which is the "e_mail_address' field. > > > > Any ideas on where to look or what questions to ask the dba? > > > > Thanks > > Mark > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Frank Caruso > *Sent:* Friday, June 13, 2008 3:26 PM > *To:* [email protected] > *Subject:* 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 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___ > > *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.* > __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"

