How to call a stored procedure from a stored function with parameter?

ithin an Sql window it works perfectly like this: CALL `IsProductInForeignDatabase`(1, @w,'question'); SELECT @w; If it worked the end of the function would be "return MyResult". Thank you in advance Zsolt Csillag www.egyediszoftverek.hu www.starsoft.hu

Re: Function returns with NOTHING in a particular database

. Another thing: if I change the result type from float(5,2) to Integer it will work. But I need float type. Thank you Zsolt On 5/8/07, Paul McCullagh <[EMAIL PROTECTED]> wrote: Hi Zsolt, The problem probably has something to do with an exception that is not handled. Try using a curso

Function returns with NOTHING in a particular database

u very much for your help. -- Zsolt Csillag

How can I detect if MySql is already installed?

Hello, I would like to create a setup program for my demo version that uses MySql database. I need to detect if the target computer has already got the MySql installed because I don't want to ruin an existing database. Is there any method to detect it? Thank you in advance -- Zsolt Csillag

How to shutdown mysql from Java

Hi, my application starts mysqld (via Runtime.getRuntime().exec) and I would like to stop it also from Java (because of technical reasons I cannot use mysqladmin). What is the best way stop shutdown mysqld? 1. FLUSH TABLES 2. Process.destroy() 3. kill PID auf Unix What do you think? Zsolt

Re: mysql 5.0 and utf8 letters inside

Zsolt Branyiczky wrote: Hi, I installed mysql-essential-5.0.18-win32.msi (under Win XP) in order to use it with Bugzilla. Since I had some problem with importing old Bugzilla dumps containing some special hungarian vowels (they are outside of latin1 characterset), I checked how mysql stores

mysql 5.0 and utf8 letters inside

codes (with 2 bytes length per hungarian special vowel), so I do not know why MySQL 5.0 stores these vowels differently than MySQL 4.1. Regards Zsolt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Resultset.getBinaryStream memory

Hi, I have to read a lot of BLOBs from the database. Does Resultset.getBinaryStream store the blob into memory? Zsolt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Találkozó a következővel: 'MySQL List'

BEGIN:VCALENDAR PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN VERSION:2.0 METHOD:REQUEST BEGIN:VEVENT ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:[EMAIL PROTECTED] ORGANIZER:MAILTO:[EMAIL PROTECTED] DTSTART:20040117T11Z DTEND:20040117T113000Z TRANSP:OPAQUE SEQUENCE:0 UID:0400

UFT-8 support under mysql-3.23.5x?

Hi, we use mysql-3.23.5x? under Linux and cannot upgrade to 4.x. Our java applications can store and fetch UTF-8 characters we have problem only with sorting. Any ideas how I can fix the problem? Zsolt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

How to convert a mysql-3.23.5x database to UTF-8

Hi, we have a mysql-3.23.5x database (Linux) that contains a lot of German umlauts. We have to support Asian charters (UTF-8) and how can I convert the database to UTF-8? Zsolt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

UPPER, LOWER bug?

lower case of 193 but the upper case of 225 is 225 !? however, in \share\charsets\latin1.conf it is defined correctly ie 193 is the upper case of 255 and 225 is the lower case of 193 - the behaviour is even stranger if i use a non-default charset on the server eg. hungarian thanks Zsolt Szloboda

Restore all results in a string

. Unfortunately I cannot use the solution described above because the SELECT INTO OUTFILE works only (as far as I know) when the output file does not exist and when the client and server hosts are not the same I cannot delete the output file. Zsolt -- Zsolt Koppany Intland GmbH www.intland.com Schulze

mysql.3.23.35 under Solaris-2.6 (Sparc)

course 35) for Solaris-2.6 Sparc? Zsolt -- Zsolt Koppany Intland GmbH www.intland.com Schulze-Delitzsch-Strasse 16 D-70565 Stuttgart Tel: +49-711-7871080 Fax: +49-711-7871017 - Before posting, please check: http://www