Telect Confidential
>
> There's really very little written on this, although there are
> specifications on the fusebox.org site. The people that I know of who've
> adopted it have learned about it from friends and tried it out. There are
> rumors of a couple of books in the works, but it seems like a very small
> potential market for a publisher.
>
> We use Fusebox exclusively and are completely committed to it - even to
the
> extent of now trying to implement it on a new C++-based Palm venture.
>
> Hope that helps.
>
> Phil Helms
>
> J. Philip Helms
> President/CEO
> Pacific Internet Development Group
>
> ----- Original Message -----
> From: "Eben Hewitt" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 11, 2000 10:28 PM
> Subject: RE: Best Practices
>
>
> > www.fusebox.org
> >
> > -----Original Message-----
> > From: David Mineer Jr [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 11, 2000 8:22 AM
> > To: CF-Server
> > Subject: RE: Best Practices
> >
> >
> > What is the address of this fusebox. I hear a lot about it but have
been
> > unable to pin point a good tutorial or other information.
www.fusebox.com
> > doesn't seem to have anything, or at least I don't know where to look,
> >
> > TIA,
> >
> > -------------------------------
> > Construction Monitor Tel: 435-586-1205
> > David Mineer Jr Fax:435-586-7414
> > Systems Administrator
> > [EMAIL PROTECTED]
> >
> >
> > -----Original Message-----
I don't know if this can be done, but I thought maybe someone may know how
to do this:
I have a simple form with multiple checkboxes on it. The checkboxes are
dynamically produced, so there could be anywhere from zero to a whole bunch
of them. There is one for each phone number in an employee description list.
I wanted the admin people to be able to check more than one box to delete
more than phone number at a time if needed. So, I have all the checkboxes
named the same so it returns a list like this:
5551212,18007652345,5551098
So, I was going to do a delete statement like:
delete phone_detail where phone in (#form.phone_number#)
Well, that would work great if the field was a Number field, but it is a
character field. So I tried doing a replace command to replace all the
commas with singlequote-comma-singlequote but that is trickier than it
sounds because the syntax is like this:
<cfset form.phone_number = replace(form.phone_number,",","','","ALL")>
All those quotes and commas mess up the function. If I do it like this:
<cfset form.phone_number = replace(form.phone_number,(,),(','),"ALL")>
it gives me a list like this: '5551212","18007652345","5551098'
But double quotes don't work in Oracle. If all else fails I will change the
table so that the phone number field is a number rather than a varchar2.
But, this table is used by many other applications which would then have to
be modified to reflect that change. And that is more hassle than it is
worth!
Any suggestions?
Thanks ...
Anthony DeStefano
[EMAIL PROTECTED]
The information contained in this message is privileged and confidential. It is
intended solely for the use of the named recipient. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution, or use
of the contents of this transmission is strictly prohibited. If you receive this
message in error, please notify the sender immediately. Thank you.
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
