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 Chriss Miller 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. pennstump

    Looking for help to simplify a SQL query

    It does, thank you. Is the CASE statement universal to all/most DBMSs?
  2. pennstump

    Looking for help to simplify a SQL query

    Hi all. I would appreciate it if you could take a moment to review my SQL code, which is now in the form of 3 statements with temporary views, and point me in the direction of simplifying it into 1 statement. CREATE TEMP VIEW voidedCounts AS (SELECT pibatch AS batch,count(*) AS counted FROM...
  3. pennstump

    Problem with sequence nextval() in embedded SELECT statement

    Great! Thanks. After some explicit CAST() calls, this worked perfectly.
  4. pennstump

    Problem with sequence nextval() in embedded SELECT statement

    I have an INSERT statement with an embedded SELECT statement similar to this: INSERT INTO a SELECT nextval('a_ID_seq') AS ID,0 AS status,false AS void,b.val AS value,c.code AS code,'test' AS createUser FROM b,c WHERE b.val=c.val ORDER BY c.val,b.val The issue stems from the ORDER BY statement...
  5. pennstump

    Any Internet-based CVSs out there?

    This is a total newbie question, but do any CVS systems work over the Internet like a sourceforge? I know that any of these systems could be exposed with a public IP address, with possibly some SSH, but are there any web-based applications (written maybe in .NET, java, PHP, etc) that can...
  6. pennstump

    PSQL text vs. varchar(n)

    I am having a problem with Java Studio Creator because the latest version of the JDBC driver returns a field length of -1 for text fields. My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I want to use the data binding part of the JSC tool I will need to convert my text...
  7. pennstump

    Maintaining Table Height After Adding Cell Borders

    I will try to clear up my description. I want to draw the border around multiple, dynamic cells of the table. In the table below, I would need to put a border around 0, 1, or 2 of these combinations: - ab,ef - cd - gh,kl -or- gh,kl,op ---------------------------------- | a | b | c...
  8. pennstump

    Maintaining Table Height After Adding Cell Borders

    I have a 4x6 data table with 100% width and a rather large (18px) font. I would like to add a colored border around certain cells as that cell's data is "checked off." I have the process down using JSF and CSS. My CSS is pretty basic, but effective: { border-top: 3px solid green; border-left...
  9. pennstump

    Nesting a SELECT in an UPDATE in a SELECT

    Nesting a SELECT in an UPDATE in a SELECT" == "Selecting the updated record from an update with a nested select" I've been searching for most of the morning without any luck on this topic. I'm not sure if it's even entirely possible with SQL, but I would like to be able to SELECT a row of work...
  10. pennstump

    Throughput Computing

    I posted a question last week, but I didn't receive any responses, so I would like to rephrase. Please excuse the repeat. I am looking to provide a financial modeling solution. We have a legacy, vendored appliation TAS from Classic Solutions (16-bit GUI on Windows Only) that parses and...
  11. pennstump

    Grid / Clustering / Parallel Processing Help

    I have an application that must run on Windows. This application creates data models on the order of ~2 Billion calculations per model. Today a 933Mhz machine can process roughly 50 of these per day. I have been tasked to build a cluster of 20 high end (3.0Ghz) PC's to distribute and share...
  12. pennstump

    PSQL Field Length Query

    Is there a way to query the db for the maximum length of a field for error-checking/truncation before writing? Thanks.

Part and Inventory Search

Back
Top