BLOB

2002-03-02 Thread John Mayson
aining the image. Just for grins I read in a picture, then wrote it out and compared the byte counts. When I store, then write-out a picture, it grows by a few bytes. Ideas? Thanks, John -- John Mayson KC4VJO Linux/Programming/Esperanto Austin, Texas 78729

Perl problem

2001-12-31 Thread John Mayson
;, ''); I get this error message... Can't locate object method "connect" via package "DBI" (perhaps you forgot to load "DBI"?) at C:\Program Files\Apache Group\Apache2\cgi-bin\rdb.pl line 7. DBI.pm lives under c:\perl\lib which is in my @INC. Ideas? J

Another join question and float question

2001-12-28 Thread John Mayson
want to display them to four decimal places (e.g. 460.1 should show as 460.1000). Under Linux I was able to use the ROUND function to accomplish this. This doesn't work under mysqlfront. Is there a better way to display floating numbers to a certain precision? Thanks, John -- J

How many tables?

2001-12-24 Thread John Mayson
ncy table, it's mostly a list of numbers. I suppose this is more efficient, but difficult (for me) to work with. I'm sure once I have a GUI working, it'll be transparent. My question is at what point should I stop using these lookup tables? Thanks, John -- John Mayson KC4VJO

GUI for Windows

2001-12-24 Thread John Mayson
Eventually my databases will be on my Linux system. In the meantime, is there a Windows program that builds a quick and dirty GUI interface for my SQL databases? Thanks, John -- John Mayson KC4VJO Linux/Perl/HP-UX/ICT Austin, Texas 78729 30.4560N

Help with join

2001-12-21 Thread John Mayson
s as a ON f.uid = a.uid; I get this error... ERROR 1064 at line 3: You have an error in your SQL syntax near 'ON f.uid = a.uid' at line 3 What am I doing wrong? John -- John Mayson KC4VJO Linux/Perl/HP-UX/ICT Austin, Texas 78729 30.4560N