On Wed, 23 Mar 2005 16:02:11 -0800 (PST), Jeff Levitt <[EMAIL PROTECTED]> wrote: > > Andrew, did you attach your patch? I didnt see it on > the email.
Whoops! Attached inline: andrew Index: src/ref/rrefsqlj1083019.dita =================================================================== --- src/ref/rrefsqlj1083019.dita (revision 158820) +++ src/ref/rrefsqlj1083019.dita (working copy) @@ -36,7 +36,7 @@ parameters in the list. <codeblock><b>WHERE ? NOT IN (?, ?, 'Santiago') <ph>-- types assumed to be CHAR</ph></b></codeblock></li> <li>Use in the values list in an IN predicate is allowed if the first operand -is not a dynamic parameter or its type was determined in rule <xref href="#rrefsqlj1083019/sqlj30695"></xref>. +is not a dynamic parameter or its type was determined in rule <xref href="rrefsqlj1083019.dita#sqlj30695">3</xref>. Type of the dynamic parameters appearing in the values list is assumed to be the type of the left operand. <codeblock><b>WHERE <b><i>FloatColumn</i></b> IN (?, ?, ?) <ph>-- types assumed to be FLOAT</ph></b></codeblock></li> @@ -79,7 +79,7 @@ list of an INSERT statement. The type of the dynamic parameter is assumed to be the type of the target column. A ? parameter is not allowed by itself in any select list, including the select list of a subquery, unless there -is a corresponding column in a UNION (see no. <xref href="#rrefsqlj1083019/sqlj20756"></xref>, +is a corresponding column in a UNION (see no. <xref href="rrefsqlj1083019.dita#sqlj20756">16</xref>, below) that is not dynamic. <codeblock><b>INSERT INTO t VALUES (?) <ph>-- dynamic parameter assumed to be the type -- of the only column in table t</ph>
