Here's how I got it to work for anyone interested:
SELECT * FROM 'tablename' ORDER BY 'tablename'.'column' DESC LIMIT 1
Search found 11 matches
- Wed Oct 16, 2019 4:53 pm
- Forum: Q/A
- Topic: Queries and scraping to tables
- Replies: 2
- Views: 8166
- Wed Oct 16, 2019 1:50 pm
- Forum: Q/A
- Topic: Copying Code and Globals
- Replies: 3
- Views: 9455
Re: Copying Code and Globals
When I try to copy a global from one project to another, it gives me an "undeclared variable" error and does not copy. How to I deal with that? Also, I am unable to select more than one piece of code at a time. Is there a way to select a section of code with more than one piece and copy it? It's ver...
- Wed Oct 16, 2019 4:58 am
- Forum: Q/A
- Topic: Queries and scraping to tables
- Replies: 2
- Views: 8166
Queries and scraping to tables
I have a couple of questions about queries. 1. I want to enter data into a text field on a website. The data is stored in the database as three separate columns - Column1, Column2, and Column3. I need to add them all together into a string so that it reads (Column1 + " " + Column2 + " " Column3) and...
- Wed Oct 16, 2019 2:31 am
- Forum: Q/A
- Topic: Copying Code and Globals
- Replies: 3
- Views: 9455
Copying Code and Globals
Is there a way to copy a global from one project to another? Also, is there a way to copy sections of code to move them up and down or into another global within a project. Often times even copying a single line will result in an error saying that it can't be copied.
- Sat Oct 05, 2019 2:28 am
- Forum: Q/A
- Topic: Download PDF
- Replies: 7
- Views: 15970
Re: Download PDF
Works great now. Thanks
- Fri Oct 04, 2019 3:23 pm
- Forum: Q/A
- Topic: Download PDF
- Replies: 7
- Views: 15970
Re: Download PDF
That works to download the PDF. Thank you. Now I am trying to use Browser.DownloadAs to create a unique name for the file and add the extension. I do an extract on the case number with Output Result to get a variable called caseNum which has the case number as a string. I would like to name the PDF ...
- Thu Oct 03, 2019 3:17 pm
- Forum: Q/A
- Topic: Global Variables
- Replies: 3
- Views: 9845
Re: Global Variables
How would I write to a Global to use it as a variable? I am scraping from multiple tabs and would like all the data to go into one table rather than a table for each tab as is automatically created. Only way I can see doing this is writing the scraped data to a variable and then writing all of the v...
- Thu Oct 03, 2019 12:49 pm
- Forum: Q/A
- Topic: Download PDF
- Replies: 7
- Views: 15970
Re: Download PDF
I am not able to download the PDF or find the link to the actual PDF where I can download it. Could you please look at the page and see if there is anything that can be done to download the PDF? Here is a sample case number and how to get to the PDF. 1. Navigate to https://myeclerk.myorangeclerk.com...
- Wed Oct 02, 2019 2:35 pm
- Forum: Q/A
- Topic: Download PDF
- Replies: 7
- Views: 15970
Download PDF
Wondering how to download a PDF file when there is no direct link. I can view the PDF and there is a download link at the top of the page, but I cannot create a Selector for the download button. When I click on it, there is nothing selected. I have included a screenshot of what I am talking about an...
- Sun Sep 29, 2019 7:01 am
- Forum: Q/A
- Topic: Global Variables
- Replies: 3
- Views: 9845
Global Variables
How do I access global variables? They seem to get set automatically and then I cannot delete the code because I cannot delete the variable. I'd also like to be able to access and create them so I can use JavaScript like in Helium 2. There seems to be a lot of functionality that was in Helium 2 that...