Search a Query Result Set
-
I can search a table using the abase shortcodes below.
Page 1
[abase form=”1,search,” from=”FOOD_DES” columns=”Long_Desc=%Long_Desc%$Search”]
Page 2
[abase table=”FOOD_DES” columns=”NDB_No,Long_Desc” link=”
NDB_No,“]
Clicking on the link
- NDB_No
results in the request
Page 3
[abase table=”ABBREV” ]This returns the expected result from the table.
Can someone help with returning the results of a query instead of a table? If I replace the table attribute in page 3 with the from attribute then all the rows are returned, not just the row NDB_No = nnnnn.
If there is an error in the SQL, then the SQL test is displayed. Is there a way of viewing a valid SQL query that is generated?
Many thanks
Richard Harding
- The topic ‘Search a Query Result Set’ is closed to new replies.
