textfield and database

[t3mh4]

hi,
how can i insert my values from textfiels to database,just i need the query.i try something but it gives error like that
query="insert into country values('"+txtStdName.toString()+"')";
error is "value too long for type character varying(40)"
thanks for helping

[Eku]

Can you post the Sql command you've used to create the table country?

[danielstoner]

Yes, check the size for your table's columns.