[thelist] don't know what this SQL does...

[Aaron Holmes]

Hi Walter,

Which database are you using?

In MySQL for instance, the password() function is used on queries to
insert a password hash. I won't go into detail, but look at
http://www.mysql.com/doc/en/Password_hashing.html if you want to know
more.

You can also use other functions in this manner ( ie. Now() and md5()
etc.)

HTH!
 
Sincerely yours, 
 
Aaron Holmes
CEO
Gurix Web Professionals
Welland, Ontario
Canada
 
Corporate e-mail: aholmes at gurix.com
 
V: 905.324.3241
F: 905.734.1398
http://www.gurix.com
 
Subscribe to "Balancing Today's Technology," our free, monthly,
electronic newsletter about using technology in business by e-mail to: 
join-todaystech at gurix.com
 

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of jsWalter
Sent: Saturday, August 30, 2003 4:02 PM
To: thelist at lists.evolt.org
Subject: [thelist] don't know what this SQL does...


UPDATE authuser SET passwd=password('$password')

OK, will I sort of know waht it does.

But I never saw that passwd=password('$password')  command before

Can someone explain it to me?

thanks

walter

PS: This came from PH script I'm fiddeling with.


-- 
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !