network profile
| bio | website | |
|---|---|---|
| location | Germany | |
| age | 41 | |
| visits | member for | 1 year, 9 months |
| seen | Apr 8 at 19:52 | |
| stats | profile views | 6 |
|
Aug 11 |
awarded | Commentator |
|
Aug 11 |
comment |
Alternatives to MySQL Workbench IP tunneling is not an application issue, you'd do that separate on the system. Some apps include it for convenience, but it's not necessary at all, it's completely different issue. You can start ssh forwarding with a single line in a shell, and then tell the app to connect to the forwarded local port (on localhost) instead of the remote ip and port. Howtos are available by googling... |
|
Aug 9 |
awarded | Supporter |
|
Aug 9 |
awarded | Scholar |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' Works - marked as solution. Too bad this isn't nearly as simple as the Unix text pipe solution... |
|
Aug 9 |
accepted | How do I group results in batches of consecutive rows with the same 'module' |
|
Aug 9 |
revised |
How do I group results in batches of consecutive rows with the same 'module' added 253 characters in body |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' I must say if it gets even more complicated I feel you should get paid, but unfortunately it's more educational than necessary - I just have to let my brain do the filtering of the superfluous lines ;)... or I use a text-tool, e.g. "awk", or pipe the text result through "uniq" on the command line... |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' The EDIT: getting closer... I get [set_option_value,get_rights_usecase,set_option_value,get_rights_usecase,get_fun_AppOptionsSingleVal,get_rights_usecase], what it should be see my example result above. |
|
Aug 9 |
revised |
How do I group results in batches of consecutive rows with the same 'module' added 143 characters in body |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' I am looking for the modules IN ORDER without duplicate rows! As I said :) So it does not matter if you give me the first, last, whatever row in a date range - it is the same module (text). I just added the desired output for the example under the EDIT as well, hope that helps. |
|
Aug 9 |
revised |
How do I group results in batches of consecutive rows with the same 'module' added 198 characters in body |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' The examnple I gave is sufficient. Instead of "pdate" you could also use "id", an auto-incremented (sequence.nextval) column. Also see my EDIT. |
|
Aug 9 |
awarded | Student |
|
Aug 9 |
awarded | Editor |
|
Aug 9 |
revised |
How do I group results in batches of consecutive rows with the same 'module' added 751 characters in body |
|
Aug 9 |
revised |
How do I group results in batches of consecutive rows with the same 'module' added 751 characters in body |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' Result: Error code 904, SQL state 42000: ORA-00904: "C"."PDATE": invalid identifier - but that's because you took "L" for "C" after the join... :) And no, I get a different sequence compared to when I look at the raw data (and let my brain do the filtering/grouping) |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' You are right, "group by" would be a better explanation of what I want. Anyway, this doesn't change the problem. |
|
Aug 9 |
comment |
How do I group results in batches of consecutive rows with the same 'module' As explained in the question. Your idea seems obvious, as I said I tried it myself that way, but it doesn't produce the desired result. This question seems simple but it isn't... |
