Re: Help - Indexing SQL server

"Stefan Hornburg (Racke)" <[email protected]> Thu, 14 Dec 2006 10:09:25 -0800 (PST)

Newsgroups	gmane.comp.web.swish-e
Message-ID	<[email protected]>

Rui Barreira wrote:
> Hi,
> 
> I need to create an index of a SQL Server database. Is this possible? How?

Write a script that turn database records into fake HTML pages:

	$doc = <<EOF;
<html>
<head>
	<title>$href->{partnumber}</title>
     <meta name="catid" content="$href->{catid}">
     <meta name="manufacturer" content="$href->{manufacturer}">
</head>
<body>
$href->{description}	
</body>
EOF

	$docsize = length($doc);
	
	print <<EOF;
Path-Name: $href->{idf}
Content-Length: $docsize
	
EOF

	print $doc;

And pipe the output to swish-e:

| /usr/bin/swish-e -c swish-e.conf -S prog -i stdin -f db/component-diff

Bye
	Racke


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team