#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Chennai
    Posts
    160
    Rep Power
    11

    Exclamation how can i use delete in postgresql


    hi

    how can i use delete in postgresql WITH PHP??


    i have used for example

    <delete from "table name" where "auto id" ="3";>
    but when i execute this it is giving a problem
    the errror is Attribute not found

    can any one help me?????????????

    CHANDAR
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Double quotes are for attribute names, single quotes are for string literals (values). In your case, you should be using single quotes (or none at all since it's numeric) around the 3. Because it's double quoted, the engine thinks you are referring to a field named 3, not the value 3.

IMN logo majestic logo threadwatch logo seochat tools logo