Stored function problem

Hi All, I have a problem that I do not quite understand. I have a table with individuals: CREATE TABLE `individual` ( `ident` mediumint(8) unsigned NOT NULL auto_increment, `fid` mediumint(8) unsigned NOT NULL, `iid` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`ident`), KEY `fidiid`

RE: Function problem

06 6:02 PM To: mysql@lists.mysql.com Subject: Re: Function problem On Thursday 07 December 2006 04:57, nikos wrote: > WHEN x<50 THEN ceiling(x+x*0.25) > > when x>=50 AND x<100 then ceiling(x+x*0.20) > > when x>=100 AND x<150 then ceiling(x+x*0.15) > > when

Re: Function problem

On Thursday 07 December 2006 04:57, nikos wrote: > WHEN x<50 THEN ceiling(x+x*0.25) > > when x>=50 AND x<100 then ceiling(x+x*0.20) > > when x>=100 AND x<150 then ceiling(x+x*0.15) > > when (x>=150 AND x<200) then (ceiling(x+x*0.10)) > > when (x>=200) then (ceiling(x+x*0.09)) You've declared a ret

Re: Function problem

> Can somebody tells what's wrong with this fuction? I guess that depends on what it should do, wouldn't it? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development ques

Function problem

Hello list. Can somebody tells what's wrong with this fuction? DELIMITER $$ DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$ CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS float(7,2) BEGIN CASE x WHEN x<50 THEN ceiling(x+x*0.25) when x>=50 AND x<100 then ceiling(x

Re: CREATE FUNCTION problem

Matt - Original Message - From: "George Chelidze" Sent: Monday, October 27, 2003 9:18 AM Subject: CREATE FUNCTION problem Hello, I have created new udf function which converts time from NTP format to timestamp. I compile it with the following command: gcc -Wall -shared -o n

Re: CREATE FUNCTION problem

Hi George, I think the MySQL-Max RPM is dynamically linked (all -max binaries actually) if you want to give it a try. Hope that helps. Matt - Original Message - From: "George Chelidze" Sent: Monday, October 27, 2003 9:18 AM Subject: CREATE FUNCTION problem > Hello, I

CREATE FUNCTION problem

Hello, I have created new udf function which converts time from NTP format to timestamp. I compile it with the following command: gcc -Wall -shared -o ntp2timestamp.so ntp2timestamp.cc with no errors. Then I copy this file to /usr/local/mysql (libmysql* files are located here and /etc/ld.so.co

Re: PASSWORD() function problem

Thanks all, it helped me a lot Manisha - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16,

Re: PASSWORD() function problem

t; Sent: Thursday, October 16, 2003 16:13 Subject: Re: PASSWORD() function problem > all encryption functions are one way only > > Nitin > > - Original Message - > From: "Manisha Sathe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> >

Re: PASSWORD() function problem

"Manisha Sathe" <[EMAIL PROTECTED]> wrote: > thanks all, it works (i just increase it to 20) Please, don't use PASSWORD() function in your own application, use MD5() or SHA1() instead. > but one more thing, now if i want to get this password (e.g for option > forget password), can we retrieve, i

Re: PASSWORD() function problem

- From: "Manisha Sathe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 15:16 Subject: Re: PASSWORD() function problem > thanks all, it works (i just increase it to 20) > but one more thing, now if i want to get this password (e.g

Re: PASSWORD() function problem

all encryption functions are one way only Nitin - Original Message - From: "Manisha Sathe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 6:46 PM Subject: Re: PASSWORD() function problem > thanks all, it works (i just increase

Re: PASSWORD() function problem

: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 15, 2003 11:05 PM Subject: Re: PASSWORD() function problem > At 17:26 +0800 10/15/03, Manisha Sathe wrote: > >Hi, > > > >I inserted one record thr PHPMyAdmin - mem_pass f

Re: PASSWORD() function problem

At 17:26 +0800 10/15/03, Manisha Sathe wrote: Hi, I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz using function 'PASSWORD' Then trying to select the same - select * from member where mem_pass = PASSWORD('xyz') - then it is not getting selected I do not know w

Re: PASSWORD() function problem

On Wed, 15 Oct 2003 17:26:23 +0800 "Manisha Sathe" <[EMAIL PROTECTED]> wrote: > Hi, > > I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz > using function 'PASSWORD' > > Then trying to select the same - select * from member where mem_pass = > PASSWORD('xyz') - t

PASSWORD() function problem

Hi, I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz using function 'PASSWORD' Then trying to select the same - select * from member where mem_pass = PASSWORD('xyz') - then it is not getting selected I do not know why I am not getting the result. please help me

RE: mySQL INSTR function problem

3.23.35-log reports it correctly. Cal http://www.calevans.com -Original Message- From: Gordon Werner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:01 PM To: [EMAIL PROTECTED] Subject: mySQL INSTR function problem Hi there ... I am running mySQL Ver. 9.33 Distrib

mySQL INSTR function problem

Hi there ... I am running mySQL Ver. 9.33 Distrib. 3.22.25 and I have run into the following problem. When I type: mysql> select INSTR('foobarbar', 'bar'); it outputs +---+ | INSTR('foobarbar', 'bar') | +---+ | 7 | +