2006年01月20日

first,I want to add an unique set like following:
alter table section add constraint section_name_seating_chart_unique unique(name,seating_chart_id);

an error occurs:
Duplicate entry ‘Producer’s Assistant-40′ for key 2

I find an article mentions it:
http://wwwprog.chez-alice.fr/mysql.htm

!!! Strange stuff with UNIQUE KEY and the MODIFY:
If you plan to modify a column which is included into unique set then you shoulddrop the index given the first column refered into the unique key then apply the change


alter table section drop index SECTION_SEATING_CHART_FK;

when I run above,another error occurs:

Error on rename of ‘.\trs\#sql-42c_21′ to ‘.\trs\section’ (errno: 150)

though some talked about that,none tell me why and how.
at last,I throw the project away,and make validation with Hibernate,everything ok,but I am unhappy.


alter table section drop index SECTION_SEATING_CHART_FK;

when I run above,another error occurs:

Error on rename of ‘.\trs\#sql-42c_21′ to ‘.\trs\section’ (errno: 150)

though some talked about that,none tell me why and how.
at last,I throw the project away,and make validation with Hibernate,everything ok,but I am unhappy.

2006年01月19日

behaviour.js:
http://bennolan.com/behaviour/
run code on elements thru CSS selector


degrader.js:
http://swik.net/Typo/Encytemedia/Graceful+Degradation+with+Prototype,+Scriptaculous+and+Ruby+on+Rails+-+Part+2:+The+Tools+Of+The+Trade/63w
event attach(observe) thru id pattern match



above can bring us AJAX features with less code.
specify id or arbitrary other html attributes,implying the action and data,bind and trigger them automatically.
we can build components,views,layouts,themes more easily.