Search results for query: *

Thanks taupirho!

How can you parse a date with a "decode"?

Is there a method of modifying a date using sqlldr on insert? My data is like the following: 20061002 TESTDATA I would need to change teh 2006 to 2005 on loading. Is there a way to parse the date? Thanks for any ideas!

Is there a more efficient way of setting and getting strings from a bean than like my code below? Seems like way too much code for just setting two strings. Thanks for any ideas. package jspBean; public class dimA { //Indicator 1 String i1; String i2; public void setI1( String value )...

Dian, Currently, my code is like this. If I remove the following: public String getsetI1() { return i1; } How do I get my specific value returned? ---CODE------- (not sure how to mark this as code from teh forum) package jspBean; public class dimA { //Indicator 1 String i1; String i2...

I am new to JSP, so could you provide information on this reflection? or guide me to a good site that I could read. thanks again! JE

Could you provide an example? I'm not sure how i could get the "dimA1.getsetI1();" to execute from within an array? Thanks! JE

Is there a method to pull all the values from a BEAN and output? My goal is to get a quick count of all the values that equal "0"? Thanks for any advice.

An array is not going to help me here, because it will treat it as a string.

I have the following called from a JSP page: String setI1 = dimA1.getsetI1(); String setI2 = dimA1.getsetI2(); String setI3 = dimA1.getsetI3(); String setI4 = dimA1.getsetI4(); Is there a way I call call these dynically, like in a for loop similiar to this? for ( int i = 1; i < 5; i++) {...

I have a function that returns me a date based on reference data. TABLE_A ------- my_date_fld ref_code select myfunc(my_Date_fld,ref_Code) as NEW_DATE from TABLE_A; Depending on what DATE and REF_CODE I pass to it, a date is returned. I want to get a COUNT(*) of the unique dates returned...

In this case, data would not be deleted. The status field would be updated to reflect invalid data. I would still have teh original data, but information could change, like a last name (someone gets married) or as I mentioned, the status would change to make that row invalid. thanks! JE

I have a table with exist data: USERS --------- id username lname fname status Every night, I get the same data with updates or new rows added into a stage table. the stage table is refreshed nightly. USER_STAGE ---------- id username lname fname status What would be the best method of...

Sweet!!! Thanks! That's exactly what I needed.

TABLE_A ------- QUESTION_NO ANSWER TABLE_A ----- QUESTION_NO ANSWER 1 20 2 30 3 50 4 50 5 20 6 20 Is there a way I can group by the QUESTION_No? Like, if I wanted the...