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

    date format conversion

    Hey, How may I be able to convert a date with the format of yyww with will be year and week, to a format of mmyy which will be month and year?
  2. memphisTNdev22

    java.sql.SQLException: invalid column index

    I am tring to execute the following query in a JSP and a I am getting a java.sql.SQLException: invalid column index what am I doing wrong..... String sqva = "Select atc.mobn, atc.accn, atc.acct_name, atc.act_date, rtrim(atc.svc_name), atc.comamt from atlcomm atc where atc.acin in...
  3. memphisTNdev22

    radio button

    I have a function that is called on a select box, but each time the select box value is changed my radio button goes to the value that has the checked attribute next to it.What am I doing wrong here? Here is the select box function: function processChangeArea(prev) { with (document.mainForm)...
  4. memphisTNdev22

    using sql queries as a string in JAVA

    yes, i need the final query to say.. select * from table union select * from table union select * from table Currently it is attaching as select * from table union select * from table unionselect * from table The union is attaching to the select statement
  5. memphisTNdev22

    using sql queries as a string in JAVA

    I am trying to union three queries as a string and my last select statement is attaching to the union.. For example. String s1 ="select * from table" String s2 = "select * from table" String s3 = "select * from table" String s4 = " s1 + " UNION " + s2 + "UNION" +s3 ;" The output looks like...
  6. memphisTNdev22

    selecting a certain number of records

    great that worked! How would I retrieve 27 percent of records = 'A', 36 percent of records = 'B', and 36 percent of records = 'C' from one table
  7. memphisTNdev22

    selecting a certain number of records

    How can I select a different number of records for different data within a column..For example...i need to select 50 records where type = 'A', 100 records where type = 'B', and 25 records where type = 'C'

Part and Inventory Search

Back
Top