RE: CFForms javaScript was Complimentary skill
It's on the main page. Scroll down to ColdFusion in Context: Augmentation of Automatic Javascript in that light-green box. -David On Sunday, June 10, 2001 10:47 PM, Zac [SMTP:[EMAIL PROTECTED]] wrote: On Sunday, June 10, 2001, at 09:54 PM, Kay Smoljak wrote: An interesting discussion of this: http://www.cftipsplus.com/ ~~ 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: OT BUT URGENT: IIS stability
Thanks to all of you for your help - after a long sleepless weekend, it finally turned out to be a combination of 1) Dodgy network card on the DB server 2) Network collisions on the LAN 3) Repeated DoS attacks 4) Brute-force password-cracking attempts 5) A dodgy router at the ISP 6) IIS needing a rebuild 7) A missing TOP 1 clause in a query 8) The two servers not wanting to talk to each other on the domain (getting rid of the domain controller status on the SQL server helped) .phew! Thanks again - if you're ever in Yorkshire, England, I'll buy you a pint! Cheers, Alistair -Original Message- From: Marc Edwards [mailto:[EMAIL PROTECTED]] Sent: 08 June 2001 20:25 To: CF-Talk Subject: Re: OT BUT URGENT: IIS stability Hmm. Quite honestly, from my experience, having a stable IIS deployment seems largely a matter of luck, and is subject to your particular recipe of Service pack versions, configuration options, the choice of IIS packages you have installed (I remember on particular system where installing the html web/ftp server administration option caused HUGE problems), peripherals and drivers on the machine, and the server hardware itself. I've experienced systems that run for months without trouble, and others that need redoing every few months, even though they have the same software, installed from the same set of CD's, on identical models of computers ordered at the same time from the same manufacturer! My suggestion to you is just to rebuild the sucker, and not waste time trying to pinpoint the source of the trouble, as in most cases you probably won't find it. Then when you've got a nice clean and reliable install up and running, DON'T TOUCH IT!! Don't try to add any other pieces of software to that server, just let it be your web/app server and nothing else. You might also want to consider migrating to Win2K. From what I've seen in the few months I've been using it in production type environments (we waited for a respectable time to give time for the worst bugs to be identified and sorted out, which is a practice I stick to religiously and unreservedly recommend to anyone deploying on ANY and every new Microsoft product or new version release) it seems to be considerably less finicky. These views may seem a bit extreme to some people, but since I'm one of the guys that needs to mobilise at 3AM , on weekends or on public holidays if something goes wrong, I have good reasons for having them.. - Original Message - From: Alistair Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 1:02 AM Subject: OT BUT URGENT: IIS stability Hi guys ( gals) Sorry for the OT post, but I REALLY need help on this one, people's jobs are on the line. We have a serious problem with stability on IIS 5, Win 2K, CF 4.5.2. IIS has suddenly started to die. Symptoms include - - Existing virtual directories get lost. VDir's that have been working fine for 6 months suddenly return This page cannot be displayed IIS errors. If you delete the VDir and recreate it, it works again. - CF pages take forever to return. Flat HTML pages are responding reasonably well, but all the images now take forever to download. Restarting the CF service seems to help, but only for about half an hour, then it returns. - FTP transfer rates have gone down from over 200K / second to about 5 BYTES / second. My first thought was a runaway CF process somewhere, but when we look at performance monitor on the CF/IIS server, CPU usage is only at 5% and memory usage is minimal. Then we thought it might be persistent database locks, but we've eliminated that. Performance monitor on the DB server shows only minimal CPU / memory usage too. We have CF and IIS on one server (Dual PIII 800, 1.3GB RAM) and SQL running on another. The SQL server is set up as the domain controller. CFSTAT shows that the database response time is fine, it's just taking ages for requests to get to from the server. I know that at my last job, IIS was rebuilt as a regular maintenance task every two or three months. This installation of IIS has been for the last five or six months until this last week. And no code has changed in the last three weeks. Has anyone else had similar problems? How often do you all have to rebuild / re-install IIS ? I need some figures to give to the management ASAP, as they're starting to growl for blood. Mail me directly if you like Cheers, Alistair Davidson Senior Web Developer Rocom New Media www.rocomx.net ~~ 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: CFForms javaScript was Complimentary skill
On Sunday, June 10, 2001, at 11:22 PM, David Shadovitz wrote: It's on the main page. Scroll down to ColdFusion in Context: Augmentation of Automatic Javascript in that light-green box. The low contrast light green box with the black type. :-) Nice article. Interesting explanation of that framework. I was specifically looking for some article or commentary around the CFForm/Form debate itself as I am not familiar with the issues. -- Any fool can make a rule, and any fool will mind it. Thoreau ~~ 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
Allaire Free CF Board (forum) missing Delete message action
Does anyone have the delete message section of Allaires Free Message Board. After doing all the graphics and personal modifications then checks. The board is missing the delete_message_action templates. The download from Allaire does not delete messages because of these missing templates. I know someone else has already fixed this. Can you please send me the templates so that members of the forum can delete messages ~~ 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
CFPOP shortcomings / questions
I've got a couple of questions regarding cfpop: 1) Is there any way that you can sort messages via date descending? 2) How can you highlight or retrieve only unread messages. 3) How can you see subfolders or other folders besides your inbox? 4) Is there any free custom tags that is better than cfpop, or has some of the above features? Regards Carlo Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
mssql mailing list?
anyone know a good MSSQL mailing list? Thanks, Michael ~~ 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
More info on Graph problem
After installation of subscription upgrade Cold Fusion 5 including graphing server on Windows 2000 running O'Reilly Website Pro 3.0 the graph scripts will not display a graph. Try it at http://www.ngtcollege.org/graphexam.cfm HOWEVER! Now try it on IIS running on port 81 same Windows 2000 box at: http://www.ngtcollege.org:81/graphexam.cfm and it works. Sounds like MM/CF needs to send me a patch for Website Pro 3.0. Jim Watkins http://www.ngtcollege.org ~~ 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
Fw: More info on Graph problem
- Original Message - From: Jim Watkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Dave Watts [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 4:07 PM Subject: More info on Graph problem After installation of subscription upgrade Cold Fusion 5 including graphing server on Windows 2000 running O'Reilly Website Pro 3.0 the graph scripts will not display a graph. Try it at http://www.ngtcollege.org/graphexam.cfm HOWEVER! Now try it on IIS running on port 81 same Windows 2000 box at: http://www.ngtcollege.org:81/graphexam.cfm and it works. Sounds like MM/CF needs to send me a patch for Website Pro 3.0. Jim Watkins http://www.ngtcollege.org ~~ 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: CFPOP shortcomings / questions
1) Is there any way that you can sort messages via date descending? Grab them all into a structure, and sort that. 3) How can you see subfolders or other folders besides your inbox? POP does not allow more than one folder. IMAP does, maybe you can use that if you can find a tag, and your server supports it. ~~ 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
file size
Is there any way to dynamically display the size of a file? I display lists of PDF links and need to show the size of each file after the title. Although all the pdf's are in the same folder, they are linked to from various pages. Thanks, Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ 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
PDF To Imag
Anyone have tag that will convert a PDF to a JPG, Gif or BMP. ~~ 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
Verity and double quotes
I have a Verity search facility on my site. When I search for literal strings using double quotes, Verity performs a search including the quotes, e.g. it searches for 'rail network' instead of 'rail network'. Has anyone come across this problem before? I've tried to fix it by using a ReplaceNoCase to extract the double quotes: cfset form.Criteria = ReplaceNoCase(form.Criteria,Chr(34),,ALL) But the first instance of the double quote is not removed - another weird error. Any ideas would be much appreciated. Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ 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
ComPLexed RERPLACE
I have a big text file that looks like this: FROM: X STEPS: 10 FROM: X STEPS: 3 .. ... .. . ... FROM: X STEPS 5 The X is a constant X characters, the steps varies from 1 to 10 with no rule or special consistency. I need the best way to Replace The X char to the REAL from number according to the steps. Each FROM is the LAST FORM + STEPS. i.e - to get something like this: FROM: 1 STEPS: 10 FROM: 11 STEPS: 3 FROM: 14 STEPS: 3 FROM: 17 .. Thanks, Michael. ~~ 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: CFSTOREDPROC and performance question
Thanks Aaron. DTS was my first attempt but it will not work on this shared server with a text file. Regards, Marc Garrett - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 9:58 PM Subject: Re: CFSTOREDPROC and performance question Or DTS and you could schedule a Job to execute it whenever. ~~ 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 in background
I want to get CFSCHEDULE to run in the background (to create a text file), and load NewPage.cfm while it is still running. However, in the following code, NewPage does not load until CFSCHEDULE has finished running. (I am using CF 4.5.1.) Any suggestions? CFSCHEDULE ACTION=UPDATE TASK=TaskName OPERATION=HTTPRequest URL=http://127.0.0.1/Script.cfm; STARTDATE=6/6/01 STARTTIME=10:53 AM INTERVAL=Once RESOLVEURL=No PUBLISH=No REQUESTTIMEOUT=600 cfschedule action=RUN task=TaskName cflocation url=NewPage.cfm Thanks Andrew ~~ 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: CFSCHEDULE in background
There is no way really - unless you upgrade to cf hawaii (5-0h) and use cfflush (or unless you use js to open a remote window that calls the cfschedule page in the background (i.e. under the main window) - then use a close window function at the end of the schdule page - while you also use a reload.opener function on the main page) J -Original Message- From: Andrew Howe [mailto:[EMAIL PROTECTED]] Sent: 11 June 2001 12:43 To: CF-Talk Subject: CFSCHEDULE in background I want to get CFSCHEDULE to run in the background (to create a text file), and load NewPage.cfm while it is still running. However, in the following code, NewPage does not load until CFSCHEDULE has finished running. (I am using CF 4.5.1.) Any suggestions? CFSCHEDULE ACTION=UPDATE TASK=TaskName OPERATION=HTTPRequest URL=http://127.0.0.1/Script.cfm; STARTDATE=6/6/01 STARTTIME=10:53 AM INTERVAL=Once RESOLVEURL=No PUBLISH=No REQUESTTIMEOUT=600 cfschedule action=RUN task=TaskName cflocation url=NewPage.cfm Thanks Andrew ~~ 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
Subject: RE: Javascript wildcard string matching
Hi Bryan - thanks for responding to my javascript question. But it still
doesn't work (checking the box doesn't automatically check the other one).
Here's your code:
input type=checkbox name=check
value=#fullfileid##processid##deptcode#
onclick=for (i=0; iform.check.length; i++) if
(form.check.value.indexOf('#fullfileid##processid#') = 0 )
form.check.checked=this.checked
Is there a syntax error anywhere? It is not colored correctly in Studio so
I figure that could be the problem. I tried a couple different things but
it still isn't working.
thanks again for your help!
~~
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: CFSTOREDPROC and performance question
What is happening when you attempt to use it? We use it a great deal in a shared server environment to do bulk inserts of text files and Access 97 databases into SQL Server 7. The only issues we have run into has been user permissions, since we are uploading files to the web server via CF and then needed to execute the DTS package on the SQL Server. Our work around for that is to use a stored procedure to copy the files from one box to the other and to setup permissions on the boxes to allow the SQL Server to connect to the web server via FTP. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Marc Garrett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 6:34 AM Subject: Re: CFSTOREDPROC and performance question Thanks Aaron. DTS was my first attempt but it will not work on this shared server with a text file. Regards, Marc Garrett - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 9:58 PM Subject: Re: CFSTOREDPROC and performance question Or DTS and you could schedule a Job to execute it whenever. ~~ 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: Subject: RE: Javascript wildcard string matching
Never Mind! I figured it out. Here's the correct syntax for anyone else
that might need it
input type=checkbox name=check
value=#fullfileid##processid##deptcode#
onclick=for (i=0; iform.check.length; i++) if
(form.check[i].value.indexOf('#fullfileid##processid#') = 0
)form.check[i].checked=this.checked
THANK YOU BRYAN!
-Original Message-
From: Smith, Melanie
Sent: Monday, June 11, 2001 8:03 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: Subject: RE: Javascript wildcard string matching
Hi Bryan - thanks for responding to my javascript question. But it still
doesn't work (checking the box doesn't automatically check the other one).
Here's your code:
input type=checkbox name=check
value=#fullfileid##processid##deptcode#
onclick=for (i=0; iform.check.length; i++) if
(form.check.value.indexOf('#fullfileid##processid#') = 0 )
form.check.checked=this.checked
Is there a syntax error anywhere? It is not colored correctly in Studio
so I figure that could be the problem. I tried a couple different things
but it still isn't working.
thanks again for your help!
~~
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: Looking for a Web Based ActiveX Treeview
You may want to consider using XML/XSL for this piece. The performance is really great. In this way, you can have complete control over the look and function of your tree. You can find some resources and samples at http://msdn.microsoft.com/xml. Greetings CF-ers! I am looking for an ActiveX Treeview that I can drop into a CF app that allows both checkboxes and radio buttons within the same tree. Very similar to the tree on this page: http://www.softelvdm.com/treeocx_ss.html This tree is only avaiable to VB and Visual C++ apps. I need one that is web based. Alternatively, is there anyway to do this with a CFTREE or possibly a customtag? Any thoughts or past experiences would be greatly appreciated. Thanks, Sutton ~~ 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: file size
Sure. Do a CFDIRECTORY ACTION=LIST NAME=qPDFs FILTER=*.pdf on the PDF files in that directory, and then you've got access to the size of each as qPDF.Size -David On Monday, June 11, 2001 3:37 AM, Steve Vosloo [SMTP:[EMAIL PROTECTED]] wrote: Is there any way to dynamically display the size of a file? I display lists of PDF links and need to show the size of each file after the title. Although all the pdf's are in the same folder, they are linked to from various pages. ~~ 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: ClickBank
I have now integrated ColdFusionMonthly.com to ClickBank it is very easy... but there instructions need a little help. Nathan Stanford Senior Programmer/Analyst [EMAIL PROTECTED] -Original Message- From: Alii Design [SMTP:[EMAIL PROTECTED]] Sent: Sunday, June 10, 2001 5:16 PM To: CF-Talk Subject: ClickBank Does anyone have any experience with integrating Clickbank into a CF app? I haven't seen any examples or tags in the dev gallery. Rich -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 10, 2001 4:46 PM To: CF-Talk Subject: CFTree form submittal How can a form be submitted via JavaScript when there is a CFTree in that form and you are selecting nothing from that CFTree? I simple document.frm.submit(); does not work with Netscape, when you get to the posting screen you get a Error resolving parameter TREE. ~~ 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: file size
From CFusion Docs for CFDIRECTORY: HTML HEAD TITLE CFDIRECTORY Example /TITLE /HEAD BODY H3CFDIRECTORY Example/H3 !--- use CFDIRECTORY to give the contents of the snippets directory, order by name and size (you may need to modify this path) --- CFDIRECTORY DIRECTORY=c:\inetpub\wwwroot\cfdocs\snippets NAME=myDirectory SORT=name ASC, size DESC !--- Output the contents of the CFDIRECTORY as a CFTABLE --- CFTABLE QUERY=myDirectory CFCOL HEADER=NAME: TEXT=#Name# CFCOL HEADER=SIZE: TEXT=#Size# /CFTABLE /BODY /HTML -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 5:37 AM To: CF-Talk Subject: file size Is there any way to dynamically display the size of a file? I display lists of PDF links and need to show the size of each file after the title. Although all the pdf's are in the same folder, they are linked to from various pages. Thanks, Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ 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: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True !
Netscape might be going away but mozilla is just getting started. The latest mozilla 0.9.1 is faster then IE on page loads and with the -turbo switch even opens up quicker then IE. The Mozilla code has really come along way and they still aren't completely done optimizing it. Netscape would have always been a few versions back from the latest mozilla build, so eventually everyone would just be using mozilla. The one bad thing is that netscape has the marketing that mozilla needs. Rich -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 10, 2001 2:55 AM To: CF-Talk Subject: RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True ! At 05:08 PM 06/09/2001 -0400, you wrote: Well Ah -- my two cents... I'm really surprised that Netscape (that is it new owners) haven't abandoned Netscape sooner to devote efforts and technologies acquired into more profitable endeavors. What would you do if you were in their shoes? I'd upgrade AOL, remove the IE browser, and put the Netscape browser in it's place. In doing so, they would probably overnight turn the tables on the browser war. Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out June 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've been vindicated, I've been loved and hated I've been pulled aside and told that I was overrated ~~ 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: CFForms javaScript was Complimentary skill
Zac, I don't have a link to the discussion you're asking about, but I've always found that CFFORM was lacking in several key areas--so I wrote a JavaScript API that I use in place of CFFORM called qForms. The API is open source and is a *lot* more powerful and flexible then the CFFORMs code, and it's as easy (or easier) to use. Plus, qForms has a lot of extended methods and properties that deal with things other than just validation, like: moving an item from one select box to another, trimming fields, populating a select box, returning the form as a structure, setting the form based on a structure, serializing the form to WDDX, plus much, much more. One of the neatest things about the API is that it provides you with the setValue() and getValue() methods--which all you to retrieve a value or set the value for *any* field type. This means you no longer have to loop through a select box to get the value, just call the getValue() method. You can find more information about the qForms API at: http://www.pengoworks.com/qForms/ Something else worth noting, the API is all client-side--which means that you can use it with *any* server-side solution and you're not limited to one platform. That also means you can use it with a standard .html file. There's a number of companies using the API and it's been written to work with NS v3+ and IE4+. (It should work w/IE3, but I don't know anybody that still has a copy to test it with. g) -Dan -Original Message- From: Zac [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 09, 2001 4:23 PM To: CF-Talk Subject: CFForms javaScript was Complimentary skill On Saturday, June 9, 2001, at 12:33 PM, Jann VanOver wrote: Do NOT use the CF form tags -- write all your own Javascript -- the javascript in CF form tags will get in your way. Does anyone have a link to a discussion of this? I've seen this being mentioned before and would be interested in any info about it. TIA -- Love is a snowmobile racing across the tundra and then suddenly it flips over, pinning you underneath. At night, the ice weasels come. ~~ 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
Doubled Form fields
Hey all. Has anyone had the problem of form fields doubling? Occasionally, when I submit this one form, it doubles all the form fields. For example, if I have a hidden form field called userid and its value is 3, the form passes it to the next page as 3,3. The form is has its enctype= multipart-form/data so it can do file uploads, but I dont know if that has anything to do with it. Anyone run into this before? Please email me at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] instead of hitting reply because I dont check this account that much. -Craig ~~ 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: file size
Thanks. -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 3:07 PM To: CF-Talk Subject: RE: file size Sure. Do a CFDIRECTORY ACTION=LIST NAME=qPDFs FILTER=*.pdf on the PDF files in that directory, and then you've got access to the size of each as qPDF.Size -David On Monday, June 11, 2001 3:37 AM, Steve Vosloo [SMTP:[EMAIL PROTECTED]] wrote: Is there any way to dynamically display the size of a file? I display lists of PDF links and need to show the size of each file after the title. Although all the pdf's are in the same folder, they are linked to from various pages. ~~ 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: Doubled Form fields
I seem to recall seeing that as a bug that was fixed in the 4.5.2 service pack. If you don't have it, try installing it and see if that fixes the problem. Tim P. - Original Message - From: Craig Bowes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 9:43 AM Subject: Doubled Form fields Hey all. Has anyone had the problem of form fields doubling? Occasionally, when I submit this one form, it doubles all the form fields. For example, if I have a hidden form field called userid and its value is 3, the form passes it to the next page as 3,3. The form is has its enctype= multipart-form/data so it can do file uploads, but I don't know if that has anything to do with it. Anyone run into this before? Please email me at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] instead of hitting reply because I don't check this account that much. -Craig ~~ 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: Doubled Form fields
I've seen this on several occasions, and on each one, it was programmer error. Check and double check to ensure that you are not doubling up the name of a form field somewhere on your form. Is the name of the form field written in a loop, effectively creating several inputs of the same name? If so the result is a comma delimited list. You say that this only happens occasionally. It could be that the code which blows up only runs when certain form fields are present, or checked, etc. HTH, let me know what you find out. Brian - Original Message - From: Craig Bowes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 8:43 AM Subject: Doubled Form fields Hey all. Has anyone had the problem of form fields doubling? Occasionally, when I submit this one form, it doubles all the form fields. For example, if I have a hidden form field called userid and its value is 3, the form passes it to the next page as 3,3. The form is has its enctype= multipart-form/data so it can do file uploads, but I don't know if that has anything to do with it. Anyone run into this before? Please email me at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] instead of hitting reply because I don't check this account that much. -Craig ~~ 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: CFSCHEDULE in background
Thanks for the JavaScript tip: I have used JS to open and then immediately close a window containing a template with the CFSCHEDULE code. This kicks off the process as I intended. Andrew - Original Message - From: James Maltby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 12:56 PM Subject: RE: CFSCHEDULE in background There is no way really - unless you upgrade to cf hawaii (5-0h) and use cfflush (or unless you use js to open a remote window that calls the cfschedule page in the background (i.e. under the main window) - then use a close window function at the end of the schdule page - while you also use a reload.opener function on the main page) J -Original Message- From: Andrew Howe [mailto:[EMAIL PROTECTED]] Sent: 11 June 2001 12:43 To: CF-Talk Subject: CFSCHEDULE in background I want to get CFSCHEDULE to run in the background (to create a text file), and load NewPage.cfm while it is still running. However, in the following code, NewPage does not load until CFSCHEDULE has finished running. (I am using CF 4.5.1.) Any suggestions? CFSCHEDULE ACTION=UPDATE TASK=TaskName OPERATION=HTTPRequest URL=http://127.0.0.1/Script.cfm; STARTDATE=6/6/01 STARTTIME=10:53 AM INTERVAL=Once RESOLVEURL=No PUBLISH=No REQUESTTIMEOUT=600 cfschedule action=RUN task=TaskName cflocation url=NewPage.cfm Thanks Andrew ~~ 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
updating records in spreadsheet-like view
OK - I've had good luck with this list lately and I'm pulling my hair out on
this - there has to be an answer!
I'd just like to display to the user a list (multi-row-like) of document ids
and a blank box for entering in train dates. When the user hits submit I'd
like to update a table with the new dates. CFGRID and CFGRIDUPDATE both
work for this purpose, but there is one catch for my application. There may
be duplicate docids for an employee based on another key field in the table,
subdept. So I really don't want to display all those duplicates to the end
user - just let them see docid and the blank box for the date, then have it
behind the scenes update the date for all instances (subdept) of the
docid. CFGRID doesn't like this since any key field needs to be included
and deptcode is a key field. I've done something similar to this by using
a concatenated field and then using the evaluate() function on the next
page, but that was with a checkbox not a date field and the checkbox allows
me to assign a concatenated value along with a name. How do I do that
with an input text box? Here's some code which works great for a checkbox
but I want to do the same for a date (text) box (with an update instead of a
insert). So how would this work if the first line below was a date field?
I guess the issue is how you can assign a value to a checkbox to be passed
to the next page but with an input text box if you assigned a value it would
show up on the entry form.
input type=checkbox name=check checked value=#fullfileid##deptcode#
/td
td
#LSNumberFormat(employeeno,9)#
/td
td
#docid#
/td
td
#Title#
/td
td
#DeptCode#
/td
/tr
input type=hidden name=empid#docid##deptcode#
value=#LSNumberFormat(employeeno,9)#
input type=hidden name=deptcode#docid##deptcode# value=#deptcode#
input type=hidden name=docid#docid##deptcode# value=#fullfileid#
/cfoutput
Processing Page:
cfloop index=doc list=#form.check#
cfquery name=addtorec datasource=docs
insert into tblemployee_train(employeeno,fullfileid,deptcode,dateadded)
values(#evaluate('form.empid' doc)#,'#evaluate('form.docid'
doc)#','#evaluate('form.deptcode' doc)#',#Now()#)
/cfquery
/cfloop
~~
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
Database Design Help
Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try to explain how the site is going to be made, and hopefully someone can help. There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub pages. I want to be able to call any page, whether it's a sub-sub, sub, or category page, just by it's id (like pageid=3). Then, using only the pageid information I want to be able to get all the other pages in that category... so, for example: If pageid 3 was a sub-sub page... when someone goes to that page, I want to be able to list the main category page it's under, the sub pages under that category, and then the sub-sub pages under the sub page (which the current page belongs to). Can anyone help me figure out how I should build the DB to handle this? I feel like an idiot because it seems like it would be so simple (especially since I know the pages will always be only 3 levels deep) but I just can't figure out how to make the DB. Please help! Cody ~~ 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
Visual SourceSafe
I know this is a cf list, but I'm hoping they are still members using sourcesafe, their documentation is really poor. I've been using sourcesafe with mapped drives. However, it's slow and a security hazzard, so I'm wishing to use FTP instead. However, even though I've now labeled projects as web projects, I can't figure out how to use the FTP available. Also, we have a clustered environment, so if anyone has experience with deploying to mutiple servers, I'd appreciate your help as well. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Help
Just have one table with all of the pages in which inclues the following fields: id - Unique ID for entry parentid - ID of parent page (this value is 0 for category pages) That way you have a heirachical data structure within 1 table. Querying the table becomes a bit trickier but still ont tat complex. The advantage of this is that you are not restricted to 3 levels should you wish to expand. where you have -Original Message- From: Cody [mailto:[EMAIL PROTECTED]] Sent: 11 June 2001 15:23 To: CF-Talk Subject: Database Design Help Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try to explain how the site is going to be made, and hopefully someone can help. There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub pages. I want to be able to call any page, whether it's a sub-sub, sub, or category page, just by it's id (like pageid=3). Then, using only the pageid information I want to be able to get all the other pages in that category... so, for example: If pageid 3 was a sub-sub page... when someone goes to that page, I want to be able to list the main category page it's under, the sub pages under that category, and then the sub-sub pages under the sub page (which the current page belongs to). Can anyone help me figure out how I should build the DB to handle this? I feel like an idiot because it seems like it would be so simple (especially since I know the pages will always be only 3 levels deep) but I just can't figure out how to make the DB. Please help! Cody ~~ 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
Difficult Replacement
I have a big text file that looks like this: FROM: X STEPS: 10 FROM: X STEPS: 3 ... ... .. FROM: X STEPS 5 The X is a constant X characters, the steps varies from 1 to 10 with no rule or special consistency. I need the best way to Replace The X char to the REAL from number according to the steps. Each FROM is the LAST FORM + STEPS. i.e - to get something like this: FROM: 1 STEPS: 10 FROM: 11 STEPS: 3 FROM: 14 STEPS: 3 FROM: 17 ... . Thanks, Michael ~~ 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
Xmailer change doesn't help!
I'm trying to send CFMAIL to yahoo using one of the following ways: 1. cfmail to=#a[i]# from=#AUTH.userEMAIL# subject=Surprise From VAMP type=HTML mailerid=Internet Mail Service (5.5.2650.21) 2.cfmailparam name=X-Mailer value=(Microsoft Exchange Internet Mail Service Version 5.5.2650.21) and both throws out: Error,TID=1128,06/11/01,09:23:45,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\1CFA.cfmail. SMTP server replied not local host yahoo.com, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\1CFB.cfmail. I've tried EVERYTHING that was on the archive, can someone help? Thanks, Michael. ~~ 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: Database Design Help
Cody, I think you should still design the system so that it can have more than three levels. Your site structure is very common in sites I have been working with and most stay within those three levels, but sometimes there can be a small change that the client wants that messes everything and requires a fourth. ANYWAY: Here is the way we do it: Create a single table called SiteCategories. Within the table create a column called parent. The first level categories will all have 0 as the parent. Each category will have an ID and the sub categories will use this ID as it's parent. Here are a few example records: catIDcatTitle catDescriptionParent 1 supportdescription of support 0 2 servicesdescription of services 0 3 online desc. of online support1 4 telephone desc. of phone support1 Now when you click on support simply query all records where the parent record is 1 and you will retrieve all support sub records. Simalarly when you want to brong up phone support all you would need to do id determine what its' parent is then query all items with the same parent. You can reply to me directly if I have confused you with this. - BILL - - Original Message - From: Cody [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 7:23 AM Subject: Database Design Help Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try to explain how the site is going to be made, and hopefully someone can help. There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub pages. I want to be able to call any page, whether it's a sub-sub, sub, or category page, just by it's id (like pageid=3). Then, using only the pageid information I want to be able to get all the other pages in that category... so, for example: If pageid 3 was a sub-sub page... when someone goes to that page, I want to be able to list the main category page it's under, the sub pages under that category, and then the sub-sub pages under the sub page (which the current page belongs to). Can anyone help me figure out how I should build the DB to handle this? I feel like an idiot because it seems like it would be so simple (especially since I know the pages will always be only 3 levels deep) but I just can't figure out how to make the DB. Please help! Cody ~~ 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: Convert ACCESS query to SQL query
I don't think you can delete from more than one table at a time. If you wanted to do it in one call from CF you could do it in a stored proc. Or you could set up a trigger to delete from one table when related records were deleted from another. -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: 08 June 2001 21:24 To: CF-Talk Subject: OT: Convert ACCESS query to SQL query Need a little help with this, just learning SQL server and am trying to convert over from ACCESS. In ACCESS my query looks like: DELETE table1.*, table2.* FROM table1 LEFT JOIN table2 ON table1.field= table2.field WHERE table1.field = variable; and works fine but removing *s does not work. works if only deleting from one table. DELETE table1, table2 FROM table1 LEFT JOIN table2 ON table1.field= table2.field WHERE table1.field = variable; IN SQL when deleting, the *s are left out, I get this to work fine when only deleting from one table, I get the error message, when I remove the *s: Incorrect syntax near ',' How do you delete from more than one table at a time with SQL? I can get around this by changing to 2 queries: 1) del records in table 1 based on variable 2) del records in table 2 based on variable but I should be able to keep in one query, similar to the one used for ACCESS. some help please Rodney ~~ 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
OT: intrusion/penetration tools
I'm looking for any tools/utilities to test the security of my application/server, specifically against intrusion/penetration or other tricks (DOS, ping of death, etc). Any suggestions? -mike ~~ 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: Xmailer change doesn't help!
This looks to me as if the SMTP server that the CF server is trying to use is not configured to relay mail. Have you talked to the administrator of the SMTP server? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 11:38 AM To: CF-Talk Subject: Xmailer change doesn't help! I'm trying to send CFMAIL to yahoo using one of the following ways: 1. cfmail to=#a[i]# from=#AUTH.userEMAIL# subject=Surprise From VAMP type=HTML mailerid=Internet Mail Service (5.5.2650.21) 2.cfmailparam name=X-Mailer value=(Microsoft Exchange Internet Mail Service Version 5.5.2650.21) and both throws out: Error,TID=1128,06/11/01,09:23:45,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\1CFA.cfmail. SMTP server replied not local host yahoo.com, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\1CFB.cfmail. I've tried EVERYTHING that was on the archive, can someone help? Thanks, Michael. ~~ 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: Database Design Help
My first thought is to use a self-referencing table. Page (PageID, categoryinfo, ParentID) ParentID references back to PageID. Set it to zero for top-level categories. You can get any page by selecting where pageID = currentpageID You can get all children by selecting where parentID = currentpageID You can get the parent by selecting where page.pageID in (select parentID where pageID = currentpageID) (-- or something like that) Since you want to reference everything by a single ID set, you probably do not want to your pages into multiple categories. At 09:23 AM 06/11/2001 -0500, you wrote: Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try to explain how the site is going to be made, and hopefully someone can help. There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub pages. I want to be able to call any page, whether it's a sub-sub, sub, or category page, just by it's id (like pageid=3). Then, using only the pageid information I want to be able to get all the other pages in that category... so, for example: If pageid 3 was a sub-sub page... when someone goes to that page, I want to be able to list the main category page it's under, the sub pages under that category, and then the sub-sub pages under the sub page (which the current page belongs to). Can anyone help me figure out how I should build the DB to handle this? I feel like an idiot because it seems like it would be so simple (especially since I know the pages will always be only 3 levels deep) but I just can't figure out how to make the DB. Please help! Cody ~~ 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
OT: Hostcentric
Does anyone know how to get response from Hostcentric? For more than two weeks, we have been trying unsuccessfully to get them to close one of our client's accounts. Several emails have produced nothing more than an automated response, their 800 number doesn't work from northern Pennsylvania, and there has been no reply after leaving a message on an Orlando phone number that we were given by the people at Virtualscape (a related company). Meanwhile, we received an automatic billing for the continuation of the account... Frustrated, Gene Kraybill LPW Associates LLC 570-549- ~~ 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: Database Design Help
I built a site very similar to this, using the technique Bill explained, with each record having a parent record. If you KNOW for sure that there will be no more than three levels, then you can get away with three tables: grandparents, parents, children. This is risky and not the best design. The parent record idea worked very well, but there's an even better method to build trees (that's the term for these things) located on www.secretagents.com, as a free sample tutorial for there tutorial services. It's not simple to pickup, but if anyone is interested in building trees of infinite depth, it's certainly an interesting technique. It reduces the number of queries required to find the parent and grandparent of a given child. Using the parent record theory, you've gotta query twice: once to find the parent, then again to find the parent's parent. At least that was the only way I figured out :). Norman Elton -Original Message- From: Bill King [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 11:41 AM To: CF-Talk Subject: Re: Database Design Help Cody, I think you should still design the system so that it can have more than three levels. Your site structure is very common in sites I have been working with and most stay within those three levels, but sometimes there can be a small change that the client wants that messes everything and requires a fourth. ANYWAY: Here is the way we do it: Create a single table called SiteCategories. Within the table create a column called parent. The first level categories will all have 0 as the parent. Each category will have an ID and the sub categories will use this ID as it's parent. Here are a few example records: catIDcatTitle catDescriptionParent 1 supportdescription of support 0 2 servicesdescription of services 0 3 online desc. of online support1 4 telephone desc. of phone support1 Now when you click on support simply query all records where the parent record is 1 and you will retrieve all support sub records. Simalarly when you want to brong up phone support all you would need to do id determine what its' parent is then query all items with the same parent. You can reply to me directly if I have confused you with this. - BILL - - Original Message - From: Cody [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 7:23 AM Subject: Database Design Help Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try to explain how the site is going to be made, and hopefully someone can help. There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub pages. I want to be able to call any page, whether it's a sub-sub, sub, or category page, just by it's id (like pageid=3). Then, using only the pageid information I want to be able to get all the other pages in that category... so, for example: If pageid 3 was a sub-sub page... when someone goes to that page, I want to be able to list the main category page it's under, the sub pages under that category, and then the sub-sub pages under the sub page (which the current page belongs to). Can anyone help me figure out how I should build the DB to handle this? I feel like an idiot because it seems like it would be so simple (especially since I know the pages will always be only 3 levels deep) but I just can't figure out how to make the DB. Please help! Cody ~~ 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
Weird problem setting client variable
I have the weirdest problem setting a client variable and for the live of me I can not see where the problem is. The problem is the following: I have a form where the user can change the language of the site, one of the fields on the form is a select box named NewLang, now, once the user selects the new language the form is posted to a template (ChangeLang.cfm) which only function is to cfset client.lang = newlang and then cflocation to the parent template. The first line in the application.cfm is to cfparam for client.lang and set it to en if is not defined, some how it is always set to en because client.lang is not defined. Now I know app.cfm is always executed, so before ChangeLang.cfm is executed the client.lang is set to en then the template is executed and client.lang is set to the new language and a redirection occurs to the parent template, client.lang should contain the new language, but is not because the cfparam resets it to en. Can somebody see where the problem is... TIA Bismarck Perez ~~ 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: intrusion/penetration tools
Look at whisker at http://www.wiretrip.net/rfp/2/index.asp as a good start to check your site for holes. Also, the last issue of Fusion Authority had a link to a totally fantastic article on DOS attacks and zombies. I'm looking for any tools/utilities to test the security of my application/server, specifically against intrusion/penetration or other tricks (DOS, ping of death, etc). Any suggestions? -mike ~~ 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: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True !
Does Netscape/Mozilla support DHTML and DOM scripting the way IE does? span style=color:redTEXT/span didn't even work in Netscape 4.7, I can't even imagine more complex items functioning in NS ... I've been building IE specific intranets for over a year now, so I don't even touch NS anymore does it still suck as bad as before? Not that IE is golden, but it IS easier to work with from a DHTML perspective. Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Richard Kuryk [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 9:27 AM To: CF-Talk Subject: RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True ! Netscape might be going away but mozilla is just getting started. The latest mozilla 0.9.1 is faster then IE on page loads and with the -turbo switch even opens up quicker then IE. The Mozilla code has really come along way and they still aren't completely done optimizing it. Netscape would have always been a few versions back from the latest mozilla build, so eventually everyone would just be using mozilla. The one bad thing is that netscape has the marketing that mozilla needs. Rich -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 10, 2001 2:55 AM To: CF-Talk Subject: RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True ! At 05:08 PM 06/09/2001 -0400, you wrote: Well Ah -- my two cents... I'm really surprised that Netscape (that is it new owners) haven't abandoned Netscape sooner to devote efforts and technologies acquired into more profitable endeavors. What would you do if you were in their shoes? I'd upgrade AOL, remove the IE browser, and put the Netscape browser in it's place. In doing so, they would probably overnight turn the tables on the browser war. Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out June 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've been vindicated, I've been loved and hated I've been pulled aside and told that I was overrated ~~ 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: updating records in spreadsheet-like view
How about something like this.
input type=text name=check#fullfileid##deptcode#
value=#fullfileid##deptcode#
/td
td
#LSNumberFormat(employeeno,9)#
/td
td
#docid#
/td
td
#Title#
/td
td
#DeptCode#
/td
/tr
input type=hidden name=empid#docid##deptcode#
value=#LSNumberFormat(employeeno,9)#
input type=hidden name=deptcode#docid##deptcode# value=#deptcode#
input type=hidden name=docid#docid##deptcode# value=#fullfileid#
/cfoutput
Processing Page:
///if all docids need the same date then it's easy.
cfloop name=the same query used to generate the form page
cfquery name=updaterec datasource=docs
update tblemployee_train set dateadded=#evaluate('form.check'
#fullfileid##deptcode#)#
where docid=#docid#
/cfquery
/cfloop
-Original Message-
From: Smith, Melanie [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 15:18
To: CF-Talk
Subject: updating records in spreadsheet-like view
OK - I've had good luck with this list lately and I'm pulling my hair out on
this - there has to be an answer!
I'd just like to display to the user a list (multi-row-like) of document ids
and a blank box for entering in train dates. When the user hits submit I'd
like to update a table with the new dates. CFGRID and CFGRIDUPDATE both
work for this purpose, but there is one catch for my application. There may
be duplicate docids for an employee based on another key field in the table,
subdept. So I really don't want to display all those duplicates to the end
user - just let them see docid and the blank box for the date, then have it
behind the scenes update the date for all instances (subdept) of the
docid. CFGRID doesn't like this since any key field needs to be included
and deptcode is a key field. I've done something similar to this by using
a concatenated field and then using the evaluate() function on the next
page, but that was with a checkbox not a date field and the checkbox allows
me to assign a concatenated value along with a name. How do I do that
with an input text box? Here's some code which works great for a checkbox
but I want to do the same for a date (text) box (with an update instead of a
insert). So how would this work if the first line below was a date field?
I guess the issue is how you can assign a value to a checkbox to be passed
to the next page but with an input text box if you assigned a value it would
show up on the entry form.
input type=checkbox name=check checked value=#fullfileid##deptcode#
/td
td
#LSNumberFormat(employeeno,9)#
/td
td
#docid#
/td
td
#Title#
/td
td
#DeptCode#
/td
/tr
input type=hidden name=empid#docid##deptcode#
value=#LSNumberFormat(employeeno,9)#
input type=hidden name=deptcode#docid##deptcode# value=#deptcode#
input type=hidden name=docid#docid##deptcode# value=#fullfileid#
/cfoutput
Processing Page:
cfloop index=doc list=#form.check#
cfquery name=addtorec datasource=docs
insert into tblemployee_train(employeeno,fullfileid,deptcode,dateadded)
values(#evaluate('form.empid' doc)#,'#evaluate('form.docid'
doc)#','#evaluate('form.deptcode' doc)#',#Now()#)
/cfquery
/cfloop
~~
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: Xmailer change doesn't help!
the SMTP is defined in the CF admin. i can send mail to other accounts just fine, just Yahoo! is causing problems. Thanks, Michael - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 4:53 PM Subject: RE: Xmailer change doesn't help! This looks to me as if the SMTP server that the CF server is trying to use is not configured to relay mail. Have you talked to the administrator of the SMTP server? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 11:38 AM To: CF-Talk Subject: Xmailer change doesn't help! I'm trying to send CFMAIL to yahoo using one of the following ways: 1. cfmail to=#a[i]# from=#AUTH.userEMAIL# subject=Surprise From VAMP type=HTML mailerid=Internet Mail Service (5.5.2650.21) 2.cfmailparam name=X-Mailer value=(Microsoft Exchange Internet Mail Service Version 5.5.2650.21) and both throws out: Error,TID=1128,06/11/01,09:23:45,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\1CFA.cfmail. SMTP server replied not local host yahoo.com, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\1CFB.cfmail. I've tried EVERYTHING that was on the archive, can someone help? Thanks, Michael. ~~ 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: intrusion/penetration tools
Are you looking for tools that will be run on a Unix or Windows platform? Also, are you looking for host or network-based tools? If you are not familiar with the terminology, host-based tools reside on the machine being tested and allow for a much deeper local inspection while network-based tools are run from a computer other than the one being tested and are better for testing remote vulnerabilities. Some network-based tools have remote agents that are installed on the system being tested so that you can test both sides at once. As for testing your application, AppScan by Sanctum is the only automated tool that I know of. I don't know if it works specifically with ColdFusion, http://www.sanctuminc.com/security/appscan/index.html. Steve -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 10:49 AM To: CF-Talk Subject: OT: intrusion/penetration tools I'm looking for any tools/utilities to test the security of my application/server, specifically against intrusion/penetration or other tricks (DOS, ping of death, etc). Any suggestions? -mike ~~ 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: Weird problem setting client variable
If you're storing client variables in cookies the cflocation will break them always. Change client variable storage to a datasource, use another way of re-locating or use a locked session variable would be my suggestions. HTH, Craig -Original Message- From: Perez, Bismark [mailto:[EMAIL PROTECTED]] Sent: 11 June 2001 16:03 To: CF-Talk Subject: Weird problem setting client variable I have the weirdest problem setting a client variable and for the live of me I can not see where the problem is. The problem is the following: I have a form where the user can change the language of the site, one of the fields on the form is a select box named NewLang, now, once the user selects the new language the form is posted to a template (ChangeLang.cfm) which only function is to cfset client.lang = newlang and then cflocation to the parent template. The first line in the application.cfm is to cfparam for client.lang and set it to en if is not defined, some how it is always set to en because client.lang is not defined. Now I know app.cfm is always executed, so before ChangeLang.cfm is executed the client.lang is set to en then the template is executed and client.lang is set to the new language and a redirection occurs to the parent template, client.lang should contain the new language, but is not because the cfparam resets it to en. Can somebody see where the problem is... TIA Bismarck Perez ~~ 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
KCfusion meeting tomorrow
Hey KCfusion and local CFUG'ers Tomorrow Girish Kshirsagar will give a presentation on how to estimate software costs in a project. He shared a little bit of it with me already and it looks very interesting. The meeting will start at 7:pm like always. You can find the meeting location and a map at http://www.kcfusion.org See you there Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ 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: Win2k Error -- Possible CF Crashing?
The browser was unable to retrieve a list of servers from the browser master \\SOMESERVER on the network etc... its usually a good idea to turn off computer browser service on all but your DC or RAS servers. cleared up a boat load of vodoo network problems for us. ~~ 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: all this email
I think there must be something wrong with your email address. It doesn't end in AOL.COM. hehe snicker snicker giggle giggle. :) -Original Message- From: Jason Santerre [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 2:22 PM To: CF-Talk Subject: all this email please stop sending me all this info... i'll search your site for it if i want it .. thank you.. 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
