Hello Everyone
i try to execute a SQL query in List Component. but its show
error .my query :
SELECT * FROM `test_question`,quiz_test_question_detail WHERE
test_question.`id`= quiz_test_question_detail.test_id and
quiz_test_question_detail.quiz_id = 49 and test_question.`is_active`
limit 40
and my Schema is :-
Quiz:
actAs: [ Timestampable,DmSortable ]
columns:
name: { type: string(200), notnull: true, unique:
true }
category_id: { type: integer, notnull: false }
syllabus: { type: string(1000), notnull: false ,extra:
markdown }
rules: { type: string(1000), notnull: false ,extra:
markdown }
is_active: { type: boolean, notnull: true, default: false }
relations:
Category:
class: Category
local: category_id
foreign: id
foreignAlias: Quizs
onDelete: CASCADE
QuizTestQuestion:
class: TestQuestion
local: quiz_id
foreign: test_id
foreignAlias: Quizs
refClass: QuizTestQuestionDetail
QuizTestQuestionDetail:
columns:
quiz_id: { type: integer, notnull: true }
test_id: { type: integer, notnull: true }
relations:
Quiz:
class: Quiz
local: quiz_id
foreign: id
foreignAlias: QuizTestQuestionDetails
onDelete: CASCADE
TestQuestion:
class: TestQuestion
local: test_id
foreign: id
foreignAlias: QuizTestQuestionDetails
onDelete: CASCADE
TestQuestion:
actAs: [ Timestampable,DmSortable ]
columns:
name: { type: string(200), notnull: true}
is_active: { type: boolean, notnull: true, default: false }
can i help me how to write Doctrine Query in TestQuestion List
function in Component ?..........
thanks in advance
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
