Hi all \r\n \r\nI am using AdoDB objects and MySQL. When I try to get the length of a field using the defined size property of the recordset object it works fine, but when the fields is a varchar, i only get the length of the largest field i have in the database \r\n \r\nfor example, i have a field that is a varchar(100), but the defined size returns me 5 if I the largest field that I have is "Hello" \r\n \r\nIs this normal, and, there is a way to get the real defined size of the field? \r\n \r\n \r\nThanks
I am using AdoDB objects and MySQL. When I try to get the length of a field using the defined size property of the recordset object it works fine, but when the fields is a varchar, i only get the length of the largest field i have in the database
for example, i have a field that is a varchar(100), but the defined size returns me 5 if I the largest field that I have is "Hello"
Is this normal, and, there is a way to get the real defined size of the field?
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET. subscribe