Lee.
Maybe others would disagree but they way I would handle this would be to
forget about storing the data in separate fields (or binary fields) and use
three tables.
Table1 - Facilities
A complete list of all criteria you want to record about the hotels
Table2 - Hotels
Table containing the hot
Eben.
Yes, use a character based data type as the leading zero's are insignificant
and will be removed.
HTH
Kev.
> --
> From: Eben Goodman
> Sent: Tuesday, August 5, 2003 14:49 PM
> To: [EMAIL PROTECTED]
> Subject: storing large integers properly
>
> I am storing
Hi.
I need to replicate data (approx. 10,000 records) from a mySQL database into
a different (non mySQl) database automatically on a regular basis. I have no
control over the mySQL server (apart from allowing ODBC access) so I cannot
modify any tables or enable replication etc...
My initial thoug
Charles.
Have you tried Omnis Studio (www.omnis.net). It's a 4GL RAD which
supports Mac Classic, OSX, Windows, Linux and Solaris.
I use the Mac and Windows version nearly everyday and find it an
excellent tool for creating database front-ends (mySQL access is via
ODBC).
The Omnis-Underground host
Brad.
Not sure if you got my last mail but did you try Omnis Studio from
www.omnis.net (trial download available).
It is available for MacOS Classic, OSX, Windows, Solaris and Linux. Never
used the Solaris/Linux versions but I do use the Mac and Windows versions
every day.
HTH
Kev.
> --
Hi.
What is the easiest way to backup a mySQL v3 database?
Can it be backed up online or do I have to disable it, copy the files and
then enable it again.
Cheers.
Kev.
This e-mail has been scanned for all viruses by Star
Hi.
I'm converting a database from a filesharing based technology to mySQL. The
database has its own column type called Sequence which is the same as using
the AUTO_INCREMENT property. I'd like to use AUTO_INCREMENT if possible but
I'm not really sure what I can do with it - can anybody help with