>ok, this is wacked, but another developer came over and told me that his >view in oracle worksheet is different, here you have to actually tell it to >commit....arg! i was not aware of that, so as soon as i commited the >changes to the table, cf showed me the correct recordset. >
I know you found your answer, but it sounds like your literally in your first few days with Oracle and your new employers (UPS, was it?) haven't gotten you up to speed on it. I thought I'd just give you another tip/trick that you may find useful: When you log in to Oracle using tools such as Worksheet, you have started a "session." As long as you don't log out or get otherwise disconnected (your session is still open), you can also do INSERTs, UPDATEs, and DELETEs without the changes becoming permanent. If you're in Worksheet and just want to see if one of the above query types will work with a bit of code your building, you can simply run your script, run a SELECT or whatever to verify that the result is what you expected, and then type "rollback" (without the quotes) and your changes will be undone. This is quite a handy feature during development that I don't believe SQL Server has (though I may be mistaken). The one caveat to watch out for is that you can't use that trick via CFML. Each database request you make via cfquery is technically a different session (the code behind </cfquery> must close it), so any changes you make will be immediately reflected. That tip may help, it may be useless, but, either way, have a good weekend!! Regards, Dave. _________________________________________________________________ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137766 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
