Cake PHP (Bug even still exists in cake php2)

2012-03-08 Thread Phil
Bad programming by cake php here.  This bug still exists in version
2.  Why does it rely on a css file existing?  A lot of people will
alter the default template first (removing the default cake stuff),
then when they revisit the home page, this error shows incorrectly.
There should be a php conditional around this rather than assuming a
css file has been included which may or may not be there.

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


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


Re: CakePhp related domain

2011-11-12 Thread Phil Dobbin
On 11/11/11 18:33, "mike karthauser"  wrote:

> If this is the case then why not offer the domain at a nominal price - ie 20
> dollars rather than 200? If your intention is to keep it away from the domain
> squatters then passing it on to someone to use it is worth that. Otherwise let
> it expire and I'll grab it then :)
> 
> Incidentally, as a developer who has benefitted from the work of the cakephp
> foundation, perhaps donating it and some cash is more in order?

+1

A little gratitude may the correct action in this case rather than legal
wranglings or trying to grift $200...

Cheers,

Phil...

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


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


Problem with default.ctp

2011-05-30 Thread Phil
I created a sample app using the scaffolding, which worked very well,
thank you.
I went the next step and created a default.ctp file using the one that
comes with cakephp.
I then created a style.css file with the following:
* { font-family: "Lucida Grande",Lucida,sans-serif; }

th {
font-size: 14px;
fond-weight: bold;
background-color: #e1e1e1;
border-bottom: 1px solid #ccc;
padding: 10px;
}

div.actions ul {
list-style-type: none;
}

I then tried rerunning the application and the only output I got was:
css('styles');?>

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


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


Re: Trying to get phpFlickr working as a Vendor

2010-09-16 Thread Phil Tysoe
Not sure if this is the correct way to reply, but I can't find the thread on
the Google Groups site.  I fixed the problem by trial and error by changing
the 'phpFlickr' argument in App::import to lowercase.  That was it!  Works
now.  Just to clarify the new declaration is:

App::import('Vendor', 'phpflickr');

(The file name itself is still 'phpFlickr.php')


On 15 September 2010 22:55, igniteflow  wrote:

> Hi, I've had success with Vendors before, but can't seem to get this
> example working, any help would be much appreciated.
>
> In my controller (flickr_controller.php) I have
>
> App::import('Vendor', 'phpFlickr');  // phpFlickr.php is in /app/
> vendors/phpFlickr.php
>
> class FlickrController extends AppController {
>
>var $name = 'Flickr';
>var $uses = array();
>
>function index() {
>$api_key = 'xxx';
>$secret = 'xxx';
>$flickr = new phpFlickr($api_key, $secret);
>debug($flickr);
>}
> }
>
> The browser returns:
> Fatal error: Class 'PhpFlickr' not found in /Applications/MAMP/htdocs/
> CakeApp/app/controllers/flickr_controller.php on line 15
>
> I'm using CakePHP 1.3, the Facebook Api works using the same Vendor
> import structure so I'm stumped why phpFlickr doesn't, especially as
> it works fine from localhost outside of CakePHP.
>
> Any ideas?

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: Using html5 video tag.

2010-04-30 Thread Phil
Thanks for the answer but it didn't worked.

If i use the $html->tag:

echo $html->tag('video','your browser does not support the video tag',
array('src' => '/1.ogv', 'controls' => 'controls'));

, I still have the same behaviour.

I see the player in the browser but can't play de movie. The route is
correct because if i make right click on the player and then click on
save as... i download the video correctly.

It's very strange because if i make a look to the generated source
code and I copy it into a normal html file outside cakephp it works.

On 30 abr, 05:58, tristan_ph  wrote:
> You may use HtmlHelper->tag()
>
> $this->Html->tag(__('your browser does not support the video tag',
> true), array('src' => '/video.ogv', array('controls' => 'controls'));
>
> On Apr 29, 10:03 pm, Phil  wrote:
>
>
>
> > Hi!
>
> > I'm trying to add a video file into my cakephp project using the html5
> >  tag. If i write a simple html file with this code:
>
> > 
> > your browser does not support the video tag
> > 
>
> > If works properly in firefox. But if I try to the next code to my .ctp
> > file in cakephp, firefox shows the player but is not playing the
> > video:
>
> > 
> > your browser does not support the video tag
> > 
>
> > The video.ogv is in the webroot folder.
>
> > Thanks.
>
> > 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 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


Using html5 video tag.

2010-04-29 Thread Phil
Hi!

I'm trying to add a video file into my cakephp project using the html5
 tag. If i write a simple html file with this code:


your browser does not support the video tag


If works properly in firefox. But if I try to the next code to my .ctp
file in cakephp, firefox shows the player but is not playing the
video:


your browser does not support the video tag


The video.ogv is in the webroot folder.

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


cookies / localhost / mac

2010-02-01 Thread phil
I am using cakephp 1.2 on my mac.  i cannot get $this->Cookie->write
to actually write a cookie.  i am guessing this has something to do
with my localhost development environment, but I can't find any
information on this issue.  can someone help?

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


Organization issues and more...

2009-06-16 Thread Phil

My questions aren't exactly about CakePHP, but more so around the MVC
architecture. I couldn't find my particular answer through searching,
but at least I discovered that this seems like an acceptable question
here.

I have a main menu. For each main menu item, there is a sub menu. To
me, it made more sense that the URL would be //
/, which would be /controller/action/. Because of this,
I created a controller for each main menu item, and created actions in
the appropriate controller for each sub menu item. My intents are for
the user to click the main menu item, and the first sub menu item will
be selected by default. As such, I used the index() for each
controller to be the first (default) sub menu item.

This is where I get confused though. The main menu item is simply for
organizational purpose. It is almost as if I shouldn’t even have a
controller for the main menu items, but rather, a controller for each
sub menu item. I guess I would have to split my current database table
up into multiple database tables, one for each controller (sub menu).
I guess that also means one model for each controller as well. Does
this make more sense?

I have further issues, which go a bit further off topic but my main
question is about MVC still. On each of these sub menu pages, the
information from the database for the authorized user is displayed for
the particular section they are on. I wanted to be able to edit this
information by clicking on the text displayed and having it turn into
a input box for editing. Then, when the user clicks away or presses
enter, it turns back into normal text, without the input box. I can do
this with Javascript just fine, but I don't know how this fits in with
MVC. I guess I would just put it in my view and use it how I would
without this framework, except input boxes will be created using the
form helper? I really think I would prefer this method of editing over
a separate edit page, but if you strongly disagree then constructive
criticism is accepted. However, I'm still not entirely sure when the
actual saving to the database should take place if I went about it
this way. I was thinking it could commit the changes every time the
text box turns back into normal text through AJAX, but depending on
how many fields are being edited, that could be putting an unnecessary
extra load on the server. I suppose it is a design decision I should
be asking myself rather than people who are reading this that don't
know any details of my project, but I am open for suggestions. The
point was that I wanted the page to almost always have a presentation
appearance and a bit more of an interactive feel to editing rather
than switching entirely to an editing view.

Congratulations to those of you who actually read everything. Thanks
in advance for any help or insight.

--~--~-~--~~~---~--~~
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: named params and prefix routing

2009-01-07 Thread Phil

Thanks for your idea - I just tried it, but interestingly, it doesn't
work (i.e. the prefix is not set), but there's also no named parameter
"prefix" appended to the url - it's completely ignored, as it seems.

On 7 Jan., 18:55, brian  wrote:
> I've not used prefix routing myself but have you tried setting
> 'prefix' in the link method?
>
> $html->link('alle Termine', array('controller' => $params
> ['controller'], 'action' => 'entries', 'prefix' => 'intranet', 'future' =>
> '0'));
>
> On Wed, Jan 7, 2009 at 7:35 AM, Phil  wrote:
>
> > Same problem here - these are my routes:
>
> > Router::connect('/intranet/', array('controller' => 'users', 'action'
> > => 'index', 'prefix' => 'intranet', 'intranet' => true));
> > Router::connect('/intranet/:controller/:action/*', array('prefix' =>
> > 'intranet', 'intranet' => true));
>
> > Works fine, except for creating a link with a named parameter:
>
> > $html->link('alle Termine', array('controller' => $params
> > ['controller'], 'action' => 'entries', 'intranet'=>true, 'future' =>
> > '0'));
>
> > creates this link:
>
> > /calendar_entries/entries/intranet:1/future:1
>
> > instead of:
>
> > /intranet/calendar_entries/entries/future:1
>
> > Anything new about this problem here?
>
> > TIA, Phil
>
> > Marcelius schrieb:
> >> I'm usually not the guy who bumbs postings but this problem still
> >> exists... So my question is: is this behavior by design or am I doing
> >> something wrong?
>
> >> On 12 dec, 07:53, Marcelius  wrote:
> >> > Thanks for the anwser but that didn't work here.
>
> >> > The be more clear: If I do not usenamedparams, the the url is
> >> > correct: It has the prefix /owner
> >> > If I do usenamedparams, the router adds owner:1 as anamedparam
> >> > instead of prepending the /owner prefix.
>
> >> > So:
> >> > Router::url(array("controller"=>"invoices", "action"=>"edit", 5,
> >> > "owner"=>true, "key"=>"val"));
>
> >> > Returns and not expected:
> >> > "/invoices/edit/5/owner:1/key:val"
> >> > I would expect:
> >> > "/owner/invoices/edit/5/key:val"
>
> >> > On 11 dec, 16:31, Lane  wrote:
>
> >> > > What were you expecting the Router to return if not "/invoices/edit/5/
> >> > > owner:1/key:val"?
>
> >> > > On Dec 11, 4:39 am, Marcelius  wrote:
>
> >> > > > Hello!
>
> >> > > > I have this route like the manual says for prefix routing:
>
> >> > > > Router::connect('/owner/:controller/:action/*', array
> >> > > > ('prefix'=>'owner', 'owner'=>true));
>
> >> > > > This works fine until I want to create a url with somenamedparamsin
> >> > > > it:
>
> >> > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5,
> >> > > > "owner"=>true));
> >> > > > returns "/owner/invoices/edit/5" as expected.
>
> >> > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5,
> >> > > > "owner"=>true, "key"=>"val"));
> >> > > > returns "/invoices/edit/5/owner:1/key:val" not as expected.
>
> >> > > > Something wrong in my routes? Please note that that's the only route
> >> > > > available.
>
> >> > > > Thanks in advance!
--~--~-~--~~~---~--~~
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: named params and prefix routing

2009-01-07 Thread Phil

Same problem here - these are my routes:

Router::connect('/intranet/', array('controller' => 'users', 'action'
=> 'index', 'prefix' => 'intranet', 'intranet' => true));
Router::connect('/intranet/:controller/:action/*', array('prefix' =>
'intranet', 'intranet' => true));

Works fine, except for creating a link with a named parameter:

$html->link('alle Termine', array('controller' => $params
['controller'], 'action' => 'entries', 'intranet'=>true, 'future' =>
'0'));

creates this link:

/calendar_entries/entries/intranet:1/future:1

instead of:

/intranet/calendar_entries/entries/future:1

Anything new about this problem here?

TIA, Phil

Marcelius schrieb:
> I'm usually not the guy who bumbs postings but this problem still
> exists... So my question is: is this behavior by design or am I doing
> something wrong?
>
> On 12 dec, 07:53, Marcelius  wrote:
> > Thanks for the anwser but that didn't work here.
> >
> > The be more clear: If I do not usenamedparams, the the url is
> > correct: It has the prefix /owner
> > If I do usenamedparams, the router adds owner:1 as anamedparam
> > instead of prepending the /owner prefix.
> >
> > So:
> > Router::url(array("controller"=>"invoices", "action"=>"edit", 5,
> > "owner"=>true, "key"=>"val"));
> >
> > Returns and not expected:
> > "/invoices/edit/5/owner:1/key:val"
> > I would expect:
> > "/owner/invoices/edit/5/key:val"
> >
> > On 11 dec, 16:31, Lane  wrote:
> >
> > > What were you expecting the Router to return if not "/invoices/edit/5/
> > > owner:1/key:val"?
> >
> > > On Dec 11, 4:39�am, Marcelius  wrote:
> >
> > > > Hello!
> >
> > > > I have this route like the manual says for prefix routing:
> >
> > > > Router::connect('/owner/:controller/:action/*', array
> > > > ('prefix'=>'owner', 'owner'=>true));
> >
> > > > This works fine until I want to create a url with somenamedparamsin
> > > > it:
> >
> > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5,
> > > > "owner"=>true));
> > > > returns "/owner/invoices/edit/5" as expected.
> >
> > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5,
> > > > "owner"=>true, "key"=>"val"));
> > > > returns "/invoices/edit/5/owner:1/key:val" not as expected.
> >
> > > > Something wrong in my routes? Please note that that's the only route
> > > > available.
> >
> > > > Thanks in advance!

--~--~-~--~~~---~--~~
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: bake newbie problem with configuration

2007-12-14 Thread Phil

Now fixed,
if its of any help to others :-)
I created a new clean directory /webroot/cakephp instead of /webroot/
cake
installed the latest nightly build
copied the bits of my app across
changes the sites-available for apache to reflect the above directory
change
ran bake as before
all OK
probably my fault on a previous upgrade of cakephp :-(

On 2 Dec, 11:09, Phil <[EMAIL PROTECTED]> wrote:
> Hi
> I have a simple cakephp app working, now trying to usebake
> downloaded 1.2
> installed php cli
>
> error message is
> cannot redeclare class ClassRegistry in /webroot/cake/cake/libs
> class_registry.php on line 39
>
> I am using debian etch, php5, cakephp 1.2, postgresql
>
> I think its my configuration thats the cause, but am stuck
>
> any ideas please
> CheersPhil
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



Re: bake newbie problem with configuration

2007-12-04 Thread Phil

directories are
/webroot/cake/app
/webroot/cake/cake/console
user phil
from dir /webroot/cake/app
calling
../cake/console/cake bake
user PATH  /usr/local/bin:/usr/bin:/bin:/usr/games

1.2.0.5875 pre-beta

the response is
../cake/console/
Hello Phil
Fatal Error: cannot redeclare class Class ClassRegistry etc

On 2 Dec, 18:29, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote:
> How are you calling it?
> Are you using 1.2 prebeta, svn trunk/branch ?
> What is your path?
>
> I've used it on debian and ubuntu, never had problems.
>
> 2007/12/2, Phil <[EMAIL PROTECTED]>:
>
>
>
> > Hi
> > I have a simple cakephp app working, now trying to use bake
> > downloaded 1.2
> > installed php cli
>
> > error message is
> > cannot redeclare class ClassRegistry in /webroot/cake/cake/libs
> > class_registry.php on line 39
>
> > I am using debian etch, php5, cakephp 1.2, postgresql
>
> > I think its my configuration thats the cause, but am stuck
>
> > any ideas please
> > Cheers
> > Phil
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



bake newbie problem with configuration

2007-12-02 Thread Phil

Hi
I have a simple cakephp app working, now trying to use bake
downloaded 1.2
installed php cli

error message is
cannot redeclare class ClassRegistry in /webroot/cake/cake/libs
class_registry.php on line 39

I am using debian etch, php5, cakephp 1.2, postgresql

I think its my configuration thats the cause, but am stuck

any ideas please
Cheers
Phil
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



Re: Newbie, slow response, wrong tools ?

2007-09-29 Thread Phil

More stuff to learn then, at least it is encouraging to know moving
from msaccess is a good idea
Thanks for the help
phil


On 29 Sep, 07:21, AD7six <[EMAIL PROTECTED]> wrote:
> On Sep 28, 10:09 pm, Phil <[EMAIL PROTECTED]> wrote:
>
> > Newbie, slow response, wrong tools ?
>
> > I use ms access to run a small business and have decided to replace my
> > app with
> > linux, apache2, postgres 8., cakephp 1.2
>
> > so far i have got as far as adapting the bookmarks tutorial by graham
> > birdhttp://grahambird.co.uk/cake/tutorials/scaffolding.php
>
> > The problem is when I use it with 2500 records the response time is
> > circa 100 secs
>
> Hi,
>
> > am I ?
> > 1. displaying too big a data set
>
> Yes, but that won't account for 100seconds
>
> > 2. entirely in the wrong software with cakephp
>
> No, but there will be a number of things that you can do differently.
> Stopping using msaccess was one such fantastic decision already
> made :).
>
> > 3. should not be using scaffolding
>
> Scaffolding is there just for starting out, you would never use
> scaffolding on a real site.
>
> > 4. made some error with the table or coding
>
> If you use bake, you will get editable code instead of getting cake to
> generate a lot of logic on the fly all the time (see screencasts)
> If you run with debug set to 0 cake caches some setup info.
> If your tmp dir is not writable or missing, this is often a cause of
> slow response
> If you have any associations you could find you /think/ you are
> looking and retrieved a small amount of data whereas infact you
> retrieved a vast amount of data which you are not using.
>
> Once you have a simple application, if you then are still getting a
> slow response identify at least where the time goes (use the log
> function before and after a method you suspect, or use a profiling
> tool) - 100s is obviously extremely slow.
>
> hth,
>
> AD


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



Re: Newbie, slow response, wrong tools ?

2007-09-29 Thread Phil

Will do,
thanks for the suggestion

On 29 Sep, 04:37, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi Phil,
>
> The problem isn't the amount of records, it's that you're trying to
> display too many results on a single page at the same time.  For this,
> there is pagination.
>
> Read this on how to integrate pagination into your 
> app:http://bakery.cakephp.org/articles/view/advanced-pagination-1-2
>
> Kevin,
>
> On Sep 28, 4:09 pm, Phil <[EMAIL PROTECTED]> wrote:
>
> > Newbie, slow response, wrong tools ?
>
> > I use ms access to run a small business and have decided to replace my
> > app with
> > linux, apache2, postgres 8., cakephp 1.2
>
> > so far i have got as far as adapting the bookmarks tutorial by graham
> > birdhttp://grahambird.co.uk/cake/tutorials/scaffolding.php
>
> > The problem is when I use it with 2500 records the response time is
> > circa 100 secs
>
> > am I ?
> > 1. displaying too big a data set
> > 2. entirely in the wrong software with cakephp
> > 3. should not be using scaffolding
> > 4. made some error with the table or coding
>
> > the only odd thing  I have done was to load the table without a
> > primary key
> > change ty_id to id and add created and modified
>
> > code and table below
>
> > tyre.php in models
> >  > class Tyre extends AppModel
> > {
> > var $name = 'Tyre';}
>
> > ?>
>
> > tyres_controller.php in controllers
> >  > class TyresController extends AppController
> > {
> > var $name = 'Tyres';
> > var $scaffold;}
>
> > ?>
>
> > -- add indexes later
> > DROP TABLE tyres ;
> > CREATE TABLE tyres (
> > --ty_ID SERIAL primary key, -- auto number field
> > ty_product_code varchar(30), -- UNIQUE NOT NULL,
> > ty_short_size   integer DEFAULT 111 NOT NULL,
> > ty_load integer NOT NULL, -- usually 2 digits
> > ty_speedvarchar(2)   NOT NULL ,
> > ty_desc varchar(35)  NOT NULL
> > );
> > Bulk load data
>
> > -- alter table
> > ALTER TABLE tyres ADD column ty_ID  SERIAL;
> > -- add primary key
> > ALTER TABLE tyres ADD PRIMARY KEY (ty_ID);
>
> > ALTER TABLE tyres RENAME COLUMN ty_ID to id;
> > ALTER TABLE ADD COLUMN created TIMESTAMP;
> > ALTER TABLE ADD COLUMN modified TIMESTAMP;


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



Newbie, slow response, wrong tools ?

2007-09-28 Thread Phil

Newbie, slow response, wrong tools ?

I use ms access to run a small business and have decided to replace my
app with
linux, apache2, postgres 8., cakephp 1.2

so far i have got as far as adapting the bookmarks tutorial by graham
bird
http://grahambird.co.uk/cake/tutorials/scaffolding.php

The problem is when I use it with 2500 records the response time is
circa 100 secs

am I ?
1. displaying too big a data set
2. entirely in the wrong software with cakephp
3. should not be using scaffolding
4. made some error with the table or coding

the only odd thing  I have done was to load the table without a
primary key
change ty_id to id and add created and modified

code and table below

tyre.php in models


tyres_controller.php in controllers


-- add indexes later
DROP TABLE tyres ;
CREATE TABLE tyres (
--ty_ID SERIAL primary key, -- auto number field
ty_product_code varchar(30), -- UNIQUE NOT NULL,
ty_short_size   integer DEFAULT 111 NOT NULL,
ty_load integer NOT NULL, -- usually 2 digits
ty_speedvarchar(2)   NOT NULL ,
ty_desc varchar(35)  NOT NULL
);
Bulk load data

-- alter table
ALTER TABLE tyres ADD column ty_ID  SERIAL;
-- add primary key
ALTER TABLE tyres ADD PRIMARY KEY (ty_ID);

ALTER TABLE tyres RENAME COLUMN ty_ID to id;
ALTER TABLE ADD COLUMN created TIMESTAMP;
ALTER TABLE ADD COLUMN modified TIMESTAMP;


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---