You're welcome.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Moore, Christopher Allen Sent: Monday, March 24, 2008 1:49 PM To: [email protected] Subject: Re: Table name containing error messages for active links
** Thanks Joe- I found it! ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 24, 2008 12:47 PM To: [email protected] Subject: Re: Table name containing error messages for active links actlink_message The structure of the table is as follows so restructure your query.. SQL> desc actlink_message Name Null? Type ----------------------------------------- -------- ---------------------- ------ ACTLINKID NOT NULL NUMBER(15) ACTIONINDEX NOT NULL NUMBER(15) MSGTYPE NOT NULL NUMBER(15) MSGNUM NOT NULL NUMBER(15) MSGTEXT NOT NULL CLOB MSGPANE CHAR(1) select actlinkid from actlink_message where msgnum = 1440010; Hope this helps Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Moore, Christopher Allen Sent: Monday, March 24, 2008 1:23 PM To: [email protected] Subject: Table name containing error messages for active links ** So if this is the query for filters, select filterid from filter_message where msgnum = 1440010 What would the table name be for active link messages? Sorry- I still don’t have DB access and can’t poke around myself yet and I need to get the table name to someone who can. SQL 2005 ITSM 7 Windows Server Thanks, Chris _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
