studio 5 & unicode

2002-01-01 Thread Paul Hastings

is anyone (else) using studio for unicode format (utf-8
in particular) cf/html templates? it seems to be mangling
my existing (notepad produced) utf-8 cf & html files
pretty consistently. any new utf-8 format files (studio 
5 produced) are also garbaged. a wild guess is that
its mucking up the BOM.

Paul Hastings   [EMAIL PROTECTED]  
DirectorEnvironmental Information Center
Thailand Environment Institute
Member   Team Macromedia (Allaire)
http://www.tei.or.th/eic ---



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.312 / Virus Database: 173 - Release Date: 12/31/2001
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Any ideas on how to do this please?

2002-01-01 Thread Office

Hi folks

The New Zealand Ecological Restoration Network Website at www.bush.org.nz is
currently being
moved over to ColdFusion. ColdFusion is a great tool!

We have the same need with events having patterns.
Our solution so far is to have a one form for one off events and another for
regular events with
a pattern. The data goes back into one table.

There is a second table for the specific occurance.

A volunteer manually enters all the repeat occurances of a regular event.

Its a real hassle. Would be nice to be able to automate this too


Mike Peters
Volunteer Developer

NZERN
Mail: PO Box 9000, Christchurch
(03) 338-5451
E-mail: [EMAIL PROTECTED]
http://www.bush.org.nz


To you too Mike, I am in Victoria so I am not affected but I feel for
those that do live in those areas.

I actually did something similar for Siemens Corporation about 2 years
ago, for their intranet. Mike I would use three filed one to decide the
date it was created, then the type (which could be a list) to determine
the period the event needs to be displayed and maybe one so that it
can't be displayed past this date.

The other thing to keep in mind that each event can be located in one
table, then use a unique user ID that would then identify who the event
belongs to as well. Sorry seeing words on a screen really doesn't help,
but hopefully we can help you out more.



-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 2 January 2002 1:22 AM
To: CF-Talk
Subject: RE: Any ideas on how to do this please?

Andrew, Kym, thanks for your interest in my problem. Happy New Year to
y
ou.
I'm not sure where in Oz you are Andrew, but I hope neither of you are
be
ing
barbecued right now in Sydney. It's a worry for me out here in Windsor,

but
thankfully we haven't been directly threatened by the fire yet, although
some of our friends have had to evacuate their homes up in Kurrajong.


The site in question is www.bluegrass.org.au .. it's a directory of
bluegrass music and events in Australia. At the moment I'm keeping it
up
to
date by editing all the pages myself, using simple html for the most
part.
(there are some dynamic aspects to the site but the events listings are
a
ll
manually created).

Single events, like a concert, I have set up ok. I enter the location
an
d
other details and the date in my SQL database and the listing appears in

the
relevant state pages and disappears after the event is over.

Now I want to do a similar thing with regular events, such as monthly
association meetings, or regular jam sessions (which could be on the
seco
nd
Tuesday of the month say) and I want to allow people around the country
t
hat
I authorise to be able to update listings in their areas. So this
mean
s I
cant have it with all these people (with greater or lesser
understandings
of
html) tinkering with the pages directly. I have to do it by giving them

a
form and the database to get the dynamic updates happening.

So I'd like to give them a form where they can enter the location and
tim
es
and other details of the event, and for the date, let them choose either
specific dates, or a pattern, such as "monthly on the first Friday" or
"fortnightly on Saturday" IT's this aspect I'm not sure how to do.

In my processing of the form, should I insert these "monthly on the
first
Friday" details into the database or convert them to specific dates at
th
at
time.

Or should I pull these events out every time the page is called, and
work
out what events are coming up in the next month, based on the specific
da
te
listings, and the periodic listings?

Does that make it clearer?

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks


-Original Message-
From: Kym Kovan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 1:04 PM
To: CF-Talk
Subject: Re: Any ideas on how to do this please?

Hi Mike,

>I am embarking on a sub-project to allow suitably authorised users to
in
put
>events to my web site, to be displayed a month before the event
happens,
and
>automatically deleted after the event is over. I want the users to be
a
ble
>to put in an event as being held on a specific date, weekly, every two
>weeks, every month, on the third Friday of the month etc.

I am a bit like Andrew, I would like to know more about the thing in
term
s
of size, business of the servers, etc. You can do more work in CF and
put
a
set of events in the DB but it will be bigger as a result but the
queries
a
lot simpler compared with calculating it on the fly every time.

BTW if you are showing the event for a month before, then clearing it,
ho
w
are you going to handle a weekly event :^)


--

Yours,

Kym



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.

LEFT JOIN query question

2002-01-01 Thread Duane Boudreau

I have the following tables:

item_category
 - itemcat_id (int)
 - type_id (int)
 - itemcat_descr (varchar)
 - display_order (varchar)

menuitem
 - itemcat_id (int)
 - menuitem_descr (varchar)
 - menuitem_id (int)
 - price (money)

menu_items
 - menu_id (int)
 - menuitem_id (int)
 - display_order (int)

item_category.itemcat_id -> menuitem.itemcat_id
menuitem.menuitem_id -> menu_items.menuitem_id


I am trying to retrieve all items that match either MI.menuitem_id =
MIS.menuitem_id OR MI.menuitem_id IN (35,32,36,30,37,40,33,24,22,23) but I
am only getting the records that match on MI.menuitem_id = MIS.menuitem_id.
Any ideas why? TIA -> Duane

SELECT
IC.itemcat_id,
IC.type_id,
IC.itemcat_descr,
IC.display_order,
MI.menuitem_descr,
MI.menuitem_id,
MI.price

FROM(
item_category IC
INNER JOIN
menuitem MI ON IC.itemcat_id = MI.itemcat_id
AND MI.menuitem_id IN (35,32,36,30,37,40,33,24,22,23)
)
LEFT OUTER JOIN
menu_items MIS ON MI.menuitem_id = MIS.menuitem_id

WHERE
MIS.menu_id = 1

ORDER BY
IC.type_id,
IC.display_order,
IC.itemcat_id,
MIS.display_order,
MI.menuitem_descr
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Any ideas on how to do this please?

2002-01-01 Thread Andrew Scott

To you too Mike, I am in Victoria so I am not affected but I feel for
those that do live in those areas.

I actually did something similar for Siemens Corporation about 2 years
ago, for their intranet. Mike I would use three filed one to decide the
date it was created, then the type (which could be a list) to determine
the period the event needs to be displayed and maybe one so that it
can't be displayed past this date.

The other thing to keep in mind that each event can be located in one
table, then use a unique user ID that would then identify who the event
belongs to as well. Sorry seeing words on a screen really doesn't help,
but hopefully we can help you out more.



-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, 2 January 2002 1:22 AM
To: CF-Talk
Subject: RE: Any ideas on how to do this please?

Andrew, Kym, thanks for your interest in my problem.  Happy New Year to
y
ou.
I'm not sure where in Oz you are Andrew, but I hope neither of you are
be
ing
barbecued right now in Sydney.  It's a worry for me out here in Windsor,

but
thankfully we haven't been directly threatened by the fire yet, although
some of our friends have had to evacuate their homes up in Kurrajong.


The site in question is www.bluegrass.org.au .. it's a directory of
bluegrass music and events in Australia.  At the moment I'm keeping it
up
 to
date by editing all the pages myself, using simple html for the most
part.
(there are some dynamic aspects to the site but the events listings are
a
ll
manually created).

Single events, like a concert, I have set up ok.  I enter the location
an
d
other details and the date in my SQL database and the listing appears in

the
relevant state pages and disappears after the event is over.

Now I want to do a similar thing with regular events, such as monthly
association meetings, or regular jam sessions (which could be on the
seco
nd
Tuesday of the month say) and I want to allow people around the country
t
hat
I authorise  to be able to update listings in their areas.   So this
mean
s I
cant have it with all these people (with greater or lesser
understandings
 of
html) tinkering with the pages directly.  I have to do it by giving them

a
form and the database to get the dynamic updates happening.

So I'd like to give them a form where they can enter the location and
tim
es
and other details of the event, and for the date, let them choose either
specific dates, or a pattern, such as "monthly on the first Friday" or
"fortnightly on Saturday"   IT's this aspect I'm not sure how to do.

In my processing of the form, should I insert these "monthly on the
first
Friday" details into the database or convert them to specific dates at
th
at
time.

Or should I pull these events out every time the page is called, and
work
out what events are coming up in the next month, based on the specific
da
te
listings, and the periodic listings?

Does that make it clearer?

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks


-Original Message-
From: Kym Kovan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 1:04 PM
To: CF-Talk
Subject: Re: Any ideas on how to do this please?

Hi Mike,

>I am embarking on a sub-project to allow suitably authorised users to
in
put
>events to my web site, to be displayed a month before the event
happens,
and
>automatically deleted after the event is over.  I want the users to be
a
ble
>to put in an event as being held on a specific date,  weekly, every two
>weeks, every month, on the third Friday of the month etc.

I am a bit like Andrew, I would like to know more about the thing in
term
s
of size, business of the servers, etc. You can do more work in CF and
put
 a
set of events in the DB but it will be bigger as a result but the
queries
 a
lot simpler compared with calculating it on the fly every time.

BTW if you are showing the event for a month before, then clearing it,
ho
w
are you going to handle a weekly event :^)


--

Yours,

Kym


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Formating to HTML output

2002-01-01 Thread Darryl Lyons

Disregard my last post :)

-Original Message-
From: atlantis [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, 1 January 2002 8:32 AM
To: CF-Talk
Subject: Formating to HTML output


I have data in a memo field in my access database that has carriage returns
in it to separate different paragraphs.

How do I get the formatting to come through as  or  when the data is
output on a webpage?

Right now all the data runs together.

Thanks,

Jason


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Formating to HTML output

2002-01-01 Thread Darryl Lyons

ParagraphFormat(variable)

Darryl

-Original Message-
From: atlantis [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, 1 January 2002 8:32 AM
To: CF-Talk
Subject: Formating to HTML output


I have data in a memo field in my access database that has carriage returns
in it to separate different paragraphs.

How do I get the formatting to come through as  or  when the data is
output on a webpage?

Right now all the data runs together.

Thanks,

Jason


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Visual Basic?

2002-01-01 Thread Jochem van Dieten

jonathan hamner wrote:

> Hi All.
> 
> Sorry that I have to ask this question in the cf-talk
> email list.
> 
> Is there a email list for VB similar to this one?


I guess none of the people with your email address use Outlook. It looks 
like I am subscribed automagically to a few lists if I judge by the 
amount of .vbs attachments I get ;)

Jochem
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Visual Basic?

2002-01-01 Thread Alex

did you look on google? 

On Tue, 1 Jan 2002, jonathan hamner wrote:

> Hi All.
> 
> Sorry that I have to ask this question in the cf-talk
> email list.
> 
> Is there a email list for VB similar to this one?
> 
> Once again, I apologize.
> 
> 
> 
> 
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Visual Basic?

2002-01-01 Thread Douglas Brown

P.S probably the best place for VB help is at
http://www.experts-exchange.com



There are two major products that come out of Berkeley: LSD and [Unix] BS
D.
We don't believe this to be a coincidence.



Doug Brown
- Original Message -
From: "jonathan hamner" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 01, 2002 12:03 PM
Subject: Visual Basic?


> Hi All.
>
> Sorry that I have to ask this question in the cf-talk
> email list.
>
> Is there a email list for VB similar to this one?
>
> Once again, I apologize.
>
>
>
>
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Visual Basic?

2002-01-01 Thread Douglas Brown

http://www.topica.com/dir/?cid=2633




There are two major products that come out of Berkeley: LSD and [Unix] BS
D.
We don't believe this to be a coincidence.



Doug Brown
- Original Message -
From: "jonathan hamner" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 01, 2002 12:03 PM
Subject: Visual Basic?


> Hi All.
>
> Sorry that I have to ask this question in the cf-talk
> email list.
>
> Is there a email list for VB similar to this one?
>
> Once again, I apologize.
>
>
>
>
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Visual Basic?

2002-01-01 Thread jonathan hamner

Hi All.

Sorry that I have to ask this question in the cf-talk
email list.

Is there a email list for VB similar to this one?

Once again, I apologize.




__
Do You Yahoo!?
Send your FREE holiday greetings online!
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: And the award goes to ....

2002-01-01 Thread Aaron Rouse

Just get a job like Dave, where you only have to do email all day long, t
hen
you can win!  ;)

Snipe - 

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 01, 2002 11:50 AM
Subject: RE: And the award goes to 


> > Dave Watts  [EMAIL PROTECTED] 1,101
> >
> > runners up include:
> > Philip Arnold - ASP [EMAIL PROTECTED]   757
>
> Wow, considering I was quiet for over half of the year (damn this work
> stuff), if I was able to post every week, I'd have probably stomped on
> Dave 
>
> Well, that's something to strive for in 2002...
>
> Philip Arnold
> Technical Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
> F: +44 (0)20 8686 7911
>
> An ISO9001 registered company.
>
> **
> 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. If you have received this email in error please notify
> the system manager.
> **
>
>
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: And the award goes to ....

2002-01-01 Thread Philip Arnold - ASP

> Dave Watts  [EMAIL PROTECTED] 1,101
>
> runners up include:
> Philip Arnold - ASP [EMAIL PROTECTED]   757

Wow, considering I was quiet for over half of the year (damn this work
stuff), if I was able to post every week, I'd have probably stomped on
Dave 

Well, that's something to strive for in 2002...

Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
F: +44 (0)20 8686 7911

An ISO9001 registered company.

**
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. If you have received this email in error please notify
the system manager.
**


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Visual Source Safe w/h CFServer 5

2002-01-01 Thread Duane Boudreau

Is there a way to integrate VSS with Server 5 if VSS was installed after
CFServer?

Thanks,
Duane
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



testing

2002-01-01 Thread Douglas Brown

testing




There are two major products that come out of Berkeley: LSD and [Unix] 
BSD. We don't believe this to be a coincidence.



Doug Brown

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Any ideas on how to do this please?

2002-01-01 Thread Douglas Brown

If I were doing this, I would allow them to choose the dates and not do t
he
first friday thing. This will save much aggrevation on your part as far a
s
date manipulation goes.
You could give them the option of start date and end date and maybe use a
 JS
calendar for them to choose dates from. There is several in allaires tag
gallery which have username/passowrd ability etc.


There are two major products that come out of Berkeley: LSD and [Unix] BS
D.
We don't believe this to be a coincidence.



Doug Brown
- Original Message -
From: "Mike Kear" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 01, 2002 6:22 AM
Subject: RE: Any ideas on how to do this please?


> Andrew, Kym, thanks for your interest in my problem.  Happy New Year to
 y
> ou.
> I'm not sure where in Oz you are Andrew, but I hope neither of you are 
be
> ing
> barbecued right now in Sydney.  It's a worry for me out here in Windsor
,
> but
> thankfully we haven't been directly threatened by the fire yet, althoug
h
> some of our friends have had to evacuate their homes up in Kurrajong.
>
>
> The site in question is www.bluegrass.org.au .. it's a directory of
> bluegrass music and events in Australia.  At the moment I'm keeping it 
up
>  to
> date by editing all the pages myself, using simple html for the most pa
rt.
> (there are some dynamic aspects to the site but the events listings are
 a
> ll
> manually created).
>
> Single events, like a concert, I have set up ok.  I enter the location 
an
> d
> other details and the date in my SQL database and the listing appears i
n
> the
> relevant state pages and disappears after the event is over.
>
> Now I want to do a similar thing with regular events, such as monthly
> association meetings, or regular jam sessions (which could be on the se
co
> nd
> Tuesday of the month say) and I want to allow people around the country
 t
> hat
> I authorise  to be able to update listings in their areas.   So this me
an
> s I
> cant have it with all these people (with greater or lesser understandin
gs
>  of
> html) tinkering with the pages directly.  I have to do it by giving the
m
> a
> form and the database to get the dynamic updates happening.
>
> So I'd like to give them a form where they can enter the location and t
im
> es
> and other details of the event, and for the date, let them choose eithe
r
> specific dates, or a pattern, such as "monthly on the first Friday" or
> "fortnightly on Saturday"   IT's this aspect I'm not sure how to do.
>
> In my processing of the form, should I insert these "monthly on the fir
st
> Friday" details into the database or convert them to specific dates at 
th
> at
> time.
>
> Or should I pull these events out every time the page is called, and wo
rk
> out what events are coming up in the next month, based on the specific 
da
> te
> listings, and the periodic listings?
>
> Does that make it clearer?
>
> Cheers,
> Mike Kear
> Windsor, NSW, Australia
> AFP WebWorks
>
>
> -Original Message-
> From: Kym Kovan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 31, 2001 1:04 PM
> To: CF-Talk
> Subject: Re: Any ideas on how to do this please?
>
> Hi Mike,
>
> >I am embarking on a sub-project to allow suitably authorised users to 
in
> put
> >events to my web site, to be displayed a month before the event happen
s,
> and
> >automatically deleted after the event is over.  I want the users to be
 a
> ble
> >to put in an event as being held on a specific date,  weekly, every tw
o
> >weeks, every month, on the third Friday of the month etc.
>
> I am a bit like Andrew, I would like to know more about the thing in te
rm
> s
> of size, business of the servers, etc. You can do more work in CF and p
ut
>  a
> set of events in the DB but it will be bigger as a result but the queri
es
>  a
> lot simpler compared with calculating it on the fly every time.
>
> BTW if you are showing the event for a month before, then clearing it, 
ho
> w
> are you going to handle a weekly event :^)
>
>
> --
>
> Yours,
>
> Kym
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Any ideas on how to do this please?

2002-01-01 Thread Mike Kear

Andrew, Kym, thanks for your interest in my problem.  Happy New Year to y
ou.
I'm not sure where in Oz you are Andrew, but I hope neither of you are be
ing
barbecued right now in Sydney.  It's a worry for me out here in Windsor, 
but
thankfully we haven't been directly threatened by the fire yet, although
some of our friends have had to evacuate their homes up in Kurrajong.


The site in question is www.bluegrass.org.au .. it's a directory of
bluegrass music and events in Australia.  At the moment I'm keeping it up
 to
date by editing all the pages myself, using simple html for the most part.
(there are some dynamic aspects to the site but the events listings are a
ll
manually created).

Single events, like a concert, I have set up ok.  I enter the location an
d
other details and the date in my SQL database and the listing appears in 
the
relevant state pages and disappears after the event is over.

Now I want to do a similar thing with regular events, such as monthly
association meetings, or regular jam sessions (which could be on the seco
nd
Tuesday of the month say) and I want to allow people around the country t
hat
I authorise  to be able to update listings in their areas.   So this mean
s I
cant have it with all these people (with greater or lesser understandings
 of
html) tinkering with the pages directly.  I have to do it by giving them 
a
form and the database to get the dynamic updates happening.

So I'd like to give them a form where they can enter the location and tim
es
and other details of the event, and for the date, let them choose either
specific dates, or a pattern, such as "monthly on the first Friday" or
"fortnightly on Saturday"   IT's this aspect I'm not sure how to do.

In my processing of the form, should I insert these "monthly on the first
Friday" details into the database or convert them to specific dates at th
at
time.

Or should I pull these events out every time the page is called, and work
out what events are coming up in the next month, based on the specific da
te
listings, and the periodic listings?

Does that make it clearer?

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks


-Original Message-
From: Kym Kovan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 1:04 PM
To: CF-Talk
Subject: Re: Any ideas on how to do this please?

Hi Mike,

>I am embarking on a sub-project to allow suitably authorised users to in
put
>events to my web site, to be displayed a month before the event happens,
and
>automatically deleted after the event is over.  I want the users to be a
ble
>to put in an event as being held on a specific date,  weekly, every two
>weeks, every month, on the third Friday of the month etc.

I am a bit like Andrew, I would like to know more about the thing in term
s
of size, business of the servers, etc. You can do more work in CF and put
 a
set of events in the DB but it will be bigger as a result but the queries
 a
lot simpler compared with calculating it on the fly every time.

BTW if you are showing the event for a month before, then clearing it, ho
w
are you going to handle a weekly event :^)


--

Yours,

Kym

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Studio 5

2002-01-01 Thread Larry Juncker

Just re-run the new install and it will import all of your setting for you.

-Original Message-
From: Anthony Abby [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 11:53 AM
To: CF-Talk
Subject: CF Studio 5


I loaded an evaluation version of Studio a month ago and now it's expired,
but I finally got my full version.  Is there a way to simply enter in the
serial to the evaluation so I don't have to uninstall it and lose all my
snippets and customizations?  I don't really feel like going through it all
over again to get Studio just how I like it anyone know?

Thanks
Anthony




_

Do You Yahoo!?

Get your free @yahoo.com address at http://mail.yahoo.com



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: null characters in a file

2002-01-01 Thread Sicular, Alexander

I heard of a similar problem. I met this guy at devcon who was using cf to
dynamicaly build images on the fly but when he got to a null on a string of
bits cf would balk. The solution escapes me atm. He was from the uk and if
he's reading this im sure he'll share his genius.

Good luck,

Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu


|-Original Message-
|From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
|Sent: Monday, December 31, 2001 11:28 PM
|To: CF-Talk
|Subject: null characters in a file
|
|
|Using CFFILE to read a file. The file has a couple of null 
|characters in the middle of the file. When it reaches the NULL 
|characters it assumes it has reached the end and stops. Is 
|there a way to read the file (I have to make some 
|modifications to it as well) and get around 
|or parse out the null characters? 
|
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: null characters in a file

2002-01-01 Thread Andrew Scott

Not 100% sure but in CF5 isn't there a binary read, which you could then
convert to a string or am I assuming binary64 on this, anyone?


-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, 1 January 2002 3:28 PM
To: CF-Talk
Subject: null characters in a file

Using CFFILE to read a file. The file has a couple of null characters in
the
middle of the file.
When it reaches the NULL characters it assumes it has reached the end
and
stops. Is there
a way to read the file (I have to make some modifications to it as well)
and
get around 
or parse out the null characters?

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists