Programming Help

Web Development

Welcome to Dream.In.Code
	Getting Help is Easy! Join 109,153 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,132 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now! Chat LIVE With a Expert Register to Make This Box Go Away!

dushi	18 Jun, 2008 - 08:43 AM Post #1
New D.I.C Head Joined: 23 Feb, 2008 Posts: 39	hello, i have made a program to store, edit and delete data from mysql database. at first it was working perfect. then a went to make another application that looks the same. now my first application does not work any more. it loads all the data from my database, but it does not edit and delete anymore. and i did not change the codes. i just copy paste them to make my second application and i have another question: i'm trying to use a jComboBox to search data on my database. i'm using this code: rs.setCommand("SELECT * FROM aanmeldingsformulier WHERE" + jComboBox1.getSelectedItem() + " = ?"); but when a i run it gives me this error: java.sql.SQLException: no value specified for parameter 1. can someone help me? thnx
	This Post Was Helpful! ^New!

Trogdor	19 Jun, 2008 - 02:56 AM Post #2
D.I.C Regular Joined: 6 Oct, 2006 Posts: 448 Thanked 1 times Dream Kudos: 125 My Contributions	Q1: you probably did change something in either the code or in the field layout of the database. Maybe you added an extra field somewhere? Q2: if you want to compare with the character "?" then you need to add database-string quotes: SELECT * FROM aanmeldingsformulier WHERE" + jComboBox1.getSelectedItem() + " = '?'
	This Post Was Helpful! ^New!