Re: url variables
try
isdefined(url.Task#i#)
hth
Charlie Hanlon
- Original Message -
From: Richard White [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, November 02, 2006 12:57 PM
Subject: url variables
hi, i have a page that submits values to a form as follows:
var sendString = rowNum= + taskGrid.getRowsNum();
for (i=1;i=taskGrid.getRowsNum();i++)
{
sendString = sendString + Task + a += + taskGrid.cells(i,
1).getValue();
a++;
}
(new Image()).src = updater.cfm? + sendString;
Therefore the update.cfm page will recieve:
url.Task1 = ...
url.Task2 = ...
url.Task3 = ...
etc...
and will contain x amount of tasks in the url variable dependant on how
many rows there are in the grid
The problem i am having is that i want to reference them in the update.cfm
page like this
cfloop index=i from=1 to=#url.rowNum#
cfif isdefined(url.Task i)/
/cfif
/cfloop
but it keeps giving me an error as it isnt recocognising
isdefined(url.Task i)
of course if i change this to isdefined(url.Task1) then it works fine.
is there are way that i can concertanate the url.Task with the value of i
and access the url.Task1
i would appreciate any help with this
thanks
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258882
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: url variables
try this. cfoutput#url[Milestone i]#/cfoutput hth charlie - Original Message - From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, November 02, 2006 4:01 PM Subject: Re: url variables forgive me for my ignorance but i have managed to get it working and going into the loop with cfif isdefined(url.Milestone#i#) but now when i want to get the value for it i am also getting errors for example i am trying cfoutputurl.Milestone#i#/cfoutput although no error are occuring it is not outputting the value, of course it wont as the url.milestone is not in the ## but i cant figure out how to do it appreciate any help thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: nested queries
cfquery name= datasource= SELECT s.staffTitle, s.staffFirstName, s.staffLastName FROM STAFF s, STUDENTS p WHERE s.staffEmail = p.staffEmail AND p.studentEmail = cfqueryparam value=[EMAIL PROTECTED] cfsqltype=cf_sql_varchar /cfquery Above is how I would write the query, but I am still learning. hth... Charles Hanlon Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 25, 2006 9:32 AM Subject: nested queries hi, i am having problems working out how to execute a nested query in a cfquery. It works fine in mysql with the following sql statement: SELECT staffTitle,staffFirstName,staffLastName FROM STAFF WHERE staffEmail = (SELECT staffEmail FROM STUDENTS WHERE studentEmail = email); however, i am not sure how to convert this into a cfquery. i have tried the following but getting an error: SELECT staffTitle, staffFirstName, staffLastName FROM STAFF WHERE staffEmail = SELECT staffEmail FROM STUDENTS WHERE studentEmail = cfqueryparam value=[EMAIL PROTECTED] cfsqltype=cf_sql_varchar i would appreciate some help on what i am doing wrong thanks very much ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfqueryparam
When I place a constant within a cfqueryparam, I am noticing performace degradation. SELECTmyField1, myField2, myField3 FROMmyDBtable WHEREmyRecID = cfqueryparam value=#val(url.id)# cfsqltype=CF_SQL_INTEGER ANDmyTypeID = cfqueryparam value=22 cfsqltype=CF_SQL_INTEGER The query above runs slower than the query shown below: SELECTmyField1, myField2, myField3 FROMmyDBtable WHEREmyRecID = cfqueryparam value=#val(url.id)# cfsqltype=CF_SQL_INTEGER ANDmyTypeID = 22 Can anyone tell me why this is, why placing the hard-coded value of 22 into a cfqueryparam causes a performance hit? thanks in advance for insight Charles Hanlon Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257781 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Single or Double Quotes - textarea values
You can use pr_text = cfqueryparam value=You'll be responsible for implementing, all of the responsibilities of cfsqltype=CF_SQL_VARCHAR or cfsqltype=CF_SQL_CHAR, depending on your data type on the field 'pr_text hth Charlie Hanlon Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 09, 2006 12:53 PM Subject: Single or Double Quotes - textarea values When I insert or update using the cfquery tag, some of the form fields has a long text string that is being palced into a text data type. Sometimes the text from the textarea contains single quotations or commas. This seems to throwing off my SQL statement. Should I be wrapping this form's values in double single quotes or or double quotes instead of single quotes. UPDATE tbl_HumanResourcesJobs SET pr_title = 'Job Description', pr_text = 'You'll be responsible for implementing, all of the responsibilities of ', pr_active = Yes, pr_date = 'September 29, 02006', pr_department = 'Marketing' WHERE hr_id = 97 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion Training Seminars
I took the FastTrack class in Toronto in 1999 or 2000 and it was a perfect fit for my experience level and acted as a springboard for my current career. I found it to be a terrific value. Charles Hanlon Senior Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Ray Champagne [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 20, 2006 11:25 AM Subject: Re: ColdFusion Training Seminars I should have probably prefaced my email with the fact that I took it in 2000 alsonot sure how much could have changed, curriculum-wise, but YMMV... Neil Middleton wrote: I did the fast-track course in 2000 (so it's probably changed), but I would say if you have less than around 1 years development under your belt then it's probably a good exposure to most bits of CF. Neil On 7/20/06, Ray Champagne [EMAIL PROTECTED] wrote: How much programming experience do you have? If you're a beginner, I'd say it would be worth it, but otherwise, pick up a WACK book from Ben Forta, work through a couple of the examples, use it for research in your first project, and you'll have about the same amount of knowledge you would have gotten from that FastTrack class, but a lot more money in your pocket. Ray Alan Dunn wrote: Thinking about taking one of the fast track training courses in coldfusion -- the 3 day courses... Has anyone taken any of these? Just wondering if they're worth the time, and what anyones experiences with these sort of classes are. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247192 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help building pages with multiple queries and tables
cfquery name=qcf_getSchools datasource=yourDSN SELECT s.SchoolID, s.SchoolName, t.SchoolType FROM Schools s, SchoolType t WHERE s.SchoolTypeID = t.SchoolTypeID ORDER BY t.SchoolType, s.SchoolName /cfquery cfoutput query=qcf_getSchools group=SchoolType #qcf_getSchools.SchoolType# cfoutput a href=school.cfm?id=#qcf_getSchools.SchoolID##qcf_getSchools.SchoolName#/a /cfoutput /cfoutput I would add a SchoolTypeID field to table SchoolType and then reference that ID within table Schools hth, Charles Hanlon Senior Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Steven Sprouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, July 19, 2006 10:38 AM Subject: Need help building pages with multiple queries and tables I'm new to this forum. I'm hoping there's someone out there that can help me with my problem. I'm trying to build a school directory similar to thi (http://www.mcps.k12.md.us/schools/index.cfm) or this (http://www.wcboe.k12.md.us/content/sch_schools.cfm) I have a Table named Schools with SchoolID, SchoolName, SchoolType, SchoolAddr, etc. and I also have a table called SchoolType with a fieldname of SchoolType that just lists Elementary, Middle, High, Center/Program. I don't know if I set my database up incorrectly or not, but I can't figure out a query (and the query string that I know I need) to get the first page to output a list of schools by School Type, and then when you click on the Go button or the School Name, it brings you to a page with information Specific to that school. Can anyone out there PLEASE help me? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247043 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help building pages with multiple queries and tables
Steve, Not sure what you are asking, but I would set up the tables thus: tbl_Schools school_id ( primary key) school_name school_typeID tbl_SchoolTypes school_typeID (primary key) school_type then you join the tables using the school_typeID fieldthis structure will allow you to modify the labels (field: school_type) you use within tbl_SchoolTypes without have to change the values of school_typeID within tbl_Schools. Charles Hanlon Senior Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Steven Sprouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, July 19, 2006 11:21 AM Subject: Re: Need help building pages with multiple queries and tables So, if my table with SchoolType just has a field with SchoolType and 4 records of Elementary, Middle, High, and Center/Program...that works? Because in my Schools table I have a field called SchoolType, so those two tables should link up correct? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247059 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form Variables and Find N Next
I am not sure this is the most efficient way to do this, but I pass the form values, if any, in the url of the pager, then at the top of the results page, I convert the url variable to a form variable ( which may be unneccessary, but I steer clear of unscoped variables) cfif isdefined(url.someVar) cfset form.someVar = url.someVar /cfif hth, and again, there may be/always are better solutions Charles Hanlon Senior Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Alan Dunn [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, July 19, 2006 12:00 PM Subject: Form Variables and Find N Next I've got a 2 field search form that submits to a results page that displays 20 records at a time, but when I click on the next 20 results, I get the error saying Element CATEGORYNAME is undefined in FORM. Here's my query-- I don't *think* its my problem, but just to make sure: cfquery name=CustomerSearch datasource=#APPLICATION.DataSource# SELECT CategoryName, CustomerID, CustomerName FROM Customers, Categories WHERE 0=0 !---Check to category field is blank:--- cfif FORM.CategoryName IS NOT AND CategoryName = '#FORM.CategoryName#' /cfif !---Check to see if CustomerDesc Search is blank:--- cfif FORM.CustomerDesc IS NOT AND CustomerDesc LIKE '%#FORM.CustomerDesc#%' /cfif ORDER BY CategoryName /cfquery how do I keep my form variables available for the next set of records? cfparam? Session scopes? My head is full of CFWACK and I think I may be guilty of new developer over complication, but I can't seem to make this work. Any hints or help from people that know more than I do would be greatly appreciated. Thanks :) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247062 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading parent form variables
This is how I have learned to it. In this case, my iframe is going to set a value for a form field on the parent window. parent.myForm.myFormField.value='foo'; hth Charles Hanlon Senior Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, May 19, 2006 3:21 PM Subject: reading parent form variables I have a page with an iframe. That iframe has a form. The action/target on the form replaces the _parent when it submits and goes to a feedback page: http://hhp.umd.edu/events/systems_thinking/q_a_test.cfm On the feedback page there is an iframe. The parent variables can be seen by CF using form.q_1, but I don't see a way to reference them from the CF in that iframe. Current it complains that it doesn't see the variables, but that's cause they're in the parent. How do I reference them? daniel - webtool - ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241027 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: input box focus
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body onload=JavaScript:document.myForm.myField.focus(); form name=myForm action= method=post textarea name=myField/textarea /form /body /html this works fine in IE and Firefox hth Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237587 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: input box focus
Just tested my code with cfform instead of form and still functions as desired. Charles Hanlon Senior Web Applications Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, April 12, 2006 2:30 PM Subject: Re: input box focus Perhaps CFFORM is messing with the form name? try a normal form tag and see if that helps Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237590 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX Client Variables
I have the following code: cfparam name=client.myVar default= cfoutput#client.myVar#/cfoutput For every ten times I run this page, 2-3 times out of then, I get the following error message: Element MYVAR is undefined in CLIENT can anyone enlighten me on this issue. thanks in advance charlie hanlon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235859 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
migration to CFMX and client variables
I have a application that utilizizes a variable that I named client.mySrchVars. This app has been running for about year on CF 4.5. This past weekend we migrated CFMX 7 (yippee!).. The problem, that client variable is no longer getting set. We created a db table to store client variables. After a few hours of frustration, I changed the variable name to client.mySrchVar without the 's'..now, everything is groovy. Was having the combination of letters 'vars' in my variables name causing an issue, or do I need to dig deeper.. thanks very much in advance if anyone can enlighten me as my already busy monday is disappearing.. charlie Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 09, 2006 12:05 PM Subject: Re: Source Code Versioning with ColdFusion Your best bet is probably Subversion. It's designed to supercede CVS, and is better in pretty much every way. The only think you might run into is if your working directories (the personal copy of the code that you work on, before checking your mods into the central repository) is located on a remote server, such as a central dev server. The filesystem access of SVN is orders of magnitude higher than CVS, so if you have to have a remote working directory, CVS might be a better choice. However, you should go out of your way to avoid that scenario, if you ask me. VSS is another option, if you don't want concurrency. I've never used it, but from what I heard, I can't say I recommend it. cheers, barneyb On 3/9/06, Jagos, Allan [EMAIL PROTECTED] wrote: I am researching source code versioning software for our team. We are 4 ColdFusion developers using Dreamweaver and SQL mainly for our development and currently do not use any code versioning software. What would you recommend for us or what are you using and how is that going? Thanks for the feedback. Allan M. Jagos -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235225 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: migration to CFMX and client variables
Also,this is only happening when the variables name ends in 'vars' if I do client.varsMySrch, no problem, but if I name it client.mySrchVars, the client variable is not getting written to our client storage table. charlie - Original Message - From: Charlie Hanlon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 13, 2006 12:52 PM Subject: migration to CFMX and client variables I have a application that utilizizes a variable that I named client.mySrchVars. This app has been running for about year on CF 4.5. This past weekend we migrated CFMX 7 (yippee!).. The problem, that client variable is no longer getting set. We created a db table to store client variables. After a few hours of frustration, I changed the variable name to client.mySrchVar without the 's'..now, everything is groovy. Was having the combination of letters 'vars' in my variables name causing an issue, or do I need to dig deeper.. thanks very much in advance if anyone can enlighten me as my already busy monday is disappearing.. charlie Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 09, 2006 12:05 PM Subject: Re: Source Code Versioning with ColdFusion Your best bet is probably Subversion. It's designed to supercede CVS, and is better in pretty much every way. The only think you might run into is if your working directories (the personal copy of the code that you work on, before checking your mods into the central repository) is located on a remote server, such as a central dev server. The filesystem access of SVN is orders of magnitude higher than CVS, so if you have to have a remote working directory, CVS might be a better choice. However, you should go out of your way to avoid that scenario, if you ask me. VSS is another option, if you don't want concurrency. I've never used it, but from what I heard, I can't say I recommend it. cheers, barneyb On 3/9/06, Jagos, Allan [EMAIL PROTECTED] wrote: I am researching source code versioning software for our team. We are 4 ColdFusion developers using Dreamweaver and SQL mainly for our development and currently do not use any code versioning software. What would you recommend for us or what are you using and how is that going? Thanks for the feedback. Allan M. Jagos -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: simple cfmail question...
This is usually how I code it cfmail to= from=[EMAIL PROTECTED] subject= cfmailparam name=from value=Tom Jones [EMAIL PROTECTED] /cfmail hth charlie hanlon - Original Message - From: Mingo Hagen [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 10, 2006 9:34 AM Subject: Re: simple cfmail question... what he said Robert Redpath wrote: from=Tom Jones [EMAIL PROTECTED] From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Fri 3/10/2006 9:22 AM To: CF-Talk Subject: simple cfmail question... User = Tom Jones User Email = [EMAIL PROTECTED] Using the cfmail tag, how do I write the from= line so that when I get an email from Tom that the From line in my email client says Tom Jones and not [EMAIL PROTECTED] Am I making sense? Thanks, Che. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235009 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: simple cfmail question...
That's how I learned. I'll assume that you're implying that the cfmailparam is unneccessary. Is this so? thanks, charlie hanlon - Original Message - From: Mingo Hagen [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 10, 2006 9:53 AM Subject: Re: simple cfmail question... Charlie Hanlon wrote: This is usually how I code it cfmail to= from=[EMAIL PROTECTED] subject= cfmailparam name=from value=Tom Jones [EMAIL PROTECTED] /cfmail wow, and why? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235018 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: simple cfmail question...
Thanks Jochem. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 10, 2006 10:06 AM Subject: Re: simple cfmail question... Charlie Hanlon said: That's how I learned. I'll assume that you're implying that the cfmailparam is unneccessary. Is this so? Just put it in the From. If the friendly name you want the user to see has any characters other then alfanumeric and spaces, enclose the friendly name in double quotes, i.e.: GOOD: cfmail from=John Doe [EMAIL PROTECTED] ... BAD: cfmail from=Doe, John [EMAIL PROTECTED] ... GOOD: cfmail from=Doe, John [EMAIL PROTECTED] ... Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235027 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Truncated Emails : maybe OT
Do you have lines longer then 998 characters? The contents of the emails gets generated dynamically. I am not sure how I would know the character count per line. Charlie Hanlon - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 07, 2006 5:08 PM Subject: Re: Truncated Emails : maybe OT Charlie Hanlon wrote: Excuse me if this is too OT, but I have an end user who recieves HTML emails from us, and the last few have been truncated with the bottom of the page displayin [Message clipped]. Do you have lines longer then 998 characters? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234536 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OOP, why me?
Claude said 'Flexibility? Framework means rules, how can rules add flexibilty?' I have often felt that rules (structure,framework) provides the enviroment for flexiblity just my 2 cents charlie hanlon - Original Message - From: Claude Schneegans [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 06, 2006 2:06 PM Subject: Re: OOP, why me? The biggest reasons I see for using frameworks are: -code reuse -flexibility -maintainability -documented code Well, IMHO these are just clichés. - code reuse? I don't see what in non framework application makes reusing any code any more difficult. - Flexibility? Framework means rules, how can rules add flexibilty? - Maintainability? By someone who knows the framework, may be, but for other (most of the time), it is like hell. - documented code? Any code should be documented, in a framework or not. Frameworks do not create documentation. Anyway, any experienced programer will end up with his own way to design applications, this is some kind of a framework, and it is the best one, because it is HIS. Gee I'm using a framework, and I didn't even know about it ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Truncated Emails : maybe OT
Excuse me if this is too OT, but I have an end user who recieves HTML emails from us, and the last few have been truncated with the bottom of the page displayin [Message clipped]. Can anyone point me in the right direction to solve this. thanks, Charlie Hanlon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using WHERE with ValueList?
RobertoI would write the sql statement thus: SELECT c.clientID, c.regionID, c.clientName, c.clientSSN, c.clientCity FROM clients_tb c WHERE c.regionID IN (cfqueryparam value=#valuelist(getRegions.regionID)# list=yes cfsqltype=CF_SQL_INTEGER) hth Charlie Hanlon - Original Message - From: Roberto Perez [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 03, 2006 2:19 PM Subject: using WHERE with ValueList? SELECT c.clientID, c.regionID, c.clientName, c.clientSSN, c.clientCity, FROM clients_tb c WHERE c.regionID CONTAINS #valuelist(getRegions.regionID)# I know now that CONTAINS is not a valid operator. Any ideas/pointers to make this query (or an alternative one) work? Thanks in advance, Roberto Perez ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234087 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using WHERE with ValueList?
Roberto, Yes, the value you use for the attribute 'cfsqltype' is directly related to the datatype of the field 'regionID'. I am not the expert regarding the performance issue, but I would assume you will take a hit if the list of IDs grows too large. Charlie Hanlon - Original Message - From: Roberto Perez [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 03, 2006 3:48 PM Subject: Re: using WHERE with ValueList? At 02:24 PM 3/3/2006, Bryan Stevenson wrote: suspect you need to use IN instead of CONTAINS v.regionID IN (cfqueryparam value=#valuelist(getRegions.regionID)## cfsqltype=cf_sql_numeric list=yes) Thanks, I stripped the extra numeral sign and it worked perfectly. Any known performance issues if my list has around 50 items? Also, my list is numeric. Would this work if I had alphanumeric characters? (I'm wondering whether the cf_sql_numeric part may affect data type) Thanks again, Roberto ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234127 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using WHERE with ValueList?
Roberto,
Keep the Where the clause the same as it was before:
WHERE r.regionID IN (cfqueryparam value=#Session.regionList# list=yes
cfsqltype=_)
As long as the variables. session.regionList is comma-delimeted, otherwise,
WHERE r.regionID IN (cfqueryparam value=#Session.regionList# list=yes
separator=myDelimeter cfsqltype=_)
You're definately close to solving this.
hth
Charlie Hanlon
- Original Message -
From: Roberto Perez [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, March 03, 2006 4:57 PM
Subject: Re: using WHERE with ValueList?
At 04:31 PM 3/3/2006, you wrote:
Sureset a var called SESSION.RegionList =
ValueList(myquery.myColumn) (when
needed).then always use the session var in your IN clause without the
ValueList() function
Mmm... that didn't work, it's the same issue I was having when I
started: it runs, but it does not find any match (recordCount returns
0). This is the WHERE clause:
WHERE r.regionID IN ('#Session.regionList#')
I can always add a previous query to get all regions for a given
user, and plug that in with the myQuery.myColumn format, but if I can
save a query, I'd like to.
Thanks,
Roberto
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234142
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Ranking SQL records
If you are able to have a normalized data set of 'business_titles', you could set up an db table, say tbl_business_titles - titleid - title - sort rank then, in your main table, you store the id of the business title, thus all records in the main table could be sorted by business_title and the sort rank would be stored in 'tbl_business_titles' hth charlie hanlon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Round Behavior
-36.0 || -35.9 || -35.8 || -35.7 || -35.6 -35.5 -35.4 || -35.3 || -35.2 || -35.1 || -35.0 The number, negative 35.6, should get rounded up to negative 36. hth charlie hanlon - Original Message - From: Ian Skinner [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 14, 2006 2:35 PM Subject: RE: CF Round Behavior Ok. Then, why -35.6 does not round up to -35 ? #Round(-35.6)# actually shows -36. That kinda confuses me. Thanks, Pine Because it is closer to -36, it is the mirror image of +35.4 rounding to 35. The middle .5 is the special case that is always rounded up (ie in the positive direction). Rounding from -35.5 to -36 would be down (ie in the negative direction). It all goes back to that number line thing. -5 -4 -3 -2 -1 0 +1 +2 +3 +4 +5 Rounding of 1/2 will always be to the right, the positive direction. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Efflare ImageCR3
Greetings All, Anyone out there utilitizing Efflare's ImageCR3 and come accross the following error: Access violation at address 77FCB0C8 in module 'ntdll.dll'. Write of address CC99 and could provide some insight into this. thanks in advance, charlie hanlon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231914 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: input box selection
http://oil.cfwebtools.com/newshome.cfm?news_id=51action=emailstory Jason, I viewed source on the url above, saved it locally and then ran that page in my browser and had no problems inputting data into the form fields. Not sure what this means. Additionally, at the URL above, I put my cursor in the keyword search on the left, and was able to tab over to the email form input. Take a look at the location of your form /form tags and make sure they are not crossing each other up..not alot of information here, but hopefully it leads you to a discovery. Charlie Hanlon - Original Message - From: Jason Herbolsheimer [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 07, 2006 5:05 PM Subject: input box selection I'm currently developing a site that has a very simple form(2 email addresses, Name and comments). The problem I'm having is that I'm unable to click on any of the text boxes to place the cursor inside of it, unless you hover exactly over the top portion of the text box (your arrow will go to a cursor). Below is a url to the page I'm having this issue on. If someone out there has encountered this problem before and found has a solution I would greatly appreciate your help, or if someone knows what might be wrong I would also appreciate your help as well. http://oil.cfwebtools.com/newsHome.cfm?news_id=51 Thanks in advance, Jason Herbolsheimer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL and IDArray
I rec'd an email regarding an error with one of my apps, here is the SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 8: Incorrect syntax near 'IDArray'. SQL = SELECT someFields FROM myTable i WHERE i.uniqueID = '' IDArray[index] '' Data Source = myDSN Was someone trying to tamper with my app and if so, what are the implications of IDArray. thanks in advance for some insight into this. charlie hanlon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL and IDArray
I may not have been clear. My global error handler sends the emails to my address. My sites throw errors, I fix them. In this case, I noticed the WHERE i.uniqueID = '' IDArray[index] '' within the error message that I rec'd. I am assuming that the site visitor substituted IDArray[index] where the url.id would have been, something like mypage.cfm?id=40 mypage.cfm?id=IDArray[index] I have added a cfqueryparam to the sql statement, but am inquiring as to wheter this was an attempted hack charlie ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231123 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Question regarding sql updates with datefields
I was curious as to whether the following code is the best way to handle updating datetime fields (SQL 2000). I use the isdate() function to verify that my variable is indeed a date, and then update the db field with the CreateODBCDate() function..is there another way I should be doing this?? thanks in advance for any advice or confirmation. cfquery name=myQuery datasource=myDSN UPDATE myTable SET myField = cfqueryparam value=#left(someValue,250)# cfsqltype=CF_SQL_VARCHAR cfif isdate(trim(attributes.publishdate)) , publishdate = #CreateODBCDate(attributes.publishdate)# /cfif cfif isdate(trim(attributes.unpublishdate)) , unpublishdate = #CreateODBCDate(attributes.unpublishdate)# /cfif WHERE myPKid = cfqueryparam value=#val(id)# cfsqltype=CF_SQL_INTEGER /cfquery charlie hanlon food service enablers, inc. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230617 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT about CSS
According to http://www.w3schools.com/css/css_pseudo_classes.asp,
Note: a:hover MUST come after a:link and a:visited in the CSS definition in
order to be effective!!
Note: a:active MUST come after a:hover in the CSS definition in order to be
effective!!
Note: Pseudo-class names are not case-sensitive.
here is the example they provide:
a:link {color: #FF} /* unvisited link */
a:visited {color: #00FF00} /* visited link */
a:hover {color: #FF00FF} /* mouse over link */
a:active {color: #FF} /* selected link */
hth
charlie hanlon
- Original Message -
From: Claude Schneegans [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 27, 2006 3:28 PM
Subject: OT about CSS
I know this list is about CF, but I cannot find any populated group
about CSS,
and well... good developers are here anyway ;-)
My question is: is it specified somewhere in the docs that pseudo styles
for links
should be given in any specific order, and why?
In the code below, the link in the blue paragraph becomes red when the
mouse passes over,
but the A:hover spec is simply ignored if it is not the last one.
html
head
titleUntitled/title
STYLE
P.blue {color:blue}
P.blue A:link {color:green}
P.blue A:visited {color:green}
P.blue A:hover {color:red}
/STYLE
/head
body
PParagraph with a A HREF=#link/A/P
P CLASS=blueBlue Paragraph with a A HREF=#link/A/P
/body
/html
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230622
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfinput problem
Larry, First, this cfinput is inside of a cfform and not just a form tag, otherwise, the 'required' attribute will not take affect. Second, you may need to trim(SESSION.User.INSTITUT) the session variable before dropping into the 'value' attribute. hth Charlie Hanlon - Original Message - From: Stephens, Larry V [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, January 25, 2006 2:41 PM Subject: cfinput problem cfinput type=text name=INSTITUT size=40 value=#SESSION.User.INSTITUT# maxlength=75 required=yes message=You must enter your organization. Why is required not being enforced? It has worked in other pieces of code. I could understand it if the variable had data in it but in an instance where we have a new registrant SESSION.User.INSTITUT is set to Is the very fact that I have a value= statement bypassing the required statement? Larry V. Stephens Office of Risk Management 812-855-9758 [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230440 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
fileexists()
When using cfif fileexists(variables.myFileName), does the variable need to be in quotes or surrounded by pounds signs? thanks in advance, Charlie Hanlon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing for an undefined date
I have had difficulty trusting the isDate() function also. I fell back to
using
cfif isdefined(whatsnew.event_date) and len(trim(whatsnew.event_date))
gt 0
take action
/cfif
Charlie Hanlon
- Original Message -
From: daniel kessler [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 13, 2006 1:28 PM
Subject: Re: testing for an undefined date
It still seems to be enacting the code. I also tried cfif
isDefined('whatsnew.event_date')
I guess it's a date but an empty date or something like that since isDate
didn't help.
cfif isDate(whatsnew.event_date)
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229495
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfloop vs cfoutput query - best practice
First, thanks to all who communicate via cf_talk. I have learned alot about my trade from all of the contributors. While its a rare occurance, when I am able to provide insight regarding someone's inquiry, I do so. My question is, if I need to loop thru a query result set and will be not displaying the data, is it better practice/more efficient to use cfloop query= instead of cfoutput query=??? thanks in advance charlie hanlon developer food service enablers, inc. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227119 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Employee name
Robertthis should work, though there may be a more optimal way of writing the select clause cfquery name=getname datasource=name select left(employee_fname,1)+employee_lname AS name from employees /cfquery hth Charlie Hanlon - Original Message - From: Orlini, Robert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 06, 2005 2:55 PM Subject: Employee name How do I trim the letters of an employee's first name (employee_fname) to the first letter and then add it to the letters of their last name (employee_lname)? For example, John Smith edited and then copied to a username field as JSMITH. I'm assuming its a RTRIM. Here is the code I have to work with: cfquery name=getname datasource=name select employee_fname, employee_lname from employees Thanks. Robert at HWW -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226295 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Question regarding closing tags
I have noticed in many code samples that I see/learn from, the use of a forward-slash in this fashion cfset variables.myVar = someValue / I understand that this represents that this particular tag has no closing tag. Is this a habit I should adopt in my coding and if so, should I use this syntax on every cf tag that does have its respective closing tag. For example, the cfparam tag cfparam name=scope.myVar default= / thanks in advance charlie Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224967 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Search results help?
Les, cfset client.srchRsltsIDs = ValueList(myQuery.id) then, on the item view pages: cfparam name=client.srchRsltsIDs default= cfparam name=url.id default= cfif ListFind(client.srchRsltsIDs,url.id) EQ 0 cflocation url=search.cfm addtoken=no /cfif And then using some list functions you will be able to get the next and previous ids out of the client.srchRsltsIDs variable. hth Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Les Irvin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, November 14, 2005 2:09 PM Subject: Search results help? I have created a search page which may return, for example, 20 records referenced by ID numbers. I'd like the user to be able to browse through the result set one at a time - a page for each record in the set. How do I maintain and reference that set of ID numbers as the user browses across many html pages? I've put the result set into an array but can't figure out how to reference the array across the pages. Am I way off base in my approach? Thanks in advance, Les ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224115 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfinclude problem
Dan, My assumption is that with the cfinclude template=/ , that the initial / signifies a directory mapping set-up in the ColdFusion administrator. If the 'includes' folder is OK, then that folder is mapped in the adminstrator, while the 'common' folder is not. Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: daniel kessler [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 11, 2005 9:38 AM Subject: cfinclude problem I have a problem cfincluding a file. One include works but the second one doesn't. Here it is: cfinclude template=/includes/head.cfm cfinclude template=/common/return_url_set.cfm The head.cfm include works fine. the return_url_set does not. I checked that it's the correct path. I found an include for another file in the 'common' directory and tried to include that path and it also doesn't work. I put some extra blank lines in the included files hoping some extra white space would help (seen it before), but nope. I separated the two includes by adding a blank line, but also nope. ok, I made it a more relative url by changing it to ../common/return_url_set.cfm and it works. So why does the / work on one file and not the other? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfinclude problem
Based on your statement that the included files where cfinclude template=/includes/* / are included, while the cfinclude template=/common/* / are not included...possibly indicates that a mapping has been made for the 'includes' folder, but not the 'common' folder. Is there any way to find out from the host if there are any such mappings Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: daniel kessler [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 11, 2005 10:15 AM Subject: Re: cfinclude problem I didn't do any special mapping in cfAdmin because it's shared hosting and I have no access to any admin tools. / is (and has always been) a built-in CF mapping (defined in the CF Admin) that goes to the root of the site. So if this is the case then why wouldn't it work? Sounds like you're saying that it should. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223957 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfinclude problem
Sean If 'recent releases do not define / as a mapping in the admin', then what do they define the / as?? thanks Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Sean Corfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 11, 2005 11:38 AM Subject: Re: cfinclude problem On 11/11/05, Charlie Griefer [EMAIL PROTECTED] wrote: / is (and has always been) a built-in CF mapping (defined in the CF Admin) that goes to the root of the site. It may have been in the past but recent releases do not define / as a mapping in the admin and, in fact, having that mapping can cause problems, especially on shared hosting, because it hijacks any path beginning with / (e.g., /index.cfm). I'd say the problem here is exactly what Ryan Guill said: someone on your shared server has a mapping for /common and it's hijacking your includes. -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223963 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find no records
Try this code. cfquery name=GetPromoters datasource=user020 SELECT u.userID,u.firstName,u.lastName,u.emailAddress,u.password FROM tbl_020publicUsers u WHERE (SELECT count(*) FROM tbl_020eventDetails e WHERE e.userID = u.userID) = 0 /cfquery Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, November 02, 2005 4:50 PM Subject: Find no records Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222978 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# !--- join tables --- AND e.musicGenreID = m.musicgenreid ORDER BY e.eventDate ASC /cfquery Try this. I think you are getting mulitple records because you're original query did not join the two tables in you're 'From' clause. rgds, Charlie Hanlon - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 26, 2005 9:49 AM Subject: Simple SQL Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Any help I'd be grateful, Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:97 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
John Paul, You stated I'd *always* use the SQL standard of explictly stating the joins instead of just letting the db figure it out Is this a best practice that I should adopt. I am self-taught and am not aware that explictly joining the tables is more efficient than joining the tables in the 'Where' clause'. thanks in advance for your clarification/confirmation... rgds, Charlie Hanlon - Original Message - From: John Paul Ashenfelter [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 26, 2005 9:59 AM Subject: Re: Simple SQL On 10/26/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Are you getting a cross join? Sounds like it -- I don't see what relates the tables in your query. I'd *always* use the SQL standard of explictly stating the joins instead of just letting the db figure it out SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, INNER JOIN tbl_020musicGenres m ON (whatever relates the tables) WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF/JavaScript help on signup
cfif not logon.recordcount script type=text/javascript language=JavaScript alert(In-Valid Login Message); /script cfinclude template= display_login_page.cfm /cfif hth Elena Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Aminova, Elena [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 24, 2005 5:20 PM Subject: CF/JavaScript help on signup Please advise what I can do in Cold Fusion, perhaps using JavaScript? I have a login page and on it, I need when the user enters wrong username and/or password which don't match up in the DB, I need to pop up or display a user friendly message that the entry does not match up, doesn't matter what the message is. Right now I just do this in the login processing page: cfif not logon.recordcount(logon is the query that checks the DB if there are any records with the form inputed username and password) !--- Need to display or Pop up a message that the users username and password dont match/ are not correct --- cfinclude template= display_login_page.cfm cfabort PLEASE HELP!!! Thanks. Elena ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222124 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
