Page 1 of 1

MySQL ENCODE() question

Posted: Wed Jul 28, 2004 2:27 pm
by tylerg
I'm getting an error in my SQL syntax, can't figure out where it is... can anyone spot it?


insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode(administrator1,'tyler1'))

and I tried

insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('administrator1','tyler1'))

and

insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('tyler1','administrator1'))

and

insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('tyler1',administrator1))


???


edited by : infolock
Moved to databases

Posted: Wed Jul 28, 2004 2:34 pm
by feyd
you have 5 values passed, but you are saying you are inserting 6..

cheers -

Posted: Wed Jul 28, 2004 4:51 pm
by tylerg
you were right! and I realized that I also had 2 mySQL quotes closing values, rather than regular single '

thnx