I want to create a CartoDB viz where the where parameter in my SQL statement changes dynamically at runtime.
When I share my CartoDB viz from the dashboard, I can't help but notice the the SQL statement is passed as a URL var.
I thought that was an easy way to dynamically change the where clause. After playing around though, I found out that the parameter is ignored (and for good reason, to guard against SQL injection), though other parms like showing the title/desc and the ne/sw latlongs are processed.
So I'm now trying to create a viz using the CartoDB API.
But for some reason, I can't get the creating visualizations at runtime example to work.
أكثر...
When I share my CartoDB viz from the dashboard, I can't help but notice the the SQL statement is passed as a URL var.
I thought that was an easy way to dynamically change the where clause. After playing around though, I found out that the parameter is ignored (and for good reason, to guard against SQL injection), though other parms like showing the title/desc and the ne/sw latlongs are processed.
So I'm now trying to create a viz using the CartoDB API.
But for some reason, I can't get the creating visualizations at runtime example to work.
أكثر...