Custom Caption based on SQL Query

Questions › Custom Caption based on SQL Query

Mike Sheppard asked 2 weeks ago

I would like to be able to create a custom caption based on an SQL Query, such as “Select MAX DATE from Table”, then put that date in the caption. I have a few reports that are built on static-data, so it would be nice to know the most recent date from the report for the caption.

I have tried a few different tricks, but nothing works and I don’t see anything in the Demos or on the help-site.

Any thoughts would be appreciated.

Thanks

Mike

5 Answers

0 Vote Up Vote Down

Mike Sheppard answered 2 weeks ago

Ticket can be closed – I was not setting the variables correctly, this works perfectly fine if you run an ODBC_EXEC, then fetch the array and set the variable.

Thanks

Mike

0 Vote Up Vote Down

Abu Ghufran Staff answered 2 weeks ago

Thanks for updating.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework

0 Vote Up Vote Down

Max answered 2 days ago

how did yo accomplish that ?

0 Vote Up Vote Down

Abu Ghufran Staff answered 1 day ago

You can run a query to get your value from database. Here $g is jqgrid object.

$rs = $g->get_one(“SELECT field from tab limit 1”);
$cap = $rs[“field”];

$opt[“caption”] = $cap;

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework

0 Vote Up Vote Down

Max answered 7 hours ago

does not seems to work, print_r($rs); there is nothing in rs varible.. $rs = $g->get_one(\”SELECT updated from markup limit 1\”); $cap = $rs[\”updated\”];

Your Answer

Other Links

Latest Updates