Skip to main content
C
ChiTownJohnnyB
Inspiring
June 27, 2008
Question

Invalid Code Highlighted

  • June 27, 2008
  • 2 replies
  • 390 views
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 attached two cfif statements got highlighted:

Can anybody see any obvious syntax problems?

Thanks,

John
This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
July 1, 2008
Better yet, use date functions to create a datetime variable before you get to your query, and use that variable instead of concatonating strings.
M
Magikaru
Inspiring
June 27, 2008
Yup, I see what it's complaining about. In the cfqueryparam tags under value, he tries to concatenate some fields together and separate them with a blank space. The problem is that he is using double quotes to signify the blank space and to open/close the value field in the tag. Try changing the double quotes that signify a blank space to single quotes. So:

<cfqueryparam value="#form.CHANGE_TICKET_REQ_STRT_TMS_Date & ' ' & form.CHANGE_TICKET_REQ_STRT_TMS_Time & ' ' & form.CHANGE_TICKET_REQ_STRT_TMS_AMPM#" ...>
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices