Re: Any thing wrong with this..

Mon, 30 Oct 2006 11:11:58 -0800

Gino,

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 protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]

--
Robert Walker


 

 _______________________________________________
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]

Reply via email to