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: *

  • Users: pennstump
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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