RE: [KCFusion] OT: Desktop automation text transfer
Try using VBA in Excel, Word, or possibly Outlook. Excel Macro example: Sub GetEmails() Dim myApp As New Outlook.Application Dim myNS As NameSpace Dim myFolder As MAPIFolder Dim myItems As Items Dim intLoopCounter As Integer, Idx As Integer Set myNS = myApp.GetNamespace(MAPI) Set myFolder = myNS.GetDefaultFolder(olFolderInbox) Set myItems = myFolder.Items Range(a1).Value = Subject Range(b1).Value = Body Idx = 2 For intLoopCounter = 1 To myItems.Count Range(a Idx).Value = myItems(intLoopCounter).Subject Range(b Idx).Value = myItems(intLoopCounter).Body Idx = Idx + 1 Next intLoopCounter Set myNS = Nothing Set myFolder = Nothing Set myItems = Nothing End Sub This will grab every email in your default email inbox and place the subject and body into separate rows within an excel spreadsheet. You could add some logic to search thru the body text and grab what you want. Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 4:09 PM To: KCFusion (E-mail) Subject: [KCFusion] OT: Desktop automation text transfer Off topic, but I'm looking to see if a certain tool exists. I have a weekly task where I have to sort through Outlook email messages, then copy and paste the content from them into a plain text file. I want to speed this up with some desktop automation. Ideally, I'd like to click on a function key (or key combination) and have Windows automatically copy the Outlook text to the target document, where it would be appended. Is there such an animal? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Messenger Ads (OT)
Stopping Advertisements with Messenger Service Titles http://www.microsoft.com/windowsxp/pro/using/howto/communicate/stopspam.asp Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 01, 2003 10:26 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] Messenger Ads (OT) A while back there was something on the list about these stupid Messenger Service pop up ads. I looked in the archive but found nothing on them. Did anybody find a free way to stop them? They are coming in on the web server and I have put up with them for a while, now they are just making me angry... A.
RE: [KCFusion] IsNumeric function and hex values?
It has to do with scientific notation. We are more familiar with 74e6, where this is 74 times 10 to the 6th power or 74 times 100 or 7400. The d instead of an e indicates an integer instead of a real number. Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message- From: Chris Stallo [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:25 AM To: [EMAIL PROTECTED] Subject: [KCFusion] IsNumeric function and hex values? I've got problem with the IsNumeric function in ColdFusion. I've got a page set up with a form on it. On the page this form calls I am doing validation to make sure the entered value is numeric by using the IsNumeric function - IsNumeric(form.variable) If I pass in a value like 74d6, it passes this validation and when I do an output on the variable it's coming out as 74,000,000. Anyone have an idea of why? Does it have something to do with the hex value? If I pass in the value 74a6 it works fine and the validation fails. I'm wanting to make sure the form field is a number and there is no character data in it. For this situation I can't use the input to do the validations. Thanks in advance, Chris __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] IsNumeric function and hex values?
Correction. Scientific Notation D indicates integer notation. E indicates exponential notation F indicates floating point notation. -Original Message- From: Ellis, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 11:07 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] IsNumeric function and hex values? It has to do with scientific notation. We are more familiar with 74e6, where this is 74 times 10 to the 6th power or 74 times 100 or 7400. The d instead of an e indicates an integer instead of a real number. Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message- From: Chris Stallo [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:25 AM To: [EMAIL PROTECTED] Subject: [KCFusion] IsNumeric function and hex values? I've got problem with the IsNumeric function in ColdFusion. I've got a page set up with a form on it. On the page this form calls I am doing validation to make sure the entered value is numeric by using the IsNumeric function - IsNumeric(form.variable) If I pass in a value like 74d6, it passes this validation and when I do an output on the variable it's coming out as 74,000,000. Anyone have an idea of why? Does it have something to do with the hex value? If I pass in the value 74a6 it works fine and the validation fails. I'm wanting to make sure the form field is a number and there is no character data in it. For this situation I can't use the input to do the validations. Thanks in advance, Chris __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] MD5 Hash
Try looking at the MacroMedia Developer Exchange website: Custom tag: CF_Authorize_Net_3 http://devex.macromedia.com/developer/gallery/info.cfm?ID=C0C7D513-2CD6-11D4 -AA9800508B94F380method=Full or Custom tag: CF_HMAC http://devex.macromedia.com/developer/gallery/info.cfm?ID=B60D8F14-FC9F-11D6 -840F00508B94F85Amethod=Full Randy Ellis -Original Message- From: Kristi Lavallee [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 2:49 PM To: [EMAIL PROTECTED] Subject: [KCFusion] MD5 Hash Our company subscribed to authorize.net to process credit cards. One of the requirements for using their system is to provide an encrypted value with each transaction. They require the value to be generated using the HMAC-MD5 hashing algorithm. I have some sample scripts written in ASP and JScript... does anyone know how to integrate ColdFusion and JScript or have a MD5 hashing script written using CFML? Any ideas on this would be helpful... Thanks, Kristi Lavallee __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Macromedia Studio MX
Title: Message You might have them upgrade to MX 6.1 http://www.macromedia.com/support/dreamweaver/releasenotes/mx/dwmx61_fixed.html Bugs fixed in Dreamweaver MX 6.1 There are intermittent occurrences of files being truncated or losing data when using Get/Put. (76640)This occurs under certain circumstances if the "Refresh local file list automatically" is unchecked and the Site window has not been refreshed before putting a big file. Randy EllisSenior Programmer AnalystCity of Overland Park -Original Message-From: cfhelp [mailto:[EMAIL PROTECTED]]Sent: Friday, January 03, 2003 9:52 AMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] Macromedia Studio MX One of my hosting clients s using MX and is having problems uploading larger files (jpg, Gifs) to the CF5 server. I think the problem is with him but I'm not sure I still use CF Studio. Rick -Original Message-From: Ron Ramphal [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 11:56 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] Macromedia Studio MX Another little extra... on the Windows edition of Studio MX CD there is a fully functional version of Homesite+ v5.1 Ron. - Original Message - From: Ryan Hartwich To: [EMAIL PROTECTED] Sent: Monday, December 30, 2002 8:56 PM Subject: RE: [KCFusion] Macromedia Studio MX I don't believe I have heard of any problems with Studio MX and CF5. (only minor ones the other way around). The trick will be to remember that some of the features/tags in Studio won't work in CF5, likewise the CFCs. So you may have a tendency to write code that is not 5 compatible. This shouldn't be a big problem and its a good chance to start working on code for MX. A plus: the Windows version of Studio MX includes a developer version of CFMX, which can coexist on a server with CF5. Though it only permits a single IP address to connect, it is a good way for you and other developers with copies of studio to write and test code on stand alone versions of CFMX prior to buying the upgrade. Ryan -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mark KirkbrideSent: Monday, December 30, 2002 4:58 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] Macromedia Studio MX Has anyone had any issues using Macromedia Studio MX with ColdFusion 5 Server? We have budgeted to upgrade to ColdFusion MX Server in '03, but was wondering about getting the Studio beforehand. Mark Kirkbride Senior LAN Administrator FBD Consulting, Inc. (913) 319-8836 [EMAIL PROTECTED]
RE: [KCFusion] ...in the works...
Ryan, are you attending DevCon 2002 next week? -Original Message- From: Ryan Hartwich [mailto:hartwichr;asme.org] Sent: Tuesday, October 22, 2002 3:05 PM To: [EMAIL PROTECTED] Subject: [KCFusion] ...in the works... FYI I'm working on some presentation materials for a possible meeting next week on CFC's (a new way of writing functions in CFMX). Hopefully we can arrange a meeting for early next week at either the UMKC location or southern Overland Park. I am also working with the MM Tools group in town to put together a presentation and demo on Flash Remoting for November. Flash Remoting allows you to use Flash to create a cross platform front end/rich user interface that can interact with a backend server like CF (or J2EE, .Net, etc.) to create dynamic applications that give you the capabilities of Flash for the interface instead of the typical html and horrible to debug javascript. I am also working on a number of book reviews that hopefully I can start sending out in the next few week. Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list;kcfusion.org Questions, Comments or Glowing Praise.. mailto:listmaster;kcfusion.org To Subscribe mailto:cf-list-subscribe;kcfusion.org To Unsubscribe mailto:cf-list-unsubscribe;kcfusion.org __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list;kcfusion.org Questions, Comments or Glowing Praise.. mailto:listmaster;kcfusion.org To Subscribe mailto:cf-list-subscribe;kcfusion.org To Unsubscribe mailto:cf-list-unsubscribe;kcfusion.org
RE: [KCFusion] SSN Validation
Chris, you may want to check out the "Social Security Number Verification" web page: http://www.ssa.gov/employer/ssnv.htm Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message-From: Chris Holdman [mailto:[EMAIL PROTECTED]]Sent: Friday, August 16, 2002 2:54 PMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] SSN Validation Has anyone done a validation on Social Security Number to check if it was valid, not juts checking to see if it follows a numeric NNN-NN- pattern, but is an actual valid Social Seciurty Number? Christopher V. Holdman Webmaster - City of Olathe (913) 393-6286 (913) 238-4681 Cell (913) 493-6010 Pager [EMAIL PROTECTED]
RE: [KCFusion] Register now for Macromedia DevCon 2002
Ryan, last year DevCon was held at the Walt Disney World Swan and Dolphin Hotels. The room rates where $235 + $34 taxes per night. Randy -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:06 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Register now for Macromedia DevCon 2002 Is anyone interested in sharing a room in Orlando for this? I am considering going. Plane tickets to Orlando are running about $200, figure the room is probably about $150 per night. Sharing would be a great way to save a few hundred. Ryan -- ~ Register for DevCon 2002 before August 27, save $155, and be entered to win a FREE conference pass (a $1,050 value). http://www.macromedia.com/go/usergroupdevcon2002 ~ At Macromedia DevCon 2002 you'll build practical skills and knowledge about the Macromedia product family -- the foundation for Rich Internet Applications and the next generation of web technology and Internet solutions. You'll have access to practical training in more than 100 in-depth technical workshops and hands-on sessions that cover everything from basic web development to the most advanced techniques for building Rich Internet Applications, as well as access and training for all the major Macromedia products, including Macromedia Flash, ColdFusion, Dreamweaver, Director, and JRun. ~ See the complete list of session descriptions at: http://www.macromedia.com/v1/conference/ConferenceProgramDetails.cfm ~ Plus, you'll have exclusive access to a wide range of events, all specifically designed to give you the most out of Macromedia technology and DevCon 2002, including: * Keynotes and Sneak Previews -- Hear the latest on Macromedia product strategies and be among the first to see new technology in the pipeline. * Exhibit Showcase -- See the latest products, innovations, complementary technology, and services offered by Macromedia partners. * Gatherings -- Join Birds-of-a-Feather discussions, Special Interest Group presentations, and Late-Night Hacker sessions. * Technical Support Labs -- Work with Macromedia technical support engineers who are ready and willing to help you move forward and be successful. * Application Gallery and People's Choice Awards -- Explore and be inspired by some of the great work being produced by the Macromedia user community. (Submit your own project for consideration, starting in mid-August.) ~~~ Additional Events: * Nielsen Norman Group Usability Tutorial -- Attend the first public presentation of the extensive usability research conducted by the Nielsen Norman Group (additional registration fee is required). * Macromedia eLearning Conference -- Explore the latest eLearning offerings from Macromedia. ~~~ Macromedia DevCon 2002 October 27-30, 2002 Walt Disney World Swan Dolphin Orlando, Florida Register by August 27th, save $155, and enter to win a FREE pass. http://www.macromedia.com/go/usergroupdevcon2002 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFMAILPARAM
Try using the TYPE=HTML attribute inside of CFMAIL. Example: CFMAIL FROM=fromname.emailserver.com TO=toname.emailserver.com SUBJECT=Place email subject here TYPE=HTML table TR TDTest Application/TD /TR TR TDIMG SRC=HTTP://www.servernamehere.com/Line.gif; ALT=Line/TD /TR /TABLE /CFMAIL -Original Message- From: Smith, Jim [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: [KCFusion] CFMAILPARAM Has anyone tried to put an image into a cfmail message? I have tried using cfmailparam, but I'm not getting anything with it. Any ideas? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Parsing two lists
CFIF IsDefined(form.Item) AND IsDefined(form.ItemQty) cfset ItemArray = ListToArray(Item) cfset ItemQtyArray = ListToArray(ItemQty) CFIF ArrayLen(ItemArray) EQ ArrayLen(ItemQtyArray) CFLOOP FROM=1 TO=#ArrayLen(ItemArray)# INDEX=Idx CFOUTPUT #ItemQtyArray[variables.Idx]# #ItemArray[variables.Idx]#BR /CFOUTPUT /CFLOOP CFELSE The Items list and Quantities list do not have the same number of values. /CFIF /CFIF -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 11:45 AM To: KCFusion (E-mail) Subject: [KCFusion] Parsing two lists This should be simple but my code keeps failing. I have a form that sends multiple values for the same form field. They arrive at my processing template as two lists; one for the item being ordered and another for quantity. Field name Value -- -- Item Servers,Modems,Printers ItemQty8,6,5 The output I seek is: 8 Servers 6 Modems 5 Printers I can't change the sending form; it's a mixture of CF, HTML and JavaScript that has been declared final. However I'd like assistance with the processing end. Any tips on the easiest way to approach this? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CF_Wait Tag
Title: CF_Wait Tag Try the CFX_Sleep tag. -Original Message-From: Rick Eidson [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 17, 2002 10:17 AMTo: CF-List (E-mail)Subject: [KCFusion] CF_Wait Tag Where can I get this CFX_Wait Tag i don't see it in the tg Gallery. Rick
RE: [KCFusion] Scheduled Datasource Updating
We have a scheduled BAT file running on our web server each night that updates a database file. The unfortunate thing is we actually down the website to perform the updates and then bring the website back up. The BAT file looks look this: net stop WORLD WIDE WEB PUBLISHING SERVICE C:\Update.exe net start WORLD WIDE WEB PUBLISHING SERVICE Randy -Original Message- From: Bakken, Kory [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:09 AM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Scheduled Datasource Updating I need to schedule maintenance window each night to perform automated repairs and compaction on my main database. I know how to do that, but in order to repair and compact the database, I need to disconnect the datasource that is hitting against it for that period of time. Does anybody know if it is possible to schedule updates to a datasource (i.e.-disconnect and reconnect)? Kory Bakken IT Enterprise Release Management Tools / Process desk: 816.559.4801 pcs:816.305.5890 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] arrays and querys
You can view the results of a Query as an array. So your query... CFQUERY NAME="test" DATASOURCE="ReservationSystem"SELECT date_numFROM dbo.DatesTimes Where class_num = 4;/CFQUERY If test.recordcount is greater than 0, you can access the results by using the following syntax. test.date_num[???] Where ??? is a number between 1 and test.recordcount Randy Ellis -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]Sent: Friday, October 19, 2001 3:37 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] arrays and querys Ok so after a bit of guess work this is what I came up with: CFQUERY NAME="test" DATASOURCE="ReservationSystem"SELECT date_numFROM dbo.DatesTimes Where class_num = 4;/CFQUERY cfset date_nums = ArrayNew(1)cfloop query="test"cfset date_nums[test.currentRow] = date_num /cfloop Is it possible to make this more efficient or elegant (i.e. professional)? Adaryl
RE: [KCFusion] Creating a CSV file
Have you tried placing single quotes around the text field? Change #LocSendTo1# to '#LocSendTo1#' Change output="#ResaleNumber#,#LocSendTo1#,#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#" to output="#ResaleNumber#,'#LocSendTo1#',#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#" Just a thought, Randy -Original Message-From: Rick Eidson [mailto:[EMAIL PROTECTED]]Sent: Monday, October 15, 2001 2:53 PMTo: CF-List (E-mail)Subject: [KCFusion] Creating a CSV file cffile nameconflict="OVERWRITE" action=append file="#FilePath##FileName#" output="" cfloop query="QryGetShippingInfo" cfset LocRequestorName = "#RequestorFirstName# #RequestorMiddleName# #RequestorLastName#" cfset LocSendTo = "#DeliveryAttention##CHR(13)##Replace(LocRequestorName,' ',' ,'All')##CHR(13)##DeliveryCompany##Chr(13)##TitleCompanyName##chr(13)##TitleCompanyAgent##Chr(13)#" cfif ListLen(LocSendTo, CHR(13)) gt 1 cfset LocSendTo1 = ListGetAt(LocSendTo, 1, CHR(13)) /cfif cffile action="append" file="#FilePath##FileName#" output="#ResaleNumber#,#LocSendTo1#,#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#" /cfloop cffile action="read" file="#FilePath##FileName#" variable="Tabfile" My problem is that sometimes LocSendTo1 contains a Comma witch causes my CSV file insert another Column. How do I get around this? Rick
RE: [KCFusion] dynamic dropdowns
Here is a working solution I just created. If the code is not clear, email
me with questions at [EMAIL PROTECTED]
You will need to modify the code for your stored procedures and default
values.
html
head
titleStates and Counties/title
SCRIPT LANGUAGE=JavaScript
// Load every county from every state
CFQUERY NAME=StatesCounties DATASOURCE=StateCounty
SELECT CountyName, StateAbbr
FROM Counties
/CFQUERY
CFINCLUDE template='/CFIDE/scripts/wddx.js'
// Convert the CF Query data into Javascript variables
CFWDDX ACTION='cfml2js' input=#StatesCounties#
topLevelVariable='StatesCounties'
function ChangeCounties(STAbbr, CountyNm) {
nRows = StatesCounties.getRowCount();
var ctr = 0;
for (row = 0; row nRows; ++row) {
if (STAbbr.value == StatesCounties.getField(row,
'StateAbbr')) {
// Load the dropdown list with counties for the
state selected
CountyNm.options[ctr]=new
Option(StatesCounties.getField(row,
'CountyName'),StatesCounties.getField(row, 'CountyName'));
ctr++;
}
}
return true;
}
/SCRIPT
/HEAD
BODY
CFQUERY NAME=States DATASOURCE=StateCounty
Select StateName, StateAbbr
From States
Order By StateName
/CFQUERY
FORM
SELECT NAME=STAbbr ONCHANGE=ChangeCounties(this.form.STAbbr,
this.form.CountyNm)
OPTION VALUE=XXSelect State
CFOUTPUT QUERY=States
OPTION VALUE=#States.StateAbbr##States.StateName#
/CFOUTPUT
/SELECT
SELECT NAME=CountyNm
OPTION VALUE=NoneSelect County
/SELECT
/FORM
/body
/html
Hope this helps,
Randy Ellis
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 2:47 PM
To: KCFusion-List
Subject: [KCFusion] dynamic dropdowns
We are working on a page that involves a state drop
down list and the counties in that state. We want to
make it dynamic so when a user chooses Missouri, just
the counties in Missouri are available.
Here's what I got so far. On the onchange event for
the state drop down we are setting a variable called
favorite. If I declare an input whose name is
favorite you can see this getting changed each time a
new state is chosen. How do I go about setting up the
stored procedure to accept this variable as an
argument and reretrieve it each time the state is
changed?
I've included my attempt at this but I'm not having
any luck.
Thanks,
Chris
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0
Transitional//EN
html
script language=JavaScript type=text/javascript
function put()
{
option=document.forms[0].st_ct.options[document.forms[0].st_ct.selectedIndex
].text
txt=option
document.forms[0].favorite.value=txt
}
/script
!--- set up defaults for state and county ---
cfset ls_st_ct = MO
cfset li_county_num = 8
cfstoredproc procedure=get_states
datasource=#application.glopds#
username=#application.glouser#
returncode=NO
cfprocparam type=In
cfsqltype=CF_SQL_VARCHAR
dbvarname=@as_code_type
value=us_st_ct
null=No
cfprocresult name=linkstate
/cfstoredproc
body
head
titleWhatever/title
/head
cfform name=detail
table width=800 border=0 cellspacing=0
cellpadding=0
tr
td colspan=2Test the state/county drop down/td
/tr
tr
!--- Set up the states drop down list ---
tdState:/td
tdselect name=st_ct onchange=put()
cfoutput query=linkstate
option value= #linkstate.code_id#
cfif trim(ls_st_ct) eq
#trim(linkstate.code_id)#selected/cfif
#linkstate.code_desc#/option
/cfoutput
/select
/td
!--- Retrieve the county drop down list based off
of the chosen state. ---
tdCounty:/td
!--- tdinput name=favorite
value=Missouri/td ---
tdselect name=favorite
onChange=cfstoredproc
procedure=county_num_name
datasource=#application.glopds#
username=#application.glouser#
returncode=NO
cfprocparam
type=In
cfsqltype=CF_SQL_CHAR
dbvarname=@as_st_ct
value=form.favorite
null=No
cfprocresult name=linkcounty
/cfstoredproc
cfoutput
query=linkcounty
option value= #linkcounty.county_num#
cfif li_county_num eq
#linkcounty.county_num#selected/cfif
#linkcounty.county_name#
/option
