SQL db connection made, won't return values. Please help :)

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.

1 Like

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

1 Like

Sounds good!