Recent content by expostfacto

You have several problems. First, you need to capture the command's stdout (and probably stderr), not just its return code. Read the subprocess documentation for how. ("stdin, stdout, and stderr specify what the subprocess's input, output, and error streams will be. You can provide a file...

No. SQLObject doesn't deal with triggers. http://spyced.blogspot.com: a python blog

1) sounds like you'll have to kick off the other users first :) 2) use a subselect: update foo set bar = (select asdf from baz where foo.id = baz.id) http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

boil down your sql to the simplest example that errors out, then fix it. :P http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

you just need to set the sort order to a case-insensitive one. http://manuals.sybase.com/onlinebooks/group-ch/chg0300e/charsets/@Generic__BookTextView/796 http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

read the docs on alter table. http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

you can use either LOB or BYTEA. there's a lot on these in the mailing list archives (or google groups). http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

that doesn't make sense to me. what tool are you using to execute this query? what happens when you do this? if exists ( select 1 from sysobjects where name = 'DB_IN_QUESTION' ) begin select 1 end else begin select 2 end http://www.carnageblender.com: Carnage Blender. Over 40...

thanks, good to know. http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

out of curiosity, which is that? http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

perhaps a sufficiently smart planner will be able to see that the IN is functionally equivalent to the exists, but I have not seen any vendor's database do this correctly. http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

what is the ANSI equivalent of CONNECT BY, then? http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

it looks like it thinks you're trying to call a function called professors_t. http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

you're going to have to play with the Calendar or Date classes. see http://mindprod.com/calendar.html http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

sorry, but you really should read some basic documentation on classpath before asking stupid questions. much less criticising the author of a library for not providing "java for dummies" tips. http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.