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

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

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

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

AW: AW: [PHP] How to argue with ASP people...

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

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

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

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

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. --

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,

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

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

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:

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 =

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

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:

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

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

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

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

AW: Too many connections

: 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

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

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

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.

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

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]

AW: Not receiving list emails

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

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

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

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

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)

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:

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]

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]

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,

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:

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 / / / / /__/ / /

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

AW: ADO Error '800a01fb'

:[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

AW: ADO Error '800a01fb'

= 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