Help with query (new to java!)

[gpittingale]

i have a form. its populated with a specific field from a mysql using java this is the code for the first page.

<c:forEach var="parish" items="${parish.rows}">
<option value="${parish.id}">${parish.ParishName}</option>
</c:forEach>
</select><br><input type="submit" value="submit" name="submit" /></form></td>

on the second page i would like to call a the row that was selected in the dropdown box here is what i have so far:

<sql:query var="parish" maxRows="1" dataSource="jdbc/gav">
SELECT ParishName, OwnerOccupierHousehold, OwnerOccupierPercOfOverall, OwnerOccupierCo2Emissions,
SocialRentedHousehold, SocialRentedPercOfOverall, SocialRentedCo2Emissions, PrivateRentedHousehold,
PrivateRentedPercOfOverall, PrivateRentedCo2Emission, TotalHouseholds, TotalPerc, Average,
Total2001, TotalEstimatedTotal2006, EmissionsPerPerson, EmissionPerHousehold, EmissionsPerParish,
EnergyChampionsNeeded, NumberOfPeopleAtWork, NumberOfSchoolAgeChildren
FROM base_data
<sql:param value="${param.id}"/>
</sql:query>
<c:set var="parish" scope="request" value="${parish.rows[0]}"/>

i know this is not correct cause i should add something after the "FROM base_data line but i am a bit stuck to what it is can someone set me straight be abusive as you wish after it should be quite simple!!

Thanks in advance

[serjant]

<sql:setDataSource dataSource="jdbc/gav" /> 
<sql:query var="parish" maxRows="1" 
sql="SELECT ParishName, OwnerOccupierHousehold, OwnerOccupierPercOfOverall, OwnerOccupierCo2Emissions,
SocialRentedHousehold, SocialRentedPercOfOverall, SocialRentedCo2Emissions, PrivateRentedHousehold,
PrivateRentedPercOfOverall, PrivateRentedCo2Emission, TotalHouseholds, TotalPerc, Average,
Total2001, TotalEstimatedTotal2006, EmissionsPerPerson, EmissionPerHousehold, EmissionsPerParish,
EnergyChampionsNeeded, NumberOfPeopleAtWork, NumberOfSchoolAgeChildren
FROM base_data WHERE id=?"
<sqlaram value="${param.id}"/>
</sql:query>
<c:set var="parish" scope="request" value="${parish.rows[0]}"/>

[tghn2b]

sorry not to talk java serjant
But if you give your photo a gamma correction of about 1.8 it will fix up the brightness, (and any other pictures that comes out of that camera) it seems that not a lot of people with electronic cameras know this.

[serjant]

sorry not to talk java serjant
But if you give your photo a gamma correction of about 1.8 it will fix up the brightness, (and any other pictures that comes out of that camera) it seems that not a lot of people with electronic cameras know this.

Spam message?