AW: Date arithmetic: 2005-08-31 - 1
Barbara, Can't you use the ADDDATE function ? http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html Freddie -Ursprüngliche Nachricht- Von: Barbara Deaton [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 23. August 2005 21:37 An: mysql@lists.mysql.com Betreff: Date arithmetic: 2005-08-31 - 1 All, I know MySQL comes with all sorts of wonderful functions to do date arithmetic, the problem is the context that my application is being called in I don't know if a user wants me to add or subtract days. I'm just given the number of days that need to be either added or subtracted from the date given. So for example, if your table was mysql select * from dtinterval; + | datecol + 2005-09-01 2005-08-30 2005-08-31 +-- a user could enter: select count(*) from dtinterval where datecol - 1 = '30AUG2005'd; Which is our applications SQL, my part of the product is only give the value 1, I have to transform that into something MySQL will understand as 1 day and then pass that back into the SQL statement to be passed down to the MySQL database. I transform our applications SQL into select COUNT(*) from `dtinterval` where (`dtinterval`.`datecol` - 1) = '1974-12-04' I know that just doing the -1 is wrong, since select '2005-08-31' - 1 and that just gives me a year mysql select '2005-08-31' - 1; +--+ | '2005-08-31' - 1 | +--+ | 2004 | +--+ What do I need to translate the 1 into in order to get back the value '2005-08-30' ? Thanks for your help. Barbara -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: beginner needs help servin up a lan
Shawn, Check out dbManager dbTools Professional : http://www.dbtools.com.br/EN/downloads.php It is free and has an MS Access import wizard Freddie -Ursprüngliche Nachricht- Von: nephish [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 12. Juli 2005 04:28 An: mysql@lists.mysql.com Betreff: beginner needs help servin up a lan Hello there i need to import an entire database or find a way to get all the info in a microsoft access .mdb database into a MySQL database. here is another trick, the access database is on an WinXP computer, the MySQL database is on a debian linux computer. They are on the same internal network though. is this even possible ? if so, where can i read up on how to do it? thanks, shawn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: AW: [PHP] How to argue with ASP people...
Ahhh, you guys are sooo funny - you all know what I mean -Ursprüngliche Nachricht- Von: Jay Blanchard [mailto:[EMAIL PROTECTED] Gesendet: Montag, 3. Januar 2005 14:36 An: Freddie Sorensen; [EMAIL PROTECTED] Cc: mail.pmpa; mysql@lists.mysql.com Betreff: RE: AW: [PHP] How to argue with ASP people... [snip] It is worth it for performance reasons ! [/snip] Really? What performance stats are you looking at here? [snip] And if you believe ASP.NET only provides a few benefits, then you are adequately informed, my friend [/snip] Yes, he is adequately informed...and correct. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: [PHP] How to argue with ASP people...
Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. -Mensagem original- De: Tony Di Croce [mailto:[EMAIL PROTECTED] I am fairly new to PHP, but I am loving it... I have recently gotten involved in a business venture and I have been using PHP so far... Recently I have taken on a partner, and he is a big ASP guy... I am not totally against ASP, but it would have to be pretty good to get me to switch at this point (PHP seems to do everything I need)... But I will need to convince him of this... What points can I bring up in PHP's favor? In what areas does PHP trounce ASP? -- td -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: AW: [PHP] How to argue with ASP people...
Shawn, It is worth it for performance reasons ! And yes, I am LOOKING at the code and DEBUGGING it every single day, also without the use of VS, what's the problem ? And it is global.asax, not global.asp I and my colleagues have never had a project which we didn't get right the first time, I mean in terms of having to reinstall anything, it was always very easy And if you believe ASP.NET only provides a few benefits, then you are adequately informed, my friend Freddie _ Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 15:26 An: Freddie Sorensen Cc: 'mail.pmpa'; mysql@lists.mysql.com Betreff: Re: AW: [PHP] How to argue with ASP people... Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... ) that VS produces to make an ASP.NET application? Have you EVER had to be in the position to debug and modify that by hand (without the aid of VS)? I have. I ask that you try it before you continue your high praise for the product. I fully believe that M$ is so full of themselves for offering this as anything approaching efficient. It's designed in such a way that once you convert, you will have a very hard time getting away from it because it is SO convoluted in its execution. I feel that it's meant more to trap you into staying with their product than making life easier. I have tried (or assisted others) on more than one occasion to get ASP.NET functioning for full development support (server-side debugging, full VS integration, yadda yadda yadda) and have YET to see anyone get it right the first time. Usually we have to rip out and reinstall or update and upgrade which required us to compare and contrast several different explanations from MSDN about what may be wrong and how to fix it. Eventually, we made it work but it was never easy. IF you like it, fine. You may use it. I however recommend against it. Stick with PHP, ASP, PERL, or Python (whichever you prefer) but I personally don't think that ASP.NET is worth the effort for the few benefits it provides. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Freddie Sorensen [EMAIL PROTECTED] wrote on 12/31/2004 04:01:14 AM: Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. -Mensagem original- De: Tony Di Croce [mailto:[EMAIL PROTECTED] I am fairly new to PHP, but I am loving it... I have recently gotten involved in a business venture and I have been using PHP so far... Recently I have taken on a partner, and he is a big ASP guy... I am not totally against ASP, but it would have to be pretty good to get me to switch at this point (PHP seems to do everything I need)... But I will need to convince him of this... What points can I bring up in PHP's favor? In what areas does PHP trounce ASP? -- td -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Brainstorming' time!
Scott, ASP.NET would be just fine ! Freddie -Ursprüngliche Nachricht- Von: Scott Hamm [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 20. August 2004 20:40 An: 'Mysql ' (E-mail) Betreff: Brainstorming' time! Looks like I will need more than just MySQL and Php/ASP.net. I might even look into perl. What else should I be using? (IIS is provided for) I'm willing to learn new tricks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Brainstorming' time!
Rhino Get the free DBTools DBManager Pro from http://www.dbtools.com.br/EN/dbmanagerpro.php - there is a cool CSV export function there Or get MyODBC and connect from Excel to your MySQL database Or as Scott said, roll your own exporter if you have programming skills Freddie -Ursprüngliche Nachricht- Von: Rhino [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 20. August 2004 18:30 An: Scott Hamm; 'Mysql ' (E-mail) Betreff: Re: Brainstorming' time! - Original Message - From: Scott Hamm [EMAIL PROTECTED] To: 'Mysql ' (E-mail) [EMAIL PROTECTED] Sent: Friday, August 20, 2004 12:02 PM Subject: Brainstorming' time! Ok. I'm looking into alternatives. I'm trying to figure out an alternative to mysql exporting into xls file. Is there any another way you can export into file and make it readable? What format do you use? I'm open to ideas from experienced database programmers :) I'm upgrading the whole database system from stupid Access database into SQL variant, whether it be MySQL or SQL server (MeowSoft) How do you export a MySQL table into an XLS file? ;-) You raised an interesting point - the whole issue of exporting data from MySQL - so I took a quick glance and couldn't see *anything* that looked like an export utility of the kind I've seen in many other programs and relational databases. Just about the only thing I saw was the mysqldump utility which basically generates the SQL needed to re-create and re-populate a table on another system. But I don't think that's what you're looking for and it clearly won't generate an XLS file. So I'm not sure how you'd even export to XLS. In the absence of an actual export utility - assuming I haven't missed one in the manual somewhere! - you are hosed. Unless of course you have programming skills; in that case you could write your own export utility to export data in any format you like. If you do that, you might consider sharing it with the rest of us when it is done, even if it isn't a full-function ultra-slick piece of code; it might still be useful to some of us if we ever need to export data. Or maybe there are some export utilities floating around for MySQL that are described somewhere other than the manual. I could well imagine users developing their own homegrown utilities and donating them to MySQL. I can also imagine professional developers writing a full-function export utility for MySQL; a Google search might turn those up. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: GUI for MySQL
Kirti Have a look at the free DBManager Pro from DBTools : http://www.dbtools.com.br/EN/dbmanagerpro.php Freddie -Ursprüngliche Nachricht- Von: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 12. August 2004 20:09 An: '[EMAIL PROTECTED]' Betreff: GUI for MySQL This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: TOP
Check out the LIMIT function in the documentation -Ursprüngliche Nachricht- Von: Kamal Ahmed [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 28. Juli 2004 20:39 An: [EMAIL PROTECTED] Betreff: TOP Hi, Does anyone know how to do a TOP function in MySQL ? Thanks, -Kamal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: making lower case then first char to upper case?
Aaron, How about something like : SELECT CONCAT(UCASE(LEFT(FieldName, 1)), LCASE(RIGHT(FieldName,LENGTH(FieldName)-1))) Right out of my head, I didn't count all the parantheses :-) Freddie -Ursprüngliche Nachricht- Von: Aaron Wolski [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 30. Juni 2004 18:46 An: [EMAIL PROTECTED] Betreff: making lower case then first char to upper case? Hi Guys, I'm trying to figure out of this is possible. I know I could do it in PHP but I am dealing with a ton of records and would rather put the processing on the DB than PHP/client side. Question is. can I do a SELECT query on a column that changes all the results to lower case and THEN changes the first character of each result to an upper case? Example: Currently in DB: AARON to Lowercase: aaron to Uppercase: Aaron Any idea on if I can do this and how I might approach it? Thanks so much Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Merging 2 Fields
David, Maybe the CONCAT() function is what you are looking for ? Freddie -Ursprüngliche Nachricht- Von: David Blomstrom [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 27. Juni 2004 08:07 An: [EMAIL PROTECTED] Betreff: Merging 2 Fields I think I recall a thread where someone mentioned merging two fields. If that can be done, I'd like to know how. For example, suppose I have a field filled with place names, next to a field filled with links: California | http://www.california.gov/ Florida | http://www.florida.gov/ I'd like to merge the columns, so the two columns are displayed as one: http://www.california.gov/California I'd have to add the closing /a tag somehow, but I think I know how to do that. So how do you merge fields? Thanks. __ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: How big is big?
Karsten, I wouln't worry about this - There are plenty of examples where people are running tables with millions of records without significant performance problems. Of course it all depends on the complexity - will you have many tables and many joins in your queries ? Just make sure to index your tables properly Freddie -Ursprüngliche Nachricht- Von: KingKarsten [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 15. Mai 2004 19:19 An: [EMAIL PROTECTED] Betreff: How big is big? Aloha! I want to create a date table which will get about 2 thousand entries per year and should easyly handle 10 years, which means about 20.000 entries. Is that realistic? Or shall I reorganize my database? Where is the border of too many entries and MySQL gets slow? Thanks for your help, Karsten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: please ignore
That's a lot of stuff to ignore but I managed to do so successfully -Ursprüngliche Nachricht- Von: Victor Medina [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. April 2004 13:39 An: [EMAIL PROTECTED] Mysql. Com Betreff: please ignore -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please ignore - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | ~ | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | ~ |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ~ ||Cel: +58-412-8859934 | ~ ||geek by nature - linux by choice | ~ |...| -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAfnQ38WJSBCrOXJ4RAoLdAKCzq8I7IyYWdeOZhAearCOtdiy5SACff13C rXyNw+3aprFYN2v5pd+PELs= =ppFP -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: DB Connection
What is the connection type ? ODBC ? -Ursprüngliche Nachricht- Von: Shrikrishna Sathe [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 31. März 2004 12:53 An: [EMAIL PROTECTED] Betreff: DB Connection The following .asp code sinppet gives error. Dim rs Set rs = Server.CreateObject(ADODB.Recordset) rs.Open printjob,objConn, adOpenForwardOnly, adLockOptimistic , adCmdTable rs.AddNew rs(jobid) = Request.Form(jobno) rs(closesize) = Request.Form(closize) rs(opensize) = Request.Form(opsize) rs.Update rs.Close Set rs = Nothing Is this AddNew call doesn't work in mysql ? The Insert into statement works well but it is very cumbersome while adding 25 fields. please guide. Thanks Regards Shrikrishna -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: MySQL - VB.NET
Thorsten Which programming language are you using ? I believe that for VB it is cbokundenr.value for a combobox Maybe it would help if you post more code, but I don't know if this is the correct list to do that You can write me off list if you want so I can try to help you Freddie -Ursprüngliche Nachricht- Von: Thorsten Reichelt [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 31. März 2004 20:13 An: MySQL List Administrator Betreff: MySQL - VB.NET hi, i want to use Select to get informations out of a Database ... i tryed to write to SelectCommand in the OdbcDataReader SELECT kdnr, auftrag FROM standart WHERE (KdNr = ' cbokundenr.text ') - i use 1 OdbcDataReader, 1 DataSet and 1 OdbcConnection i want to read data`s(kdnr) out of a combobox to search with this number(kdnr) for data`s out of another database. but with this above nothing happens ... i hope someone can help me. complete new ways are also welcome. greetings thorsten -- +++ NEU bei GMX und erstmalig in Deutschland: TÜV-geprüfter Virenschutz +++ +++ 100% Virenerkennung nach Wildlist. Infos: http://www.gmx.net/virenschutz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Migrating Access databases to MySQL
Arjun The free DBTools DBManager can import Access databases directly to MySQL : http://www.dbtools.com.br/EN/dbmanagerpro.php Freddie -Ursprüngliche Nachricht- Von: Arjun Subramanian [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 19. März 2004 02:56 An: [EMAIL PROTECTED] Betreff: Migrating Access databases to MySQL Hello people ! I was hoping for some wisdom from the good folks on this list about moving databases from access to MySQL. I am aware of the brute force method of exporting in CSV format or tab delimited formats and using mysqlimport to move the tables. 1. I was wondering if there was a way to dump access databases in SQL queries like the mysqldump utility does ? 2. When exporting tab delimited values from access and using mysqlimport everything works fine except date columns. All the data moves except the date field which shows up zero's I mysql after I use mysqlimport. Does anyone have a clue on what might be happening? 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? I would appreciate any help at all. Thanks to everyone in advance ! Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 I'm MySQL certified. Are you? -Original Message- From: Casey Sheridan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 6:32 PM To: [EMAIL PROTECTED] Subject: writing queries to get distinct results I have a table that has employee names, pay rates, and unique IDs. I want to select all of the distinct employee names, and if there are two employees with the same name, I want to be able to choose only one; the one with the highest pay rate. If there are two identical employee names with the same pay rate, I want to select the one that has the lowest unique ID number. Can anyone help me on how to write this query? Thanks! -Casey Sheridan [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Test Email - Please Disregard
Successfully disregarded ! -Ursprüngliche Nachricht- Von: Kevin Carpenter [mailto:[EMAIL PROTECTED] Gesendet: Montag, 15. März 2004 19:33 An: [EMAIL PROTECTED] Betreff: Test Email - Please Disregard Test Email - Please Disregard -:Kevin Carpenter CHOP - Biomedical Engineering (215) 590-5762 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: max used connections question
Dean It is the number of concurrent connections They disappear either when they are closed by the application which has opened them, or when wait_timeout expires for inactive connections The wait_timeout is by default at 28800 seconds, so it will take quite a long time before they disappear (didn't calculate the number of hours though) Freddie -Ursprüngliche Nachricht- Von: Rochester, Dean [mailto:[EMAIL PROTECTED] Gesendet: Montag, 8. März 2004 15:14 An: '[EMAIL PROTECTED]' Betreff: max used connections question Does this number indicate the current number of connections or the max number of connections during the current uptime? We have this number max set to 200 from the default 100 how does this number go down during uptime? It hovers around 30 - 40 but sometimes goes to 90 But it does not seem to go back down without restarting the mysql service Dean-O EMAIL CONFIDENTIALITY NOTICE This Email message, and any attachments, may contain confidential patient health information that is legally protected. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of this message is strictly prohibited. If you have received this information in error, please notify the sender immediately by replying to this message and delete the message from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: VB and mySql
Walt You can also use VB with MySQL without problems. There are several connectors available at the MySQL site Freddie -Ursprüngliche Nachricht- Von: Walt [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 7. März 2004 18:01 An: [EMAIL PROTECTED] Betreff: VB and mySql I used to program with VB using MS access as the db. VB was very quick to develope nice looking forms. Which language would be the best to use with mysql to create similiar forms. These forms would be for scrolling through the db, adding, updating, deleteing, printing... Walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: OLEDB Provider for Mysql
Gilbert You might want to look at the ByteFX provider Freddie -Ursprüngliche Nachricht- Von: Gilbert Wu [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 4. März 2004 18:28 An: [EMAIL PROTECTED] Betreff: OLEDB Provider for Mysql Hi, We are developing in Microsoft's C++.NET with MS SQL Server as the underlying DBMS. We are planning to move to MySQL.Please kindly advise if there is a OLEDB provider for MySQL? or do I have to stay with ODBC? Many thanks. Gilbert Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Too many connections
Randy Thanks but I am not really sure where the connections are kept alive or 'asleep' I am quite sure that I am closing my objects, setting them to nothing and disposing them in my script (actually, ASP.NET is not relly script) but I don't know if IIS is keeping the connection objects in the connection pool, if the .NET garbage collector needs to dispose them or if MySQL keeps them in sleep mode. I didn't have this problem when both services were running on the same machine, only after I separated them. In the MyINI file you can alse set the timeout for sleep connections, by default it is 28800 seconds. I tried to redûce it to 5 seconds, and BOOM - it smashed my MySQL service I am really very confused about where the cause of the problem is. Finding this out would maybe help finding a solution Any thoughts or experiences, anybody ? Freddie -Ursprüngliche Nachricht- Von: Randy Clamons [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 3. März 2004 22:05 An: Freddie Sorensen; [EMAIL PROTECTED] Betreff: Re: Too many connections Freddie, Try tuning startup parameters in my.ini or my.cnf. The default value for max_connections is 100. That's a lot for a web site with a single server. If max_connections is set in my.ini (or my.cnf) to a low number, try a larger value. If max_connections is not set, your connections are staying open. Make sure your scripts are closing your connections. If none of this works for you, try tuning the memory parameters to get better performance from mysqld. Randy Clamons Astro-auction.com At 09:15 PM 03/03/2004 +0100, Freddie Sorensen wrote: Hi, I am using MySQL 4.1.1 as backend for an ASP.NET webapplication using the provider from ByteFX. Until now, IIS and MySQL were running on the same machine and now I have moved the webserver to another machine. Now I start getting 'Too many connections' errors from the MySQL server. This did not happen before when I was connecting to localhost Anybody knows why this starts happening now and what I can do to solve it ? Thanks in advance Freddie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Query error in Access
Ed The MS Access SQL syntax for if() is iif(condition, then stuff, else stuff) Maybe that's the problem, I am not sure - try it Freddie -Ursprüngliche Nachricht- Von: Ed Reed [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 26. Februar 2004 02:09 An: [EMAIL PROTECTED] Betreff: Query error in Access Hello Everyone, If I run the following query in MySQL Control Center or MySQL-Front it works correctly, SELECT -1 AS ProductID, Add New Part AS PartNumber, AS VendorPartNo, AS Description, AS VendorStatus FROM Products UNION SELECT ProductID, PartNumber, If(SubNo=1135, VendorPart,AltVendorPart) AS VendorPartNo, Description, If(SubNo=1135, Primary,Alternate) AS VendorStatus FROM Products WHERE ((Obsolete=0) AND (SubNo=1135)) OR ((AltSubNo=1135)) ORDER BY ProductID, VendorPartNo, VendorStatus DESC; If I run the same query in MSAccess, where my user interface is, I get the following error, [MySQL][ODBC 3.51 Driver][mysqld-4.1.1-alpha-log]You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the syntax to use near 'Description FROM products WHERE (((Obsolete = 0 ) AND (SubNo = (#1064) My log file shows the following, 1163 Query (SELECT ProductID ,NSIPartNumber ,,Description FROM products WHERE (((Obsolete = 0 ) AND (SubNo = 1135 ) ) OR (AltSubNo = 1135 ) ) ) UNION (SELECT -1 ,'Add New Part' ,'' ,'' FROM products ) I'm aware of the difference between Access and MySQL regarding the IIF versus IF and I've tried the query both ways with no success. SubNo is a valid ID. In both MySQL Control Center or MySQL-Front this query returns 58 records in about on third of a second. Any thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Transfering from access to MySQL?
Jonas Check out the free DBManager at http://www.dbtools.com.br/EN/dbmanager.php It can not only import directly from Access but might be very handy later in your every day work with MySQL as a front-end Couldn't live without it ! Freddie -Ursprüngliche Nachricht- Von: Jonas Lindén [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 25. Februar 2004 09:33 An: [EMAIL PROTECTED] Betreff: Transfering from access to MySQL? Hello, Could someone help me with a tip on how I can convert my old Access DBs to MySQL? Regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: How To Write This SQL Statement
Try : SELECT * From table WHERE `address` = '' Or SELECT * From table WHERE `address` IS NULL -Ursprüngliche Nachricht- Von: Caroline Jen [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Februar 2004 20:17 An: [EMAIL PROTECTED] Betreff: How To Write This SQL Statement Please help. What is the syntax of idenfying those who do not have addresses (in the address field) in the database? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: iterating through a month
Check out GROUP BY -Ursprüngliche Nachricht- Von: Scott Haneda [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 6. Februar 2004 23:34 An: MySql Betreff: iterating through a month In MySql is it possible to repeat through a month, for example I would like to Select count(user) from table where date = x However, I want x to be a range from the first of the month to the last day in the month, I of course would need to pass in a month and year value to limit it to that month and year. Basically, I am trying to provide a month at a glance report of total posts by various users to a table. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: SQL Query
Ian Check the documentation for the correct SELECT SYNTAX : http://www.mysql.com/doc/en/SELECT.html Your WHERE clause should be before ORDER BY Freddie -Ursprüngliche Nachricht- Von: Ian O'Rourke [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 18. Januar 2004 12:22 An: [EMAIL PROTECTED] Betreff: SQL Query Any idea what is wrong with the following: SELECT * From articles ORDER BY EntryDate DESC LIMIT 1,10 WHERE SectionID=1 I want to return all articles with a particular SectionID, ordered by EntryDate and then I want to pick the start point and list the next 10 from that. Obviously in the final version the start point and the SectionID will be dynamic. I have tried removing the LIMIT part. I've tried changing the SectionID to a different field it always gives me an uninformative error? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Not receiving list emails
The emails have started to come today. I did several things, but don't know which one of them caused the emails to start coming in again : I reported the problem on the 'contact us' page on www.mysql.com I re-subscribed all my lists. When the confirmation emails came today and I clicked on the subscription confirmation links, it said that I was already subscribed This has actually happened to me before a few months ago. At that time I received no emails for weeks until I reported the problem. Seems like reporting the problem solves it but I have received no confirmation of that or any explanation. I would really like to know what causes this so that I know how to react next time Freddie -Ursprüngliche Nachricht- Von: Stephen Brownlow [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. Januar 2004 02:44 An: Freddie Sorensen; 'MySQL List' Betreff: Re: Not receiving list emails Hello, The MySQL list server sent me nothing for about 24 hours, until just recently. It followed my first attempt to use the support.mysql.com website and change my details there [that might have been just a coincidence]. I started getting messages again soon after I sent a new subscription message to [EMAIL PROTECTED] The posting today by Jim Winstead of MySQL AB indicates that SpamCop might be involved. The message is not clear to a non email techo like myself, so I expect to see more comments in that thread. Good luck, Stephen - Original Message - From: Freddie Sorensen [EMAIL PROTECTED] To: 'MySQL List' [EMAIL PROTECTED] Sent: Friday, January 16, 2004 11:27 AM Subject: Not receiving list emails I have not received any emails from this list since last Sunday - if this post comes through and anybody has an idea what is wrong please reply to me off list Thanks Freddie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not receiving list emails
I have not received any emails from this list since last Sunday - if this post comes through and anybody has an idea what is wrong please reply to me off list Thanks Freddie
AW: The Future of MySQL with .NET Plataform
Well, I am using MySQL with ASP.NET, using the managed provider from ByteFX Works like a dream ! Freddie -Ursprüngliche Nachricht- Von: Donald Henson [mailto:[EMAIL PROTECTED] Gesendet: Montag, 5. Januar 2004 16:34 An: MySQL List Betreff: Re: The Future of MySQL with .NET Plataform On Mon, 2004-01-05 at 07:31, Carlos J Souza wrote: Hello for all, Please i need comments about future of MySQL with .NET Plataform introduction. Regards for all Carlos Souza I don't know if you're going to get an answer to that query. .NET is not a very popular subject around here. If you discover the answer somewhere else, I would appreciate it if you could post a summary to the list. Thanks. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Convert MS Access to MySql
Arthur Get DBManager Professional (for free) here : http://www.dbtools.com.br/EN/dbmanagerpro.php There is a wizard which can do this conversion for you Freddie -Ursprüngliche Nachricht- Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 21. Dezember 2003 19:00 An: [EMAIL PROTECTED] Betreff: Convert MS Access to MySql I need to convert an MS Access database to MySql. I would like to know the best way to do this. I was going to write an asp or php script that would read the MS Access db row by row and insert into the MySql db row by row. Is that the only way to move the data from the one db to the other? Many thanks Arthur -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: MySQL GUI tool
I'm using DBTools DBManager Professional - it's free : http://www.dbtools.com.br/EN/dbmanagerpro.php Freddie -Ursprüngliche Nachricht- Von: Amanullah [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 18. Dezember 2003 03:57 An: [EMAIL PROTECTED] Cc: MySQL List Betreff: Re: MySQL GUI tool Hi, I'm Using the Same, the Tool is very much useful to me to export data from one server to another online, and for much more activities. Excellent... -Aman. Mike Blezien wrote: Hello, Was wondering if any one on the list has or is using PremiumSoft Navicat's MySQL Administration Tool for windows, and if so, any thoughts on it... good, excellent, poor...etc. Appreciate the feedback ;) TIA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: read (Off subject Help) ACCESS!!
Karl I have quite a lot of experience with MS Access - write to me off list if you want me to help you Freddie -Ursprüngliche Nachricht- Von: karl james [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 2. Dezember 2003 15:16 An: [EMAIL PROTECTED] Betreff: read (Off subject Help) ACCESS!! Does anyone use Microsoft access? I need help with creating a query that will delete records, If you can help me please email me directly! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: Table Name
Eduardo
MySQL does not use the square brackets [] as field delimiters. Try to use
`Clientes of Supermarkets` instead
Note, these are not single quotes (') but ASCII 96
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 14:40
To: [EMAIL PROTECTED]
Hi all !
I am migrating my database from MS-ACCESS to MYSQL. When I try to use a
select statement below the application fails.
select * from [Clientes of Supermarkets]
anybody have an idea ?
best regards,
Eduardo F. Melo
_
MSN Messenger: converse com os seus amigos online.
http://messenger.msn.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: alternate syntax for UNION?
Victor How about generating a temporary table with the results of both queries ? Or open two recordsete and merge them in your code ? Freddie -Original Message- From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED] Sent: Sonntag, 26. Oktober 2003 16:56 To: [EMAIL PROTECTED] Desperately need some way to get around the fact that UNION is not possible to use on mysql prior to version 4 Was just about to launch a site when it showed up that the hosting provider was running version 3. Help! Regards, Victor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Date Field
Eduardo
Use the format '-mm-dd' instead
By the way, there is an excellent manual on http://www.mysql.com including
all the field types and formats
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 16:15
To: [EMAIL PROTECTED]
Hi All !
I have a datetime field in a table. When I use insert into table
(aniversary) values ('24/10/2003'). The date is save as 20/10/2024. I am
using dd/mm/ What can I do to save the date correctely ?
best regards,
Eduardo F. Melo
_
MSN Messenger: converse com os seus amigos online.
http://messenger.msn.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Database Admin
Ratmil Check out the free dbTools at http://www.dbtools.com.br/EN/ Freddie -Original Message- From: Ratmil Torres [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 23. Juli 2003 14:22 To: [EMAIL PROTECTED] Hi, I just installed MySQL. Does anybody know where to manage the databases, create, edit and delete tables? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: tst msg
test failed -Original Message- From: Neeraj Vasudeva [mailto:[EMAIL PROTECTED] Sent: Samstag, 19. Juli 2003 11:28 To: [EMAIL PROTECTED] this is a test message -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: test 1 2 3...
4 5 6 -Original Message- From: Tom Roos [mailto:[EMAIL PROTECTED] Sent: Montag, 14. Juli 2003 11:48 To: [EMAIL PROTECTED] _ ___ _ __ /______/ / ___/ / \ // / / / // / / ^ v / / / / /__/ / / / \/ / / /_ / /__ / /_ / /_ / Cell: 083 440 2213 Ph: 021 980 4969 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: ADO Error '800a01fb'
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
AW: ADO Error '800a01fb'
I have heard of cases where there were some problems with MDAC and that it helped to reinstall the latest version Otherwise try to troubleshoot with something like : 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 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/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
AW: ADO Error '800a01fb'
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/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
