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
