anyone know where to get any? especially the opening theme "No Need to Promise"

Please read the 'Filled Transcriptions' Thread before you request next time. There is an index there that has a list of Escaflowne music.

Index (http://alphatrance.com/0engine/music/anime/master-index.php)