date:20020328

Re: filemaker to mysql

2002-03-28 Thread Joel Rees

rory oconnor inquired:

> I have a new client that wants to use filemaker on his mac to enter data
> for site information.  I'm sure that I can take that and export the
> files and import into the site's MySQL database...but I'm wondering if
> it is possible to link his filemaker database to the MySQL database
> using ODBC?  I have done this with MS Access on a PC, but not filemaker
> on a mac.
>
> Has anybody done this or know where I can get more information?

Haven't done it, but it sounds interesting. Nosed around with searches at
google and found out that Lasso (who sometimes announces to this mail list)
appears to claim to be able to integrate them. (Lasso has their own
language, something of a non-open competitor to perl/php.)

Also went over to filemaker (http://www.filemaker.com) and found some specs.
ODBC is apparently not yet supported on Mac OS X, but they seem to indicate
they are working on it. It looks like it supports JDBC, so you may be in
luck if you use Java.

Not much information.

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka


sql, query



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Importing fixed-length records

2002-03-28 Thread Joel Rees


David Yee queried:


> Hi.  How can I import a text file containing all fixed-length records into
> MySQL?  Is there a way to do it with LOAD INFILE?  The text file was
> originally designed for import into Oracle.  Thanks.

http://www.mysql.com/doc/ 'import' 

http://www.mysql.com/doc/m/y/mysqlimport.html
4.8.7 mysqlimport, Importing Data from Text Files

Mysqlimport provides a command-line interface to the LOAD DATA INFILE SQL
statement. Most options to mysqlimport correspond directly to the same
options to LOAD DATA INFILE. See section 6.4.9 LOAD DATA INFILE Syntax.



http://www.mysql.com/doc/L/O/LOAD_DATA.html
6.4.9 LOAD DATA INFILE Syntax



HTH

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka



sql, query



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: auto_increment question

2002-03-28 Thread Joel Rees

Jeff Habermann asked:

> well.  Now, because of this deletion, there are sequence gaps in the "idx"
> field.  We would like to be able to use those numbers again for incoming
> clients...Is this possible?

It looks like you can, but IMHO, it would probably be more effective to add
a DELETED flag to your records, and just have your routine that adds new
records look for records with the DELETED flag set before it tries an
insert. The WHERE clauses in your normal queries would include 'DELETED = 0'
to filter out the deleted records.

Another possibility is to make your index (in this case, client ID) so huge
that you don't care if there are gaps. An unsigned INT (instead of
MEDIUMINT) will give you so many keys that it will take over thirteen years
at an average ten new clients per second to overflow.

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka




sql, query




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

PHP4, Mysql , Apache and RedHat Linux 7.x, URGENT! HELP!!

2002-03-28 Thread Admin/Admin


Hi all,
I have installed a clean RedHatLinux 7.1, and 7.2, and have selected
the PHP and mysqlshare components to install. I also have configured the
httpd.conf to use the php modules with Override ALL option. But when I want
to run any php, including the one that need to access the mysql server,
only the source code are shown, but not exdecute the PHP. Rather I update
the apache and PHP or not, still the same result. How to configure the
httpd.conf or php.ini or anything else to make the PHP run? Or anyone who
have experience on running PHP in RedHat Linux 7.x??


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re[2]: client dependent timezone

2002-03-28 Thread Gerald R. Jensen


Depends on the language you are writing in, and the level of your
programming skills.

If your users/guests have database entries, it would be a rather trivial
task to set their timezone in a column in the database, then write your app
to calculate their local time based on the offset from GMT. You would either
have to rely on the user to use a form or image map of some sort to select a
timezone (ala Red Hat's installer), or devise a way to ready the clock on
their local machine.

IMHO, this is a programming problem as opposed to a MySQL database issue.


- Original Message -
From: "Maxim Vysotskiy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 7:14 PM
Subject: Re[2]: client dependent timezone


Hello Gerald,

But how people build web-applications then ? How can you use
web-hosting in GMT+1 if web-application will be in use in GMT+5 for
example?
Have anybody an experience of resolving this problem (without
embedding this functionality to backend app, because backend app is
allready contains ~2 lines of code, and somewhere near to 1000
queries).

If someone knows how to play this around - please help!

Friday, March 29, 2002, 3:02:57 AM, you wrote:

GRJ> Per client? Per database? The only timezone setting in the MySQL manual
is
GRJ> for the server (tz), and permits you to set it to your local timezone
so it
GRJ> does not return values in GMT.

GRJ> If you want clients to have different timezones, perhaps you should
write
GRJ> that capabilty into your front-end application.

GRJ> Gerald Jensen

GRJ> - Original Message -
GRJ> From: "Maxim Vysotskiy" <[EMAIL PROTECTED]>
GRJ> To: <[EMAIL PROTECTED]>
GRJ> Sent: Thursday, March 28, 2002 6:46 PM
GRJ> Subject: client dependent timezone


GRJ> Hello mysql,

GRJ> So nobody here (even at MySQL AB) knows how to set a timezone for a
GRJ> MySQL client ? Not for whole server but per client? (or maybe for
GRJ> database???)
GRJ> I already posted this question here few days ago - and didn't get any
GRJ> reply.
GRJ> Please! Somebody help!

GRJ> --
GRJ> Best regards,
GRJ>  Maxim  mailto:[EMAIL PROTECTED]


--
Best regards,
 Maximmailto:[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

database design

2002-03-28 Thread @Basebeans.com

Subject: database design
From: "deco" <[EMAIL PROTECTED]>
 ===
I'm having a problem getting this to fit...

I have a file with a bunch of data stored... This data represents messages,
one after the other, with message header followed by message data.

I'm porting this to a mysql database. The thing is the message data is
defined in an external file, which defines foi each message type a bunch of
fields that can be double, long, short, ushort, etc...
I can parse this file easily, and i'm storing this data in java with no
difficulty.

The thing is: My DB would be something like:
A table holding data types (not programming types, but "data" types), which
holds information about every type that can appear in a file...
Another one where values read from the file are stored, with a foreign key
to the corresponding "data" type.

Thing is: if the value for this "data" types can be a double, or a long, or
a char, or a short, if my table is like (data_type, value) what field type
would i give to value? Cause it can be a lot of things. I can put the
biggest one, but then i would be using a lot more space to hold the db than
i would need.

I was hoping for some possibility of a dynamic size field, that could answer
to my needs... Maybe i'll need to set it as a binary object or something.
Any help?

Thanks in advance
Ricardo Rocha

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AJP News 28-03-2002 dla mysql

2002-03-28 Thread AJP

*** WYSYŁKA JEDNORAZOWA - PRZEPRASZAMY JEŻELI NIE TRAFILIŚMY W PAŃSTWA ZAINTERESOWANIA
***

Wraz z najlepszymi życzeniami świątecznymi przekazujemy za pośrednictwem Państwa konta
e-mail ([EMAIL PROTECTED]) krótki przegląd atrakcji z naszej oferty:

1. Dla Twojego DOMU I RODZINY proponujemy projektor multimedialny (do komputera, TV,
video, kamery, DVD) SHARP PG-M15S w cenie 10'990 + odtwarzacz DVD GRATIS !!!

2. Jeżeli prowadzisz MAŁĄ FIRMĘ LUB BIURO pomożemy zadbać o niski koszt Twoich kopii i
wydruków proponując kopiarko-drukarkę cyfrową SHARP AR-121 (format A4, prędkość 12
kopii/min.) która:
- jako drukarka laserowa GDI jest o 60% tańsza w eksploatacji od najpopularniejszych
drukarek laserowych dostępnych na rynku
- jako kopiarka daje gwarancję niskich kosztów eksploatacji (w odróżnieniu do kopiarek
wykorzystujących kardridż)
- pomoże Tobie uzyskać kopię/wydruk znakomitej, cyfrowej jakości (600 DPI) w trybie
FOTO
Interesująca jest niespotykana dotychczas cena kopiarki cyfrowej SHARP AR-121 z
modułem drukarki laserowej: 2'890 zł !!! (w wersji kopiarki cyfowej bez druku
komputerowego: 2'490 zł).

3. Dla posiadających WIĘKSZE POTRZEBY mamy w ofercie promocyjnej cyfrową
kopiarko-drukarkę sieciową SHARP AR-235 (format A3, prędkość 23 kopie/min., pamięć
16MB, duplex, sorter elektroniczny, karta sieciowa, moduł druku PCL6, dwustronny
podajnik oryginałów). Cena tak bogato wyposażonego centrum druku/kopiowania Twojej
Firmy zamyka się w atrakcyjnej kwocie 18'990 zł, a zakup premiowany jest 100Hz
TELEWIZOREM 28" marki SHARP !!!
* do wszystkich podanych cen należy doliczyć podatek VAT 22%

Proponujemy Państwu również atrakcyjne formy finansowania oraz użytkowania urządzeń
kopiujących - leasing lub dzierżawa płatna za kopie.

Zapraszamy do zapoznania się z pełną ofertą naszej firmy:
www.ajp-supplies.pl/oferta.html oraz pozostałymi promocjami:
www.ajp-supplies.pl/promocje.html dostępnymi w sieci naszych oddziałów
www.ajp-supplies.pl/oddzialy.html

Państwa adres e-mail został pozyskany z internetowej bazy adresów e-mail. Mamy
nadzieję, że przesłane informacje znajdują się w obszarze Państwa zainteresowań -
jeżeli nie serdecznie przepraszamy.
Wiadomość nadano na adres e-mail publicznie dostępny w Internecie zgodnie z art. 25,
ust. 2, pkt 2 Ustawy o ochronie danych osobowych (Dz.U. nr 133, poz. 883 z dnia 29
sierpnia 1997 r. z późniejszymi zmianami).

MateriałyEksploatacyjneAJP Sp. z o.o.
AUTORYZOWANY DYSTRYBUTOR SHARP
WARSZAWA * POZNAŃ * KRAKÓW * GDYNIA
tel./fax (061) 66-32-797; www.ajp-supplies.pl

-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

1 2 >

1 - 100 of 111 matches

Mail list logo