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.CreateOb ject("ADODB.Com mand")
spudateAll.Acti veConnection = MM_RORACsql_STR ING
spudateAll.Comm andText = "spUpdateAllFac ilities"
spudateAll.Comm andType = 4
spudateAll.Comm andTimeout = 0
spudateAll.Prep ared = true
spudateAll.Para meters.Append spudateAll.Crea teParameter("RE TURN_VALUE", 3, 4)
spudateAll.Para meters.Append spudateAll.Crea teParameter("@I D1", 3,
1,4,spudateAll_ _ID1)

<-- There is another 100 Parameter lines, which I am not including -->

spudateAll.Exec ute()

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***@discussi ons.microsoft.c om> wrote in message
news:3C******** *************** ***********@mic rosoft.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.CreateOb ject("ADODB.Com mand")
spudateAll.Acti veConnection = MM_RORACsql_STR ING
spudateAll.Comm andText = "spUpdateAllFac ilities"
spudateAll.Comm andType = 4
spudateAll.Comm andTimeout = 0
spudateAll.Prep ared = true
spudateAll.Para meters.Append spudateAll.Crea teParameter("RE TURN_VALUE", 3,
4)
spudateAll.Para meters.Append spudateAll.Crea teParameter("@I D1", 3,
1,4,spudateAll_ _ID1)

<-- There is another 100 Parameter lines, which I am not including -->

spudateAll.Exec ute()

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***@discussi ons.microsoft.c om> wrote in message
news:3C******** *************** ***********@mic rosoft.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.CreateOb ject("ADODB.Com mand")
spudateAll.Acti veConnection = MM_RORACsql_STR ING
spudateAll.Comm andText = "spUpdateAllFac ilities"
spudateAll.Comm andType = 4
spudateAll.Comm andTimeout = 0
spudateAll.Prep ared = true
spudateAll.Para meters.Append spudateAll.Crea teParameter("RE TURN_VALUE", 3,
4)
spudateAll.Para meters.Append spudateAll.Crea teParameter("@I D1", 3,
1,4,spudateAll_ _ID1)

<-- There is another 100 Parameter lines, which I am not including -->

spudateAll.Exec ute()

Any help, and I mean any would be much appreciated.

Thanks