Updating Internet Security Records

Last Post 19 May 2009 09:54 AM by triley01. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
triley01
New Member
New Member

--
19 May 2009 07:16 AM
Hello, I am trying to update records to make the web login = id, the password = id + last name. However when I try and execute the query I get the following error

Msg 107, Level 16, State 3, Line 1
The column prefix 'name' does not match with a table name or alias name used in the query.

I am thinking it might be bringing in the Name table but not sure. Any help would be greatly appreciated!

UPDATE name_security
SET name_security.Web_login = name.id, name_security.password = dbo.gthash(name_security.id + name.last_name)
WHERE name_security.id = name.id
AND name.status = 'a' AND name.member_type in ('tac','pfc','dfc','fam','ld','pfac')
and name_security.web_login = ''

triley01
New Member
New Member

--
19 May 2009 09:54 AM
I did... you just added name to the update line right?

I get the following

Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ','.

thanks!
You are not authorized to post a reply.

Acceptable Use Policy