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
