Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Bangalore, India
    Posts
    4

    Unanswered: insert problem, error: invalid column name

    Can anybody plz help me?

    I m getting this error,invalid column name. BUt the same works for mysql.

    my query is:

    insert into lp(lp_date, lp_mobile_no, lp_points) select '$date', a.um_mobile_no as Mobile, round((sum(a.um_count * (b.lw_weightage)))/10,2) as Points from un a,lw b where a.um_rep_date='$date' and length(a.um_mobile_no) >= 6 and a.um_category=b.lw_category and a.um_serv_provider=b.lw_operator and Points >0 group by a.um_mobile_no order by Points, Mobile desc ;


    plz help me

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    What is '$date' ??? If you are trying to pull in the current date, user
    select sysdate ...

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •