Hello, DRH,
On Mon, Mar 2, 2009 at 6:32 PM, D. Richard Hipp wrote:
> The RANDOM() function takes zero arguments. This has always been the
> case. But 3.6.11 has begun to enforce that rule. Prior to 3.6.11,
> the error was ignored.
Oh. That explains it.
Thanks
--
Alberto Simões
_
Hi,
in http://www.sqlite.org/lang_corefunc.html the random() function is
documented as taking no arguments,
So, use
SELECT word FROM dict ORDER BY RANDOM() LIMIT 1;
I tried an older version of sqlite (can't say which, but 3.*), and could
call random() with 0, 1, 2, 3 and 4 parameters. I would b
On Mar 2, 2009, at 1:16 PM, Alberto Simões wrote:
> Hello
>
> I am using random as:
>
> SELECT word FROM dict ORDER BY RANDOM(term) LIMIT 1;
>
> And I am getting:
>
> DBD::SQLite::db prepare failed: wrong number of arguments to function
> RANDOM()(1) at dbdimp.c line 271 at OpenDict.pm line 64.
>
Hello
I am using random as:
SELECT word FROM dict ORDER BY RANDOM(term) LIMIT 1;
And I am getting:
DBD::SQLite::db prepare failed: wrong number of arguments to function
RANDOM()(1) at dbdimp.c line 271 at OpenDict.pm line 64.
(yes, using it through DBD::SQLite, but I do not think that is the p
4 matches
Mail list logo
