CFLOCK instead of CFTRANSACTION
The MySQL driver does not support CFTRANSACTION. Except for the inability to rollback, does anyone see a problem with using a CFLOCK tag instead? cflock name=fooUpdate timeout=5 cfquery name= datasource=#request.mainDSN# INSERT INTO foo VALUES( bla bla ) /cfquery cfquery name=new datasource=#request.mainDSN# SELECT max(fooID) AS ID FROM foo /cfquery /cflock +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFLOCK instead of CFTRANSACTION
I know that the database itself can handle transactions using InnoDB tables. The error I'm getting from CF is that the ODBC DRIVER can't handle them. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 2:29 PM To: CF-Talk Subject: RE: CFLOCK instead of CFTRANSACTION MySQL can do transactions you just need to use the database type: InnoDB I have never use this myself, but according to the mysql.com documentation you can use it. -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 4:04 PM To: CF-Talk Subject: CFLOCK instead of CFTRANSACTION The MySQL driver does not support CFTRANSACTION. Except for the inability to rollback, does anyone see a problem with using a CFLOCK tag instead? cflock name=fooUpdate timeout=5 cfquery name= datasource=#request.mainDSN# INSERT INTO foo VALUES( bla bla ) /cfquery cfquery name=new datasource=#request.mainDSN# SELECT max(fooID) AS ID FROM foo /cfquery /cflock +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Dynamic var name
this will check existence like you wanted cfif structKeyExists(session,var) AND isArray(session[var],2) /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bruce, Rodney S HQISEC/SIGNAL [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 2:59 PM To: CF-Talk Subject: Dynamic var name Hello all Hoping someone can help with an isdefined issue. I am trying to do: CFIF isdefined(session[#var#][#x#][1]) but am getting the error: must be a syntactically valid variable name. CF seems to be rendering the vars correctly, the debug info shows: Parameter 1 of function IsDefined which is now session[BR21102][1][15] must be a syntactically valid variable name I have also tried CFIF isdefined(session.#var#[#x#][1]) With same results. Can someone tell me what I am missing? Thanks for any help Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: SQL without Subquery
this won't return rows with counts of 0... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 1:54 PM To: CF-Talk Subject: Re: OT: SQL without Subquery How about: SELECT l.id, l.description, l.build_date, l.edit_date, l.admin_user, COUNT(*) AS userCount FROM mailroomLeadList ll, customer c, mailroomLead l WHERE l.id = ll.id AND ll.customerid = c.id AND c.mail_list 0 GROUP BY l.id, l.description, l.build_date, l.edit_date, l.admin_user, ORDER BY description DESC Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL without Subquery
I don't have your DB so I can't test this, but it's close. SELECT l.id, l.description,l.build_date,l.edit_date,l.admin_user, COUNT(ll.id) AS userCount FROM mailroomLead l LEFT OUTER JOIN (mailRoomLeadList ll INNER JOIN customer c ON ll.customerid = c.id) ON l.id = ll.id) WHERE c.mail_list 0 GROUP BY l.id, l.description,l.build_date,l.edit_date,l.admin_user ORDER BY description DESC +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 1:36 PM To: CF-Talk Subject: OT: SQL without Subquery I have the following query that I am trying to use on a mySQL db (which doesn't support sub-queries). Can anyone see a good way to write this query other than with the sub query? SELECT l.id, l.description,l.build_date,l.edit_date,l.admin_user, (SELECT COUNT(*) FROM mailroomLeadList ll INNER JOIN customer c ON ll.customerid = c.id WHERE l.id = ll.id AND c.mail_list 0 ) AS userCount FROM mailroomLead l ORDER BY description DESC I was trying to stick this information into a 'temp' table via mySQL, but it is producing errors on the COUNT(*) ... Any suggestions? Thank you Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Converting new lines to br
replace(yourString,chr(10),br,all) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 2:53 PM To: CF-Talk Subject: Converting new lines to br I'm new to Cold Fusion so bear with me. Is there a way of converting new lines in a string to html line breaks br. If you are familiar with PHP I'm looking for something like the nl2br function. thanks, Luis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFTREE changed???
I have an application that uses CFTREE to display nested categories. I know it works fine in CF 4.5 and CF 5, but it's putting categories under the wrong parent categories in CFMX. Anyone know if they changed the source code for the CFTREE class? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFTREE changed???
Much thanks, I'll check the known issues on MM's site before I post another question like that :o +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Debbie Dickerson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:08 PM To: CF-Talk Subject: RE: CFTREE changed??? It's bug 47077 (Children appear under parent based on order coded and not due to parent attribute.) The current estimate is for a fix to be included in the next Updater release. Deb -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:49 PM To: CF-Talk Subject: CFTREE changed??? I have an application that uses CFTREE to display nested categories. I know it works fine in CF 4.5 and CF 5, but it's putting categories under the wrong parent categories in CFMX. Anyone know if they changed the source code for the CFTREE class? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Multiple Apps, one name
yes you can. Application-specific variables are based on the application name so you CAN have one application inherit information from another. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 2:54 PM To: CF-Talk Subject: Multiple Apps, one name What happens if I have multiple application.cfm files with one application name? I've looked around a bit, and all I see is don't do that. :-) I'm curious as to whether I can make one application inherit information from another. --Ben Doom Programmer General Lackey Moonbow Software __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Array Help
x isn't a list - it's an array. You can't use listgetat() with arrays. try this instead: cfset x = ListToArray(hot, ,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #x[Counter]#/cfoutput /CFLOOP or even better, try this: ol CFLOOP list=#hot# INDEX = i cfoutputLI#i#/cfoutput /CFLOOP /ol +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 11:28 AM To: CF-Talk Subject: Array Help Hi everyone, I am developing a sales thing for our reps and I got yanked off a project to do it and my brain is fuzzy. I have a column that gets returned that is titled Hot (a bit field in a SQL 2K DB). This column has checkboxes that can be checked so that the DB will flag them for future contact. The check box contains a dual value: 1, and the PK. So what I would like to do is when the check box is checked, set the Hot field to 1 for that particular record. My problem is that both values are numbers and not text. I am also unsure of how to accomplish this if someone selects like 20 checkboxes. I would need to update all associated records. Thanks! Tony Here is my VERY feabile attempt thus far. I just wanted to make sure the records were coming back correctly. I haven't started the update to the DB yet. So advice there would be greatly appreciated as well. cfset x = ListToArray(hot, ,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(x, Counter)#/cfoutput /CFLOOP The error I get: Error Diagnostic Information An error occurred while evaluating the expression: #ListGetAt(x, Counter, ,)# Error near line 54, column 29. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Array Help - SOLVED
why would you convert a list to an array then convert it back to a list again? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:01 PM To: CF-Talk Subject: RE: Array Help - SOLVED I figured it out. Just FYI: cfset x = ListToArray(hot, ,) cfset y = ArrayToList(x,,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(y, Counter)#/cfoutput /CFLOOP -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 2:28 PM To: CF-Talk Subject: Array Help Hi everyone, I am developing a sales thing for our reps and I got yanked off a project to do it and my brain is fuzzy. I have a column that gets returned that is titled Hot (a bit field in a SQL 2K DB). This column has checkboxes that can be checked so that the DB will flag them for future contact. The check box contains a dual value: 1, and the PK. So what I would like to do is when the check box is checked, set the Hot field to 1 for that particular record. My problem is that both values are numbers and not text. I am also unsure of how to accomplish this if someone selects like 20 checkboxes. I would need to update all associated records. Thanks! Tony Here is my VERY feabile attempt thus far. I just wanted to make sure the records were coming back correctly. I haven't started the update to the DB yet. So advice there would be greatly appreciated as well. cfset x = ListToArray(hot, ,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(x, Counter)#/cfoutput /CFLOOP The error I get: Error Diagnostic Information An error occurred while evaluating the expression: #ListGetAt(x, Counter, ,)# Error near line 54, column 29. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP question
Text parsing is somewhat of a lost art. It's easy to do, but difficult to do well. Your question is too general for me to provide a detailed answer. If you want to provide a sample of the data you want to parse perhaps I can be of some help... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:52 AM To: CF-Talk Subject: CFHTTP question I have a cfhttp get call to get another text webpage. I get the file fine but I want to parse out the useful data from that page that i get and I am not sure what the easiest way is. the data i am looking for is dynamic and can be one to many words. but it always starts at the same spot. whats the easiest way to parse it out.? Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP question
here is my suggestion... cfscript // find the second anchor tag artistIndex = find(a , cfhttp.filecontent, find(a , cfhttp.filecontent)+2); // strip everything before the second anchor tag content = removeChars(cfhttp.filecontent,1,artistIndex); // artist name is all text between start and end anchor tags artistName = listRest(listFirst(content,),); // strip characters up to and including the first br tag content = removeChars(content,1,find(br,content)+3); // song name is all text before next br tag songName = listFirst(content,); /cfscript +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:20 AM To: CF-Talk Subject: RE: CFHTTP question Bryan below is the snapshot of the data i have. I want to get the artist name and song name in this case it is Castlevania, Dracula New Class and Vampire Killer John tr td background=http://www.streamingsoundtracks.com/images/bg_name.gif; width=22% nowrapVisitors: a href='http://www.perlonline.com' style=47/abr Requests: 1/Hourbr Listeners: 149/185/td td align=center background=http://www.streamingsoundtracks.com/images/bg_name.gif; width=56% nowrap a href=http://www.amazon.com/exec/obidos/external-search/?mode=musictag=nopa tiencekeyword=Castlevania, Dracula New ClassCastlevania, Dracula New Class/a - a href=http://www.amazon.com/exec/obidos/external-search/?mode=musictag=nopa tiencekeyword=KonamiKonami/abr Vampire Killer (7:05)br img src=http://www.streamingsoundtracks.com/images/simages/fourh.gif; border=0 brfont face=Verdana size=2 color= /font /td td align=center background=http://www.streamingsoundtracks.com/images/bg_name.gif; width=22% a onclick=NewWindow(this.href,'name','510','170','yes');return false; href=http://www.streamingsoundtracks.com/cgi-bin/rating/stars/stars.pl?Cast levania_DNCRate It/a/td /tr At 10:10 AM 9/24/2002 -0700, you wrote: Text parsing is somewhat of a lost art. It's easy to do, but difficult to do well. Your question is too general for me to provide a detailed answer. If you want to provide a sample of the data you want to parse perhaps I can be of some help... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:52 AM To: CF-Talk Subject: CFHTTP question I have a cfhttp get call to get another text webpage. I get the file fine but I want to parse out the useful data from that page that i get and I am not sure what the easiest way is. the data i am looking for is dynamic and can be one to many words. but it always starts at the same spot. whats the easiest way to parse it out.? Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need help with CFHTTP
well first off the only two valid characters for the delimiter are a tab or comma and you are using a semi-colon. Here is the excerpt from CF Help: GET file into a query -- To download a file in a ColdFusion page so that a query can be built using the file, the file must be either comma-separated or tab-delimited. Although risky, text qualification may be omitted. The file will be parsed and an appropriate query built from it. Columns may be specified in the attribute list so that the client can override the columns specified in the file. There is error checking within the tag that prevents a user from either entering an invalid column name or using an invalid column name that was specified in the original file. If such an illegal filename is encountered, the illegal characters are stripped. Such action could produce duplicate column names, so duplicate columns are renamed and inserted into the query header. The query has all of the functionality of a standard CFQUERY object. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:57 PM To: CF-Talk Subject: Need help with CFHTTP Hello, Last week I asked about a CFFILE issue and was advised to use CFHTTP to read files from a remote server. Now I am trying to make this work but with no success yet. Unfortunatelly, this is on an intranet and I am not able to give you the link, but I will try to explain what is happenening. received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/received_plans.cfm) sends a form to received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/view_received.cfm) The form sends whatever field office, plan type, fiscal year and beginning quarter is selected from a set of drop-down menus. Depending on the fiscalyear selected in page1.cfm, page2.cfm is supposed to read a text file and expose its content sorted one way or another. Here is the error message I am getting: Error Diagnostic Information CFHTTP The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (449:11) to (450:111) in the template file /home1/web-docs-80/pih/pha/received/view_received_test.cfm. Date/Time: Mon Sep 23 15:52:49 2002 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0) Remote Address: 10.200.36.101 HTTP Referrer: http://www2.hud.gov/pih/pha/received/received_plans_test.cfm Here is the piece of code between lines 449 and 450: cfhttp method=get name=PHAPlansQuery URL=http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#- #fiscalyear#.txt delimiter=; /cfhttp What is wrong? Thanks in advance for your help, Mitko __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange JS Wierdness with CF
dunno for sure, but it would be dirt simple to have JS clear the form on
page load...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
Let's Roll
- Todd Beamer, Flight 93
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 1:25 PM
To: CF-Talk
Subject: Strange JS Wierdness with CF
I have a simple form that shares a page with a popup window.
If the popup window link is clicked and I submit the form --if
I hit the back button the form is cleared.
Heres the kicker; it only happens if my page has a .cfm file
extension. If its .html or .htm it does not clear.
CODE:
html
head
~titleUntitled/title
/head
body
form action=anypage.html method=post
~input type=text name=search
~input type=submit
/form
a href=# onClick=window.open('http://www.yahoo.com','yahoo')popup
test/a
/body
/html
Does anyone know why this happens or how to fix it?
Thanks,
David Murphy
www.cfugcny.org
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UCASING in the DB
Sure it is. You have two choices - a trigger or a stored procedure. I think you are way better off leaving it the CF server though (unless you're talking about thousands of characters per second...). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:01 AM To: CF-Talk Subject: UCASING in the DB Is it possible to insert lcase values in a SQL2K db and have it automatically ucase them in the database? Purpose: To take ucasing processing off the CFserver and onto the SQL server. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Multiple Inserts
I agree. I've never found a way to do it in Access, MS SQL, or Oracle. You CAN do it with MySQL however since it allows a multiple insert syntax like so: INSERT INTO table( columlist ) VALUES( record1 ), ( record2 ), ( record3 ), ( record4 ); +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 10:50 AM To: CF-Talk Subject: Re: OT: Multiple Inserts Can you do multiple insert statements in one CFQUERY statement? ie cfquery ... Insert into Insert Into ... Insert Into ... /cfquery If yes, is there something special that needs to be added? It probably depends on your drivers, although I've not been able to in the past with the default MS SQL Server drivers provided with CF 5 and prior... You can use a select statement to insert data from a query into another table, although I'm guessing that this is for your enterprise manager app you were talking about earlier today, so I'd say your best bet is probably multiple cfqeuries... S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UCASING in the DB
in fact, why don't you just put the upper() function in your insert query like so.. INSERT INTO table VALUES( upper(#text#), upper(#text#) ) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:17 AM To: CF-Talk Subject: RE: UCASING in the DB Sure it is. You have two choices - a trigger or a stored procedure. I think you are way better off leaving it the CF server though (unless you're talking about thousands of characters per second...). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:01 AM To: CF-Talk Subject: UCASING in the DB Is it possible to insert lcase values in a SQL2K db and have it automatically ucase them in the database? Purpose: To take ucasing processing off the CFserver and onto the SQL server. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UCASING in the DB
true, but if you do it during the INSERT you only do it once - if you do it during the SELECT you do it thousands, maybe millions of times. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:43 PM To: CF-Talk Subject: RE: UCASING in the DB you could also do the upper function on retrevial of the query. -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:56 PM To: CF-Talk Subject: RE: UCASING in the DB in fact, why don't you just put the upper() function in your insert query like so.. INSERT INTO table VALUES( upper(#text#), upper(#text#) ) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:17 AM To: CF-Talk Subject: RE: UCASING in the DB Sure it is. You have two choices - a trigger or a stored procedure. I think you are way better off leaving it the CF server though (unless you're talking about thousands of characters per second...). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:01 AM To: CF-Talk Subject: UCASING in the DB Is it possible to insert lcase values in a SQL2K db and have it automatically ucase them in the database? Purpose: To take ucasing processing off the CFserver and onto the SQL server. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multiple OUTER joins in SQL?
ACCESS requires the use of parenthesis to do multiple outer joins... SELECT c.itemID, c.title, c.ownerID, c.type, i.subject, i.intDate, r.rvwType FROM (( content c LEFT OUTER JOIN interviews i ON c.itemID = i.itemID) LEFT OUTER JOIN reviews r ON c.itemID = r.itemID) WHERE c.activated = 1 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:43 AM To: CF-Talk Subject: Re: multiple OUTER joins in SQL? - Original Message - From: Dina Hess [EMAIL PROTECTED] Try this: SELECT c.itemID, c.title, c.ownerID, c.type, i.subject, i.intDate, r.rvwType FROM content c LEFT JOIN interviews i ON c.itemID = i.itemID LEFT JOIN reviews r ON c.itemID = r.itemID WHERE c.activated = 1 Afraid not - I get Syntax error (missing operator) for the WHERE statement. I'm using Access 2000 - is this the problem? Maybe it can't handle multiple outer joins? Thanks anyways, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: parsing user input to get count
Unfortunately it's messy... cfset numList = 1,2,5-9 cfset count = 0 cfloop list=#numList# index=i cfif i CONTAINS - cfset count = count + abs(val(i)) cfelse cfset count = count + 1 /cfif /cfloop +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:38 PM To: CF-Talk Subject: parsing user input to get count I have a text field that I allow users to input data as follows: 1,2,5-9 Basically it is a coma delmited list with a range. Whats the best way to get a count... in this case I'd need to return 7 Thanks in advance... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Run a check before an insert
sounds like you'd need something like this: SELECT ... FROM table WHERE itemID IN (#idList#) AND type = 'food' [idList is a comma-delimited list of item IDs] Assuming your list (sugar, milk, tv, flour) is actually a list of IDs the above query will return information on the rows you desire. I also assume you have a column (type) that can be used to differentiate the items. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 9:55 AM To: CF-Talk Subject: Run a check before an insert Ok I need to make a check on one table before I do an insert into another table. (Kind of similar to a login where the 1st query checks the username/2nd query checks the group). But I want to be able to have the 1st table be able to check for several rows in the first query and only insert the matches into the second query. So an example is: I am restricted to only ordering food items. I order sugar, milk, a tv and flour. I want the first query to look at the order then send to the 2nd query the order for sugar, milk and sugar, leaving out the tv. (and maybe sending a message to the user...sorry you can't order that...) I can't seem to get my loops right on this one- I either seem to be able to add all or nothing. Thanks in advance, Janine __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinput
the only thing unique about CF inputs is that they cause the CF Server to generate JavaScript that is used for validation and such... Otherwise they end up the same as any other HTML input +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Nick Varner [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:37 PM To: CF-Talk Subject: cfinput Can you mix cfinputs with regular inputs? I am losing data and that seems like the only possible reason. I don't lose data all the time but when I do it drops information after the first space. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Urgent: Need help with a CFFILE error
if you must use a URL then use CFHTTP The content of the file will be in cfhttp.filecontent after the call. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 3:00 PM To: CF-Talk Subject: Urgent: Need help with a CFFILE error Hello, I am uploading an application which was built by the previous team and now I have to resolve some issues... Here is the page: http://webapps1.hud.gov/pih/pha/plans/approved/approved_plans.cfm When there, select a state from the drop down menu and then it takes you to: http://webapps1.hud.gov/pih/pha/plans/approved/view_approved_plans.cfm Here is the segment of code from view_approved_plans.cfm: cfset CURRENTDIRECTORY = #GETDIRECTORYFROMPATH(GETTEMPLATEPATH())# cfoutput !-- FILE=http://www2.hud.gov/pih/pha/plans/approved/#fiscalyear#/#statecode#_#f iscalyear#.txt -- cfif #statecode# NEQ 0 cffile action=Read file=http://www.hud.gov/offices/pih/pha/approved/#fiscalyear#/#statecode#_# fiscalyear#.txt variable=phacodeoff cfset codeofflist=ListToArray(phacodeoff,;) /cfif /cfoutput And here is the error I am getting: Error Diagnostic Information Error processing CFFILE Error attempting to read 'http://www.hud.gov/offices/pih/pha/approved/02/al_02.txt.' No such file or directory (error 2) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (449:11) to (451:25). Date/Time: Thu Sep 19 17:41:05 2002 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0) Remote Address: 10.200.36.101 HTTP Referrer: http://webapps1.hud.gov/pih/pha/plans/approved/approved_plans.cfm Now, I have no clue why is there a dot in the end of the file name which is being read: 'http://www.hud.gov/offices/pih/pha/approved/02/al_02.txt.' If you go to http://www.hud.gov/offices/pih/pha/approved/02/al_02.txt you will see that the file is there. Any help will be appreciated! Thanks, Mitko PS. I think the app server is ColdFusion 5 on Netscape Enterprise Server. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Las record
Different DB's provide different ways of doing this, but the only universal way I know of is this: Assuming the key is numeric and increments ascending: cftransaction cfquery... do the insert /cfquery cfquery... SELECT MAX(whateverID) as maxID FROM tablename /cfquery /cftransaction The transaction tags prevent another thread from doing an insert between the two queries and screwing up the SELECT MAX... statement. If the key is random then you likely are generating it in the code and already know it before the query is even run. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:49 PM To: CF-Talk Subject: Las record How do I get the Unique ID from the last field I inserted? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UUID's ( maybe OT)
Not really true. The word terrible is a vast overstatement. Assuming you use char (or varchar) for the UUID (char is better since the size is constant)... The difference btwn string keys and numeric keys (performance-wise) is pretty much null until you get up into the millions of records and even then it's not enough to worry about. Also, I saw a comment about nText. nText stores information in unicode so each character in a string has an accompanying unicode key. This doubles the storage size of strings and I believe it slows processing (although I'm not sure on that one) so it's not generally a good idea. If you're gonna use nText, nChar, nVarchar, make sure you have a really good reason! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:33 PM To: CF-Talk Subject: RE: UUID's ( maybe OT) My DBE tells me, however, that UUIDs (or GUIDs) are terrible for joins. Better to just use integers. -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 3:59 PM To: CF-Talk Subject: Re: UUID's ( maybe OT) UUIDs with a datatype of uniquidentifier are indexed just as pk's - Original Message - From: Zac Spitzer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:15 AM Subject: UUID's ( maybe OT) I am probably OT here, but I see so many people using UUID's when simpler normal numeric keys are better... a classic example for me is article id's... look at cfcomet for example... the article ids aren't user friendly, it reminds me of good old lotus notes and we all know how short urls are better than long one ( email wrapping for example ) not to mention that your database and CF load is much higher using long text pk's than with nice short numeric keys and your page size is increased a lot too.. just letting off steam. don't want to create a flame war or anything z __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX - cftree doesn't work
dunno if this is true with CFMX, but... In other versions of CF whenever you use CFTREE the browser would look for the tree class starting with /CFIDE/Classes/ That meant that your browser had to be able to find the CFIDE folder from the web root. In other words if your website is http://bla.bla.com then you must be able to see http://bla.bla.com/cfide/classes... If you can't then CFTREE won't work. Most web server software has a way of mapping virtual directories so that you can make it seem as though the CFIDE folder is at the root even if it is not. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:57 PM To: CF-Talk Subject: CFMX - cftree doesn't work Just installed CFMX on a Solaris box, copied some code over that worked fine on my cf4.5 box, but the cftree that I am using seems to be broken. Anyone know why cftree wouldn't work on a CFMX server? It just shows an outline of the tree browser, with a broken img icon in the box. No error. Thanks, Ray __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX Updater
I posted this question once before, but I don't remember getting a response and I don't have email from this list that old... Does anyone know of a size limit for input type=file...? I couldn't find one in the official HTTP RFC... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HTTP file limit?
oops, I posted this with the wrong subject line... see question below +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 2:03 PM To: CF-Talk Subject: RE: CFMX Updater I posted this question once before, but I don't remember getting a response and I don't have email from this list that old... Does anyone know of a size limit for input type=file...? I couldn't find one in the official HTTP RFC... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using a variable to collect query-like results
actually it should probably be: cfquery datasource=firmdaily name=GetMyQueryResults #preserveSingleQuotes(myquery)# /cfquery +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 1:27 PM To: CF-Talk Subject: Re: Using a variable to collect query-like results cfquery datasource=firmdaily name=GetMyQueryResults cfoutput#myquery#/cfoutput /cfquery should read cfquery datasource=firmdaily name=GetMyQueryResults #myquery# /cfquery HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Clark, Aimee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 1:16 PM Subject: Using a variable to collect query-like results Hello everyone, If you had a variable set like the one I have below...how do you then reference the variable to display the results? (sorry in advance for the long posting) -Here's the variable--- cfset myquery = Select *, CALLS.ID AS TICKET, DATENAME(MM, CALLDATE) + ' ' + DATENAME(DD, CALLDATE) + ', ' + DATENAME(, CALLDATE)AS 'DATEOFCALL', DATENAME(MM, LASTUPDATE) + ' ' + DATENAME(DD, LASTUPDATE) + ', ' + DATENAME(, LASTUPDATE)AS 'LU', Ext, ExternalEmail, LastName + ', ' + FirstName AS FullName from CALLS, Employees WHERE cfif closed IS NOT cfset myquery = myquery CLOSED = ' #CLOSED# ' /cfif cfif useridconj IS NOT cfif closed IS NOT cfset myquery = myquery #useridconj# /cfif cfset myquery = myquery CALLS.NAME = #NameID# /cfif cfif techconj IS NOT cfif nameid IS NOT cfset myquery = myquery #useridconj# /cfif cfset myquery = myquery #techconj# CALLS.TECH = ' #TECH# ' /cfif cfif calldatestart IS NOT cfset myquery = myquery #calldatefromconj# CALLS.CALLDATE = #CallDateStart# /cfif cfif calldatethru IS NOT cfset myquery = myquery AND CALLS.CALLDATE = #CallDatethru# /cfif cfif category IS NOT cfset myquery = myquery #categoryconj# CALLS.CATEGORY = ' #CATEGORY# '/cfif cfif enteredby IS NOT cfset myquery = myquery #enteredbyconj# CALLS.ENTEREDBY = ' #ENTEREDBY# '/cfif cfif callmethod IS NOT cfset myquery = myquery #callmethodconj# CALLS.CALLMETHOD = ' #CALLMETHOD# '/cfif cfif Office IS NOT cfset myquery = myquery #Officeconj# Employees.Office = ' #Office# '/cfif cfif CallDescWords IS NOT cfset myquery = myquery #descwordsconj#Calls.Issue like ' #CallDescWords# '/cfif cfif CallNotesWords IS NOT cfset myquery = myquery #noteswordsconj#Calls.Notes like ' #CallNotesWords# '/cfif cfif CallResolutionWords IS NOT cfset myquery = myquery #resolutionwordsconj# Calls.Resolution like ' #CallResolutionWords# '/cfif -Here's the query I try to use--- cfquery datasource=firmdaily name=GetMyQueryResults cfoutput#myquery#/cfoutput /cfquery -Here's the output I try to display-- cfoutput query=GetMyQueryResults tr td#Ticket#/td tda href= #FullName# mailto:#ExternalEmail# mailto:#ExternalEmail#;#FullName#/a/td td#Ext#/td tda href= #Tech# mailto:#Tech# mailto:#Tech#;#Tech#/a/td td#DateOfCall#/td td#LU#/td tda href=MonitorEdit.cfm?ID=#CallsQry.Ticket#OLDTECH=#TECH#Edit/aBR a href=MonitorClose.cfm?ID=#Ticket#OLDTECH=#TECH#Close/aBR a href=MonitorViewNotes.cfm?ID=#Ticket#Notes/a/td td#Issue#/td td#Category#/td td#Office#/td /tr /cfoutput -Here's the lovely error message I receive- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or column names. Use a single space if necessary. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (64:1) to (64:57). Date/Time: 09/17/02 15:04:06 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Hotbar 4.1.5.0) Remote Address: 10.30.25.134 HTTP Referrer: http://dailynews/helpdesk/monitorqbe.cfm http://dailynews/helpdesk/monitorqbe.cfm Does anyone have any ideas on a better way for me to generate my output? This is a Query By Example application. Thanks
RE: Man this query @#%$*
tablenames or aliases
SELECT COUNT(*) as count_ttl,
DATEPART(dy, cl1.logdate) as doy,
DATEPART(, cl1.logdate) as yr,
DATEPART(mm, cl1.logdate) as mnth,
DATEPART(d, cl1.logdate) as dy,
count(cl1.logdate) as count_in
FROM customer_log as cl2, customer_log as cl1
WHERE logdate BETWEEN #start# AND #DateAdd('D', 1, end)#
and cl1.logdate = cl2.logdate
and cl1.logtype 'callout'
GROUP BY DATEPART(dy, logdate), DATEPART(, logdate),
DATEPART(mm, logdate), DATEPART(d, logdate)
ORDER BY DATEPART(dy, logdate)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 11:57 AM
To: CF-Talk
Subject: RE: Man this query @#%$*
You need to secify the tablenames in the dateart I am sure.
Regards,
Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 1:27 PM
To: CF-Talk
Subject: RE: Man this query @#%$*
I get an Ambiguous column name 'logdate'. When I use this.
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 12:56 PM
To: CF-Talk
Subject: RE: Man this query @#%$*
Can you just do a join between the two?
SELECT COUNT(*) as count_ttl,
DATEPART(dy, logdate) as doy,
DATEPART(, logdate) as yr,
DATEPART(mm, logdate) as mnth,
DATEPART(d, logdate) as dy,
count(cl1.logdate) as count_in
FROM customer_log as cl2, customer_log as cl1
WHERE logdate BETWEEN #start# AND #DateAdd('D', 1, end)#
and cl1.logdate = cl2.logdate
and cl1.logtype 'callout'
GROUP BY DATEPART(dy, logdate), DATEPART(, logdate),
DATEPART(mm, logdate), DATEPART(d, logdate)
ORDER BY DATEPART(dy, logdate)
Dan
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 10:42 AM
To: CF-Talk
Subject: Man this query @#%$*
Can anyone out there assist me with this query? I need to count two
sets, differentiated by a text field and grouped by yet another field.
Here's what I have:
SELECT COUNT(*) as count_ttl,
DATEPART(dy, logdate) as doy,
DATEPART(, logdate) as yr,
DATEPART(mm, logdate) as mnth,
DATEPART(d, logdate) as dy,
(SELECT COUNT(*)
FROM customer_log as cl1
WHERE logtype 'callout'
AND cl1.logdate = cl2.logdate) AS count_in
FROM customer_log as cl2
WHERE logdate BETWEEN #start# AND #DateAdd('D', 1, end)#
GROUP BY DATEPART(dy, logdate), DATEPART(, logdate),
DATEPART(mm, logdate), DATEPART(d, logdate)
ORDER BY DATEPART(dy, logdate)
The problem is that cl2.logdate is not used in the GROUP BY clause nor
can I use it. Logdate contains a time stamp which screws up the GROUP
BY day functionality which is necessary for my report, thus the
DATEPART. Basically, I'm counting all lines in a date range but also
need to count just the lines in which the logtype is a specified value.
HELP!
cc
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfdirectory
and keep in mind that expandpath() evaluates a templates full path FROM THE CALLING TEMPLATE - NOT from the current web location. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:19 PM To: CF-Talk Subject: RE: cfdirectory I tried and got an error evaluating expression.. -Original Message- From: Rocky Palladino [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 1:38 PM To: CF-Talk Subject: Re: cfdirectory Is there any way to use cfdirectory this way in CF 4.5: cfdirectory ACTION=directory action DIRECTORY=../directory/files Did you try using the expandPath() function around your relative path? cfdirectory ACTION=directory action DIRECTORY=#expandPath(../directory/files)# __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfdirectory
missing quotes: ..#expandPath(../directory/files)#... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:19 PM To: CF-Talk Subject: RE: cfdirectory I tried and got an error evaluating expression.. -Original Message- From: Rocky Palladino [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 1:38 PM To: CF-Talk Subject: Re: cfdirectory Is there any way to use cfdirectory this way in CF 4.5: cfdirectory ACTION=directory action DIRECTORY=../directory/files Did you try using the expandPath() function around your relative path? cfdirectory ACTION=directory action DIRECTORY=#expandPath(../directory/files)# __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfdirectory
you're missing quotes, but otherwise this will work IF the template that has the cfdirectory... tag is in the SITE folder. If it still doesn't work you may want to add a dot to represent current folder like so: #expandPath(./images/tour)# but I can't remember offhand if the dot is required... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:40 PM To: CF-Talk Subject: RE: cfdirectory cfdirectory ACTION=directory action DIRECTORY=#expandPath(images/tour)# the actual physical path is: E:\site\images\tour the template is in the site dir and I want to go to the tour dir.. Am I correct in the way I have it formatted? I can't use that because of where we are hosting they will not give me the physical paths. -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 2:20 PM To: CF-Talk Subject: RE: cfdirectory and keep in mind that expandpath() evaluates a templates full path FROM THE CALLING TEMPLATE - NOT from the current web location. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:19 PM To: CF-Talk Subject: RE: cfdirectory I tried and got an error evaluating expression.. -Original Message- From: Rocky Palladino [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 1:38 PM To: CF-Talk Subject: Re: cfdirectory Is there any way to use cfdirectory this way in CF 4.5: cfdirectory ACTION=directory action DIRECTORY=../directory/files Did you try using the expandPath() function around your relative path? cfdirectory ACTION=directory action DIRECTORY=#expandPath(../directory/files)# __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfdirectory
actually I believe removeChars(len(listLast(...))) is faster than reverse(), but I could be wrong. Not that it really matters unless you're doing it in a loop... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:27 PM To: CF-Talk Subject: RE: cfdirectory There is also a non regex solution that's fairly simple: cfset uppath = Reverse(ListRest(Reverse(Expandpath()),/\)) Get the current base template directory, reverse it, drop the first element and reverse it again... Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Oops. Typo. Too many parens. Try: cfset uppath=rereplace(GetBaseTemplatePath(), [^\]+\\$, ) This isn't a tested copy, btw. It's cut down from something more complex I did. But it ought to give a good idea of what to do, even if it doesn't work. If it doesn't make sense, I'd be happy to explain, but let's move over to CF-RegEx where this particular solution would be more on-topic. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Webmaster [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, September 11, 2002 1:33 PM : To: CF-Talk : Subject: RE: cfdirectory : : : I got this error when trying to do that.. : : : Error Diagnostic Information : Just in time compilation error : : Invalid parser construct found on line 9 at position 45. ColdFusion was : looking at the following text: : : , : Invalid expression format. The usual cause is an error in the expression : structure. : : : : : -Original Message- : From: Ben Doom [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, September 11, 2002 11:35 AM : To: CF-Talk : Subject: RE: cfdirectory : : : It's easy enough to get the current directory and strip off the : last folder. : Something like: : : cfset uppath=rereplace(GetBaseTemplatePath()), [^\]+\\$, ) : : There may be a more efficient way to do this (anyone?) but this type of : thing has worked for me. : : : : --Ben Doom : Programmer General Lackey : Moonbow Software : : : -Original Message- : : From: Webmaster [mailto:[EMAIL PROTECTED]] : : Sent: Wednesday, September 11, 2002 12:32 PM : : To: CF-Talk : : Subject: cfdirectory : : : : : : Is there any way to use cfdirectory this way in CF 4.5: : : : : cfdirectory ACTION=directory action : : DIRECTORY=../directory/files : : : : I know if I do it this way it will work. : : : : cfdirectory ACTION=directory action : : DIRECTORY=c:\directory\files : : : : : : : : __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java and Verisign
Try this for your JVM path (it's looking for the dll): Java Virtual Machine Path: C:\Program Files\JavaSoft\JRE\1.3.1_04\bin\hotspot\jvm.dll +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: John Jonathan Kopanas [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 9:32 AM To: CF-Talk Subject: Java and Verisign This is my first time using a Java custom tag so I would appreciate if someone tell me what I am doing wrong. notes: - I am using CFX_PayFlowPro custom tag from VeriSign - Client is running CF 4.5.1 SP 2 CF ADMINISTRATION SETTINGS Java Virtual Machine Path: C:\Program Files\JavaSoft\JRE\1.3.1_04 Class Path: c:\CFusion\Java\Classes (this is where VeriSign.jar and CFXPayFlowPro.class are) CFX Jar Path: C:\CFUSION\Java\classes CFX_TAG SETTINGS Tag Name: CFX_PAYFLOWPRO Class Name: CFXPayFlowPro The error message I get is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. Does anyone know what is causing this error and how I can resolve it? Thanks. John Jonathan Kopanas __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: iif usage
I agree with Sean. IIF is slow and can ALWAYS be avoided. I'm very fond of using the following syntax as Sean pointed out, except that I use style sheet classes instead of arrays: cfset theMod = currentRow MOD 2 td class=alternateRowColor#theMod# .. /td IIF screws up the color coding of the editor and looks messy and is also difficult to immediately comprehend when scanning a page. It really has no place in well written code. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 11:00 AM To: CF-Talk Subject: Re: iif usage On Sunday, September 8, 2002, at 09:33 , Joe Eugene wrote: I dont agree with Sean or Dave... That doesn't surprise me Joe :) i dont think IIF is necessary but its a very useful function ... IF USED PROPERLY I didn't say it wasn't *useful* - I just said it was bad practice and could always be avoided. Many of you guys dont agree.. but i personally prefer using IIF and i use it only when necessary... a good example would be...table row colors. .. It is NEVER necessary. You even admit that above! i dont use the above for complex logic...write cfscript blocks of code... i am not very fond of cfif contructs... But you can structure your code to be concise without iif(). Since you want alternating colors, you should see that rownum mod 2 will give alternating 1, 0, 1, 0 values. So you could construct a two-element array containing the colors you want - do this above the loop over the table rows - and then each row just accesses the appropriate element of the array. The main benefit of this approach is that it keeps the color specification separate from the row logic instead of being embedded in the table and it also scales easily to alternately through more colors or alternating on blocks of rows. And of course it doesn't use iif() which is a big plus in my book. If you want to use iif() instead of cfif, that's up to you. Just don't ask me for a job (or a reference)... :) Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cflocation vs. server side redirect.
server side redirects allow the use of cookies since the page is processed by the browser. Cflocations are faster since the relocation happens at the server and does not have to go to the browser and back again (which is why cookies don't work with cflocation by the way). There are many different ways to do a client side redirect: - use meta refresh= tag - use javascript window.location= - use body onload=window.location='' whatever you choose you must use writeoutput() if you are in a cfscript block or set a variable to use later: cfscript if( whatever ) writeOutput(body onload=window.location=''); /cfscript +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 11:39 AM To: CF-Talk Subject: cflocation vs. server side redirect. ok, now I have heard that one is better than the other that's fine, but whats the code for the server side redirect that we can use inside cfscript tags? also, in using the server side redirect, can we set cookies on action pages, that at the end of the page use a server side redirect? as opposed to the problem with cflocation at the end of an action page, and not being able to set cookies correctly cause of the redirect? thanks .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 2:29 PM To: CF-Talk Subject: RE: iif usage IIF has its place. Someone correct me if I am wrong, but I thought I read on this list weeks ago that with MX, IIF was just as fast as CFIF. All languages have their fans in terms of language specifics and what to use and what not to use... if you do not like something, don't use it. If you like it and and the performance from your method is the best it can be, use it. So. My 2 cents. Mike -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 2:17 PM To: CF-Talk Subject: Re: iif usage Good (humor) Sean...~! I agree there are bad practices... (evaluate,cflocation, variable prefixes, spaghetti code and some others) but i dont think you should include IIF in them... Joe - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 09, 2002 1:59 PM Subject: Re: iif usage On Sunday, September 8, 2002, at 09:33 , Joe Eugene wrote: I dont agree with Sean or Dave... That doesn't surprise me Joe :) i dont think IIF is necessary but its a very useful function ... IF USED PROPERLY I didn't say it wasn't *useful* - I just said it was bad practice and could always be avoided. Many of you guys dont agree.. but i personally prefer using IIF and i use it only when necessary... a good example would be...table row colors. .. It is NEVER necessary. You even admit that above! i dont use the above for complex logic...write cfscript blocks of code... i am not very fond of cfif contructs... But you can structure your code to be concise without iif(). Since you want alternating colors, you should see that rownum mod 2 will give alternating 1, 0, 1, 0 values. So you could construct a two-element array containing the colors you want - do this above the loop over the table rows - and then each row just accesses the appropriate element of the array. The main benefit of this approach is that it keeps the color specification separate from the row logic instead of being embedded in the table and it also scales easily to alternately through more colors or alternating on blocks of rows. And of course it doesn't use iif() which is a big plus in my book. If you want to use iif() instead of cfif, that's up to you. Just don't ask me for a job (or a reference)... :) Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cflocation vs. server side redirect.
I haven't worked with CFMX yet, so my replies are for CF 4.5 and 5.0 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 12:05 PM To: CF-Talk Subject: RE: cflocation vs. server side redirect. server side redirects allow the use of cookies since the page is processed by the browser. Cflocations are faster since the relocation happens at the server and does not have to go to the browser and back again (which is why cookies don't work with cflocation by the way). There are many different ways to do a client side redirect: - use meta refresh= tag - use javascript window.location= - use body onload=window.location='' whatever you choose you must use writeoutput() if you are in a cfscript block or set a variable to use later: cfscript if( whatever ) writeOutput(body onload=window.location=''); /cfscript +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 11:39 AM To: CF-Talk Subject: cflocation vs. server side redirect. ok, now I have heard that one is better than the other that's fine, but whats the code for the server side redirect that we can use inside cfscript tags? also, in using the server side redirect, can we set cookies on action pages, that at the end of the page use a server side redirect? as opposed to the problem with cflocation at the end of an action page, and not being able to set cookies correctly cause of the redirect? thanks tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 2:29 PM To: CF-Talk Subject: RE: iif usage IIF has its place. Someone correct me if I am wrong, but I thought I read on this list weeks ago that with MX, IIF was just as fast as CFIF. All languages have their fans in terms of language specifics and what to use and what not to use... if you do not like something, don't use it. If you like it and and the performance from your method is the best it can be, use it. So. My 2 cents. Mike -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 2:17 PM To: CF-Talk Subject: Re: iif usage Good (humor) Sean...~! I agree there are bad practices... (evaluate,cflocation, variable prefixes, spaghetti code and some others) but i dont think you should include IIF in them... Joe - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 09, 2002 1:59 PM Subject: Re: iif usage On Sunday, September 8, 2002, at 09:33 , Joe Eugene wrote: I dont agree with Sean or Dave... That doesn't surprise me Joe :) i dont think IIF is necessary but its a very useful function ... IF USED PROPERLY I didn't say it wasn't *useful* - I just said it was bad practice and could always be avoided. Many of you guys dont agree.. but i personally prefer using IIF and i use it only when necessary... a good example would be...table row colors. .. It is NEVER necessary. You even admit that above! i dont use the above for complex logic...write cfscript blocks of code... i am not very fond of cfif contructs... But you can structure your code to be concise without iif(). Since you want alternating colors, you should see that rownum mod 2 will give alternating 1, 0, 1, 0 values. So you could construct a two-element array containing the colors you want - do this above the loop over the table rows - and then each row just accesses the appropriate element of the array. The main benefit of this approach is that it keeps the color specification separate from the row logic instead of being embedded in the table and it also scales easily to alternately through more colors or alternating on blocks of rows. And of course it doesn't use iif() which is a big plus in my book. If you want to use iif() instead of cfif, that's up to you. Just don't ask me for a job (or a reference)... :) Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really
RE: Client Vars again
I'm late on this one, but it's worth the reply I think... I noticed you are using StructClear(session)#... Don't know if it's true in CFMX, but you NEVER want to do this in CF 4.5 or 5.0. There is a variable named session.sessionID that is ONLY created at the beginning of a session. If you delete it then it's gone until the browser is closed and a new session begins. I don't know what it is used for, but occasionally in the past it has caused problems for me (before I knew about it). If you want to use StructClear then store session.sessionID in a temp var before using StructClear then put it back in the session struct after clearing. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 8:19 AM To: CF-Talk Subject: Re: Client Vars again To ensure our logged-out (or timed-out) user is completely removed from our application, we delete: 1. the entire session structure, 2. all the client vars (one at a time), 3. set the cookies to delete, and 4. use non-persistent cookies anyway. I know that sounds redundant, but it's been robust for us. Chris Norloff !--- delete the session (all vars, including CFID CFTOKEN) --- cflock timeout=#variables.lock_timeout# throwontimeout=Yes scope=session type=EXCLUSIVE cfset temp = #StructClear(session)# /cflock !--- delete all client vars --- cfset variables.client_var_list = #GetClientVariablesList()# cfloop index=list_element list=#variables.client_var_list# delimiters=, cfset temp = DeleteClientVariable(#list_element#) /cfloop !--- delete cookies --- cfcookie name=CFID value=empty expires=NOW cfcookie name=CFTOKEN value=empty expires=NOW -- Original Message -- from: Adrian Lynch [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 6 Sep 2002 18:53:51 +0100 I've posted this to CF-Talk, sorry for any who get both and don't like cross posts... Is there anyone out there that's built reliable login/logout functionality into their site? Something that works on ALL browser combinations? This is what we're doing... Client vars stored in a DB Using the usual code to kill a session on close of the browser CFMX, SQL Server 7 Testing on most combinations of browser. Trying to figure out what's going wrong wouldn't be so bad if we could just have some consistency in the way it's going wrong. We have... Logging in on 2nd, 3rd, 4th, 5th try instead of the 1st Not able to log out, trying both reseting the client vars back to their original state and deleting them altogether Having to change a cflocation to a window.location to get it to log in on IE5 (don't ask) I've just said to the guy I'm building it with, shall we pass cfid and cftoken in all the links and redirects, see if that cures it. What does everyone else think. It's not the easiest thing to debug something that you can't reliably replicate :O( Adrian Lynch Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cflocation vs. server side redirect.
you wrote: This is incorrect. cflocation simply sends a HTTP 302 Found statuscode to the browser together with a Location header. How could the URL one sees in the browser possibly change if nothing was send to the browser? This is my understanding: Of course something is sent to the browser, but AFTER the cflocation happens. Say for example you have page1, page2, and page3. Page1 is a form, page2 processes the form, and page3 is a thank you page. Server side (cflocation): - user submits page1 - server processes page2 - server requests page3 - server processes page3 - server returns page3 Client side (using JS or HTML): - user submits page1 - server processes page 2 - server returns page2 - browser requests page3 - server processes page3 - server returns page3 Maybe I'm wrong, but I don't think so... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 12:25 PM To: CF-Talk Subject: Re: cflocation vs. server side redirect. Bryan Love wrote: server side redirects allow the use of cookies since the page is processed by the browser. Cflocations are faster since the relocation happens at the server and does not have to go to the browser and back again (which is why cookies don't work with cflocation by the way). This is incorrect. cflocation simply sends a HTTP 302 Found statuscode to the browser together with a Location header. How could the URL one sees in the browser possibly change if nothing was send to the browser? There are many different ways to do a client side redirect: - use meta refresh= tag - use javascript window.location= - use body onload=window.location='' All of these depend on a user client understanding at least HTTP and HTML (and possibly javascript). I would go for cflocation because that only requires the user client to understand HTTP. Jochem __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mysterious second set of single quotes
the most obvious answer is to not write anything to the db until they have confirmed all is correct. Just pass the form fields through to the next page... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 1:38 PM To: CF-Talk Subject: Mysterious second set of single quotes I have a variable I build before inserting into my query called where cfset where = #where##table#id = '#attributes.id#' Then I put into my query... cfquery name=search datasource=#session.datasource# SELECT t.id,t.product_name,t.operator,t.stage,t.qc_lot,r.s4_time,r.s5_time FROM trip_data t, report_stamps r WHERE t.id = r.id AND #where# /cfquery If I output the variable before the query like so (line 2) I get t.id='100' 1. cfset where = #where##table#id = '#attributes.id#' 2. cfoutput#where#/cfoutputcfabort 3. cfquery name=search 4. datasource=#session.datasource# 5. SELECT t.id,t.product_name,t.operator,t.stage,t.qc_lot,r.s4_time,r.s5_time 6. FROM trip_data t, report_stamps r 7. WHERE t.id = r.id AND #where# 8. /cfquery However when I ditch line 2 the query output has two single quotes surrounding my variable. EXAMPLE OUTPUT IN QUERY 1. SELECT t.id,t.product_name,t.operator, 2. t.stage,t.qc_lot,r.s4_time,r.s5_time 3. FROM trip_data t, report_stamps r 4. WHERE t.id = r.id AND t.id = ''100'' Notice line 4 Does anyone know why CFML adds this mysterious second set of single quotes when I output within the cfquery tags? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mysterious second set of single quotes
oops, I replied to the wrong thread! please disregard! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 1:50 PM To: CF-Talk Subject: RE: Mysterious second set of single quotes the most obvious answer is to not write anything to the db until they have confirmed all is correct. Just pass the form fields through to the next page... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 1:38 PM To: CF-Talk Subject: Mysterious second set of single quotes I have a variable I build before inserting into my query called where cfset where = #where##table#id = '#attributes.id#' Then I put into my query... cfquery name=search datasource=#session.datasource# SELECT t.id,t.product_name,t.operator,t.stage,t.qc_lot,r.s4_time,r.s5_time FROM trip_data t, report_stamps r WHERE t.id = r.id AND #where# /cfquery If I output the variable before the query like so (line 2) I get t.id='100' 1. cfset where = #where##table#id = '#attributes.id#' 2. cfoutput#where#/cfoutputcfabort 3. cfquery name=search 4. datasource=#session.datasource# 5. SELECT t.id,t.product_name,t.operator,t.stage,t.qc_lot,r.s4_time,r.s5_time 6. FROM trip_data t, report_stamps r 7. WHERE t.id = r.id AND #where# 8. /cfquery However when I ditch line 2 the query output has two single quotes surrounding my variable. EXAMPLE OUTPUT IN QUERY 1. SELECT t.id,t.product_name,t.operator, 2. t.stage,t.qc_lot,r.s4_time,r.s5_time 3. FROM trip_data t, report_stamps r 4. WHERE t.id = r.id AND t.id = ''100'' Notice line 4 Does anyone know why CFML adds this mysterious second set of single quotes when I output within the cfquery tags? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
File Upload Size Limit?
Does anyone know if there is a file upload size limit for input type=file...? Anyone? Anyone? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:22 PM To: CF-Talk Subject: Re: Bulk Insert Does cfuser have the below? db_owner db_ddladmin db_datareader db_datawriter cfuser should have the above privileges to be able to create objects as dbo. Joe - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 09, 2002 7:13 PM Subject: Bulk Insert I wonder if any one can help with this one. SQL Server management is not my strongest skill :) I'm using a SQL Server login account via CF (cfuser). When I create a table via CF, the tables owner is cfuser rather than DBO. This is fine, until I try to do a BULK INSERT and get an error on the opentable statement. I can run the BULK INSERT on any of the tables owned by dbo. I set up a new account, with sys_admin privileges and even this account can not run the BULK INSERT. Another funny thing is the owner account (cfuser) can also not run the BULK INSERT. Does any one know why this would be? Thanks :) Brook Davies __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamically naming arrays
checking to see if it's defined is simple:
cfif isdefined(Application.#theVar#)
or
cfif structKeyExists(application,theVar)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: bryan.hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 8:38 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Well heck, I don't know what I did to make it work with Rays, but now in
trying it is not. Anyways, I got the cfset to work but how would I do the
isdefined.
-- Original Message --
From: Bryan Love [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Thu, 5 Sep 2002 16:22:57 -0700
Actually they both work.
Run this for proof:
cfset theVar = foo
cflock scope=APPLICATION type=EXCLUSIVE timeout=5
cfset application.#theVar# = arrayNew(1)
cfset bar = evaluate(application. theVar)
cfif isArray(bar)
hooray!
/cfif
/cflock
cfabort
-
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:10 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
This unfortunately turned the array into a string. Ray's idea worked
flawlessly. Thanks anyways.
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 4:14 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
or alternatively
cfset Application.#dynamicName# = arrayNew(1)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 1:00 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Well, since Application is a structure itself, you can easily do:
cfset Application[dynamicName] = arrayNew(1)
Don't forget your cflock of course.
===
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:46 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Yes, I could. I went off into the wrong direction on this one from the
start. Is there a way to do it with the arrays so I don't
have to write the
thing over again?
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:39 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Why not just use structures? If Application.Chat was a structure, you
could easily add dynamic values to it by using bracket notation.
==
=
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:26 PM
To: CF-Talk
Subject: dynamically naming arrays
In the following code I am trying to make the application.users and
application.chat arrays dynamically named.
I have a variable called variables.currentroomid which I
would like to be
appended to the application.chat and application.users arrays
like this
application.chatX where x is the variables.currentroomid variable.
How can I do this?
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=SESSION
CFIF ISDEFINED('SESSION.CHATUSERNAME')
CFSET ENTERROOM =
CFELSE
CFSET ENTERROOM = ENTERS ROOM
/CFIF
/CFLOCK
CFPARAM NAME=FORM.CHAT DEFAULT=#VARIABLES.ENTERROOM#
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFIF NOT ISDEFINED('APPLICATION.USERS')
CFSET
RE: CFMODULE vs CFINCLUDE
cfinclude is WAY WAY WAY faster ALWAYS use includes if you can... Of course there will always be circumstances where you won't be able to (like recursive calls), but always try. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 10:55 AM To: CF-Talk Subject: CFMODULE vs CFINCLUDE I have a page where I want to conditionally include specific code blocks which exist in other pages. What is more efficient, CFMODULE or CFINCLUDE? Thanks __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: ecommerce live chat case study
Most decent chat applications are pure Java, but there are alternatives... Check out AlohaPost here: http://aloha-webdesign.com An example is at the bottom of the home page. A friend of mine wrote it and it's pretty neat. I think it uses iFrames so it might be IE specific, but not sure. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 10:26 AM To: CF-Talk Subject: Re: OT: ecommerce live chat case study On Friday, September 6, 2002, at 05:37 , I-Lin Kuo wrote: Has anybody every implemented a live chat? I'm thinking of adding chat capability to an e-commerce site so customers can ask questions as they shop without picking up a phone. How difficult is it? If you use Flash MX and the Flash Communication Server, this is pretty much trivial. The FlashCom UI Components for Flash make this almost a drag' n'drop exercise and FlashCom itself is very easy to script. The bonus about taking this approach is the ease with which you can integrate it with a ColdFusion MX web site... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Vars again
how did you confirm that the client vars are not being recorded in DB? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:13 PM To: CF-Talk Subject: RE: Client Vars again DB: SQL Server 2000; Client OS: win2k; intranet app; single server win2k server. Application.cfm set for clientmanagement=Yes, clientstorage=the SQl data source, which was successfully registered w/in CF. Using cflocation addtoken=yes. First we thought everything was great; then we ran the app on another pc in the office. Client variables were not writing to the db, although they were writing successfully on the 2 developers' machines. Checked browser versions, os versions, couldn't find any links to identify where the problem was. Again, these two machines were writing the client var strings correctly to the database. Read on MM site that addtoken=yes will cause CFID to increment, which we did find to be true for SOME of the pcs. Changed addtoken to no; the machines they didn't carry the variables successfully now did not write to the database at all. My machine was the only one of the 5 that kept working no matter what. Uninstalled CFMX, reinstalled, changed addtoken to yes, and now my machine did the same thing (CFID incrementing, one row per write to the client state). No other machines were able to write to the db, although they sometimes seemed to actually carry the variables in memory successfully. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 3:51 PM To: CF-Talk Subject: RE: Client Vars again Hi Susan, Can you give full details. Db, os, whats the applciation, intranet/extranet/web,cfserver details,cluster/singleserver? Have you tried session vars or homegrown client vars? Can you consistently set a cookie and across page requests read it properly? DRE -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:50 PM To: CF-Talk Subject: RE: Client Vars again Adrian: I posted to CF-Talk several times yesterday (with no useful results) with a similar problem regarding client vars. We are now re-engineering to write cookies instead. I had posted a notice from MM about cflocation addtoken=yes incrementing CFID. Look at your CFID table; we had new rows being written for each write to the client state, with incremented CFIDs. We changed to addtoken=no and all of a sudden only one user could write to the database at all. We tried, as you have, to find a common denominator to explain the inconsistent behavior among 5 machines; browser versions, os versions, etc. After much trial and error, I uninstalled CFMX, reinstalled, and are now using cookies instead. Hope you have better luck than us; like I said, take a look at your db and you may see the same symptoms. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- On Fri, 6 Sep 2002, Adrian Lynch wrote: I've posted this to CF-Talk, sorry for any who get both and don't like cross posts... Is there anyone out there that's built reliable login/logout functionality into their site? Something that works on ALL browser combinations? This is what we're doing... Client vars stored in a DB Using the usual code to kill a session on close of the browser CFMX, SQL Server 7 Testing on most combinations of browser. Trying to figure out what's going wrong wouldn't be so bad if we could just have some consistency in the way it's going wrong. We have... Logging in on 2nd, 3rd, 4th, 5th try instead of the 1st Not able to log out, trying both reseting the client vars back to their original state and deleting them altogether Having to change a cflocation to a window.location to get it to log in on IE5 (don't ask) I've just said to the guy I'm building it with, shall we pass cfid and cftoken in all the links and redirects, see if that cures it. What does everyone else think. It's not the easiest thing to debug something that you can't reliably replicate :O( Adrian Lynch Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do
RE: Variable Precedence
if you leave a variable unscoped it will search in this order (in CF 4.5 and I think 5.0): query (if inside of a cfoutput query=) variables url form +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 11:47 AM To: CF-Talk Subject: Variable Precedence Is there a Precedence in the order Variable assignment. IE If for some reason you have variables named the same which one has Precedence. If So does any one have a list of the Variable Precedence. Thx Jim __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Vars again
remember that the CFID can come from the following scopes: - session - cookie - client - url I don't know the order these are searched in when no scope is specified - CFID seems to be an exception to the standard scoping rule since it can be found without scoping even when it doesn't exist in the url, form, or variables scope. Anyway, make sure they are all the same and if not then make sure you're looking up the right one. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:23 PM To: CF-Talk Subject: RE: Client Vars again Well, I opened the CFID and CFGLOBAL tables and the rows corresponding to the CFID/CFTOKEN in the dubugging results were not there. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 4:18 PM To: CF-Talk Subject: RE: Client Vars again how did you confirm that the client vars are not being recorded in DB? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:13 PM To: CF-Talk Subject: RE: Client Vars again DB: SQL Server 2000; Client OS: win2k; intranet app; single server win2k server. Application.cfm set for clientmanagement=Yes, clientstorage=the SQl data source, which was successfully registered w/in CF. Using cflocation addtoken=yes. First we thought everything was great; then we ran the app on another pc in the office. Client variables were not writing to the db, although they were writing successfully on the 2 developers' machines. Checked browser versions, os versions, couldn't find any links to identify where the problem was. Again, these two machines were writing the client var strings correctly to the database. Read on MM site that addtoken=yes will cause CFID to increment, which we did find to be true for SOME of the pcs. Changed addtoken to no; the machines they didn't carry the variables successfully now did not write to the database at all. My machine was the only one of the 5 that kept working no matter what. Uninstalled CFMX, reinstalled, changed addtoken to yes, and now my machine did the same thing (CFID incrementing, one row per write to the client state). No other machines were able to write to the db, although they sometimes seemed to actually carry the variables in memory successfully. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 3:51 PM To: CF-Talk Subject: RE: Client Vars again Hi Susan, Can you give full details. Db, os, whats the applciation, intranet/extranet/web,cfserver details,cluster/singleserver? Have you tried session vars or homegrown client vars? Can you consistently set a cookie and across page requests read it properly? DRE -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:50 PM To: CF-Talk Subject: RE: Client Vars again Adrian: I posted to CF-Talk several times yesterday (with no useful results) with a similar problem regarding client vars. We are now re-engineering to write cookies instead. I had posted a notice from MM about cflocation addtoken=yes incrementing CFID. Look at your CFID table; we had new rows being written for each write to the client state, with incremented CFIDs. We changed to addtoken=no and all of a sudden only one user could write to the database at all. We tried, as you have, to find a common denominator to explain the inconsistent behavior among 5 machines; browser versions, os versions, etc. After much trial and error, I uninstalled CFMX, reinstalled, and are now using cookies instead. Hope you have better luck than us; like I said, take a look at your db and you may see the same symptoms. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- On Fri, 6 Sep 2002, Adrian Lynch wrote: I've posted this to CF-Talk, sorry for any who get both and don't like cross posts... Is there anyone out there that's
RE: Client Vars again
let me expand on that a little The ONLY way the server knows who you (the client) are is by you passing your CFID and CFTOKEN to the server. The only way that can happen is via COOKIE or URL. Compare the COOKIE and URL values for CFID and CFTOKEN and ensure they are the same. Perhaps one of them is getting changed and that is throwing you off... Also, be sure to delete all cookies on the test machine(s) before running the test and comparing the results to those on other test machine(s). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:39 PM To: CF-Talk Subject: RE: Client Vars again remember that the CFID can come from the following scopes: - session - cookie - client - url I don't know the order these are searched in when no scope is specified - CFID seems to be an exception to the standard scoping rule since it can be found without scoping even when it doesn't exist in the url, form, or variables scope. Anyway, make sure they are all the same and if not then make sure you're looking up the right one. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:23 PM To: CF-Talk Subject: RE: Client Vars again Well, I opened the CFID and CFGLOBAL tables and the rows corresponding to the CFID/CFTOKEN in the dubugging results were not there. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 4:18 PM To: CF-Talk Subject: RE: Client Vars again how did you confirm that the client vars are not being recorded in DB? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:13 PM To: CF-Talk Subject: RE: Client Vars again DB: SQL Server 2000; Client OS: win2k; intranet app; single server win2k server. Application.cfm set for clientmanagement=Yes, clientstorage=the SQl data source, which was successfully registered w/in CF. Using cflocation addtoken=yes. First we thought everything was great; then we ran the app on another pc in the office. Client variables were not writing to the db, although they were writing successfully on the 2 developers' machines. Checked browser versions, os versions, couldn't find any links to identify where the problem was. Again, these two machines were writing the client var strings correctly to the database. Read on MM site that addtoken=yes will cause CFID to increment, which we did find to be true for SOME of the pcs. Changed addtoken to no; the machines they didn't carry the variables successfully now did not write to the database at all. My machine was the only one of the 5 that kept working no matter what. Uninstalled CFMX, reinstalled, changed addtoken to yes, and now my machine did the same thing (CFID incrementing, one row per write to the client state). No other machines were able to write to the db, although they sometimes seemed to actually carry the variables in memory successfully. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 3:51 PM To: CF-Talk Subject: RE: Client Vars again Hi Susan, Can you give full details. Db, os, whats the applciation, intranet/extranet/web,cfserver details,cluster/singleserver? Have you tried session vars or homegrown client vars? Can you consistently set a cookie and across page requests read it properly? DRE -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:50 PM To: CF-Talk Subject: RE: Client Vars again Adrian: I posted to CF-Talk several times yesterday (with no useful
RE: Client Vars again
I know you are storing client vars in the DB, but that's only one piece of the puzzle. CF must have a way of associating incoming requests with their respective client variables. It does that using CFID and CFTOKEN and the ONLY way it knows what those are is by the client passing them in via COOKIE or URL. No matter how complicated things are behind the scenes it all boils down to the browser passing the CFID and CFTOKEN back to the server via COOKIE or URL. I know... it was a revelation to me too when I really thought about this for the first time :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 2:02 PM To: CF-Talk Subject: RE: Client Vars again We are not talking cookies here. We were using client variables written to a database, as recommended by MM best practices. We ran the same two pages of simplified code on each machine (and yes, the app was running from the server), with the results I described. We systematically excluded browser version differences, os version differences, user profiles, file privileges, etc. As I said before, there is a known bug with cflocation incrementing cfid, the results of which are clearly seen in the CFID/CFGLOBAL tables. The known bug's fix made our situation worse. We are NOW using cookies instead of storing client variables to the database. I just thought it might be of interest to this group, seeing as I found several references to similar problems on other support sites, and those requests also were never resolved. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 4:29 PM To: CF-Talk Subject: RE: Client Vars again Hmm. I'm assuming that when you say we ran the app on another pc in the office, you mean that you made requests to the test server and that the client vars were incrementing or not working from that client. Checekd that its accepting cookies? The first thing I would do is reproduce the problem from the ground up. So, setup a test page that writes a cookie incrementally or something. So, everytime you hit it, your cookie value should increase by 1. Try this from every browser in the office. Maybe you can find a problem there. Then setup a client var incrementing on that same page so that everytime you increment the value of the client var and then read it on the next request. Make sure that's working. If its not, also try session vars and seeif they do the same thing. If all that works perfectly, I'd suspect something going on in your code. Hopefully you can start with that! DRE Ps. It's a stressfull thing so be thorough and clear minded! -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 2:13 PM To: CF-Talk Subject: RE: Client Vars again DB: SQL Server 2000; Client OS: win2k; intranet app; single server win2k server. Application.cfm set for clientmanagement=Yes, clientstorage=the SQl data source, which was successfully registered w/in CF. Using cflocation addtoken=yes. First we thought everything was great; then we ran the app on another pc in the office. Client variables were not writing to the db, although they were writing successfully on the 2 developers' machines. Checked browser versions, os versions, couldn't find any links to identify where the problem was. Again, these two machines were writing the client var strings correctly to the database. Read on MM site that addtoken=yes will cause CFID to increment, which we did find to be true for SOME of the pcs. Changed addtoken to no; the machines they didn't carry the variables successfully now did not write to the database at all. My machine was the only one of the 5 that kept working no matter what. Uninstalled CFMX, reinstalled, changed addtoken to yes, and now my machine did the same thing (CFID incrementing, one row per write to the client state). No other machines were able to write to the db, although they sometimes seemed to actually carry the variables in memory successfully. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 3:51 PM To: CF-Talk Subject: RE: Client Vars again Hi Susan, Can you give full details. Db, os, whats the applciation, intranet/extranet/web,cfserver details,cluster/singleserver? Have you tried session vars or homegrown client vars
RE: Client Vars again
keep in mind that you probably were using cookies before, you just didn't know it. Unless you specify cfapplication... setClientCookies=no then cookies will be used. If you do specify ...cookies=no then you MUST pass CFID and CFTOKEN in the url string. Otherwise you lose your session with every request. This has been the source of many problems I've seen. Many people don't realize that cfapplication sets cookies and so they wonder why their session persists even after the browser closes. If you let cfapplication set cookies you must replace them with temporary ones or they will still be there days, weeks, months later. That can cause a problem debugging if you don't realize they exist... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 2:12 PM To: CF-Talk Subject: RE: Client Vars again Thanks, but the problem was not with cookies. This is the MM posting I posted yesterday. As I said, we also changed addtoken to no and experienced other more puzzling problems. We are now using cookies, no problems. MM Forum posting: July 16, 2002 4:11 PM I have two servers where I have installed my web pages. On one machine it works fine. On the other, the client variables seem to not be saved. I have set the client variables to be saved in the database on both machines. On the one that doesn't work, it seems like when I submit my login form, the next page doesn't know about the client variables. It also seems to generate a new row in my database. It's almost acting like it doesn't know who it is so it's generating every single time. I've tried setting it to registry and cookie and have the same results. As it turns out the bug was that CFMX changed the default attribute setting on the cflocation tag. It used to default to addtoken=no, but now defaults to addtoken =yes. Because we have a snippet of code that prevents session hijacking by removing the CFID CFTOKEN from the url line, this caused every CFLOCATION to increment the CFID and actually lose state. Small CF change, but big problem for us until we were able to figure it out. Everything was back to normal when we added addtoken=no to each occurrence in the site. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Rock Run Center, Ste. 280 5700 Lombardo Center Dr. Seven Hills, OH 44131 phone: 216.328.8926 fax: 216.328.9452 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 4:55 PM To: CF-Talk Subject: RE: Client Vars again let me expand on that a little The ONLY way the server knows who you (the client) are is by you passing your CFID and CFTOKEN to the server. The only way that can happen is via COOKIE or URL. Compare the COOKIE and URL values for CFID and CFTOKEN and ensure they are the same. Perhaps one of them is getting changed and that is throwing you off... Also, be sure to delete all cookies on the test machine(s) before running the test and comparing the results to those on other test machine(s). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:39 PM To: CF-Talk Subject: RE: Client Vars again remember that the CFID can come from the following scopes: - session - cookie - client - url I don't know the order these are searched in when no scope is specified - CFID seems to be an exception to the standard scoping rule since it can be found without scoping even when it doesn't exist in the url, form, or variables scope. Anyway, make sure they are all the same and if not then make sure you're looking up the right one. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:23 PM To: CF-Talk Subject: RE: Client Vars again Well, I opened the CFID and CFGLOBAL tables and the rows
RE: Query to CSV problem
This should speed things up some... It eliminates the IF statement and the count increment - both of which are slow. Try changing the value of blockfactor to get different performance results. -Code-- CFQUERY NAME=getUserDetails Query database /CFQUERY cfset blockfactor = 500 cfloop from=1 to=#getUserDetails.recordcount# step=#blockFactor# index=i CFOUTPUT QUERY=getUserDetails startrow=#i# maxrows=#blockFactor# CFSET csvstring=csvstring #id#,#replace(first_name,',','ALL')#,#replace(last_name,',','ALL')#,#replac e(email,',','ALL')#,#replace(postcode_P1,',','ALL')# chr(10) /CFOUTPUT CFFILE ACTION=APPEND FILE=thecsvfile.csv OUTPUT=#csvstring# ADDNEWLINE=No cfset csvstring = /cfloop +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Colin Murphy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:17 AM To: CF-Talk Subject: Query to CSV problem I am looking for a solution to outputing a query to a CSV file. I am currently querying the database, and running through the results and storing them in a string. Once I have stored 500 results I append them to the CSV file and reset the string. -Code-- CFQUERY NAME=getUserDetails Query database /CFQUERY CFOUTPUT QUERY=getUserDetails CFSET csvstring=csvstring #id#,#replace(first_name,',','ALL')#,#replace(last_name,',','ALL')#,#replac e(email,',','ALL')#,#replace(postcode_P1,',','ALL')# chr(10) CFIF #count# EQ 500 OR #getUserDetails.CurrentRow# EQ #getUserDetails.RecordCount# CFFILE ACTION=APPEND FILE=thecsvfile.csv OUTPUT=#csvstring# ADDNEWLINE=No CFSET count=0 CFSET csvstring= /cfif CFSET count=#count#+1 /CFOUTPUT --Code-- The query currently returns 100,000 records, and takes about 5 seconds to process but the page keeps timing out. The timeout on the server is 2 minutes, which I dont want to increase. I need this process to be performed as quickly as possible, under 2 minutes. I know I could increase the timeout for the page by calling the page using 'requesttimeout' in the URL. Any suggestions would be grateful. thanks, Colin Murphy http://www.colin-murphy.co.uk __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query to CSV problem
BTW... I just ran some tests on this out of curiosity and the looping structure I wrote below is more than 10 times faster than using the IF statement with a counter. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 10:18 AM To: CF-Talk Subject: RE: Query to CSV problem This should speed things up some... It eliminates the IF statement and the count increment - both of which are slow. Try changing the value of blockfactor to get different performance results. -Code-- CFQUERY NAME=getUserDetails Query database /CFQUERY cfset blockfactor = 500 cfloop from=1 to=#getUserDetails.recordcount# step=#blockFactor# index=i CFOUTPUT QUERY=getUserDetails startrow=#i# maxrows=#blockFactor# CFSET csvstring=csvstring #id#,#replace(first_name,',','ALL')#,#replace(last_name,',','ALL')#,#replac e(email,',','ALL')#,#replace(postcode_P1,',','ALL')# chr(10) /CFOUTPUT CFFILE ACTION=APPEND FILE=thecsvfile.csv OUTPUT=#csvstring# ADDNEWLINE=No cfset csvstring = /cfloop +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Colin Murphy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:17 AM To: CF-Talk Subject: Query to CSV problem I am looking for a solution to outputing a query to a CSV file. I am currently querying the database, and running through the results and storing them in a string. Once I have stored 500 results I append them to the CSV file and reset the string. -Code-- CFQUERY NAME=getUserDetails Query database /CFQUERY CFOUTPUT QUERY=getUserDetails CFSET csvstring=csvstring #id#,#replace(first_name,',','ALL')#,#replace(last_name,',','ALL')#,#replac e(email,',','ALL')#,#replace(postcode_P1,',','ALL')# chr(10) CFIF #count# EQ 500 OR #getUserDetails.CurrentRow# EQ #getUserDetails.RecordCount# CFFILE ACTION=APPEND FILE=thecsvfile.csv OUTPUT=#csvstring# ADDNEWLINE=No CFSET count=0 CFSET csvstring= /cfif CFSET count=#count#+1 /CFOUTPUT --Code-- The query currently returns 100,000 records, and takes about 5 seconds to process but the page keeps timing out. The timeout on the server is 2 minutes, which I dont want to increase. I need this process to be performed as quickly as possible, under 2 minutes. I know I could increase the timeout for the page by calling the page using 'requesttimeout' in the URL. Any suggestions would be grateful. thanks, Colin Murphy http://www.colin-murphy.co.uk __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anything better than Quilldesign's Site Director or Able Comm erce???
Hell yes. Check out NetReady for a full-featured hardcore ecommerce solution. ***Nothing*** performs better or is easier to integrate. For a few hundred bucks you can't go wrong! http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 11:06 AM To: CF-Talk Subject: Anything better than Quilldesign's Site Director or Able Commerce??? Are there any packages out there that are better than Quilldesign's Site Director or Able Commerce? I'm just gathering opinions. Ché Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Looking for mail tag - submit form emails contents without al l the code...
actually, loop over the fieldNames variable instead to avoid having the list of fieldNames in the mail output: cfset entry= CFLOOP list=#form.fieldNames# index=field cfset entry=entry#field#=#StructFind(form, field)#chr(13)chr(10) /CFLOOP cfmail ... #entry# /cfmail +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 12:36 PM To: CF-Talk Subject: Re: Looking for mail tag - submit form emails contents without all the code... Something like: cfset entry= CFLOOP collection=#form# item=field cfset entry=entry#field#=#StructFind(form, field)#chr(13)chr(10) /CFLOOP cfmail ... #entry# /cfmail HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 *** Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm *** inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Steven A. del Sol [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 2:22 PM Subject: Looking for mail tag - submit form emails contents without all the code... I am sure there is something so simple to this... I would like to send the users form variables to a contact email. Is there a tag to do this? Without writing some long old CFMAIL? Steve __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamically naming arrays
or alternatively
cfset Application.#dynamicName# = arrayNew(1)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 1:00 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Well, since Application is a structure itself, you can easily do:
cfset Application[dynamicName] = arrayNew(1)
Don't forget your cflock of course.
===
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:46 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Yes, I could. I went off into the wrong direction on this one from the
start. Is there a way to do it with the arrays so I don't
have to write the
thing over again?
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:39 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Why not just use structures? If Application.Chat was a structure, you
could easily add dynamic values to it by using bracket notation.
==
=
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:26 PM
To: CF-Talk
Subject: dynamically naming arrays
In the following code I am trying to make the application.users and
application.chat arrays dynamically named.
I have a variable called variables.currentroomid which I
would like to be
appended to the application.chat and application.users arrays
like this
application.chatX where x is the variables.currentroomid variable.
How can I do this?
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=SESSION
CFIF ISDEFINED('SESSION.CHATUSERNAME')
CFSET ENTERROOM =
CFELSE
CFSET ENTERROOM = ENTERS ROOM
/CFIF
/CFLOCK
CFPARAM NAME=FORM.CHAT DEFAULT=#VARIABLES.ENTERROOM#
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFIF NOT ISDEFINED('APPLICATION.USERS')
CFSET APPLICATION.USERS=ARRAYNEW(1)
/CFIF
/CFLOCK
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFIF NOT ISDEFINED('SESSION.CHATUSERNAME')
CFSET
SESSION.CHATUSERNAME=UCASE(TRIM(GETMEMBERNAME.USERNAME))
CFSET
ARRAYAPPEND(APPLICATION.USERS,SESSION.CHATUSERNAME)
/CFIF
/CFLOCK
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFIF NOT ISDEFINED('APPLICATION.CHAT')
CFSET APPLICATION.CHAT=ARRAYNEW(1)
CFSET ARRAYAPPEND(APPLICATION.CHAT,'')
/CFIF
/CFLOCK
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFSET
ARRAYAPPEND(APPLICATION.CHAT,BSESSION.CHATUSERNAME :/B
FORM.CHAT)
/CFLOCK
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamically naming arrays
Actually they both work.
Run this for proof:
cfset theVar = foo
cflock scope=APPLICATION type=EXCLUSIVE timeout=5
cfset application.#theVar# = arrayNew(1)
cfset bar = evaluate(application. theVar)
cfif isArray(bar)
hooray!
/cfif
/cflock
cfabort
-
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:10 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
This unfortunately turned the array into a string. Ray's idea worked
flawlessly. Thanks anyways.
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 4:14 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
or alternatively
cfset Application.#dynamicName# = arrayNew(1)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 1:00 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Well, since Application is a structure itself, you can easily do:
cfset Application[dynamicName] = arrayNew(1)
Don't forget your cflock of course.
===
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:46 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Yes, I could. I went off into the wrong direction on this one from the
start. Is there a way to do it with the arrays so I don't
have to write the
thing over again?
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:39 PM
To: CF-Talk
Subject: RE: dynamically naming arrays
Why not just use structures? If Application.Chat was a structure, you
could easily add dynamic values to it by using bracket notation.
==
=
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 3:26 PM
To: CF-Talk
Subject: dynamically naming arrays
In the following code I am trying to make the application.users and
application.chat arrays dynamically named.
I have a variable called variables.currentroomid which I
would like to be
appended to the application.chat and application.users arrays
like this
application.chatX where x is the variables.currentroomid variable.
How can I do this?
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=SESSION
CFIF ISDEFINED('SESSION.CHATUSERNAME')
CFSET ENTERROOM =
CFELSE
CFSET ENTERROOM = ENTERS ROOM
/CFIF
/CFLOCK
CFPARAM NAME=FORM.CHAT DEFAULT=#VARIABLES.ENTERROOM#
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFIF NOT ISDEFINED('APPLICATION.USERS')
CFSET APPLICATION.USERS=ARRAYNEW(1)
/CFIF
/CFLOCK
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFIF NOT ISDEFINED('SESSION.CHATUSERNAME')
CFSET
SESSION.CHATUSERNAME=UCASE(TRIM(GETMEMBERNAME.USERNAME))
CFSET
ARRAYAPPEND(APPLICATION.USERS,SESSION.CHATUSERNAME)
/CFIF
/CFLOCK
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFIF NOT ISDEFINED('APPLICATION.CHAT')
CFSET APPLICATION.CHAT=ARRAYNEW(1)
CFSET ARRAYAPPEND(APPLICATION.CHAT,'')
/CFIF
/CFLOCK
CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=READONLY
SCOPE=APPLICATION
CFSET
ARRAYAPPEND(APPLICATION.CHAT,BSESSION.CHATUSERNAME :/B
FORM.CHAT)
/CFLOCK
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
RE: Reverse Engineer DayOfYear Function?
cfscript
theYear = year(now()); // or whatever...
janEnd = 31;
febEnd = janEnd + 28;
if( isLeapYear(theYear) )
febEnd = febEnd + 1;
marEnd = febEnd + 31;
aprEnd = marEnd + 30;
mayEnd = aprEnd + 31;
junEnd = mayEnd + 30;
julEnd = junEnd + 31;
augEnd = julEnd + 31;
sepEnd = augEnd + 30;
octEnd = sepEnd + 31;
novEnd = octEnd + 30;
decEnd = novEnd + 31;
// figure out the date
if( theDay LTE janEnd )
theDate = 1/#theDay#/#theYear#;
else if( theDay LTE febEnd ){
newDay = theDay - janEnd;
theDate = 2/#newDay#/#theYear#;
}
else if( theDay LTE marEnd ){
newDay = theDay - febEnd;
theDate = 3/#newDay#/#theYear#;
}
else if( theDay LTE aprEnd ){
newDay = theDay - marEnd;
theDate = 4/#newDay#/#theYear#;
}
else if( theDay LTE mayEnd ){
newDay = theDay - aprEnd;
theDate = 5/#newDay#/#theYear#;
}
else if( theDay LTE junEnd ){
newDay = theDay - mayEnd;
theDate = 6/#newDay#/#theYear#;
}
else if( theDay LTE julEnd ){
newDay = theDay - junEnd;
theDate = 7/#newDay#/#theYear#;
}
else if( theDay LTE augEnd ){
newDay = theDay - julEnd;
theDate = 8/#newDay#/#theYear#;
}
else if( theDay LTE sepEnd ){
newDay = theDay - augEnd;
theDate = 9/#newDay#/#theYear#;
}
else if( theDay LTE octEnd ){
newDay = theDay - sepEnd;
theDate = 10/#newDay#/#theYear#;
}
else if( theDay LTE novEnd ){
newDay = theDay - octEnd;
theDate = 11/#newDay#/#theYear#;
}
else if( theDay LTE decEnd ){
newDay = theDay - novEnd;
theDate = 12/#newDay#/#theYear#;
}
/cfscript
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Christian Abad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 12:52 PM
To: CF-Talk
Subject: Reverse Engineer DayOfYear Function?
Folks:
I am trying to obtain a date from the ordinal produced by the function
DayOfYear. In other words, does anyone know how to reverse engineer the
ordinal into a usable date? I would assume I'd need to pass the ordinal and
the year to some function to obtain a usable date. I can't seem to find a
function that will accomplish this! Any ideas?
Thanks,
Christian N. Abad
--
Sr. Analyst - Apps Programming
Bank of America
eCommerce Technology - Website Support
http://www.bankofamerica.com
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reverse Engineer DayOfYear Function?
wow. mine was total overkill. I figured there was an easier way brainfart +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 1:37 PM To: CF-Talk Subject: RE: Reverse Engineer DayOfYear Function? Simply create a date object for Jan 1 in the year you are testing. Then add to it the ordinal (minus 1 I think). This will give you a date object for the ordinal. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 3:52 PM To: CF-Talk Subject: Reverse Engineer DayOfYear Function? Folks: I am trying to obtain a date from the ordinal produced by the function DayOfYear. In other words, does anyone know how to reverse engineer the ordinal into a usable date? I would assume I'd need to pass the ordinal and the year to some function to obtain a usable date. I can't seem to find a function that will accomplish this! Any ideas? Thanks, Christian N. Abad -- Sr. Analyst - Apps Programming Bank of America eCommerce Technology - Website Support http://www.bankofamerica.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Structures
study structures in general - for any language. The concept is always the same (key-value). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 1:59 PM To: CF-Talk Subject: CF Structures I am a bit limited in my dealings with Cold Fusion structures. And as such, I was wondering if anyone has any links to good reference onlive dealing with CF Structures? Thanks a ton for any and all help, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Injection Attacks (scrubbers cont.)
I might be way off here, but wouldn't you just need to screen for
semi-colons? In order to hack a query the user would have to enter a
semi-colon to end the current statement and begin one of their own...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 11:54 AM
To: CF-Talk
Subject: SQL Injection Attacks (scrubbers cont.)
I have been trying to use the UDF below, which I got from
http://www.cflib.org/udf.cfm?ID=612enable=0.
The problem is this UDF will return true whenever a field contains the word
delete, drop, insert etc. Or when it contains a single quote character.
This doesn't really work very well since a user could submit the valid
value: we'll update the price later and drop by to talk. Which would
return true for an injection attach using this UDF.
Anybody have any ideas on how we could go about updating this UDF to be bit
more accurate?
cfscript
/**
* Tests a string, one-dimensional array, or simple struct for possible
SQL injection.
*
* @param input String to check. (Required)
* @return Returns a boolean.
* @author Will Vautrain ([EMAIL PROTECTED])
* @version 1, July 1, 2002
*/
function IsSQLInject(input) {
/*
* The SQL-injection strings were used at the suggestion of Chris
Anley
[[EMAIL PROTECTED]]
* in his paper Advanced SQL Injection In SQL Server Applications
available for downloat at
* http://www.ngssoftware.com/
*/
var listSQLInject = select,insert,update,delete,drop,--,';
var arraySQLInject = ListToArray(listSQLInject);
var i = 1;
for(i=1; i lte arrayLen(arraySQLInject); i=i+1) {
if(findNoCase(arraySQLInject[i], input)) return true;
}
return false;
}
/cfscript
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXECUTE account
I believe it would be whatever account the CF Service is running under... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:16 AM To: CF-Talk Subject: CFEXECUTE account Hello all, Can someone please tell me which account is used when running an application using CFEXECUTE? TIA David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Suggestions on saving a search
sounds like you already found a good way to do it. The only other way that might make more slightly more sense (but will take up more space in the DB) is to create a struct and use WDDX to store it in the DB. Using a struct you can associate a search value with a specific field name. Keep in mind though that using WDDX takes up a LOT of space (relatively speaking of course). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:11 AM To: CF-Talk Subject: Suggestions on saving a search oi CF-Talk,!! I am curious if anyone has any forms that they allow the user to save their search criteria, so that they can go back at a later time to it.and resubmit it. or edit itetc? any suggestions as to how to go about this? Currently, I loop all the form. variables into a list. then plug it into the db. And on them selecting a saved search i loop thru the list and populate variables/textboxes. Was just looking for a better way. -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: thanks and sharing the bubbly
Hot links if you have any. They're great with sauerkraut! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:38 AM To: CF-Talk Subject: RE: thanks and sharing the bubbly Congrats! Links, we want links!! ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:30 PM To: CF-Talk Subject: thanks and sharing the bubbly Hi, everyone. I just wanted to share a bit of the ship-christening bubbly with everyone: I have launched a major new ColdFusion app (my first) to a large userbase, so far with excellent success. I could not have done it without the generous help of the CF-Talk group, nor, of course, could I have done it if Michael and Judith hadn't made the group available in the first place. Thanks to all! Cheers, Matthieu __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Why is this query not working in Access??
actually you can quote dates as long as the format is correct... if it is
wrong you'll get a datatype mismatch error.
You'll want to hard-code values in place of each variable in the VALUES()
clause one at a time until you figure out which one is giving you a problem
and work from there...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 12:35 PM
To: CF-Talk
Subject: Re: Why is this query not working in Access??
Looks like you have single quotes around a date field '#date#' take the
quotes out ...
You do not put quotes around dates and numbers
Paul Giesenhagen
QuillDesign
- Original Message -
From: Bob Wilson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 2:46 PM
Subject: Why is this query not working in Access??
html
Hello,br
br
Any help is appreciated here.nbsp; I'm using code I've used before,
butbr
Access keeps giving me a syntax error.nbsp; br
br
Here is the query -br
lt;cfquery datasource=quot;#application.datasource#quot;gt;br
Insert INTO TBLteam ( Title, Team, Author, Date, Body )br
Values('#Title#', '#Team#', '#Author#', '#Date#', '#Body#')br
lt;/cfquerygt;br
br
br
And here is the error ---br
Error Occurred While Processing Requestbr
btable border=1
trth width=624Error Diagnostic Information br
/bODBC Error Code = 37000 (Syntax error or access violation) br
br
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement. br
br
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (366:1) to (366:62).br
/th/tr
/table
br
I can't seem to get past the Insert request.nbsp; Oh, the version
isbr
CF 4.5.2.br
br
Any help is very appreciated.br
br
Thanks,br
br
Bobbr
br
/html
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: rotating mail servers - cfmail...
just use the mod function: (it would be much easier if you had mail0, mail1, and mail2 as servers) cfset maxServers = 3 cfloop query=foo... cfset theMod = currentRow MOD maxServers cfmail server=mail#theMod#... /cfmail /cfloop in case you don't know, MOD will give you the remainder after dividing value A by value B. When MODing by 3 it will always be 0, 1, or 2. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 9:55 AM To: CF-Talk Subject: Re: rotating mail servers - cfmail... Using a query column with the email addresses... Divide the number of email by three, and use the udf http://www.cflib.org/udf.cfm?ID=117 to spilt the query into 3 even parts. Are these emails personalized, or are they all the same piece of email? If they are all the same, then just use the query column as your cfmail. Otherwise you will still need to loop. cfmail to=#mailserver1.emails# ... cfmail to=#mailserver2.emails# ... -- jon mailto:[EMAIL PROTECTED] Friday, August 16, 2002, 12:32:36 PM, you wrote: B Hey everyone, I'm writing a mail app and looking for suggestions for a cool B way to handle part of the app: B I am sending a bunch of emails out with CFMAIL. I am looping over a list of B the addresses, it could be from a query or a struct or an array, doesn't B really matter to me or the app, anyway, as I loop over the emails I would B like to have the app evenly distribute the mails between any number of my B mail servers, to keep the load lighter on all of them. It could be any B number, but right now it is 3: mail, mail2, and mail3. Anyone have any B thoughts about a really cool or elegant way to do this? Thanks y'all. B Buddy __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Average Orders Per Day
what DB? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Nicholas Bourgeois [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 12:43 PM To: CF-Talk Subject: SQL: Average Orders Per Day I need to construct a SQL statement to get the average number of orders per day, but I can't figure it out. The table name is orderSummary and the date field is named ordDate. Nick __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problem with FB 3.0
The username and password you are supplying most likely can't see DBO tables... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 8:13 AM To: CF-Talk Subject: problem with FB 3.0 Greetings, I'm using FUSEBOX 3.0, apart from trying to get my head around how its structured, I'm getting this error, ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DBO.administrator'. SQL = SELECT USERNAME,PASSWORD FROM DBO.administrator WHERE USERNAME = 'asd' AND PASSWORD = 'asd' Data Source = UTILITYADMIN The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:4) to (13:30) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\ACT_LOGIN.CFM. The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. DBO.administrator table does exist, // calling code CFQUERY NAME=validateUser DATASOURCE=#REQUEST.DSNAdmin# USERNAME=#REQUEST.user# PASSWORD=#REQUEST.key# SELECT USERNAME,PASSWORD FROMDBO.UtilityAdmin WHERE USERNAME = '#ATTRIBUTES.username#' AND PASSWORD = '#ATTRIBUTES.pass#' /CFQUERY //username dtype = varchar 10 //password dtype = ntext 16 I'm just wondering why an error is being reported below, The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. and maybe if it has something to do with CF5.0 and FB3, I'M sorry if this is vague,its just a very basic DB login check, any ideas out there, especially any FB3.0 people, Respectfully, j __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problem with FB 3.0
The username and password you are supplying most likely can't see DBO tables... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 8:13 AM To: CF-Talk Subject: problem with FB 3.0 Greetings, I'm using FUSEBOX 3.0, apart from trying to get my head around how its structured, I'm getting this error, ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DBO.administrator'. SQL = SELECT USERNAME,PASSWORD FROM DBO.administrator WHERE USERNAME = 'asd' AND PASSWORD = 'asd' Data Source = UTILITYADMIN The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:4) to (13:30) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\ACT_LOGIN.CFM. The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. DBO.administrator table does exist, // calling code CFQUERY NAME=validateUser DATASOURCE=#REQUEST.DSNAdmin# USERNAME=#REQUEST.user# PASSWORD=#REQUEST.key# SELECT USERNAME,PASSWORD FROMDBO.UtilityAdmin WHERE USERNAME = '#ATTRIBUTES.username#' AND PASSWORD = '#ATTRIBUTES.pass#' /CFQUERY //username dtype = varchar 10 //password dtype = ntext 16 I'm just wondering why an error is being reported below, The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. and maybe if it has something to do with CF5.0 and FB3, I'M sorry if this is vague,its just a very basic DB login check, any ideas out there, especially any FB3.0 people, Respectfully, j __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping Carts
Check out Netready. It's not expensive and it has all the bells and whistles including: auctions banners shopping lists discounts one-click purchasing customizable security system click tracking CyberCash integration Skipjack integration And it's all done in Fusebox (NOT fusebox 3!!) so it's easy to understand. Check it out at http://aloha-webdesign.com/ +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:20 AM To: CF-Talk Subject: Shopping Carts What shopping carts do people use at the moment? Please don't all say Able Commerce as it is WAY to expensive for what my client wants. -- James Smith - [EMAIL PROTECTED] http://www.xsite.ltd.uk - Xsite Limited -- As a computer, I find your faith in technology amusing. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping Carts
well said! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:21 AM To: CF-Talk Subject: Re: Shopping Carts Look at it this way. If you use the old Tack2 example as a basis - you can build one in a few hours, then use it for all of your tight wad customers. But I think your root problem is you cannot make money providing e-commerce for people who cannot or will not afford to pay for it. They're not going to make any money on the site, and you'll bleed yourself dry supporting them. FWIW, Dave - Original Message - From: James Smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 12:56 PM Subject: Re: Shopping Carts ok, perhaps I didn't make myself clear the first time. I am quite capable of coding a custom shopping cart system for the clients willing to pay for it, we are looking for a CHEEP (ie: £100, or free would be better), crap system we can give to tight customers who want a shopping cart enabled web site for £500 all in (design, hosting, the works), I (we) can't supply them this if we are spending £300+ on a shopping cart (a lot more if I design a custom one). Thanks for the suggestions so far they are just a bit much for the cheep end of the market. -- James Smith - [EMAIL PROTECTED] http://www.xsite.ltd.uk - Xsite Limited -- As a computer, I find your faith in technology amusing. - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 5:35 PM Subject: Re: Shopping Carts For the $$ I would look at SiteDirector http://www.quilldesign.com Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 5:32 AM Subject: RE: Shopping Carts go to webmonkey.com and look in the coldfusion section. there is a tutorial on writing a shopping cart in coldfusion. I would suggest downloading the source code and poking through it. It is a great way to start writing your own shopping cart application. I would bet that after you've written your first one, it would take you all of 5 minutes to write your next one. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 7:20 AM To: CF-Talk Subject: Shopping Carts What shopping carts do people use at the moment? Please don't all say Able Commerce as it is WAY to expensive for what my client wants. -- James Smith - [EMAIL PROTECTED] http://www.xsite.ltd.uk - Xsite Limited -- As a computer, I find your faith in technology amusing. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Locking a record in database!!
actually I might use the APPLICATION scope to handle this... When someone opens a record for editing set the following variable: cfset application.record#recordID# = now() When the person commits changes to the DB delete it from the struct like so: cfset foo = StructDelete(application, record#recordID#) Then when someone else tries to open it you can check to see if it exists in the application struct and how long it's been there: cfif StructKeyExists(application, record#recordID#) cfif dateDiff(n,evaluate(application.record#recordID#), now()) LT maxAllowedLockTime bForget it!b cfabort cfelse !-- it shouldn't be there - max allowed lock time exceeded... -- [...delete from struct...] /cfif /cfif where maxAllowedLockTime is some variable you set in minutes for how long a person can keep a record locked before timeout. Anyway, you get the idea... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 2:37 PM To: CF-Talk Subject: RE: Locking a record in database!! Can any one tell me how to lock a record in the table for some time. When One record is opened for writing through a form, I don't anyone else to open that particular record. I don't know at which level this should be done either at Database level or in ColdFusion. The short answer is, you can't, and you really don't want to be able to do that anyway for various reasons. The problem you're trying to solve is a concurrency problem, but it doesn't lend itself well to a locking solution. Instead, you might use a simple timestamp solution - add a field to the record to track when it was last changed, and check the field's value before allowing a user's changes to be accepted. If the value is different than it was when the user first selected the record for editing, you know it's been changed since then, and you can address that various ways in code. In most CF applications I've seen, the developers have simply ignored concurrency issues with multiple editors, which isn't really a good idea, but locking the database to prevent it would be even worse, since there's no persistent connection between the browser and the database. However, implementing the timestamp model described above is pretty trivial - I've done it in fifteen minutes or less in classrooms for student demonstrations. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: transact(ms sql) VS PL SQL(Oracle)
What do you want to know? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:52 PM To: CF-Talk Subject: transact(ms sql) VS PL SQL(Oracle) Does anyone have a good article or experiences on the differences between ms sql and oracle databases... thanks, --- phumes1 [EMAIL PROTECTED] wrote: I don't know whats happening... The contents of my output.txt file still contains the following. The output to the screen (console) is totally different and this is what I want dumped into the output file. The executable is a compiled Perl script. Does anyone know how to dump the output of the perl script to a file? C:\tempsetlocal C:\tempc: C:\tempcd c:\temp c:\tempc:\program\runme.exe c:\temp\filename printer At 11:19 AM 6/7/2002 +0100, you wrote: C:\temptest.bat output.txt I'd suggest putting a location before the output.txt, something like Test.bat c:\output.txt I'm not sure where CFEXECUTE calls the file from... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: 06 June 2002 18:27 To: CF-Talk Subject: cfexecute Hi, This is what I put in my batch file: test.bat setlocal c: cd C:\temp c:\tempc:\program\runme.exe c:\temp\filename printer Then from the command prompt I did: C:\temptest.bat output.txt The programs run just fine. The program displays the processing to the screen. When I open the file output.txt this is what it contains: C:\tempsetlocal C:\tempc: C:\tempcd c:\temp c:\tempc:\program\runme.exe c:\temp\filename printer I don't know whats going on. The output.txt file should contain the output thats dumped to the screen but it doesn't. The executable file is a Perl script which was compiled to a .exe file. Could there be something in the Perl script thats stopping the output to a file? Its works to the screen so I can't figure out whats happening. Any ideas? The bat file seem to be working exactly as you tell them to. In the instance below, when you are calling the exe directly, you are rerouting the screen output to the p.log file. It is routing the ouput of the runme command to the log file. In the CFExecute example you posted earlier, you are routing the output from the BAT file to the log file. Not quite the same thing. Try changing the call in the BAT file to match your example below, including the redirected output stream. (and what are the command switches -e /q /v doing for you in the CFExecute example? Is /q quiet mode, which supresses all bat file output?) Now you've got me curious Jerry Johnson [EMAIL PROTECTED] 06/05/02 02:27PM Why is my output file empty? The filename is passed to the executable for processing but shen I specify the output to be redirected to a file its empty. Why? Run from command prompt: c:\tempc:\program\runme.exe c:\temp\filename printer p.log +- --+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +- ---+ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cftry/catch scoping
I think it works like this (but I'm not positive): custom tags operate in their own memory space - they do not share memory space with the calling procedure. Therefore if you want the calling template to capture errors you'll need to somehow notify that template. I believe the calling template will capture errors thrown in CFINCLUDEs (since they operate in the same memory space), so you might try that instead. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Rob Baxter [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 9:48 AM To: CF-Talk Subject: cftry/catch scoping If I have a cftry block which contains calls to custom tags, what happens if there is an error in one of the custom tags? I would expect that the exception would be thrown out and caught by the catch block of the cftry, but that doesn't seem to be the case. I'm still getting untrapped errors out of the custom tags. Can anyone confirm this, or am I doing something wrong? CF version is 5.0 Professional. /rob __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Directory permission bitwise operation help needed
I believe Lewis Sellers can help you. He has written CFX tags to manipulate users and permissions. You'll find posts from him on this talk list... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 11:26 AM To: CF-Talk Subject: Directory permission bitwise operation help needed I am trying to find a post from a few months ago about setting folder permissions for a particular user using a byte length string of 0s and 1s. You are then able to get a users' permission to perform a certain action (edit/add/delete) by using bitwise operations on the string. ex. a user permssion string of 01010101 would give the user permission to edit files (this is a very generic example) Does anyone know where I can find the old topic or have any advice on how to get started doing this? Thanks in advance for your help Brian __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Directory permission bitwise operation help needed
Dunno... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 12:05 PM To: CF-Talk Subject: RE: Directory permission bitwise operation help needed Thanks Bryan for the tip. Do you know if there is another way to search the archives other than going to http://www.mail-archive.com/cf-talk@houseoffusion.com/ ?? -- the posts only go back to late May. I think Michael is doing some work on the archives...at least it appears he is. -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 2:42 PM To: CF-Talk Subject: RE: Directory permission bitwise operation help needed I believe Lewis Sellers can help you. He has written CFX tags to manipulate users and permissions. You'll find posts from him on this talk list... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 11:26 AM To: CF-Talk Subject: Directory permission bitwise operation help needed I am trying to find a post from a few months ago about setting folder permissions for a particular user using a byte length string of 0s and 1s. You are then able to get a users' permission to perform a certain action (edit/add/delete) by using bitwise operations on the string. ex. a user permssion string of 01010101 would give the user permission to edit files (this is a very generic example) Does anyone know where I can find the old topic or have any advice on how to get started doing this? Thanks in advance for your help Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Directory permission bitwise operation help needed
Oh, that's a different story. If you are creating your own bit strings it's easy: Use constants in application.cfm to define what each bit means: cfset BIT_CANEDIT = 0 cfset BIT_CANVIEW = 1 cfset BIT_CANDELETE = 2 etc... Then you can check them using this: cfif NOT BitMaskRead(client.permissions,BIT_CANEDIT,1) relocate to DENIED page /cfif The only caveat here is that client.permissions must be an integer. If you want to store the bit string in the DB as a string then you'll have to convert it to an integer when the user logs in. Manipulation is also easy: start with a permission setting of 0 and use BitMaskSet(client.permissions,1,BIT_CANEDIT,1) to turn the bit on and BitMaskSet(client.permissions,0,BIT_CANEDIT,1) to turn it off Good luck! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 12:53 PM To: CF-Talk Subject: RE: Directory permission bitwise operation help needed Thanks for the reply Lewis. What I am looking for is a lot less complicatedthan CFX-Permissions and also necessary to run on both Windows and Linux. I basically want to be able to set a permissions string for a user in the database and use a mask to test if a certain bit string is set. If it is the user has permission to perform a certain action Ex. 10101010 permission string 0010 mask 0010 user has permission to perform this action I just wanted to know if there was anything more involved in this other than just doing the above masking operation. I'm sure there is, but it's Friday and I can only think about the weekend right now. I'll also take a look at your custom tag and bug you if I have any questions. Thanks for your help. Brian -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 3:34 PM To: CF-Talk Subject: Re: Directory permission bitwise operation help needed On Fri, 7 Jun 2002 11:41:55 -0700, in cf-talk you wrote: I believe Lewis Sellers can help you. He has written CFX tags to manipulate users and permissions. You'll find posts from him on this talk list... Yep. Though the phrase I've forgotten more than you'll ever know might apply here. Many moons and years ago I wrote a tag called CFX_Permissions for the IHTK (which is free now btw and open-sourced). CFX_Permissions lets you modify the permission settings of files and folders under NT. It also does extended directory listings which included the permissions for all the files/folders you tell it to look at. It also lists SIDs, and NT Account names for the owners of the files/folders. Very handy for web hosting and intranet security (hense it's inclusion in the Intranet/Hosting Toolkit. :). I don't offhand recall the exact bits you have to set for each of the permissions types... though I can tell you wasn't exactly a simple set up. We're talking something designed by microsoft here after all. But if you poke around the request.cpp in the cfx_permissions source everything should be there... in C though. If you don't understand how it works... just ask. I might remember how it worked. /-) --min __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: strange SQL error
do this: cfquery name=Update datasource=#Form.DSN# Update #preserveSingleQuotes(Form.Tablename)# SET #preserveSingleQuotes(FieldNameValues)# WHERE ID = #preserveSingleQuotes(Form.ID)# /cfquery +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:26 AM To: CF-Talk Subject: strange SQL error I have a action page that accepts any form page and its variables then based on the stored proc sp_columns builds sql statment for update or insert. When I try to use it I get an Datefield overflow error (SQL 2000). But if I output the sql statment and then copy and past it into my sql enterprise manager the statement will work fine. If I remove the form date field I then get an syntax error, but I can copy and past it into SQL enterprise manager and it works. Here is the page that builds the sql statment: !--- Int Fields with default --- cfset FieldNameValue= cfset ColumnNames= cfset FieldNameValues= cfparam name=Form.ID default=0 !--- Get Column Names, Data Types from Form Field TableName and DSN(should be an hidden form fields --- cfquery name=GetTableInfodatasource=#Form.DSN# sp_columns #Form.TableName# /cfquery !--- Loop through each column in table --- cfloop query=GetTableInfo cfif ListFindNoCase(Form.FIELDNAMES,Column_Name) NEQ 0 AND Trim(Evaluate(ListGetAt(Form.FieldNames,ListFindNoCase(Form.FIELDNAMES,Colum n_Name NEQ cfset ElePos = ListFindNoCase(Form.FIELDNAMES,Column_Name) !--- Check to see what data type each column is and build insert based on value --- CFSWITCH EXPRESSION=#GetTableInfo.Type_Name# cfcase value=varchar cfset FieldNameValues = FieldNameValues , Column_Name = ' Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) ' /cfcase cfcase value=datetime cfset FieldNameValues = FieldNameValues , Column_Name = CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos /cfcase cfcase value=text cfset FieldNameValues = FieldNameValues , Column_Name = ' Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) ' /cfcase cfcase value=timestamp cfset FieldNameValues = FieldNameValues , Column_Name = ' Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) ' /cfcase cfcase value=smalldatetime cfset FieldNameValues = FieldNameValues , Column_Name = ' Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) ' /cfcase CFDEFAULTCASE cfset FieldNameValues = FieldNameValues , Column_Name = Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) /CFDEFAULTCASE /CFSWITCH /cfif /cfloop !--- Check to see if there is a ,(comma) at the START of the string --- CFIF Left(FieldNameValues,1) EQ ,cfset FieldNameValues = Right(FieldNameValues,Len(FieldNameValues)-1)/CFIF CFIF Left(ColumnNames,1) EQ ,cfset ColumnNames = Right(ColumnNames,Len(ColumnNames)-1)/CFIF !--- Sample Insert statement --- cfquery name=Update datasource=#Form.DSN# Update #Form.Tablename# SET #FieldNameValues# WHERE ID = #Form.ID# /cfquery Here is the output of the sql statment it builds and then error i get. Update tbl_PreOp SET id=5, PreRegType='Hosp', Allergies='Tape,Iodine', LatexDiagnosis='Yes', EpipenAnaphylaxis='Yes', RubberReaction='Yes', TypeReation='test1', AvacadoBannaETC='Yes', TypeReactionToAvacadoBananaETC='test2', MedCondition='test3', UnexplainedAllergyType='test4' WHERE ID = 5 Queries GetTableInfo (Records=57, Time=63ms) SQL = sp_columns tbl_PreOp /PLAINTEXTPRE/PRE/Q/S/SAMP/SCRIPT/SELECT/SMALL/STRIKE/S TRONG/SUB/SUP/TABLE/TD/TEXTAREA/TH/TITLE/TR/TT/U UL/UL/VAR/WBRXMP/XMP HR H3Error Occurred While Processing Request/H3 P TABLE border=1 TBODY TR TD H4Error Diagnostic Information/H4 PODBC Error Code = 37000 (Syntax error or access violation) P P[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near 'Hosp'. P PSQL = Update tbl_PreOp SET id=5, PreRegType=''Hosp'', Allergies=''Tape,Iodine'', LatexDiagnosis=''Yes'', EpipenAnaphylaxis=''Yes'', RubberReaction=''Yes'', TypeReation=''test1'', AvacadoBannaETC=''Yes'', TypeReactionToAvacadoBananaETC=''test2'', MedCondition=''test3'', UnexplainedAllergyType=''test4'' WHERE ID = 5 PData Source = INTERNET_PHA P PThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (55:1) to (55:47) in the template file I:\INETPUB\WWWROOT\PALMETTOHEALTH\PREREGISTRATION\..\INCLUDE\CFM\INC_AUTOFOR MUPDATE.CFM./P P PDate/Time: 06/06/02 09:55:33BRBrowser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1
RE: milonic menu problems
try putting the menu in a layer with a greater z-index than the rest of the page. That should solve it. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 2:15 PM To: CF-Talk Subject: Re: milonic menu problems I meant NS6 is the only browser its NOT doing it in.. long day - Original Message - From: Ewok [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 5:08 PM Subject: Re: milonic menu problems the only browers its NOT doing it in is opera --- Original Message - From: Timothy Heald [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 4:56 PM Subject: RE: milonic menu problems This isn't a problem with CF or the menu. It is a problem with browsers. The only way around this that I have seen so far is to use the ms combo box object (ie only). Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 4:54 PM To: CF-Talk Subject: milonic menu problems This is more than likley a problem with the menu and not CF but I figured someone here has probably used it and may have encountered the same problem... Im using the milonic menu from http://www.milonic.co.uk (nice menu) but if a sub nav pops out over a SELECT or CFSELECT form field the nav hides behind the filed. It does not however hide behind any other form types. I've searched their site and forums with no luck. Any help is greatly appreciated. Ewok __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORDER BY question
You are using SQL Server. The function name is not the same in SQL Server
as in Oracle. I can't remember what the exact function is, but it would be
worth your time to look it up...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 5:58 AM
To: CF-Talk
Subject: RE: ORDER BY question
ok
tried brians
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]'instr' is not a recognized
function name.
with
cfset newOrderList = ,Partner,Principal,Senior Associate,Associate,
cfquery name=Employees datasource=RPH
cachedwithin=#CreateTimeSpan(0,0,30,0)#
SELECT LEFT(RTrim(tblEmployee.Lastname),10)+', '+tblEmployee.Firstname as
Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID,
tblEmployee.StudioID, tblEmployee.StatusID, tblEmployee.TitleID,
tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName,
tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb,
tblPhone.PhoneTypeID, tblFloor.floor, tblJobTitle.TitleID, tblJobTitle.Title
FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor, tblJobTitle
WHERE tblEmployee.studioid = tblStudio.studioid
AND tblEmployee.TitleID = tblJobTitle.TitleID
AND tblOffice.OfficeID = tblStudio.OfficeID
AND tblJobTitle.TitleID IN (25,26,28,4)
AND tblPhone.EmpResID = tblEmployee.EmployeeID
AND tblPhone.PhoneTypeID = '1'
!--- AND tblEmployee.StudioID in (#FORM.StudioID#) ---
AND tblEmployee.FloorID = tblFloor.floorid
ORDER BY instr('#newOrderList#',',' | Title | ',')
, Fullname;
/cfquery
-paul
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 9:55 PM
To: CF-Talk
Subject: RE: ORDER BY question
Ok, I'm an idiot... I just thought of a MUCH faster way to do this
!--- create a list with commas at both ends ---
cfset newOrderList = ,#orderList#,
!--- this query is in ORACLE syntax, but can be done for any DB,
ORDER BY orders by how far in it found the index in your order by
string. ---
cfquery name= ...
SELECT *
FROM myTable
WHERE ID IN (#orderList#) [or whatever here]
ORDER BY instr('#newOrderList#',',' | idColumn | ',')
/cfquery
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 6:45 PM
To: CF-Talk
Subject: RE: ORDER BY question
This will do it, but keep a close eye on the processing time of the server,
and make sure if the list gets long that you are using a properly indexed
database.
customTagName.cfm
cfparam name=attributes.sortOrder default=
cfset sqlBase = SELECT * FROM myTable
cfif listLen(attributes.sortOrder) GT 1
cfset sqlString = sqlBase WHERE myColumn =
#replace(attributes.sortOrder,,, UNION ALL #sqlBase# WHERE myColumn =
,all)#
cfelseif attributes.sortOrder NEQ
cfset sqlString = sqlBase WHERE myColumn =
#attributes.sortOrder#
cfelse
cfset sqlString = sqlBase
/cfif
cfquery name= ...
#preserveSingleQuotes(sqlString)#
/cfquery
notice that in the above you are simply creating a SELECT statement for each
item in the specified SORTORDER list and UNIONing them all together.
I chose UNION ALL because it is faster than UNION... UNION filters out
duplicate rows...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 11:59 AM
To: CF-Talk
Subject: ORDER BY question
ok. ASC DESC don't work on this one.
i want to be able to ORDER BY in a specific order
such as
ORDER BY tblJobTitle.TitleID='25,26,28,4'
is that possible?
if not how else could i do it...
!--- tblJobTitle.TitleID
Partner=25
Principal=26
Senior Associate=28
Associate=4 ---
Thanks
-paul
RE: Multiple CFApplication under 1 application.cfm
Your example should work, but I've always had trouble changing the session timeout. Just keep track of it manually instead. Put this in application.cfm: - cfapplication name=someappname sessionmanagement=Yes setclientcookies=Yes cfif Internal_Network cfset timeoutMinutes = 480 cfelse cfset timeoutMinutes = 60 /cfif cfparam name=session.timeStamp default=#now()# cfif dateDiff(n,session.timeStamp,now()) GT timeoutMinutes expire the session relocate to login page /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Perez, Percy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 8:14 AM To: CF-Talk Subject: Multiple CFApplication under 1 application.cfm Hello, Is the following possible under CF 4.5? I would like to setup a timeout of 8 hours for my internal network machines and 1 hour for people for external users? Even though, I get no errors, it seems to time out very quickly ( 15 minutes...) Thanks for the help. Percy cfif Internal_Network cfapplication name=someappname sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,8,0,0)# cfelse cfapplication name=someappname sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,1,0,0)# /cfif __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing a cached query
I've found in the past that is one of the (if not the only...) good arguments for the use of application variables. Have an application variable defaulted to 30 minutes or so, then put code in application.cfm that looks for url.setCacheTime or something like that. cfparam name=application.cacheTime default=#createTimeSpan(0,0,30,0)# cfif isdefined(url.setCacheTime) cflock... cfset application.cacheTime = createTimeSpan(0,0,url.setCacheTime,0) /cflock /cfif Then just make sure all your queries use the application variable. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: mr_urc [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 1:27 PM To: CF-Talk Subject: Re: Killing a cached query Quoting Burcham, Steve [EMAIL PROTECTED]: What is the best way to 'kill' a cached query on a logout sequence? The only way that I know of to kill a cached query is to run the query with cachedwith set to one second. If there's a better way, I'd *love* to hear about it. (There are cachedwithins all over my website set for like 10 days but every few months when I update the site I have to go through the code and reset the cachedwiths to one second, then hit every page in the site.) By the way, I tried to set a request variable to put in cachedwithin so I could change it in only one place instead of every query in the site. It was not happy. It just dawned on me that maybe I have to put PreserveSingleQuotes() around it to make it work. Does anybody know before I go breaking my site? But if you are doing it on a logout, it seems like maybe you really want the query to exist in the session, not in the cache. If you store the query in a session, it'll die on logout or when the session times out. -- If you hate the interface, blame Kevin. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamically Processing Form Values
Javascript can work miracles here...
use JS to populate a hidden form field on submit.
function checkQty( theForm ){
// check all QUANTITY fields
for( k=0; ktheForm.elements.length; k++ ){
if( fieldName.indexOf(quantity) = 0 ){
fieldValue = 0 + theForm.elements[k].value;
if( parseInt(fieldValue) 0 )
theForm.hidIDs.value += , +
theForm.elements[k].name;
}
}
}
You may want to use JS to parse out the actual item ID if you are so
inclined. Anyway, you'll get a hidden field [hidIDs] passed to the
processing page containing a comma-delimited list of the items that had a
QTY greater than 0.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Jason Miller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 12:58 PM
To: CF-Talk
Subject: Dynamically Processing Form Values
Hello all. New to the list - Hope someone can help me. Of course time is
somewhat urgent on this.
I have a lengthy form page. It is created through 5 cfqueries for eachmain
subject. The entire page is a form. I have javascript arrays that populate a
summary area on the fly when someone enteres a quantity.
Each product has a unique identifiersproduct0 - producti - whatever
the recordcount is.
So another words - it loops through all records.. starting with product0
and currently ending in product79
Each product has about 4 form values I need to process..
So product0 - has itemqty0, itemdesc0, itemname0 and so on.
BUT I ONLY want products that have itemQty ( quantity) that is GT 0 to
display.With 79 products - each with 4 pieces of information - that becomes
316 of #FORM.Product0#
#FORM.ItemQty0# and so on.
The latest thing I tried was very straightforward.. except too straigh
forward.. do not know how to interject and only spit out the variabls with
itemqty
of GTE 1
CFLOOP COLLECTION=#form# ITEM=myfield
#variables.myfield# : #form[myfield]#
/CFLOOP
In my head it seems o straightforward.. but whatever I have tried does not
produce the right results.
So to recap my request. I have over 300 form values on the form page. On the
Form Process page - I wish to spit back out ONLY those that have a value in
the qty field of 0 or better.
Whatever I attempt I am unable to get this to work - seems like it should be
so simple. Any help is GREATLY appreciated.
Thanks,
Jason Miller
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Running program with cfexecute
what DB are you using? SQL Server has the ability to do it. It would look something like this... Create a stored procedure like this: -- create procedure sqlexec @p1 text as exec(@p1) -- then execute it like this... cfquery name=... EXECUTE sqlexec [whatever] /cfquery +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 4:42 PM To: CF-Talk Subject: Running program with cfexecute Hi, I'm not having much luck running a certain program using cfexecute. Some programs work and others don't. This application is strickly intranet and I was wondering if there was another way of running a program on the server from the client? Possibly via CFHTTP?? +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Running program with cfexecute
I've done this also and it worked. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 5:20 PM To: CF-Talk Subject: RE: Running program with cfexecute I had some problems with runing some programs but got around them by creating a .bat or .cmd file and cfexecute them. Rick Eidson -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 6:42 PM To: CF-Talk Subject: Running program with cfexecute Hi, I'm not having much luck running a certain program using cfexecute. Some programs work and others don't. This application is strickly intranet and I was wondering if there was another way of running a program on the server from the client? Possibly via CFHTTP?? +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORDER BY question
This will do it, but keep a close eye on the processing time of the server, and make sure if the list gets long that you are using a properly indexed database. customTagName.cfm cfparam name=attributes.sortOrder default= cfset sqlBase = SELECT * FROM myTable cfif listLen(attributes.sortOrder) GT 1 cfset sqlString = sqlBase WHERE myColumn = #replace(attributes.sortOrder,,, UNION ALL #sqlBase# WHERE myColumn = ,all)# cfelseif attributes.sortOrder NEQ cfset sqlString = sqlBase WHERE myColumn = #attributes.sortOrder# cfelse cfset sqlString = sqlBase /cfif cfquery name= ... #preserveSingleQuotes(sqlString)# /cfquery notice that in the above you are simply creating a SELECT statement for each item in the specified SORTORDER list and UNIONing them all together. I chose UNION ALL because it is faster than UNION... UNION filters out duplicate rows... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:59 AM To: CF-Talk Subject: ORDER BY question ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... !--- tblJobTitle.TitleID Partner=25 Principal=26 Senior Associate=28 Associate=4 --- Thanks -paul __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORDER BY question
Ok, I'm an idiot... I just thought of a MUCH faster way to do this
!--- create a list with commas at both ends ---
cfset newOrderList = ,#orderList#,
!--- this query is in ORACLE syntax, but can be done for any DB,
ORDER BY orders by how far in it found the index in your order by
string. ---
cfquery name= ...
SELECT *
FROM myTable
WHERE ID IN (#orderList#) [or whatever here]
ORDER BY instr('#newOrderList#',',' | idColumn | ',')
/cfquery
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 6:45 PM
To: CF-Talk
Subject: RE: ORDER BY question
This will do it, but keep a close eye on the processing time of the server,
and make sure if the list gets long that you are using a properly indexed
database.
customTagName.cfm
cfparam name=attributes.sortOrder default=
cfset sqlBase = SELECT * FROM myTable
cfif listLen(attributes.sortOrder) GT 1
cfset sqlString = sqlBase WHERE myColumn =
#replace(attributes.sortOrder,,, UNION ALL #sqlBase# WHERE myColumn =
,all)#
cfelseif attributes.sortOrder NEQ
cfset sqlString = sqlBase WHERE myColumn =
#attributes.sortOrder#
cfelse
cfset sqlString = sqlBase
/cfif
cfquery name= ...
#preserveSingleQuotes(sqlString)#
/cfquery
notice that in the above you are simply creating a SELECT statement for each
item in the specified SORTORDER list and UNIONing them all together.
I chose UNION ALL because it is faster than UNION... UNION filters out
duplicate rows...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 11:59 AM
To: CF-Talk
Subject: ORDER BY question
ok. ASC DESC don't work on this one.
i want to be able to ORDER BY in a specific order
such as
ORDER BY tblJobTitle.TitleID='25,26,28,4'
is that possible?
if not how else could i do it...
!--- tblJobTitle.TitleID
Partner=25
Principal=26
Senior Associate=28
Associate=4 ---
Thanks
-paul
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bytes to MB/GB conversion tag?
Is this a trick question?? MB = bytes/1,000,000 -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 7:11 AM To: CF-Talk Subject: Bytes to MB/GB conversion tag? Hi, I have a database of about 35,000 files with their filenames, sizes, ID tags and so on. The guy who started this project wrote the sizes of the files as bytes - and I was wondering if anyone knew of a tag to convert bytes to MB/GB (if less than 1MB, make it a percentage of 1MB...ie. 0.9MB). I had a look at devex.macromedia.com but couldn't see any. Many thanks Will --- Become a Pingographer and share your photos for free: http://www.localbounty.com/pingo __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bytes to MB/GB conversion tag?
LOL THANK YOU!!! -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 1:51 PM To: CF-Talk Subject: Re: Bytes to MB/GB conversion tag? Neil Clark - =TMM= wrote: 1 MB = 1024KB. You're wrong :) 1 MB = 1000 kB = 100 B 1 Mi = 1024 Ki = 1048576 B http://physics.nist.gov/cuu/Units/binary.html Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTREE Question
The HREF attribute of CFTREEITEM operates exactly the same way as the HREF attribute of an a ... tag. If it's not working for you then you may have a bad CFTREE class. I don't know how that happens, but it happened to me once before. Do you have the 4.5.1 patch installed? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Graham Lewis [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:16 AM To: CF-Talk Subject: CFTREE Question If I am creating a directory growsing tool with CFTREE, gow would I make a document item in CFTREEITEM into a hyperlink to that file? I thought the HREF attribute would do this but it seems not. I am using v4.5 I am afraid Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic image
You could do it with layers and Javascript. Just put a layer containing text over the top of the image. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:38 AM To: CF-Talk Subject: dynamic image I want to create an image and make the text on the image dynamic, but I am not sure where to start.. Anybody have a suggestion? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting MIME Type for a file
I've run into this problem before... I think the best way to solve it is to use a meta refresh and let the client do the work. META HTTP-EQUIV=Refresh CONTENT=0; URL=#url.file# +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 11:08 AM To: CF-Talk Subject: Getting MIME Type for a file I know the security considerations for this... I will be trapping that security on this within the client's session as well, but nevertheless, does anyone know how would I be able to get the mime type for this file? cfparam name=url.file default= cfif fileExists(url.file) cfheader name=Content-disposition value=attachment; fileName=#url.file# cfcontent type=? file=#url.file# deletefile=No /cfif __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting MIME Type for a file
How bout creating a virtual mapping to the network share in the web server? That would allow you to point to files as if they were in a sub-directory of the web root. The only other solution I know of is to create a switch statement and load it up with all the mime types you can think of. Here's a comprehensive list of mime types http://www.utoronto.ca/webdocs/HTMLdocs/Book/Book-3ed/appb/mimetype.html +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 11:18 AM To: CF-Talk Subject: RE: Getting MIME Type for a file True, thing is, these files are gonna be stored on a network share somewhere else... I was hoping to use cold fusion to host out the file instead :( Thanks anyways though... -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 11:14 AM To: CF-Talk Subject: RE: Getting MIME Type for a file I've run into this problem before... I think the best way to solve it is to use a meta refresh and let the client do the work. META HTTP-EQUIV=Refresh CONTENT=0; URL=#url.file# +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 11:08 AM To: CF-Talk Subject: Getting MIME Type for a file I know the security considerations for this... I will be trapping that security on this within the client's session as well, but nevertheless, does anyone know how would I be able to get the mime type for this file? cfparam name=url.file default= cfif fileExists(url.file) cfheader name=Content-disposition value=attachment; fileName=#url.file# cfcontent type=? file=#url.file# deletefile=No /cfif __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV in a select
what DB are you using? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 1:52 PM To: CF-Talk Subject: SQL: Creating a CSV in a select A while ago Marian Dumitrascu posted the following code to create a csv file which is very nice and clean: CFQUERY NAME=GetDocs... SELECT '' + RTRIM(CATEGORY) + '' + ',' + '' + RTRIM(newc2) + '' + ',' + ... '' + RTRIM(C_Alias) + '' AS line FROM table /CFQUERY !--- create the file content CFSET filecontent = ValueList(GetDocs.line,#CHR(13)##CHR(10)#) !--- and save it --- cffile action=APPEND file=#csvfile# output=#filecontent# My problem comes in trying to do the select statement, I am finding that it will not populate that line field if any of the fields used to build it are null. Is there a way to get around this in the select statement. Having to loop through a query takes far too much time with 7000 records, where ValueList() is much quicker. TIA for any help. --- Ben Morris Web Site Developer American Federation of Government Employees, AFL-CIO (202) 639-6448 www.afge.org __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV in a select
I'm pretty sure in SQL Server you can do this... CFQUERY NAME=GetDocs... SELECT '' + ISNULL(RTRIM(CATEGORY),'*') + '' + ',' + '' + ISNULL(RTRIM(newc2),'*') + '' + ',' + ... '' + ISNULL(RTRIM(C_Alias),'*') + '' AS line FROM table /CFQUERY this will cause any NULL entries to be *... so you would get this... a,b,c,*,d if the fourth column is NULL +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 2:10 PM To: CF-Talk Subject: RE: Creating a CSV in a select A while ago Marian Dumitrascu posted the following code to create a csv file which is very nice and clean: CFQUERY NAME=GetDocs... SELECT '' + RTRIM(CATEGORY) + '' + ',' + '' + RTRIM(newc2) + '' + ',' + ... '' + RTRIM(C_Alias) + '' AS line FROM table /CFQUERY !--- create the file content CFSET filecontent = ValueList(GetDocs.line,#CHR(13)##CHR(10)#) !--- and save it --- cffile action=APPEND file=#csvfile# output=#filecontent# My problem comes in trying to do the select statement, I am finding that it will not populate that line field if any of the fields used to build it are null. Is there a way to get around this in the select statement. Having to loop through a query takes far too much time with 7000 records, where ValueList() is much quicker. If you're using SQL Server, you should be able to use the COALESCE function, which returns the first non-null argument: SELECT ... + COALESCE(RTRIM(CATEGORY), ) + ... If not, you can build a CASE statement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems installing a cfx dll
did you stop and restart the CF service? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:36 AM To: CF-Talk Subject: RE: Problems installing a cfx dll Thanks for the correction. Wasn't certain on that, but thought it was worth mentioning. :) -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: Re: Problems installing a cfx dll You don't use Regsvr32 on a CFX DLL. What he needs to do is make sure that the DLL is in the specified path and that any DLLs that are also required by the CFX are available as well. ColdFusion will complain that a CFX is missing when a required DLL is missing so you need to know if any other DLLs are required. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:31 AM Subject: RE: Problems installing a cfx dll When you say installed, did you use regsvr32.exe ? I'm not 100% if this is necessary... but it might be. :) Eric -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:28 AM To: CF-Talk Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping cart
Netready is very good. Huge feature list, relatively cheap, works with ACCESS, SQL Server, and Oracle, available in FB3. You can't go wrong here! http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:35 AM To: CF-Talk Subject: Shopping cart I just started work for a company that is using CF mainly, but has a ASP shopping cart. Does anyone know of an open source shopping cart done in CF that is pretty good? Douglas Brown Email: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ( escape character
use JSStringFormat() +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 7:15 PM To: CF-Talk Subject: ( escape character In javascript how can I avoid ( being an escape character... Neil __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
