Re: MySql runs on windows ME

2001-09-09 Thread WCBaker
I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on BOTH systems (it is running just fine on Win ME right now). -w - Original Message - From: Doug V [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 09, 2001 2:24 PM Subject: windows ME Will mysql

Re: MySql runs on windows ME

2001-09-09 Thread WCBaker
I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on BOTH systems (it is running just fine on Win ME right now). -w - Original Message - From: Doug V [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 09, 2001 2:24 PM Subject: windows ME Will mysql

Re: Data Entry Forms for MySql

2001-06-25 Thread WCBaker
Hello I often use an html editor to create forms, use PHP4 as a cgi and enter the data directly into MySql. This does not necessitate Microsoft, and has worked very well for me. -warren - Original Message - From: Stephen Reynolds [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday,

Re: MySQL too slow....

2001-06-07 Thread WCBaker
Hello! A lot of people use PHP4 or PERL or C++ and connect *directly using the script. PHP4 has MySql functions built right in for convenience. In PHP for example, just do this: MYSQL_CONNECT(localhost,yourID,yourPassword); mysql_select_db(yourDB); $maxi=mysql_query(select fieldname1,

Re: events that i can trigger on intervals.

2001-06-05 Thread WCBaker
Hi! Could this work, I wonder? Have a timestamp field that gets set whenever a person books a room. Then when people look at a room, if the current date is more than a certain amount of time after the timestamp showing, it is EXPIRED. This would be easy to code in PHP. Cheers! -Warren

Re: Configuring PHP for MySQL

2001-05-17 Thread WCBaker
Wrong. As the MySQL Development Team suggested, this is a quesiton for PHP people. THe message Header files not found at ..has nothing to do with MySQL. This is a header that is being generated (HTML HEADERS). Therefore, at the TOP of a (PHP) script file you are saying something like

storage and retrieval of blobs

2001-05-09 Thread WCBaker
Hi! I'm new too, but here are some things I've picked up from others on the List kind enough to advise: Regarding blobs, putting even large amounts of material into them is the same as using any other data type. Some considerations: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:10632

Re: mysql hosting?

2001-04-26 Thread WCBaker
Gary Huntress, who sometimes posts on this List, runs such a free system. It is found in his signature line, as follows: SNIP == FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org SNIP == - Original Message - From:

re: JAPANESE QUESTION: My Inept Translation Attempt

2001-04-19 Thread WCBaker
I'll try to translate this as best I can. The sender can likely understand the response in English, so fire away. If you send them English he'll probably try (and probably can use) English. If anyone on the list can do a better job of translating this, please feel free to correct me! Keep

mySql on PhatLinux

2001-04-19 Thread WCBaker
Hi All! Has anyone got mySql running on PhatLinux? As I understand it, Phat is designed to run on a Windows partition - intel machine. If so, which binaries are used? (or which src file)I was thinking of trying the following distribution: Linux (Intel libc6 systems)

building a timer for controlled display of records

2001-03-23 Thread WCBaker
Hi! Has anyone a nice example of a timer that will run on a Win OS? It is to be a timed display in which a record is retrieved from a MySql database table and after 15 seconds the next record comes up for display. Since the application has to be responsive to user input during the "show" of

Is storing a whack of text in a binary format ok?

2001-03-20 Thread WCBaker
Hi, I can store and retrieve binary data in the form of image or sound files. However, I wanted to store up to say, 10,000 bytes of textual data. Since varchar has a 255 byte ceiling I thought that mediumblob might be nice for this. I can store the stuff as mediumblob without difficulty.

text stored as binary question posted earlier

2001-03-20 Thread WCBaker
Hi all! Regarding my earler question about storing text as binary - I found no problem storing the text as mediumtext or longtext, and then dragging it out with a normal "mysql_query ".This solves my problem. However, if anyone has other ideas I'd love to hear them! Thanks very much!

having problems getting a distinct listing

2001-03-05 Thread WCBaker
Hi! I have a tests database that has questions (one table is "questions" and a field in this table is "uid" and another field is "question") there is also a Testerator table in my tests database, which organizes questions by section and keeps track of test number (as field "Quid") SO I would

IGNORE previous temporary table problem posting

2001-03-05 Thread WCBaker
Hi All! I just posted a note about having problems creating temporary tables. However, I JUST realized (and empirically verified) that my problem of not being able to create temporary tables is that I didn't use an ID with the CREATE permission enabled. I am a bonehead. Thanks again! Cheers!

RDBMS question on coding expanding series-like fields

2001-02-27 Thread WCBaker
Hi! I have a Test Questions database. Right now I have a hard-coded limit of 200 questions in it; I actually made a table with field names like Quest1, Quest2. . . Quest200. However, I know that I am not using the power of MySql in setting it up this way. This is more an example of my own

modification of my last question

2001-02-27 Thread WCBaker
Hi! I just realised that the question I posed moments ago was not explained fully and therefore sounds even more silly than it perhaps is. My need is to have a number of fields that can be expanded and fit the form of field[i] where "i" can be expanded as desired. So I would like to know how

generic question re. image blobs in dbs

2001-02-23 Thread WCBaker
Hi! There is a consensus that blobs containing image files like .jpgs, .gifs, etc. might better be stored just as links in the database, with the actual files in a directory pointed to by the database links. Forgive my ignorance, but can someone explain a few of the more obvious reasons why