Dear listers,
can anyone shine a light on this one...
I have some HTML page-titles which i'd like to put in a dropdown menu. Least
load for server is when just using a server-cursor. And going trough the
results just once.
So best thing is to order the titles in the right way when recieving them
Hi list,
I'd like to generate arrays into a field for the result-set
by means of grouping...
myTable >> ( MySQL 3.23.33 / MyISAM table )
++--+
| id| type |
++--+
| 002 | 'CD' |
| 002 | 'LP' |
| 011 |'DVD' |
| 081 |
the source of trouble. This convertion
is a solution that does the trick.
My guess is that the ODBC driver is
behaving badly in this case ...
Cheers,
bart
> Van: Bart Goormans
> Verzonden: zondag 16 december 2001 9:21
>
>
> There seems to be a flaw in the myODBC driver
There seems to be a flaw in the myODBC driver
02.50 when working with the Unix-Timestamp()
function.
Apparently, the driver doesn't know which
data-type to use...
When I send the sql statement:
--
Select
( UNIX_TIMESTAMP(U.lastTime) -
UN
mailto:[EMAIL PROTECTED]]
> Verzonden: donderdag 9 augustus 2001 7:45
> Aan: Bart Goormans
> Onderwerp: Re: Migrating from MS SQLserver to MySQL
>
>
> I had an almost similar problem with conversion from
> Access to MySQL and that was easily solved by
> generating an SQL
I'll look into this,
Thanks,
bart goormans
(will be following up on this thread shortly ...)
Van: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 9 augustus 2001 3:53
Bart:
There are many ways to skin this cat, but this is one we have used
recently
with good su
'DTS' the information ?
Sorry Edgart, what exactly do you mean by that ?
bart
From: Edgart Gonzalez [mailto:[EMAIL PROTECTED]]
augustus 9, 2001 3:39
You can DTS you information from MsSql to MySQL via ODBC.
-Original Message-----
From: Bart Goormans [mailto:[EMAIL PROTEC
Hi all,
There's a fairly large MS SQLserver Database that my client wants me to
convert to MySQL. Can someone advice me on how to tackle this, or direct me
to some help.
There aren't any BLOBs-fields or other exotic field types, mainly
straightforward text/integers, so I don't expect too much pro