Prepared statement within a stored procedure loop

Does anyone have a rough idea of what the syntax for a prepared statement would be inside a loop of a stored procedure.

Example:

while x < 10
  preparedStatement = "SELECT label" + x + " FROM field" + x + " WHERE item = "somestring"
execute(preparedstatement)
end loop

i realize the syntax above is all screwed up. any help would be appreciated, or a GOOD url. notice how the table and field element dynamically change according to the value of "x"

send a carbon copy of your reply to jonx.williams_at_intel.com

thanks a bunch

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 11 1999 - 18:31:08 CDT