Re: Double Dimesion ArraySorting
Thanks a ton! I'll work on that ! cheers, vin -Original Message- From: JustinMacCarthy To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 11, 2000 5:52 PM Subject: Re: Double Dimesion ArraySorting Build a structure (associative array) where you have the value you are trying to sort (array[x][5]) as the keyname and the array[x] as the keyvalue -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Free text verity search in CF
Guys, may I know how do I achieve searching only part of the word in verity search without using any wildcard? For example, I just type "ho" in the textbox and all the words that consists of "ho" will be found. thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
? onChange and cfset
Hi, There is a select list in my form. I want a new form filed to be written after the selection is done before the form submit: select name="country" option value="uk"UK option value="usa"USA /select If user selects UK, a new form will written under the selection field: PUK something: UK related form fields If user selects USA, another field will be writtten under this selection: p USA something.USA related form fields --- I am doing this using onChange , but does not work: select name="country" size="1" onChange="mycountry=select_country(this.form,this.options[this.selectedIndex].value)" option value="uk"UK option value="usa"USA /select SCRIPT LANGUAGE="JavaScript" function select_country(my_form,my_select_value) { var temp=0; temp=my_select_value; return temp; } /SCRIPT - Also tried select name="country" size="1" onChange="cfset mycountry=select_country(this.form,this.options[this.selectedIndex].value)" How to pass this.options[this.selectedIndex].value to Coldfusion variable before submit? I want to do this after one option is selected in the same form: cfif mycountry is "uk" field group 1 cfelseif mycountry is "usa" filed group2 /cfif Thanks Ins __ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF-Talk V1 #139 (Out of office)
Can we say annoying? OK... "annoying" snigger On this subject though, can someone (Mike if he's available) unsubscribe this guy This might sound snotty, but I think we should have a "You'll be unsubscribed if you send Out Of Office replies to this list" policy - the quantity of people isn't huge, but it's still annoying Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FORM values doubling when submitted. (When CP from Word)
I have a simple form, show below, which is causing me problems. The users Copy Paste text from Word into the text area. Sometimes, the err.. "extended characters" for want of a better word, cause problems. For example, typing "hello world" into Word changes the double quotes into nice looking curly one, which look like 66 99. The same for three periods '...' turn into some funky 3dot character. When these submit to the next page, they double up... Here's the form I'm using... form action="add_update_news.cfm" method="post" name="newsForm" enctype="multipart/form-data" input type="text" name="headline" value="" size="50" style="width: 393;" textarea cols=46 rows=20 name="article" style="width: 393;"/textarea input type="file" name="image1" value="" size="50" style="width: 393;" input type="Submit" value="Submit"nbsp;nbsp;input type="Reset" value="Reset"nbsp;nbsp; /form I enter 'title' into the text box called headline and '"hello world"' (copy and pasted from Word) into the textarea. On the next page, if I output the form fields passed to me I get... #headline# = title,title #article# = "hello world","hello world" This is even before I do anything else on the page. Now the weird part, if I remove the file upload part of the form, everything works fine. Anyone come across this problem of copying and pasting from Word, and what do I do about the funky characters. Cheers Dan. This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible.The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Select Distinct not so distinct
I'm trying to select all of the values from a table where type=foo and I would like to eliminate duplicates based on name. EG. SQL="select distinct(name), other, field, names from table where type = foo" -this returns every field where type is a match. SQL="select distinct(name) from table where type = foo" -this works but does not retrieve additional field info. Am I to understand that select distinct cannot be utilized in this fashion? It works if I select the name field only, but if I want more than the name field it returns all matches. I cannot ask that the database be restructured. But if there are n rows sharing the same value in the 'name' column, which of those rows do you want the query to return??? Or do you want the values in the other columns aggregated in some way? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF-Talk V1 #140 (Out of office)
I am currently out of the office and will return on Monday, August 21. Any urgent concerns should be forwarded to David McCormick or Mary Prosceno. CF-Talk 08/14/00 06:44 CF-TalkMon, 14 Aug 2000 Volume 1 : Number 140 In this issue: Re: CF-Talk V1 #139 (Out of office) Re: CF-Talk V1 #139 (Out of office) Mail Archives Re: Mail Archives Re: Mail Archives cfgrid and submit buttons Re: Double Dimesion ArraySorting Free text verity search in CF ? onChange and cfset RE: CF-Talk V1 #139 (Out of office) FORM values doubling when submitted. (When CP from Word) RE: Select Distinct not so distinct -- Date: Sun, 13 Aug 2000 22:34:54 -0400 From: "Julie Hopple" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: CF-Talk V1 #139 (Out of office) Message-ID: [EMAIL PROTECTED] I am currently out of the office and will return on Monday, August 21. = Any urgent concerns should be forwarded to David McCormick or Mary = Prosceno. CF-Talk 08/13/00 22:44 CF-TalkSun, 13 Aug 2000 Volume 1 : Number = 139 In this issue: Re: Using CFX_PGP tag... comments? Re: Using CFX_PGP tag... comments? Oracle Time...again Help - writeEmergencyMessage Error ! mySQL,cf,W2K: possible? Re: Help - writeEmergencyMessage Error ! Re: [mySQL,cf,W2K: possible?] RE: [mySQL,cf,W2K: possible?] RE: [mySQL,cf,W2K: possible?] RE: More elegant way of passing URL variables? Re: Oracle Time...again RE: Queries RE: user interface resources/groups Re: Database problems RE: user interface resources/groups RE: user interface resources/groups Dynamic Filefield in CFFILE? RE: user interface resources/groups nesting queries Re: nesting queries Re: nesting queries RE: nesting queries RE: nesting queries RE: nesting queries -- Date: Sun, 13 Aug 2000 06:58:31 -0400 From: Bud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Using CFX_PGP tag... comments? Message-ID: p04320400b5bc2c05cba3@[192.168.0.2] On 8/13/00, Britta Wingenroth penned: I'm building a site that will take credit card information online on SSL = but send it to the business to be processed by hand. I need for the mail = that gets sent from the cfmail tag to be encrypted. Apparently PGP is installed on my ISP, but the SysAdmins don't know how to use it. I'm thinking of buying the cfx_pgp tag from the allaire site... has = anyone used it? Any comments? Is it secure just with using the free version of PGP6 and this tag? Are there any other products out there that would do = the same thing for $150? Thanks for any feedback! Yep. Pretty easy. I use it to store credit card information in a=20 database of recurring monthly billing. I tried all kinds of stuff,=20 cfx_hash, cf_cryption, cf_encryption. Nothing does what it's supposed=20 to do. This is probably the most secure method anyway. Here is the tag, subject being the string to encrypt; cfx_pgp action=3D"encrypt" subject=3D"#encryptit#" keyring=3D"C:\Pgpnt\Keyrings\pubring.pkr" UserID=3D"[EMAIL PROTECTED]" Not exactly sure how you would get their public key into the keyring=20 on the ISPs server, maybe by importing from a public keyserver. I'm a=20 little new to PGP and have never tried that, but there is also a=20 parameter "KEYSERVER" that you'd replace KEYRING above with and put a=20 FQDN to a public keyserver to get the recipient's public key. I would=20 presume it may be quicker using a keyring right on the server though,=20 if possible. After running the tag above, you'd just place the=20 variable #PGPOut# into the cfmail body. You can also specify your own=20 variable name. To see a quick demo: http://www.twcreations.com/pgp/ --=20 Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Date: Sun, 13 Aug 2000 07:00:26 -0400 From: Bud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Using CFX_PGP tag... comments? Message-ID: p04320401b5bc2ff4b8f9@[192.168.0.2] I forgot to mention. I'm not sure if this will work with the freeware=20 version of PGP. I don't think so. --=20 Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Date: Sun, 13 Aug 2000 10:31:43 -0400 From: Scott Mulholland [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: Oracle Time...again Message-ID:
RE: Select Distinct not so distinct
Correct. "Select Distinct" selects distinct records for ALL of the columns that you supplied. i.e. "SELECT DISTINCT name From table" selects one record for each distinct name. "SELECT DISTINCT name, otherfield From table" selects one record for each distinct combination of name and other field. What you can do is select all distinct names into a temporary table and then do a second select combining these records and the additional info from the table based on a the primary key. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 14 August 2000 11:37 To: '[EMAIL PROTECTED]' Subject: RE: Select Distinct not so distinct I'm trying to select all of the values from a table where type=foo and I would like to eliminate duplicates based on name. EG. SQL="select distinct(name), other, field, names from table where type = foo" -this returns every field where type is a match. SQL="select distinct(name) from table where type = foo" -this works but does not retrieve additional field info. Am I to understand that select distinct cannot be utilized in this fashion? It works if I select the name field only, but if I want more than the name field it returns all matches. I cannot ask that the database be restructured. But if there are n rows sharing the same value in the 'name' column, which of those rows do you want the query to return??? Or do you want the values in the other columns aggregated in some way? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Remote SQL server as datasource
I have seen this happen if the network protocol was "NAMED PIPES". Check the SQL Client configuration in the ODBC32 application in Control Panel, and try TCP/IP. DC - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 21:12 Subject: Remote SQL server as datasource Hi Folks, I am trying to set a remote MS SQL server (via the internet) as an ODBC datasource in ColdFusion 4.x. I can get the connection going fine in the ODBC control panel. But in the ColdFusion administrator the datasource verification fails. Does anyone have any ideas of what could be wrong? Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Studio - report unused files.
This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_3169921C.DDBCD625 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Can studio report which files are not being uses in a site? If not, does = anyone know of a software that does? Thanks Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 --=_3169921C.DDBCD625 Content-Type: text/plain Content-Disposition: attachment; filename="David Clay.vcf" BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Clay, David EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] TEL;PREF;FAX:(303) 770-8506 X-GWUSERID:clayd ADR;DOM;WORK;PARCEL;POSTAL:;Denver LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Clay, David=0A= Denver ORG:;Engineering Automation Group N:Clay;David TEL;WORK:(303) 967-1558 TITLE:Web Facilitator END:VCARD --=_3169921C.DDBCD625-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
one more try re: oracle stored proc and session mgmt
I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Double Dimesion ArraySorting
I'm a bit dissappointed no one else submitted method. Anyone got a better why then this ~Justin - Original Message - From: "Vincent" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 14, 2000 7:35 AM Subject: Re: Double Dimesion ArraySorting Thanks a ton! I'll work on that ! cheers, vin -Original Message- From: JustinMacCarthy To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 11, 2000 5:52 PM Subject: Re: Double Dimesion ArraySorting Build a structure (associative array) where you have the value you are trying to sort (array[x][5]) as the keyname and the array[x] as the keyvalue -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
database
City/County/state URL http://www.naco.org/counties/queries/city1_res.cfm?STATECODE=md I have a state/county database I could send you. I don't have a state/country db. Let me know if you'd like the db I have and I'll send it over. Bonnie R. -Original Message- From: Bonnie Betts (E-mail 2) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:43 PM To: Cf-Talk (E-mail) Subject: FW: Bonnie E. Betts [EMAIL PROTECTED] 703-344-7057 -Original Message- From: Bonnie Betts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:36 PM To: Cf-Talk (E-mail) Subject: Does anyone know where the url is for the states-country database someone had post a while back? Bonnie E. Betts [EMAIL PROTECTED] 703-344-7057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Oracle Time...again
Scott, You could update using 'Sysdate' which will update the record with date and time. I havent been using oracle in a while, look at what 'sysdate' inserts and pass the sql string in same format. Hope this helps. Thanks Joe --- Original Message --- Scott Mulholland [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 08:13:03 -0400 -- Joe, Thanks for the reply...I am not having any issues with the date, I can insert/update these with no problem, it is when I try to capture the time as well that it is failing. Scott -Original Message- From: Joseph Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 13, 2000 5:02 PM To: [EMAIL PROTECTED] Subject: Re: Oracle Time...again Scott, The date format is Oracle is very picky. Its worth having an Oracle sql referrence book. If you just want the current date "update MyTable set API_UPDATE = 'Sysdate'" This will update the date field to the current oracle db date. If you want to manually update the date with CF you have to use the format "12-Jun-2000" The month should be abbreviated to 3 chars Thanks Joe - Original Message - From: "Scott Mulholland" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 13, 2000 10:31 AM Subject: Oracle Time...again This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C00533.33F6C520 Content-Type: text/plain; charset="iso-8859-1" I am using the following statement to insert a date/time string into an Oracle table (date field type): update MyTable set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss tt")#') I keep getting the error message: ORA-01843: not a valid month Any ideas? Thanks, Scott --_=_NextPart_001_01C00533.33F6C520 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVSPAN class=030583114-13082000FONT face=Arial size=2I am using the following statement to insert a date/time string into an Oracle table (date field type):/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2/FONT/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2update MyTable/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2set /FONT/SPANSPAN class=030583114-13082000FONT face=Arial size=2API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss tt")#')/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2/FONT/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2I keep getting the error message: FONT face="Times New Roman" size=3ORA-01843: not a valid month /FONT/FONT/SPAN/DIV DIVSPAN class=030583114-13082000/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2Any ideas?/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2/FONT/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2Thanks,/FONT/SPAN/DIV DIVFONT face=Arial size=2Scott/FONT/DIV/BODY/HTML --_=_NextPart_001_01C00533.33F6C520-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Oracle Time...again
Scott, You could update using 'Sysdate' which will update the record with date and time. I havent been using oracle in a while, look at what 'sysdate' inserts and pass the sql string in same format. Hope this helps. Thanks Joe --- Original Message --- Scott Mulholland [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 08:13:03 -0400 -- Joe, Thanks for the reply...I am not having any issues with the date, I can insert/update these with no problem, it is when I try to capture the time as well that it is failing. Scott -Original Message- From: Joseph Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 13, 2000 5:02 PM To: [EMAIL PROTECTED] Subject: Re: Oracle Time...again Scott, The date format is Oracle is very picky. Its worth having an Oracle sql referrence book. If you just want the current date "update MyTable set API_UPDATE = 'Sysdate'" This will update the date field to the current oracle db date. If you want to manually update the date with CF you have to use the format "12-Jun-2000" The month should be abbreviated to 3 chars Thanks Joe - Original Message - From: "Scott Mulholland" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 13, 2000 10:31 AM Subject: Oracle Time...again This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C00533.33F6C520 Content-Type: text/plain; charset="iso-8859-1" I am using the following statement to insert a date/time string into an Oracle table (date field type): update MyTable set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss tt")#') I keep getting the error message: ORA-01843: not a valid month Any ideas? Thanks, Scott --_=_NextPart_001_01C00533.33F6C520 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVSPAN class=030583114-13082000FONT face=Arial size=2I am using the following statement to insert a date/time string into an Oracle table (date field type):/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2/FONT/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2update MyTable/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2set /FONT/SPANSPAN class=030583114-13082000FONT face=Arial size=2API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss tt")#')/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2/FONT/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2I keep getting the error message: FONT face="Times New Roman" size=3ORA-01843: not a valid month /FONT/FONT/SPAN/DIV DIVSPAN class=030583114-13082000/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2Any ideas?/FONT/SPAN/DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2/FONT/SPAN /DIV DIVSPAN class=030583114-13082000FONT face=Arial size=2Thanks,/FONT/SPAN/DIV DIVFONT face=Arial size=2Scott/FONT/DIV/BODY/HTML --_=_NextPart_001_01C00533.33F6C520-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Studio - report unused files.
http://www.tetranetsoftware.com/products/link-data.htm This is about the only program I know of that does find orphans. It's $495. There's another that does it as well called smart site. (don't know the URL). However, it has big problems. I bought it one day at CompUSA. I tried it on a couple of pages but it didn't return anything. I called their tech support. They said that if my pages didn't adhere to strict html standards it would have problems. Meaning my comment tags were like this: !-- comments here --- The ending part was longer that two dashes. So, while sxearching the page their software would bomb out. Got my $$ back on that one. John Cesta http://www.cybersmarts.net - ColdFusion ASP and ActiveState PERL Hosting www.serverautomationtools.com -Original Message- From: David Clay [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 8:50 AM To: [EMAIL PROTECTED] Subject: Studio - report unused files. This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_3169921C.DDBCD625 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Can studio report which files are not being uses in a site? If not, does = anyone know of a software that does? Thanks Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 --=_3169921C.DDBCD625 Content-Type: text/plain Content-Disposition: attachment; filename="David Clay.vcf" BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Clay, David EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] TEL;PREF;FAX:(303) 770-8506 X-GWUSERID:clayd ADR;DOM;WORK;PARCEL;POSTAL:;Denver LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Clay, David=0A= Denver ORG:;Engineering Automation Group N:Clay;David TEL;WORK:(303) 967-1558 TITLE:Web Facilitator END:VCARD --=_3169921C.DDBCD625-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: one more try re: oracle stored proc and session mgmt
1. Call the stored procedure (pass the sessionid and valid hours to the sp): cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN" cfprocparam type="in" dbvarname="sesid" value="#sessionid# cfsqltype"datatype" cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs# cfsqltype"datatype" cfprocparam type="out" variable="sp_results" cfsqltype"varchar2" /cfstoredproc 2. Put the call: in your application.cfm 3. Loginaction: add the logged-in userid to the correct record in the database, create variables for sessionid and validhrs 4. application.cfm: run the stored procedure, if the output is null, the user is not supposed to be logged in anymore. If it returns a user id, make sure its the right user and all that. 5. Oracle stored procedures don't return a regular recordset to cf, so you might need to play with the "sp_results" to get the output to work. hth, Matt -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: one more try re: oracle stored proc and session mgmt I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: one more try re: oracle stored proc and session mgmt
maybe you could also use a call statement.. cfquery Name="Test" Datasource="your_data" Call FunctionName(Param1, param2); /cfquery --- Original Message --- "Matt Rodosky" [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 07:42:25 -0600 -- 1. Call the stored procedure (pass the sessionid and valid hours to the sp): cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN" cfprocparam type="in" dbvarname="sesid" value="#sessionid# cfsqltype"datatype" cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs# cfsqltype"datatype" cfprocparam type="out" variable="sp_results" cfsqltype"varchar2" /cfstoredproc 2. Put the call: in your application.cfm 3. Loginaction: add the logged-in userid to the correct record in the database, create variables for sessionid and validhrs 4. application.cfm: run the stored procedure, if the output is null, the user is not supposed to be logged in anymore. If it returns a user id, make sure its the right user and all that. 5. Oracle stored procedures don't return a regular recordset to cf, so you might need to play with the "sp_results" to get the output to work. hth, Matt -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: one more try re: oracle stored proc and session mgmt I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: one more try re: oracle stored proc and session mgmt
maybe you could also use a call statement.. cfquery Name="Test" Datasource="your_data" Call FunctionName(Param1, param2); /cfquery --- Original Message --- "Matt Rodosky" [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 07:42:25 -0600 -- 1. Call the stored procedure (pass the sessionid and valid hours to the sp): cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN" cfprocparam type="in" dbvarname="sesid" value="#sessionid# cfsqltype"datatype" cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs# cfsqltype"datatype" cfprocparam type="out" variable="sp_results" cfsqltype"varchar2" /cfstoredproc 2. Put the call: in your application.cfm 3. Loginaction: add the logged-in userid to the correct record in the database, create variables for sessionid and validhrs 4. application.cfm: run the stored procedure, if the output is null, the user is not supposed to be logged in anymore. If it returns a user id, make sure its the right user and all that. 5. Oracle stored procedures don't return a regular recordset to cf, so you might need to play with the "sp_results" to get the output to work. hth, Matt -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: one more try re: oracle stored proc and session mgmt I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: one more try re: oracle stored proc and session mgmt
maybe you could also use a call statement.. cfquery Name="Test" Datasource="your_data" Call FunctionName(Param1, param2); /cfquery --- Original Message --- "Matt Rodosky" [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 07:42:25 -0600 -- 1. Call the stored procedure (pass the sessionid and valid hours to the sp): cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN" cfprocparam type="in" dbvarname="sesid" value="#sessionid# cfsqltype"datatype" cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs# cfsqltype"datatype" cfprocparam type="out" variable="sp_results" cfsqltype"varchar2" /cfstoredproc 2. Put the call: in your application.cfm 3. Loginaction: add the logged-in userid to the correct record in the database, create variables for sessionid and validhrs 4. application.cfm: run the stored procedure, if the output is null, the user is not supposed to be logged in anymore. If it returns a user id, make sure its the right user and all that. 5. Oracle stored procedures don't return a regular recordset to cf, so you might need to play with the "sp_results" to get the output to work. hth, Matt -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: one more try re: oracle stored proc and session mgmt I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFXhosting.com?
Can anybody provide comments about these guys? Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Confirm CF bugs
Hi All, Does anyone know if there is a list of confirmed bugs in CF anywhere. Or is it a case of looking at all the KB articles?? ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Adding numbers to a select box... urgent
Here you go Mark: It worked for me... OPTION VALUE="#trim(GetAcctInfo.Account)# CFIF Len(GetAcctInfo.Sub_Account) EQ 4 #rtrim(GetAcctInfo.sub_account)#CFELSE /cfif"#trim(GetAcctInfo.Account)# CFIF Len(GetAcctInfo.Sub_Account) EQ 4 #rtrim(GetAcctInfo.sub_account)#CFELSE /cfif/OPTION H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -Original Message- From: Marc Lippman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 4:20 PM To: [EMAIL PROTECTED] Subject: Adding numbers to a select box... urgent I'm in a bind here, I have to add 4 0's to a select box if the "Sub-account" does not exist, otherwise, just use the sub-account. Here's the code: OPTION VALUE="#trim(GetAcctInfo.Account)##trim(GetAcctInfo.sub_account)#"#trim(Get AcctInfo.Account)##rtrim(""GetAcctInfo.sub_account, 4)#/OPTION Right now, it doesn't work. Any guru's out there have an idea? Marc -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Search engine for dynamic sites
Anyone know of a search engine that's capable of searching dynamic sites? Our intranet uses a fusebox based content engine. Pages are generated from a combination of SQL data and CFINCLUDED html documents. Indexing the data and documents themselves won't work because you can't tell for sure on what page(s) a piece of content will appear, so what would the links be?The easiest option seems to be to index the site by crawling the pages on a regular basis; not perfect, but it will do for the moment. So, does anyone have any suggestions for a suitable tool? -- Paul Wakefield Hofstadter's Law - It always takes longer than you think, even if you take into account Hofstadter's Law. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
creating your own functions in cold fusion
There was an email (either here or fusebox list) about creating your own functions in cold fusion. Does anyone know where the article explaining it is because I have moved jobs and lost all my archives of CF-Talk. Thanks Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using TRIM
Could it be because the fields in the database are set to CHAR and not to VARCHAR? -Original Message- From: Planet CF [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 10:38 AM To: [EMAIL PROTECTED] Subject: Using TRIM Hi All, A 'Select' on a Sybase Database results in extra spaces being added to the data being selected (mostly spaces on the right). I really don't know as to why this is happenning. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Using TRIM
html font size=3A field of type char(30) will return a 30 character long string padded with spaces on the right.br Use varchar instead.br br br At 07:37 AM 8/14/00 -0700, Planet CF wrote:br blockquote type=cite citeHi All,br A 'Select' on a Sybase Database results in extrabr spaces being added to the data being selected (mostlybr spaces on the right). I really don't know as to whybr this is happenning.br br So what we do is use the TRIM function to get rid ofbr those spaces. Now this has become some kind of abr quot;xtraquot; in the application. Like... if somehow youbr forget to TRIM, you end up in errors which are notbr traceable to a specific code for a long timebr kindof time consuming... and frustratiing too. br br There could be two solutions to this problem:br 1. Find out the reason for the 'spaces' that are beingbr added and fix the problem at the root.br br 2. Assuming that the problem cannot be fixed and onebr has to deal with TRIM, a better way of doing it (thatbr comes to my mind) would be to write a custom tag thatbr TRIM's all query data before sending it to the callingbr page. Is there a custom tag on the gallery, thatbr already does this?br br Any suggestions or comments are welcome.br br Thanksbr Kedar Desaibr Differential Technologiesbr Fairfax, VAbr br br __br Do You Yahoo!?br Yahoo! Mail Free email you can access from anywhere!br a href="http://mail.yahoo.com/" eudora="autourl"http://mail.yahoo.com//abr --br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//abr To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3--br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF And SQL Server
Hey, I got a question about setting up seperate DB and CF servers. Currtnly im running SQL 7 and CF4.51 on NT/SP6 on the same machine. I wish to put SQL on its own server. My question is network traffic, as since they are on seperate machines, ALL DB activity has to go through the network, which is 100 MB. Is it better to allow it to go over the 'normal path' through the switch to the other machine? Or am I better off setting up a patch cable between the two spare NICs on the servers, hence a private network between the two machines. What routing requirements and other network issues would I have in using a private network. Could I tell NT that all request for the other server to go over the private link? I know I can do simular things with linux using routed and hosts. It seems like it would make a bunch of sense, since that traffic wouldnt have to shuffle accross the same wire that my customers come though. thanx David -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Question with CFCACHE tag
Can the CFCache tag's "cache directory" and "map directory" use a mapped drive. Thinking about using it in a load balanced environment. Rick _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
identifying a query
Hello, I have a problem with users running a query, then selecting different options and running the query again. The user then backs up their browser to the first query results and hits the "next page" button and the code errors out because of the rowcount being different than the last query ran. What's the quickest/easiest method to keep the user from accessing the first query results? Tks Bonnie Russell [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: E-commerce Security, for the non programmer..
Hello. My brother Adam just got promoted at the Credit Card Co. that he works for. He has been in fraud security for a couple of years. His new position is to look at e-commerce sites that are using his Co.'s. card. If they are not secure he needs to shut them down, revoke usage of said card. I have never done any CF related shopping carts, so I really cant give him any advice on Key things to pay attention to. If you have any good resources, [Books, URL's], Tests, or just advice please respond. I would like to help him out. Thanks a bunch I apologize for the OT: His email is [EMAIL PROTECTED] -paul Web Developer, nbbj Work: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 614 241-3534 Home: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 614 449-1681 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] icq: 47658358 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: E-commerce Security, for the non programmer..
Check out the The World Wide Web Security FAQ @ http://www.perl.com/pub/doc/FAQs/cgi/www-security-faq.html ~Justin MacCarthy - Original Message - From: "Paul Ihrig" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 14, 2000 4:05 PM Subject: OT: E-commerce Security, for the non programmer.. Hello. My brother Adam just got promoted at the Credit Card Co. that he works for. He has been in fraud security for a couple of years. His new position is to look at e-commerce sites that are using his Co.'s. card. If they are not secure he needs to shut them down, revoke usage of said card. I have never done any CF related shopping carts, so I really cant give him any advice on Key things to pay attention to. If you have any good resources, [Books, URL's], Tests, or just advice please respond. I would like to help him out. Thanks a bunch I apologize for the OT: His email is [EMAIL PROTECTED] -paul Web Developer, nbbj Work: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 614 241-3534 Home: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 614 449-1681 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] icq: 47658358 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: E-commerce Security, for the non programmer..
The shopping cart/cc portion MUST be under an SSL, note the closed "lock" at the bottom of the browser and HTTPS instead of HTTP. Check that the CC no is NOT going over the URL (I've actually seen this done). I don't know if there's a way to check, but the CC no should not be going through email either. It's not necessary to have more information than the CCNO for a transaction to occur, I think this is bad business on the banks part. There really should be more validation than just the number, but again, it's not required with all banks. Just remember that I am in no way an e-commerce expert. These are just my observations so far. Good Luck Bonnie -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 11:05 AM To: '[EMAIL PROTECTED]' Subject: OT: E-commerce Security, for the non programmer.. Hello. My brother Adam just got promoted at the Credit Card Co. that he works for. He has been in fraud security for a couple of years. His new position is to look at e-commerce sites that are using his Co.'s. card. If they are not secure he needs to shut them down, revoke usage of said card. I have never done any CF related shopping carts, so I really cant give him any advice on Key things to pay attention to. If you have any good resources, [Books, URL's], Tests, or just advice please respond. I would like to help him out. Thanks a bunch I apologize for the OT: His email is [EMAIL PROTECTED] -paul Web Developer, nbbj Work: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 614 241-3534 Home: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 614 449-1681 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] icq: 47658358 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF And SQL Server
What is network utilization looking like between the CF server and switch port? Unless your utilization is peaking to higher than 75% then I wouldn't think your going to have to much of a problem. IMHO, I'd keep things simple and use the existing network. Bill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF And SQL Server
I have done it both ways, a separate network for the sql and webservers and allowing SQL and CF to go over the "normal path". After testing and monitor, I saw no difference. We have an 100MB network between the servers and switches. But we have only 15MB of bandwidth provided to us. So this, in theory, leaves us with 85MB. Keeping SQL and CF on the same network with the internet traffic did not cause any slowdowns and network congestion. Jacob At 10:43 AM 8/14/00 -0500, you wrote: Hey, I got a question about setting up seperate DB and CF servers. Currtnly im running SQL 7 and CF4.51 on NT/SP6 on the same machine. I wish to put SQL on its own server. My question is network traffic, as since they are on seperate machines, ALL DB activity has to go through the network, which is 100 MB. Is it better to allow it to go over the 'normal path' through the switch to the other machine? Or am I better off setting up a patch cable between the two spare NICs on the servers, hence a private network between the two machines. What routing requirements and other network issues would I have in using a private network. Could I tell NT that all request for the other server to go over the private link? I know I can do simular things with linux using routed and hosts. It seems like it would make a bunch of sense, since that traffic wouldnt have to shuffle accross the same wire that my customers come though. thanx David -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Signed Objects (scripts) with IE 5.x
I know this is OT but does anyone know where I can find some info on how IE handles signed scripts (javascript)... I can find lots of docs on NN, but nothing on IE. TIA Dick -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dynamic
Sorry if this has been covered before. I need a way of reading form fields on a dynamic basis through a loop. Ie. Form fields: Qty1 - Qty6, Main1 - Main6, Block1 - Block6 etc etc Rather than having 6 almost identical blocks of code to handle each set of fields I'd like to just run through a CFLOOP 6 times. The fields are created in this way on the previous template (see below) but I'm unsure of the syntax to actually read the fields on the subsequent (if it is possible). cfloop index="i" from="1" to="6" cfinput name="Qty#i#".etc Any ideas? Neil Robinson -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Refining Search
Can someone point me in the right direction. I have done verity searched before, but now is there a standard way to let the user refine his or her search results. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Server hardware and software config
I've got a customer that wants to host his own sites. All of my sites have been hosted with an ISP and I've never gotten into working with servers. He wants me to organize the process of setting everything up. I'd like some opinions on hardware/software configurations for running multiple CF sites with medium traffic. This is just in the planning stage, so we haven't bought anything yet. A couple of opinions of different configurations of, name brand boxes, white boxes, operating systems, databases, email servers, etc. would be nice. Or if there are resources already on the web, that would help too. (searched the allarie site, but didn't find anything) Thanks for your help, Brad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Dynamic
Try this, it's worked for me in the past cfloop index="i" from="1" to="6" cfset tempvar='Qty' '#index#' input name="#tempvari#" value="#Evaluate("#tempvar#")#" /cfloop This should give inputs Qty1 to Qty6 with the values past from the previous page. Hope this works. Steve Wach Software Engineer Canadian Web Design Consulting Inc. A: 701-281 McDermot Avenue (McDermot King) P: 204-946-5155 C: 204-228-0477 F: 204-946-5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com - Original Message - From: Neil Robinson [EMAIL PROTECTED] To: CFList [EMAIL PROTECTED] Sent: Monday, August 14, 2000 10:41 AM Subject: Dynamic Sorry if this has been covered before. I need a way of reading form fields on a dynamic basis through a loop. Ie. Form fields: Qty1 - Qty6, Main1 - Main6, Block1 - Block6 etc etc Rather than having 6 almost identical blocks of code to handle each set of fields I'd like to just run through a CFLOOP 6 times. The fields are created in this way on the previous template (see below) but I'm unsure of the syntax to actually read the fields on the subsequent (if it is possible). cfloop index="i" from="1" to="6" cfinput name="Qty#i#".etc Any ideas? Neil Robinson -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Dynamic
I've done this before. Here's how: cfloop index="i" from="1" to="6" cfparam name="Qty#i#" default="" ... /cfloop -Original Message- From: Neil Robinson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 10:41 AM To: CFList Subject: Dynamic Sorry if this has been covered before. I need a way of reading form fields on a dynamic basis through a loop. Ie. Form fields: Qty1 - Qty6, Main1 - Main6, Block1 - Block6 etc etc Rather than having 6 almost identical blocks of code to handle each set of fields I'd like to just run through a CFLOOP 6 times. The fields are created in this way on the previous template (see below) but I'm unsure of the syntax to actually read the fields on the subsequent (if it is possible). cfloop index="i" from="1" to="6" cfinput name="Qty#i#".etc Any ideas? Neil Robinson -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Adobe sues Macromedia????
For your reading pleasure: http://www.pcworld.com/pcwtoday/article/0,1510,18000,00.html and http://www.i-us.com/graphicallyspeaking/ Katie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Fusebox Question
I am new to the fusebox methodology, and hoping that someone might give me some structural pointers. It seems like there will be plenty of situations where query content will be required to provide content to a display page. In this scenario, is the preferred method to go back to the index.cfm page to include the query file, or is it ok to include the file directly from the display file? How about conditional includes? Should the following code be contained within the index.cfm or not? Should includes be contained within the index.cfm file only? CFIF Attributes.UserName IS "Dave" CFINCLUDE TEMPLATE="qry_Dave" CFELSE CFINCLUDE TEMPLATE="qry_NotDave" /CFIF TIA, Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Backing Up SQL
Hi all. I'm running MSDE (for now) and when I do my tape backups I'm getting a sharing violation on the SQL databases. I set these databases up as Access Projects and am able to go in and manually back them up, creating .dat files. Anyone have a solution that I can use to back these things up with some sort of SQL Query or other method? Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Adobe sues Macromedia????
I have been following this and it really seems to be a paper-thin lawsuit that is basically seeing if Adobe has a defendable patent or not. They are suing over "tearable tabs" where you can click on a tab and drag it off the dialog it is on etc. Or you can drag it to new dialogs to create your own custom dialogs. the only problem is this has been in the Unix world since before Photoshop existed just about. At least since the very very early 90's OpenStep has had this, and I know for certain certain parts of Visual Studio have this feature. I am not sure exactly what product Adobe is suing Macromedia for using this patened 'technology'. Patents like that are just not ground breaking software patents. However... they do pose a very bad threat to us. Amazon gets away with One-Click shopping. claiming they spend millions in research for this when Its kind of like a logical procession of a shopping site to store most of the clients data behind the scenes. Patents like this threaten the well being of software as a whole. Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Howell, Katie [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: OT: Adobe sues Macromedia For your reading pleasure: http://www.pcworld.com/pcwtoday/article/0,1510,18000,00.html and http://www.i-us.com/graphicallyspeaking/ Katie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Adobe sues Macromedia????
well it goes to show that companies like Microsoft "the start button controversy", Amazon.com "One click shopping", and now Adobe have control over the patents department because they don't understand what most of this stuff is. plus from what I understand Microsoft and every other operating system Developer has this functionality built into their operating systems. Chris Straight -Original Message- From: Howell, Katie [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 5:42 PM To: [EMAIL PROTECTED] Subject: OT: Adobe sues Macromedia For your reading pleasure: http://www.pcworld.com/pcwtoday/article/0,1510,18000,00.html and http://www.i-us.com/graphicallyspeaking/ Katie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Fusebox Question
Hey, my answers are indicated by below. Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/14 9:45 AM I am new to the fusebox methodology, and hoping that someone might give me some structural pointers. It seems like there will be plenty of situations where query content will be required to provide content to a display page. In this scenario, is the preferred method to go back to the index.cfm page to include the query file, or is it ok to include the file directly from the display file? Good Fusebox code will not include a fuse within a fuse, all code should be built to include directly from the fuse central (index.cfm usually). How about conditional includes? Should the following code be contained within the index.cfm or not? Should includes be contained within the index.cfm file only? Fusebox does not recognize conditional includes, you should build your conditions around the templates, not the index itself. The ONLY thing the index page should have is the necessary includes for a given action (and of course an app_globals file). CFIF Attributes.UserName IS "Dave" CFINCLUDE TEMPLATE="qry_Dave" CFELSE CFINCLUDE TEMPLATE="qry_NotDave" /CFIF TIA, Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Adobe sues Macromedia????
They are suing over "tearable tabs" where you can click on a tab and drag it off the dialog it is on etc. Or you can drag it to CFSTUDIO too!! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Automating Datasource Creation
Does any one have suggestions on creating datasources in an automoted process outside of using the CF Administrator ? Tony There are two rules for ultimate success in life: (1) Never tell everything you know. Keep on Truck'n -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: E-commerce Security, for the non programmer..
In-Reply-To: [EMAIL PROTECTED] but the CC no should not be going through email either. There's no problem if you use CFX_PGP for the email (I'm using it on a site that has no direct Cybercash-type CC verification). The page into which the customer types his/her CC is under SSL. Terry Riley Riley Varea Associates, London, UK -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ordering of structure based dynamic forms
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_000_01C00612.F0B20370 Content-Type: multipart/alternative; boundary="_=_NextPart_001_01C00612.F0B20370" --_=_NextPart_001_01C00612.F0B20370 Content-Type: text/plain; charset="iso-8859-1" Hi I'm currently building a set of forms based on a custom tag and an array of structures. Anyone know how I can order the loop thru the structure (using the collection and item properties of cfloop) and display the output in a predefined order other than the default of alphabetical order of keys. I'm thinking a method may be to create an array of each key, one array variable for the 'key value' and another one for the display order. Then I will have the problem of sorting all this! There must be a better way! Regards Rich --_=_NextPart_001_01C00612.F0B20370 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVFONT face=Verdana size=2SPAN class=830125816-14082000Hi/SPAN/FONT/DIV DIVFONT face=Verdana size=2SPAN class=830125816-14082000/SPAN/FONTnbsp;/DIV DIVFONT face=Verdana size=2SPAN class=830125816-14082000I'm currently building a set of forms based on a custom tag and an array of structures. Anyone know how I can order the loop thru the structure (using the collection and item properties of cfloop) and display the output in a predefined order other than the default of alphabetical order of keys./SPAN/FONT/DIV DIVFONT face=Verdana size=2SPAN class=830125816-14082000/SPAN/FONTnbsp;/DIV DIVFONT face=Verdana size=2SPAN class=830125816-14082000I'm thinking a method may be to create an array of each key, one array variable for the 'key value' and another one for the display order. Then I will have the problem of sorting all this! /SPAN/FONT/DIV DIVFONT face=Verdana size=2SPAN class=830125816-14082000/SPAN/FONTnbsp;/DIV DIVFONT face=Verdana size=2SPAN class=830125816-14082000There must be a better way!/SPAN/FONT/DIV DIVFONT face=Verdana size=2/FONTnbsp;/DIV DIVFONT face=Verdana size=2/FONTnbsp;/DIV DIVSPAN class=830125816-14082000FONT face=Verdana size=2Regards/FONT/SPAN/DIV DIVSPAN class=830125816-14082000FONT face=Verdana size=2/FONT/SPANnbsp;/DIV DIVSPAN class=830125816-14082000FONT face=Verdana size=2Rich/FONT/SPAN/DIV DIVnbsp;/DIV/BODY/HTML --_=_NextPart_001_01C00612.F0B20370-- --_=_NextPart_000_01C00612.F0B20370 Content-Type: application/octet-stream; name="Richard Moger (E-mail).vcf" Content-Disposition: attachment; filename="Richard Moger (E-mail).vcf" BEGIN:VCARD VERSION:2.1 N:Moger;Richard FN:Richard Moger (E-mail) ORG:James Villa Holidays Ltd TITLE:IT Manager TEL;WORK;VOICE:+44 (01732) 840846 TEL;CELL;VOICE:+44 (0777) 953 8192 TEL;WORK;FAX:+44 (01732) 872093 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Regents Court=0D=0ALondon Road;Addington;Kent;ME19 5PL;United Kingdom LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Regents Court=0D=0ALondon Road=0D=0AAddington, Kent ME19 5PL=0D=0AUnited Kin= gdom EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:2707T003119Z END:VCARD --_=_NextPart_000_01C00612.F0B20370-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Adobe sues Macromedia????
Exactly... It is such a lame patent adobe is trying to win with. specifically they are referring to the way their tabs work in photoshop if anyone is interested in seeing how many programs you can find that breach the patent. Okay you have two dialogs one is the color dialog and maybe the other is the history dialog each has a few tabs. You can drag that particular 'tab' over to another dialog and that tab is now on that dialog. I just did that with CF Studio and I *know* I have done that in Visual Studio. Point is.. its lame and ive seen the *exact* thing nearly in stuff that I know was around before Photoshop had it, so I really hope Macromedia does not have a hard time convincing the judge that there is plenty of prior art and existing art... From what I understand however, patents are not like trademarks where you have to defend them religiously you can just pick and choose when you defend your patent. I am not super clear on this one so dont take my advice :) This is just what I have come to understand. And to tie it into CF, CFstudio does almost the exact same thing except it lacks a 'container' type widget for the tabs. Ugh well anywhu... Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 12:59 PM To: [EMAIL PROTECTED] Subject: Re: Adobe sues Macromedia They are suing over "tearable tabs" where you can click on a tab and drag it off the dialog it is on etc. Or you can drag it to CFSTUDIO too!! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Automating Datasource Creation
We are going to be releasing our automation for the creation of ODBC soon. John Cesta http://www.cybersmarts.net - ColdFusion ASP and ActiveState PERL Hosting www.serverautomationtools.com -Original Message- From: Tony Reynolds [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:10 PM To: [EMAIL PROTECTED] Subject: Automating Datasource Creation Does any one have suggestions on creating datasources in an automoted process outside of using the CF Administrator ? Tony There are two rules for ultimate success in life: (1) Never tell everything you know. Keep on Truck'n -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Whoever asked about stockgrabber
I am looking at the tag now. I found what the problem is with it cutting off the last character. This tag is really messed up though. So if you want a quick fix just email me off list. I will go through the tag a recode the entire thing soon. Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Automating Datasource Creation
CF_Datasource at http://www.cfdev.com/ -Original Message- From: Tony Reynolds [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:10 PM To: [EMAIL PROTECTED] Subject: Automating Datasource Creation Does any one have suggestions on creating datasources in an automoted process outside of using the CF Administrator ? Tony There are two rules for ultimate success in life: (1) Never tell everything you know. Keep on Truck'n -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFXhosting.com?
Here's all I know about them, They are a division on Express Technologies. Express Technologies also owns halfpricehosting.com, I am not satisified with halfpricehosting.com, trouble with mail servers, long hold times for support, and overall slow serving from their servers. Now with that said, I do not know if the same holds true for CFXHosting. -- Original Message -- From: "stas" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 14 Aug 2000 10:03:44 -0400 Can anybody provide comments about these guys? Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dynamic GIGs/JPEGs
What are my options for the Subject? That is, displaying a set sequence of GIFs/JPEGs? best, paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFRegistry and SQL Server DSN
I am creating a CF Administrator-like application that allows users to add datasources w/o getting into the CF Administrator. The problem that I'm having is encrypting the password correctly. I'm using the CFRegistry tag to create the entries on the server and I can get the datasources to work, unless they need a password. Can anyone help w/ the encryption of a ColdFusion login password? Thanks in advance! Greg Albert -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Working with a string...
You could also use Left CFSET strEmail = "[EMAIL PROTECTED]" CFSET Index = Find("@", strEmail) CFSET strEmailPart = Left(strEmail, Index) The reason taht works is because you know where your string starts, if you were searching for emails as a sub string, of a larger string a regular expression would most likely be more suited to your needs. Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Andrew [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:03 PM To: [EMAIL PROTECTED] Subject: Re: Working with a string... Gary: I would do a Find on the string for the @ and then a Mid function that starts at 1 and ends at the position returned from the find function. Andrew Hewitt Web Application Developer webworld studios inc. - Original Message - From: "Gary McNeel, Jr." [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 7:06 PM Subject: Working with a string... I have an email address sting that I need to manipulate. I need to just get the first part before the @ symbol and discard the rest (although knowing how to grab it might be useful too). Is the only way to do a regular expression? Ex. [EMAIL PROTECTED] would become gmcneel (maybe in a variable). TIA Gary McNeel, Jr. Project Manager - DAC-Net, Research Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 http://dacnet.rice.edu/DAC-Net/Staff/Gary/ "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Dynamic
I need a way of reading form fields on a dynamic basis through a loop. Ie. Form fields: Qty1 - Qty6, Main1 - Main6, Block1 - Block6 etc etc Rather than having 6 almost identical blocks of code to handle each set of fields I'd like to just run through a CFLOOP 6 times. The fields are created in this way on the previous template (see below) but I'm unsure of the syntax to actually read the fields on the subsequent (if it is possible). cfloop index="i" from="1" to="6" cfinput name="Qty#i#".etc If you're gonna use loops, use 2 loops cfloop index="j" list="Qty,Main,Block" cfloop index="i" from=1 to=6 cfinput name="#j##i#" /cfloop /cfloop Seeing as the fields are dynamic, you can read them using Evaluate(); cfloop index="j" list="Qty,Main,Block" cfloop index="i" from=1 to=6 cfif Evaluate("#j##i#") is "" This field is empty /cfif /cfloop /cfloop Or to set this field to be something; cfset "#j##i#"=myValue Variable name flexibility is a wonderful thing Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Announcing: CF_OUTPUTPG (thank you everyone)
Now, who ever claimed CF was sane G I always have to go back and correct myself to start my loops at one with certain things such as list indexes etc. *mutters* I think they did this as a trade-off to make it more sensible to less traditional programmer's It just messes me up but I guess ill get over it ;) I dont think doing very much C is healthy for someone anyhow. Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] !-- // Why can't CF be zero based like any sane language? !-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Version 4.5.1 memory leak fixed?
Depends if you are talking about the Server or Studio. When I installed 4.5.1 Studio on Windows 98, it crashed all of the time. Recently I wiped out my drive and installed Win2K Professional, and Studio now runs like a clock. That is probably because Win2K is very good at keeping memory leaks from crashing the OS. If you are using Windows98 on your workstation and you crash a lot, you could do what I did and pay Bill Gates to get Win 2K. It runs great and is very hard to crash. As for the CF 4.5.1 Server, it has given us a lot of problems running it on NT 4.0 SP6.What happens is the NT performance monitor spikes up to 100% usage. And our code is clean. We are not even doing really high zoot CF stuff here yet. At a CFUG conference I just went to in DC they said that CFHTTP can cause memory spikes like this, but we aren't even using that tag on this server (it is a development server). I have heard other CF admins complain about the memory spike too. Allaire JUST released a patch a couple of days ago, and we should have that installed here soon. I will let you know how it works. John McKown, VP of Business Services Delaware.Net, Inc. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 12, 2000 2:29 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Version 4.5.1 memory leak fixed? html font size=3On the Allaire support forum I think everyone reached a consensus that Windows-NT can handle the resource memory leak better. Cold Fusion Studio 4.5 crashes Windows-98 very quickly.br br At 02:20 PM 8/12/00 -0400, Ken Wilson wrote:br blockquote type=cite citeWorks great for me.br br Ken Wilsonbr br br br - Original Message -br From: PC lt;[EMAIL PROTECTED]gt;br To: lt;[EMAIL PROTECTED]gt;; lt;[EMAIL PROTECTED]gt;br Sent: Saturday, August 12, 2000 1:35 PMbr Subject: Version 4.5.1 memory leak fixed?br br br gt; Is this a stable platform yet?br gt;br gt; -- br br gt; Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion .com//abr gt; To Unsubscribe visitbr a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bod y=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=li stsamp;body=lists/cf_talk/a orbr send a message to [EMAIL PROTECTED] with 'unsubscribe' inbr the body.br br -- br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion .com//abr To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bod y=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=li stsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3--- ---br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
session.basket URL
Im just starting to develop a E-commerce Shopping basket and i notice that when i goto add product to my session.basket the persons CFID, and CFToken are displayed in the URL. i.e. /outputsession.cfm?CFID=34CFTOKEN=56471755 Is this normal? Is this a security risk? BTW I am adding the product with a form. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. This behavior can be suppressed by adding the attribute ADDTOKEN="No" to the CFLOCATION tag. This is an excerpt from http://www.houseoffusion.com/cfdocs1/Developing_Web_Applications_with_ColdFu sion/05_Using_the_Application_Framework/dwa05_07.htm Hope this helps, Natalie -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 3:19 PM To: [EMAIL PROTECTED] Subject: session.basket URL Im just starting to develop a E-commerce Shopping basket and i notice that when i goto add product to my session.basket the persons CFID, and CFToken are displayed in the URL. i.e. /outputsession.cfm?CFID=34CFTOKEN=56471755 Is this normal? Is this a security risk? BTW I am adding the product with a form. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
Ahh! Thank you! I never even thought to relate this to the CFLOCATION tag i am using. At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. This behavior can be suppressed by adding the attribute ADDTOKEN="No" to the CFLOCATION tag. This is an excerpt from http://www.houseoffusion.com/cfdocs1/Developing_Web_Applications_with_ColdFu sion/05_Using_the_Application_Framework/dwa05_07.htm Hope this helps, Natalie -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 3:19 PM To: [EMAIL PROTECTED] Subject: session.basket URL Im just starting to develop a E-commerce Shopping basket and i notice that when i goto add product to my session.basket the persons CFID, and CFToken are displayed in the URL. i.e. /outputsession.cfm?CFID=34CFTOKEN=56471755 Is this normal? Is this a security risk? BTW I am adding the product with a form. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
help with REReplace
This is a multi-part message in MIME format. --=_NextPart_000_000D_01C00609.01E91A20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I need to check for single instances of a CR/LF only and replace them = with null strings. Am I right with this bit of code? cfset var =3D REReplace(inputvar,"\r?","","ALL") When I run the application, the server seems to hang. Is this expected = behaviour? Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax --=_NextPart_000_000D_01C00609.01E91A20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR/HEAD BODY bgColor=3D#ff DIVFONT size=3D2Hi all,/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2I need to check for single instances of a CR/LF only = and=20 replace them with null strings.nbsp; Am I right with this bit of=20 code?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2lt;cfset var =3D=20 REReplace(inputvar,"\r?","","ALL")gt;/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2When I run the application, the server seems to = hang.nbsp; Is=20 this expected behaviour?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Thanks,/FONT/DIV DIVFONT size=3D2Jamie/FONT/DIV DIVFONT size=3D2BR--BRJamie = KeaneBRProgrammerBRSolutionMasters,=20 Inc.BR9111 Monroe Rd., Suite 100BRCharlotte, NCnbsp; 28270BRA=20 href=3D"http://www.solutionmasters.com"www.solutionmasters.com/ABR70= 4.563.5559=20 x 228nbsp; VoiceBR704.849.9291nbsp; Fax/FONT/DIV/BODY/HTML --=_NextPart_000_000D_01C00609.01E91A20-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
When the client has cookies disabled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Fusebox Question
Thanks for the response. How are situations handled where you have a query within a loop handled within Fusebox? For example: CFLOOP INDEX="CountLoop" FROM=1 TO=10 CFQUERY . SELECT * FROM Table WHERE ID = CountLoop /CFQUERY CFOUTPUT You are at record #ID#. /CFOUTPUT /CFLOOP I don't see an easy way to abstract this functionality back to only CFINCLUDEs at the index.cfm. Thanks, Kevin [EMAIL PROTECTED] 08/14/00 09:54AM Hey, my answers are indicated by below. Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/14 9:45 AM I am new to the fusebox methodology, and hoping that someone might give me some structural pointers. It seems like there will be plenty of situations where query content will be required to provide content to a display page. In this scenario, is the preferred method to go back to the index.cfm page to include the query file, or is it ok to include the file directly from the display file? Good Fusebox code will not include a fuse within a fuse, all code should be built to include directly from the fuse central (index.cfm usually). How about conditional includes? Should the following code be contained within the index.cfm or not? Should includes be contained within the index.cfm file only? Fusebox does not recognize conditional includes, you should build your conditions around the templates, not the index itself. The ONLY thing the index page should have is the necessary includes for a given action (and of course an app_globals file). CFIF Attributes.UserName IS "Dave" CFINCLUDE TEMPLATE="qry_Dave" CFELSE CFINCLUDE TEMPLATE="qry_NotDave" /CFIF TIA, Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: help with REReplace
Do you mean if you have adjacent cr/lf (say 3) you want to keep 3 but if you have 1 you want to strip it? If so I don't think what you have will work because it will not distinguish adjacent occurences. Also since you have the ? you will be replacing nothing or \r with nothing which will probably hang the server. - Original Message - From: "Jamie Keane" [EMAIL PROTECTED] To: "CFTalk" [EMAIL PROTECTED] Sent: Monday, August 14, 2000 2:02 PM Subject: help with REReplace This is a multi-part message in MIME format. --=_NextPart_000_000D_01C00609.01E91A20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I need to check for single instances of a CR/LF only and replace them = with null strings. Am I right with this bit of code? cfset var =3D REReplace(inputvar,"\r?","","ALL") When I run the application, the server seems to hang. Is this expected = behaviour? Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax --=_NextPart_000_000D_01C00609.01E91A20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR/HEAD BODY bgColor=3D#ff DIVFONT size=3D2Hi all,/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2I need to check for single instances of a CR/LF only = and=20 replace them with null strings.nbsp; Am I right with this bit of=20 code?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2lt;cfset var =3D=20 REReplace(inputvar,"\r?","","ALL")gt;/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2When I run the application, the server seems to = hang.nbsp; Is=20 this expected behaviour?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Thanks,/FONT/DIV DIVFONT size=3D2Jamie/FONT/DIV DIVFONT size=3D2BR--BRJamie = KeaneBRProgrammerBRSolutionMasters,=20 Inc.BR9111 Monroe Rd., Suite 100BRCharlotte, NCnbsp; 28270BRA=20 href=3D"http://www.solutionmasters.com"www.solutionmasters.com/ABR70= 4.563.5559=20 x 228nbsp; VoiceBR704.849.9291nbsp; Fax/FONT/DIV/BODY/HTML --=_NextPart_000_000D_01C00609.01E91A20-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: help with REReplace
cfset var = REReplace(inputvar,"\r?","","ALL") This will replace all characters with an empty string, one character at a time. Somehow, I imagine that this is not what you want. :) You really don't even need a regex for this; it's just a simple search and replace: CFSET var=Replace(inputvar,Chr(13) Chr(10),"","ALL") However, this will only handle input from browsers that (correctly) wrap lines with both Cr and Lf. To handle both: CFSET var=ReplaceList(inputvar,"#Chr(13)#,#Chr(10)#",",","ALL") -Rick -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
I believe, developer has to manually append it for situations like this. See below: "Developers who choose to maintain client state without cookies must ensure that every request carries CFID and CFTOKEN. To maintain client state without cookies, set the SETCLIENTCOOKIES attribute of the CFAPPLICATION tag to No. Then, the developer must maintain client state in URLs. by passing the client ID (CFID)and the client security token (CFTOKEN) between pages, either in hidden form fields or appended to URLs. You accomplish this using the variable Client.URLTOKEN or Session.URLTOKEN." Natalie -Original Message- From: Brad Pauly [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 4:15 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL When the client has cookies disabled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Automating Datasource Creation
CFX_ODBC tag by Nadeem Hasan can be found at: http://members.home.com/hoffmanj/CFXODBC.zip "The CFX_ODBCUTIL tag allows you to access the ODBC functionality on the server machine. You can get the list of ODBC drivers, datasources as well as create, modify or remove a datasource. You need to know and pass the driver specific attributes to create or modify the database. Note that the operations can only be performed on system DSNs. The common attributes are listed below." Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: LISTS [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:34 PM To: [EMAIL PROTECTED] Subject: RE: Automating Datasource Creation We are going to be releasing our automation for the creation of ODBC soon. John Cesta http://www.cybersmarts.net - ColdFusion ASP and ActiveState PERL Hosting www.serverautomationtools.com -Original Message- From: Tony Reynolds [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:10 PM To: [EMAIL PROTECTED] Subject: Automating Datasource Creation Does any one have suggestions on creating datasources in an automoted process outside of using the CF Administrator ? Tony There are two rules for ultimate success in life: (1) Never tell everything you know. Keep on Truck'n -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Fusebox Question
I'm not sure if I understand you. But here it goes. This looks like a regular programming construct that could be handled within any CF Block. Just use a query or action file (qry_file or act_file) as appropriate. Remember that templates can be dependent on other templates to do actions, this is a virtual necessity of programming. As long as you use CFINCLUDE, variables will pass from one template to another without a problem. All a CFINCLUDE does essentially is copy and paste the code from it's source into the current page, so variables will carry. Hope this helped, if not, lemme know! Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/14 1:19 PM Thanks for the response. How are situations handled where you have a query within a loop handled within Fusebox? For example: CFLOOP INDEX="CountLoop" FROM=1 TO=10 CFQUERY . SELECT * FROM Table WHERE ID = CountLoop /CFQUERY CFOUTPUT You are at record #ID#. /CFOUTPUT /CFLOOP I don't see an easy way to abstract this functionality back to only CFINCLUDEs at the index.cfm. Thanks, Kevin [EMAIL PROTECTED] 08/14/00 09:54AM Hey, my answers are indicated by below. Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/14 9:45 AM I am new to the fusebox methodology, and hoping that someone might give me some structural pointers. It seems like there will be plenty of situations where query content will be required to provide content to a display page. In this scenario, is the preferred method to go back to the index.cfm page to include the query file, or is it ok to include the file directly from the display file? Good Fusebox code will not include a fuse within a fuse, all code should be built to include directly from the fuse central (index.cfm usually). How about conditional includes? Should the following code be contained within the index.cfm or not? Should includes be contained within the index.cfm file only? Fusebox does not recognize conditional includes, you should build your conditions around the templates, not the index itself. The ONLY thing the index page should have is the necessary includes for a given action (and of course an app_globals file). CFIF Attributes.UserName IS "Dave" CFINCLUDE TEMPLATE="qry_Dave" CFELSE CFINCLUDE TEMPLATE="qry_NotDave" /CFIF TIA, Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
That is correct. Thanks for the clarification. -Original Message- From: Sytov, Natalie L. [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:24 PM To: '[EMAIL PROTECTED]' Subject: RE: session.basket URL I believe, developer has to manually append it for situations like this. See below: "Developers who choose to maintain client state without cookies must ensure that every request carries CFID and CFTOKEN. To maintain client state without cookies, set the SETCLIENTCOOKIES attribute of the CFAPPLICATION tag to No. Then, the developer must maintain client state in URLs. by passing the client ID (CFID)and the client security token (CFTOKEN) between pages, either in hidden form fields or appended to URLs. You accomplish this using the variable Client.URLTOKEN or Session.URLTOKEN." Natalie -Original Message- From: Brad Pauly [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 4:15 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL When the client has cookies disabled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: help with REReplace
The problem I see with the non-regex solutions is that they will replace all CR/LFs, whereas I only want to replace single single instances, while leaving double instances untouched. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Rick Osborne [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, August 14, 2000 4:23 PM Subject: RE: help with REReplace cfset var = REReplace(inputvar,"\r?","","ALL") This will replace all characters with an empty string, one character at a time. Somehow, I imagine that this is not what you want. :) You really don't even need a regex for this; it's just a simple search and replace: CFSET var=Replace(inputvar,Chr(13) Chr(10),"","ALL") However, this will only handle input from browsers that (correctly) wrap lines with both Cr and Lf. To handle both: CFSET var=ReplaceList(inputvar,"#Chr(13)#,#Chr(10)#",",","ALL") -Rick --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: help with REReplace
Well, the idea behind your regex way would have done the exact same thing. The solution you want is more along the lines of this CFSET crlf = Chr(13) Chr(10) CFSET var = REReplace(inputvar, "([^#crlf#])#crlf#([^#crlf#])", "\1\2", "ALL") I cannont remember right now if \r is correct, if \r does work as a newline value in RE's, then: CFSET var = REReplace(inputvar, "([^\r])\r([^\r])", "\1\2", "ALL") I do not have time to look up the \r thing, but this should find and squash single newlines. Justin Kidman -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:45 PM To: [EMAIL PROTECTED] Subject: Re: help with REReplace The problem I see with the non-regex solutions is that they will replace all CR/LFs, whereas I only want to replace single single instances, while leaving double instances untouched. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Rick Osborne [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, August 14, 2000 4:23 PM Subject: RE: help with REReplace cfset var = REReplace(inputvar,"\r?","","ALL") This will replace all characters with an empty string, one character at a time. Somehow, I imagine that this is not what you want. :) You really don't even need a regex for this; it's just a simple search and replace: CFSET var=Replace(inputvar,Chr(13) Chr(10),"","ALL") However, this will only handle input from browsers that (correctly) wrap lines with both Cr and Lf. To handle both: CFSET var=ReplaceList(inputvar,"#Chr(13)#,#Chr(10)#",",","ALL") -Rick --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
Nope. I have "Accept all cookies" checked in NetScrape 4.51. best, paul At 01:14 PM 8/14/00 -0700, you wrote: When the client has cookies disabled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Version 4.5.1 memory leak fixed?
Thanks for all this great info! It would be very useful to hear back from you when you have any new news on this from your experiences/patches/etc. I am most concerned about Server at this point... Thanks again .. Depends if you are talking about the Server or Studio. When I installed 4.5.1 Studio on Windows 98, it crashed all of the time. Recently I wiped out my drive and installed Win2K Professional, and Studio now runs like a clock. That is probably because Win2K is very good at keeping memory leaks from crashing the OS. If you are using Windows98 on your workstation and you crash a lot, you could do what I did and pay Bill Gates to get Win 2K. It runs great and is very hard to crash. As for the CF 4.5.1 Server, it has given us a lot of problems running it on NT 4.0 SP6.What happens is the NT performance monitor spikes up to 100% usage. And our code is clean. We are not even doing really high zoot CF stuff here yet. At a CFUG conference I just went to in DC they said that CFHTTP can cause memory spikes like this, but we aren't even using that tag on this server (it is a development server). I have heard other CF admins complain about the memory spike too. Allaire JUST released a patch a couple of days ago, and we should have that installed here soon. I will let you know how it works. John McKown, VP of Business Services Delaware.Net, Inc. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 12, 2000 2:29 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Version 4.5.1 memory leak fixed? html font size=3On the Allaire support forum I think everyone reached a consensus that Windows-NT can handle the resource memory leak better. Cold Fusion Studio 4.5 crashes Windows-98 very quickly.br br At 02:20 PM 8/12/00 -0400, Ken Wilson wrote:br blockquote type=cite citeWorks great for me.br br Ken Wilsonbr br br br - Original Message -br From: PC lt;[EMAIL PROTECTED]gt;br To: lt;[EMAIL PROTECTED]gt;; lt;[EMAIL PROTECTED]gt;br Sent: Saturday, August 12, 2000 1:35 PMbr Subject: Version 4.5.1 memory leak fixed?br br br gt; Is this a stable platform yet?br gt;br gt; -- br br gt; Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion .com//abr gt; To Unsubscribe visitbr a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bod y=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=li stsamp;body=lists/cf_talk/a orbr send a message to [EMAIL PROTECTED] with 'unsubscribe' inbr the body.br br -- br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion .com//abr To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bod y=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=li stsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3--- ---br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
Actually Paul it's when you don't specify "addtoken="no"" If you just have cflocation url="foo.htm" you'll get the cfid and cftoken in the URL. If you cflocation url="foo.htm" addtoken="no" You won't. --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 2:10 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL Nope. I have "Accept all cookies" checked in NetScrape 4.51. best, paul At 01:14 PM 8/14/00 -0700, you wrote: When the client has cookies disabled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL: Using LIKE with and without a wildcard
As a rule, will their be a performance penalty using LIKE instead of = in SQL queries if there's NOT a wildcard in the expression? That is, if my users have the option of using wildcards in their searches (on multiple fields), is it better to detect the presence/absence of a wildcard and adjust the operator accordingly? I'd hope that most SQL engines would do this on their own, treating the LIKE operator the same as = whenever no wildcard is present. Thanks, Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using LIKE with and without a wildcard
Well there would be some sort of minimal performance hit somewhere detecting if there are wild cards. Of course if there are no wild cards they will not be evaluated but it still has to check for their prescence, however if you are just testing for equality it is going to be a quicker operation just given that there is less overhead assocaited with it Either on the CF or SQL side, however since most good SQL servers will optimize this it should not be much of an issue. But it will still be somewhat less expensive to test for equality in terms of processor time. The SQL server *may* optimize for it, but there is no real way to know without testing it out. Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 6:16 PM To: [EMAIL PROTECTED] Subject: SQL: Using LIKE with and without a wildcard As a rule, will their be a performance penalty using LIKE instead of = in SQL queries if there's NOT a wildcard in the expression? That is, if my users have the option of using wildcards in their searches (on multiple fields), is it better to detect the presence/absence of a wildcard and adjust the operator accordingly? I'd hope that most SQL engines would do this on their own, treating the LIKE operator the same as = whenever no wildcard is present. Thanks, Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Copying a Directory and it's files
CFFILE ACTION="Copy" SOURCE="d:\apps\cgi-bin\*.*" DESTINATION="d:\www\#domain#\cgi-bin\" I'm trying to copy a directory and it's contents to another directory... any ideas on how I can achieve this? I've tried many things with cffile and cfexecute... any help? jake -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Administrator Mapping and Apache Alias
html font size=3What exactly does CF Administrator mapping do?br Does it map URLs as they come in, in other words it affects ALL http requests even to .html files?br Or does it map URLs that are to .cfm files?br Or does it only affect CFINCLUDE?br br How does it interact with Apache directory quot;Aliasquot; mapping?br br I want to map certain directories for images and cfm files. I also want a different set of mappings for my CF library of includable quot;functionsquot; so I can use lt;cfinclude template=quot;/cflib/mymodule.cfmquot;gt; although that file is NOT located under my document root.br br /fontbr br -font size=3--br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help with SQL
I have a date and time field in the form of 8/14/00 in an Access database. I want to be able to select out the distinct months in all the fields. It seems that I can't do that. Do I have to redo the database and separate the month? Or do I have to process the query with some kind of CF code? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Administrator Mapping and Apache Alias
All mappings do is create an alias for a phsyical directory... like say if you wanted an absolute reference for CFINCLUDE you could make a mapping named Foo which points to /usr/home/cftagman/cftags And say you had a lot of templates in /usr/home/cftagman/cftags then you could use CFINCLUDE Template="#foo#/SomeTemplate.cfm" and Sometemplate.cfm would of course be in the D:\CFStuff directory. Thats all :) Its purely CF driven and referenced with CF basically its a nice way to map out the absolute location for something. of course NT machines start with drive letters ;) So I would say that a that the Apache alias takes higher precedence than the CF Mapping. Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 6:38 PM To: [EMAIL PROTECTED] Subject: CF Administrator Mapping and Apache Alias html font size=3What exactly does CF Administrator mapping do?br Does it map URLs as they come in, in other words it affects ALL http requests even to .html files?br Or does it map URLs that are to .cfm files?br Or does it only affect CFINCLUDE?br br How does it interact with Apache directory quot;Aliasquot; mapping?br br I want to map certain directories for images and cfm files. I also want a different set of mappings for my CF library of includable quot;functionsquot; so I can use lt;cfinclude template=quot;/cflib/mymodule.cfmquot;gt; although that file is NOT located under my document root.br br /fontbr br -font size=3- -br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
Well, there's no CFLOCATION. best, paul At 03:07 PM 8/14/00 -0700, you wrote: Actually Paul it's when you don't specify "addtoken="no"" If you just have cflocation url="foo.htm" you'll get the cfid and cftoken in the URL. If you cflocation url="foo.htm" addtoken="no" You won't. --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 2:10 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL Nope. I have "Accept all cookies" checked in NetScrape 4.51. best, paul At 01:14 PM 8/14/00 -0700, you wrote: When the client has cookies disabled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help with SQL
You use the SQL DatePart function select DatePart(mm, columnname) as month from foo --K -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Help with SQL I have a date and time field in the form of 8/14/00 in an Access database. I want to be able to select out the distinct months in all the fields. It seems that I can't do that. Do I have to redo the database and separate the month? Or do I have to process the query with some kind of CF code? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with SQL
In SQL server there is a month function, i.e. month(getdate()) or month(mydate). Access may have the same function. If you are going to be ordering them, remember to take the year into account if it spans the end of a year. David sebastian palmigiani wrote: I have a date and time field in the form of 8/14/00 in an Access database. I want to be able to select out the distinct months in all the fields. It seems that I can't do that. Do I have to redo the database and separate the month? Or do I have to process the query with some kind of CF code? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session.basket URL
Well then can we see the offending code? Both the posting page and the processing pages please. --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 3:57 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL Well, there's no CFLOCATION. best, paul At 03:07 PM 8/14/00 -0700, you wrote: Actually Paul it's when you don't specify "addtoken="no"" If you just have cflocation url="foo.htm" you'll get the cfid and cftoken in the URL. If you cflocation url="foo.htm" addtoken="no" You won't. --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 2:10 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL Nope. I have "Accept all cookies" checked in NetScrape 4.51. best, paul At 01:14 PM 8/14/00 -0700, you wrote: When the client has cookies disabled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: session.basket URL What causes appending when there's no CFLOCATION? best, paul At 03:32 PM 8/14/00 -0400, you wrote: Client variables with CFLOCATION behavior: When using CFLOCATION to redirect to a path that contains .DBM or .CFM, the Client.URLToken is automatically appended to the URL. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Browser / desktop resolution
Hi All, Is there a way from CF to work out what resolution a users browser is set to? Thanks, Lucas. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Lucas Sherwood Technical Sales Consultant FirmwareDesign [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Administrator Mapping and Apache Alias
html font size=3So you are saying it does not affect URL requests at all, right?br It only affects CFINCLUDE?br br Your example can't be right. You are using the mapping as a variable quot;#foo#/SomeTemplate.cfmquot;br If that were right, I wouldn't need mapping at all. I would just set a variable.br It must be more like this:br br MAP /cflib = /usr/home/coldfusion/library/peterbr br lt;cfinclude template=quot;/cflib/myfile.cfmquot;gt;br br br At 06:56 PM 8/14/00 -0400, Jeremy Allen wrote:br blockquote type=cite citeAll mappings do is create an alias for a phsyical directory...br br like say if you wanted an absolute reference for CFINCLUDEbr br you could make a mapping named Foo which points to /usr/home/cftagman/cftagsbr br And say you had a lot of templates in /usr/home/cftagman/cftags then youbr could usebr br lt;CFINCLUDE Template=quot;#foo#/SomeTemplate.cfmquot;gt; and Sometemplate.cfmbr would of course be in the D:\CFStuff directory.br br Thats all :)br br Its purely CF driven and referenced with CF basically its a nicebr way to map out the absolute location for something.nbsp; of coursebr NT machines start with drive letters ;) So I would say that abr that the Apache alias takes higher precedence than the CFbr Mapping.br br Jeremy Allenbr [EMAIL PROTECTED]br [Insert cool title here]br br br -Original Message-br From: Peter Theobald [a href="mailto:[EMAIL PROTECTED]" eudora="autourl"mailto:[EMAIL PROTECTED]/a]br Sent: Monday, August 14, 2000 6:38 PMbr To: [EMAIL PROTECTED]br Subject: CF Administrator Mapping and Apache Aliasbr br br What exactly does CF Administrator mapping do?br Does it map URLs as they come in, in other words it affects ALL http requests even to .html files?br Or does it map URLs that are to .cfm files?br Or does it only affect CFINCLUDE?br br How does it interact with Apache directory quot;Aliasquot; mapping?br br I want to map certain directories for images and cfm files. I also want a different set of mappings for my CF library of includable quot;functionsquot; so I can use lt;cfinclude template=quot;/cflib/mymodule.cfmquot;gt; although that file is NOT located under my document root.br br br br -- -br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br br br --br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//abr To Unsubscribe visitbr a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a orbr send a message to [EMAIL PROTECTED] with 'unsubscribe' inbr the body.br br --br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//abr To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3--br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Browser / desktop resolution
What have you tried?? Ever looked into JavaScript?? I am going to be frank and apologize to everyone for this. I have been watching this list for 2 weeks and the mass of amounts of email being sent on a daily basis is annoying. There are some really good subjects in some of them but reading through them all is difficult to say the least. Maybe I will just look through the archives if I need anything. Now, comes my *whining*. This is a developers email list, right? more or less... if not then I am sorry but in mailing lists where development and programming goes, people just don't ask how and what can and where and so forth without trying to find what they need, playing with the code and then posting. But also posting what they tried and what they got and what they really want to do. I find though, on this list, messages such as Lucas' (sorry, you just happen to be the one that broke the camel's back). You ask how, but you don't state what you have tried, what you think is supposed to happen, what you think you should try, so forth... no info given but you need this/that personally Lucas, I would go look to some JavaScript sites and books, I am 99.9% sure that I saw one (shoot I probably have it in my personally repository) out there and where there is one there are more. Again, forgive me... most of the messages posted here are by very serious and very good developers and I applaud them. But they got that way by putting a lot of effort into their work and asked questions after trying stuff out (usual they figured it out on their own though).. I will be un-subscribing tomorrow, so if you wish to wait on hazing me without hurting my feelings (which you couldn't anyway) I would wait till tomorrow Any personal hate mails can be sent to me directly, which of course I will probably delete anyway. To all the serious learners and programmers, excellent job.. Terry Bader Web Developer EDO Corp - Combat Systems (757) 424-1004 ext 361 [EMAIL PROTECTED] [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Lucas Sherwood [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:10 PM To: [EMAIL PROTECTED]; Cfaussie Subject: Browser / desktop resolution Hi All, Is there a way from CF to work out what resolution a users browser is set to? Thanks, Lucas. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Lucas Sherwood Technical Sales Consultant FirmwareDesign [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Administrator Mapping and Apache Alias
Ugh my apologies I was thinking of something else thats what I get for replying while im trying to code ;) They work just like document mappings in apache except, they only refer to application pages. You should only need it for CF with CGi or absolute references with the CFINCLUDE tag ... Apache does document type mapping which lets apache know that a .cfm is a CF File and that it should be procesed by the CF Server. So say you make your mapping /Foo/ which points to D:\CFStuff now from CFincludes you should be able to do CFINCLUDE TEMPLATE="/Foo/SomeFileInMyStuff.html" And if you dont want it for CFInclude I would just use document type mappings unless you need to do something strange with CGI and CF. Sorry for the inconsistency ;) Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:10 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: CF Administrator Mapping and Apache Alias html font size=3So you are saying it does not affect URL requests at all, right?br It only affects CFINCLUDE?br br Your example can't be right. You are using the mapping as a variable quot;#foo#/SomeTemplate.cfmquot;br If that were right, I wouldn't need mapping at all. I would just set a variable.br It must be more like this:br br MAP /cflib = /usr/home/coldfusion/library/peterbr br lt;cfinclude template=quot;/cflib/myfile.cfmquot;gt;br br br At 06:56 PM 8/14/00 -0400, Jeremy Allen wrote:br blockquote type=cite citeAll mappings do is create an alias for a phsyical directory...br br like say if you wanted an absolute reference for CFINCLUDEbr br you could make a mapping named Foo which points to /usr/home/cftagman/cftagsbr br And say you had a lot of templates in /usr/home/cftagman/cftags then youbr could usebr br lt;CFINCLUDE Template=quot;#foo#/SomeTemplate.cfmquot;gt; and Sometemplate.cfmbr would of course be in the D:\CFStuff directory.br br Thats all :)br br Its purely CF driven and referenced with CF basically its a nicebr way to map out the absolute location for something.nbsp; of coursebr NT machines start with drive letters ;) So I would say that abr that the Apache alias takes higher precedence than the CFbr Mapping.br br Jeremy Allenbr [EMAIL PROTECTED]br [Insert cool title here]br br br -Original Message-br From: Peter Theobald [a href="mailto:[EMAIL PROTECTED]" eudora="autourl"mailto:[EMAIL PROTECTED]/a]br Sent: Monday, August 14, 2000 6:38 PMbr To: [EMAIL PROTECTED]br Subject: CF Administrator Mapping and Apache Aliasbr br br What exactly does CF Administrator mapping do?br Does it map URLs as they come in, in other words it affects ALL http requests even to .html files?br Or does it map URLs that are to .cfm files?br Or does it only affect CFINCLUDE?br br How does it interact with Apache directory quot;Aliasquot; mapping?br br I want to map certain directories for images and cfm files. I also want a different set of mappings for my CF library of includable quot;functionsquot; so I can use lt;cfinclude template=quot;/cflib/mymodule.cfmquot;gt; although that file is NOT located under my document root.br br br br -- -br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br br br --br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//a br To Unsubscribe visitbr a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf _talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bo dy=lists/cf_talk/a orbr send a message to [EMAIL PROTECTED] with 'unsubscribe' inbr the body.br br --br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//a br To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf _talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bo dy=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3- -br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
Linux CF Services
Is it normal for a Linux installation of CF 4.5.1 to start about 5 copies of cfserver, cfexec, and cfrdsservice? Is this the equivalent to apache's child servers? Where is this configurable? j !j! The mark of mediocrity is searching for the precedent. !jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI BIGWORDS.com worker#2 [EMAIL PROTECTED] [EMAIL PROTECTED] .r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with SQL
I tried that in Access and got an error message. I think this is available in SQL Server but not Access. Sebastian on 8/14/00 5:58 PM, Chapman, Katrina at [EMAIL PROTECTED] wrote: You use the SQL DatePart function select DatePart(mm, columnname) as month from foo --K -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Help with SQL I have a date and time field in the form of 8/14/00 in an Access database. I want to be able to select out the distinct months in all the fields. It seems that I can't do that. Do I have to redo the database and separate the month? Or do I have to process the query with some kind of CF code? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Browser / desktop resolution
I do totally agree with what you have written, however sometimes in the heat of frustration sometimes even the experienced can get stumped. Even if they are developing on their own and have know else in the team to help out. But you are right, a lot of the time its people who have not bothered to read the documentation. Which btw is the best Application Software I have seen with great reference material both in print and in IDE tools Homesite/Studio, a lot of the simple questions can be answered by fiddling, playing, experimenting knowing the functions backwards. And even in these times if you thing you understand what is happening, you sometimes don't. And you ask for help in what is going wrong, so sometimes don't excuse these people either. But people need to slow down and explain things alot more, and people on this list will recall a few that I got going. Not because I was an ass, and not because I wanted to cause trouble. But deadlines are deadlines, and sometimes you need help there and then and don't have a great deal of time to explain it. Well this happens all the time, I have been on this list now for nearly the beginning of its time. I have seen the most stupidest questions! Questions that can be answered, but people also have to remember that CF is great for the beginner and for those Advanced Senior Programmers its a godsend. To be an Advanced/Senior developer takes time, and a lot of hard work and understanding of lateral thinking and logic. These don't come easy and some people on this list think it does, but sometimes it can be a writers block so to speak and we need a third person to look at it to see why we can't see the logical problem. This is why such publications as Dr Jobbs and such publications are great, the use the information to teach and show new logic. Wouldn't it be good for a mailing list like this to behave like that as well, instead of so much people with big heads and there the people who tend to rub people up the wrong way. Anyway enough said, just a few thoughts I had after reading this! regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Terry Bader [mailto:[EMAIL PROTECTED]] Sent: 15 August 2000 09:40 To: [EMAIL PROTECTED] Subject: RE: Browser / desktop resolution What have you tried?? Ever looked into JavaScript?? I am going to be frank and apologize to everyone for this. I have been watching this list for 2 weeks and the mass of amounts of email being sent on a daily basis is annoying. There are some really good subjects in some of them but reading through them all is difficult to say the least. Maybe I will just look through the archives if I need anything. Now, comes my *whining*. This is a developers email list, right? more or less... if not then I am sorry but in mailing lists where development and programming goes, people just don't ask how and what can and where and so forth without trying to find what they need, playing with the code and then posting. But also posting what they tried and what they got and what they really want to do. I find though, on this list, messages such as Lucas' (sorry, you just happen to be the one that broke the camel's back). You ask how, but you don't state what you have tried, what you think is supposed to happen, what you think you should try, so forth... no info given but you need this/that personally Lucas, I would go look to some JavaScript sites and books, I am 99.9% sure that I saw one (shoot I probably have it in my personally repository) out there and where there is one there are more. Again, forgive me... most of the messages posted here are by very serious and very good developers and I applaud them. But they got that way by putting a lot of effort into their work and asked questions after trying stuff out (usual they figured it out on their own though).. I will be un-subscribing tomorrow, so if you wish to wait on hazing me without hurting my feelings (which you couldn't anyway) I would wait till tomorrow Any personal hate mails can be sent to me directly, which of course I will probably delete anyway. To all the serious learners and programmers, excellent job.. Terry Bader Web Developer EDO Corp - Combat Systems (757) 424-1004 ext 361 [EMAIL PROTECTED] [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Lucas Sherwood [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:10 PM To: [EMAIL PROTECTED]; Cfaussie Subject: Browser / desktop resolution Hi All, Is there a way from CF to work out what resolution a users browser is set to? Thanks, Lucas. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Lucas Sherwood Technical Sales Consultant FirmwareDesign [EMAIL PROTECTED]
Re: Linux CF Services
Is it normal for a Linux installation of CF 4.5.1 to start about 5 copies of cfserver, cfexec, and cfrdsservice? Is this the equivalent to apache's child servers? Where is this configurable? I've been wondering the same thing - my installation on Linux is also doing this. Anyone? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
List Values (Formerly: Browser / desktop resolution)
Ok, time for my 2 cents on the issue of off topic protests. Typically there are a few things that humans do: 1) Make mistakes, and use the wrong tools for the wrong job (whether it's a hammer to cut down a tree or Cold Fusion for a client issue) 2) Let their mind wander (whether it's from their significant other to a cute specimen opposite him/her, or from Cold Fusion to Server Hardware) 3) Ask dumb questions in an unfamiliar environment (whether it's "Is the pope catholic?" to "Can Cold Fusion determine screen size?") Anyways, we are all human, we all do stupid things, what do we do? Live with them. 'cuz this list, and many others are used by humans, and therefore will occasionally be flawed in their topic, stupidly questioned, and otherwise imperfect. There is my mindless rambling for the day. To whomever thinks that they can find a "pure" list where there is nothing but on track posts, people who can respond in 30 seconds 24/7, and expect it to be 100% accurate, I wish you good luck Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/14 4:51 PM I do totally agree with what you have written, however sometimes in the heat of frustration sometimes even the experienced can get stumped. Even if they are developing on their own and have know else in the team to help out. But you are right, a lot of the time its people who have not bothered to read the documentation. Which btw is the best Application Software I have seen with great reference material both in print and in IDE tools Homesite/Studio, a lot of the simple questions can be answered by fiddling, playing, experimenting knowing the functions backwards. And even in these times if you thing you understand what is happening, you sometimes don't. And you ask for help in what is going wrong, so sometimes don't excuse these people either. But people need to slow down and explain things alot more, and people on this list will recall a few that I got going. Not because I was an ass, and not because I wanted to cause trouble. But deadlines are deadlines, and sometimes you need help there and then and don't have a great deal of time to explain it. Well this happens all the time, I have been on this list now for nearly the beginning of its time. I have seen the most stupidest questions! Questions that can be answered, but people also have to remember that CF is great for the beginner and for those Advanced Senior Programmers its a godsend. To be an Advanced/Senior developer takes time, and a lot of hard work and understanding of lateral thinking and logic. These don't come easy and some people on this list think it does, but sometimes it can be a writers block so to speak and we need a third person to look at it to see why we can't see the logical problem. This is why such publications as Dr Jobbs and such publications are great, the use the information to teach and show new logic. Wouldn't it be good for a mailing list like this to behave like that as well, instead of so much people with big heads and there the people who tend to rub people up the wrong way. Anyway enough said, just a few thoughts I had after reading this! regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Terry Bader [mailto:[EMAIL PROTECTED]] Sent: 15 August 2000 09:40 To: [EMAIL PROTECTED] Subject: RE: Browser / desktop resolution What have you tried?? Ever looked into JavaScript?? I am going to be frank and apologize to everyone for this. I have been watching this list for 2 weeks and the mass of amounts of email being sent on a daily basis is annoying. There are some really good subjects in some of them but reading through them all is difficult to say the least. Maybe I will just look through the archives if I need anything. Now, comes my *whining*. This is a developers email list, right? more or less... if not then I am sorry but in mailing lists where development and programming goes, people just don't ask how and what can and where and so forth without trying to find what they need, playing with the code and then posting. But also posting what they tried and what they got and what they really want to do. I find though, on this list, messages such as Lucas' (sorry, you just happen to be the one that broke the camel's back). You ask how, but you don't state what you have tried, what you think is supposed to happen, what you think you should try, so forth... no info given but you need this/that personally Lucas, I would go look to some JavaScript sites and books, I am 99.9% sure that I saw one (shoot I probably have it in my personally repository) out there and where there is one there are more. Again, forgive me... most of the messages posted here are by very serious and very good developers and I applaud them. But they got that way by putting a lot of effort into their work and asked questions after trying
RE: CF Administrator Mapping and Apache Alias
Which does not have to be a directory your web server can see. best, paul At 06:56 PM 8/14/00 -0400, you wrote: All mappings do is create an alias for a phsyical directory... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.