ASP->Stored Procedure Properties

[ACase]

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

[Bruce Barker]

check that you are doing form posts, not gets. a get will limit you to about
2k.

-- bruce (sqlwork.com)

"ACase" <AC***@discussions.microsoft.com> wrote in message
news:3C**********************************@microsof t.com...

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

[ACase]

Your a genius. Thank You.

Amazing that one little piece of code, was the source of so much confusion.
"Bruce Barker" wrote:

check that you are doing form posts, not gets. a get will limit you to about
2k.

-- bruce (sqlwork.com)

"ACase" <AC***@discussions.microsoft.com> wrote in message
news:3C**********************************@microsof t.com...

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