Friday
Sep282012

from attr() to prop(), why my checkboxes no longer work

Quick note/top. Come jQuery 1.6, the attr() function used for checking and unchecking items (radio button, checkboxes) has moved from

.attr('checked', 'checked) and attr('checked', '')

to

.prop('checked', true) and .prop('checked', false)

I believe it is supposed to be backwards compatible but I have not found that to be the case.

Tuesday
Sep252012

oraext:query-database tip

After searching Google for a bit a came across this blog post about an issue that many face when using oraext:query-database and getting an internal xpath error. The gist of it is this...when using oraext:query-database, ALIAS YOUR COLUMN...ugh...

example

BAD!!!

oraext:query-database('select something_something from dual',false(),false(),'jdbc/hphc_sbc')

GOOD!!!

oraext:query-database('select something_something as something from dual',false(),false(),'jdbc/hphc_sbc')

Seems its due to the length of the query string...

Tuesday
Sep252012

Namespaced Attributes and XPATHs

 Can across a curious thing yesterday, namespaced attribute.

<pe:headers>
<pe:header tns:name="content-type">application/pdf</pe:header>
<pe:header tns:name="version">22</pe:header>
<pe:header tns:name="content-disposition">12</pe:header>

</pe:headers>

I needed the following..

/pe:headers/pe:header[@tns:name = 'version']

Just a quick tip, looks like common sense but threw me for a minute...

 

Monday
Sep102012

CSS Variables

Good article on CSS Variables

 

Tuesday
Sep042012

Saving your bacon, Part II

 

Dropped a package or overwrote one with old code? Flashback can help...if you need get your DBA to grant the following if they can to you:

grant flashback on sys.all_source to YOUR_SCHEMA;

 

Now execute this sql to get the package back:

 

select text

    from all_source

    as of timestamp

    to_timestamp('04-SEP-2012 10:30:00', 'DD-MON-YYYY HH24:MI:SS')

    where name = 'YOUR_PACKAGE_NAME'

can save your bacon....