Hi,
Getting the above error.
Strange thing is: The fields concerned are used in other queries
further up the page.
Error:
The system has attempted to use an undefined value, which usually
indicates a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
The error occurred in C:\Platypus2\Batch\sbbp14_update.cfm: line 667
Called from C:\Platypus2\Batch\sbbp14_update.cfm: line 586
Called from C:\Platypus2\Batch\sbbp14_update.cfm: line 1
Called from C:\Platypus2\Batch\sbbp14.cfm: line 321
Called from C:\Platypus2\Batch\sbbp14.cfm: line 320
Called from C:\Platypus2\Batch\sbbp14.cfm: line 1
665 : GETDATE() ,
666 : <CFIF
isdefined("attributes.ope_ref_date") and attributes.ope_ref_date NEQ ""
AND isdefined("attributes.ope_ref_end_date") and
attributes.ope_ref_end_date NEQ "">
667 : #DateDiff("m",
CreateODBCDateTime(attributes.ope_ref_date),
CreateODBCDateTime(attributes.ope_ref_end_date) )#
668 : <cfelse>
669 : null
The code concerend is a Insert query. If I remove the code starting at
the <cfif.... the insert works, so I am fairly certain the error lies in
the code aboce.
Can anyone spot anything abnormal? I added the "IsDefined" code when
started getting the error, which didn't help.
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service
Phone RNH +61 2 49236078 JHH +61 2 49214193
Fax +61 2 49214191
[EMAIL PROTECTED]
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
