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 - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185795
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
