Search results for query: *

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?

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

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

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

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

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

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'