Re: Date Range Search Problem - when it's integers stored and not dates
This is ugly and uses T-SQL syntax but you get the idea. SELECT id FROM ( SELECT id, CAST( CAST(year AS varchar) + '-' + CAST(CASE month WHEN 0 THEN 1 ELSE month END AS varchar) + '-' + CAST(CASE day WHEN 0 THEN 1 ELSE day END AS varchar) AS datetime) as realdate FROM aaa ) tmpT WHERE realdate BETWEEN '2006-01-01' AND '2007-05-05' On Mon, Mar 24, 2008 at 4:06 PM, Les Mizzell [EMAIL PROTECTED] wrote: I've got a database in which dates are stored as integers in three separate columns as: day|month|year This was done because the client wished to create records that could contain only a year, or just a year and month, or year, month, and day, or no date at all. Values in the columns default to 0 if nothing was entered. Bad idea. Really bad idea! Worked great at first, but as 'feature creep has slowly reared its ugly head, this way of storing dates has caused me no end of headaches. They want to add a date search by range. So, you'd want to do something like: and YEAR = #form.from_y# and YEAR = #form.to_y# and MONTH = #form.from_m# and MONTH = #form.to_m# and DAY = #form.from_d# and DAY = #form.to_d# So, let's say you have four records day|month|year 15 | 05 |2005 16 | 04 |2006 15 | 03 |2007 0 | 01 |2006 Uh oh - that's not going to work. For example, searching for dates between 05/15/2006 and 04/16/2007 is looking at *integers* in the month column greater than 5 *and* less than 4, plus integers in the day column greater then 15 but less than 16. Whoops, no results returned. I've gotten myself into this mess. Is there any trick I can use in the queries to get myself out, or am a @[EMAIL PROTECTED] I should have NEVER let them talk me into letting them enter records without *complete* dates - but, the client is always right, huh? But, that was almost a year ago and they weren't asking for a date range search at the time either.. Argh! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New To CF
On Sunday 23 Mar 2008, Bruce Kersten wrote: How do I get version 8? Adobe.com :-) Is it free? To develop on yes. To deploy in production no. There are non-Adobe ColdFusion servers (BlueDragon is open source, Railo is free for one web site) too. -- Tom Chiverton Helping to assertively brand interdependent models on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Date Range Search Problem - when it's integers stored and not dates
Les Mizzell wrote: I've got a database in which dates are stored as integers in three separate columns as: day|month|year This was done because the client wished to create records that could contain only a year, or just a year and month, or year, month, and day, or no date at all. Values in the columns default to 0 if nothing was entered. Bad idea. Really bad idea! Worked great at first, but as 'feature creep has slowly reared its ugly head, this way of storing dates has caused me no end of headaches. They want to add a date search by range. In SQL that is easy with a row-wise comparison: WHERE ROW(2008, 3, 25) ROW(year, month, day) AND ROW(2008, 3, 28) ROW(year, month, day) The problem is your rows with a 0 in them. Under which conditions should they match? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
best google indexing mode for my coldfusion site
Hi all, how can i do to best index my site by google pagerank. I have a site with the index.cfm page that calls all dinamic content with url parameters (es. index.cfm?page=mypage1param) tnk u all ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
best google indexing
Hi all, how can i do to best index my site by google pagerank. I have a site with the index.cfm page that calls all dinamic content with url parameters (es. index.cfm?page=mypage1param) tnk u all ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Checkboxes not passing variables correctly
I have a group of 10 checkboxes where 3 have to be checked. I have a JS script to validate this. The issue at hand is the values are not being passed completely. If you choose Robert Mckenzie the name is passed Robet Mkenzie, any ideas would be appreciated. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best google indexing
On Tuesday 25 Mar 2008, Davide Campo wrote: I have a site with the index.cfm page that calls all dinamic content with url parameters (es. index.cfm?page=mypage1param) This doesn't matter. -- Tom Chiverton Helping to globally reintermediate fine-grained e-services on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: best google indexing
This doesn't matter. Yep - good content for better search indexing. Dominic On 25/03/2008, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 25 Mar 2008, Davide Campo wrote: I have a site with the index.cfm page that calls all dinamic content with url parameters (es. index.cfm?page=mypage1param) This doesn't matter. -- Tom Chiverton Helping to globally reintermediate fine-grained e-services on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
Steve, We want to help, but without seeing the form code it is almost impossible to troubleshoot. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Steve LaBadie wrote: I have a group of 10 checkboxes where 3 have to be checked. I have a JS script to validate this. The issue at hand is the values are not being passed completely. If you choose Robert Mckenzie the name is passed Robet Mkenzie, any ideas would be appreciated. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checkboxes not passing variables correctly
This is the script to check for 3 checked boxes:
script
function is_checked() {
var formObj = document['internships']['fac'];
var count = 0;
for (i=0;iformObj.length; i++) {
if(formObj[i].type == 'checkbox')
if(formObj[i].checked)
count++;
}
if (count 3) {
return false;
}else {
return true;
}
}
function val(){
if (!is_checked()){
alert('You Must Choose 3 Faculty Supervisors');
return false;
}else {
return true;
}
}
/script
trtd align=right valign=topstrongFaculty
Supvisor:/strongnbsp;br /font style=color: #BD2925; font-size:
xx-small;(Choose 3)/fontnbsp;/tdtd
input type=checkbox name=fac value=Joseph Ashcroft /nbsp;Joseph
Ashcroftbr /
input type=checkbox name=fac value=Paul Lippert /nbsp;Paul
Lippertbr /
input type=checkbox name=fac value=Charles Warner /nbsp;Charles
Warnerbr /
input type=checkbox name=fac value=Marcia Godich /nbsp;Marcia
Godichbr /
input type=checkbox name=fac value=Andrea McClanahan
/nbsp;Andrea McClanahan/td
tdinput type=checkbox name=fac value=Glenn Geiser-Getz
/nbsp;Glenn Geiser-Getzbr /
input type=checkbox name=fac value=Robert McKenzie /nbsp;Robert
McKenziebr /
input type=checkbox name=fac value=Wenji Yan /nbsp;Wenjie
Yanbr /
input type=checkbox name=fac value=Patricia Kennedy
/nbsp;Patricia Kennedybr /
input type=checkbox name=fac value=Cem Zeytinoglu /nbsp;Cem
Zeytinoglu
/td/tr
Action page:
Faculty Supervisor: cfloop list=#form.fac# index=f
delimiters=crlf#f#/cfloop
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
Steve LaBadie wrote:
I have a group of 10 checkboxes where 3 have to be checked. I have a
JS
script to validate this. The issue at hand is the values are not being
passed completely.
If you choose Robert Mckenzie the name is passed Robet Mkenzie, any
ideas would be appreciated.
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.esu.edu http://www.esu.edu
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301999
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Memory discrepancy
We are running CFMX 8 in a Jrun4 (updater7) instance using java 1.6 under Win2k3. When I run the Server Monitor or even Jprofiler on the instance for example they both report 125,000 in use. However, when I look at Windows Task Manager the Jrun process reports around 225,000. Why the difference? One of the things we have noticed is that over time the amount windows reports grows. Yet internally it does not. Anyone seen this behavior? Any ideas what is going on? thanks in advance! - Alex OK... Well my instance ran out of memeory Java.lang. out of memeory: Java Heap Which is set at 1.2g Which should be more then adaquate. CHeckout what happened in the logs: 03/24 18:49:22 metrics Web threads (busy/total): 0/5 Sessions: 2640 Total Memory=1299840 Free=1132810 03/24 18:50:22 metrics Web threads (busy/total): 0/4 Sessions: 2640 Total Memory=1299840 Free=1128173 03/24 18:51:22 metrics Web threads (busy/total): 25/57 Sessions: 2637 Total Memory=1299840 Free=1115280 03/24 18:52:22 metrics Web threads (busy/total): 25/57 Sessions: 2626 Total Memory=1299840 Free=600673 03/24 18:53:22 metrics Web threads (busy/total): 25/57 Sessions: 2615 Total Memory=1299840 Free=600612 03/24 18:54:22 metrics Web threads (busy/total): 25/57 Sessions: 2602 Total Memory=1299840 Free=606314 03/24 18:55:22 metrics Web threads (busy/total): 25/57 Sessions: 2598 Total Memory=1299840 Free=606632 03/24 18:56:22 metrics Web threads (busy/total): 2/57 Sessions: 2610 Total Memory=1299840 Free=59994 Would Jprofiler help me to see what is going internally the next time this happens? Any suggestions would be appreciated. thanks! - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Memory discrepancy
It appears that 1.2GB isn't adequate. If you are on CF 8 Enterprise (or you can copy the code to a CF 8 Developer server) you can use the memory monitor to closely profile the memory usage on the server and find what's chewing up the heap. On Tue, Mar 25, 2008 at 11:14 PM, Alex DeMarco [EMAIL PROTECTED] wrote: OK... Well my instance ran out of memeory Java.lang. out of memeory: Java Heap Which is set at 1.2g Which should be more then adaquate. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Search opinion needed
We have a verity search that searches db and docs. They want to combine the results and then sort by relevance then date. I have done the combination before by just putting it in a structure. Any better ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Google geocoder and CF5
My guess is that it's an encoding problem. Use an HTTP sniffer/recording proxy/whatever to see what's different. Yeah, this is what I suspect also. I'm considering using another format to access their geocoder. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
No, there's nothing there that would explain it. I'd like to blame it on
the font tags, but I can't;)
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Steve LaBadie wrote:
This is the script to check for 3 checked boxes:
script
function is_checked() {
var formObj = document['internships']['fac'];
var count = 0;
for (i=0;iformObj.length; i++) {
if(formObj[i].type == 'checkbox')
if(formObj[i].checked)
count++;
}
if (count 3) {
return false;
}else {
return true;
}
}
function val(){
if (!is_checked()){
alert('You Must Choose 3 Faculty Supervisors');
return false;
}else {
return true;
}
}
/script
trtd align=right valign=topstrongFaculty
Supvisor:/strongnbsp;br /font style=color: #BD2925; font-size:
xx-small;(Choose 3)/fontnbsp;/tdtd
input type=checkbox name=fac value=Joseph Ashcroft /nbsp;Joseph
Ashcroftbr /
input type=checkbox name=fac value=Paul Lippert /nbsp;Paul
Lippertbr /
input type=checkbox name=fac value=Charles Warner /nbsp;Charles
Warnerbr /
input type=checkbox name=fac value=Marcia Godich /nbsp;Marcia
Godichbr /
input type=checkbox name=fac value=Andrea McClanahan
/nbsp;Andrea McClanahan/td
tdinput type=checkbox name=fac value=Glenn Geiser-Getz
/nbsp;Glenn Geiser-Getzbr /
input type=checkbox name=fac value=Robert McKenzie /nbsp;Robert
McKenziebr /
input type=checkbox name=fac value=Wenji Yan /nbsp;Wenjie
Yanbr /
input type=checkbox name=fac value=Patricia Kennedy
/nbsp;Patricia Kennedybr /
input type=checkbox name=fac value=Cem Zeytinoglu /nbsp;Cem
Zeytinoglu
/td/tr
Action page:
Faculty Supervisor: cfloop list=#form.fac# index=f
delimiters=crlf#f#/cfloop
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
Steve LaBadie wrote:
I have a group of 10 checkboxes where 3 have to be checked. I have a
JS
script to validate this. The issue at hand is the values are not being
passed completely.
If you choose Robert Mckenzie the name is passed Robet Mkenzie, any
ideas would be appreciated.
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.esu.edu http://www.esu.edu
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302004
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Search opinion needed
Use a Query of a Query to join the two search results and sort as needed. m!ke -Original Message- From: Stone, Lori [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 8:31 AM To: CF-Talk Subject: Search opinion needed We have a verity search that searches db and docs. They want to combine the results and then sort by relevance then date. I have done the combination before by just putting it in a structure. Any better ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checkboxes not passing variables correctly
This script work correctly, try it.
cfif isDefined(Form.submit)
cfloop list=#form.fac# index=f
delimiters=crlfcfoutput#f#/cfoutput/cfloop
/cfif
form name=internships action= onsubmit=return val() method=post
script
function is_checked() {
var formObj = document['internships']['fac'];
var count = 0;
for (i=0;iformObj.length; i++) {
if(formObj[i].type == 'checkbox') {
if(formObj[i].checked) count++;
}
}
if (count 3) {
return false;
}else {
return true;
}
}
function val(){
if (!is_checked()){
alert('You Must Choose 3 Faculty Supervisors');
return false;
}else {
return true;
}
}
/script
trtd align=right valign=topstrongFaculty Supvisor:/strong br
/font style=color: #BD2925; font-size: xx-small;(Choose 3)/font
/tdtd
br /
input type=checkbox name=fac value=Joseph Ashcroft / Joseph Ashcroftbr
/ input type=checkbox name=fac value=Paul Lippert / Paul Lippertbr /
input type=checkbox name=fac value=Charles Warner / Charles Warnerbr
/ input type=checkbox name=fac value=Marcia Godich / Marcia Godichbr
/ input type=checkbox name=fac value=Andrea McClanahan / Andrea
McClanahanbr
input type=checkbox name=fac value=Glenn Geiser-Getz / Glenn
Geiser-Getzbr / input type=checkbox name=fac value=Robert McKenzie /
Robert McKenziebr / input type=checkbox name=fac value=Wenji Yan /
Wenjie Yanbr / input type=checkbox name=fac value=Patricia Kennedy /
Patricia Kennedybr / input type=checkbox name=fac value=Cem Zeytinoglu
/ Cem Zeytinoglu
/td/tr
input type=submit value=submit name=submit /
/form
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302006
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
Faculty Supervisor: cfloop list=#form.fac# index=f delimiters=crlf#f#/cfloop that's your problem - your list delimiters. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Steve LaBadie wrote: I have a group of 10 checkboxes where 3 have to be checked. I have a JS script to validate this. The issue at hand is the values are not being passed completely. If you choose Robert Mckenzie the name is passed Robet Mkenzie, any ideas would be appreciated. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best google indexing
good content for better search indexing. And also, being referred by sites having a high rank will increase your rank. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates
Ok, how about this, a bit ugly, but should work on any database: WHERE (YEAR #form.from_y# OR (YEAR = #form.from_y# AND (MONTH = 0 OR (MONTH = #form.from_m# AND (DAY = 0 OR DAY = #form.from_d#) AND (YEAR #form.to_y# OR (YEAR = #form.to_y# AND (MONTH = 0 OR (MONTH = #form.to_m# AND (DAY = 0 OR DAY = #form.to_d#) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
delimiters=crlf You're using crlf as delimitior? No wonder c, r, l f are lost. You probably meant CR LF, but these are not the delimiters used to separate field values, the simple comma is used. So just use Faculty Supervisor: cfloop list=#form.fac# index=f#f#/cfloop or more simply: Faculty Supervisor: #form.fac# -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Memory discrepancy
I'm not sure I would get hung up on what windows task manager reports vs. the server monitor or Jprofiler. Looking at this log it appears that the number of simultaneous requests is set at 25. When 25 is reached all other threads begin to queue. It goes from 0/5 (0 running requests out of 5 total) to 25/57 (25 running requests and 57 threads total). Whatever happened basically Froze all requests and is keeping them from completing. Typical culprits are the database server, driver and/or network. Eventually all these threads hung or queued will kill your memory - but that does not mean you have a memory issue. The question to ask is - why are my threads queuing? Your memory may well be adequate if you can solve the mystery of the hanging requests :) The server monitor should give you some clues - but if everything is failing all at once the problem is likely something very global that affects every request - like the NIC card resynching it's speed or the DB server being unavailable temporarily or a file system that is having IO problems. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Alex DeMarco [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 9:15 AM To: CF-Talk Subject: Re: Memory discrepancy We are running CFMX 8 in a Jrun4 (updater7) instance using java 1.6 under Win2k3. When I run the Server Monitor or even Jprofiler on the instance for example they both report 125,000 in use. However, when I look at Windows Task Manager the Jrun process reports around 225,000. Why the difference? One of the things we have noticed is that over time the amount windows reports grows. Yet internally it does not. Anyone seen this behavior? Any ideas what is going on? thanks in advance! - Alex OK... Well my instance ran out of memeory Java.lang. out of memeory: Java Heap Which is set at 1.2g Which should be more then adaquate. CHeckout what happened in the logs: 03/24 18:49:22 metrics Web threads (busy/total): 0/5 Sessions: 2640 Total Memory=1299840 Free=1132810 03/24 18:50:22 metrics Web threads (busy/total): 0/4 Sessions: 2640 Total Memory=1299840 Free=1128173 03/24 18:51:22 metrics Web threads (busy/total): 25/57 Sessions: 2637 Total Memory=1299840 Free=1115280 03/24 18:52:22 metrics Web threads (busy/total): 25/57 Sessions: 2626 Total Memory=1299840 Free=600673 03/24 18:53:22 metrics Web threads (busy/total): 25/57 Sessions: 2615 Total Memory=1299840 Free=600612 03/24 18:54:22 metrics Web threads (busy/total): 25/57 Sessions: 2602 Total Memory=1299840 Free=606314 03/24 18:55:22 metrics Web threads (busy/total): 25/57 Sessions: 2598 Total Memory=1299840 Free=606632 03/24 18:56:22 metrics Web threads (busy/total): 2/57 Sessions: 2610 Total Memory=1299840 Free=59994 Would Jprofiler help me to see what is going internally the next time this happens? Any suggestions would be appreciated. thanks! - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Date Range Search Problem - when it's integers stored and not dates
Lez, this has been asked, but not answered. What do the zeros mean? Do they indicate a date range? Does 2007.0.0 mean the entire year of 2007? Does 2007.10.0 mean the entire month of October in 2007? Does 0.0.0 mean always? If so, I'd create two date columns, begin_dt and end_dt. I'd then write SQL scripts to populate those columns. On Tue, Mar 25, 2008 at 9:51 AM, Claude Schneegans [EMAIL PROTECTED] wrote: Ok, how about this, a bit ugly, but should work on any database: WHERE (YEAR #form.from_y# OR (YEAR = #form.from_y# AND (MONTH = 0 OR (MONTH = #form.from_m# AND (DAY = 0 OR DAY = #form.from_d#) AND (YEAR #form.to_y# OR (YEAR = #form.to_y# AND (MONTH = 0 OR (MONTH = #form.to_m# AND (DAY = 0 OR DAY = #form.to_d#) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checkboxes not passing variables correctly
Is there a list of all possible delimiters value? If I use your suggestion there are no spaces or commas between full names when the information is sent. If I use delimiters=| there is a comma but no space after comma. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 9:59 AM To: CF-Talk Subject: Re: Checkboxes not passing variables correctly delimiters=crlf You're using crlf as delimitior? No wonder c, r, l f are lost. You probably meant CR LF, but these are not the delimiters used to separate field values, the simple comma is used. So just use Faculty Supervisor: cfloop list=#form.fac# index=f#f#/cfloop or more simply: Faculty Supervisor: #form.fac# -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
What is your desired output? If you just want a straight list with commas between the chosen names, then do as Claude said: Faculty Supervisor: #form.fac# If you need line breaks between the names, then do a loop as Claude said (with a br/ added): cfloop list=#form.fac# index=f #f#br/ /cfloop On Tue, Mar 25, 2008 at 9:12 AM, Steve LaBadie [EMAIL PROTECTED] wrote: Is there a list of all possible delimiters value? If I use your suggestion there are no spaces or commas between full names when the information is sent. If I use delimiters=| there is a comma but no space after comma. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 9:59 AM To: CF-Talk Subject: Re: Checkboxes not passing variables correctly delimiters=crlf You're using crlf as delimitior? No wonder c, r, l f are lost. You probably meant CR LF, but these are not the delimiters used to separate field values, the simple comma is used. So just use Faculty Supervisor: cfloop list=#form.fac# index=f#f#/cfloop or more simply: Faculty Supervisor: #form.fac# -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
If you just want the list of names, separated by comma and space, then use: Faculty Supervisor: #Replace(form.fac ,all)# On Tue, Mar 25, 2008 at 9:12 AM, Steve LaBadie [EMAIL PROTECTED] wrote: Is there a list of all possible delimiters value? If I use your suggestion there are no spaces or commas between full names when the information is sent. If I use delimiters=| there is a comma but no space after comma. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 9:59 AM To: CF-Talk Subject: Re: Checkboxes not passing variables correctly delimiters=crlf You're using crlf as delimitior? No wonder c, r, l f are lost. You probably meant CR LF, but these are not the delimiters used to separate field values, the simple comma is used. So just use Faculty Supervisor: cfloop list=#form.fac# index=f#f#/cfloop or more simply: Faculty Supervisor: #form.fac# -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checkboxes not passing variables correctly
Is there a list of all possible delimiters value? There only one delimiter: the comma, which is the default delimiter for all list functions, so you don't need to specify one. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checkboxes not passing variables correctly
Is there a list of all possible delimiters value? If you want to know more about forms and how values are passed, use CFDUMP var=#form# in your action template and you'll know everything a young lady should know before wedding ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checkboxes not passing variables correctly
Thanks everyone for your input and wisdom. Thanks Claude for the laugh. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 10:30 AM To: CF-Talk Subject: Re: Checkboxes not passing variables correctly Is there a list of all possible delimiters value? If you want to know more about forms and how values are passed, use CFDUMP var=#form# in your action template and you'll know everything a young lady should know before wedding ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Search opinion needed
Michale's QofQ is a good idea - but don't forget you can search multiple collections at once. On Tue, Mar 25, 2008 at 8:31 AM, Stone, Lori [EMAIL PROTECTED] wrote: We have a verity search that searches db and docs. They want to combine the results and then sort by relevance then date. I have done the combination before by just putting it in a structure. Any better ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ImageGetIPTCMetadata not returning metadata
Hi, Has anyone seen any issues with ImageGetIPTCMetadata not actually getting the IPTC Metadata? I have some images created using PhotoShop CS3. We put IPTC metadata in them but CF does not pull it out. I can even look at the file properties in windows and see more data than CF is extracting. Thanks, --Dave blog.dkferguson.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Solved - String Issue
Last Friday I posted a problem that I was having and with the help of
Hatton, who got me pointed in the right direction, and Leigh (his posts
show up as CS) who extended it a bit, it is now working. I am going to
post the results here but I will quickly explain what I was doing.
There are a series of forms that are pulled from a database using an CMS
system. When the forms are submitted, the user wanted a PDF emailed that
looks exactly like the form, except of course the input elements are
replaced with the submitted values. The easy way out would be to create
a separate action page for each form, but that was not the solution they
were looking for. Basically I needed everything to go to one file, and
regardless of what form was submitted, the same file processes each one.
The biggest headache was that all the forms are checklists, and thus
each row has three radio buttons. There are also some forms with text
fields, text areas and select lists. I could extract the text and even
get the filled values to show up, but I could not get the cells to line
up with their respective columns (a radio in column three, cell 1 would
show up in column one, cell 1 and crap like that). So anyway, like I
said, Leigh got it to work for me and I want to post the information in
case anyone else runs across this issue.
Bruce
cfloop query=getContentObjectData
!--- Now we need strip out all the form elements and replace
them with what was submitted ---
!--- first remove open/close form tags ---
cfset NewContentBlock =
REReplace(contentBlock,/*form[^]*,,ALL)
!--- Remove the hidden fields, otherwise they show up in the
header ---
cfset NewContentBlock =
#REReplaceNoCase(NewContentBlock,'input\s+[^]*hidden[^]*', ,ALL)#
!--- get an array of all input tags ---
cfset matches = reMatchNoCase('input\s+[^]*', NewContentBlock)
!--- for each input field ... ---
cfloop array=#matches# index=element
!--- initialize a structure for storing input field
properties ---
cfset htmlField = {}
!--- extract field properties: name, value AND type (if
exists) ---
cfset params =
reMatchNoCase('((name|value|type)=\[^\]*\)', element)
cfloop array=#params# index=pair
cfif listLen(pair, =)
cfset htmlField[listFirst(pair, =)] =
replace(listLast(pair, =), '', , all)
/cfif
/cfloop
!--- verify this field was submitted in the current form ---
cfset fieldExists = structKeyExists(htmlField, name) AND
structKeyExists(form, htmlField.name)
cfset isRadioButton = structKeyExists(htmlField, type)
AND htmlField.type is radio
!--- if the field exists ... ---
cfset newValue =
cfif fieldExists
cfif isRadioButton
!--- AND it was the selected button, replace it
with an X ---
cfif structKeyExists(htmlField, value) AND
htmlField.value EQ form[htmlField.name]
cfset newValue = x
cfelse
cfset newValue = nbsp; !--- This is done
so that the form looks like the original, except instead of an X we
enter a non-breaking space ---
/cfif
!--- otherwise, assume it is a text field and replace
it with the field value ---
cfelse
cfset newValue = form[htmlField.name]
/cfif
/cfif
! do the actual replace ---
cfset NewContentBlock = reReplaceNoCase(NewContentBlock,
element, newValue, 'all')
/cfloop
/cfloop
Once this is done I put everything inside a cfsavecontent tag, then use
CFDOCUMENT and create the PDF on the file system, and then attach it to
an email.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302021
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
turn the coldfusion query into sql stored procedure or view
I have a cooldfusion query that i want to turn into the stored procedure or view . How can I do that cfquery name=getReport datasource=cfelsunrise dbtype=ODBC Select e.employeeid, e.last_name as empLastName, e.first_name as empFirstName, e.middle_name as empMiddleName, tr.TrainingID, tr.courseID, tr.StdTimeFrame, .et.completiondate, er.last_name as erLastName, er.first_name as erFirstName, er.middle_name as erMiddleName, er.EmployeeID as erEmployeeiD, ea.last_name as eaLastName, ea.first_name as eaFirstName, ea.middle_name as eaMiddleName, ea.EmployeeID as eaEmployeeiD, ea.middle_name as eaMiddleName, l.name, l.locationID, l.state, s.stateid, a.areaID, r.regionID, e.hireDate from employee e join employeejobhistory h on h.employeeid = e.employeeid inner join jobassignment ja on (ja.sequence = h.sequence and ja.emplrcd = 0 and ja.enddate is NULL) inner join jobcode_list j on j.jobcode = h.jobcode inner join location l on l.locationid = ja.locationid Inner join States s on l.state = s.StateCode inner join JobTrainLink jtl on (jtl.JobCode = h.JobCode and jtl.DeptID = h.DeptID and jtl.TrainingID is not NULL) inner Join TrainingReqmt tr ON (tr.TrainingID = jtl.TrainingID and tr.courseID in(#crslist#)) left outer Join TrainReqState trs ON (trs.TrainReqID = tr.TrainReqID and trs.StateID = s.StateID) left outer join employeeTraining et on (e.employeeid = et.employeeid and et.courseID = tr.CourseID and et.Errflag is NULL) left outer join area a on a.areaid = l.areaid left outer join employee ea on ea.employeeid = a.managerEmpID left outer join region ron r.regionid = a.regionid left outer join employee er on er.employeeid = r.managerEmpID where e.terminationdate is NULL and DATEDIFF(dy, #cutoffdate#, e.HireDate) = 0 and l.excludeflag != 'Y' cfif selregionalVP gt 0and r.ManagerEmpID = #selregionalVP#/cfif cfif selareaManager gt 0and a.ManagerEmpID = #selareaManager#/cfif cfif community gt 0and l.LocationID = #community#/cfif order by er.last_name, er.first_name, ea.last_name, ea.first_name, l.name, l.locationID, e.last_name, e.first_name, e.middle_name, e.employeeID, tr.courseID, et.completiondate /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: turn the coldfusion query into sql stored procedure or view
No wonder you want to turn that query into a stored procedure. That's about the most complicated query I've seen! Rick -Original Message- From: erik tom [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 12:36 PM To: CF-Talk Subject: turn the coldfusion query into sql stored procedure or view I have a cooldfusion query that i want to turn into the stored procedure or view . How can I do that cfquery name=getReport datasource=cfelsunrise dbtype=ODBC Select e.employeeid, e.last_name as empLastName, e.first_name as empFirstName, e.middle_name as empMiddleName, tr.TrainingID, tr.courseID, tr.StdTimeFrame, .et.completiondate, er.last_name as erLastName, er.first_name as erFirstName, er.middle_name as erMiddleName, er.EmployeeID as erEmployeeiD, ea.last_name as eaLastName, ea.first_name as eaFirstName, ea.middle_name as eaMiddleName, ea.EmployeeID as eaEmployeeiD, ea.middle_name as eaMiddleName, l.name, l.locationID, l.state, s.stateid, a.areaID, r.regionID, e.hireDate from employee e join employeejobhistory h on h.employeeid = e.employeeid inner join jobassignment ja on (ja.sequence = h.sequence and ja.emplrcd = 0 and ja.enddate is NULL) inner join jobcode_list j on j.jobcode = h.jobcode inner join location l on l.locationid = ja.locationid Inner join States s on l.state = s.StateCode inner join JobTrainLink jtl on (jtl.JobCode = h.JobCode and jtl.DeptID = h.DeptID and jtl.TrainingID is not NULL) inner Join TrainingReqmt tr ON (tr.TrainingID = jtl.TrainingID and tr.courseID in(#crslist#)) left outer Join TrainReqState trs ON (trs.TrainReqID = tr.TrainReqID and trs.StateID = s.StateID) left outer join employeeTraining et on (e.employeeid = et.employeeid and et.courseID = tr.CourseID and et.Errflag is NULL) left outer join area a on a.areaid = l.areaid left outer join employee ea on ea.employeeid = a.managerEmpID left outer join region ron r.regionid = a.regionid left outer join employee er on er.employeeid = r.managerEmpID where e.terminationdate is NULL and DATEDIFF(dy, #cutoffdate#, e.HireDate) = 0 and l.excludeflag != 'Y' cfif selregionalVP gt 0and r.ManagerEmpID = #selregionalVP#/cfif cfif selareaManager gt 0and a.ManagerEmpID = #selareaManager#/cfif cfif community gt 0and l.LocationID = #community#/cfif order by er.last_name, er.first_name, ea.last_name, ea.first_name, l.name, l.locationID, e.last_name, e.first_name, e.middle_name, e.employeeID, tr.courseID, et.completiondate /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: turn the coldfusion query into sql stored procedure or view
And it will be just as complicated in the stored procedure too. If performance gains are your only motivation, I would suggest refactoring your code a bit. Moving to a stored proc won't really give you any more performance over the addition of cfqueryparams. Of course if you wish to centralize your logic so another app can use the query without code duplication that would be a perfectly acceptable reason too. For starters, what is your DBMS? You will have some fun with stuff like your courseID list. Let us know what your database is and we'll start from there. If you don't wish to rewrite all the SQL, MOST of it can be directly placed in a proc with little changes. Each of your criterions will need to be input parameters to the proc. ~Brad -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 10:42 AM To: CF-Talk Subject: RE: turn the coldfusion query into sql stored procedure or view No wonder you want to turn that query into a stored procedure. That's about the most complicated query I've seen! Rick -Original Message- From: erik tom [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 12:36 PM To: CF-Talk Subject: turn the coldfusion query into sql stored procedure or view I have a cooldfusion query that i want to turn into the stored procedure or view . How can I do that cfquery name=getReport datasource=cfelsunrise dbtype=ODBC Select e.employeeid, e.last_name as empLastName, e.first_name as empFirstName, e.middle_name as empMiddleName, tr.TrainingID, tr.courseID, tr.StdTimeFrame, .et.completiondate, er.last_name as erLastName, er.first_name as erFirstName, er.middle_name as erMiddleName, er.EmployeeID as erEmployeeiD, ea.last_name as eaLastName, ea.first_name as eaFirstName, ea.middle_name as eaMiddleName, ea.EmployeeID as eaEmployeeiD, ea.middle_name as eaMiddleName, l.name, l.locationID, l.state, s.stateid, a.areaID, r.regionID, e.hireDate from employee e join employeejobhistory h on h.employeeid = e.employeeid inner join jobassignment ja on (ja.sequence = h.sequence and ja.emplrcd = 0 and ja.enddate is NULL) inner join jobcode_list j on j.jobcode = h.jobcode inner join location l on l.locationid = ja.locationid Inner join States s on l.state = s.StateCode inner join JobTrainLink jtl on (jtl.JobCode = h.JobCode and jtl.DeptID = h.DeptID and jtl.TrainingID is not NULL) inner Join TrainingReqmt tr ON (tr.TrainingID = jtl.TrainingID and tr.courseID in(#crslist#)) left outer Join TrainReqState trs ON (trs.TrainReqID = tr.TrainReqID and trs.StateID = s.StateID) left outer join employeeTraining et on (e.employeeid = et.employeeid and et.courseID = tr.CourseID and et.Errflag is NULL) left outer join area a on a.areaid = l.areaid left outer join employee ea on ea.employeeid = a.managerEmpID left outer join region r on r.regionid = a.regionid left outer join employee er on er.employeeid = r.managerEmpID where e.terminationdate is NULL and DATEDIFF(dy, #cutoffdate#, e.HireDate) = 0 and l.excludeflag != 'Y' cfif selregionalVP gt 0and r.ManagerEmpID = #selregionalVP#/cfif cfif selareaManager gt 0and a.ManagerEmpID = #selareaManager#/cfif cfif community gt 0and l.LocationID = #community#/cfif order by er.last_name, er.first_name, ea.last_name, ea.first_name, l.name, l.locationID, e.last_name, e.first_name, e.middle_name, e.employeeID, tr.courseID, et.completiondate /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checkboxes not passing variables correctly
the value attrubute of your checkboxes are different from their labels/text? typos? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Steve LaBadie wrote: I have a group of 10 checkboxes where 3 have to be checked. I have a JS script to validate this. The issue at hand is the values are not being passed completely. If you choose Robert Mckenzie the name is passed Robet Mkenzie, any ideas would be appreciated. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
BlueDragon AMI
Has anyone gone through the paces to make a BlueDragon AMI for Amazon EC2? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ImageGetIPTCMetadata not returning metadata
Hi, Has anyone seen any issues with ImageGetIPTCMetadata not actually getting the IPTC Metadata? I have some images created using PhotoShop CS3. We put IPTC metadata in them but CF does not pull it out. I can even look at the file properties in windows and see more data than CF is extracting. Thanks, --Dave blog.dkferguson.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Perhaps a little over complicated - Dissecting a String
Yes. It ensures WORDS are not cut in half. If the string is longer than the 'trimat' attribute, it cuts off the specified amount of text, then works its way BACK to the first space it finds and chops everything after it, else it just returns the string as is since it wasn't long enough. You could change the space to a period but there are plenty of uses for period that aren't the end of a sentence so it might be a bit tougher. Mr. Garrison and Mr. Hat have one weird relationship. If you cut that at 25 and worked for ONLY full sentences based on periods, you would get Mr. Garrison and Mr. -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 10:58 PM To: CF-Talk Subject: RE: Perhaps a little over complicated - Dissecting a String Thanks bobby. This ensures words are not cut in half, not sentences correct? Or did I miss something? Thanks Bobby Hartsfield [EMAIL PROTECTED] wrote: Been using this forever. Author: Bobby Hartsfield | [EMAIL PROTECTED] File: trimtext.cfm Description: This tag will take the text passed to it and create a teaser Meaning, it will trim the text back and add a trailing ... to the end Making for a good teaser news article with a read more link. Give the tag the text to trim and the number of characters to trim it at it will trim to that specified number and work its way BACK to the first space character and add ... --- the Trimat attribute --- attribute --- any words in half--- listlen(Cutparagraph, ), ) #finalparagraph#... trimat specifications display it without any editing --- #paragraph# -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 7:23 PM To: CF-Talk Subject: Re: Perhaps a little over complicated - Dissecting a String These are all good steps in the right direction however, I haven't found anything that ties all this logic together. Logic if first sentence is between 200-250 characters show that setence if no sentence, show first 250 characters +... if first sentence is less than 250 sentences, get as many sentences as possible before hitting 250 characters and output. Has anyone built something like this? Thanks Steve Bryant wrote: I think you want: #Left(ListFirst(string,.),100)#. (untested) Instead of returning say just 100 characters. Is there a way to return the first sentence only if its under 100 characters, and if not then 100 characters resulting in a cut off string. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Music previewing
I don't know of one off-hand but there are TONS of flash based MP3 players out there. I would imagine there is one to do what you are trying. I've written a couple of players myself that read the music info from an xml file and play them based on passed URLs. I could dig one up for you if you half to start from scratch. -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 2:46 PM To: CF-Talk Subject: RE: Music previewing Thank you Will and Bobby, In my searches, I came across a premade 'sound machine' flash file which takes an XML document and then you indicate which sound file from the XML you had wanted. Does anyone know of any other premade flash files which would take a simple 'url' in the flash variables from the embed or object tag to play the music? Otherwise I will need to download the trial of Adobe Flash Thank you again, William ::-Original Message- ::From: Will Tomlinson [mailto:[EMAIL PROTECTED] ::Sent: Monday, March 24, 2008 4:16 AM ::To: CF-Talk ::Subject: Re: Music previewing :: ::I am trying to get a temporary fix of having an embed object created ::dynamically through javascript and then using a settimeout to replace ::that ::object with a blank one that will 'stop' the music playing, but since the ::music isn't 'streaming' the song takes too much time to download to the ::users' machine before starting the playback. :: :: ::Flash will stream the music automatically like you need. :: ::Will :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: BlueDragon AMI
I have. About six months ago so my memory is a little hazy. I ended up opting not to go with EC2 because of them not being able to guarantee that I would be able to keep the same IP. Adam Howitt did a presentation on it. http://www.webdevref.com/blog/index.cfm?t=Build_a_scalable_architecture_with_Amazon%27s_EC2mode=entryentry=62ED0DB1-E1D7-BDC2-1BEC6F6C616658A4dv=link On Tue, Mar 25, 2008 at 2:30 PM, Eric Dawson [EMAIL PROTECTED] wrote: Has anyone gone through the paces to make a BlueDragon AMI for Amazon EC2? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BlueDragon AMI
You might want to look at right scale. They make the process as painless as possible for setting up VM instances. http://www.rightscale.com/m/ http://blog.synthasite.com/2007/08/14/scaling-on-amazon-with-rightscale/ There is a FF plugin for it as well (of course there is). http://www.rjonna.com/ext/s3fox.php On Tue, Mar 25, 2008 at 2:30 PM, Eric Dawson [EMAIL PROTECTED] wrote: Has anyone gone through the paces to make a BlueDragon AMI for Amazon EC2? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Row Height or Padding in CFGrid
Is there a way to set the Row Height or Padding of a row in CFGrid. I have a small number of records I want to display at a time and would like to combine making the grid look like a table with the paging sorting capabilities of the grid. thanks in advance, Michael ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Music previewing
I have used Wimpy. It is $30 and worth every penny. It has an API and all that. Very powerful and flexible. It might be able to do what you want. I donno. I haven't messed with it for over a year. http://www.wimpyplayer.com/ On Tue, Mar 25, 2008 at 2:08 PM, Bobby Hartsfield [EMAIL PROTECTED] wrote: I don't know of one off-hand but there are TONS of flash based MP3 players out there. I would imagine there is one to do what you are trying. I've written a couple of players myself that read the music info from an xml file and play them based on passed URLs. I could dig one up for you if you half to start from scratch. -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 2:46 PM To: CF-Talk Subject: RE: Music previewing Thank you Will and Bobby, In my searches, I came across a premade 'sound machine' flash file which takes an XML document and then you indicate which sound file from the XML you had wanted. Does anyone know of any other premade flash files which would take a simple 'url' in the flash variables from the embed or object tag to play the music? Otherwise I will need to download the trial of Adobe Flash Thank you again, William ::-Original Message- ::From: Will Tomlinson [mailto:[EMAIL PROTECTED] ::Sent: Monday, March 24, 2008 4:16 AM ::To: CF-Talk ::Subject: Re: Music previewing :: ::I am trying to get a temporary fix of having an embed object created ::dynamically through javascript and then using a settimeout to replace ::that ::object with a blank one that will 'stop' the music playing, but since the ::music isn't 'streaming' the song takes too much time to download to the ::users' machine before starting the playback. :: :: ::Flash will stream the music automatically like you need. :: ::Will :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
XPath with namespace
Hey all, got this XML: cfsavecontent variable=x?xml version=1.0 encoding=UTF-8? kml xmlns=http://earth.google.com/kml/2.0; Placemark nameLondon SE14 6QP/name addressLondon SE14 6QP/address styleUrlroot://styleMaps#default+nicon=0x304+hicon=0x314/styleUrl Point coordinates-0.030183,51.471709,0/coordinates /Point LookAt longitude-0.030183/longitude latitude51.471709/latitude range1000.00/range /LookAt /Placemark /kml/cfsavecontent Which I want to navigate to the long and lat values. I wanted to do an XMLSearch but the xmlns attribute is stopping it from working. The following code to test it highlights the problem. If you remove the namespace it works. Any ideas on how to get this to work other than drilling down with XmlChildren syntax. cfset x = XMLParse(x, false) cfdump var=#x# cfdump var=#XMLSearch(x, '//LookAt')# Cheers. Adrian Lynch http://www.adrianlynch.co.uk/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XPath with namespace
Try cfdump var=#XMLSearch(x, '//:LookAt')# That specifies the 'default' or 'no name' namespace which is what is being used in that xml. There can be a problem when there is more than one namespace declared without a prefix but it doesn't seem that that comes up a lot (though it does with the google maps geocoder). You should be ok here though. Dominic On 25/03/2008, Adrian Lynch [EMAIL PROTECTED] wrote: Hey all, got this XML: cfsavecontent variable=x?xml version=1.0 encoding=UTF-8? kml xmlns=http://earth.google.com/kml/2.0; Placemark nameLondon SE14 6QP/name addressLondon SE14 6QP/address styleUrlroot://styleMaps#default+nicon=0x304+hicon=0x314/styleUrl Point coordinates-0.030183,51.471709,0/coordinates /Point LookAt longitude-0.030183/longitude latitude51.471709/latitude range1000.00/range /LookAt /Placemark /kml/cfsavecontent Which I want to navigate to the long and lat values. I wanted to do an XMLSearch but the xmlns attribute is stopping it from working. The following code to test it highlights the problem. If you remove the namespace it works. Any ideas on how to get this to work other than drilling down with XmlChildren syntax. cfset x = XMLParse(x, false) cfdump var=#x# cfdump var=#XMLSearch(x, '//LookAt')# Cheers. Adrian Lynch http://www.adrianlynch.co.uk/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XPath with namespace
Dominic Watson wrote: Try cfdump var=#XMLSearch(x, '//:LookAt')# That specifies the 'default' or 'no name' namespace which is what is being used in that xml. There can be a problem when there is more than one namespace declared without a prefix but it doesn't seem that that comes up a lot (though it does with the google maps geocoder). You should be ok here though. Dominic This blog entry discuss this in a bit more detail. http://www.talkingtree.com/blog/index.cfm/2005/11/18/XmlSearchNoNameNamespace ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
Is there a list of all possible delimiters value? A delimeter could be any 'legal' character in a string. The delimeter you use is informed by the string you are given to break up into list items; using different delimiters will break up your 'list' in different ways. Here is some code to demonstrate, just copy and past into a blank template and run it; then look over the output and hopefully things will become clear for you (if they haven't already): cfset myList = foo|bar,sticky toffee pudding|init cfoutput h1Delimiter demo/h1 p The list: #myList#/p h2Using default delimiter (comma)/h2 ul cfloop list=#myList# index=listItem li#listItem#/li /cfloop /ul h2Using '|'/h2 ul cfloop list=#myList# index=listItem delimiters=| li#listItem#/li /cfloop /ul h2Using '|' or ','/h2 ul cfloop list=#myList# index=listItem delimiters=|, li#listItem#/li /cfloop /ul h2Using any vowel/h2 ul cfloop list=#myList# index=listItem delimiters=aeiou li#listItem#/li /cfloop /ul h2Using a character that isn't in the string (@)/h2 ul cfloop list=#myList# index=listItem delimiters=@ li#listItem#/li /cfloop /ul /cfoutput Also, if you want a delimiter of CR LF (used quite regularly to delimit whole lines of a csv that have a line break to indicate a new row) you can use the Chr function: delimiters=#Chr(13)##Chr(10)# HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checkboxes not passing variables correctly
Thank you Dominic for the extra input, very helpful examples. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 3:53 PM To: CF-Talk Subject: Re: Checkboxes not passing variables correctly Is there a list of all possible delimiters value? A delimeter could be any 'legal' character in a string. The delimeter you use is informed by the string you are given to break up into list items; using different delimiters will break up your 'list' in different ways. Here is some code to demonstrate, just copy and past into a blank template and run it; then look over the output and hopefully things will become clear for you (if they haven't already): cfset myList = foo|bar,sticky toffee pudding|init cfoutput h1Delimiter demo/h1 p The list: #myList#/p h2Using default delimiter (comma)/h2 ul cfloop list=#myList# index=listItem li#listItem#/li /cfloop /ul h2Using '|'/h2 ul cfloop list=#myList# index=listItem delimiters=| li#listItem#/li /cfloop /ul h2Using '|' or ','/h2 ul cfloop list=#myList# index=listItem delimiters=|, li#listItem#/li /cfloop /ul h2Using any vowel/h2 ul cfloop list=#myList# index=listItem delimiters=aeiou li#listItem#/li /cfloop /ul h2Using a character that isn't in the string (@)/h2 ul cfloop list=#myList# index=listItem delimiters=@ li#listItem#/li /cfloop /ul /cfoutput Also, if you want a delimiter of CR LF (used quite regularly to delimit whole lines of a csv that have a line break to indicate a new row) you can use the Chr function: delimiters=#Chr(13)##Chr(10)# HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XPath with namespace
This blog entry discuss this in a bit more detail. http://www.talkingtree.com/blog/index.cfm/2005/11/18/XmlSearchNoNameNamespace It does but it also misses a point that this IS a missing feature of ColdFusion. The solution works fine when you only have one default namespace being used (as in Ade's example) but it falls down when there are more than one. Here is a recent thread from here that discusses it (with no current solution other than ugly XPath): http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55440 Dominic On 25/03/2008, Ian Skinner [EMAIL PROTECTED] wrote: Dominic Watson wrote: Try cfdump var=#XMLSearch(x, '//:LookAt')# That specifies the 'default' or 'no name' namespace which is what is being used in that xml. There can be a problem when there is more than one namespace declared without a prefix but it doesn't seem that that comes up a lot (though it does with the google maps geocoder). You should be ok here though. Dominic This blog entry discuss this in a bit more detail. http://www.talkingtree.com/blog/index.cfm/2005/11/18/XmlSearchNoNameNamespace ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need Include to be first thing after BODY tag
Hello, I'm working on a project to change the web analysis tags on our CF8 site. Currently we use onrequestend.cfm to tell the rendered page to include the analysis javascripts at the end of the file and then put in the /body tag. We are changing brands and the javascripts must be included right after the opening body tag. I can't think of a way to do this without putting an cfinclude right after the body tag in every document that requires it. There are about 50 template pages that make up the site and I could add a cfinclude tag to every page but there must be a better way that I don't know about. I will be dynamically adding values to the javascript tag such as: script language=javascript1.1 src=/somedir type=text/javascript xxCreatePageViewTag(Housewares,Cool Kitchen Gadgets,Page 1); /script Any suggestions are much appreciated. Thanks, Jerry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need Include to be first thing after BODY tag
Yes, they want it directly after the body tag. Their claim is that the want to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. p.s. I hope this goes to the correct place - mailing list - as I don't see my own question on the CF-Talk web page. Thanks, Jerry -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:16 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Row Height or Padding in CFGrid
assuming you are referring to an html cfgrid, you will need to
modify/'over-ride' the cf's css for the grid.
i have managed to achieve a very table-like look by adding the following
style declaration to my page with an html cfgrid:
[style]
td div, table div, form div { margin:0; }
..x-grid-header { margin:0; }
..x-grid-hd-row td { line-height:normal; }
[/style]
this removes the annoying margins on various sections of the grid
(header/footer, rows), making it look more like a normal table...
hth
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Michael Brennan-White wrote:
Is there a way to set the Row Height or Padding of a row in CFGrid. I have
a small number of records I want to display at a time and would like to
combine making the grid look like a table with the paging sorting
capabilities of the grid.
thanks in advance,
Michael
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302044
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. Ah ok, now this is a valuable reason I didn't think of. ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need Include to be first thing after BODY tag
Extract everything from the opening body tag for your pages and make a common include file. On Tue, Mar 25, 2008 at 5:04 PM, Gerald Weir [EMAIL PROTECTED] wrote: Hello, I'm working on a project to change the web analysis tags on our CF8 site. Currently we use onrequestend.cfm to tell the rendered page to include the analysis javascripts at the end of the file and then put in the /body tag. We are changing brands and the javascripts must be included right after the opening body tag. I can't think of a way to do this without putting an cfinclude right after the body tag in every document that requires it. There are about 50 template pages that make up the site and I could add a cfinclude tag to every page but there must be a better way that I don't know about. I will be dynamically adding values to the javascript tag such as: script language=javascript1.1 src=/somedir type=text/javascript xxCreatePageViewTag(Housewares,Cool Kitchen Gadgets,Page 1); /script Any suggestions are much appreciated. Thanks, Jerry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
Not to help you at all, and providing info you didn't ask for, but... Best practices when counting pages is to wait for the page to load, or most of the page to load, before counting that page. This is especially true when counting advertising page views, or counting pages read for subscription purposes. (If the page didn't load, they couldn't have actually read it, and counting it as a view is a bit of a stretch.) But now on to your question. Are you trying to find a way to do it on every page, without having to actually write it into every page? Jerry On Tue, Mar 25, 2008 at 4:24 PM, Gerald Weir [EMAIL PROTECTED] wrote: Yes, they want it directly after the body tag. Their claim is that the want to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. p.s. I hope this goes to the correct place - mailing list - as I don't see my own question on the CF-Talk web page. Thanks, Jerry -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:16 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
Unless I'm not getting something (it is late in the afternoon.. need caffeine).. Can't you use the body onload=javascript:myFunc(...); / On Tue, Mar 25, 2008 at 3:36 PM, Claude Schneegans [EMAIL PROTECTED] wrote: to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. Ah ok, now this is a valuable reason I didn't think of. ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need Include to be first thing after BODY tag
Ah.. I see.. you're wanting to do it without editing all the pages.. dunno there... On Tue, Mar 25, 2008 at 3:55 PM, Greg Morphis [EMAIL PROTECTED] wrote: Unless I'm not getting something (it is late in the afternoon.. need caffeine).. Can't you use the body onload=javascript:myFunc(...); / On Tue, Mar 25, 2008 at 3:36 PM, Claude Schneegans [EMAIL PROTECTED] wrote: to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. Ah ok, now this is a valuable reason I didn't think of. ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need Include to be first thing after BODY tag
Jerry, I appreciate your point and it is a good one. I'm just the programmer however, it's their call I'm afraid. Yes, your question is correct, this is the javascript report the page view so in the end it must go on all. Thanks, Gerald -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:53 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag Not to help you at all, and providing info you didn't ask for, but... Best practices when counting pages is to wait for the page to load, or most of the page to load, before counting that page. This is especially true when counting advertising page views, or counting pages read for subscription purposes. (If the page didn't load, they couldn't have actually read it, and counting it as a view is a bit of a stretch.) But now on to your question. Are you trying to find a way to do it on every page, without having to actually write it into every page? Jerry On Tue, Mar 25, 2008 at 4:24 PM, Gerald Weir [EMAIL PROTECTED] wrote: Yes, they want it directly after the body tag. Their claim is that the want to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. p.s. I hope this goes to the correct place - mailing list - as I don't see my own question on the CF-Talk web page. Thanks, Jerry -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:16 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need Include to be first thing after BODY tag
On Tue, Mar 25, 2008 at 5:01 PM, Gerald Weir [EMAIL PROTECTED] wrote: Jerry, I appreciate your point and it is a good one. I'm just the programmer however, it's their call I'm afraid. Yes, your question is correct, this is the javascript report the page view so in the end it must go on all. Thanks, Gerald There is no better way to do this if you are storing header information directly in each template. This is why people don't do that anymore ;-) You could download all 50 templates put them in a special folder for a minute... Open one in your favorite editor FIND body REPLACE WITH body cfoutput script language=javascript1.1 src=/#PageDirectory# type=text/javascript xxCreatePageViewTag(#PageCategory# ,#ProductCategory#,#PageNumber#); /script /cfoutput Or replace with your include if you want to do that route. Then upload the templates. Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
Just wanted to put it out there (or _my_ coworkers would yell at _me_). lol. OK, just winging it here, but i think if you include a standard javascript function or include at the top that attaches a function to the onLoad for the body, the function it attaches would be the coldfusion-custom javascript to call the view stasher. Not 100% sure if the objects all exist at the right time, but it could maybe get you there. On Tue, Mar 25, 2008 at 5:01 PM, Gerald Weir [EMAIL PROTECTED] wrote: Jerry, I appreciate your point and it is a good one. I'm just the programmer however, it's their call I'm afraid. Yes, your question is correct, this is the javascript report the page view so in the end it must go on all. Thanks, Gerald -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:53 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag Not to help you at all, and providing info you didn't ask for, but... Best practices when counting pages is to wait for the page to load, or most of the page to load, before counting that page. This is especially true when counting advertising page views, or counting pages read for subscription purposes. (If the page didn't load, they couldn't have actually read it, and counting it as a view is a bit of a stretch.) But now on to your question. Are you trying to find a way to do it on every page, without having to actually write it into every page? Jerry On Tue, Mar 25, 2008 at 4:24 PM, Gerald Weir [EMAIL PROTECTED] wrote: Yes, they want it directly after the body tag. Their claim is that the want to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. p.s. I hope this goes to the correct place - mailing list - as I don't see my own question on the CF-Talk web page. Thanks, Jerry -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:16 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need Include to be first thing after BODY tag
If you are using a version of ColdFusion that supports the Application.CFC and can make use of this feature in your site, you can use the Application.cfc onRequest method for this type of work. There are a lot a ramifications with this, especially if you also use templates in this site remotely such as web service for flash remoting. But with careful planing both these functions can be accommodated. When you use the onRequest method, it returns all the generated content as an argument to the function which can then be modified with string manipulations to add something like you want. I.E. something like replace(arguments.targetPage,body,bodyscript,one). Check the documentation for the full details on how you implement an onRequest method. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFWindow with forms
I'm looking for some sample use of cfwindow using a form and closing the cfwindow once the form passes validation and backend processing. I've search and found a few great articles by Ray Camden, but I wanted to see the whole thing put together to grasp the entire concept. http://www.coldfusionjedi.com/index.cfm/2007/7/27/Update-to-ColdFusionBloggersorg-Ajaxbased-Contact-Form Any direction, link etc would be great. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates - My Solution
Just to recap - client had a database that was storing the dates of transactions - but - they wanted to be able to only enter a year, or just a year and month without an actual date. So, three columns were set up day|month|year and the values were being stored as integers ... I ended up adding another column to the database (searchDATE) and am basically forcing a valid date value into it. When the client enters a new record - any value they leave blank in the date fields is still recording as a 0 in the day|month|year interger fields, but is converted into a 1, and then I'm using createdate to put it together in the searchDATE field. So, if they only enter 2007 and nothing else, 01/01/2007 is getting recorded into the searchDATE field. If only enter a month and year (which is what they seem to be doing most of the time) the day gets recorded as a 1. Presto - valid dates. Now their requested search dates by range feature works fine. Some of the other solutions posted look pretty cool though, and I'm playing with them just to learn the techniques used. Thanks for everybody that replied. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates - IDEA!!!
On Mon, Mar 24, 2008 at 7:26 PM, Les Mizzell [EMAIL PROTECTED] wrote: ... What's the easiest way to search for values in a list starting at position X and ending at position Y? Off the top of my head, I'd do a listSort, and then iterate. Dunno if the list position idea would work for the search tho-- that'd be some really intensive looping there. :denny -- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Date Range Search Problem - when it's integers stored and not dates
On Mon, Mar 24, 2008 at 7:29 PM, Les Mizzell [EMAIL PROTECTED] wrote: denstar wrote: Are they against letting you add a real date field? Seeing there's already several hundred records in the database, some with dates, some with NONE - which is exactly what they want - adding a real date field would be tough. It was a hard argument to start with, and I let them win. They won, they get to figure it out. :-) Seriously tho, when I've been in that position, I've done the following: No dates become nulls 0/0/2008 becomes 1/1/2008 12/0/2008 becomes 12/1/2008 If they want whole years spanned, months, etc. do what Sonny suggests, and add a second end date field. If you go with the end date, you can put whatever logic they want in there. If only the year is specified, have it span the whole year 0/0/2008 becomes 1/1/2008 and 12/31/2008. ditto for months: 12/0/2008 becomes 12/1/2008 and 12/31/2008. And that's logic you could add to the entry form's save routine, so future events will have correct dates too, without having to change the way they're inputting them now. But - see my other email. I've had an idea while watching House!! Sometimes getting out from in front of the computer is the best way to find a solution (maybe - haven't tried it yet)!! Oh yeah. Breaks are good for the noggin, and water doesn't hurt either. :-) -denny -- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
Actually there *IS* a way to do this. It is pretty sneaky. Not my idea. I got it from Raymond Camden's Blog. http://www.coldfusionjedi.com/index.cfm/2008/1/26/Ask-a-Jedi-CFIMPORT-Applicationcfc-and-custom-tags Create a folder under a mapped path COM called tagLib Create a file under it called body.cfm In the application.cfm or application.cfc (in the onRequest method), add cfimport taglib=/com/tagLib Now, for the source of the body.cfm custom tag: cfif thistag.executionMode eq 'Start'body/cfif; cfif thistag.executionMode eq 'End'script language=javascript1.1 src=/somedir type=text/javascript xxCreatePageViewTag(Housewares,Cool Kitchen Gadgets,Page 1); /script/cfif This will effectively replace Body with the contents of your Custom tag. I have tried it before and it works. It is pretty damn ingenious. I am not sure what it will do with the body tag attributes you might have to add them to your custom tag. hth G On Tue, Mar 25, 2008 at 5:16 PM, Jerry Johnson [EMAIL PROTECTED] wrote: Just wanted to put it out there (or _my_ coworkers would yell at _me_). lol. OK, just winging it here, but i think if you include a standard javascript function or include at the top that attaches a function to the onLoad for the body, the function it attaches would be the coldfusion-custom javascript to call the view stasher. Not 100% sure if the objects all exist at the right time, but it could maybe get you there. On Tue, Mar 25, 2008 at 5:01 PM, Gerald Weir [EMAIL PROTECTED] wrote: Jerry, I appreciate your point and it is a good one. I'm just the programmer however, it's their call I'm afraid. Yes, your question is correct, this is the javascript report the page view so in the end it must go on all. Thanks, Gerald -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:53 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag Not to help you at all, and providing info you didn't ask for, but... Best practices when counting pages is to wait for the page to load, or most of the page to load, before counting that page. This is especially true when counting advertising page views, or counting pages read for subscription purposes. (If the page didn't load, they couldn't have actually read it, and counting it as a view is a bit of a stretch.) But now on to your question. Are you trying to find a way to do it on every page, without having to actually write it into every page? Jerry On Tue, Mar 25, 2008 at 4:24 PM, Gerald Weir [EMAIL PROTECTED] wrote: Yes, they want it directly after the body tag. Their claim is that the want to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. p.s. I hope this goes to the correct place - mailing list - as I don't see my own question on the CF-Talk web page. Thanks, Jerry -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:16 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
Wait... That will not work. Never mind. Sorry. I didn't think it all the way through. On Tue, Mar 25, 2008 at 5:43 PM, Gerald Guido [EMAIL PROTECTED] wrote: Actually there *IS* a way to do this. It is pretty sneaky. Not my idea. I got it from Raymond Camden's Blog. http://www.coldfusionjedi.com/index.cfm/2008/1/26/Ask-a-Jedi-CFIMPORT-Applicationcfc-and-custom-tags Create a folder under a mapped path COM called tagLib Create a file under it called body.cfm In the application.cfm or application.cfc (in the onRequest method), add cfimport taglib=/com/tagLib Now, for the source of the body.cfm custom tag: cfif thistag.executionMode eq 'Start'body/cfif; cfif thistag.executionMode eq 'End'script language=javascript1.1 src=/somedir type=text/javascript xxCreatePageViewTag(Housewares,Cool Kitchen Gadgets,Page 1); /script/cfif This will effectively replace Body with the contents of your Custom tag. I have tried it before and it works. It is pretty damn ingenious. I am not sure what it will do with the body tag attributes you might have to add them to your custom tag. hth G On Tue, Mar 25, 2008 at 5:16 PM, Jerry Johnson [EMAIL PROTECTED] wrote: Just wanted to put it out there (or _my_ coworkers would yell at _me_). lol. OK, just winging it here, but i think if you include a standard javascript function or include at the top that attaches a function to the onLoad for the body, the function it attaches would be the coldfusion-custom javascript to call the view stasher. Not 100% sure if the objects all exist at the right time, but it could maybe get you there. On Tue, Mar 25, 2008 at 5:01 PM, Gerald Weir [EMAIL PROTECTED] wrote: Jerry, I appreciate your point and it is a good one. I'm just the programmer however, it's their call I'm afraid. Yes, your question is correct, this is the javascript report the page view so in the end it must go on all. Thanks, Gerald -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:53 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag Not to help you at all, and providing info you didn't ask for, but... Best practices when counting pages is to wait for the page to load, or most of the page to load, before counting that page. This is especially true when counting advertising page views, or counting pages read for subscription purposes. (If the page didn't load, they couldn't have actually read it, and counting it as a view is a bit of a stretch.) But now on to your question. Are you trying to find a way to do it on every page, without having to actually write it into every page? Jerry On Tue, Mar 25, 2008 at 4:24 PM, Gerald Weir [EMAIL PROTECTED] wrote: Yes, they want it directly after the body tag. Their claim is that the want to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. p.s. I hope this goes to the correct place - mailing list - as I don't see my own question on the CF-Talk web page. Thanks, Jerry -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 4:16 PM To: CF-Talk Subject: Re: Need Include to be first thing after BODY tag the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need Include to be first thing after BODY tag
On second thought it just might work Try this code instead: cfif thistag.executionMode eq 'Start'body script language=javascript1.1 src=/somedir type=text/javascript xxCreatePageViewTag(Housewares,Cool Kitchen Gadgets,Page 1); /script/cfif cfif thistag.executionMode eq 'End'/body/cfif On Tue, Mar 25, 2008 at 5:46 PM, Gerald Guido [EMAIL PROTECTED] wrote: Wait... That will not work. Never mind. Sorry. I didn't think it all the way through. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Solved - String Issue
Congratulations Bruce! Thanks for posting back the solution, too. |Denny -- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How to get this part of this string...
Can't seem to figure this one out... How would I select falls_bridge out of falls_bridge_original.jpg? It would also need to work to select falls_bridge our of falls_bridge_original.jpeg And it would need to be able to select roanoke out of roanoke_original.jpg... So, in other words, the only constant would be the _original. part. It could be How do I get everything to the left of _original in a string with an extension after _original. Anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to get this part of this string...
probably like this... #reReplace(falls_bridge_original.jpeg, ^(.+?)(_original)?\.\w+$, \1)# -- nathan strutz http://www.dopefly.com/ On Tue, Mar 25, 2008 at 3:30 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Can't seem to figure this one out... How would I select falls_bridge out of falls_bridge_original.jpg? It would also need to work to select falls_bridge our of falls_bridge_original.jpeg And it would need to be able to select roanoke out of roanoke_original.jpg... So, in other words, the only constant would be the _original. part. It could be How do I get everything to the left of _original in a string with an extension after _original. Anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to get this part of this string...
You could do this in several different ways, here's one: cfset result = ReplaceNoCase(ListFirst(filename,'.'), '_original', '') HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get this part of this string...
Thanks, guys! Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 6:48 PM To: CF-Talk Subject: Re: How to get this part of this string... You could do this in several different ways, here's one: cfset result = ReplaceNoCase(ListFirst(filename,'.'), '_original', '') HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Mapping prefixes to XML namespaces for XPath searches
I cracked it: http://fusion.dominicwatson.co.uk/2008/03/xmlsearch-and-default-namespaces.html Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application Design Advice Needed
All, Application Design Advice Needed I need to build an application where one person can login and edit their emergency contact address lists, 1: many data relationship. Does anyone know of a example CF application that might fit this pattern? Iâm looking for GUI ideas and best practices using HTML forms or FLEX. Regards, -Jim Blaha ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to obtain just the domain from a URL
Would I use a REGEX to achive this? Or some other method? Start with something like: http://www.popularmechanics.com/technology/military_law/4255750.html End up with: popularmechanics.com Example 2 Start: http://blogs.abcnews.com/politicalpunch/2008/03/dnc-official-cl.html End: blogs.abcnews.com Thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
Regex would work. Using listGetAt(url, 3, '/') with as the delimiter would also work. Nic Nate Willard wrote: Would I use a REGEX to achive this? Or some other method? Start with something like: http://www.popularmechanics.com/technology/military_law/4255750.html End up with: popularmechanics.com Example 2 Start: http://blogs.abcnews.com/politicalpunch/2008/03/dnc-official-cl.html End: blogs.abcnews.com Thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
listGetAt(url, 2, '/') since CF ignores empty list attributes, no? On Tue, Mar 25, 2008 at 5:27 PM, Nicholas M Tunney [EMAIL PROTECTED] wrote: Regex would work. Using listGetAt(url, 3, '/') with as the delimiter would also work. Nic Nate Willard wrote: Would I use a REGEX to achive this? Or some other method? Start with something like: http://www.popularmechanics.com/technology/military_law/4255750.html End up with: popularmechanics.com Example 2 Start: http://blogs.abcnews.com/politicalpunch/2008/03/dnc-official-cl.html End: blogs.abcnews.com Thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
Good call. That behavior frustrates me ;) Nic Charlie Griefer wrote: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
I really love GetToken: cfset fullURL = ' http://blogs.abcnews.com/politicalpunch/2008/03/dnc-official-cl.html' cfdump var=#getToken( fullURL, 2, '//' )# cfset fullURL = ' http://www.abcnews.com/politicalpunch/2008/03/dnc-official-cl.html' cfdump var=#getToken( fullURL, 2, '//' )# cfset fullURL = 'http://www.correios.com.br' cfdump var=#getToken( fullURL, 2, '//' )# Cheers Marco Antonio On Tue, Mar 25, 2008 at 9:40 PM, Nicholas M Tunney [EMAIL PROTECTED] wrote: Good call. That behavior frustrates me ;) Nic Charlie Griefer wrote: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Row Height or Padding in CFGrid
Azadi,
Thanks for the reply. I am referring to an html cfgrid. I am calling the grid
into a div inside a cflayoutarea.
Should the CSS code be on the page that is being pulled in or on the index page
or as part of the css files being included in the index page?
Michael
assuming you are referring to an html cfgrid, you will need to
modify/'over-ride' the cf's css for the grid.
i have managed to achieve a very table-like look by adding the
following
style declaration to my page with an html cfgrid:
[style]
td div, table div, form div { margin:0; }
..
x-grid-header { margin:0; }
..
x-grid-hd-row td { line-height:normal; }
[/style]
this removes the annoying margins on various sections of the grid
(header/footer, rows), making it look more like a normal table...
hth
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Michael Brennan-White wrote:
Is there a way to set the Row Height or Padding of a row in CFGrid.
I have a small number of records I want to display at a time and would
like to combine making the grid look like a table with the paging
sorting capabilities of the grid.
thanks in advance,
Michael
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302072
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to obtain just the domain from a URL
I hadn't used GetToken before very interesting. What's the breakdown on best practices on GetToken versus Regex? Your code works well. thanks for the example. The third example returns the www. though, is there a ways to exclude that in the one line of GetToken? Thanks Web Specialist [EMAIL PROTECTED] wrote: I really love GetToken: Cheers Marco Antonio On Tue, Mar 25, 2008 at 9:40 PM, Nicholas M Tunney wrote: Good call. That behavior frustrates me ;) Nic Charlie Griefer wrote: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to obtain just the domain from a URL
listGetAt(url, 2, '/') works very well too, thanks! it does return the www. though, is there a way in the same line to remove the www without needed a www. replace ? Thanks Nicholas M Tunney [EMAIL PROTECTED] wrote: Good call. That behavior frustrates me ;) Nic Charlie Griefer wrote: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to obtain just the domain from a URL
cfif listfirst([variable],.) eq 'www'cfset listdeleteat([variable],1,.)/cfif I am certain that there is a REGEX guru here who can put you in turn with a good regex expression to do this as well, though. ::-Original Message- ::From: Nate Willard [mailto:[EMAIL PROTECTED] ::Sent: Tuesday, March 25, 2008 6:04 PM ::To: CF-Talk ::Subject: Re: How to obtain just the domain from a URL :: ::listGetAt(url, 2, '/') works very well too, thanks! it does return the ::www. though, is there a way in the same line to remove the www without ::needed a www. replace :: ::? :: ::Thanks :: ::Nicholas M Tunney [EMAIL PROTECTED] wrote: Good call. That ::behavior frustrates me ;) :: ::Nic :: ::Charlie Griefer wrote: :: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? :: :: :: :: :: :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
how about #cgi.server_name#? On Tue, Mar 25, 2008 at 6:09 PM, William Seiter [EMAIL PROTECTED] wrote: cfif listfirst([variable],.) eq 'www'cfset listdeleteat([variable],1,.)/cfif I am certain that there is a REGEX guru here who can put you in turn with a good regex expression to do this as well, though. ::-Original Message- ::From: Nate Willard [mailto:[EMAIL PROTECTED] ::Sent: Tuesday, March 25, 2008 6:04 PM ::To: CF-Talk ::Subject: Re: How to obtain just the domain from a URL :: ::listGetAt(url, 2, '/') works very well too, thanks! it does return the ::www. though, is there a way in the same line to remove the www without ::needed a www. replace :: ::? :: ::Thanks :: ::Nicholas M Tunney [EMAIL PROTECTED] wrote: Good call. That ::behavior frustrates me ;) :: ::Nic :: ::Charlie Griefer wrote: :: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? :: :: :: :: :: :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
The problem is that you wanted the server name in your blog.whatever.com, but not in www.whatever.com. Behavior would need to be consistent, or remove www. after the fact. HTH, Nic Nate Willard wrote: listGetAt(url, 2, '/') works very well too, thanks! it does return the www. though, is there a way in the same line to remove the www without needed a www. replace ? Thanks Nicholas M Tunney [EMAIL PROTECTED] wrote: Good call. That behavior frustrates me ;) Nic Charlie Griefer wrote: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
hehehe: Try this: cfset fullURL = 'http://www.correios.com.br' cfdump var=#ReplaceNoCase( getToken( fullURL, 2, '//' ), 'www.', '', 'one' )# Cheers Marco Antonio On Tue, Mar 25, 2008 at 10:04 PM, Nate Willard [EMAIL PROTECTED] wrote: listGetAt(url, 2, '/') works very well too, thanks! it does return the www. though, is there a way in the same line to remove the www without needed a www. replace ? Thanks Nicholas M Tunney [EMAIL PROTECTED] wrote: Good call. That behavior frustrates me ;) Nic Charlie Griefer wrote: listGetAt(url, 2, '/') since CF ignores empty list attributes, no? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Design Advice Needed
All, If you look at: http://examples.adobe.com/cf8gettingstarted/experience/index_content.cfm Check out the code snippet explorer. Any idea how I might use cfform and cftree to populate the information to the right of the cftree? -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to obtain just the domain from a URL
cfscript domain = ReplaceNoCase(CGI.SERVER_NAME,www.,,ALL); /cfscript I can't imagin a domain name starting with anything other than that... Or maybe you want www, Of course www. should be setup as a CNAME for @ or what's the point of www. anyway. Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
weird data base issue
I have a quick question and not sure how to solve this. I am working on an application CF8 connecting to a SQL database. All of my queries are working perfectly. Then I need to add a column to one of the tables in my database. Once I add the column, the queries still work but the data they are pulling back is incorrect, it is not the correct field. If I stop and restart the services everything works fine. I am not sure if this is an issue with the way I have the CF admin setup. I am not using the select * but naming each column name in the query. any help would be great. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weird data base issue
Are you caching queries in CF? Nic Matthew Friedman wrote: I have a quick question and not sure how to solve this. I am working on an application CF8 connecting to a SQL database. All of my queries are working perfectly. Then I need to add a column to one of the tables in my database. Once I add the column, the queries still work but the data they are pulling back is incorrect, it is not the correct field. If I stop and restart the services everything works fine. I am not sure if this is an issue with the way I have the CF admin setup. I am not using the select * but naming each column name in the query. any help would be great. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Row Height or Padding in CFGrid
Michael, the css should be either on the calling page or loaded page inside a style/style block, iirc. not sure if having the content page loaded into a div inside a cflayout area matters or not - it could be that your css will only work if it is on the loaded page, not the calling page... in either case, it CANNOT be in the included/linked stylesheet .css, as CF puts its css styles into the actual page and those will override your settings in a .css file. iirc, cf will put its styles into the calling page... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Michael Brennan-White wrote: Azadi, Thanks for the reply. I am referring to an html cfgrid. I am calling the grid into a div inside a cflayoutarea. Should the CSS code be on the page that is being pulled in or on the index page or as part of the css files being included in the index page? Michael ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFWindow with forms
here's one i use:
*cfwindow content - add_collection.cfm - loaded into an
'add-new-gallery-window' cfwindow:*
!--- ---
cfset err = 0
cfset errmsg = strongPlease correct the following errors and submit
the form again:/strongbr /
cfif isdefined('form.submitbtn')
!--- validate input ---
cfif len(trim(form.collection_title)) is 0
cfset err = 1
cfset errmsg = errmsg bull;nbsp;Gallery Title is
required.br
/cfif
cfif len(trim(collection_description)) is 0
cfset err = 1
cfset errmsg = errmsg bull;nbsp;Gallery Decription is
required.br
/cfif
cfif err is 0
!--- insert data ---
cfinvoke component=... method=... returnvariable=result
cfinvokeargument name=...
value=#trim(form.collection_title)#
cfinvokeargument name=...
value=#trim(form.collection_description)#
/cfinvoke
cfif result is true
scriptonAddNewSuccess('add-new-gallery-window',
onHideAddGallery);/script
cfelse
cfset err = 1
cfset errmsg = Error creating gallery!
/cfif
/cfif
/cfif
html xmlns=http://www.w3.org/1999/xhtml;
head
script
hideWindow = function(){
ColdFusion.Window.hide('add-new-gallery-window');
}
/script
/head
body
cfform name=addgallery action=#getfilefrompath(cgi.SCRIPT_NAME)#
method=post style=width:100%;
cfoutput
cfif err gt 0
div class=row
div class=errors
#errmsg#
/div
/div
/cfif
div class=row
span class=labelTitle:/span
span class=formfieldcfinput type=text name=collection_title
value=#form.collection_title# required=yes message=Enter Gallery
Title. //span
/div
div class=row
span class=labelDescription:/span
span class=formfieldcftextarea name=collection_description
style=height:100px; required=yes message=Enter Gallery
Description.#form.collection_description#/cftextarea/span
/div
div class=row
cfinput type=submit name=submitbtn
value=Savenbsp;nbsp;cfinput type=button name=cancelbtn
value=Cancel onClick=hideWindow();
/div
/cfoutput
/cfform
/div
/body
/html
*calling page (highly abbreviated)*
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
openWindow = function(name,title,url,options){
ColdFusion.Window.create(name, title, '', options);
ColdFusion.navigate(url, name);
}
addGallery = function(){
openWindow('add-new-gallery-window', 'Add Image Gallery',
'add_collection.cfm',
{center:true,height:400,width:650,minheight:400,minwidth:650,closable:false,dragable:true,resizable:true,modal:true,initshow:true});
}
onHideAddGallery = function(name){
//some code to run after cfwindow closes - i update the galleries
drop-down list
}
/head
body
.
.
a href=javascript:addGallery();[ add new gallery ]/a
.
.
/div
/body
/html
HTH!
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
[EMAIL PROTECTED] wrote:
I'm looking for some sample use of cfwindow using a form and closing the
cfwindow
once the form passes validation and backend processing. I've search and found
a few
great articles by Ray Camden, but I wanted to see the whole thing put
together to grasp
the entire concept.
http://www.coldfusionjedi.com/index.cfm/2007/7/27/Update-to-ColdFusionBloggersorg-Ajaxbased-Contact-Form
Any direction, link etc would be great.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302084
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
another reason would be for instance with google analytics / urchin tracker and tracking ajax content. you need to have the ga javascript loaded BEFORE the ajax calls you want to track, so if you are dynamically loading an external page into a container on the calling page, you need the ga js to be at the beginning of your page... ..02c Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Claude Schneegans wrote: to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. Ah ok, now this is a valuable reason I didn't think of. ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
managing product stock levels
hi guys, my client wishes to be able to add stock to a particular product in their webstore, and this stock to be reduced each time a sale is made. how have people done this? i figure i have a stock_level field (INT) for each product and this is decreased by one each time a sale is made. once a product reaches 0, the item can be made inactive for purchase (or removed from catalogue until topped up). would it be of any benefit to keep a log of each time the administrator adds stock to a product eg. date / stock added? any thoughts would be appreciated. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Application Design Advice Needed
http://www.lukew.com/resources/articles/web_forms.html http://www.uie.com/articles/web_forms/ All, Application Design Advice Needed I need to build an application where one person can login and edit their emergency contact address lists, 1: many data relationship. Does anyone know of a example CF application that might fit this pattern? Iâm looking for GUI ideas and best practices using HTML forms or FLEX. Regards, -Jim Blaha ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: managing product stock levels
my client wishes to be able to add stock to a particular product in their webstore, and this stock to be reduced each time a sale is made. how have people done this? i figure i have a stock_level field (INT) for each product and this is decreased by one each time a sale is made. once a product reaches 0, the item can be made inactive for purchase (or removed from catalogue until topped up). That's pretty much all there is to it. would it be of any benefit to keep a log of each time the administrator adds stock to a product eg. date / stock added? That is a business question. If it's a requirement or desired feature, or you think it will be in the future, it's a benefit. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion Remote Developer
I hope you used Allot to highlight the point! ;) Adrian -Original Message- From: Phillip M. Vector Sent: 25 March 2008 05:30 To: CF-Jobs-Talk Subject: Re: Cold Fusion Remote Developer Dude... A few things... 1) You are replying to the list. Please reply to the person. If you don't know how to do that, may I suggest you learn basic web before doing any programing. :) 2) Spelling your as ur looks really bad to a potential employer. Get a spell checker. it's free and it helps Allot. 3) Grammar can probably be forgiven since you are in a different country. But if anyone wants to have you make content, it hurts your chances. Just trying to help. vishnu prasad wrote: I am from india looking for a freelance work . can i have ur email id so that i can send my CV so far i have worked for couple of person in us on freelance Does your family own the town you live in?? I require a developer familiar with: -ColdFusion on Linux -Mysql 4 and 5 -File Replication -mysql data sync -CVS English speakers only. Full Time and paid through direct deposit. -_-_-_-_-_-_-_-_-_-_-_- Brian Thornton 871 Thornton Parkway, Suite #176 Thornton, CO 80229 cell: 702-787-7913 fax: 303-457-4879 -_-_-_-_-_-_-_-_-_-_-_-_-_-_ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3705 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
