im getting a sql exception thrown from the line of code below.
The error is "SQL Exception: A syntax error has occurred."
both 'fav_price' and 'surface' are doubles in the java code and decimals in the informix db.
can anybody see an obvious error?
"select surface,st_momemtum,mom_ampli,momasy_p1,momasy_p2,set_to_set,score_inf,st_sts,effect_11_22 from guide_params_3_set where fav_price = "+fav_price +" and surface = "+ inputs.SURFACETYPE+";"