2009

[/!][grep search=3D"/(imglibrary|download)&replace=3D&quo=t;http://www.client.ie/\1][grep searc=h=3D<p> </p>&replace=3D][xBTEXT][/grep][/grep][!]



[/!][/convertchars]</description>

<c=ategory>[!]

------------------------------=------



### ==C2=A0Set up categories table =C2=A0###

[/!][table= name=3DconvertCATEGORIES&fields=3Dfrom,to]

[search db=3D../d=b_categories/categories.db&neRIDdatarq=3Dfind_all&assTITLEsort=3D1]=[founditems][rID]=[sTITLE]



[/founditems][/search][/table][convertwords table=3DconvertCATEGORIES]=[sCATEGORY][/convertwords]</category>

<pubDate>[forma=t days_to_date %a, %d %b %Y][dPUBDATE][/format] [format seconds_to_time][ma=th]{[tPUBTIME]}[/math][/format] [if ("[date %Z]" =3D "BST&qu=ot;)][then]+0100[/then][else]GMT[/else][/if]</pubDate>



<guid>http://www.c=lient.ie/news/[format days_to_date %Y/%m/%d][dPUBDATE][/format]/[sSLUG]=/</guid>

</item>

--001485e8e587bcd67104767265d1-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Archives (Steve Craig 2009) Re: [WebDNA] Archives (Tom Duke 2009) Re: [WebDNA] Archives (Govinda 2009) [WebDNA] Archives (Steve Craig 2009)

--001485e8e587bcd67104767265d1Content-Type: text/plain; charset=UTF-8Steve,Hi - the archive link is at the bottom of these emails: http://mail.webdna.us/list/talk@webdna.usI include the following code in awritefile. I'm searching a news database, an image library database and acategories database. But you can strip out what you need.Take care- Tomhttp://www.client.ie/news/Latest news from the ClientenCopyright (C) [date %Y] Client[date %a, %d %b %Y %X] [if ("[date %Z]" ="BST")][then]+0100[/then][else]GMT[/else][/if][date %a, %d %b %Y %X] [if ("[date %Z]" ="BST")][then]+0100[/then][else]GMT[/else][/if]20http://www.client.ie/news/http://www.client.ie/xml/rss.gif4645Latest news from the Client[table name=rssconversions1&fields=from,to] & &[/table][!][/!][table name=rssconversions2&fields=from,to]%0B%1D& &> >< <[/table][!][/!][searchdb=news.db&startat=1&max=15&neRIDdata=find_all&dedPUBDATEsort=1&detPUBTIMEsort=2&tPUBTIMEtype=time][founditems]http://www.client.ie/news/[format days_to_date%Y/%m/%d][dPUBDATE][/format]/[sSLUG]/[convertchars table=rssconversions2][!][/!][hideif [url][sIMAGE][/url]=][searchdb=../db_imageminder/imageminder.db&eqRIDdatarq=[sIMAGE]][founditems][!][/!][hideif [sizesmw]=][/hideif][!][/!][showif [sizesmw]=][/showif][!][/!][/founditems][/search][/hideif][!][/!][grep search="/(imglibrary|download)&replace="http://www.client.ie/\1][grepsearch=

&replace=][xBTEXT][/grep][/grep][!][/!][/convertchars][!]------------------------------------### Set up categories table ###[/!][table name=convertCATEGORIES&fields=from,to][searchdb=../db_categories/categories.db&neRIDdatarq=find_all&assTITLEsort=1][founditems][rID][sTITLE][/founditems][/search][/table][convertwordstable=convertCATEGORIES][sCATEGORY][/convertwords][format days_to_date %a, %d %b %Y][dPUBDATE][/format] [formatseconds_to_time][math]{[tPUBTIME]}[/math][/format] [if ("[date %Z]" ="BST")][then]+0100[/then][else]GMT[/else][/if]http://www.client.ie/news/[format days_to_date%Y/%m/%d][dPUBDATE][/format]/[sSLUG]/[/founditems][/search]--001485e8e587bcd67104767265d1Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printableSteve,

Hi - the archive link is at the bottom of these e=mails:

=C2=A0=C2=A0 =C2=A0http://mail.webdna.us=/list/talk@webdna.us



=I include the following code in a writefile. =C2=A0=I'm searching a news database, an image library database and a categori=es database. =C2=A0But you can strip out what you need.



<=span class=3D"Apple-style-span" style=3D"border-collapse: collapse;">Take c=are



- Tom

=




<?xml version=3D"1.0" encoding=3D"utf-8"?>

<=div><rss version=3D"2.0" xmlns:atom=3D"http://www.w3.org/2005/Atom">

&=lt;channel>



<title>Client - Latest News</title>

<link>=http://www.client.ie/news/</l=ink>

<description>Latest news from the Client</descri=ption>



<language>en</language>

<copyright>Copyrig=ht (C) [date %Y] Client</copyright>

<pubDate>[date %a=, %d %b %Y %X] [if ("[date %Z]" =3D "BST")][then]+0100[=/then][else]GMT[/else][/if]</pubDate>



<lastBuildDate>[date %a, %d %b %Y %X] [if ("[date %Z]"= =3D "BST")][then]+0100[/then][else]GMT[/else][/if]</lastBuild=Date>

<ttl>20</ttl>

<i=mage>



<title>Client - Latest News</title>

<link>=http://www.client.ie/news/</l=ink>

<url>h=ttp://www.client.ie/xml/rss.gif</url>



<width>46</width>

<height>45</height>=;

<description>Latest news from the Client</description&=gt;

</image>

<atom:link href=3D="http://www.cli=ent.ie/xml/news_fulltext.xml" rel=3D"self" type=3D"=application/rss+xml" />



[table name=3Drssconversions1&fields=3Dfrom,to]

=C2=A0& &amp;

[/table][!]

[/!][tabl=e name=3Drssconversions2&fields=3Dfrom,to]



%0B

%1D=C2=A0

&&amp;



>&=amp;gt;

<&lt;

[/table][!]

[/!][search db=3Dnews.db&startat=3D1&max=3D15&neRIDdata=3Dfind_=all&dedPUBDATEsort=3D1&detPUBTIMEsort=3D2&tPUBTIMEtype=3Dtime][=founditems]<item>

<title>[convertwords table=3Drsscon=versions1][sTITLE][/convertwords]</title>



<link>http://www.c=lient.ie/news/[format days_to_date %Y/%m/%d][dPUBDATE][/format]/[sSLUG]=/</link>

<description>[convertchars table=3Drssconver=sions2][!]



[/!][hideif [url][sIMAGE][/url]=3D][search db=3D../db_i=mageminder/imageminder.db&eqRIDdatarq=3D[sIMAGE]][founditems][!]

<=div>

[/!][hideif [sizesmw]=3D]<img src=3D"http://www.client.ie[grep search=3D\.\.\/\.\.&=;replace=3D][FILOC][/grep][sIMAGE]_sm.[FITYPE]" width=3D"[SIZESMW=]" height=3D"[SIZESMH]" class=3D"left" style=3D&qu=ot;border: 1px solid #ccc; padding: 3px;" />[/hideif][!]



[/!][showif [sizesmw]=3D]<img src=3D"http://www.client.ie[grep search=3D\.\.\/\.\.&am=p;replace=3D][FILOC][/grep][sIMAGE].[FITYPE]" width=3D"[SIZEORW]&=quot; height=3D"[SIZEORH]" class=3D"left" style=3D"=;border: 1px solid #ccc; padding: 3px;" />[/showif][!]



[/!][/founditems][/search][/hideif][!]

[/!][grep search=3D"/(imglibrary|download)&replace=3D&quo=t;http://www.client.ie/\1][grep searc=h=3D<p> </p>&replace=3D][xBTEXT][/grep][/grep][!]



[/!][/convertchars]</description>

<c=ategory>[!]

------------------------------=------



### ==C2=A0Set up categories table =C2=A0###

[/!][table= name=3DconvertCATEGORIES&fields=3Dfrom,to]

[search db=3D../d=b_categories/categories.db&neRIDdatarq=3Dfind_all&assTITLEsort=3D1]=[founditems][rID]=[sTITLE]



[/founditems][/search][/table][convertwords table=3DconvertCATEGORIES]=[sCATEGORY][/convertwords]</category>

<pubDate>[forma=t days_to_date %a, %d %b %Y][dPUBDATE][/format] [format seconds_to_time][ma=th]{[tPUBTIME]}[/math][/format] [if ("[date %Z]" =3D "BST&qu=ot;)][then]+0100[/then][else]GMT[/else][/if]</pubDate>



<guid>http://www.c=lient.ie/news/[format days_to_date %Y/%m/%d][dPUBDATE][/format]/[sSLUG]=/</guid>

</item>

[/founditems][/search]

</channel>

</rss>



--001485e8e587bcd67104767265d1-- Tom Duke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[WebDNA] Dead line Time Math (2017) Loss in form (1998) Clean Code: Rules for inserting keyboard returns? (1997) Quit revisited (1997) Roundup function? (1997) Re[2]: New syntax feedback for 4.0 (2000) RE: type 2 errors with ssl server (1997) Forbidden CGI Error (1997) Orders.db problem (2003) maximum database size (2004) Capturing the referring site (1999) User Defined Sorting (1997) Slow wiht MAC OS and Webstar IV (2002) Uh...can someone help me out with the b10? (1997) Execute Applescript (1997) NT or Mac (1997) Version f1 status (1997) syntax question, not in online refernce (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Re:E-mailer application times out (1998)