14 Posts
10 years ago
Topic
Hi to all. I am using the following sql query with end behavior and choose some articles, based on custom fields. The problem is that while it works fine (i get the right results on the dropdown), it does not save the result to a storage place, declared as int (11). Could anyone help me with this? Thanks.
SELECT #__content.id AS value, #__content.title AS text FROM #__content INNER JOIN #__cck_store_item_content ON #__content.id = #__cck_store_item_content.id WHERE #__cck_store_item_content.race_institution = [parent]
SELECT #__content.id AS value, #__content.title AS text FROM #__content INNER JOIN #__cck_store_item_content ON #__content.id = #__cck_store_item_content.id WHERE #__cck_store_item_content.race_institution = [parent]
14 Posts
10 years ago
0
Level 1
For anyone that has a similar problem, I put an ; at the end of the query, which made the submit procedure misbehave. I removed it and everything is ok.