Hidden/Appearing Query Rows

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, https://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, https://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, https://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