Form not updating through Datastore

Suite and Optimus Suite 5
#1

I am trying to develop with connector, datastore, dataprocessor, grid, and form -
I successfully implemented one of your samples using the same arrangements.

Load Grid works.
Delete works.
Add Works.
Edit New row works.
But edit existing row does not work.

I believe I have narrowed it down to my connector file. I use SQL to get a filtered and sorted dataset.

if ($data->is_select_mode()) {
$data->render_sql(“SELECT ParagraphAID, MenuFKID, ParagraphName, ParagraphDisplayOrder, ShowNow, ParagraphBody FROM paragraphs WHERE MenuFKID =”.$_GET[‘rowID’]." Order BY ParagraphDisplayOrder ASC" , “ParagraphAID”,“ParagraphName,ParagraphDisplayOrder,ShowNow,MenuFKID(rowID),ParagraphBody”);
} else {
$data->render_table(“paragraphs”, “ParagraphAID”, “ParagraphName,ParagraphDisplayOrder,ShowNow,MenuFKID(rowID), ParagraphBody”);
}

I have found that if I just use $data->render_table… everything works.

What have I done wrong?
Is there a better way to get the simplified data?

#2

can you enable logging and provide log file for incorrect operation

$data->enable_log("savelog.txt"); $data->render_table("paragraphs", "ParagraphAID", ...

#3

WOW, I have to learn more about that log file!
I did as requested and solved the problem.
I will share the results here for others to see.

First attempt - I just ran the connector file to check its results:
File: GetParagraphs.php?rowID=9
Results: even though I received correct data on the screen the log file said I had a problem.

====================================
Log started, 04/05/2012 09:05:21

SELECT ParagraphAID, MenuFKID, ParagraphName, ParagraphDisplayOrder, ShowNow, ParagraphBody FROM paragraphs WHERE ( MenuFKID =9) ORDER BY ParagraphDisplayOrder ASC

Undefined index: rowID at …\data_connector.php line 157

Undefined index: rowID at …\data_connector.php line 157

Done in 0.011599779129028s

So I altered my SQL "SELECT ParagraphAID, MenuFKID AS rowID…

Second attempt at just the connector file ran without errors:

====================================
Log started, 04/05/2012 09:05:25

SELECT ParagraphAID, MenuFKID AS rowID, ParagraphName, ParagraphDisplayOrder, ShowNow, ParagraphBody FROM paragraphs WHERE ( MenuFKID =9) ORDER BY ParagraphDisplayOrder ASC

Done in 0.032202005386353s

Next I attempted the actual application and it all worked. Here is the log file results{

====================================
Log started, 04/05/2012 09:05

SELECT ParagraphAID, MenuFKID AS rowID, ParagraphName, ParagraphDisplayOrder, ShowNow, ParagraphBody FROM paragraphs WHERE ( MenuFKID =7) ORDER BY ParagraphDisplayOrder ASC

Done in 0.0042228698730469s

====================================
Log started, 04/05/2012 09:05

DataProcessor object initialized
18_id => 18
18_!nativeeditor_status => updated
18_ParagraphName => New Paragraph Name
18_ParagraphDisplayOrder => 700
18_ShowNow => 1
18_rowID => 7
18_ParagraphBody => Replace Body Text here
ids => 18

Row data [18]
id => 18
!nativeeditor_status => updated
ParagraphName => New Paragraph Name
ParagraphDisplayOrder => 700
ShowNow => 1
rowID => 7
ParagraphBody => Replace Body Text here

UPDATE paragraphs SET ParagraphName='New Paragraph Name
',ParagraphDisplayOrder=‘700’,ShowNow=‘1’,MenuFKID=‘7’,ParagraphBody=‘Replace Body Text here’ WHERE ParagraphAID=‘18’ AND (( MenuFKID =7))

Edit operation finished
0 => action:updated; sid:18; tid:18;

Done in 0.027704954147339s