Skip to main content.
home | support | download

Back to List Archive

Re: Help - Indexing SQL server

From: Stefan Hornburg (Racke) <racke(at)not-real.linuxia.de>
Date: Thu Dec 14 2006 - 18:09:59 GMT
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
Received on Thu Dec 14 10:10:00 2006