Can I modify the values of a query?

For instance.. I do a select * on a table with a column called "state"
and it returns some rows with state value of IL and some rows with
state value of CA.

Could I loop through that query and change the IL values to CA, so
that the next time that query is looped through, all IL values would
be CA ? Or do I need to build a new query?

-Jason

-- 
Open BlueDragon Public Mailing List
 http://www.openbluedragon.org/   http://twitter.com/OpenBlueDragon
 official manual: http://www.openbluedragon.org/manual/
 Ready2Run CFML http://www.openbluedragon.org/openbdjam/

 mailing list - http://groups.google.com/group/openbd?hl=en

Reply via email to