Query Works in SQL, but Not in Java? [SOLVED]

[Al Johnston]

Hi,

I'm not sure why I can't get this to work...

The code is:

    
            rs = statement.executeQuery("SELECT TOP 1 CPA_Offer.AdvertiserID, CPA_Advertiser.subConcat " +
                    "FROM CPA_Offer" +
                    "INNER JOIN CPA_Advertiser" +
                    "ON CPA_Offer.AdvertiserID = CPA_Advertiser.AdvertiserID " +
                    "WHERE OfferID = " + offerID);

If I copy and past this into SQL Query Manager, it works fine:

  

SELECT TOP 1 CPA_Offer.AdvertiserID, CPA_Advertiser.subConcat
                    FROM CPA_Offer
                    INNER JOIN CPA_Advertiser
                    ON CPA_Offer.AdvertiserID = CPA_Advertiser.AdvertiserID
                    WHERE OfferID = 232

 

When I run this in Java, I get "java.sql.SQLException:... Incorrect syntax near "."... at OfferClicked.getTestLink(OfferClicked.java:203)"

Why does this work in SQL, but not Java? Your help is much appreciated.

Best,
Al

[Al Johnston]

Nevermind. I figured it out. Seems that there was not enough space between the values.

Changed it to:

   

           rs = statement.executeQuery("SELECT TOP 1 CPA_Offer.AdvertiserID, CPA_Advertiser.subConcat " +
                    "FROM CPA_Offer " +
                    "INNER JOIN CPA_Advertiser " +
                    "ON CPA_Offer.AdvertiserID = CPA_Advertiser.AdvertiserID " +
                    "WHERE OfferID = " + offerID);
 

Now it works.

[Sagar Rohankar]

For such long quires, you can always use string object to hold the query string.
like:

String myQuery = "SELECT TOP 1 CPA_Offer.AdvertiserID," +  
                 "PA_Advertiser.subConcat FROM CPA_Offer " +
                 "INNER JOIN CPA_Advertiser ON " +
 		         "CPA_Offer.AdvertiserID = Advertiser.AdvertiserID " +
                 "WHERE OfferID = " + offerID;

and you can edit and make the subject line as [SOLVED]... to let other know & save their time.

[Al Johnston]

Thanks Sagar.

I will edit the forum topic.

Best,
Al