topic Re: Skipping Values in Query but Seen in Preview in Discussions

Skipping Values in Query but Seen in Preview

DMerchen — Sat, 10 Jun 2023 23:36:50 GMT

I am pulling data from an SQL database. In the updated preview it looks good, but when I run the query, not all of the values fill in properly. Any idea what is happening with this?

Thanks,

Dave

Re: Skipping Values in Query but Seen in Preview

Phil_Kay — Tue, 14 Sep 2021 08:41:08 GMT

No, sorry! I haven't seen anything like this before. And without being able to investigate your data source and connection it is very difficult to help. I think this might be a better question for technical support (email: support@jmp.com).

Re: Skipping Values in Query but Seen in Preview

DMerchen — Tue, 14 Sep 2021 20:25:27 GMT

I will respond to tech support. They have already reached out. If I get a solution I will be sure and post it here.

Re: Skipping Values in Query but Seen in Preview

DMerchen — Wed, 08 Dec 2021 00:02:50 GMT

It was an older MySQL driver issue. Now having to use 2 drivers for MySQL. One for JMP and one for the internal database. It works!

The newer driver for JMP fixed the issue I was seeing. I went through several drivers until I finally got to one that worked. JMP also doesn't like if the driver is too new, so there seems to be a sweet spot with MySQL 5.2.