Denis, Thanks for testing, I guess that assertion should be relaxed to allow number to be either rank-1 or rank-2 column vector. However text should remain as rank-2 character matrix.
inverted table http://www.jsoftware.com/jwiki/Essays/Inverted%20Table Чтв, 08 Июл 2010, Denis Samson писал(а): > > Bill, > > I retried it with (>'un';'deux') and ddins works fine; OTOH, ddins > insists on having data in columns, for some unknown -& quite unnecessary, > I'd guess- reason: > > lh=.'select hnd,id,lat,lon from stop'; 3 4; (>'un';'deux'); 1234 1234; > 2345 2345 > lh ddins ch > _1 > NB. (because ddins[4] if. -. *./ 2=> #...@$&.>}.x do. errret ISI08 > return. end.) > > lh=.'select hnd,id,lat,lon from stop'; ,.each 3 4; (>'un';'deux'); 1234 > 1234; 2345 2345 > lh ddins ch > 0 > ]data=. ddfch _1,~ 'select * from stop' ddsel ch > ┌─┬────────────────────┬────┬────┬──┐ > │3│un │1234│2345│__│ > │4│deux │1234│2345│__│ > └─┴────────────────────┴────┴────┴──┘ > > regards, > Denis > > > > Date: Thu, 8 Jul 2010 01:16:57 +0800 > > From: [email protected] > > To: [email protected] > > Subject: Re: [Jprogramming] bulk insert with ODBC (into MySQL db) > > > > Срд, 07 Июл 2010, Denis Samson писал(а): > > > > (...) > > > ]lh=:'select hnd,id,lat,lon from stop';,.each 1 2;('un';'deux');1234 > > > 1235;2345 2345 > > > ┌──────────────────────┬─┬──────┬────┬────┐ > > > │select hnd,id,lat,lon from stop│1│┌────┐│1234│2345│ > > > │ > > > │2││un ││1235│2345│ > > > │ │ > > > │├────┤│ │ │ > > > │ │ > > > ││deux ││ │ │ > > > │ │ > > > │└────┘│ │ │ > > > └──────────────────────┴─┴──────┴────┴───┘ > > > > I think that should be > > ]lh=:'select hnd,id,lat,lon from stop'; 1 2;(>'un';'deux');1234 1235;2345 > > 2345 > > > > shape of numbers doesn't matter but string data must not boxed, may be > > that is the reason for the funny characters returned. > > > > -- > > regards, > > ==================================================== > > GPG key 1024D/4434BAB3 2008-08-24 > > gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > > _________________________________________________________________ -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
