If I use
select * from table1
how can I know rs(0) 's field name & data type?
for more properties
MCDBA, MCSD, MCSE
Internet Database Architect
Keybright Services Ltd
'Databases for the Internet'
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
text is slow...use varchar
text will always block off that amount of memory no matter how much text is
actually in the field, such as if you allocate 500 characters for the field
the text type always gives you 500 even if the field has 1 character in it
varchar will allocate 1 for 1 character, 2 for 2, etc.