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 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.8/1340 - Release Date: 3/23/2008 6:50 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
