Professional Web Applications Themes

[PHP] Escaping nasty quotes - PHP Development

[snip] $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '" . '"' . "' "; {/snip] try ... $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '"' "; The period concats were not needed....

  1. #1

    Default RE: [PHP] Escaping nasty quotes

    [snip]
    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable
    FIELDS TERMINATED BY ',' ENCLOSED BY '" . '"' . "' ";
    {/snip]

    try ...

    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable
    FIELDS TERMINATED BY ',' ENCLOSED BY '"' ";

    The period concats were not needed.
    Jay Blanchard Guest

  2. #2

    Default RE: [PHP] Escaping nasty quotes

    Sorry...Because of the double quote near the ENCLOSED BY .. It delivers a
    P ERROR

    ?



    -----Original Message-----
    From: Jay Blanchard [mailto:jay.blanchardniicommunications.com]
    Sent: Thursday, July 31, 2003 12:38 PM
    To: Roy W; [email]php-generallists.php.net[/email]
    Subject: RE: [PHP] Escaping nasty quotes


    [snip]
    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
    TERMINATED BY ',' ENCLOSED BY '" . '"' . "' "; {/snip]

    try ...

    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
    TERMINATED BY ',' ENCLOSED BY '"' ";

    The period concats were not needed.


    Roy W Guest

  3. #3

    Default RE: [PHP] Escaping nasty quotes

    [snip]
    Sorry...Because of the double quote near the ENCLOSED BY .. It delivers
    a
    P ERROR

    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable
    FIELDS
    TERMINATED BY ',' ENCLOSED BY '"' ";
    [/snip]

    Are the fields enclosed by a quote? If not...

    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable
    FIELDS TERMINATED BY ',' ENCLOSED BY '' ";
    Jay Blanchard Guest

Similar Threads

  1. Bug: Escaping of single-quotes in cfQuery !
    By Stefan K. in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: April 11th, 04:42 PM
  2. cfquery not escaping single quotes correctly
    By Gregd66 in forum Coldfusion Database Access
    Replies: 1
    Last Post: March 17th, 10:18 PM
  3. MS Access driver not escaping single quotes?
    By DGH in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 16th, 09:06 PM
  4. Escaping nasty quotes
    By Roy W in forum PHP Development
    Replies: 5
    Last Post: August 1st, 10:06 AM
  5. Escaping single quotes
    By in forum PHP Development
    Replies: 0
    Last Post: July 30th, 11: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