Calling plugin (database) functions from an alias

Posted by Quagmyre on Fri 09 May 2003 07:20 AM — 2 posts, 12,902 views.

#0
Hi all,
I'm writing a database script that needs to programmaticly query the db and then create a new query based on the result. In trying to work out how to use this, I had a look at the MudDatabase plugin code and I think I need to call ExecuteQuery from my own script.

I couldn't work out how to do this however. I don't think I can use CallPlugin because I need to be able to pass the variables by reference, rather than by value (I assume).

Any help here (in Javascript preferably) would be muchly appreciated.

Thanks
Quagmyre from Discworld (discworld.imaginary.com:23)
Australia Forum Administrator #1
You can't use CallPlugin for ExecuteSQL anyway because it expects routines in the plugin to have a single argument.

However you should be able to use CallPlugin for DoSQL (to execute a command like 'create table') or DoQuery (to do a query).

If you want to get the results back you might have to modify the ideas in that plugin a bit.