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
_________________________________________________________________
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
