Mysql UDF

2004-03-30 Thread Prem Soman
HI! I wrote a mysql UDF that works well in older versions of mysql (3.23.*) but the same is not working for new versions like (4.0*) . The server restarts every time i invoke my function . I also compiled and linked with libmysqlclient.so.11, but still the problem persists. how to solve the

Re: mysql UDF in windows

2003-12-04 Thread miguel solorzano
At 11:45 4/12/2003 +, Prem Soman wrote: Hi, how can i resolve this and what the prototype for functions that returns integer values. i searched the manual but got no solution. In the \sql\udf_example.cpp you find: #ifdef __WIN__ typedef unsigned __int64 ulonglong; /* Microsofts 64 bit typ

mysql UDF in windows

2003-12-04 Thread Prem Soman
i find problem while compiling the UDF in windows. the function returns an integer and so i set the type as "long long" but this datatype is not recognised by VC++ 6.0 and i end up with a compilation error. how can i resolve this and what the prototype for functions that returns integer values

MySql UDF under WIN32

2002-10-10 Thread FABIAN VON ROMBERG
Hi, I finally could get MySql UDF functions to work under win32 (VC++). The only thing that concerns me is that it nevers returns any error message. It works fine, but none error message is displayed. The function expects 2 strings, if one, more or none is passed, I should get the error

Re: MySQL UDF questions

2002-04-11 Thread Georg Richter
On Thursday, 11. April 2002 10:26, Fei Chen wrote: > Dear Georg, > > > * notation. Just as normally I can say > select * from myTable; > can I write a UDF to handle > select my_udf(*) from myTable; ? > There is the builtin function > select count(*) from myTable; > But the manual does not say how

Re: MySQL UDF questions

2002-04-11 Thread Fei Chen
Dear Georg, Thanks for replying. I have read the mysql manual but unfortunately have not been able to find the answer. I realize UDFs can have field names as their parameters, as in select my_udf(fld1, fld2, fld10) from myTable; but here the field names have to be specified explicitly. What I'm w

Re: MySQL UDF questions

2002-04-10 Thread Georg Richter
On Thursday, 11. April 2002 02:11, Fei Chen wrote: > How do I write a UDF to handle a entire tuple, e.g. is it possible to have > select my_udf(*) from myTable; > ? Parmeters in the UDF could also be fields from a table. > Also, is there a way for a UDF to return a data structure, say, a multi

MySQL UDF questions

2002-04-10 Thread Fei Chen
Dear all, I'm new to writing UDFs in MySQL so please bear with my couple of questions. How do I write a UDF to handle a entire tuple, e.g. is it possible to have select my_udf(*) from myTable; ? Also, is there a way for a UDF to return a data structure, say, a multi dimensional array? Or do I n