Thunderstone Support Forums

When we run a large texis query we are getting an error 266: sql command too large. This is the first time we've ever recieved this type of error. Because we typically run very large queries, we have most of the limits on query size removed. So this is new. What do we need to change to premit the query to run?

Use parameters (or vortex variables) for the data values in your SQL rather than placing them inline.

Instead of (vortex example)
<sql "select * from products where Description like 'golf club'">
use
<$query="golf club">
<sql "select * from products where Description like $query">