Professional Web Applications Themes

SQL query missing only date data elements - Coldfusion Database Access

I just upgraded from CF 5 to CF 6.1 and am having an issue with any query that pull a date from the database. I am using Oracle 9i as the database. I am able to insert and update, but I can not pull any dates. Note: In my data table all of the fields have data in them. Here is an example of the query: <cfquery name="Get_XTF" datasource="source"> SELECT XTF, Role, Email, Expires, attempt1, password as proper_pass FROM source.Users WHERE (login='#Login#') </cfquery> Note: that the "Expires" and "attempt1" fields are both date fields. The code for the output is: ...

  1. #1

    Default SQL query missing only date data elements

    I just upgraded from CF 5 to CF 6.1 and am having an issue with any query that
    pull a date from the database. I am using Oracle 9i as the database.

    I am able to insert and update, but I can not pull any dates.


    Note: In my data table all of the fields have data in them.

    Here is an example of the query:

    <cfquery name="Get_XTF" datasource="source">
    SELECT XTF, Role, Email, Expires, attempt1, password as proper_pass
    FROM source.Users
    WHERE (login='#Login#')
    </cfquery>

    Note: that the "Expires" and "attempt1" fields are both date fields.
    The code for the output is:

    <cfoutput query="Get_XTF">
    #XTF#<br>
    #Role#<br>
    #Email#<br>
    #Expires#<br>
    #attempt1#<br>
    #proper_pass#
    </cfoutput>

    The output looks like such:
    0
    R
    [email]meemail.com[/email]


    newpassword_1


    Thanks


    Jared13 Guest

  2. #2

    Default Re: SQL query missing only date data elements

    Are you using an ODBC socket connection by any chance? If so, check the
    advanced settings for your datasource in ColdFusion administrator and make sure
    that the Return TimeStamp as String parameter is unchecked.

    Phil

    paross1 Guest

Similar Threads

  1. Some MIssing Elements
    By 2010designs in forum Macromedia Flash Player
    Replies: 0
    Last Post: February 5th, 04:55 PM
  2. Query of Query Missing Some Data
    By g1zm0guy in forum Coldfusion Database Access
    Replies: 7
    Last Post: January 17th, 09:30 AM
  3. Missing something in this query
    By quiero mas in forum Coldfusion Database Access
    Replies: 5
    Last Post: November 28th, 05:03 AM
  4. date query problem, date in variable
    By roy in forum MySQL
    Replies: 1
    Last Post: October 16th, 11:57 AM
  5. missing fonts in Elements 2
    By Nancy S in forum Adobe Photoshop Elements
    Replies: 2
    Last Post: August 15th, 03:29 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