Access database error message

Can anyone help me decypherthe 'POST DATA' portion of an errormessage from IIS that goes like this:
>
> POST Data:
> b00=on&b10=on&a40=on&BoxA40=Yes&a50=on&BoxA50=Yes&a60=on&BoxA60=Yes&a7
> 0=on&B
> oxA70=Yes&a80=on&BoxA80=Yes&a90=on&BoxA90=Yes&a100=on&BoxA100=Yes&a110=on&Bo
> xA110=Yes&a120=on&BoxA120=Yes&a130=on&BoxA130=Ye . . .

The error is caused when the page runs a script to insert data into MS Access (web app @discountasp).The INSERT statementruns in a For...Next loop - and inserts data into a new row (new record) as 'i' is incremented with each loop.When only 1 record is inserted - For i = 0 to 0 - everything is fine. When 2 or morerecords - For i = 0 to1 (or2 or3...)- are inserted, page crashes with error as above.


Does anyone know:

1.Is the post data string too long tofit on the screen (the 'Ye ...' looks like a 'Yes' that is truncated)?
2.Is there anything in asp/sql/vbscript code that could cause this type of error msg endin as '...' ?
Any thoughts or ideas would be appreciated.

The sql code that cause this error is as follows:

 

Looks like truncation disappears when # ofitems posted reduced. Can read entire line for POST DATA OK.

But, I am still stuck with an asp page that crashes when the sql="INSERT statement cycles second time (i=1....for i = 0 to 1...Next) to input data to next row and make next record.
Error msg looks like this:


HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services


Technical Information (for support personnel)

• Error Type:
  Microsoft VBScript runtime (0x800A000D)
  Type mismatch
  /rock/users9T.asp, line 270
  
  
• Browser Type:
  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
  
• Page:
  POST 89 bytes to /rock/users9T.asp
  
• POST Data:
  a00=on&BoxA00=Yes&b10=on&BoxB10=Yes&b20=on&BoxB20=Yes&BoxB30=Yes&flag=True&Submit1=Submit

Code for INSERT is in previous thread (from me)





Any help much appreciated


</CODE>



Richard

www.rsai2.com