I see your point. I may also hit some ASP limit. I'm using OleDB not ODBC but the same applies I guess. Maybe I'll have to be conservative and just put some kind of arbitrary limit myself and warn them beforehand.
Of course, if ASP/VBS had a decent error handling system that would not be a problem.
>>>>>>>>>>>>>>>>>>>>
All I could find was "SQL string length (batch size) 128 KB " Now, I don't know if the ODBC has a limit or an ASP statement, you may want to look their next. Sorry I don't have a simple answer for your question.
>>>>>>>>>>>>>>>>>>>>