nadel | A GraphQL DSL and execution engine for distributed schemas | GraphQL library

I have an issue where I'm joining two record sets from two different datasources using Ben Nadel's QueryAppend.cfc. The data I get back is correct but the ordering of the data is not expected. The combined result set is being sorted like so with all results starting with a lowercase letter appended to the bottom of the record set:

Screen grab of cfdump

I'm expecting (and need) the following type of sort:

Apple

art

bottle

Boy

Cat

coin

dart

Dog

Code follows:

I have a few processes that utilize the CFSpreadsheet tag to import and then manipulate Excel data. This works great for .XLS & .XLSX files, however, it doesn't work if the data is sent as a .CSV file since CFSpreadsheet apparently was never updated to import .CSV files. At the end of the day I just want a simple pre-processor that takes a .CSV file and re-writes it as an .XLSX file so that my other process can take it from there.

My environment is the developer edition of Coldfusion 2018 and I've tried importing the data manually (which can work if I know all of the column definitions---but I won't always know that). My latest attempt has been with Ben Nadel's CSVToArray function ( https://www.bennadel.com/blog/2041-update-parsing-csv-data-files-in-coldfusion-with-csvtoarray.htm ) which works---I can easily get the .CSV file into an array---but I can't figure out how to go from that array to something like a query that I can write a spreadsheet with using CFSpreadsheet.

Here's an EXAMPLE:

I'm having an issue trying to use cfhttp. I'm using an API that requires me to send login credentials, then send subsequent commands. The reply on the subsequent commands is "login required". After looking at my requests, I think I've found the issue but I don't understand it.

Here's my login call:

I am trying to convert JSON data into CSV and XLSX and have 2 buttons that will allow me to download the CSV and XLSX form. The CSV button works but the XLSX one does not.

I have tried many things such as:

var filename = "RawData.xlsx" alasql('SELECT * INTO XLSX("' + filename + '",{headers:true}) FROM ?', [$scope.data]);

var filename = "RawData.xls" alasql('SELECT * INTO XLS("' + filename + '",{headers:true}) FROM ?', [$scope.data]);

var filename = "RawData.xlsx" alasql('SELECT * INTO XLSXML("' + filename + '",{headers:true}) FROM ?', [$scope.data]);

The first one just does not output anything when I click the button.

The second one outputs a .xls file but when I open it it's just messed up and does not give the proper result.

The third one outputs a .xlsx file but when I try to open it it fails and says "The file format is invalid".

Does anyone know how to fix this?

My code is here:

My algorithm for converting CSV to JSON data works but when I click "Download JSON" it gives me a CSV file. Does anyone know what the issue is?

Also, the "convert to CSV" button is not outputting anything!

You don't need to pay attention to the Highcharts code even though I included it.

Does anyone know how to fix this? The code is here (some of the code belongs to Sturtevant from JSFiddle. Credits to him):

I initially posted this as an answer to this question earlier regarding Empty CGI.REDIRECT_URL on ColdFusion 2016. After thinking about it, I thought better of it since technically didn't answer the OP's question. Instead I decided to make it into a separate question, even though it's more of a commentary than a question. While this technically might not meet the full requirements of a Minimal, Complete, and Verifiable example and people might ding me with downvotes, I decided it was worth it anyway in the hope that it will become easier to find for future CFers who might encounter this. Thus preventing them from banging their head against the wall regarding this peculiar behavior of the CGI struct/scope.

With that said, the CGI struct/scope has some undocumented inconsistent behavior from other structs/scopes. Note that I personally take no credit for this discovery since I happened across this some time ago upon reading Ben Nadel's blog post on this. So all the information I'm posting here is already detailed there, but I wanted to write a nice summary here on SO.

Undocumented behavior 1 - Unlike other structures, if a CGI struct key doesn't exist, then it won't throw an error when referencing it.

In the OP's original question, he was wondering why cgi.REDIRECT_URL existed but was empty. As he eventually found out, it never actually existed. As a separate example you can execute this line of code without throwing an error. Not what you'd expect, huh?

Does anyone know a way that I can pass initialization data into an Angular 2 application built with Angular CLI? I need to pass Access Token that I currently have from a pre-authenticated .NET backend so that I can call an API.

I've tried to do this via a local web api endpoint, but since Observables are async, the module tries to use the value before it's available in the app.

I've already tried the OnRun suggestion by @Ben Nadel Here. The result of my http call still happens AFTER the app is loaded causing my access token to be null when it first is loaded.

Something like @Bilyachat suggested below would work great! Where I could simply do something like the following:

I am creating a webpage that has search, add, update, and delete (all in one webpage without any modals). This webpage is dedicated for facility maintenance. Add works fine. But the rest doesn't look good. Whenever I add a 'facility', the page reloads (as expected). The page gets the data from mysql database and add it on a table inside my webpage. The table has a column called 'Actions' that holds two buttons, update and delete.

The problem is when I use innerHTML. On the top of the table containing the list of 'facilities', is a search input. Search works fine (I think). Search uses the 'POST' method and accesses a PHP code inside my file. The PHP code is tasked to search for any matching strings from the database and echo . Inside these script tags is a code where I searched for the id of the table I want to update. Then I changed & added inner HTML. Inside the inner HTML is a new table row. Inside the table row is a form, and inside these forms are s. Whenever the form(the form inside each table rows) submits, it should access a PHP code inside my file that has already been written (it was already there when the page first loads). But whenever I click the action buttons on my table, it does nothing. It doesn't trigger the PHP POST code written.

Clicking update and delete buttons works fine IF search is not clicked first. Clicking update will create another table with input fields and a button to save changes. The 'button-to-save-changes' doesn't work even if it has a PHP POST code already written in the file.

Here is my code: