RE: fusebox style: too much disk access?
Not these days, everything on the computers usually are cached. So it would be no surprise to know that files have always been cached from Windows 95/98/ME/2000. So in reality because these files are heavily used the files would be cached and would be accessed quicker the second/third time. But it is a very small issue to the server. regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]] Sent: 20 October 2000 07:00 To: CF-Talk Subject: fusebox style: too much disk access? I was reading on the fusebox concept of putting minute modules into separate files and the question is: wouldn't that slow the site by having to access too many different disk files to load one page? Cyrill Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: uregent(difference between two logics)
ok I have a structure setup:-) structname.elementArray[1] = "what Ever" structname.elementArray[2] = "what Ever" structname.elementArray[3] = "what Ever" structname.elementArray[4] = "what Ever" structname.elementArray[5] = "what Ever" structname.elementtext This is a structure with an array embeded into the structure, the following is an array with embeded structure. Array[1].Title = "Title" Array[2].Title1 = "Title1" Array[3].Title2 = "Title2" Array[4].Title3 = "Title3" Array[5].Title4 = "Title4" Array[6].Next = Structurename As you can see the combination of structure and arrays is endless:-) regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Sam Komolafe (Hotmail) [mailto:[EMAIL PROTECTED]] Sent: 23 October 2000 16:00 To: [EMAIL PROTECTED] Subject: Array of Structures Hi Scott, Just read your comments on arrary and structure. How do you define an Array of Structure. Also how do you define a structure of Arrays. Thanks Sam Komolafe [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: [OT] Looking for good DHTML tutorial and or book
http://developer.netscape.com has some good DHTML resources. Regards Stew Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SP2
error.FormFields gives ULLIP/UL Can you make it output ULLI/LI/UL instead? -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: How to build a solid development team?
Julie, From my travels/experience, the best teams (most productive) I've seen assembled are basically a combination of 3 groups, at least member for each group. You can vary these numbers depending on the amount of work for each type and the skill level of each member.. But basically what you want is: 1) a Graphics team a. This team will do the storyboards, Photoshop mockups and has/gets final approval of the design. They may/may not work with the 3rd member for the HTML storyboards depending on their skill level with HTML.. 2) Functional team - aka.. the CF coders.. a. This is the team who will take the Photoshop mockups and build the basic functional interface (block interface). For instance making sure there is a search box at the top and it does the search properly, or the form has the needed fields and inserts the data properly. But you don't want them spending too much time, making sure all of the fonts are correct or that there are 15 pixels of space between the columns.. That's for the 3rd team.. 3) An HTML team.. a. This team will take the functional app/pieces from team 2 and work with the graphics team making sure it looks the way they imagined. Thus completing the circle. Basically after the CF team makes it work they can hand off the easy HTML stuff back to this team to make sure all of the fonts are right, the spacing is just how the graphics team imagined, and all of the forms are left aligned, spaced and sized right. b. This is a good place for Junior developers/interns to start, working with the finished CF code they usually will get up to speed with CF more quickly and move on to doing more functional work. c. You might also want to plan on a 2-1 ratio with the CF team.. basically 2 HTML coders for every one CF coder. You might ask why a separate HTML team, aren't all CF coders advanced HTML coders.. We'll yes.. But once your brain is thinking of stored procedures, and search logic, etc.. you start ignoring the HTML parts. CF coders have a tendency to hate doing the finer details of the HTML, and they let it slip. at least that's my opinion I could be wrong. Not to mention that sometimes making that form look just right can take 80% of the development time where 20% was doing the actually dynamic logic.. And a good CF coder will want to get on to the next piece of functionality, that's the fun part of the job.. Watching this type of team in action, is very interesting. It's amazing the amount of work that can get done when you break up an application into its separate pieces by teams. And let each one do what they do best.. That's my 2cents.. Hope it helps, Mike -Original Message- From: Julie McKellar [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 22, 2000 10:26 PM To: CF-Talk Subject:How to build a solid development team? This is a multi-part message in MIME format. --=_NextPart_000_016D_01C03C6E.A5584AF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Could any of you give me some insight as to how your development team is built? How many junior, mid, senior developers, lead developers, application architects, database administratorsetc.?? Basically, if you are working for a company, how is your development = team structured? I am trying to decide the best way to build a development = team that will be responsible for building applications and integrating = acquired applications. Thanks so much! Julie McKellar --=_NextPart_000_016D_01C03C6E.A5584AF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN" HTML HEAD META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3D'"MSHTML 4.72.3511.1300"' name=3DGENERATOR /HEAD BODY bgColor=3D#ff DIVCould any of you give me some insight as to how your development = team=20 isBRbuilt?nbsp; How many junior, mid, senior developers, lead=20 developers,BRapplication architects, database=20 administratorsetc.??BRBRBasically, if you are working for a = company, how=20 is your development teamBRstructured?nbsp; I am trying to decide the = best way=20 to build a development teamBRthat will be responsible for building=20 applications and integrating acquiredBRapplications.BRBRThanks so=20 much!BRJulie McKellar/DIV/BODY/HTML --=_NextPart_000_016D_01C03C6E.A5584AF0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
CFApplication and IE5.5 - not work properly!
I've just upgraded to IE5.5, and on an application that uses Application scope variables suddenly stopped working - this code worked perfectly on IE5.0 It gives me; "Attempt to access an Application variable when application management is not enabled. Use the CFAPPLICATION tag to enable application management. Note: This feature may have been disabled by the site administrator." Now, I KNOW that it's activated in the back office, and here's the code; cfApplication name="EBiz" ApplicationTimeOut="#CreateTimeSpan(0,1,0,0)#" cfif not isDefined("application.DPAfieldTransformation") cfscript application.DPAfieldTransformation=QueryNew("FieldName,DisplayName,FieldLeng th,Required,PRRequired"); And then the definitions It crashes on the first line of code in the CFScript (QueryNew) Any ideas anyone? Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SQL: Getting values from a just inserted record.
I know this has been asked before a while back, but I can find the mail which covered it, so here's the question. I add a record which is using a "uniqueidentifier" as the key, how can I then get the value of that field, without having to do a search on the rest of the data I've just added (which ain't unique enough)? I seem to remember that you used some SQL @somethingOrOther to reference it, but can pin down a solution. Cheers, Dan. This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible.The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Getting values from a just inserted record.
For SQL server CFQUERY name="Whatever" datasource="#Application.DSN#" SET NOCOUNT ON INSERT INTO YourTable (Field1, Field2) VALUES ('a','b') SELECT TheID = @@IDENTITY SET NOCOUNT OFF /CFQUERY In Access you will have to query for the latest record: cftransaction cfquery ... INSERT ... /cfquery cfquery name="bob" ... SELECT max(ID) as MaxID FROM TheTable /cfquery /cftransaction You can then refer to the latest record's ID as bob.maxid Steve -Original Message- From: Daniel Kemp [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:30 To: CF-Talk Subject: SQL: Getting values from a just inserted record. I know this has been asked before a while back, but I can find the mail which covered it, so here's the question. I add a record which is using a "uniqueidentifier" as the key, how can I then get the value of that field, without having to do a search on the rest of the data I've just added (which ain't unique enough)? I seem to remember that you used some SQL @somethingOrOther to reference it, but can pin down a solution. Cheers, Dan. This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible.The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Getting values from a just inserted record.
I know this has been asked before a while back, but I can find the mail which covered it, so here's the question. I add a record which is using a "uniqueidentifier" as the key, how can I then get the value of that field, without having to do a search on the rest of the data I've just added (which ain't unique enough)? I seem to remember that you used some SQL @somethingOrOther to reference it, but can pin down a solution. @@identity returns the inserted identity field, but it must be done within the same query - I tend to use; set nocount on insert into MYTABLE (myField) values ('myValue') select @@identity as ID set nocount off The returned ID is then the new identity You may want to look at Triggers though, as this saves a bit of code on your end and SQL Server automatically sends the new ID at you Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
nope that didnt work. http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggraph9 9Notes.htm##course6 any other ideas? thank you -paul -Original Message- From: Nardi, Gaston [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2000 4:26 PM To: CF-Talk Subject: RE: Cfparam :: FrameSets :: Anchors oh my! Maybe you should scape the # in your link with another #, like this: http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggrap h9 9Notes.htm##course6 Hope this help you. Gaston. -Mensaje original- De: Paul Ihrig [SMTP:[EMAIL PROTECTED]] Enviado el: MiƩrcoles 18 de Octubre de 2000 17:14 Para: CF-Talk Asunto: Cfparam :: FrameSets :: Anchors oh my! this should be simple but it isnt. to be able to pull up the surounding framesets on out intranet i was helped to put a few cfparams in my default frame set. now i would like to be able to email an inhouse link like below, going to a specific anchor in a specific frameset. http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggrap h9 9Notes.htm#course6 but the anchores dont seem to work this way. any ideas? can it be done. do i need a ? befor the #course6 do i need to define the # in my main default.cfm frame set. please dont laugh too hard. -paul -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Update Query/Output question from a newbie...
Hi Michael, I'll just start at the top, ok? What is distrib_state? I get the impression that it is the actual name of the state. If so, I would suggest that you use state_id instead - I know the names of the states are not going to change but it will save you space and is good database design. Now, modify your query and select to include the state_id... CFQUERY NAME="GetState" DATASOURCE="dbcms" SELECT state_name, state_id FROM tblstates /CFQUERY SELECT NAME="distrib_state" CFOUTPUT QUERY="GetState" OPTION value="#GetState.state_id#"#GetState.state_name#/OPTION /CFOUTPUT /SELECT This means that when you action the form you get the state_id as the value of distrib_state rather then state_name. In the update form where you want to display the state for the distributor you need to add a bit more code to the select so that it 'selects' the state you want: SELECT NAME="distrib_state" CFOUTPUT QUERY="GetState" OPTION value="#GetState.state_id#" cfif GetState.state_id eq Distributor.state_idSELECTED/cfif #GetState.state_name# /OPTION /CFOUTPUT /SELECT I'm not sure why you are using CFOUTPUT QUERY="Distributor" when you know you are only going to get a single record. It does save typing 'distributor' in front of the variable names but I would suggest that this is a false economy. Using full 'dot' notation (as recommended by Bill) will make your maintenance task much easier in another four years time and is (I believe) marginally faster for CF to lookup. If you decide to continue to use CFOUTPUT QUERY="Distributor" then you will need to change the CFOUTPUT QUERY="GetState" in the select to be CFLOOP QUERY="GetState". OK? And don't forget the /cfoutput to /cfloop... I hope that answers your question... Regards Brett Payne-Rhodes B) Eaglehawk Computing Perth, Western Australia Michael Wilson wrote: Hi all and thanks for taking time to look this over. I will try my best to keep it as brief as possible, although I need to give you some background on my problem. Thanks in advance for any help you can provide. I have a client I did a site for about 4 years ago and it have never really been changed much. The site owner asked me to update the look and functionality of the site to make it easier to use. He also requested that I create a system that would allow him to update the Distributors section on his own, so I went with ColdFusion, because I want to learn more about it. I am working on the code for the Distributors first. The original page is http://www.mfay.com/Locations.htm. Don't laugh, it's really Old School... I stared with my Database in MS Access, dbcms.mdb. I have 2 tables, tbldistrib and tblstates. tbldistrib has the following columns: distrib_id (auto number), distrib_name, distrib_city, distrib_state and distrib_phone tblstates has the following columns: state_id (auto number), state_name and state_abb (incase he wants to use abbreviation later) Next I started on the Add New Distributor area of his CMS. I created the insert form using Text type inputs for name, city and phone. I used a select box for the sate and got the select options from tblstates/state_names in the Database. the code I used for the select box: Query: CFQUERY NAME="GetState" DATASOURCE="dbcms" SELECT state_name FROM tblstates /CFQUERY Output: SELECT NAME="distrib_state" CFOUTPUT QUERY="GetState" OPTION #GetState.state_name# /OPTION /CFOUTPUT /SELECT All went according to plan and it works fine. I then created the display page and messed around with the ordering and formatting until I have it real close to the original style of listing the distributors. You can find it at: http://xiondev2.dynip.com/cms/list_distrib.cfm Then I started on the Update Distributor section... I can make this work by using the following Query: CFQUERY DATASOURCE="dbcms" NAME="Distributor" SELECT distrib_name, distrib_city, distrib_state, distrib_phone FROM tbldistrib WHERE distrib_id = #distrib_id# /CFQUERY Output: CFOUTPUT QUERY="Distributor" FORM ACTION="distrib_update.cfm" METHOD="post" INPUT TYPE="hidden" NAME=distrib_id" Value="#distrib_id#" p Distributor Name: INPUT TYPE="text" NAME=distrib_name" SIZE="35" MAXLENGTH="50" Value="#Trim(distrib_name)#" ..and so forth for each form field. What I would like to do is have the "State Name" portion of the form return as a select box as in the insert form, displaying the current distrib_state as the default option while also populating the rest of the select box (options) with the data (state names) from the tblsates/state_names in the database. This way my client can change the Distributor State if he needs to in the same manner as when he adds a new distributor. I tried running 2 Queries and 2 outputs calling a distrib_id in the url (...cfm?distrib_id=30) Query: CFQUERY DATASOURCE="dbcms"
RE: Cfparam :: FrameSets :: Anchors oh my!
nope that didnt work. http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99 /siggraph9/Notes.htm##course6 any other ideas? Can I get you to try something? What is the value of URL.MainPage when default.cfm? If it includes the "#course6" then you might have to put a dummy value on the URL, such as; default.cfm?MainPage=DesignTech/technews/Siggraph99/Notes.htmjunk=Yes#cours e6 Give this a try and see what happens... I'm only using "Junk=Yes" as a test - you might want to change the variable name to something less obvious... Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
wddx deserialize
I am posting from CF via SOAP a WDDX packet representing a WDDX recordset. Using the com DLL provided, I receive an error when I attempt to deserialize the packet. Any Help? wddxrs = obj.deserialize(XMLResult) XMLResult is a serialized WDDX recordset. obj is a WDDXDeserializer Gary Davidson Corporate Data Architect Mortgage.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
Philip, thanks, but i didnt work. here is my default frameset. --- cfparam name="url.TitleBar" default="default/_TOP.htm" cfparam name="url.ButtonBar" default="default/_LEFT.htm" cfparam name="url.MainPage" default="fs/fsrite.cfm" frameset frameborder="NO" framespacing="0" border="0" rows="48,703*" cols="*" bordercolor="#FF" frame name="TitleBar" src="cfoutput#url.TitleBar#/cfoutput" SCROLLING="NO" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder="NO" bordercolor="#FF" noresize frameset cols="144,656*" frameborder="NO" border="0" framespacing="0" bordercolor="#FF" frame name="ButtonBar" src="cfoutput#url.ButtonBar#/cfoutput" MARGINWIDTH="0" MARGINHEIGHT="0" bordercolor="#FF" frameborder="NO" target="Main Page" scrolling="NO" frame NAME="MainPage" SRC="cfoutput#url.MainPage#/cfoutput" SCROLLING="AUTO" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder="NO" bordercolor="#FF" /frameset - the example you gave me just returned a 404. again thank you. -paul Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: wddx deserialize
What's the error? What does the packet look like? You can check it using: cfoutput#HTMLEditFormat(XMLResult)#/cfoutput -David On Mon, 23 Oct 2000 08:52:09 -0400 Gary Davidson [EMAIL PROTECTED] writes: I am posting from CF via SOAP a WDDX packet representing a WDDX recordset. Using the com DLL provided, I receive an error when I attempt to deserialize the packet. Any Help? wddxrs = obj.deserialize(XMLResult) XMLResult is a serialized WDDX recordset. obj is a WDDXDeserializer Gary Davidson Corporate Data Architect Mortgage.com - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: fusebox style: too much disk access?
Fusebox does break up your application by object. It does this first, in Fusebox that's known as a "circuit application". Fusebox tries to have friendly names than in OO programming, this is so it can be more easily described to a non technical person. Here's the breakdown of a Fusebox app: 1) Home application - this is your entire site 2) Circuit Application - this is a section of your home (or one of the objects). Basically a circuit is a directory of .cfm files. so you might have a "/products" or "/users" or "/surveys". or even sub-circuits like: "/users/addresses" 3) Fuseaction - This is one of the things a circuit can do. In Object oriented programming this is known as a "method". 4) Fuse - This is one of the various files: dsp_file.cfm, qry_file.cfm, act_file.cfm, url_file.cfm, or even: com_file.cfm, ejb_file.cfm, JS_file.cfm. Fusebox suggestions files but if they don't work for you, come up with new ones, but be sure to tell everyone so others can benefit. Steve Peter Theobald wrote: Since we're talking about it... I always thought that breaking up an application by "type of activity in the file" like dsp for display and qry for query didn't make sense. I want to break up my application by logical "object" like a user profile, an inventory item, etc.. At 11:19 AM 10/20/00 -0700, Nat Papovich wrote: What-evah, Dave. Fusebox kicks ass for the very implementation you mention. COMs can be called from a single file (using a new prefix com_filename.cfm if you want), then whenever you need that COM, you cfinclude that file. Maybe it would help us if you made a distinction between application logic encapsulation and business rules encapsulation. If you do both within COM/EJB, then you practically don't even need CF for anything other than CFOUTPUT. If however, you want application logic in COM, but still want business rules in CF, then Fusebox is great. No? It seems to me that if you remove application and business logic from CF, then a structured application architecture (like Fusebox) becomes less of a necessity. What kind of CF architecture do you guys use in EJB/COM-heavy apps? Nat Papovich ICQ 32676414 "I'm for truth no matter who tells it." -Malcolm X, 1965 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, October 20, 2000 10:12 AM To: CF-Talk Cc: '[EMAIL PROTECTED]' Subject: RE: fusebox style: too much disk access? I'm not a Fusebox fan, by any measure, Why not? What would need to be changed to make you a fan? I'd have to be working on applications where the complex logic is stored in CF, instead of in other application tiers. I don't want to fuel another "Is Fusebox good or bad" thread, but I don't think it fits well with the type of applications that we focus on here at Fig Leaf, which typically have lots of client-side complexity, like frames, JavaScript, Flash, etc. and have lots of application logic within other application tiers on the server-side, like within stored procedures or COM/EJB. On the other hand, if I was working on an application with all of its complexity within CF, I'd probably like Fusebox quite a bit. Once you move most of that complexity from CF to other tiers, though, Fusebox doesn't do much for you, in my opinion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Update Query/Output question from a newbie...
Hi Mike, Invalid tag nesting configuration A query driven CFOUTPUT tag is nested inside a CFOUTPUT tag that also has a QUERY= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, only the top-level tag can specify the query that drives the processing. I've had a look at the code for the update form and you've got a couple of problems. Firstly, you're missing a bunch of quote marks from the name attribute on your input tags. Secondly, you're missing the 's from the end of your submit and reset buttons Thirdly, you have a nested CFOUTPUT, just as the error says ;o) Basically, you have the right idea, but CF doesn't allow nested CFOUTPUT tags, unless you're using the GROUP attribute in the outer CFOUTPUT. What you need to do is use a CFLOOP for your state select box, like so : Distributor State: SELECT name="distrib_state" CFLOOP query="GetState" cfif GetState.State_ID IS distrib_state cfset selected_var = "selected" cfelse cfset select_var = "" /cfif OPTION VALUE="#GetState.state_id#" #selected_var##GetState.state_name#/OPTION /CFLOOP /SELECTBR The CFOUTPUT for the Distributor query will make sure that the CF variables in the above bit of code get displayed correctly and the CFIF is to make sure that the distributors state is initially correctly selected from the complete list of states. Well, hope that helps. Regards Stephen Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
Paul, http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggraph9 9Notes.htm#course6 Daft question, but are you putting/generating the a name="course6"/a into your html page, so that the browser knows where to go when you give it an anchor name?? If you are, have you tried : http://inhouse/default.cfm#course6?MainPage=DesignTech/technews/Siggraph99/s iggraph99Notes.htm I'm not entirely convinced that this will work, but give it a go Regards Stephen Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFApplication and IE5.5 - not work properly!
That error should have nothing to do with IE5.5, or any browser. Have you verified that it still works in IE5.0, and other browsers? -- Billy Cravens [EMAIL PROTECTED] Philip Arnold - ASP wrote: I've just upgraded to IE5.5, and on an application that uses Application scope variables suddenly stopped working - this code worked perfectly on IE5.0 It gives me; "Attempt to access an Application variable when application management is not enabled. Use the CFAPPLICATION tag to enable application management. Note: This feature may have been disabled by the site administrator." Now, I KNOW that it's activated in the back office, and here's the code; cfApplication name="EBiz" ApplicationTimeOut="#CreateTimeSpan(0,1,0,0)#" cfif not isDefined("application.DPAfieldTransformation") cfscript application.DPAfieldTransformation=QueryNew("FieldName,DisplayName,FieldLeng th,Required,PRRequired"); And then the definitions It crashes on the first line of code in the CFScript (QueryNew) Any ideas anyone? Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
nope that didn't work either. and yes this is what i have for a link in the targeted frame. a href="#course6"Course #6: Fundamental Issues of Visual Perception for Effective Image Generation/a targeting a name="course6"/a any other ideas? again thank you -paul -Original Message- From: Stephen Moretti [SMTP:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 9:27 AM To: CF-Talk Subject: RE: Cfparam :: FrameSets :: Anchors oh my! Paul, http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggrap h9 9Notes.htm#course6 Daft question, but are you putting/generating the a name="course6"/a into your html page, so that the browser knows where to go when you give it an anchor name?? If you are, have you tried : http://inhouse/default.cfm#course6?MainPage=DesignTech/technews/Siggraph99 /s iggraph99Notes.htm I'm not entirely convinced that this will work, but give it a go Regards Stephen -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
Paul, frame NAME="MainPage" SRC="cfoutput#url.MainPage#/cfoutput" SCROLLING="AUTO" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder="NO" bordercolor="#FF" If, from the URL you gave us in your first email, default.cfm is the frameset, from which the above comes, then the anchor will never work, as your browser will look for course6 in default.cfm and not in the MainPage that you specify. I think the only way that you will get this to work is if you actually target the page to the frame, so that you will open "DesignTech/technews/Siggraph99/siggraph99Notes.htm#course6" in your frame "MainPage" rather than re-openning all of the frames from the top of your browser window via default.cfm. Hope this helps Regards Stephen Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Javascript Syntax for URL Parameters
This is a multi-part message in MIME format. --FA32DF5ABAE7BC9CB0762DD7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit What is the syntax for passing more than one URL parameter using javascript? Below I have it working for one parameter. SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- function newWin(id) { detWin = window.open('reassign.cfm?entry=' + id, 'detWin', 'scrollbars=yes,width=700,height=375,screenX=0,screenY=0,top=0,left=0') } //-- /SCRIPT --FA32DF5ABAE7BC9CB0762DD7 Content-Type: text/x-vcard; charset=us-ascii; name="jtaavon.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for James Taavon Content-Disposition: attachment; filename="jtaavon.vcf" begin:vcard n:Taavon;James tel;cell:(443) 506-2117 tel;fax:(410) 333-5203 tel;work:(410) 767-3415 x-mozilla-html:FALSE org:Department of Labor, Licensing and Regulation;Office of Information and Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Web Developer adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201; fn:James Taavon end:vcard --FA32DF5ABAE7BC9CB0762DD7-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: fusebox style: too much disk access?
!--- com_foo.cfm --- cfobject type="COM" class="MyClass.Foo" name="oFoo" action="CREATE" !--- end com_foo.cfm --- OK. Well, that sure buys me a lot, doesn't it? Admittedly, you might reuse some of the methods and properties, but then again you might not. The point of using COM, in my opinion, is that it IS an encapsulation - I simply instantiate the object, then use it. I don't need to encapsulate the encapsulation! You're totally right, it doesn't need it's own file. What if you put the cfobject call right in your index.cfm file? Maybe that's something Fusebox is missing. Actually, it does make perfect sense to put it in the index file because a cfobject call is essentially like making a cfmodule call except it's to a different platform. i love it! SEE! if you had just brought this up a long time ago! haha We'll often place significant amounts within stored procedures. Now, according to Fusebox, we should then place the stored procedure calls within separate "qry_" or "act_" files. Of course, since all the real code is in the stored procedure, and we often call the stored procedure using CFQUERY (as we can then cache the recordset using CFQUERY's caching attributes), we'd have something like this: !--- qry_foo.cfm --- cfquery name="foo" datasource="bar" cachedwithin="#CreateTimeSpan(0,1,0,0)#" { call myspFoo(#mynumericparam#, '#mytextparam#') } /cfquery !--- end qry_foo.cfm --- Again, not a lot of reuse value. In fact, at this point, using Fusebox seems to me to be just another layer of abstraction I'd have to deal with. ok here's why you still 'may' want to do this (you don't have to). It's not about reusing the query file, it's about reusing the display file. If you separate the cfquery call named "foo" from the display code (cfoutput query="foo") you can reuse that display code with a different query that has the same name. For example: cfcase value="fuseaction1" !--- assume this query file returns a query named "foo"--- cfinclude template="qry_davesstoredprocedure" cfinclude template="dsp_listfoo.cfm" /cfcase cfcase value="fuseaction2" !--- assume this query file returns a query named "foo" --- cfinclude template="qry_druckersstoredprocedure" cfinclude template="dsp_listfoo.cfm" /cfcase There just isn't that much CFML code to organize! The amount of organizational structure in Fusebox seems to me to exceed the amount of algorithmic content. sure, that makes sense. If you only have a couple lines of CFML, there really is no need for an architecture. How many .cfm files do your normal applications have? If there are more than 50, Fusebox is will make a difference, if there are more than 200, LOOK OUT! Fusebox kicks ass! Finally, I've never told anyone "don't use Fusebox". I've said that I don't think it's the best choice for everything, and that I don't use it. If you like it, go ahead and use it! But if you don't, don't use it just because "it's what everybody uses". Of course you shouldn't use it because it's what everybody uses, but if so many people think it makes sense, it shouldn't be ignored. Fusebox will only work in every application if every developer contributes to it. From this conversation you have just contributed something no one hadn't thought of before. I'm going to go bring up this topic of adding cfobject to the index.cfm file. Thanks baby. Steve Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: How to build a solid development team?
Mike, Don't you think you could take things a bit further? I feel that any successful project requires a distinct separation of duties on the "functional" side of things: middleware coders, dba's, network architects/administrators, object/component developers. Not to mention that each of those groups will probably be further split by experience level (senior, junior, etc.), in which there is more difference than just pay :) -- Billy Cravens [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
Philip, thanks, but i didnt work. here is my default frameset. --- cfparam name="url.TitleBar" default="default/_TOP.htm" cfparam name="url.ButtonBar" default="default/_LEFT.htm" cfparam name="url.MainPage" default="fs/fsrite.cfm" CF_Snip /frameset - the example you gave me just returned a 404. again thank you. Paul, Can you check the value of URL.MainPage when it's called? I just want to know if it includes the "#course6" If you want to jump to another position in a sub-frame, then I don't think you'll be able to do it with a normal bookmark, I _think_ HTML will think that you're jumping to a bookmark on the frame page which (obviously) won't exist. Can you try sending the bookmark jump on another URL variable? Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
session variables disappearing
I've written a CF application in 4.0.1 which works fine locally, but when I try to modify it and use it on a 4.5 remote server, I'm getting some weird actions. When a user logs into the application successfully, a number of session variables are written, and on their welcoming screen these variables are accessed and displayed. BUT whenever a user clicks a link to another page within the application, suddenly the session variables are gone (including the really important [for me] session.authorized and session.adminlevel and session.adminuid variables)... it also dumps the session.cfid and session.cftoken variables and creates new ones. Has anyone experienced anything like this before? What am I doing wrong? How can I fix it? Any help would be greatly appreciated. Thanks in advance, bw Bill Walthall "...now he knew what Shalimar knew: If you surrendered to the air, you could ride it" --Toni Morrison, Song of Solomon [EMAIL PROTECTED][EMAIL PROTECTED] www.billwalthall.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Do outer joins work in MS Access 2k?
Please excuse this Access question on the CF list; this query concerns a CF site and I've run out of places to ask! I'm having a heck of a time with a complex query. I can't seem to get outer joins to work in Access, either using the *= syntax or the LEFT OUTER JOIN ... ON syntax. The same query will work either way against the same database running on a SQL Server 7 db. Unfortunately, this query needs to run against the Access version of the DB due to ISP hosting constraints. Our data model calls for storing bits of information (actually a mailing list) as rows related to a master row in another table, data that normally would be stored in fields in the master row. Problems arose when we noticed that a couple of fields were null in many of the entries, necessitating the outer joins to get the data we want. The query involves three tables:, RS_link (the master table), subcategories (a table that stores a "type" characteristic for rows in RS_Link), and data (a table that stores attributes related to a row in RS_Link each in a separate row). To produce a single record per RS_Link entry requires joins of several aliased copies of the data table, one column extracted from the data table according to each alias. The idea was to join RS_Link and subcategories together first, then tack on an aliased data table for every column needed via an outer join. Any thoughts would be greatly appreciated! Here's the query: --- SELECT D1.dt_text AS FirstName, D2.dt_text AS LastName, D3.dt_text AS Address1, D4.dt_text AS Address2, D5.dt_text AS City, D6.dt_text AS State, D7.dt_text AS Zip, D8.dt_text AS Country, D9.dt_text AS Phone, D10.dt_text AS AltPhone, D11.dt_text AS Fax, D12.dt_text AS Email FROM subcategories AS S INNER JOIN rs_link AS RS ON RS.subcat_id=S.subcat_id) LEFT JOIN data AS D1 ON RS.r_id=D1.r_id) LEFT JOIN data AS D2 ON RS.r_id=D2.r_id) LEFT JOIN data AS D3 ON RS.r_id=D3.r_id) LEFT JOIN data AS D4 ON RS.r_id=D4.r_id) LEFT JOIN data AS D5 ON RS.r_id=D5.r_id) LEFT JOIN data AS D6 ON RS.r_id=D6.r_id) LEFT JOIN data AS D7 ON RS.r_id=D7.r_id) LEFT JOIN data AS D8 ON RS.r_id=D8.r_id) LEFT JOIN data AS D9 ON RS.r_id=D9.r_id) LEFT JOIN data AS D10 ON RS.r_id=D10.r_id) LEFT JOIN data AS D11 ON RS.r_id=D11.r_id) LEFT JOIN data AS D12 ON RS.r_id=D12.r_id WHERE S.area_id=2 And D1.q_id=34 And D2.q_id=35 And D3.q_id=20 And D4.q_id=21 And D5.q_id=23 And D6.q_id=22 And D7.q_id=24 And D8.q_id=25 And D9.q_id=26 And D10.q_id=36 And D11.q_id=28 And D12.q_id=27; - Thanks, Brian _ Brian Panulla [EMAIL PROTECTED] Elmwood Media Group 814.238.6680www.elmwoodmedia.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: session variables disappearing
are you setting these session variables in cfapplication? Test for their existence first. Also, check your session timeout settings. I'd start with these two things ~Simon -Original Message- From: Bill Walthall [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 9:46 AM To: CF-Talk Subject: session variables disappearing I've written a CF application in 4.0.1 which works fine locally, but when I try to modify it and use it on a 4.5 remote server, I'm getting some weird actions. When a user logs into the application successfully, a number of session variables are written, and on their welcoming screen these variables are accessed and displayed. BUT whenever a user clicks a link to another page within the application, suddenly the session variables are gone (including the really important [for me] session.authorized and session.adminlevel and session.adminuid variables)... it also dumps the session.cfid and session.cftoken variables and creates new ones. Has anyone experienced anything like this before? What am I doing wrong? How can I fix it? Any help would be greatly appreciated. Thanks in advance, bw Bill Walthall "...now he knew what Shalimar knew: If you surrendered to the air, you could ride it" --Toni Morrison, Song of Solomon [EMAIL PROTECTED] [EMAIL PROTECTED] www.billwalthall.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Migrating to Unix and ORACLE!
Okay this is much the same Q. as before regarding migrating to Sybase on a Unix platform - this time it is the pitfalls etc. encountered with moving to Oracle when you have been developing on a MSSQLServer 7 and NT base.? We are in the unhappy[happy?] situation of developing in NT with the job actually going to be on a Unix/Oracle box - what should we look out for? anything glaringly obvious except case and possibly SP's? anyone with this king of experince/oracle xperience? Neil ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: cferror
you can't put cfm commands on the cferror page, but you can set the error page to submit a form when it loads... post the form to another page that has your cfmail and whatever error message you wish to display. script language="JavaScript" type="text/javascript" !-- function submitform(){ document.ErrorSend.submit(); } //-- /script /head body OnLoad="submitform();" form action="error_send.cfm" method="post" name="ErrorSend" input type="hidden" name="Error.Diagnostics" value="#Error.Diagnostics#" input type="hidden" name="Error.MailTo" value="#Error.MailTo#" input type="hidden" name="Error.DateTime" value="#Error.DateTime#" input type="hidden" name="Error.Browser" value="#Error.Browser#" input type="hidden" name="Error.RemoteAddress" value="#Error.RemoteAddress#" input type="hidden" name="Error.HTTPReferer" value="#Error.HTTPReferer#" input type="hidden" name="Error.Template" value="#Error.Template#" input type="hidden" name="Error.QueryString" value="#Error.QueryString#" /form -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 12:09 PM To: CF-Talk Subject: cferror can you put cfm commands on a cferror page? application.cfm: cferror type="REQUEST" template="error.cfm" mailto="[EMAIL PROTECTED]" error.cfm cfmail to = "gavin" subject = "ERROR!!" AN ERROR HAS OCCURED AT: #error.datetime# #error.remoteaddress# #error.browser# #error.template# #error.querystring# /cfmail if i do this, the contents of the cfmail just show up and doesnt send out an e-mail to me thanks, Gavin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
write var into txt file and save
Hi all - I have a client that wants to be able to update a txt file with a var from a form field. I have been able to call the file with CFFILE "read" and the save with CFFILE "write", but it does not insert the new variable. I have also used CFHTTP and with CFHTTP.FileContent, which does input the var, but does not save it to the file. I have been pounding this for three days, and I think I shall go mad if i do not find a solution or at least a decent alternative. Any suggestions on how to make this work? Here's a two examples of what I have so far (1st Example) !--- insert.cfm --- form action="action.cfm" method="post" input type="text" name="new_name" input type="submit" value="Update File" /form !--- pass variable to action.cfm --- !--- which reads txt file --- cffile action="READ" file="C:\somedir\someroot\names.txt" variable ="TXTINPUT" !--- names.txt looks like --- #new_name# has updated this file. !--- then write the file with new var --- cffile action="WRITE" file="C:\somedir\someroot\names.txt" output=" #TXTINPUT#" addnewline="No" (2nd Example) !--- insert.cfm --- form action="action.cfm" method="post" input type="text" name="new_name" input type="submit" value="Update File" /form !--- pass variable to action.cfm --- !--- which reads txt as URL --- cfhttp url="http://www.somedomain.com/txtdir/names.txt" method="POST" resolveurl="false" cfset TXTINPUT = #CFHTTP.FileContent# /cfhttp !--- then write the file with new var --- cffile action="WRITE" file="C:\somedir\someroot\names.txt" output=" #TXTINPUT#" addnewline="No" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: session variables disappearing
Has anyone experienced anything like this before? What am I doing wrong? How can I fix it? The fact that you just upgraded to CF 4.5 may be throwing you off the trail of a totally different reason which may not have anything to do with the upgrade. Make sure you've double checked that cookies are enabled on the browser(s) in question. Also make sure that if there is a firewall or proxy server between your app and the browser(s), that it's setting have not been changed. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: write var into txt file and save
This is a multi-part message in MIME format. --=_NextPart_000_0005_01C03D04.54B3B1C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit you can do this by using the this Custom Tag - cf_FileWriteText FILE="myFileName.txt" cffile action="READ" file="myFileName.txt" variable="TempX" /cf_FileWriteText hope this helps. Neil ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- --=_NextPart_000_0005_01C03D04.54B3B1C0 Content-Type: application/octet-stream; name="CF_FileWriteText.cfm" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="CF_FileWriteText.cfm" CFSETTING ENABLECFOUTPUTONLY=3D"YES"!--- Suspend whitespace output = --- !--- Include tag name in all error messages --- CFSET ErrorHeader =3D"PBError Occurred in CF_FileWriteText = Tag./B/P" !--- Tag parameters --- CFIF NOT IsDefined("Attributes.File") CFABORT SHOWERROR=3D"#ErrorHeader# The FILE attribute is required." /CFIF CFPARAM NAME=3D"Attributes.Action" DEFAULT=3D"Write" !--- Make sure a closing tag exists in calling template --- CFIF NOT ThisTag.HasEndTag CFABORT SHOWERROR=3D"#ErrorHeader# You need to supply a closing = lt;CF_FileWriteTextgt; tag." /CFIF =20 !--- When the closing tag is encountered... --- CFIF ThisTag.ExecutionMode is "End" !--- Do different things based on ACTION parameter --- CFSWITCH EXPRESSION=3D"#Attributes.Action#" CFCASE VALUE=3D"Write" CFFILE FILE=3D"#Attributes.File#" ACTION=3D"WRITE" OUTPUT=3D"#ThisTag.GeneratedContent#" /CFCASE !--- If ACTION=3D"APPPEND" --- CFCASE VALUE=3D"Append" CFFILE FILE=3D"#Attributes.File#" ACTION=3D"APPEND" OUTPUT=3D"#ThisTag.GeneratedContent#" /CFCASE =20 !--- Must have been an invalid ACTION parameter --- CFDEFAULTCASE CFABORT SHOWERROR=3D"#ErrorHeader# You supplied an invalid ACTION = parameter. Only WRITE and APPEND are allowed." /CFDEFAULTCASE /CFSWITCH =20 !--- Set the tag's GeneratedContent value to empty string --- !--- so output doesn't get shown on web page --- CFSET ThisTag.GeneratedContent =3D "" /CFIF CFSETTING ENABLECFOUTPUTONLY=3D"NO"!--- Re-enable whitespace output = --- --=_NextPart_000_0005_01C03D04.54B3B1C0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: session variables disappearing
The fact your on a remote server might mean it's the domain attribute of your cfcookie tags.. either you're still setting them to match your old server.. or you might need to set them to match your new server, especially if there is a cluster involved.. I'd double check this... HTH, ---Mike -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 10:15 AM To: CF-Talk Subject:RE: session variables disappearing Has anyone experienced anything like this before? What am I doing wrong? How can I fix it? The fact that you just upgraded to CF 4.5 may be throwing you off the trail of a totally different reason which may not have anything to do with the upgrade. Make sure you've double checked that cookies are enabled on the browser(s) in question. Also make sure that if there is a firewall or proxy server between your app and the browser(s), that it's setting have not been changed. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: cfhttp problems/getting system information from users i.e. cpu speed/ram
Here is the address. I would like for the people in my office to be able to go here, and run the tests. The tests generate webpages that have all of the information into forms which they put into their database. I need to figure out a way to grab the data out of the forms and put it into our database. Just so that we have a record of what everyon'e system is so if someone says they have a problem, we can just check the db now they have a pIII 600 with 128 megs RAM, etc. http://wintune.winmag.com Thanks, Eddie -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 5:56 PM To: CF-Talk Cc: [EMAIL PROTECTED] Subject: RE: cfhttp problems/getting system information from users i.e. cpu speed/ram You know, now that I've re-read your message, I think I understand what you're trying to do. Could you send us the URL for the site you're talking about? ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 1:55 PM To: CF-Talk Subject: RE: cfhttp problems/getting system information from users i.e. cpu speed/ram Help me to understand how using only HTML (or ColdFusion generated HTML) you could find out that information about someone's system. CFHTTP is usually used for fetching files (URLs). -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 1:03 PM To: CF-Talk Subject: cfhttp problems/getting system information from users i.e. cpu speed/ram Hello, I am having trouble using cfhttp, everytime I us it I get a connection error, I have read that this is caused by the firewall, is this true? What I am trying to do is have our employees go to a website that runs a check on their system, i.e. hard drive, ram, speed, etc. the website saves all this information into its database but we want to somehow use cf to save it into ours and I thought the cfhttp tag might help...any suggestions?? THanks, Eddie -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFHTTP - how to continue when there is a broken url
Hi guys, Scenario: I have a few servers in different location. When the new record is added to Master (Central) Database. My code should automatically update the rest of the server in different locations. Code: cfoutput query="q_Server" cfhttp method="Post" url="#Trim(ServerURL)#/UpdateDB.cfm" timeout="10" cfhttpparam name="FirstName" value="ABC" type="FORMFIELD" /cfhttp /cfoutput Problem: When there is an invalid Server's URL, the cfhttp will return error message and stop executing. Expected: I need CFHTTP to continue executing until end of records, and returns the list of invalid Server's URL. Your idea are most welcome. Thanks in advance. - Rudy Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: wddx deserialize
The serialized packet is identical the packet I am trying to deserialize. I wrote a test app removing all but the serialization and deserialization. Run-time error '438' Object doesn't support this property or method Thanks -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 9:15 AM To: CF-Talk Subject: Re: wddx deserialize What's the error? What does the packet look like? You can check it using: cfoutput#HTMLEditFormat(XMLResult)#/cfoutput -David On Mon, 23 Oct 2000 08:52:09 -0400 Gary Davidson [EMAIL PROTECTED] writes: I am posting from CF via SOAP a WDDX packet representing a WDDX recordset. Using the com DLL provided, I receive an error when I attempt to deserialize the packet. Any Help? wddxrs = obj.deserialize(XMLResult) XMLResult is a serialized WDDX recordset. obj is a WDDXDeserializer Gary Davidson Corporate Data Architect Mortgage.com - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cfparam :: FrameSets :: Anchors oh my!
thanks. so sending an email link, to users on our intranet that would pull up the frame sets the target anchor wont work? thanks again -paul If, from the URL you gave us in your first email, default.cfm is the frameset, from which the above comes, then the anchor will never work, as your browser will look for course6 in default.cfm and not in the MainPage that you specify. I think the only way that you will get this to work is if you actually target the page to the frame, so that you will open "DesignTech/technews/Siggraph99/siggraph99Notes.htm#course6" in your frame "MainPage" rather than re-openning all of the frames from the top of your browser window via default.cfm. Hope this helps Regards Stephen -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Javascript Syntax for URL Parameters
'reassign.cfm?entry=' + id + 'param2=' + param2, 'detWin', Also, you'll want to use the JS escape function around the variables if they contain spaces or other troublesome characters. That'd be: 'reassign.cfm?entry=' + escape(id) + 'param2=' + escape(param2), 'detWin', -David On Mon, 23 Oct 2000 09:41:36 -0400 James Taavon [EMAIL PROTECTED] writes: What is the syntax for passing more than one URL parameter using javascript? Below I have it working for one parameter. function newWin(id) { detWin = window.open('reassign.cfm?entry=' + id, 'detWin', 'scrollbars=yes,width=700,height=375,screenX=0,screenY=0,top=0,left=0') YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_MENSCH Awards
i would like to nominate Mike Grundivig, for his continued patience! : ] And also Stephen Moretti, JJ Frausto, CF_Scott for thier help as well. thanks again -paul Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Cardservice International
Does anyone have any experience (good or bad) with Cardservice International as a payment provider? They have an available ColdFusion tag that can be used for on-line transactions. From their literature: = To support storefront development in Windows platforms, Cardservice has developed a custom ColdFusion Tag, which provides the same functionality as the API. The LinkPoint ColdFusion Tag (LCFX)is a built-in utility to be used with the LinkPoint API. LCFX provides all the functionality of the LinkPoint API and eliminates the necessity of the user knowing C++. For more information, e-mail [EMAIL PROTECTED] or download the manual. = Thanks in advance, Howie Hamlin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFX tags
Hi, Could someone resolve an argument I've been having all day with a colleague about CFX tags? I'm hardly an expert on CF, but am pretty sure that to create CFX tags, you don't just press an "Export to CFX DLL" button :) Am I right in thinking you have to write it in a different lanugage? Thanks in advance? Will Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: How to build a solid development team?
Definitely.. But I save those details for my late night Self Help/How-To series on PBS... All donations go to helping others coughmy bank account/cough.. :-) Seriously.. You're absolutely right if you're building a large application using multiple technologies (CF, Java, COM, etc..). you will probably need to divide up your functional team into the different types of developers. But I'm betting most web apps pick one technology and build it in that technology, with maybe one or two small pieces of other technologies.. Then you bring in the right kind of developer for that single piece, or maybe buy it... At least that's what I've noticed. As for Network Administrators and dba's. You need them! But they usually end up in their own groups (look to your local IS department) that all of the development teams utilize as needed.. Since they are usually only involved on any single project for short periods of time. As for having senior and junior members, you will have/need them but be careful not to make one team to big, compared to the other two, or to have to big gap between skill sets, otherwise the senior developers will end up having to do almost all of the work, plus find time to teach the more junior developers. And under a deadline this can cause a lot of stress.. That's why I recommend starting Junior developers in group 3, hopefully they won't stay there long. And you can get an idea of how they might work with your more seasoned developers without causing lot's of stress.. But then again this all really depends on your teams dynamics/personalities.. But this is just my simple opinion, Mike -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 9:38 AM To: CF-Talk Subject:Re: How to build a solid development team? Mike, Don't you think you could take things a bit further? I feel that any successful project requires a distinct separation of duties on the "functional" side of things: middleware coders, dba's, network architects/administrators, object/component developers. Not to mention that each of those groups will probably be further split by experience level (senior, junior, etc.), in which there is more difference than just pay :) -- Billy Cravens [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Cardservice International
I have used the LinkPoint CFX Tag and it works great. Once the account it set up and the Tag is installed everything worked great for me. At 11:13 AM 10/23/2000 -0400, you wrote: Does anyone have any experience (good or bad) with Cardservice International as a payment provider? They have an available ColdFusion tag that can be used for on-line transactions. From their literature: = To support storefront development in Windows platforms, Cardservice has developed a custom ColdFusion Tag, which provides the same functionality as the API. The LinkPoint ColdFusion Tag (LCFX)is a built-in utility to be used with the LinkPoint API. LCFX provides all the functionality of the LinkPoint API and eliminates the necessity of the user knowing C++. For more information, e-mail [EMAIL PROTECTED] or download the manual. = Thanks in advance, Howie Hamlin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- Nick McClure[EMAIL PROTECTED] Technical Director 859.245.9656 squareFish Mediawww.squareFish.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFX tags
CFX tags can be written in C++, Java and Delphi. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 11:18 AM Subject: CFX tags Hi, Could someone resolve an argument I've been having all day with a colleague about CFX tags? I'm hardly an expert on CF, but am pretty sure that to create CFX tags, you don't just press an "Export to CFX DLL" button :) Am I right in thinking you have to write it in a different lanugage? Thanks in advance? Will -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
HELP! Local variables confused between sessions
I have a simple form that allows users to upload a file (using a file type form variable). They also must enter their school district and an email address.All fields are required (and the action page checks- I'm not relying on javascript alone). I'm only using form and local variables. After successfully processing the file, the user gets an email stating that we have successfully processed the file for [district name]. Twice now, I have been notified that users have gotten emails for the wrong district! How can this be? (BTW, it can't be that the user just selected the wrong district, because it has to match what's in the file.) I have absolutely no idea, and this scares me. Part of this file processing involves writing it out line by line to a new file (after all kinds of nitpicking validations), and I'm concerned that the variables are somehow getting mixed up between sessions, and that the output files may be worthless. (I can't easily check them at this point, either.) Please help! Thanks, Carol Chandler Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFApplication and IE5.5 - not work properly!
That error should have nothing to do with IE5.5, or any browser. Have you verified that it still works in IE5.0, and other browsers? I down-graded to IE5.01 (uninstalled 5.5) and it worked perfectly - it only happens in IE5.5 (from what I've seen) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFX tags
Your friend is buying lunch... C++ or Java Jim - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 11:18 AM Subject: CFX tags Hi, Could someone resolve an argument I've been having all day with a colleague about CFX tags? I'm hardly an expert on CF, but am pretty sure that to create CFX tags, you don't just press an "Export to CFX DLL" button :) Am I right in thinking you have to write it in a different lanugage? Thanks in advance? Will -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Smart renames on images?
Hi folks, I've got a project that requires that all images that are uploaded are named uniquely. This would usually be a simple case of using the MAKEUNIQUE attribute in CFFILE but the client is picky about the names of the incoming files. Therefore, the original name must be preserved. If the desired filename already exists on the server, I need to let the user know, and rename the file accordingly. What's the easiest and most efficent way to handle this? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SQL Server equivalent of Access' compact database
Is there a SQL Server equivalent of Access' "compact database"? I would like to dump all the data in certain tables and for the Identity fields to start renumbering from 1. Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFApplication and IE5.5 - not work properly!
Are you launching new windows in your app. I believe that 5.5 (can't remember 5.0) has an option to launch windows in separate processes.. And although I haven't confirmed it I have heard that these separate process have different cookie sets also.. A thought, Mike -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:17 AM To: CF-Talk Subject:RE: CFApplication and IE5.5 - not work properly! That error should have nothing to do with IE5.5, or any browser. Have you verified that it still works in IE5.0, and other browsers? I down-graded to IE5.01 (uninstalled 5.5) and it worked perfectly - it only happens in IE5.5 (from what I've seen) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Query Trouble
You want a LEFT JOIN: Select messages.fieldname, users.fieldname, [more fields] FROM messages LEFT JOIN users ON messages.userID = users.userID -Original Message- From: Russell Jones [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 21, 2000 12:10 PM To: CF-Talk Subject: Query Trouble In a forum app, I have a table of messages that I'm going to query for display. A field in that table is called "UserID". Everywhere that "UserID" is not "0", I'd like to query another table for that person's user info. Q: Is this something I could do all in one query, or should I do the first part as one query and then worry about a second query where necessary while I'm outputting the first one .. I'm not sure if this calls for a JOIN, a Left JOIN, a UNION or what ... Any ideas? Thanks -Russ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HELP! Local variables confused between sessions
How are you maintaining client state between/among templates? Are you using any method other than local/form variables to maintain this state? Mike "Outside of a dog, a book is man's best friend. Inside of a dog it is too dark to read." -Groucho Marx -Original Message- From: Carol Chandler [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:20 AM To: CF-Talk Subject: HELP! Local variables confused between sessions I have a simple form that allows users to upload a file (using a file type form variable). They also must enter their school district and an email address.All fields are required (and the action page checks- I'm not relying on javascript alone). I'm only using form and local variables. After successfully processing the file, the user gets an email stating that we have successfully processed the file for [district name]. Twice now, I have been notified that users have gotten emails for the wrong district! How can this be? (BTW, it can't be that the user just selected the wrong district, because it has to match what's in the file.) I have absolutely no idea, and this scares me. Part of this file processing involves writing it out line by line to a new file (after all kinds of nitpicking validations), and I'm concerned that the variables are somehow getting mixed up between sessions, and that the output files may be worthless. (I can't easily check them at this point, either.) Please help! Thanks, Carol Chandler Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarlists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Smart renames on images?
I'd say run a check first so if the name is taken have the user rename the file themself, if not you'll have to write sometime where it is the name of the file plus a number or something like that. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:29 AM To: CF-Talk Subject: Smart renames on images? Hi folks, I've got a project that requires that all images that are uploaded are named uniquely. This would usually be a simple case of using the MAKEUNIQUE attribute in CFFILE but the client is picky about the names of the incoming files. Therefore, the original name must be preserved. If the desired filename already exists on the server, I need to let the user know, and rename the file accordingly. What's the easiest and most efficent way to handle this? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Smart renames on images?
CFTRY and CFCATCH to capture the 'file already exists' error -Original Message- From: Jamie Keane [SMTP:[EMAIL PROTECTED]] Sent: 23 October 2000 16:29 To: CF-Talk Subject: Smart renames on images? Hi folks, I've got a project that requires that all images that are uploaded are named uniquely. This would usually be a simple case of using the MAKEUNIQUE attribute in CFFILE but the client is picky about the names of the incoming files. Therefore, the original name must be preserved. If the desired filename already exists on the server, I need to let the user know, and rename the file accordingly. What's the easiest and most efficent way to handle this? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Smart renames on images?
I've got a project that requires that all images that are uploaded are named uniquely. This would usually be a simple case of using the MAKEUNIQUE attribute in CFFILE but the client is picky about the names of the incoming files. Therefore, the original name must be preserved. If the desired filename already exists on the server, I need to let the user know, and rename the file accordingly. What's the easiest and most efficent way to handle this? Do they have to be names correctly on the server, or just when they are downloaded back to the client again? There are different filename two parameters which would help you do that. File.ServerFile is the unique name on the server, but File.ClientFile is the original name of the file before it was made unique. You can always store BOTH these names in the DB so that you can preserve the filename in listings and such in the application. If a file is downloaded out of the app, you can also apply the original name back again to fake out the users into thinking it was always named that on the server. If they actually need it to be named correctly on the server itself (boy that is picky), then you'll want to read up no the NAMECONFLICT="Error" attribute of the CFFILE tag. You should be able to use this along with CFTRY/CFCASE to handle the error and give the user some options on renaming it. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access' compact database
Enterprise Manager - Database - [Your DB] - All Tasks - Shrink DB. as for resetting the auto-numbers [?] N ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HELP! Local variables confused between sessions
I'm not doing anything other than using local and form variables. Is that some incredibly stupid mistake? I'm actually a reasonably seasoned programmer, but fairly new to CF - as is everyone else in my department. We don't have any CF "alpha geeks" around to notice dumb mistakes. The only application we have used client or session variables is our controlled access stuff. Carol [EMAIL PROTECTED] 10/23/00 10:33AM How are you maintaining client state between/among templates? Are you using any method other than local/form variables to maintain this state? Mike "Outside of a dog, a book is man's best friend. Inside of a dog it is too dark to read." -Groucho Marx -Original Message- From: Carol Chandler [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:20 AM To: CF-Talk Subject: HELP! Local variables confused between sessions I have a simple form that allows users to upload a file (using a file type form variable). They also must enter their school district and an email address.All fields are required (and the action page checks- I'm not relying on javascript alone). I'm only using form and local variables. After successfully processing the file, the user gets an email stating that we have successfully processed the file for [district name]. Twice now, I have been notified that users have gotten emails for the wrong district! How can this be? (BTW, it can't be that the user just selected the wrong district, because it has to match what's in the file.) I have absolutely no idea, and this scares me. Part of this file processing involves writing it out line by line to a new file (after all kinds of nitpicking validations), and I'm concerned that the variables are somehow getting mixed up between sessions, and that the output files may be worthless. (I can't easily check them at this point, either.) Please help! Thanks, Carol Chandler Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarlists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Slightly OT : How many accounts can my server handle?
Hello, I realize that there are many factors in determining how many sites a server can handle are, but i'm just looking for guidelines. The server information is below, and lets assume that an average site on the server uses ColdFusion and Access or SQL Server 7.0 and uses 1 Gig of bandwidth a month. Lets also assume that I would use Virtual Directories instead of unique IP addresses for each account. How many sites would you say this server could handle? Thanks in advance for any help! Hardware: - Pentium 600MHz - 256MB RAM - 20GB EIDE hard drive Software: - Windows NT 4(with most recent service pack) - IIS 4.0 - Primary DNS Server - SQL Server 7.0 - ColdFusion Server 4.5 Professional - MS Access Craig Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: How to build a solid development team?
Everyone is going to have a different answer for this that depends on the kind of projects they usually do. For us there are 6 skill sets we need. This may or may not mean 6 different people. We are lucky to have some people with excellent skills in more than one area. However sometimes we need to bring in freelancers to round out a project team. (1) Site Architect: high level, overall "big picture". Designs the entire project. Has to know some of all the technologies involved including scalability issues, hosting issues, etc. Project management of team. (2) Graphic web designer. Artist HTML. (3) Database programmer. Designs the schema, Stored procedures, writes the queries. Later does database tuning. (4) mid-level Application programmer - Cold Fusion front end (5) high-level Application programmer - Cold Fusion back end (modules, functions, etc) (6) And a network engineer/system administrator that is shared among all teams who builds the servers, sets up the databases, web servers, load balancing routers, performance tuning, security, etc. At 09:25 PM 10/22/00 -0500, Julie McKellar wrote: This is a multi-part message in MIME format. --=_NextPart_000_016D_01C03C6E.A5584AF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Could any of you give me some insight as to how your development team is built? How many junior, mid, senior developers, lead developers, application architects, database administratorsetc.?? Basically, if you are working for a company, how is your development = team structured? I am trying to decide the best way to build a development = team that will be responsible for building applications and integrating = acquired applications. Thanks so much! Julie McKellar --=_NextPart_000_016D_01C03C6E.A5584AF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN" Could any of you give me some insight as to how your development = team=20 is built? How many junior, mid, senior developers, lead=20 developers, application architects, database=20 administratorsetc.?? Basically, if you are working for a = company, how=20 is your development team structured? I am trying to decide the = best way=20 to build a development team that will be responsible for building=20 applications and integrating acquired applications. Thanks so=20 much! Julie McKellar --=_NextPart_000_016D_01C03C6E.A5584AF0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CF Job Sites...an OT question
I know this is off topic, so I will be brief. I am in search of a new ColdFusion position and I have been looking for some good web sites specifically targeted to my skill set: CF 4.5, SQL, JavaScript and HTML. I have reactivated my monster.com and dice.com accounts, but don't know where to go from here. If any one has any suggestions, please mail me off list. Any comments and/or suggestions would be greatly appreciated. Thank you. Ryan John Williams (h) 240-632-9688 message: 202-756-4100 x1435 [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Smart renames on images?
What type of error is returned from an unsuccessful upload? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Cameron Childress [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, October 23, 2000 11:35 AM Subject: RE: Smart renames on images? I've got a project that requires that all images that are uploaded are named uniquely. This would usually be a simple case of using the MAKEUNIQUE attribute in CFFILE but the client is picky about the names of the incoming files. Therefore, the original name must be preserved. If the desired filename already exists on the server, I need to let the user know, and rename the file accordingly. What's the easiest and most efficent way to handle this? Do they have to be names correctly on the server, or just when they are downloaded back to the client again? There are different filename two parameters which would help you do that. File.ServerFile is the unique name on the server, but File.ClientFile is the original name of the file before it was made unique. You can always store BOTH these names in the DB so that you can preserve the filename in listings and such in the application. If a file is downloaded out of the app, you can also apply the original name back again to fake out the users into thinking it was always named that on the server. If they actually need it to be named correctly on the server itself (boy that is picky), then you'll want to read up no the NAMECONFLICT="Error" attribute of the CFFILE tag. You should be able to use this along with CFTRY/CFCASE to handle the error and give the user some options on renaming it. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Slightly OT : How many accounts can my server handle?
Erm, yes and no; CF and SQL Server can happily sit on the same box. Unless you are expecting some serious load and I mean serious load 100,000 + ! :-) ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Smart renames on images?
What type of error is returned from an unsuccessful upload? I'm not sure. I would suggest you try them all at once and see which one trips. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
case sensitivity in structures
are values in structures case sensitive? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Parent/Child CFML Tags
Caller is a scope that lets you access the parent variables. imagine foo.cfm and bar.cfm foo.cfm cfset x=1 cf_bar y=2 bar.cfm cfoutput #caller.x# #attributes.y# /cfoutput cfset caller.x=3 Jaime/ -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 21, 2000 7:05 AM To: CF-Talk Subject: RE: Parent/Child CFML Tags Hi All How do you get the child tag to access the attributes of the parent? cf_MyParentTag Attrib1="test1" Attrib2="test2" cf_MyChildTag ShowAttrib="Attrib1" /cf_MyParentTag Also how do you pass data from the parent tag to the child tag without using the request scope? For instance if I set a variable called X in the parent how do I out put it in the child TIA, Duane -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SQL UPDATE question (was Update Query/Output question from a newbie)
Hi again to everyone, I would like to thank Stephen and Bret for their help earlier. I managed to get things working on the update form, although I haven't moved to the state_id rather than the state_name system yet. I still receive errors (ColdFusion was unable to determine the value of the parameter) with #selected_var# using Steven's method, but Bret's works fine. Now I have yet another problem on my update action page and although I am learning SQL at the moment I don't have enough knowledge to understand what I should do here. I would like to note that CFUPDATE DATASOURCE="dbcms" TABLENAME="tbldistrib", works great. I would, however, like to learn the proper SQL for the update action because I have been told that it is much better than CFUPDATE. Please correct me if I am mistaken. Any help with this will be much appreciated. My Query is as follows: CFQUERY DATASOURCE="dbcms" UPDATE tbldistrib SET distrib_name='#Form.distrib_name#', distrib_city='#Form.distrib_city#', distrib_state='#Form.distrib_state#', distrib_phone='#Form.distrib_phone#' WHERE distrib_id = '#distrib_id#' /CFQUERY I have a hidden field in my update form for the distributor ID: INPUT TYPE="hidden" NAME="distrib_id" Value="#distrib_id#" The error I receive is: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. SQL = "UPDATE tbldistrib SET distrib_name='Calico Corners III', distrib_city='Charlston', distrib_state='SOUTH CAROLINA', distrib_phone='555-555-' WHERE distrib_id = '31'" Data Source = "DBCMS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:29) in the template file c:\inetpub\wwwroot\cms\updatedata.cfm. Thanks for your time, Mike Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL UPDATE question (was Update Query/Output question from a newbie)
Probably because the distrib_id field is of type integer. Try removing the quotes around it in the where clause so you've got: WHERE distrib_id = #distrib_id# -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: 23 October 2000 17:45 To: CF-Talk Subject: SQL UPDATE question (was Update Query/Output question from a newbie) Hi again to everyone, I would like to thank Stephen and Bret for their help earlier. I managed to get things working on the update form, although I haven't moved to the state_id rather than the state_name system yet. I still receive errors (ColdFusion was unable to determine the value of the parameter) with #selected_var# using Steven's method, but Bret's works fine. Now I have yet another problem on my update action page and although I am learning SQL at the moment I don't have enough knowledge to understand what I should do here. I would like to note that CFUPDATE DATASOURCE="dbcms" TABLENAME="tbldistrib", works great. I would, however, like to learn the proper SQL for the update action because I have been told that it is much better than CFUPDATE. Please correct me if I am mistaken. Any help with this will be much appreciated. My Query is as follows: CFQUERY DATASOURCE="dbcms" UPDATE tbldistrib SET distrib_name='#Form.distrib_name#', distrib_city='#Form.distrib_city#', distrib_state='#Form.distrib_state#', distrib_phone='#Form.distrib_phone#' WHERE distrib_id = '#distrib_id#' /CFQUERY I have a hidden field in my update form for the distributor ID: INPUT TYPE="hidden" NAME="distrib_id" Value="#distrib_id#" The error I receive is: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. SQL = "UPDATE tbldistrib SET distrib_name='Calico Corners III', distrib_city='Charlston', distrib_state='SOUTH CAROLINA', distrib_phone='555-555-' WHERE distrib_id = '31'" Data Source = "DBCMS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:29) in the template file c:\inetpub\wwwroot\cms\updatedata.cfm. Thanks for your time, Mike Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: write var into txt file and save
You don't need a custom tag to do this. You need to use the Append action of the cffile tag. --K -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 7:17 AM To: CF-Talk Subject: RE: write var into txt file and save This is a multi-part message in MIME format. --=_NextPart_000_0005_01C03D04.54B3B1C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit you can do this by using the this Custom Tag - cf_FileWriteText FILE="myFileName.txt" cffile action="READ" file="myFileName.txt" variable="TempX" /cf_FileWriteText hope this helps. Neil ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- --=_NextPart_000_0005_01C03D04.54B3B1C0 Content-Type: application/octet-stream; name="CF_FileWriteText.cfm" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="CF_FileWriteText.cfm" CFSETTING ENABLECFOUTPUTONLY=3D"YES"!--- Suspend whitespace output = --- !--- Include tag name in all error messages --- CFSET ErrorHeader =3D"PBError Occurred in CF_FileWriteText = Tag./B/P" !--- Tag parameters --- CFIF NOT IsDefined("Attributes.File") CFABORT SHOWERROR=3D"#ErrorHeader# The FILE attribute is required." /CFIF CFPARAM NAME=3D"Attributes.Action" DEFAULT=3D"Write" !--- Make sure a closing tag exists in calling template --- CFIF NOT ThisTag.HasEndTag CFABORT SHOWERROR=3D"#ErrorHeader# You need to supply a closing = lt;CF_FileWriteTextgt; tag." /CFIF =20 !--- When the closing tag is encountered... --- CFIF ThisTag.ExecutionMode is "End" !--- Do different things based on ACTION parameter --- CFSWITCH EXPRESSION=3D"#Attributes.Action#" CFCASE VALUE=3D"Write" CFFILE FILE=3D"#Attributes.File#" ACTION=3D"WRITE" OUTPUT=3D"#ThisTag.GeneratedContent#" /CFCASE !--- If ACTION=3D"APPPEND" --- CFCASE VALUE=3D"Append" CFFILE FILE=3D"#Attributes.File#" ACTION=3D"APPEND" OUTPUT=3D"#ThisTag.GeneratedContent#" /CFCASE =20 !--- Must have been an invalid ACTION parameter --- CFDEFAULTCASE CFABORT SHOWERROR=3D"#ErrorHeader# You supplied an invalid ACTION = parameter. Only WRITE and APPEND are allowed." /CFDEFAULTCASE /CFSWITCH =20 !--- Set the tag's GeneratedContent value to empty string --- !--- so output doesn't get shown on web page --- CFSET ThisTag.GeneratedContent =3D "" /CFIF CFSETTING ENABLECFOUTPUTONLY=3D"NO"!--- Re-enable whitespace output = --- --=_NextPart_000_0005_01C03D04.54B3B1C0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CF in permanent infinite restart loop
Somehow our CF 4.01 on Solaris 2.6 had gotten caught in an infinite loop of restarts. About every ten seconds it restarts, and constantly refuses all cfm service. I've tried stopping/starting CF, iPlanet webserver, and the Unix computer. I've tried Allaire's recomendation of "stop -force", then delete ServicePid and ServiceRunning (KB 11501) - but that hasn't worked. The start script is okay (replaced with a backup) and the odbc.ini file is okay. No templates can run because the server is too busy constantly restarting itself - so it's not a template problem. Any ideas out there? thanks, Chris Norloff Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CF_STRIP_EMAIL_SHOWME_DOMAIN
Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Javascript Syntax for URL Parameters
This is a multi-part message in MIME format. --661E1EC5AC28210FB105F079 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit thanks, i will try it out. David Shadovitz wrote: 'reassign.cfm?entry=' + id + 'param2=' + param2, 'detWin', Also, you'll want to use the JS escape function around the variables if they contain spaces or other troublesome characters. That'd be: 'reassign.cfm?entry=' + escape(id) + 'param2=' + escape(param2), 'detWin', -David On Mon, 23 Oct 2000 09:41:36 -0400 James Taavon [EMAIL PROTECTED] writes: What is the syntax for passing more than one URL parameter using javascript? Below I have it working for one parameter. function newWin(id) { detWin = window.open('reassign.cfm?entry=' + id, 'detWin', 'scrollbars=yes,width=700,height=375,screenX=0,screenY=0,top=0,left=0') YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --661E1EC5AC28210FB105F079 Content-Type: text/x-vcard; charset=us-ascii; name="jtaavon.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for James Taavon Content-Disposition: attachment; filename="jtaavon.vcf" begin:vcard n:Taavon;James tel;cell:(443) 506-2117 tel;fax:(410) 333-5203 tel;work:(410) 767-3415 x-mozilla-html:FALSE org:Department of Labor, Licensing and Regulation;Office of Information and Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Web Developer adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201; fn:James Taavon end:vcard --661E1EC5AC28210FB105F079-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cardservice International
Howie, Call and ask for Chuck Taylor. I've used them in the past and Chuck is very knowledgeable about tying them in with various merchant services (AuthNet, CyberCash, etc.). Cheers, --David L. Rice Web Applications Developer Nation Tax, Inc. [EMAIL PROTECTED] Direct: 205.380.8164 eFax: 253.550.8239 Demo our services @ www.nationtax.com --- -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 10:13 AM To: CF-Talk Subject: Cardservice International Does anyone have any experience (good or bad) with Cardservice International as a payment provider? They have an available ColdFusion tag that can be used for on-line transactions. From their literature: = To support storefront development in Windows platforms, Cardservice has developed a custom ColdFusion Tag, which provides the same functionality as the API. The LinkPoint ColdFusion Tag (LCFX)is a built-in utility to be used with the LinkPoint API. LCFX provides all the functionality of the LinkPoint API and eliminates the necessity of the user knowing C++. For more information, e-mail [EMAIL PROTECTED] or download the manual. = Thanks in advance, Howie Hamlin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_STRIP_EMAIL_SHOWME_DOMAIN
I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Didn't test it, but something along these lines should do the trick CFSET EmailAddress = '[EMAIL PROTECTED]' CFSET Domain = ListGetAt(EmailAddress, 2 , '@') CFSET URL = 'www.' Domain CFOUTPUT#URL#/CFOUTPUT -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFApplication and IE5.5 - not work properly!
Are you launching new windows in your app. I believe that 5.5 (can't remember 5.0) has an option to launch windows in separate processes.. And although I haven't confirmed it I have heard that these separate process have different cookie sets also.. If only this was the case - all I did was start the machine, then go to the website I only use one set of Application scope variables on this website (to stop re-loading) and this crashes (apparently) on IE5.5 only - it works perfectly on IE4-5 and NS4-4.7 I've currently ripped the Application scope off of it to get it working (can't have clients not being able to update their websites) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
An Idea about access and paragraphs
Hi everyone, So, here's my idea. Access cannot literally store paragraphs however you can always put in P at the start of each paragraph/line and achieve the the paragraphs. The drawback to this is that if it is left up to the regular user, they'll probably mess it up. So, this is the idea. Is there a way to detect a paragraph break, then when you submit the page, the paragraph break is detected, and then replaced with a P tag. Therefor all the user has to do, is put in a normal paragraph. Mark Smeets/stranger0/ICQ #1062196 "Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two" - Wild Wild West Official Splitting Adam Homepage http://www.splittingadam.com/ Over the Wall Productions and Web Designs http://www.solarcourt.com/ _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_STRIP_EMAIL_SHOWME_DOMAIN
you could do something like: cfset myvar = listgetat(emailaddy,1,"@") CFSET mynewvar = "www." myvar if you wanted to. ~Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:58 AM To: CF-Talk Subject: CF_STRIP_EMAIL_SHOWME_DOMAIN Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CF_STRIP_EMAIL_SHOWME_DOMAIN
Try: cfset newstr="www"left(emailaddr,find("@",emailaddr)-1) Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 11:57 AM Subject: CF_STRIP_EMAIL_SHOWME_DOMAIN Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFTRY CFCATCH
Ok I want to try and make an application able to not error out so I want to encase the entire processing (end part) with cftry and cfcatch. Now I have used it before but I am a little fuzzy as to how it would work with testing out multiple file updates and deletes. Would it take out any tested data or will it leave it in there? Robert Everland III Web Developer Dixon Ticonderoga Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Cardservice International
They're pretty good, i've used them in the past. You can probably find better rates than what they offer. Honestly, i haven't noticed a difference between any of the merchant banks other than their rates. You almost rarely ever have to deal with them, although I'm not doing millions of transactions a day, so I can't speak for problems involved with those numbers of transactions. CardService is one of the biggest merchant banks if not the biggest. Try and negotiate a better deal with them, do a simple search on yahoo for "accept credit cards", get the rates from other merchant banks before you pick one. You might also take a look at Authorize.net, integrating authorize.net is much easier and cheaper than something like cybercash. It's just a simple https form, there are a couple free CF_authorizenet tags out there. Steve Nelson Howie Hamlin wrote: Does anyone have any experience (good or bad) with Cardservice International as a payment provider? They have an available ColdFusion tag that can be used for on-line transactions. From their literature: = To support storefront development in Windows platforms, Cardservice has developed a custom ColdFusion Tag, which provides the same functionality as the API. The LinkPoint ColdFusion Tag (LCFX)is a built-in utility to be used with the LinkPoint API. LCFX provides all the functionality of the LinkPoint API and eliminates the necessity of the user knowing C++. For more information, e-mail [EMAIL PROTECTED] or download the manual. = Thanks in advance, Howie Hamlin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_STRIP_EMAIL_SHOWME_DOMAIN
excuse me... I meant listgetat(emailaddress,2,"@") (that's 2, not 1). It's been a rough morning. ~Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:58 AM To: CF-Talk Subject: CF_STRIP_EMAIL_SHOWME_DOMAIN Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_STRIP_EMAIL_SHOWME_DOMAIN
Jaime strikes again with his list functions! cfset www="www." ListGetAt("[EMAIL PROTECTED]", 2, '@') Over-simplistic. You add more ifs, and what not... Jaime/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 8:58 AM To: CF-Talk Subject: CF_STRIP_EMAIL_SHOWME_DOMAIN Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Slightly OT : How many accounts can my server handle?
I realize that there are many factors in determining how many sites a server can handle are, but i'm just looking for guidelines. The server information is below, and lets assume that an average site on the server uses ColdFusion and Access or SQL Server 7.0 and uses 1 Gig of bandwidth a month. Lets also assume that I would use Virtual Directories instead of unique IP addresses for each account. How many sites would you say this server could handle? Thanks in advance for any help! Hardware: - Pentium 600MHz - 256MB RAM - 20GB EIDE hard drive Software: - Windows NT 4(with most recent service pack) - IIS 4.0 - Primary DNS Server - SQL Server 7.0 - ColdFusion Server 4.5 Professional - MS Access As a matter of point, I'd throw at least 512Mb RAM at any SQL Server machine, and more if you want to run CF Server on it. I don't know how DNS Server works with others... The big thing is not the number of sites, but the traffic - if you aren't expecting tons of visitors then your setup will probably be fine, but if you're expecting hundreds of thousands a day, then get a separate SQL Server machine From the little I know about MS DNS Server, it's happier on it's own machine - so maybe a low spec Celeron would do the trick... Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_STRIP_EMAIL_SHOWME_DOMAIN
This should do it. CFSET emailstring = '[EMAIL PROTECTED]' CFSET url = REReplace(emailstring,'([^@]*)@([^@]*)','www.\1\2') Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 4:58 PM To: CF-Talk Subject: CF_STRIP_EMAIL_SHOWME_DOMAIN Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CF_STRIP_EMAIL_SHOWME_DOMAIN
Oops...that's wrong... try this instead: cfset newstr="www"mid(emailaddr,find("@",emailaddr)+1,len(emailaddr)) Howie - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 1:26 PM Subject: Re: CF_STRIP_EMAIL_SHOWME_DOMAIN Try: cfset newstr="www"left(emailaddr,find("@",emailaddr)-1) Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 11:57 AM Subject: CF_STRIP_EMAIL_SHOWME_DOMAIN Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_STRIP_EMAIL_SHOWME_DOMAIN .. ooops
Actually ment to do this. CFSET emailstring = '[EMAIL PROTECTED]' CFSET url = REReplace(emailstring,'([^@]*)@([^@]*)','www.\2') -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 4:58 PM To: CF-Talk Subject: CF_STRIP_EMAIL_SHOWME_DOMAIN Hello all, I was just looking for some help on how to take an email address and strip away the string to the left of the "@" sign and add "www." to the newly create string variable. Thanks, D- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: An Idea about access and paragraphs
So, here's my idea. Access cannot literally store paragraphs however you can always put in P at the start of each paragraph/line and achieve the the paragraphs. The drawback to this is that if it is left up to the regular user, they'll probably mess it up. So, this is the idea. Is there a way to detect a paragraph break, then when you submit the page, the paragraph break is detected, and then replaced with a P tag. Therefor all the user has to do, is put in a normal paragraph. See the ParagraphFormat() function. There's not really such a thing as a paragraph break when entering text in an html textbox. The closest thing is two successive line breaks. CF's ParagraphFormat() function simply replaces every pair of linebreaks with a P tag. I've found a better approach is to replace every linebreak with a BR. Then, when rendering the text, it more closely resembles what was entered by the user. For example, this text entered in a textbox: Sincerely, John Smith doesn't get altered by ParagraphFormat() and the resulting html appears something like: Sincerely, John Smith Jim Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Cardservice International
I would like to know if you could interface as easily with CSI's Linkpoint as with Authorize Net's Gateway That was the original question. Neil - Original Message - From: "Steve Nelson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 1:33 PM Subject: Re: Cardservice International They're pretty good, i've used them in the past. You can probably find better rates than what they offer. Honestly, i haven't noticed a difference between any of the merchant banks other than their rates. You almost rarely ever have to deal with them, although I'm not doing millions of transactions a day, so I can't speak for problems involved with those numbers of transactions. CardService is one of the biggest merchant banks if not the biggest. Try and negotiate a better deal with them, do a simple search on yahoo for "accept credit cards", get the rates from other merchant banks before you pick one. You might also take a look at Authorize.net, integrating authorize.net is much easier and cheaper than something like cybercash. It's just a simple https form, there are a couple free CF_authorizenet tags out there. Steve Nelson Howie Hamlin wrote: Does anyone have any experience (good or bad) with Cardservice International as a payment provider? They have an available ColdFusion tag that can be used for on-line transactions. From their literature: = To support storefront development in Windows platforms, Cardservice has developed a custom ColdFusion Tag, which provides the same functionality as the API. The LinkPoint ColdFusion Tag (LCFX)is a built-in utility to be used with the LinkPoint API. LCFX provides all the functionality of the LinkPoint API and eliminates the necessity of the user knowing C++. For more information, e-mail [EMAIL PROTECTED] or download the manual. = Thanks in advance, Howie Hamlin -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Stored Procedure Problem
Greetings all I am having problems with a db2 stored procedure and I am guessing the problem is on the cf server side though I am not sure. The first time the stored procedure is run, it brings back the right result set. After the procedure is run the first time though, it takes the first results from the first time it was run, and them combines it with the next newest set of returned data. It continues to do this for each time that the procedure is ran. If I allow the cfserver to sit a couple of minutes, and then rerun my app, I get the following error message: ODBC Error Code = 40003 () [IBM][CLI Driver][DB2] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "11.143.234.532". Communication function detecting the error: "recv". Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001 The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (211:1) to (211:52). After getting this message, then running the procedure again, it brings back the correct records the first time, then it goes back to adding the results of each subsequent running to it. What it seems to me is that it is caching the results somewhere and then adding to this cache. The stored procedure, is a Cobol program that is indexed by db2. The Cobol program creates a temporary table that the results are stored in, before passing them back to coldfusion. The person working on the db2 side of things has tested the procedure by using a batch file to return the results and is unable to duplicate the errors I am getting which leads me to believe that it is a caching problem on the server, but if so, don't know what to do about it? any advice and words of wisdom would be greatly appreciated. Thanx Bill cfstoredproc datasource="dbd1" procedure="procedure-name" !--- result set tag --- cfprocresult name="proc_output" !--- cfprocparam tags --- cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" value="#input1##input2##input3#" dbvarname="@INPUTCODE" cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" VARIABLE="code" DBVARNAME="@RETURNCODE1" cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" VARIABLE="message" DBVARNAME="@RETURNCODE2" /cfstoredproc Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: An Idea about access and paragraphs
So, here's my idea. Access cannot literally store paragraphs however you can always put in P at the start of each paragraph/line and achieve the the paragraphs. The drawback to this is that if it is left up to the regular user, they'll probably mess it up. So, this is the idea. Is there a way to detect a paragraph break, then when you submit the page, the paragraph break is detected, and then replaced with a P tag. Therefor all the user has to do, is put in a normal paragraph. Great idea! Allaire must have had the same one, since they've given us the ParagraphFormat() function, which substitutes CRLF strings into p strings for display purposes. I prefer to do it manually, however, with a Replace function, and replace a CRLF with br instead, since users will sometimes use just one CRLF for things like address formatting, and two for actual paragraphs. Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: writing files from oracle
Chris, Oracle has a tool called UTL_FILE that will allow you to write out text file of unlimited size to the server it resides on. You can write a stored procedure to create the file. Let me know if you need more info? Pete -Original Message- From: Chris Hamer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 14:20 To: CF-Talk Subject:writing files from oracle Is there a way to get oracle to write a csv file from a coldfusion request. Does oracle have a 'bcp' type program like sql server that writes files out quickly? I need to write a file with about 10 - 15,000 records without over-taxing the cfserver. Chris Hamer Web Development ImageServe, Inc. http://www.imageserve.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Stored Procedure Problem
I am having problems with a db2 stored procedure and I am guessing the problem is on the cf server side though I am not sure. The first time the stored procedure is run, it brings back the right result set. After the procedure is run the first time though, it takes the first results from the first time it was run, and them combines it with the next newest set of returned data. It continues to do this for each time that the procedure is ran. If I allow the cfserver to sit a couple of minutes, and then rerun my app, I get the following error message: ... After getting this message, then running the procedure again, it brings back the correct records the first time, then it goes back to adding the results of each subsequent running to it. What it seems to me is that it is caching the results somewhere and then adding to this cache. The stored procedure, is a Cobol program that is indexed by db2. The Cobol program creates a temporary table that the results are stored in, before passing them back to coldfusion. The person working on the db2 side of things has tested the procedure by using a batch file to return the results and is unable to duplicate the errors I am getting which leads me to believe that it is a caching problem on the server, but if so, don't know what to do about it? I'm no DB2 expert (to say nothing about my COBOL skills), but I think the problem is with DB2, not CF. Specifically, it sounds like the stored procedure is reusing the temporary table, instead of dropping that table at the end of the stored proc execution. That would explain why you get the cumulative records each time it's run. Does the COBOL program explicitly drop the table? CF isn't caching the stored procedure recordset, either. It probably is reusing the database connection, however, and I wouldn't be surprised if that's why multiple queries use the same temporary table. As a test, you can go into the CF Administrator and configure your datasource so that it doesn't maintain the database connection. You'll have to cycle the CF server after this to get your change to take effect. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: case sensitivity in structures
are values in structures case sensitive? Values in any variable in CF are "case-sensitive" in the sense that CF stores them in the case in which they're created. Keys within structures (keys being the variable names within structures), are not case-sensitive, and if you loop over keys and output them, the keys themselves will be output in all caps. The values for those keys, as mentioned above, will be whatever you put in them originally. Here's a demo. Just copy this into a cfm file, and run it: !--- structuredemo.cfm --- cfscript mystruct = StructNew(); mystruct["First Stooge"] = "Larry"; mystruct["Second Stooge"] = "Curly"; mystruct["Third Stooge"] = "Moe"; /cfscript cfloop collection="#mystruct#" item="ThisStooge" cfoutput #ThisStooge# : #mystruct[ThisStooge]#br /cfoutput /cfloop !--- end structuredemo.cfm --- Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Cardservice International
h... I've never dealt with Linkpoint, just CSI as a bank. When i used CSI as the merchant we were using cybercash as the gateway. Cybercash will eat you alive in fees though. If linkpoint can be accessed through a regular HTML form then absolutely, it would take 15 minutes to build yourself a CF_linkpoint tag. Steve "Neil H." wrote: I would like to know if you could interface as easily with CSI's Linkpoint as with Authorize Net's Gateway That was the original question. Neil - Original Message - From: "Steve Nelson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 1:33 PM Subject: Re: Cardservice International They're pretty good, i've used them in the past. You can probably find better rates than what they offer. Honestly, i haven't noticed a difference between any of the merchant banks other than their rates. You almost rarely ever have to deal with them, although I'm not doing millions of transactions a day, so I can't speak for problems involved with those numbers of transactions. CardService is one of the biggest merchant banks if not the biggest. Try and negotiate a better deal with them, do a simple search on yahoo for "accept credit cards", get the rates from other merchant banks before you pick one. You might also take a look at Authorize.net, integrating authorize.net is much easier and cheaper than something like cybercash. It's just a simple https form, there are a couple free CF_authorizenet tags out there. Steve Nelson Howie Hamlin wrote: Does anyone have any experience (good or bad) with Cardservice International as a payment provider? They have an available ColdFusion tag that can be used for on-line transactions. From their literature: = To support storefront development in Windows platforms, Cardservice has developed a custom ColdFusion Tag, which provides the same functionality as the API. The LinkPoint ColdFusion Tag (LCFX)is a built-in utility to be used with the LinkPoint API. LCFX provides all the functionality of the LinkPoint API and eliminates the necessity of the user knowing C++. For more information, e-mail [EMAIL PROTECTED] or download the manual. = Thanks in advance, Howie Hamlin -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Slightly OT : How many accounts can my server handle?
I second what Phil said, especially since you have an IDE drive. Hope you have a a backup ;-) Assuming the 1 GB per site, I wouldn't put more than 75-100 sites on that server, BUT there are so many variables involved that a number is hard to nail down. If you put SQL on a different machine it would make a big difference if you expect heavy usage of SQL. If you cant put it on a different machine, putting it on a different drive in the machine would releive some of the strain on that poor IDE drive. A lot depends on your pipeline too, just 10 sites at 1 GB a month will max a T1 and your sites will be very slow. I'll give you the specs on one of our NT servers so you can compare for yourself: Dual P3 600's 3 9 Gig SCSI's 256 Megs of RAM IIS 4 Secondary DNS CF server 4.01 ~150 sites This machine runs between 10 - 50 % cpu utilization during peak hours and in my opinion is overloaded. - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 1:32 PM Subject: RE: Slightly OT : How many accounts can my server handle? I realize that there are many factors in determining how many sites a server can handle are, but i'm just looking for guidelines. The server information is below, and lets assume that an average site on the server uses ColdFusion and Access or SQL Server 7.0 and uses 1 Gig of bandwidth a month. Lets also assume that I would use Virtual Directories instead of unique IP addresses for each account. How many sites would you say this server could handle? Thanks in advance for any help! Hardware: - Pentium 600MHz - 256MB RAM - 20GB EIDE hard drive Software: - Windows NT 4(with most recent service pack) - IIS 4.0 - Primary DNS Server - SQL Server 7.0 - ColdFusion Server 4.5 Professional - MS Access As a matter of point, I'd throw at least 512Mb RAM at any SQL Server machine, and more if you want to run CF Server on it. I don't know how DNS Server works with others... The big thing is not the number of sites, but the traffic - if you aren't expecting tons of visitors then your setup will probably be fine, but if you're expecting hundreds of thousands a day, then get a separate SQL Server machine From the little I know about MS DNS Server, it's happier on it's own machine - so maybe a low spec Celeron would do the trick... Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
OT: Anti-caching code...
This is a multi-part message in MIME format. --=_NextPart_000_0138_01C03CFE.D4DBACA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I am having an issue with my CFM templates caching like crazy, and was = wondering if someone could tell me how they solved it. I know there are = a few META tags that work with the different browsers, but don't seem to = be able to find the exact syntax. I am also aware of how to do it in = ASP, but am not sure if there is a way with CF. Thanks, Jim --=_NextPart_000_0138_01C03CFE.D4DBACA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all,/FONT/DIV DIVFONT face=3DArial size=3D2I am having an issue with my CFM = templates caching=20 like crazy, and was wondering if someone could tell me how they solved = it. I=20 know there are a few META tags that work with the different browsers, = but don't=20 seem to be able to find the exact syntax. I am also aware of how to do = it in=20 ASP, but am not sure if there is a way with CF./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Jim/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV/BODY/HTML --=_NextPart_000_0138_01C03CFE.D4DBACA0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server equivalent of Access' compact database
Is there a SQL Server equivalent of Access' "compact database"? I would like to dump all the data in certain tables and for the Identity fields to start renumbering from 1. These are two different things. When you compact an Access database, it doesn't delete any records. It simply discards the space where records used to be before they were deleted. I'm not sure how identity columns in Access are affected by this, if you delete records from the end of a table and then compact the database - I'd kind of hope that it doesn't ever reuse an identity value, simply because the database may be poorly designed and missing the appropriate declarative referential integrity. You can reduce the size of a database in SQL Server from within the Enterprise Manager interface. In addition, you can configure databases so that they automatically resize as the dataset grows and shrinks. If you want to delete data from a table, and reinitialize its identity column back to the original seed value, you can use the T-SQL statement TRUNCATE TABLE. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Slightly OT : How many accounts can my server handle?
Hi Craig, Microsoft strongly urges and in same cases will not even support a system that has more than a couple hundred domains on a single server. There are folks out there with several thousand sites under O'Reilly Website. So the limit is probably not CF but IIS and given this config probably about 25 to 50. You have already heard to not put SQL and IIS on the same server, very good advice. Also the amount of RAM is probably too low for any serious hosting. - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]] Sent: Monday, October 23, 2000 11:48 AM To: CF-Talk Subject: Slightly OT : How many accounts can my server handle? Hello, I realize that there are many factors in determining how many sites a server can handle are, but i'm just looking for guidelines. The server information is below, and lets assume that an average site on the server uses ColdFusion and Access or SQL Server 7.0 and uses 1 Gig of bandwidth a month. Lets also assume that I would use Virtual Directories instead of unique IP addresses for each account. How many sites would you say this server could handle? Thanks in advance for any help! Hardware: - Pentium 600MHz - 256MB RAM - 20GB EIDE hard drive Software: - Windows NT 4(with most recent service pack) - IIS 4.0 - Primary DNS Server - SQL Server 7.0 - ColdFusion Server 4.5 Professional - MS Access Craig Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
database forums and/or lists
Any suggestions where I can find a really good forum and/or list that discusses relational databases? Thanks, Brad Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Anti-caching code...
CFHEADER NAME="Expires" VALUE="Mon, 06 Jan 1990 00:00:01 GMT" CFHEADER NAME="Pragma" VALUE="no-cache" CFHEADER NAME="cache-control" VALUE="no-cache" try them jon - Original Message - From: "J.Milks" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 23, 2000 2:37 PM Subject: OT: Anti-caching code... This is a multi-part message in MIME format. --=_NextPart_000_0138_01C03CFE.D4DBACA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I am having an issue with my CFM templates caching like crazy, and was = wondering if someone could tell me how they solved it. I know there are = a few META tags that work with the different browsers, but don't seem to = be able to find the exact syntax. I am also aware of how to do it in = ASP, but am not sure if there is a way with CF. Thanks, Jim --=_NextPart_000_0138_01C03CFE.D4DBACA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all,/FONT/DIV DIVFONT face=3DArial size=3D2I am having an issue with my CFM = templates caching=20 like crazy, and was wondering if someone could tell me how they solved = it. I=20 know there are a few META tags that work with the different browsers, = but don't=20 seem to be able to find the exact syntax. I am also aware of how to do = it in=20 ASP, but am not sure if there is a way with CF./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Jim/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV/BODY/HTML --=_NextPart_000_0138_01C03CFE.D4DBACA0-- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]