I'm using MySQL in combination with ASP VBScript. DreamWeaver automatically inserts the database name prefix to generated SQL. So instead of generating:

Select * from databaseName.tableName

I want DreamWeaver to generate SQL without table name prefix:

Select * from tableName

Any idea how to achieve this?

Thanx

Obviously hand editing it is out I guess?

Try creating you RS in Advanced mode.

I'm currently removing the prefix manually, but when I pass my pages to someone else DreamWeaver either has trouble recognizing the RecordSet or re-generates the prefix. But you've got a point...