Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. expostfacto

    Python telnet server -- Server not sending back output to client

    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...
  2. expostfacto

    Any sqlObject users? (Triggers question)

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

    Jet 3.5 SQL and tables

    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.
  4. expostfacto

    math question

    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.
  5. expostfacto

    Case sensitivity in Sybase Database

    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.
  6. expostfacto

    Altering column size

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

    saving a file in a database

    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.
  8. expostfacto

    Sybase if statement question?

    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...
  9. expostfacto

    SQL Table Pivot-like Requirement

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

    is there any other shorter way to write these queries

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

    is there any other shorter way to write these queries

    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.
  12. expostfacto

    SQL Table Pivot-like Requirement

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

    "missing expression"

    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.
  14. expostfacto

    Simple? Java Date Query

    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.
  15. expostfacto

    How to use this JAR file?

    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.
  16. expostfacto

    How to use this JAR file?

    "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...
  17. expostfacto

    IN operator

    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.
  18. expostfacto

    Optimizing a Query

    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...
  19. expostfacto

    is there any other shorter way to write these queries

    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...
  20. expostfacto

    SQL Table Pivot-like Requirement

    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...

Part and Inventory Search

Back
Top