Advertisement

02.12.2008 at 12:49PM PST, ID: 23157681
[x]
Attachment Details

Java and Ms Access

Asked by sonchoy in Java AWT & Swing, Microsoft Access Database, SQL Query Syntax

I am writing a front end in Java and using MS Access Databse as backend
I am getting syntax error
String strSQL = "SELECT tblArtistCategory.[ArtistCategory_ArtistName] FROM tblArtistCategory WHERE tblArtistCategory.[ArtistCategory_CategoryName]=" + this.jCboCategory.getSelectedItem() ;

what's wrong with this?Start Free Trial
[+][-]02.12.2008 at 12:53PM PST, ID: 20878848

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Java AWT & Swing, Microsoft Access Database, SQL Query Syntax
Sign Up Now!
Solution Provided By: cmangus
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628