Tip

Using ?OpenView&StartKey on the Web for numbers

Using ?OpenView&StartKey on the Web for numbers...

Say you have a situation where the view leading key is a number, this by itself poses no problem. However, when you try to access this view from the Web using something like this:

http://Host/Database/ViewNoteID?OpenView&StartKey=<string>

Then the funs begin ......

It seems that you have to use a string in the first column (the sorted one) so you go ahead and use @Text(<Your_Numeric_Key>) ,if you do that things get no better because the @Text function remove the leading zeros and the result looks like this:

     6  
     60 
     600
     601
     61 
     610
     699
     7  
     70 
     700
     71 
     710
     719
     72 

However if you use a formula like this one:

@Repeat(" "; 5 - @Length(@Text(<Your_Numeric_Key>))) + @Text(<Your_Numeric_Key>)

(The 5 stands for a key up to 99999. If you expect a bigger key, use a bigger number) The formula adds leading blanks so the result in nicely adjust and the result looks like this:

  6
  7
  8
  9
 10
 11

In order to use the StartKey= we have to add leading blanks: The full code for the Java script stuff is to big to fit here but it comes down to this:

query.value =  "               ".substr(1,5 - query.value.length) + query.value ;
window.opener.location.search= "?OpenView&StartKey=" + query.value + "&Count=10&"  ;

Note: query is the field the user will fill to get to the required key.

This was first published in August 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.