insert query in sql server

[rj]

When I try to insert a row in the SQL server. I received these warnings :

Warning: mssql_query() [function.mssql-query]: message: Invalid object name
'transactions'. (severity 16) in
C:\aisservice\aisservice\inc\database\mssql.php on line 169

Warning: mssql_query() [function.mssql-query]: Query failed in
C:\aisservice\aisservice\inc\database\mssql.php on line 169
INSERT INTO users (login,domain,email,credit,entrance_bonus)VALUES
('klaas','klaas','klaas',0,6.00)

The record is inserted in the database. But what is wrong? When starting a
SELECT query everthing is running fine. When doing an update same message
appears.

Who can tell me more about this.
Many thanks in advance

Richard

[Tony Clarke]

What code is on line 169?
Try putting single quotations around the numbers eg '0','6.00'

"rj" <[e-mail]> wrote in message
news:nS*****************@amsnews05.chello.com...

When I try to insert a row in the SQL server. I received these warnings :

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'transactions'. (severity 16) in
C:\aisservice\aisservice\inc\database\mssql.php on line 169

Warning: mssql_query() [function.mssql-query]: Query failed in
C:\aisservice\aisservice\inc\database\mssql.php on line 169
INSERT INTO users (login,domain,email,credit,entrance_bonus)VALUES
('klaas','klaas','klaas',0,6.00)

The record is inserted in the database. But what is wrong? When starting a
SELECT query everthing is running fine. When doing an update same message
appears.

Who can tell me more about this.
Many thanks in advance

Richard

[Pedro Graca]

rj wrote:

When I try to insert a row in the SQL server. I received these warnings :

Warning: mssql_query() [function.mssql-query]: message: Invalid object name
'transactions'. (severity 16) in
C:\aisservice\aisservice\inc\database\mssql.php on line 169

Warning: mssql_query() [function.mssql-query]: Query failed in
C:\aisservice\aisservice\inc\database\mssql.php on line 169
INSERT INTO users (login,domain,email,credit,entrance_bonus)VALUES
('klaas','klaas','klaas',0,6.00)

What happens when you type (or copy/paste) the SQL command into the
"Query Analyser" (or whatever it is called) window and execute it?

--
Mail to my "From:" address is readable by all at http://www.dodgeit.com/
== ** ## !! ------------------------------------------------ !! ## ** ==
TEXT-ONLY mail to the whole "Reply-To:" address ("My Name" <my@address>)
may bypass my spam filter. If it does, I may reply from another address!