Re: Limits

Hello Shannon, Thursday, November 30, 2000, 11:46:36 PM, you wrote: SD> Hi people, SD> is there a limit to the number of fields that can be updated in a mysql SD> database at one time? ie can we update as many field with the one query as SD> we like, or is there a maximum number of fields that can be changed.? SD> The reason that I ask is that I have a large number of fields that need to SD> be entered into a database on a form submit that I have decided to split SD> over a few pages. The first page submits the data into the database no SD> problem, the second page uses an update query and that works, but from then SD> on the following 3 or 4 pages do not update the database with the data SD> entered. SD> Any ideas as to why this would be happening, I've done this before and never SD> had the trouble, however this time I do have a lot of fields in the d'base SD> and each query is quite large itself. SD> Kind regards, SD> Shannon I don't know about any limit with fields. When I have this problem in my scripts I always have a problem in sql query. So check query again, and try to write it to brovser it must work. hope it helps. -- Best regards, Daniel mailto:dr@photo.digitallaut.at