- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Skipping Values in Query but Seen in Preview
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Skipping Values in Query but Seen in Preview
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Skipping Values in Query but Seen in Preview
I will respond to tech support. They have already reached out. If I get a solution I will be sure and post it here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Skipping Values in Query but Seen in Preview
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.