ASP->Stored Procedure Properties

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
 
B

Bruce Barker

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

-- bruce (sqlwork.com)
 
G

Guest

Your a genius. Thank You.

Amazing that one little piece of code, was the source of so much confusion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,997
Messages
2,570,239
Members
46,827
Latest member
DMUK_Beginner

Latest Threads

Top