I'm not sure if I have correctly understood your question yet then..
Do you mean to ask how do you know what column maps to what field ID???
If so that could be easily determined from the field meta table..
select name, fieldid from field where schemaid in (select schemaid from
arschema where name = 'HPD:Help Desk') order by fieldid;
That will give you a list of all fields from the helpdesk form with the
corresponding fieldID for each fieldname..
Joe
-----Original Message-----
From: smiley
Sent: Monday, May 07, 2012 11:44 AM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: to commit or not to commit... that is the question
Hi Joe!
I only did the "Select *" because I'm trying to find out the NAMES of the
COLUMNS so I can find my fields.
I hope to use the Direct SQL to update my fields as to who is in the
incident and at what time-stamp.
so my final SQL will be something like:
UPDATE HPD_Help_Desk SET $xxx$ = $USER$ WHERE $1$ = $Incident Number$;
But my Problem is... How do I know Which Field Number / Column is My
Field??? Is it defined somewhere in the Properties of the field???
Thanks for any help!!! :)
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
