| Index
» Projects
» phpMyEdit
» Bug list
» Bug #69 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000069 |
core / field option |
feature |
always |
2003-04-06 02:53 |
2007-07-04 23:34 |
|
|
|
Reporter |
anonymous |
View Status |
public |
|
|
Assigned To |
nepto |
|
Priority |
normal |
Resolution |
fixed |
Platform |
|
|
Status |
resolved |
Duplicate ID |
0000127 |
OS |
|
|
Projection |
none |
|
Version |
|
|
ETA |
none |
|
Product Version |
0.6.1 |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
Summary |
RFE: Ability to reference non-displayed SQL columns in URL |
|
Description |
I have a table with a bunch of columns:
a b c d e f g
There's not enough room for all of them, so I use 'options'=>'ACV' to hide some of them:
a c e f
But when I create a URL link, I would like to reference fields that are not listed:
http://example.com? this=$a & that=$b
Might this be possible some day? It would require that phpMyEdit present the entire sql result, not just $row[qf1..n]. |
|
Steps To Reproduce |
|
|
Additional Information / Solution |
|
|
Attached Files |
|
|
|
|
Bug Notes |
nepto
2003-04-10 21:57
|
I hope this will be possible one day. |
|
|
michal
2003-08-25 23:14
|
possible patch:
virtual cols with U option (U is close to virtual). define it together with ACVF in 'options'
changes in pme.class.php as to 5.3 release:
add line 184:
function virtual_only($k) { return stristr($this->fdd[$k]['options'],'U'); }
around line 1557:
for ($k = 0; $k < $this->num_fds; $k++) {
$fd = $this->fds[$k];
if ($this->displayed[$k]) {
to
for ($k = 0; $k < $this->num_fds; $k++) {
$fd = $this->fds[$k];
if ( !$this->displayed[$k] || $this->virtual_only($k)) {
continue;
}
which will skip virtual cols in header
line 1679:
from
for ($k = 0; $k < $this->num_fds; $k++) {
if (! $this->displayed[$k]) {
continue;
}
to
for ($k = 0; $k < $this->num_fds; $k++) {
if ( !$this->displayed[$k] || $this->virtual_only($k)) {
continue;
}
line 1885 from :
for ($k = 0; $k < $this->num_fds; $k++) { /* {{{ */
$fd = $this->fds[$k];
if (! $this->displayed[$k]) {
continue;
}
to
for ($k = 0; $k < $this->num_fds; $k++) { /* {{{ */
$fd = $this->fds[$k];
if (! $this->displayed[$k] || $this->virtual_only[$k]) {
continue;
}
which skip them in table content.
the behavior in view/change mode is not changed if U option is used. or at least i think so.
i wonder what happens with only U option specified.
btw, how should i post diffs ? |
|
|
michal
2003-08-26 23:35
|
for nicer version of this patch see
http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=127 |
|
|
nepto
2007-07-04 23:34
|
Solved by #127. |
|
|
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2003-04-06 02:53 |
anonymous |
New Bug |
|
|
2003-04-10 21:57 |
nepto |
Bugnote Added: 0000180 |
|
|
2003-04-10 21:57 |
nepto |
status |
new => acknowledged |
|
2003-08-25 23:14 |
michal |
Bugnote Added: 0000388 |
|
|
2003-08-26 23:35 |
michal |
Bugnote Added: 0000389 |
|
|
2004-02-02 14:20 |
hbernard |
Bug Monitored: hbernard |
|
|
2007-07-04 23:34 |
nepto |
Bugnote Added: 0001883 |
|
|
2007-07-04 23:34 |
nepto |
duplicate_id |
0 => 127 |
|
2007-07-04 23:34 |
nepto |
handler_id |
=> nepto |
|
2007-07-04 23:34 |
nepto |
resolution |
open => fixed |
|
2007-07-04 23:34 |
nepto |
status |
acknowledged => resolved |
|
|