A genius designed a complex, multi-tabbed online database interface for which I
am now responsible for maintenance and upkeep. One tab is having some problems
and I want to try to troubleshoot it. I'm working in DreamWeaver and used the
'highlight invalid code' button on the coding toolbar. The cfqueryparams in
the following two cfif statements got highlighted:
<cfif form.CHANGE_TICKET_REQ_STRT_TMS_Date neq "">
<cfqueryparam
value="#form.CHANGE_TICKET_REQ_STRT_TMS_Date & " " &
form.CHANGE_TICKET_REQ_STRT_TMS_Time & " " &
form.CHANGE_TICKET_REQ_STRT_TMS_AMPM#" null="#not
len(CHANGE_TICKET_REQ_STRT_TMS_Date)#" cfsqltype="CF_SQL_TIMESTAMP">,
<cfelse>
NULL,
</cfif>
<cfif form.CHANGE_TICKET_REQ_END_TMS_Date neq
"">
<cfqueryparam
value="#form.CHANGE_TICKET_REQ_END_TMS_Date & " " &
form.CHANGE_TICKET_REQ_END_TMS_Time & " " &
form.CHANGE_TICKET_REQ_END_TMS_AMPM#" null="#not
len(CHANGE_TICKET_REQ_END_TMS_Date)#" cfsqltype="CF_SQL_TIMESTAMP">,
<cfelse>
Can anybody see any obvious syntax problems?
Thanks,
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3783
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
