This content has been marked as final. Show 26 replies
That by far is the most important application I've seen APEX put to lately :)
only 9 more days to go ....... I can barley wait.
Happy you enjoy it... maybe an app for the wiki, apex studio or sourfourge?! ;-)
I suppose you're a VS supporter? Belgium isn't even qualified!
That's the ultimate killer application for Apex ;-)
But how do you know already first results ;-) ????
The number 1 app I've seen.
I've filled Englands scores in for you.
We should make it multi-lingual ;-)
I already created a translation page; http://htmldb.oracle.com/pls/otn/f?p=12318:204
Waiting for translation in English and German
your script has at least an error
failed to parse SQL query:
ORA-00904: "M"."WROUND": invalid identifier
this column is not defined in the table
as far as I can see. Could you post the updated ddl script somehow? It is interesting - I will provide a link to my user to a copy of your application (got to be in English).
Cool app. You may want to put some security on the ">> Update Score <<" link or someone may have some fun changing the results!!
I made this little application (partial) multi-lingual ;-)
The translation depends on the language settings of your browser.
(IE: Tools - Internet options - Language; Firefox: Tools - Advanced - Language)
The country names are dynamically taken. I created a new table and based my queries on a view. I translated the countries in Dutch, English, French and German.
In my query I've now where c.lang = <application item> where I store your language of the browser.
For Dutch I also made an XLIFF translation.
* The column names I couldn't translate?! Is this a bug or should it be a feature enhancement? *
-with translation: http://htmldb.oracle.com/pls/otn/f?p=12318:overview
-without translation: http://htmldb.oracle.com/pls/otn/f?p=12318:soverview
I updated the zip-file on my blog with the latest version (the multi lingual page is also included)
Hope it works now,
The application is now available in following languages:
- Dutch (nl)
- English (en)
- French (fr)
- German (de)
- Simplified Chinese (zh-cn) - China
- Traditional Chinese (zh-tw) - Taiwan
- Japanese (ja)
(only the countries are translated)
Thanks to Robert Pang for the translations (zh-cn, zh-tw, ja) and the testing of the application... it took a while, but finally we managed to get it working!
To show the flags: grant execute on PROC_FLAG_DISPLAY to public
a colleague of mine made a similar application, but then you can bet on each game what the result will be, and it supports multiple users so the whole company can bet on it (and in the end see who has the most points).
ApEx sure has some good uses ;)
You're not the first who tells me the idea of betting ;-)
Some people of the customer I'm currently working for, already asked me if I couldn't add that. So if this already exists, I'm interested to see it... If you allow me, I'll integrate your code in the app.
* Only one thing, I don't allow betting for money! Betting for an Oracle T-shirts is a lot more fun ;-) *
Tell you what.....
If you can come up with a method where people can somehow bet and then accumulate points (i.e. so at the end of the World Cup we have a ranking of how many points people have got) then....
...I will throw in a Years Free Hosting as the prize of the person who scores the most points.
(Obviously I've left out the fine detail of how you work out how people score points ;)