jetwashphotos
Forum Replies Created
-
Forum: Plugins
In reply to: [ABASE] Query Button?Hey Richard,
Thanks. I have done a little work around, by placing the sql queries on individual pages for now. Click on the page link and the query runs.
Followup question for you though. Do you know if Abase runs queries concurrently or in sequence? For example, if I place two sql queries on a page, would it run the them in order of placement:
[abase sql=”UPDATE AVDMASTER p, SightingsEntrytmp pp
SET pp.MAKE = ‘1’ WHERE pp.UNIQUEID = p.UNIQUEID AND p.MAKE = ‘0’;”][abase sql=”UPDATE SightingsEntrytmp p, AVDMASTER pp
SET pp.MAKE = ‘1’ WHERE pp.UNIQUEID = p.UNIQUEID AND p.MAKE = ‘1’;”]I need to first query to be complete in order to run the second query.
Thanks,
Stephen
Forum: Plugins
In reply to: [ABASE] Hidden/Appearing Query RowsHello 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
Forum: Plugins
In reply to: [ABASE] Hidden/Appearing Query RowsHello,
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.