Professional Web Applications Themes

Temporary Table Creation Problem in CF7 not CF6.1 - Coldfusion Database Access

We have been preparing for our upgrade to CF7.0 from 6.1 on a test site with a test mssql database and come across an issue we cannot resolve. Maybe someone can help. We cannot create a LOCAL temporary table in the mssql database with CF7 but can with CF6.1. Using Enterprise Manager we can create a LOCAL temporary table and it seems the problem is with CF7 specifically. We can create a GLOBAL temporary table in CF7 just fine so the problem is only with LOCAL temporary table creation in CF7. Here is the code element to create the LOCAL ...

  1. #1

    Default Temporary Table Creation Problem in CF7 not CF6.1

    We have been preparing for our upgrade to CF7.0 from 6.1 on a test site with a
    test mssql database and come across an issue we cannot resolve. Maybe someone
    can help.

    We cannot create a LOCAL temporary table in the mssql database with CF7 but
    can with CF6.1. Using Enterprise Manager we can create a LOCAL temporary table
    and it seems the problem is with CF7 specifically. We can create a GLOBAL
    temporary table in CF7 just fine so the problem is only with LOCAL temporary
    table creation in CF7.

    Here is the code element to create the LOCAL table that gives the problem in
    CF7 but not in 6.1:
    <cfquery username ="#userName#" password ="#passWord#" name="test"
    datasource="#DSource#">
    select testid into ##ctest from testtable
    </cfquery>

    Ortho Guest

  2. #2

    Default Re: Temporary Table Creation Problem in CF7 not CF6.1

    Local temp tables live only for the duration of the connection that created
    them. Perhaps CF7 is timing out the data connection in the middle of your
    process.

    Does the code throw an error, or not? If so, what error does it return?

    philh Guest

  3. #3

    Default Re: Temporary Table Creation Problem in CF7 not CF6.1

    There is not an error; the file is just not created so when you try to access
    the table, it is not there and then you get a standard error message.

    We verified the file was not created in Enterprise Manager.

    Ortho Guest

Similar Threads

  1. Replies: 8
    Last Post: January 26th, 05:01 PM
  2. Get result from temporary Oracle Table
    By Franck in forum ASP.NET Web Services
    Replies: 0
    Last Post: April 28th, 07:48 AM
  3. #26387 [NEW]: TABLE TEMPORARY DOES NOT WORK
    By davefazio at annulet dot com in forum PHP Development
    Replies: 0
    Last Post: November 24th, 08:09 PM
  4. Temporary Table Query
    By Jonathan Derbyshire in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 4th, 07:44 PM
  5. Replies: 3
    Last Post: December 6th, 02:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139