Jump to content
Larry Ullman's Book Forums

Recommended Posts

Table structure is:

ID int(11) Auto Primary Key Not NULL

DetoxUnit varchar(255)

Address1 varchar(255)

Address2 varchar(255)

Suburb int(11)

Phone varchar(255)

Fax varchar(255)

Contact varchar(255)


Command is:

insert into tblDetoxUnits (DetoxUnit, Address1, Address2, Suburb, Phone, Fax, Contact) values('Dr Gumley\'s Sanitorium', '21 Acidic way', '', '13', '3210 9999', '3210 8888,' 'Michelle');


The error message is:

Column count doesn't match value count at row 1 in
on line


As far as I can see I am trying to insert 7 values into their 7 coresponding columns.


What am I missing?

Link to comment
Share on other sites

That's Great! Code on bruda! or (Sista!... profile didn't say gender) Im just paying it forward when I can, cause there is a ton of help on this forum. This is the only spot on the internet for coding help (as far as I am concerned) that is worth while. I keep coming back and learning from all the loyal members, especially when I read other members coding troubles & solutions.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...