Professional Web Applications Themes

Update Access field, SQL operator - Coldfusion Database Access

I'm trying to update a field in Access. Here's my code: <CFQUERY> SELECT * FROM tblFinal WHERE Field0='L' AND Field1 = 'ID 123 000 000' </CFQUERY> <CFSET FIELD1NUM = #NumberofRecords.FIELD11#> <CFQUERY> UPDATE tblFinal SET FIELD1= ' ID 123 000 001' WHERE Field1='ID 123 000 000' AND Field0='L' AND Field11num > '99' </CFQUERY>...

  1. #1

    Default Update Access field, SQL operator

    I'm trying to update a field in Access.

    Here's my code:

    <CFQUERY>
    SELECT * FROM tblFinal WHERE Field0='L' AND Field1 = 'ID 123 000 000'
    </CFQUERY>

    <CFSET FIELD1NUM = #NumberofRecords.FIELD11#>
    <CFQUERY>
    UPDATE tblFinal SET FIELD1= ' ID 123 000 001' WHERE Field1='ID 123 000 000'
    AND Field0='L' AND Field11num > '99'
    </CFQUERY>


    Frec Guest

  2. #2

    Default Re: Update Access field, SQL operator

    Is there a question here, or some sort of error that you are getting? If so, you might want to post more information.

    Phil
    paross1 Guest

Similar Threads

  1. Access: (missing operator) in query expression
    By Bob the ASP Builder in forum ASP Database
    Replies: 1
    Last Post: February 12th, 05:18 AM
  2. Update db Field with datagrip
    By dbento webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 1
    Last Post: October 28th, 11:45 PM
  3. Replies: 1
    Last Post: August 1st, 05:57 PM
  4. Key Field Update
    By Ray Thigpen in forum Microsoft Access
    Replies: 0
    Last Post: July 17th, 03:46 PM
  5. Missing Operator Error in Access
    By CJM in forum ASP Database
    Replies: 2
    Last Post: July 14th, 08:23 AM

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