OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

October 2009 Blog Posts (5)

Validation on attachment

When I want attachment option in any application then we normally call launch function with attachment.jsp file of dimension and we can attach documents files to a particular record of application.

But if I want to apply validation on attachment means member has to attach documents to a particular record and then he wiil be able to submit the record.

So to do this I am using this query on model

=DBQUERY("select count(*) from modelattachment where… Continue

Added by Neeraj Singh Bhandari on October 28, 2009 at 2:53pm — 1 Comment

Undocumented fix for Attachment feature in dimension


Problem : Attachment.jsp not getting refreshed once the attachment is added.( If the user wants to know the no of attachment's for the record in editor view )

Solution : The attachement.jsp has a function called closeWindow() which calls the save button.

Write a function called closeWindow() inside <script></script> :-

Open the file attachment.jsp and paste the below lines above </script> tag… Continue

Added by Santhosh Mahizhan on October 28, 2009 at 2:30pm — No Comments

Difference between len() and datalength() mssql

If you want to just get number of characters excluding blanks you would use LEN() function, while in all other cases DATALENGTH().

Please find more information about the same in the following links :


Added by VM.Hanitha on October 8, 2009 at 10:28am — No Comments

How to run two Dimension Servers in the same machine

Please do the following to run 2 Dimension servers on the same machine

1. Install two dimension servers.

2. In one of the servers do the following:

a. Navigate to < Server Installation Directory>\DimensionServer\server\default\deploy\jbossweb- tomcat50.sar\server.xml

b. Change the port 6666 to an other free port (e.g. 6667)

c. Navigate to < Server Installation Directory>\DimensionServer\server\default\conf

d. Open the… Continue

Added by Santhosh Mahizhan on October 7, 2009 at 6:19pm — No Comments

Phone Number Validation in forms - Using MSSQL Server function PATINDEX

In forms when asking for phone numbers fields,validation is needed in general like they should not enter alphabets.If you are using MSSQL server you can use the function PATINDEX


Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.

For more information :… Continue

Added by Santhosh Mahizhan on October 1, 2009 at 2:00pm — 2 Comments

Monthly Archives








© 2018   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service