Memento

[quote=aditi19mitra;263246]hi guys, i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad:[/quote] …

[quote=g.prabu;330146]i have to call a stored procedure that shoud return all data in a table. so how to create procedure and how to return data from procedure. kindly send me a small example program .........[/quote] You need to return a ref cursor. See [URL]http://www.oradev.com/ref_cursor.jsp[/URL] for code examples specific to your …

I hope you can help me with this because I am out of ideas... I am trying to pass a structure [I]into[/I] an Oracle procedure and have had no luck… does anyone know how to pass a complex data type into an Oracle database? My idea was to pass in …

I have not used CF much since version 5... I would try running your query against the database outside of ColdFusion and fetching all the rows. That may help isolate where the problem is. If the problem turns out to be with the query, you may want to check the …

If you add the rowid pseudo column to your initial select statement you would see that it is different for both rows. The where clause of your update statement would then reference the rowid of the record you want to update.

Goal is something like: World > United States > North East > New York >list of cities Hidden form fields for: Country Region State City Your CFM page checks if the hidden form fields have a value, if they do, it will add them to whatever query you have to …

I always start with Google for PL/SQL questions. It sometimes takes me to techonthenet.com (syntax refresher) or expertsexchange.com but I never start my search with those sites. As a last resort I will occasionally browse the documentation for some tidbit. You can’t search for something if you don’t know it …

[quote=satish.paluvai;336148]can any body tell how to delete all the tables in a user ata a time[/quote] I have never had to do that so I don't know if there is a built in command to do it. The query below would return all the drop commands you need which you …

Might a SQL query like this work? [code=SQL]SELECT employee, SUM(login_date_time-logout_date_time) as empTime FROM login_log_table WHERE login_date_time BETWEEN X and Y GROUP BY employee[/code]

My sites <URLs snipped> are not taking off so I am thinking that the best route may be to stop trying to create a destination and instead create a service/tool that other websites can incorporate. Below are two examples of photo centric profiles that my web application provides that I …

In Oracle you can define your own data types which can act like tables and can be used to define columns in your table (see collections). Like you suggested you can also just store a list in a large text field. However, I would not use either of these approaches …

That schema shows more planning and thought then many corporate systems I have inherited.[LIST] [*]Merge sd_leaders, sd_volunteers, sd_contacts, and sd_pastors together.[LIST] [*]If needed, you can add one or more columns to this table to designate some special status, however, [*]You can determine their role(s) by whether sd_church_has_sd_pastors, sd_contacts_has_sd_worksite, sd_volunteers_has_sd_project, and/or …

I think if you are patient you will end up with an old website with few users. I am experiencing a similar problem myself regarding new forums; it seems you have to reach a certain critical mass of users for it to sustain itself. I have seen programs where you …

[quote=nikkiH;294612]Missing a where? SELECT weeklyMileage, totalMileageFROM mileage WHERE teamName=#teamName#[/quote] You also may want to look into using the GROUP by clause. For example, if your data is as follows: team, week_nbr, week_miles A,1,4 A,2,4 A,3,6 B,2,5 C,1,3 C,2,6 You could write a query like: SELECT team, SUM(week_miles) as total_miles FROM …

Hello, If I understand you correctly, you are trying to store multiple grades in one text/varchar column. To do this, the first grade would be put into the database using an INSERT statement with each consecutive grade getting inserted by an UPDATE statement because we are updating an existing record. …