M Ryder

Greenhorn
+ Follow
since May 01, 2008
Merit badge: grant badges
For More
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 M Ryder

yes, I got it.. makes sense
15 years ago
Thanks Bear. I will review the mvc.
15 years ago
Hi,
I am trying to determine the best way to get a resultset from a servlet to display as a report on a jsp page. Any suggestions?
Thanks!
15 years ago
Thanks Chad, sometimes a second pair of eyes will do the trick
Hi Jeanne,
I have modified my code below and it still doesn't fix the issue. Any other suggestions?
Thanks Jeanne. Still can't get it to work, now I get to many quotes
('1','2','',') something is not right, I will keep on trying.
i am trying to query a database with selections from a jsp form to create a report. I am pulling the selections into a servlet, adding delimiters and then using in a where clause, but I can't seem to get the syntax right (I think i have been staring at it to long). instead of getting ('1','2','3') I am getting ('1,2,3,') so it is not working. Any suggestions would be greatly appreciated.

getting parameters from jsp;

adding delimiter;

where in clause:

[ May 16, 2008: Message edited by: Scott Selikoff ]
Thanks Scott. The javascript function creates a hidden variable which is passed to a servlet. The servlet then pulls the variable into the where clause.
Hi,
I am trying to take the values from a hidden field created with a js function and pass them into a select...from...where clause and can't seem to get the syntax right. The js function stores the values like ("cat,dog") but for the where clause I need them to be like ("cat","dog"). I am not sure whether this is more a js question or jdbc question, so please forgive me if I am in the wrong forum. I will attach my function. Thanks in advance for any suggestions.