I found the OpenBD 1.4 and just gave it a go. It works just fine.
Matt,
I'm using MySQL 5.1. So what I mean by truncates is if I take my query
and pump the results in to a cfdump I dont see the complete query
result. But if I limit the amount of data going in to the table it
works fine.
For example (Breaks):
<tbody>
<cfloop query="qGet2"><cfoutput>
<tr>
<td align="center"><input name="addPatch" type="checkbox"
value="#id#" #iif(ListFindNocase(currPatchList,id,",") GTE
1,DE('checked'),DE(''))#></td>
<td><img src="_assets/images/info.png" height="16"
width="16">#qGet2.name#</td>
<td align="center">#Reboot#</td>
<td align="center">#type#</td>
<td align="center">#patch_state#</td>
<td align="center"><cfif #Len(baseline_id)# GT
6>Required<cfelse>NA</
cfif></td>
<td align="center">#DateFormat(postdate,"dd/mm/yyyy")#</td>
</tr>
</cfoutput></cfloop>
</tbody>
Remove the img tag and it works:
<tbody>
<cfloop query="qGet2"><cfoutput>
<tr>
<td align="center"><input name="addPatch" type="checkbox"
value="#id#" #iif(ListFindNocase(currPatchList,id,",") GTE
1,DE('checked'),DE(''))#></td>
<td>#qGet2.name#</td>
<td align="center">#Reboot#</td>
<td align="center">#type#</td>
<td align="center">#patch_state#</td>
<td align="center"><cfif #Len(baseline_id)# GT
6>Required<cfelse>NA</
cfif></td>
<td align="center">#DateFormat(postdate,"dd/mm/yyyy")#</td>
</tr>
</cfoutput></cfloop>
</tbody>
Or if I remove another column like "patch_state" it works with the
image tag.
I'm at a loss here, I've never had this kind of problem before and I'm
not sure how to provide more info.
Thanks,
Charlie
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
