Gossamer Forum
Home : General : Databases and SQL :

Access query using a custom function causing problems

Quote Reply
Access query using a custom function causing problems
I have an MS-Access query wich calls a custom function in a module to remove the accents in the first character of a field in order to group them properly in a ColdFusion application.

The query works just fine when I view it in Access itself but if I try to call that query from a ColdFusion application, it says the function is undefined.

Is it even possible to use the results of a query calling modules in the Access DB from ColdFusion?

If not, then does anyone know how I can have CF list my entries by (let's say...) title, regardless of accents?

At the moment I group my resuslts by the first letter but something like "É" would be listed after the "E"... I want both to be grouped under the "E"...

Thanks.