Why does WO create such an odd SQL statement:
UPDATE QA SET question = NULL, answer1 = NULL, id_users = ?, problem = NULL, date_modified = ? WHERE (id = ? AND answer1 = ? AND answer2 is NULL AND date_created = ? AND date_modified = ? AND figure1url is NULL AND figure2url is NULL AND figure3url is NULL AND id_language = ? AND id_qaDetails = ? AND id_users = ? AND keywords is NULL AND problem = ? AND question = ?)
'id' is the primary key. Why does WO not just use the primary key only?I know I have seen this discussed before but I can't find the thread anywhere. Does know the thread where this was discussed?
(This update fails, I presume because there are characters in the 'answer1' column that don't make the round trip so it can't find the row to update.)
Thanks in advanced. kib"Success is not final, failure is not fatal: it is the courage to continue that counts.”
- Winston Churchill -- Klaus Berkling Systems Administrator DynEd International, Inc. www.dyned.com | web.mac.com/kib
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
