Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL string

Status
Not open for further replies.

khue

Programmer
Joined
Mar 6, 2001
Messages
112
Location
US
how long can a SQL string be? Is it dependent upon OS's. If so, then how long can a SQL string be for SQL Server 7?
 
The sql string is basically dependant on the database.

However, coldfusion doesn't handle lists longer than 1000 items so if you are sending a list of ids (or whatever) and the list gets over 1000, you wil get an error from coldfusion.

For MSSQL, check out the site. (support)

My advice, don't use MS SQL. Down with Bill Gates..

Some alternatives Good news is there are no licensing fees to deal with.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top