User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
View Translated Thread
DMerchen
DMerchen
Level II

Skipping Values in Query but Seen in Preview

Created: Sep 10, 2021 12:22 PM  |  Last Modified: Jun 10, 2023 4:36 PM (1739 views)

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?

DMerchen_0-1631290799771.png

Thanks,

Dave

DMerchen
0 Kudos
3 REPLIES 3
Phil_Kay
Staff Phil_Kay
Staff

Re: Skipping Values in Query but Seen in Preview

Sep 14, 2021 04:41 AM (1712 views)  |  Posted in reply to message from DMerchen 09-10-2021

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).

0 Kudos
DMerchen
DMerchen
Level II

Re: Skipping Values in Query but Seen in Preview

Sep 14, 2021 04:25 PM (1704 views)  |  Posted in reply to message from Phil_Kay 09-14-2021

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

DMerchen
DMerchen
DMerchen
Level II

Re: Skipping Values in Query but Seen in Preview

Dec 7, 2021 07:02 PM (1681 views)  |  Posted in reply to message from DMerchen 09-14-2021

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.

DMerchen
0 Kudos

Recommended Articles