[RESOLVED] Please help with preparedstatement

[Nitesh]

Hi Guys, please help me

I have this code inside a loop:

String f_supplier = nextLine[7];
				long Sid = 0;
				
				if (!f_supplier.equals("")) 
				{
					
				  try
				    {
					stSupplier = ITdb.prepareStatement("SELECT OurID FROM Mapping WHERE MapName = ? AND Active=1");	
  				      rsSupplier = stSupplier.executeQuery();
					stSupplier.setString(1,f_supplier);
					
					   if (rsSupplier.next()) {			
            				Sid = rsSupplier.getLong("OurID");
						
							//if no record found
					   } else {
											
						Sid = 0;
							
					  } // if
				}catch (exception e) {
					e.printStackTrace();
				}

				}else{

					Sid=0;
				}

but I get this error:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
        at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3149)
        at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:216)
        at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:91)
        at BusbyFTP.doImport(BusbyFTP.java:126)
        at BusbyFTP.doWork(BusbyFTP.java:51)
        at Job.doWork(Job.java:81)
        at JobPane.btnRunNowActionPerformed(JobPane.java:148)
        at JobPane.access$500(JobPane.java:11)
        at JobPane$6.actionPerformed(JobPane.java:139)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6041)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
        at java.awt.Component.processEvent(Component.java:5806)
        at java.awt.Container.processEvent(Container.java:2058)
        at java.awt.Component.dispatchEventImpl(Component.java:4413)
        at java.awt.Container.dispatchEventImpl(Container.java:2116)
        at java.awt.Component.dispatchEvent(Component.java:4243)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
        at java.awt.Container.dispatchEventImpl(Container.java:2102)
        at java.awt.Window.dispatchEventImpl(Window.java:2440)
        at java.awt.Component.dispatchEvent(Component.java:4243)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

[Nitesh]

im so stupid, I had these two lines the wrong way around:

rsSupplier = stSupplier.executeQuery();
					stSupplier.setString(1,f_supplier);

the problem seems fixed now