Error trying to display sql joined fields... October 05, 2018, 01:50:47 PM Hi, on a table list view I just wanted to extract one more field, I setup the JOIN properties for the query in the WHERE property and all the field o the joined table appeared correctly, but when I open the page in the browser I obtain a "NOTICE: UNDEFINED INDEX: FieldNameXXX" for each field. The joined field are missing in the $data array. What's wrong? Thank you. Quote Selected
Re: Error trying to display sql joined fields... Reply #1 – October 06, 2018, 04:48:36 PM Have you selected the Join table fields by making a tick mark? Please share screenshot to get the better idea of your scenario. Quote Selected
Re: Error trying to display sql joined fields... Reply #2 – October 07, 2018, 07:33:12 AM Here is the join... Quote Selected
Re: Error trying to display sql joined fields... Reply #3 – October 07, 2018, 07:35:03 AM Here the field properties... Quote Selected
Re: Error trying to display sql joined fields... Reply #4 – October 07, 2018, 07:35:40 AM Here's the error... Quote Selected
Re: Error trying to display sql joined fields... Reply #5 – October 07, 2018, 10:30:00 AM P.S. I'm using PHP Rad Classic 2.0 that emman gave me some days ago... I also found that the property ExportButton=False do not work, I still have the button on the pages... Quote Selected
Re: Error trying to display sql joined fields... Reply #6 – October 08, 2018, 05:14:06 PM Quote from: Shin74 – October 07, 2018, 10:30:00 AMP.S. I'm using PHP Rad Classic 2.0 that emman gave me some days ago... I also found that the property ExportButton=False do not work, I still have the button on the pages...PHPRad Classic 2.0?! We are having 2.5.7 with us right? Why using the old version? Quote Selected
Re: Error trying to display sql joined fields... Reply #7 – October 08, 2018, 05:21:12 PM After talking to him on chat he gave me that version, I dont't exactly remember what we talk about, I suppose for Italian language translation.... I though that was a parallel different version... You mean I should use the 2.5.7? Quote Selected
Re: Error trying to display sql joined fields... Reply #8 – October 08, 2018, 05:27:26 PM I installed 2.5.7 but trying to open the 2.0 project I obtain the error shown in the picture... is it possible to recover my work? thank you... Quote Selected
Topic: Error trying to display sql joined fields... (Read 1660 times)
previous topic - next topic
Track issues, Ask questions, Make suggestions,Report a bug