please dont rip this site

SET Statement

The SET statement maps column names to property IDs and GUIDs (SET PROPERTYNAME) or selects a ranking method for content searches (SET RANKMETHOD).

You typically use a series of SET statements to define your friendly names for columns, prior to executing subsequent SELECT statements.

The type of aliasing done with SET is similar to the [Names] Section of the Index Server Internet Data Query (.idq) files, where you can define "friendly" column names for use in queries.

SET PROPERTYNAME

This statement associates a property set with a friendly name (column alias) and a data type. The property is identified by a GUID and a property ID, which can be either a number or a string. The SET PROPERTYNAME definitions last for the duration of an active connection.

Note   Once a property name has been used in a view, it cannot be redefined.

Syntax

SET PROPERTYNAME 'GUID '
PROPID { 'Property_Name' | Property_ID } AS Friendly_Name 
[ TYPE dbtype ]

Elements

GUID   Specifies the Globally Unique Identifier. The GUID must be written in the following format, enclosed in single quotes:
  • One 6-hex-character sequence, followed by a minus sign
  • Three 4-hex-character sequences, followed by minus signs
  • One 12-hex-character sequence, followed by a minus sign
   
Property_Name   Specifies the name of the property within the ActiveX property namespace.
   
Property_ID   Specifies the property ID as a decimal or hexadecimal number. If you use a hexadecimal number, precede the number with "0x".
   
dbtype   Specifies the type of data being used. The dbtype parameter is optional for Index Server. You need to specify the parameter in situations when the data type is not a string. This is the default. For example, in the following piece of code, Index Server needs to know whether to interpret the value as a string or a date: 

WHERE MyProperty = '1996-10-10'

If the data type is not provided, DBTYPE_WSTR (Unicode string) is assumed. See the Names section of the Internet Data Query Files chapter for further information.
   
Friendly_Name   Specifies the friendly name (column alias). It is possible to set different (multiple) friendly names to the same property. For example, the friendly name "author" may be also known as "auteur" for a mixed community where both English and French are spoken. However, it is important to note that these two friendly names cannot be used in the same query.

Example

  1. Following is an example of the SET PROPERTYNAME statement: 
    
SET PROPERTYNAME 'D5CDD502-2E9C-101B-9397-08002B2CF9AE' 
PROPID 0xE AS DocManager

SET RANKMETHOD

SET RANKMETHOD sets the ranking method you want to use before issuing queries. The SET RANKMETHOD definition lasts for the duration of the session with Index Server. Subsequent queries will continue using the method you set until you change it. If the specified method is not supported, the default (JACCARD COEFFICIENT) is used instead.

Syntax


SET RANKMETHOD Method

Elements

Method   Specifies the ranking algorithm to use to evaluate the rank of a vector query match for content searching. The method can be one of the following:
  • JACCARD COEFFICIENT
  • DICE COEFFICIENT
  • INNER PRODUCT
  • MINIMUM
  • MAXIMUM

Example

  1. Following is an example of the SET RANKMETHOD statement: 
    
SET RANKMETHOD DICE COEFFICIENT

© 1997 by Microsoft Corporation. All rights reserved.
file: /Techref/language/asp/ix/ixseset.htm, 6KB, , updated: 1997/10/1 01:56, local time: 2024/5/16 20:37,
TOP NEW HELP FIND: 
18.226.251.210:LOG IN
 ©2024 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?
Please DO link to this page! Digg it! / MAKE!

<A HREF="http://www.massmind.org/techref/language/asp/ix/ixseset.htm"> SQL Access to Index Server Data: SET Statement</A>
After you find an appropriate page, you are invited to your to this massmind site! (posts will be visible only to you before review) Just type a nice message (short messages are blocked as spam) in the box and press the Post button. (HTML welcomed, but not the <A tag: Instead, use the link box to link to another page. A tutorial is available Members can login to post directly, become page editors, and be credited for their posts.


Link? Put it here: 
if you want a response, please enter your email address: 
Attn spammers: All posts are reviewed before being made visible to anyone other than the poster.
Did you find what you needed?
 

Welcome to massmind.org!

 

Welcome to www.massmind.org!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  .