I mean attribute i.s.o. argument... On Fri, Jun 27, 2008 at 4:45 PM, Wim Lemmens <[EMAIL PROTECTED]> wrote:
> 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:3785 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
