SV: ADO recordset is not returning rows in ASP page

2002-05-30 Thread Carsten Gehling
Have you tried to run the query in MySQL's console? - Carsten -Oprindelig meddelelse- Fra: Rob Galvin [mailto:[EMAIL PROTECTED]] Sendt: 30. maj 2002 20:29 Til: [EMAIL PROTECTED] Emne: ADO recordset is not returning rows in ASP page I have an active server page using an ADO

SV: building tree view in mysql?

2002-05-27 Thread Carsten Gehling
Well you'll neew to do some coding in your application language. What are you using to connect to MySQL? Perl? PHP? Java? Tell me, and I'll give you an example where you only query the database once (for optimum performance). - Carsten -Oprindelig meddelelse- Fra: Sagi Bashari

SV: building tree view in mysql?

2002-05-27 Thread Carsten Gehling
call. The trick is, that to make a tree you always need to use recursive functions. The performance is gained by loading the complete list from database at once (instead of calling a mysql SELECT statement for each branch of the tree). - Carsten -Oprindelig meddelelse- Fra: Carsten

SV: 4.0.1 Bugs

2002-05-18 Thread Carsten Gehling
Fra: Richard Clarke [mailto:[EMAIL PROTECTED]] Sendt: 18. maj 2002 22:29 Emne: 4.0.1 Bugs List, I wondered if any movement has been made to determine the cause of the following bugs that I have come across using Mysql 4.0.1. 1) selectunion causes a temporary table full type

SV: Newbie Question

2002-05-06 Thread Carsten Gehling
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi ported to Linux. - Carsten -Oprindelig meddelelse- Fra: Yvon Darang [mailto:[EMAIL PROTECTED]] Sendt: 6. maj 2002 15:31 Til: [EMAIL PROTECTED] Emne: Newbie Question Hi everybody, Let's say I do not want to

SV: C++ API for Mysql

2002-05-06 Thread Carsten Gehling
You can download MySQL++ from www.mysql.com - Carsten -Oprindelig meddelelse- Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]] Sendt: 6. maj 2002 17:24 Til: [EMAIL PROTECTED] Emne: C++ API for Mysql Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on

SV: Strategies for maintaining tables calculated from other tables?

2002-05-04 Thread Carsten Gehling
Fra: Nick Arnett [mailto:[EMAIL PROTECTED]] Sendt: 3. maj 2002 04:30 Emne: Strategies for maintaining tables calculated from other tables? I'm finding that it's not quite as simple as I had imagined to maintain a table whose values are calculated by analyzing other tables. The source

SV: WHERE ignored

2002-04-28 Thread Carsten Gehling
-Oprindelig meddelelse- Fra: Mike Hall [mailto:[EMAIL PROTECTED]] Sendt: 28. april 2002 12:28 Til: [EMAIL PROTECTED] Emne: Fw: WHERE ignored Corrupt index, hmm? I'll check that in a moment - thanks. After looking at your fault-free script, my best bet would also be a corrupted

SV: WHERE ignored

2002-04-27 Thread Carsten Gehling
-Oprindelig meddelelse- Fra: Mike Hall [mailto:[EMAIL PROTECTED]] Sendt: 27. april 2002 00:04 snip No other scripts perform UPDATEs on that table, only INSERTs. But MySQL returned the correct data at 8:55 and again at 9:05. It was only when it ran at 9am that it appeared to

SV: Max 127 records

2002-04-19 Thread Carsten Gehling
Fra: Henning Olsen [mailto:[EMAIL PROTECTED]] Sendt: 19. april 2002 14:39 Hey - can anyone help? I have a MySql-db in which I can only have 127 records. Using phpmyadmin to insert record number 128 (autoincrement) gets this message: INSERT INTO `kontakt` (`id`, `navn`, `adresse`,

SV: a query from php doen't work

2002-04-17 Thread Carsten Gehling
Fra: savaidis [mailto:[EMAIL PROTECTED]] Sendt: 17. april 2002 22:14 Emne: a query from php doen't work I get a Query failed error on this: What could hapent? Try to alter this line: $result=mysql_query($buffer); to look like this: $result=mysql_query($buffer) or

SV: MySQL and stored procedures - v4.1 :(

2002-04-16 Thread Carsten Gehling
Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sendt: 16. april 2002 09:52 MySQL AB wants to satisfy as many users as possible. That means there may be more than one language available for writing stored procedures. For example, many mainstream databases currently support both Java and a

SV: How does DISTINCT really work ?

2002-04-14 Thread Carsten Gehling
Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]] Sendt: 14. april 2002 19:22 In fact what it's odd is when I use EXPLAIN, I don't see anywhere DISTINCT in the EXPLAIN result : That's because the MySQL optimizer converts your distinct into a group by. Read more here:

SV: Trouble compiling 3.23.49 on Redhat 6.2

2002-04-14 Thread Carsten Gehling
Fra: Simon Byrnand [mailto:[EMAIL PROTECTED]] Sendt: 15. april 2002 04:00 I'm currently running MySQL 3.23.40 on Redhat 6.2 and its working nicely. It was installed from binary RPM's. I'm not trying to update to 3.23.49, but because the binary RPM's available require GLIBC 2.2 (Redhat

Re: PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Carsten Gehling
From: Russell E Glaue [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 2:20 AM On the mysql-internals mail list we had a thread going about this. I was suggesting something like embedding PERL into MySQL to produce something like PERL/SQL (similar to PL/SQL in oracle). snip Would anyone on

Re: encrypt password

2002-03-03 Thread Carsten Gehling
To examplify this: When you add your user, do it like you do now: insert into a values (password('name')); When the user logs in at a later time, do this: select * from a where pw = password('name'); If no row is selected, no user with that password was found. - Carsten - Original

Re: How can i acheive 'Triggers' in MySQL

2002-02-18 Thread Carsten Gehling
From: sreedhar [EMAIL PROTECTED] Sent: Saturday, February 16, 2002 6:03 AM How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. By sitting tight and waiting, just like the rest of us :-) http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html - Carsten

Re: MySQL on the Playstation2? (OT? You betcha)

2002-01-31 Thread Carsten Gehling
From: Colin Faber [EMAIL PROTECTED] Sent: Thursday, January 31, 2002 7:07 AM I think a better question would be why ;-) To quote our beloved Basil Fawlty: Do you think this is what made the British Empire great? When asked why anyone would want to climb Mount Everest, George Lee Mallory

Re: Bug in UNIQUE?

2002-01-31 Thread Carsten Gehling
From: Paul DuBois [EMAIL PROTECTED] To: Jude Insley [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Bug in UNIQUE? The SQL below illustrates what I believe is a bug in MySQL up to and including 3.23.47. Essentially I need a unique key where one or more of the component fields of the unique

Re: MATCH vs LIKE

2002-01-15 Thread Carsten Gehling
- Original Message - From: Peter Dunham [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 12:03 PM Subject: MATCH vs LIKE I am trying to speed up keyword searches using MATCH AGAINST instead of like, but am getting unexpected results. I had assumed that

Re: what is the limit for max_packet_size?

2002-01-14 Thread Carsten Gehling
- Original Message - From: Jenny [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 5:14 AM Finally i able to retrive image from MYSQL database via VB6.0. However, i can only retrieve image where the size is greate than 17kb and less then 32KB. I have try to increate my

Very large mysqld processes

2002-01-12 Thread Carsten Gehling
Maybe it's just me, but I find that my mysqld proccesses consume quite a lot of memory. 7584 KB each to be exact. I've installed MySQL using the RPM on mysql.com (and I don't use the MAX version). I haven't made any config file, just installed it and let it run. Can I do anything about it? It's

Re: Very large mysqld processes

2002-01-12 Thread Carsten Gehling
- Original Message - From: Dan Nelson [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 11:23 PM In the last episode (Jan 12), Carsten Gehling said: Maybe it's just me, but I find that my mysqld proccesses consume quite a lot of memory. 7584 KB each to be exact. 7 MB is nothing

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-29 Thread Carsten Gehling
Gehling [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 20, 2001 1:49 PM Subject: Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields Hi! 3.23 (but 4.0 hasn't that bug either). Will be 2.23.40 soon. And have nice trip, btw. On Jul 20, Carsten Gehling

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-20 Thread Carsten Gehling
I'm going to Spain today and cannot respond to any questions in the next week. I was going to wait with this until I got home again, but what the heck ;-) Run the following script through your MySQL on an empty database with mysql -uusername -ppassword dbname scriptname and the last command

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-20 Thread Carsten Gehling
BTW: As I've stated earlier, the error goes away, if you either remove the FULLTEXT index or let the affected fields accept NULL values. - Carsten - Original Message - From: Carsten Gehling [EMAIL PROTECTED] To: Sergei Golubchik [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-20 Thread Carsten Gehling
Which dev. tree is that? 3.23 or 4.0? - Carsten (who hasn't left yet ;-) - Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Carsten Gehling [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 20, 2001 1:22 PM Subject: Re: Bug report: FULLTEXT index corrupts

Re: re-indexing records

2001-07-18 Thread Carsten Gehling
Drop the index and recreate it alter table you-table drop index your-index; alter table you-table create index your-index(fieldlist); - Carsten - Original Message - From: Rory O'Connor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 7:55 AM Subject: re-indexing

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-18 Thread Carsten Gehling
- Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Carsten Gehling [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 16, 2001 6:26 PM Subject: Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields Hi! On Jul 16, Carsten Gehling wrote

Solution (but only a temporary one) Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-18 Thread Carsten Gehling
of the NULL value in RDBMS' - I regard it as a necessary evil to be used sparsely. So it would be great if I did not have to convert my text fields (text varchar) into accepting NULL. - Carsten - Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Carsten Gehling [EMAIL PROTECTED

Problem with FULLTEXT index

2001-07-16 Thread Carsten Gehling
Using MySQL version 3.23.39 on a Win2k server with SP2, I have some problems with the FULLTEXT index. I have a table created like this: CREATE TABLE `visitkort` ( `id` int(10) unsigned NOT NULL auto_increment, `kategori_id` int(10) unsigned NOT NULL default '0', `aktiv` tinyint(3) unsigned

Re: Slightly off-topic... Dump SQL editor thats cross-compatWin/Linux

2001-07-16 Thread Carsten Gehling
You could use VIM (cross-platform) or UltraEdit (Win32), the latter is capable of reading and writing *nix compatible files even though it's only a Win32 program. - Carsten - Original Message - From: Mike Cermak [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday,

Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-16 Thread Carsten Gehling
3 - Fixing index 4 - Fixing index 5 Fix: The error does not occur, if you drop the FULLTEXT index Synopsis: FULLTEXT index corrupts the index with too many TEXT fields Submitter-Id: Originator: Carsten Gehling Organization: Sarum MySQL support: [none] Severity: [serious] Priority: [low | medium

Re: Dump SQL editor thats cross-compatWin/Linux

2001-07-16 Thread Carsten Gehling
at: http://www.code-genie.com/ - Original Message - From: Carsten Gehling [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 16, 2001 6:04 AM Subject: Re: Slightly off-topic... Dump SQL editor thats cross-compatWin/Linux You could use VIM (cross-platform

Re: XML support under mySQL (Long rant)

2001-02-28 Thread Carsten Gehling
From: "Florian G. Pflug" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 1:31 AM I think XML support should not be just "sending the respone of an SQL-Queries written in a weird way as an XML Document as another weird XML Document to the client". It should make the DB-Server into a hugh

Re: Here you have, ;o)

2001-02-13 Thread Carsten Gehling
From: "Jon Haworth" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 5:40 PM Oh no, not another one Mike and James - you fell for the good ol' trick. Bu hu for you - don't you just "love" it? :-) Now whoever made the little bastard this time...? Funny thing actually: My Outlook Express

Re: Large text searches

2001-02-01 Thread Carsten Gehling
From: "Geoff Coffey" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 5:25 PM I am in the process of migrating a site built with FileMaker Pro to MySQL and PHP mostly because filemaker's web capabilities are too limiting. In one situation, we have a database of about 20,000 rows that

Re: win2k

2001-01-18 Thread Carsten Gehling
From: "Tom" [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 11:18 AM I can't seem to get mysql server started on win2k. hell I don't even know which file to run to start it up. I did try all though and nothing seems to work. http://www.mysql.com/doc/N/T/NT_start.html Normally I'm not a

Re: Problem when I want to set password to root user

2001-01-16 Thread Carsten Gehling
From: "Michel Tignyemb" [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 4:33 PM Here is the command : mysqladmin -u root -p password 'mysql' Remove the space between -p and password: mysqladmin -u root -ppassword mysql - Carsten