Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

POST limitations using Paradox OCX...

1 view
Skip to first unread message

Trevor Stripling

unread,
Apr 24, 2001, 4:51:09 PM4/24/01
to
I have been working on a project with the Paradox OCX and seem to be running
into some limitations with the POST action.

Example:

I have a page with contact names. Each contact has 7 fields. When you
first access the page there are no contacts. I have a POST button that adds
fields for a new contact and another POST button that writes the data back
to the table.

I can add and update approx. 3 contacts, but when I go to add the 4th, the
page fails and I get a 404 error. I can add more than 3 contacts if I do
not type much in the fields of the first 3.

I have followed it in debug and nothing fails and I can see the HTML sting
reponse and everthing is there, it just fails to return the page.

Is there a limitation to how much data and/or how many fields you can POST
back?

With some tests it seem that when I POST and the content.lenght is over 1020
bytes, it fails. Anything under the number works fine.

I have been communicating with Tony M. and he indicated that there were some
discussions on this topic.

Also, does Corel provide support for the OCX?

Any help would be greatly appreciated!


Trevor Stripling
tre...@mail.theauditgroup.com


Dennis Santoro

unread,
Apr 24, 2001, 6:18:29 PM4/24/01
to
Trevor,

I haven't seen a limitation and I know I have posted more than 102 bytes. I have
posted strings of several K. So there must be more going on.

Can you give us more info? Just the OCX or is there another server involved
(there was a post earlier re a limitation in another web server working as a
proxy). How are you handling the post? Can you show us some code? Can you take
the return string and run it through an HTML editor for correctness?

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
375 High Street
Rochester, MA 02770
(508) 295-7350
and
Waldweg 5
83512 Reitmehring
Germany
08071 924271
Providing solutions to health care, business, governments and non-profits since
1982

Oak Hall

unread,
Apr 24, 2001, 7:38:55 PM4/24/01
to
I have posted large numbers of fields, with large amounts of information, no
failers. Are you using a single html form? Is its action "Post" as apposed to
"Get". What browser are you using?

How about trying to put a debugger break on the very first execution of your
handle request library and then trace it to see exactly where your code fails.

Are you using the ocx as a proxy?

Good Luck
Oak

Liz

unread,
Apr 24, 2001, 7:52:28 PM4/24/01
to
Trevor,

Besides the other replies, what's your memory like on this
machine? Are you using a proxy server? Are you using
frames, or does the page reload on each post with the
already-entered data redisplayed and a new set of empty
fields for your next contact? Or something else?

Anywho, I suspect some kind of memory limitation.

Liz

Tony McGuire

unread,
Apr 25, 2001, 1:27:20 PM4/25/01
to

Trevor,

Update your browser. 5.0 has a lot of problems, of which working with POSTs
is one I ran into immediately. Also, setting values in forms often gets
mungled. The list goes on............


--
Tony McGuire
Jedstar Technologies Inc
http://www.tonymcguire.com
Web Solutions w/Paradox-I


"Trevor Stripling" <tre...@mail.theaudtigroup.com> wrote in message
news:3ae7050c$1_1@cnews...
> Hi Liz, Oak and Dennis,
>
> Thanks for your replies!
>
> First, to try to answer your questions:
>
> Liz,
> The OCX is running on a local machice, NT Workstation 4, 1 GHZ, with 256MB
> RAM. No proxy. No Frames.
>
> Oak,
>
> Yes, I was using a single form as in the test below. Yes, I am using
POST.
> Browser IE 5.0. I did put a debug and followed it through and see no
> failures. When I inspect the string right before the endMethod it looks
> good, it just does not make it to the browser.
>
> Dennis,
>
> The problem happens when I exceed 1020 bytes. Just the OCX no other
server
> or proxy.
>
>
>
> I have put together a set of test code that, hopefully will duplicate the
> problem. I tried to make it as simple as possible.
>
> Here are two POST pages:
>
> In this example TEST.HTM will succeed and TEST1.HTM will fail. The only
> differnece between the pages is that TEST1.HTM has one more field than
> TEST.HTM. I put numbers in the fields as test content.
>
> -Add a record to your server.db with a P, /test.htm, and test.
> -Add to your fechtemplate method:
> case (lower(strHandler) = "test") :
> return test_method(Request, Response)
> -Add a method test_methond with the following:
> method test_method(var Request OleAuto, var Response OleAuto) Logical
> var
> strResult String
> numContent Number
> endVar
>
> numContent = request.contentLength
> numContent.view()
> strResult = "<html>Success</html>"
>
> Response.ResultString = strResult
>
> return True
>
> endMethod
>
> -Notice the view command. TEST.HTM has a content length of 1020 and
> TEST1.HTM has a content lenght of 1035. Anything over 1020 fails.
>
> -Try a POST from TEST.HTM, you should get a simple Success page.
> -Try a POST from TEST1.HTM and you should receive an "The page cannot be
> dispayed" error.
>
> I don't know if has anything to do with the fact that I am not doing
> anything with the data being sent by the POST? I ran into this problem
> before I got to that point in the project.
>
>
> Thanks Again!
>
> Trevor
>
>
>
>
> ***** Dennis wrote: *****

> ***** Oak wrote: *****


>
> I have posted large numbers of fields, with large amounts of information,
no
> failers. Are you using a single html form? Is its action "Post" as apposed
> to
> "Get". What browser are you using?
>
> How about trying to put a debugger break on the very first execution of
your
> handle request library and then trace it to see exactly where your code
> fails.
>
> Are you using the ocx as a proxy?
>
> Good Luck
> Oak
>
>

> Liz <lea...@aros.net> wrote in message news:3AE611BC...@aros.net...

Trevor Stripling

unread,
Apr 25, 2001, 1:13:57 PM4/25/01
to

Thanks for your replies!

Oak,

Dennis,

Response.ResultString = strResult

return True

endMethod


Thanks Again!

Trevor


***** Dennis wrote: *****

Trevor,

***** Oak wrote: *****

Good Luck
Oak

Trevor Stripling

unread,
Apr 25, 2001, 1:58:29 PM4/25/01
to
Hi Tony,

Updated to IE 5.5. Same problem.

Trevor


"Tony McGuire" <tmcg...@jedstar.com> wrote in message
news:3ae7081b$1_3@cnews...

Trevor Stripling

unread,
Apr 25, 2001, 4:36:25 PM4/25/01
to
Here is another bit of information the error page that I get is:
 

The page cannot be displayed

The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.

Please try the following:

  • Click the refresh.gif (82 bytes) Refresh button, or try again later.
  • If you typed the page address in the Address bar, make sure that it is spelled correctly.
  • To check your connection settings, click the Tools menu, and then click Internet Options. On the Connections tab, click Settings. The settings should match those provided by your local area network (LAN) administrator or Internet service provider (ISP).
  • If your Network Administrator has enabled it, Microsoft Windows can examine your network and automatically discover network connection settings.
    If you would like Windows to try and discover them,
    click Detect Settings Detect Network Settings
  • Some sites require 128-bit connection security. Click the Help menu and then click About Internet Explorer to determine what strength security you have installed.
  • If you are trying to reach a secure site, make sure your Security settings can support it. Click the Tools menu, and then click Internet Options. On the Advanced tab, scroll to the Security section and check settings for SSL 2.0, SSL 3.0, TLS 1.0, PCT 1.0.
  • Click the Back button to try another link.


Cannot find server or DNS Error
Internet Explorer

"Trevor Stripling" <tre...@mail.theaudtigroup.com> wrote in message news:3ae72dd0$1_3@cnews...
Hi Liz,

Wow, 7904.  I wish I cound get the same.

Here try the HTML forms that go with the test code I sent.

If you could do the exact test, I would greatly appreciate it.

Trevor

"Liz" <l...@aros.netlead> wrote in message
news:3AE72855...@aros.netlead...
> Trevor,
>
> First, you didn't include the htm files, but I wouldn't unless
> someone first asks you too.
>
> Next, I have a question.  You say it only happens with posts and
> only with lots of data.  So, explain how the web page is laid out
> and what's included in that post - go back to my first reply for
> some questions on how the site functions.
>
> Just did a quick test, posted a form with 'contentlength' of
> 7904.  Worked fine.  Something else is going on for you.  Please
> give us more detail.
>
> Liz


Liz

unread,
Apr 25, 2001, 3:41:09 PM4/25/01
to

Trevor Stripling

unread,
Apr 25, 2001, 4:46:23 PM4/25/01
to
Also, the OCX Status shows 200 even thou I receive the error page.  If I am correct this means success sending page to browser?
 
Trevor
"Trevor Stripling" <tre...@mail.theaudtigroup.com> wrote in message news:3ae73484$1_3@cnews...

Tony McGuire

unread,
Apr 25, 2001, 5:24:11 PM4/25/01
to

Trevor,

Please don't post HTML. Many of us won't even look at it, what with the
proliferation of viruses out there (my viewer eliminates all HTML).

You are correct, however, than 200 indicates 'success'.

This certainly appears to be a 'client browser' issue. You may want to
check your browser settings; make sure it is looking at every page rather
than a cached version ( Internet Options | General, Temporary Internet Files
| Settings | Check for newer versions and use every time or automatic).

Also, if you have an IP to connect to, pass it along and I can see if I get
the same results. (I got nowhere figuring this out before you posted here.)

Trevor Stripling

unread,
Apr 25, 2001, 5:20:16 PM4/25/01
to
Another strange thing.  In the test, the form TEST1.HTM will work with >2000 as content length if I open my browser and POST from it first.  The next time it fails.  If I post with the TEST.HTM that always works first then the TEST1.HTM, it fails.
 
Also, if I go to Intenet Options and change my Security Level and come back to the form, it will work one more time, then fail?
 
It's like if I reset my brower, it will work once, then fail.
 
It's got to be a brower setting or bug.  I'm confused.
 
Trevor
"Trevor Stripling" <tre...@mail.theaudtigroup.com> wrote in message news:3ae736d5$1_2@cnews...

Dennis Santoro

unread,
Apr 25, 2001, 5:22:49 PM4/25/01
to
Trevor,

Please don't post HTML, even in this context. Lots of folks have HTML
turned off because of the stuff many unscrupulous types do with HTML
posts to NGs. Same goes for attachments, javascript, etc. Send in plain
text. Folks will be able to read it (since that is what you actually
want here) with no issues, and those who want to see it in HTML ac copy
and paste to their browser. And this particular HTML is going to cause
some folks problems replying. Makes life easier on everyone if you stick
to plain text.

You might check out this link re NG nettiquet.

http://www.techtricks.com/assorted/newshints.php3

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
375 High Street
Rochester, MA 02770
(508) 295-7350
and
Waldweg 5
83512 Reitmehring
Germany
08071 924271
Providing solutions to health care, business, governments and
non-profits since 1982

Trevor Stripling wrote:


Liz

unread,
Apr 25, 2001, 5:31:44 PM4/25/01
to
Trevor,

In netscape, those show up as part of your post, and I don't
know how to extract them into files (no obvious means
presented themselves). I'll look at them if you put them in
a zip and send them to my email address (don't post to the
groups again). Remove the word lead from my return address
to get my real return address.

Liz
---
Get the lead out before you reply

Oak Hall

unread,
Apr 26, 2001, 8:24:27 AM4/26/01
to
Wondering,

Your post submits to the ocx, your code executes fine, and replies
with a string and a 200 status, but you web browser displays "Error page
could not be displayed", and this is the ONLY time this happens the rest
of your site works fine and smaller posts work fine???

If this is "Yes" then I would wonder the following, How long does it
take your code to process the data?? Is your web browser timing out
because the reply takes to long to be sent back??

Good Luck
Oak

Liz

unread,
Apr 26, 2001, 9:16:00 AM4/26/01
to
Trevor,

First, in Netscape, unchecking View > View Attachment Inline
enabled me to see those things as files (in case anyone else
wants to know). So, I learned something new.

Second, using the files in this page (rather than the .zip, which
I forgot to bring to work with me), the first page is right at
1020 and works fine; the second is at 1035 and works fine. So,
it's something in your setup somewhere...

NOTE: You cannot do a post using localhost as both server and
client, so I had to route the request through our proxy machine.
That may have played a role in the problem/solution.

Liz


Trevor Stripling wrote:
>
> Hi Liz,
>
> Wow, 7904. I wish I cound get the same.
>
> Here try the HTML forms that go with the test code I sent.
>
> If you could do the exact test, I would greatly appreciate it.
>
> Trevor
>

>
> Name: test1.htm
> test1.htm Type: Hypertext Markup Language (text/html)
> Encoding: x-uuencode
>
> Name: test.htm
> test.htm Type: Hypertext Markup Language (text/html)
> Encoding: x-uuencode

RobbK

unread,
Apr 26, 2001, 9:34:25 AM4/26/01
to
I ran into the same exact problem you're encountering. It only affected IE5 and
IE5.5 . I posted my code in the NG and others were not able to duplicate the
problem but all of my boxes misbehaved the same way. The only way I was able to
get rid of it was by running a proxy. I don't know why that took care of it.
After spending a week of debugging, checking & changing setting, and not finding
anything wrong in my HTML or OPAL code I just gave up and went with the proxy.

-RobbK

Trevor Stripling

unread,
Apr 26, 2001, 10:08:10 AM4/26/01
to
Hi Oak,

Yes all of my code executes fine and I get a 200 status. When I inspect the
string that is being sent back to the server it is exaclty what is supposed
to be sent. But I get a Server Not Found error on my IE titlebar.

The code in my test takes less than one second to execute.

The weird thing is that Netscape works fine. The problem only happens in IE
5.0 and 5.5?

I'm stumped????

Tony M. has ran the test off of my server and so far he is seeing the same
problem also. He is seting it up on his system to see if he gets the same.

Trevor


"Oak Hall" <o...@neumedia.net> wrote in message
news:3AE8137A...@neumedia.net...

Trevor Stripling

unread,
Apr 26, 2001, 10:10:50 AM4/26/01
to
Hi Liz,

Are you using Netscape or IE 5.x?

I downloaded Netscape yesterday and so far it works fine with the test????

I have been testing using one machine as the server and another as the
client (browser) and still have the problem.

Trevor


"Liz" <l...@aros.netlead> wrote in message

news:3AE81F90...@aros.netlead...

Liz

unread,
Apr 26, 2001, 10:18:16 AM4/26/01
to
Maybe IE has code in it: if webserver.brand = Corel then fail
endIf (Wouldn't be the first time.)

Liz

Liz

unread,
Apr 26, 2001, 10:16:53 AM4/26/01
to
Trevor,

Netscape 4.76.

Liz


Trevor Stripling wrote:
>
> Hi Liz,
>

Trevor Stripling

unread,
Apr 26, 2001, 10:12:34 AM4/26/01
to
Hi Robb,

Can you explain more about running a proxy? What proxy are you using?

We have a router and firewall versus a proxy.

Trevor

"RobbK" <robb.k...@noaa.gov> wrote in message
news:3AE823E1...@noaa.gov...

Vladimir Menkin

unread,
May 4, 2001, 6:02:13 PM5/4/01
to
Hi!

STRANGE THING. I got the same problem as Trevor... And for me the solution became to turn
off Friendly Error Messages in the advanced settings of IE options. Stupid... I or M$?
Trevor, can you check this solution in your case?

Vladimir Menkin

Trevor Stripling

unread,
May 16, 2001, 9:14:57 AM5/16/01
to
Hi Vladimir,

You got it right, thanks for the input, I turned off friendly error messages
and the problem went away, but only to find another.

It does work now, but at the point that it would ususally fail, it hits the
server twice for every POST. I have a form that you click a POST button to
add a new set of contact fields. Since it is hits the server twice, it adds
two every time. It is like it thinks the POST failed due to a friendly
error and POSTs again????

I am having a similar problem with Netscape, the weird thing is that it was
only happening on GETS not POSTS, now IE is doing just the oposite, it hits
the server twice on POSTS not GETS.

Anyone experiencing similar problems????


Thanks,

Trevor

"Vladimir Menkin" <men...@east.ru> wrote in message
news:3AF326E5...@east.ru...

Trevor Stripling

unread,
May 16, 2001, 10:36:26 AM5/16/01
to
What proxy did you use?

Trevor


"RobbK" <robb.k...@noaa.gov> wrote in message
news:3AE823E1...@noaa.gov...

Vladimir Menkin

unread,
May 16, 2001, 11:42:37 AM5/16/01
to
Hi!

> It does work now, but at the point that it would ususally fail, it hits the
> server twice for every POST. I have a form that you click a POST button to
> add a new set of contact fields. Since it is hits the server twice, it adds
> two every time. It is like it thinks the POST failed due to a friendly
> error and POSTs again????

Yes, I saw exactly the same in my case. It seems that when the friendly messages are on,
the error arises on the second POST. The second POST is generated only by IE (not
Netscape) in case of contentlength of the POST operation exceeds 8192 bytes (2^13). The
only "solution" I found is to keep maximum POST contentlength below 8192 (i.e. to avoid
extremly large forms - to divide such forms on several small ones).

> I am having a similar problem with Netscape, the weird thing is that it was
> only happening on GETS not POSTS, now IE is doing just the oposite, it hits
> the server twice on POSTS not GETS.

These problems are different - I far as I understand, double GET has roots in Netscape
cashing alghoritm, but not sure...

Vladimir Menkin

Trevor Stripling

unread,
May 16, 2001, 12:53:50 PM5/16/01
to
I am getting the double POST with content lenght that exceed 1024? I would
love it if it only happened > 8192.

Do you have a proxy?

Trevor

"Vladimir Menkin" <men...@east.ru> wrote in message

news:3B029FED...@east.ru...

Trevor Stripling

unread,
May 16, 2001, 1:25:13 PM5/16/01
to
I get the double post on anything greater than 1022 (exaclty), the wierd
thing is that when my contentlenght is greater than ~2k (don't know exact
byte) the problem goes away again. I have not tried anything near 8k.

I am going to try to use an Apache server as a proxy to see if it helps.
Another post to the NG indicated that a proxy solved all his problems

Trevor

"Vladimir Menkin" <men...@east.ru> wrote in message

news:3B02B57B...@east.ru...


> > I am getting the double POST with content lenght that exceed 1024? I
would
> > love it if it only happened > 8192.
> >
> > Do you have a proxy?
>

> No... Can you check it? I.e. exact content length when the double POST
begins?
>
> Vladimir Menkin
>


Vladimir Menkin

unread,
May 16, 2001, 1:14:35 PM5/16/01
to
> I am getting the double POST with content lenght that exceed 1024? I would
> love it if it only happened > 8192.
>
> Do you have a proxy?

No... Can you check it? I.e. exact content length when the double POST begins?

Vladimir Menkin

0 new messages