(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Re: [Alex] build in random order every time?: Edit Log

Here is the list of edits for this post
Oct 1, 2002, 6:28 AM
BryanL
User (100 posts)
Oct 1, 2002, 6:28 AM
Views: 9055
Re: [Alex] build in random order every time?
In Reply To:
You can edit nph-build.cgi and add:

$DB->table('Links')->update ( { Randomizer => \'RAND()' });

Alex, I can't seem to get this to work in nph-build.cgi. I'm running SQL 3.22 and when I insert the above line into the Repair Tables or Build All sub nothing happens to the Randomizer number for the Links.

Is the code above missing a SET command? Also, where would you recommend putting it in nph-build?

It works fine when I run this query: `UPDATE Links SET Randomizer = RAND()` in the SQL Monitor.

Thanks,

Bryan

Last edited by:

BryanL: Oct 1, 2002, 6:29 AM

Edit Log: