REborn

12/20/2009 19:44 conquer93#1

Help,

I try reborn system for janvier and it login flag error.

WHERE (login_flag0 = 1100);

Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'WHERE'.

12/20/2009 20:57 janvier123#2

remove ;

12/20/2009 21:18 *JayKay*#3

Quote:

Originally Posted by conquer93

Help,

I try reborn system for janvier and it login flag error.

WHERE (login_flag0 = 1100);

Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'WHERE'.

correct is:

PHP Code:


			
USE [account];

GO



UPDATE dbo.user_profile

SET login_flag = 0 

WHERE (login_flag = 1100);