Re: [Dbix-class] [newbie]How to call stored procedure?(doc already read)

2007-12-29 Thread Tony Winslow
Peter Flanigan wrote: Tony Winslow wrote: Danny Warren wrote: It would be helpful if you could post a code sample. I am sure someone could spot it quickly that way (more eyes, etc etc). Check to make sure the first argument to your search call is truly undef, and make sure you are pas

Re: [Dbix-class] [newbie]How to call stored procedure?(doc already read)

2007-12-29 Thread Tony Winslow
Peter Flanigan wrote: Tony Winslow wrote: Danny Warren wrote: It would be helpful if you could post a code sample. I am sure someone could spot it quickly that way (more eyes, etc etc). Check to make sure the first argument to your search call is truly undef, and make sure you are pas

Re: [Dbix-class] Write only + No-read/retrieve on a column

2007-12-29 Thread Ashley Pond V
On Dec 29, 2007, at 12:47 AM, Peter Edwards wrote: I'd think twice about mastering your images in the database. It depends on data volumes and number of simultaneous accesses, but the easiest is to keep them in a directory hierarchy under Unix with a normal backup to protect them, running an

Re: [Dbix-class] help with dbix::class syntax

2007-12-29 Thread Mark Smith
> I am writing a small catalyst application for online maintenance of leave > records at the office. I need to ensure that a dept head is not flooded with > all the leave applications, but gets only those pertaining to his dept. I > have a users table and a leave_application table. The first table

[Dbix-class] help with dbix::class syntax

2007-12-29 Thread jagdish eashwar
Hi, I am writing a small catalyst application for online maintenance of leave records at the office. I need to ensure that a dept head is not flooded with all the leave applications, but gets only those pertaining to his dept. I have a users table and a leave_application table. The first table con

Re: [Dbix-class] [newbie]How to call stored procedure?(doc already read)

2007-12-29 Thread Tony Winslow
Peter Flanigan wrote: Tony Winslow wrote: Danny Warren wrote: It would be helpful if you could post a code sample. I am sure someone could spot it quickly that way (more eyes, etc etc). Check to make sure the first argument to your search call is truly undef, and make sure you are pas

Re: [Dbix-class] [newbie]How to call stored procedure?(doc already read)

2007-12-29 Thread Peter Flanigan
Tony Winslow wrote: > Danny Warren wrote: >> It would be helpful if you could post a code sample. I am sure >> someone could spot it quickly that way (more eyes, etc etc). >> >> Check to make sure the first argument to your search call is truly >> undef, and make sure you are passing your array of

RE: [Dbix-class] Write only + No-read/retrieve on a column

2007-12-29 Thread Peter Edwards
AP >> What do you think? Two classes for the table? One for admin functions >> which has the LONGBLOB in it and one for the web app (Catalyst) which >> doesn't? >> >> Is there a better trick for this kind of thing? MS >Typical SQL "best practice" is to use two tables ... the meta-data >table (or ma

Re: [Dbix-class] Write only + No-read/retrieve on a column

2007-12-29 Thread Mark Smith
> What do you think? Two classes for the table? One for admin functions > which has the LONGBLOB in it and one for the web app (Catalyst) which > doesn't? > > Is there a better trick for this kind of thing? Typical SQL "best practice" is to use two tables ... the meta-data table (or main table) an