Is this the one you mean?

Wild Irish Rose

In a field by a river
my love and I did lie
And on my naked shoulder
she too proud to cry
She said that I must leave her
an icy tear she froze
How could I melt the heart
Of a Wild Irish Rose

Well a gypsy she has made of me
A servent of the street
And back to bed I've travelled
To taste a love as sweet
Well the heart it knows no reasons
And reason never knows
As I lie with them I'm thinking
Of a Wild Irish Rose

Well I saw the city of angels
It brought a devil out in me
And Hell's hotel on Sunset
Showed a whore no mercy
As the orange sky was screaming
From the roof I let her go
These are the dizzying heights that brought me
My Wild Irish Rose

Now red is the rose
That she layed on my grave
A life is what she wanted
And a life I surely gave
Like a hundred men before me
They lay lying here in rows
Young men, bloody
As a Wild Irish Rose

Ed