www.webdeveloper.com
Results 1 to 3 of 3

Thread: column count doesn't match value count at row 1

  1. #1
    Join Date
    Jul 2013
    Posts
    1

    column count doesn't match value count at row 1

    insert into amar(cname,date,address,occupation,idproof,povisit,room,advance,adults,child,perday,eperson) values('amar',2013-12-03,'aaaa','cc',idcara','hosp','520','500','5','2','1500','150')

    this is query insert into my code in asp.net. i am get error as (column count doesn't match value count at row 1) i try allots of time but error is occurring still.... pls give me a solution soon.....

  2. #2
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    idcara is missing a single opening quote

  3. #3
    Join Date
    Sep 2011
    Posts
    59
    Quote Originally Posted by yamaharuss View Post
    idcara is missing a single opening quote
    2013-12-03 should be in single quotes or in # depense from what database you have

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles