|
From: John H. <jh...@im...> - 2011-07-30 16:11:13
|
On Sat, 30 Jul 2011, Aaron Harrison wrote: > Thanks for responding; but that's not really what I'm asking. > > I can fix the query, what I want to know is what the error means, "Too many or too few host variables" means exactly that. "?" is an Informix query parameter token and you provided the server no variable to use for substitution in the query. You generally can't use parameterized queries in interactive SQL query utilities, because there's generally no way to provide the parameter values. If the SQL client does support parameterized queries, then you'll hit "execute" and it will prompt you somehow to provide values for the parameters. The closest equivalent for Squirrel is the standard sqlparam plugin, which looks for :sometext in the query, prompts you for the value to use, and replaces that token with whatever you typed. This is entirely client-side and purely Squirrel syntax, however, as the SQL query with the tokens expanded is what gets sent to the server. As far as I know there is no support for _native_ parameterized queries for any of the backends Squirrel supports. > or how to modify the Informix plugin for Squirrel so that I can see the > procs list in the db browser. That I don't know. I use Informix a lot, but I haven't looked at this particular part of Squirrel so I can't offer any advice. Sorry. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Pork (n): (political) The manifestation of the principle that it is a felony to bribe a legislator, unless you are also a legislator. ----------------------------------------------------------------------- 6 days until the 276th anniversary of John Peter Zenger's acquittal |
