com_chronoforms [tmpl] => component [chronoform] => stSearch [event] => submit [searchword] => Shravan [Search] => Search [54fe994922c85c10805a178d666936a1] => 1)Validation Errors: Array()Debug Datadb_record_loaderSELECT * FROM `schoolD_chronoforms_data_studentProfile` AS `DATA` WHERE `stname` = 'Shravan'***"> Howto Read data from DB Record Loader - Forums

Forums

Howto Read data from DB Record Loader

paramkrish 08 Jul, 2013
I have probably a lame question since i am still exploring the Chronforms since last few days.

I have a simple table that has some records. I have brought up a form through which i want to search for a text ( that matches to one of the fields in the table) and the results to be shown in display. I think i have added all the components required to make it work but it does not help yet. Can you shed some light what i am missing please?

Text Label takes a word and it matches with the field "stname" but the display is not shown. When i run the same SQL query i get the results.

screenshot1: [attachment=1]1.png[/attachment]
screenshot2: [attachment=0]2.png[/attachment]

*******
Debugger output:
Data Array:
Array
(
[option] => com_chronoforms
[tmpl] => component
[chronoform] => stSearch
[event] => submit
[searchword] => Shravan
[Search] => Search
[54fe994922c85c10805a178d666936a1] => 1
)
Validation Errors:
Array
(
)
Debug Data
db_record_loader
SELECT * FROM `schoolD_chronoforms_data_studentProfile` AS `DATA` WHERE `stname` = 'Shravan'

***
GreyHead 09 Jul, 2013
Hi paramkrish,

Is the Debugger output you posted complete? If the query is valid I would expect to see the results included. There is nothing wrong with the code you've posted here as far as I can see.

Bob
This topic is locked and no more replies can be posted.