Winston Liek

Ranch Hand
+ Follow
since Jan 19, 2014
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
2
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Winston Liek

Thank you for your message, since the processed values can only be 2 values, I created a subquery containing only those 2 values

Thank you for your suggestion. However I found a different approach for this one. I will now mark this as resolved.

The reason I am asking this is because we have an app that processes the batch. Initially, all records have Processed values = 'N'. When the application runs, it scans BatchId per batchId, row per row. After the method is done for that row, it updates Processed='Y'. However, when it encounters an error, the app stops.

Therefore, I need to create a report which last batchId should I continue to resume my app running.
Hi, Thank you very much for your follow up response.

Are you referring to this code:



But it does not return 3. It returns 1 instead
Hi Stephan,

I need to select the MIN batchId where it does not contain any 'Y' in it. In other words all 'N' in that batchId
Sorry, my question is

"How can I return the first batchId with no 'Y' in it?" In my given table, I need to return batchId = 3 since all 5 records under batchId = 3 has 'N' Processed value
Hi guys, I would like to ask for your help with regards to selecting the necessary records in the DB using MySQL. I have a batch that is executing. Each batch has batchId (integer) and contains many records (no definite count of records per batch). There is a column in the table 'Processed' and it's value is either 'Y' or 'N'. I would like to select the last batchId value that contains at least one 'Y' processed. How can I return batchId = 3 for this example:

given the table:

BatchIdProcessed?
1Y
1Y
1Y
1N
2N
2Y
3N
3N
3N
3N
3N
4N
4N
4N
Hi guys, I have a working web app on my local laptop and want it to transfer to azure. I have a file appender that writes in a file and stores it on my local computer. My logging is completely working when I deploy it on my local tomcat.

However, I can't see the log file when I successfully publish it in azure.
Here is my log4j.properties file:



Can someone please tell me where is the log file can be found in azure?
2 years ago
Hi, the reason why i am asking this is because i created an account on a website (not my own website) and i already logged in on my laptop. The user will remote access my laptop and use the website's dashboard as if i am the one accessing it. I do not want him to access some pages on that website (such as change password or email). It is not possible to create an account for his own as it needs to be my account.

Any way to do this?
2 years ago
I dont want him to copy my web app and open my source codes. I just want him to use my web app just like browsing the internet
2 years ago
Yes, my purpose is to prevent the user to copy my web app that i created since it is deployed on my local computer and he will be accessing my laptop. I just want him to use my web app pages.

So final answer is impossible as long as he cant access the tomcat manager? If that so then my next question is there any way for the user to edit the user config of tomcat server? How can i prevent it?
2 years ago
Hi, my os is windows 10. So is it possible to allow page urls instead of domain name only?

For example if i whitelisted:
Coderanch.com/categoryA

I will not allow the user to visit this site:
Coderanch.com/categoryB

But i will allow the user to visit this:
Coderanch.com/categoryA/threadA

2 years ago
how can I prevent it? I do not want him to copy my deployed war file.

If in case I deployed my war file in tomcat manager and I will not give him access to tomcat manager, will he still be able to find it in file directory or ftp?
2 years ago
Hi guys,

I have a tomcat and a web app that will be deployed on my local laptop. Then I will allow other user to remote access my laptop and use my application on localhost.

My question is, can the user be able to copy or download my deployed app on my local laptop? Because I do not want him to copy my program. I just want him to use it on my laptop remotely. No plans on uploading my app on cloud.

Thanks!
2 years ago