hibernate - Join same table and fetch sub folders in mysql query -


I have a table to save "folders" in the document management system.

So I need to recover all folders ID from a folder id. E, the sub folders list of a folder.

Is it possible to join self in the same query?

try 

  from the folders to choose d.folder_id d In, for folders e where d.parent_id = e.folder_id

Comments

Post a Comment

Popular posts from this blog

Android - Facebook GraphUser has no email attribute -

I checked online sources about this issue and checked it twice - but I still get the email attribute Can not Facebook Response As indicated on the launch, I have applied the permissions ("original_third", "email", "user_bridade") to read on the login buttons. Also set the same permissions when creating a session (session .createFromExistingAccessToken). However, on the callback function, when the GraphUser and Response object is logged, I was still not able to retrieve the user's email. Why the error still persists, what are the possible reasons for this? Am I missing some steps? ** onCreate () ** ((Login button) ViewById (R.id.dialog_generic_footer_button_fblogin)) .setPublishPermissions (FBSessionV2.getPermissions ()); String & gt; GetPermissions () {if (permissions.ISTT)} {PERMISSIONS.add ("basic_info"); PERMISSIONS.add ("email"); PERMISSIONS.add ("publish_actions"); PERMISSIONS.add ("user_birthda...
Read more

Opencart and VQMOD issue: Could not load controller in vq2-system_engine_controller.php -

I am using Opencart 1.5.6.1 and VQMOD 2.4.1. I have installed the Ewe Rapid 3.0 extension now and at checkout, I get this error: Notice: Error: Controller payment / EVE could not be loaded! On line 47 trigger_error ('Error: Could not load controller'. ($) At $ ($) ... \ vqmod \ vqcache \ vq2-system_engine_controller.php in line children! '!'); I'm not sure whether this is anything with the VQMD or EVE extension. How to fix this? Steps to try: Check if you have a eway.php in the list / controller / payment folder Verify the square name of that file: Class Controller Payment and Controller { . Check file permissions. It's a good day!
Read more

deployment - How to upload Parent child SSIS package to server -

Image
Hi all I am very new to SSIS I got some SSIS package developed by some other person, this flat after package mapping. Reads data from files and stores in the database. Flow: 1) To first extract the package into the flat file and in the table in the store 2) Then it calls the child package using the package package. 3) Then baby packages do some calculations and update the database table. The SSIS database is using environment variables to get information. Everything is working fine, but now I want to deploy it to the package on my client's server. Q: Do I need to copy and paste from the bin folder and paste it on the client machine? What I tried: I copy the file from the bin folder and keep it on my local computer. Then I prepare a job in MSSQL and run the work. The package runs completely but later I changed the location of my project and the problem started, the work stopped. Problem: An error says that the location of the hair package is not available (as I have changed ...
Read more