amelton
· Edited by
tariqrahiman
Aquascript Help
I have a table with two columns: `Name` and `City`. I would like to create an Aquascript that would prompt the user to supply a name and output a table with the number of occurrences of `name` by `city`.
The sql would be something like:
select count(1),city from records
where name like 'xxxxxxx'
group by city
I tried slimming down the "Company Revenue Advanced" example, but that was more than I needed. Can you assist in creating the above?
Thanks.
The sql would be something like:
select count(1),city from records
where name like 'xxxxxxx'
group by city
I tried slimming down the "Company Revenue Advanced" example, but that was more than I needed. Can you assist in creating the above?
Thanks.
Hello Andrew,
I have created a very simple script which will accept city name as the user input and will display the count. See attached screenshots and Sample.xjs. I basically worked on the Company Revenue Advanced and trimmed out items like Export, Email which you can add easily. Let us know if you need anything else
The table structure I used is below:
CREATE TABLE city (
Name varchar(25) NOT NULL,
City varchar(25) NOT NULL
)
ENGINE = InnoDB
GO
Thanks. Hello Andrew, I have created a very simple script which will accept city name as the user input and will display the count. See attached screenshots and Sample.xjs. I basically worked on the Company Revenue Advanced and trimmed out items like Export, Email which you can add easily. Let us know if you need anything else The table structure I used is below: CREATE TABLE city ( Name varchar(25) NOT NULL, City varchar(25) NOT NULL ) ENGINE = InnoDB GO Thanks.