Re: Undefined variable in view

2010-09-03 Thread Richard
Hello Milos, thanks for you reply! If I define the variable in the
controller as follows it states again that it's undefined in the view.

$this-set('categories',  'TestValue');

When I echo the variable in the controller everything looks alright:
var_dump($this-viewVars['categories']);

However it does not pass all of the viewVars for some reason to the
view.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Component code

2010-09-03 Thread alaxos
Hello,

You can call a model function from a component.

Here's a way to do it:

-
class MyComponent
{
  private $controller;

  public function initialize($controller)
  {
$this-controller = $controller;
  }

  public function my_function()
  {
$this-controller-Order-function();
  }
}
-

Just test if $this-controller-Order and/or $this-OrderItem-Order
are set, depending on your needs.

Regards,
Nico

On 3 sep, 07:05, Jeremy Burns | Class Outfit
jeremybu...@classoutfit.com wrote:
 I should mention that I both read from and write to the session...

 Jeremy Burns
 Class Outfit

 jeremybu...@classoutfit.com
 (t) +44 (0) 208 123 3822
 (m) +44 (0) 7973 481949
 Skype: jeremy_burnshttp://www.classoutfit.com

 On 3 Sep 2010, at 06:00, Dave Maharaj wrote:

  Place the code in the model and pass the Session data as vars from the
  controller?

  -Original Message-
  From: Jeremy Burns [mailto:jeremybu...@classoutfit.com]
  Sent: September-03-10 2:24 AM
  To: CakePHP
  Subject: Component code

  I have a chunk of code that appears in two controllers
  (orders_controller and order_items_controller) that is virtually
  identical in each case. I'd like to move it to a single location, so
  this sounds like an ideal candidate for a component.

  Part of the code calls a function in the Order model, so whilst one
  calls it via $this-Order-function() the other calls it via $this-
  OrderItem-Order-function(); hence the difference.

  I could also consider moving the code into the Order model and calling
  it from both controllers, but unfortunately the code also refers to
  $this-Session, which is not allowed in models.

  So I'm stuck. I can't move it to a component because a component can't
  call a model function, and I can't move it to a model because a model
  can't talk to the Session.

  Any ideas?

  Check out the new CakePHP Questions sitehttp://cakeqs.organd help others
  with their CakePHP related questions.

  You received this message because you are subscribed to the Google Groups
  CakePHP group.
  To post to this group, send email to cake-php@googlegroups.com
  To unsubscribe from this group, send email to
  cake-php+unsubscr...@googlegroups.com For more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en

  Check out the new CakePHP Questions sitehttp://cakeqs.organd help others 
  with their CakePHP related questions.

  You received this message because you are subscribed to the Google Groups 
  CakePHP group.
  To post to this group, send email to cake-php@googlegroups.com
  To unsubscribe from this group, send email to
  cake-php+unsubscr...@googlegroups.com For more options, visit this group 
  athttp://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


autotesting with web test cases - brainstorming

2010-09-03 Thread euromark
our application gets bigger and bigger
every time we change a component we make sure the test cases for it
pass

but often times there might be some unforeseen consequences for the
output in the views.
i was wondering how this could me automated

ideas:
- level 1: build a crawler and index all available views and test them
for errors, warnings, ...
- level 2: add specific urls not reachable by the crawler
- level 3: add manual test cases for backend (logged in)

every time we update the live branch we run the web test

what do you think? a coverage of 99% for all sites checking for any
errors and warnings would be a huge help

we could index all urls in a table
by using some custom HtmlHelper::url() we could save all generated
urls in this table automatically (saves some crawling time).

if we save the differences between tests we could even evaluate those
differences compared to the errors occuring etc

the biggest problem as of right now is a suitable crawler...
the ones i tried seem not to fit to the framework

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Lots of cakephp warnings in the log

2010-09-03 Thread Thunderstriker
ok i looked in to this a bit more
this only happens when I'm not in debug mode

and this is becous in the error handling function fron debugger there
is this:
if (error_reporting() == 0 || $code === 2048 || $code === 8192) {
return;
}

and in the normal production error handling:
if ($code === 2048 || $code === 8192) {
return;
}

so in production it doesn't check if error_reporting() is suppressed

On Aug 25, 10:15 am, Thunderstriker thunders...@gmail.com wrote:
 ok i digged a bit deeper and found that even when i remove all queries
 (-find, uses, ..) and i check in debug mode the only connection to
 the db it makes is for my sessions becous i save my sessions to the db
 and i still get thesewarningsbut only wen debug is turned of

 then i switched the sessions to php and the errors where gone  but as
 soon as i added any model-find they were back

 any ideas?

 On Aug 24, 9:56 pm, Jeremy Burns | Class Outfit

 jeremybu...@classoutfit.com wrote:
  I'd guess that model-query is your culprit. If it were me I'd want to find 
  out what's awry because I'd need to know the impact and fix it.

  Jeremy Burns
  Class Outfit

  jeremybu...@classoutfit.comhttp://www.classoutfit.com

  On 24 Aug 2010, at 20:49, Thunderstriker wrote:

   there are no errors poping up when debug set to 2 and everiting is
   working fine
   i am only using the model-find() and model-query() functions

   On 24 aug, 21:26, j.blotus j.blo...@gmail.com wrote:
   is there a reason you are running those ms sql functions directly
   instead of using model-find() etc?

   On Aug 24, 9:41 am, Thunderstriker thunders...@gmail.com wrote:

   i get a lot ofwarningsin my logs like:
   2010-08-24 09:34:01 Warning: Warning (2): mssql_num_rows(): supplied
   argument is not a valid MS SQL-result resource in [C:\xampp\htdocs\cake
   \libs\model\datasources\dbo\dbo_mssql.php, line 468]
   2010-08-24 09:34:01 Warning: Warning (2): mssql_free_result():
   supplied argument is not a valid MS SQL-result resource in [C:\xampp
   \htdocs\cake\libs\model\datasources\dbo\dbo_mssql.php, line 180]
   2010-08-24 09:34:01 Warning: Warning (2): mssql_free_result():
   supplied argument is not a valid MS SQL-result resource in [C:\xampp
   \htdocs\cake\libs\model\datasources\dbo\dbo_mssql.php, line 180]

   thesewarningsjust overun my log files and make them almost useless.
   i looked up the lines and they used the @ sign to suppress these
   errors like:
   @mssql_free_result($this-results);

   and still the show up in my log is there anyway to really suppress
   them without changing the cake code?

   Check out the new CakePHP Questions sitehttp://cakeqs.organdhelp others 
   with their CakePHP related questions.

   You received this message because you are subscribed to the Google Groups 
   CakePHP group.
   To post to this group, send email to cake-php@googlegroups.com
   To unsubscribe from this group, send email to
   cake-php+unsubscr...@googlegroups.com For more options, visit this group 
   athttp://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


AW: Undefined variable in view

2010-09-03 Thread Anja Liebermann
And how about 
var_dump($categories);
In the view?

Anja
 
-Ursprüngliche Nachricht-
Von: cake-php@googlegroups.com [mailto:cake-...@googlegroups.com] Im Auftrag 
von Richard
Gesendet: Freitag, 3. September 2010 09:25
An: CakePHP
Betreff: Re: Undefined variable in view

Hello Milos, thanks for you reply! If I define the variable in the controller 
as follows it states again that it's undefined in the view.

$this-set('categories',  'TestValue');

When I echo the variable in the controller everything looks alright:
var_dump($this-viewVars['categories']);

However it does not pass all of the viewVars for some reason to the view.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com To unsubscribe 
from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group 
cake-php+at http://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Ajax Pagination - rearrange pages after item deleting

2010-09-03 Thread Mariano C.
Yes, this is what I do actually.
collection() function create my paginated list, after object removing
I recall collection() function but this display first page of list,
even if during deleting process I was at page 3.

On 3 Set, 06:22, Miloš Vučinić milosvuci...@gmail.com wrote:
 I think you should refresh your view and then the pagiation should be
 set as it is supposed to be. I do not have much experience in Ajax so
 I can't really advise you better on how to make your own paginaton ..

 On Sep 2, 4:36 pm, Mariano C. mariano.calan...@gmail.com wrote:



  Suppose to have 3 page, I delete an object from page 2, so I would
  take the first element from page 3 and use it as last element of page
  2, and so on...

  There's an article or tutorial to explain that?

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Undefined variable in view

2010-09-03 Thread Richard
Hello Anja,

I also did that, returns also 'Undefined variable'.
However I found a way, I added the following function to the
controller:
function beforeRender() {
parent::beforeRender();
$this-set('categories', $this-Category-find('all',
array('recursive'=0)));
}

This works now as expected, however I do not really understand why it
didn't worked in the first place.

greeting, Richard

On 3 sep, 11:58, Anja Liebermann
anja.lieberm...@schauinslandreisen.de wrote:
 And how about
 var_dump($categories);
 In the view?

 Anja

 -Ursprüngliche Nachricht-
 Von: cake-php@googlegroups.com [mailto:cake-...@googlegroups.com] Im Auftrag 
 von Richard
 Gesendet: Freitag, 3. September 2010 09:25
 An: CakePHP
 Betreff: Re: Undefined variable in view

 Hello Milos, thanks for you reply! If I define the variable in the controller 
 as follows it states again that it's undefined in the view.

 $this-set('categories',  'TestValue');

 When I echo the variable in the controller everything looks alright:
 var_dump($this-viewVars['categories']);

 However it does not pass all of the viewVars for some reason to the view.

 Check out the new CakePHP Questions sitehttp://cakeqs.organd help others with 
 their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups 
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com To unsubscribe 
 from this group, send email to
 cake-php+unsubscr...@googlegroups.com For more options, visit this group
 cake-php+athttp://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: autotesting with web test cases - brainstorming

2010-09-03 Thread euromark
juhuu
at least the crawler works now
after a few minutes he found all 3500 public urls

the testsuite then iterates over this array and performs some basic
tests
it seems all 3500 pages dont produce any fatal errors, errors,
warnings or notices :)

not sure how to test the backend (user, admin route + specific roles
(retailer, customer etc)), though
especially because delete links should not be crawled^^ we dont check
on post on delete actions yet

i'd appreciate any ideas
thx


On 3 Sep., 11:15, euromark dereurom...@googlemail.com wrote:
 our application gets bigger and bigger
 every time we change a component we make sure the test cases for it
 pass

 but often times there might be some unforeseen consequences for the
 output in the views.
 i was wondering how this could me automated

 ideas:
 - level 1: build a crawler and index all available views and test them
 for errors, warnings, ...
 - level 2: add specific urls not reachable by the crawler
 - level 3: add manual test cases for backend (logged in)

 every time we update the live branch we run the web test

 what do you think? a coverage of 99% for all sites checking for any
 errors and warnings would be a huge help

 we could index all urls in a table
 by using some custom HtmlHelper::url() we could save all generated
 urls in this table automatically (saves some crawling time).

 if we save the differences between tests we could even evaluate those
 differences compared to the errors occuring etc

 the biggest problem as of right now is a suitable crawler...
 the ones i tried seem not to fit to the framework

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Undefined variable in view

2010-09-03 Thread euromark
if it is not passed this part of the code in your action is NOT
REACHED

try
die('XYZ')
right in front of it

you will see that it is probably not even invoked

maybe some return in front of it?



On 3 Sep., 14:10, Richard richard_j...@hotmail.com wrote:
 Hello Anja,

 I also did that, returns also 'Undefined variable'.
 However I found a way, I added the following function to the
 controller:
 function beforeRender() {
     parent::beforeRender();
     $this-set('categories', $this-Category-find('all',
 array('recursive'=0)));

 }

 This works now as expected, however I do not really understand why it
 didn't worked in the first place.

 greeting, Richard

 On 3 sep, 11:58, Anja Liebermann



 anja.lieberm...@schauinslandreisen.de wrote:
  And how about
  var_dump($categories);
  In the view?

  Anja

  -Ursprüngliche Nachricht-
  Von: cake-php@googlegroups.com [mailto:cake-...@googlegroups.com] Im 
  Auftrag von Richard
  Gesendet: Freitag, 3. September 2010 09:25
  An: CakePHP
  Betreff: Re: Undefined variable in view

  Hello Milos, thanks for you reply! If I define the variable in the 
  controller as follows it states again that it's undefined in the view.

  $this-set('categories',  'TestValue');

  When I echo the variable in the controller everything looks alright:
  var_dump($this-viewVars['categories']);

  However it does not pass all of the viewVars for some reason to the view.

  Check out the new CakePHP Questions sitehttp://cakeqs.organdhelp others 
  with their CakePHP related questions.

  You received this message because you are subscribed to the Google Groups 
  CakePHP group.
  To post to this group, send email to cake-php@googlegroups.com To 
  unsubscribe from this group, send email to
  cake-php+unsubscr...@googlegroups.com For more options, visit this group
  cake-php+athttp://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


How to determine if the current page is a Flash() or not

2010-09-03 Thread Ernesto
Hello.

is there any way to determine if the current page is loaded by a
controller::flash() call?

i'm working in the controller::beforeRender().

Thx

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Question about ACL

2010-09-03 Thread Roland Pish
Hi there.

I'm starting with a project which will need the use of ACL to control
permissions.

These are the tables involved in permissions:

Users (a user always will belong to a group)
Groups
Operations

Permissions will be established only between Groups and Operations
like: Group 1 are granted access for the Operation 1, Operation 2, and
Operation 3. Group 2 are granted access only for Operation 2, and so
on.
New groups can be added.

I just created the db schema for cake acl tables, and I'm noticing
that aros_acos table has the fields: _create, _read, _update, _delete
which I believe are used for permissions on controllers actions, is
this correct?

So in my scenario, as I won't establish permissions based on
controllers actions, these fields wouldn't be used right?

Or am I designing permissions in a wrong way?

Thanks in advance

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Ajax Pagination - rearrange pages after item deleting

2010-09-03 Thread cricket
On Fri, Sep 3, 2010 at 6:35 AM, Mariano C. mariano.calan...@gmail.com wrote:
 Yes, this is what I do actually.
 collection() function create my paginated list, after object removing
 I recall collection() function but this display first page of list,
 even if during deleting process I was at page 3.

Create the link in the view so that it will pass the page number (get
it from $this-params['page']) in the AJAX request. Then, adjust the
'page' option when calling paginate().

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: How to determine if the current page is a Flash() or not

2010-09-03 Thread cricket
You could probably check $this-Session for that, although I'm not
sure, offhand, what to look for.

On Fri, Sep 3, 2010 at 10:10 AM, Ernesto e.fanz...@gmail.com wrote:
 Hello.

 is there any way to determine if the current page is loaded by a
 controller::flash() call?

 i'm working in the controller::beforeRender().

 Thx

 Check out the new CakePHP Questions site http://cakeqs.org and help others 
 with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups 
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
 http://groups.google.com/group/cake-php?hl=en


Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Excel file uploading and converting to csv

2010-09-03 Thread Muthuvel Subramani
hello I am new to cakephp.. i need to import files from excel to mysql
database.. so for this i need to upload the excel file...
after uploading i need to convert excel to csv file..
after converting to csv, i need to import csv file to mysql..
how should i approach for this scenario..
thanks..

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Excel file uploading and converting to csv

2010-09-03 Thread Sam
You can export to csv directly from excel.
http://vegdave.wordpress.com/2007/05/19/import-a-csv-file-to-mysql-via-phpmyadmin/

On Sep 3, 2:11 pm, Muthuvel Subramani jmsmuthu...@gmail.com wrote:
 hello I am new to cakephp.. i need to import files from excel to mysql
 database.. so for this i need to upload the excel file...
 after uploading i need to convert excel to csv file..
 after converting to csv, i need to import csv file to mysql..
 how should i approach for this scenario..
 thanks..

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: autotesting with web test cases - brainstorming

2010-09-03 Thread Sam
Just curious,
What did you use to crawl the urls?

On Sep 3, 8:09 am, euromark dereurom...@googlemail.com wrote:
 juhuu
 at least the crawler works now
 after a few minutes he found all 3500 public urls

 the testsuite then iterates over this array and performs some basic
 tests
 it seems all 3500 pages dont produce any fatal errors, errors,
 warnings or notices :)

 not sure how to test the backend (user, admin route + specific roles
 (retailer, customer etc)), though
 especially because delete links should not be crawled^^ we dont check
 on post on delete actions yet

 i'd appreciate any ideas
 thx

 On 3 Sep., 11:15, euromark dereurom...@googlemail.com wrote:



  our application gets bigger and bigger
  every time we change a component we make sure the test cases for it
  pass

  but often times there might be some unforeseen consequences for the
  output in the views.
  i was wondering how this could me automated

  ideas:
  - level 1: build a crawler and index all available views and test them
  for errors, warnings, ...
  - level 2: add specific urls not reachable by the crawler
  - level 3: add manual test cases for backend (logged in)

  every time we update the live branch we run the web test

  what do you think? a coverage of 99% for all sites checking for any
  errors and warnings would be a huge help

  we could index all urls in a table
  by using some custom HtmlHelper::url() we could save all generated
  urls in this table automatically (saves some crawling time).

  if we save the differences between tests we could even evaluate those
  differences compared to the errors occuring etc

  the biggest problem as of right now is a suitable crawler...
  the ones i tried seem not to fit to the framework

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


my happiness!

2010-09-03 Thread Sohei Okamoto
Dear friend,
A good news for you! I bought a laptop from Frioffere. Luckily, I was
one of their first 100 customers that day, so they sold it to me at
half price. Only 5 days later, I received my laptop. It is really
high-quality.
Same products, much lower prices! Share my happiness quickly. Come to
visit   www.frioffere.org They also sell mobiles, cameras and other
electronic products. Now they have a promotion: every day the first
100 customers will be given big discount.
Good luck!

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Ajax Pagination - rearrange pages after item deleting

2010-09-03 Thread ohcibi
put something like
$(#itemlist).load(/items/index/page:$page #itemlist); into your
delete function

On 2 Sep., 16:36, Mariano C. mariano.calan...@gmail.com wrote:
 Suppose to have 3 page, I delete an object from page 2, so I would
 take the first element from page 3 and use it as last element of page
 2, and so on...

 There's an article or tutorial to explain that?

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: autotesting with web test cases - brainstorming

2010-09-03 Thread euromark
a self written crawler
basically it collects all links and puts them into two arrays

a worklist and a all links list
after a while there are no new links so the worklist empties itself
as soon as its empty the crawler is done


On 3 Sep., 21:25, Sam s...@masterscommission360.com wrote:
 Just curious,
 What did you use to crawl the urls?

 On Sep 3, 8:09 am, euromark dereurom...@googlemail.com wrote:

  juhuu
  at least the crawler works now
  after a few minutes he found all 3500 public urls

  the testsuite then iterates over this array and performs some basic
  tests
  it seems all 3500 pages dont produce any fatal errors, errors,
  warnings or notices :)

  not sure how to test the backend (user, admin route + specific roles
  (retailer, customer etc)), though
  especially because delete links should not be crawled^^ we dont check
  on post on delete actions yet

  i'd appreciate any ideas
  thx

  On 3 Sep., 11:15, euromark dereurom...@googlemail.com wrote:

   our application gets bigger and bigger
   every time we change a component we make sure the test cases for it
   pass

   but often times there might be some unforeseen consequences for the
   output in the views.
   i was wondering how this could me automated

   ideas:
   - level 1: build a crawler and index all available views and test them
   for errors, warnings, ...
   - level 2: add specific urls not reachable by the crawler
   - level 3: add manual test cases for backend (logged in)

   every time we update the live branch we run the web test

   what do you think? a coverage of 99% for all sites checking for any
   errors and warnings would be a huge help

   we could index all urls in a table
   by using some custom HtmlHelper::url() we could save all generated
   urls in this table automatically (saves some crawling time).

   if we save the differences between tests we could even evaluate those
   differences compared to the errors occuring etc

   the biggest problem as of right now is a suitable crawler...
   the ones i tried seem not to fit to the framework

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Alternate Pagination question

2010-09-03 Thread Dave Maharaj
Has anyone created,  thought of , started on the idea of an alphabetical
character paging system? 

So rather than 1 | 2 | 3 it spits out A |B |C? 

 

The ABC part seems rather simple just getting the letters to be links if
there are records for that letter seems to be the real issue. Any ideas on
how to approach this one before I start?

 

Thanks,

 

Dave 

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


RE: Alternate Pagination question

2010-09-03 Thread Dave Maharaj
Sorry , my first thought would be to do a looping find-first of each letter
and so if it found a record starting with A set that link true, if nothing
for B then just the letter no link and co on... 

 

The only  problem I see is 26 queries just to build the paging links.

 

Other ideas?

 

Thanks

 

 

 

From: Dave Maharaj [mailto:m...@davemaharaj.com] 
Sent: September-03-10 6:22 PM
To: cake-php@googlegroups.com
Subject: Alternate Pagination question

 

Has anyone created,  thought of , started on the idea of an alphabetical
character paging system? 

So rather than 1 | 2 | 3 it spits out A |B |C? 

 

The ABC part seems rather simple just getting the letters to be links if
there are records for that letter seems to be the real issue. Any ideas on
how to approach this one before I start?

 

Thanks,

 

Dave 

Check out the new CakePHP Questions site http://cakeqs.org and help others
with their CakePHP related questions.
 
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


cakePHP + openid on windows XP

2010-09-03 Thread Dmitry Shevchenko
Hi
I have use openId component from cakebaker (http://code.42dh.com/
openid/) and when I'm trying to authentificate fom google I'm getting
an errors:

handleOpenIDResponse

Notice (8): Undefined variable: sregContents [APP\controllers
\users_controller.php, line 229]

Auth_OpenID_FailureResponse Object
(
[status] = failure
[endpoint] =
[identity_url] =
[message] = Server denied check_authentication
[contact] =
[reference] =
)

my config is
OS Win XP
PHP 5.2.12
cakePHP 1.2.6



I have double check is openSSL and curl enabled, also I have added a
patch from  http://www.pixelastic.com/blog/171:adding-openid-support
for windows

Maybe someone stuck in the same trouble?
I really appreciate any help.

Thank you.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Query help

2010-09-03 Thread Dave Maharaj
I have this query in the model

 

$params = array(

'conditions' = array(

'Profile.company LIKE' = $i.'*'),

'fields' = array(

'Profile.company',

'Profile.id'),

'contain' = false);

 

$this-find('first', $params);

 

Where $i is a single letter so I am trying to get the first record starting
with A for example produces this SQL query

 

SELECT `Profile`.`company`, `Profile`.`id` FROM `profiles` AS `Profile`
WHERE `Profile`.`company` LIKE 'A*' LIMIT 1

 

And even though I have a Profile.company record in the database starting
with 'A' nothing is found. Where am I going wrong? I simply want to find 1
record where the Profile.company starts with $i.

 

Thanks,

 

Dave

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Null date fields in scaffolding

2010-09-03 Thread aries
Hello,

I'd like to have date fields that allow null values to default to a
null selection in the date/time menus when generating pages from the
admin scaffold. I found ticket 5702 that suggests a patch, but that's
for Cake 1.2, I wasn't able to work out a fix for 1.3. Has anyone
worked this out or is there something I'm missing?

Thanks,
-aries

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Query help

2010-09-03 Thread Blackymetal

You should use % instead of *


On Sep 3, 4:49 pm, Dave Maharaj m...@davemaharaj.com wrote:
 I have this query in the model

 $params = array(

 'conditions' = array(

 'Profile.company LIKE' = $i.'*'),

 'fields' = array(

 'Profile.company',

 'Profile.id'),

 'contain' = false);

 $this-find('first', $params);

 Where $i is a single letter so I am trying to get the first record starting
 with A for example produces this SQL query

 SELECT `Profile`.`company`, `Profile`.`id` FROM `profiles` AS `Profile`
 WHERE `Profile`.`company` LIKE 'A*' LIMIT 1

 And even though I have a Profile.company record in the database starting
 with 'A' nothing is found. Where am I going wrong? I simply want to find 1
 record where the Profile.company starts with $i.

 Thanks,

 Dave

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Query help

2010-09-03 Thread Andras Kende
Dave,

'conditions' = array('Profile.company LIKE' = $i . '%'),

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html

Andras Kende
http://www.kende.com/

On Sep 3, 2010, at 5:49 PM, Dave Maharaj wrote:

 I have this query in the model
  
 $params = array(
 'conditions' = array(
 'Profile.company LIKE' = $i.'*'),
 'fields' = array(
 'Profile.company',
 'Profile.id'),
 'contain' = false);
  
 $this-find('first', $params);
  
 Where $i is a single letter so I am trying to get the first record starting 
 with A for example produces this SQL query
  
 SELECT `Profile`.`company`, `Profile`.`id` FROM `profiles` AS `Profile` WHERE 
 `Profile`.`company` LIKE 'A*' LIMIT 1
  
 And even though I have a Profile.company record in the database starting with 
 ‘A’ nothing is found. Where am I going wrong? I simply want to find 1 record 
 where the Profile.company starts with $i.
  
 Thanks,
  
 Dave
 
 Check out the new CakePHP Questions site http://cakeqs.org and help others 
 with their CakePHP related questions.
  
 You received this message because you are subscribed to the Google Groups 
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
 http://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Alternate Pagination question

2010-09-03 Thread Sam
The most efficient way database-wise would be to have a char(1)
database column that you populate with whatever the first letter of
the field you're using... that way it could be indexed and easily
counted. It would be slightly slower when saving data but (I assume)
much faster retrieving it.


If you didn't want to do that, you could use the mysql substring
function:

Here is mysql the query string(tested)
SELECT SUBSTRING(name, 1, 1) as letter, COUNT(SUBSTRING(name, 1, 1))
as count FROM people GROUP BY letter ORDER BY letter;

Here is a cake query(untested)
$this-People-find('list', array(
'fields' = array('SUBSTRING(name, 1, 1) as letter',
'COUNT(SUBSTRING(name, 1, 1)) AS COUNT'),
'group' = 'letter',
'order' = array('letter' = 'ASC')
)
);

On Sep 3, 4:02 pm, Dave Maharaj m...@davemaharaj.com wrote:
 Sorry , my first thought would be to do a looping find-first of each letter
 and so if it found a record starting with A set that link true, if nothing
 for B then just the letter no link and co on...

 The only  problem I see is 26 queries just to build the paging links.

 Other ideas?

 Thanks

 From: Dave Maharaj [mailto:m...@davemaharaj.com]
 Sent: September-03-10 6:22 PM
 To: cake-php@googlegroups.com
 Subject: Alternate Pagination question

 Has anyone created,  thought of , started on the idea of an alphabetical
 character paging system?

 So rather than 1 | 2 | 3 it spits out A |B |C?

 The ABC part seems rather simple just getting the letters to be links if
 there are records for that letter seems to be the real issue. Any ideas on
 how to approach this one before I start?

 Thanks,

 Dave

 Check out the new CakePHP Questions sitehttp://cakeqs.organd help others
 with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.com For more options, visit this group 
 athttp://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en