It be easy if everything was in a form. lol Sadly, the data that I need is in another database and that is the problem. The Push Fields doesn't handle SQL at all. If it did, it would be easier then. I've tried throwing some sql into the Push Fields "push if" qualification and it gave me a relational error and the sql was valid. I guess I'll just have to handle one at a time.
Thanks though Carey =) Bob Halstead -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, September 29, 2006 7:07 AM To: [email protected] Subject: Re: Database results Bob, Make a view form that you can do an equivalent search to your "SQL query". Then you could: Create a table field that searches this view form with the correct search conditions. Use an active link loop over the table and for every row push a new record to the target form. OR you could: Do a push to modify all matching rows in the view. Then have filters on the view form do a push to the target form. NOTE: ARS is not a "set based language". It is "single record" tranactional in nature. Even the Push to "Modify All" really processes each record one by one. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 9/28/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: > ** > > I would like to handle multiple results from a sql query in remedy. > The query I want to run may return multiple results in which I would > like to push each result to a form. Is this possible? > > > > Bob Halstead __20060125_______________________This posting was > submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
