Re: Any thing wrong with this..

sbValue.append("INSERT INTO photos (album,section,sequence,caption,pic) VALUES ("1,1,1,'some text',87);");

This line has an unterminated double quote I see three of them in this line. One before INSERT, one just after VALUES, and one after the semicolon at end of SQL statement.

This also seems to me like a heck of a low level way to run a SQL statement. Maybe there's an advantage to this, but I generally just use EOUtilities.rawRowsForSQL to do this kind of work for me. Something like:

String sql = "INSERT INTO photos (album,section,sequence,caption,pic) VALUES (1,1,1,'some text',87);"

EOUtilities.rawRowsForSQL(ec, "MyModel", sql, null);

Maybe that's a bad idea, but it seems to work for me.

On Oct 30, 2006, at 12:41 PM, Gino Pacitti wrote:

Hi All

I have this code:

EOEntity anEntity = EOModelGroup.defaultGroup().entityNamed("Photos");
EOModel aModel = anEntity.model();

EOAdaptorChannel myAdaptorChannel = this.adaptorChannelForModel(aModel, ec);
myAdaptorChannel.openChannel();
StringBuffer sbValue = new StringBuffer();
sbValue.append("INSERT INTO photos (album,section,sequence,caption,pic) VALUES ("1,1,1,'some text',87);");
String SQLString = sbValue.toString();
EOSQLExpressionFactory expressionFactory = new EOSQLExpressionFactory(EOAdaptor.adaptorWithModel(aModel));
myAdaptorChannel.evaluateExpression(expressionFactory.expressionForString(SQLString));
myAdaptorChannel.closeChannel();

Can anyone see anything obvious why this will not commit to the database?

Gino
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden

Robert Walker

email@hidden

References:
	>Any thing wrong with this.. (From: Gino Pacitti <email@hidden>)