Re: Find character not in a list (reverse of FindOneOf).
This is great! How would I add the dash, dot and underscore to the list of accepted characters? TIA!! Michael Gagnon - Original Message - From: "Steve Bernard" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 27, 2000 3:42 PM Subject: RE: Find character not in a list (reverse of FindOneOf). I'm guessing from your example code that you need to use REFind[NoCase](). An RE is much more efficient in terms of programming time, readability, and execution efficiency than a set of nested loops. My example lets you know if there are any characters besides A-Z and 0-9, case insensitive. The "^" at the beginning of the RE means, "not any of the following". If the parser finds a non-compliant character it returns its position in the string. If no offending characters are found it returns 0. CFIF REFindNoCase("[^A-Z0-9]", FORM.Username, 1) NEQ 0 ... An illegal character exists /CFIF Regards, Steve -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 1:00 PM To: CF-Talk Subject: RE: Find character not in a list (reverse of FindOneOf). It's gonna be a little more extensive than that. The scenario is that we have a variable which contains n characters and a list which contains m elements. We need a function which returns true if one of the characters in the string does not occur in the list. For this we will have to loop over the string and compare each character. cfset stopcondition=0 cfloop from=1 to=Len(FORM.Username) index=i cfif not ListFind(variables.SomeList, i) cfset stopcondition=1 cfbreak /cfif /cfloop cfif stopcondition Do your stuff here /cfif Steve -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 15:03 To: CF-Talk Subject: Re: Find character not in a list (reverse of FindOneOf). erlistfind() function I mean. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Find character not in a list (reverse of FindOneOf).
Modifying Steve B's example code, just add the extra characters to the end of the RE. The slashes simply escape the fact the dot, comma and underscore are special chars (AFAIK, haven't tested it). CFIF REFindNoCase("[^A-Z0-9\,\.\_]", FORM.Username, 1) NEQ 0 ... An illegal character exists /CFIF Steve M -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 13:30 To: CF-Talk Cc: [EMAIL PROTECTED] Subject: Re: Find character not in a list (reverse of FindOneOf). This is great! How would I add the dash, dot and underscore to the list of accepted characters? TIA!! Michael Gagnon - Original Message - From: "Steve Bernard" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 27, 2000 3:42 PM Subject: RE: Find character not in a list (reverse of FindOneOf). I'm guessing from your example code that you need to use REFind[NoCase](). An RE is much more efficient in terms of programming time, readability, and execution efficiency than a set of nested loops. My example lets you know if there are any characters besides A-Z and 0-9, case insensitive. The "^" at the beginning of the RE means, "not any of the following". If the parser finds a non-compliant character it returns its position in the string. If no offending characters are found it returns 0. CFIF REFindNoCase("[^A-Z0-9]", FORM.Username, 1) NEQ 0 ... An illegal character exists /CFIF Regards, Steve -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 1:00 PM To: CF-Talk Subject: RE: Find character not in a list (reverse of FindOneOf). It's gonna be a little more extensive than that. The scenario is that we have a variable which contains n characters and a list which contains m elements. We need a function which returns true if one of the characters in the string does not occur in the list. For this we will have to loop over the string and compare each character. cfset stopcondition=0 cfloop from=1 to=Len(FORM.Username) index=i cfif not ListFind(variables.SomeList, i) cfset stopcondition=1 cfbreak /cfif /cfloop cfif stopcondition Do your stuff here /cfif Steve -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 15:03 To: CF-Talk Subject: Re: Find character not in a list (reverse of FindOneOf). erlistfind() function I mean. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Duplicate key row in object 'CDATA'?
I've started to get the following error in my app: --- [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. --- CF 4.5.1 (no SPs) NT 4 (SP6a) SQL7 (SP2) I did a quick search of the forums, and came up empty on solutions. Not to mention the fact that forums was bugging out big time on me... I suspect this has something to do with initiating a new client token pair. The site uses frames, and my only theory would be that when a new user tries to enter the site, CF tries to set up two records in the client store at the exact same time. This doesn't seem right though. Help? -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFFile
If a file with the same name already exists on the server, you can use a NAMECONFLICT="makeunique". But what I want to know is if there is a way to see if it already exists on the server, and then prompt the user to rename the file, instead of CF handling this issue? Thanks, Chad -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 1:47 AM To: CF-Talk Subject: Re: CFFile How do I get the name of a file after it has been uploaded by a user using cffile? See the documentation for CFFILE with action="Upload". There are a whole slew of results variables, prefixed with 'file.', that give you the results of an upload. The one that gives the filename on your server is 'file.ServerFile'. Jim Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SQL Server and Win 98
Apart from using enterprise manager which works fine on win 98 and allows uploading/ conversion to sql databases can we run full sql on win 98 I want to be able to run the sql database locally and edit it locally rather than have to edit it off the live server. Can this be achieved in a 98 environment or do I have to upgrade the operating system to win 2000 I look forward to your comments Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFFile
Sure. You can 1) upload the file initially to a temporary holding area. 2) Check to see whether the ultimate destination has a file by that name, 3) If not then move the file from the holding area to the final destination and terminate. 4) If there is a file by that name then prompt the user to provide a different filename. 5) If this new filename is available then rename the file and move it terminate. Otherwise repeat (4) HTH Steve -Original Message- From: Chad Elley [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 14:20 To: CF-Talk Subject: RE: CFFile If a file with the same name already exists on the server, you can use a NAMECONFLICT="makeunique". But what I want to know is if there is a way to see if it already exists on the server, and then prompt the user to rename the file, instead of CF handling this issue? Thanks, Chad -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 1:47 AM To: CF-Talk Subject: Re: CFFile How do I get the name of a file after it has been uploaded by a user using cffile? See the documentation for CFFILE with action="Upload". There are a whole slew of results variables, prefixed with 'file.', that give you the results of an upload. The one that gives the filename on your server is 'file.ServerFile'. Jim -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Allaire Tag gallery ???
Ok, I give up! How are we supposed to use the Allaire Tag Gallery? I search for a tag I need, there is no documentation. I download the tag on the hopes it is what I need and I get an encrypted tag with no documentation... This has happened over and over. Am I missing something? Is there some place to go to get the documentation or source for these tags? --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Multi-table inserts updates
David, This sounds like what I'm after. But can you explain in a little more detail how you're handling the creation of the PK and FKs? Are you relying on the relationship between the tables set in the database? I'm close here. Maybe you can get me all the way home in one step. Thanks, --John David Shadovitz wrote: John, I agree with your concerns. In my Option 2, I pass the parent table info (not yet inserted into the db) to the 2nd page. I gather all of the child table info into a list for each field. Then I do all the inserts within a CFTRANSACTION: CFTRANSACTION CFQUERY to insert into parent table using FORM-scoped vars CFLOOP from 1 to length of list CFQUERY to insert into child table using ListGetAt(FORM-scoped list, index) /CFLOOP /CFTRANSACTION Let me know what you discover. -David On Fri, 27 Oct 2000 13:16:44 -0500 John Allred [EMAIL PROTECTED] writes: David, Thanks. I hadn't thought of your Option 2. I'm still thinking of a couple of other ways. The main thing with most obvious approaches is that the parent record has to be created first, then the children in subsequent steps. I guess what I was originally hoping for was something like entering parent and child info, saving the parent record and storing the child elements in an array or structure on one pass, then moving them to the child table in a second pass or upon Save Exit. Seems like this would insulate the user from the trips back and forth to the database to build up the parent and child records and behave more like non-web applications. Thanks for the suggestion. --John YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- John Allred / Jackson, Mississippi mailto:[EMAIL PROTECTED] -- "Wealth, like happiness, is never attained when sought after directly. It comes as a by-product of providing a useful service" -- Henry Ford -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Allaire Tag gallery ???
It is a problem but the fault is the writer of that tag not Allaire. If there is not tag in the zip file you download, and often times there isn't, sometimes on the Allaire page for the tag with the developer's name and a link for the email address. Try emailing the developer and ask if they have docs available or a website. - Steve -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 11:23 AM To: CF-Talk Subject: Allaire Tag gallery ??? Ok, I give up! How are we supposed to use the Allaire Tag Gallery? I search for a tag I need, there is no documentation. I download the tag on the hopes it is what I need and I get an encrypted tag with no documentation... This has happened over and over. Am I missing something? Is there some place to go to get the documentation or source for these tags? --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server and Win 98
Claude, I know you can install and use the MSDE on Windows 98. As you probably know, MSDE is something like a "lite" version of SQL Server that comes free with MS Access 2000 and can be used as an alternative to the Jet engine. Because its basically identical to SQL Server's underpinnings, "upsizing" is pretty much a no-brainer. So perhaps you can use the MSDE instead of SQL Server to get the job done. Eron -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 9:34 AM To: CF-Talk Subject: SQL Server and Win 98 Apart from using enterprise manager which works fine on win 98 and allows uploading/ conversion to sql databases can we run full sql on win 98 I want to be able to run the sql database locally and edit it locally rather than have to edit it off the live server. Can this be achieved in a 98 environment or do I have to upgrade the operating system to win 2000 I look forward to your comments Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server and Win 98
Can this be achieved in a 98 environment or do I have to upgrade the operating system to win 2000 Claude, Recent experience taught me to simply upgrade to Windows 2k Professional. The problem is that Win98 resource pool is so small that when I was running SQL Server on a laptop with win98 and then opened CF Studio, I'd have to reboot the machine after about 30 min of work. Win98 wouldn't recover it's resources even if I shut down the program. Once I upgraded I was a very happy developer ;-) p.s., if you plan to upgrade, install SQL 7 after otherwise you'll be forced to uninstall it prior to upgrading. Sincerely, Rob Sherman President CFDude, Inc. http://www.cfdude.com Allaire Certified Developer Instructor -- Office (310) 543-1622 Fax (310) 543-0512 Email [EMAIL PROTECTED]ICQ 3266081 AIM RobSSherm Yahoo! RobSherman_CFDev Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
HTML Anchors displayed as Text
--_-1239278004==_ma Content-Type: text/plain; charset="us-ascii" ; format="flowed" I am storing HTML Anchors in a database (happens to be oracle, but I don't think that is germane). I would like to read them out and dispaly the text of the anchor, not have it interpreted and displayed AS the actual anchor. In other words, I want to see: A HREF="whatever"something/A, not merely the underlined something. Is this possible? Thanks. -- ___ Joseph J. Sanger, M.D.| Phone: (212) 263-7410 Associate Professor of Clinical Radiology | Fax: (212) 263-2039 Director, Division of Radiology Informatics | Co-Director, Division of Nuclear Medicine | Co-Director, Nuclear Cardiology | New York University School of Medicine| [EMAIL PROTECTED] ___ --_-1239278004==_ma Content-Type: text/html; charset="us-ascii" !doctype html public "-//W3C//DTD W3 HTML//EN" htmlheadstyle type="text/css"!-- blockquote, dl, ul, ol, li { margin-top: 0 ; margin-bottom: 0 } --/styletitleHTML Anchors displayed as Text/title/headbody divI am storing HTML Anchors in a database (happens to be oracle, but I don't think that is germane).nbsp; I would like to read them out and dispaly the text of the anchor, not have it interpreted and displayed AS the actual anchor.nbsp; In other words, I want to see:nbsp; lt;A HREF=quot;whateverquot;gt;somethinglt;/Agt;, not merely the underlinedu something/u./div divbr/div divIs this possible?nbsp; Thanks./div div-- br _span /span__br nbsp;Joseph J. Sanger, M.D.nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /span nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /spannbsp;nbsp; | Phone: (212) 263-7410br nbsp;Associate Professor of Clinical Radiologynbsp;nbsp;nbsp;nbsp; | Fax:nbsp;nbsp; (212) 263-2039br nbsp;Director, Division of Radiology Informaticsnbsp;nbsp; |br nbsp;Co-Director, Division of Nuclear Medicinenbsp;nbsp;nbsp;nbsp; |br nbsp;Co-Director, Nuclear Cardiologynbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /spannbsp;nbsp;nbsp;nbsp;nbsp; |br nbsp;New York University School of Medicinenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; | [EMAIL PROTECTED]br _span /span__/div /body /html --_-1239278004==_ma-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HTML Anchors displayed as Text
I was able to accomplish this by replacing "" with "lt;", and "" with "gt;". For example: lt;A HREF="whatever"gt;somethinglt;/Agt; should work. Good luck! Norman Elton Information Technology College of William Mary -Original Message- From: Joseph J. Sanger, M.D. [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 1:35 PM To: CF-Talk Subject: HTML Anchors displayed as Text --_-1239278004==_ma Content-Type: text/plain; charset="us-ascii" ; format="flowed" I am storing HTML Anchors in a database (happens to be oracle, but I don't think that is germane). I would like to read them out and dispaly the text of the anchor, not have it interpreted and displayed AS the actual anchor. In other words, I want to see: A HREF="whatever"something/A, not merely the underlined something. Is this possible? Thanks. -- ___ Joseph J. Sanger, M.D.| Phone: (212) 263-7410 Associate Professor of Clinical Radiology | Fax: (212) 263-2039 Director, Division of Radiology Informatics | Co-Director, Division of Nuclear Medicine | Co-Director, Nuclear Cardiology | New York University School of Medicine| [EMAIL PROTECTED] ___ --_-1239278004==_ma Content-Type: text/html; charset="us-ascii" !doctype html public "-//W3C//DTD W3 HTML//EN" htmlheadstyle type="text/css"!-- blockquote, dl, ul, ol, li { margin-top: 0 ; margin-bottom: 0 } --/styletitleHTML Anchors displayed as Text/title/headbody divI am storing HTML Anchors in a database (happens to be oracle, but I don't think that is germane).nbsp; I would like to read them out and dispaly the text of the anchor, not have it interpreted and displayed AS the actual anchor.nbsp; In other words, I want to see:nbsp; lt;A HREF=quot;whateverquot;gt;somethinglt;/Agt;, not merely the underlinedu something/u./div divbr/div divIs this possible?nbsp; Thanks./div div-- br _span /span__br nbsp;Joseph J. Sanger, M.D.nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /span nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /spannbsp;nbsp; | Phone: (212) 263-7410br nbsp;Associate Professor of Clinical Radiologynbsp;nbsp;nbsp;nbsp; | Fax:nbsp;nbsp; (212) 263-2039br nbsp;Director, Division of Radiology Informaticsnbsp;nbsp; |br nbsp;Co-Director, Division of Nuclear Medicinenbsp;nbsp;nbsp;nbsp; |br nbsp;Co-Director, Nuclear Cardiologynbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /spannbsp;nbsp;nbsp;nbsp;nbsp; |br nbsp;New York University School of Medicinenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; | [EMAIL PROTECTED]br _span /span__/div /body /html --_-1239278004==_ma-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HTML Anchors displayed as Text
Alternatively you can use the HTMLEditFormat() function to escape the characters. Steve -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 19:09 To: CF-Talk Subject: RE: HTML Anchors displayed as Text I was able to accomplish this by replacing "" with "lt;", and "" with "gt;". For example: lt;A HREF="whatever"gt;somethinglt;/Agt; should work. Good luck! Norman Elton Information Technology College of William Mary -Original Message- From: Joseph J. Sanger, M.D. [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 1:35 PM To: CF-Talk Subject: HTML Anchors displayed as Text --_-1239278004==_ma Content-Type: text/plain; charset="us-ascii" ; format="flowed" I am storing HTML Anchors in a database (happens to be oracle, but I don't think that is germane). I would like to read them out and dispaly the text of the anchor, not have it interpreted and displayed AS the actual anchor. In other words, I want to see: A HREF="whatever"something/A, not merely the underlined something. Is this possible? Thanks. -- __ _ Joseph J. Sanger, M.D.| Phone: (212) 263-7410 Associate Professor of Clinical Radiology | Fax: (212) 263-2039 Director, Division of Radiology Informatics | Co-Director, Division of Nuclear Medicine | Co-Director, Nuclear Cardiology | New York University School of Medicine| [EMAIL PROTECTED] __ _ --_-1239278004==_ma Content-Type: text/html; charset="us-ascii" !doctype html public "-//W3C//DTD W3 HTML//EN" htmlheadstyle type="text/css"!-- blockquote, dl, ul, ol, li { margin-top: 0 ; margin-bottom: 0 } --/styletitleHTML Anchors displayed as Text/title/headbody divI am storing HTML Anchors in a database (happens to be oracle, but I don't think that is germane).nbsp; I would like to read them out and dispaly the text of the anchor, not have it interpreted and displayed AS the actual anchor.nbsp; In other words, I want to see:nbsp; lt;A HREF=quot;whateverquot;gt;somethinglt;/Agt;, not merely the underlinedu something/u./div divbr/div divIs this possible?nbsp; Thanks./div div-- br _span /span__br nbsp;Joseph J. Sanger, M.D.nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /span nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /spannbsp;nbsp; | Phone: (212) 263-7410br nbsp;Associate Professor of Clinical Radiologynbsp;nbsp;nbsp;nbsp; | Fax:nbsp;nbsp; (212) 263-2039br nbsp;Director, Division of Radiology Informaticsnbsp;nbsp; |br nbsp;Co-Director, Division of Nuclear Medicinenbsp;nbsp;nbsp;nbsp; |br nbsp;Co-Director, Nuclear Cardiologynbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;span /spannbsp;nbsp;nbsp;nbsp;nbsp; |br nbsp;New York University School of Medicinenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; | [EMAIL PROTECTED]br _span /span__/div /body /html --_-1239278004==_ma-- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
cfexecute
I'm having some sort of problem using CFEXECUTE The server is Windows 2000, CF 4.5.1 This works cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip d:\mylittlepdfdocument.pdf" /cfexecute This doesn't work.. cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf" /cfexecute * OR * cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip \\myserver\myshare\mylittlepdfdocument.pdf /cfexecute The E: drive is a mapped network drive going from one machine to another... If I call the following line from the web servers command prompt, it executes ok... d:\pkzip25.exe -add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf But it seems that CF doesn't like going across servers or something using cfexecute - please help :-) thx Tom Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Duplicate key row in object 'CDATA'?
I've started to get the following error in my app: --- [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. As a follow up to my original post, I have found out a great deal more about the problem, though I still don't have a solution. Here's a post I just made to the Forums about it. Common CF-Talk, don't fail me now -- I've having the same error. Here's what info I can contribute... I am able to reproduce the error intermittantly using IE 5.5, but not with Netscape 4.7 (same client machine). I also have discovered a bit of code which I can comment out that makes the problem completely do away, but I have no idea why. The particular place in my app where this error occurs is when a user is logging into my app. After the login is authenticated via a CFSTOREDPROC, a whole slew of client vars are set, including one which is a WDDX packet (in case that matters). After that, a quick CFIF test is done on the resultsets of the STOREDPROC. No client vars are accessed during the execution of this CFIF, nor inside it if it returns true. If the CFIF does return true, an email is generated using CFMAIL and more of the STOREDPROC resultsets. That CFIF is the code I can comment out to make it all work. I also tried commenting out the CFMAIL (so that nothing happened if the CFIF returns true), and I can reproduce the error. Also, if I replace the CFIF with a CFOUTPUT which output the same var called in the CFIF, I can also generate the error. But yes, there's more! After the CFIF statement, the user is CFLOCATIONed to the entrance page to the app. The CFLOCATION does use ADDTOKEN="Yes", but deleting that does not prevent the error from happening. Funny thing is, that the error is not happening on the page with the CFIF, it's happening on the entry page to the app. Something in the login template (cfm page 1) is causing the entry page (cfm page 2) to fail. The offending sequence seems to be (1) call a storedproc (it returns several recordsets) (2) set a bunch or client vars using that data (3) call data from the storedproc recordset again. (4) CFLOCATION to another page. One other note here in ramblings... When you view the souce of the page, it contains the error, then a bunch of raw HTML headers (which should not show in the browser), and then the CFM page, correctly executed! So, my conclusion is... Well, I dunno really, but I can reproduce the error, and I *can* make it go away (in my app). I just don't know why. Also, I wonder why it's only happening in IE,a nd not NS? Maybe something to do with the way each browser executes the CFLOCATION? Maybe the way each stores the CFID/CFTOKEN cookies? Anyone have any ideas? -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: cfexecute
Make sure the "ColdFusion Application Server" service has the priviledges to access the network drive. By default the services is logged on with "local system" account. Xing - Original Message - From: "Tom Langer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 1:20 PM Subject: cfexecuteo I'm having some sort of problem using CFEXECUTE The server is Windows 2000, CF 4.5.1 This works cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip d:\mylittlepdfdocument.pdf" /cfexecute This doesn't work.. cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf" /cfexecute * OR * cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip \\myserver\myshare\mylittlepdfdocument.pdf /cfexecute The E: drive is a mapped network drive going from one machine to another... If I call the following line from the web servers command prompt, it executes ok... d:\pkzip25.exe -add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf But it seems that CF doesn't like going across servers or something using cfexecute - please help :-) thx Tom -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: cfexecute
Tom, In order for the CF service to be able access networked drives you need to have it log in with the appropriate rights. In control panel/services double click on "Cold Fusion Application Server" and change the user the service logs in as to either a preexisting user or a new user, say "CFServer" or something which has network file access rights to the share. The reason it works from the console is because you are logged in to the system as a user. The CF service by default logs in as LocalSystem which basically has only local system rights. HTH Steve -Original Message- From: Tom Langer [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 21:20 To: CF-Talk Subject: cfexecute I'm having some sort of problem using CFEXECUTE The server is Windows 2000, CF 4.5.1 This works cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip d:\mylittlepdfdocument.pdf" /cfexecute This doesn't work.. cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf" /cfexecute * OR * cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip \\myserver\myshare\mylittlepdfdocument.pdf /cfexecute The E: drive is a mapped network drive going from one machine to another... If I call the following line from the web servers command prompt, it executes ok... d:\pkzip25.exe -add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf But it seems that CF doesn't like going across servers or something using cfexecute - please help :-) thx Tom -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: cfexecute
additional info I must have forgotten some basic security, here's an update to my problem... If I do a CFFILE copy I get an access denied message, when copying a file from one machine to another.. just doing the file copy from the start--run works fine. CF is using the local system account, I'd assume this should work fine - or am I forgetting some stupid fundemental thing here? Thanks Tom - Original Message - From: Tom Langer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 3:20 PM Subject: cfexecute I'm having some sort of problem using CFEXECUTE The server is Windows 2000, CF 4.5.1 This works cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip d:\mylittlepdfdocument.pdf" /cfexecute This doesn't work.. cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf" /cfexecute * OR * cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip \\myserver\myshare\mylittlepdfdocument.pdf /cfexecute The E: drive is a mapped network drive going from one machine to another... If I call the following line from the web servers command prompt, it executes ok... d:\pkzip25.exe -add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf But it seems that CF doesn't like going across servers or something using cfexecute - please help :-) thx Tom -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: cfexecute
Thanks Steve and Xing - that fixed it - grr, I knew it was going to be a simple silly thing :-/ Tom - Original Message - From: Tom Langer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 3:42 PM Subject: Re: cfexecute additional info I must have forgotten some basic security, here's an update to my problem... If I do a CFFILE copy I get an access denied message, when copying a file from one machine to another.. just doing the file copy from the start--run works fine. CF is using the local system account, I'd assume this should work fine - or am I forgetting some stupid fundemental thing here? Thanks Tom - Original Message - From: Tom Langer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 3:20 PM Subject: cfexecute I'm having some sort of problem using CFEXECUTE The server is Windows 2000, CF 4.5.1 This works cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip d:\mylittlepdfdocument.pdf" /cfexecute This doesn't work.. cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf" /cfexecute * OR * cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip \\myserver\myshare\mylittlepdfdocument.pdf /cfexecute The E: drive is a mapped network drive going from one machine to another... If I call the following line from the web servers command prompt, it executes ok... d:\pkzip25.exe -add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf But it seems that CF doesn't like going across servers or something using cfexecute - please help :-) thx Tom -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Duplicate key row in object 'CDATA'?
Interesting... I'm not using CFHEAD at all... But I would suspect that both CFLOCATION and CFAPPLICATION (setting cookies) use the same functionality internally. As for the cfid/app unique combination error, you mentioned that the errors shows up on framed cfm pages? Is it still true for a non-framed page? I thought that made a difference, but the error is actually displaying on the Framset page... The individual frame pages never load because of the error and/or lack of correct headers I suppose. I am pretty sure that the use of frames doesn't have anything to do with this problem. Your info is helpful, but I still can't see the reason for this error, or the long term solution... I'm continuing to tinker with the code to try to determine what will make it work without error. I'm kinda thinking that the first template is not finished saving the client data when the second page is called. The second page then thinks that the client var pair does not exist in the database, and tries to create it. But then why only on IE 5.5? It's fine on IE 4, and NS. Maybe IE 5.5 processes location headers faster? Fast enough to cause this problem? Still in the dark... -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Xing Li [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 6:12 PM To: CF-Talk Subject: Re: Duplicate key row in object 'CDATA'? Just checked the data scheme for CDATA and the "id1" is an unique index of the two columns "cfid" and "app". I have never experienced the culmulative error as you have described but I have gotten cflocation errors where html headers show up on only IE browsers. Many this will help a bit. If you use a wrapper for CFHEAD to cfhead a bunch of generated html to the header area and do a cflocate to another page, IE will, not always, but will frequently generate a type of error where you either a blank page or a full page with some html header shown at the top. When the html headers are shown, it seems like the cfserver has started but aborted the first set of html headers and then continued with a second set of the same headers. This eror is much more severe for Mac IE but is part of Win IE as well. I don't think it's a browser issue but rather the cfserver's way of handling the cfhead operation. Netscape does not have this problem which is exactly as you have discribed so this two problems might be related. As for the cfid/app unique combination error, you mentioned that the errors shows up on framed cfm pages? Is it still true for a non-framed page? Xing - Original Message - From: "Cameron Childress" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 1:37 PM Subject: RE: Duplicate key row in object 'CDATA'? I've started to get the following error in my app: --- [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. As a follow up to my original post, I have found out a great deal more about the problem, though I still don't have a solution. Here's a post I just made to the Forums about it. Common CF-Talk, don't fail me now -- I've having the same error. Here's what info I can contribute... I am able to reproduce the error intermittantly using IE 5.5, but not with Netscape 4.7 (same client machine). I also have discovered a bit of code which I can comment out that makes the problem completely do away, but I have no idea why. The particular place in my app where this error occurs is when a user is logging into my app. After the login is authenticated via a CFSTOREDPROC, a whole slew of client vars are set, including one which is a WDDX packet (in case that matters). After that, a quick CFIF test is done on the resultsets of the STOREDPROC. No client vars are accessed during the execution of this CFIF, nor inside it if it returns true. If the CFIF does return true, an email is generated using CFMAIL and more of the STOREDPROC resultsets. That CFIF is the code I can comment out to make it all work. I also tried commenting out the CFMAIL (so that nothing happened if the CFIF returns true), and I can reproduce the error. Also, if I replace the CFIF with a CFOUTPUT which output the same var called in the CFIF, I can also generate the error. But yes, there's more! After the CFIF statement, the user is CFLOCATIONed to the entrance page to the app. The CFLOCATION does use ADDTOKEN="Yes", but deleting that does not prevent the error from happening. Funny thing is, that the error is not happening on the page with the CFIF, it's happening on the entry page to the app. Something in the login template (cfm page 1) is causing the entry page (cfm page 2) to fail. The offending sequence seems to be (1) call a storedproc (it returns
Re: Duplicate key row in object 'CDATA'?
Cameron, I could not prove it but I think that error was caused by more than one. cfapplication tag having the same client storage db but different application names. ie. cfapplication name="appone" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" clientstorage="ClientDB" cfapplication name="apptwo" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" clientstorage="ClientDB" I had the problem for a while it went away then it came back. I searched for application.cfm templates on the server. Made appropriate changes. Now it has gone away again. :o)) To expand a little bit I actually think the problem was on a separate development server in a totally different application that got attached to the same client database. Jeff Craig - Original Message - From: "Cameron Childress" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 3:37 PM Subject: RE: Duplicate key row in object 'CDATA'? I've started to get the following error in my app: --- [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. As a follow up to my original post, I have found out a great deal more about the problem, though I still don't have a solution. Here's a post I just made to the Forums about it. Common CF-Talk, don't fail me now -- I've having the same error. Here's what info I can contribute... I am able to reproduce the error intermittantly using IE 5.5, but not with Netscape 4.7 (same client machine). I also have discovered a bit of code which I can comment out that makes the problem completely do away, but I have no idea why. The particular place in my app where this error occurs is when a user is logging into my app. After the login is authenticated via a CFSTOREDPROC, a whole slew of client vars are set, including one which is a WDDX packet (in case that matters). After that, a quick CFIF test is done on the resultsets of the STOREDPROC. No client vars are accessed during the execution of this CFIF, nor inside it if it returns true. If the CFIF does return true, an email is generated using CFMAIL and more of the STOREDPROC resultsets. That CFIF is the code I can comment out to make it all work. I also tried commenting out the CFMAIL (so that nothing happened if the CFIF returns true), and I can reproduce the error. Also, if I replace the CFIF with a CFOUTPUT which output the same var called in the CFIF, I can also generate the error. But yes, there's more! After the CFIF statement, the user is CFLOCATIONed to the entrance page to the app. The CFLOCATION does use ADDTOKEN="Yes", but deleting that does not prevent the error from happening. Funny thing is, that the error is not happening on the page with the CFIF, it's happening on the entry page to the app. Something in the login template (cfm page 1) is causing the entry page (cfm page 2) to fail. The offending sequence seems to be (1) call a storedproc (it returns several recordsets) (2) set a bunch or client vars using that data (3) call data from the storedproc recordset again. (4) CFLOCATION to another page. One other note here in ramblings... When you view the souce of the page, it contains the error, then a bunch of raw HTML headers (which should not show in the browser), and then the CFM page, correctly executed! So, my conclusion is... Well, I dunno really, but I can reproduce the error, and I *can* make it go away (in my app). I just don't know why. Also, I wonder why it's only happening in IE,a nd not NS? Maybe something to do with the way each browser executes the CFLOCATION? Maybe the way each stores the CFID/CFTOKEN cookies? Anyone have any ideas? -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Problem with CFFTP
One of my users says his attempted use of CFFTP replies with a "CFObject Disabled By Administrator" error. I don't see where to enable/disable CFFTP Suggestions? best, paul At 07:11 PM 10/10/00 -0400, you wrote: I am kind of confused since the question seems to be asking why doesn't orange juice come out of my apple... If the user is not running an ftp server, you will not be able to ftp to them. Much better to just include a link in the same page to the generated file. That would let them download the file onto their computer using their browser and save it wherever they want. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Duplicate key row in object 'CDATA'?
From: [EMAIL PROTECTED] I could not prove it but I think that error was caused by more than one. cfapplication tag having the same client storage db but different application names. I don't think that this is the cause of the problem. Three reasons: 1) CF's client storage was specifically designed to be used with multiple datasources. 2) The offending index, 'id1', is a combination of the columns cfid and app. The cfid column is made up of "cfid:cftoken", and the app colum is the actual appname set in the CFAPPLICATION tag. In order to cause the duplicate row error, both offending records would have to be the same app name. 3) It only happens in IE 5.5 Of course, I could be wrong. It's happened before... Still seeking the answer... -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
ODBC Error Code = S0002 (Base table not found)
Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
take off all references of dbo. - Original Message - From: Martin S [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 5:14 PM Subject: ODBC Error Code = S0002 (Base table not found) Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm -- -- On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Or that :-) depends take off all references of dbo. - Original Message - From: Martin S [EMAIL PROTECTED] Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm -- -- On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFERROR Usage
Hi guys, I haven't used CFCERROR before so would appreciate a little help with it. I am using it in my application.cfm file as advised and all is working with my error handling page. Thing is, I want an e-mail to be sent to the site's webmaster when an error occurs. The CFERROR tag includes a mailto attribute but this isn't sending out e-mails. This seems to only make the variable available to the error handling page which is quite useless in my eyes. Since no CF code is executed in an error handling page, does anyone have any ideas? I would prefer to stick with CFERROR rather than use CFTRY and CFCATCH exception handling. Regards, Peter Alexandrou Technical Leader tapestry communications : www.tapestry.net.au level 4, 32 walker street north sydney NSW 2060 australia phone : +61 2 9929 7400 mobile : +61 411 445 111 e-mail : [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Datatype Mismatch in Access
Hi, I'm wondering if anyone can help with this problem. Since I'm pretty new to using ColdFusion with MS Access, I can't figure out why the following: cfquery name="AddAccount" datasource="netinfhosts" debug="Yes" Insert into CompanyInfo (HostName, RoleContact, ContactName) Values('Host Test', 'Yes', 'Sales Manager')/cfquery causes this error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:4) to (10:67) I've rechecked my database, and the fields, HostName, RoleContact, and ContactName, have been set as text(50), yes/no, and text(50) respectively. Is there anything wrong with the SQL statements or was my database not set up properly? Thanks, Harry _ Half.com the hottest site for DVDs, CDs more! Get $5 off your 1st purchase of $10 or more. http://ads.adflight.com/mach1.asp?a=19061b=46867c=3094 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Datatype Mismatch in Access
on 10/29/00 7:42 PM, Harry Kurrosawa at [EMAIL PROTECTED] wrote: cfquery name="AddAccount" datasource="netinfhosts" debug="Yes" Insert into CompanyInfo (HostName, RoleContact, ContactName) Values('Host Test', 'Yes', 'Sales Manager')/cfquery Try the number 1 instead of 'Yes' Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Datatype Mismatch in Access
Don't quote the yes value. It is a true false field. Make yes the number 1 with no quotes for yes and 0 for no. It may be a yes no field in access but it works much better when you supply it a boolean value. Kevin - Original Message - From: Harry Kurrosawa [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:42 PM Subject: Datatype Mismatch in Access Hi, I'm wondering if anyone can help with this problem. Since I'm pretty new to using ColdFusion with MS Access, I can't figure out why the following: cfquery name="AddAccount" datasource="netinfhosts" debug="Yes" Insert into CompanyInfo (HostName, RoleContact, ContactName) Values('Host Test', 'Yes', 'Sales Manager')/cfquery causes this error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:4) to (10:67) I've rechecked my database, and the fields, HostName, RoleContact, and ContactName, have been set as text(50), yes/no, and text(50) respectively. Is there anything wrong with the SQL statements or was my database not set up properly? Thanks, Harry _ Half.com the hottest site for DVDs, CDs more! Get $5 off your 1st purchase of $10 or more. http://ads.adflight.com/mach1.asp?a=19061b=46867c=3094 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFERROR Usage
If you use CFERROR Type="Exception" rather than "Request" (the default value), you can execute any CF commands in the Error template, including the CFMAIL tag. -Original Message- From: Peter Alexandrou [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 5:13 PM To: CF-Talk Subject: CFERROR Usage Hi guys, I haven't used CFCERROR before so would appreciate a little help with it. I am using it in my application.cfm file as advised and all is working with my error handling page. Thing is, I want an e-mail to be sent to the site's webmaster when an error occurs. The CFERROR tag includes a mailto attribute but this isn't sending out e-mails. This seems to only make the variable available to the error handling page which is quite useless in my eyes. Since no CF code is executed in an error handling page, does anyone have any ideas? I would prefer to stick with CFERROR rather than use CFTRY and CFCATCH exception handling. Regards, Peter Alexandrou Technical Leader tapestry communications : www.tapestry.net.au level 4, 32 walker street north sydney NSW 2060 australia phone : +61 2 9929 7400 mobile : +61 411 445 111 e-mail : [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Select All option
Anyone know of a quickie to select all option check boxes with one? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Application Variables
CFSET Application.VariableName = "value" Dave - Original Message - From: Peter Alexandrou [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 9:20 PM Subject: Application Variables Guys, Is there anyway of resetting application variables in CF? i.e. I have an application and would like administrators to be able to log in and select an option that resetsout all application and server variables. Thanks, Peter Alexandrou Technical Leader tapestry communications : www.tapestry.net.au level 4, 32 walker street north sydney NSW 2060 australia phone : +61 2 9929 7400 mobile : +61 411 445 111 e-mail : [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Hey... to make it simple go through Cold Fusion ODBC. do this by pointing your browser to something like http://yourserver.com/cfide/Administrator/index.cfm Create the ODBC that way... - Original Message - From: Marius Milosav [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 7:15 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC datasource as System DSN Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:57 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius and all, Sorry about this. I am new to accessing DBs other than Access in COldFusion..so excuse my ignorance when it comes to this. I belive I have done what you say, but please verify this with me, as I am after all new to this frontier. I just went to confirm this from the ontrol Panel, ODBC DS, System DSN, and it was all there..I checked it etc.. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Whwere does this leave me? From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:55:00 -0500 When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free
RE: Select All option
Yep javascript, do a for loop and change the state of the select object of the form name in question. regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 14:22 To: CF-Talk Subject: Select All option Anyone know of a quickie to select all option check boxes with one? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. Thanks, Martin. From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 21:15:15 -0500 If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC datasource as System DSN Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:57 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius and all, Sorry about this. I am new to accessing DBs other than Access in COldFusion..so excuse my ignorance when it comes to this. I belive I have done what you say, but please verify this with me, as I am after all new to this frontier. I just went to confirm this from the ontrol Panel, ODBC DS, System DSN, and it was all there..I checked it etc.. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Whwere does this leave me? From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:55:00 -0500 When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
I have.. The thing is I am doing the Cold Fusion remotely on a different computer on the network. I have set up the remote computer (where the Code and DB is stored) datasource settings in Both NT and ColdFusion Admin..as well a the local computer (my pc) datasource settings in both NT and ColdFusion Admin. I am not sure if this is over-kill or required but as I said I am new to using a DB other than Acss (which I haven't had many problems with before) and working remotely, so to speak. Thanks, Martin. From: [EMAIL PROTECTED] (Brian bouldernet) Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:25:14 -0700 Hey... to make it simple go through Cold Fusion ODBC. do this by pointing your browser to something like http://yourserver.com/cfide/Administrator/index.cfm Create the ODBC that way... - Original Message - From: Marius Milosav [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 7:15 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC datasource as System DSN Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:57 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius and all, Sorry about this. I am new to accessing DBs other than Access in COldFusion..so excuse my ignorance when it comes to this. I belive I have done what you say, but please verify this with me, as I am after all new to this frontier. I just went to confirm this from the ontrol Panel, ODBC DS, System DSN, and it was all there..I checked it etc.. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Whwere does this leave me? From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:55:00 -0500 When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE ..
CF Scheduled task in password protected directory
Hi. I have set up a scheduled task from CF server (CF 4.0 on Windows NT), but I've been having a problem when the scheduled page is in password protected directory. Once I schedule to run a page from that directory, it won't run. The directory is protected using NT's basic authentication. Does anyone know why this is the case, or any workaround ? Thanks. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
cfquery datasource="BP" username="yourusername" password="Your_pwd" Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' /cfquery Are you absolutely positive that the table "name" your using in your query statement actually exists in the database ? Steve - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 6:50 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Post your query.. - Original Message - Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Limit the output of words to 300 chars
How can I Limit the output of words to 300 chars but don't cut off a word in the middle? Thanks, Nathan P.S. I know I should know but I don't have time to find it can someone help me.. see you all at the Conf in DC!! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error NO MORE
ALAS, Your a legend, it works now!! Thanks..I can progress to another problem no doubt :-) Cheers mate. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 19:19:36 -0800 cfquery datasource="BP" username="yourusername" password="Your_pwd" Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' /cfquery Are you absolutely positive that the table "name" your using in your query statement actually exists in the database ? Steve - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 6:50 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Limit the output of words to 300 chars
Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 14:29 To: CF-Talk Subject: Limit the output of words to 300 chars How can I Limit the output of words to 300 chars but don't cut off a word in the middle? Thanks, Nathan P.S. I know I should know but I don't have time to find it can someone help me.. see you all at the Conf in DC!! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Limit the output of words to 300 chars
on 10/30/00 1:35 PM, Scott, Andrew at [EMAIL PROTECTED] wrote: Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! Some of these posters are very intolerant... -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Limit the output of words to 300 chars
Andrew, Thanks for posting a possible solution but why bother if youre gonna belittle? STFW your a "seasoned professional" - lots of people are here to learn. Lay off the cafe' and keep your arrogance to your small self. Steve - Original Message - on 10/30/00 1:35 PM, Scott, Andrew at [EMAIL PROTECTED] wrote: Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Drop down List
Hi every one, I have 2 drop down lists ,the first one has options which are hard coded. When the user selects one of these options from the first dropdown list then the second dropdown list gets populated from the database accordingly.I want this to happen in the same template. Please help Shally __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Limit the output of words to 300 chars
Please Andrew. Lay off the cheap sentimentality. All this lovin' is getting a little mushy. btw, your solution will get rid of the last word in the 300 characters, even if the word was complete, which may not be exactly what you want. Sometimes basic is not so basic. Take a look at char 301. If it's whitespace, or maybe even punctuation, you can leave your 300 chars alone. And that's just the start of the fun. Neatest, most elegant solution to this near-but-not-quite trivial problem wins a beautiful set of steak knives. Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! regards Andrew Scott -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] How can I Limit the output of words to 300 chars but don't cut off a word in the middle? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Drop down List
There is a custom tag called twoSelectsRelated that may be of help. Hi every one, I have 2 drop down lists ,the first one has options which are hard coded. When the user selects one of these options from the first dropdown list then the second dropdown list gets populated from the database accordingly.I want this to happen in the same template. Please help Shally __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SUBSTR : SQL queries
Hi, I encountered problem in executing the below SQL statement : select property_no, road_name, postal_code from usr_prop_info where substr(postal_code,1,length(a.postal_code)) in (select a.postal_code from road_info a where district_no = '#form.hdb_estate#') Apparently, my ROAD_INFO.POSTAL_CODE is either in 2-digit or 3-digit number but my USR_PROP_INFO.POSTAL_CODE is in 6-digit number. I'm trying to do a substr() but its length is determined by the length of the postal_code in ROAD_INFO. How do I able to achieve that ? Thanks. Roger Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Limit the output of words to 300 chars
*s* You are welcome to your comments, as I am welcome to mine! But I just wanted to say that this is an easy thing that even the most basic programers can figure out... but hey I guess CF attracts a lot of non programmers then regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Stephen M. Aylor [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 14:39 To: CF-Talk Subject: Re: Limit the output of words to 300 chars Andrew, Thanks for posting a possible solution but why bother if youre gonna belittle? STFW your a "seasoned professional" - lots of people are here to learn. Lay off the cafe' and keep your arrogance to your small self. Steve - Original Message - on 10/30/00 1:35 PM, Scott, Andrew at [EMAIL PROTECTED] wrote: Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Limit the output of words to 300 chars
Well thats the price you pay, for example you would need to expand the concept a bit more. Does the last position (301) contain a space, then you wouldn't need to go back any further, or is it a comma or a full stop. You see if you think about it then the solution is simple! There are no hard and fast methods, its what you program at the time for what you need. In my case when I first did something like this, it didn't matter it was words upto 300 chars. No if you want to throw more conditions on top of this then you can do what you need! regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 14:51 To: CF-Talk Subject: RE: Limit the output of words to 300 chars Please Andrew. Lay off the cheap sentimentality. All this lovin' is getting a little mushy. btw, your solution will get rid of the last word in the 300 characters, even if the word was complete, which may not be exactly what you want. Sometimes basic is not so basic. Take a look at char 301. If it's whitespace, or maybe even punctuation, you can leave your 300 chars alone. And that's just the start of the fun. Neatest, most elegant solution to this near-but-not-quite trivial problem wins a beautiful set of steak knives. Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! regards Andrew Scott -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] How can I Limit the output of words to 300 chars but don't cut off a word in the middle? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Limit the output of words to 300 chars
but hey I guess CF attracts a lot of non programmers then Andrew Scott Senior Cold Fusion Application Developer Your just now realizing this? Steve Aylor Basic Dude Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Limit the output of words to 300 chars
I don't know if this will qualify as either neat or elegant, but I believe that it will work. If not, please forgive me, I haven't tested it exhaustively ;) cfset partA = Left(test1,301) cfif Right(partA,1) EQ " " cfset final = partA cfelse cfset lastword = ListLast(partA," ") cfset final = Left(partA,Len(partA)-Len(lastword)) /cfif Note: test1 is the string we are truncating, final is the result Bob -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 10:51 PM To: CF-Talk Subject: RE: Limit the output of words to 300 chars Please Andrew. Lay off the cheap sentimentality. All this lovin' is getting a little mushy. btw, your solution will get rid of the last word in the 300 characters, even if the word was complete, which may not be exactly what you want. Sometimes basic is not so basic. Take a look at char 301. If it's whitespace, or maybe even punctuation, you can leave your 300 chars alone. And that's just the start of the fun. Neatest, most elegant solution to this near-but-not-quite trivial problem wins a beautiful set of steak knives. Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! regards Andrew Scott -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] How can I Limit the output of words to 300 chars but don't cut off a word in the middle? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Limit the output of words to 300 chars
I simply stated I didn't have the time to figure it out and since it was sooo simple could someone point me in the right direction... by the way there are plenty of beginners and advanced people on this list... cfset startnum=Find(' ', Reverse(left(MyText,301)) , 1) cfset outvar=#mid(Reverse(left(MyText,301)),startnum,300)# #reverse(outvar)# Here is my final bit of code for all of the beginners and those of us who are too busy to have ALL of the answers. :) Nathan Stanford PS. I will be at the cf_underground on the expert panel so sorry to have bothered you. grin -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 10:07 PM To: CF-Talk Subject: RE: Limit the output of words to 300 chars *s* You are welcome to your comments, as I am welcome to mine! But I just wanted to say that this is an easy thing that even the most basic programers can figure out... but hey I guess CF attracts a lot of non programmers then regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Stephen M. Aylor [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 14:39 To: CF-Talk Subject: Re: Limit the output of words to 300 chars Andrew, Thanks for posting a possible solution but why bother if youre gonna belittle? STFW your a "seasoned professional" - lots of people are here to learn. Lay off the cafe' and keep your arrogance to your small self. Steve - Original Message - on 10/30/00 1:35 PM, Scott, Andrew at [EMAIL PROTECTED] wrote: Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
FW: Limit the output of words to 300 chars
Ok, so I didn't account for punctuation! I guess that's what happens when you bang code out at 11:15 on a Sunday evening! -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 11:06 PM To: CF-Talk Subject: RE: Limit the output of words to 300 chars I don't know if this will qualify as either neat or elegant, but I believe that it will work. If not, please forgive me, I haven't tested it exhaustively ;) cfset partA = Left(test1,301) cfif Right(partA,1) EQ " " cfset final = partA cfelse cfset lastword = ListLast(partA," ") cfset final = Left(partA,Len(partA)-Len(lastword)) /cfif Note: test1 is the string we are truncating, final is the result Bob -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 10:51 PM To: CF-Talk Subject: RE: Limit the output of words to 300 chars Please Andrew. Lay off the cheap sentimentality. All this lovin' is getting a little mushy. btw, your solution will get rid of the last word in the 300 characters, even if the word was complete, which may not be exactly what you want. Sometimes basic is not so basic. Take a look at char 301. If it's whitespace, or maybe even punctuation, you can leave your 300 chars alone. And that's just the start of the fun. Neatest, most elegant solution to this near-but-not-quite trivial problem wins a beautiful set of steak knives. Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! regards Andrew Scott -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] How can I Limit the output of words to 300 chars but don't cut off a word in the middle? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CHILL! Re: Limit the output of words to 300 chars
Hey Andrew, Jump off that BIG horse... I'm SURE, and I know there are those whom have more knowledge then yourself. But do you see them crashing you development when you don't answer question correctly.So take a chill no one calling you a non programmer. HISTORY: http://listserver.tved.net.au/pipermail/cfaussie/2000-August/000283.html http://www.allaire.com/Products/ColdFusion/features/CF45ServerFeatureMatrix. pdf -Brian - Original Message - From: Scott, Andrew [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 9:06 PM Subject: RE: Limit the output of words to 300 chars *s* You are welcome to your comments, as I am welcome to mine! But I just wanted to say that this is an easy thing that even the most basic programers can figure out... but hey I guess CF attracts a lot of non programmers then regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Stephen M. Aylor [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 14:39 To: CF-Talk Subject: Re: Limit the output of words to 300 chars Andrew, Thanks for posting a possible solution but why bother if youre gonna belittle? STFW your a "seasoned professional" - lots of people are here to learn. Lay off the cafe' and keep your arrogance to your small self. Steve - Original Message - on 10/30/00 1:35 PM, Scott, Andrew at [EMAIL PROTECTED] wrote: Easy do a left(string,300) then reverse the string and find the first space get the position and then do a mid on that? Some of these quesations are very basic programming skills guys! -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Limit the output of words to 300 chars
*LOL* regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Stephen M. Aylor [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 15:05 To: CF-Talk Subject: Re: Limit the output of words to 300 chars but hey I guess CF attracts a lot of non programmers then Andrew Scott Senior Cold Fusion Application Developer Your just now realizing this? Steve Aylor Basic Dude Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Help creating ODBC connection with MySql under Linux
Hello everyone, I am new at this so please bare with me. I have 1 year of experience with CF on windows, but not much under Linux. I have installed the CF server(4.5.1) under RedHat 7.0 and everything works, the administrator and I tested the installation and I also used the example applications to see if they worked too and they did. I installed MySql and I know it works as well because I can use the terminal window to create tables and query the databases. So with the Administrator I created an ODBC connection to a test database that I created and when I use the Verify button the connection always fails. Can someone tell me how to make and ODBC connection to MySQL? Am I doing something wrong? I left everything as the default all I typed in was the database name Thanks Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Help creating ODBC connection with MySql under Linux
on 10/30/00 2:29 PM, Phil Labonte at [EMAIL PROTECTED] wrote: Am I doing something wrong? I left everything as the default all I typed in was the database name You have to use the advanced button in the CF administrator and make sure you have added the user/password than you use to connect to mySQL and that that user/pass has the appropriate privileges in mySQL. Make sure you have also entered a datasource name as well as the database name. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CHILL! Re: Limit the output of words to 300 chars
Down here, we have what we refer to lovingly as "the Ugly Australian". It's a much-valued tradition that Andrew is trying his best to perpetuate. All power to him, I say. Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Hey Andrew, Jump off that BIG horse... I'm SURE, and I know there are those whom have more knowledge then yourself. But do you see them crashing you development when you don't answer question correctly.So take a chill no one calling you a non programmer. IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Help creating ODBC connection with MySql under Linux
Is this under NT or unix, I found under Solaris at least that you need to also had to the ini file in one of the directories as well. Not sure under NT as I have not used mySQL under NT:-) regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 15:38 To: CF-Talk Subject: Re: Help creating ODBC connection with MySql under Linux on 10/30/00 2:29 PM, Phil Labonte at [EMAIL PROTECTED] wrote: Am I doing something wrong? I left everything as the default all I typed in was the database name You have to use the advanced button in the CF administrator and make sure you have added the user/password than you use to connect to mySQL and that that user/pass has the appropriate privileges in mySQL. Make sure you have also entered a datasource name as well as the database name. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFLINUX
http://www.mslinux.org/ Any feedback would be great... Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Help creating ODBC connection with MySql under Linux
The Subject dude... the subject. amazing Captn Critique' - open arse insert 10' er Steve - Original Message - From: "Scott, Andrew" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 9:02 PM Subject: RE: Help creating ODBC connection with MySql under Linux Is this under NT or unix, I found under Solaris at least that you need to also had to the ini file in one of the directories as well. Not sure under NT as I have not used mySQL under NT:-) regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 15:38 To: CF-Talk Subject: Re: Help creating ODBC connection with MySql under Linux on 10/30/00 2:29 PM, Phil Labonte at [EMAIL PROTECTED] wrote: Am I doing something wrong? I left everything as the default all I typed in was the database name You have to use the advanced button in the CF administrator and make sure you have added the user/password than you use to connect to mySQL and that that user/pass has the appropriate privileges in mySQL. Make sure you have also entered a datasource name as well as the database name. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFLINUX
If I didn't know better the site looks like a complete hoax, however if it is then they are in deep trouble with the Copyright message at the bottom of the screen:-) But it wouldn't surprise me that MS will do this either, they dominate everything else when it comes to OS market share! regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 17:00 To: CF-Talk Subject: CFLINUX http://www.mslinux.org/ Any feedback would be great... Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFLINUX
Umm.. This site is a parody site dude... Its quite obvious! - Original Message - From: "Scott, Andrew" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 30, 2000 4:25 PM Subject: RE: CFLINUX If I didn't know better the site looks like a complete hoax, however if it is then they are in deep trouble with the Copyright message at the bottom of the screen:-) But it wouldn't surprise me that MS will do this either, they dominate everything else when it comes to OS market share! regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 17:00 To: CF-Talk Subject: CFLINUX http://www.mslinux.org/ Any feedback would be great... -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFLINUX
Considering the quotes on the left, the articles about Microsoft invading Cuba, the bogus daemon names I'd say it's a hoax. But a good one! :) Norman Elton Information Technology College of William Mary -Original Message- From: Brian bouldernet [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 1:00 AM To: CF-Talk Subject: CFLINUX http://www.mslinux.org/ Any feedback would be great... Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Limit the output of words to 300 chars
From: "Nathan Stanford" [EMAIL PROTECTED] How can I Limit the output of words to 300 chars but don't cut off a word in the middle? In psuedo code -- target define word ListInsertAt 300th word some_unused_char_as_delimiter goal = ListFirst(target) in CF ( not guaranteed) this is verbose and explicit, there should be a regex that can do the same in one step (Rick Osborne??) !--- define: word n chars ending in chr(32) cfset spc=chr(32) cfset lf=chr(10) cfset cr=chr(13) cfset lfcr=lf cr cfset rareChar=chr(135) cfset thisFile="c:\foo\some_tract.txt" cffile action = "read" file=#thisFile# variable=txt cfset sanityCheck=FindOneOf(#spc#,txt) cfset yesLF=FindOneOf(#lf#,txt) cfset yesCR=FindOneOf(#cr#,txt) cfif(sanityCheck) cfset isIt_unix_or_dos_or_charStream=yesLF + yesCR cfswitch expression="#isIt_unix_or_dos#" cfcase value=0 !--- it's char stream !--- do nothing --- /cfcase cfcase value=1 !--- must be unix cfset txt=ReplaceNoCase(txt,#lf#,#spc#,"ALL") /cfcase cfcase value=2!--- it's dos cfset txt=ReplaceNocase(txt,#lfcr#,#spc#,"ALL") /cfcase /cfswitch !--- now we have a stream of char representable as one long line --- !--- if the txt is properly punctuated, (cf. differences tween English English and American English) then txt is finished being prepped. Might add in recursive code to replace instances where chr32 appears more than once in any given char sequence. Probably should do this as some do two chr32 after periods and some do one chr32. Code is trivial and left as exercise :) - cfset txt=ListSetAt(txt,300,#rareChar#,#spc#) cfset goal=ListFirst(txt,#rareChar#) cfelse cfoutputredefine wordbrcfabort/cfoutput /cfif rareChar selection should be informed by awareness of language used in txt and by general knowledge of context I.E. chr(135) will be likely in highly footnoted tracts from academic types (especially history majors :) ). Pan - the one and only Baroque programmer Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFLINUX
http://www.mslinux.org/ If I didn't know better the site looks like a complete hoax, however if it is then they are in deep trouble with the Copyright message at the bottom of the screen:-) Andrew "Sherlock" Scott, with the always helpful observation. -ron Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Limit the output of words to 300 chars ---- it even says chars in the subject line
ARRRGH ! Too late he wrote "limit to 300 chars" NOT 300 words Pan - abashed, no excuses Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
NOTICE! Re: CFLINUX
As Austin Powers said so elegantly... "Throw me a freaking bone here.." FOR THE RECORD, YES THIS IS A PARODY And no, Monkeys are not being shot to mars to develop MSOpenShip 2006... yet - Original Message - From: Scott, Andrew [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 10:25 PM Subject: RE: CFLINUX If I didn't know better the site looks like a complete hoax, however if it is then they are in deep trouble with the Copyright message at the bottom of the screen:-) But it wouldn't surprise me that MS will do this either, they dominate everything else when it comes to OS market share! regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 17:00 To: CF-Talk Subject: CFLINUX http://www.mslinux.org/ Any feedback would be great... -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFLINUX
Really But look at the legal aspects dude. Copyright material from a company, throws up legal issues all over. Can I ask are you guys in the USA on drugs or something or is it that its just late for you guys over there:-) regards Andrew Scott Senior Cold Fusion Application Developer Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFLINUX
Whoa tiger I mean "dude". No disrespect or disregard to Australia and Aussies, but we have something in America that we love to use.. A sense of Humor... That is especially true at 3AM. - Original Message - From: Scott, Andrew [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 10:49 PM Subject: RE: CFLINUX Really But look at the legal aspects dude. Copyright material from a company, throws up legal issues all over. Can I ask are you guys in the USA on drugs or something or is it that its just late for you guys over there:-) regards Andrew Scott Senior Cold Fusion Application Developer -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
tree structure
I have got a databse table like this: catid category parent 1 auto 0 2 autos1 1 3 autos2 2 4 autos3 3 5 autos4 0 6 autos5 0 7 autos6 5 and so on .i can add and delete categories from the table from another template i have made... what i want is to make a tree structure of all the categories like this --auto --autos1 --autos2 --autos3 --autos4 --autos5 --autos6 this tree structure should come dynamically and any no. of categories i add should be displayed here. i tried to do this but i got mixed up with cfloop and cfoutput and i dont have that much time to work on it can anybody please help me out of this. P.S There can be any no. of categories under another category ..so dont think that there is only one subcategory under another category. I hope i get a solution for this here thanks in advance... _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFLINUX
errr, feeling more and more embarrassed to be Australian... Sense of humour cut in last Federal Budget. Minister For Disdain re-appointed for another four-year-term... Oh, for a GreenCard -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Whoa tiger I mean "dude". No disrespect or disregard to Australia and Aussies, but we have something in America that we love to use.. A sense of Humor... That is especially true at 3AM. - Original Message - From: Scott, Andrew [EMAIL PROTECTED] But look at the legal aspects dude. Copyright material from a company, throws up legal issues all over. Can I ask are you guys in the USA on drugs or something or is it that its just late for you guys over there:-) IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Help creating ODBC connection with MySql under Linux
Wow... for someone who was just slinging two-fisted criticism you really left yourself wide open... :-) I'd hazard a guess that he's talking about on Linux... since his subject and entire message is all about Linux... At 04:02 PM 10/30/00 +1100, Scott, Andrew wrote: Is this under NT or unix, I found under Solaris at least that you need to also had to the ini file in one of the directories as well. Not sure under NT as I have not used mySQL under NT:-) regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: 30 October 2000 15:38 To: CF-Talk Subject: Re: Help creating ODBC connection with MySql under Linux on 10/30/00 2:29 PM, Phil Labonte at [EMAIL PROTECTED] wrote: Am I doing something wrong? I left everything as the default all I typed in was the database name You have to use the advanced button in the CF administrator and make sure you have added the user/password than you use to connect to mySQL and that that user/pass has the appropriate privileges in mySQL. Make sure you have also entered a datasource name as well as the database name. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803rid=972879910type=A Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: tree structure
Your going to need a recursive custom tag to do this. Here is a quick and dirty way to do it... --page.cfm-- cf_deletetree node="234" --deletetree.cfm-- cfquery name="data" SELECT catid from tbl WHERE parent = #attributes.node# /cfquery cfif data.recordcount !--- recursive call --- cf_deletetree node="#data.catid#" /cfif -- __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com -Original Message- From: Anuj Gakhar [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 1:02 AM To: CF-Talk Subject: tree structure I have got a databse table like this: catid category parent 1 auto 0 2 autos1 1 3 autos2 2 4 autos3 3 5 autos4 0 6 autos5 0 7 autos6 5 and so on .i can add and delete categories from the table from another template i have made... what i want is to make a tree structure of all the categories like this --auto --autos1 --autos2 --autos3 --autos4 --autos5 --autos6 this tree structure should come dynamically and any no. of categories i add should be displayed here. i tried to do this but i got mixed up with cfloop and cfoutput and i dont have that much time to work on it can anybody please help me out of this. P.S There can be any no. of categories under another category ..so dont think that there is only one subcategory under another category. I hope i get a solution for this here thanks in advance... _ Do You Yahoo!? Get your free @yahoo.com address at ttp://mail.yahoo.com -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HTML Editor
Deepak, Activedit 2.0 will be released this week, One of the main features is that it can be used in a form, thus can be used as Spectra's cfa_htmleditor The syntax is a bit different, but it does the same thing... cf_activedit fieldname="form_field" ...etc. This is where the value goes, just like a textarea. /cf_activedit Vs. cfa_htmleditor name="form_field" form="FormNameNotRequiredInActivedit" value="etc..." __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com -Original Message- From: Deepak Agarwal [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 11:50 AM To: CF-Talk Subject: HTML Editor Can anyone suggest me a good HTML Editor tag, that can be used in cfm = templates/Spectra. Thanks in advance. Deepak 703.633.4257 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Quick Question - Size Limit?
is there a size limit for client, application and session? if yes, what's the limit line? i'm dying for the answer rgds, - rudy Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: HTML Editor
on 10/30/00 4:35 PM, Pete Freitag at [EMAIL PROTECTED] wrote: Deepak, Activedit 2.0 will be released this week, One of the main features is that it can be used in a form, thus can be used as Spectra's cfa_htmleditor The syntax is a bit different, but it does the same thing... No chance of it working in Mac/Linux and Netscape clients? We have had problems with all these "active" HTML editors with anything other than IE/Win which effectively makes them useless for many customer intranets. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Online CF training!
I've just launched a new tool on SecretAgents.com: Online CF Training that EVERY CF developer can afford! $10 for a years subscription, view as many viewlets as you want. It's easier than watching TV, and cheaper! http://www.secretagents.com/products/index.cfm?fuseaction=productproduct_id=6 Steve Nelson Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Hard Break
Quick Question: Anyone know how to enter a hard break to a text file using CF functions or variable. I have a comma delimeted output and need to create a hard break for more than one record to export. Code: cfset rightnowtime = #Timeformat(Now(), "HHmmss")# CFSET thisListHeadings=ArrayToList(ArrayHeadings, ",") CFSET thisList=ArrayToList(ArrayData, ",") cfset rightnowdate = #Dateformat(Now(), "mmdd")# CFFILE ACTION="WRITE" FILE="D:\out\#rightnowdate##rightnowtime#.txt" OUTPUT="#thisList#" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: HTML Editor
We incorporated a good one for our webbased email program... go to lasvegas.com and sign up for free email It works in both browsers great - Original Message - From: Rob Keniger [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 11:46 PM Subject: Re: HTML Editor on 10/30/00 4:35 PM, Pete Freitag at [EMAIL PROTECTED] wrote: Deepak, Activedit 2.0 will be released this week, One of the main features is that it can be used in a form, thus can be used as Spectra's cfa_htmleditor The syntax is a bit different, but it does the same thing... No chance of it working in Mac/Linux and Netscape clients? We have had problems with all these "active" HTML editors with anything other than IE/Win which effectively makes them useless for many customer intranets. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Quick Question - Size Limit?
depends how they are stored: Memory: Memory dependand Database: Hard Drive Space Registry: Memory Did I forget anything! -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: Monday, 30 October 2000 5:34 PM To: CF-Talk Subject: Quick Question - Size Limit? is there a size limit for client, application and session? if yes, what's the limit line? i'm dying for the answer rgds, - rudy Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Quick Question - Size Limit?
HAHAHAH HAI RUDY SIZE LIMIT IS 255 CHARS FOR CLIENT V THANX RAMESH -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 2:34 PM To: CF-Talk Subject: Quick Question - Size Limit? is there a size limit for client, application and session? if yes, what's the limit line? i'm dying for the answer rgds, - rudy Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Hard Break
try something like this: cfset vRecord = vRecord Chr(13) Chr(10) Keith Meade www.kmweb.com - Original Message - From: "Brian bouldernet" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 30, 2000 2:10 AM Subject: Hard Break : Quick Question: : Anyone know how to enter a hard break to a text file using CF functions or : variable. I have a comma delimeted output and need to create a hard break : for more than one record to export. : Code: : : cfset rightnowtime = #Timeformat(Now(), "HHmmss")# : CFSET thisListHeadings=ArrayToList(ArrayHeadings, ",") : CFSET thisList=ArrayToList(ArrayData, ",") : cfset rightnowdate = #Dateformat(Now(), "mmdd")# : CFFILE ACTION="WRITE" FILE="D:\out\#rightnowdate##rightnowtime#.txt" : OUTPUT="#thisList#" : : --- - : Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ : Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]