Re: Can anyone help with this please?
Robb Exact error messages would be good at this point and it may be possible that their version of MySQL may not fully support the command you are trying to perform although with an UPDATE TABLE I would hope this unlikely. I think you probably need to provide:- SQL statement you are trying to execute that you think is causing the problem URL to the script trying to do the job Exact error that you are getting My first guess is something about the export of the Access DB is screwing up or set to read only or somehow the grant permissions are screwing up, but that really is just crystal ball gazing without some more info. If you have any possibility at all of using personal web server of better still NT/2000 to test on your own box then I think that would be ideal, but lets see what we can do with some more detail. Andy - Original Message - From: "Robb Meade" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 6:23 PM Subject: Can anyone help with this please? Hi there... Very new to Databases I have been learning ASP over the last few months and have no come to start using databases My web host is WebFusion, who use a MySQL system for their database, where as I at home use MS Access2000... I've got it all set up so that I can export from home to the server and it updates the database, and also I've got a test page that allows you to enter some info and it updates the database from the web - so that side of things is kinda working... I've added a table this evening, as I wanted to set up a special one for people who register on my site, I've come across a couple of problems, and I'm not sure what to do... 1) Once I've exported the table, I dont seem to be able to change the structure of it, ie add more fields, or remove some, or what ever, I just get an error if I try... 2) Fields set to 'autonumber' and 'yes/no - true/false etc' are changed to 'number'... 3) I dont seem to be able to remove a table from the databaseso now I'm getting loads as I'm testing stuff, and i want to remove them... If anyone can help me at all I'd be very greatful, I appreciate this is probably not quite the usual sort of question you get here... Oh, and as I'm kinda new to this, if you could explain things kinda 'newbie' clearly, that would be great :) Thanks in advance for any help Respectfully Robb Meade - 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
Re: Limiting to specific field value of type float
Alec Exact matches on float values are notoriously unreliable - the problem with the math is that it can often turn out the value at something like :- 123.539 which won't produce an equality match. For this you would probably better use a DECIMAL field. Andy - Original Message - From: "Alec Solway" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 6:51 PM Subject: Limiting to specific field value of type float Hi, I'm having some trouble with the following: I have a sample table that has one record where price == 123.54, however select * from gpl where price=123.54 returns an empty set. If I set price to an integer value that's also in the table, it works. e.g. select * from gpl where price=500 returns the proper results. price is a column of type float. TIA. Alec Solway - 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
Re: Match Records
SELECT with two (or one) of the three fields - probably with loads of OR's after the intial search returns 0 rows. Messy maybe but I don't see any other way. You can't use a SELECT like you are currently using with fields of the same name in different tables - I'm surprised you are not throwing an error at this point unless you are using a web interface that is not error checking. Andy - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 10:04 AM Subject: Match Records I`m trying to find the best method to match records between two tables in a MySQL database. But it must match atleast once, so here is a scenario for you to think about. Member - Job, Salary, Location Jobs - Job, Salary, Location All values will be enum sets in both tables as follows Job = enum 'developer','designer','none' Salary = enum '10K','15K','none' Location = enum 'usa','uk','none' Ok so the user has come to the site and I have his Job Salary and Location stored, he clicks a link which then performs the search. His values are as follows.. Job = developer, Salary = 10K, Location = uk I want to search the Jobs table and match it with the above, this part I can do. The next stage is if it doesn`t find any matches it then finds the nearest. So if the only record I have in the Jobs table is as follows Job = developer, Salary = none, Location = uk How do I go about making it pick up the nearest. At the moment I am using SELECT * FROM Jobs where Job='$Job' and Salary='$Salary' and Location='$Location' So obviously it won`t match them, anyone wake me up from my slumber and help me out with this? Cheers Ade - 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
Re: running mysql not as a server
Broadly speaking, I would agree with Cal becasue MySQL is, by its very nature, a server application.. However, you can easily emulate it being an application by adding net start(s) and net stop(s) to the beginning and end of your application - you may have timing issues, however, with the start and stops and your application - you will need to ensure that everything is in place before you start your app main code and that everything closes off properly before your app releases all resources. I think the first will just be a timing or return function problem and the second a flush buffer and ensuring all updates have taken place. O'course I aint heard of anyone trying this yet! Andy The rest of life is left as an exercise for the reader :-) - Original Message - From: "Cal Evans" [EMAIL PROTECTED] To: "Michael Gilman" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 7:38 AM Subject: RE: running mysql not as a server Michael, IMHO, if you are looking for a desktop database, something built around a .dbf file would be a more suitable choice. (My personal fav is FoxPro even though it's a M$ product) MySQL, while it probably can be made to do this, is not designed to do this. Cal http://www.calevans.com -Original Message- From: Michael Gilman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:08 AM To: [EMAIL PROTECTED] Subject: running mysql not as a server How can I run mySQL in a Windows app in a non-server mode. That is how can I get the app to start mySQL when the app starts and shut it down when the app is exited. Are there any issue that might cause a problem? Thanks for your help. Best Regards, Mike Michael Gilman, PhD Data Mining Technologies Inc. (516) 470-9011 ext 100 [EMAIL PROTECTED] The information transmitted in this email is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and permanently delete the email from your computer. - 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
Re: windows 2000
Micke Can't really speak for Professional but I have it running fine on Server and Advanced Server. If my memory is right then 1067 is normally that the service cannot respond to the control function effectively. Together with the fact that you cannot remove the service after uninstall, this suggests to me that the service is not being installed or initialised correctly on install of MySQL - not sure why, unless it is a Professional problem. Try using mysql command line to see if it will connect - a problem with BIND on NT used to give this 1067 error BUT the service was actually started and running OK despite it. Go figure! :-) You might try removing the following registry key to remove the service (then reboot, natch!):- HKLM\SYSTEM\CurrentControlSet\Services\MySQL See how that goes. Andy - Original Message - From: "Micke Bjork Coolbase" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 8:53 AM Subject: windows 2000 Hello, Im having a problem running MySQL on a Windows 2000 Professional plattform. There is no problem installing or uninstalling mysql, but you cant start MySQL or the MySQL service. In the service list a MySQl entry exist, but when Im tying to start it I get the erro 1067. It is imppossible ti remove the service also. It cant be removed event thoug I have uninstalled MySQL. How can I get MySQL running on Windows 2000? / Micke - 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: Table reorg question
John ALTER TABLE ADD [column] col_declaration is what you are after I think - no need to go making another table For example:- ALTER TABLE example_table ADD example_column INT UNSIGNED NOT NULL AUTO_INCREMENT With the greatest regards to Paul DuBois whose marvellous book MySQL this is unashemedly ripped off from and to whom I owe everything I know about this app! :-) Andy - Original Message - From: "John Vaughan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 9:11 PM Subject: Table reorg question Hello I am using MYSQL Server version 3.22.27 on a Redhat Linux System. The question I have is I have created a database with three tables in it. One of the tables has been populated by data. I later decided I wanted to add a new column to the already populated table. Can anyone explain or point me to relevant information about how I can create another table with the new column and then import the data from the old table. I used mysqldump to export the data but when I try to use mysqlimport to import the dump file to the newly created table structure I get the following error: Can't get stat of '/path/filename' (Errcode: 2), when using table: tablename Anyone have any suggestions about reorganizing a table?? John Vaughan Micro Analysis Design, Inc. 4900 Pearl East Circle, Suite 201 E Boulder, CO 80301 303 442-6947 303 442-8274 fax mailto:[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