or if it returns {error, Reason}
On Friday, October 10, 2014 6:16:23 PM UTC+4, can2nac wrote:
>
> not sure about
>
> [WeixinLog|_] = boss_db:find(weixin, [{macid, 'equals', MacID}]),
>
> in case find returns []
>
> On Friday, October 10, 2014 1:19:21 PM UTC+4, mihawk wrote:
>>
>> hi,
>>
>> i guess,
>>
>> boss_db:find(...) return a list of record, then WeixinLog:id() doesn't
>> apply here,
>>
>> try boss_db:find_first(...) or use this:
>>
>> [WeixinLog|_] = boss_db:find(weixin, [{macid, 'equals', MacID}]),
>>
>> mihawk
>>
>>
>>
>>
>>
>>
>> 2014-10-10 15:34 GMT+08:00 Sid Wu <[email protected]>:
>>
>>> Hi g <https://github.com/davidw>uys ,
>>>
>>> These are my code and table:
>>> deal(MacID, FromUserName, Site) ->
>>> WeixinLog = boss_db:find(weixin, [{macid, 'equals', MacID}]),
>>> {output, WeixinLog:id()};
>>>
>>> Model:
>>> -module(weixin, [Id, Macid, Site, Created, Fromusername, Ticket]).
>>> -compile(export_all).
>>> -table("weixinTest").
>>>
>>> Table:
>>> CREATE TABLE weixinTest (
>>> id int(11) NOT NULL AUTO_INCREMENT,
>>> macid varchar(20) NOT NULL,
>>> site varchar(100) NOT NULL,
>>> created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
>>> fromusername varchar(255) NOT NULL,
>>> ticket varchar(255) NOT NULL,
>>> PRIMARY KEY (id)
>>> )
>>>
>>> I got this when visit the url:
>>> 10:28:31.682 [info] Query SELECT * FROM weixinTest WHERE macid =
>>> 'fawfwaf' AND TRUE ORDER BY id ASC
>>> 10:28:31.687 [error] Error in controller error badarg
>>> [{erlang,apply,[[{weixin,"weixin-1",<<"fawfwaf">>,<<"weixin">>,{{2014,10,9},{14,16,44}},<<"wbfwbf">>,<<"fwafwaf">>}],id,[]],[]},{weixin_t1_s_controller,deal,4,[{file,"/home/sid/weixin_t1/src/controller/weixin_t1_s_controller.erl"},{line,12}]},{boss_web_controller,call_controller_action,3,[{file,"src/boss/boss_web_controller.erl"},{line,316}]},{boss_web_controller,apply_action,4,[{file,"src/boss/boss_web_controller.erl"},{line,308}]},{boss_web_controller,execute_action_inner,9,[{file,"src/boss/boss_web_controller.erl"},{line,287}]},{boss_web_controller_handle_request,process_dynamic_request,5,[{file,"src/boss/boss_web_controller_handle_request.erl"},{line,254}]},{boss_web_controller_handle_request,process_request,5,[{file,"src/boss/boss_web_controller_handle_request.erl"},{line,240}]},{boss_web_controller_handle_request,set_timer,8,[{file,"src/boss/boss_web_controller_handle_request.erl"},{line,160}]}]
>>>
>>> What's the problem?
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "ChicagoBoss" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> Visit this group at http://groups.google.com/group/chicagoboss.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/chicagoboss/0170a5ed-0ee4-4da0-a4e7-d18b44dfcd53%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/chicagoboss/0170a5ed-0ee4-4da0-a4e7-d18b44dfcd53%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"ChicagoBoss" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
Visit this group at http://groups.google.com/group/chicagoboss.
To view this discussion on the web visit
https://groups.google.com/d/msgid/chicagoboss/f16f4a77-62e4-4f70-b1b2-5b00f2a5d95c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
