David Bear,您好! yes.of course. you should insert the record like this: insert into person3 (asuid, fname, lname, addedby, addedon, slopbucket) values ('123455', 'name', 'name', 'entered', '12/12/2004', ''); ======= 2005-06-24 08:12:03 您在来信中写道:======= >I guess I'm too stupid to see the error, but I don't understand why >the following fails. > > >insert into person3 (asuid, fname, lname, addedby, addedon, >slopbucket) values ("123455", "name", "name", "entered", "12/12/2004", NULL); >ERROR: column "123455" does not exist > >is the double quote byting me? >-- >David Bear >phone: 480-965-8257 >fax: 480-965-9189 >College of Public Programs/ASU >Wilson Hall 232 >Tempe, AZ 85287-0803 > "Beware the IP portfolio, everyone will be suspect of trespassing" > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > = = = = = = = = = = = = = = = = = = = = 致 礼! 李江华 ljh1469@xxxxxxxxxxxxxxx 2005-06-24