Ok, so we know that it is working for other users that are connecting to SQL?
If yes, then I know it would be my query.
Ok, so we know that it is working for other users that are connecting to SQL?
If yes, then I know it would be my query.
We haven’t heard about issues.
Interesting. Okay thanks, I’ll work on it on my side then.
Hi @topherwilliams,
Try these queries:
select top 200 * from CRM where phone like @phone order by name
insert into CRM (phone,Existing_customer,address,city,state,zip,customer_since) values (@phone,@existing_customer,@address,@city,@state,@zip,@customer_since)
I took the liberty of testing with your database connection … you should change the password so nobody can mess it up even more than I have.
Thank for this! I figured out how to do this yesterday by using Zapier <> SQL Connection, but this will be better. I’ll check it out today.
For exact match, need to convert Bubble’s type “text” to “varchar” …
select top 200 * from CRM where phone = CONVERT(VARCHAR,@phone) order by name
Sounds good!