View Single Post
 
Old June 4th, 2006, 07:10 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

From what I can see, I don;t think this SQL statement would cause the error you're getting. I see the same number of columns and values.

However, you enclose all your data values in quotes, which won't work for numeric fields. Are you sure, for example, that BrAge is a text type in the database?

And did you try executing this SQL statement that you posted? Maybe this one works, but fields that contain a ' don't....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004