SQL Server 2008 can't update

jpavan

I try work with SQL Server 2008 R2 but I can't update because the error "SQLSTATE[HY093]: Invalid parameter number: parameter was not defined".

Thanks in advanced.

allan

Could you give me a little more information please?

• Are you using Editor's PHP or .NET libraries here, or your own code?
• Are you using Editor at all?
• What is the code on the server-side?
• What is the code on the client-side?

Allan

jpavan

Hi Allan.
* Editor's PHP.
* Yes, at all.
* The usual php file
* The usual html and js files

I did the following: use your generator to build a similar table, I got put it on my site and it worked!.
However, for various reasons I need to make explicit in the names of the base and table fields corresponding to each column. In the case of MySQL I do indicating "db.table.column" and it works perfectly. In the case of SQL Server I indicate "db.dbo.table.column".
But if I change the columns created by the generator it gives an error saying that there is not "base" in sys.servers.

I will continue investigating.

Best regards,
jorge.

allan

Unfortunately Editor's PHP code won't cope with four levels of identifiers I'm afraid (e.g. db.dbo.table.column) - it only goes to three levels (db or schema / table / column).

Regards,
Allan