Re: Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
Re: Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
- Subject: Re: Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
- From: email@hidden
- Date: Fri, 10 Oct 2003 12:16:08 +0100
Hi Bob
On Friday, October 10, 2003, at 08:02 am, Bob McCormick wrote:
Hi All,
FROM \"AUTHOR\" AS \"T0\" WHERE (\"T0\".\"FIRST_NAME\"=\"BOB\") AND
(\"T0\".\"LAST_NAME\"=\"MCCORMICK\");. Next exception:SQL
State:null -- error code: 485 -- msg: Semantic error 485. Near:
\"BOB\". Next exception:SQL State:null -- error code: 217 -- msg:
Semantic error 217. Datatypes are not comparable or don't match.
Next exception:SQL State:null -- error code: 226 -- msg: Semantic
error 226. Referenced column - MCCORMICK - not found. Next
exception:SQL State:null -- error code: 485 -- msg: Semantic error
All these escaped quotes look suspicious to me. But it may be just me.
Can you browse the AUTHOR table in EOModeler? (yellow cylinder icon)
For some reason the database thinks that "BOB" and "MCCORMICK" are
column names, not strings. You may need to put them in single quotes.
Now, since I'm using this EOModeler tool and I'm technically not
supposed to have to touch SQL code, I'm really not sure where to even
begin looking for a problem. Ah, the joys of being a newbie.
How are you not supposed to have to touch SQL code?
EOF takes out the hassle of coding direct requests, and switching
between different databases (with different SQL dialects). But if you
are serious about building a database-driven application, whatever the
technology it will help to know some SQL. Which is not difficult by the
way.
Cheers,
-- Denis.
Any kind soul out there care to set me straight?
Appreciate any help on this.
Thanks...Bob
Bob McCormick
XebraTech
(805) 302-3359
_______________________________________________
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.