RE: Using characters other than ? in the url query string
I don't know how to do that, but there is a custom tag that will do that for you. Check out http://www.erikv.com/downloads.html and download the sample fusebox application (the file is fbx_sesconverter.cfm) -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: donderdag 15 november 2001 18:13 To: CF-Talk Subject: Using characters other than ? in the url query string G'day Peoples, Does any of you Jedi Knights know a way of reconfiguring either IIS or Cold Fusion so that it takes a / instead of a ? as the control character in a url cgi query string...? According to the Spider Food site it is possible, but they don't tell you how and I can't find anything on the tech support site that talks about it? The Spider Food URL is: http://spider-food.net/dynamic-page-optimization-b.html Any help would be greatly appreciated.. best wishes, -= Ed ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
uploading a whole folder-- instead of just a file.
---how do I upload a FOLDER to the server? -- PLEASE oh god please. help. me. I've built a template driven web-site for the local community college. Every instructor can upload templates for their classes, which is a collection of files and graphics. The instructors want to up load the root directory and all the folders inside of that (so something like 1 folder with 4 html files and a number of folders in that. One of those folders would be your classic 'images' folder.) so here's the question: ---how do I upload a FOLDER to the server? -- you can only upload individual files using the cffile tag, and the cffftp tag seems to have a similar limitation. PLEASE, can any one point me in the right direction? I've include one of the solutions I tried as a work around. It didn't work because you can't set the Value attribute of a input=file tag the same way you can with a input=text. (If you do set the value of the input=file tag, the page you pass the variables to thinks they are empty regardless) I m hoping this set of code will inspire someone. FIRST FILE--- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body form action=uploadtest2.cfm method=post enctype=multipart/form-data what is the local root folder? (the absolute path to this directory) input name=LocalRoot type=Text width=50 br list all the files you'd like to upload. Must be a comma delineated list br textarea cols=35 rows=10 name=localFile/textarea p what is the remote root folder? input name=remoteRoot type=Text width=50 input type=Submit /form /body /html SECOND FILE--- cfset localfileLen = #listlen(form.localFile)# cfset upLoadFile = #form.localRoot# #form.localFile# cfset UpLoadFile = arrayNew(1) !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body cfloop index=z from=1 to=#localfileLen# cfset upLoadFile[#z#] = (#form.localRoot#) (#listGetAt(form.localFile,z,,)#) form name=form1 action=uploadtest3.cfm method=post enctype=multipart/form-data cfoutputinput type=text name=upLoadFile#z# value= value=#upLoadFile[z]#p align=right/p/cfoutput /cfloop cfoutput input type=Hidden name=localFile value=#form.localFile# input type=Hidden name=remoteRoot value=#form.remoteRoot# input type=Hidden name=LocalRoot value=#form.LocalRoot# /cfoutput input type=Submit /form cfoutput For testing variables br form.localRoot #form.localRoot# br form.localFile #form.localFile# /cfoutput /form /body /html THIRD FILE--- cfset localfileLen = #listlen(form.localFile)# !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body cfloop from=1 to=#localfileLen# index=x cffile action=upload destination=#form.remoteRoot# filefield=upLoadFile#x# /cfloop cfoutput for testing: br form.localFile = #form.localFile# br form.remoteRoot = #form.remoteRoot# /cfoutput /body /html - again these files are just for insperation. I was trying to work around the only upload one file at a time limitation the idea was to have the instructors point to a folder and list the files in that folder then have cold fusion loop through it, doing all the leg work but the easiest solution would be to UPLOAD an ENTIRE FILE!!! please... Its so late and Im so tired. Thank you Jay FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploading a whole folder-- instead of just a file.
Hey, I just did something like this. Here's an idea, use a zip file. Have them zip up their whole folder and upload the zip file. Then unzip it on the server (cfexecute to a command-line zip program works nicely or there is a cfx_zip tag out there). Just a thought. Cheers, -Max ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Tree in windows XP - Cold Fusion 5
There is an error (visual C error) when you double click CF Tree applet in wndows XP and on CF 5.0. Any body can help? thanks FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Tree in windows XP - Cold Fusion 5
There is an error (visual C error) when you double click CF Tree applet in windows XP and on CF 5.0. How to enable CAB like in CF 4.5 form cause in CF 5.0 using JRE version 1.3.0_01 Java HotSpot(TM) Client VMAny body can help? thanks FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: uploading a whole folder-- instead of just a file.
This should take you to it, wrote by Ben Forta. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347298-2830-11D4-AA ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: uploading a whole folder-- instead of just a file.
Sorry about that, http://www.forta.com/cf/tags/ -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:05 AM To: CF-Talk Subject: RE: uploading a whole folder-- instead of just a file. This should take you to it, wrote by Ben Forta. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347298-2830-11D4-AA ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: uploading a whole folder-- instead of just a file.
this link isn't working. What file is it pointing to? thanks -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 2:05 AM To: CF-Talk Subject: RE: uploading a whole folder-- instead of just a file. This should take you to it, wrote by Ben Forta. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347298-2830-11D4-AA ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX API with C++
The green Forta book (advanced coldfusion application development) has some good info on this. Not sure if theres a more recent version of the book than the one that covers CF 4.0 HTH Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 -Original Message- From: Jared Stark [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 21:23 To: CF-Talk Subject: CFX API with C++ Does anyone have any good recommendations for information about creating CFX tags with C++? I've read the info in Wrox Professional ColdFusion 5.0, and I've read through the reference manual, but I'm having a difficult time finding information elsewhere online. Thanks, Jared ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access XP and CF?
Yup - been using an XP mdb for about 2 weeks, and it's fine (on CF 4.5) Will - Original Message - From: Matt Robertson [EMAIL PROTECTED] Newsgroups: gradwell.lists.cftalk Sent: Friday, November 16, 2001 1:28 AM Subject: Access XP and CF? I just got a copy of Office XP Pro yesterday, which includes the new Access XP. Is Access XP compatible with CF 4.5 sp2's ODBC *and* OLEDB drivers? Should I leave XP off my development box and stick with Access 2k? Any shared experiences would be much appreciated. Thankfully I only have a very few sites still running it, but I have a bunch of custom tags with Access in them that I have to keep up. Thx, - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query Problem
Can't you just use isnull(BrandID,0)? Then you'll have 0's replacing null values, and your average won't be messed up. Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 5:49 PM To: CF-Talk Subject: Re: SQL Query Problem I'd add in some AND WHATEVER BrandIF Field IS NOT NULL to weed out the NULL records Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Brian Ferrigno [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 2:39 PM Subject: SQL Query Problem I am having a problem trying to think of the correct SQL statement I need. It's late in the day and my brain is completely fried. What I am tring to do is get the average price of one column based a an ID that is passed to the SQL query. For example if a BrandID of 1 is passed into the query it should output an average price of $4.00 The problem arises when one of the BrandID(BNID) columns doesn't contain any of the #ID# numbers in it. The value that it returns is NULL which causes the rest of the SQL statement to return NULL as a result even if the other columns contain at least one #ID# in the BNID column. For example passing a BrandID of 24 will return a resultset of NULL because it is not in the second or third BRANDID column. Hopefully I made some sense. Below is the partial table design and SQL statements I am using in my script. Any help would be great. TABLE DESIGN BNID1_3 Price1_3 BNID2_3 Price2_3 BNID3_3 Price3_3 1 $2.0010 $0.001 $5.00 24 $0.001 $5.0023 $0.00 SQL STATEMENT select (select avg(Price1_3) from temp1 where BNID1_3=#ID#)+ (select avg(Price2_3) from temp1 where BNID2_3=#ID#)+ (select avg(Price3_3) from temp1 where BNID3_3=#ID#) AS AVGPRICE ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF code and Netscape Browser...
Just a point on this, screen.height and screen.width are the size of the whole screen, not the browser For example, I have 2 monitors, one at 1280x1024 and the other at 1024x768 screen.height and screen.width for me returns 2304x1024, which is OBVIOUSLY rubbish - if I put the browser on the right hand screen and change it to 800x600, then screen.height and screen.width will be 2080x1024 You should use the browser specific ones to find the size of the browser setting (if not maximised) Philip Arnold Director Certified ColdFusion Developer 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. ** -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 19:45 To: CF-Talk Subject: CF code and Netscape Browser... I am pulling my hair out over this oneI have an index.html that gets the screensize then sends the page to a CF page (using JavaScript) to figure out which images I should use. It works fine in IE... But Netscape, I get an endless loop. It basically says my variable Session.Current is not defined. Please look at my code below and let me know why this is happening. INDEX.HTML html head titleUntitled/title META HTTP-EQUIV=refresh content=7; url=jscript.html /head BODY SCRIPT if (window != top) top.location.href = location.href; /SCRIPT form action=default.cfm method=post name=frm id=frm input type=hidden name=screensize value= input type=hidden name=MyCntr value= /form script language=JavaScript1.2 var width = screen.width; var height = screen.height; document.frm.screensize.value = screen.width; document.frm.MyCntr.value = 1; document.frm.submit(); /script /body /html APPLICATION.CFM cfapplication name=Myapp sessionmanagement=Yes setclientcookies=No sessiontimeout=#createTimeSpan(0,0,40,0)# cfset DSN = lala cflock timeout=60 throwontimeout=No name=check_session type=READONLY cfparam name=form.MyCntr default=No cfif form.MyCntr IS 1 cfset Session.current = Yes /cfif cfif Not IsDefined(session.current) cflocation url=index.html addtoken=No /cfif Cfparam name=Session.checkout default=No /cflock DEFAULT.CFM cfparam name=form.screensize default=800 cfquery name=Get_index datasource=#DSN# dbtype=ODBCSELECT * FROM Index_page_tbl WHERE Index_page_key = 1/cfquery cfoutput cfif Not IsDefined(form.screensize) cflocation url=index.html addtoken=No /cfif cflock timeout=30 throwontimeout=No name=Check_size type=READONLY cfset session.screensize = #form.screensize# /cflock /cfoutput cflock timeout=30 throwontimeout=No name=set_color type=READONLY cfoutputcfset session.color_scheme = #Get_index.color_scheme#/cfoutput /cflock html head titlecfoutput#Get_index.title#/cfoutput/title /head frameset cols=19%,81% FRAMEBORDER=0 BORDER=0 BORDERCOLOR=#FF frame name=menu src=menu.cfm scrolling=yes title=menu frame name=main title=main src=main.cfm /frameset noframes body pThis page uses frames, but your browser doesn't support them./p /body /noframes /html Thank you all... Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
insert question
i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: unknown exception condition
Thanks Mike.. now i know where to look :) - Original Message - From: Brunt, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 5:33 PM Subject: RE: unknown exception condition Typically this indicates a memory threading/corruption issue which in turn usually relates to unlocked shared scope variables (Application, Server and Session Scopes). I would take a good look at your Application and Server logs and look for occurrences of the word thread or threading then chase down the pages shown in the logs which caused these words to occur in the logs. Hope this helps. Mike Brunt Sempra Energy 213.244.5226 Artificial Intelligence usually beats natural stupidity. -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 3:25 PM To: CF-Talk Subject: unknown exception condition What does this error mean?? i cant figure out whats wrong.. it only happenes once in a while.. Error Occurred While Processing Request Error Diagnostic Information unknown exception condition CFMLInterpreterImp::process Date/Time: 11/15/01 17:19:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.139.129.20 -- -- ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access XP and CF?
access XP sux.. same thing it just doesnt let you open files on other networked drives.. they have to be on your local drive. i would stick to Access and Office 2000.. XP is buggy too.. example.. if you open a doc file in word and then save it and try to open it in word perfect it wont work.. if you create a doc file and try to open it in word perfect it wont work.. some other random application crashes also makes it suck more.. i see no reall advantage on using any XP product over 2000 products. - Original Message - From: Joseph Thompson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 11:29 PM Subject: Re: Access XP and CF? I talked to one developer who uploaded one of these and it worked fine; no problems yet (only two days live mind you) CF4.5 I just got a copy of Office XP Pro yesterday, which includes the new Access XP. Is Access XP compatible with CF 4.5 sp2's ODBC *and* OLEDB drivers? Should I leave XP off my development box and stick with Access 2k? Any shared experiences would be much appreciated. Thankfully I only have a very few sites still running it, but I have a bunch of custom tags with Access in them that I have to keep up. Thx, - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access XP and CF?
Alexis, I have no issues at all opening a DB on a networked drive. It works just fine. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:02 AM To: CF-Talk Subject: Re: Access XP and CF? access XP sux.. same thing it just doesnt let you open files on other networked drives.. they have to be on your local drive. i would stick to Access and Office 2000.. XP is buggy too.. example.. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session and Client Variables
Woe, cease fire! I, the 'original respondent', was just trying to exercise my awkward sense of humor. Kwan Suh, if I ever pick a fight, I want you on my side. You may be belligerent, but you make a good case. I have worked on two shopping cart type applications with complex variables. On the first I used client scope and wddx, on the second I tried session variables. They both worked fine, but the session variables were more troublesome because things didn't work out as planned (and I did actually plan). My 'brilliant' idea was to use the Duplicate() function to copy all complex session variables to request scope in the application.cfm (to be 'efficient', not lazy), and then copy changed data back to the session variables as applicable in each action page. The problem was that the Duplicate() function was buggy (to put it mildly), and I finally had to resort to copying individual structure keys at the top of every page, and putting cflock tags around the queries, which, I agree, is very cumbersome. So we learn from our mistakes, but had the Duplicat() function worked correctly, I think it would have been a good plan. Perhaps when we upgrade to CF 5 it will work. The reason I spoke of hidden variables was that when using client variables, I stored the wddx in a hidden field rather than in a database. Also, before I got involved in the second appilication, it had been designed without session management, and hidden fields were used to pass data for each selected line item from one page to the next, which was was truly cumbersome to manage. We will probably never use clustered servers, but you have a very good point. Should we ever have the opportunity to work on an application that calls for it, it would be a sign of growth from a business perspective, but a perhaps a nightmare from a programmer's point of view. I hope Gyrus will be ready for his exam, now. Taking cover! Marianne -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 7:11 PM To: CF-Talk Subject: Re: Session and Client Variables - Original Message - From: Freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 5:16 PM Subject: Re: Session and Client Variables Kwang Suh wrote: My heart goes out to you! You sound like you've had a bad experience with a session variable cult, or something. But if used in its proper context, session variables can change your (work) life. Yeah, but what's proper context? Do people even bother to do enough analysis to say whether they should go client or session, or do people use session vars because that's what they've been using since they started using CF? I would think that any application should be built with a well thought out plan. Utilize whatever is best in a given situation. A proerly used session variable works better than an inproperly used client and vice versa. Agreed. I'm saying that most people don't even create the well thought out plan. In your darkest hour, when confronted with the need to pass queries of information, the number of rows unbeknownst to you, from one page to another, over and over again in a endless, vicious cycle, you might find that session variables are your only hope. Hardly. That's what WDDX is for. WDDX is great for hanling large recordsets but it is not as fast to access as a session scoped query on a seperate page. Again the method used is depoendent on what you need to do. Yes, some people may have committed evil act in the name of session variables, but don't let hypocrites turn you away from the tool that delivered you from the hands of hidden form fields and time consuming database calls. Why would I need hidden form fields and database calls when I'm using client variables? Take a look at your database activity. Using client variables will generate a database call. Yes, I realize this. But I will bet you 1 million widgets that a properly configured RDBMS is _much_ better at handling locking than a properly configured CF server using session variables. Not to mention that my client app will actually scale, and your session app will not. I think the original respondent was referring to constant database calls for variables that should be persistent. Also try holding a complex structure in a client variable. I've already mentioned this drawback. I would say use what works for you. Do not rely on any one method overly much. If you do you will find that you are not going to get the full benefits that working a rich scripting language like cf can provide. I think the overarching requirement for most, if not all, enterprise-class applications are reliability and availability. I can't see how using session vars meshes with this requirement. Hey, if all someone's making are small apps, go right ahead and use session variables. Just don't expect the application
RE: Access XP and CF?
Actually, in Office XP they introduced another tier of security. If you're accessing a network drive that's being restricted based upon your Internet Explorer settings (which I believe by default is any network drive mapped by an IP addy,) then there are some configuration changes you'll need to make. Search support.microsoft.com for more info. -Dan -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:10 AM To: CF-Talk Subject: RE: Access XP and CF? Alexis, I have no issues at all opening a DB on a networked drive. It works just fine. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:02 AM To: CF-Talk Subject: Re: Access XP and CF? access XP sux.. same thing it just doesnt let you open files on other networked drives.. they have to be on your local drive. i would stick to Access and Office 2000.. XP is buggy too.. example.. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access XP and CF?
Alexis It works fine as well for me. Win XP Access XP Mike -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:10 AM To: CF-Talk Subject: RE: Access XP and CF? Alexis, I have no issues at all opening a DB on a networked drive. It works just fine. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
a way of pausing in CF code?
What's the best way of getting the processing of a CF template to 'pause' for a certain amount of time? I'm testing for the value of a certain application variable. I want a DB query to be processed only if the value of this var gets set to 'true' within, say, 5 seconds. At the moment I've got a CFLOOP that keeps going round, testing the var, as long as the time isn't 5 seconds later than when it started: cfset queryDone=0 cfset startTime=CreateODBCDateTime(Now()) cfloop condition=(NOT queryDone) AND (DateDiff('s', startTime,CreateODBCDateTime(Now())) LTE 5) cflock timeout=10 throwontimeout=No cfset locked=application.locked /cflock cfif NOT locked cfquery name=queryName datasource=#request.DSN# dbtype=ODBC [SQL] /cfquery --- cfset queryDone=1 /cfif /cfloop (The app has to be in CF 4.0, hence simple CFLOCK and no Duplicate). Is this long-winded? Anything more elegant? Any suggestions appreciated :) - Gyrus ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session and Client Variables
I hope Gyrus will be ready for his exam, now. Learning by the minute :) - Gyrus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
max length of query string and Acive edit
Hello there, I am using Active Edit to create a page - a couple of these have grown to be massive pages. Unfortunately I am now losing the bottom section of the big pages. I have checked in our SQL server 7 dbase and the data type is set to ntext which I believe can hold 2GB of data. Is there a maximum length that Coldfusion can handle being passed to it or should I be looking for another error. (CF 4.5 on NT4). Cheers Simon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP problems: Invalid column header ???
I still get that error when I remove the entire CFOUTPUT tag? Carl - Original Message - From: Dave Watts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 5:18 PM Subject: RE: CFHTTP problems: Invalid column header ??? text file contents * col_a, col_b, col_c a,b,c d,e,f g,h,i cf code cfhttp url=http://127.0.0.1/text2.txt; method=GET name=textFile textqualifier= delimiter=, resolveurl=false cfoutput query=textFile #textFile#br /cfoutput There are three potential problems that I can see... I removed the textqualifier information from the tag, and verified the url to my text file is valid, but I am still getting the cfhttp error. Invalid column header Any other ideas? Actually, yes. I missed the biggest error. In your CFOUTPUT, you'll be able to reference col_a, col_b or col_c, not textFile. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: a way of pausing in CF code?
If you want to sleep for, say, 5 seconds in CF then you can do something like this. cfset lockname = CreateUUID() cflock name=#lockname# type=readonly timeout=0 cftry cflock name=#lockname# type=exclusive timeout=5 /cflock cfcatch type=lock /cfcatch /cftry /cflock ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query Problem
No, you would not want to use isnull(BrandID,0). This would cause the number of IDs by which to divide the price total to be incorrect. For example, if you have 10 brands, but 2 of them have NULL fields, the total price should be divided by 8. However, by your proposed method, substituting a 0 (which is what the isnull function would do) would cause the total price to be divided by 10 because technically there is a value for that brand now, hence skewing your average. I would definitely use an IS NOT NULL clause to filter out the wrong fields. Be very careful about this, as I have seen that mistake before, and it wreaks havoc! Dave. Original Message Follows From: Steven Dworman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Problem Date: Fri, 16 Nov 2001 08:13:37 -0500 Can't you just use isnull(BrandID,0)? Then you'll have 0's replacing null values, and your average won't be messed up. Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 5:49 PM To: CF-Talk Subject: Re: SQL Query Problem I'd add in some AND WHATEVER BrandIF Field IS NOT NULL to weed out the NULL records Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Brian Ferrigno [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 2:39 PM Subject: SQL Query Problem I am having a problem trying to think of the correct SQL statement I need. It's late in the day and my brain is completely fried. What I am tring to do is get the average price of one column based a an ID that is passed to the SQL query. For example if a BrandID of 1 is passed into the query it should output an average price of $4.00 The problem arises when one of the BrandID(BNID) columns doesn't contain any of the #ID# numbers in it. The value that it returns is NULL which causes the rest of the SQL statement to return NULL as a result even if the other columns contain at least one #ID# in the BNID column. For example passing a BrandID of 24 will return a resultset of NULL because it is not in the second or third BRANDID column. Hopefully I made some sense. Below is the partial table design and SQL statements I am using in my script. Any help would be great. TABLE DESIGN BNID1_3 Price1_3 BNID2_3 Price2_3 BNID3_3 Price3_3 1 $2.0010 $0.001 $5.00 24 $0.001 $5.0023 $0.00 SQL STATEMENT select (select avg(Price1_3) from temp1 where BNID1_3=#ID#)+ (select avg(Price2_3) from temp1 where BNID2_3=#ID#)+ (select avg(Price3_3) from temp1 where BNID3_3=#ID#) AS AVGPRICE ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using characters other than ? in the url query string
PATH_INFO is available as a CGI variable in ColdFusion --- anything after the script name but not including the part after the ? mark is (usually) parsed out as PATH_INFO by web servers. So in http://www.myserver.com/test.cfm/this/is/the/path/info?/andthisisthequerystr ing CGI.PATH_INFO = /this/is/the/path/info CGI.QUERY_STRING = andthisisthequerystring (careful here --- IIS will throw everything after the .com part in PATH_INFO, so you'd instead get CGI.PATH_INFO = /test.cfm/this/is/the/path/info CGI.QUERY_STRING = andthisisthequerystring So you can use PATH_INFO to pass information back and forth in, if you rewrite your URLs accordingly. If your site uses the query string on a URL to pass variables back and forth, and you want to use PATH_INFO instead without rewriting your application (e.g., to get search engines to index your URLs), then there are various ways to accomplish that, depending on your web server and application software. Most that I can think of off the top of my head use the web server's redirection functionality in various ways to accomplish this. Netscape Enterprise Server, for example, supports running CGI programs or ColdFusion programs as additional document directories --- your request would get handed off to another program for redirection, essentially. You'd start with http://www.myserver.com/test.cfm/this/is/the/path/info the server redirects this request to another program which parses out the SERVER_NAME, PATH_INFO and SCRIPT_NAME variables and rewrites the URL with a query string (or adds on to it), then sends the browser a redirect request, i.e., CFLOCATION URL=http://www.myserver.com/test.cfm?/this/is/the/path/info; With IIS, you can set up aliases for redirection as well. Or, from the pages you referred to, you can also install a component onto IIS that will rewrite the request internally for the application server without the overhead of a redirect request to the browser. (Apache pulls a similar trick with the mod_rewrite module.) Hope this helps... Regards, Joel Parramore -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 3:06 AM To: CF-Talk Subject: RE: Using characters other than ? in the url query string I don't know how to do that, but there is a custom tag that will do that for you. Check out http://www.erikv.com/downloads.html and download the sample fusebox application (the file is fbx_sesconverter.cfm) -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: donderdag 15 november 2001 18:13 To: CF-Talk Subject: Using characters other than ? in the url query string G'day Peoples, Does any of you Jedi Knights know a way of reconfiguring either IIS or Cold Fusion so that it takes a / instead of a ? as the control character in a url cgi query string...? According to the Spider Food site it is possible, but they don't tell you how and I can't find anything on the tech support site that talks about it? The Spider Food URL is: http://spider-food.net/dynamic-page-optimization-b.html Any help would be greatly appreciated.. best wishes, -= Ed ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
are you getting an error? is the user just not getting inserted? christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 8:29 AM To: CF-Talk Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
it will overlook user a (he is already in the dbase) but it wont insert user b (he is not in dbase and should get put in) -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:00 AM To: CF-Talk Subject: RE: insert question are you getting an error? is the user just not getting inserted? christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 8:29 AM To: CF-Talk Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query Problem
I didn't check out the table design. He is using 0's. I thought he was using nulls instead of 0's. My bad. Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:55 AM To: CF-Talk Subject: RE: SQL Query Problem No, you would not want to use isnull(BrandID,0). This would cause the number of IDs by which to divide the price total to be incorrect. For example, if you have 10 brands, but 2 of them have NULL fields, the total price should be divided by 8. However, by your proposed method, substituting a 0 (which is what the isnull function would do) would cause the total price to be divided by 10 because technically there is a value for that brand now, hence skewing your average. I would definitely use an IS NOT NULL clause to filter out the wrong fields. Be very careful about this, as I have seen that mistake before, and it wreaks havoc! Dave. Original Message Follows From: Steven Dworman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Problem Date: Fri, 16 Nov 2001 08:13:37 -0500 Can't you just use isnull(BrandID,0)? Then you'll have 0's replacing null values, and your average won't be messed up. Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 5:49 PM To: CF-Talk Subject: Re: SQL Query Problem I'd add in some AND WHATEVER BrandIF Field IS NOT NULL to weed out the NULL records Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Brian Ferrigno [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 2:39 PM Subject: SQL Query Problem I am having a problem trying to think of the correct SQL statement I need. It's late in the day and my brain is completely fried. What I am tring to do is get the average price of one column based a an ID that is passed to the SQL query. For example if a BrandID of 1 is passed into the query it should output an average price of $4.00 The problem arises when one of the BrandID(BNID) columns doesn't contain any of the #ID# numbers in it. The value that it returns is NULL which causes the rest of the SQL statement to return NULL as a result even if the other columns contain at least one #ID# in the BNID column. For example passing a BrandID of 24 will return a resultset of NULL because it is not in the second or third BRANDID column. Hopefully I made some sense. Below is the partial table design and SQL statements I am using in my script. Any help would be great. TABLE DESIGN BNID1_3 Price1_3 BNID2_3 Price2_3 BNID3_3 Price3_3 1 $2.0010 $0.001 $5.00 24 $0.001 $5.0023 $0.00 SQL STATEMENT select (select avg(Price1_3) from temp1 where BNID1_3=#ID#)+ (select avg(Price2_3) from temp1 where BNID2_3=#ID#)+ (select avg(Price3_3) from temp1 where BNID3_3=#ID#) AS AVGPRICE ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access XP and CF?
darn.. i'll have to check on that network thing see if i can get it to work.. i hate having to mess with my win2k server and stuff everytime i install something new.. oh well.. - Original Message - From: Michael Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 8:35 AM Subject: RE: Access XP and CF? Alexis It works fine as well for me. Win XP Access XP Mike -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:10 AM To: CF-Talk Subject: RE: Access XP and CF? Alexis, I have no issues at all opening a DB on a networked drive. It works just fine. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using characters other than ? in the url query string
Joel that was great, thanks a lot for your help best wishes, -= Ed ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access XP and CF?
well i've been thinking.. is there anything new on access XP exept that security thing.. why would somone want to upgrade to office XP if there is nothing woth upgrading for the looks..? i did notice a small improvement from office 97 to 2000 but in XP i havent found any improvements but the look. Alexis.. - Original Message - From: Alexis Maldonado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 9:24 AM Subject: Re: Access XP and CF? darn.. i'll have to check on that network thing see if i can get it to work.. i hate having to mess with my win2k server and stuff everytime i install something new.. oh well.. - Original Message - From: Michael Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 8:35 AM Subject: RE: Access XP and CF? Alexis It works fine as well for me. Win XP Access XP Mike -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:10 AM To: CF-Talk Subject: RE: Access XP and CF? Alexis, I have no issues at all opening a DB on a networked drive. It works just fine. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: max length of query string and Acive edit
Is your Enable retrieval of long text checked in your datasource? Otherwise, the long text have a max buffer size(usually set to 65000). Pascal -Original Message- From: Simon Whittaker Sent: vr 16-11-2001 15:28 To: CF-Talk Cc: Subject: max length of query string and Acive edit Hello there, I am using Active Edit to create a page - a couple of these have grown to be massive pages. Unfortunately I am now losing the bottom section of the big pages. I have checked in our SQL server 7 dbase and the data type is set to ntext which I believe can hold 2GB of data. Is there a maximum length that Coldfusion can handle being passed to it or should I be looking for another error. (CF 4.5 on NT4). Cheers Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: insert question
It looks just like my create user account, take a look and hope it helps. CFQUERY DATASOURCE=#application.dsn# NAME=check_login SELECT email, password FROM cust_contacts WHERE email = '#email#' AND password = '#password#' /CFQUERY !--- CHECK TO SEE IF THE USER EXISTS IN THE DB AND IF THEY DO, REDIRECT THEM TO THE ERROR PAGE AND NOTIFY THEM TO LOGIN NORMALLY. //--- CFIF CHECK_LOGIN.RECORDCOUNT GT 0 CFLOCATION URL=/index.cfm?fuseaction=errormessage=1 CFELSE !--- IF THE USER DOES NOT EXIST, INSERT THEM INTO THE DATABASE//--- CFTRANSACTION CFQUERY DATASOURCE=#application.dsn# NAME=insert_cust_login DECLARE @maxid int BEGIN SELECT @maxid = MAX(ID) FROM cust_contacts IF@maxid IS NULL SELECT @maxid = 1 ELSE SELECT @maxid = @maxid + 1 END INSERT INTO cust_contacts VALUES ( '#custNum#', @maxid, '#f_name#', '#l_name#', '#email#', '#password#' ) /CFQUERY /CFTRANSACTION /CFIF Doug - Original Message - From: Jones, Becky [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:28 AM Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
Doug, Is this for Oracle or SQL Server (or will it work for both)? Brian -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:33 AM To: CF-Talk Subject: Re: insert question It looks just like my create user account, take a look and hope it helps. CFQUERY DATASOURCE=#application.dsn# NAME=check_login SELECT email, password FROM cust_contacts WHERE email = '#email#' AND password = '#password#' /CFQUERY !--- CHECK TO SEE IF THE USER EXISTS IN THE DB AND IF THEY DO, REDIRECT THEM TO THE ERROR PAGE AND NOTIFY THEM TO LOGIN NORMALLY. //--- CFIF CHECK_LOGIN.RECORDCOUNT GT 0 CFLOCATION URL=/index.cfm?fuseaction=errormessage=1 CFELSE !--- IF THE USER DOES NOT EXIST, INSERT THEM INTO THE DATABASE//--- CFTRANSACTION CFQUERY DATASOURCE=#application.dsn# NAME=insert_cust_login DECLARE @maxid int BEGIN SELECT @maxid = MAX(ID) FROM cust_contacts IF@maxid IS NULL SELECT @maxid = 1 ELSE SELECT @maxid = @maxid + 1 END INSERT INTO cust_contacts VALUES ( '#custNum#', @maxid, '#f_name#', '#l_name#', '#email#', '#password#' ) /CFQUERY /CFTRANSACTION /CFIF Doug - Original Message - From: Jones, Becky [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:28 AM Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: insert question
This is for sql, I am not real sure in regard to oracle. But the same logic. I think the problem is really in the use of the CFIF statements. Doug - Original Message - From: Yager, Brian T Contractor/NCCIM [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 8:29 AM Subject: RE: insert question Doug, Is this for Oracle or SQL Server (or will it work for both)? Brian -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:33 AM To: CF-Talk Subject: Re: insert question It looks just like my create user account, take a look and hope it helps. CFQUERY DATASOURCE=#application.dsn# NAME=check_login SELECT email, password FROM cust_contacts WHERE email = '#email#' AND password = '#password#' /CFQUERY !--- CHECK TO SEE IF THE USER EXISTS IN THE DB AND IF THEY DO, REDIRECT THEM TO THE ERROR PAGE AND NOTIFY THEM TO LOGIN NORMALLY. //--- CFIF CHECK_LOGIN.RECORDCOUNT GT 0 CFLOCATION URL=/index.cfm?fuseaction=errormessage=1 CFELSE !--- IF THE USER DOES NOT EXIST, INSERT THEM INTO THE DATABASE//--- CFTRANSACTION CFQUERY DATASOURCE=#application.dsn# NAME=insert_cust_login DECLARE @maxid int BEGIN SELECT @maxid = MAX(ID) FROM cust_contacts IF@maxid IS NULL SELECT @maxid = 1 ELSE SELECT @maxid = @maxid + 1 END INSERT INTO cust_contacts VALUES ( '#custNum#', @maxid, '#f_name#', '#l_name#', '#email#', '#password#' ) /CFQUERY /CFTRANSACTION /CFIF Doug - Original Message - From: Jones, Becky [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:28 AM Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
this looks like it is for one user at a time. i want to be able to deal with multiple users and insert only the ones that arent already in the database. -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 11:33 AM To: CF-Talk Subject: Re: insert question It looks just like my create user account, take a look and hope it helps. CFQUERY DATASOURCE=#application.dsn# NAME=check_login SELECT email, password FROM cust_contacts WHERE email = '#email#' AND password = '#password#' /CFQUERY !--- CHECK TO SEE IF THE USER EXISTS IN THE DB AND IF THEY DO, REDIRECT THEM TO THE ERROR PAGE AND NOTIFY THEM TO LOGIN NORMALLY. //--- CFIF CHECK_LOGIN.RECORDCOUNT GT 0 CFLOCATION URL=/index.cfm?fuseaction=errormessage=1 CFELSE !--- IF THE USER DOES NOT EXIST, INSERT THEM INTO THE DATABASE//--- CFTRANSACTION CFQUERY DATASOURCE=#application.dsn# NAME=insert_cust_login DECLARE @maxid int BEGIN SELECT @maxid = MAX(ID) FROM cust_contacts IF@maxid IS NULL SELECT @maxid = 1 ELSE SELECT @maxid = @maxid + 1 END INSERT INTO cust_contacts VALUES ( '#custNum#', @maxid, '#f_name#', '#l_name#', '#email#', '#password#' ) /CFQUERY /CFTRANSACTION /CFIF Doug - Original Message - From: Jones, Becky [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:28 AM Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF code and Netscape Browser...
Does anyone know if Netscape has different rules regarding frames? I did a test with this (printed out the session.cfid) and it was different in both frames. So I added this to me default.cfm page (the framset page): frameset cols=19%,81% FRAMEBORDER=0 BORDER=0 BORDERCOLOR=#FF frame name=menu src=menu.cfm?CFID=#session.cfid#CFTOKEN=#Session.cftoken# scrolling=yes title=menu frame name=main title=main src=main.cfm?CFID=#session.cfid#CFTOKEN=#Session.cftoken# /frameset After I did this, I still get different CFID's. Can anyone help? thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:48 PM To: CF-Talk Subject: RE: CF code and Netscape Browser... Let me clarify what it's doing.It goes from the Index.html page to the default.cfm page (of course the application.cfm is first). The application.cfm page is saying the session variable session.current is not defined and sends it back to the Index.html...An endless loop... Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:45 PM To: CF-Talk Subject: CF code and Netscape Browser... I am pulling my hair out over this oneI have an index.html that gets the screensize then sends the page to a CF page (using JavaScript) to figure out which images I should use. It works fine in IE... But Netscape, I get an endless loop. It basically says my variable Session.Current is not defined. Please look at my code below and let me know why this is happening. INDEX.HTML html head titleUntitled/title META HTTP-EQUIV=refresh content=7; url=jscript.html /head BODY SCRIPT if (window != top) top.location.href = location.href; /SCRIPT form action=default.cfm method=post name=frm id=frm input type=hidden name=screensize value= input type=hidden name=MyCntr value= /form script language=JavaScript1.2 var width = screen.width; var height = screen.height; document.frm.screensize.value = screen.width; document.frm.MyCntr.value = 1; document.frm.submit(); /script /body /html APPLICATION.CFM cfapplication name=Myapp sessionmanagement=Yes setclientcookies=No sessiontimeout=#createTimeSpan(0,0,40,0)# cfset DSN = lala cflock timeout=60 throwontimeout=No name=check_session type=READONLY cfparam name=form.MyCntr default=No cfif form.MyCntr IS 1 cfset Session.current = Yes /cfif cfif Not IsDefined(session.current) cflocation url=index.html addtoken=No /cfif Cfparam name=Session.checkout default=No /cflock DEFAULT.CFM cfparam name=form.screensize default=800 cfquery name=Get_index datasource=#DSN# dbtype=ODBCSELECT * FROM Index_page_tbl WHERE Index_page_key = 1/cfquery cfoutput cfif Not IsDefined(form.screensize) cflocation url=index.html addtoken=No /cfif cflock timeout=30 throwontimeout=No name=Check_size type=READONLY cfset session.screensize = #form.screensize# /cflock /cfoutput cflock timeout=30 throwontimeout=No name=set_color type=READONLY cfoutputcfset session.color_scheme = #Get_index.color_scheme#/cfoutput /cflock html head titlecfoutput#Get_index.title#/cfoutput/title /head frameset cols=19%,81% FRAMEBORDER=0 BORDER=0 BORDERCOLOR=#FF frame name=menu src=menu.cfm scrolling=yes title=menu frame name=main title=main src=main.cfm /frameset noframes body pThis page uses frames, but your browser doesn't support them./p /body /noframes /html Thank you all... Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Macintosh Browser Emulator
Does anyone know of a website that allows you to emulate a Macintosh browser? I have been to Netscape's Website Garage, anybrowser.com and a couple of other browser compatibility checkers, and none of them emulate a Mac browser. If I can't find an emulator online or some software similar to Virtual PC, then I may have to break down and buy the Mac OS. Any help is appreciative, Jeff Stone [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
Since you are having CF do the processing and as long as Oracle is setup as the DSN this should work fine. I have been dealing with Oracle for ten years and it uses SQL just like SQL(database) does. I think you will find that when you do things using CF instead of stored procedures it will go across several platforms where if you use stored procedures it may not. One advantage to not using stored procedures but there are many advantages to using them. Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 713-328-2532 (Office) 713-328-2150 (Fax) 832-259-3010 (Cell) mailto:[EMAIL PROTECTED] http://www.corelab.com -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:45 AM To: CF-Talk Subject: Re: insert question This is for sql, I am not real sure in regard to oracle. But the same logic. I think the problem is really in the use of the CFIF statements. Doug - Original Message - From: Yager, Brian T Contractor/NCCIM [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 8:29 AM Subject: RE: insert question Doug, Is this for Oracle or SQL Server (or will it work for both)? Brian -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:33 AM To: CF-Talk Subject: Re: insert question It looks just like my create user account, take a look and hope it helps. CFQUERY DATASOURCE=#application.dsn# NAME=check_login SELECT email, password FROM cust_contacts WHERE email = '#email#' AND password = '#password#' /CFQUERY !--- CHECK TO SEE IF THE USER EXISTS IN THE DB AND IF THEY DO, REDIRECT THEM TO THE ERROR PAGE AND NOTIFY THEM TO LOGIN NORMALLY. //--- CFIF CHECK_LOGIN.RECORDCOUNT GT 0 CFLOCATION URL=/index.cfm?fuseaction=errormessage=1 CFELSE !--- IF THE USER DOES NOT EXIST, INSERT THEM INTO THE DATABASE//--- CFTRANSACTION CFQUERY DATASOURCE=#application.dsn# NAME=insert_cust_login DECLARE @maxid int BEGIN SELECT @maxid = MAX(ID) FROM cust_contacts IF@maxid IS NULL SELECT @maxid = 1 ELSE SELECT @maxid = @maxid + 1 END INSERT INTO cust_contacts VALUES ( '#custNum#', @maxid, '#f_name#', '#l_name#', '#email#', '#password#' ) /CFQUERY /CFTRANSACTION /CFIF Doug - Original Message - From: Jones, Becky [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:28 AM Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Macromedia Partner Briefing, Nov. 29th
Hello, Please allow me to introduce myself as the Macromedia Alliance Partner Manager for the west coast. I would like to invite all Macromedia partners to an Executive Partner Briefing on the 29th at our headquarters in San Francisco. The executive staff of Macromedia will be discussing the state of the industry, where Macromedia is taking our technology and how you can become more involved. Below are more details, and here is how to register http://www.allaire.com/partners/premierbriefing/ . Hope to see you there. Sarah Sarah A. Burns Alliance Partner Manager Macromedia [EMAIL PROTECTED] 617-219-2061 -Original Message- Subject: Register: Partner Briefing, November 29, 2001 Dear Macromedia Partner, Macromedia will be holding a special Partner Briefing at Macromedia headquarters in San Francisco on November 29, 2001. If you missed the Macromedia Partner Day at DevCon in Florida, this is your chance to get the latest information from the Macromedia Executive Team. The briefing will be a full day of presentations and discussions to update our Partners on Macromedia's product direction, strategy and new Partner Programs. This meeting will also give you the opportunity to ask questions and provide feedback on Macromedia's plans and programs. Please join Macromedia Executives: Stephen Elop, Executive VP, WorldWide Field Operations Tom Hale, Senior VP, Business Strategy Carolyn Lightner, VP, Educational Services Kevin Lynch, Executive VP President of Products Meg Meaney, Director, Partner Programs David Mendels, Chief Strategy Officer Patrick Morley, VP, US Sales Peter O'Kelly, VP, Strategy Sean Schnoor, Sr. Director, Solutions Marketing This is your opportunity to hear directly from the Macromedia leadership team: - Where the industry is going and what is Macromedia's impact - How Macromedia is planning to go-to-market today and in the future - How Partners can build a business around Macromedia - Partner feedback WHEN: Thursday, November 29th 9:00am - 3:00 pm WHERE: Macromedia 600 Townsend Street San Francisco, CA 94103 Tel: (415) 252-2000 For directions and map visit - http://www.macromedia.com/macromedia/mmdirections.html. WHO SHOULD ATTEND: To keep the briefing as intimate as possible, we ask that no more than two company representatives attend the Partner Briefing. The focus of the meeting is business strategy, so please choose your attendees accordingly. REGISTRATION: Registration for the Partner Briefing is required. You may register online at http://www.allaire.com/partners/premierbriefing. Upon registering you will receive a detailed confirmation email. We hope your schedule allows you to attend! Macromedia Partner Programs [EMAIL PROTECTED] Sarah A. Burns Alliance Partner Manager Macromedia 275 Grove Street Newton, MA 02466 617-219-2061 [EMAIL PROTECTED] Sarah A. Burns Alliance Partner Manager Macromedia 275 Grove Street Newton, MA 02466 617-219-2061 [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access XP and CF?
At least they finally got the default settings for text fields right... Required= No and Allow Zero Length = Yes Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 7:02 AM To: CF-Talk Subject: Re: Access XP and CF? access XP sux.. same thing it just doesnt let you open files on other networked drives.. they have to be on your local drive. i would stick to Access and Office 2000.. XP is buggy too.. example.. if you open a doc file in word and then save it and try to open it in word perfect it wont work.. if you create a doc file and try to open it in word perfect it wont work.. some other random application crashes also makes it suck more.. i see no reall advantage on using any XP product over 2000 products. - Original Message - From: Joseph Thompson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 11:29 PM Subject: Re: Access XP and CF? I talked to one developer who uploaded one of these and it worked fine; no problems yet (only two days live mind you) CF4.5 I just got a copy of Office XP Pro yesterday, which includes the new Access XP. Is Access XP compatible with CF 4.5 sp2's ODBC *and* OLEDB drivers? Should I leave XP off my development box and stick with Access 2k? Any shared experiences would be much appreciated. Thankfully I only have a very few sites still running it, but I have a bunch of custom tags with Access in them that I have to keep up. Thx, - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
I think your approach is a bit too simple. I don't know what your form looks like, or what this test USERS NEQ No Users means, but it should probably look like this. === CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT UserID, AppID FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) ORDER BY UserID /cfquery !--- Create a structure with a list of appIDs for each UserID found. --- cfset stUserApps = StructNew() cfoutput query=qryPeople group=UserID cfset stUserApps[qryPeople.UserID] = cfoutput cfset stUserApps[qryPeople.UserID]= ListAppend(stUserApps[qryPeople.UserID],AppID) /cfoutput /cfoutput cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfif NOT(StructKeyExists(stUserApps,i) AND ListFind(stUserApps[i],p)) !--- Only insert if the appID is not in the list for that user --- cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfif /cfloop /cfloop /cfif Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: vrijdag 16 november 2001 14:29 To: CF-Talk Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Tree in windows XP - Cold Fusion 5
Try upgrading to Sun Java Runtime Environment 1.3.1 or better. From what I understand, the applets were made to work under that flavor. Anything lower, be it Microsoft Java implementation or Sun and CF5 applets work properly... -Original Message- From: Irwan Kurniawan [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 1:52 AM To: CF-Talk Subject: RE: CF Tree in windows XP - Cold Fusion 5 There is an error (visual C error) when you double click CF Tree applet in windows XP and on CF 5.0. How to enable CAB like in CF 4.5 form cause in CF 5.0 using JRE version 1.3.0_01 Java HotSpot(TM) Client VMAny body can help? thanks FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
Something like this might help Becky, it will just skip the insert if a corresponding record already exists. cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, CFQUERY DATASOURCE=#request.dsn# NAME=qlogin BEGIN TRANSACTION IF NOT EXISTS (select AppID from tblAppIAUsers where Listing_ID = #i# and AppID = #p#) BEGIN INSERT INTO tblAppIAUsers (AppID,Listing_ID) VALUES (#p#,#i#) END COMMIT TRANSACTION /CFQUERY /cfloop /cfloop Doing the loops inside the query/stored proc is beyond me atm, but it will be possible with cursors if it's really necessary. Cheers, Craig. -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 16 November 2001 13:29 To: CF-Talk Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: insert question
I would do this in a stored proc I am not this is absolutely the most efficient but works well for me (this is sql server) You would then call stored proc each step of loop ove form list. I actually have built some stored procs and functions for looping over lists but for this application probably just as simple to do the looping in cf. HTH Don create procedure usp_update_app_listing @appID int, (or whatever types you are using) @listing_id int AS DECLARE @foo int set @foo=(select AppId from tblAppIAUsers where appId = @appId and listing_id = @listing_id ) IF @foo is null insert into tblAppIAUsers (appId, listing_id) VALUES (@appId,@listing_id) - Original Message - From: Jones, Becky [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 6:28 AM Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Macintosh Browser Emulator
Net Mechanic has a service that will do screenshots on multiple platform/br owser combinations. I'm pretty sure Mac is included. http://www.netmechanic.com/browser-index.htm Jeff Stone [EMAIL PROTECTED] 11/16/01 11:44AM Does anyone know of a website that allows you to emulate a Macintosh browser? I have been to Netscape's Website Garage, anybrowser.com and a couple of other browser compatibility checkers, and none of them emulate a Mac browser. If I can't find an emulator online or some software similar to Virtual PC, then I may have to break down and buy the Mac OS. Any help is appreciative, Jeff Stone [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access XP and CF?
There are quite a few new or improved features according to Microsoft. Some new features are: - Enabled for the use of speech for both voice dictation and command-and-control scenarios - The Data Access Page HTML Designer provides users with a variety of new and improved enhancements - Using the new optional Access file format, users can enjoy faster access and data processing for large databases - Multiple Undo and Redo - Conversion Error Logging - PivotTables and PivotCharts - XML Presentation Output - Save Forms and Reports as Data Access Pages - Stored Procedure Designer - Batch Updates for Access Projects - XML Support - XSL Transforma-tions and Presentations - Bind Data Access Pages to Embedded or Linked XML Files - Worldwide Complex Script Interface There are tons of things they claim are improved. Check out the Product Guide at: http://www.microsoft.com/office/access/evaluation/AccessPG.doc Mike -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:45 AM To: CF-Talk Subject: Re: Access XP and CF? well i've been thinking.. is there anything new on access XP exept that security thing.. why would somone want to upgrade to office XP if there is nothing woth upgrading for the looks..? i did notice a small improvement from office 97 to 2000 but in XP i havent found any improvements but the look. Alexis.. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Converting an Access 97 db to an Access 200 db?
Folks: For one of our ColdFusion apps, we are contemplating upgrading one of our Access 97 databases to an Access 2000 database. Has anyone had any experience doing this? Thoughts, comments and suggestions are welcome! Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Converting an Access 97 db to an Access 200 db?
should be just fine as long as you have the latest version of MDAC installed Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 10:57 AM Subject: Converting an Access 97 db to an Access 200 db? Folks: For one of our ColdFusion apps, we are contemplating upgrading one of our Access 97 databases to an Access 2000 database. Has anyone had any experience doing this? Thoughts, comments and suggestions are welcome! Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting an Access 97 db to an Access 200 db?
I never experienced any problems switching over. went smoothly. -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 1:58 PM To: CF-Talk Subject: Converting an Access 97 db to an Access 200 db? Folks: For one of our ColdFusion apps, we are contemplating upgrading one of our Access 97 databases to an Access 2000 database. Has anyone had any experience doing this? Thoughts, comments and suggestions are welcome! Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting an Access 97 db to an Access 200 db?
MDAC? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 2:04 PM To: CF-Talk Subject: Re: Converting an Access 97 db to an Access 200 db? should be just fine as long as you have the latest version of MDAC installed Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 10:57 AM Subject: Converting an Access 97 db to an Access 200 db? Folks: For one of our ColdFusion apps, we are contemplating upgrading one of our Access 97 databases to an Access 2000 database. Has anyone had any experience doing this? Thoughts, comments and suggestions are welcome! Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Converting an Access 97 db to an Access 200 db?
Microsoft Data Access Components (latest will be installed if you have latest version of IE or at least 5.5) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 11:13 AM Subject: RE: Converting an Access 97 db to an Access 200 db? MDAC? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 2:04 PM To: CF-Talk Subject: Re: Converting an Access 97 db to an Access 200 db? should be just fine as long as you have the latest version of MDAC installed Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 10:57 AM Subject: Converting an Access 97 db to an Access 200 db? Folks: For one of our ColdFusion apps, we are contemplating upgrading one of our Access 97 databases to an Access 2000 database. Has anyone had any experience doing this? Thoughts, comments and suggestions are welcome! Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
pascal, this works great. thank u. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 12:03 PM To: CF-Talk Subject: RE: insert question I think your approach is a bit too simple. I don't know what your form looks like, or what this test USERS NEQ No Users means, but it should probably look like this. === CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT UserID, AppID FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) ORDER BY UserID /cfquery !--- Create a structure with a list of appIDs for each UserID found. --- cfset stUserApps = StructNew() cfoutput query=qryPeople group=UserID cfset stUserApps[qryPeople.UserID] = cfoutput cfset stUserApps[qryPeople.UserID]= ListAppend(stUserApps[qryPeople.UserID],AppID) /cfoutput /cfoutput cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfif NOT(StructKeyExists(stUserApps,i) AND ListFind(stUserApps[i],p)) !--- Only insert if the appID is not in the list for that user --- cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfif /cfloop /cfloop /cfif Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: vrijdag 16 november 2001 14:29 To: CF-Talk Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL-Server DTS through CF
I would like to be able to import an ACCESS data table into SQL-Server 2000 (using DTS?), and do a reverse export, under CF control. This needs to happen every month. Does anyone know of any documentation or sample code for this kind of task? Any pointers would be much appreciated. Thank you. Rick Colman ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL-Server DTS through CF
Dumb question perhaps but why the added complication of involving cf? Why not just have it be a scheduled task in SQL Server? - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 12:32 PM Subject: SQL-Server DTS through CF I would like to be able to import an ACCESS data table into SQL-Server 2000 (using DTS?), and do a reverse export, under CF control. This needs to happen every month. Does anyone know of any documentation or sample code for this kind of task? Any pointers would be much appreciated. Thank you. Rick Colman ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting an Access 97 db to an Access 200 db?
Sup man, MDAC = Microsoft Data Access Components http://www.microsoft.com/data/MDAC21info/MDACinstQ.htm Peace, Mike -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 2:14 PM To: CF-Talk Subject: RE: Converting an Access 97 db to an Access 200 db? MDAC? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Best practices storing CC
Any advice on storing credit card info? My thoughts are that it should be stored in a separate db which is not accessible via web and have cf push the info to a template behind the firewall to do the actual authorization and push the results back to the main server. Does this make sense or am I making it too complicated (or leaving something obvious out). What are recommendatsions on encyption, is DES ok or do I need something else? TIA Don ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL-Server DTS through CF
Richard: I have recently tackled the same task for a project that I was working on. Mind you, my usage was with SQL Server 2000, so any incompatibilities (of which I believe there are none) with 7.0 are not accounted for here. First of all, DTS packages can only be called via command prompt using the DTSRun utility that comes with SQL Server. To execute this through CF, you can leverage an Extended Stored Procedure that comes with SQL Server, called xp_cmdshell. Since it's a stored procedure, it can be invoked via CFSTOREDPROC or even through CFQUERY. Keep in mind that only SQL Server logins with the sysadmin roll can execute Extended Stored Procs. My need was to use DTS to import data from an Excel file uploaded by the user into SQL Server, and perform some manipulation to that data. I wrote my own stored procedure to invoke the extended stored procedure, which then ran the DTS Run Command: Stored Proc --invokes--- xp_cmdShell --invokes--- DTSRun I then pass in the necessary parameters for the DTSRun utility into my stored proc, as shown in the below example: --- BEGIN MY STORED PROC --- CREATE PROC sp_Survey_import @ImportFilePath nvarchar(100), @DTSName nvarchar(20), @server nvarchar(30), @username nvarchar(15), @password nvarchar(15) AS DECLARE @dtsScript nvarchar(100); SET @dtsScript = dtsrun /n + @DTSName + /s + @server + /u + @username + /p + @password PRINT @DTSName EXEC master.dbo.xp_cmdshell @dtsScript GO --- END MY STORED PROC --- The import path must be publicly accessible to the Database server, since that is where the procedure is invoked. If you need CF to handle DTS, this is the best method that I have found. --Paul Paul W. Wille[EMAIL PROTECTED] -- Certified Advanced ColdFusion 5.0 Developer -- ISITE Design, Inc. - Solutions Architect www.isitedesign.com 503.221.9860 x110 888.269.9103 503.221.9865 fax -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 11:32 AM To: CF-Talk Subject: SQL-Server DTS through CF I would like to be able to import an ACCESS data table into SQL-Server 2000 (using DTS?), and do a reverse export, under CF control. This needs to happen every month. Does anyone know of any documentation or sample code for this kind of task? Any pointers would be much appreciated. Thank you. Rick Colman ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF code and Netscape Browser...
Whoever is interestedHere is the answer I had to pass the cfid and cftoken like this... frame name=menu src=menu.cfm?session.CFID=#session.cfid#session.CFTOKEN=#Session.cftoken# scrolling=yes title=menu frame name=main title=main src=main.cfm?session.CFID=#session.cfid#session.CFTOKEN=#Session.cftoken# This made everything work just fine... Thanks all.. Brian -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:38 AM To: CF-Talk Subject: RE: CF code and Netscape Browser... Does anyone know if Netscape has different rules regarding frames? I did a test with this (printed out the session.cfid) and it was different in both frames. So I added this to me default.cfm page (the framset page): frameset cols=19%,81% FRAMEBORDER=0 BORDER=0 BORDERCOLOR=#FF frame name=menu src=menu.cfm?CFID=#session.cfid#CFTOKEN=#Session.cftoken# scrolling=yes title=menu frame name=main title=main src=main.cfm?CFID=#session.cfid#CFTOKEN=#Session.cftoken# /frameset After I did this, I still get different CFID's. Can anyone help? thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:48 PM To: CF-Talk Subject: RE: CF code and Netscape Browser... Let me clarify what it's doing.It goes from the Index.html page to the default.cfm page (of course the application.cfm is first). The application.cfm page is saying the session variable session.current is not defined and sends it back to the Index.html...An endless loop... Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:45 PM To: CF-Talk Subject: CF code and Netscape Browser... I am pulling my hair out over this oneI have an index.html that gets the screensize then sends the page to a CF page (using JavaScript) to figure out which images I should use. It works fine in IE... But Netscape, I get an endless loop. It basically says my variable Session.Current is not defined. Please look at my code below and let me know why this is happening. INDEX.HTML html head titleUntitled/title META HTTP-EQUIV=refresh content=7; url=jscript.html /head BODY SCRIPT if (window != top) top.location.href = location.href; /SCRIPT form action=default.cfm method=post name=frm id=frm input type=hidden name=screensize value= input type=hidden name=MyCntr value= /form script language=JavaScript1.2 var width = screen.width; var height = screen.height; document.frm.screensize.value = screen.width; document.frm.MyCntr.value = 1; document.frm.submit(); /script /body /html APPLICATION.CFM cfapplication name=Myapp sessionmanagement=Yes setclientcookies=No sessiontimeout=#createTimeSpan(0,0,40,0)# cfset DSN = lala cflock timeout=60 throwontimeout=No name=check_session type=READONLY cfparam name=form.MyCntr default=No cfif form.MyCntr IS 1 cfset Session.current = Yes /cfif cfif Not IsDefined(session.current) cflocation url=index.html addtoken=No /cfif Cfparam name=Session.checkout default=No /cflock DEFAULT.CFM cfparam name=form.screensize default=800 cfquery name=Get_index datasource=#DSN# dbtype=ODBCSELECT * FROM Index_page_tbl WHERE Index_page_key = 1/cfquery cfoutput cfif Not IsDefined(form.screensize) cflocation url=index.html addtoken=No /cfif cflock timeout=30 throwontimeout=No name=Check_size type=READONLY cfset session.screensize = #form.screensize# /cflock /cfoutput cflock timeout=30 throwontimeout=No name=set_color type=READONLY cfoutputcfset session.color_scheme = #Get_index.color_scheme#/cfoutput /cflock html head titlecfoutput#Get_index.title#/cfoutput/title /head frameset cols=19%,81% FRAMEBORDER=0 BORDER=0 BORDERCOLOR=#FF frame name=menu src=menu.cfm scrolling=yes title=menu frame name=main title=main src=main.cfm /frameset noframes body pThis page uses frames, but your browser doesn't support them./p /body /noframes /html Thank you all... Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF code and Netscape Browser...
Why would you pass your URL vars like that? That creates a struct called session in the URL scope - NOT the same thing as a session variable. - Original Message - From: Yager, Brian T Contractor/NCCIM [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:56 PM Subject: RE: CF code and Netscape Browser... Whoever is interestedHere is the answer I had to pass the cfid and cftoken like this... frame name=menu src=menu.cfm?session.CFID=#session.cfid#session.CFTOKEN=#Session.cftoken# scrolling=yes title=menu frame name=main title=main src=main.cfm?session.CFID=#session.cfid#session.CFTOKEN=#Session.cftoken# This made everything work just fine... Thanks all.. Brian -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:38 AM To: CF-Talk Subject: RE: CF code and Netscape Browser... Does anyone know if Netscape has different rules regarding frames? I did a test with this (printed out the session.cfid) and it was different in both frames. So I added this to me default.cfm page (the framset page): frameset cols=19%,81% FRAMEBORDER=0 BORDER=0 BORDERCOLOR=#FF frame name=menu src=menu.cfm?CFID=#session.cfid#CFTOKEN=#Session.cftoken# scrolling=yes title=menu frame name=main title=main src=main.cfm?CFID=#session.cfid#CFTOKEN=#Session.cftoken# /frameset After I did this, I still get different CFID's. Can anyone help? thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:48 PM To: CF-Talk Subject: RE: CF code and Netscape Browser... Let me clarify what it's doing.It goes from the Index.html page to the default.cfm page (of course the application.cfm is first). The application.cfm page is saying the session variable session.current is not defined and sends it back to the Index.html...An endless loop... Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:45 PM To: CF-Talk Subject: CF code and Netscape Browser... I am pulling my hair out over this oneI have an index.html that gets the screensize then sends the page to a CF page (using JavaScript) to figure out which images I should use. It works fine in IE... But Netscape, I get an endless loop. It basically says my variable Session.Current is not defined. Please look at my code below and let me know why this is happening. INDEX.HTML html head titleUntitled/title META HTTP-EQUIV=refresh content=7; url=jscript.html /head BODY SCRIPT if (window != top) top.location.href = location.href; /SCRIPT form action=default.cfm method=post name=frm id=frm input type=hidden name=screensize value= input type=hidden name=MyCntr value= /form script language=JavaScript1.2 var width = screen.width; var height = screen.height; document.frm.screensize.value = screen.width; document.frm.MyCntr.value = 1; document.frm.submit(); /script /body /html APPLICATION.CFM cfapplication name=Myapp sessionmanagement=Yes setclientcookies=No sessiontimeout=#createTimeSpan(0,0,40,0)# cfset DSN = lala cflock timeout=60 throwontimeout=No name=check_session type=READONLY cfparam name=form.MyCntr default=No cfif form.MyCntr IS 1 cfset Session.current = Yes /cfif cfif Not IsDefined(session.current) cflocation url=index.html addtoken=No /cfif Cfparam name=Session.checkout default=No /cflock DEFAULT.CFM cfparam name=form.screensize default=800 cfquery name=Get_index datasource=#DSN# dbtype=ODBCSELECT * FROM Index_page_tbl WHERE Index_page_key = 1/cfquery cfoutput cfif Not IsDefined(form.screensize) cflocation url=index.html addtoken=No /cfif cflock timeout=30 throwontimeout=No name=Check_size type=READONLY cfset session.screensize = #form.screensize# /cflock /cfoutput cflock timeout=30 throwontimeout=No name=set_color type=READONLY cfoutputcfset session.color_scheme = #Get_index.color_scheme#/cfoutput /cflock html head titlecfoutput#Get_index.title#/cfoutput/title /head frameset cols=19%,81% FRAMEBORDER=0 BORDER=0 BORDERCOLOR=#FF frame name=menu src=menu.cfm scrolling=yes title=menu frame name=main title=main src=main.cfm /frameset noframes body pThis page uses frames, but your browser doesn't support them./p /body /noframes /html Thank you all... Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 ~~ Your ad could be
Re: SQL-Server DTS through CF
It can also be called via COM. - Original Message - From: Paul Wille [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:53 PM Subject: RE: SQL-Server DTS through CF Richard: I have recently tackled the same task for a project that I was working on. Mind you, my usage was with SQL Server 2000, so any incompatibilities (of which I believe there are none) with 7.0 are not accounted for here. First of all, DTS packages can only be called via command prompt using the DTSRun utility that comes with SQL Server. To execute this through CF, you can leverage an Extended Stored Procedure that comes with SQL Server, called xp_cmdshell. Since it's a stored procedure, it can be invoked via CFSTOREDPROC or even through CFQUERY. Keep in mind that only SQL Server logins with the sysadmin roll can execute Extended Stored Procs. My need was to use DTS to import data from an Excel file uploaded by the user into SQL Server, and perform some manipulation to that data. I wrote my own stored procedure to invoke the extended stored procedure, which then ran the DTS Run Command: Stored Proc --invokes--- xp_cmdShell --invokes--- DTSRun I then pass in the necessary parameters for the DTSRun utility into my stored proc, as shown in the below example: --- BEGIN MY STORED PROC --- CREATE PROC sp_Survey_import @ImportFilePath nvarchar(100), @DTSName nvarchar(20), @server nvarchar(30), @username nvarchar(15), @password nvarchar(15) AS DECLARE @dtsScript nvarchar(100); SET @dtsScript = dtsrun /n + @DTSName + /s + @server + /u + @username + /p + @password PRINT @DTSName EXEC master.dbo.xp_cmdshell @dtsScript GO --- END MY STORED PROC --- The import path must be publicly accessible to the Database server, since that is where the procedure is invoked. If you need CF to handle DTS, this is the best method that I have found. --Paul Paul W. Wille[EMAIL PROTECTED] -- Certified Advanced ColdFusion 5.0 Developer -- ISITE Design, Inc. - Solutions Architect www.isitedesign.com 503.221.9860 x110 888.269.9103 503.221.9865 fax -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 11:32 AM To: CF-Talk Subject: SQL-Server DTS through CF I would like to be able to import an ACCESS data table into SQL-Server 2000 (using DTS?), and do a reverse export, under CF control. This needs to happen every month. Does anyone know of any documentation or sample code for this kind of task? Any pointers would be much appreciated. Thank you. Rick Colman ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best practices storing CC
cf_cya I would strongly recommend against storing credit card numbers anywhere. 1. potential for thousands, if not millions, in dollars of liability 2. if the site's customers find out, they will likely go somewhere else (I do when I know a site stores my card #) 3. performance - CF's encryption is too weak - you'd need to use something third-party which would probably be a load increase 4. see #1 5. see #4 6. see #5 /cf_cya However, if you just HAVE to keep your users from reentering their card # every time, look at some third party solutions. Microsoft's comes to mind. (Okay ppl - let's pretend like we're mature and not turn this into another pathetic why Microsoft is bad thread - I'm just pointing out a potential technology) I don't know how much faith I have in other company's security infrastructures, but I'd be willing to bet that it's far better than anything that I could ever hope to build. - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:46 PM Subject: Best practices storing CC Any advice on storing credit card info? My thoughts are that it should be stored in a separate db which is not accessible via web and have cf push the info to a template behind the firewall to do the actual authorization and push the results back to the main server. Does this make sense or am I making it too complicated (or leaving something obvious out). What are recommendatsions on encyption, is DES ok or do I need something else? TIA Don ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best practices storing CC
Don Vawter asked: Any advice on storing credit card info? We're pretty radical about our beliefs on CC#'s: We don't keep them *anywhere*. We keep the last 4 digits and the CC type, and that's it. The CC# gets immediately PGP encrypted [1] and emailed to our processing center, where it is stored on a machine that, for all intents and purposes, is inaccessible via the web. We also don't have have any responsibility for the machine, so we have pretty much zero liability, which is exactly how we like it. We're CC#-phobic. :) Does this make sense or am I making it too complicated (or leaving something obvious out). Well, while the complexity of a system does not always relate to the security of a system, you never can be *too* secure. I think that any hoops that you can jump through for even the slightest bit more security are worth jumping through. Then again, that may just be my gov't contractor background speaking. ;) What are recommendatsions on encyption, is DES ok or do I need something else? If you *absolutely must* store and retrieve CC#s, then 3DES isn't a bad route. While it is tried and true (having been a gov't std for the last few decades), also know that it is being phased out and replaced. I think the normal key length for good 3DES encryption is up to 256bits? I may be a bit out of it, tho, as I haven't messed with it in a few years. You may also want to look into Blowfish/Twofish. I'm pretty sure there are CFX tags to do each of them. Also, if you haven't read Applied Cryptography by Bruce Schneier (sp?), do so. It's a bit thick, but it's totally worth it. It'll help show you that security isn't just about encryption and may even give you a few ideas for tightening up your CC# security. -R [1] Notes on PGP :: PGP is rather difficult to get talking to CF. There are pre-built solutions, but they are not for the tight of budget. The CFX_PGP tag is in the $300 area, but I haven't heard any complaints about it. PGP, Inc. has a solution, but it *starts* at $5500 per server. The current PGP tools (7.x) are *intentionally* hobbled to keep you from using them with web servers. [2] There is an API that you can use for the 7.x series, but it is new and completely undocumented, so you just have several hundred source files to work with if you want to build a CFX tag. The previous API is better documented, but it doesn't work with the 7.x series and is now unsupported. I wrote a huge journal entry on the trials and tribulations of trying to get PGP to work. I eventually got it to work, but I'm a bit hazy on whether or not my implementation is even legally/correctly licensed. My advice: tread lightly. [2] http://www.rickosborne.org/Journal/journal-1-69.cfm -R ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL-Server DTS through CF
Needs to be done under manual control by an operator. Cannot run automatically. Sigh ... -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 11:37 AM To: CF-Talk Subject: Re: SQL-Server DTS through CF Dumb question perhaps but why the added complication of involving cf? Why not just have it be a scheduled task in SQL Server? - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 12:32 PM Subject: SQL-Server DTS through CF I would like to be able to import an ACCESS data table into SQL-Server 2000 (using DTS?), and do a reverse export, under CF control. This needs to happen every month. Does anyone know of any documentation or sample code for this kind of task? Any pointers would be much appreciated. Thank you. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Coldfusion form within Onclick?
Im using ezedit. I want to from within the onclick of one of their function call on coldfusion to set some variables for me? Anyone out there done this... I cannot figure this out? Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best practices storing CC
Your best bet would be to send them to me :) On Fri, 16 Nov 2001, Don Vawter wrote: Any advice on storing credit card info? My thoughts are that it should be stored in a separate db which is not accessible via web and have cf push the info to a template behind the firewall to do the actual authorization and push the results back to the main server. Does this make sense or am I making it too complicated (or leaving something obvious out). What are recommendatsions on encyption, is DES ok or do I need something else? TIA Don ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best practices storing CC
(Okay ppl - let's pretend like we're mature and not turn this into another pathetic why Microsoft is bad thread - I'm just pointing out a potential technology) So its immature to point out that the system is insecure (re: the recent Hotmail exploit of Passport that grabbed people's CC numbers)? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best practices storing CC
heh my whole database lies on a separate server, and the CC numbers in there look like this ^%@!^%@$!)fwer4ewkahnsdkajlhj7866t43223$^%#!@!@bslk\][qe2896^$!@09uepwrhjkl/nda/;lq-098213hkljhklisy87^*(%@#@)(*POJW}QESKJNQDSKJ982t1837521iugKJALKNSoe8134602984ioLKHANS:IQJH)9712936521543 it's low tech cuz i just use this algorithm in my coldfusion template to turn it into that. If anyone needed to find out that number, they will have to hack into my root folder and look at the CFM template. But that's not it. Another part of the algorithm lies in my hard drive somewhere but not in the root folder. And just for good measure, the name of the fields of those CC's has nothing to do with CC's. Also the actual billing table has a field called credit card in it, that contains this... *^#@*(IUHDSDHO:IHIDO:HDW*(^@IhOID*^#@*(IUHDSDHO:IHIDO:HDW*(^@IhOID*^#@*(IUHDSDHO:IHIDO:HDW*(^@IhOID which is just dynamic garbage lol. HAHA, have fun decrypting that my friend! Pyschology is your best tool! From: Don Vawter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Best practices storing CC Date: Fri, 16 Nov 2001 12:46:38 -0700 Any advice on storing credit card info? My thoughts are that it should be stored in a separate db which is not accessible via web and have cf push the info to a template behind the firewall to do the actual authorization and push the results back to the main server. Does this make sense or am I making it too complicated (or leaving something obvious out). What are recommendatsions on encyption, is DES ok or do I need something else? TIA Don ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
is fileexists slow?
Is cffileexists slow, or processor/file system intensive? Would it be unwise to have a cffileexists on a template which is called frequently? I could create a flag in the db indicating that a file exists as an alternative. But is it necessary? Would a large number of fileexists calls cause a drag on the file system? Or is it relatively fast? Thanks for the insights! Brook ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best practices storing CC
I don't WANT to store credit card information. The question is whether the customer is willing to reenter cc number every month. The billing is monthly but unlike a subscription the charge is not constant which seems to be difficult for the providers to handle. Currently I use payflow from Verisign (cfm app by the way) and am perfectly happy with them. I am just afraid in this new scenario that a B2B customer is unlikely to be happy filling in cc info every month. Any better solutions would be very welcome. I could even go the paper invoicing method if necessary but that seems terribly inefficient. - Original Message - From: BILLY CRAVENS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:07 PM Subject: Re: Best practices storing CC cf_cya I would strongly recommend against storing credit card numbers anywhere. 1. potential for thousands, if not millions, in dollars of liability 2. if the site's customers find out, they will likely go somewhere else (I do when I know a site stores my card #) 3. performance - CF's encryption is too weak - you'd need to use something third-party which would probably be a load increase 4. see #1 5. see #4 6. see #5 /cf_cya However, if you just HAVE to keep your users from reentering their card # every time, look at some third party solutions. Microsoft's comes to mind. (Okay ppl - let's pretend like we're mature and not turn this into another pathetic why Microsoft is bad thread - I'm just pointing out a potential technology) I don't know how much faith I have in other company's security infrastructures, but I'd be willing to bet that it's far better than anything that I could ever hope to build. - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:46 PM Subject: Best practices storing CC Any advice on storing credit card info? My thoughts are that it should be stored in a separate db which is not accessible via web and have cf push the info to a template behind the firewall to do the actual authorization and push the results back to the main server. Does this make sense or am I making it too complicated (or leaving something obvious out). What are recommendatsions on encyption, is DES ok or do I need something else? TIA Don ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL-Server DTS through CF
may be oversimplifed but... cfexecute name=c:\path\to\DTSRun.exe arguments=-S ServerName -E -N DTSName/ load the page and boom, executed DTS Package. I'm sure one could set up a switch/case scenario as well. Or one of the other methods. will William H. Bowen Webmaster ALSTOM's Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX Master ColdFusion 4.5 - Brainbench 10/02/2001 http://www.brainbench.com/transcript.jsp?pid=1577915 CONFIDENTIALITY: This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 11:32 AM Subject: SQL-Server DTS through CF I would like to be able to import an ACCESS data table into SQL-Server 2000 (using DTS?), and do a reverse export, under CF control. This needs to happen every month. Does anyone know of any documentation or sample code for this kind of task? Any pointers would be much appreciated. Thank you. Rick Colman ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best practices storing CC
That sure looks like a different question to me. You could invoice customers by either email or paper and have them connect to your web site to pay by credit card. In that case, entering a card number each time is not out of the question. Also, in contast to automated billing, I would think this approach may be more desirable to the billing company. By requiring a live human being to connect and re-enter cc information, you're also getting an explicit approval from the customer for the invoiced charges. With automated card payments, given that the invoice amounts may vary each month, you could have the charges questioned after the cc is billed, and you may see a number of charge-backs. Jim - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 2:02 PM Subject: Re: Best practices storing CC I don't WANT to store credit card information. The question is whether the customer is willing to reenter cc number every month. The billing is monthly but unlike a subscription the charge is not constant which seems to be difficult for the providers to handle. Currently I use payflow from Verisign (cfm app by the way) and am perfectly happy with them. I am just afraid in this new scenario that a B2B customer is unlikely to be happy filling in cc info every month. Any better solutions would be very welcome. I could even go the paper invoicing method if necessary but that seems terribly inefficient. - Original Message - From: BILLY CRAVENS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:07 PM Subject: Re: Best practices storing CC cf_cya I would strongly recommend against storing credit card numbers anywhere. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: is fileexists slow?
Not really. In my tests it took about 3.5 times longer to run this cfif fileExists() than it did to run this: cfif x IS 1 So you shouldn't worry about it. My mediocre machine will still run about 6 cfif fileExists() per millisecond. Bryan Love Macromedia Certified Professional Internet Application Developer / Database Analyst Telecommunication Systems Inc. [EMAIL PROTECTED] ...'If there must be trouble, let it be in my day, that my child may have peace;' and this single reflection, well applied, is sufficient to awaken every man to duty - Thomas Paine, The American Crisis -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 1:11 PM To: CF-Talk Subject: is fileexists slow? Is cffileexists slow, or processor/file system intensive? Would it be unwise to have a cffileexists on a template which is called frequently? I could create a flag in the db indicating that a file exists as an alternative. But is it necessary? Would a large number of fileexists calls cause a drag on the file system? Or is it relatively fast? Thanks for the insights! Brook ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RequestTimeOut with a custom tag
How do you pass a requesttimeout when you call the template as a custom tag? Or do you put the timeout on the template calling the tag? Lon Lentz Applications Developer and CyberEntomolgist http://ProofitOnline.Com - Free 15 Day Trial ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
get date? OT
I have a query that selects all the shipping addresses that a user has, and I am using a JS array to populte the fields correctly. What I want to do is populate the fields with their last used shipping address (default address) based upon the date. Is there a way in javascript that I can get the latest date from today's date in javascript? I have a field that is called dateLastUsed that I can query from CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: get date? OT
www.irt.org has how tos on dates On Fri, 16 Nov 2001, Douglas L. Brown wrote: I have a query that selects all the shipping addresses that a user has, and I am using a JS array to populte the fields correctly. What I want to do is populate the fields with their last used shipping address (default address) based upon the date. Is there a way in javascript that I can get the latest date from today's date in javascript? I have a field that is called dateLastUsed that I can query from CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DreamWeaver UltraDev 4 and CF Studio
Question; Has anyone figured out how to do Tag completion in UltraDev4 like we can do in CF Studio? They want me to use UltraDev, but I truly am spoiled by the Tag Completion feature of Studio. Any direction on this would be greatly appreciated. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best practices storing CC
No, I wouldn't say that's immature. I'm just referring to the way that Microsoft discussion usually disintegrate - you know, the usual this is just a typical example of Microsoft and Microsoft is evil and is taking over my life by ppl with Outlook and Outlook Express headers. It just seems that Microsoft, more than any other company, seems to motivate responses that seem to be filled with slippery slopes and silly conspiracy talk. Discussing systems is very mature; it's the generalized discussions about companies that annoy me. - Original Message - From: Zac Belado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 3:06 PM Subject: RE: Best practices storing CC (Okay ppl - let's pretend like we're mature and not turn this into another pathetic why Microsoft is bad thread - I'm just pointing out a potential technology) So its immature to point out that the system is insecure (re: the recent Hotmail exploit of Passport that grabbed people's CC numbers)? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best practices storing CC
In that case, I would make the client aware of the risks, and make them sign a disclaimer. Forgoing a client's 15-30 seconds of convenience, or even losing a client, seems better than the potential liability. - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 3:02 PM Subject: Re: Best practices storing CC I don't WANT to store credit card information. The question is whether the customer is willing to reenter cc number every month. The billing is monthly but unlike a subscription the charge is not constant which seems to be difficult for the providers to handle. Currently I use payflow from Verisign (cfm app by the way) and am perfectly happy with them. I am just afraid in this new scenario that a B2B customer is unlikely to be happy filling in cc info every month. Any better solutions would be very welcome. I could even go the paper invoicing method if necessary but that seems terribly inefficient. - Original Message - From: BILLY CRAVENS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:07 PM Subject: Re: Best practices storing CC cf_cya I would strongly recommend against storing credit card numbers anywhere. 1. potential for thousands, if not millions, in dollars of liability 2. if the site's customers find out, they will likely go somewhere else (I do when I know a site stores my card #) 3. performance - CF's encryption is too weak - you'd need to use something third-party which would probably be a load increase 4. see #1 5. see #4 6. see #5 /cf_cya However, if you just HAVE to keep your users from reentering their card # every time, look at some third party solutions. Microsoft's comes to mind. (Okay ppl - let's pretend like we're mature and not turn this into another pathetic why Microsoft is bad thread - I'm just pointing out a potential technology) I don't know how much faith I have in other company's security infrastructures, but I'd be willing to bet that it's far better than anything that I could ever hope to build. - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 1:46 PM Subject: Best practices storing CC Any advice on storing credit card info? My thoughts are that it should be stored in a separate db which is not accessible via web and have cf push the info to a template behind the firewall to do the actual authorization and push the results back to the main server. Does this make sense or am I making it too complicated (or leaving something obvious out). What are recommendatsions on encyption, is DES ok or do I need something else? TIA Don ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DreamWeaver UltraDev 4 and CF Studio
Those capabilities don't exist. The code mode is really nothing more than Notepad with color coding. - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 4:23 PM Subject: DreamWeaver UltraDev 4 and CF Studio Question; Has anyone figured out how to do Tag completion in UltraDev4 like we can do in CF Studio? They want me to use UltraDev, but I truly am spoiled by the Tag Completion feature of Studio. Any direction on this would be greatly appreciated. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Windows NT Error 0 when running CFX Wizard
Hey All! I'm trying to run the CFX Wizard provided by CF 4.5.1. When I finish the settings, I get the error Windows NT Error 0 when accessing the registry. Anyone have any idea how to fix this? I am running Win 2K Pro without IIS on a laptop. Russel ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DreamWeaver UltraDev 4 and CF Studio
Actually, UD/DW seems to be pretty good about allowing you to make modifications in a WYSIWYG without totally screwing up your code. I think it really varies by application and developer - sometimes your emphasis is tight, efficient code, sometimes it's on RAD. Each tool has its strong points. - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 4:39 PM Subject: RE: DreamWeaver UltraDev 4 and CF Studio Thanks - That was kind of what I had come to the conclusion of, Worthless unless you totally use WYSIWYG I like to see what I am coding, so I guess I just stick with Studio. I guess I still don't see why they have the link to UD in Studio either, what purpose does that solve? Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 4:25 PM To: CF-Talk Subject: Re: DreamWeaver UltraDev 4 and CF Studio Those capabilities don't exist. The code mode is really nothing more than Notepad with color coding. - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 4:23 PM Subject: DreamWeaver UltraDev 4 and CF Studio Question; Has anyone figured out how to do Tag completion in UltraDev4 like we can do in CF Studio? They want me to use UltraDev, but I truly am spoiled by the Tag Completion feature of Studio. Any direction on this would be greatly appreciated. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DreamWeaver UltraDev 4 and CF Studio
Go to www.massimocorner.com for a set of ColdFusion objects for UltraDev that make it easier to work with, and also his Snippets extension to UltraDev, which allow you to work with snippets created in Homesite/CFStudio. If you use the two programs together you'll get the most for your money. UltraDev takes a little getting used to -- especially the floaty windows -- but you can do things in it that you can't do in CF Studio, such as applying rollover behaviors, javascript functions, adjusting table widths, inserting and optimizing images, turning complex code into point-and-click server behaviors, and doing complex recordset navigation easily. Having the button on Studio makes it easy to go back and forth. tom Larry Juncker [EMAIL PROTECTED] wrote in message 001701c16eef$83873580$2354ead1@HEARTLAND">news:001701c16eef$83873580$2354ead1@HEARTLAND... Thanks - That was kind of what I had come to the conclusion of, Worthless unless you totally use WYSIWYG I like to see what I am coding, so I guess I just stick with Studio. I guess I still don't see why they have the link to UD in Studio either, what purpose does that solve? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DreamWeaver UltraDev 4 and CF Studio
I've used UD and Studio together since UD 1 came out and before that DW and Studio. Personally designing complex table structures from scratch by hand takes way too much time. That's what CF is all about, RAD... I've done some site designs in DW that would never have been possible by hand simply because of the time it would take to perfect a table structure that was extremly complex. Hopefully after all of the people still using NS4 upgrade, we can finally totally get rid of tables alltogether and use css, but until then, designing a site to look exactly like you want will require complex table design. Take a look at msn or cnn's home page. I'll go out on a limb and say that hand coding either one of those site designs is impossible, and I can guarantee that neither of them were done by hand for sure. Half of the time I dont even save a design in UD though, I just do the design then paste the code into Studio and start refining it. After refining the design if I change my mind and need to change the table structure drastically, I'll just copy back into UD, click a button, then copy back. Unless you follow the Yahoo site design school of thought, a WYSIWYG editor is a necessity imho. jon - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:39 PM Subject: RE: DreamWeaver UltraDev 4 and CF Studio Thanks - That was kind of what I had come to the conclusion of, Worthless unless you totally use WYSIWYG I like to see what I am coding, so I guess I just stick with Studio. I guess I still don't see why they have the link to UD in Studio either, what purpose does that solve? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DreamWeaver UltraDev 4 and CF Studio
Jon, I personally don't agree that a WYSIWYG editor is a necessity for web development. Not at all. In fact, I think it is a crutch for many developers because they never learn a solid foundation and good HTML. Designing complex table layouts is easy if you've been practicing and know HTML like the back of your hand. I've never met a table that I could not make my bitch. I hand code almost everything, and consequently have a very intimidate (no jokes please) relationship with the resulting code. Brook At 07:05 PM 16/11/01 -0500, you wrote: I've used UD and Studio together since UD 1 came out and before that DW and Studio. Personally designing complex table structures from scratch by hand takes way too much time. That's what CF is all about, RAD... I've done some site designs in DW that would never have been possible by hand simply because of the time it would take to perfect a table structure that was extremly complex. Hopefully after all of the people still using NS4 upgrade, we can finally totally get rid of tables alltogether and use css, but until then, designing a site to look exactly like you want will require complex table design. Take a look at msn or cnn's home page. I'll go out on a limb and say that hand coding either one of those site designs is impossible, and I can guarantee that neither of them were done by hand for sure. Half of the time I dont even save a design in UD though, I just do the design then paste the code into Studio and start refining it. After refining the design if I change my mind and need to change the table structure drastically, I'll just copy back into UD, click a button, then copy back. Unless you follow the Yahoo site design school of thought, a WYSIWYG editor is a necessity imho. jon - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:39 PM Subject: RE: DreamWeaver UltraDev 4 and CF Studio Thanks - That was kind of what I had come to the conclusion of, Worthless unless you totally use WYSIWYG I like to see what I am coding, so I guess I just stick with Studio. I guess I still don't see why they have the link to UD in Studio either, what purpose does that solve? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DreamWeaver UltraDev 4 and CF Studio
I've used UD and Studio together since UD 1 came out and before that DW and Studio. Personally designing complex table structures from scratch by hand takes way too much time. That's what CF is all about, RAD... I've done some site designs in DW that would never have been possible by hand simply because of the time it would take to perfect a table structure that was extremly complex. But you don't need UD for this. You can do the same thing in DW2. In fact that's the only version of DW I use and its only around for the reason you mention. UD and DW are complimentary tools and I think the idea of UD replacing Studio borders on the ludicrous. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DreamWeaver UltraDev 4 and CF Studio
Don't get me wrong I am a hand coder too...when it makes sense (which is most of the time). I guess it comes down to design style. Not being an artist, I do my site designs in html, then bring in art elements later, after I'm totally sure I like the structure. Having no images to lead me, I tend to radically change the structure midway through a site. I can not justify hand changing 20 td's into one td with a rowspan of 20 by hand when I have UD close by. I can do it in 10 seconds in UD, it doesn't even need to be thought about. Doing that one task by hand would be a waste of time and money. I totally agree about WYSIWYG being a crutch to new developers also. Believe me, working at a hosting company I have to deal with the army of Frontpage dweebs (nicest word I could think of.. ;-)) everyday. Designing and developing are two different things though, and there is no such thing as a good designer who doesn't have some kind of visual tool in my book. It's just plain stubbornness to insist on hand coding everything. Everyone has a different style though, and required is a bit of a strong word, but if I have an entire site to do and nothing but an idea to start with. It just makes sense to start in a visual editor. jon - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 7:26 PM Subject: Re: DreamWeaver UltraDev 4 and CF Studio Jon, I personally don't agree that a WYSIWYG editor is a necessity for web development. Not at all. In fact, I think it is a crutch for many developers because they never learn a solid foundation and good HTML. Designing complex table layouts is easy if you've been practicing and know HTML like the back of your hand. I've never met a table that I could not make my bitch. I hand code almost everything, and consequently have a very intimidate (no jokes please) relationship with the resulting code. Brook At 07:05 PM 16/11/01 -0500, you wrote: I've used UD and Studio together since UD 1 came out and before that DW and Studio. Personally designing complex table structures from scratch by hand takes way too much time. That's what CF is all about, RAD... I've done some site designs in DW that would never have been possible by hand simply because of the time it would take to perfect a table structure that was extremly complex. Hopefully after all of the people still using NS4 upgrade, we can finally totally get rid of tables alltogether and use css, but until then, designing a site to look exactly like you want will require complex table design. Take a look at msn or cnn's home page. I'll go out on a limb and say that hand coding either one of those site designs is impossible, and I can guarantee that neither of them were done by hand for sure. Half of the time I dont even save a design in UD though, I just do the design then paste the code into Studio and start refining it. After refining the design if I change my mind and need to change the table structure drastically, I'll just copy back into UD, click a button, then copy back. Unless you follow the Yahoo site design school of thought, a WYSIWYG editor is a necessity imho. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fusebox - opinions?
OK, I think I'm on the verge of knuckling down and getting friendly with Fusebox for CF. Glancing through the PPT presentations, it seems pretty cool, and quite close to the systems I've developed anyway, only better organised :) A few questions for everyone out there who uses Fusebox: 1. Pros? Cons? Opinions? I've generally only seen good feedback, but I thought I'd see... 2. Is there any good documentation/literature? I think the PPT presentations should get me going, but I know I'll want something a little meatier. I was going to try out the book but it got so-so reader reviews on Amazon.com. Anyone think the book's worth it? Alternative deeper discussions of Fusebox anywhere? 3. I've not really used PHP or ASP. Does anyone know how the moves to have Fusebox work for these is going? Will knowing Fusebox in CF help me get going quicker with PHP/ASP if/when I delve into them (assuming Fusebox has been adapted for them)? 4. Some clients I have are still hosted with CF 4.0 - does this pose any problems for using Fusebox 3? All comments and feedback most welcome :) - Gyrus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Help converting Project 2000 file to 98
Is there anyone on this list that would please be able to convert a MS Project 2000 file to MS Project 98 for me? This is an urgent requirement. Thanks! Peter Tilbrook ([EMAIL PROTECTED]) Cubok Pty. Ltd. Units 7-10 Australian Heritage Village Watson ACT 2602 AUSTRALIA http://www.cubok.com Mobile: 0401 973 415 Tel: +61-2-6262-4080 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help converting Project 2000 file to 98
send it to me and I will save it as project 98 Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 10:17 PM Subject: OT: Help converting Project 2000 file to 98 Is there anyone on this list that would please be able to convert a MS Project 2000 file to MS Project 98 for me? This is an urgent requirement. Thanks! Peter Tilbrook ([EMAIL PROTECTED]) Cubok Pty. Ltd. Units 7-10 Australian Heritage Village Watson ACT 2602 AUSTRALIA http://www.cubok.com Mobile: 0401 973 415 Tel: +61-2-6262-4080 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DreamWeaver UltraDev 4 and CF Studio
I have been using DW since version 1, and before that I have been coding HTML by hand, and I still do (with Studio, which really could be considered a crutch since it helps you along the way with tag insight and all). Anyway, I have discovered UD, especially version 4 which I just bought to be very handy. Like the ASP developer and Interdev, Ultradev serves a good purpose. Although I can lay out tables by hand, what is the point when you have a good tool that pretty much does the work for you? And as far as layering goes, have fun doing it by hand as well. It can and is done, but I prefer to use UD for that. And the CF integration is great. I tried Netobjects Fusion and totally thought it was a waste of time and money (glad I did not buy it, some other poor schlep did and he just let me try it out). And as far as the link in Studio, I like it because I do not have to go to the task bar, click on UD, then browse to the folder that has the file I want to edit. Just click and it is there in seconds. As Ben Forta said some time ago in CFDJ, you have to pick the right web tool (CF, ASP, Java, PHP, etc... for the current project, so goes your editing tools. Use the right tool for the job. Why go to the icehouse to fill the icebox when you have electricity in your house and you can plug in a refrigerator. Why use Notepad just because it is free when there are great tools out there to use that can speed up development time? For just pure coding CF, studio is the way to go. For doing the more mundane stuff like page design, use UD or your preferred WYSIWYG tool (except for FrontPage). IMHO that is. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 4:39 PM To: CF-Talk Subject: RE: DreamWeaver UltraDev 4 and CF Studio Thanks - That was kind of what I had come to the conclusion of, Worthless unless you totally use WYSIWYG I like to see what I am coding, so I guess I just stick with Studio. I guess I still don't see why they have the link to UD in Studio either, what purpose does that solve? Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 4:25 PM To: CF-Talk Subject: Re: DreamWeaver UltraDev 4 and CF Studio Those capabilities don't exist. The code mode is really nothing more than Notepad with color coding. - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 4:23 PM Subject: DreamWeaver UltraDev 4 and CF Studio Question; Has anyone figured out how to do Tag completion in UltraDev4 like we can do in CF Studio? They want me to use UltraDev, but I truly am spoiled by the Tag Completion feature of Studio. Any direction on this would be greatly appreciated. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
traitorous question re VBScript
Hi can anyone help me with this rather traitorous question I'm putting a small search page in a friend's website (which is not cf-enabled, unfortunately) The search results code I want is (in coldfusion): cfquery name=get_titles datasource=gaslight_cf dbtype=ODBC SELECT tbl_category.category, shstock.BOOKNUM, shstock.TITLE, shstock.Author, shstock.PRICE, shstock.CategoryID FROM tbl_category INNER JOIN shstock ON tbl_category.category_id = shstock.CategoryID WHERE 0=0 CFLOOP INDEX=i FROM=1 TO=#ListLen(Title, ' ')# AND Title LIKE '%#ListGetAt(Title, i, )#%' /CFLOOP CFLOOP INDEX=i FROM=1 TO=#ListLen(Author, ' ')# AND Author LIKE '%#ListGetAt(Author, i, )#%' /CFLOOP CFIF Len(FORM.Category_id) AND shstock.CategoryID=#FORM.Category_id# /CFIF ORDER BY Title /CFQUERY Is anyone able to translate the middle bit to VBScript for me, please ie CFLOOP INDEX=i FROM=1 TO=#ListLen(Title, ' ')# AND Title LIKE '%#ListGetAt(Title, i, )#%' /CFLOOP CFLOOP INDEX=i FROM=1 TO=#ListLen(Author, ' ')# AND Author LIKE '%#ListGetAt(Author, i, )#%' /CFLOOP CFIF Len(FORM.Category_id) AND shstock.CategoryID=#FORM.Category_id# /CFIF MTIA Seamus ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access XP and CF?
I agree, if it ain't broke... However, I'm still using Office '97. And I have lots of memory and disk space, which I know XP is going to want buckets of, so I was thinking it might be time to upgrade. plus I won the software as a prize in a golf tournament, so it didn't cost me anything ;D Thanks to all for your advice. It was very helpful. Cheers, - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Alexis Maldonado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 7:44 AM Subject: Re: Access XP and CF? well i've been thinking.. is there anything new on access XP exept that security thing.. why would somone want to upgrade to office XP if there is nothing woth upgrading for the looks..? i did notice a small improvement from office 97 to 2000 but in XP i havent found any improvements but the look. Alexis.. - Original Message - From: Alexis Maldonado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 9:24 AM Subject: Re: Access XP and CF? darn.. i'll have to check on that network thing see if i can get it to work.. i hate having to mess with my win2k server and stuff everytime i install something new.. oh well.. - Original Message - From: Michael Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 8:35 AM Subject: RE: Access XP and CF? Alexis It works fine as well for me. Win XP Access XP Mike -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:10 AM To: CF-Talk Subject: RE: Access XP and CF? Alexis, I have no issues at all opening a DB on a networked drive. It works just fine. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion form within Onclick?
I think you're using the wrong language for what you have in mind, think JavaScript to temporarily set and manipulate the variables needed on the outside. When you're ready to submit you would encode all the variables into either a form or URL pass and set the variables up with ColdFusion appropriately. Email me if you need any more help. Gregory Harris [EMAIL PROTECTED] -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 12:46 PM To: CF-Talk Subject: Coldfusion form within Onclick? Im using ezedit. I want to from within the onclick of one of their function call on coldfusion to set some variables for me? Anyone out there done this... I cannot figure this out? Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists