On Dec 24, 2010, at 12:15 PM, Carey Gagnon wrote:
> 2010-12-24 10:00:58 - INFO - FAILED SQL: select `builders`.`id`,
> `builders`.`buildername`, `builders`.`address1`,
> `builders`.`address2`, `builders`.`city`,
> `builders`.`provstate`, `builders`.`postalcode`,
> `builders`.`phonenumber`, `builders`.`faxnumber`,
> `builders`.`url` from `builders` where `builders`.id = %s limit 1
> 2010-12-24 10:00:58 - INFO - DBQueryException encountered in execute():
> (1064, "You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> '%s \n limit 1' at line 12")
> select `builders`.`id`,
> `builders`.`buildername`,
> `builders`.`address1`,
> `builders`.`address2`,
> `builders`.`city`,
> `builders`.`provstate`,
> `builders`.`postalcode`,
> `builders`.`phonenumber`,
> `builders`.`faxnumber`,
> `builders`.`url`
> from `builders`
> where `builders`.id = %s
> limit 1
>
> I do not have a limit 1 clause and if I understand the above where clause
> the builders.id in not being picked up. Builders is a child of Contacts.
Is the LinkField set properly? Is the Builders bizobj added as a child
bizobj of Contacts?
> This was all working fine prior to the update to 6278, but even if I revert
> back to 6238 where it was working before, it doesn't work there either. I'm
> puzzled
Can you post the bizobj code for Builders? I don't need any data
validation, business rules, etc., if any of that is proprietary; just the parts
that define the bizobj's data relationships.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
