Re: [sqlite] reuse of named parameters within a single statement

It would be great to include "SELECT @myparam, @myparam, @myotherparam, @myparam" is it equivalent to "SELECT ?1, ?1, ?2, ?1" in the documentation on parameters (in expressions). Thank you, Aron On 5/4/10, Jay A. Kreibich wrote: > On Tue, May 04, 2010 at 01:48:52PM -0400, Aron Rubin scratched o

Re: [sqlite] reuse of named parameters within a single statement

On Tue, May 04, 2010 at 01:48:52PM -0400, Aron Rubin scratched on the wall: > Sorry if this is a repeat but I am having a heck of a time figuring > out a definitive answer to a this question on the list. Certainly it > is not addressed in the documentation. > > Is the following valid string to pre

Re: [sqlite] reuse of named parameters within a single statement

Aron Rubin wrote: > Is the following valid string to prepare: > "SELECT @myparam, @myparam, @myparam, @myotherparam" Yes. > If so, which is it equivalent to: > A - "SELECT ?1, ?1, ?1, ?2" > or > B - "SELECT ?1, ?2, ?3, ?4" A -- Igor Tandetnik ___ s

[sqlite] reuse of named parameters within a single statement

Sorry if this is a repeat but I am having a heck of a time figuring out a definitive answer to a this question on the list. Certainly it is not addressed in the documentation. Is the following valid string to prepare: "SELECT @myparam, @myparam, @myparam, @myotherparam" If so, which is it equival