View Single Post

   
  #3 (permalink)  
Old 04-17-2008, 09:18 PM
Stephan Szabo
 
Posts: n/a
Default Re: LOOping clobbering variable

On Sat, 1 Jan 2005, K Anderson wrote:

> The enclosed function returns a proper result only when the LOOP and its
> enclosed functionality is removed from the function. Notice near the
> return I have xml=xml||'</transaction>';
>
> That should at the least return what ever is in xml with </transaction>
> concatinated, or so I would hope. But it's empty.


Is it possible that you're ending up with a NULL after the loop? NULL
concatenated with anything is still NULL. If any of the various fields
you're concatenating in could be NULL you'll need to guard against that.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote