Professional Web Applications Themes

MySQL Queries with multiple statements - Coldfusion Database Access

I'm trying to include multiple statement in a MySQL query. MySQL seems to need to have a linefeed between the statements to work correctly but no matter what text i put in between the cfquery tags, CF passes the query as one long string to mysql... causing an error. Any ideas how to make this work? <cfquery NAME="sqldata" datasource="local"> DELETE * FROM PROJECTS; INSERT INTO PROJECTS SELECT * FROM PROJECTS_NEW; </cfquery> I know i can do this with two separate cf queries...... but i'm trying to integrate this kind of query with AJAX.... so i'd like to have both sql ...

  1. #1

    Default MySQL Queries with multiple statements

    I'm trying to include multiple statement in a MySQL query. MySQL seems to
    need to have a linefeed between the statements to work correctly but no matter
    what text i put in between the cfquery tags, CF passes the query as one long
    string to mysql... causing an error.

    Any ideas how to make this work?

    <cfquery NAME="sqldata" datasource="local">
    DELETE * FROM PROJECTS;
    INSERT INTO PROJECTS SELECT * FROM PROJECTS_NEW;
    </cfquery>

    I know i can do this with two separate cf queries...... but i'm trying to
    integrate this kind of query with AJAX.... so i'd like to have both sql
    statements executed in one call to the server.

    roadWorkAhead Guest

  2. #2

    Default Re: MySQL Queries with multiple statements

    I'm not sure that is the problem. Assuming you're using jdbc, is your
    datasource configured to allow multiple sql statements? You may need to enable
    that setting.
    [url]http://www.petefreitag.com/item/357.cfm[/url]
    [url]http://dev.mysql.com/doc/refman/5.0/en/cj-configuration-properties.html[/url]



    mxstu Guest

Similar Threads

  1. I need help with a query using multiple join statements
    By mfitz in forum Coldfusion Database Access
    Replies: 5
    Last Post: June 9th, 06:45 PM
  2. Oracle and asp multiple sql statements
    By Mike D in forum ASP Database
    Replies: 2
    Last Post: June 11th, 01:58 PM
  3. Replies: 6
    Last Post: September 5th, 05:26 AM
  4. MySQL - multipul WHERE statements
    By Jon Roobottom in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 17th, 06:22 PM
  5. help with multiple BETWEEN statements
    By Yvonne G in forum Oracle Server
    Replies: 6
    Last Post: January 13th, 06:42 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