phpMyEdit - Viewing Bug Advanced Details [ Go Back ]
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
69 core / field option feature always 2003-04-06 02:53 2007-07-04 23:34
Reporter: anonymous Platform:  
Assigned To: nepto OS:  
Priority: normal Version:  
Status: resolved Product Version: 0.6.1  
Product Build: Resolution: fixed  
Projection: none Duplicate ID: 0000127  
ETA: none  
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.