Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Password Problem

Apr 25, 2002, 6:29 AM
minesite
User (357 posts)
Apr 25, 2002, 6:29 AM
Views: 8351
Shortcut
Quote Reply
Password Problem
Hi

I posted this question on another thread in the Links SQL Discussion but it is probably more relevant to this Forum.

Alex posted the following and it works for others but not me.

UPDATE Users SET Password = FLOOR(RAND() * 10000)


All I get is the same 4 digit number on every record.

I'm on a MS SQL Server, could this be the problem.?

Regards

minesite
Subject Author Views Date
Thread Password Problem minesite 8351 Apr 25, 2002, 6:29 AM
Thread Re: [minesite] Password Problem 		Wil 8106 Apr 25, 2002, 6:51 AM
Thread Re: [Wil] Password Problem 		minesite 8089 Apr 25, 2002, 7:26 AM
Post Re: [minesite] Password Problem 		Alex 8030 Apr 25, 2002, 1:13 PM
Post Re: [minesite] Password Problem 		Paul 8058 Apr 25, 2002, 7:23 AM