RP_property ,is my parameter.
FROM property_info AS pi
WHERE pi.propertyid = :RP_property
Now if I set RP_property to a valid entry say 001 it works no problem; but if I set it to pi.propertyid ,it returns nothing. It should return the entire table. I don't know if there's a way to show the generated query somehow after all parameters and what not get filled in at run time, so i'm just guessing it's because of some quotes being added.
I'm sure there's an easy work around with the spreadsheet designer/java api i don't know about yet. I'm still rather new in the realm.
Please let me know if you have any suggestions or thoughts!
Parameters without quotes
1 reply to this topic
Posted 29 February 2012 - 07:29 AM
FYI, I ended up just making a sproc and built a dynamic sql statement based on the parameters, rather then just try to pass off column names as variables. It worked for me, although I'd still be curious if there's a way to do this in spreadsheet designer.