scottybwoy
01-18-2007, 11:01 AM
Hi All,
Having a problem inserting into MSSQL 2005. Whenever I try to insert into just a few colums like so :
"INSERT INTO client ("custId", "clientId", "userId", "client", "dEmail", "dTel") VALUES ('TES000', 'TE0000', 3, 'TEST', 'test@test.com', 01234567890)"
It always retuns : PHP Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'client'. (severity 16)
Now it's fine if I make a fix where it inserts values of NULL in the ommited values case, but if I want to just insert a few and specify the cols, it always returns the above. UPDATE works fine. Any pointers, really wanna have this working instead of my workaround. thanks
Having a problem inserting into MSSQL 2005. Whenever I try to insert into just a few colums like so :
"INSERT INTO client ("custId", "clientId", "userId", "client", "dEmail", "dTel") VALUES ('TES000', 'TE0000', 3, 'TEST', 'test@test.com', 01234567890)"
It always retuns : PHP Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'client'. (severity 16)
Now it's fine if I make a fix where it inserts values of NULL in the ommited values case, but if I want to just insert a few and specify the cols, it always returns the above. UPDATE works fine. Any pointers, really wanna have this working instead of my workaround. thanks