Take that proactive approach a step further and grab a known good image URL,
and a known bad image URL. Dump the headers and compare.
Worst case scenario, nothing seems out of the ordinary. Then you could do
something else like build a valid list of mime types (valid to you and your
app) and at
With such a small percentage of images with issues. Could there be issues of
the upload itself? I remember in the past alot of the issues I use to run into
with images not rendering via the upload usually came back to a bad connection.
Tested it with the clients help to verify. Its
5:33 PM
To: cf-talk
Subject: Re: Can this be done?
With such a small percentage of images with issues. Could there be issues
of the upload itself? I remember in the past alot of the issues I use to
run into with images not rendering via the upload usually came back to a bad
connection. Tested
You actually have two problems here.
Let's talk about the first problem, as it sounds like you are uploading the
file directly to the images directory. This is a major security risk and you
should avoid this.
Second this gives you the opportunity to store the files into a temp
directory that is
are there that can be run
to
verify images?
Thanks,
Rick
-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au]
Sent: Sunday, April 18, 2010 6:00 PM
To: cf-talk
Subject: RE: Can this be done?
You actually have two problems here.
Let's talk about the first problem, as it sounds
-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au]
Sent: Sunday, April 18, 2010 6:00 PM
To: cf-talk
Subject: RE: Can this be done?
You actually have two problems here.
Let's talk about the first problem, as it sounds like you are uploading the
file directly to the images
On 4/19/2010 10:33 AM, Rick Faircloth wrote:
If appropriate formats are specified in the cffile accept parameter, what
risk is there? Some kind of file that fakes its format or has malicious
code embedded in it?
Yes, that can happen.
And concerning your second concern below, I've
We were aware of the security issues so we do upload to a temporary location,
we then check the sizing of the images and create thumbnails and reduce the
size to the correct size.
The weird thing is the images that do not work - are images. If we pull the
file down, open it in PhotoShop and
Thanks for the feedback, Ian.
I'll at least start making use of the isImage() function.
Rick
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Monday, April 19, 2010 1:57 PM
To: cf-talk
Subject: Re: Can this be done?
On 4/19/2010 10:33 AM, Rick Faircloth wrote
Matt -
I have the same problem with a client - they receive images from a 3rd party
- and when they upload them they don't show up in IE. (They do in FF
though...) Resaving in photoshop doesn't always fix the issue either...
Sometimes we have to make a NEW image - then cut and paste the pic
: Monday, April 19, 2010 1:43 PM
To: cf-talk
Subject: RE: Can this be done?
Matt -
I have the same problem with a client - they receive images from a 3rd party
- and when they upload them they don't show up in IE. (They do in FF
though...) Resaving in photoshop doesn't always fix the issue either
I don't see where you mention what version of ColdFusion you are using, but if
you are using CF8+ then here is what I do. I also have a site that uploads
images.
cfimage action=read source=C:\ImgStore\TheUploadedImage.jpg name=myImage
cfset Info = ImageInfo(myImage)
!--- LOOK AT THE
:08 PM
To: cf-talk
Subject: Re: Can this be done?
I don't see where you mention what version of ColdFusion you are using, but
if you are using CF8+ then here is what I do. I also have a site that
uploads images.
cfimage action=read source=C:\ImgStore\TheUploadedImage.jpg
name=myImage
cfset Info
2 types of JPG that can cause problems: CMYK and progressive JPEG. As
others have noted on this thread, this is not just a problem with the
image engine used by CF, but is a problem with any browser as well.
CMYK images will *not* (in my experience) convert properly within CF
image
does isImageFile() do this?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Hi there
Is there anything simpler than that.
Hi there
Iâm in the process of finalising the developing an application to handle
personal training sessions at a gym â basically there are 6 or more personal
trainers who each have more than 60 clients that they work with for ½ hour up
to 2
Does a user have to have interaction on the homepage? If the classes are
defined by time, you could do something simple like have the homepage check
the date and time and show the classes that fall within the current date and
time range. That would be simple.
I am developing an application for
Sounds like a good place for a little ajax magic. When you check a box, it'd
be cool to update the status without leaving or refreshing the page.
You could also use some ajax to have the remaining time update in real time
as well.
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Peter Tanswell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 9:07 AM
To: CF-Talk
Subject: Re: Can this be done
Yeah
I had just been browsing a book on AJAX, but havent used
Yeah
I had just been browsing a book on AJAX, but havent used it before so a
liitle bit lost.
Any suggestions or anywhere where I can get enough info to let me do this?
Thanks in advance.
On 10/30/07, Bobby Hartsfield [EMAIL PROTECTED] wrote:
Sounds like a good place for a little ajax
JQuery is your friend:) Something like this should work:
script
$(document).ready(function(){
// Here's a reference to our form
var frm = $('form##testForm');
// Assign an onChange event handler
Is a live chat app out of the question?
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
The client want to use MSN as the client, so yes, for this solution it is...
2007/5/18, Will Tomlinson [EMAIL PROTECTED]:
Is a live chat app out of the question?
~|
Create Web Applications With ColdFusion MX7 Flex 2.
What about using the same application name for the whole app so when you
receive the message back save it to the application scope and the users
response page can check the application scope for the response. maybe
an array treated as a queue or something
-Randy
Erik-Jan Jaquet wrote:
A database solution would not be bad either because you could delete
conversations that have not had any messages added within a certain time
frame
-Randy
Erik-Jan Jaquet wrote:
Hi all,
I am breaking my head over something, and I hope someone can tell me if, and
how, this van be done.
I have set up an MSN Gateway, I can send messages to the MSN account
and receive messages from that MSN account. But I am not able to
figure out how to show the user the response, other then letting the
gateway add it to the DB, and let the app pull it from the DB. But I
don't want to do
More specifically, look at the meebo me embeddable widget:
http://www.meebome.com/
On 5/18/07, chopper [EMAIL PROTECTED] wrote:
Have you looked at meebo.com
It allows you to embed a chat client in your webpage that connects to
an MSN account.
Have you looked at meebo.com
It allows you to embed a chat client in your webpage that connects to
an MSN account.
On 5/18/07, James Wolfe [EMAIL PROTECTED] wrote:
I have set up an MSN Gateway, I can send messages to the MSN account
and receive messages from that MSN account. But I am not
Hi,
I have a frame split in half (topframe bottomframe).
I the top frame I'm listing directories/files which have links to them. Beside each directory/file is an image that when clicked I want to send the link information to the bottom frame asthe path.
Each time a link is clicked the bottom
or sanctioned by these organizations. This e-mail is
unclassified based on the definitions in E.O. 12958.
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 8:56 AM
To: CF-Talk
Subject: re: Can this be done??
Hi,
I have a frame split in half (topframe
]
Sent: Wednesday, November 26, 2003 8:56 AM
To: CF-Talk
Subject: re: Can this be done??
Hi,
I have a frame split in half (topframe bottomframe).
I the top frame I'm listing directories/files which have links to them.
Beside each directory/file is an image that when clicked I want to send the
link
Subject: RE: Can this be done??
Do you know where I could find some examples?
--Original Message Text---
From: Heald, Tim
Date: Wed, 26 Nov 2003 08:56:10 -0500
_javascript_.
Timothy Heald
Web Portfolio Manager
Overseas Security Advisory Council
U.S. Department of State
571.345.2319
The opinions
PROTECTED]
Sent: 26 November 2003 14:02
To: CF-Talk
Subject: RE: Can this be done??
Do you know where I could find some examples?
--Original Message Text---
From: Heald, Tim
Date: Wed, 26 Nov 2003 08:56:10 -0500
_javascript_.
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent
the target attribute in the a href for each link
and point it to the other frame.
-Kevin
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 8:13 AM
Subject: RE: Can this be done??
http://developer.irt.org/script/script.htm
-
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 8:13 AM
Subject: RE: Can this be done??
http://developer.irt.org/script/script.htm... the _javascript_
FAQ's learned most of my js there many moons ago...don't know how
up to date
it is but certainly give you examples of things that you
could use to achieve what you want
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 26 November 2003 14:02
To: CF-Talk
Subject: RE: Can this be done??
Do you know where I could find some examples?
--Original Message Text
t whatever is
in that list.
-Kevin
- Original Message -
From: Bushy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 8:25 AM
Subject: Re: Can this be done??
--Original Message Text---
From: Kevin Graeme
Date: Wed, 26 Nov 2003 08:20:45 -0600
Actually, depending o
- Original Message -
From: Bushy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 8:25 AM
Subject: Re: Can this be done??
--Original Message Text---
From: Kevin Graeme
Date: Wed, 26 Nov 2003 08:20:45 -0600
Actually, depending on how he's doing things _javascr
, November 26, 2003 9:12 AM
Subject: Re: Can this be done??
Cool.
I got it to work using the URL variable.
How can I keep adding or concatenate each selection to the URL.item
variable I'm displaying in the bottomframe to a list or array?
--Original Message Text---
From: Kevin Graeme
Date: Wed
Subject: Re: Can this be done??
Cool.
I got it to work using the URL variable.
How can I keep adding or concatenate each selection to the URL.item variable
I'm displaying in the bottomframe to a list or array?
--Original Message Text---
From: Kevin Graeme
Date: Wed, 26 Nov 2003 08:56:40 -0600
Ah
these
opinions been approved or sanctioned by these organizations. This e-mail is
unclassified based on the definitions in E.O. 12958.
-Original Message-
From: Kevin Graeme [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 10:36 AM
To: CF-Talk
Subject: Re: Can this be done??
Did you
Message -
From: Bushy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 9:12 AM
Subject: Re: Can this be done??
Cool.
I got it to work using the URL variable.
How can I keep adding or concatenate each selection to the URL.item
variable I'm displaying
nice.
- Original Message -
From: Bushy
To: CF-Talk
Sent: Wednesday, November 26, 2003 8:40 AM
Subject: Re: Can this be done??
Nope.
--Original Message Text---
From: Kevin Graeme
Date: Wed, 26 Nov 2003 09:24:36 -0600
Did you even try looking up how to use a list or array and figure
shy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 9:12 AM
Subject: Re: Can this be done??
Cool.
I got it to work using the URL variable.
How can I keep adding or concatenate each selection to the URL.item
variable I'm displaying in the bottomframe to a lis
Here's a lead:
_ColdFusion MX Web Application Construction Kit_ by Ben Forta, page 170.
-Kevin
- Original Message -
From: Bushy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 9:12 AM
Subject: Re: Can this be done??
Cool.
I got it to work using the URL va
CTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 9:12 AM
Subject: Re: Can this be done??
Cool.
I got it to work using the URL variable.
How can I keep adding or concatenate each selection to the URL.item
variable I'm displaying in the bottomframe to a list or array?
u're after?
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 1:24 PM
To: CF-Talk
Subject: Re: Can this be done??
That typo is OK in my code. I'm doing something else wrong.
--Original Message Text---
From: [EMAIL PROTECTED]
Date: Wed, 26 Nov 2003 13:07:46
if listlen(client.big_list) GT 0
cfloop index=i list=#client.big_list#
#i#br
/cfloop
/cfif
Is that what you're after?
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 1:24 PM
To: CF-Talk
Subject: Re: Can this be done??
That typo is OK in my code.
I presume you don't have a URL to a working example so we can see it in
action?
-Gel
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Hello all..
I'm bidding on a job and the client told me something that a competitor
does that seems pretty amazing.
He said that this
Hthat would seem to imply that this competitor can read the browser
history (and even what was typed)and that's not possible AFAIK because
it would be a HUGE security/privacy hole.
my 2 cents on a Monday morning ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
: Monday, September 08, 2003 10:16 AM
To: CF-Talk
Subject: Re: Can this be done?
Hthat would seem to imply that this competitor can
read the browser history (and even what was typed)and
that's not possible AFAIK because it would be a HUGE
security/privacy hole.
my 2 cents
Che,
I'm guessing that the competitor did a poor job (or a very good job - ha) of
explaining how he could use the HTTP_Referer variable to figure out how a
user is searching and finding the site. If not, then I'd say he's violating
security on the client side somehow. I would also note to your
I know you can look at the CGI.HTTP_REFERER value for some search
engines,
but does anyone know how to do this for all sites. Is there a tool,
CFC or
UDF that could do this for me? Is there an easy way to parse the info
out?
You are correct that HTTP_REFERER will have the information you
CGI.HTTP_REFERER is the only option I know of.
If someone has come form a search engine, it 'should' contain their
search terms in the url query string.
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: 08 September 2003 17:08
To: CF-Talk
Subject: Can this be done?
]
Sent: Monday, September 08, 2003 12:16 PM
To: CF-Talk
Subject: Re: Can this be done?
Hthat would seem to imply that this competitor can read the browser
history (and even what was typed)and that's not possible AFAIK because
it would be a HUGE security/privacy hole.
my 2 cents
This would be a bad idea for a community implemented UDF. *hint* *hint*
Here is the idea...
Someone writes up a quick UDF shell something like the following.
cffunction name=getSearchQuery returntype=string
cfargument name=referer type=string required=true
!--- pick out the
, September 08, 2003 12:16 PM
To: CF-Talk
Subject: Re: Can this be done?
Hthat would seem to imply that this competitor can read the browser
history (and even what was typed)and that's not possible AFAIK because
it would be a HUGE security/privacy hole.
my 2 cents on a Monday morning
://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 12:20 PM
To: CF-Talk
Subject: Re: Can this be done?
You are correct
: http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 12:38 PM
To: CF-Talk
Subject: Re: Can this be done?
This would
12:16 PM
To: CF-Talk
Subject: Re: Can this be done?
Hthat would seem to imply that this competitor can read the
browser
history (and even what was typed)and that's not possible AFAIK because
it would be a HUGE security/privacy hole.
my 2 cents on a Monday morning ;-)
Bryan
) in there. Have
fun!
http://www.firesideloghomes.com/ryandotnet/searchEngines.html
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 12:38 PM
To: CF-Talk
Subject: Re: Can this be done?
This would be a bad idea for a community implemented UDF. *hint
I would hate to hard code all that data inside the UDF. I'd much
rather see
a cached XML file with the information and a community site where
people can
put in new information and the UDF can grab it as needed (referesh
every day
or so).
I would hate it also, but for purposes of an
://www.firesideloghomes.com/ryandotnet/searchEngines.html
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 12:38 PM
To: CF-Talk
Subject: Re: Can this be done?
This would be a bad idea for a community implemented UDF. *hint* *hint*
Here is the idea
speculating:
cffile the apache/iis logs... parse the last couple of lines...
output...
dont wanna think what will happen if the logs are a few megabytes
big...
The logs just contain the same data that would be in CGI.HTTP_REFERER
anyway, so it would be better to just get it from the CGI
Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 08, 2003 9:38 AM
Subject: RE: Can this be done?
Well how do the stats packages come up with the 10 most
OK, here's a small UDF that includes Ryan's list of search URL's. The list
is embedded in CFScript per Ray Camden's request so the UDF is not dependent
on an outside file. The format for the data is pretty straightforward, url
and possible search criteria keys.
As of right not it creates the
After talking with Ray some more I re-wrote the UDF to use an XML file as
it's source. Includes options for the XML file URL (remote), and alternate
URL (local in case of connection error), and refresh rate.
Comments welcome.
Thanks,
Sam
--
Blog:
Haven't tried this, but I think you can go into the Internet Services
Manager under Admin Tools, go the Properties for the Default Web Site
(or sub directory), choose the Home Directory tab and click on the
Configuration button. Under Application Mappings, add .htm and point it
to the same .dll
I don't know if this will work on MX
Go into IIS go to the webs properties click on the Home Directory tab and
then click Configuration Double click .cfm and copy the Executable path
Close it and click add Paste the path and in the executable and make the
extension .htm do the same for .html.
Just go into the IIS config... website properties... Home Directory tab...
and click CONFIGURATION.
Look at the .cfm entry and how it's set up... then set up another entry for
htm or .html (whichever you like) that looks identical.
All .htm (or .html) will then be parsed through the CF engine
Open up IIS, and click on the properties of the website in question. Click
on the home directory tab. Then click Configuration. Copy the path used in
the *.cfm mapping and create a new mapping for *.html that points to the
same executable as the *cfm path. That should do it
At 03:24 PM
What version of CF?
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Joel Blanchette [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 1:24 PM
Subject: Can this be done?
Hello All,
Wondering if there is a way to make the html files to
cf 5 yeah.from the iis manager,
add an extension, called .html
that is mapped to use the iscf.dll
(basically mirror the settings that
the .cfm file have, just change the .cfm
to .html, or whatever .tony if you want)
cfmx is a bit harder
tw
-Original Message-
From: Joel
Is there a reason why you need to change the file extensions?
Are you using Dreamweaver at all?
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Hi,
This might be a crazy question but here it goes.
I'm using cfdirectory to list files on our server. Some directories can
have a 100+ files in them. Presently I'm displaying the list down the left
side of my webpage under each other.
file1.txt
file2.txt
file3.txt
file4.txt
file5.txt
.
Margaret
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 9:57 AM
To: CF-Talk
Subject: Re: Can this be done?
Hi,
This might be a crazy question but here it goes.
I'm using cfdirectory to list files on our server. Some directories can
have a 100+ files
with
four tr's.
If that helps I'm not sure :OP
Ade
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2002 17:57
To: CF-Talk
Subject: Re: Can this be done?
Hi,
This might be a crazy question but here it goes.
I'm using cfdirectory to list files on our server. Some
You can reference the query by bracket syntax and do a nested loop as such:
!--- Query name = qResults ---
cfset cols = 4
cfset rows = Int(qResults.Recordcount/4)+1
cfloop from=1 to=#rows# index=i
tr
cfloop from=1 to=#cols# index=j
cfset currentIndex = i +
use MOD. something like ...
!--- quad column checkboxes ---
cfif getSubCats.CurrentRow MOD 4 IS 0
/tr
tr
/cfif
On Wed, 15 May 2002, phumes1 wrote:
Hi,
This might be a crazy question but here it goes.
I'm using cfdirectory to list files on our server. Some
Yes
cfset itemcount = 0
cfset columncounter = 0
table
cfoutput query=myquery
cfset itemcount = itemcount + 1
cfif itemcount EQ 1
cfif coulmncount EQ 1
tr
/cfif
td#NAMEbr
/cfif
cfif itemcount GTE 2 and LTE 3
#name#br
the
new one within that if. It is a lot easier to do it horizontally though.
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 12:57 PM
To: CF-Talk
Subject: Re: Can this be done?
Hi
Would x be the line number?
At 11:12 AM 5/15/2002 -0600, you wrote:
You can reference the query by bracket syntax and do a nested loop as such:
!--- Query name = qResults ---
cfset cols = 4
cfset rows = Int(qResults.Recordcount/4)+1
cfloop from=1 to=#rows# index=i
tr
cfloop
I was wondering if there is a way automatically using a table to do the
following and if so, how?
I have used (something like) the following to get how ever many columns I
want columns.
x = number of columns desired;
table cellpadding=2 cellspacing=2 border=1 width=100%
tr
Where's the x?
-Ben
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 11:35 AM
To: CF-Talk
Subject: RE: Can this be done?
Would x be the line number?
At 11:12 AM 5/15/2002 -0600, you wrote:
You can reference the query by bracket syntax and do
-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Can this be done?
Date: Wed, 15 May 2002 12:58:00 -0400 (EDT)
use MOD. something like ...
!--- quad column checkboxes ---
cfif getSubCats.CurrentRow MOD 4 IS 0
/tr
tr
/cfif
On Wed, 15 May 2002, phumes1
Of course it is, the replies will come flooding in just you
wait...
;O)
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: 13 May 2002 17:05
To: CF-Talk
Subject: can this be done?
Hello cf-talk,
I have an existing project where a form takes a
I am not sure about in Access. In T-SQL you have functions like charindex,
and subsrtring and right, and left that would make it easy to do this all in
SQL. Using access I don't think you have those functions, however you can
use CF to do it, and use the space as a list delimiter. It would be
Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 13 May 2002 17:07
To: CF-Talk
Subject: RE: can this be done?
Of course it is, the replies will come flooding in just you
wait...
;O)
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: 13 May
I have an existing project where a form takes a field name
and inserts in in a row name in an Access database.
So, we have about 1000 names in the database as one name
(firstname lastname). Now, the client changes his mind, and
wants to be able to sort by last name, firstname.
Yes,
]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 9:10 AM
To: CF-Talk
Subject: RE: can this be done?
I am not sure about
At 12:04 PM 5/13/02 -0400, Jeff Fongemie wrote:
So, we have about 1000 names in the database as one name (firstname
lastname). Now, the client changes
his mind, and wants to be able to sort by last name, firstname.
I'd run a query through the table, picking up the names, breaking them
12:10 PM
To: CF-Talk
Subject: RE: can this be done?
I am not sure about in Access. In T-SQL you have functions like
charindex,
and subsrtring and right, and left that would make it easy to do this
all in
SQL. Using access I don't think you have those functions, however you
can
use CF to do
You ought show them a comparison (cost) of how much time (therefore money)
you are putting into the fix and how much it would have cost had they
listened to you in the first place ($0.00)
Let the figures speak for you
again, proof the client really has no idea what they really wantsigh.
At 12:04 PM 5/13/02 -0400, you wrote:
Is there a way, to somehow break up the full name into 2 fields, say
by using the space as a separator? I would only need to do this
once as it is an event. Could I make two new fields, last_name and
first_name, then get the fullname, break it up
I second this - even though I posted a selotape solution, to break down the
info into 2 separate entities is the better option
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 13 May 2002 17:24
To: CF-Talk
Subject: RE: can this be done?
I have an existing project
Yes, it can be done. But it will require manual review afterwards.
I'd probably just right a quick and dirty CF page to do this work for you (a
bit easier to understand/code than T-SQL), or if you have the skills, use
SQL directly.
However, what about cases where the name is something like
It can also be done by creating a query using SQL in access. ColdFusion
is not necessary.
- Matt Small
-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 12:29 PM
To: CF-Talk
Subject: RE: can this be done?
It can be done in access
Give this a shot - should get you on the right track.
==
cfscript
i=1;
fname=ArrayNew(1);
lname=ArrayNew(1);
if(not isdefined(url.orderby)){
url.orderby=fname;
}
if(not isdefined(url.updn)){
updn=ASC;
}
/cfscript
(Home Office)
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 12:32 PM
To: CF-Talk
Subject: RE: can this be done?
Give this a shot - should get you on the right track.
==
cfscript
i
13, 2002 12:32 PM
To: CF-Talk
Subject: RE: can this be done?
Give this a shot - should get you on the right track.
==
cfscript
i=1;
fname=ArrayNew(1);
lname=ArrayNew(1);
if(not isdefined(url.orderby)){
url.orderby=fname
1 - 100 of 117 matches
Mail list logo