Professional Web Applications Themes

Table losing Records - Coldfusion - Advanced Techniques

My table is static until I run the code listed in this post. After this code runs, the table loses records at a rate of 100 or so a minute. Any suggestions would be great. <cfquery name="ConvertTimes" datasource="lab_stats"> UPDATE NEWDATA2 SET NEWDATA2.LoginNew = convert(datetime,Left([LoginTime],4)+ '/' + substring(LoginTime,5,2)+'/'+ substring(LoginTime,7,14)), NEWDATA2.TransNew = convert(datetime,Left([TransactionTime],4)+ '/' + substring(TransactionTime,5,2) + '/'+ substring(TransactionTime,7,14)), NEWDATA2.FacilityID = [tblValidIPs].[FacilityID] FROM NEWDATA2 INNER JOIN [tblValidIPs] ON NEWDATA2.NetAddress = [tblValidIPs].NetAddress </cfquery>...

  1. #1

    Default Table losing Records

    My table is static until I run the code listed in this post.

    After this code runs, the table loses records at a rate of 100 or so a minute.

    Any suggestions would be great.

    <cfquery name="ConvertTimes" datasource="lab_stats">
    UPDATE NEWDATA2
    SET NEWDATA2.LoginNew = convert(datetime,Left([LoginTime],4)+ '/' +
    substring(LoginTime,5,2)+'/'+ substring(LoginTime,7,14)),
    NEWDATA2.TransNew = convert(datetime,Left([TransactionTime],4)+ '/' +
    substring(TransactionTime,5,2) + '/'+ substring(TransactionTime,7,14)),
    NEWDATA2.FacilityID = [tblValidIPs].[FacilityID]
    FROM NEWDATA2 INNER JOIN [tblValidIPs] ON NEWDATA2.NetAddress =
    [tblValidIPs].NetAddress
    </cfquery>

    happikarma Guest

  2. #2

    Default Re: Table losing Records

    Are you sure you actually losing records, and not just nullifying a bunch of
    fields? In any event, you need a where clause that contains a subquery.

    where thisfield in (select thisfield from theothertable)

    Originally posted by: happikarma
    My table is static until I run the code listed in this post.

    After this code runs, the table loses records at a rate of 100 or so a minute.

    Any suggestions would be great.



    Dan Guest

  3. #3

    Default Re: Table losing Records

    happikarma,

    1) What do you mean by "loses records at a rate of 100 or so a minute"?
    2) Are you intentionally updating every record in the "NEWDATA2" table in your
    UPDATE statement?
    3) What kind of datetime values are these?

    convert(datetime,Left([LoginTime],4)+ '/' + substring(LoginTime,5,2)+'/'+
    substring(LoginTime,7,14)) .....



    mxstu Guest

Similar Threads

  1. How to get All Records in Table A that don't havematching ID in Table B
    By Photoshare in forum Coldfusion Database Access
    Replies: 4
    Last Post: February 23rd, 10:46 PM
  2. Many form records to many table records
    By Anne in forum Microsoft Access
    Replies: 4
    Last Post: September 3rd, 02:12 PM
  3. Delete from one table with matching records in another table
    By Dale Fye in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 1st, 01:28 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