Update loop problem 1

[clivehenderson]

I have an update statement that updates a field in each record in a recordset to a random value using a function.

The problem is that it creates a random number for the first receord and carries on using it for all the others.
Iss there a way of forcing the statement to call the function freshly each time or am I missing something fundamental?
Any help appreaciated

The statement is like this:
Thanks
Clive

UPDATE tblMembers2 SET tblMembers2.mSecKey= tNG_generateRandomString(16) WHERE tblMembers2.mID>0;

 

[ingresman]

what happens is you call tng_generaterandomstring multiple times;
I thought it might be sonmething to do with the where clause getting the roes and then applying the first value it got to all rhe mSecKey in the resuklt set. I playted with rand() which generates a different value each time.
Can you try using rand(), you might have to fiddle with the convert() or cast() functions to get it to work though

 

[feherke]

Hi

ingresman, take a look at clivehenderson's previous thread434-1526839. tng_generaterandomstring() seems to be a PHP function, so it is called only once when composing the string with the SQL query.

It would be better to rewrite it in MySQL. ( Visit forum436 for help. )

Feherke.

http://rootshell.be/~feherke/

 

[jpadie]

$sql = "UPDATE tblMembers2 SET tblMembers2.mSecKey= ".tNG_generateRandomString(16)." WHERE tblMembers2.mID>0;";