Bruce Cowin wrote:
> Strange. Do you know it's the password causing the problem? What if you
> pass an empty string for the password and see if the insert works?
>
>
Good suggestion Bruce, thank you. Did the blank password and still get
the same error therefore possibly I am misunderstanding
The following works fine:-
INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel,
last_login, UserID)
values ('Alfred', 'Stockton', 'alf', 0xd8cc7e40d17aaefd27cd324f7ba91079,
'9', '2006/10/03 13:09:28', '0' )
Therefore problem solved but thanks for the assistance and suggestion
Setembro de 2006 13:56
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] insert md5 password
Hi Alf
> The command now looks like:-
> INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel,
> last_login, UserID) VALUES ('Alf'
Hi Alf
> The command now looks like:-
> INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel,
> last_login, UserID) VALUES ('Alf', 'Stockton', 'alf',
> "0xd8cc7e40d17aaefd27cd324f7ba91079", '9', '2006/09/29 13:29:34', '0')
> but still fails.
What is the error returned? Does the
lt);
>return "[$code] $text";
>}
>
> Tom
>
> -Original Message-
> From: Alf Stockton [mailto:[EMAIL PROTECTED]
> Sent: 29 September 2006 13:11
> To: DvDmanDT
> Cc: php-windows@lists.php.net
> Subject: Re: [PHP-W
:[EMAIL PROTECTED]
Sent: 29 September 2006 13:11
To: DvDmanDT
Cc: php-windows@lists.php.net
Subject: Re: [PHP-WIN] insert md5 password
DvDmanDT wrote:
> Just check why it fails.. mysql_error() returns a string with the last
error
> message..
>
>
Unfortunately this is mssql not mys
DvDmanDT wrote:
> Just check why it fails.. mysql_error() returns a string with the last error
> message..
>
>
Unfortunately this is mssql not mysql..:-(
--
Regards,
Alf Stocktonwww.stockton.co.za
You'll never see all the places, or read all the books, but fortunately,
they'
Just check why it fails.. mysql_error() returns a string with the last error
message..
--
// DvDmanDT
mail: dvdmandt¤telia.com
msn: dvdmandt¤hotmail.com
"Alf Stockton" <[EMAIL PROTECTED]> skrev i meddelandet
news:[EMAIL PROTECTED]
> SMITHT wrote:
>> INSERT INTO Users (FirstName, LastName, Usrn
The relevant PHP code looks like :-
$Surname = strip_tags($_POST['Surname']);
$FirstName = strip_tags($_POST['FirstName']);
$uname = strip_tags($_POST['uname']);
$passwd = strip_tags($_POST['passwd']);
$accesslevel = strip_tags($_POST['accesslevel']);
$passwd = md5($passwd
SMITHT wrote:
> INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel,
> last_login, UserID) VALUES ("Alf", "Stockton", "alf",
> "0xd8cc7e40d17aaefd27cd324f7ba91079", 9, "2006/09/29 12:05:23", 0)
>
> Put the hashed password in as a string.
>
>
The command now looks like:-
INSERT
--Original Message-
From: Alf Stockton [mailto:[EMAIL PROTECTED]
Sent: 29 September 2006 11:46
To: php-windows
Subject: [PHP-WIN] insert md5 password
Using MSSQL database I am attempting to insert a new user into a table
using the following command in PHP:-
INSERT INTO Users (FirstName, LastName,
Using MSSQL database I am attempting to insert a new user into a table
using the following command in PHP:-
INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel,
last_login, UserID) VALUES ('Alf', 'Stockton', 'alf',
0xd8cc7e40d17aaefd27cd324f7ba91079, '9', '2006/09/29 12:05:23', '0
12 matches
Mail list logo
