SQL command too large

Post Reply
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

SQL command too large

Post by barry.marcus »

Is there a limit to the size of a sql command in a Vortex script? If there is, I don't see a reference to it in the documentation. We're getting the error "SQL command too large".
User avatar
mark
Site Admin
Posts: 5515
Joined: Tue Apr 25, 2000 6:56 pm

SQL command too large

Post by mark »

I think the limit is 8k. In general you should never hit that limit if you're using parameters instead of putting literals into the query. Parameters are also safer as they don't need escaping to avoid SQL errors and side effects.
Post Reply