RE: [PHP-DB] Random Password Generation/MSSQL

> -----Original Message----- > From: Ryan Marrs [mailto:rmarrs@strtrade.com] > Sent: Thursday, July 12, 2001 1:54 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Random Password Generation/MSSQL > > > Having an issue with this script, the generator works if I > just echo out the password, however when I attempt to update > the table, it times-out in IIS. I've bumped the IIS Timeout > up to over 20 minutes, and it still times out. This is on a > database with approximately 29,000 entries. Any ideas? > > [snip] > > for($i=1;$i<=$count;$i++){ > $DUNSNumber=$row->DUNSNumber; > > echo rand_pass()."<br>"; I bet if you echo $insertquery right here, you won't see what you were expecting to. (Hint: $password and $DUNSNumber aren't set when you give $insertquery its value; neither is the string updated for each iteration of this loop.) > MSSQL_QUERY($insertquery); > } Perhaps that's not the entire problem, but it can't be helping...if nothing else, once that's corrected maybe you can start looking at doing those updates in smaller batches. 20 minutes does seem a bit extreme, but then it's hard to make much of a judgment on that without knowing more about the machine in question, what else it's being used for besides sql services, how heavily it's being utilized, etc. --- Mark Roedel | "Nothing in life is so bad that it cannot be Systems Programmer | made much, much worse by the addition of LeTourneau University | lots of spikes and razors." Longview, Texas, USA | -- Sean Kozma