MDB2 escape question

[drew]

I just started using the MDB2 library and I'm trying to use it in our form creation tool. The tool stores templates in an SQL Server 2000 database. The templates contain HTML and field placeholders which look like %FIELD_fieldName%. If I use the MDB2 escape function on these templates I end up with extra brackets([,]) around the % and _ symbols.

I can see that these are the wildcards defined in MDB2_Driver_Common. I'd like to use the escape function to take care of any single quotes that are in the strings, but I can't have all these extra brackets that keep multiplying each time a template is saved.

My question is, what is the correct way to store strings with wildcard characters using MDB2? Do I need to not use the escape function or is there a corresponding unescape that I need to use when I retrieve the data?

Thanks for your help,
Drew

[mark]

Using quote() seems to be more reasonable for your case:
http://pear.php.net/manual/en/package.database.mdb2.intro-quote.php

[drew]

Yes, that is what I needed.

Thanks