I use the following code to get column sizes: http://fabio.pastecode.com/1445
Then I encapsulate it into a helper: http://fabio.pastecode.com/1446 -- Fábio David Batista [EMAIL PROTECTED] http://nerd-o-matic.blogspot.com On 7/14/06, Zhi Wen Wong <[EMAIL PROTECTED]> wrote: > hey, how u doing. how to get the length of varchar type column? I need to > find the max length for validation in user input text box. > > like > > create table MyTable > ( > id int, > name varchar(40) > ); > > so, how to get "name"'s length? (which is 40) > > Thank you. I searched the emails but can't find anything. Have a nice day. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ CastleProject-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/castleproject-users
