Using MSSQL functions instead of MYSQL functions w/autocomplete

Hi,

I'm a newbie with PHP and web development in general so forgive me if I ask something that a more seasoned developer would already know and not need to ask.

However, I'm running SQL Server 2005 and the basic form class is working perfectly with respect to me being able to validate data and then create my own connection to the DB to insert data.

However with "auto-complete plug-in input and MySQL database queries", the following thing happened: I was able to change all of the functions to mssqlXXX from mysqlXXX. If I click on the ellipses (...) I get a drop down list indicating that queries are being executed successfully on the server.

However, if I type in one or two letters next to location, it looks like its processing something and then I get a server timeout issue.

Why is the drop down db driven part working but the other not?

Any thoughts or suggestions would be greatly appreciated!

Thanks,

Jeff

There is a variant of the auto-complete plug-in that uses the Metabase database abstraction API. Metabase supports the most important databases besides MySQL including Microsoft SQL server, Oracle, PostgreSQL, etc..

What is it called / where can we find it?

That plug-in class script is named form_metabase_auto_complete.php and comes with the forms package . Take a look at the test_metabase_auto_complete.php example script. You also need the Metabase package:

phpclasses.org/metabase