Max Length of SQL Statement using CFQuery

[LearningSql]

Hi All --

Is there a Maximum Length for a SQL Statement to be passed using the CFQuery tag?

I'm looking for documentation out there on the web and have come up with nothing.

I have CF6.1 and MSSqlServer2K -- all the appropriate patches etc.

Thanks in advance to all that answer.
PJ

 

[Sarky78]

I've never come across a max length for a SQL statement, and I have had some stupidly long statements in the past.

What error are you getting?

Post your code and we'll have a look

Tony