SQL Server 2008 can't update

SQL Server 2008 can't update

jpavanjpavan Posts: 38Questions: 12Answers: 0

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.

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 61,452Questions: 1Answers: 10,055 Site admin

    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

  • jpavanjpavan Posts: 38Questions: 12Answers: 0

    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.

  • allanallan Posts: 61,452Questions: 1Answers: 10,055 Site admin
    Answer ✓

    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

This discussion has been closed.