using DetailsView control, update works, insert fails

[oaksong]

Here are the commands in the sqlDataSource line.

InsertCommand="INSERT INTO T_ADMIN_LOGIN (ALID, LNAME, FNAME, USERID,
DOMAIN, STATUS) VALUES (S_ADMIN_LOGIN.NEXTVAL, :Lname, :Fname, :Userid,
'AAC', 1)"

UpdateCommand='UPDATE T_ADMIN_LOGIN SET LNAME = :Lname, FNAME = :Fname,
USERID = :Userid, STATUS = :Status where alid=:alid'>

The update works fine. The insert fails with: ORA-01036: illegal
variable name/number

Anyone got any ideas?

TIA
Chris

 

[ReyN]

S_ADMIN_LOGIN

shouldn't this be T_ADMIN_LOGIN?

 

[oaksong]

No. It's an Oracle sequencer, not a table.