Search results for query: *

Phew!!!! My goodness im glad i got that sorted. Thank you all for your amazing (and swift) response!!

The values are being submitted from a form via a bean TeamRegisterBean.I have changed the query around,having tried with above solution from alex,i have changed data type to varchar and entered a new userName called styx. public boolean registerTeamtoSystem( TeamRegisterBean registerTeam)...

Ok i have implemented above method which has made a difference but however,is still not adding to db my print stack trace is showing that data is being passed to option1... but is still throwing an error ...syntax to use near '(option1 ='D James 3.0',option2 ='F Quedrue 2.5',option3 ='M...

I dont have the values im trying to add to option1,option2 fields for the specific user 'heggy'

Im getting the values from a bean which i need to return statement.setString(1, registerTeam.getGoalkeeper()); statement.setString(2, registerTeam.getRightBack()); statement.setString(3, registerTeam.getLeftBack()); and so forth for all the options... So it would be something like INSERT...

This is a simple issue but ive been staring at it so long i cant get it and its driving me mad statement = _connection.prepareStatement("INSERT INTO users (option1,option2,option3,option4,option5,option6,option7,option8,option9,option10,option11) VALUES (?,?,?,?,?,?,?,?,?,?,?) WHERE userName=...

hi tim ive just had a read around and this is defintley the right approach,however the problem is that i have 5 tables of players (goalkeepers,fullbacks,midfielders etc) At the moment i have primary key as "Player_Id". If i was to change primary key in each of those tables to...

Hi Chrissie, I am storing all the players in a single table, i just need each table name to be specific to the user name,there will be a different user name each time a team is registered,how do i integrate this into my sql statement regards, styx218

I am developing a fantasy football application.When the user makes choice of players, i need them to be stored in a seperate table,that applys to only them,so that when the user is logged in i can retrieve the values from the table and display in a bean. So it will be titled whatever the...

Hi Guys, Im developing a function to allow users to modify there passwords.im having a little trouble finishing it off,can anyone give any pointers? Simple form to take parameters form name = "passwordform" action = "LoginServlet" method = post> <input type="hidden" name="ACTION...

That helped a lot thanks phil :)

Ok i settled on using sql:query tag to display my data,which is working fine. How would i go about appending the choice selected in my drop down menu to a table on the same page? i am developing a fantasy football application which requires 11 drop down boxes and for the choices to be displayed...

Hi guys, Just a quick question.I am developing a jsp application an dwould like to display records from my sql database dynamically from a drop down box.Is this possible.And would the page have to be reloaded everytime a user selected a record from the drop down box.Any help appreciated...

Thanks for quick reply statement = _connection.prepareStatement("INSERT INTO teams (Name) VALUES (?)");

Hi guys, Just joined the board so a big hello to you all. The reason im here is because im having a sql related issue. Im using a form to gather user details to store in sql database. But when i add records they are being saved as "Null".What am i doing wrong here? Any ideas?