You could output the results on an extra page by adding an url parameter in form=”…”
[abase form="1,search,/results" table="employees" columns="first_name,last_name$Search Employees" elements="first_name,last_name"]
then on the /results page
[abase table="employees" columns="first_name,last_name" ack="green"]
BUT the whole data set would still be viewable to the clever user when he goes directly to /results.
Any ideas for a better solution?
Kind of solved this by adding limit=”1″ on the results page.
I found a solution.
In mySQL I created 3 columns: ID, product and URL
ID Product Url
1 let it empty let it empty
2 Product-1 URL-1
3 Product-2 URL-2
4 Product-3 URL-3
5 Product-4 URL-4
If you would write limit=”1″, then it would be the list preview empty.
[abase table=”TABLE” columns=”url” alink=”url,../../product/,url,’_blank'” notitle=”1″ limit=”1″]
Hello,
Newbie to Abase, some sql experience. I have a similar question. I would like the search box to appear on page opening, but the table preview is taking too long. I have 70,000+ rows in this table. Here is my current ABASE query:
[abase form=”1,search” table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]
[abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,FLIGHT,MAKE” ack=”green”]
I have 1 million+ in another table, so I would really like some assistance.
Try something like:
[abase form=”1,search, http://XXXXX/testing-2″ table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]
On another page testing-2, place
[abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,FLIGHT,MAKE” ack=”green”]
Richard Harding
Hello Richard,
That is perfect. Thanks. What I have done is place: [abase form=”1,search, http://XXXXX/testing-2″ table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”] on the testing
and on testing-2, I have place both shortcodes [abase form=”1,search, http://XXXXX/testing-2″ table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]
and [abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,FLIGHT,MAKE” ack=”green”]
This way the search form is always available. No going back and forth.
Thanks again,
Stephen
Wonderful – and it is a great idea to place the search form on the second page. It makes it easier to use.
Richard
