SQL Database connector- Error

hi, I’m using external Postgres DB for my app using SQL database connector. And I am trying to create a query adding some parameters.

but I’m getting an error as such when I initialize the query:
image

Also wanted to know if there is any other way to get data more than 200 count as there is a limit in SQL database connector. Is SQL Database Connector Pro, a bubble recommended plugin?

@saranya It is not a “Bubble plugin” or a “Bubble recommended plugin”. However, it is a plugin that our team created that is still supported and works very nicely if you find yourself in need of more than what the Bubble SQL plugin offers

@saranya which type of database are you trying to connect?

It is a Postgres DB in which I’m trying to do an ‘Insert’, when I initialize the query I get errors like this.
image

@saranya Try this instead to using ‘$1’ use $1
Remove the ’ ’ from all the variables

Yes! That worked. Thanks

1 Like