Migrating a number of sites to MS SQL 7 from Access. The first thing I
notice is that the ODBC driver for SQL server throws an error if you tell it
to store too many characters in a varchar field. With Access, the ODBC
driver (or some other entity) truncated the data as needed and went on it's
merry way.
So, is there a simple workaround? Can MS SQL 7, or it's ODBC driver be told
to truncate excessively long character strings? I've got a LOT of forms and
form-handlers to modify if there's no alternative. I'm also not very keen
on hard-coding all those field-length values into my CF templates. It also
adds a fair amount of overhead if within your SQL code you're using CF
functions to truncate every character field, as in:
city = '#Left(form.city, 30)#',
Jim
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
