Slackerksg5
Programmer
My problem is retrieving data from a sql table called "section". The portion that I want is s_name(Section Name), but I am attempting to grab them one at a time using an increment of which ever page I am on.
So my attempt at doing this is as follows...
SELECT s_name INTO :inspectionName FROM section WHERE s_id = :index ORDER BY s_name USING sqlca;
index is the page I am on and the row I need to grab, but obviously this doesn't work, because it gives me the name for whichever index I am at. Therefore if I had a,c,b,d,g,f,e in the database that would be the way in which I retrieved it even though what I was looking for was a,b,c,d,e,f,g any help is appreciated. Thanks in advance.
Oh I also attempted to use that above query and load the values into an array, but was unable to sort the array... Maybe I simply over looked something.
So my attempt at doing this is as follows...
SELECT s_name INTO :inspectionName FROM section WHERE s_id = :index ORDER BY s_name USING sqlca;
index is the page I am on and the row I need to grab, but obviously this doesn't work, because it gives me the name for whichever index I am at. Therefore if I had a,c,b,d,g,f,e in the database that would be the way in which I retrieved it even though what I was looking for was a,b,c,d,e,f,g any help is appreciated. Thanks in advance.
Oh I also attempted to use that above query and load the values into an array, but was unable to sort the array... Maybe I simply over looked something.