You might want ot check the value you have in url. It could be that CF thinks it's the structure that holds url variables. Try changing the name fo the variable or using the scope specifier as in variables.url.
-----Original Message----- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 25 February 2002 09:13 To: CF-Talk Subject: Expression results? Experts ? Hi I am getting the following error when trying to add a record to my database via coldfusion, anyone on the list have any ideas ? 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). This is the code I am using in the query where it may be going wrong I feel <cftransaction> <cfquery name="LOOKUP" datasource="intranetv8"> SELECT Max(eventid) NeweventID FROM whatson </cfquery> <cfif lookup.neweventid is ""> <cfset eventid = 1> <cfelse> <cfset eventid = lookup.neweventid + 1> </cfif> <!--- Insert contact into the contacts tabel in the tes8 Database ---> <!---- COMBINE MONTH, DAY, AND YEAR INTO A SINGLE VARIABLE -----> <cfset eventdate = form.event_month & "/" & form.event_day & "/" & form.event_year> <cfset eventdate = #CreateODBCDate(eventdate)#> <cfset eventexpires = form.expires_month & "/" & form.expires_day & "/" & form.expires_year> <cfset eventexpires = #CreateODBCDate(eventexpires)#> <cfset formatted_date = dateformat(eventdate, "MM/DD/YYYY")> <cfset format_date = dateformat(eventexpires, "MM/DD/YYYY")> <cfset content = REReplacenocase(content, "</*font[^<>]*>", "", "ALL")> <cfset content = REReplacenocase(content, "</*span[^<>]*>", "", "ALL")> <cfif form.uploadfile neq ""> <cffile action="UPLOAD" filefield="Form.UploadFile" destination="/export/home/docs/intranet/testpages/" nameconflict="OVERWRITE"> </cfif> <!--- Make sure that file is of correct type ---> <cfquery datasource="#Application.DSN#" name="insert_query"> INSERT INTO whatson ( eventid, eventdate, eventexpires, longtitle, location, telephone, email, url, eventsummary, description, imgsrc) VALUES (#eventid#, TO_DATE('#formatted_date#', 'MM/DD/YYYY'), TO_DATE('#format_date#', 'MM/DD/YYYY'), '#longtitle#', '#location#', '#telephone#', '#email#', '#url#', '#eventsummary#', '#content#', <cfif isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>) </cfquery> </cftransaction> ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
