Hi Robby,
Re-reading the docs following Ryan's exposition, I find that all the
information actually is there. There is an example of multiple returns,
but I missed it or misinterpreted it because I expected that it would
work like the other query functions ... only it doesn't.
My suggestion
Maybe another example in the docs somewhere would have helped?
Robby
On Fri, Dec 12, 2014 at 10:05 AM, George Neuner wrote:
> On 12/11/2014 11:53 AM, Ryan Culpepper wrote:
>>
>>
>> Using in-query within a for loop:
>> > (for/list ([(n t) (in-query c "select n, t from numbers")])
>> (li
On 12/11/2014 11:53 AM, Ryan Culpepper wrote:
Using in-query within a for loop:
> (for/list ([(n t) (in-query c "select n, t from numbers")])
(list n t))
'((1 "one") (2 "two") (3 "three") (4 "four") (5 "five"))
Ok, so in-query does return multiple columns as (values ...). That
On 12/11/2014 10:31 AM, George Neuner wrote:
Hi Ryan,
I re-read your message and did some more experimenting.
On 12/10/2014 2:15 PM, Ryan Culpepper wrote:
Could you be turning entire rows into records (perhaps to deal with the issue
below)?
That seems to be precisely what is happening, alth
Hi Ryan,
I re-read your message and did some more experimenting.
On 12/10/2014 2:15 PM, Ryan Culpepper wrote:
Could you be turning entire rows into records (perhaps to deal with the issue
below)?
That seems to be precisely what is happening, although it was forced
because in-query won't a
Forgot to mention 2 other oddities.
1) If there is more than one column, in-query requires parentheses
around the column list. None of the other row returning functions do.
But putting parentheses around * doesn't work ... it doesn't produce an
error but it returns nothing.
2) if you d
Hi Ryan,
I'm confused by your response. What you're saying doesn't match what I
see.
On 12/10/2014 2:15 PM, Ryan Culpepper wrote:
On Dec 10, 2014, at 12:22 PM, George Neuner wrote:
> I'm using 6.0.1 and having problems trying to use in-query.
>
> First: in-query is the only function
On Dec 10, 2014, at 12:22 PM, George Neuner wrote:
> Hi all,
>
> I'm using 6.0.1 and having problems trying to use in-query.
>
> First: in-query is the only function that can use cursors, but, unlike the
> other row returning functions (query, query-rows, query-maybe-row), in-query
> d
8 matches
Mail list logo
