Re: CF form in dreamweaver
It's something I use frequently. I don't have the time to figure out how to re-write dreamweaver and shouldn't have to. I think it's a big hole in the product. Chris Kief [EMAIL PROTECTED] wrote in message 001001c211b1$f7d61040$9e01a8c0@RISE5">news:001001c211b1$f7d61040$9e01a8c0@RISE5... After reading some of the DWMX docs, it doesn't appear that this toolbar is offered. Maybe someone out there can write an extension to add it?? No, it's not there, but you can customize it pretty easily, just edit: Dreamweaver MX\Configuration\Objects\insertbar.xml I don't plan to do an extension right now because I don't use cfform, sorry Massimo __ 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: CF form in dreamweaver
No replies to this... I can't imagine I am the only one to go from CF Studio to DWMX and have this problem. Nobody else has the problem or nobody knows the solution? anyone? When editing a cfm file in DWMX I have the tool groups of CFML Basic, CFML Flow, CFML Advanced and Application. How can I get the CF Form tool group as it exists in Cold Fusion Studio? TIA. Chris Giminez __ 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
CF form in dreamweaver
When editing a cfm file in DWMX I have the tool groups of CFML Basic, CFML Flow, CFML Advanced and Application. How can I get the CF Form tool group as it exists in Cold Fusion Studio? TIA. Chris Giminez __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: extracting data from a huge text file
the format of the text file is not very consistent. It's a comma delimited list, but the last field is itself a comma delimited list and fields 8 and 9 contain one double quote instead of a pair like every other field. It's very strange and I can't get the writers of this text file to explain their logic or change it so far. I don't think an automated solution will work for these reason, so I am parsing each line piece by piece and saving as individual variables. Another option.. Why not open it as an ODBC data source, and let the ODBC drivers worry about the size of the file? We recently did something like this with VB for a text file, only a few lines/records though. But it should still work well with larger files. -Original Message- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:56 PM To: CF-Talk Subject: Re: extracting data from a huge text file It's called CFX_ReadLine and with an initial test, it looks like it's going to do the trick. thanks very much!! Chris I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: CFSchedule
Nothing too difficult about CF schedule, just point it to a page that runs normally. I see your url is under /admin. If you have security built in to application.cfm of that directory, you won't be able to get in with your scheduled tag as far as I know. I had to do something like this with cfschedule, so I made another directory under admin, call it schedule and only would run the template with a password in the url variable, so your scheduled tag url might look like this. http://www.mydomain.com/admin/email/scheduler/test_email_process.cfm?accesscode=OIEiorJD833Ksjd Nothing is output in the template, so great security is not really necessary. Just run your report output within cfmail tags. Also keep in mind it won't work in https mode. Chris Any good tutorials on this subject - all I've seen in numerous books is examples of running reports at determined intervals. What I want to do is run a template which contains a query and then outputs the results to CFMAIL. Can I do this using CFSchedule, or is there a better way? Here's what I have now, and it won't work (I'm on a shared server with no access to the CF Admin functions): Any assistance or suggestions is/are appreciated. Thanks, Mark - !---Scheduler Template--- CFSCHEDULE ACTION=UPDATE TASK=TestMessage OPERATION=HTTPRequest URL=http://www.mydomain.com/admin/email/scheduler/test_email_process.cfm; STARTDATE=01/24/02 STARTTIME=06:45:00 INTERVAL=DAILY RESOLVEURL=No PUBLISH=No /cfschedule !---Query/Email Sendout Template--- CFQUERY NAME=q_sub DATASOURCE=uspc SELECT * FROM t_email, t_msg, t_sig, t_subcat, t_unsub_msg WHERE t_email.subcat_h = t_msg.t_subcat_ID AND t_msg.t_subcat_ID = t_subcat.sc_id AND t_msg.dateofsend = DateValue(Now()) /CFQUERY CFIF q_sub.recordcount IS 0cfabort/cfif !--- Send out mail to the specified group--- CFMAIL QUERY=q_sub GROUP = email GROUPCASESENSITIVE=No STARTROW=1 TO=#firstname# #lastname# #email# FROM=John Doe [EMAIL PROTECTED] SUBJECT=#msg_subject# CC=#copy_to# BCC=#blind_copy_to# SERVER=127.0.0.1 cfmailparam name=Reply-To value=John Doe [EMAIL PROTECTED] cfif q_sub.vit_ID NEQ 0#trim(thought)# --#trim(author)##crlf##crlf#/cfif cfif q_sub.txtmessage IS NOT #Trim(txtmessage)##crlf##crlf#/cfif cfif unsublink IS Yes#trim(unsub_msg)##crlf##crlf#/cfif cfif msg_sig IS Yes#trim(sig_line)#/cfif /CFMAIL !---Send a confirming Email to Mydomain.com indicating that the messages have been delivered.--- !---Do not suppress whitespace in the email message--- CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=No CFMAIL TO=John Doe [EMAIL PROTECTED] FROM=John Doe [EMAIL PROTECTED] SUBJECT=Email Message Center Delivery Success SERVER=127.0.0.1 As of #LSDateFormat(Now(), dd, )# #LSTimeformat(Now(), hh:mm:ss)#, #q_sub.recordcount# subscribers have been provided a #q_sub.sub_category# message via automated email. END OF MESSAGE /CFMAIL /CFPROCESSINGDIRECTIVE cfabort __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: extracting data from a huge text file
It does look ideal. Unfortunately, I'm not sure how to plug in and compile the Java code and don't know that I can take the time to learn just now. Anyone have the class files for this that can be plugged in ready to roll? Chris This should be IDEAL for you. http://www.macromedia.com/v1/handlers/index.cfm?ID=22277method=full DRE -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:10 PM To: CF-Talk Subject: Re: extracting data from a huge text file How does it accomplish this when you want to loop over the contents of a large file? Does it keep the file open, or when you call it to read the 250,000th line, has it opened and closed and read through the file 249,999 times already? Jim - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:54 PM Subject: Re: extracting data from a huge text file On Thu, 24 Jan 2002 16:09:54 -0800, Chris Giminez [EMAIL PROTECTED] wrote: I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
extracting data from a huge text file
I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? I tried using cfhttp and that didn't work. I think the format of the data is not suitable for that. Below is a sample of two records. miamimls,FL,M805531,1003958,MAJESTIC PROPERTIES INC,3055341999,M,,,A,459000,,FLMiami Beach,Y22391,33139,,42,DADE,12025,,THE SUNDANCE,0,1612,2,2,2,,,THE SUNDANCE,00-42-00-000-0006,0,0,0,,0,, ,T16 miamimls,FL,F425895,620406,P C REALTY,9545818853,M,,,A,36000,,FLSunri se,Y23056,33322,,3850,BROWARD,12011,,SUNRISE LAKES,80,,2,2,2,,,SUNRISE LAKES 60 CONDO UNIT 302,494129AA0260,666,1,29,C05, E05,J02,J07,M01,M05,N02,N13,Q08,T11,U01,W30,X35 any suggestions would be very much appreciated. Chris __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: extracting data from a huge text file
It's called CFX_ReadLine and with an initial test, it looks like it's going to do the trick. thanks very much!! Chris I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
convert .tif to .pdf
Can anyone recommend a custom tag that can open a .tif file (that's the primary need, but ideally it could also open .doc and .xls) and then convert to .pdf on the fly? I have heard of activepdf, but cannot get any info from their web site at the moment. will this work? Thanks, Chris ~~ 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
Sandbox security consultation
So far I have been unable to completely understand how to implement Sandbox Security. I need to set this up for a server that will be used in a hosting environment. I have read the Forta books and the product documentation. If anyone knows of a step by step tutorial I may not be aware of, please let me know or if you can provide an hour or two of consultation, please let me know your rates. Chris Giminez 805-239-2375 ~~ 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: Upfrade CF4.5 Pro to 5 Ent
Check your log files. We had one CF log file that was about 200MB and the installation tried to read it into memory. It used up all the RAM and hung. After clearing the log files, (I cleared em all to be safe.) the installation went fine. All apps worked without modification. Obviously be sure to select the migration option when you begin the install to import your existing ODBC datasources, Verity collections, custom tags and all other custom settings. Chris We're going to be upgrading a server from CF 4.5 Profesional to CF5 Enterprise. Does anyone have a list of things I should look out for? The server is as follows: WIN2K 1GB RAM/SCSI HDs O'Reilly WebSite Pro 2.x I just want to avoid breaking any applications that are working now :-) Thanks, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon ~~ 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: cfgraph dateformat
Is there any way to use the dateformat function within cfgraph? My items are dates which display as an ugly odbc date with the time included. Trying to add a dateformat throws an error. What am I missing? I tried with and without #'s and with and without double and single ' can't find any combination that will work. This code works fine: cfgraph type=BAR query=logonsbydate valuecolumn=logoncount itemcolumn=date_in barspacing=20 url=logons.cfm?showdate= urlcolumn=date_in /cfgraph This code will not: cfgraph type=BAR query=logonsbydate valuecolumn=logoncount itemcolumn=date_in barspacing=20 url=logons.cfm?showdate= urlcolumn=dateformat(date_in,'m/d/yy') /cfgraph The error is very non descript Error Occurred While Processing Request Error Diagnostic Information CFGRAPH The error occurred while processing an element with a general identifier of (CFGRAPH), occupying document position (34:1) to (40:52) in the template file C:\MY DOCUMENTS\CHRIS DATA\WEBSITES\PEOPLE IN MAMMOTH PRODUCTIONS\ADMIN\LOGONS.CFM. Date/Time: 08/24/01 19:08:16 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 127.0.0.1 ~~ 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
cfgraph dateformat
My items are dates which display as an ugly odbc date with the time included. Trying to add a dateformat throws an error. What am I missing? I tried with and without #'s and with and without double and single ' can't find any combination that will work. This code works fine: cfgraph type=BAR query=logonsbydate valuecolumn=logoncount itemcolumn=date_in barspacing=20 url=logons.cfm?showdate= urlcolumn=date_in /cfgraph This code will not: cfgraph type=BAR query=logonsbydate valuecolumn=logoncount itemcolumn=date_in barspacing=20 url=logons.cfm?showdate= urlcolumn=dateformat(date_in,'m/d/yy') /cfgraph The error is very non descript Error Occurred While Processing Request Error Diagnostic Information CFGRAPH The error occurred while processing an element with a general identifier of (CFGRAPH), occupying document position (34:1) to (40:52) in the template file C:\MY DOCUMENTS\CHRIS DATA\WEBSITES\PEOPLE IN MAMMOTH PRODUCTIONS\ADMIN\LOGONS.CFM. Date/Time: 08/24/01 19:08:16 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 127.0.0.1 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sharing a structure with the calling template
What's the best way to share a structure that is created in a custom tag with the calling template. Apparently it's not permitted to use cfset caller.mystructure = #mystructure# Thanks, Chris ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
single user version of 5.0
I need the single user version of 5.0 for development. I could not find this at allaire or macr. I called macr and was told by a CSR that the evaluation version will work as a single user version after 30 days. This was after she first told me a single user version did not exist. can someone confirm that it does continue to work as a single user version and if not how i can upgrade my 4.5 single user version to 5.0? I need to be able to develop with these nifty new feature without testing on the live server. the macromedia rep really didn't seem to grasp this concept. Thanks, Chris Giminez Cyber Scriber ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is CF still relevant?
I have only dabbled in other programming languages, but from what I can see, CF does most everything the others do, but does it easier. The high cost keeps it from being as popular as ASP and others. I know lots of developers who are spending lots of time learning PHP since the Enterprise version of CF is just too expensive to put on the server. There is just not enough demand for a higher priced account. Too bad Allaire/Macr... There are a lot of potential clients out there if it were just more affordable. Chris Giminez Cyber Scriber I probably should not join this particular thread because I will probably be seen as very biased BUT. But I am a relative newbie as an employee of Allaire now Macromedia. My experience with using ColdFusion and briefly trying ASP is more relevant since I have used ColdFusion since late 1995-96. In reality ColdFusion should have died long ago as it has an appreciable up front cost. But it did not die in the face of alternatives that have no up front costs. In fact rather than ceasing to exist it grew exponentially in use. Also, the ColdFusion community has never seemed small to me as I struggled with and was presented with solutions to challenging issues, time and time again. Now, we have the honeymoon and final marriage of Allaire and Macromedia. I do not know what will eventually come out of this but I do know it will be fed and nurtured with ideas from all the worldwide developers and users of both former Macromedia and Allaire products and I do know that we are only limited by our own imaginations. My personal opinion is that now would definitely be the wrong time to move away from ColdFusion for anyone with a desire to be involved in the future of the Internet and the Web. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.macromedia.com -Original Message- From: Joseph Grossberg [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 12:28 PM To: CF-Talk Subject: Is CF still relevant? Now, before you dismiss this as a troll, please let me elaborate. This isn't so much an instigation or a whine as it is a call for us to take a step back and reevalutate things periodically. Over the course of my career as a web programmer/developer, I have worked with a variety of sever-side languages and technologies: ColdFusion, ASP, JSP, PHP, Perl and Python. I like some more than others, but I'm not an evangelist for any; they each have their uses. And I recognize some of CF's strengths: easy to learn for people who know only tag-based HTML or don't have significant programming experience; built-in admin tool; specialized editor; comes with pre-built tags and web-based administrator. There are also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively small community; etc. Right now, I work at a web development firm that is primarily "a CF house" (besides me). Our more senior programmers are looking at honing their CF skills, while our less experienced webmasters are trying to learn ColdFusion. But, I can't help but wonder whether they are wasting their time. Would they be better off spending their time learning ASP, Java or another non-CF solution? Why or why not? And how would we tell if and when it was time to give up CF and try something else, as all but the most stubborn experts in also-ran languages (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems (Amiga) have resignedly done? Lastly, why do *you* still use CF? Is it because it's what you're best at, and you don't want to try something new (where, temporarily, you'd be a novice again)? Is it because your ccompany's legacy code is all in CF? Is it because you genuinely think that ColdFusion is, generally speaking, the best solution for web application development in 2001? Joe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfschedule behind protected directory
I am using cf security to protect a directory. If the user is not logged in (with a correctly defined session variable) they are redirected to a login page in a different directory. I would like to run cfschedule for a page that is located in the protected directory. It cannot access it due to the redirection. How can I get this to run under cfschedule without removing it from this protected directory or changing the method of security? Best Regards, Chris Giminez Owner - Cyber Scriber Toll Free: 866-CYBER-SC (292-3772) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Verity Errors
Just encountered the same error. Same scenario. I have done nothing with it lately and it is hosted on a shared server. Have you found the solution? Error Diagnostic Information Error occurred in tag CFINDEX Internal Error: VDKSessionNew failed Error Code: -125 -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Does anybody know what might cause the following errors? My templates were running just fine and I haven't changed a single line of code on them. The site is in a shared hosting environment so I suspect that something has been done by someone else to cause these errors but what!?? Can anyone kindly suggest what might be going on? Error info: Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -125 Error occurred in tag CFINDEX Collection failed to open: urlguide CF/Server info: COLD FUSION: Product Version: 4, 5, 1, 0 Product Level: Enterprise SERVER/OS Server OS Name: Windows NT Server OS Version: 4.0 Server OS Additional Info: Service Pack 6 Server Software: Microsoft-IIS/4.0 Thanks if anyone can help. Sue McNab --- email: [EMAIL PROTECTED] url: http://www.smcnab.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How to set a future date?
Use the dateadd function cfset tomorrow = dateadd("d",1,now()) Tomorrow is #tomorrow# Add or subtract any date or time with the same fuction and differing parameters. -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 a table? I am familiar with the function now(). Is there a way of getting 1year, 1 month , 1 day, 1 hr, 1 min, 1 sec from now and filling it in in a column of a table? Appreciate. A.B. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problem comparing now date with access97 date
Have you tried using the datecompare or datediff functions? I don't think you need to change the format of now() to get what you need. Are you trying to see if the date is before, after or the same as now()? If so, use datecompare. cfset result = datecompare("2000-11-04 00:00:00", now() , "d") -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 2000-11-04 00:00:00 and I want to compare it against now() in the format: {ts '2000-07-05 00:00:00'} I'm fairly new to cold fusion and I'd like to hear any easy suggestions of changing now() into the first format.. {ts '2000-07-05 00:00:00'} to just 2000-07-05 00:00:00 I've tried the DateFormat function but that doesn't give you the hours:min:sec part... and I tried to add a second to it with the DateAdd function to give me the time part of it back.. and it converts the whole thing back to {ts '2000-07-05 00:00:01'} Help!... Thanks in advance! Lee -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
limiting upload file size
I am permitting a user to upload their resume as an option when inquiring for employment. This file should never exceed 1Mb and will usually be much less. I'm using cffile to write the file to the server, then attaching it with cfmail to go to my client. How can I detect the size of the file prior to upload to prevent someone from maliciously uploading a 100MB file (or worse!). I know I can see it with #file.filesize# but this is only after the upload, right? I want to not upload at all if the file is bigger than 1MB. How can this be done? Thanks! -- Chris Giminez -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
controlling print page break
I'm missing something in the way to control a page break within a cfoutput block. I have P, TABLE { page-break-after: auto; in the style block in the head Then... cfoutput query="project_list" p table width="600" align="center" . bunch of tr's and td's (never more than a 3rd of a page) /table /p /cfoutput I want to be sure the content of a single table will not break when printed, but this is not working. As it is now, it's breaking whenever the page ends. I have tried it with and without just the table being in the style block. Nothing I have tried works. Anyone know why this isn't working? Thanks a bunch! -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: controlling print page break
Just tried table width="600" align="center" style="page-break-inside: never" That seems to have no affect. -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 I have P, TABLE { page-break-after: auto; in the style block in the head Then... cfoutput query="project_list" p table width="600" align="center" . bunch of tr's and td's (never more than a 3rd of a page) /table /p /cfoutput I want to be sure the content of a single table will not break when printed, but this is not working. As it is now, it's breaking whenever the page ends. I have tried it with and without just the table being in the style block. Nothing I have tried works. Anyone know why this isn't working? Thanks a bunch! -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Error Msg
I run a little program that shows my system resources available at all times. If I have IE, CF, Photoshop, Outlook and one or two others open at once (not to mention all of the "start up programs"), I may drop as low as 5%. At that point, I will commonly get the same error. Rarely do I get it if resources are over 20%. You can avoid the error by not getting too low on system resources. If you do, close other programs before going back to Studio -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Every once in a while, I get a message box that pops up in studio 4.5.1 saying "Canvas does not allow". I hit OK but it just keeps coming up. I have to cycle studio to work again. It seems to happen most when I come back to studio after looking at my page in the browser (IE). Anyone else getting this? Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
combining order by and cf group attribute
I'm joining a few tables and grouping them by their "package". It works great until I try to add an ORDER BY price statement to the sql. When I do that, it creates several groups. The pricing order takes precedence over the grouping done in CF. How can I order by price and stay within the groups? thanks! __ CFQUERY NAME="bid_package_results" DATASOURCE="scbuild" SELECT contractors.company_name as company, contractors.city, bid_results.price, bid_results.project_id, bid_packages.label as package FROM bid_packages, contractors, bid_results WHERE bid_packages.package_id = bid_results.package_id AND contractors.contractor_id = bid_results.bid_id AND (bid_results.project_id = #form.project_result#) /CFQUERY cfoutput query="bid_package_results" group="package" trth align="left"#package#/th/tr cfoutput trtd#company#/tdtd#city#/tdtd#price#/td/tr /cfoutput /cfoutput -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
modifying variable names in a loop
I have a form that may have just one or up to 20 or so sets of data. The form fields will be passed, but could be blank for all but one set up data. It's being passed as something like form.name1 form.address1 form.city1 form.state1 form.name2 form.address2 form.city2 form.state2 ... so on. On the action page, I want to loop over an insert query and only execute the query if the set of data is not "" so I need to do a cfif name1 is not "" run the querycfelsedon't run the query/cfif How do I run the count in the cfif statement since name#loopcount# won't work within a cfif statement? Then if I do the insert, how can I get the value of the variable for the query. It has to be dynamically generated from the loop Obviously this is not going to work, but I think it illustrates what I am trying to do. CFQUERY NAME="name" DATASOURCE="name" INSERT INTO tablename ( name, city, ... ) VALUES ( #name#loopcount##, #city#loopcount##, ) /CFQUERY Thanks! -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: The query below will return a match without regard to the case
I figured it out using the compare function after getting a valid username and password from the db. This will check a username and password for case sensitivity. CFIF (login.recordcount eq 0) or (compare(form.password, login.password) neq 0) or (compare(form.username, login.username) neq 0) ...bad password. try again. -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 I'm using Access. Any ideas with that or would I need to use the solution you provided below with nested loops? There may be something for this in Access, but I don't know enough about Access to tell you. Are all password protected sites done with Cold Fusion non-case sensitive, or is a lot of special processing done when Access is the db? I suspect that most sites don't use case-sensitive passwords. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Using CF output only
Only cfoutput would be displayed. It it were enabled the code of Some text cfoutput more text here with some variables perhaps/cfoutput ending text would result in a browser display of more text here with some variables perhaps Anything not in a cfoutput would not be sent to the browser. -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 In some of the Coldfusion tutorials I have this tag seems to be used extensively Can anyonme explain what it does? cfsetting enablecfoutputonly="Yes" Cheers Alex -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: The query below will return a match without regard to the case
I'm using Access. Any ideas with that or would I need to use the solution you provided below with nested loops? Are all password protected sites done with Cold Fusion non-case sensitive, or is a lot of special processing done when Access is the db? -- Chris Giminez "password" in the database returns a record when matched with "PASSWORD" or "PaSSwORd" when I want it to return a record with "password" exactly. How can I force a case sensative query? CFQUERY NAME="login" DATASOURCE="datasourse" SELECT Count(*) AS loggedin FROM admin_pass WHERE username = '#trim(FORM.username)#' AND password = '#trim(FORM.password)#' /CFQUERY I can tell you how this works in SQL Server; when you install SQL Server, it asks you what sort order to use. You can then pick case-sensitive or -insensitive. If you want to change later, you have to reinstall SQL Server and rebuild all your databases. The default is case-insensitive. So, if you had a default SQL Server install, you'd have to do a lot of work with string functions to make this happen. For example, within your SQL you could retrieve all the records that have a simple string match, then loop over each returned record, and within that loop have a nested loop that examines each string character-by-character. Alternatively, you could do that within CF. . -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newsgroups?
Thank, in it now. Much better. Too bad there's still the beg delays in posting. A post of mine took close to a week. -- Chris Giminez There is one already. news.fuseware.com Regards, -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Checking case sensativity for a log in
I found my own answer for anyone who is interested on verifying the case of a password. Run the query to get a non-case sensitive match. Then run CFIF (login.recordcount eq 0) or (compare(form.password, login.password) neq 0) or (compare(form.username, login.username) neq 0) Invalid password - back to the login screen /cfif -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newsgroups still working
Really good to know. It's much easier to read through threads from the newsgroup anyway. I wish everyone would migrate over, especially now. -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 For those of you who are still reading the cf-talk newsgroup, after cf-talk mailing list has gone down, I wanted to mention that the newsgroup is still working. It doesn't get nearly as much pure traffic as cf-talk, but there are those of us who read and use it. Chris Evans [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
duplicate values in query supplying verity search.
I need to run a query to provide data for a verity search. I need to use a few tables so information can be provided in the body of the verity collection to make it searchable. Here's my query. CFQUERY NAME="contractor_query" DATASOURCE="scbuild" SELECTDISTINCT contractors.company_name, contractors.*, license_types.*, lic_tie.* FROM contractors, license_types, lic_tie WHERE contractors.contractor_id = lic_tie.cont_id AND lic_tie.lic_id = license_types.id ORDER BY contractors.company_name DESC /CFQUERY Most contractors have just one license type, and it works just fine. The problem I am having is that when a contractor has more than one license type, duplicates are returned. Distinct isn't working and I think it would be problem if it did since only one license description (with keywords I need searchable by verity) would show up. This is an Access database. If it weren't for the need to provide this to Verity, I could split this into separate queries just for display purposes. If I can't fix this query, can I eliminate duplicates in Verity somehow or in the results of a search using CF? -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: date function
Use the dateformat function #dateformat(date," d ")# Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 I have a source that is outputting dates in this format: 26-May-2000 10:55:16 -0500 It doesn't seem that any of CF's date functions want to touch it. I was = wanting to decrease the amount of overhead on the server by not messing = with the trim and replace functions, especially seeing that this is = going to be a very repetitive function. Does anyone have any = suggestions or am I doing something wrong? I would like an output of = May 26 2000. I guess I could trim after the first whitespace and then = do formatting from there, but if anyone has a better suggestion I would = appreciate it. Adam Cantrell -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
case sensativity in a query
The query below will return a match without regard to the case "password" in the database returns a record when matched with "PASSWORD" or "PaSSwORd" when I want it to return a record with "password" exactly. How can I force a case sensative query? CFQUERY NAME="login" DATASOURCE="datasourse" SELECT Count(*) AS loggedin FROM admin_pass WHERE username = '#trim(FORM.username)#' AND password = '#trim(FORM.password)#' /CFQUERY Thanks, Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
The query below will return a match without regard to the case
This is my third attempt to post this question. Hopefully it will show up this time. ** The query below will return a match without regard to the case "password" in the database returns a record when matched with "PASSWORD" or "PaSSwORd" when I want it to return a record with "password" exactly. How can I force a case sensative query? CFQUERY NAME="login" DATASOURCE="datasourse" SELECT Count(*) AS loggedin FROM admin_pass WHERE username = '#trim(FORM.username)#' AND password = '#trim(FORM.password)#' /CFQUERY Thanks, Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newsgroups?
Please, someone start a CF newsgroup. (anyone know how that's done?) It would much easier to sift through messages than this list. I love the info I can get on this list, but the reliability lately is terrible. I posted a message a few days ago never saw it. Who knows if this will make it or if it will post several times over the next week Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Newsgroups? As in, 'why aren't there any ColdFusion...'? There could be a whole Allaire group in the comp.* heirarchy... comp.lang.ColdFusion.server.linux comp.lang.ColdFusion.server.windows comp.lang.ColdFusion.studio.linux comp.lang.ColdFusion.studio.windows (etc.) ...I'd personally prefer to start 'em in the alt.* heirarchy, but let's not go there... ...Anyway, I was just wondering if this was something that someone had tried that Allaire smacked down, or if there's really so few people that access Usenet anymore that no one bothered... Brandon Whitaker [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help With CFMAIL using 4.5.1
Someone just posted this a couple of days ago. It fixed this very problem for me. http://www.allaire.com/Handlers/index.cfm?ID=15821Method=Full Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 I am trying to run a mail script that has worked in 4.0.1 When I try to run it in 4.5.1 I get the following error unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:97). Any ideas how I can get this to work? TIA DDINC -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Forms
Move the form tags outside of the td tags. HTML TABLE WIDTH="100%" bgcolor="#CC" FORMTD INPUT type="text" value="Search"/TD/FORM/TABLE /HTML Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Sorry, but that didn't solve it. This is what I do. I wrote this code quickly under Notepad and sent it to the list: HTML TABLE WIDTH="100%" bgcolor="#CC" TD FORMINPUT type="text" value="Search"/FORM/TD/TABLE /HTML When you're going to view this code in your browser, you'll see a blank line under the textbox. So, the question is: Where am I wrong, what's wrong with this code? Please help, I am sure the solution is quite simple, but I haven't found it, yet! Thanks. - Original Message - From: "Smad" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 21, 2000 5:45 PM Subject: Forms I have a pretty weird problem. I usualy use Dreamweaver for designing the site's layout, sometimes I handcode. Anyway, whenever I insert a FORM tag and all the inputs inside, the tag appears between two white lines, or leaves at the bottom a big space. How do I get rid of that space? What am I doing wrong? Thanx in advance. Smad -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Search Engines
Web Position Gold does this and a lot more. http://searchengineboost.com/webpositiongold/index.htm Chris Giminez Ok.. remedial question, but one that I can seem to find a good answer to. We do a lot of web hosting and we provide a service to our customers where we register domain names for them and then list them with search engines. I have yet to find a good program to use to mass register with search engines. I want one that will be totally self-acting (all I have to do is enter info once, and it does all the registering just by pushing a button and walking away). I don't mind paying for this, but want feedback from anyone who has used one and likes it. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: You have nice cookies .. mind if I have a look?
Are you serious?!? They absolutely need to be told/warned. Is this a small town bank or a national? Chris Giminez Hello ALL. all this talk of cookies got me to go poke arund through my own. Not sure if i should really care or not. but my bank has my ATM/Visa Number plain as day in one of its cookies on my box. should i bring it to theire attention? Should i just disable cookies for that site? i know that they use CF for most there stuff. but the files always display as htm. Thanks -paul -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: You have nice cookies .. mind if I have a look?
Just d/l the update for IE. It seems to have effectively sealed the security hole. Chris Giminez -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: You have nice cookies .. mind if I have a look?
But what good is an encrypted cookie? If I have a cookie on my machine that automatically logs me in to Amazon's one click, for example, encryption is irrelevant if some hacker steals it and installs it as their own. Next time they go to Amazon, they're me; encryption or not. What's scary about this is that you can only get your cookies "grabbed" by visiting a site that is trying to grab it, right? Well, what about an html email being read? Same thing as visiting a site, right? I would imagine a cookie grabbing script could be embedded in a typical html spam just as easily. Chris Giminez In the page submitted by Todd: "The NY Times said it has rewritten its cookies code with stronger encryption..." Certainly no one on this list would steal anyone's cookies grin, but I didn't hear anyone mention the possibility of encrypting one's own cookies to protect their contents. This is possible, isn't it? --John Allred Todd Ashworth wrote: Might want to be extra carefull what you store in your cookies from now on, ladies and gents. Or .. if you are the naughty kind of CF developer, I suppose you could take advantage of this ... http://www.cnnfn.com/2000/05/16/technology/microsoft_browser/ .Todd -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- John Allred / Jackson, Mississippi Webmaster, Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Getting only records with a date
I'm failing to write a query that will get all records from a table when they have a date entered into a particular field. I want to exclude Null values. This doesn't work. Still getting all the NULL records. What does work? CFQUERY NAME="dbname" DATASOURCE="dbsource" SELECT MyDate FROM Table WHERE (MyDate NULL) /CFQUERY Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Member database with access levels -=- CF4.0.1+Access97
Have a one folder for login. Enable session variables in the application.cfm file Have another folder for protected templates. Again, enable session variables in the application.cfm file. When the user successfully logs in, set a session variable to their access level. Now, in the protected folder - application.cfm, check for the existence of the session.accesslevel variable. If it doesn't exist, cflocation back to the login page If it does exist, process the users queries or location based on their level of access. If they try to change url variables without the correct session variable set, you can reject their request. If they try to go straight into a protected area without login in first, they'll be redirected to the login page. Chris Hi, I'm 18 years old and have been working with CF for a few months now. I have read books, articles, etc and have learned enough on my own to use CF with Access 97 to make simple DB's -- adding, updating, deleting records, setting variables, using CFMail, etc. You know, the easy stuff. I think it's really cool, I love ColdFusion! My next project is to create a database of members with access levels. I have fields like: MemberName Password MemberSince AccessLevel I'm trying to figure out how to use session variables and cookies and stuff to log a user into a section of a website that will display certain options (links basically) depending on their access level (levels are like 1 to 5). However, the only part I have done is checking their username and password against the database and sending them to a page once they have successfully logged in. The thing is, how do you make it so someone cant just copy the URL they were sent to when they logged in and paste in a browser window and have it pop up? Cookies right? What I am looking for is someone to point me in the direction or to a resource that could explain how some of this works (coding wise).. any suggestions.. anything will help. Thanks!! :) *~Tiffany~* -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: DayofWeek()
Use cfoutput#dateformat(now(),"")#/cfoutput Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 I am apparently having problems with the Dayofweek function. According to the language reference manual, it returns the ordinal of the week, as an integer, ranging from 1 (Sunday) to 7 (Saturday). By my calculations, Friday should return 6. Today I am doing some testing and I am getting 4 back from this function call: dayofweek(now()). Am I losing my mind, or is there an error in the documentation? I have tried this on 2 CF servers with the same result. Dave -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: low-end web hosting services?
I can refer you to a reseller program if you can deal with a Unix host. It runs about $120/year for resellers and support is outstanding. Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 My contract is about to come up for renewal at my current host (ICOM). It's just basic service (no CF or ASP or anything like that) to handle static webpages for my wife's business. For $100/yr it's a good deal, but their tech support is pretty lame. Has anyone had any experience with other low-end hosting services? This service gives me 40mb of disk, 1 POP3 address plus unlimited email forwarding. tia, -reed -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
remove frames option
I have a page with two frames. I want to put a "remove frames" link on one so the user can have a bit more screen real estate if they want to. This is no problem. I just create a link to itself with a target="top" attribute. But, once it's out of frames, how can I detect this and not have the "remove frames" link appear on the page? Thanks, Chris Giminez -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Slightly OT: Lighten things up a little
Hey everyone, for a simple new idea for my homepage, I wanted to start a "you know you're a ColdFusion programmer when..." your wife asks you to call all the kids to dinner and you shout, "Dinner time *!" Chris Giminez 1) You know you're a ColdFusion programmer when you press the # key twice on your phone to "close the variable". I know that sounds lame, but I need some people with some good humor to start this page. Feel free to submit to me your ideas, they will go up on my page with your name and optionally your email when it is complete. Thanks! Gregory Harris (tekiegreg) [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
replacing characters
How can I change a value of a variable with this format 12/345,678 to this format 12-345678 I need to replace the / with a - and remove the comma. Thanks, Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
custom tag - security based on user
I need to set up security so that a user enter's their user name and password (from a db table) then that user name is used in all queries so they only can see their own data from the database. Anyone know of a custom tag for this that's already done? I didn't see anything in the Allaire tag gallery and the custom tags link at forta.com has been broken for quite some time. Thanks, Chris Giminez -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
dropdown navigation and Netscrape 6
I know this is not CF related, but it was discussed on this list a short time ago. There was some discussion of using dhtml navigation (drop down menus) like microsoft (and millions of other sites) uses. Shortly after spending a couple of hours implementing one of them (and loving it) I downloaded Netscape 6 and found it did not work at all. Netscape 4-4.7 had no problems. I was hoping it was a bug since it's a preview release, but it appears not to be. See http://www.netmechanic.com/news/vol3/javascript_no4.htm I don't know enough about dhtml and what WILL be supported to know if this type of navigation can be done in any way or if designers will be forced to load an applet to accomplish this navigation style. Standards Schmandards Netscape. At least make it backwards compatible. Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
tying two tables
Sorry if this is a lame question. I'm not very strong in SQL yet and am having a brain freeze on how to do this. I have table A where I pull one record. In this one record are name ID's that correspond to table B where the name ID's are associated with full name, email, phone, etc. How do I post information of each name id from table A as the full name, email, phone, etc from table B I will display something like this cfoutput #tablea.data1# #tablea.data2# #tablea.data3# #tablea.data4# #tablea.data_name_id1# (but here is where I don't want the Id, I want the info from table B) #tablea.data_name_id2# (same goes here) /cfoutput thanks Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: tying two tables
thanks for the reply, but that's not what I am trying to do. The only way I can think to accomplish this is to use multiple - separate queries. If someone can show me how to improve this, I'd appreciate it. Let me give you an example: Say I run a query for a real estate listing (this isn't what I'm doing, but it correlates well) CFQUERY NAME="property_detail" DATASOURCE="properties" SELECT * FROM Listing WHERE (Listing.Id = '#url.id#') /CFQUERY Now, lets say this returns the address, city, zip, price, etc along with 5 ID's of agents that have shown this particular property. The format would be the agent's initials. Now I want to display the agent's full name and email on the same page. The table containing this might be something like: Agent_IdNameLNameEmail CSG ChrisGiminez[EMAIL PROTECTED] ...and so on I am accomplishing this by setting up additional queries for each "agent" CFQUERY NAME="agent_name_1" DATASOURCE="properties" SELECT Agent_Id, Name, LName, Email FROM Agents WHERE (Agent_ID= '#property_detail.Agent_Id_1#') /CFQUERY Then I run another query for each Agent_Id needed. I'm sure there's a better way, but I don't know what. Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 On 4/30/00, Chris Giminez penned: Sorry if this is a lame question. I'm not very strong in SQL yet and am having a brain freeze on how to do this. I have table A where I pull one record. In this one record are name ID's that correspond to table B where the name ID's are associated with full name, email, phone, etc. How do I post information of each name id from table A as the full name, email, phone, etc from table B CFQUERY DATASOURCE="mydatasource" NAME="myQuery" SELECT Name,Address,City,State,Etc FROM Table_A,Table_B WHERE Table_A.NameID = Table_B.NameID AND Some_Record_From_Table_A = '#Some_Search_Criteria#' /CFQUERY Name, Address, City and State are from table b. You could also include any records you like from table a. The only time you'll need to specify the table (like in Table_A.NameID) is if there are fields named the same in both tables. It's also very important NOT to name fields the same in two tables that may be called from the same query unless they ARE related and contain the same info. Then: cfoutput query = "myQuery" #Name#br #Address#br #City#br #State#P /cfoutput Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Classes
I took it and would recommend it. It didn't cover as much as I hoped, but still was a "Fast Track" Chris Giminez I'm a newbie to CF and am considering taking the Fast Track to CF class. Anyone have anything good/bad to say about this class? It's put on by Productivity Point in LA. Thanks, -Laura -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Express for Linux
I just asked Allaire this question and was told maybe in a month. Chris Giminez Hy! When can we expect CF Express for Linux? Lep pozdrav, Iztok -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is Able Commerce truly user-unfriendly and hence useless?
Try asking Able for the wizards source code. They gave them to me after I complained and I was able to customize some things as needed. It turned out it wasn't enough so I had to pay the $1500 for source of everything, but they may give you the wizards at least without charging. Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 What I meant is when you click on Van Seats for example, you see only 2 products out of maybe 30. Then to see the other 28 (since they're no displayed in one column), you have to click a next button over and over again to see them in groups of 2. And when you try to change the format so they display in one column in total or in groups of say 10 in a column, lo and behold, theres no way to get into the templates. The wizards in Able Commerce are quite cryptic and help section is not very helpful. If anyone found a way to get around these obstacles without buying the open source version (another $1500), please let me know. Thanks. At 09:52 PM 4/16/2000 +0100, you wrote: You use the 'Styles' to set, say a group. So the first step would be to design a style for your group. In the style you may insert any HTML code at various points. So, for example design your trucks header with photo etc and insert it into a style as header one - in the wizard for the group select the style you have just designed and turn of all navigation options etc. In the style also decide on colours etc for the background. here is a site with thousands of able commerce pages - I have used a Java navigation applet in the right hand frame to be able to navigate to any counter - I call their 3 levels, Department, counter and product - rather than use their terminology. The counters on this site only take minutes to design in able commerce. http://www.fishtec.co.uk Kind regards Paul Burgess -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 16, 2000 8:52 PM To: [EMAIL PROTECTED] Subject: RE: Is Able Commerce truly user-unfriendly and hence useless? Dear Paul, I tried this with medium and large sized store. Unfortunately the templates don't allow you to go in and customize them to look exactly as you want. The output is nowhere near what the client is looking for. Normally in other programs you can go into the code and do this, but in Able Commerce, when you're using a wizard you're apparently not able to get into the source code. Try to get into the underlying CFM file and you find that its encrypted. Any ideas? Thanks for the feedback. At 01:38 PM 4/16/2000 +0100, you wrote: 1. You can achieve exactly that in Able Commmerce. Choose a large store option and you have three levels. Top level - create categories vans, trucks and suvs. Now create groups within each of those ie ford trucks, nissan trucks etc. Now create products within the groups. For each group, go to the style for that group and simply enter up your photo etc to show just what you are asking for. You must have set it up wrong if you are not achieving this - what demo store did you copy? You need at least a medium size store for what you wish to achieve. Paul Burgess -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 16, 2000 1:18 PM To: [EMAIL PROTECTED] Subject: RE: Is Able Commerce truly user-unfriendly and hence useless? I have a site with 3 categories: 1. VANS 2. TRUCKS 3. SUVS So what I need to do is have three tabs on the home page, each tab going to a page that has the group listings of each category on the next page. So if a visitor clicks on VANS, they go to a page with a nice picture of a van and a listing of all VAN products. When they click on a product, they see a display, etc. This I have not been able to accomplish with Able Commerce's so called wizards. Next, I need to change the icons, that I agree is not such a big deal but I was amazed that they would have enough courage to ship their product with such an ugly set. A real montrosity, I share this to vent my frustration with the user-unfriendliness of the product. I couldn't even get one page to list all 3 categories in a table with 3 rows. And finally to add insult to injury, when someone clicks on SEATS as a group listing, on the next page, instead of seeing a listing of all seats one after another vertically in a column, the visitor is expected to click on an ugly NEXT button to see the next one. No thumbnails, highly arcane looking navigation system created by their templates/wizards
Re: A Good CF Host Has What?
I'm sure someone can add to this list, but here's a list of what a dream host would offer in my opinion: Always up unlimited pop accounts reasonable price web based email access statistics package real time account set up (or within an hour) real time datasource set up static IP (for development and testing without a domain) phone (no more than 5 minutes on hold) or chat support Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Over time I've noticed the classic "I'm looking for a host threads". One of the things I've noticed is a general comment along the lines of "at least they're always up". I'm curious what people find to be important in a host. But not only that, but how difficult those things are to implement. To me, I would think that having enough bandwidth is a problem a host can easily fix with money (getting a OC-12 instead of a T-3, etc.). But I would think something are more difficult to implement, like good customer service. -Allen -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: A Good CF Host Has What?
phone (no more than 5 minutes on hold) or chat support Only needed to contact them once via email to ask that CFFILE be enabled on my account...taken care of immediately. A friend has spoken with them on the phone and gotten immediate response. They do offer a support forum but I've never used it. Funny, I called regarding the use of CFFILE and was told it was disabled. Period. There was no mention of the possibility of it being enabled. I guess I'll have to make a specific request. I set up an account elsewhere because of the lack of support for this tag. Other than that Inermedia has been great. You definately will pay for the great service and features, but it's worth it. Why don't hosting companies offer MySQL as a free option or maybe a one time set up? I've not seen it. Only Access or SQL. Chris Ken -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: WebHosting
Count me as one person who had very poor service from halfpricehosting. I would definately not recommend them. Intermedia.net has been good and fusionfx.com has been decent and is getting better. Chris Giminez Check out www.halfpricehosting.com On Fri, 14 Apr 2000, Tim Bahlke wrote: I am having problems with WebHosting and am researching others i.e. HostPro, SiteHosting ... Tim Bahlke Graphica www.thinkcreate.com -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Friday, April 14, 2000 8:21 AM To: [EMAIL PROTECTED] Subject: Re: WebHosting You taking about HostPro or some other??? The previous messages were cropped, and some other hosts have been mentioned in this discussion. So who are you talking about Thanks, Dave - Original Message - From: Chris Lott [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 13, 2000 5:23 PM Subject: Re: WebHosting I had some problems with them so bad that lawyers had to come out! I stay, and tell everyone I know to stay, as far away from them as possible. Terrible service, terrible uptimes, behavior that was either a serious case of internal miscommunication or attempts at outright bilking of customers... c -- Chris Lott [EMAIL PROTECTED], Technical Manager p907.474.5122 | f907.474.5402 | PGP Key ID: 0x8687E87E -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Tariq Ahmed - [EMAIL PROTECTED] - ICQ 6308515 TIBCO Finance Technology - Web Group - Senior Web Engineer Work: 650-461-3472 Pager: 800-759-x1702632 Fax: 650-461-3003 3375 Hillview Avenue. Palo Alto, CA. 94304. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
domain maker custom tag
Anyone know of a custom tag that would let a user enter a few keywords and have them combined in various combinations and with and without dashes "-", then check for registration availability. The output would show two lists. One for unavailable names and the other for available names. Chris Giminez -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Netscape 6 Eats Microsoft PWS...Story at 11
I installed N6 (hate it, btw). No problem with PWS though. Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Yesterday evening I installed the Netscape 6 beta. I just realized that the Personal Web Server icon was missing in my Win98 sys tray and trying to start PWS from the program menu throws an error. Time to reinstall PWS (NN6 is already gone). Anyone else notice a problem like this after installing NN6? Chris Montgomery = astutia.com - http://www.astutia.com [EMAIL PROTECTED] Astute e-business applications web site development 210-490-3249/888-745-7603 Fax 210-490-4692 Allaire Consulting Partner/Authorized NetObjects Reseller Find a Job in San Antonio - http://www.sajobnet.com = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: looping through a mailing list
I've changed part of the checking to the query, not cfif's, but I am still getting the same wrong results. I could really use some help if someone can, or at least a nudge in the right direction. ***!--- Get the list of subscribers who wich to be notified. --- CFQUERY NAME="notify_list" DATASOURCE="kane" SELECT * FROM notify Where 0=0 AND #form.bed# = des_bed AND #form.bath# = des_bath AND #form.garage# = des_garage AND #form.price# = gt_price AND #form.price# = lt_price AND #form.sq_ft# = des_sq_ft ORDER BY date_subscribed /CFQUERY !--- Loop through the subscribers --- cfloop QUERY="notify_list" !--- Check the desires of the subscriber against the actual values of the property. --- cfif notify_list.des_city CONTAINS form.city AND form.display eq 1 AND form.status eq "for sale" !--- Send email if the cfif evaluates true cfmail block will go here when it's working right. --- Send email to cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr cfelse !--- Don't send email if cfif evaluates to false. cfelse is only here for testing now. --- Don't send email cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr /cfif /cfloop *** Thanks! Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Yer wasting a lot of processing power in coldfusion unnecessarily. You should build a where clause that replicates the conditions you are searchinf for in your CFIF, that way you just loop over the result set and send the email to every single record. SQL Will handle that much faster than Cold Fusion will. Jordon This is for a real estate web site where the realtor will add their own property. When new property is added, I want it to check a data table of subscribers who are interested in a property fitting certain criteria, such as price, number of bedrooms, bathrooms, etc. I thought I had this figured out, but am not getting the desired results. Here's my code: ** !--- Get the list of subscribers who wich to be notified. --- CFQUERY NAME="notify_list" DATASOURCE="kane" SELECT * FROM notify ORDER BY date_subscribed /CFQUERY !--- Loop through the subscribers --- cfloop QUERY="notify_list" !--- Check the desires of the subscriber against the actual values of the property. --- cfif form.bed gte notify_list.des_bed AND form.bath gte notify_list.des_bed AND form.garage gte notify_list.des_garage AND form.price gte notify_list.gt_price AND form.price lte notify_list.lt_price AND form.sq_ft gte notify_list.des_sq_ft AND notify_list.des_city CONTAINS form.city AND form.display eq 1 AND form.status eq "for sale" !--- Send email if the cfif evaluates true cfmail block will go here when it's working right. --- Send email to cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr cfelse !--- Don't send email if cfif evaluates to false. cfelse is only here for testing now. --- Don't send email cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr /cfif /cfloop ** I currently have just 3 subscrbers in the notify table for testing and the above code gives me this result. * Send email to joe testerTest PersonChris Giminez Don't send email joe testerTest PersonChris Giminez Don't send email joe testerTest PersonChris Giminez * It's somehow evaluating to true and false for each person. I know I'm close to getting this. If someone could enlighten me I would be most grateful. Thanks! Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
sql list syntax
What is the sql syntax for checking if a form field value is contained in the contents of a comma delimted list of values in a field? Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
looping through a mailing list
This is for a real estate web site where the realtor will add their own property. When new property is added, I want it to check a data table of subscribers who are interested in a property fitting certain criteria, such as price, number of bedrooms, bathrooms, etc. I thought I had this figured out, but am not getting the desired results. Here's my code: ** !--- Get the list of subscribers who wich to be notified. --- CFQUERY NAME="notify_list" DATASOURCE="kane" SELECT * FROM notify ORDER BY date_subscribed /CFQUERY !--- Loop through the subscribers --- cfloop QUERY="notify_list" !--- Check the desires of the subscriber against the actual values of the property. --- cfif form.bed gte notify_list.des_bed AND form.bath gte notify_list.des_bed AND form.garage gte notify_list.des_garage AND form.price gte notify_list.gt_price AND form.price lte notify_list.lt_price AND form.sq_ft gte notify_list.des_sq_ft AND notify_list.des_city CONTAINS form.city AND form.display eq 1 AND form.status eq "for sale" !--- Send email if the cfif evaluates true cfmail block will go here when it's working right. --- Send email to cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr cfelse !--- Don't send email if cfif evaluates to false. cfelse is only here for testing now. --- Don't send email cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr /cfif /cfloop ** I currently have just 3 subscrbers in the notify table for testing and the above code gives me this result. * Send email to joe testerTest PersonChris Giminez Don't send email joe testerTest PersonChris Giminez Don't send email joe testerTest PersonChris Giminez * It's somehow evaluating to true and false for each person. I know I'm close to getting this. If someone could enlighten me I would be most grateful. Thanks! Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: some high trafic cf websites please
How can you tell? amazon.com and fedex.com are both CF sites. Hope this helps Tim -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.