Richard Cunningham wrote: > sh =: 'select purch_ref, from_whom, description, category, ir_category, date_format(date_purch,''%Y-%m-%d''), amount, pay_method from purchases2' ddsel ch
I haven't done much with database connectivity. However, an observation, if you take the result from this query, and assign it to a sequence of variables, you might find the result easier to work with. In other words, > dat =. ddfet sh,5 'purch_ref from_whom description category ir_category date_purch amount pay_method'=: |:dat By the way, if you wind up with a column of numbers represented as a table of characters, ". will convert that to a vector of numbers. (I didn't see one of these in my brief experiments, but I don't know if that's my version of mysql, the options I used to connect, my version of the drivers, the underlying datatype of the column, or what.) But maybe this one suggestion will help. -- Raul ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
