My bad... the query should actually be..
select fieldname, fieldid from field where schemaid in (select schemaid from
arschema where name = 'HPD:Help Desk') order by fieldid;
I typed name for fieldname by mistake..
Sorry about that..
Joe
-----Original Message-----
From: smiley
Sent: Monday, May 07, 2012 11:55 AM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: to commit or not to commit... that is the question
Yes! that is it! Thank you!!!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"