Query Stops Working....

[mark_W]

As soon as I add an extra argument to it.

  
  			String query = "INSERT INTO logged_calls" +
 			 "(firstName,secondName,telNumber,priority,dept,assetNum,category,summary,description,group)" +
  				"VALUES" +
 			 "('" + firstName + "','" + secondName + "','" + telNumber + "','" + priority + "','" + dept + "','" + assetNum + "','" + category + "','" + summary + "','" + description + "','" + group + "')";

If I remove the last bit I added, the group and group variable, so the query is as below

   
   			String query = "INSERT INTO logged_calls" +
 			 "(firstName,secondName,telNumber,priority,dept,assetNum,category,summary,description)" +
   				"VALUES" +
 			 "('" + firstName + "','" + secondName + "','" + telNumber + "','" + priority + "','" + dept + "','" + assetNum + "','" + category + "','" + summary + "','" + description + "')";

Everything works fine. Is there some sort of limit to how many fields I can pull out or anything, as there is nothing wrong with the code.

Its only an access database but I wouldnt think this would be a problem.

Thanks

[r937]

whaddya bet GROUP is a reserved word, eh

for Access, you escape reserved words with square brackets

INSERT INTO ... ( ... [group] ... ) VALUES ...

better would be to rename the column

[mark_W]

Tut...... Never even thought it could be that! Thanks so much rudy!