Re: Do any of your applications work?
At 14:31 2002-04-06, Hugh O'Loughlin wrote: Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Microsoftish? Gosh, us Microsoft users have been having problems because the software doesn't follow Windows standards... Developing cross-platform software isn't all that simple. Instead of complaining and ranting, why can't you simply ask for help? Your tone doesn't exactly invite friendly responses from experienced users. filter fodder: sql,query -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: ER Program
At 15:12 2002-03-21, Bernhard Doebler wrote: - Original Message - From: [EMAIL PROTECTED] To: Bernhard Doebler [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 1:58 PM Subject: Re: Re: ER Program Look out for the Czech Program Case Studio. Looks interesting - but it's hardly freeware... Regards Bernhard - Original Message -=20 From: Ricardo Striquer Soares [EMAIL PROTECTED] To: Listas (En) - MySQL [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 1:21 PM Subject: ER Program i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. =20 - 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 -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Sorting Data
At 16:32 2002-03-19, Victoria Reznichenko wrote: MySQL doesn't look at bits when sorting data and MySQL doesn't support Tamila scripting. Then what does MySQL look at? Are you aware Tamil is a human language? How would MySQL support Tamil - is there a character set that supports it for MySQL? -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: FW: IS THIS BETTER?
I may have misunderstood, but I though the whole idea of having a spam filter rather than a subscription system was to make posting for newbies easier, not harder. At 20:39 2002-03-17, Dan Vande More wrote: Is there a way to spam control caps? filter fodder: sql,query -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: SQL coding: Finding singular when search with plural.
At 16:10 2002-03-06, BadgerBay wrote: Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for my SQL search: MY CURRENT SEARCH SELECT ID, Authors, Year, Title FROM libraryTable WHERE (Authors LIKE '% + varAuthor + %') OR (Keywords LIKE '% + varKeyword + %') OR (Title LIKE '% + varTitle + %'); ORDER BY Year; ADDITIONAL FUNCTIONALITY REQUIRED 1) The search should be able to locate singular words when the plural (s or es) is entered. Example: If singers is entered in the search box, than singer would be found. 1. language-dependent (may not be an issue if all you're using is English - but some languages are more regular than English so it may be even *less* of an issue if what you're using is not English!) 2. gammar-dependent: - not every word that ends in an 's' is a plural (like 'ends' in thi ssentence, or 'grass') - irregular (or more exactly ancient) plurals: child-children to correctly detect plurals you need at least a basic knowledge of grammar - and a dictionary. -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Mysql Date Functions - input
Keith, At 21:51 2002-02-28, you wrote: That has certain advantages, but it's a pain for the user if it's in a application where you have to enter a lot of dates or fill out a form repeatedly. For that sort of data entry, typing digits is far preferable to selecting from a dropdown list. Agreed - but in that case, for an international application, you'd have to let the user select their preferred date format first! Do you know what 2/3/2002 is? Tomorrow or nearly a month ago? I have absolutely no idea... :) The main thing I tried to get across is that handling date input is nearly always dependent on the type of application and the types of dates needed. There is no general solution for dates. (And dates get *really* interesting when you're dealing with partially unknown data (just a year, or only year and month) or historical data (is this date in 1012 a valid date?)...) [Filter fodder: SQL, query] -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Mysql Date Functions - input
At 15:02 2002-02-28, you wrote: Hi all, I asked this question on the PHP-DB list but everyone was asleep (no response). = = = = = = = I have a site where dates are being displayed and also entered by users. I don't want to offend them by asking them to use the -mm-dd format or to split the date into its constituent parts. I would feel greatly appreciated if you'd allow me to enter in -mm-dd format! I've been using ISO format since 1971... :) I am displaying by using the MySQL Date_Format syntax and that's fine. I get dd/mm/ and I want to be able to have the user enter 'dd/mm'' into a form and have it put into MySQL in the -mm-dd format. Now I have written a function in php to do this but I might be missing an easier, more elegant/efficient way of doing this. Any suggestions? The easiest way to work around all the date formats of the world for data input on a web page is to simply split the input into three parts: year, month and day. Month and day can then be dropdown lists (built-in -partial- validation!) and depending on context, the year might be a dropdown list as well (good for expiration date for a CC, not so good for a birth date). Also, depending on context, you might be able to initialize the fields to the most likely or likely nearest value and save the user some scrolling. For added user-friendlyness, you can add validation using JavaScript for day within month (dependent on year, of course) to save an extra trip to the server - but you need server-side validation always since not everyone uses (or can use!) JavaScript. For special dates like birthdates other simple validations might apply. -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Invitation to join the bilgisayar_bolumu group
It's Turkish. (It's also half-converted from ISO-8859-9 which makes the Turkish somewhat hard to read ;-) ) It appears to be a computer group, so it's conceivably *possible* MySQL could be discussed there - but it looks more like ordinary spam.. At 12:49 2002-02-26, you wrote: Um, it sounds very inviting... is that Euskera or Hungarian, or what? -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Paul DuBois - Thank You
Paul, At 23:09 2002-02-25, you wrote: One of the chapters (the C API chapter) is online at the publisher's site, and there are some other pages available at Amazon. All of these are PDF format. There are pointers to this material at the book's companion site: http://www.mysql.com/mysql-book/ Actually, that gives a 404. Did you mean http://www.kitebird.com/mysql-book/ ? ;-) The pages available at Amazon are, of course, useless - since they are only *pictures* of pages. You need extremely good eyes to read the extremely blurry, very small print. Though I've seen worse than the pictures for your book! I do wish Amazon would stop with their stupid look inside - it's totally inaccessible and a complete waste of bandwidth. They used to have a decent table of contents for most (CS) books, which is useful to get an idea of a book's value, but these have become rare (and non-existent for books which you can look inside) Otherwise, no it's not available electronically. -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: can I use different charsets with one server?
At 16:56 2002-02-12, Egor Egorov wrote: It's possible and it is covered in the manual as well. Look at: http://www.mysql.com/doc/A/d/Adding_character_set.html That only explains how to install extra character sets - not how to use different character sets with different databases on the same server, which the original question was about. I'd like to know the answer as well! Also: is it possible to install character sets *without* recompiling? What if my hosting provider hasn't installed a character set I need? G: sql database table mysql -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Old Messages
Yes I'm getting them, with an extra footer, and (sometimes) different encoding. I've just been plowing though this mailbox to delete duplicates... At 06:29 2002-02-12, you wrote: Greetings: Anyone else getting lists messages from several days, or longer ago? Phrrrp!: sql database table mysql Van -- -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: for You
At 01:13 2002-01-30, Engr Duke Paul [EMAIL PROTECTED] wrote: NIGERIAN NATIONAL PETROLEUM CORPORATION (DEPARTMENT OF PETROLEUM RESOURCES) And he subscribed to this list, right? Grrr: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Urgent Business Assistance.
At 03:52 2002-01-30, Todd Williamsen wrote: If its so urgent and private then why are you spamming a mail list? I smell scam, or is that Spam? It's both. And please do not quote the *whole* spam - the loss of bandwidth (it goes to every subscriber!) from the actual spam is already bad enough. Replying to the spammer is useless, too - they do NOT subscribe. Spammers are lazy. Grrr: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Attention ! Ce Email est une bombe !!!
At 01:11 2002-01-28, Alex wrote: Enfin, disons surtout quen visitant le site dont je vais vous donner le lien, vous allez avoir accès à des photos et à des vidéos qui sont de véritables bombes . A ne pas mettre entre toutes les mains [snip] Aurez-vous le courage de cliquer ici ? http://www.sexportail.com/ 100% des gagnants ont essayé... Alex. Un ami qui vous veut vraiment du bien ! Sure, it had to happen, of course Now we get even sex spam - I'm sure this guy wasn't required to SUBSCRIBE? If not, why not? (And no, I really don't believe this guy wishes us well! And spammers aren't friends.) -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: seeking partner
Of course, the SAME spam we saw before appears again. No surprise. Does anyone still believe this will go away by itself? It won't - it will only get worse - unless the list administrators actually *do* something about it! The filters DO NOT WORK. At 17:05 2002-01-28, you wrote: TF Information Exchange (TF) Physical Address : Room 210, Building 2, Chegongzhuang Street No. 6, Xicheng District, Beijing, China Post Code: 100044 Tel: +86-10-6800-3112 Fax: +86-10-6800-1452 Web site: http://www.tangfeng.org E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Grrr: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: SOME ITEMS THAT YOU MAY BE INTERESTED IN OR BE ABLE TO ADVISE ME ON
And this nitwit also just spammed the SpamCop newsgroup! Must be out on a suicide mission... Once again: PLEASE make this list subscription-only! We really DON'T need spam here! At 15:53 2002-01-24, you wrote: These are the items that iam interested in selling.. Could you help me with some details on the goods, history, origin etc. are these worth anything and if so who would i contact with regards to selling them? and the best way to sell them ie auction etc APOLOGISE IF YOU HAVE ALREADY RECEIVED THIS E-MAIL Yes I have - in the SpamCop newsgroup! news:news.spamcop.net/spamcop Apologies are NOT accepted, though! G: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: seeking partner
Good grief! Yet another SPAM on the same day. When will it filter through the apparently thick head that the so-called filtering DOES NOT WORK? Stop this sillyness already, please. SUBSCRIPTION only for this list is the only sensible solution! At 22:41 2002-01-25, you wrote: TF Information Exchange (TF) Physical Address : Room 210, Building 2, Chegongzhuang Street No. 6, Xicheng District, Beijing, China Post Code: 100044 Tel: +86-10-6800-3112 Fax: +86-10-6800-1452 Web site: http://www.tangfeng.org E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Dear Sirs, I'm not a sir either! As a direct result of the excellent reputation you enjoy here, we would like to build a cooperative relationship with you.TF is a senior investigative corporation in China. We are seeking international cooperation with investigative companies abroad. [snip] G: database,sql,query,table (just to get this through the non-functional filters...) -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Tergat MySQL Studio
And can you turn those off and get normal widgets that respect user system settings? XP style for me is a reason to not even look! At 11:07 2002-01-17, you wrote: Just downloaded and at least it looks pretty creamy with the latest XP style widgets... G: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: my.ini vs. my.cnf on Winodws?
Jeremy, I have version 3.23.41 installed on Win2K. The installation program may have been corrected since (I hope so!), but when I installed it it did the following: - It created my_cnf in C:\ even though I told the installation program I wanted to install on F: and the system drive is R: (*nothing* should be installed in C:\ in that situation!) - It created my-example.cnf in the program installation directory - but with incorrect paths in it (see below) - instructions in both these files mention only C:\mycnf - no reference to my.ini - It created my.ini in R:\ (the *root* of the system drive, not my %WinDir% directory); I didn't find this until later, because that's not where a configuration file should be: I didn't even look there. It did not have an [mysqld] section at all (I had to copy that from my_cnf/my-example.cnf), and though the default is to not use innodb, it --and my_cnf-- lacked the statement skip-innodb making it impossible to even get mysqld started. - I also found mysqld.trace in R:\ - it has no business being there either. (In fact, I also had to *tell* the installation program that it should install on F: even though that is indicated in the Registry as the program installation path. This is incorrect behavior for a Windows installation program: it should look in the Registry to present a default program installation location.) Apart from that, the files that are installed did not have content that corresponded with the actual installation. That is not necessary - such files can be simply *generated* from the installation using the actual installation paths as given by the user. For instance this instruction is not only wrong (unless you happened to install on D:\), but completely unnecessary: ~~~ # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ ~~~ The file could simply have been generated with the *actual* location for basedir. The MySqlManager.exe program (correctly) expects a file my.ini in the %WinDir% directory; I had to create that before I could use the program. Final note: The whole situation illustrates Unix-centric thinking. The problem is that the results badly confuse both beginning and experienced Windows users - especially if they have no experience with Unix. If a Windows program uses a configuration file at all (instead of the Registry) they expect to find [programname].ini in their %WinDir% directory because that's where they belong and what they should be called - not in the root of any drive. The names my.cnf and my.ini are badly chosen. my normally indicates of mine (My Documents, My Pictures...); if you see a file called my.ini you think my what?. Configuration files should be named after the program the configuration is for. So we should actually have mysql.ini (and only mysql.ini). An installation program should also make sure the application can at least be immediately started in a default configuration. At 08:56 2002-01-14, you wrote: According to what I read in the manual, I'm lead to believe that MySQL on Windows can read from either C:\my.cnf or systemdir\my.ini. Which will it read first? The manual also seems to say that you can only use one. So if you create both, which will it prefer? Here's the part I'm reading: There are two configuration files with the same function: `my.cnf' and `my.ini' file, however please note that only of one these should can used. Both files are plain text. The `my.cnf' file should be created in the root directory of drive C and the `my.ini' file on the WinDir directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive isn't the boot drive, then your only option is to use the `my.ini' file. Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin' directory contains a help file with instructions for using this tool. If I had a suitable system handy to install on, I'd just install it and try (of course). Can anyone shed some light on this? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 261,751,768 queries (266/sec. avg) - 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 -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
Re: Spam - a possible cause ?
Tony, You have the same info on these opportunities as I had, and any other subscriber, since they were all posted on (um, spammed to) this list. (If you're a *very* recent subscriber you should be able to find them in the archives or Google.) I gave literal quotes from messages sent to the list. Of course if you just deleted them you'll have to wait (just a bit, surely not long) for the next irresistable Business opportunity to be announced here ;-) At 18:49 2002-01-13, Tony Buckley wrote: - Original Message - From: Marjolein Katsma [EMAIL PROTECTED] To: [EMAIL PROTECTED] [RegSoft/mysql] [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 12:44 PM Subject: RE: Spam - a possible cause ? Matthew, snip Spam is people not interested in MySQL at all posting a Business opportunity (Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center!) or Golden Investment Opportunity or Great Growth Potential stock scams. Marjolein, They sound like great opportunities. Do you have any more info? Tony -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Spam - a possible cause ?
Matthew, Posting simple questions, even different people repeatedly posting simple questions is NOT spam. It may be a problem for some people, but it is not what this discussion is about. Spam is people not interested in MySQL at all posting a Business opportunity (Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center!) or Golden Investment Opportunity or Great Growth Potential stock scams. At 01:07 2002-01-12, you wrote: I am an experienced programmed and have worked on Unix and with Oracle and Informix for many years. I personally am struggling to get my head around Mysql (getting there now though) I think part of the reason I am posting simple questions is. -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Heads up re Spam.
At 07:16 2002-01-11, Michael T. Babcock wrote: On Thu, Jan 10, 2002 at 08:55:35PM +0100, Marjolein Katsma wrote: That proves it's a REAL problem for subscribers to this list. No, it proves that some subscribers (like yourself) have real problems. Your E-mails will all be blacklisted at my border if I see you whining about this on-list again; So? whine to the administrators _in private_. This is a matter that concerns all members of this list. If I am in a minority, fine. But even a minority should have a voice. The fact that people are actually *leaving* this list because of the continuing spam should give the administrators (and you ) a clue. Wouldn't they rather lose the spammers than valuable list members? If you raise the noise ratio from .5% to 2.5% by whining so much, who is really the problem? The list management - because they do not limit posting to subscribers only. Your logic skills are extremely lacking. The list administration did not require you to post your whining to the list. I don't want to hear what you have to say about spam; I ignore the spam as, obviously, do the hundreds of other subscribers not whining on the list. My logic skills are fine. The list administrators are forcing me to pay for downloading the spam they let through. They should not. I don't mind paying for member's posts, I do mind paying for spam. As long as spam is allowed here, this will keep coming up. Ignoring spam is not a solution - we *all* pay for it because of the huge costs involved with the bandwidth it takes up. PS, I post to a lot of lists I'm not a member of. So do I. The ones that _require_ membership for me to post lose my traffic as well as my use of their software. The ones that do not require membership to post *all* suffer from spam. Hence I much prefer posting by members only. database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: 4208 Golden Investment Opportunity 185261
Carl, You'll be missed but I can't blame you. I'm tired enough of getting this kind of pam in my personal mailboxes, I don't need an additional load from this list. Worst is that I've changed to using a SneakEmail address to combat spam from spambots harvesting addresses from mail lists - but now I cannot even report these spams because SneakEmail creates its own headers. The list is too valuable for me to leave - but it really SHOULD be subscription only. This spamming is getting out of hand! At 09:50 2002-01-10, you wrote: [EMAIL PROTECTED] writes: OTC News Alerts' Last 3 Picks have gained 358%! Here is our next Hot Pick! That's it. I'm out of here too. //C - wonders what the list owner gets for letting the spam in. 10%? -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. mysql - 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 -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: Heads up re Spam.
At 19:46 2002-01-10, Steve Rapaport wrote: Okay guys, let's not get our panties in a twist. I've just scanned through the last 1500 postings and come up with about 7 spams. On the other hand there have been at least 4 times that amount of messages griping about spam, which you will acknowledge is just as off-topic. That proves it's a REAL problem for subscribers to this list. If the list were limited to subscribers only, there wouldn't BE any spam, and no griping about it either. If you raise the noise ratio from .5% to 2.5% by whining so much, who is really the problem? The list management - because they do not limit posting to subscribers only. Query: can we now sweep this non-database issue under the table, and just talk about MySql? :-) NO! Because we cannot sweep spam under the table. The only way to deal with spam is to fight it. I will continue complaining about spam on this list, until it stops. We have requested numerous times to make the list subscriber only. It's not rocket science and would keep spammers away. The best way to save bandwidth is to prevent spam in the first place. -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: About spam
Reported to SpamCop.net At 15:54 2002-01-08, Carl Troein [EMAIL PROTECTED] [RegSoft/mysql] wrote: [EMAIL PROTECTED] writes: HTML I'm getting seriously sick of the amount of spam on this list. I don't know what MySQL employee is responsible for managing this list, but assuming that there is such a person, could he/she _please_ do something about the problem? When every other list owner can figure out how to restrict posting to subscribers only, how hard can it be? As far as I have seen, it's quite rare with serious posts from non-subscribers, whereas the spam and empty bug reports arrive at a rate that's on the order of mails per day. //C - annoyed -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: MySql forum or newsgroup
At 10:30 2001-12-14 -0600, Philip Molter wrote: On Fri, Dec 14, 2001 at 11:14:00AM -0500, Etienne Marcotte wrote: : Sorry but I've never seen a mailing list archive really working.. That's a fault of mailing list archive designers, not mailing list archives. [snip] I agree. Besides, and more importantly, I much prefer a mailing list. HD space is cheap, I keep everything, just subdivide into different folders. The result is that I can *always* search everything - even off-line. The biggest disadvantage of a forum is that you have to on-line to be able to do anything, and every new action is a new connect and a new wait. That ends up being more expensive than receiving all posts in your mailbox in one burst, especially when you have to pay per minute for the phone connection (as most people in the world have to do). Cost of using a newsgroup is somewhere in-between as some readers are able to download everything and then let you read and prepare responses off-line. A web front end for the mailing list would be fine - but I would never use it! [anti-filter kluge: mysql, database, grrr] Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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: Optimizing date queries
Emil, You might try to split the time stamp into separate date and time columns. That would allow you to cretae and use an index on time alone. At 14:24 2001-12-05 +0100, Emil Rasmussen wrote: WHERE myfield LIKE 'HH' However this query will probably not use your index either :) Yeah, it works, but still, it does not use my index as long as it is working with strings. But neat trick anyway. Thanks Regards Emil -- Emil Rasmussen http://noget.net - 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 Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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: Netscape not rendering correctly
At 22:53 2001-11-26 -0600, sherzodR wrote: Lotta peoploe do not use /td and /tr closing tags. It works fine in IE, as it closes them automaticly whenever it sees the opening td and tr. But Netscape turns up its nose. So it should do w/ the HTML syntax, I believe. You could post a link to that page, if you wish, or have HTML validator to validate it for you (available at w3c.org) In HTML 4.01, closing tags for td and tr are optional; the W3C validator won't give you an error if you leave them out - in fact many of the table examples in the standard itself leave out the optional closing tags. On the other hand, it *is* true that Netscape 4.x has problems when these optional closing tags are not present (that's a bug). And since as of XHTML 1.0 all tags must be closed anyway, it would be a good strategy to get used to closing all tags with optional closing tags all the time. Less trouble with browser bugs, more consistent code, everyone gains! -- (database,sql,query,table) GRRR!!! Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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: String Comparision
At 12:19 2001-11-25 -0600, Paul DuBois wrote: select * from users where dbname= Brain returns both brain and Brain. I read section 6.3.2.2 and select binary dbname from users where dbname=brain also returns both records. SELECT dbname FROM users WHERE BINARY dbname = brain perhaps? How would that locate records with Brain? Doesn't sound like a solution to me... -- (database,sql,query,table) GRRR!!! Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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: String Comparision
Paul, At 16:56 2001-11-25 -0600, Paul DuBois wrote: database,sql,query,table At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote: At 12:19 2001-11-25 -0600, Paul DuBois wrote: select * from users where dbname= Brain returns both brain and Brain. I read section 6.3.2.2 and select binary dbname from users where dbname=brain also returns both records. SELECT dbname FROM users WHERE BINARY dbname = brain perhaps? How would that locate records with Brain? Doesn't sound like a solution to me... It wouldn't locate such records. BINARY makes the comparison case sensitive. WHERE dbname = brain returns only brain records WHERE dbname = Brain returns only Brain records But the original report (which I quoted, and still quote) was that the latter (the intended effect) did not work as it returned also brain. Your solution is apparently no solution to this problem. So the question remains what the solution (or the cause of the problem!) is. -- (database,sql,query,table) GRRR!!! Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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: SELECT * FROM allofthetables
Deryck, Since you already got a reply that it can't be done, here's a suggestion how it *could* be done (jus a general approach - since you mention usnig ASP): - use an SQL command to gather all the table names in the database - store the names in a list or array (ASP) - use ASP to loop over the list - for each %tablename% do teh SQL command (fill in the table name): SELECT * FROM %tablename% WHERE User = 'username' I don't use ASP myself, but the same general approach could be used with ASP, PHP, CFML, or any other server-side language. Cheers, At 21:09 2001-09-08 -0500, Deryck Henson wrote: How do I select all of the tables in a database and use a whre clause like this??:: SELECT * FROM alltables(substitute with command) WHERE User = 'username' I need this for my site (Code Cafe- Free source code) so that the user can see all the code he has uploaded. It is done in ASP, but all I need is the sql query string. Thanx - Deryck H - http://www.comp-u-exchange.com - 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 Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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:Can't get MySQL running on Win2K
Heikki, Thanks for the reply. Since I don't even know what InnoDB' is, obviously I don't want it ;-) I tried adding the line 'skip-innodb' to the [mysqld] section in C:\my.cnf as you suggested but it didn't make any difference. I wonder whether that file is actually read, since I next tried *moving* the whole [mysqld] section to R:\Win2000\my.ini - this time the error does not appear when I try mysqld --standalone. However, it still hangs: in the command-line window it never returns to the command prompt. (Though I can close the command-line window and mysqld remains loaded - it actually *should* return to the prompt. Buglet?) Should my.cnf actually be on R:\ on my system since that is the root of the _system_ drive when I run Win2K (while C: definitely isn't)? Cheers, At 15:11 2001-09-06 +0300, Heikki Tuuri wrote: Marjolein, if you do not want to use transactional InnoDB tables, add skip-innodb [snip] Heikki http://www.innodb.com Configuration: multiboot system. C: is for DOS and System Commander, R: is for Win2K. \ (Most) applications go on F:, (most) data goes on P:. - I installed MySQL to F:\Development\Database\MySQL - I edited my-example.cnf and added [mysqld] basedir=F:/Development/Database/MySQL/datadir=P:/MySQL/ then Save as to C:\my.cnf (do I *really* have to store this on a drive that's \ reserved for DOS and multiboot?) The installation created databases 'mysql' and \ 'test' on F: - I copied these to the designated data location on P:. - I ran winmysqladmin.exe, created an .ini file and designated mysqld-nt.exe as the \ service, then tried to start it. The traffic light remains red. (The ini file is in \ the Windows directory: R:\WIN2000\my.ini ) - Tried MySqlManager.exe which wants to \ connect to localhost - but can't connect. - In the Services applet, mysqld-nt.exe is \ registered as a service, automatic, but not started. - After reboot, same situation: \ the service is automatic, but not started. Trying to start results in an error. - \ Removed the service with F:\Development\Database\MySQL\bin\mysqld-nt --remove - Tried \ to start mysqld in debug mode with F:\Development\Database\MySQL\bin\mysqld --debug \ --standalone this results in an error: Can't initialize InnoDB as \ 'innodb_data_file_path' is not set and mysqld hung - I had to kill it from task \ manager. - Tried to start mysqld (no debug) with \ F:\Development\Database\MySQL\bin\mysqld --standalone this results in the error - I \ had to kill it from task manager again. (Note: while mysqld hangs, \ winmysqladmin.exe's traffic light in the system tray is green, so it does detect if \ mysqld is running.)Now what?Thanks,Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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:Can't get MySQL running on Win2K
Heikki, Thanks a lot for your help! This mail list is a great resource (but I knew that already ;-)) Now that I have moved the whole [mysqld] section from C:\my.cnf to R:\Win2000\my.ini and rebooted, everything has started to work - the service now starts automatically. (If something else will appear not to work, I know where to look now.) I've since tried MySQL-Front as a GUI client and that works perfectly as well. (Background: I only tried installing MySQL locally as a workaround because I could not get MyODBC working to connect from Access2000 to MySQL on my (web) server - and I did try _everything_ I found in the manual and on this list (latest versions, patches, etc.)! Now with MySQL running locally and MySQL-Front I will be able to do it the other way round: import from Access to local MySQL (using the ODBC sriver for Access rather than MyODBC, of course), and then export to MySQL on the server, both using MYSQL. That way I can design a database and enter basic (static) data with Access, and when done, export to the server. I haven't tested all the steps yet but I did successfully import a table from Access2000 and I can successfully connect to the server on my web host.) Thanks again - problem solved within one day! At 17:25 2001-09-06 +0300, Heikki Tuuri wrote: Date: Thu, 06 Sep 2001 17:24:21 To: Marjolein Katsma [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re:Can't get MySQL running on Win2K X-Attachments: C:\MY.CNF; Hi! I think it is best to have only one my.ini or my.cnf in your system. Otherwise there will be confusion. If MySQL finds your my.* then the place is obviously ok. [snip] But when I deleted my.cnf, I got: ... C:\trybuild\client_debugmysqld --console Can't initialize InnoDB as 'innodb_data_file_path' is not set mysqld: ready for connections 010906 17:18:15 mysqld: Normal shutdown 010906 17:18:16 mysqld: Shutdown Complete C:\trybuild\client_debugmysqld --standalone Can't initialize InnoDB as 'innodb_data_file_path' is not set but I was not able to connect to the MySQL server. This suggests that your my.cnf is missing something. Look in the MySQL manual about startup options. Regards, Heikki Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html - 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: Help -- can't install mysql as service in win2k
Michael, Have a look at the thread Can't get MySQL running on Win2K (started by me) - I have it working now (thanks Heikki!) and the solution might be of use to you as well. At 08:27 2001-09-06 -0700, Michael Tam wrote: Hi all, I have uninstall mysql3.23.39 from Win2k and after I install mysql3.23.41-max ... I was unable to run it as service. When I tried to start the service I receive the following message ... Could not start the MySql service on Local Computer Error 1067: The process terminated unexpectedly. Any idea how I can fix this? Many thanks to any suggestions. Michael - 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 Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html - 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: LOAD DATA INFILE - split one field into two??
That would be a tough one - you'd first have to make sure every single record has no more than two words in that field. there's no guarantee that a field name would actually always contain only two names, or even two names at all. When I get stuffy, I spell my name as A. Marjolein Katsma - what's my first name and what my last? What if people have first and middle name? What about last names consisting of two or more words (Jan van der Aalst; how would you parse that)? There are countries where people actually can have only a single name (Indonesia); there are countries where a name always consists of three names (China), etc. The variations are endless. What you intend to do can be done only halfway reliably by going back to original documents or asking the people referred to! Cheers, At 14:36 2001-09-06 -0700, Anthony E. wrote: I have a tab delimited file from a spreadsheet that has a field Name (includes first and last name). I am importing the file into a table that has firstName and lastName as seperate fields. Is there a way to split the field from the text file Name into two different fields in the database, firstName and lastName? I would assume the last word in Name is the last name for lastName in mysql table. Thanks, = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - 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 Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - 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