460: Statement length exceeds maximum.

Err · #1 (**permalink**) 01-17-07, 16:31

I've been getting this error for my excessively long SQL statements.

Does anyone know what the row limit is? Does it vary from system to system?

Since I am (mostly) making criteria statements on every line, could I shorten the number of rows by putting more than one criteria statement per line?

That is

Code:

select blah.colors from blah
where colors are in ("blue",
"red",
"yellow",
"purple",
"green",
"orange",
"muave",
"tangerine")

to :

Code:

select blah.colors from blah
where colors are in ("blue",
"red",
"yellow", "purple",
"green", "orange",
"muave", "tangerine")

(You will have to imagine that my list is very long)

Will this work or Must I break it up?

Err · #2 (**permalink**) 01-17-07, 16:56

Well, I can't increase the number of lines by doubling them on the line. The same error occurs.

Internet Services

Web Development

Digital Marketing

Consumer Tech