RE: Can this be done?
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 least compare the results to that list. -Original Message- From: Matthew Friedman [mailto:m...@hozgroup.com] Sent: Sunday, April 18, 2010 4:43 PM To: cf-talk Subject: Can this be done? We have a site where people are uploading images to our site. We are using cffile upload, checking the sizing resizing them - all is working great but about 2% of the images will sometimes be upload but not able to be displayed on the site - they might be set as CMYK or some other reason and there is the red x being displayed. Here is my question - since I have the full url to the image saved in the database is there any way that I can check the images that have been uploaded in the past hour and see if they are working in an automated format. My thoughts would be to just loop through the list by hour and using an http get to see the image - the question is there a host header error or notice that will indicate that the image is bad and we need to fix the image. We are trying to be proactive instead of reactive to clients telling us that there is a bad image on the list. Thanks for any incite. Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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 it with the clients help to verify. Its different in every case I know but just an idea. From: Matthew Friedman m...@hozgroup.com To: cf-talk cf-talk@houseoffusion.com Sent: Sun, April 18, 2010 2:42:42 PM Subject: Can this be done? We have a site where people are uploading images to our site. We are using cffile upload, checking the sizing resizing them - all is working great but about 2% of the images will sometimes be upload but not able to be displayed on the site - they might be set as CMYK or some other reason and there is the red x being displayed. Here is my question - since I have the full url to the image saved in the database is there any way that I can check the images that have been uploaded in the past hour and see if they are working in an automated format. My thoughts would be to just loop through the list by hour and using an http get to see the image - the question is there a host header error or notice that will indicate that the image is bad and we need to fix the image. We are trying to be proactive instead of reactive to clients telling us that there is a bad image on the list. Thanks for any incite. Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332984 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can this be done?
When I clients having problems uploading images, I will usually ask for one or more of the problem images to be sent to me so I can verify their format or other issues. Rick -Original Message- From: Christopher Stowell [mailto:christopher.stow...@yahoo.com] Sent: Sunday, April 18, 2010 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 it with the clients help to verify. Its different in every case I know but just an idea. From: Matthew Friedman m...@hozgroup.com To: cf-talk cf-talk@houseoffusion.com Sent: Sun, April 18, 2010 2:42:42 PM Subject: Can this be done? We have a site where people are uploading images to our site. We are using cffile upload, checking the sizing resizing them - all is working great but about 2% of the images will sometimes be upload but not able to be displayed on the site - they might be set as CMYK or some other reason and there is the red x being displayed. Here is my question - since I have the full url to the image saved in the database is there any way that I can check the images that have been uploaded in the past hour and see if they are working in an automated format. My thoughts would be to just loop through the list by hour and using an http get to see the image - the question is there a host header error or notice that will indicate that the image is bad and we need to fix the image. We are trying to be proactive instead of reactive to clients telling us that there is a bad image on the list. Thanks for any incite. Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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 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 not accessible by the web, in which you can the run what you need to make sure that they are indeed images and are of the required types before deleting them. Hope that helps. -Original Message- From: Matthew Friedman [mailto:m...@hozgroup.com] Sent: Monday, 19 April 2010 6:43 AM To: cf-talk Subject: Can this be done? We have a site where people are uploading images to our site. We are using cffile upload, checking the sizing resizing them - all is working great but about 2% of the images will sometimes be upload but not able to be displayed on the site - they might be set as CMYK or some other reason and there is the red x being displayed. Here is my question - since I have the full url to the image saved in the database is there any way that I can check the images that have been uploaded in the past hour and see if they are working in an automated format. My thoughts would be to just loop through the list by hour and using an http get to see the image - the question is there a host header error or notice that will indicate that the image is bad and we need to fix the image. We are trying to be proactive instead of reactive to clients telling us that there is a bad image on the list. Thanks for any incite. Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332986 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can this be done?
Can you clarify this some, Andrew? 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. 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? And concerning your second concern below, I've always assumed that using the accept parameter was enough to verify file format and prevent malicious code from being uploaded in a file. What other tests 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 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 not accessible by the web, in which you can the run what you need to make sure that they are indeed images and are of the required types before deleting them. Hope that helps. -Original Message- From: Matthew Friedman [mailto:m...@hozgroup.com] Sent: Monday, 19 April 2010 6:43 AM To: cf-talk Subject: Can this be done? We have a site where people are uploading images to our site. We are using cffile upload, checking the sizing resizing them - all is working great but about 2% of the images will sometimes be upload but not able to be displayed on the site - they might be set as CMYK or some other reason and there is the red x being displayed. Here is my question - since I have the full url to the image saved in the database is there any way that I can check the images that have been uploaded in the past hour and see if they are working in an automated format. My thoughts would be to just loop through the list by hour and using an http get to see the image - the question is there a host header error or notice that will indicate that the image is bad and we need to fix the image. We are trying to be proactive instead of reactive to clients telling us that there is a bad image on the list. Thanks for any incite. Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332987 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be done?
RE: First problem. Something like this is the problem: http://www.coldfusionjedi.com/index.cfm/2009/9/21/How-Galleon-was-Hacked - Gabriel On Mon, Apr 19, 2010 at 1:33 PM, Rick Faircloth r...@whitestonemedia.comwrote: Can you clarify this some, Andrew? 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. 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? And concerning your second concern below, I've always assumed that using the accept parameter was enough to verify file format and prevent malicious code from being uploaded in a file. What other tests 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 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 not accessible by the web, in which you can the run what you need to make sure that they are indeed images and are of the required types before deleting them. Hope that helps. -Original Message- From: Matthew Friedman [mailto:m...@hozgroup.com] Sent: Monday, 19 April 2010 6:43 AM To: cf-talk Subject: Can this be done? We have a site where people are uploading images to our site. We are using cffile upload, checking the sizing resizing them - all is working great but about 2% of the images will sometimes be upload but not able to be displayed on the site - they might be set as CMYK or some other reason and there is the red x being displayed. Here is my question - since I have the full url to the image saved in the database is there any way that I can check the images that have been uploaded in the past hour and see if they are working in an automated format. My thoughts would be to just loop through the list by hour and using an http get to see the image - the question is there a host header error or notice that will indicate that the image is bad and we need to fix the image. We are trying to be proactive instead of reactive to clients telling us that there is a bad image on the list. Thanks for any incite. Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be done?
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 always assumed that using the accept parameter was enough to verify file format and prevent malicious code from being uploaded in a file. What other tests are there that can be run to verify images? No, accept simple looks at the file name. I can name my CFML hacking file myImage.jpg and it will pass an accept test just fine. It is not quite as simple as that to get an code file to fake being an image file. But if find that I sleep much easier, if I do *not* underestimate the resourcefulness of hackers. The isImage() function should help, since it actually looks at the file binary data not just the file name. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be done?
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 re save the image and upload it back to the correct folder all works fine. So using the isImage() function I am not sure if that will solve this. Question I have is if you save an image as a CMYK format and then use CF to manipulate that image, will it create an issue where the browser can not render it correctly and place a missing image. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can this be done?
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: 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 always assumed that using the accept parameter was enough to verify file format and prevent malicious code from being uploaded in a file. What other tests are there that can be run to verify images? No, accept simple looks at the file name. I can name my CFML hacking file myImage.jpg and it will pass an accept test just fine. It is not quite as simple as that to get an code file to fake being an image file. But if find that I sleep much easier, if I do *not* underestimate the resourcefulness of hackers. The isImage() function should help, since it actually looks at the file binary data not just the file name. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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... Sometimes we have to make a NEW image - then cut and paste the pic into it to save to the correct format... However - I am not aware of any method for testing the JPGs formats through CF... (Or even what is really wrong with these JPGS - I just assume something is wrong with the way they were originally created - perhaps using RAW?) RGB vs CMYK isn't necessarily the problem... At least for me. (Some of the JPGS in CMYK actually show up... Others in GRB don't...?! ) Only thing I can say - is try that conversion stuff and see what happens. And please post the answer - would LOVE to know the answer. - Nick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can this be done?
There are several things which could be wrong. - Unidentified, or incorrect, color profile - Image is in CMYK. ColdFusion might not mind this, but many browsers won't display these images. andy -Original Message- From: Eric Nicholas Sweeney [mailto:n...@bigfatdesigns.com] Sent: 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... Sometimes we have to make a NEW image - then cut and paste the pic into it to save to the correct format... However - I am not aware of any method for testing the JPGs formats through CF... (Or even what is really wrong with these JPGS - I just assume something is wrong with the way they were originally created - perhaps using RAW?) RGB vs CMYK isn't necessarily the problem... At least for me. (Some of the JPGS in CMYK actually show up... Others in GRB don't...?! ) Only thing I can say - is try that conversion stuff and see what happens. And please post the answer - would LOVE to know the answer. - Nick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332996 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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 = ImageInfo(myImage) !--- LOOK AT THE COLORSPACE TO SEE IF IT IS AN IMAGE THAT A BROWSER CAN USE --- cfif NOT FindNoCase(CMYK, Info.colormodel.colorspace) !--- DO SOMETHING WITH THE IMAGE --- cfelse !--- DELETE THE IMAGE OR DO SOMETHING ELSE WITH THE IMAGE --- /cfif HTH Chuck ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can this be done?
Good stuff, Chuck! I've been using cfimage like crazy since CF8, but there are so many other image functions I haven't used or am not even aware of! Time to have a look at them! Rick -Original Message- From: Chuck Weidler [mailto:h...@coldfusionguru.com] Sent: Monday, April 19, 2010 4: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 = ImageInfo(myImage) !--- LOOK AT THE COLORSPACE TO SEE IF IT IS AN IMAGE THAT A BROWSER CAN USE --- cfif NOT FindNoCase(CMYK, Info.colormodel.colorspace) !--- DO SOMETHING WITH THE IMAGE --- cfelse !--- DELETE THE IMAGE OR DO SOMETHING ELSE WITH THE IMAGE --- /cfif HTH Chuck ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332998 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be done?
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 functions. As Chuck noted, you can look into the colorspace to determine some of these potential pitfalls, but I find that isImage() is my single greatest friend when it comes to these JPG issues. MIMETypes are no help, of course, since these are really binaries within the correct MIME space ... there just happens to be some critical variation within that space. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332999 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be done?
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: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be done
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 hour sessions. A person at the front desk manages their bookings.
Basically Iâm developing a system for the gym to enable the person at the
front desk to enter details of bookings etc. These details will once entered
into the system will be in one of 3 states.
1. Waiting bookings
2. Bookings in process
3. Completed bookings
On the front screen of the application Iâm planning on displaying â current
bookings in process and underneath that waiting bookings.
E.G.
Sessions in Progress
Trainer RoomStart FinishRemaining TimeOverTime Manage
Sandra1 05:09 PM 06:09 PM Time has Passed 5 Minutes(s) Edit
E.G.
Waiting Bookings
Trainer RoomStart FinishRemaining TimeOverTime Manage
Rob1 06:00 PM 07:00 PM Waiting N/A Edit
I was initially thinking once the Edit link was clicked open up a pop-up window
to let the user edit the record. Is there a better way so basically the user
can just click a button and then by clicking on that button the status would be
changed.
Another couple of points â I have set the page to refresh every 60 seconds so
that way it will be easy for reception to quickly determine how long is
remaining in any given session.
The question I have relates to the following:
Take the bottom part of the screen (bookings made but the session has not yet
started). These will be displayed. I would like to somehow give the user a
simple way to start a booking. I was thinking of letting the user click on the
little Edit link under manage and open a pop-up window to edit the record and
change the status from waiting to session started.
And similarly I would like to make it easy for a person to be able to click a
button to indicate that a current booking has been completed â i.e. click on
a button then it would change the status from current to complete.
Just wondering what would be the simplest yet effective implementation. I was
thinking of using AJAX but at this stage I havenât used AJAX previously so
not too sure about it.
The idea of opening up a pop-up window and letting a user edit the record would
work but it seems a little cumbersome and not really that user friendly.
Any ideas.
Thanks in advance.
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
$('input[type=checkbox]',frm).change(function(){
// Create a JSON object to use in our Ajax call
var postObj = new Object();
postObj = {action : this.checked ?
'add':'delete',id :
$(this).val()};
// Ajax call to our CFC, taking 'action' and 'id' as
args
// 'success' is indicative of a successful Ajax call,
// and will show whatever message is returned from your
method
$.ajax({
url: processor.cfc,
type: POST,
data: postObj,
success: function(msg){
$('div##msgDisplay').html(msg);
},
error: function(){
$('div##msgDisplay').html('There was an
error processing your
request.');
}
});
});
});
/script
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Peter Tanswell wrote:
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292399
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can this be done
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 a gym. On the home page of the application I am currently displaying details of personal training sessions which are in progress, and also thos sessions which are waiting to be started. Sessions in progress P/TrainerRoom # Start Time Finish Time Remaing Time Rob 17:00 8:00 25 mins Mick 27308:30 55 mins Sessions waiting to start P/TrainerRoom # Start Time Finish Time Remaing Time Rob 1 Mick 2 I have also set this page up to referesh every 60 seconds - this part works well and as intended. I could I guess add a button for each record which would allow a user to edit each record individually, but am wondering if there is another simpler way that this could be done - e.g. maybe a checkbox which the user checks and then when the screen refeshes any records with checkboxes marked have their status changed. Basically I want to enable a user to be able to effortlessly indicate that a session has been completed so that record does not continue to be displayed). Also I want the user to indicate that a session has moved from the waiting state to the active state. I was thinking of including a check box which can be clicked - to indicate that a record can move from the wating state to current. Any thoughts on this will be greatly appreciated. Thanks ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Can this be done
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 http://acoderslife.com ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Can this be done
Pete,
I would look into jQuery for AJAX. It is rockin' simple:
$( input.status ).click(
function(){
var jCheckbox = $( this );
$.get(
change_status.cfm,
{ id: jCheckbox.attr( id ) },
function(){ ... Callback ... }
);
}
);
..
Ben Nadel
Certified Advanced ColdFusion MX7 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 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 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
http://acoderslife.com
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292325
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done
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 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 http://acoderslife.com ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can this be done
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
$('input[type=checkbox]',frm).change(function(){
// Create a JSON object to use in our Ajax call
var postObj = new Object();
postObj = {action : this.checked ?
'add':'delete',id :
$(this).val()};
// Ajax call to our CFC, taking 'action' and 'id' as
args
// 'success' is indicative of a successful Ajax call,
// and will show whatever message is returned from your
method
$.ajax({
url: processor.cfc,
type: POST,
data: postObj,
success: function(msg){
$('div##msgDisplay').html(msg);
},
error: function(){
$('div##msgDisplay').html('There was an
error processing your
request.');
}
});
});
});
/script
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Peter Tanswell wrote:
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 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
http://acoderslife.com
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292329
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can this be done?
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. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278600 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can this be done?
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: Hi all, I am breaking my head over something, and I hope someone can tell me if, and how, this van be done. A client wants some sort of 'Live helper' functionality on the website, where a web visitor fills in a form with a questions, that question is then delivered to an MSN account within the company. The company responds via MSN, and the response must then be shown to the user. 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 that, because it is a lot of data to put in the DB. Is there any other way? Hope you can help! Kind regards, Erik-Jan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
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. A client wants some sort of 'Live helper' functionality on the website, where a web visitor fills in a form with a questions, that question is then delivered to an MSN account within the company. The company responds via MSN, and the response must then be shown to the user. 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 that, because it is a lot of data to put in the DB. Is there any other way? Hope you can help! Kind regards, Erik-Jan ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this 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 that, because it is a lot of data to put in the DB. Is there any other way? You can, in theory, put the response into an application or server variable in the handler from the event gateway and have JS poll a CF page that looks for a response. Heres a sample implementation. User enters in question in form on webpage. Javascript submits question via XMLHTTP post to CF page. CF Page posts question to MSN user and prefixes a UUID (or the users CFID/CFToken/JSessionID/any unique ID) to the question. For example: WebsiteMSN_User: [987124] - Do you guys sell widgets? And returns that unique as the response of the XMLHTTP request. Javascript holds that number in memory and polls a different page (getResponse.cfm?msgID=987124) every 5-10 seconds (or uses a hanging get, whatever you prefer) passing that number as a parameter to the page. MSN user responds, prefixing the same code to his response MSNUser: [987124] - we do sell widgets, click on Cogs/Widgets on the top menu bar and you will see it You would add an application variable in your msn event gateway incoming message handler that would create a variable cfset application.msnDialogue.987124 = we do sell widgets, click on Cogs/Widgets on the top menu bar and you will see it Finally, the getResponse.cfm page would look for that variable and if it found it, return it and structDelete it so you dont have too many variables sitting in memory. Its not elegant, but it will work without a DB. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
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. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
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 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 that, because it is a lot of data to put in the DB. Is there any other way? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 information to the bottom frame asthe path. Each time a link is clicked the bottom frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can this be done??
_javascript_. Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have 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: 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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have 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: 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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can this be done??
http://www.w3schools.com/js/js_frames.asp http://www.w3schools.com/js/js_frames.asp Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have 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: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 9:04 AM 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_. Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have 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: 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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can this be done??
Actually, depending on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use 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... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can this be done??
Hi, I have an example working from http://developer.irt.org/script/11.htm When I click on a directory or filename link the results gets passed to the bottom frame. The problem I have is every link that a user clicks on I want it to concatenate each directory/file to the listing. Currently it only display each link cliked. How can I do this? Help! --Original Message Text--- From: [EMAIL PROTECTED] Date: Wed, 26 Nov 2003 14:13:15 - 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can this be done??
Ah, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can this be done??
Did you even try looking up how to use a list or array and figure it out for yourself? 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 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can this be done??
You could store the info in a session variable and then append the new value to it. Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have 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: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 10:21 AM To: CF-Talk 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can this be done??
I was actually wondering the same thing. Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have 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 even try looking up how to use a list or array and figure it out for yourself? 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 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 it out for yourself? 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 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can this be done??
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 it out for yourself? 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 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can this be done??
I've flipped through ColdFusion MX Web Application Construction Kit_ by Ben Forta, page 170. and this is just too deep for me. I've tried using cfset itemlist - listappend(itemlist,URL.DIR) without any success? When a link is clicked a href="" target=bottomframe I'm passing the results to the bottom frame which works fine. I put the cfset into the bottom.cfm file. When I click on another link the ITEMLIST does not get appended. Am I using the correct CF code? What am I doing wrong? --Original Message Text--- From: Bushy Date: Wed, 26 Nov 2003 10:40:11 -0500 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 it out for yourself? 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 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href="" target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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 ... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 as the path. Each time a link is clicked the bottom frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can this be done??
cfset itemlist = listappend(itemlist,URL.DIR) You had a typo on the equals sign. Tom Nunamaker I've flipped through ColdFusion MX Web Application Construction Kit_ by Ben Forta, page 170. and this is just too deep for me. I've tried using cfset itemlist - listappend(itemlist,URL.DIR) without any success? When a link is clicked a href=""> target=bottomframe I'm passing the results to the bottom frame which works fine. I put the cfset into the bottom.cfm file. When I click on another link the ITEMLIST does not get appended. Am I using the correct CF code? What am I doing wrong? --Original Message Text--- From: Bushy Date: Wed, 26 Nov 2003 10:40:11 -0500 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 it out for yourself? 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 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href=""> target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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 ... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 as the path. Each time a link is clicked the bottom frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 -0500 (EST) cfset itemlist = listappend(itemlist,URL.DIR) You had a typo on the equals sign. Tom Nunamaker I've flipped through ColdFusion MX Web Application Construction Kit_ by Ben Forta, page 170. and this is just too deep for me. I've tried using cfset itemlist - listappend(itemlist,URL.DIR) without any success? When a link is clicked a href=""> target=bottomframe I'm passing the results to the bottom frame which works fine. I put the cfset into the bottom.cfm file. When I click on another link the ITEMLIST does not get appended. Am I using the correct CF code? What am I doing wrong? --Original Message Text--- From: Bushy Date: Wed, 26 Nov 2003 10:40:11 -0500 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 it out for yourself? 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 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, maybe I misunderstood what you were trying to do. That still sounds pretty basic and still may not need _javascript_. One way that you might do it is in the top frame, each link goes to the same page in the bottom frame and just passes the link information as a url variable. So pass from the top frame something like: a href=""> target=bottomFramechanges/a Then on the bottom frame, just grab the url.item variable passed to it, add it to a list or array or whatever you need of url variables that you've passed, probably storing them in the session scope. Then output 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 on how he's doing things _javascript_ might not be feasible. If the file/folder listing view is a ftp window in the frame, then he probably won't be able to use _javascript_. The directory/file listing is created using CFFTP. If it's a cf/html listing of files, then it's easy and doesn't even really need _javascript_. Just use the target attribute in the a href for each link and point it to the other frame. OK...but how can I concatenate the listings? -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 ... 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--- From: Heald, Tim Date: Wed, 26 Nov 2003 08:56:10 -0500 _javascript_. -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 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 as the path. Each time a link is clicked the bottom frame would get updated with a new entry. For example (+ is directory, - is files): Top frame listing - Directory Listing: + changes + delivery + late + schedule - data.txt - test.txt - mywork.txt So if a user click on a the directory changes link the file path and name are passed to the bottom frame. user then click on the directory late and then filename test.txt Bottom frame: - changes late test.txt How could this be done? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can this be done??
If I'm hearing you right you want to pass a value from the top frame
like:
a href="" target=_bottom_frameSomething/a
Then in your bottom.cfm you can have a persistant variable or maybe a
cookie that you can add the selected value to:
cfparam name=client.big_list default=
cfif isdefined('url.value')
cfset client.big_list = listappend(client.big_list, url.value)
/cfif
Then you can loop over the list and display the items that you selected
in the top:
cfif 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'm doing something else wrong.
--Original Message Text---
From: [EMAIL PROTECTED]
Date: Wed, 26 Nov 2003 13:07:46 -0500 (EST)
cfset itemlist = listappend(itemlist,URL.DIR)
You had a typo on the equals sign.
Tom Nunamaker
I've flipped through ColdFusion MX Web Application Construction Kit_
by
Ben Forta, page 170. and this is just too deep for me.
I've tried using cfset itemlist - listappend(itemlist,URL.DIR)
without
any success?
When a link is clicked a href="">
target=bottomframe
I'm passing the results to the bottom frame which works fine.
I put the cfset into the bottom.cfm file. When I click on another
link
the ITEMLIST does not get appended. Am I using the correct CF code?
What am I doing wrong?
--Original Message Text---
From: Bushy
Date: Wed, 26 Nov 2003 10:40:11 -0500
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 it
out
for yourself?
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 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, maybe I misunderstood what you were trying to do. That still
sounds pretty basic and still may not need _javascript_.
One way that you might do it is in the top frame, each link goes to
the
same
page in the bottom frame and just passes the link information as a
url
variable. So pass from the top frame something like:
a href="">
target=bottomFramechanges/a
Then on the bottom frame, just grab the url.item variable passed to
it,
add
it to a list or array or whatever you need of url variables that
you've passed, probably storing them in the session scope. Then
output
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 on how he's doing things _javascript_ might not
be
feasible. If the file/folder listing view is a ftp window in the
frame,
then
he probably won't be able to use _javascript_.
The directory/file listing is created using CFFTP.
If it's a cf/html listing of files, then it's easy and doesn't even
really
need _javascript_. Just use the target attribute in the a href for
each
link
and point it to the other frame.
OK...but how can I concatenate the listings?
-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 ... 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---
From: Heald, Tim
Date: Wed, 26 Nov 2003 08:56:10 -0500
_javascript_.
-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 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 as the path. Each time a
link
is clicke
RE: Can this be done??
Exactly!
Work like a charm!
Mucho Grande!
--Original Message Text---
From: Greg Luce
Date: Wed, 26 Nov 2003 14:01:17 -0500
If I'm hearing you right you want to pass a value from the top frame
like:
a href="" target=_bottom_frameSomething/a
Then in your bottom.cfm you can have a persistant variable or maybe a
cookie that you can add the selected value to:
cfparam name=client.big_list default=
cfif isdefined('url.value')
cfset client.big_list = listappend(client.big_list, url.value)
/cfif
Then you can loop over the list and display the items that you selected
in the top:
cfif 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'm doing something else wrong.
--Original Message Text---
From: [EMAIL PROTECTED]
Date: Wed, 26 Nov 2003 13:07:46 -0500 (EST)
cfset itemlist = listappend(itemlist,URL.DIR)
You had a typo on the equals sign.
Tom Nunamaker
I've flipped through ColdFusion MX Web Application Construction Kit_
by
Ben Forta, page 170. and this is just too deep for me.
I've tried using cfset itemlist - listappend(itemlist,URL.DIR)
without
any success?
When a link is clicked a href="">
target=bottomframe
I'm passing the results to the bottom frame which works fine.
I put the cfset into the bottom.cfm file. When I click on another
link
the ITEMLIST does not get appended. Am I using the correct CF code?
What am I doing wrong?
--Original Message Text---
From: Bushy
Date: Wed, 26 Nov 2003 10:40:11 -0500
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 it
out
for yourself?
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 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, maybe I misunderstood what you were trying to do. That still
sounds pretty basic and still may not need _javascript_.
One way that you might do it is in the top frame, each link goes to
the
same
page in the bottom frame and just passes the link information as a
url
variable. So pass from the top frame something like:
a href="">
target=bottomFramechanges/a
Then on the bottom frame, just grab the url.item variable passed to
it,
add
it to a list or array or whatever you need of url variables that
you've passed, probably storing them in the session scope. Then
output
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 on how he's doing things _javascript_ might not
be
feasible. If the file/folder listing view is a ftp window in the
frame,
then
he probably won't be able to use _javascript_.
The directory/file listing is created using CFFTP.
If it's a cf/html listing of files, then it's easy and doesn't even
really
need _javascript_. Just use the target attribute in the a href for
each
link
and point it to the other frame.
OK...but how can I concatenate the listings?
-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 ... 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---
From: Heald, Tim
Date: Wed, 26 Nov 2003 08:56:10 -0500
_javascript_.
-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 bottomframe).
I the top frame I'm listing directories/files which have links to
them.
Beside each directory/file is an ima
RE: Can this be done?
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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
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 Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 08, 2003 9:08 AM Subject: Can this be done? 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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Can this be done?
The location you came from (http_referer) is one of the standard cgi variables. It doesn't always exist, but you can check for it. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 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 on a Monday morning ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Can this be done?
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 potential client that such techniques are not terribly reliable accross all ranges of browsers. -Mark -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 11:08 AM To: CF-Talk Subject: Can this be done? 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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Can this be done?
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 need, but you are going to have to determine what URL format each and ever search engine uses for their keywords. For example, Google using a URL variable named q. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Can this be done?
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? 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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Can this be done?
I'm guessing it is based on the HTTP_REFERER variable. What else could it be??? And to everyone else, I do not have a URL to check this out. keeps scratching head... I guess I'll have to do more research in this... ~Ché -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 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 on a Monday morning ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 08, 2003 9:08 AM Subject: Can this be done? 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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Can this be done?
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 domain from the referer ---! cfset var domain = REFind() cfswitch expression=#UCase(domain)# cfcase value=GOOGLE.COM !--- return the search query --- cfreturn REFIND() /cfcase cfswitch /cffunction Then a bunch of different communities pick a search engine and write the cfcase for it. Before you know it all the major search engines will be supported. Anyone interested? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Can this be done?
Well how do the stats packages come up with the 10 most common search keywords used to find your pages then? There must be some variable passed that appears in the logs somewhere. No? If that goes in the logs somewhere, it can be used, I'd have thought. But certainly I'd be very cautious about using any system that depends heavily on browser information - http_referer or suchlike, because many users block that info by way of their firewalls or because they are behind a router. You can have hundreds of people in a building using only a few ip addresses and that can skew all kinds of systems. I'm just saying don't build any application that REQUIRES info back from the browser in order to function, unless you're ready to deal with the user calls I CAN'T GET INTO YOUR SITE! WHAT DO I DO!? YOU CALL YOURSELF A CUSTOMER ORIENTED ORGANISATION?? I'M GOING TO RESPORT YOU TO THE CONSUMERS ASSOCIATION. NO WAIT .. YOU *ARE* THE CONSUMERS ASSOCIATION! REPORT YOURSELVES THEN. Trust me, I've been there, heard all the jokes. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 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 on a Monday morning ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 08, 2003 9:08 AM Subject: Can this be done? 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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Can this be done?
I would think that the majority of search traffic is concentrated in a couple of engines--mostly Google and Yahoo. Even if you get a list of a few dozen, it's not a big deal to check the referrer and grab this info. Would make a nice little UDF. Sounds like the competitor is overstating their claims to the client. I'd suggest creating a page that does the same thing and showing it to the client on 4-5 different search engines. Tell them you never had a request for this before but it is easily accomplished. My $0.02. Sam -- Blog: 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:20 PM To: CF-Talk Subject: Re: Can this be done? You are correct that HTTP_REFERER will have the information you need, but you are going to have to determine what URL format each and ever search engine uses for their keywords. For example, Google using a URL variable named q. Matt Liotta ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Can this be done?
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). Sam -- Blog: 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 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 domain from the referer ---! cfset var domain = REFind() cfswitch expression=#UCase(domain)# cfcase value=GOOGLE.COM !--- return the search query --- cfreturn REFIND() /cfcase cfswitch /cffunction Then a bunch of different communities pick a search engine and write the cfcase for it. Before you know it all the major search engines will be supported. Anyone interested? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Can this be done?
There is an apache module called mod_suru: http://www.adornsoft.com/suru/ There are 2 more solutions (first is Python, second is JavaScript): http://neil.fraser.name/software/highlighter/ http://www.stompstompstomp.com/weblog/technical/2003-04-15 mack / I'm guessing it is based on the HTTP_REFERER variable. What else could it be??? And to everyone else, I do not have a URL to check this out. keeps scratching head... I guess I'll have to do more research in this... ~Ché -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 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 on a Monday morning ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 08, 2003 9:08 AM Subject: Can this be done? 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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Can this be done?
Here's a start. I started collecting this data quite some time ago, and it only represents search engines that people used to find sites where I've collected this data. In other words, this isn't exactly a comprehensive list and you can already see where minor variations on the URL could cause a big headache. What I have at this page is a list of Search Engine URLs that directed user's to my site, as well as the query string variable to holds the search term. I also have the generic search name (for instance google.com, google.ca, google.it, google.co.uk, et al. is just Google) 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* *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 domain from the referer ---! cfset var domain = REFind() cfswitch expression=#UCase(domain)# cfcase value=GOOGLE.COM !--- return the search query --- cfreturn REFIND() /cfcase cfswitch /cffunction Then a bunch of different communities pick a search engine and write the cfcase for it. Before you know it all the major search engines will be supported. Anyone interested? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Can this be done?
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 example hard coding is the way to go. It may even be the way to go initially, but if there is interest in maintaining such a beast then it would need to be refactored such that UDF wouldn't need to change to support new search engines or changes to existing search engines. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Can this be done?
Wow, great list! It would appear glancing at it that simply looking for the URL variable q in the referer would handle most search engines by itself. -Matt On Monday, September 8, 2003, at 12:52 PM, Hagan, Ryan Mr (Contractor ACI) wrote: Here's a start. I started collecting this data quite some time ago, and it only represents search engines that people used to find sites where I've collected this data. In other words, this isn't exactly a comprehensive list and you can already see where minor variations on the URL could cause a big headache. What I have at this page is a list of Search Engine URLs that directed user's to my site, as well as the query string variable to holds the search term. I also have the generic search name (for instance google.com, google.ca, google.it, google.co.uk, et al. is just Google) 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* *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 domain from the referer ---! cfset var domain = REFind() cfswitch expression=#UCase(domain)# cfcase value=GOOGLE.COM !--- return the search query --- cfreturn REFIND() /cfcase cfswitch /cffunction Then a bunch of different communities pick a search engine and write the cfcase for it. Before you know it all the major search engines will be supported. Anyone interested? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Can this be done?
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 variable at runtime. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Can this be done?
Yep...my badnever really looked at what search engines pass when entering keywords (I build apps...not market them)figured it would be a form post and therefore no URL string to pick apartMondays!! ;-) Anyhoo...yep everyone is rightI sure wouldn't rely on HTTP_REFERER Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver 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 common search keywords used to find your pages then? There must be some variable passed that appears in the logs somewhere. No? If that goes in the logs somewhere, it can be used, I'd have thought. But certainly I'd be very cautious about using any system that depends heavily on browser information - http_referer or suchlike, because many users block that info by way of their firewalls or because they are behind a router. You can have hundreds of people in a building using only a few ip addresses and that can skew all kinds of systems. I'm just saying don't build any application that REQUIRES info back from the browser in order to function, unless you're ready to deal with the user calls I CAN'T GET INTO YOUR SITE! WHAT DO I DO!? YOU CALL YOURSELF A CUSTOMER ORIENTED ORGANISATION?? I'M GOING TO RESPORT YOU TO THE CONSUMERS ASSOCIATION. NO WAIT .. YOU *ARE* THE CONSUMERS ASSOCIATION! REPORT YOURSELVES THEN. Trust me, I've been there, heard all the jokes. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 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 on a Monday morning ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 08, 2003 9:08 AM Subject: Can this be done? 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 competitor can dynamically build certain sections of a homepage based on the search term that was used on the previous page of a search engine site, no matter which one is used. 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? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Can this be done?
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 patterns structure outside the UDF and caches
it in Application scope, which violates some of cflib.org's standards, so I
may have to modify before submitting, moving the structKeyExists check
inside the UDF.
If anyone has time, please test it out. I'll submit to cflib.org shortly.
Thanks,
Sam
--
Blog: http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--
!---
getReferringSearch
Extracts the search criteria from the referrer, or a supplied URL.
Thanks to Ryan Hagan for providing a detailed list of search urls.
Samuel Neff ([EMAIL PROTECTED])
---
cfscript
if (not structKeyExists(application, getReferringSearchPatterns)) {
s = structNew();
s[http://altavista.com/sites/search/web;] = q;
s[http://altavista.com/web/results;] = q;
s[http://br.altavista.com/web/results;] = q;
s[http://de.altavista.com/web/results;] = q;
s[http://de.altavista.com/web/results/;] = aqa;
s[http://es.altavista.com/web/results;] = q;
s[http://it.altavista.com/web/results;] = q;
s[http://se.altavista.com/web/results;] = q;
s[http://uk.altavista.com/web/results;] = q;
s[http://www.altavista.com/sites/search/web;] = q;
s[http://www.altavista.com/web/results;] = q;
s[http://www.altavista.cz/web/results;] = q;
s[http://aolsearch.aol.ca/dirsearch.adp;] = query;
s[http://search.dogpile.com/texis/search;] = q;
s[http://search.earthlink.net/search;] = q;
s[http://www.findology.com/2.php;] = q;
s[http://go.google.com/hws/search;] = q;
s[http://www.google.at/search;] = q;
s[http://www.google.be/search;] = q;
s[http://www.google.ca/search;] = q,as_epq;
s[http://www.google.ch/search;] = q;
s[http://www.google.cl/search;] = q;
s[http://www.google.co.cr/search;] = q;
s[http://www.google.co.hu/search;] = q;
s[http://www.google.co.il/search;] = q;
s[http://www.google.co.in/search;] = q;
s[http://www.google.co.nz/search;] = q;
s[http://www.google.co.th/search;] = q;
s[http://www.google.co.uk/search;] = q;
s[http://www.google.co.ve/search;] = q;
s[http://www.google.com.ar/search;] = q;
s[http://www.google.com.au/search;] = as_epq;
s[http://www.google.com.br/search;] = q;
s[http://www.google.com.hk/search;] = q;
s[http://www.google.com.mx/search;] = q;
s[http://www.google.com.pe/search;] = q;
s[http://www.google.com.ru/search;] = q;
s[http://www.google.com.tr/search;] = q;
s[http://www.google.com.tw/search;] = q;
s[http://www.google.com/custom;] = q;
s[http://www.google.com/ie;] = q;
s[http://www.google.com/search;] = q,as_q,as_epq;
s[http://www.google.de/search;] = q,as_epq;
s[http://www.google.fi/search;] = q;
s[http://www.google.fr/search;] = q,as_q;
s[http://www.google.ie/search;] = q;
s[http://www.google.it/search;] = q,as_epq;
s[http://www.google.nl/search;] = q;
s[http://www.google.pl/search;] = q;
s[http://www.google.pt/search;] = q;
s[http://search.iwon.com/commerce/google.jsp;] = searchfor;
s[http://search.lycos.com/default.asp;] = query;
s[http://search.metacrawler.com/texis/search;] = q;
s[http://auto.search.msn.com/results.asp;] = q;
s[http://search.msn.com.mx/results.aspx;] = q;
s[http://search.msn.com.tw/spresults.aspx;] = q;
s[http://search.msn.com/pass/results.aspx;] = q;
s[http://search.msn.com/preview.aspx;] = q;
s[http://search.msn.com/results.asp;] = q;
s[http://search.msn.com/results.aspx;] = q;
s[http://search.msn.com/spresults.aspx;] = q;
s[http://search.msn.nl/results.aspx;] = q;
s[http://search.netscape.com/nscp_results.adp;] = query;
s[http://aolsearch.aol.com/aol/search;] = query;
s[http://eplansekits.com/cgi-bin/smartsearch/smartsearch.cgi;] =
keywords;
s[http://ms108.mysearch.com/jsp/AVweb.jsp;] = searchfor;
s[http://rr.looksmart.com/r_search;] = key;
s[http://search.cometsystems.com/search.php;] = qry;
s[http://search.virgilio.it/search/cgi/search.cgi;] = qs;
s[http://www.1stblaze.com/rel_search.phtml;] = xml_kwd;
s[http://www.agoodsearch.com/find.php;] = terms;
s[http://www.att.net/cgi-bin/websearch;] = qry,as_q;
s[http://www.browserwise.com/search/search.cgi;] = Terms;
s[http://www.coolwebsearch.com/search.php;] = qq;
s[http://www.findtarget.com/cb/hotsheet.php;] = q;
s[http://www.go-in-search.com/selink.php;] = terms;
RE: Can this be done?
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: http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- !--- getReferringSearch Extracts the search criteria from the referrer, or a supplied URL. Thanks to Ryan Hagan for providing a detailed list of search urls. Samuel Neff ([EMAIL PROTECTED]) --- cffunction name=getReferringSearch returnType=string output=false cfargument name=testUrl type=string required=false cfset var s = cfset var refererSplit = cfset var p = cfset var i = cfset var xmlDoc = cfset var patterns = cfset var atts = !--- OPTIONS referringSearchPatternDataUrl The URL to the search patterns XML file. This is intended to be a centrally managed remote file that can be kept up to date through community effort. referringSearchPatternDataAltUrl Secondary URL to the search patterns XML file. This is intended to be a local cache of the patterns file in case of connection failure. referringSearchPatternRefreshRate Frequency to referesh the XML file. The file will probably be rarely changed so a high number is recommended. In hours. Data File The patterns XML file should match the following example: ?xml version=1.0 ? patterns pattern url=http://altavista.com/sites/search/web; keys=q / pattern url=http://www.google.com/search; keys=q,as_q,as_epq / /patterns keys is comma delim list of possible URL keys that indicate criteria. --- cfscript referringSearchPatternDataUrl = http://127.0.0.1/tst/getReferringSearchPatterns.xml;; referringSearchPatternDataAltUrl = http://127.0.0.1/tst/getReferringSearchPatterns.xml;; referringSearchPatternRefreshRate = 6; /cfscript !--- If we don't have the patterns or if they're old, reload them. Since this function will typically only be called once per request, then there's no disadvantage of having this code inside the function as opposed to when the function is loaded. If for some reason you're calling this a lot in the same request, then you may want to move this code outside the function execution block. --- cfif not structKeyExists(application, getReferringSearchPatterns) or application.getReferringSearchPatterns.lastReloadTime LTE dateAdd(h, -1 * referringSearchPatternRefreshRate, now()) cftry cfhttp url=#referringSearchPatternDataUrl# method=get throwOnError=true cfcatch type=any cfhttp url=#referringSearchPatternDataAltUrl# method=get throwOnError=true /cfcatch /cftry cfset xmlDoc = xmlParse(cfhttp.fileContent) cfset patterns = xmlDoc.patterns.pattern cfset s = structNew() cfloop index=i from=1 to=#arrayLen(patterns)# cfset atts = patterns[i].xmlAttributes cfset s[atts.url] = atts.keys /cfloop cfset s.lastReloadTime = now() cfset application.getReferringSearchPatterns = s /cfif cfparam name=arguments.testUrl default=#cgi.http_referer# cfif arguments.testUrl neq cfset refererSplit = listToArray(arguments.testUrl, ?) cfif arrayLen(refererSplit) GTE 2 and structKeyExists( application.getReferringSearchPatterns, refererSplit[1]) cfset u = listToArray(refererSplit[2],) cfloop index=p list=#application.getReferringSearchPatterns[refererSplit[1]]# cfloop index=i from=1 to=#arrayLen(u)# cfif listGetAt(u[i], 1, =) is p cfset s = listGetAt(u[i], 2, =) cfbreak /cfif /cfloop /cfloop /cfif /cfif cfreturn s /cffunction ?xml version=1.0 ? patterns pattern url=http://altavista.com/sites/search/web; keys=q / pattern url=http://altavista.com/web/results; keys=q / pattern url=http://br.altavista.com/web/results; keys=q / pattern url=http://de.altavista.com/web/results; keys=q / pattern url=http://de.altavista.com/web/results/; keys=aqa / pattern url=http://es.altavista.com/web/results; keys=q / pattern url=http://it.altavista.com/web/results; keys=q / pattern
RE: Can this be done?
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 used by the version of CF you are using. You should see the mappings already set up for the .CFM files there. I've played around with this to have CF process .css style sheets... Chuck McElwee Macromedia Certified Advanced ColdFusion Developer www.etechsolutions.com [EMAIL PROTECTED] -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 4:24 PM To: CF-Talk Subject: Can this be done? Hello All, Wondering if there is a way to make the html files to using cold fusion on a windows server 2000 iis5? I need to map all the html in a site to cold fusion. I don't really feel like changing all the html extensions to cfm. Thanks. Joel __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Can this be done?
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. Rick -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 3:24 PM To: CF-Talk Subject: Can this be done? Hello All, Wondering if there is a way to make the html files to using cold fusion on a windows server 2000 iis5? I need to map all the html in a site to cold fusion. I don't really feel like changing all the html extensions to cfm. Thanks. Joel __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Can this be done?
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 and will be treated the same as .cfm files. -Novak - 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 using cold fusion on a windows server 2000 iis5? I need to map all the html in a site to cold fusion. I don't really feel like changing all the html extensions to cfm. Thanks. Joel __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Can this be done?
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 29/08/02 -0500, you wrote: Hello All, Wondering if there is a way to make the html files to using cold fusion on a windows server 2000 iis5? I need to map all the html in a site to cold fusion. I don't really feel like changing all the html extensions to cfm. Thanks. Joel __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Can this be done?
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 using cold fusion on a windows server 2000 iis5? I need to map all the html in a site to cold fusion. I don't really feel like changing all the html extensions to cfm. Thanks. Joel __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Can this be done?
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 Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 4:24 PM To: CF-Talk Subject: Can this be done? Hello All, Wondering if there is a way to make the html files to using cold fusion on a windows server 2000 iis5? I need to map all the html in a site to cold fusion. I don't really feel like changing all the html extensions to cfm. Thanks. Joel __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: Can this be done?
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] 08/29/02 19:39 PM Hello All, Wondering if there is a way to make the html files to using cold fusion on a windows server 2000 iis5? I need to map all the html in a site to cold fusion. I don't really feel like changing all the html extensions to cfm. Thanks. Joel __ Get the mailserver that powers this list at http://www.coolfusion.com 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: 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 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 etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: Can this be done?
One way you can do this is to keep a count of the items in the list and when the count is equal to X, create a new cell. Have the count restart every time you create a new cell (td) and don't forget to close your previous one. You can even have the X variable be something a user can set. 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 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 etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Can this be done?
Not sure of exactly how to do it, but I'd guess you grab the first 4 and display them, then the next four, then the next four. If it's the display part that you're having trouble with, have one table with one row and (using your example below) five td's. Then in each td have another table 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 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 etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Can this be done?
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 + ((j-1)*rows) cfif currentIndex gt qResults.Recordcount tdnbsp;/td cfelse td#qResults.fieldName[currentIndex]#/td /cfif /cfloop /tr /cfloop NOTE, that code is not tested. It's just give you the idea/theory behind it. I hope that makes sense. Ben Johnson Hostworks, Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Can this be done?
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 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 etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Can this be done?
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 /cfif cfif itemcount EQ 4 cfset itemcount =0 cfset columncount = coulmncount+1 #name#/td /cfif cfif coulmncount GT 5 cfset columncount = 1 /tr /cfif /cfoutput /table Well atleast something along that lines. Did not test it but you can try it. [EMAIL PROTECTED] 05/15/02 12:54 PM 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 etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: Can this be done?
I know how to do this with a query, and that's all that a CFDIRECTORY call is right? You would use current row and mod and nested tables to make it work. Say you wanted to have it 5 or 10 high ten you would do something like cfif currentrow mod 10 is 0 and end your current table and start 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, 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 etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +- --+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +- ---+ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: 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 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 + ((j-1)*rows) cfif currentIndex gt qResults.Recordcount tdnbsp;/td cfelse td#qResults.fieldName[currentIndex]#/td /cfif /cfloop /tr /cfloop NOTE, that code is not tested. It's just give you the idea/theory behind it. I hope that makes sense. Ben Johnson Hostworks, Inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Can this be done?
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 td align=center valign=top cfoutput query=getProducts //could be loop YOUR CONTENT HERE /td cfif getProducts.CurrentRow mod x eq 0//that would make this loop count /tr td align=center cfelse td align=center /cfif /cfoutput /tr /table -Craig __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Can this be done?
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 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 + ((j-1)*rows) cfif currentIndex gt qResults.Recordcount tdnbsp;/td cfelse td#qResults.fieldName[currentIndex]#/td /cfif /cfloop /tr /cfloop NOTE, that code is not tested. It's just give you the idea/theory behind it. I hope that makes sense. Ben Johnson Hostworks, Inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Can this be done?
or to fillup each column first before starting a new row. int(currentrow / ((recordcount+1)/columns)) example 10 records, 2 columns 1/((10+1)/2)=0 === designate the column to display 2/((10+1)/2)=0 3/((10+1)/2)=0 4/((10+1)/2)=0 5/((10+1)/2)=0 6/((10+1)/2)=1 7/((10+1)/2)=1 8/((10+1)/2)=1 9/((10+1)/2)=1 10/((10+1)/2)=1 sample output table trtdcfset col=0 cfoutput query=dirlist cfif col is int(currentrow / ((recordcount+1)/columns)) filenamebr cfelse cfset col = col+1 /tdtdfilenamebr /cfif /cfoutput /td/tr could be cleaned up lots - done quickly. Eric From: Alex [EMAIL PROTECTED] Reply-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 wrote: 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 etc... I was wondering if there is a way automatically using a table to do the following and if so, how? file1.txt file5.txt file9.txt file13.txt file17.txt file2.txt file6.txt file10.txt file14.txt file18.txt file3.txt file7.txt file11.txt file15.txt file19.txt file4.txt file8.txt file12.txt file16.txt file20.txt +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: 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 2002 17:05 To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: 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 it, and use the space as a list delimiter. It would be time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: can this be done?
You need to select just the surname part in your select list and then order by that. e.g. if your field is called name try sommat like the following.. SELECT name, LEFT(name,CHARINDEX( ,name)) as 'fname', RIGHT(name,CHARINDEX( ,name)) as 'sname' FROM table ORDER by sname This assumes that your data is all ok - i.e. all confors to the format fname sname. i.e. if there is someone who's first or surnames have a space in them then you are a bit stuffed. I have no idea if this will work in access but should work in SQL. Sticky tape job but there you go.. -Original 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 2002 17:05 To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: can this be done?
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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Yes, this is certainly possible. Access has the necessary string functions to support this within SQL statements, and you could approach this in many ways - you could do a one-time, offline data transformation, and rewrite your code to work with the new table design, or you could incorporate the transformation process into your existing CF code. I'd recommend the first option, myself. I'll also take this opportunity to say that, despite the client's initial desires, there's no reason that you had to use one field, even if that's how the client wanted to see the data. It's a good idea, for exactly this reason, to break your data into its smallest components, so that you don't have to transform it later. Even if your client didn't want to see the two fields as separate, you could certainly have handled that in your CF code, and still had the two separate fields in the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: can this be done?
Save yourself some pain and create two DB columns. Use CF to loop over them and re-insert the proper values. You only need to do this once of course... cfquery name=myQuery .. cfoutput query=myQuery cfquery name= INSERT INTO theTable (firstName, lastName) VALUES( '#listFirst(fullName, )#', '#listLast(fullName, )#') .. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'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 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 time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: can this be done?
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 in two using FindNoCase( ,Name,1) and grabbing to the left and right of the space. Then write the data back into the database into the two new fields you've created. (I don't give the customer the choice on this sort of thing, because they generally don't understand the ramifications.) T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: can this be done?
It can be done in access... Create two field within your table for first_name and last_name Then cfquery name=queryname datasoure=datasource Update table set first_name = left(fullname, instr(fullname,' ')), last_name=right(fullname, instrrev(fullname,' ')) /cfquery This should work. I haven't tried it so there might be some logical error I haven't thought of but the functions are in access to achieve the solution. - Matt Small -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 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 it, and use the space as a list delimiter. It would be time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: can this be done?
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. feeling pessimistic today. Jon -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Get the mailserver that powers this list at http://www.coolfusion.com 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: can this be done?
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 using the space, then insert first_name, then last_name? I planned for something like this before and depending on the data, it might be more complicated than you think. The problem comes in when you have people with middle name, middle initials, Jr., Sr., III, etc. These things don't fit easily into a break at the first whitespace plan. Of course, if you don't actually have that kind of data, there's no problem. Change it once and never go back because eventually you will have that problem. Take a look at the data and see what kind of anomalies exist in the field before you proceed. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: can this be done?
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 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Yes, this is certainly possible. Access has the necessary string functions to support this within SQL statements, and you could approach this in many ways - you could do a one-time, offline data transformation, and rewrite your code to work with the new table design, or you could incorporate the transformation process into your existing CF code. I'd recommend the first option, myself. I'll also take this opportunity to say that, despite the client's initial desires, there's no reason that you had to use one field, even if that's how the client wanted to see the data. It's a good idea, for exactly this reason, to break your data into its smallest components, so that you don't have to transform it later. Even if your client didn't want to see the two fields as separate, you could certainly have handled that in your CF code, and still had the two separate fields in the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: can this be done?
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 John Van Dusen ? Is the Van portion a middle name, or part of the last name? How do you write that logic into the code? Hence the reason I say you need a manual review afterwards. (or before, to be certain you do not have any of these situations.) If you are going the CF route, then you might be able to use the list functions to do this. For instance: cfscript sFullName = Shawn Grover; sFirstName = ListGetAt(sFullName, 1, ); sLastName = ListGetAt(sLastName, 2, ); /cfscript Or you can be more elaborate, and get the first name, then using the left/right functions, strip that string from the full name, and assume the rest is the last name. My thoughts Shawn Grover -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:05 AM To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Get the mailserver that powers this list at http://www.coolfusion.com 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: can this be done?
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... Create two field within your table for first_name and last_name Then cfquery name=queryname datasoure=datasource Update table set first_name = left(fullname, instr(fullname,' ')), last_name=right(fullname, instrrev(fullname,' ')) /cfquery This should work. I haven't tried it so there might be some logical error I haven't thought of but the functions are in access to achieve the solution. - Matt Small -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 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 it, and use the space as a list delimiter. It would be time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, 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, this was discussed prior to, and was deemed not needed. 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 using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: 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;
}
if(not isdefined(url.updn)){
updn=ASC;
}
/cfscript
cfquery name=qGetAll datasource=#request.dsn#
SELECT fullname
FROM mytable
/cfquery
cfoutput query=qGetAll
fname[i]=ListGetAt(fullname,1, );
lname[i]=ListGetAt(fullname,2, );
cfset i=i+1
/cfoutput
cfscript
tmp=QueryAddColumn(qGetAll, fname, fname);
tmp=QueryAddColumn(qGetAll, lname, lname);
/cfscript
cfquery name=qGetAll_2 dbtype=query
SELECT * FROM qGetAll
ORDER BY #url.orderby# #url.updn#
/cfquery
cfscript
if(updn is ASC){
updn=DESC;
}else{
updn=ASC;
}
/cfscript
cfoutput query=qGetAll_2
a href=mypage.cfm?sortby=fnameupdn=#updn##fname#/a
a href=mypage.cfm?sortby=lnameupdn=#updn##lname#/a
br
/cfoutput
==
Hope this helps!
Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 12:05 PM
To: CF-Talk
Subject: can this be done?
Hello cf-talk,
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, this was discussed prior to, and was deemed not needed.
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 using the space, then
insert first_name, then last_name?
Is this even possible? This would have been so much easier if client
said yes to this at the design stage!
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
_
Composed on Monday, May 13, 2002, at 11:55:57 AM
__
Get the mailserver that powers this list at http://www.coolfusion.com
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: can this be done?
Although several folks had much better solutions using SQL - take their
advice - don't do it the CF way unless you have to for some reason.
Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (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=1;
fname=ArrayNew(1);
lname=ArrayNew(1);
if(not isdefined(url.orderby)){
url.orderby=fname;
}
if(not isdefined(url.updn)){
updn=ASC;
}
/cfscript
cfquery name=qGetAll datasource=#request.dsn#
SELECT fullname
FROM mytable
/cfquery
cfoutput query=qGetAll
fname[i]=ListGetAt(fullname,1, );
lname[i]=ListGetAt(fullname,2, );
cfset i=i+1
/cfoutput
cfscript
tmp=QueryAddColumn(qGetAll, fname, fname); tmp=QueryAddColumn(qGetAll,
lname, lname); /cfscript
cfquery name=qGetAll_2 dbtype=query
SELECT * FROM qGetAll
ORDER BY #url.orderby# #url.updn#
/cfquery
cfscript
if(updn is ASC){
updn=DESC;
}else{
updn=ASC;
}
/cfscript
cfoutput query=qGetAll_2
a href=mypage.cfm?sortby=fnameupdn=#updn##fname#/a
a href=mypage.cfm?sortby=lnameupdn=#updn##lname#/a
br
/cfoutput
==
Hope this helps!
Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 12:05 PM
To: CF-Talk
Subject: can this be done?
Hello cf-talk,
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, this was discussed prior to, and was deemed not needed.
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 using the space, then
insert first_name, then last_name?
Is this even possible? This would have been so much easier if client
said yes to this at the design stage!
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
_
Composed on Monday, May 13, 2002, at 11:55:57 AM
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
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: can this be done?
How about really easy. You set up a where that looks for whatever they
entered.
Select name
from personnel
where name like '%#form.firstname#%'
or name like '%#form.lastname#%'
I mean it wouldn't be exact but there shouldn't be to many over lapping
names. Not a lot of people out there with a last name containing Tim or bob
or whatever. It wouldn't be exact but it would probably fit the middle
ground and save you some trouble.
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
-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=1;
fname=ArrayNew(1);
lname=ArrayNew(1);
if(not isdefined(url.orderby)){
url.orderby=fname;
}
if(not isdefined(url.updn)){
updn=ASC;
}
/cfscript
cfquery name=qGetAll datasource=#request.dsn#
SELECT fullname
FROM mytable
/cfquery
cfoutput query=qGetAll
fname[i]=ListGetAt(fullname,1, );
lname[i]=ListGetAt(fullname,2, );
cfset i=i+1
/cfoutput
cfscript
tmp=QueryAddColumn(qGetAll, fname, fname);
tmp=QueryAddColumn(qGetAll, lname, lname);
/cfscript
cfquery name=qGetAll_2 dbtype=query
SELECT * FROM qGetAll
ORDER BY #url.orderby# #url.updn#
/cfquery
cfscript
if(updn is ASC){
updn=DESC;
}else{
updn=ASC;
}
/cfscript
cfoutput query=qGetAll_2
a href=mypage.cfm?sortby=fnameupdn=#updn##fname#/a
a href=mypage.cfm?sortby=lnameupdn=#updn##lname#/a
br
/cfoutput
==
Hope this helps!
Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 12:05 PM
To: CF-Talk
Subject: can this be done?
Hello cf-talk,
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, this was discussed prior to, and was deemed not needed.
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 using the space, then
insert first_name, then last_name?
Is this even possible? This would have been so much easier if client
said yes to this at the design stage!
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
_
Composed on Monday, May 13, 2002, at 11:55:57 AM
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
