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"

Reply via email to