Are you getting error messages? - Matt Small
-----Original Message----- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:43 AM 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 > > > > > > > > > ______________________________________________________________________ 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
