Andrea Corbally

Greenhorn
+ Follow
since Jul 28, 2003
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Andrea Corbally

Found my problem. I only had r.next not While(r.next()){}
19 years ago
I have a prepared statement that is only returning one record. When I execute the same query in sql plus I get 12 rows. Any ideas what it might be. I can submit all the code and details, but what would you want? sSessionHome or just prepared statement?
19 years ago
Thanks everyone for the suggestions. I am having difficulty adjusting to OOP. Thanks again!!
19 years ago
OK, I have a simple if statement and in watch window it is true, but it is failing. Here it is (simplified of course). You tell me what is wrong. Thanks in advance. my is a string of "-FEB-2003". Mnth is "FEB"

mnth = my.substring(1,4); // get month
if (mnth == "JAN") {
int m = 01;
}
else if(mnth == "FEB"){
int m = 02;
}
else if(mnth == "NOV"){
int m = 11;
}
else if(mnth == "DEC"){
int m = 12;
}
else {
System.out.println("MNTH is not valid: "+mnth);
}
19 years ago
Thanks for all of your comments. I have gotten my string down to "-MAR-2003". I now need to convert it into a date and add the day. So it would look like "01-MAR-2003" and "31-MAR-2003". Any ideas on how I can do that?
19 years ago
Yes, I believe that is what I want to do. I have an array of months that I need to turn into the date field (first day of the month and last day of the month) based upon the month they select.
Ex:
They choose April from the drop down. I want that to convert to 01-APR-2003
Does that make sense? It is a string and has no date value. I need to determine what month they choose and add the day and year to it.
19 years ago
I am new to java, but familar enough with programming, I thought I should post in intermediate, I hope someone here can help. My question is how to convert a string to a date. I am retreiving a month, from a drop down that I have created full with all 12 months. This is returned as a string. I need this with another text field where they enter the four digit year to turn into a date field. First with the first of the month and then with the last day of the month. Example
Drop down selection: "March"
Text entry for year: "2002"
I need it to look like this 01-MAR-2003 and 31-MAR-2003 in order for me to insert it into the database.
Let me know if you can help.
Thanks.
19 years ago