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:185791
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
