I am developing a site which uses MS Content index server from perl
scripts. I am using Win32::OLE to link to ADO. The server running the
scrips is using Activestate Perl build 613.
The problem I am having is that the properties I am setting to an object do
not appear to be taking effect.
I use the following subroutine to open up the connection and record set to
CI server.
use Win32::OLE;
$CONNSTR = "Provider=MSIDXS;"; #Conection string for CI
Provider.
$CATALOGUE = "TTMax"; #CI Server Catalogue to
look at.
sub OPENCON {
$CONN = new Win32::OLE("ADODB.Connection");
$RS = new Win32::OLE("ADODB.Recordset");
$CONN->Open($CONNSTR);
$RS->{MaxRecords} = $MAXRECORDS;
$RS->{CursorType} = 1;
$RS->{localeid} = 1031;
$RS->Open($SQL,$CONN,0,1,1);
}
If I set the $RS->{MaxRecords} property, it works, but not entirely as
expected. The other properties, such as:
$RS->{CursorType}
$RS->{localeid}
do not seem to take effect.
With $RS->{localeid} = 1031; I am trying to force CI server to query only
German language files. This is completely ignored, as I should be told
that "und" (and) is a restricted world. However, I am not told this and
all documents with "und" in are returned.
I was wondering if anyone knows of any problems with Win32::OLE that might
cause this.
TIA for your time and help.
Regards
Roland
--
Roland Corbet
Systems Administrator & Developer
Psyche Solutions Limited
Chester Road
Cradley Heath
West Midlands
B64 6AB
Tel: + 44 (0)1384 414183 Ext. 4412
Fax: + 44 (0)1384 414111
Email: [EMAIL PROTECTED]
WWW: http://www.psyche.net.uk
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl
