[Reactor for CF] using wildcard(%) in gateway

[Doug Sims]

I am tring to pull back all records that start with a certain letter for example, the letter H.

I first tried this:
 <CFSET memberQuery =membergateway.getbyfields(lastname="H%")>
 but get no records.

I then tried a custom query, both with islike() and isequal()

    <CFSET query.getWhere().isEqual("member", "lastname",'H%')>
  <CFSET order = query.getorder().setasc("member","familyheadID")>
    <CFSET membergateway.createquery().setorder(order)>
    <CFSET memberQuery =membergateway.getByQuery(query)>

I don't have access to see the debug, so I can't really tell what is going on with the generated query. any suggestions on how to do this?

Thanks,
Doug S.

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --