Forbidden data in a Data Grid?

[Bob Sneidar]

Okay, do this in a script:

put the dgData of group "<your data grid here>" into theDataA
put printKeys(theDataA)

The message box will now contain the text representation of the array from your data grid. Copy that and take it into some kind of text editor that can show you things like line feeds or special characters. 

I assume you are escaping your data when you post it to the sql database? Sanitizing your SQL? It sounds like someone inadvertently (or otherwise) entered some kind of data and it got into the database when it shouldn't have. 

Bob


On Jan 25, 2012, at 2:21 PM, Paul Looney wrote:

> Are there characters that prevent a Data Grid from displaying?
> 
> We have Data Grid in the UI front end to a database.
> For years it has worked well with databases for many different customers.
> Recently the data from one customer would not display. Stepping through the code, all was well until the end - setting the dgtext of the data grid. The scroll bars resized properly. The number or records listed was right. Clicking on a line in the Data Grid opened the record viewer. 
> But no data was displayed in the Data Grid fields.
> 
> The same grid continued to work with data from other customers. That customer's data was visible in other grids.
> 
> It is just that this one grid will not display data from this one account.
> 
> We already strip out NULLs (from our experience with sorting problems) but are there other characters that would cause a Data Grid to not display data?
> 
> Or should we look elsewhere?
> 
> Thanks in advance,
> Paul Looney
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode