ADF table – delete current row

This one had me up the wall for quite a bit of while…

I’ve been searching the web for all permutations of “ADF Delete button removes the wrong row” with no luck. But then I finally found the answer.

When a view object is dragged onto a page as a table and you then drag the Delete-operation in. You do not use the operations toolbar – for whatever reason.
Continue reading

Posted in Software development | Tagged | 1 Comment

WordPress: Comments are closed (???)

My wife has a blog as well. And she’s get comments on hers (not jealous, not me *sigh*).

Problem was all her post said “Comments closed”. It couldn’t be solved with setting any “Discussion” settings, turning off all plugins. Nothing helped. So she called the resident geek.

After some searching, head-scratching and a lot of speed-reading on a Google-search. I found this topic on WordPress Support.

For me the gems here a bit down the page. A few SQL’s to change comment status.

I’m dumping the here so I don’t forget them:

  • Globally enable comments for all users:
    UPDATE wp_posts SET comment_status = ‘open’;
  • Globally disable comments for all users:
    UPDATE wp_posts SET comment_status = ‘closed’;
  • Globally enable comments for registered users only:
    UPDATE wp_posts SET comment_status = ‘registered_only’;
  • Globally enable pingbacks/trackbacks for all users:
    UPDATE wp_posts SET ping_status = ‘open’;
  • Globally disable pingbacks/trackbacks for all users:
    UPDATE wp_posts SET ping_status = ‘closed’;

Hope you find them useful as well.

Posted in Software development | Leave a comment

Site open for comments

I thought I was being clever…

I had added a plugin to WordPress – that should allow people to use their logins from other socials sites to login for commenting. But, but, but … when testing it wasn’t clear that this was possible.

So I’ve removed the plugin as well as the requirement to login to leave a comment.

Comments still need approval and Askimet is active as well.

Posted in Uncategorized | Leave a comment

Oracle JDeveloper 11.1.2 or 11.1.1.6

In Sten Vesterli’s post the question the question of whether one should go for JDev 11.1.2 or JDev 11.1.1.6 (lastest R1).

Chris Muir answers this in the comments: 11.1.2 is for JSF 2.0 only. In 11.1.2 the bug-fixes will be back-ported from 11.1.1.6 as this is the version Oracle is using for their Fusion Applications development effort.
Continue reading

Posted in Software development | Tagged , | Leave a comment

Oracle database: schema versioning

When working on a project where the data model isn’t completely stable, you want to be able to run scripts changing one or more database schemas. But how do you make sure that all updates run successfully. And how do you avoid running the same update script twice one a schema.

One a project some years back I had the opportunity to work out a way to handle this.
Continue reading

Posted in Software development | Tagged , | Leave a comment