DECLARE 	@LocalizedContentXML	AS INT

DECLARE @LanguageContent 			TABLE
(	LanguageId				int		Not Null	)

INSERT INTO @LanguageContent 
(	LanguageId	)

-- Values (1)

SELECT *
FROM	OPENXML(@LocalizedContentXML,  '/ArrayOfQuestionnaireMode/QuestionnaireMode/ModeLanguageCollection/QuestionnaireModeLanguage', 3)
WITH
(	LanguageId				'./Language/ID')

quote:

---

Originally posted by RitaBowman

I am receiving the following message

Server: Msg 170, Level 15, State 1, Line 30
Line 30: Incorrect syntax near './Language/ID'.

Using this code

DECLARE 	@LocalizedContentXML	AS INT

DECLARE @LanguageContent 			TABLE
(	LanguageId				int		Not Null	)

INSERT INTO @LanguageContent 
(	LanguageId	)

-- Values (1)

SELECT *
FROM	OPENXML(@LocalizedContentXML,  '/ArrayOfQuestionnaireMode/QuestionnaireMode/ModeLanguageCollection/QuestionnaireModeLanguage', 3)
WITH
(	LanguageId		int		'./Language/ID')

I can't see what the problem is. The xpath is correct, other's have looked at it and can't figure it out either.

Any ideas?

---