Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Wednesday, November 11, 2026
About Us
Magazine
Open Source
CVS
Services
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

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy