of course you have to remember to use:
WHERE phone_detail in (#PreserveSingleQuotes(event_list)#)
Allan Pichler
Chief Technical Officer
Machine Dreams Inc.
-----Original Message-----
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 9:46 AM
To: CF-Server
Subject: RE: question about quotations
You could do something like this ...
<cfset form.phone_number = #listqualify(form.phone_number, "'", ",", "ALL")#
Allan Pichler
Chief Technical Officer
Machine Dreams Inc.
-----Original Message-----
From: Anthony DeStefano [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 9:28 AM
To: CF-Server
Subject: question about quotations
Telect Confidential
Sorry about the previous message. I forgot to cut out the top part before
replying to the list-server. Here is a more legible version:
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
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
