Re: ADO Error '800a01fb'
Hi Shih Chiang, From what I remember, MySQL 3.23 was OK with MyODBC as well. However, with 4.06 MyODBC 2.50 AND 3.51 bomb occasionally with this error message. At 05:37 PM 12/29/2002 +0800, Chien, Shih Chiang wrote: Dear ALL. I have the similar problem... mysql 3.23 + myodbc 3.51 = OK mysql 4.07 + myodbc 3.51 = Error the code list is : - strSQL = DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=root;OPTION=35; Set Cn1 = CreateObject(ADODB.Connection) Cn1.Open strSQL strSQL1 = select * from mytable where pkey = 1 Set rs2 = CreateObject(ADODB.Recordset) rs2.Open strSQL1, Cn1, 1, 3 If Not rs2.EOF Then rs2(data).Value = Now rs2.Update ' Error Line Reported. ## End If rs2.Close Cn1.Close Set rs2 = Nothing Set Cn1 = Nothing - pls see the attached file for more error msg... tks. Chiang - Original Message - From: jumpmaster [EMAIL PROTECTED] To: Michael She [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 7:39 AM Subject: RE: ADO Error '800a01fb' Michael, My guess (and this is *only a guess*) -- for some reason one of the objects is not being created; maybe the recordset object. I am not sure where you are getting that error number from (presumably in you browser) as you do not state it. i suggest that you check your webserver logs if you have access to them. They might have an extended error message which will pinpoint your problem. Also, you can try to 'trap' the error. I found this tid-bit on the M$ site... On error resume next .. .. .. Your problem code goes here .. .. .. if err.number 0 then Response.Write err.description BR err.source BR err.clear end if Here is the link where I found it: http://support.microsoft.com/default.aspx?scid=kb;en-us;299981#7 One last note...the reason I think it is your recordset object is because of your query...You use single quotes in the wrong place. Your strSQL variable should be defined as follows: strSQL = SELECT * FROM IMAGES WHERE ID = ' ID ' Or - if ID is numeric then: strSQL = SELECT * FROM IMAGES WHERE ID = ID HTH, Kurt -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 6:57 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: ADO Error '800a01fb' Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 The code for that area is: strConn = DSN=binaryio; Set objConn = Server.CreateObject(ADODB.Connection) objConn.open strConn set rs = server.createobject(adodb.recordset) strSQL = SELECT * FROM IMAGES WHERE `ID` = ID rs.open strSQL, objConn, 3,1,1 Nothing out of the ordinary... anyone know why I'm getting this error? Thanks! -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ - Before posting, please check: http://www.mysql.com/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, e-mail [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, e-mail [EMAIL PROTECTED] -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ADO Error '800a01fb'
Line 45 is the Recordset open. I've checked the connection object beforehand to ensure it is connected properly. What is odd is that the error shows up occasionally - every 10 - 15 database queries. If I reboot my server, the error goes away, but comes back after a few days. At 02:43 PM 12/29/2002 +0200, Gelu Gogancea wrote: I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 12:02 An: [EMAIL PROTECTED]; Michael She Cc: [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Hi, This is an aoutomation error and is possible to be raised because you use CreateObject instead of using object directly. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael She [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 7:57 AM Subject: ADO Error '800a01fb' Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 The code for that area is: strConn = DSN=binaryio; Set objConn = Server.CreateObject(ADODB.Connection) objConn.open strConn set rs = server.createobject(adodb.recordset) strSQL = SELECT * FROM IMAGES WHERE `ID` = ID rs.open strSQL, objConn, 3,1,1 Nothing out of the ordinary... anyone know why I'm getting this error? Thanks! -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - Before posting, please check: http://www.mysql.com/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, e-mail [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/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, e-mail [EMAIL PROTECTED] -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: An Idea
At 11:26 AM 12/29/2002 +0100, =?iso-8859-2?Q?Adam_Wi=EAckowski?= wrote: Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. Don't use the PK for numbering. Instead, in PHP, ASP, etc, just use a counter when looping through your guestbook entries and label them 1, 2, 3, etc. BTW, does MySQL have a RowNumber function? -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: AW: ADO Error '800a01fb'
The ' is actually a ` (under the Tilda). It's a used to quote column names in MySQL. As for trapping the error... I don't think it'll do much good since the err.description and err.source are already displayed by ASP, which is just simply: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 : ( At 05:53 PM 12/29/2002 +0100, Freddie Sorensen wrote: I have heard of cases where there were some problems with MDAC and that it helped to reinstall the latest version I also think you should remove the ' from the ID in your SQL query. If the ID field is not numeric it should be ...WHERE ID = ' ID ' If it is numeric it should be ...WHERE ID = ID Hth Freddie -Ursprüngliche Nachricht- Von: Michael She [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 17:39 An: Gelu Gogancea Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Line 45 is the Recordset open. I've checked the connection object beforehand to ensure it is connected properly. What is odd is that the error shows up occasionally - every 10 - 15 database queries. If I reboot my server, the error goes away, but comes back after a few days. At 02:43 PM 12/29/2002 +0200, Gelu Gogancea wrote: I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 12:02 An: [EMAIL PROTECTED]; Michael She Cc: [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Hi, This is an aoutomation error and is possible to be raised because you use CreateObject instead of using object directly. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael She [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 7:57 AM Subject: ADO Error '800a01fb' Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 The code for that area is: strConn = DSN=binaryio; Set objConn = Server.CreateObject(ADODB.Connection) objConn.open strConn set rs = server.createobject(adodb.recordset) strSQL = SELECT * FROM IMAGES WHERE `ID` = ID rs.open strSQL, objConn, 3,1,1 Nothing out of the ordinary... anyone know why I'm getting this error? Thanks! -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - Before posting, please check: http://www.mysql.com/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, e-mail [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/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, e-mail [EMAIL PROTECTED] -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ - Before posting, please check: http://www.mysql.com/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, e-mail [EMAIL PROTECTED] -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ - Before posting
Re: ADO Error '800a01fb'
Hi, Have you tried passing a string value of the date? MySQL accepts dates in -MM-DD format instead of Microsoft's standard value... maybe it'll work if you concatanate the values manually? It's a wild guess : ) At 01:24 AM 12/30/2002 +0800, Chien, Shih Chiang wrote: tks, Michael I am not sure it's mysql's problem or myODBC351's problem But, what I am sure is rs2(data).Value = Now is working fine in mysql323 + myodbc351 but, err in mysql407 + myodbc351 the err msg in msgbox: Query-based update failed because the row to update could not be found. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Anyone have MySQL/PHP running from CD?
At 11:38 AM 12/29/2002 -0600, databarn wrote: Wouldn't it make more sense for your friend to design a flash based Demo CD, then have links to the sites on the web? No. The purpose of the CD is to let people see the products w/o net access. It seems to be a bit excessive to run a HTTP Daemon on a business card CD + PHP + MySQL. If I were the employer, I wouldn't even bother installing all that stuff just to view the card. You may have missed the point; I was apparently not clear . . . all this must run _from the CD_ w/o installing to the hard drive. The idea is to let anyone who has access to a spindled CD player view the web/products by doing nothing more than putting the CD in the player and _possibly_ clicking a start file - autorun would be preferable, but some folk may have it turned off. The concept here is not to build web traffic, but to build orders grin /. I understand you want to run all this stuff OFF the CD. But the reality is - all those daemons need to be configured, installed, and executed. It seems a bit excessive for a business card CD ROM. Also, keep in mind that most business card CD ROMs are ~100MB. If you install MySQL + Apache + PHP + the sites, you're going to hit the limit really quick. With that many executables, your demo cd will become very complex very quickly. You may have more technical problems than it is worth. Others have suggested that you spider the websites and place them on the CD ROM. I think that is a very good solution. At least you're guaranteed cross platform compatiblity and it is almost sure fire solution. Another possiblity is to convert all the application/search logic into Java like Macromedia's Help files. Also... if one does not have internet access, what are the chances that they'll view your CD-ROM in the first place? If you're trying to sell websites to businesses who are NOT net savvy, a flashy CD-ROM may not do the job... Instead, pictures, charts, and graphs may do the job better. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: View image from browser
What language are you using to pull the data? ASP? PHP? VB? At 11:23 PM 12/26/2002 -0800, tan tan wrote: Hi, Is anyone know how to view image that is stored in mysql as binary format to a browser ? Thank you. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
ADO Error '800a01fb'
Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 The code for that area is: strConn = DSN=binaryio; Set objConn = Server.CreateObject(ADODB.Connection) objConn.open strConn set rs = server.createobject(adodb.recordset) strSQL = SELECT * FROM IMAGES WHERE `ID` = ID rs.open strSQL, objConn, 3,1,1 Nothing out of the ordinary... anyone know why I'm getting this error? Thanks! -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Delimited Characters (\)
Thanks for the link! I was having some trouble figuring what keywords to search under ; ) At 11:43 PM 12/22/2002 -0800, Jeremy Zawodny you wrote: On Mon, Dec 23, 2002 at 02:41:03AM -0500, Michael She wrote: Hi, Is the \ character a delimited in MySQL? I noticed in text inserts I have to double slash even if it is enclosed in single quotes. I find this behaviour a bit odd. Are there other delimited characters I should be aware of? The manual has all the answers: http://www.mysql.com/doc/en/String_syntax.html :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 8 days, processed 298,338,567 queries (425/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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: datetime field as key
Hi, you can use a DateTime field, but it is possible to get duplicate datetimes if you insert multiple queries fast enough. At 04:17 PM 12/23/2002 -0200, João Borsoi Soares wrote: I would like to use a datetime field as a key. I'm wondering if I will have any problems with key violation. I found in the document something saying that timestamp fields are precise, like unix time, but I don't want it to be changing on update. Does anyone has some experience with it? -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
MySQL + ADO + ODBC
Hi all, Does MySQL's ODBC v2.50 driver support Bookmarks? I can only get ADO bookmarks to work with a Client Side Cursor. Here is some sample code: strSQL = SELECT * FROM IMAGES WHERE `CATID` = CatID rs.CursorLocation = 3 'Client Side Cursor rs.open strSQL, objConn rs.PageSize = 1 rs.absolutepage = LocationCount -- This line dies with the error message: Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. If I do not use a Client side cursor. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
Delimited Characters (\)
Hi, Is the \ character a delimited in MySQL? I noticed in text inserts I have to double slash even if it is enclosed in single quotes. I find this behaviour a bit odd. Are there other delimited characters I should be aware of? Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: MySQL Decimal Column Types Question
At 09:18 PM 12/20/2002 -0500, Michael She wrote: The value's been clipped to the upper end of the range. Your next question should be why that value has 9 digits to the left of the decimal point. :-) How did you guess! This behaviour is why I asked the question in the first place. Why does it get clipped for a 10 digit number. Without the decimal value I believe it inserts correctly, but with the 2 decimal places it get clipped... Oops correction. A 10 digit value gets clipped at the upper range. So I guess the range is really n-1. Odd. sql, query, mysql, smallint -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: MySQL Decimal Column Types Question
How did you guess! This behaviour is why I asked the question in the first place. Why does it get clipped for a 10 digit number. Without the decimal value I believe it inserts correctly, but with the 2 decimal places it get clipped... No, it won't insert correctly, it will still get clipped. The reason for the 9 digits is that the column requires an extra byte to store the sign for negative numbers. For positive numbers, the sign is not present, so MySQL uses it to extend the upper range. That is what I thought initially, but the manual is not very clear: The decimal point and, for negative numbers, the `-' sign, are not counted in M (but space for these is reserved) The manual states that the negative sign and decimal points are not counted in M. By this wording, it should be 10 numeric digits. I guess it's bad wording... or just an incorrecct entry? -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: MySQL Decimal Column Types Question
At 10:12 PM 12/20/2002 -0600, Paul DuBois wrote: For a 10,2 decimal column, should this be a valid number: 1234567890.12? It's easy to test: mysql CREATE TABLE t (d DECIMAL(10,2)); Query OK, 0 rows affected (0.01 sec) mysql INSERT INTO t SET d = 1234567890.12; Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM t; +--+ | d| +--+ | 9.99 | +--+ 1 row in set (0.00 sec) The value's been clipped to the upper end of the range. Your next question should be why that value has 9 digits to the left of the decimal point. :-) How did you guess! This behaviour is why I asked the question in the first place. Why does it get clipped for a 10 digit number. Without the decimal value I believe it inserts correctly, but with the 2 decimal places it get clipped... -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ mysql INSERT INTO t SET d = 1234567890.12; Query OK, 1 row affected (0.01 sec) A different question would be why does MySQL not generate an error or warning on the insert when it mangled the value? The philosophy is that it's the clients responsibility not to insert bad data. I think more error checking should still be done. Often times the client doesn't know the datatype of the columns, hence it is very hard for the client to do error checking. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
MySQL Decimal Column Types Question
Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? For a 10,2 decimal column, should this be a valid number: 1234567890.12? Thanks. MySQL, SQL -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Best Windows MySQL client?
At 03:24 PM 12/20/2002 +, Jeff Snoxell wrote: What's the best MySQL client for windows? I've tried 5 or 10 shareware ones that seem ok but all seem a bit chasty (some more than others). Any recommendations? I've been using EMS HiTech's Trial version of MySQL Manager. http://www.mysqlmanager.com It seems to be the most professional of all programs I've tried. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: MySQL Decimal Column Types Question
At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote: At 17:21 -0500 12/20/02, Michael She wrote: Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? The former. For a 10,2 decimal column, should this be a valid number: 1234567890.12? It's easy to test: mysql CREATE TABLE t (d DECIMAL(10,2)); Query OK, 0 rows affected (0.01 sec) mysql INSERT INTO t SET d = 1234567890.12; Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM t; +--+ | d| +--+ | 9.99 | +--+ 1 row in set (0.00 sec) The value's been clipped to the upper end of the range. Your next question should be why that value has 9 digits to the left of the decimal point. :-) How did you guess! This behaviour is why I asked the question in the first place. Why does it get clipped for a 10 digit number. Without the decimal value I believe it inserts correctly, but with the 2 decimal places it get clipped... -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 MySQL handle 120 million records?
At 03:28 PM 12/20/2002 -0800, Jeremy Zawodny wrote: I think it will in time...thats why i stick with it. besides, confidence is often just a synonym for 'knowledge' Really? I tend to see it more like confidence builds with experience (and therefore time). You don't need to know a lot about to become confident in its operation. Many of us don't *really* understand how gravity works, but we're quite confident in it. The gravity is a great analogy. It works with databases too. People are confident in gravity because it is an observable fact of our planet. For millennia people have experienced gravity and have grown accustomed to it. The same can be said of DB2 and Oracle. People have been using it for years, hence the comfort level with these products. MySQL can be analogized to a new phenomena. People wonder what it is, what it does, and how it operates. Over time, MySQL will gain the confidence and accept of lay-people and turn into gravity of sorts. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 MySQL handle 120 million records?
I agree. MySQL is a great database, but I wouldn't call it enterprise grade. Considering that the database is used to store billing information... one has to be weary about losing all the records due to a bug or deficiency in MySQL. I was searching through some of the MySQL help documentation, and there have been more than a few examples in the comments where people have lost data due to wacky functions on databases greater than a couple of GBs... At 08:43 PM 12/17/2002 -0800, Qunfeng Dong wrote: I am not sure. Does anyone know any real examples of mysql handling huge database and still perform well? I am having problems with the performance with the MySQL Left join recently. A big table (about 2.5 million records) left join a small table (about 350K records) takes generally 2 mins to finish. I check the explain and primary key index on the small table was indeed used for the joining. My system is Redhat Linux 7.3 with 4 GB memory. I also tried replacing the default my.cnf with my-huge.cnf. It didn't help at all. Another thing, with some linux system, there is a size limit for file. MySQL seems to store each of its table as single file. You need to choose a file system without that limit. Qunfeng Dong --- B.G. Mahesh [EMAIL PROTECTED] wrote: hi We are evaluating few databases for developing an application with following specs, 1.OS not very important. Leaning towards Linux 2.Currently the database has about 5 million records but it will grow to 120 million records. 3.The tables will have billing information for a telecom company. Nothing complex. 4.Back office staff will use the data in the database to create invoices to be sent to customers. This data is not connected to the live telecom system [e.g. switches etc]. We get the data every day from the telecom company. 5.Staff may perform queries on the database to get reports like busiest hour of the day etc etc. I don't see too many concurrent users using the system, however the system needs to be stable. 6.Need to create excel, pdf files from the data in the database. This I think has nothing to do with the database, however this is a requirement. 7.Needless to say, good security is a must which will also be built into the front end application. We are considering the following databases, 1.MYSQL 2.Postgres 3.Oracle 4.MSQL If MYSQL or Postgres can do the job I prefer not to spend the money on Oracle/MSQL. However, if Oracle/MSQL are required for getting good reports and scalability, so be it. We will use Oracle/MSQL. Any pointers/advice is appreciated -- -- B.G. Mahesh mailto:[EMAIL PROTECTED] http://www.indiainfo.com/ India's first ISO certified portal - 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 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 MySQL handle 120 million records?
Being paranoid... Have you ever lost data with MySQL before? Is it reliable. I have no problems using MySQL as a lightweight database for simple chores, but I'm a bit weary about putting into a mission critical environment. At 10:19 PM 12/17/2002 -0800, Jeremy Zawodny wrote: On Wed, Dec 18, 2002 at 11:55:32AM -0500, Muruganandam wrote: Dear Jeremy, Can you end me the hardware details of your DB Engine server... The hardware is about 2 years old now. The master is a dual P3 866 with 2GB RAM and 6 36GB SCSI disks. Some of the slaves are a little faster (dual P3 1GHz). -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: mysql dreamweaver
Did you setup MySQL yet? Can you log into to the mySQL server using your command line utilities? At 10:40 PM 12/17/2002 -0800, Is98 wrote: hello, i have access to mysql db i created, using a client app even on a remote pc (adding tables, fields, values) but when i try to connect with dreamweaver i get an unknown error, or unexpected. what do i need to do to us dreamweaver on my development machine to access an mysql db on my server? i have the pages hosted on my server but when i develop i use my dev machine, -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: MySQL security flaws uncovered
It's bad for business : ) Maybe they're taking the MS route. At 12:19 AM 12/18/2002 -0500, Michael Bacarella wrote: A good question posted to another list.. forwarded message follows Several vulnerabilities have been found in the MySQL database system, a light database package commonly used in Linux environments but which runs also on Microsoft platforms, HP-Unix, Mac OS and more. http://zdnet.com.com/2100-1104-977958.html So why no mention on the MySQL.COM site? That rather bugs me. In contrast, sites for products like Apache or Bind are very clear about current/past security issues. Is MySQL.COM the wrong place? -- Michael Bacarella | Netgraft Corp | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | http://netgraft.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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 MySQL handle 120 million records?
At 08:06 AM 12/18/2002 -0800, Jeremy Zawodny wrote: I have no problems using MySQL as a lightweight database for simple chores, but I'm a bit weary about putting into a mission critical environment. Why, exactly? Mainly for 2 reasons: 1. MySQL hasn't been proven yet in the corporate environment 2. Some of the comments in the mySQL manual... people losing data doing routine stuff like table optimizations, adding keys, etc. If a database is reliable, things like that shouldn't happen. Comments like those in the MySQL manual scared me. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 MySQL handle 120 million records?
I guess you can say I'm a follower. Other DB systems have been in use for years, so their reliability has been generally proven through use. It's good to know that a lot of people have had success with MySQL, but considering MySQL is the new comer, I'm still a little tepid! At 01:22 PM 12/18/2002 -0500, Michael T. Babcock wrote: Michael She wrote: X-MDRcpt-To: [EMAIL PROTECTED] X-Return-Path: [EMAIL PROTECTED] X-MDaemon-Deliver-To: [EMAIL PROTECTED] 2. Some of the comments in the mySQL manual... people losing data doing routine stuff like table optimizations, adding keys, etc. If a database is reliable, things like that shouldn't happen. Comments like those in the MySQL manual scared me. 1) Do you believe this doesn't ever happen with other 'enterprise' level DB systems? 2) What do you think Microsoft's pages would look like if they allowed arbitrary user comments (read their newsgroups ...) 3) Those reports should be filed as bugs to be fixed, not added as comments in the manual. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Using MS Access as front end to mysql database
Yup, agreed. MySQLODBC works over TCP/IP fine. I'm currently tunneling through a Linksys router to a database I have at home. If your provider is unwilling to compromise, it maybe time to look for another host. There are plenty of MySQL and MS SQL hosts who allow TCP/IP connections. At 11:56 AM 12/14/2002 -0800, JamesD wrote: they can do it. they just dont want to. firewall rules can be established to allow connects to the mysql port from only the ip's assoc with your remote offices, etc etc the answer is you can do what you want. You just need a business partner who can service his customer properly. mysqlODBC can do what you want. where mysql is located is irrelevant, in the grand sense. you just point to an ip and a port. etc etc James Danforth -Original Message- From: Donna Flanders [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 6:59 AM To: [EMAIL PROTECTED] Subject: Using MS Access as front end to mysql database We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS Access as the front end to the database. Our reasons are - we have an existing Access database with a small number of users at different locations that need to be entering data, running reports and queries. We also have a large number of agencies that would hit the database. It was our intent to migrate the data tables to mysql and leave MS Access as the front end. When we asked our web host about this, they responded this way: Due to security concerns you would not be able to connect to our mysql server thru an external terminal directly as a mysql client. You would be able to use mysql services only thru Web sevices i.e either thru php scripts or thru phpmyadmin in Control panel--Advanced Menu--Sql Databases _ My questions are - Is this true of all web hosts or just the one we are using? Our current hosting plan is a shared hosting plan. Do we have to have a dedicated database server to do this? Knowing that we want to keep MS Access as the front end, are there other options we have not explored? - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
Actually, no that isn't how I was doing it - I was concatenating multiple inserts together like you do on SQL server. (ie Insert... Insert... Insert...) Thanks for the Insert Sytax! I'll give this a go! At 08:14 AM 12/11/2002 -0500, Anderson, Alan R wrote: From: Michael She [mailto:[EMAIL PROTECTED]] ...So are you saying that the Windows ODBC MySQL driver doesn't support multiple statements? So far as I know, *no* drivers support multiple statements. However, that's not what you want for bulk inserts. What you want is multiple value sets in one INSERT statement: INSERT INTO tablename(col1, col2) VALUES (val1a, val2a), (val1b, val2b), (val1c, val2c) That's what you're doing already, right? So I don't understand your issue. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
Same table, but it shouldn't matter right? I'm getting a SQL syntax error once I start combining my statements together. If I submit the statements separately they're OK. At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote: Are the inserts to the same table or different tables and columns? JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 14:56 To: MySQL List Subject: ADO Bulk Inserts Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a single insert statement to be inserted, but if I try t concatenate multiple inserts, I get a sytax error. I tried putting a space between each statement, return charater, semi-colon, etc, but it doesn't work. I'm doing the inserts through a ADODB.Connection. Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
Hi, That is how I currently submit my statements, but can't I go: Hi, that is how I execute my current statements. But can't I submit multiple statements like: INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1) VALUES(val1);? If I submit multiple statements I get a SQL error. At 12:55 PM 12/10/2002 -0500, Fernando Grijalba wrote: Have you try this: dbConn.Execute(INSERT INTO tblname(fld1, fld2) VALUES(val1, val2),(val1,val2),(val1,vla2);) JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 12:08 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Same table, but it shouldn't matter right? I'm getting a SQL syntax error once I start combining my statements together. If I submit the statements separately they're OK. At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote: Are the inserts to the same table or different tables and columns? JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 14:56 To: MySQL List Subject: ADO Bulk Inserts Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a single insert statement to be inserted, but if I try t concatenate multiple inserts, I get a sytax error. I tried putting a space between each statement, return charater, semi-colon, etc, but it doesn't work. I'm doing the inserts through a ADODB.Connection. Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
Apparently, aren't bulk inserts faster? I'm currently looping my insert statements, but from what I read, a single bulk insert should be faster? Can anyone confirm this? At 02:49 PM 12/10/2002 -0500, Fernando Grijalba wrote: Why do you have to do it that way? Could you do it in a loop? Do Until rst.EOF dbConn.Execute(INSERT STATMENT); Loop JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 13:55 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Hi, That is how I currently submit my statements, but can't I go: Hi, that is how I execute my current statements. But can't I submit multiple statements like: INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1) VALUES(val1);? If I submit multiple statements I get a SQL error. At 12:55 PM 12/10/2002 -0500, Fernando Grijalba wrote: Have you try this: dbConn.Execute(INSERT INTO tblname(fld1, fld2) VALUES(val1, val2),(val1,val2),(val1,vla2);) JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 12:08 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Same table, but it shouldn't matter right? I'm getting a SQL syntax error once I start combining my statements together. If I submit the statements separately they're OK. At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote: Are the inserts to the same table or different tables and columns? JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 14:56 To: MySQL List Subject: ADO Bulk Inserts Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a single insert statement to be inserted, but if I try t concatenate multiple inserts, I get a sytax error. I tried putting a space between each statement, return charater, semi-colon, etc, but it doesn't work. I'm doing the inserts through a ADODB.Connection. Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
Re: Building Web Pages
Macromedia Dreamweaver or Microsoft Frontpage would be the best choice. However, they are both expensive. Macromedia Dreamweaver MX has some database tools built into allow you to build simple data driven webpages. At 11:38 AM 12/10/2002 -0800, Grant Cooper wrote: Does anyone know of a package that computer novices can use to build simple web pages. Even if they know nothing of HTML? I'm using mysql and I figure there might be something out there all ready built. This is for a small college that teachers can use to put on there stuff. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
At 11:00 PM 12/10/2002 -0600, Paul DuBois wrote: Yes, a single bulk insert will be faster. Also, the reason your multiple statements separated by semicolons approach fails with a syntax error is that the client server protocol does not allow you to send multiple statements in the same string. Indeed, you might even get a syntax error by adding a semicolon to the end of a string containing a *single* query, because semicolons are not actually part of any SQL statement syntax. Shoot, this is what I thought. I tried it without a semi-colon as well but it didn't work. So are you saying that the Windows ODBC MySQL driver doesn't support multiple statements? Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
ADO Bulk Inserts
Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a single insert statement to be inserted, but if I try t concatenate multiple inserts, I get a sytax error. I tried putting a space between each statement, return charater, semi-colon, etc, but it doesn't work. I'm doing the inserts through a ADODB.Connection. Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Front end won't connect
Are you connecting locally or remotely? By default, MySQL creates a Localhost Root account with no password. You can try logging in with that account. If you need to log in remotely, you'll need to change the permissions on the user table (add a % to the hosts section to allow for any ip addresses to connect). At 11:46 PM 12/9/2002 -0600, DIetrich Speer wrote: Question from a Linux and MySql newbie I just installed RedHat 8.0 and MySQL. During installation there was no prompt for any database server properties (hostname, user). Now I downloaded MySQLCC and try to configure the connection to the server. I assume the server is running, because I can start and stop it through the services interface. However, whatever info I put into the Client - it will always give me an error 145 (User can't connect). -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: How to get MySQL to list current db's ?
Hi, SHOW DATABASES; At 11:35 AM 12/9/2002 -0500, Will Standley wrote: I have two sample MySQL db's running on a local Linux box w/Apache... Once I enter mysql from the Linux command line... Is there a way to ask MySQL to list the db's that are currently created? -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: porting stored procedures from sql server
If you use PHP, here is an idea: http://www.ashleyit.com/blogs/brentashley/archives/000339.html Also, someone wrote a UDF to interpret PHP in MySQL...I'm not sure if it'll work as a Stored Procedure system tho. http://www.oreillynet.com/pub/wlg/2292 At 03:03 PM 12/10/2002 +1100, Chandra Amarasingham wrote: Hi, Any advice on porting stored procedures from sql server. I have looked at UDF's but can't figure out how to use the existing database connection to perform queries, also have not used C for a very long time. Also had a brief look at myperl, but not well documented and still in beta. Thanks Chandra -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: How is DBTools Software?
MySQL-Front isn't being developed anymore right? Anyhow, the last version I used was very very buggy. At 06:37 AM 12/8/2002 -0400, Chris Mason wrote: I've found mysql-front to be far superior, in fact, I can't complain about it at all. -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 3:27 PM To: Will Standley Cc: Sandeep Murphy; Crercio O. Silva; MySQL List Subject: Re: How is DBTools Software? Hi, I used it for a while, it's quite good for free software, but it is rough around the edges. Some of the menus are a bit hard to navigate and it crashes once in a while too. I'm currently using EMS Hitech's MySQL Manager. It's one of the best GUI's I've come across. There are a couple of glitches with the program, but nothing severe. The author is really responsive in returning questions and comments. The only drawback - It's not free... http://www.ems-hitech.com/mymanager I'm debating if I should register it (might go back to DB Tools), but that's because I'm building a charity/non-profit site and funds are kind of tight! At 08:15 AM 12/7/2002 -0500, Will Standley wrote: Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/) It is a free utility for managing MySQL other db's. I also discovered Intelligent Converters at www.convert-in.com Both look good. The first is free and does more than convert Access to MySQL. The second converts more stuff... like Excel to MySQL. All comments encouraged. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Date conversion
You need to convert the date format to: -MM-DD: http://www.mysql.com/doc/en/Using_DATE.html At 08:38 PM 12/8/2002 -0500, [EMAIL PROTECTED] wrote: Hi all, I have a datetime data field in SQLServer7, and I am trying to get a recordset according to criteria that the CallDate field in the database equals todays date 09/12/2002 Dim TodaysDate TodaysDate= cDate(Date) -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Replication between Windows MSSQL and UNIX MYSQL
Did you read the Replicatoin Manual? http://www.mysql.com/doc/en/Replication.html At 09:15 PM 12/8/2002 -0500, shawn xu wrote: We have an application software which uses MSSQL 7.0 or 2000 server on Windows. Now we want to use the MSSQL as a master, and MYSQL on UNIX as a slave. How can we configure Windows MSSQL and UNIX MYSQL both sides to implement replication? -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 connect error 10061 - nothing but Mascon works remotely.
Sorry for jumping in late, but are you saying that you can't connect from a remote machine? Did you add a Host '%' to your username in the users table? At 07:36 PM 12/8/2002 -0800, Daevid Vincent wrote: *I* am the admin. I don't have a command line utility on my WinXP box. The command line util on Linux works just fine for itself (localhost, daevid.com, 192.168.1.254, etc) MySQL *is* configured properly otherwise mascon would not be able to connect either. I've done this for a while. The problem lies either with RedHat 8.0 and their whacked glibc (still) _OR_ the MySQL*.rpm files on the mysql.com site are not statically linked as they say they are. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
Server Memory Requirements
Hi all, I'm going to run MySQL off a shared Unix server so I'm wondering what the memory requirements are. I have about 15 tables are simple text columns (~10 - 20 columns). The largest tables will be ~25MB. I did a quick test on my Win32 Machine and the largest query only takes up 18MB of RAM. Is there a way to minimize RAM usage? Maybe flush the RAM cache X minutes? Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: MySql Feature
At 04:22 PM 12/7/2002 +0100, Benjamin Pflugmann wrote: Hello. On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote: Hello friends, newbie here. 1. I need to know if these features are supported or not by MySql ver 4.05a. - Referencial integrity constraint - Stored Procedure - View - Trigger I can't wait for these features too! But since some of the features are slated for v5.0 - v6.0, I guess we won't be seeing them for a couple of years. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: How is DBTools Software?
Hi, I used it for a while, it's quite good for free software, but it is rough around the edges. Some of the menus are a bit hard to navigate and it crashes once in a while too. I'm currently using EMS Hitech's MySQL Manager. It's one of the best GUI's I've come across. There are a couple of glitches with the program, but nothing severe. The author is really responsive in returning questions and comments. The only drawback - It's not free... http://www.ems-hitech.com/mymanager I'm debating if I should register it (might go back to DB Tools), but that's because I'm building a charity/non-profit site and funds are kind of tight! At 08:15 AM 12/7/2002 -0500, Will Standley wrote: Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/) It is a free utility for managing MySQL other db's. I also discovered Intelligent Converters at www.convert-in.com Both look good. The first is free and does more than convert Access to MySQL. The second converts more stuff... like Excel to MySQL. All comments encouraged. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Questions Compressed Tables Indexs
Hi all, I'm planning to run a remote DB across the internet for a web application and I would like to minimize retrival times and bandwidth. I have a couple of questions about MyISAM compressed Tables: 1. Is it slower to retrieve from a compressed table, or actually faster since data is packed? 2. Is there an increase in CPU overhead? Is it significant? 3. Is the data sent to the client compressed or decompressed? As for indicies is it better to create a single index per column, or an index for a set of columns. For example, if I go: SELECT * FROM SOMETABLE WHERE A = X and B = Y. Is it better to create a X AND Y index, or two separate indicies? Thanks! sql, query, mysql, stuff to avoid the spam filter... -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Error Message Documents - where to find it?
The manual: http://www.mysql.com/doc/en/perror.html It'll return the error string. At 02:59 PM 12/5/2002 -0500, Jason Hall you wrote: Where can i find documents with the description of mysql error code returned by the mysql daemon? - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: QUICK: What is the optimal way to store opening times ?
Yes, in some cases. It's called Normalization. Although normalization is good practice, it can complicate queries. Have you thought about storing just M/T/W/etc and then storing the Opening, Closing times as a comma delimited string? Maybe like Monday: 11AM,1PM,5PM,1AM Tuesday 10AM,1PM,6PM,12AM You'll only need 7 fields. OR, you can reduce it further and only have 3 Fields. Morning, Afternoon, Night. Then you can store all times for the week into one string. At 03:26 AM 12/6/2002 +0100, Alliax you wrote: Thank you for this and for the previous answer about create temporary table, your RestTimes is a nice way to do it, but it multiplies the number of rows of the table. So you say it's better to have more rows than have less row, when doing simple select query? I'll do it your way then, except if somebody has a better idea ? -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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