Archive of UserLand's first discussion group, started October 5, 1998.

Re: Scripts to produce Channel files?

Author:Mesplé Fabrice
Posted:6/17/1999; 9:01:38 AM
Topic:Scripts to produce Channel files?
Msg #:7512 (In response to 7508)
Prev/Next:7511 / 7513

Here is the script -in Cold Fusion- I use to produce the file used by my.userland.com for the channel Liaison Francophone (http://my.userland.com/viewChannel$51).

Obviously some variables should be renamed according to your database.

--------






	SELECT TOP 4 DateAutoCreation, HeureCreation, TitreClip, NumeroFiche FROM infos 
		WHERE HeureCreation <= NOW()
		AND Publiable = 1
		ORDER BY HeureCreation DESC




http://www.w3.org/1999/02/22-rdf-syntax-ns##"" xmlns=""http://my.netscape.com/rdf/simple/0.9/"">



	Liaison Francophone
	http://www.francophonie.org/liaison/<;/link>
	Inforoutes et Francophonie




		Liaison Francophone
		http://www.francophonie.org/liaison/images/LF110x29.gif<;/url>
		http://www.francophonie.org/liaison/<;/link>

">









		



http://www.francophonie.org/liaison/VoirBreve.cfm?Num=#NumeroFiche#<;/link>
	">




This page was archived on 6/13/2001; 4:50:53 PM.

© Copyright 1998-2001 UserLand Software, Inc.