You have double quotes at the start of your argument (value=") which get interrupted by double quotes in the argument value. Try this: <cfqueryparam value="#form.CHANGE_TICKET_REQ_STRT_TMS_Date# #form.CHANGE_TICKET_REQ_STRT_TMS_Time# #form.CHANGE_TICKET_REQ_STRT_TMS_AMPM#" ...
On Fri, Jun 27, 2008 at 4:41 PM, John Beirne <[EMAIL PROTECTED]> wrote: > 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:3784 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
