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). --------------------- ----- Original Message ----- From: "Ian Vaughan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 3:16 PM Subject: Re: ADVANCED - Expression results - Please Help !!! > Please ingnore my ignorance but what do you mean by 'specifiers' ?? > > Also could upgrading the server have caused this ? > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, April 08, 2002 3:05 PM > Subject: RE: ADVANCED - Expression results - Please Help !!! > > > > I would try putting specifiers in front of all your variables. > > > > -----Original Message----- > > From: Ian Vaughan [mailto:[EMAIL PROTECTED]] > > Sent: 08 April 2002 14:43 > > To: CF-Talk > > Subject: Re: ADVANCED - Expression results - Please Help !!! > > > > > > Hi Kevan & Folks > > > > It has only stopped working since I upgraded the CF Server from 4.0 to 4.5 > ? > > > > Would this have anything to do with it ? > > > > This is the code I am using in my action page..... any help would be most > > appreciated > > > > ------------- > > <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> > > > > -------------- > > > > > > > > > > ----- Original Message ----- > > From: <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, March 26, 2002 10:22 AM > > Subject: RE: ADVANCED - Expression results > > > > > > > CF uses that name url for the structure that holds all url variables, so > > it > > > is trying to convert a structure to string. You'd have to reference it > > with > > > #url.url# or even better try changing the name of the variable. > > > > > > -----Original Message----- > > > From: Ian Vaughan [mailto:[EMAIL PROTECTED]] > > > Sent: 26 March 2002 09:02 > > > To: CF-Talk > > > Subject: ADVANCED - Expression results > > > > > > > > > Hi Folks > > > > > > I am getting the following error when trying to add a record to my > Oracle > > 8 > > > database through coldfusion 4.5, when I was using Coldfusion 4.0 it > worked > > > ok. > > > > > > Any ideas on what it could be or mean? > > > > > > 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). > > > > > > > > > Date/Time: Tue Mar 26 09:05:09 2002 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
