Whats the name of the server?

[DerStephan]

Hallo again

Ok I have a page in my web-aplication and on this page I have an action button that computes and calls an URL:

database := @ReplaceSubstring(@Subset(@DbName; -1);"\\";"/");
server := @Name([CN]; @Subset(@DbName; 1));
url:="[URL unfurl="true"]http://"+server+"/"+database+"/all/$searchForm?SearchView";[/URL]
url

It works fine, well not realy

the only problem is @DbName

It's computet on server side, so for the server the server is localhost and @DbName gives me a NULL-String for the server name, but how to get the right name of the server?
It can't be that difficult.... I hope

Thanks in advance


Stephan

 

[pmonett]

Not difficult it is, you just need a CGI variable instead of @dbname.
Put a field in your form named Server_Name. In the browser, it will automatically be filled with the name of the server via CGI, and you can use that in your formula.
Look up CGI variables in your Designer Help for more info.

Pascal.

 

[DerStephan]

Hi Pascal,

My problem is, that I have a page....

But I will try to use a form

I already thought of using cgi variables but on poages it wouldn't work

But a form is also a page, or?

strange workaround


Regards


Stephan

 

[pmonett]

Silly me. I didn't read the word "page" correctly.
OK, field won't work.
Hmmm, using Java could work, but your button would need to be coded in Java instead.
If you do that, you could load the server_name in the OnLoad event (defined in a variable for the frame), then call that variable in the button code.
I think that could work.

Pascal.

 

[DerStephan]

Ok I didi it with a Form it works fine.
hope no one will ever save this frame

but thanks


Stephan

 

[pmonett]

Use the SaveOptions field in the form, or better yet, go to the QuerySave event and put

Continue=False

.