On Wed, Aug 15, 2001 at 02:00:31AM -0500, Don Read wrote:
>
> update da_table set password=concat('{crypt}', password);
Duh... That's the smart way to do it. :-) No programming required.
I should probably sleep now.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo F
Perl.
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 15 August 2001 5:04 PM
> To: Michael Bellears
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: insert(append) text to multiple fields..
>
>
> On Wed, Aug
On Wed, Aug 15, 2001 at 04:37:15PM +1000, Michael Bellears wrote:
> Hi,
>
> I have a table with approx 500 encrypted users passwords, and I need
> to insert {crypt} at the beginning of each one ->
>
> eg..
>
> Sample password:
>
> $dfij98unoc8jew9048urf
>
> would become:
>
> {crypt}$df
On 15-Aug-2001 Michael Bellears wrote:
> Hi,
>
> I have a table with approx 500 encrypted users passwords, and I need to
> insert {crypt} at the beginning of each one ->
>
> eg..
>
> Sample password:
>
> $dfij98unoc8jew9048urf
>
> would become:
>
> {crypt}$dfij98unoc8jew9048urf
>
Hi,
I have a table with approx 500 encrypted users passwords, and I need to
insert {crypt} at the beginning of each one ->
eg..
Sample password:
$dfij98unoc8jew9048urf
would become:
{crypt}$dfij98unoc8jew9048urf
Any suggestions are greatly appreciated.
Regards,
Michael
