hi There, i do not need to make a join just a "select * from where myCriteriaHere" the criteria is:
(initial_date <= myCustomInput1 and final_date >= myCustomInput1 ) or (final_date >= myCustomInput2 and initial_date <= myCustomInput2 ) or (initial_date >= myCustomInput1 and final_date <= myCustomInput2) As yo can see i need to acces 2 values for create the query, following your example supose i have 2 coupon fields, and into my addCouponColumnCriteria method, i will need access to my coupon value and my coupon2 value, but as long a i can see, if i use the method "addCouponColumnCriteria", i only have acces to the coupon field, that its value comes into the $value parameter. So how can i create a method addGENERICColumnCriteria, where i can have access to all the fields so i can create my complex criteria using all the values that i need? or is there any way to acces the values of the other fields inside addCouponColumnCriteria method? Do you got me? BTW i do not have any idea of what these things you used means: "CustomerPeer::ID, WebsitePeer::CUSTOMER_ID" Cheers -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en