Search results for query: *

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.

"Why he would go through all that trouble to write the code and make it available at his website but not offer a sentence or 2 how how to use it, beats me !?" Uh, it's a set of utility classes. And he offers more than several sentences on use. http://www.carnageblender.com: Carnage...

you can't. on system 12, you can dynamically execute a string like this select @s = "1,2,3,4" exec("select * from foo where id in (" + @s + ")") but on 11 you're out of luck. http://www.carnageblender.com: Carnage Blender. Over 40 million battles served.

usually using a vendor extension to get only one row will be faster than matching with a subselect, e.g. select * from foo order by foo_id desc limit 1 rather than select * from foo where foo_id = (select max(foo_id) from foo) http://www.carnageblender.com: Carnage Blender. Over 40 million...

it really depends on your database's planner whether the join will produce faster results or not. Stylistically, it's better to only join to tables you are actually selecting data from. If using a subselect, however, you should use exists rather than in: ... where exists (select 1 from loan...

tables have no inherent ordering in ANSI SQL. so talking of "rearranging the records" makes no sense except in the context of clustering, which is database-specific. there is also no ANSI way to generate the ordering you want. You will have to use a vendor extension like Oracle's...