loading recordset into weblistbox causes exception

Targets Web
1

HI,

ive converted some data into a mysql server (and this is my first app using mysql)

mostly it seems ok, but on one query (which works) i try to display the data in a listbox and i get an exception
with lots of data in it, but the first row is this

Trouble evaluating response: JSON Parse error: Expected ‘}’

any ideas what might be causing it?

its 2015r1 i’m using

2

When are you trying to load the weblistbox? If you’re doing this from the open event switch to the shown event. I’ve even seen it where you have to delay a bit even after the shown event.

3

[quote=182161:@Russ Lunn]HI,

ive converted some data into a mysql server (and this is my first app using mysql)

mostly it seems ok, but on one query (which works) i try to display the data in a listbox and i get an exception
with lots of data in it, but the first row is this

Trouble evaluating response: JSON Parse error: Expected ‘}’

any ideas what might be causing it?

its 2015r1 i’m using[/quote]
Make sure you’re setting the encoding of the data coming out of the database correctly. If you don’t you may end up with characters that cannot be rendered properly in JSON.

4

thanks Greg,

that was it! uk £ signs had an odd accented A in front of them, i removed those and it sprang to life.
i’m guessing it was because i went via a text file from SQL Server and imported it into mySQL.

all sorted now, cheers!