@dbName don't work when migrate from R5 to R6

HCL Domino Domino Forum
1

Hi all,

Actually I have a Domino Server R5.7 running in a Windows-NT SP4.

I have a web view where a column use the next formula, that works fine:

tmp:=@Name([CN];@DbName);

Path:=@Trim(@Implode(@Explode(@Subset(tmp;-1);“\\”);“/”));

“<tr onClick="window.location='/”+Path+“/agnt_genDoc?OpenAgent&UNID=” +@Text(@DocumentUniqueID)+“'" style="cursor:hand" >” +TIPODOC+“”

But now, I’m triying to migrate to a R6 Domino Server running in a Suse Linux 8.0.

In this new environment this formula don’t work.

I find that @dbcolumn don’t return information about the server name , so @name([cn],@dbname) only return the first member of the database URI.( If the database URI is ‘net\temp\bb.nsf’ only return ‘net’ )

In Notes Help I’ve found that I must rebuild the view with Crtl-Shift-F9. I do that but the error remains.

In the server console I wrote “load compact ” and “load fixup ” triying to rebuild views at server level, but without results.

Can someone help me?. I’m really mad about that.

Thanks in advance.

2

Subject: @dbName don’t work when migrate from R5 to R6

The issue is in the ‘Path’ temporary variable. Your code is set up to use the delimiters used by windows - you need to update it for use with Linux.

Extract from the help:

UNIX uses the “/” character (slash) as the directory separator while DOS/Windows platforms use "" (backslash). LotusScript supports the use of slash and backslash, with the following restrictions:

String literals. If a slash is used in a string literal that is a pathname argument, the .LSO file generated will not run on other platforms, unless that platform supports slash (for example, the UNIX platform).

String variables. If you assign a string literal containing a slash to a variable, and then pass the variable as a pathname argument, a run-time error occurs if the platform does not support slash pathnames (for example, the DOS/Windows platform).

HTH,

Ranjan

3

Subject: RE: @dbName don’t work when migrate from R5 to R6

Thanks for your response, Ranjan.

I think my trouble is other.

Simplifiying my question:

When applying the formula @name([cn];@dbname) in a view column in my database ‘net\temp\pp.nsf’, it return only ‘net’.

Since that point, the error is previous at calculate ‘Path’.

Actually I’m changing ‘@name([cn];@DbName)’ for ‘@subset(@DbName;-1)’ ¡against Lotus recommendations! and my formula works fine, but that suppose search in all my databases and views.

So, I’m still looking for better solution. I think there must be something at Administrator Level, but I can’t find it.

Regards.

4

Subject: RE: @dbName don’t work when migrate from R5 to R6

The issue is DEFINATELY the ‘/’. We have experienced the issue b4…

HTH,

Ranjan

5

Subject: RE: @dbName don’t work when migrate from R5 to R6

When applying the formula @name([cn];@dbname) in a view column in my
database ‘net\temp\pp.nsf’, it return only ‘net’.

and it’s also due to

UNIX uses the “/” character (slash) as the directory separator while
DOS/Windows platforms use "" (backslash).

your database full file name is not

net\temp\pp.nsf

but

net/temp/pp.nsf

and CN is “net” like it should be.

but that suppose search in all my databases and views.

use DDsearch - it rocks!