The bug you fixed, was that local.result had no value if returnValues was an
empty string.

The rest is an enhancement request.  I'm using it just fine, for example
with this cfgrid.

  <cfgrid name="gridResults" bindonload=true format="html" width="99%"
striperows=true
  pagesize="20" selectOnLoad=false
  bind="cfc:mg.RemotingService.executeBindEvent(
      eventName='#searchEvent#', text={txtsea...@keyup},
category={cbCategory},
    page={cfgridpage},
    size={cfgridpagesize},
    column={cfgridsortcolumn},
    direction={cfgridsortdirection}
    )">
      <cfgridcolumn name="id"  header="Customer Number" />
      <cfgridcolumn name="name" header="Name" />
      <cfgridcolumn name="username" header="Username" />
      <cfgridcolumn name="email" header="Email Address" />
      <cfgridcolumn name="dateadded" header="Date Added" />
  </cfgrid>

I just could not do that with executeEvent() as it currently exists.  If you
want to implement what I posted earlier, go for it, it works as is.

My controller code, if anyone wants a peek, looks like,

    <cfset var table = event.GetArgument('table')>
    <cfset var gateway = beans.reactor.createGateway(table)>
    <cfset var text = event.GetValue('text')>
    <cfset var field = event.GetValue('category')>
    <cfset var page = event.GetValue('page')>
    <cfset var size = event.GetValue('size')>
    <cfset var column = event.GetValue('column')>
    <cfset var direction = event.GetValue('direction')>
    <cfset var result = StructNew()>

    <cfset result.query = gateway.search(field, text, column, direction,
page, size)>
    <cfset result.TotalRowCount = gateway.numberOfRecords(field, text)>

    <cfset event.SetValue('result', result)>

The gateway.search() and the gateway.numberOfRecords() are custom functions,
since I couldn't find a way to do search's in reactor, and the
numberOfRecords() is needed for the cfgrid to know how many records would be
returned were I not using the LIMIT clause in my mysql statement in
search().
-- 
Chuck Savage
http://SeaRisen.com
-- 
Model-Glue Sites:
Home Page: http://www.model-glue.com
Documentation: http://docs.model-glue.com
Bug Tracker: http://bugs.model-glue.com
Blog: http://www.model-glue.com/blog

You received this message because you are subscribed to the Google
Groups "model-glue" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/model-glue?hl=en

Reply via email to