Professional Web Applications Themes

Help with INSERT INTO statement - Coldfusion - Getting Started

I'm getting the following error on a query. I haven't seen this one before. Any ideas on what I'm doing wrong? Thanks. Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. Here's the query: <cfquery name="qMarkAsHidden" datasource="convention"> INSERT INTO convention06 (hide) VALUES ('Yes') WHERE id = #URL.ID# </cfquery> I'm trying to enter the value "yes" into the "hide" row of my DB....

  1. #1

    Default Help with INSERT INTO statement

    I'm getting the following error on a query. I haven't seen this one before. Any
    ideas on what I'm doing wrong? Thanks.

    Error Executing Database Query.
    [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access
    Driver] Missing semicolon (;) at end of SQL statement.

    Here's the query:

    <cfquery name="qMarkAsHidden" datasource="convention">
    INSERT INTO convention06 (hide)
    VALUES ('Yes')
    WHERE id = #URL.ID#
    </cfquery>

    I'm trying to enter the value "yes" into the "hide" row of my DB.

    s_jancich Guest

  2. #2

    Default Re: Help with INSERT INTO statement

    You cannot use a WHERE ... clause with this type of INSERT statement. You can
    either insert a list of values....

    INSERT INTO tableName(TextColumnName)
    VALUES ('some value')

    OR use a SELECT statement to insert values from another table...

    INSERT INTO tableName(ColumnName)
    SELECT SomeColumnName
    FROM otherTableName
    WHERE SomeNumericID = 1





    mxstu Guest

Similar Threads

  1. Question Insert from ASP to SQL using recordset data as values in insert statement
    By JasonM in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 13th, 05:54 PM
  2. Trouble with INSERT statement
    By Jess930 in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: June 14th, 04:55 PM
  3. Replies: 3
    Last Post: September 30th, 09:24 PM
  4. Insert 100 rows in just one statement
    By David Portas in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 1st, 12:52 PM
  5. Insert Statement help
    By ksbrace in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 30th, 02:04 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