Hello,
I am running into a problem with an application that doesn't work too
well with mutliple rows. Therefore, I need a script that will return a
SINGLE row. This is what I'd like to do:
I have a table (cash) that has 3 fields (date, id, balance). I would
like to be able to retrieve the balance for the last 5 days for a
unique id.
Ideally the result would look like this:
date1, balance1, date2, balance2, etc.
I did get this to work with temporary tables, but then the script was
run by the app, I got a "Can not issue data manipulation statements
with executeQuery()" error. This obviously indicates the other
constraint... using executeQuery, and thus no data manipulation.