SELECT an url as string

AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

http://alasql.org

MIT License

7.01k stars 653 forks source link

SELECT an url as string #595

Closed MarioVanDenEijnde closed 8 years ago

MarioVanDenEijnde commented 8 years ago

Hello ALASQL team,

I want to select a string with slashes but ALASQL seems to fall over slashes. The column data looks like: "Path":"/office/SportVloerenLijst/1" I just tried SELECT Path but this throws an error.

Can you advise?

Kind regards, Mario

MarioVanDenEijnde commented 8 years ago

Sorry. It seems the column name "Path" is causing the error. The name seems to be restricted in ALSSQL. Resolved: I used SELECT [Path] AS PathX

Kind regards, Mario