Works now.... I insert this query after the first INSERT query <cfquery name="commituser" datasource="#application.dsn#"> COMMIT; </cfquery>
Cheers >Hi all > >after insert a user record I need to show that same record to that >user. But using SELECT statement in other cfquery don't show that user >record. Please look this simple example: ><cfquery datasource="#application.dsn#" name="insertuser"> >INSERT INTO resourcebank ( userID,corpID,statusID,age1 ) >VALUES ("8EFACE46-795D-1267-34CB31AA6276B84F",17 ,1,37 ) ></cfquery> > >Insert works fine. > >By now I need to show user info: > ><cfquery datasource="#application.dsn#" name="getuserinfo"> >SELECT userID,statusID >FROM resourcebank >WHERE userID = "8EFACE46-795D-1267-34CB31AA6276B84F" ></cfquery> > >This query returns ZERO records.... inserting COMMIT after INSERT >query don't work. > > >How to refresh that connection to work like a charm? > >Cheers > >Marco ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54