----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Here's the code that actually submits the values from the Form:
"
String sqlINSERT=("INSERT INTO GamerFinder(Name, Country, StateProv,
AreaCodeIntExt, City, Email, Title, Game, ZipCode, Event, PhoneNum,
Address, Website, Age,YearsExperience, Gender, Languages, Notes) VALUES
('"+ strName + "','" + strCountry + "','" + strStateProv + "','" +
strAreaCodeIntExt + "','" + strCity + "','" + strEmail + "','" +
strTitle + "','" + strGame + "','" + strZipCode + "','" + strEvent +
"','" + strPhoneNum + "','" + strAddress + "','" + strWebsite + "','" +
strAge + "','" + strYearsExperience + "','" + strGender + "','" +
strLanguages + "','" + strNotes + "');");
stmtI1.executeUpdate(sqlINSERT);
"
-Hawke
Kirk Benson wrote:
>
> ----------------------------------------------------------------
> BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
> WHEN YOU POST, include all relevant version numbers, log files,
> and configuration files. Don't make us guess your problem!!!
> ----------------------------------------------------------------
>
> It appears that you may be obtaining the parameter value as a single string
> via HttpServletRequest.getParameter(). To obtain multiple values it is
> necessary to call getParameterValues() which returns a String array.
>
> hope this helps
> Kirk
>
> > -----Original Message-----
>
> > This problem has plagued me for months now (real time spent on it maybe
> > around 10 hours total, coming back to it, giving up, etc), and I can't
> > seem to find an answer, so please, anyone that has any ideas, HELP! :)
> >
> > For reference, the site I'm having this trouble is:
> > http://www.gamerfinder.com/AddToDB.html
> >
> > When you select more than one item (using Shift/click or Ctrl/click)
> > from the multiple choice boxes, and then click submit, only the first of
> > the selected items for each box will be submitted.
> > I don't believe it's my code or a Java issue, I believe it's a Servlet
> > engine issue, here's why:
> >
> > When I run this exact same application on the servlet engine provided
> > with Symantec Cafe DB Edition 3.0c, but still hit the same DB server
> > (from my laptop), the multiple values get submitted no problem.
> > Now, unless there's something quirky about Cafe's servlet engine, that
> > seems pretty good evidence, but there's more...
> > This servlet USED to work, many months ago, it was when I was fiddling
> > with jserv install, that I realized some weeks later, that it was having
> > this "bug". Unfortunately, since it was so much later, I don't know what
> > changed. I tried fully uninstalling, and reinstalling all of the jserv
> > (back then 1.0), but now difference.
> > I installed 1.1 when it came out, still no difference.
> > I am majorly perplexed about what to do. I am about to give up on jserv
> > and start using Sun's web server with the built in servlet support (the
> > servlet works on that engine too). But I would rather stick with jserv
> > if this can be figured out.
> > Here's my system info for the site:
> > Solaris 7 (with patches)
> > Apache 1.3.9
> > jserv 1.1 loaded as apache module
> > jsdk 2.0
> > java 1.1.8
> > MySQl 3.22.29
> > org.gjt.mm.mysql JDBC connector
> >
> > Thanks again to anyone that can offer some constructive help on this
> > beguiling issue.
> > -Hawke
> > [EMAIL PROTECTED]
> >
> >
> > --
> > --------------------------------------------------------------
> > Please read the FAQ! <http://java.apache.org/faq/>
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Archives and Other: <http://java.apache.org/main/mail.html>
> > Problems?: [EMAIL PROTECTED]
> >
>
> --
> --------------------------------------------------------------
> Please read the FAQ! <http://java.apache.org/faq/>
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Archives and Other: <http://java.apache.org/main/mail.html>
> Problems?: [EMAIL PROTECTED]
--
-Hawke
Systems & Components Architect
for Franklin Covey eSolutions.
Independent Java Developer, Webmaster,
Photographer, & Multimedia designer.
The statements included are solely based on my own opinion,
and in no way reflects any position or approval by my employer.
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
