is there a limit to the number of form fileds you can insert into a new record at the same time??

i have a short form which works fine (6 fields) but i have a very long form (50 + fields) which will not insert, it does not produce an error message but instead of going to the redirect page it reloads the page with the form on and no record is inserted into the database.

cheers

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk

anybody?????

DW8.02|ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk

what has happened to these forums???
time was you could be guaranteed a reply, nowadays it seems nobody cares anymore

DW8.02|ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk

Hi Dave,

I know it is frustrating when you do not get an answer but this is a voluntary site and as a community there is not always the answer out there.

Back to your question, I believe the limiting element will always be the db limitations rather than the page.



Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

Hi Vince

sorry for the tone Vince, I was not getting at anybody in particular but generally lamenting the demise of this forum.

I have gone over the db again and again and cannot see any reason why it's not inserting.
I have disabled many of the form elements to cut down the size of the insert but still no joy, you are right it is very frustrating especially as one form works and the other doesn't.

DW8.02|ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk

I know this is not going to solve you problem but 50 fields in a form sounds very large to me, not from the point of view of the database, but from the point of view of a user who is going to entering that much data in one go. They could become frustrated and abandon it.

I took a look at the mysql documentation and there is no mention of any limit on the number of fields there, could you consider a redesign of the form so that people entered their data in smaller sections?

Hi Alan

I have been considering this, passing the form input as variables along a series of pages containing smaller forms until I have what i need and then inserting them.. but I wanted to get the insert actually working first.

I have now resolved the problem.. turns out it was me being an idiot as usual.. I have somehow managed to set the enctype of the form to multipart/form-data and this was why it wasn't working. <img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>

trouble now is that with me thinking it was the db i have revamped it so none of my recordsets now work, also i was considering whether it was anything to do with 8.02 updater so i have re-installed without it and now have extraneous code on my pages which i will have to clean up.. jeez what an idiot <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

DW8.02|ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk

good news

I find working with database very frustrating - I like the quickness of using DW but then I like the control that hand coding gives me. I keep getting diverted from doing my database stuff having to learn other techniques then making silly mistakes when I come back to it.