how to get fields length ???

[tyris]

hi all,
i have a VB program that uses a sql server database.
i put a sample of my code :


strSQL = "SELECT ContactLName, ContactAddress, ContactPhWork, ContactMobile, ContactFax, ContactEmail FROM T_CONTACTS WHERE ContactID = 15;"
Set rsTemp = New ADODB.Recordset
rsTemp.Open strSQL, MyConn, adOpenStatic

then i get back the results of my query with this :

CStr(rsTemp.Fields("ContactAddress&quot
CStr(rsTemp.Fields("ContactMobile&quot ...
for each field.

i take them to put them in a web page.
what i need to know is the size of each field, as described in the database.
an exemple :
in the database the size of the field ContactAddress is 200.
so the text box should get 200 characters max too. and if someone changes the size of the field in the database, that should be automaticaly changed in the code. that's why i'd like to know how to get the lenght of a field, is there a varialbe, a property, something that returns the max lenght of each field ???.

any idea ??? X-)
best regards,
elise Best regards,
Elise

 

[culshaja]

What you want to use is the

DefinedSize

property of the feild object. This is the size in bytes of the underlying data,. As long as you are not using Unicode on the server then 1 byte = 1 char.

lngLength = rsMyRecordset("MyField").DefinedSize

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305