1. delete multiple records using checkboxes coderanch.comHello, I have a dynamic list of data, next to each is a checkbox with specific data as the value, I want to pass all of the values from this to another page that will place them into an SQL statement and perform and action on ... |
2. Displaying Multiple Columns And Records from database. coderanch.comhello there,i have a table called 'user_meaasurement' and i need to display all the columns and its records onto a JSP page.any idea how to display all the columns and its records out? my rs.getstring can only retrieve one column and its record. Im not really sure how to do it.any help is appreciated.thanks. The following are my codes // Load ... |
3. Fetching Multiple Records Through Functions coderanch.comI have a requirement to find the max of purchase for the user and then find the avg of those max records retrieved. So i created a procedure which joins multiple tables and hence calling the below function for one of those columns. CREATE OR REPLACE FUNCTION salesAvg RETURN NUMBER IS sc NUMBER; avgsales NUMBER; sales_cursor refcur_pkg.sales_cursor; BEGIN OPEN sales_cursor FOR ... |
4. Displaying a Single Record with a Comma Separated Column from Multiple Records coderanch.comHi There, please see the below code(it is MYSQL) but i need the query in oracle. In this table for each id_no there is one or more items identified. Each record contains a single item value. I will use the code listed below to populate the above table: - Hide quoted text - -- create example table CREATE TABLE Example2(id_no int ... |
5. Synchronizing database record manipulation by multiple rmi clients coderanch.comHi All, I have an RMI Server that allows clients to retrieve,edit and remove records from a database. How do I make sure that not more than one client can edit an order at the same time? So far the method below does all my database manipulation, but I don't think this is safe. public class MyImplementation extends UnicastRemoteObject implements MyRemoteInterface ... |
6. Best way to retrieve data from database and display multiple records on web forums.oracle.comI'm new to java and I'm building an application where users will enter some keywords on a web page (jsp page). Based on those keywords I'm building a sql statement in my java code to find the appropriate records. I have the code that connects to my database and I can loop through the result set, but I'm not sure of ... |