Josue Cedeno

Excellent!!!

I can understand your response. It really wasn't a lot to go on, but I do appreciate the summary. And I especially appreciate you taking time to respond.
I was able to solve the problem. I was assuming that it was a problem with the driver (and it still may be). I was testing a "null" result in the stored procedure and the result was not understood. So I changed the test and it worked.
Thanks again.

When will we see you again?
Can't wait 'til you get back. Have fun!!

First, I am using the jdbc-odbc driver.
Using I-SQL I am retrieving a resultset of one row, but in my servlet I am retrieving "0" rows.
Any ideas?

I emailed the code. I really appreciate your help. I've tried isolating the problem and it still doesn't make sense.

Currently I have a stored procedure which evaluates three scenarios and appends to a temporary table depending on the selection.
if 1
insert temp table
if 2
insert temp table
if 3
insert temp table
display temp table
On the command line this works fine, but when I call this stored procedure using the jdbc-odbc bridge I can only retrieve a resultset when the option is "3"
Any ideas?

Welcome to the drive Peter!! If you like pain than this is the place. =) You're gonna love it!

Not the flu. Booo! Feel better Marilyn. Get lots of rest.

All praise goes to the nitpickers ( especially Marilyn )!! The ranch is the closest I have come to a serious curriculum in programming. And without the stress of a deadline, who could ask for more?
Thank you to everyone at the ranch!!

Welcome to the drive!!
Until now, I never had a good excuse to use all (at least the max:8 .. Boo to the restriction) of them. Have fun!! :roll:

I guess if you try hard enough you can break anything. It took me 1111111 attempts on "Say" and it almost broke me.

Finally a thread that I know something about and you guys are all done. Louise is right. Be aware of your quotation marks.
I hope this doesn't totally give it away (where's the fun in that anyway)

Welcome to the Drive! It's going to be a rough ride so don't "say" I didn't warn you.
Have Fun!

As always, great job Marilyn!!!

I am currently working on a project which passes form data to retrieve data using a stored procedure. It is a basic commission report.
The current IT team uses servlets heavily, but I wonder if JSP would offer a more efficient solution.
Is an MVC solution using JSP(view), Servlets(Controller), Bean(Model) the optimal solution for this project?
(This is a sincere question, but also a ploy for a free servlet reference book)