[fw-general] Weird bug in ZF?

2010-08-12 Thread Jigal sanders
hello i have a very weird bug. I have pasted all code here: http://pastebin.com/K5riS3ng its in the zend framework. In the beginning of the function all my values are there. But when creating the sql statement all the values are gone. Any Idea's? J. Sanders

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Chris Riesen
On line 11 you check if the value is a db expr. Those are string,s so it always goes to else, which means it prints a ? in it, thats it. Unset on line 13 is not needed. Besides, if you have a table, defined as a Zend_Db_Table you can just to this: $table = new UserTable(); // assuming your table

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Jan Pieper
@lists.zend.com Betreff: [fw-general] Weird bug in ZF? hello i have a very weird bug. I have pasted all code here: http://pastebin.com/K5riS3ng its in the zend framework. In the beginning of the function all my values are there. But when creating the sql statement all the values are gone. Any Idea's

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Jigal sanders
/Prepared_statements#Parameterized_statements with regards, Jan Pieper Original-Nachricht Datum: Thu, 12 Aug 2010 10:13:24 +0200 Von: Jigal sanders jigalroe...@gmail.com An: fw-general fw-general@lists.zend.com Betreff: [fw-general] Weird bug in ZF? hello i have

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Bill Karwin
On Aug 12, 2010, at 9:41 AM, Jigal sanders wrote: 2.Select `user`.* FROM `user` WHERE( usr_email = `em...@adres.com`) LIMIT 1 For one thing, use single-quotes for string literals. The back-ticks are for table names and column names. Regards, Bill Karwin

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Jigal sanders
Bill please dont look at that query i typed it over in stead of copy paste it from firebug db profiler. So it cant be that. On Thu, Aug 12, 2010 at 6:59 PM, Bill Karwin b...@karwin.com wrote: On Aug 12, 2010, at 9:41 AM, Jigal sanders wrote: 2.Select `user`.* FROM `user` WHERE( usr_email =

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Bill Karwin
On Aug 12, 2010, at 9:41 AM, Jigal sanders wrote: Hi, I realized that. I was just blinded by something. I am trying already two weeks to debug my application and something goes wrong with inserting data to my db from my form. And the problem is that: 1. It says in my screen An Error has

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Jigal sanders
Bill Thanks for your time. Do you suggest that i paste the code below in an controllerAction and then execute it? On Thu, Aug 12, 2010 at 10:20 PM, Bill Karwin b...@karwin.com wrote: On Aug 12, 2010, at 9:41 AM, Jigal sanders wrote: Hi, I realized that. I was just blinded by something. I

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Bill Karwin
I assumed your pastebin example showed a function insert(), I was suggesting that you add the diagnostic error_log() to this function (temporarily). You could alternatively enable the Zend_Db_Profiler so it records the SQL statements it executes. Then run your insert and see what's in

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Jigal sanders
Bill, According to my profiler, the insert qeury is never executed. On 13 aug. 2010, at 00:00, Bill Karwin b...@karwin.com wrote: I assumed your pastebin example showed a function insert(), I was suggesting that you add the diagnostic error_log() to this function (temporarily). You could

Re: [fw-general] Weird bug in ZF?

2010-08-12 Thread Bill Karwin
On Aug 12, 2010, at 3:08 PM, Jigal sanders wrote: According to my profiler, the insert qeury is never executed. Try fetching profilers with getQueryProfiles(null, true) to include unfinished statements (those with no end time recorded). It would be good to examine the SQL generated, so