Comments for Yet another blog about PHP, HTML and CSS

Comment on Getting rid of JOINs in updateAll() query by Jesh

Jesh — Sun, 07 Feb 2010 18:54:00 +0000

Nice to know but any idea why Cake left join associated model when calling Model::updateAll() ?

Comment on Getting rid of JOINs in updateAll() query by kleingeist

kleingeist — Wed, 16 Dec 2009 15:33:38 +0000

Hey thanks,
this was exactly what i was looking for :)

And unfortunately i have to agree, that relationships seem to stand in the way too often :(
But well, thats the cake way of coding and we choose it.

Comment on Populating a SELECT box with distinct values by CyberCortex

CyberCortex — Mon, 07 Dec 2009 23:56:56 +0000

After a lot of tests, I finally solved this problem with this ridiculous line:

$years = $this->Payments->find(’list’, array(’fields’ => array(’year’, ‘year’)));

Sorry for my bad english, I am Brazilian.

Comment on Populating a SELECT box with distinct values by Petr 'PePa' Pavel

Petr 'PePa' Pavel — Fri, 25 Sep 2009 09:07:56 +0000

Ming, your code wouldn’t work for several reasons:

If you just return something then you can’t use it in your view to populate SELECT box. Maybe you omitted $this->set() just to keep your code simple though.
With $this->set() your solution would pass through
array(0 => value1, 1 => value2 …)
and thus if I choose value1 in the SELECT box it’s in fact “0″ that gets submitted.
We need
array(value1 => value1, value2 => value2 …)
because we want value1 submitted.
I also considered that you were in fact, just suggesting to use find(’list). But then again you get
array(0 => value1, 1 => value2 …)

But thanks for commenting. Expressing opinions, making suggestions. That’s what these comments are for.

Comment on Populating a SELECT box with distinct values by Ming

Ming — Fri, 25 Sep 2009 07:34:48 +0000

How about this…

$list = $this->find(’list’, array(’fields’ => array(’Model.field’)));
return array_unique($list);

Comment on SQL functions or keywords in CakePHP conditions by Rubens Mariuzzo

Rubens Mariuzzo — Fri, 29 May 2009 05:25:49 +0000

Thanks a lot it save me some extra hours. Thanks.

Comment on Absolute positioning in HTML e-mails for Outlook 2007 by ciccio

ciccio — Thu, 12 Feb 2009 01:23:54 +0000

Sorry for being unpolite.
And I had really appreciated the way you answered to my comment.
But I arrived here searching for “

The docs are contained in a database of a product that has to be migrated.
I wrote a software that, among the others, extract the xml from the db blobs, transform some xml nodes and extract some html parts to build a html document, as a part of the migration project.
While I’m writing it, I was doing some tests against a number of documents as xml parsing and transformation is time and resource consuming, and all went ok.
Now that the sw is 99.9% done, I’ve tested it against a broader set of documents and it’s failing because of that v:shape attribute.
Now I have to choose among:
- add the xmlns to all the documents, whether they have the attr or not (little effort, not elegant)
- navigate all the nodes and check all the attributes, sanitizing them or adding the xmlns if necessary (middle effort, time and resource consuming)
- implement my own transformer (high effort)
- ?
AFAIK, all the solutions require time and you know time==money/life.
That’s way I’m unhappy.

Comment on Absolute positioning in HTML e-mails for Outlook 2007 by Petr 'PePa' Pavel

Petr 'PePa' Pavel — Wed, 11 Feb 2009 07:02:04 +0000

I despise this MS-only stuff as much as you do but by closing my eyes I won’t make it go away. So if a client specifically requests he wants his e-mail thing to show well in Outlook 2007 I just take a deep breath and do it. That’s just life I guess.

Comment on Absolute positioning in HTML e-mails for Outlook 2007 by ciccio

ciccio — Wed, 11 Feb 2009 01:14:07 +0000

Interesting…
“

Please, stop publishing that crap on the web.

Comment on Populating a SELECT box with distinct values by Petr 'PePa' Pavel

Petr 'PePa' Pavel — Fri, 16 Jan 2009 12:03:55 +0000

Hi Steve, that’s weird that you’re getting an error.
I’m using CakePHP 1.2.0.7692 RC3 and my real code differs from the example I have given in my post only in that I specify additional options like “order” and “recursive” for the find() call.

My best guess is that your find call doesn’t return a valid search result array (e.g. because of a typo in a field name), or you changed the variable name that holds it but forgot to change it later in the combine call as well. I create this kind of errors all the time.

Petr