---Sending very long text into DB-----

[olga]

Hey guys,

I am sending a very long text from Flash into the DataBase. The record is not created. (Although when I am sending the text less then 1500 characters it works fine)
I am using:
Flash5 ( In the textfield Max Characters - 10000)
ASP
DB - SQL 2000 (Data type of the field - Text)

Here is the Flash script:

loadVariables ("ASP_Flash_Insert2.asp", this, "POST");

Does anybody knows how to fix this?

Thank you

Olga.

[Flash-db]

I wasn't aware that Flash has any "POST" size limit restrictions - I think it's just whatever your server is set at which is usually like 2 mB or so (which is way more then is ever needed).

Could this be a restriction on the column type you are trying to insert the Text into - what type are you using.

Can you try a test - something like Post the Contents to a asp script that just prints out what you sent. - so at least you know it can handle that.  If that works their may be a size limit on the column type in the db you are trying to insert the text into.

Other then that it should work.

[olga]

Jeff,

Thank you for your response. I know what you mean. I made a script in ASP to display the info in the browser, but it doesn't work.
Here is the script:

<%  Skills = Request("Skills")

    Response.Write "&i=" & Skills
   
%>

I think something is wrong there.
Could you advise me any other script to test it?
I would really appreciate it!

Olga.

PS: DB field data type is set to text wich is more then millions characters.

[Flash-db]

Ok,

1:  Their is not a problem with the data type in the db.
2:  This works when sending 1500 Or less characters?


Does the test script you wrote work with less then 1500 characters.

- You have an input text field called 'Skills'

Then

the AS:
loadVariables ("ASP_Flash_Insert2.asp", this, "POST");


I have no idea why this would not work using 'POST' - It would not work with 'GET' because their is a Limit on the amount of text you can send in that way - maybe for some weird reason it is trying to send the request via GET instead of POST.   Or maybe your server has a really low limit setting for the amount of data you can send using 'POST' (doubtful though).

I don't know if I have ever tried sending a really large amount of text from Flash to a script - 1500 characters doesn't seem like that much though.

[olga]

Even more interesting:

I tryed to use "POST"  and then "GET"  it gives exactly the same results: It inserts up to 1500 characters and if it is more - it doesn't create any record in DB.