>- see footer for list info -<
Nice one duncan :D
dont you have any work to do?
:D
----- Original Message -----
From: "Duncan Cumming" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 15, 2004 11:51 AM
Subject: Re: [CF-Dev] Greetings From A New member
> >- see footer for list info -<
> hi Peter
>
> For the first part, have a form with whatever fields your President
> needs, perhaps Title, Summary and Main Text. Main Text and perhaps
> Summary being textareas, Title being a text field. Submit this form to
> another .cfm file, which stores the info in the database. Then have a
> page that grabs this information from the database, either the most
> recent one, or the archived list.
>
> Form page:
> <form action="page2.cfm" method="post">
> Title: <input type="text" name="Title"><br>
> Summary: <textarea name="summary" rows="5" cols="30"></textarea><br>
> Main Text: <textarea name="MainText" rows="5"
> cols="30"></textarea><br>
> <input type="Submit">
> </form>
>
> page2:
> <cfparam name="Form.Title" default="">
> <cfparam name="Form.Summary" default="">
> <cfparam name="Form.MainText" default="">
>
> <!--- check they entered something --->
> <cfif Len(Form.Title) OR Len(Form.Summary) OR Len(Form.MainText)>
> <!--- store the info in the database --->
> <cfquery name="addData" datasource="#yourDSN#">
> INSERT
> INTO Messages (Title, Summary, MainText, DatePosted)
> VALUES ('#Form.Title#', '#Form.Summary#',
> '#Form.MainText#', '#Now()#')
> </cfquery>
> Your data has been saved.
> <cfelse>
> You must enter something!
> </cfif>
>
> To display most recent message:
> <!--- gets most recent message --->
> <cfquery name="getMessage" datasource="#yourDSN#">
> SELECT TOP 1 *
> FROM Messages
> ORDER BY DatePosted DESC
> </cfquery>
>
> <cfif getMessage.RecordCount GT 0>
> <cfoutput query="getMessage">
> #getMessage.Title# - #DateFormat(getMessage.DatePosted)#<br>
> #getMessage.Summary#<br>
> #getMessage.MainText#<br>
> </cfoutput>
> <cfelse>
> No message of the day available.
> </cfif>
>
> To list older messages:
> <cfquery name="getArchivedMessages" datasource="#yourDSN#">
> SELECT *
> FROM Messages
> ORDER BY DatePosted DESC
> </cfquery>
>
> <cfif getArchivedMessages.RecordCount GT 1>
> <!--- just display the title and summary --->
> <cfoutput query="getArchivedMessages" startrow="2">
> <!--- start at the second row, as the first one is our most recent
> message --->
> <a
> href="messageDetails.cfm?ID=#getMessage.ID#">#getMessage.Title#</a> -
> #DateFormat(getMessage.DatePosted)#<br>
> #getMessage.Summary#<br>
> </cfoutput>
> </cfif>
>
> Display more details of the archive message:
> <cfparam name="URL.ID" default="">
>
> <cfif IsNumeric(URL.ID)>
> <cfquery name="getMessage" datasource="#yourDSN#">
> SELECT *
> FROM Messages
> WHERE ID = #URL.ID#
> </cfquery>
> <cfelse>
> ID has to be numeric.
> </cfif>
>
> <cfif getMessage.RecordCount GT 0>
> <cfoutput query="getMessage">
> #getMessage.Title# - #DateFormat(getMessage.DatePosted)#<br>
> #getMessage.Summary#<br>
> #getMessage.MainText#<br>
> </cfoutput>
> <cfelse>
> No message found.
> </cfif>
>
>
> That's a very simplistic way of doing it, with a lot of room for
> improvement, but it's just to give you an idea of how you might want to
> go about it.
>
>
> Duncan Cumming
> New Media Developer
> 700 4105 / 01592 414105
>
> >>> [EMAIL PROTECTED] 14/12/2004 17:25:43 >>>
> >- see footer for list info -<
> Good morning everyone,
>
> I just wanted to drop a quick note to introduce myself. My name
> is
> Peter Donahue, and I'm from San Antonio Texas here in the good old USA.
> I
> live here with my wife Mary. I was introduced to Cold Fusion during
> the
> past few months while taking an Internet Commerce Course at Northwest
> Vista
> College here in San Antonio. Of all of the Web Languages I've seen
> for
> adding interactivity I find Cold Fusion to be the most
> programmer/developer
> friendly. What really drew me to the language is the fact that one can
> add
> this interactivity and write CF pages with nothing more than a good
> text
> editor such as Notepad. This is especially important if you're a
> blind
> developer who must rely on special software called screen readers to
> access
> your computer's screen output. I was amazed at how easy it was to
> implement
> a database in to several websites I'm developing by using CF and
> notepad
> instead of a clunky Web Editing program such as FrontPage. I say
> clunky in
> that these packages do not always work well with screen reading
> software.
> Efforts are under way to make Macromedia's Dream Weaver blind-friendly.
> If
> you want to check out my CF work to date visit:
> http://www.freecfm.com/0/1nvc/index.cfm
>
> I'm also developing my first CF Website for an organization Mary
> and I
> belong to. You can get to that site from the URL given above.
>
> The President of the organization mentioned above wants the ability
> to
> be able to post a periodic message to the website for our visitors. I
> told
> him I could develop a form he could use to compose the message which
> would
> appear on a page on the site. Having the ability to archive these
> messages
> to allow visitors to view previous messages is also wanted. If anyone
> has
> code, or tutorials I can check out for creating a message posting
> facility
> I'll appreciate that very much.
>
> We also want to add the ability to include photo albums and
> slideshows
> too. If you have code, or know of good tutorials for developing these
> components in CF that will be appreciated also.
>
> Anyway that's a little about me to allow you to know who I am, and
> what
> I'm doing with CF. Take care and have a great day.
>
> Peter Donahue----- Original Message -----
> From: "Tim Blair" <[EMAIL PROTECTED]>
> To: "Coldfusion Development" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 14, 2004 3:19 AM
> Subject: RE: [CF-Dev] DNS service
>
>
> >- see footer for list info -<
>
> > Any other recommendations?
>
> http://www.gradwell.com/
>
> Blimey, that's the second recommendation Peter's been given in a
> week...
> Anyone would think we know him or something ;)
>
> Seriously: very good service, always willing to help out where needed.
> Complete control panel allows hosting of email/web/ftp etc too, but
> the
> DNS service gives total control over your zone file, so you can add
> what
> you like!
>
> Tim.
>
>
> --
> -------------------------------------------------------
> Badpen Tech - CF and web-tech: http://tech.badpen.com/
> -------------------------------------------------------
> RAWNET LTD - independent digital media agency
> "We are big, we are funny and we are clever!"
> New site launched at http://www.rawnet.com/
> -------------------------------------------------------
> This message may contain information which is legally
> privileged and/or confidential. If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of rawnet limited,
> unless otherwise explicitly and independently indicated
> by an authorised representative of rawnet limited.
> -------------------------------------------------------
>
> _______________________________________________
>
> For details on ALL mailing lists and for joining or leaving lists, go
> to
> http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Forum provided by www.fusetalk.com -<
> >- DHTML Menus provided by www.APYCOM.com -<
> >- Lists hosted by www.Gradwell.com -<
> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your
> help -<
>
>
> _______________________________________________
>
> For details on ALL mailing lists and for joining or leaving lists, go
> to http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Forum provided by www.fusetalk.com -<
> >- DHTML Menus provided by www.APYCOM.com -<
> >- Lists hosted by www.Gradwell.com -<
> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your
> help -<
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed
and should not be disclosed to any other party.
> If you have received this email in error please notify your system manager
and the sender of this message.
>
> This email message has been swept for the presence of computer viruses but
no guarantee is given that this e-mail message and any attachments are free
from viruses.
>
> Fife Council
> Tel: +44 (0) 1592 414141
> **********************************************************************
>
> _______________________________________________
>
> For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Forum provided by www.fusetalk.com -<
> >- DHTML Menus provided by www.APYCOM.com -<
> >- Lists hosted by www.Gradwell.com -<
> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
>
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
