Prepared Statements, SQL functions and MDB2

[Belisarius]

I'm using MDB2 for database connectivity on a project. I had been using DB, but that's depricated, and I figured there's no point in building something new based on a depricated framework.

Now, one of the things I do is create geo-spatial datapoints and insert them as values for query later. This is a unique datatype that is formed by calling an SQL function - the general format is "PointFromText(<lat> <lon>)".

Now, I want to create a prepared statment out of this, as I have a lot of points to enter. The problem is, I can't seem to use them in MDB2. The result is, according to the debugging output, "PointFromText(? ?)". That's literally it - it doesn't translate the "?" to a value as it does with the rest of the SQL statement. In DB, I used the "!" symbol, and it worked fine, but I can't get it to work under MDB2. I've even created a "types" array, and told it exactly what type it was (float). No joy.

Can anyone give me any ideas short of going back to DB?

[DJMaze]

Just run a query without prepare?

[Belisarius]

I've actually done that as well, but it really irks me I was able to do it with the *deprecated* version, but not the current. Plus, the database overhead is the single largest timesink, and I'd really like to do anything I can to reduce it.