EOModeler Generating Bad SQL
EOModeler Generating Bad SQL
- Subject: EOModeler Generating Bad SQL
- From: MadBrowser <email@hidden>
- Date: Mon, 10 Nov 2003 23:35:49 -0800
EOModeler WO 5.2.2 on Panther 10.3.1.
I have the following qualifier:
((emailAddress = $emailAddress) and (password = $password) and
(administratorStatus = 'yes'))
This generates the following SQL:
SELECT administrator_status, country, editor_status, email_address,
first_name, last_name, password, quality_cost_preference, rec_num,
street_address_1, street_address_2, us_city, us_state, username,
wants_casino_offers, wants_newsletter, year_of_birth, zip_code FROM
user_account WHERE (email_address = ? AND password = ? AND
administrator_status = ?)
Why is it trying to take administratorStatus as a variable when I am
explicitly requiring that the field contain the value 'yes'?
I have been fiddling with this and can't seem to figure this out.
Am I doing something wrong or is this a bug?
Thanks,
Hunter
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.