$d->select(-sql=$sql) has limit of 50?
- 1 Messages
- Collapse All
- Expand All
- Subscribe
Dec 24
Steve Piercy - Web Site Builder $d->select(-sql=$sql) has limit of 50?
Dec 24, 2010; 05:33
Steve Piercy - Web Site Builder
$d->select(-sql=$sql) has limit of 50?
// knop method
$d->select(-sql=$sql);
log_critical($d->action_statement);
log_critical($d->maxrecords_value);
// inline method
inline(cnxn,-sql=$sql);
log_critical(action_statement);
log_critical(maxrecords_value);
log_critical(found_count);
/inline;
=>
[12/24/10 05:20:20] SELECT * FROM d.t
WHERE
`c` LIKE '%foo%'
[12/24/10 05:20:20] 50
[12/24/10 05:20:20] 107
[12/24/10 05:20:20] SELECT * FROM d.t
WHERE
`c` LIKE '%foo%'
[12/24/10 05:20:20] -1
[12/24/10 05:20:20] 107
WTF? There is no limit clause in my SQL statement, but Knop
says the maxrecords_value is 50, whereas in the inline it is
-1? How is that even possible? How can I force Knop to use maxrecords=all?
--steve
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy Web Site Builder
Soquel, CA
<web@StevePiercy.com> <http://www.StevePiercy.com/>
--
#############################################################
This message is sent to you because you are subscribed to
the mailing list <knop@lists.montania.se>.
To unsubscribe, E-mail to: <knop-off@lists.montania.se>
Send administrative queries to <knop-request@lists.montania.se>
List archive http://www.nabble.com/Knop-Framework-Discussion-f29076.html
Project homepage http://montania.se/projects/knop/
Google Code has the latest downloads at http://code.google.com/p/knop/
$d->select(-sql=$sql);
log_critical($d->action_statement);
log_critical($d->maxrecords_value);
// inline method
inline(cnxn,-sql=$sql);
log_critical(action_statement);
log_critical(maxrecords_value);
log_critical(found_count);
/inline;
=>
[12/24/10 05:20:20] SELECT * FROM d.t
WHERE
`c` LIKE '%foo%'
[12/24/10 05:20:20] 50
[12/24/10 05:20:20] 107
[12/24/10 05:20:20] SELECT * FROM d.t
WHERE
`c` LIKE '%foo%'
[12/24/10 05:20:20] -1
[12/24/10 05:20:20] 107
WTF? There is no limit clause in my SQL statement, but Knop
says the maxrecords_value is 50, whereas in the inline it is
-1? How is that even possible? How can I force Knop to use maxrecords=all?
--steve
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy Web Site Builder
Soquel, CA
<web@StevePiercy.com> <http://www.StevePiercy.com/>
--
#############################################################
This message is sent to you because you are subscribed to
the mailing list <knop@lists.montania.se>.
To unsubscribe, E-mail to: <knop-off@lists.montania.se>
Send administrative queries to <knop-request@lists.montania.se>
List archive http://www.nabble.com/Knop-Framework-Discussion-f29076.html
Project homepage http://montania.se/projects/knop/
Google Code has the latest downloads at http://code.google.com/p/knop/
Dec 24
Bil Corry Re: $d->select(-sql=$sql) has limit of 50?
Dec 24, 2010; 09:13
Bil Corry
Re: $d->select(-sql=$sql) has limit of 50?
Dec 24
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 24, 2010; 14:43
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 24
Bil Corry Re: $d->select(-sql=$sql) has limit of 50?
Dec 24, 2010; 18:59
Bil Corry
Re: $d->select(-sql=$sql) has limit of 50?
Dec 25
Jolle Carlestam Re: $d->select(-sql=$sql) has limit of 50?
Dec 25, 2010; 08:35
Jolle Carlestam
Re: $d->select(-sql=$sql) has limit of 50?
Dec 25
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 25, 2010; 15:51
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 25
Bil Corry Re: $d->select(-sql=$sql) has limit of 50?
Dec 25, 2010; 16:49
Bil Corry
Re: $d->select(-sql=$sql) has limit of 50?
Dec 26
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 26, 2010; 02:11
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 26
Johan Solve Re: $d->select(-sql=$sql) has limit of 50?
Dec 26, 2010; 18:24
Johan Solve
Re: $d->select(-sql=$sql) has limit of 50?
Dec 26
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 26, 2010; 15:37
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 26
Bil Corry Re: $d->select(-sql=$sql) has limit of 50?
Dec 26, 2010; 16:34
Bil Corry
Re: $d->select(-sql=$sql) has limit of 50?
Dec 26
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 26, 2010; 19:42
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
Johan Solve Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 09:00
Johan Solve
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
list Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 09:46
list
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 04:54
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 05:02
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
Johan Solve Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 14:33
Johan Solve
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
list Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 15:00
list
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 06:52
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 07:06
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
list Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 16:08
list
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
list Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 16:19
list
Re: $d->select(-sql=$sql) has limit of 50?
Dec 27
Steve Piercy - Web Site Builder Re: $d->select(-sql=$sql) has limit of 50?
Dec 27, 2010; 07:47
Steve Piercy - Web Site Builder
Re: $d->select(-sql=$sql) has limit of 50?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!