CODEWITHSUNDEEP
coldfusion
David Brierton
David Brierton

Reputation: 7397

CF Blank White Screen No Errors

I am using CF 10 and I am trying to figure out why I cannot get even an error to tell me whats going wrong.

 <cfset result = {} /> 
    <cftry> 

    <!--- Step 1 --->
    <cfset session.exitinterview.name = "test1" >
    <cfset session.exitinterview.todayDate = "test2" >
    <cfset session.exitinterview.title = "test3" >
    <cfset session.exitinterview.department = "test4" >
    <cfset session.exitinterview.hireDate = "test5" >
    <cfset session.exitinterview.terminationDate = "test6" >
    <cfdump var="#session#" label="variables">
    <cfoutput>#session.exitinterview.name#</cfoutput>

    <cfif (isDefined("session.exitinterview.name"))>  
<cfif session.exitinterview.name is not "">
<cfquery datasource="dsn" name="InsertEntry" result="transactionResult">
 INSERT INTO [dbo].[ExitInterview] (Name, JobTitle, DateHired, Dept, InterviewDate, TerminationDate)
 VALUES (
   <cfqueryparam value='#session.exitinterview.name#' cfsqltype='cf_sql_varchar' />
  , <cfqueryparam value='#session.exitinterview.title#' cfsqltype='cf_sql_varchar' />
  , <cfqueryparam value='#session.exitinterview.hireDate#' cfsqltype='cf_sql_varchar' />
  , <cfqueryparam value='#session.exitinterview.department#' cfsqltype='cf_sql_varchar' />
  , <cfqueryparam value='#session.exitinterview.todayDate#' cfsqltype='cf_sql_varchar' />
  , <cfqueryparam value='#session.exitinterview.terminationDate#' cfsqltype='cf_sql_varchar' />
)
</cfquery>
<cfelse>
</cfif>
</cfif>

    <cfcatch type="any"> 
            <cfset result.error = CFCATCH.message > 
            <cfset result.detail = CFCATCH.detail > 
        </cfcatch> 
    </cftry>

That is the hardcoding thats not working posting to the database, but I am posting through a form like below. The "test1" stuff was just for testing purposes to see why its not posting to the database.

<cfset session.exitinterview.name = form.name >
<cfset session.exitinterview.todayDate = form.todayDate >
<cfset session.exitinterview.title = form.title >
<cfset session.exitinterview.department = form.department >
<cfset session.exitinterview.hireDate = form.hireDate >
<cfset session.exitinterview.terminationDate = form.terminationDate >

I am trying to set session variables with a form but even hardcoding like test1, test2 is not working. All I am getting is a blank white screen. Will someone please tell me what I might be missing here?

Upvotes: 2

Views: 624

Answers (1)

Alex Baban
Alex Baban

Reputation: 11732

You don't see anything because of the <cftry> and <cfcatch> tags. You'll need to remove or comment them out to see the error.

If the 'test...' variables are not defined that's an error that is caught and will not show on screen.

Upvotes: 5

Related Questions