> Yes this the error I am getting when trying to add a new > record to my Oracle 8 database. > > -------------- > Error Occurred While Processing Request > Error Diagnostic Information > Expression result cannot be converted to a string > > Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, > etc. must evaluate to a value that can be converted to a > string for output or dynamic text accumulation purposes. > Complex objects, such as queries, arrays, and COM/DCOM > objects, cannot be represented as strings. > > The error occurred while processing an element with a > general identifier of (#url#), occupying document position > (50:159) to (50:163).
When you reference the variable "URL", you're referencing the URL scope, which is exposed as a structure. CF 4.0.x may have let you get away with that; CF 4.5.x won't. You might be able to scope your variable to avoid the problem (URL.URL), but I'd recommend that you rename the variable as well for the sake of clarity. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

