Skip to content

Simple additional alasql function node to handle dynamic queries via msg.query

License

Notifications You must be signed in to change notification settings

Gippsman2017/node-red-contrib-alasqlfunc

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

AlaSQLFunc additional complimentary Alasql node

node-red-contrib-alasqlfunc

This additional node-red alasql node lets you use msg.query to send in query commands like query/insert/update Note: This node now uses alasql-nr as its base, it has extra fixes for known alasql faults

Eg:

msg.query='select * from abc where Id="'+msg.payload.response.id+'"';

or

var a = 'wombat';
var b = 'platypus';
msg.query='insert into abc values ("'+a+'","'+b,+'")';

About

Simple additional alasql function node to handle dynamic queries via msg.query

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published