It is very simple, just make a .dll with any C++, I especifically use VC++ this time, and define the members of you dll as the documentation says (function_init, function_deinit if used , and function), usin the same scheme and type of parameters the mysql espects to send and receive to/from your function.

Here is the transcription of mi first succed try:

// prueba.h // some definitions

#include <mysql.h>

#ifdef PRUEBA_EXPORTS #define PRUEBA_API __declspec(dllexport) #else #define PRUEBA_API __declspec(dllimport) #endif

#define MY_FUNC_API extern "C" __declspec(dllexport)

// This class is exported from the prueba.dll class PRUEBA_API CPrueba { public: CPrueba(void); // TODO: add your methods here. };

MY_FUNC_API int fnPrueba( UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error);

// prueba.cpp // #include "stdafx.h" #include "prueba.h" #include <mysql.h>

BOOL APIENTRY DllMain( HANDLE hModule, DWORD ul_reason_for_call, LPVOID lpReserved ) { switch (ul_reason_for_call) { case DLL_PROCESS_ATTACH: case DLL_THREAD_ATTACH: case DLL_THREAD_DETACH: case DLL_PROCESS_DETACH: break; } return TRUE; }

CPrueba::CPrueba() { return; }

MY_FUNC_API prueba_init( UDF_INIT *initid, UDF_ARGS *args, char *message) { if (args->arg_count != 1 || args->arg_type[0] != INT_RESULT) { strcpy(message,"Argumentos equivocados\n Uso: Select prueba(int);"); return 1; } return 0; }

MY_FUNC_API prueba_deinit(UDF_INIT *initid) { }

extern "C" my_ulonglong __declspec(dllexport)prueba( UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error) { my_ulonglong val; val = *((my_ulonglong*) args->args[0]); return val+2; // add 2 to the value passed and return te result }

you can download the complete project from here: ftp://ftp.cafeinternet.com.py/udf/prueba.rar (my server is down from late night, about 12:00 pm, till 8:00 AM.)

Once compiled, just place a copy under your windows\system folder, tell you server of the new function: CREATE FUNCTION prueba RETURNS INTEGER SONAME "prueba.dll" and that's all, now you hace a function that every time you call it with a integer it adds to that integer 2 and returns you the result.

Please give me some time if you are ineterested in the Zeosudf I have ported to Windows, to contact with the people from Zeos about the license, to port the rest of the functions and document the changes, I just used the code I needed.