I am running a LIKE query in tsql, and when I try the same query in my script I get different answers. Why is that?
Vortex scripts are designed to be run on a web-site, although they can be used for other purposes. To help ensure the smooth running of the web-site Texis applies certain query protection rules while processing Vortex scripts. These are meant to prevent queries that could take significant CPU or I/O from bogging down the machine.
Tsql is intended for command line and administrative use where the user has a better idea of what they are doing so it does not apply the same restrictions.
If you look at the HTML source you will see messages that indicate if query protection changed the query.
http://thunderstone.master.com/texis/ma ... ction&s=.2 points to documentation about query protection.