Website access problem.

[dearram]

While trying to access web site I am getting following error:

You don't have permission to access / on this server.


Apache/1.3.27 Server at emmersonbennett.com Port 80

 

[kaeserea]

Hi dearram,

probably not the right forum... but ask your admin. If the server is an NT Server then the security flag is probably not set to everybody=read.

Regards
Eva

 

[LouiseMoorcock]

I am getting exactly the same problem as this when I try to launch a WebFocus report from a java application.

The problem occurs because the URL is too long for the command interpreter to cope with (the URL is approx 2.5k characters long because it includes the sql to be run). Can anyone think of a simple way of getting round this? Is there another way to launch the report or something?

 

[gizzy17]

Put your SQL in a focexec. You would then specify the focexec that your are trying to run by pasing &IBIF_ex=focexecname in your URL.

 

[LouiseMoorcock]

The thing is, the application generates a new sql every time. How would you get this data to a focexec? I'm afraid I'm really new to WebFocus!

 

[kiddpete]

You write the SQL commands to a file with the same name as the FOCEXEC. Focus will find it.

 

[gizzy17]

Using the same parameters that you are using in your current application, it may be possible to create the SQL inside of a focexec using dialog manager. For example, if your web form had a number of field names that could be selected that you wanted to put into sql, you could do the following.

SQL
select
  &MYFIELD
-IF MYFIELD0.EXIST EQ 0 THEN GOTO ALLDONE;
-REPEAT ENDSELECT FOR &COUNTER FROM 2 TO &MYFIELD;
 ,&MYFIELD.&COUNTER
-ENDSELECT
from mysqltable;
END

This would fill in the select statement with all of the fields that were selected from the web form.

&MYFIELD would be the first field that they selected from a multiple select box

&MYFIELD0 would only exist if more than 1 field was selected and would contain the number of fields that were selected.

&MYFIELD[number] would only exist if more than 1 field was selected and would contain the value of the iteration that was selected.