RE: Hi - Lists- Viewing 2 values at a time !!!
cfloop from=1 to=#Evaluate(ListLen(list) - 1)# step=2 index=i #ListGetAt(list, i)# / #ListGetAt(list, i + 1)# /cfloop That should do it. At 07:15 PM 5/20/2002 -0500, you wrote: Hi, I am looking for a List. is there any possibility of outputting the list like: 1 2 3 4 5 6 When the list has 1,2,3,4,5,6 as its contents. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Online CSS editors ?
I am looking for a way that I can allow site admins to edit CSS styles to effect the look of a site, or page etc. It needs to be edited online. Basically I want soEditor but for editing CSS styles instead of html :-) Anybody seen anything like this around ? --- James Sleeman __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MX in distributed mode?????
Thanks Stacy. I did post on the beta forum as well and got a reply that this would come with the J2EE versions, but it may have been that I didn't ask the right question (see below). doesn't conclusively say you can't do it, just that the J2EE version will implement it properly. I am using IIS unfortunately and it seems more involved than for Apache. I'm sure that for IIS the process must have changed, it used to involve ini files that of-course aren't there anymore. Thanks again I'll post if I get anymore info. I asked: Does that mean that NEO can run on top of a JRUN4 installation on another server? In other words in distributed mode with the app server separate from the web server? The answer: I asked product marketing and the answer is: CFMX for J2EE is a separate version that will come out after the release of the CFMX Server. We will have more details about the features of CF MX for JRun as we go into beta next month. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 19:20 To: CF-Talk Subject: RE: MX in distributed mode? Ok I was curious myself ;) http://livedocs.macromedia.com/jrun4docs/JRun_Administrators_Guide/connector s4.jsp#1124835 I believe you should be able to manually edit an equivalent file on the CFMX install. Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:16 PM To: CF-Talk Subject: RE: MX in distributed mode? Checkout the JRun install guide, should give ya the answer! http://livedocs.macromedia.com/jrun4docs/ -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:36 PM To: CF-Talk Subject: RE: MX in distributed mode? We use CF5 in distributed mode at the moment...and we're moving to CFMX. I can't confirm 100% but all you have to do is configure the apache module to farm out all jsp/cfm/cfc requests to the app server IP address rather than localhost:55000 or whatever it is normally. As for IIS configuration I'm not sure :( Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:09 AM To: CF-Talk Subject: MX in distributed mode? From a previous post I know that CF5 could be run in distributed mode, and that this was only done to satisfy security requirements. Well that's what I need to do. But I wondered what the process might be to manage this for MX? I assume it must be a different process. Can't find anything in the docs. I also assume that when the J2EE versions come out that can sit directly on top of for example the full version of JRun or WebSphere, this will be standard? What will the general architecture model be? Anyone at Macromedia point me in the right direction? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query help
How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
XML Design
All, Would someone know of a good list to post questions concerning XML document design? Maybe some of you might have some comments to add. Either way, I would appreciate other points of views to my approach. I'm trying to represent a hierarchical data structure in an XML document. In this case I am dealing with geographical regions. For example, Solar system could be the root region which contains planets, open space, etc. Then next could be planet Earth. The planet Earth contains continents and oceans like North American and the Pacific Ocean. Then North America contain Canada and United States. The United States contains North Carolina, Georgia. Georgia contains Cobb County, Fulton County. Fulton County contains Metro Atlanta. Metro Atlanta Contains Buckhead neighborhood. Etc, Etc, Etc. So theoretically my Region Path to the High Museum of Art in Atlanta, Georgia would be: \\ High Museum of Art \\ Atlanta \\ Georgia \\ United States \\ North America \\ Earth \\ Solar System \\ Universe \\ Root In order to represent this in an XML document I have considered this approach: ?xml version=1.0? region rid=0 regiontype=Root rcutter=R000Root region rid=1000 regiontype=astronomical object rcutter=U304Universe region rid=1010 regiontype=astronomical object rcutter=S682Solar System region rid=1001 regiontype=astronomical objects rcutter=E010Earth region rid=300 regiontype=continent rcutter=N823North America region rid=269 regiontype=country rcutter=F715United States region rid=316 regiontype=state (US) rcutter=G256Georgia region rid=1103 regiontype=city rcutter=A861Atlanta region rid=1253 regiontype=museum rcutter=High Museum of Art /region /region /region /region /region /region /region /region /region Here is my concern. Even though this may be good form, these elements are of Mixed Type Elements in which they contain both PCDATA and Elements. I personally would like to stay clear from Mixed type Elements in an XML document if possible. This is do to personal preference and what I read in the book XML Unleashed by Michael Morrison, et al. that provided disadvantages to using this type of markup. I would appreciate another set of eyes to point out the flaws/advantages in this design. I do truely appreciate your comments. Sincerely, Troy -- - Troy Simpson Applications Analyst/Programmer, MCSE, OCP-DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MX in distributed mode?????
Thanks Stacy. I did post on the beta forum as well and got a reply that this would come with the J2EE versions, but it may have been that I didn't ask the right question (see below). doesn't conclusively say you can't do it, just that the J2EE version will implement it properly. I am using IIS unfortunately and it seems more involved than for Apache. I'm sure that for IIS the process must have changed, it used to involve ini files that of-course aren't there anymore. Thanks again I'll post if I get anymore info. I asked: Does that mean that NEO can run on top of a JRUN4 installation on another server? In other words in distributed mode with the app server separate from the web server? The answer: I asked product marketing and the answer is: CFMX for J2EE is a separate version that will come out after the release of the CFMX Server. We will have more details about the features of CF MX for JRun as we go into beta next month. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 19:20 To: CF-Talk Subject: RE: MX in distributed mode? Ok I was curious myself ;) http://livedocs.macromedia.com/jrun4docs/JRun_Administrators_Guide/connector s4.jsp#1124835 I believe you should be able to manually edit an equivalent file on the CFMX install. Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:16 PM To: CF-Talk Subject: RE: MX in distributed mode? Checkout the JRun install guide, should give ya the answer! http://livedocs.macromedia.com/jrun4docs/ -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:36 PM To: CF-Talk Subject: RE: MX in distributed mode? We use CF5 in distributed mode at the moment...and we're moving to CFMX. I can't confirm 100% but all you have to do is configure the apache module to farm out all jsp/cfm/cfc requests to the app server IP address rather than localhost:55000 or whatever it is normally. As for IIS configuration I'm not sure :( Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:09 AM To: CF-Talk Subject: MX in distributed mode? From a previous post I know that CF5 could be run in distributed mode, and that this was only done to satisfy security requirements. Well that's what I need to do. But I wondered what the process might be to manage this for MX? I assume it must be a different process. Can't find anything in the docs. I also assume that when the J2EE versions come out that can sit directly on top of for example the full version of JRun or WebSphere, this will be standard? What will the general architecture model be? Anyone at Macromedia point me in the right direction? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFError Problem
What would cause cferror type=EXCEPTION template=error.cfm to not work in a CF5 application. I have this exact same tag working fine in other applications, but on one client's site I wanted to add this in so that the application would email me all the errors and have a friendly error page, but it just ignores it as though I didn't even have it in there. Anyone run into this? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Hi fellows, i looking for some advice on migrating websites of one of my customers from windows to linux. The customers has it's own CF4.5Pro-Server and 'cause he switched his entire office to linux he's also chenging the webserver to linux with apache. The nice thing is, that is will purchase/update to CF5 or MX. Now my question is will the applications i wrote under Windows+Access run under Linux+MySQL without bigger problems??? i have a event-calendar-app which will probably make no trouble. but i have a little shopping-cart-like app with session-vars and a full-text-search with verity. So if anyone can share experience i would be really glad for any input! TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
Kris, In your Stored Proc you can use one of SQL's own variables @@identity to get the row id for the record you have just inserted. Simply assign @@identity to a local var et voilà! HTH Stephen DECLARE @id as int INSERT INTO tableFoo (Col1,Col2,Col3) VALUES (a,b,c) SELECT @@identity = @id SELECT @id -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 14:06 To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
almost! instead of SELECT @@identity = @id you need SELECT @id = @@identity -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 15:14 To: CF-Talk Subject: RE: Query help Kris, In your Stored Proc you can use one of SQL's own variables @@identity to get the row id for the record you have just inserted. Simply assign @@identity to a local var et voilà! HTH Stephen DECLARE @id as int INSERT INTO tableFoo (Col1,Col2,Col3) VALUES (a,b,c) SELECT @@identity = @id SELECT @id -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 14:06 To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sharing sessions due to url.cfid and url.token
I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
Just keeping you on your toes Boss! -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 15:18 To: CF-Talk Subject: RE: Query help almost! instead of SELECT @@identity = @id you need SELECT @id = @@identity -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 15:14 To: CF-Talk Subject: RE: Query help Kris, In your Stored Proc you can use one of SQL's own variables @@identity to get the row id for the record you have just inserted. Simply assign @@identity to a local var et voilà! HTH Stephen DECLARE @id as int INSERT INTO tableFoo (Col1,Col2,Col3) VALUES (a,b,c) SELECT @@identity = @id SELECT @id -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 14:06 To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
If you are using SQL server you can encase your query in a cftransaction tag and then after your query, SELECT @@identity FROM tbljustinsertedto I don't believe access supports this, however, you could just SELECT MAX(id) from tbljustinsertedto and that should be that last id. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:06 AM To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
you actually don't need a stored proc for this CFQUERY NAME=foo bar, etc SET NOCOUNT ON; INSERT ... SELECT @@Identity as newid; SET NOCOUNT OFF; /CFQUERY now foo.newid will be your new ID. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:14 AM To: CF-Talk Subject: RE: Query help Kris, In your Stored Proc you can use one of SQL's own variables @@identity to get the row id for the record you have just inserted. Simply assign @@identity to a local var et voilà! HTH Stephen DECLARE @id as int INSERT INTO tableFoo (Col1,Col2,Col3) VALUES (a,b,c) SELECT @@identity = @id SELECT @id -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 14:06 To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query help
If you are doing an autonumber type deal, just do the following insert stuff cfquery datasource=dsn name=getid select MAX(id) from tablename /cfquery That should do it for ya! Paul Giesenhagen QuillDesign - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 8:05 AM Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Question on Email Addresses
well consider that, it did not work. The ReReplace function did nothing. Randy Adkins [EMAIL PROTECTED] 05/20/02 16:37 PM CFSET email=myname [EMAIL PROTECTED] cfset x=reReplaceNoCase(email,.*(.*).*,\1) CFOUTPUT#x#/CFOUTPUT On Mon, 20 May 2002, Randell B Adkins wrote: I am trying to parse an email address due to the friendly email addresses by using CFPOP. If the #FROM# resembles: [EMAIL PROTECTED] then I am fine however since there are friendly email address which look like myname [EMAIL PROTECTED] then I have to use HTMLEditFormat to get the email address. However using this code, does not FIND the in the email addresses that are Friendly however it will fine the @ symbol. What am I missing??? cfset checkEmail = #HTMLEditFormat(from)# cfif #FindNoCase(,checkEmail,1)# Email Start Point Located cfelse !--- Use CheckEmail --- If it is a Friendly Email Address then When I validate this in the DB, it looks for the entire string myname [EMAIL PROTECTED] and NOT just the email address. /cfif sorry I am just not with it today to think about it any longer and I know it is something so dang simple that I am just overlooking... Thanks in Advance! NO - #findnocase(@,checkEmail,1)# - /cfif #LEN(checkEmail)# br /cfoutput __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP Question
I have two questions regarding the query columns returned from using CFPOP. 1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? 2. Any idea on how to grab the NEW MESSAGE and NOT the replied message. Meaning if this is a reply to an original message I do not want the original message but the NEW message. ANY IDEAS ON THIS? Thanks! __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom warning this page has expired page?
Hi sorry for the OT post but I'm sure some of you may have desired this at one time or another. I would like to know if its possible to change the page displayed when ie Displays the warning page has expired message. If I search the registry I find a key called postNotCached But it points to a dll I think, the data held in this key is: Res://mshtml.dll/repost.htm Does this mean that the page is generated by the mshtml dll? As I cant find the page anywhere on my machine by doing a search. What does the res:// path mean? Any pointers or suggestions woule really be appreciated - this is for an internal application so I know the end browser will be IE 5+ Thanks in advance Kola __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Design
Disadvantages? What you have now is hard to read. Just focusing on tags and IDs, how about the good 'ol: planet id=Earth continent id=North America country id=United States state id=Georgia city id=Atlanta on and on I find that easier to read than 100+ region tags. I guess that is personal preference. -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:13 AM To: CF-Talk Subject: XML Design All, Would someone know of a good list to post questions concerning XML document design? Maybe some of you might have some comments to add. Either way, I would appreciate other points of views to my approach. I'm trying to represent a hierarchical data structure in an XML document. In this case I am dealing with geographical regions. For example, Solar system could be the root region which contains planets, open space, etc. Then next could be planet Earth. The planet Earth contains continents and oceans like North American and the Pacific Ocean. Then North America contain Canada and United States. The United States contains North Carolina, Georgia. Georgia contains Cobb County, Fulton County. Fulton County contains Metro Atlanta. Metro Atlanta Contains Buckhead neighborhood. Etc, Etc, Etc. So theoretically my Region Path to the High Museum of Art in Atlanta, Georgia would be: \\ High Museum of Art \\ Atlanta \\ Georgia \\ United States \\ North America \\ Earth \\ Solar System \\ Universe \\ Root In order to represent this in an XML document I have considered this approach: ?xml version=1.0? region rid=0 regiontype=Root rcutter=R000Root region rid=1000 regiontype=astronomical object rcutter=U304Universe region rid=1010 regiontype=astronomical object rcutter=S682Solar System region rid=1001 regiontype=astronomical objects rcutter=E010Earth region rid=300 regiontype=continent rcutter=N823North America region rid=269 regiontype=country rcutter=F715United States region rid=316 regiontype=state (US) rcutter=G256Georgia region rid=1103 regiontype=city rcutter=A861Atlanta region rid=1253 regiontype=museum rcutter=High Museum of Art /region /region /region /region /region /region /region /region /region Here is my concern. Even though this may be good form, these elements are of Mixed Type Elements in which they contain both PCDATA and Elements. I personally would like to stay clear from Mixed type Elements in an XML document if possible. This is do to personal preference and what I read in the book XML Unleashed by Michael Morrison, et al. that provided disadvantages to using this type of markup. I would appreciate another set of eyes to point out the flaws/advantages in this design. I do truely appreciate your comments. Sincerely, Troy -- - Troy Simpson Applications Analyst/Programmer, MCSE, OCP-DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Question on Email Addresses
We do a fair amount of parsing of email addresses for our http://www.spamex.com service and found that the regex to properly parse email and remain RFC compliant is actually about 1 page long (we found it published somewhere). We ended up not going the regex way due to the complexity and just parsing the email address one character at a time to isolate the email address. Not as elegant but much easier. Justin -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 4:13 PM To: CF-Talk Subject: Re: Question on Email Addresses CFSET email=myname [EMAIL PROTECTED] cfset x=reReplaceNoCase(email,.*(.*).*,\1) CFOUTPUT#x#/CFOUTPUT On Mon, 20 May 2002, Randell B Adkins wrote: I am trying to parse an email address due to the friendly email addresses by using CFPOP. If the #FROM# resembles: [EMAIL PROTECTED] then I am fine however since there are friendly email address which look like myname [EMAIL PROTECTED] then I have to use HTMLEditFormat to get the email address. However using this code, does not FIND the in the email addresses that are Friendly however it will fine the @ symbol. What am I missing??? cfset checkEmail = #HTMLEditFormat(from)# cfif #FindNoCase(,checkEmail,1)# Email Start Point Located cfelse !--- Use CheckEmail --- If it is a Friendly Email Address then When I validate this in the DB, it looks for the entire string myname [EMAIL PROTECTED] and NOT just the email address. /cfif sorry I am just not with it today to think about it any longer and I know it is something so dang simple that I am just overlooking... Thanks in Advance! NO - #findnocase(@,checkEmail,1)# - /cfif #LEN(checkEmail)# br /cfoutput __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
It depends on the db vendor and the primary key type (if it's anything other than an int it is a little more tricky). In SQL Server you can use the @@Identity immediately after the insert. It will return the last primary key (as long is it is an identity) which was inserted. There are some things to be careful of when using @@Identity, but it is fairly straightforward. Check Books Online for more detail. In Access, AFAIK there is not an equivalent operator. What I usually do is select max(pk_id) from table where data = 'whatever I just inserted' That approach obviously has some pitfalls as well, but in practice it works pretty well. In Oracle, most likely you'd be using sequences, and can get the value out of the sequence before the insert. But in that case you probably wouldn't be asking the question ;) /rob -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:06 AM To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFError Problem
Actually, I just ran into the same thing yesterday. Still working on a cause. Pete - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 8:40 AM Subject: CFError Problem What would cause cferror type=EXCEPTION template=error.cfm to not work in a CF5 application. I have this exact same tag working fine in other applications, but on one client's site I wanted to add this in so that the application would email me all the errors and have a friendly error page, but it just ignores it as though I didn't even have it in there. Anyone run into this? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sharing sessions due to url.cfid and url.token
Sure, you can check their ip if you know its going to be unique(not neccessarily true accross firewalls). You can keep a random var cookie on their machine which matches a session or client var on the server, if they dont match or it doesnt exist, then they swapped links. DRE -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:19 AM To: CF-Talk Subject: sharing sessions due to url.cfid and url.token I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_HierMenus
The newer versions of Hier Menus do but, you have to buy the license for this. The freeway versions tend to fall over on NS 6. Darren Adams Web Developer Mob:07759 965523 Office:01252 556220 Data + Structure = Information -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED]] Sent: 28 April 2002 02:26 To: CF-Talk Subject:Re: CF_HierMenus Does hiermenu work in IE and NS? - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 27, 2002 8:59 PM Subject: RE: CF_HierMenus The coding is a bit of a pain, but do-able. I wrote CF_MenuMonger to do the job. You can get it in the Exchange. http://makeashorterlink.com/?Q39E264C It should still work with current HierMenus code, although you may need to tweak it a tad. Was written for v4.1. I tried to use CF_HierMenus first myself, and got it to work, but that tag builds an entire HierMenus setup from scratch on every page view. Its passing so many parameters that performance suffers badly as a result. MenuMonger assumes static menu parameters and only tries to db-drive menu choices. Performance is in the 60-80ms range as a result (all exec times are from my dirt-slow dev server). A cached query helps a LOT, BTW. Hope you have lots of cash for the required HierMenus license. Milonic menus are MUCH cheaper and faster. I did a tag for that menu system, too. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 27, 2002 4:30 PM To: CF-Talk Subject: CF_HierMenus CF_HierMenus I've been trying to use this tag for a few days now and can't seem to figure out how to populate it from a database. ...ANY cfml in the middle of the tag seems to blow it up. Anyone using this tag successfully??? Throw me a bone ;-) Thanks guys, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Updating a form from a pop up window
Hi guys I'm building a content control system where new products are added or updated via a form. I want the users to be able to upload images. I'm storing the image name in the DB along with the other porduct details. The plan is to use a sub window whihc allows the users to upload a new image using CFFILE and then retrive the filename with the serverFile param. I wonderd if there were any quick ways of updating the master form with the new image name. I'm guessing the answer is some Javascript and DHTML. I suppose I'd better also set the value of a hidden control and then pass that along with the regular text inputs to the action page whihc will insert/update the DB? And I hate debugging JavaScript. Anyone have any better ideas? regards Steve Steve Powell 07971 583 792 [EMAIL PROTECTED] FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
port 1433 scans..heads up
for those of us w/sql server backends: not sure if anyone's noticed but Dshield, bugTraq and a few virus/security firms have reported higher than normal scans on port 1433. if your sql box is hanging out there not patched, now might be a good time to get it done Paul Hastings [EMAIL PROTECTED] DirectorEnvironmental Information Center Thailand Environment Institute Member Team Macromedia (Allaire) http://www.tei.or.th/eic --- __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sharing sessions due to url.cfid and url.token
That would be a good idea if most of the users weren't exactly behind firewalls... and usually they send the link to another user behind the same firewall :( -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:24 AM To: CF-Talk Subject: RE: sharing sessions due to url.cfid and url.token Sure, you can check their ip if you know its going to be unique(not neccessarily true accross firewalls). You can keep a random var cookie on their machine which matches a session or client var on the server, if they dont match or it doesnt exist, then they swapped links. DRE -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:19 AM To: CF-Talk Subject: sharing sessions due to url.cfid and url.token I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFError Problem
Do you have any code in your application.cfm besides the cferror? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:35 AM To: CF-Talk Subject: Re: CFError Problem Actually, I just ran into the same thing yesterday. Still working on a cause. Pete - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 8:40 AM Subject: CFError Problem What would cause cferror type=EXCEPTION template=error.cfm to not work in a CF5 application. I have this exact same tag working fine in other applications, but on one client's site I wanted to add this in so that the application would email me all the errors and have a friendly error page, but it just ignores it as though I didn't even have it in there. Anyone run into this? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPOP Question
1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? ParseDateTime(Date, POP) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sharing sessions due to url.cfid and url.token
About the only thing I can think of is to add some code to your App.cfm file which checks for the existence of CFID and CFTOKEN as URL variables and if found, just redirect to the same page minus the session info on the url line. Of course this assumes you don't ever pass the session info in the url. /rob -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:19 AM To: CF-Talk Subject: sharing sessions due to url.cfid and url.token I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query help
What database? What are you using as a primary key (an ID number)? On Tue, 21 May 2002, Kris Pilles wrote: How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPOP Question
1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? I use a cfx tag, cfx_pop3date, for this. As far as I know custom solutions are the only solutions in this case. cfx_pop3date will get both the date and the time for you. However, it doesn't *always* work, so I've had to wrap it in cftry to prevent errors. 2. Any idea on how to grab the NEW MESSAGE and NOT the replied message. Meaning if this is a reply to an original message I do not want the original message but the NEW message. ANY IDEAS ON THIS? I don't understand what you're asking here. Can you elaborate? -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPOP Question
Thanks.. any idea on the 2nd question? [EMAIL PROTECTED] 05/21/02 10:45 AM 1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? ParseDateTime(Date, POP) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MX in distributed mode?????
There's a technote in the works that will give all the instructions for setting up in distributed mode with CFMX. As Stacy mentioned, it's not much more than using the steps for configuring JRun to run in distributed mode. Deb -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:36 PM To: CF-Talk Subject: RE: MX in distributed mode? We use CF5 in distributed mode at the moment...and we're moving to CFMX. I can't confirm 100% but all you have to do is configure the apache module to farm out all jsp/cfm/cfc requests to the app server IP address rather than localhost:55000 or whatever it is normally. As for IIS configuration I'm not sure :( Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:09 AM To: CF-Talk Subject: MX in distributed mode? From a previous post I know that CF5 could be run in distributed mode, and that this was only done to satisfy security requirements. Well that's what I need to do. But I wondered what the process might be to manage this for MX? I assume it must be a different process. Can't find anything in the docs. I also assume that when the J2EE versions come out that can sit directly on top of for example the full version of JRun or WebSphere, this will be standard? What will the general architecture model be? Anyone at Macromedia point me in the right direction? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Visual Studio
Greetings, We have a bug in our web application, Visual Studio is creating vti_cnf folders inside directories, I have tried some error handling to account for this, ... CFIF deleteFolderContents.name CONTAINS(vti_cnf) CFDIRECTORY action=list DIRECTORY=#REQUEST.logPath##SESSION.CUSTOMERNAME#\#folderSelectArray[j]#\vt i_cnf NAME=ERRORHandler SORT=DateLastModified desc //The vti_cnf Directory contains a copy of all files that are contained in the directory //I am deleting //If I do, CFLOOP QUERY=ERRORHandler STARTROW=1 ENDROW=#ERRORHandler.RECORDCOUNT# #ERRORHandler.NAME#BR /CFLOOP //nothing is returned, but there are 20 or so files in there, so obviously when I try to delete, //nothing happens either. /CFIF ...continue any thoughts on this would be appreciated, Respectfully j __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
Access. Yeah autonumber field... I've never done this before seems like it would be a simple task -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:29 AM To: CF-Talk Subject: Re: Query help What database? What are you using as a primary key (an ID number)? On Tue, 21 May 2002, Kris Pilles wrote: How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Migrating from CF4.5+WinNT to CF5(or MX)/Linux
I've done this on 5 projects, now. The three things that bit me repeatedly: Boolean types in Access were not the same in mySQL. Went with int (1/0). Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) But it really wasn't very difficult. Jerry Johnson [EMAIL PROTECTED] 05/21/02 08:33AM Hi fellows, i looking for some advice on migrating websites of one of my customers from windows to linux. The customers has it's own CF4.5Pro-Server and 'cause he switched his entire office to linux he's also chenging the webserver to linux with apache. The nice thing is, that is will purchase/update to CF5 or MX. Now my question is will the applications i wrote under Windows+Access run under Linux+MySQL without bigger problems??? i have a event-calendar-app which will probably make no trouble. but i have a little shopping-cart-like app with session-vars and a full-text-search with verity. So if anyone can share experience i would be really glad for any input! TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Online CSS editors ?
James I am looking for a way that I can allow site admins to edit CSS styles to effect the look of a site, or page etc. It needs to be edited online. Basically I want soEditor but for editing CSS styles instead of html :-) Anybody seen anything like this around ? Yes, I have one I built, drop me a line if you're still looking. Nick __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Custom warning this page has expired page?
AFAIK it loads the page from the resource which is held in mshtml.dll. therefore the res:// means that it will try and load the resource repost.htm from the mshtml.dll. To change the default i would assume that you will need to change the registry entry to point to either a file:// or a http:// address... although i could be wrong HTH Kola Oyedeji wrote: Hi sorry for the OT post but I'm sure some of you may have desired this at one time or another. I would like to know if its possible to change the page displayed when ie Displays the warning page has expired message. If I search the registry I find a key called postNotCached But it points to a dll I think, the data held in this key is: Res://mshtml.dll/repost.htm Does this mean that the page is generated by the mshtml dll? As I cant find the page anywhere on my machine by doing a search. What does the res:// path mean? Any pointers or suggestions woule really be appreciated - this is for an internal application so I know the end browser will be IE 5+ Thanks in advance Kola __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem writing query result to file
Nevermind... The process is to be run by only one person, so it doesn't protect against multiple people running at the same time. The person double-clicked the link, causing the process to run twice simultaneously, creating the issue. If it continues to happen, I'll use unique file names to eliminate the problem. Thanks again, Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 6:00 PM To: CF-Talk Subject: RE: Problem writing query result to file I think you'd have two choices... 1. CFLOCK the cffile action=append... tag (not recommended) 2. build up a string in the CFOUTPUT then do a single CFFILE ACTION=write... Both options will fix your problem, but the second one will be MUCH faster (assuming you are not memory constrained) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Steven Monaghan [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:28 PM To: CF-Talk Subject: Problem writing query result to file I am using CFFILE to create a file using write and then append about 10,000 lines to the file by using cfoutput over a set of query results. Sporadically in the file, it puts two sets of data on the same line, and leaves the next line blank. It happens a few dozen times in this 10,000 line file, so I can't ignore it. Has anyone ever seen this behavior? Any remedies? I am running CF5 on Solaris. Thanks, Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP Question
I have two questions regarding the query columns returned from using CFPOP. 1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? 2. Any idea on how to grab the NEW MESSAGE and NOT the replied message. Meaning if this is a reply to an original message I do not want the original message but the NEW message. ANY IDEAS ON THIS? Thanks! __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPOP Question
Not off hand, sorry. :( Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:48 AM To: CF-Talk Subject: RE: CFPOP Question Thanks.. any idea on the 2nd question? [EMAIL PROTECTED] 05/21/02 10:45 AM 1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? ParseDateTime(Date, POP) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: mySQL vs. Access
My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
Almost all the answers are MS SQL-centric. Not sure what type of development house you work in, but MS-SQL centric answers are not a valid solution for some of us. Both Oracle and MS SQL have several methods to retrieve the last primary key in a particular table. I won't bore you with my opinion which I think is a better and more elegant solution as both are effective. If you want to be able to 100% retrieve the last record you inserted into any DB system simply use a dateTime Stamp. Do a select against the inserted fields and the datetimestamp. If you need sample code, email me off the list and I will cut and paste something for you. Won Lee __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problems installing a cfx dll
Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Updating a form from a pop up window (Frames)
Can the same methodology be used to update a frame and/or frames from a pop-up window? -Original Message- From: Gary Groomer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:03 AM To: CF-Talk Subject: Re: Updating a form from a pop up window Steve, I just went through this for a shopping cart that I developed. Here is the code that I used. !-- Post Form Data from PopUp Window to Frame and Close PopUp -- SCRIPT TYPE=text/javascript !-- // Link the Popup Window Back to the Opener function targetopener(mylink, closeme, closeonly) { if (! (window.focus window.opener))return true; window.opener.focus(); if (! closeonly)window.opener.location.href=mylink.href; if (closeme)window.close(); return false; } //-- /SCRIPT !-- Post Form Data by Page Name and Frame Name and Close PopUp Window -- form action=../dsp_footer.cfm target=footer method=post input type=IMAGE src=images/addtoc.gif border=0 onClick=javascript:window.close(); /form I hope it helps, Gary Groomer - Original Message - From: Steve Powell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 7:36 AM Subject: Updating a form from a pop up window Hi guys I'm building a content control system where new products are added or updated via a form. I want the users to be able to upload images. I'm storing the image name in the DB along with the other porduct details. The plan is to use a sub window whihc allows the users to upload a new image using CFFILE and then retrive the filename with the serverFile param. I wonderd if there were any quick ways of updating the master form with the new image name. I'm guessing the answer is some Javascript and DHTML. I suppose I'd better also set the value of a hidden control and then pass that along with the regular text inputs to the action page whihc will insert/update the DB? And I hate debugging JavaScript. Anyone have any better ideas? regards Steve Steve Powell 07971 583 792 [EMAIL PROTECTED] FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems installing a cfx dll
When you say installed, did you use regsvr32.exe ? I'm not 100% if this is necessary... but it might be. :) Eric -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:28 AM To: CF-Talk Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPOP Question
The 2nd question is when you send an email to someone and then they reply to that message, it now contains their NEW message as well as the original message such as: THIS IS NEW THIS IS PART OF THE OLD MESSAGE It will also contain the HEADER information. What I am attempting is to parse the OLD stuff out and just GRAB the new message in which they are conveying. Randy Adkins [EMAIL PROTECTED] 05/21/02 10:48 AM 1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? I use a cfx tag, cfx_pop3date, for this. As far as I know custom solutions are the only solutions in this case. cfx_pop3date will get both the date and the time for you. However, it doesn't *always* work, so I've had to wrap it in cftry to prevent errors. 2. Any idea on how to grab the NEW MESSAGE and NOT the replied message. Meaning if this is a reply to an original message I do not want the original message but the NEW message. ANY IDEAS ON THIS? I don't understand what you're asking here. Can you elaborate? -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problems installing a cfx dll
You don't use Regsvr32 on a CFX DLL. What he needs to do is make sure that the DLL is in the specified path and that any DLLs that are also required by the CFX are available as well. ColdFusion will complain that a CFX is missing when a required DLL is missing so you need to know if any other DLLs are required. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:31 AM Subject: RE: Problems installing a cfx dll When you say installed, did you use regsvr32.exe ? I'm not 100% if this is necessary... but it might be. :) Eric -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:28 AM To: CF-Talk Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems installing a cfx dll
No I did it through CFSERVER under Extensions/ CFXTags, would this matter, -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:31 PM To: CF-Talk Subject: RE: Problems installing a cfx dll When you say installed, did you use regsvr32.exe ? I'm not 100% if this is necessary... but it might be. :) Eric -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:28 AM To: CF-Talk Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
If we're talking SMALL small and software licencing is a concern, then Access will do the job as well. msSQL is preferable if budget permits, but Access is an ok substitute if there are fewer requests, smaller tables, etc... Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:24 AM To: CF-Talk Subject: Re: mySQL vs. Access My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems installing a cfx dll
Thanks for the correction. Wasn't certain on that, but thought it was worth mentioning. :) -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: Re: Problems installing a cfx dll You don't use Regsvr32 on a CFX DLL. What he needs to do is make sure that the DLL is in the specified path and that any DLLs that are also required by the CFX are available as well. ColdFusion will complain that a CFX is missing when a required DLL is missing so you need to know if any other DLLs are required. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:31 AM Subject: RE: Problems installing a cfx dll When you say installed, did you use regsvr32.exe ? I'm not 100% if this is necessary... but it might be. :) Eric -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:28 AM To: CF-Talk Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: mySQL vs. Access
I prefer mySQL for intranets. Intranets, by definition, will be used by multiple people. The largest problem with Access is its inability to handle multiple concurrent users. If you have fears of using mySQL and prefer the GUI of Access you can buy myAccess for about $20. It essentially allows developers unfamiliar with mySQL to create and work in Access and then port it over to mySQL, data inclusive. As personal opinion goes, I find mySQL to be the best suited DB for my needs. You can directly telnet into the DB server from any remote location as long as the sys admins have given you access. It seems odd, but the mySQL community is very much like the CF community in that they are always willing to help and consists of a lot of very knowledgeable developers. Can't beat the price either! I've extensively used FoxPro, Access, MS SQL Server, Oracle, and MySQL. Of those, I can only seriously recommend MS SQL, Oracle and MySQL for any web application. Of the 3 mySQL is a happy medium. The learning curve and power is between MS SQL and Oracle. It lacks certain things such as subselects and transactions. Sub-selects are easily circumvented by using outer joins and due to the inherent speed advantage it enjoys over MS SQL my informal tests show that outer joins are faster on mySQL then sub-selects on SQL server. At 09:15 AM 5/21/2002 -0400, you wrote: Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Online CSS editors ?
Any chance we see this? At 10:59 AM 5/21/2002 -0400, you wrote: James I am looking for a way that I can allow site admins to edit CSS styles to effect the look of a site, or page etc. It needs to be edited online. Basically I want soEditor but for editing CSS styles instead of html :-) Anybody seen anything like this around ? Yes, I have one I built, drop me a line if you're still looking. Nick __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating a form from a pop up window (Frames)
This is what the below script does. In the example that I am referring to, the user clicks on a link in one frame, selects the quantity and item color in the PopUp. Upon clicking the submit button in the PopUp, the PopUp closes and posts the data back to another frame for addition to the users shopping cart. Gary Groomer - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 8:29 AM Subject: RE: Updating a form from a pop up window (Frames) Can the same methodology be used to update a frame and/or frames from a pop-up window? -Original Message- From: Gary Groomer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:03 AM To: CF-Talk Subject: Re: Updating a form from a pop up window Steve, I just went through this for a shopping cart that I developed. Here is the code that I used. !-- Post Form Data from PopUp Window to Frame and Close PopUp -- SCRIPT TYPE=text/javascript !-- // Link the Popup Window Back to the Opener function targetopener(mylink, closeme, closeonly) { if (! (window.focus window.opener))return true; window.opener.focus(); if (! closeonly)window.opener.location.href=mylink.href; if (closeme)window.close(); return false; } //-- /SCRIPT !-- Post Form Data by Page Name and Frame Name and Close PopUp Window -- form action=../dsp_footer.cfm target=footer method=post input type=IMAGE src=images/addtoc.gif border=0 onClick=javascript:window.close(); /form I hope it helps, Gary Groomer - Original Message - From: Steve Powell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 7:36 AM Subject: Updating a form from a pop up window Hi guys I'm building a content control system where new products are added or updated via a form. I want the users to be able to upload images. I'm storing the image name in the DB along with the other porduct details. The plan is to use a sub window whihc allows the users to upload a new image using CFFILE and then retrive the filename with the serverFile param. I wonderd if there were any quick ways of updating the master form with the new image name. I'm guessing the answer is some Javascript and DHTML. I suppose I'd better also set the value of a hidden control and then pass that along with the regular text inputs to the action page whihc will insert/update the DB? And I hate debugging JavaScript. Anyone have any better ideas? regards Steve Steve Powell 07971 583 792 [EMAIL PROTECTED] FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
I suppose the answers were MS centric but in my experience on this list if someone doesn't explicitly state which database they are using in a post, 99% of the time it will be Access or SQL Server so I suspect that's why the anwers were geared that direction. As I mentioned in an earlier response, if someone is using Oracle it is more likely then already know how do this since it requires a bit more knowledge up front. Your 100% solution really is no more reliable/portable than several of the suggestions which have been previously posted. From his mention of using an autonumber field it sounds like he's using MS Access, in which case I don't believe there even exists a datetimestamp column type. /rob -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:23 AM To: CF-Talk Subject: RE: Query help Almost all the answers are MS SQL-centric. Not sure what type of development house you work in, but MS-SQL centric answers are not a valid solution for some of us. Both Oracle and MS SQL have several methods to retrieve the last primary key in a particular table. I won't bore you with my opinion which I think is a better and more elegant solution as both are effective. If you want to be able to 100% retrieve the last record you inserted into any DB system simply use a dateTime Stamp. Do a select against the inserted fields and the datetimestamp. If you need sample code, email me off the list and I will cut and paste something for you. Won Lee __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
If we're talking SMALL small and software licencing is a concern, then Access will do the job as well What type of licensing concern would dictate Access over mySql? I would use mySql over access any day. -Craig Thomas __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Online CSS editors ?
I would like to see it work and maybe use it myself.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:35 AM To: CF-Talk Subject: Re: Online CSS editors ? Any chance we see this? At 10:59 AM 5/21/2002 -0400, you wrote: James I am looking for a way that I can allow site admins to edit CSS styles to effect the look of a site, or page etc. It needs to be edited online. Basically I want soEditor but for editing CSS styles instead of html :-) Anybody seen anything like this around ? Yes, I have one I built, drop me a line if you're still looking. Nick __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
In Access you can create a date/time field and create the ODBC datetime with a cf variable and check against that. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom warning this page has expired page?
Mike Thanks. I found the html for the page inside the mentioned dll in the winnt folder haven't tried to change it yet though. But actually changing the registry entry might be a better idea, thanks Kola -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 15:57 To: CF-Talk Subject: Re: Custom warning this page has expired page? AFAIK it loads the page from the resource which is held in mshtml.dll. therefore the res:// means that it will try and load the resource repost.htm from the mshtml.dll. To change the default i would assume that you will need to change the registry entry to point to either a file:// or a http:// address... although i could be wrong HTH Kola Oyedeji wrote: Hi sorry for the OT post but I'm sure some of you may have desired this at one time or another. I would like to know if its possible to change the page displayed when ie Displays the warning page has expired message. If I search the registry I find a key called postNotCached But it points to a dll I think, the data held in this key is: Res://mshtml.dll/repost.htm Does this mean that the page is generated by the mshtml dll? As I cant find the page anywhere on my machine by doing a search. What does the res:// path mean? Any pointers or suggestions woule really be appreciated - this is for an internal application so I know the end browser will be IE 5+ Thanks in advance Kola __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
Hm, if we're talking SMALL small then I would think you don't have to pay anything to use msSQL, right? -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: RE: mySQL vs. Access If we're talking SMALL small and software licencing is a concern, then Access will do the job as well. msSQL is preferable if budget permits, but Access is an ok substitute if there are fewer requests, smaller tables, etc... Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:24 AM To: CF-Talk Subject: Re: mySQL vs. Access My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: mySQL vs. Access
I mean mySQL! *looking for coffee cup* -Original Message- From: Hoag, Claudia (LNG) Sent: Tuesday, May 21, 2002 11:50 AM To: '[EMAIL PROTECTED]' Subject: RE: mySQL vs. Access Hm, if we're talking SMALL small then I would think you don't have to pay anything to use msSQL, right? -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: RE: mySQL vs. Access If we're talking SMALL small and software licencing is a concern, then Access will do the job as well. msSQL is preferable if budget permits, but Access is an ok substitute if there are fewer requests, smaller tables, etc... Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:24 AM To: CF-Talk Subject: Re: mySQL vs. Access My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
I agree with you, 99% of the time it will be Access or SQL Server. I just gave another possible answer because I wanted to shed another view. Access also has a date/time field which one can create a CF variable and then insert that in and then check against the cf variable. Works well. At 11:41 AM 5/21/2002 -0400, you wrote: I suppose the answers were MS centric but in my experience on this list if someone doesn't explicitly state which database they are using in a post, 99% of the time it will be Access or SQL Server so I suspect that's why the anwers were geared that direction. As I mentioned in an earlier response, if someone is using Oracle it is more likely then already know how do this since it requires a bit more knowledge up front. Your 100% solution really is no more reliable/portable than several of the suggestions which have been previously posted. From his mention of using an autonumber field it sounds like he's using MS Access, in which case I don't believe there even exists a datetimestamp column type. /rob __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Problems installing a cfx dll
Didn't solve the problem, deleted the entry from admin, re-registered it, same problem, then tried regSvr32 dll location, First got Dunzip31.dll could not be found, then CFX_Zip.dll could not be found, ... -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:34 PM To: CF-Talk Subject: Re[2]: Problems installing a cfx dll oi Eric!! it probably has something to do with the fact there is a bug in Ben's install program. it skips a key needed in the registry for the cfx_zip tag.. if you want you can go in the registry and add type =CPP or you can just fire up admin.delete the entry there(you cannot edit it due to the missing regkey) and then just re-register the cfxwala. bob's yer uncle -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Tuesday, May 21, 2002, 11:31:07 AM, you wrote: CE When you say installed, did you use regsvr32.exe ? CE I'm not 100% if this is necessary... but it might be. :) CE Eric CE -Original Message- CE From: John McCosker [mailto:[EMAIL PROTECTED]] CE Sent: Tuesday, May 21, 2002 11:28 AM CE To: CF-Talk CE Subject: Problems installing a cfx dll CE Greetings, CE installed a dll and registered it in CFSERVER, CE but when running the tag I get this error, CE The library associated with the custom tag CFX_ZIP CE (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CE CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CE CFX_Zip CE ACTION=ZIP CE FILE=#VARIABLES.ZIPPath#*.* CE ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP CE RECURSE=Yes CE STOREPATH=Yes CE Am I missing something simple here, CE J CE __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Custom warning this page has expired page?
if you want to change the actual file (not sure of the legalities in that) then you will probably need to use a resource editor such as Visual C++ Load the resources from the DLL make the necessary changes and save the resources back in... HTH Kola Oyedeji wrote: Mike Thanks. I found the html for the page inside the mentioned dll in the winnt folder haven't tried to change it yet though. But actually changing the registry entry might be a better idea, thanks Kola -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 15:57 To: CF-Talk Subject: Re: Custom warning this page has expired page? AFAIK it loads the page from the resource which is held in mshtml.dll. therefore the res:// means that it will try and load the resource repost.htm from the mshtml.dll. To change the default i would assume that you will need to change the registry entry to point to either a file:// or a http:// address... although i could be wrong HTH Kola Oyedeji wrote: Hi sorry for the OT post but I'm sure some of you may have desired this at one time or another. I would like to know if its possible to change the page displayed when ie Displays the warning page has expired message. If I search the registry I find a key called postNotCached But it points to a dll I think, the data held in this key is: Res://mshtml.dll/repost.htm Does this mean that the page is generated by the mshtml dll? As I cant find the page anywhere on my machine by doing a search. What does the res:// path mean? Any pointers or suggestions woule really be appreciated - this is for an internal application so I know the end browser will be IE 5+ Thanks in advance Kola __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Re[2]: Problems installing a cfx dll
Sounds like DUnzip.DLL may be a DLL required by the CFX and it is not in a folder that is either in the same folder as the CFX or a folder in the search path... Howie - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:55 AM Subject: RE: Re[2]: Problems installing a cfx dll Didn't solve the problem, deleted the entry from admin, re-registered it, same problem, then tried regSvr32 dll location, First got Dunzip31.dll could not be found, then CFX_Zip.dll could not be found, ... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
Certainly you can do that (or even more reliably you could get a UUID value and insert that and then select it back out to get your PK). However, then you end up cluttering up your database with a bunch of information whose life span is essentially over once the insert is complete. Personally I don't like that. Getting the max(id) value where the inserted data fields match what you just inserted will work just as well without the overhead. Especially if you wrap the whole operation in a cftransaction block. Obviously a personal choice on which way to go. Both will work. I doubt whoever started this thread is paying attention to my ramblings at this point anyway. /rob -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:50 AM To: CF-Talk Subject: RE: Query help I agree with you, 99% of the time it will be Access or SQL Server. I just gave another possible answer because I wanted to shed another view. Access also has a date/time field which one can create a CF variable and then insert that in and then check against the cf variable. Works well. At 11:41 AM 5/21/2002 -0400, you wrote: I suppose the answers were MS centric but in my experience on this list if someone doesn't explicitly state which database they are using in a post, 99% of the time it will be Access or SQL Server so I suspect that's why the anwers were geared that direction. As I mentioned in an earlier response, if someone is using Oracle it is more likely then already know how do this since it requires a bit more knowledge up front. Your 100% solution really is no more reliable/portable than several of the suggestions which have been previously posted. From his mention of using an autonumber field it sounds like he's using MS Access, in which case I don't believe there even exists a datetimestamp column type. /rob __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Problems installing a cfx dll
I've sent an email to their support for registered users @ [EMAIL PROTECTED], but nothing back as of yet, I did suspect that DUnzip.DLL or DUnzip32.DLL was required, I'll check this out, -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 5:07 PM To: CF-Talk Subject: Re: Re[2]: Problems installing a cfx dll Sounds like DUnzip.DLL may be a DLL required by the CFX and it is not in a folder that is either in the same folder as the CFX or a folder in the search path... Howie - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:55 AM Subject: RE: Re[2]: Problems installing a cfx dll Didn't solve the problem, deleted the entry from admin, re-registered it, same problem, then tried regSvr32 dll location, First got Dunzip31.dll could not be found, then CFX_Zip.dll could not be found, ... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems installing a cfx dll
did you stop and restart the CF service? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:36 AM To: CF-Talk Subject: RE: Problems installing a cfx dll Thanks for the correction. Wasn't certain on that, but thought it was worth mentioning. :) -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: Re: Problems installing a cfx dll You don't use Regsvr32 on a CFX DLL. What he needs to do is make sure that the DLL is in the specified path and that any DLLs that are also required by the CFX are available as well. ColdFusion will complain that a CFX is missing when a required DLL is missing so you need to know if any other DLLs are required. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:31 AM Subject: RE: Problems installing a cfx dll When you say installed, did you use regsvr32.exe ? I'm not 100% if this is necessary... but it might be. :) Eric -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:28 AM To: CF-Talk Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
If you're using SQL Server, it's not always good practice to use IDENTITY. Instead, use SCOPE_IDENTITY(). SCOPE_IDENTITY() is the same as IDENTITY, except it limits the scope. For example, if you insert a row into TableA, but that table has an insert trigger that does some processing and inserts into another table called TableB, you'll pull the ID for TableB. SCOPE_IDENTITY() always pulls the most recent identity within scope for the current session, which means you don't need to worry about triggers. Granted, not a lot of people use triggers, but it's still good practice. Also, SCOPE_IDENTITY() may have been recently added. It may be a SQL Server 2000 feature so if you're using anything prior, you may be out of luck. Anybody else know if this is new to SQL Server 2000? Ben Johnson Hostworks, Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Design
In order to represent this in an XML document I have considered this approach: ?xml version=1.0? region rid=0 regiontype=Root rcutter=R000Root region rid=1000 regiontype=astronomical object rcutter=U304Universe region rid=1010 regiontype=astronomical object rcutter=S682Solar System ... Here is my concern. Even though this may be good form, these elements are of Mixed Type Elements in which they contain both PCDATA and Elements. I personally would like to stay clear from Mixed type Elements in an XML document if possible. If that's your only concern, why not just specify an additional attribute for the name? I'd be more concerned about building a more concrete hierarchy, myself - as Mr. Kime noted, what you've got is hard to read, but also it's hard to determine what the relationship limitations are between the various regions - that is, how do you enforce the (assumed) limitation that a Solar System can't contain a Universe? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
Also, SCOPE_IDENTITY() may have been recently added. It may be a SQL Server 2000 feature so if you're using anything prior, you may be out of luck. Anybody else know if this is new to SQL Server 2000? Yes, it's new to SQL Server 2000. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Need Help w/CFMail its running a muck
I'm having trouble with CFMAIL on my server, it's not delevering any mail and it's generated +95,000 undeliverable pieces in the UnDelvr folder and it looks like its still go'in. How do I make it stop? Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Shopping cart
I just started work for a company that is using CF mainly, but has a ASP shopping cart. Does anyone know of an open source shopping cart done in CF that is pretty good? Douglas Brown Email: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
Thanks, Ben I was not aware of that. Unfortunately, it does seem new to SQL Server 2000, at least I don't see anything about it in books online fot MSSQL7. Good tip though. /rob -Original Message- From: Ben Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:21 AM To: CF-Talk Subject: RE: Query help If you're using SQL Server, it's not always good practice to use @@IDENTITY. Instead, use SCOPE_IDENTITY(). SCOPE_IDENTITY() is the same as @@IDENTITY, except it limits the scope. For example, if you insert a row into TableA, but that table has an insert trigger that does some processing and inserts into another table called TableB, you'll pull the ID for TableB. SCOPE_IDENTITY() always pulls the most recent identity within scope for the current session, which means you don't need to worry about triggers. Granted, not a lot of people use triggers, but it's still good practice. Also, SCOPE_IDENTITY() may have been recently added. It may be a SQL Server 2000 feature so if you're using anything prior, you may be out of luck. Anybody else know if this is new to SQL Server 2000? Ben Johnson Hostworks, Inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems installing a cfx dll
Yep!! -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 5:19 PM To: CF-Talk Subject: RE: Problems installing a cfx dll did you stop and restart the CF service? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:36 AM To: CF-Talk Subject: RE: Problems installing a cfx dll Thanks for the correction. Wasn't certain on that, but thought it was worth mentioning. :) -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: Re: Problems installing a cfx dll You don't use Regsvr32 on a CFX DLL. What he needs to do is make sure that the DLL is in the specified path and that any DLLs that are also required by the CFX are available as well. ColdFusion will complain that a CFX is missing when a required DLL is missing so you need to know if any other DLLs are required. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:31 AM Subject: RE: Problems installing a cfx dll When you say installed, did you use regsvr32.exe ? I'm not 100% if this is necessary... but it might be. :) Eric -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:28 AM To: CF-Talk Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
mySQL, hands down. With the right GUI front end you also have an easy and very powerful environment to work in. The free/donationware mySQLFront (http://www.mysqlfront.de) is my favorite. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 6:15 AM To: CF-Talk Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
Good Grief! *brews more coffee* mySQL mySQL mySQL... For some stupid reason, I read it as Access vs MS SQL. :/ By all means use mySQL over Access... every day of the week and twice on Sunday. :) -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:51 AM To: CF-Talk Subject: FW: mySQL vs. Access I mean mySQL! *looking for coffee cup* -Original Message- From: Hoag, Claudia (LNG) Sent: Tuesday, May 21, 2002 11:50 AM To: '[EMAIL PROTECTED]' Subject: RE: mySQL vs. Access Hm, if we're talking SMALL small then I would think you don't have to pay anything to use msSQL, right? -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: RE: mySQL vs. Access If we're talking SMALL small and software licencing is a concern, then Access will do the job as well. msSQL is preferable if budget permits, but Access is an ok substitute if there are fewer requests, smaller tables, etc... Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:24 AM To: CF-Talk Subject: Re: mySQL vs. Access My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping cart
Look at Web monkey's shopping cart it also go over the basics of building that shopping cart.. also there is one in the 4.0 WACK I am not sure about the 5.0.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:35 AM To: CF-Talk Subject: Shopping cart I just started work for a company that is using CF mainly, but has a ASP shopping cart. Does anyone know of an open source shopping cart done in CF that is pretty good? Douglas Brown Email: [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
If you are looking for ease of use, go with Access. Much easier to use than MySQL. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:30 AM To: CF-Talk Subject: RE: mySQL vs. Access mySQL, hands down. With the right GUI front end you also have an easy and very powerful environment to work in. The free/donationware mySQLFront (http://www.mysqlfront.de) is my favorite. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 6:15 AM To: CF-Talk Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPOP Question
What I am attempting is to parse the OLD stuff out and just GRAB the new message in which they are conveying. Doesn't that depend entirely on how they reply to your message? The original message may or may not be included in their reply. Or maybe I still don't understand what you're describing. -- Owen 2. Any idea on how to grab the NEW MESSAGE and NOT the replied message. Meaning if this is a reply to an original message I do not want the original message but the NEW message. ANY IDEAS ON THIS? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sharing sessions due to url.cfid and url.token
If you pass a URL with a CFID and token in it to a different user, the new user will hi-jack that session information. We are currently experiencing the same issue as Claudia. Our current solution is to put addtoken = no (or something of that nature) from the cflocation tags. The other thought is to check to ensure IP's match via the suggestion Jeffry gave, but he raised an interesting point, the IP's may not always match behind a firewall. Why would the IP's not always match? Anyone want to give a firewalls 101 crash paragraph? Thanks, CC Jeffry Houser jeffTo: CF-Talk [EMAIL PROTECTED] @farcryfly.cocc: m Subject: RE: sharing sessions due to url.cfid and url.token 05/21/02 10:02 AM Please respond to cf-talk If the session wasn't being passed in the URL, then there would be no problem with someone stealing a session through URL sharing. I would look into using CGI Variables. Check if the CGI variable (I forget which one, HTTP_Referrer maybe?) to see where the user came from. Granted if someone fakes it, this will not prevent anything. At 10:44 AM 5/21/2002 -0400, you wrote: About the only thing I can think of is to add some code to your App.cfm file which checks for the existence of CFID and CFTOKEN as URL variables and if found, just redirect to the same page minus the session info on the url line. Of course this assumes you don't ever pass the session info in the url. /rob -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:19 AM To: CF-Talk Subject: sharing sessions due to url.cfid and url.token I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problems installing a cfx dll
Doublecheck your permissions...make sure CF has access to the dll and directory. jon - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 12:29 PM Subject: RE: Problems installing a cfx dll Yep!! -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 5:19 PM To: CF-Talk Subject: RE: Problems installing a cfx dll did you stop and restart the CF service? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problems installing a cfx dll
You need to also copy dzip32.dll and dunzip32.dll to your server's WINNT/System32 directory. These are the DLLs that actually do the work. Just look for them on a machine that was successfully running a licensed copy of CFX_ZIP and copy them over... as soon as you pay your license fee. :) That will solve your problem. Have a great one! :) Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion 5 Developer Productivity Enhancement, Inc. http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:27 AM Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom warning this page has expired page?
I was playing with this and hubby brought up a good point ... Changing the registry key to point to a new doc is cool, if you are viewing the web page from that machine ... It's not the server that feeds the page, it's the end user's browser. Would this be an issue in your search for customizing the expired paged? Or is this wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - Instant Messenger Access AIM: WebErika5 | Yahoo: WebErika | MSN: WebErika - | -Original Message- | From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] | Sent: 21 May 2002 12:42 | To: CF-Talk | Subject: Custom warning this page has expired page? | | | Hi sorry for the OT post but I'm sure some of you may have | desired this at one time or another. | | I would like to know if its possible to change the page | displayed when ie Displays the warning page has expired message. | | If I search the registry I find a key called postNotCached | But it points to a dll I think, the data held in this key is: | | Res://mshtml.dll/repost.htm | | Does this mean that the page is generated by the mshtml | dll? As I cant find the page anywhere on my machine by | doing a search. What does the res:// path mean? | | | Any pointers or suggestions woule really be appreciated - | this is for an internal application so I know the end | browser will be IE 5+ | | Thanks in advance | | Kola | | | | | | | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? OK, here's a simple rule of thumb: mySQL (or msSQL g) is a Server app, so it should be used on servers Access is a Desktop app, so it should be used on a desktop As long as you can GUARANTEE that the traffic is very low, then Access will do, but it has HUGE Jet Engine problems, and horrible memory leaks - DO NOT use it in a live environment that you expect to get some real traffic to (Intranet or Internet) It's probably better to use mySQL anyways as if you ever have to upgrade the number of users, then you don't have to do anything - with Access you'd have to re-write to get it working with a real database engine once you increase the number of users Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems installing a cfx dll
I have paid my licence fee, also ordered a copy on CD, MY MACHINE IS TRYING TO RUN A LICENSED COPY OF CFX_ZIP ALREADY -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 5:53 PM To: CF-Talk Subject: Re: Problems installing a cfx dll You need to also copy dzip32.dll and dunzip32.dll to your server's WINNT/System32 directory. These are the DLLs that actually do the work. Just look for them on a machine that was successfully running a licensed copy of CFX_ZIP and copy them over... as soon as you pay your license fee. :) That will solve your problem. Have a great one! :) Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion 5 Developer Productivity Enhancement, Inc. http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:27 AM Subject: Problems installing a cfx dll Greetings, installed a dll and registered it in CFSERVER, but when running the tag I get this error, The library associated with the custom tag CFX_ZIP (C:\CFusion\cfx\CFX_Zip\CFX_Zip.dll) was not found. CFSET VARIABLES.ZIPPath=#REQUEST.LOGPATH##SESSION.CustomerName# CFX_Zip ACTION=ZIP FILE=#VARIABLES.ZIPPath#*.* ZIPFILE=#REQUEST.ZIPPath##SESSION.CustomerName#.ZIP RECURSE=Yes STOREPATH=Yes Am I missing something simple here, J __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sharing sessions due to url.cfid and url.token
You can have multiple users showing the same IP address if they're behind the same firewall. I've already added addtoken=No to the cflocations, but I just wanted to know if there was a way of checking. I thought about the cgi.http_referrer and clearing the session structure and expiring the cookies if the referrer is not the expected, but sometimes the http_referrer is blank and that doesn't mean the user is pasting a url on the browser. Considering that all access is done after user login, I guess I can create my own cookie when the user logs in, containing cfid and cftoken, and always check that against the current cfid and cftoken. If that's not the same, there wasn't a login in the current machine or session is expired - force new login. -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:43 PM To: CF-Talk Subject: RE: sharing sessions due to url.cfid and url.token If you pass a URL with a CFID and token in it to a different user, the new user will hi-jack that session information. We are currently experiencing the same issue as Claudia. Our current solution is to put addtoken = no (or something of that nature) from the cflocation tags. The other thought is to check to ensure IP's match via the suggestion Jeffry gave, but he raised an interesting point, the IP's may not always match behind a firewall. Why would the IP's not always match? Anyone want to give a firewalls 101 crash paragraph? Thanks, CC Jeffry Houser jeffTo: CF-Talk [EMAIL PROTECTED] @farcryfly.cocc: m Subject: RE: sharing sessions due to url.cfid and url.token 05/21/02 10:02 AM Please respond to cf-talk If the session wasn't being passed in the URL, then there would be no problem with someone stealing a session through URL sharing. I would look into using CGI Variables. Check if the CGI variable (I forget which one, HTTP_Referrer maybe?) to see where the user came from. Granted if someone fakes it, this will not prevent anything. At 10:44 AM 5/21/2002 -0400, you wrote: About the only thing I can think of is to add some code to your App.cfm file which checks for the existence of CFID and CFTOKEN as URL variables and if found, just redirect to the same page minus the session info on the url line. Of course this assumes you don't ever pass the session info in the url. /rob -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:19 AM To: CF-Talk Subject: sharing sessions due to url.cfid and url.token I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sharing sessions due to url.cfid and url.token
Usually machines behind a firewall will have non-routable IP address (ex. any ip address starting with 192.168.*.*) When any user on our trusted network access a resource on the external network (such as an external website), their IP address is masqueraded by the external WAN interface. So the end result is that _all_ of the users coming from our trusted/internal network appear to have the same IP address. The same problem arises when the uses have a proxy server between them and the intranet. In general the IP address is an unreliable way to uniquely identify users. /rob -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:43 PM To: CF-Talk Subject: RE: sharing sessions due to url.cfid and url.token If you pass a URL with a CFID and token in it to a different user, the new user will hi-jack that session information. We are currently experiencing the same issue as Claudia. Our current solution is to put addtoken = no (or something of that nature) from the cflocation tags. The other thought is to check to ensure IP's match via the suggestion Jeffry gave, but he raised an interesting point, the IP's may not always match behind a firewall. Why would the IP's not always match? Anyone want to give a firewalls 101 crash paragraph? Thanks, CC Jeffry Houser jeffTo: CF-Talk [EMAIL PROTECTED] @farcryfly.cocc: m Subject: RE: sharing sessions due to url.cfid and url.token 05/21/02 10:02 AM Please respond to cf-talk If the session wasn't being passed in the URL, then there would be no problem with someone stealing a session through URL sharing. I would look into using CGI Variables. Check if the CGI variable (I forget which one, HTTP_Referrer maybe?) to see where the user came from. Granted if someone fakes it, this will not prevent anything. At 10:44 AM 5/21/2002 -0400, you wrote: About the only thing I can think of is to add some code to your App.cfm file which checks for the existence of CFID and CFTOKEN as URL variables and if found, just redirect to the same page minus the session info on the url line. Of course this assumes you don't ever pass the session info in the url. /rob -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:19 AM To: CF-Talk Subject: sharing sessions due to url.cfid and url.token I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPOP Question
I have two questions regarding the query columns returned from using CFPOP. 1. The date field when it comes in is not a TRUE date field thus I can not use CreateODBCDate or DateFormat on this field to grab JUST THE DATE and then JUST the time. IDEAS??? This really depends on your mail server - but why not ParseDateTime() to make it into a real Date type? Then you can use DateFormat() and TimeFormat() as much as you want 2. Any idea on how to grab the NEW MESSAGE and NOT the replied message. Meaning if this is a reply to an original message I do not want the original message but the NEW message. ANY IDEAS ON THIS? Why not store the messages in a database (read via CFPOP on a schedule) and then you can do whatever you want with it... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping cart
Netready is very good. Huge feature list, relatively cheap, works with ACCESS, SQL Server, and Oracle, available in FB3. You can't go wrong here! http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:35 AM To: CF-Talk Subject: Shopping cart I just started work for a company that is using CF mainly, but has a ASP shopping cart. Does anyone know of an open source shopping cart done in CF that is pretty good? Douglas Brown Email: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
Thanks Matt! The mySQL interface is excellent! I was doing it from the command line when I started and this is much easier! Thanks, Dave Bosky -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:30 PM To: CF-Talk Subject: RE: mySQL vs. Access mySQL, hands down. With the right GUI front end you also have an easy and very powerful environment to work in. The free/donationware mySQLFront (http://www.mysqlfront.de) is my favorite. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 6:15 AM To: CF-Talk Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: mySQL vs. Access
Jeppers use mysql if you are about access is evil.. A wise man named adam once told me ;) FRiends dont let friends use access Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 9:15 AM Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
I'm just as happy with it. Totally simplifies db management. Make sure you check out logging into multiple db's (on multiple machines) at once, then export/import between them. That one's worth its weight in gold, IMHO. --Matt-- -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:15 AM To: CF-Talk Subject: RE: mySQL vs. Access Thanks Matt! The mySQL interface is excellent! I was doing it from the command line when I started and this is much easier! Thanks, Dave Bosky __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
Just as good as Enterprise Manager and a lot cheaper! Thanks, Dave Bosky -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:23 PM To: CF-Talk Subject: RE: mySQL vs. Access I'm just as happy with it. Totally simplifies db management. Make sure you check out logging into multiple db's (on multiple machines) at once, then export/import between them. That one's worth its weight in gold, IMHO. --Matt-- -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:15 AM To: CF-Talk Subject: RE: mySQL vs. Access Thanks Matt! The mySQL interface is excellent! I was doing it from the command line when I started and this is much easier! Thanks, Dave Bosky __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OPTION QUERY HINT OT SQL PROBLEM
Does anyone know the correct synatx to the option query hint keep plan BOL God bless it is sometimes sparce in its explanations. TIA, Josh SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into ##DA69EE60673311D6B9B3000AD1311671 FROM vw_CTMCORPAPPFULLVIEWprod option query_hint, keep plan where (requestor like 'OVD%') and year = 2001 GROUP BY reg_NO, y_id, M_id __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping cart
I agree, we like it a lot. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:14 AM To: CF-Talk Subject: RE: Shopping cart Netready is very good. Huge feature list, relatively cheap, works with ACCESS, SQL Server, and Oracle, available in FB3. You can't go wrong here! http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:35 AM To: CF-Talk Subject: Shopping cart I just started work for a company that is using CF mainly, but has a ASP shopping cart. Does anyone know of an open source shopping cart done in CF that is pretty good? Douglas Brown Email: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sharing sessions due to url.cfid and url.token
claudia, I played around with this code in my Application.cfm file. It seems to work ok. The idea is to check for and invalidate any session information passed along on the url line. You can probably spruce it up by actually removing the CFID and CFTOKEN arguments with an REReplace or something, but I'm lousy at regular expressions so I just hacked this up quick. Also, you'll likely want to loop over the NewQs query string and Url Encode the right hand side of each expression. cfif IsDefined(Url.CFID) And IsDefined(Url.CFTOKEN) cfset NewQS = ReplaceNoCase(Cgi.Query_String, CFID, CFID_ignore) cfset NewQS = ReplaceNoCase(NewQS, CFTOKEN, CFTOKEN_ignore) cfoutput META HTTP-EQUIV=Refresh CONTENT=0; URL=#Cgi.Script_Name#?#NewQs# /cfoutput /cfif /rob -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:01 PM To: CF-Talk Subject: RE: sharing sessions due to url.cfid and url.token You can have multiple users showing the same IP address if they're behind the same firewall. I've already added addtoken=No to the cflocations, but I just wanted to know if there was a way of checking. I thought about the cgi.http_referrer and clearing the session structure and expiring the cookies if the referrer is not the expected, but sometimes the http_referrer is blank and that doesn't mean the user is pasting a url on the browser. Considering that all access is done after user login, I guess I can create my own cookie when the user logs in, containing cfid and cftoken, and always check that against the current cfid and cftoken. If that's not the same, there wasn't a login in the current machine or session is expired - force new login. -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:43 PM To: CF-Talk Subject: RE: sharing sessions due to url.cfid and url.token If you pass a URL with a CFID and token in it to a different user, the new user will hi-jack that session information. We are currently experiencing the same issue as Claudia. Our current solution is to put addtoken = no (or something of that nature) from the cflocation tags. The other thought is to check to ensure IP's match via the suggestion Jeffry gave, but he raised an interesting point, the IP's may not always match behind a firewall. Why would the IP's not always match? Anyone want to give a firewalls 101 crash paragraph? Thanks, CC Jeffry Houser jeffTo: CF-Talk [EMAIL PROTECTED] @farcryfly.cocc: m Subject: RE: sharing sessions due to url.cfid and url.token 05/21/02 10:02 AM Please respond to cf-talk If the session wasn't being passed in the URL, then there would be no problem with someone stealing a session through URL sharing. I would look into using CGI Variables. Check if the CGI variable (I forget which one, HTTP_Referrer maybe?) to see where the user came from. Granted if someone fakes it, this will not prevent anything. At 10:44 AM 5/21/2002 -0400, you wrote: About the only thing I can think of is to add some code to your App.cfm file which checks for the existence of CFID and CFTOKEN as URL variables and if found, just redirect to the same page minus the session info on the url line. Of course this assumes you don't ever pass the session info in the url. /rob -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:19 AM To: CF-Talk Subject: sharing sessions due to url.cfid and url.token I'm trying to think of a way not to allow people to inadvertedly share a session by sending each other a url with their cfid and cftoken in it. Of course we can just make sure that those are not passed as url parameters, but I'm thinking if there's a way to check if this is a session initiated by someone else. Do you guys have any ideas? Thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: ActivePDF
My company is evaluating a few different PDF generators, and I have two quick questions regards ActivePDF, specifically pertaining to ColdFusion: 1. Are graphics (i.e., bar charts, line charts, etc.) available natively in the API? 2. If not, how do you use graphics with the product? Thanks, Dave. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: CF and mSQL hosting recommendation? (was mySQL vs. Access)
Apologies in advance if this is too OT for this list, but with all the talk of CF paired with mySQL, I was wondering if people could recommend a reliable, US based hosting service that offers both CF and mySQL. From what I've seen, hosts typically offer CF with Access and/or SQL server OR php with mySQL -- but maybe I haven't searched enough. Any recommendations would be greatly appreciated. TIA. Regards, Bob Haroche O n P o i n t S o l u t i o n s http://www.OnPointSolutions.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists