G
Guest
Hello;
I am having an interesting problem.
I have an application which allows a user to enter data on the front end
(Broswer HTML/ASP), click on a button and using the entered data runs some
calculations and returns the data.
Everything works fine, all the fields all the calulcations up to a certain
amount of entered characters. Not sure why.
As soon as I reach the breaking point, any additional character, number will
make the applicatino fail. The application will not even reach the stored
procedure.
I am dealing with 120 possible input boxes, so the data entered can get
pretty big.
My question: Is there a property, either in the browser, in the stored
procedure or in asp which allows for only a certain size limit.
I enclosed the code connection me to the Stored Procedure.
set spudateAll = Server.CreateObject("ADODB.Command")
spudateAll.ActiveConnection = MM_RORACsql_STRING
spudateAll.CommandText = "spUpdateAllFacilities"
spudateAll.CommandType = 4
spudateAll.CommandTimeout = 0
spudateAll.Prepared = true
spudateAll.Parameters.Append spudateAll.CreateParameter("RETURN_VALUE", 3, 4)
spudateAll.Parameters.Append spudateAll.CreateParameter("@ID1", 3,
1,4,spudateAll__ID1)
<-- There is another 100 Parameter lines, which I am not including -->
spudateAll.Execute()
Any help, and I mean any would be much appreciated.
Thanks
I am having an interesting problem.
I have an application which allows a user to enter data on the front end
(Broswer HTML/ASP), click on a button and using the entered data runs some
calculations and returns the data.
Everything works fine, all the fields all the calulcations up to a certain
amount of entered characters. Not sure why.
As soon as I reach the breaking point, any additional character, number will
make the applicatino fail. The application will not even reach the stored
procedure.
I am dealing with 120 possible input boxes, so the data entered can get
pretty big.
My question: Is there a property, either in the browser, in the stored
procedure or in asp which allows for only a certain size limit.
I enclosed the code connection me to the Stored Procedure.
set spudateAll = Server.CreateObject("ADODB.Command")
spudateAll.ActiveConnection = MM_RORACsql_STRING
spudateAll.CommandText = "spUpdateAllFacilities"
spudateAll.CommandType = 4
spudateAll.CommandTimeout = 0
spudateAll.Prepared = true
spudateAll.Parameters.Append spudateAll.CreateParameter("RETURN_VALUE", 3, 4)
spudateAll.Parameters.Append spudateAll.CreateParameter("@ID1", 3,
1,4,spudateAll__ID1)
<-- There is another 100 Parameter lines, which I am not including -->
spudateAll.Execute()
Any help, and I mean any would be much appreciated.
Thanks