[PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

2011-03-26 Thread Richard Quadling
Hi. What preferences do you all have when using SQL. Stored Procedures or PHP generated dynamic SQL or parameterized static SQL. Whichever you use how do you test them? Do you use unit testing in your PHP code? If so, do you also have unit code testing for the SQL statements (I suppose this

Re: [PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

2011-03-26 Thread Geoff Lane
On Saturday, March 26, 2011, Richard Quadling wrote; What preferences do you all have when using SQL. Stored Procedures or PHP generated dynamic SQL or parameterized static SQL. Whichever you use how do you test them? Do you use unit testing in your PHP code? If so, do you also have unit

Re: [PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

2011-03-26 Thread Bastien
On 2011-03-26, at 9:00 AM, Richard Quadling rquadl...@gmail.com wrote: Hi. What preferences do you all have when using SQL. Stored Procedures or PHP generated dynamic SQL or parameterized static SQL. I used both. SPs work for some of the larger reports, especially when combined with a