|
Terry, I’ve tried a dynamic select statement like yours with a bool used for the comparison and another property used for the actual SQL and it worked. Are you able to debug and step through what may be happening to the query / command text?
Roberto
-----Original Message-----
I fixed the int and long problem, but I still can't get timestamp to search correctly. I fixed the first two by going to the most recent version of ibatis in svn.
I added parameterClass="PAF_ACTION_CT_MAIN", and that didn't work.
I tried the literal syntax on the timestamp, but haven't gotten it to work. I've even added a property called SQLTimestamp to return a definitely-formatted-correctly SQL datetime, but I can't make it work.
Any ideas?
Thanks! Terry
From: roberto
[mailto:[EMAIL PROTECTED] Terry,
The .vb files got deleted, but the SqlMap xml file got through.
Anyway, just for clarification, using parameterClass=”PAF_ACTION_CT_MAIN” doesn’t work?
Also, what database and provider are you using?
Can you try the literal syntax ($ActionCTId$ instead of #ActionCTId#)?
Roberto
-----Original Message-----
Ok, I set that, but still no luck. One thing that I don't know if I pointed out is that it _does_ work for string elements, but not int/long or datetime. I've attached the xml and related classes.
The only thing that doesn't work is the search.
Thanks in advance! Terry
From: roberto
[mailto:[EMAIL PROTECTED] Doh! Sorry, I meant:
<select id="PAF_ACTION_CT_MAINSearch" resultMap="PAF_ACTION_CT_MAINResult" parameterClass="yourClassNameTypeAlias_Or_FullNamespaceAndAssembly">
…needs to be added as an attribute of your select element.
Roberto
|
- Long/int not working Heath, Douglas T
- RE: Long/int not working roberto
- RE: Long/int not working Heath, Douglas T
- RE: Long/int not working roberto
- RE: Long/int not working Heath, Douglas T
- RE: Long/int not working roberto
- RE: Long/int not working Heath, Douglas T
- RE: Long/int not working roberto
- RE: Long/int not working Heath, Douglas T
