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>
______________________________________________________________________
Get Your Own Dedicated Windows 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=coldfusionb
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
