RE: survey: locales on nt
date functions big time with dates like 01/07/2000. Becomming 07 Jan 2000 in some countries outside the USA However this may have been fixed since 4.5 now is upto a release of 4.5.1 sp2 I dont think it has: http://localhost/cfdocs/tagframe.cfm?tagname=LSDateFormat%0D%0A on Win2k, CF 4.5.1 sp2 shows no difference betwen US and UK locals for short format dates. ~~ 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: Counting members online.
http://www.cfm-resources.com/tutorials.cfm?Include=_currentvis itorstutorial. cfm ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'DATASERVER'. Date/Time: 05/14/01 05:11:18 Typical. ~~ 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: SQL 7.0 (checking for the existence of a table)
IF EXISTS (SELECT * FROM sysobjects WHERE name = tablename AND type = P) BEGIN Table exisits! END ELSE BEGIN table doesn't exist END -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 23:47 To: CF-Talk Subject: SQL 7.0 (checking for the existence of a table) Is it possible (without using a stored procedure) to check for the existence of a table in SQL 7.0? Thanks for the help. Brook Davies MaracasMedia Inc. ~~ 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: SQL 7.0 (checking for the existence of a table)
Sorry ...ignoree my last postthat was to test for the existence of an SP!replace type=P with type=U for a user table or type=S for a system table -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 10:11 To: CF-Talk Subject: RE: SQL 7.0 (checking for the existence of a table) IF EXISTS (SELECT * FROM sysobjects WHERE name = tablename AND type = P) BEGIN Table exisits! END ELSE BEGIN table doesn't exist END -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 23:47 To: CF-Talk Subject: SQL 7.0 (checking for the existence of a table) Is it possible (without using a stored procedure) to check for the existence of a table in SQL 7.0? Thanks for the help. Brook Davies MaracasMedia Inc. ~~ 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: survey: locales on nt
* Team Allaire * I dont think it has: http://localhost/cfdocs/tagframe.cfm?tagname=LSDateFormat%0D%0A on Win2k, CF 4.5.1 sp2 shows no difference betwen US and UK locals for short format dates. did you set the Locale? ~~ 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_DOWNLOAD -- need fix ASAP
Anyone successfully downloading files from server to client? We are running tests on Monday and help would be appreciated. I have a fix, but it is really horrable. IE has a problem with headers saying 'ask the user where to put this', and trys to sniff the datatype from the extension, resulting in it doing the wrong thing. In the end I used a tag that did the Right Thing for netscape, and some horrable kludge for IE invloving a popup window and javascript to close it again. Let me know off list if you want 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
Escaping Characters in a SQL Statement
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear all I have a column in a table which is of type long. After filtering for a set of records from this table, I want to write back this column into the table. This column is known to store HTML code (i.e. web pages). I only know the following characters have to be escaped: '/\. How do I write my SQL update statement such that all the possible nasty characters are escaped? Thanx. - Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547 E-Developer | novaSPRINT.com (S) Pte Ltd -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOv800RQsl2B8K+e4EQJESwCfZ2SI8q+08PB+uyc0NupPobAqFtMAni1E ubb4VP+NoPkiASiPK31PhpjD =WN/5 -END PGP SIGNATURE- ~~ 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
searching from memory?
I'm trying to develop an ultra-fast search engine. the search content is mostly html pages (that can be easily indexed into database/tables or reside as a bunch of txt files). is it possible to move the content to the server RAM somehow (via organized structers and/or some other way) and search from memory? I've also noticed Verity creates collection files, is it possible to somehow specify to verity to search from ram? Any pointers would be great!! Michael Lugassy ~~ 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
CF-Talk Archiver
I am currently putting the finishing touches on a small CF application that reads in email messages, in this case CF-Talk email, stores them in a database and makes the database searchable (via Verity). The final application will be able to do the same with any email address but hey CF-Talk deserves posterity so I wrote it for that purpose. The finished version will be postcardware, ie: send me a postcard and I will send you the full code via email. Cheers! PT ~~ 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
html/script/code stripper
I'm trying to locate the best html/script/cf/applet code stripper from html. I've checked the CF Gallery at allaire and found some intresting CustomTags but none of them are fast enough for large files. I'm intrested in a COM object or an ActiveX that I can run with param (file name) and that will do the job much much faster then CF. (C++/VB...) Have anyone came across this? my final task is to get a file or a variable containing all the TEXTUAL information in the coded html file: no scripts, no tags, no design.. just the actual text. 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: REWARD OFFERED
Deb Dickerson first diagnosed the problem I've been having, and earned $50. THANK YOU DEB! Thanks also to everyone who responded here and privately. Special thanks to [EMAIL PROTECTED] who tested my code on CF 5, found that the bug causing the problem is now fixed, and even loaded tested the app! Regards, Karl Simanonok Date: Sat, 12 May 2001 10:16:09 -0400 From: Deb Dickerson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: REWARD OFFERED Message-ID: [EMAIL PROTECTED] It's probably your partdetails.cfm template. It's using _range validation, which has a known bug that causes the exact error you're getting. Details are here: http://www.allaire.com/Handlers/index.cfm?ID=20622Method=Full Deb Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: was reward offered
This is a great idea. However. We are all struggling programmers, right? My alternative is this - within reason - check it out with the bosses first. It is not shareware or even commercial. It is postcardware. This means that if you send me a nice postcard from your end of this planet, I will in return send you full application code. Your postcard could be of, say, the Rocky Mountains - or if an Aussie, the Sydney Harbour Bridge, the Three Sisters, the Australian War Memorial, Uluru (Ayers Rock) or something like that. $2.00 for functional code sounds like a bargain! What do you think? ~~ 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
CFMakeTree
Dear all, Can I use cf_make_tree.dll in CF Linux version ? thanks mosos ~~ 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-Talk Archiver
Can you post your address so that we can send you postcards ? -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 10:54 To: CF-Talk Subject: CF-Talk Archiver I am currently putting the finishing touches on a small CF application that reads in email messages, in this case CF-Talk email, stores them in a database and makes the database searchable (via Verity). The final application will be able to do the same with any email address but hey CF-Talk deserves posterity so I wrote it for that purpose. The finished version will be postcardware, ie: send me a postcard and I will send you the full code via email. Cheers! PT ~~ 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
query error
Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01); This is the query that seems to be causing the problem: cfquery name=addthread datasource=#APPLICATION.chatdsn# INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); /cfquery Any ideas anyone? TIA Will ~~ 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: query error
Do You realy need the ; at the end of the Query? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 11:36 To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01); This is the query that seems to be causing the problem: cfquery name=addthread datasource=#APPLICATION.chatdsn# INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); /cfquery Any ideas anyone? TIA Will ~~ 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: query error
Possibly not.but its not generating the error. I still get it with or without the ; Cheers Will -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 12:40 To: CF-Talk Subject: RE: query error Do You realy need the ; at the end of the Query? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 11:36 To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01); This is the query that seems to be causing the problem: cfquery name=addthread datasource=#APPLICATION.chatdsn# INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); /cfquery Any ideas anyone? TIA Will ~~ 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: query error
This message is usually caused by a permissions problem with the database. Is it set to read-only? Also suggest making that thread_time field an ODBC date/time. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01); This is the query that seems to be causing the problem: cfquery name=addthread datasource=#APPLICATION.chatdsn# INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); /cfquery Any ideas anyone? TIA Will ~~ 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: query error
Is your OperaID an autonumber field perchance? Trying to insert a value into an autonumber field is not going to happen. Steve -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 12:36 To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01); This is the query that seems to be causing the problem: cfquery name=addthread datasource=#APPLICATION.chatdsn# INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES(#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); /cfquery Any ideas anyone? TIA Will ~~ 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: CFMakeTree
I mean, is there any cf_make_tree for Linux version ? -Original Message- From: Dian Oktosoma Sent: Monday, May 14, 2001 6:10 PM To: CF-Talk Subject: CFMakeTree Dear all, Can I use cf_make_tree.dll in CF Linux version ? thanks mosos ~~ 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: Escaping Characters in a SQL Statement
If you want to store store html in a text field in the db, you don't need to do anything if you use the cfquery tag. HTH Dick At 5:28 PM +0800 5/14/01, Teng-Yan Loke wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear all I have a column in a table which is of type long. After filtering for a set of records from this table, I want to write back this column into the table. This column is known to store HTML code (i.e. web pages). I only know the following characters have to be escaped: '/\. How do I write my SQL update statement such that all the possible nasty characters are escaped? Thanx. ~~ 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: query error
I seem to have figured this out, in case anyone is interested. It is due to a weird permissions issue with Win2000. BAsically, the folder that the DB was in had full permissions set to 'Everyone', but I had to add the system profile to this as well, as obviously as far as Win2000 is concerned,, everyone is not everyone Cheers Will -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 12:36 To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01); This is the query that seems to be causing the problem: cfquery name=addthread datasource=#APPLICATION.chatdsn# INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); /cfquery Any ideas anyone? TIA Will ~~ 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
Mime types
I've got this piece of code to limit the the type of file that is uploaded, but it doesn't seem to work, it still allows you to upload files of a different type. Any suggestions? cffile action=UPLOAD filefield=UploadFile destination=#GetTempDirectory()# nameconflict=MAKEUNIQUE accept=text/html Darren Daniel Producer -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 419 4235 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~~ 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: Mime types
So it's not just me! Try using the same accept value in your input type='file' tag. -David On Monday, May 14, 2001 5:42 AM, Darren Daniel [SMTP:[EMAIL PROTECTED]] wrote: I've got this piece of code to limit the the type of file that is uploaded, but it doesn't seem to work, it still allows you to upload files of a different type. Any suggestions? cffile action=UPLOAD filefield=UploadFile destination=#GetTempDirectory()# nameconflict=MAKEUNIQUE accept=text/html ~~ 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: Slightly OT: Form Validation Woes
Matthew, Check out qForms: http://www.pengoworks.com/qForms/ It will greatly simplify creating client-side validation. You don't need to be a JavaScript wizard, if can program in CF, you should be able to use the qForms API with no problems. It's also *much* more powerful than the built-in CFFORM validation in CF. -Dan -Original Message- From: Matthew Hood [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 12, 2001 5:44 PM To: CF-Talk Subject: Slightly OT: Form Validation Woes Ok, here is the problem: I have various sets of radio buttons on a page. 4 sets to a page actually. I need a javascript that will validate that a radio button has been selected for each of the four sets. Being no good a javascript I am turning to you for help. ( I know this isn't a cold fusion question per say but the values are entered into a DB when all is said and done.) Is there a script that can run through each set and verify that a selection has been made, without having to manually edit the script for each page and inputting the names? Here is a what the radio buttons look like: TD cfinput type=Radio name=WPAvailability value=5 tabindex=15br cfinput type=Radio name=WPAvailability value=4 tabindex=24br cfinput type=Radio name=WPAvailability value=3 tabindex=33br cfinput type=Radio name=WPAvailability value=2 tabindex=42br cfinput type=Radio name=WPAvailability value=1 tabindex=51br cfinput type=Radio name=WPAvailability value=0 tabindex=6N/A /TD TD cfinput type=Radio name=WPProficiency value=5 tabindex=15br cfinput type=Radio name=WPProficiency value=4 tabindex=24br cfinput type=Radio name=WPProficiency value=3 tabindex=33br cfinput type=Radio name=WPProficiency value=2 tabindex=42br cfinput type=Radio name=WPProficiency value=1 tabindex=51br cfinput type=Radio name=WPProficiency value=0 tabindex=6N/A /TD TD cfinput type=Radio name=WPImportance value=5 tabindex=15br cfinput type=Radio name=WPImportance value=4 tabindex=24br cfinput type=Radio name=WPImportance value=3 tabindex=33br cfinput type=Radio name=WPImportance value=2 tabindex=42br cfinput type=Radio name=WPImportance value=1 tabindex=51br cfinput type=Radio name=WPImportance value=0 tabindex=6N/A /TD TD cfinput type=Radio name=WPFrequency value=5 tabindex=15br cfinput type=Radio name=WPFrequency value=4 tabindex=24br cfinput type=Radio name=WPFrequency value=3 tabindex=33br cfinput type=Radio name=WPFrequency value=2 tabindex=42br cfinput type=Radio name=WPFrequency value=1 tabindex=51br cfinput type=Radio name=WPFrequency value=0 tabindex=6N/A /TD Any help would be GREATLY appreciated! Thanks. Matthew Hood ~~ 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
CF stuy guide (was:New Cold Fusion book, O'riely Press)
Am i right in saying that the certification study guide only covers 4.5? When does coldfusion 5 certification come into effect? Thanks KOla -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 18:27 To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:11 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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:RE: CF_DOWNLOAD -- need fix ASAP
Please tell me who you are and I'll contact off line. Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:RE: CF_DOWNLOAD -- need fix ASAP Author: [EMAIL PROTECTED] Date: 5/14/01 2:24 AM Anyone successfully downloading files from server to client? We are running tests on Monday and help would be appreciated. I have a fix, but it is really horrable. IE has a problem with headers saying 'ask the user where to put this', and trys to sniff the datatype from the extension, resulting in it doing the wrong thing. In the end I used a tag that did the Right Thing for netscape, and some horrable kludge for IE invloving a popup window and javascript to close it again. Let me know off list if you want 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
Re: [CF-Talk Archiver]
Doesn't CF-Talk already archive the emails? Peter Tilbrook [EMAIL PROTECTED] wrote: I am currently putting the finishing touches on a small CF application that reads in email messages, in this case CF-Talk email, stores them in a database and makes the database searchable (via Verity). The final application will be able to do the same with any email address but hey CF-Talk deserves posterity so I wrote it for that purpose. The finished version will be postcardware, ie: send me a postcard and I will send you the full code via email. Cheers! PT ~~ 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: Session/Application Locking
Would be grateful... Thanks KOla -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 16:55 To: CF-Talk Subject: RE: Session/Application Locking Thank you and my apologies to all on the list, the attachment is only 21kb, if anyone wants it, please let me know. Kind Regards - Mike Brunt -Original Message- From: ibtoad To: CF-Talk Sent: 5/13/01 11:46 AM Subject: RE: Session/Application Locking Attachments don't work on this list. Rich -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 11:23 AM To: CF-Talk Subject: RE: Session/Application Locking I have attached an article by Jim Schley of Macromedia which gives a good explanantion of locking. There is also a paper by Ben Forta. Hope this helps. Kind Regards - Mike Brunt Macromedia Consulting -Original Message- From: Michael Lugassy To: CF-Talk Sent: 5/13/01 5:48 AM Subject: Session/Application Locking Hi, can someone please explain how can I lock session/application/other shared variables in order NOT to lose them? I know there is a timeout and/or readonly attribute but I can't seem to understand what to use and where. if you can clarify, I would be more then grateful. BTW: I don't want to use CF automatic lock. 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: [CF-Talk Archiver]
Yes .. observe the bottom of every E-mail ;) | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ I don't like the format all that much; maybe this new one is better? :) Todd - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 9:43 AM Subject: Re: [CF-Talk Archiver] | Doesn't CF-Talk already archive the emails? | | Peter Tilbrook [EMAIL PROTECTED] wrote: | I am currently putting the finishing touches on a small CF application | that reads in email messages, in this case CF-Talk email, stores them in a | database and makes the database searchable (via Verity). | | The final application will be able to do the same with any email address | but hey CF-Talk deserves posterity so I wrote it for that purpose. | | The finished version will be postcardware, ie: send me a postcard and I | will send you the full code via email. | | Cheers! | | PT | ~~ 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
Going bonkers with an Update in table
This is beginning to drive me bananas. This is a repost that I'm hoping someone can help with. I am trying to do an update query on a table-it keeps updating only the first column of the table- with all the data updating in just that one field! Although the table seems set up correctly (ie: the Id number that I want updated shows up correctly- until you run the update query. For example my table displays like so: #Skill# #ID##Semester##Grade# #ID# #Semester##Grade# Reads 1 A4 B Writes 2 A5 A Spells 3 B6 B If I run the update query it'll put everything into ID 1 field (A, A, B, B, A, B) My code is as follows: !---Query used to populate table--- CFQUERY NAME=GetSubjects DATASOURCE=#Request.maindsn# SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID, tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject, tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor, tbl_StudentGrade.GradingPeriod, tbl_StudentGrade.PERMNUM FROM tbl_CourseSkill, tbl_StudentGrade WHERE tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=1 OR tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=2 Order BY tbl_StudentGrade.SkillID, GradingPeriod /CFQUERY !---Put grades into table TABLE CFOUTPUT QUERY=GetSubjects GROUP=SkillID TR TD COLSPAN=2#Skill#/TD CFOUTPUT TD CFIF Val(GetSubjects.GradeForSubject)#GetSubjects.GradeForSubject# CFELSEINPUT NAME=GradeForSubject VALUE=#GradeForSubject# SIZE=4 /CFIF /TD /CFOUTPUT /TR INPUT TYPE=Hidden NAME=SkillID VALUE=#SkillID# INPUT TYPE=Hidden NAME=GradesID VALUE=#GradesID# INPUT TYPE=Hidden NAME=PERMNUM VALUE=#PERMNUM# INPUT TYPE=Hidden NAME=GradeForSubject VALUE=#GradeForSubject# /CFOUTPUT /TABLE !---Update query to update grades--- CFQUERY NAME=EditGrades DATASOURCE=#Request.maindsn# UPDATE tbl_StudentGrade SET GradeForSubject='#trim(GradeForSubject)#' WHERE GradesID=#Val(GradesID)# /CFQUERY Are there any ideas about what I need to do differently? Thanks in advance for the help. j Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
[Re:] RE: oracle LOB query problem
I read this article and it is talking about CF settings button in the DSN setting screen. I logged onto my CF server administrator and could not find the DSN setting screen. Anyone knows where and how to do the setting ? thanks On Sun, 13 May 2001 13:48:15 -0700 David Shadovitz wrote: You may want to read KB article 16259, Best Practice: Enabling Retrieval of Long Text Fields with CF 4.5, http://www.allaire.com/Handlers/index.cfm?ID=16259Method=Full -David On Friday, May 11, 2001 9:31 AM, FARRAH NG [SMTP:[EMAIL PROTECTED]] wrote: I have defined a column as CLOB in an oracle 8i table and when CF return Unknown Data Access Error when i do an query on this table. If i remove the CLOB column from the table the query works fine. ~~ 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
Way OT:Java Mailing Lists
Hi All, Can anybody recommend a good JAVA Mailing list like CF-Talk. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ 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: Session/Application Locking
Mike, I would be pleased if you sent a copy to me [EMAIL PROTECTED] Thanks From: Kola Oyedeji [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Session/Application Locking Date: Mon, 14 May 2001 14:49:13 +0100 Would be grateful... Thanks KOla -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 16:55 To: CF-Talk Subject: RE: Session/Application Locking Thank you and my apologies to all on the list, the attachment is only 21kb, if anyone wants it, please let me know. Kind Regards - Mike Brunt -Original Message- From: ibtoad To: CF-Talk Sent: 5/13/01 11:46 AM Subject: RE: Session/Application Locking Attachments don't work on this list. Rich -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 11:23 AM To: CF-Talk Subject: RE: Session/Application Locking I have attached an article by Jim Schley of Macromedia which gives a good explanantion of locking. There is also a paper by Ben Forta. Hope this helps. Kind Regards - Mike Brunt Macromedia Consulting -Original Message- From: Michael Lugassy To: CF-Talk Sent: 5/13/01 5:48 AM Subject: Session/Application Locking Hi, can someone please explain how can I lock session/application/other shared variables in order NOT to lose them? I know there is a timeout and/or readonly attribute but I can't seem to understand what to use and where. if you can clarify, I would be more then grateful. BTW: I don't want to use CF automatic lock. 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: [CF-Talk Archiver]
On Mon, 14 May 2001 08:43:28 CDT, Alex [EMAIL PROTECTED] wrote: Doesn't CF-Talk already archive the emails? Yes, but unfortunately some of us occasionally have to go offline. Yes, I know, it sucks, but a sad fact of life :) I think a client side app would be great - searching would be much faster than loading up the online archive. I currently read CF-Talk through Agent (the icky newsreader) from the fuseware NNTP mirror. I am working on a little program to parse the Agent file format and dump the messages into a database. If someone can make available their archives in a format Peter's application can read, I may not have to bother finishing it. Anyone? Peter, I would love to send you a postcard... but good ole Perth is not too exciting :) K. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Tools for developers: http://developer.perthweb.com.au -- cfx_pwimageproc: image processing tool -- cfx_pwcardcrypt: credit card validation and encryption Peter Tilbrook [EMAIL PROTECTED] wrote: I am currently putting the finishing touches on a small CF application that reads in email messages, in this case CF-Talk email, stores them in a database and makes the database searchable (via Verity). The final application will be able to do the same with any email address but hey CF-Talk deserves posterity so I wrote it for that purpose. The finished version will be postcardware, ie: send me a postcard and I will send you the full code via email. Cheers! PT Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: structure in request scope
I guess you missed the part about the query being cached. best, paul At 06:54 PM 5/13/01 -0400, you wrote: Problem is, then every page request you are running the query, which takes longer than to copy the recordset from the shared-server scope. your way runs the danger of negating some of the time you would save by creating the query in the shared scope. |-Original Message- |From: Paul Smith [mailto:[EMAIL PROTECTED]] |Sent: Friday, May 11, 2001 9:50 AM |To: CF-Talk |Subject: RE: structure in request scope | | |I find it easier and simpler to put the query in request scope |in the first |place (not really necessary) and cache it. That way, none of |the below is |necessary. | |best, paul | |At 09:27 AM 5/11/01 -0400, you wrote: |And to wrap it all up | |You want to write the query in a persistent scope. But since |every time you |write to or access a persistent scope you must lock the |access, you want to |copy the query to the request scope in the application.cfm. |This way you |will only nead to bother with the locking process when |creating the query |and copying to the request scope. Everywhere else in your |site you'll call |the request variable to access the query info... and you |won't have to use a |lock. | |so your application.cfm would look something like this. | |!--- Create the query in a persistent scope --- |cflock scope=APPLICATION throwontimeout=No timeout=1 |type=EXCLUSIVE | cfif NOT isdefined(application.myquery) | cfquery name=application.myquery |datasource=mydsn | [SQL Stuff] | /cfquery | /cfif |/cflock | |!--- Copy the query to the request scope --- |cflock scope=APPLICATION throwontimeout=No timeout=1 |type=READONLY | cfset request.myquery = duplicate(application.myquery) |/cflock | ||-Original Message- ||From: Sean Daniels [mailto:[EMAIL PROTECTED]] ||Sent: Thursday, May 10, 2001 10:54 AM ||To: CF-Talk ||Subject: Re: structure in request scope || || ||On 5/10/01 1:59 AM Mark Ireland wrote: || || Could someone tell me how to load a structure into the ||request scope in the || application.cfm || || once only when a user first visits a page. That is, check that the || structure is there and dont rerun the query code if it is || || unless a change has been made to the database. || ||It sounds like you want to put the structure into a persistent ||scope, which ||request is not. Use the application scope instead if it is ||global to all ||users. If not, client or session scope. || ||cfif isdefined(application.strFoo) ||cflock type=exclusive scope=application name=strLock ||cfset application.strFoo = structnew() ||!--- etc --- ||/cflock ||/cfif || || ||- Sean || | | ~~ 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: ] RE: oracle LOB query problem
I read this article and it is talking about CF settings button in the DSN setting screen. I logged onto my CF server administrator and could not find the DSN setting screen. Anyone knows where and how to do the setting ? The DSN setting screen is what you see when you edit any one of your data sources in the CF Administrator. For example, if it's an ODBC data source, you select ODBC from the left menu bar, then you click on the appropriate data source. You'll then see the DSN setting screen for that data source. At the bottom, you'll see a button labeled CF Settings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Going bonkers with an Update in table
First thing to note is the where clause in your select statement. I'm don't think it's doing what you want as you have and's and or's with no brackets seperating them. I'd suggest that in your where clause you only put conditional values and not links between tables. For links between tables (like tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID) use the JOIN syntax (INNER, LEFT OUTER, etc...)it's much safer and indeed the accepted correct way to join tables. What I suggest you do first of all is to run the select statement by itself within the db and make sure you get back what you expect. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 14:59 To: CF-Talk Subject: Going bonkers with an Update in table This is beginning to drive me bananas. This is a repost that I'm hoping someone can help with. I am trying to do an update query on a table-it keeps updating only the first column of the table- with all the data updating in just that one field! Although the table seems set up correctly (ie: the Id number that I want updated shows up correctly- until you run the update query. For example my table displays like so: #Skill# #ID##Semester##Grade# #ID# #Semester##Grade# Reads 1 A4 B Writes 2 A5 A Spells 3 B6 B If I run the update query it'll put everything into ID 1 field (A, A, B, B, A, B) My code is as follows: !---Query used to populate table--- CFQUERY NAME=GetSubjects DATASOURCE=#Request.maindsn# SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID, tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject, tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor, tbl_StudentGrade.GradingPeriod, tbl_StudentGrade.PERMNUM FROM tbl_CourseSkill, tbl_StudentGrade WHERE tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=1 OR tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=2 Order BY tbl_StudentGrade.SkillID, GradingPeriod /CFQUERY !---Put grades into table TABLE CFOUTPUT QUERY=GetSubjects GROUP=SkillID TR TD COLSPAN=2#Skill#/TD CFOUTPUT TD CFIF Val(GetSubjects.GradeForSubject)#GetSubjects.GradeForSubject# CFELSEINPUT NAME=GradeForSubject VALUE=#GradeForSubject# SIZE=4 /CFIF /TD /CFOUTPUT /TR INPUT TYPE=Hidden NAME=SkillID VALUE=#SkillID# INPUT TYPE=Hidden NAME=GradesID VALUE=#GradesID# INPUT TYPE=Hidden NAME=PERMNUM VALUE=#PERMNUM# INPUT TYPE=Hidden NAME=GradeForSubject VALUE=#GradeForSubject# /CFOUTPUT /TABLE !---Update query to update grades--- CFQUERY NAME=EditGrades DATASOURCE=#Request.maindsn# UPDATE tbl_StudentGrade SET GradeForSubject='#trim(GradeForSubject)#' WHERE GradesID=#Val(GradesID)# /CFQUERY Are there any ideas about what I need to do differently? Thanks in advance for the help. j 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
RE: CF_DOWNLOAD -- need fix ASAP
i'm not sure what the original request was, but if what you want to do is force the browser to open a save as dialog instead of try to display the file in the browser, Fig Leaf has some code on their site explaining how to force a download with the header info. maybe dave can post the URL again or you can email him and ask. DB -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:25 AM To: CF-Talk Subject: RE: CF_DOWNLOAD -- need fix ASAP Anyone successfully downloading files from server to client? We are running tests on Monday and help would be appreciated. I have a fix, but it is really horrable. IE has a problem with headers saying 'ask the user where to put this', and trys to sniff the datatype from the extension, resulting in it doing the wrong thing. In the end I used a tag that did the Right Thing for netscape, and some horrable kludge for IE invloving a popup window and javascript to close it again. Let me know off list if you want 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
Does application tag need to be executed every time?
I have this code in my application tag: cfif NOT isDefined(application.name) cfapplication name=myapp sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# cfset application.name=myapp /cfif All the session/application vars seem to be fine Does the application tag have to be executed on every page request? If so why? Thanks KOla ~~ 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
Fusebox for ASP using Javascript?
Hi all, My company is about to embark on a large project using ASP, and are considering using Fusebox, as I use it in CF. We have a lot of Javascript talent in house, so will be using that rather than VBScript (am I the only one who equates VBScript with VB, the ickiest pogramming language ever?). I have looked through the Fusebox ASP white paper (http://aloha-webdesign.com/dloads/asp/aspfusebox.htm) and I notice it uses VBScript. I know it's not hard to substitute Javascript in the code examples, and I know it's a bit of a reach on this list, but is there anyone out there using Fusebox for Javascript ASP who would like to share their experiences? Any language specific things to watch out for? Thanks, K. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Tools for developers: http://developer.perthweb.com.au -- cfx_pwimageproc: image processing tool -- cfx_pwcardcrypt: credit card validation and encryption Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Harpoon Release is Final Available
We are happy to announce the availability of The Macromedia Flash Component Kit for ColdFusion. The kit, first announced in November 2000 under the code name 'Harpoon', is now available for download from the ColdFusion Developers Exchange. The Macromedia Flash Component Kit for ColdFusion is a resource for ColdFusion developers to quickly and easily add Macromedia Flash elements to their Web applications. ColdFusion developers can immediately take advantage of the design and delivery benefits of Macromedia Flash and Macromedia Flash Player without learning a new authoring product. For more advanced developers, the Component Kit provides guidelines and documentation for creating and customizing new Macromedia Flash components for ColdFusion that can be shared with other developers. The Component Kit includes 4 prebuilt Macromedia Flash sample components, guidelines detailing how to use and customize components and ColdFusion custom tags that control the behavior of those components. The four Macromedia Flash sample components included with the kit are: *Calendar *Calculator *Horizontal Menu *Cascading Menu (for Microsoft Internet Explorer) The Component Kit is available for free download from the Allaire Developers Exchange for the Windows and UNIX platforms. To access the components, type Macromedia Flash into the Developers Exchange Search window (http://devex.allaire.com/developer/gallery/index.cfm) or visit the following page to link directly to the kit: http://www.allaire.com/handlers/index.cfm?ID=20983 The FAQ and license agreements are also available on this page. Best, -Sam ~~ 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: Forced logout
I would try something like this: BODY ONUNLOAD=javascript:redirectToLogout(); the redirectToLogout() would use a location to send the page to a CFM page to do the logout and then another script to close the current window. Terry Bader IT/Web Specialist Macromedia Certified Coldfusion Developer EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 8:32 AM To: CF-Talk Subject: Forced logout How can I use javascript to make a member logout if they go to a different web site? Is this possible to do with javascript. Sebastian ~~ 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: structure in request scope
Yup. Was part of a different message, though. shrug it's all good. |-Original Message- | |I guess you missed the part about the query being cached. | |best, paul | ~~ 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: Going bonkers with an Update in table
Had to guess at some of this: From the cfoutput query=GetSubjects... loop, it looks as if you are expecting to retrieve more than 1 row with your query and store the retrieved elements in FORMname lists. But the update query *isn't* in a loop, and you aren't doing anything like GetToken or ListGetAt, so updates the row with the entire list. ?? - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 9:58 AM Subject: Going bonkers with an Update in table This is beginning to drive me bananas. This is a repost that I'm hoping someone can help with. I am trying to do an update query on a table-it keeps updating only the first column of the table- with all the data updating in just that one field! Although the table seems set up correctly (ie: the Id number that I want updated shows up correctly- until you run the update query. For example my table displays like so: #Skill# #ID# #Semester##Grade# #ID# #Semester##Grade# Reads 1A 4 B Writes 2A 5 A Spells 3B 6 B If I run the update query it'll put everything into ID 1 field (A, A, B, B, A, B) My code is as follows: !---Query used to populate table--- CFQUERY NAME=GetSubjects DATASOURCE=#Request.maindsn# SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID, tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject, tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor, tbl_StudentGrade.GradingPeriod, tbl_StudentGrade.PERMNUM FROM tbl_CourseSkill, tbl_StudentGrade WHERE tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=1 OR tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=2 Order BY tbl_StudentGrade.SkillID, GradingPeriod /CFQUERY !---Put grades into table TABLE CFOUTPUT QUERY=GetSubjects GROUP=SkillID TR TD COLSPAN=2#Skill#/TD CFOUTPUT TD CFIF Val(GetSubjects.GradeForSubject)#GetSubjects.GradeForSubject# CFELSEINPUT NAME=GradeForSubject VALUE=#GradeForSubject# SIZE=4 /CFIF /TD /CFOUTPUT /TR INPUT TYPE=Hidden NAME=SkillID VALUE=#SkillID# INPUT TYPE=Hidden NAME=GradesID VALUE=#GradesID# INPUT TYPE=Hidden NAME=PERMNUM VALUE=#PERMNUM# INPUT TYPE=Hidden NAME=GradeForSubject VALUE=#GradeForSubject# /CFOUTPUT /TABLE !---Update query to update grades--- CFQUERY NAME=EditGrades DATASOURCE=#Request.maindsn# UPDATE tbl_StudentGrade SET GradeForSubject='#trim(GradeForSubject)#' WHERE GradesID=#Val(GradesID)# /CFQUERY Are there any ideas about what I need to do differently? Thanks in advance for the help. j 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
Re: Forced logout
I bet you could spawn a new window that calls template to log them out and closes onload. - BILL - - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 13, 2001 3:48 PM Subject: Re: Forced logout You can't. Well, maybe you could be annoying to the point that they'd want to log out, but in reality you cannot MAKE them log out. The way to log somebody out is to use a inactivity timeout for their session and when they've been inactive for longer than this time, you consider them logged out. If you use CF session management to handle the login, then this is pretty much taken care of. Just set the specific time period in your CFAPPLICATION tag's SESSIONTIMEOUT attribute, or else use the default time period set at the CF server level. Jim - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 13, 2001 6:31 AM Subject: Forced logout How can I use javascript to make a member logout if they go to a different web site? Is this possible to do with javascript. Sebastian ~~ 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_DOWNLOAD -- need fix ASAP
force a download with the header info. maybe dave can post the URL again or you can email him and ask. Really ? IE has a bug in its header reading bits :-) http://support.microsoft.com/support/kb/articles/Q279/6/67.ASP?LN=EN-USSD=g nFR=0qry=force%20downloadrnk=8src=DHCS_MSPSS_gn_SRCHSPR=IEP Dave, if you could post the URL to your code, that would be great ! ~~ 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
Verify Address
Does anybody have a good block of code in CF, SQL, or even ASP that will verify an address against the post office data? I have the Post Office Data. Any help would be greatly appreciated. I am open to commercial products as well ~~ 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: [Re: [CF-Talk Archiver]]
Oh. I never noticed the stuff on the bottom of these emails before. Thanks. Todd Ashworth [EMAIL PROTECTED] wrote: Yes .. observe the bottom of every E-mail ;) | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ I don't like the format all that much; maybe this new one is better? :) Todd - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 9:43 AM Subject: Re: [CF-Talk Archiver] | Doesn't CF-Talk already archive the emails? | | Peter Tilbrook [EMAIL PROTECTED] wrote: | I am currently putting the finishing touches on a small CF application | that reads in email messages, in this case CF-Talk email, stores them in a | database and makes the database searchable (via Verity). | | The final application will be able to do the same with any email address | but hey CF-Talk deserves posterity so I wrote it for that purpose. | | The finished version will be postcardware, ie: send me a postcard and I | will send you the full code via email. | | Cheers! | | PT | ~~ 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: Verify Address
USPS Validator in the DEV Exchange kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 7:53 AM To: CF-Talk Subject: Verify Address Does anybody have a good block of code in CF, SQL, or even ASP that will verify an address against the post office data? I have the Post Office Data. Any help would be greatly appreciated. I am open to commercial products as well ~~ 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
CF on unix restarts
I have CF4.5 with updates running on solaris and it restarts about every 10 minutes. I have read this problem before but have not seen a resolution. Anyone here know how to fix this? ~~ 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_DOWNLOAD -- need fix ASAP
force a download with the header info. maybe dave can post the URL again or you can email him and ask. Really ? IE has a bug in its header reading bits :-) http://support.microsoft.com/support/kb/articles/Q279/6/67.ASP ?LN=EN-USSD=gnFR=0qry=force%20downloadrnk=8src=DHCS_MSPSS _gn_SRCHSPR=IEP Dave, if you could post the URL to your code, that would be great! I think the problem you mention is limited to IE 5.5. In any case, my code uses inline vs attachment, which seems to work with IE 5.5, and still forces a download for file types for which there isn't a registered MIME handler. The URL is: http://www.figleaf.com/demo/mimetest/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ftp to novell
I am trying to ftp to a novell server and am not having the best of luck. I can get the currect directroy to return sys: which is right. When I try to listdir of a direcotyr called crsapps I get nothing. I have tried /crsapps, crsapps. crsapps/*.* and get nothing. Is there a trick to novell? Joshua Tipton cfftp connection=ftp username=crsser password=crsser server=10.66.64.52 action=open stoponerror=yes cfftp action=GETCURRENTDIR stoponerror=Yes connection=ftp cfoutput#cfftp.returnvalue#/cfoutput cfftp connection=ftp action=listdir directory=/crsapps name=q stoponerror=yes cftable query=q htmltable cfcol header=bname/b text=#name# /cftable ~~ 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
best search
what will be the best option for searching on text based content: 1. insert content into database, search using SQL statments 2. insert content into database, search using VERITY queried collections 3. VERITY search, collections will search directly on 1000s of txt files 4. Microsoft TextSearch Engine 5. SQL Full Text Search Any help, please.. -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:] RE: ] RE: oracle LOB query problem
dave, thank you. I have enable the long text retrieval setting but i am still getting the SQL error Data Access Error Unknown Data Access Error. from the CF server when it runs the CF query in my action page. My query is very simple, as follow select Cust_Info from company where Cust_id = 10; Cust_info is defined as a CLOB in the oracle table Company. thanks On Mon, 14 May 2001 10:12:02 -0400 Dave Watts wrote: I read this article and it is talking about CF settings button in the DSN setting screen. I logged onto my CF server administrator and could not find the DSN setting screen. Anyone knows where and how to do the setting ? The DSN setting screen is what you see when you edit any one of your data sources in the CF Administrator. For example, if it's an ODBC data source, you select ODBC from the left menu bar, then you click on the appropriate data source. You'll then see the DSN setting screen for that data source. At the bottom, you'll see a button labeled CF Settings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.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
CF function to manipulate a date
Hello, I have a date field(myDate) in mm format. I want to compare it to a another year field and to another month field. How do I string out myDate inorder to seperate the mm and section of it so I can compare each section to a seperate month and year. Thanks, Julie ~~ 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
Access database question: how to structure a link between two tables
hi, i've created a database to handle an insurance form which deals with the insurance of money. it has a number of different tables such as 'cust', which lists details of customers, 'prem', which lists details of where the money is stored, and 'safe' which lists details of the safes in which the money is stored. the tables 'safe' and 'prem' relate to each other, in that a premises may have one or more safes, and one type of safe may be used in more than one premises. another way of putting it is that each safe could have 1 or more premises that match to it each premises could have 1 or more safes that match to it, with a maximum number of 3 safes or premises. what structure should i use for the link between the two tables? sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ 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: best search
Michael, In my experience, I have played with Verity and Full Text searching. It really depends on what you are wanting to search and how much flexibility you are wanting to provide. Verity is very good when it comes to things like searching .txt, .htm, .cfm, ..doc and .pdf files. I think CF 5's version of verity throws in .ppt (Power Point Presentation) and some other file types. The downside of verity is the fact that you have to update the collection any time you modify one file or database entry. When I built a search recently, I incorporated CFX_Spell and Verity along with some massaging of the search field. HTH Hatton Humphrey -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:45 PM To: CF-Talk Subject: best search what will be the best option for searching on text based content: 1. insert content into database, search using SQL statements 2. insert content into database, search using VERITY queried collections 3. VERITY search, collections will search directly on 1000s of txt files 4. Microsoft Text Search Engine 5. SQL Full Text Search Any help, please.. -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: best search
* Team Allaire * 5. SQL Full Text Search buys you off cf processing, cached queries, more languages than verity, ORDER BYs, JOINs, and beer when you need 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
RE: CF function to manipulate a date
YOu could use CFSET Monthpart = #Left(DateField,2)# CFSET Yearpart = #Right(DateField,4)# Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:54 AM To: CF-Talk Subject: CF function to manipulate a date Hello, I have a date field(myDate) in mm format. I want to compare it to a another year field and to another month field. How do I string out myDate inorder to seperate the mm and section of it so I can compare each section to a seperate month and year. Thanks, Julie ~~ 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: Access database question: how to structure a link between tw o tables
i've created a database to handle an insurance form which deals with the insurance of money. it has a number of different tables such as 'cust', which lists details of customers, 'prem', which lists details of where the money is stored, and 'safe' which lists details of the safes in which the money is stored. the tables 'safe' and 'prem' relate to each other, in that a premises may have one or more safes, and one type of safe may be used in more than one premises. another way of putting it is that each safe could have 1 or more premises that match to it each premises could have 1 or more safes that match to it, with a maximum number of 3 safes or premises. what structure should i use for the link between the two tables? You have what is called a many-to-many relationship. There's no way to directly represent a many-to-many relationship in a relational database, so you'll need to create a table for this purpose. This table, called a linking table or an intersection table, should contain the primary key columns from each of the other two tables, and should be related to each of those tables using a one-to-many relationship; one record from each table can have many matches within the linking table. As a primary key, the linking table should use the two foreign keys together - a composite primary key. In Access, you can create these relationships using the Relationship window, once you've created the linking table. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: best search
It really depends on how your content is being displayed - if it's flat-file then Verity is OK - if it's a combination of SQL and Verity then pass your query through both database and verity, if it's all sql held then rely on sql/verity collections (faster than plain sql requests), however database searches will depend on how often the data is to be updated. A quick rule we use for template based sites is verity index the flat file content, then build a link database with file names and page titles in which is used to display the url links to the content (your option 2). However, saying the above the main downfall of Verity is that it takes a f*** load of time to index large amount of pages and the collections can become corrupt - so it may be worthwhile using something else completely different (AltaVista supply a free search engine as do Lycos and Atomz). What you have to remember is Verity with CF is a lite version and as such is not too hot on larger sites. As a rule of thumb use the right tool for the job, don't just use a tool because it is there. J The Force is strong in this one... - Darth Vader -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 17:45 To: CF-Talk Subject: best search what will be the best option for searching on text based content: 1. insert content into database, search using SQL statments 2. insert content into database, search using VERITY queried collections 3. VERITY search, collections will search directly on 1000s of txt files 4. Microsoft TextSearch Engine 5. SQL Full Text Search Any help, please.. -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: CF function to manipulate a date
Use something like: cfset myMonth = #lsdateformat(myDate, mm)# cfset myYear = #lsdateformat(myDate, )# Then use the two vars myMonth and myYear to compare. I guess James -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 16:54 To: CF-Talk Subject: CF function to manipulate a date Hello, I have a date field(myDate) in mm format. I want to compare it to a another year field and to another month field. How do I string out myDate inorder to seperate the mm and section of it so I can compare each section to a seperate month and year. Thanks, Julie ~~ 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 function to manipulate a date
In CF you could use the DateFormat() function and put a mask of just mm or for each of the compares. In SQL you could use the Month() and Year() functions for the respective compares. Hope that helps J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Losing - If at first you don't succeed, failure may be your style. ~despair.com -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 8:54 AM To: CF-Talk Subject: CF function to manipulate a date Hello, I have a date field(myDate) in mm format. I want to compare it to a another year field and to another month field. How do I string out myDate inorder to seperate the mm and section of it so I can compare each section to a seperate month and year. Thanks, Julie ~~ 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: Access database question: how to structure a link between tw o tables
Hi Hubert, If I understand you correctly, you have a many-to-many relationship. Another example of this is college classes and students -- a student may be enrolled in a number of classes a class has a number of students enrolled so you have many-to-many, unlike say an invoice which is one-to-many: one invoice, many line items. Access (and other databases) handle many-to-many by having a linking table in between. The linking table contains pairs of keys (pointers) to the main data tables. An example in the college metaphor: You have a student named Fred, id 123456. You have a class named Chemistry 101, id CHEM101. You have a record in the link table where Student_ID = 123456 and Class_ID = CHEM101. HTH. BTW, look up many-to-many relationships in Access help. Ben -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 7:56 AM To: CF-Talk Subject: Access database question: how to structure a link between two tables hi, i've created a database to handle an insurance form which deals with the insurance of money. it has a number of different tables such as 'cust', which lists details of customers, 'prem', which lists details of where the money is stored, and 'safe' which lists details of the safes in which the money is stored. the tables 'safe' and 'prem' relate to each other, in that a premises may have one or more safes, and one type of safe may be used in more than one premises. another way of putting it is that each safe could have 1 or more premises that match to it each premises could have 1 or more safes that match to it, with a maximum number of 3 safes or premises. what structure should i use for the link between the two tables? sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ 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: Harpoon Release is Final Available
I seem to remember that in some of the early betas for Harpoon there was an actionscript file for reading WDDX packets in Flash. Did this disappear? Or did it simply become subsumed into some of the FLA's. If the latter is true, could someone point me to the right place to find it? If it's gone, is there a reason? Thanks, Evan -Original Message- From: Sam Coe [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:29 AM To: CF-Talk Subject: Harpoon Release is Final Available We are happy to announce the availability of The Macromedia Flash Component Kit for ColdFusion. The kit, first announced in November 2000 under the code name 'Harpoon', is now available for download from the ColdFusion Developers Exchange. The Macromedia Flash Component Kit for ColdFusion is a resource for ColdFusion developers to quickly and easily add Macromedia Flash elements to their Web applications. ColdFusion developers can immediately take advantage of the design and delivery benefits of Macromedia Flash and Macromedia Flash Player without learning a new authoring product. For more advanced developers, the Component Kit provides guidelines and documentation for creating and customizing new Macromedia Flash components for ColdFusion that can be shared with other developers. The Component Kit includes 4 prebuilt Macromedia Flash sample components, guidelines detailing how to use and customize components and ColdFusion custom tags that control the behavior of those components. The four Macromedia Flash sample components included with the kit are: *Calendar *Calculator *Horizontal Menu *Cascading Menu (for Microsoft Internet Explorer) The Component Kit is available for free download from the Allaire Developers Exchange for the Windows and UNIX platforms. To access the components, type Macromedia Flash into the Developers Exchange Search window (http://devex.allaire.com/developer/gallery/index.cfm) or visit the following page to link directly to the kit: http://www.allaire.com/handlers/index.cfm?ID=20983 The FAQ and license agreements are also available on this page. Best, -Sam ~~ 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: best search
Does anyone know if verity works on searching a data type of LONG or CLOB for an oracle database? I am building a search engine for an oracle db and am new to the Oracle world, where I was recently struck by the fact you can't do a search on a LONG Data type?!? Has anyone built a search engine on a oracle database that can offer some help on this topic? At 12:08 PM 5/14/2001 -0400, you wrote: Michael, In my experience, I have played with Verity and Full Text searching. It really depends on what you are wanting to search and how much flexibility you are wanting to provide. Verity is very good when it comes to things like searching .txt, .htm, .cfm, ..doc and .pdf files. I think CF 5's version of verity throws in .ppt (Power Point Presentation) and some other file types. The downside of verity is the fact that you have to update the collection any time you modify one file or database entry. When I built a search recently, I incorporated CFX_Spell and Verity along with some massaging of the search field. HTH Hatton Humphrey -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:45 PM To: CF-Talk Subject: best search what will be the best option for searching on text based content: 1. insert content into database, search using SQL statements 2. insert content into database, search using VERITY queried collections 3. VERITY search, collections will search directly on 1000s of txt files 4. Microsoft Text Search Engine 5. SQL Full Text Search Any help, please.. -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: CF function to manipulate a date
You can use the actual functions built into CF: Month(myDate) Year(myDate) If you need a 4-digit Year: DateFormat(myDate,) HTH -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 11:54 AM To: CF-Talk Subject: CF function to manipulate a date Hello, I have a date field(myDate) in mm format. I want to compare it to a another year field and to another month field. How do I string out myDate inorder to seperate the mm and section of it so I can compare each section to a seperate month and year. Thanks, Julie ~~ 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: Access web reference
Anyone know of a good web-based reference for Access SQL syntax? Thanks, Jeremy ~~ 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: best search
As a rule of thumb use the right tool for the job, don't just use a tool because it is there. This is probarbly the best sentence I've heard this week! (come to think of it, it's only monday.. :) I asked for help and got it, but actually more questions arises, I'll try to describe them: 1. the content would be txt and pure ASCII text only! actually I just finished the mechanisem which takes the html files from all of the sites I want to search in and then remove all html tags/javascript codes and stuff. 2. how much is considered BIG in the lite version of verity? 100mb, 200mb of content? that's about the amount I have. 3. verity would be great for me to display the data more efficient along with CF tags. I know CF, I know verity is easy to use, but I know they MUST be slower then Microsoft Solutions. (BTW: IS THERE ANY DIFFRENCE?, MS Search =SQL Full text?) what will be the best way to go if: I want the search to be as fast as possible YET: 1. I need an easy way to get the results to good-looking HTML format. 2. and maybe an easy way to still incorporate CF tags. my database design is as follows: uID = url ID uLINK = full url location (i.e http://www.cftalk.com/whatis/cf.html) uCONTENT = txt content I fetched from the site earlier? do I actually need to save this data in tables or can I just search directly on the txt files? And final note: you mentioned Altavista engine - do they offer server search engines too? Thanks alot guys!! you'll be the first to run the search queries on my engine :) Michael. - Original Message - From: James Maltby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 6:15 PM Subject: RE: best search It really depends on how your content is being displayed - if it's flat-file then Verity is OK - if it's a combination of SQL and Verity then pass your query through both database and verity, if it's all sql held then rely on sql/verity collections (faster than plain sql requests), however database searches will depend on how often the data is to be updated. A quick rule we use for template based sites is verity index the flat file content, then build a link database with file names and page titles in which is used to display the url links to the content (your option 2). However, saying the above the main downfall of Verity is that it takes a f*** load of time to index large amount of pages and the collections can become corrupt - so it may be worthwhile using something else completely different (AltaVista supply a free search engine as do Lycos and Atomz). What you have to remember is Verity with CF is a lite version and as such is not too hot on larger sites. As a rule of thumb use the right tool for the job, don't just use a tool because it is there. J The Force is strong in this one... - Darth Vader -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 17:45 To: CF-Talk Subject: best search what will be the best option for searching on text based content: 1. insert content into database, search using SQL statments 2. insert content into database, search using VERITY queried collections 3. VERITY search, collections will search directly on 1000s of txt files 4. Microsoft TextSearch Engine 5. SQL Full Text Search Any help, please.. -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: [CF-Talk Archiver]
* Team Allaire * House of Fusion (yes, that's me) is looking into doing a weekly thread compilation of the lists. I have in my hand an 18 page test compilation that was done by an editor. Once it's been reviewed and polished I'll hand it out to a few 'test' subjects to see how they like it. Once we have a solid format we'll be compiling list archives on a regular basis. The basic format I'd like to see is one of: 1. Question 2. Answer 3. Additional answers (if exist) 4. Clarification (if exist) 5. Answers on clarification (if exist) This will allow someone to see the whole flow of logic from question to possible answer. That's the good news. The bad is that we have to pay for the editor to go through all the posts, compile them and write them up. We're looking to MM and others for sponsorships and would like to keep from charging people for it. We'll have to see how it goes. On Mon, 14 May 2001 08:43:28 CDT, Alex [EMAIL PROTECTED] wrote: Doesn't CF-Talk already archive the emails? Yes, but unfortunately some of us occasionally have to go offline. Yes, I know, it sucks, but a sad fact of life :) I think a client side app would be great - searching would be much faster than loading up the online archive. I currently read CF-Talk through Agent (the icky newsreader) from the fuseware NNTP mirror. I am working on a little program to parse the Agent file format and dump the messages into a database. If someone can make available their archives in a format Peter's application can read, I may not have to bother finishing it. Anyone? Peter, I would love to send you a postcard... but good ole Perth is not too exciting :) K. ~~ 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: Going bonkers with an Update in table
I'm assuming the update query goes after the form is sbumitted? Look at the values of your hidden fields in the form processing page -- since you don't change or update the hidden field variable names for each field, it just appends it to what the previous values was. So, it should put the list in the first field you have it update, since there is only one variable (ie Form.GradesID, Form.PERNUM, etc). See if that helps... -S- --- Dave f [EMAIL PROTECTED] wrote: Had to guess at some of this: From the cfoutput query=GetSubjects... loop, it looks as if you are expecting to retrieve more than 1 row with your query and store the retrieved elements in FORMname lists. But the update query *isn't* in a loop, and you aren't doing anything like GetToken or ListGetAt, so updates the row with the entire list. ?? - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 9:58 AM Subject: Going bonkers with an Update in table This is beginning to drive me bananas. This is a repost that I'm hoping someone can help with. I am trying to do an update query on a table-it keeps updating only the first column of the table- with all the data updating in just that one field! Although the table seems set up correctly (ie: the Id number that I want updated shows up correctly- until you run the update query. For example my table displays like so: #Skill# #ID# #Semester##Grade# #ID# #Semester##Grade# Reads 1A 4 B Writes 2A 5 A Spells 3B 6 B If I run the update query it'll put everything into ID 1 field (A, A, B, B, A, B) My code is as follows: !---Query used to populate table--- CFQUERY NAME=GetSubjects DATASOURCE=#Request.maindsn# SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID, tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject, tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor, tbl_StudentGrade.GradingPeriod, tbl_StudentGrade.PERMNUM FROM tbl_CourseSkill, tbl_StudentGrade WHERE tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=1 OR tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and PERMNUM='#PERMNUM#' And CourseID=2 Order BY tbl_StudentGrade.SkillID, GradingPeriod /CFQUERY !---Put grades into table TABLE CFOUTPUT QUERY=GetSubjects GROUP=SkillID TR TD COLSPAN=2#Skill#/TD CFOUTPUT TD CFIF Val(GetSubjects.GradeForSubject)#GetSubjects.GradeForSubject# CFELSEINPUT NAME=GradeForSubject VALUE=#GradeForSubject# SIZE=4 /CFIF /TD /CFOUTPUT /TR INPUT TYPE=Hidden NAME=SkillID VALUE=#SkillID# INPUT TYPE=Hidden NAME=GradesID VALUE=#GradesID# INPUT TYPE=Hidden NAME=PERMNUM VALUE=#PERMNUM# INPUT TYPE=Hidden NAME=GradeForSubject VALUE=#GradeForSubject# /CFOUTPUT /TABLE !---Update query to update grades--- CFQUERY NAME=EditGrades DATASOURCE=#Request.maindsn# UPDATE tbl_StudentGrade SET GradeForSubject='#trim(GradeForSubject)#' WHERE GradesID=#Val(GradesID)# /CFQUERY Are there any ideas about what I need to do differently? Thanks in advance for the help. j 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
Re: Access database question: how to structure a link between tw o tables
Also, don't confuse a safe type - such as a model designation, with a safe serial number. You would use a safe's serial number as a primary key in the safe table, as well as a foreign key in the intersection table Dave described below. To figure out what type of safe it is, you would need another table which will contain that model's description, and an additional field in the safe table which we be a foreign key to the safe type table. - Original Message - From: Dave Watts [EMAIL PROTECTED] i've created a database to handle an insurance form which deals with the insurance of money. it has a number of different tables such as 'cust', which lists details of customers, 'prem', which lists details of where the money is stored, and 'safe' which lists details of the safes in which the money is stored. the tables 'safe' and 'prem' relate to each other, in that a premises may have one or more safes, and one type of safe may be used in more than one premises. another way of putting it is that each safe could have 1 or more premises that match to it each premises could have 1 or more safes that match to it, with a maximum number of 3 safes or premises. what structure should i use for the link between the two tables? You have what is called a many-to-many relationship. There's no way to directly represent a many-to-many relationship in a relational database, so you'll need to create a table for this purpose. This table, called a linking table or an intersection table, should contain the primary key columns from each of the other two tables, and should be related to each of those tables using a one-to-many relationship; one record from each table can have many matches within the linking table. As a primary key, the linking table should use the two foreign keys together - a composite primary key. In Access, you can create these relationships using the Relationship window, once you've created the linking table. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
It's gone...the Harpoon documentation details various best practices for transferring information from ColdFusion to Flash. Using WDDX at this time, regrettably, is NOT a best practice. Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:30 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available I seem to remember that in some of the early betas for Harpoon there was an actionscript file for reading WDDX packets in Flash. Did this disappear? Or did it simply become subsumed into some of the FLA's. If the latter is true, could someone point me to the right place to find it? If it's gone, is there a reason? Thanks, Evan -Original Message- From: Sam Coe [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:29 AM To: CF-Talk Subject: Harpoon Release is Final Available We are happy to announce the availability of The Macromedia Flash Component Kit for ColdFusion. The kit, first announced in November 2000 under the code name 'Harpoon', is now available for download from the ColdFusion Developers Exchange. The Macromedia Flash Component Kit for ColdFusion is a resource for ColdFusion developers to quickly and easily add Macromedia Flash elements to their Web applications. ColdFusion developers can immediately take advantage of the design and delivery benefits of Macromedia Flash and Macromedia Flash Player without learning a new authoring product. For more advanced developers, the Component Kit provides guidelines and documentation for creating and customizing new Macromedia Flash components for ColdFusion that can be shared with other developers. The Component Kit includes 4 prebuilt Macromedia Flash sample components, guidelines detailing how to use and customize components and ColdFusion custom tags that control the behavior of those components. The four Macromedia Flash sample components included with the kit are: *Calendar *Calculator *Horizontal Menu *Cascading Menu (for Microsoft Internet Explorer) The Component Kit is available for free download from the Allaire Developers Exchange for the Windows and UNIX platforms. To access the components, type Macromedia Flash into the Developers Exchange Search window (http://devex.allaire.com/developer/gallery/index.cfm) or visit the following page to link directly to the kit: http://www.allaire.com/handlers/index.cfm?ID=20983 The FAQ and license agreements are also available on this page. Best, -Sam ~~ 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: [Session Variables - I don't get it]
because you are setting it to black on the application.cfm page. change the application.cfm cfset to cfparam Kronenberger, Douglas [EMAIL PROTECTED] wrote: Greetings, I'm not getting how to implement session variables. I'm just trying to set the session variable Session.Dog from black to Blue and have it show up as Blue on the test.cfm. It keep show'n up black. I do have Session Variables enabled via the CF Administrator page. What am I miss'n here. !--- Application.CFM --- cfapplication name=TEST sessionmanagement=Yes setclientcookies=no cflock scope=session timeout=2 cfset Session.Dog = Black /cflock !--- Test.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput cfset #Session.Dog# = Bluebr /cflock cflock scope=session type=readonly timeout=2 a href=test2.cfm?cfoutput#Session.URLTOKEN#/cfoutput Goto/abr /cflock /body /html !--- Test2.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput /cflock br /body /html - Can someone get me started here. Thanks Doug Kronenberger OI National Training and Education Office 440-526-3030 x7776 ~~ 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: disable user on LDAP server
Maybe this might help, in ldap using Novell DS there is a field called LOGINDISABLED if this is set to true its disabled if not, its not. See if there is a similar field in Netscape. Thanks [EMAIL PROTECTED] 05/11/01 10:34PM hi, is there a way where i can temporary disable an user on Netscape LDAP server? sort of disable that user account which in future allow me to enable it again, for temporary suspension on that user account. I did not see any function for me to disable user account in Netscape LDAP server, any advise? ~~ 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
cookie form url -less sessions
hey hey everyone.. here's a dilemma for you. i've been task with createing an application model for a very large application that is being gutted and rebuilt. now i've decided that we need both application and session variables. however the govt doesnt allow cookies on thier machines.. even for intranets. we have way too much code to go through and add cfid and cftoken to the url or to form vars.. so i'm kinda stuck. the only thing i have going for me is that the users must log in using challange response, so i know who is who in the application. and with that, i could add a structure to the application class which bears the name of the user.. then add variables to the structure from there... thereby creating a session that lasts untill the server is rebooted.. but i'd much rather create a session taht times out and expunges the data etc etc. so my thought would be to create 2 variables in the application.#username# class that are cfid and CFtoken then use those to refrence the session... i'm not sure if that'll work tho.. any other thoughts on how this could be done? -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
RE: best search
Does anyone know if verity works on searching a data type of LONG or CLOB for an oracle database? I am building a search engine for an oracle db and am new to the Oracle world, where I was recently struck by the fact you can't do a search on a LONG Data type?!? Has anyone built a search engine on a oracle database that can offer some help on this topic? As long as you can retrieve the field in a SELECT statement, and it's a string, you should have no problems using it with Verity. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Harpoon Release is Final Available
Steve Drucker wrote: Using WDDX at this time, regrettably, is NOT a best practice. Is this because of some problem with Flash? -- Every cloud has its silver lining, and lightning kills hundreds of people each year who are trying to find it. email: [EMAIL PROTECTED] web: http://www.pixelgeek.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: ftp to novell
*This message was transferred with a trial version of CommuniGate(tm) Pro* Try setting up a new user just to login to ftp and set its home directory to crsapps. Make sure this account has the appropriate rights to get to the files. I think all you should need is read and file scan. Hope that helps. Dave Livingston [EMAIL PROTECTED] -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:41 AM To: CF-Talk Subject: ftp to novell *This message was transferred with a trial version of CommuniGate(tm) Pro* I am trying to ftp to a novell server and am not having the best of luck. I can get the currect directroy to return sys: which is right. When I try to listdir of a direcotyr called crsapps I get nothing. I have tried /crsapps, crsapps. crsapps/*.* and get nothing. Is there a trick to novell? Joshua Tipton cfftp connection=ftp username=crsser password=crsser server=10.66.64.52 action=open stoponerror=yes cfftp action=GETCURRENTDIR stoponerror=Yes connection=ftp cfoutput#cfftp.returnvalue#/cfoutput cfftp connection=ftp action=listdir directory=/crsapps name=q stoponerror=yes cftable query=q htmltable cfcol header=bname/b text=#name# /cftable ~~ 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: the dbl devil
if using CF 4.5.x, why not use: CFSET temp=CFUSION_DISABLE_DBCONNECTIONS(DSN, 1) to release the DSN, and: CFSET temp=CFUSION_DISABLE_DBCONNECTIONS(DSN, 0) to re-enable it. just replace DSN with your actual DSN. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:45 AM To: CF-Talk Subject: RE: the dbl devil Just as an aside... Its not actually your application that's holding your database open. By default, ODBC is set to maintain connections. This is a good and a bad thing. Good because it is more efficient to maintain a connection to the database than to re-make the connection each time you query, insert or update any of your database tables. Bad because it means that its difficult to update your database, but, as Chris says, as long as you are using CF 4.5.x then you can use the cfusion_dbconnections_flush()function. One thing to say about that function - Use it sparingly The function will flush _all_ database connections. This means that not only will connections to your database, but everyone else's connections too. So potentially you could upset all the other people hosted on the same server as you, if you use it too often and affect the performance of their applications. If you're on a dedicated server and have access to the CF Administrator, then you can also flush DB connections from the Verify Data Source menu item. Regards Stephen PS. Does anyone know if you can specify a datasource name as an attribute of cfusion_dbconnections_flush(), so that it will release only the named datasource? -Original Message- From: Chris Maloney [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 14:48 To: CF-Talk Subject: RE: the dbl devil Megan, Provided you are using CF4.5.x you should be able to use the cfusion_dbconnections_flush() function to release the database. You do need to make sure that from the time you release the connection to the time you delete the database or replace it that no database accesses are done, otherwise the database will again be locked. The use of 'date' as a field name is a pretty common mistake, it would be nice if Access provided warnings about this when you create a database but it does not. Chris -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:27 AM To: CF-Talk Subject: the dbl devil Hi all, I'm using Access for my database. Sometimes when I need to make changes to the database on the server there is a .dbl file in the directory. I can't delete it, and it won't let me upload the database. A couple days ago someone on this list said to create a query calling a table that doesn't exist. I did that. Got the error on the screen, but the devilish dbl was still there. I talked to my cf host and he said, Your code is holding your database too long..put in your code a time to release the database after so many minutes. Does anyone know what he was talking about? Also, thanks for your assistance on my syntax error when inserting date. I was thrown off because cfinsert and cfupdate worked fine. But all went awry when I tried to use insert in a query in a cfloop. So changing the field name from date to classdate did the trick. Thanks! Megan 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
RE: Access web reference
Here's a couple bookmarks to get you started: http://www.accesswatch.co.uk/ http://msdn.microsoft.com/library/techart/acacclinks.htm Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Sales Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 Instant Messaging: AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED] -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 11:39 AM To: CF-Talk Subject: OT: Access web reference Anyone know of a good web-based reference for Access SQL syntax? Thanks, Jeremy ~~ 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: cfm-resources?
They went down over the weekend to install a wireless t1 connection for the freebie sites. From an email I got last week from cfm-resources.com... We'd like to let you know that we have just ordered a Wireless T1 connection strictly for the free sites, therefore we will be turning them off for two days. Starting May 11th, 2001 until May 13th, 2001. This is a necessary action, to provide better service and much more reliability. A dedicated T1 connection will be in place only for the free server, therefore giving our free customers faster access and more uptime! We do however appologize for the downtime, but it is necessary for the system to be installed on that machine. After May 13th, 2001 you will no longer experience downtime. All paying sites (Bronze and higher, will remain up with no changes to the sites, whatsoever). HTH! Jennifer Kay Smoljak wrote: Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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/CF easy problem for someone.
I am pulling info from my database and trying to display in a table. Here is my code cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Order By Coname ASC /cfquery table cellspacing=2 cellpadding=2 border=1 tr tdFSC #/td tdFranchise/td tdController/td tdAnalyst/td tdRevenue/td td align=centerAP/td tdPayroll Processor/td /tr cfoutput query=getDeptR tr td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td tr /cfoutput /table Here is what displays Department Responsibilities ... FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG HospitalitiesVirginia 69 AG HospitalitiesCharlie 69 AG HospitalitiesJoanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? Corrine Clark 316-689-0049 x 383 -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ 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
IE4 and Required Fields w/ CFINPUT
Ok, My form works like a champ in Netscape and I run into no problems in IE5 but I get a javascript error in IE4. Since I have no javascript on the page I can only assume it is the javascript that is auto-generated by my CFINPUT TYPE=Radio REQUIRED=Yes ... ... Anyone else run into problems using required=yes under IE4? Is there any way around it? Matt Hood ~~ 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/CF easy problem for someone.]
take out your 2nd tr from inside the loop tr cfoutput query=getDeptR td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td /cfoutput /tr Corrine Clark [EMAIL PROTECTED] wrote: I am pulling info from my database and trying to display in a table. Here is my code cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Order By Coname ASC /cfquery table cellspacing=2 cellpadding=2 border=1 tr tdFSC #/td tdFranchise/td tdController/td tdAnalyst/td tdRevenue/td td align=centerAP/td tdPayroll Processor/td /tr cfoutput query=getDeptR tr td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td tr /cfoutput /table Here is what displays Department Responsibilities ... FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG HospitalitiesVirginia 69 AG HospitalitiesCharlie 69 AG HospitalitiesJoanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? Corrine Clark 316-689-0049 x 383 -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ 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: ftp to novell
I have tried multiple users and I can FTP through NT just fine. It just seems to be a problem when I use the cfftp through Novell. *This message was transferred with a trial version of CommuniGate(tm) Pro* Try setting up a new user just to login to ftp and set its home directory to crsapps. Make sure this account has the appropriate rights to get to the files. I think all you should need is read and file scan. Hope that helps. Dave Livingston [EMAIL PROTECTED] -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:41 AM To: CF-Talk Subject: ftp to novell *This message was transferred with a trial version of CommuniGate(tm) Pro* I am trying to ftp to a novell server and am not having the best of luck. I can get the currect directroy to return sys: which is right. When I try to listdir of a direcotyr called crsapps I get nothing. I have tried /crsapps, crsapps. crsapps/*.* and get nothing. Is there a trick to novell? Joshua Tipton cfftp connection=ftp username=crsser password=crsser server=10.66.64.52 action=open stoponerror=yes cfftp action=GETCURRENTDIR stoponerror=Yes connection=ftp cfoutput#cfftp.returnvalue#/cfoutput cfftp connection=ftp action=listdir directory=/crsapps name=q stoponerror=yes cftable query=q htmltable cfcol header=bname/b text=#name# /cftable ~~ 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/CF easy problem for someone.
I assume I want it on one line means the output...???(correct?) Try this...(putting the output loop inside the tr tags) tr cfoutput query=getDeptR td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td /cfoutput tr of course the will give you numerous table datas ... What are you trying to do with these IFs??? since you are outputing #getDeptR.Firstname# in every instance... they seem spufluous... HTH JP Original Message Follows From: Corrine Clark [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Database/CF easy problem for someone. Date: Mon, 14 May 2001 14:11:47 -0500 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Mon, 14 May 2001 15:20:46 -0400 From [EMAIL PROTECTED] Mon May 14 12:19:19 2001 Message-id: 850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2 I am pulling info from my database and trying to display in a table. Here is my code cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Order By Coname ASC /cfquery table cellspacing=2 cellpadding=2 border=1 tr tdFSC #/td tdFranchise/td tdController/td tdAnalyst/td tdRevenue/td td align=centerAP/td tdPayroll Processor/td /tr cfoutput query=getDeptR tr td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td tr /cfoutput /table Here is what displays Department Responsibilities ... FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG HospitalitiesVirginia 69 AG HospitalitiesCharlie 69 AG HospitalitiesJoanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? Corrine Clark 316-689-0049 x 383 -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ 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: IE4 and Required Fields w/ CFINPUT
Matthew Hood wrote: Ok, My form works like a champ in Netscape and I run into no problems in IE5 but I get a javascript error in IE4. Since I have no javascript on the page I can only assume it is the javascript that is auto-generated by my CFINPUT TYPE=Radio REQUIRED=Yes ... ... Anyone else run into problems using required=yes under IE4? Is there any way around it? Matt Hood What's more, after clicking either yes or no, the form will continue onto the next page. If there is no way to make it compatible with IE4, is there a way to simply supress the error message? I am about done with this project and this is the only hurdle remaining and I feel as if I am gonna trip and fall flat on my face over a damn javascript error! Matt Hood ~~ 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: IE4 and Required Fields w/ CFINPUT
Make sure your cfform tag has a name AND the cfinput type has a name specified At 03:27 PM 5/14/2001 -0400, you wrote: Ok, My form works like a champ in Netscape and I run into no problems in IE5 but I get a javascript error in IE4. Since I have no javascript on the page I can only assume it is the javascript that is auto-generated by my CFINPUT TYPE=Radio REQUIRED=Yes ... ... Anyone else run into problems using required=yes under IE4? Is there any way around it? Matt Hood ~~ 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: IE4 and Required Fields w/ CFINPUT
Manually code your JavaScript validation routines. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Matthew Hood wrote: Ok, My form works like a champ in Netscape and I run into no problems in IE5 but I get a javascript error in IE4. Since I have no javascript on the page I can only assume it is the javascript that is auto-generated by my CFINPUT TYPE=Radio REQUIRED=Yes ... ... Anyone else run into problems using required=yes under IE4? Is there any way around it? Matt Hood ~~ 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: ftp to novell
Does the server that your Ftp server is running on have contextless login? If not you would have to use a fully qualified login name , e.g., .userid.ou.o.us Lanny Udey Hofstra University [EMAIL PROTECTED] Monday, May 14, 2001 I have tried multiple users and I can FTP through NT just fine. It just seems to be a problem when I use the cfftp through Novell. *This message was transferred with a trial version of CommuniGate(tm) Pro* Try setting up a new user just to login to ftp and set its home directory to crsapps. Make sure this account has the appropriate rights to get to the files. I think all you should need is read and file scan. Hope that helps. Dave Livingston [EMAIL PROTECTED] -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:41 AM To: CF-Talk Subject: ftp to novell *This message was transferred with a trial version of CommuniGate(tm) Pro* I am trying to ftp to a novell server and am not having the best of luck. I can get the currect directroy to return sys: which is right. When I try to listdir of a direcotyr called crsapps I get nothing. I have tried /crsapps, crsapps. crsapps/*.* and get nothing. Is there a trick to novell? Joshua Tipton cfftp connection=ftp username=crsser password=crsser server=10.66.64.52 action=open stoponerror=yes cfftp action=GETCURRENTDIR stoponerror=Yes connection=ftp cfoutput#cfftp.returnvalue#/cfoutput cfftp connection=ftp action=listdir directory=/crsapps name=q stoponerror=yes cftable query=q htmltable cfcol header=bname/b text=#name# /cftable ~~ 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/CF easy problem for someone.
Actually I have no problem with my IFs, they do what I want, which is display the firstname of the person associated with the Dept. I want one table row for each Company number and Name on a line with the Responsibility, like so: FSC # Franchise Controller Analyst Revenue AP PayrollProcessor 95 2JR TonySheryl Vickie Tim Virginia Not each on its own line. And not all in one line. -Original Message- From: j p [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:42 PM To: CF-Talk Subject: Re: Database/CF easy problem for someone. I assume I want it on one line means the output...???(correct?) Try this...(putting the output loop inside the tr tags) tr cfoutput query=getDeptR td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td /cfoutput tr . of course the will give you numerous table datas ... What are you trying to do with these IFs??? since you are outputing #getDeptR.Firstname# in every instance... they seem spufluous... HTH JP Original Message Follows From: Corrine Clark [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Database/CF easy problem for someone. Date: Mon, 14 May 2001 14:11:47 -0500 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Mon, 14 May 2001 15:20:46 -0400 From [EMAIL PROTECTED] Mon May 14 12:19:19 2001 Message-id: 850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2 I am pulling info from my database and trying to display in a table. Here is my code cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Order By Coname ASC /cfquery table cellspacing=2 cellpadding=2 border=1 tr tdFSC #/td tdFranchise/td tdController/td tdAnalyst/td tdRevenue/td td align=centerAP/td tdPayroll Processor/td /tr cfoutput query=getDeptR tr td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td tr /cfoutput /table Here is what displays Department Responsibilities ... FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG HospitalitiesVirginia 69 AG HospitalitiesCharlie 69 AG HospitalitiesJoanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? Corrine Clark 316-689-0049 x 383 -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
OT: catalog.wci filling up hard drive space?
We have a server that is filling up hard disk space very quickly and most of the growth is happening in this catalog.wci folder. Is this the logging folder for index server? If not what is it used for and how can I control it's growth? Thanks, Rick ~~ 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: [RE: Database/CF easy problem for someone.]
try the group attribute in cfoutput Corrine Clark [EMAIL PROTECTED] wrote: Actually I have no problem with my IFs, they do what I want, which is display the firstname of the person associated with the Dept. I want one table row for each Company number and Name on a line with the Responsibility, like so: FSC # Franchise Controller Analyst Revenue AP PayrollProcessor 95 2JR TonySheryl Vickie Tim Virginia Not each on its own line. And not all in one line. -Original Message- From: j p [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:42 PM To: CF-Talk Subject: Re: Database/CF easy problem for someone. I assume I want it on one line means the output...???(correct?) Try this...(putting the output loop inside the tr tags) tr cfoutput query=getDeptR td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td /cfoutput tr . of course the will give you numerous table datas ... What are you trying to do with these IFs??? since you are outputing #getDeptR.Firstname# in every instance... they seem spufluous... HTH JP Original Message Follows From: Corrine Clark [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Database/CF easy problem for someone. Date: Mon, 14 May 2001 14:11:47 -0500 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Mon, 14 May 2001 15:20:46 -0400 From [EMAIL PROTECTED] Mon May 14 12:19:19 2001 Message-id: 850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2 I am pulling info from my database and trying to display in a table. Here is my code cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Order By Coname ASC /cfquery table cellspacing=2 cellpadding=2 border=1 tr tdFSC #/td tdFranchise/td tdController/td tdAnalyst/td tdRevenue/td td align=centerAP/td tdPayroll Processor/td /tr cfoutput query=getDeptR tr td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td tr /cfoutput /table Here is what displays Department Responsibilities ... FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG HospitalitiesVirginia 69 AG HospitalitiesCharlie 69 AG HospitalitiesJoanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? Corrine Clark 316-689-0049 x 383 -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ Structure your ColdFusion code with Fusebox.
RE: Database/CF easy problem for someone.
You need to do a select distinct statement in your query. SELECT DISTINCT FSA #, Franchise Or use the Group By statement in your query (this is probably the better answer) cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Group by FSA# or Franchise or whateverit must be located before the order by clause. Order By Coname ASC /cfquery ~~ 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: cookie form url -less sessions
There's a custom tag on Allaire's site that will automatically add the ID Token to all URL's between it's open and closing tags. Which, if you are using fusebox, is super-easily implemented. You might look into that and see if that solves this for you. -Bill brainbox - Original Message - From: Christopher Porter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 1:17 PM Subject: cookie form url -less sessions hey hey everyone.. here's a dilemma for you. i've been task with createing an application model for a very large application that is being gutted and rebuilt. now i've decided that we need both application and session variables. however the govt doesnt allow cookies on thier machines.. even for intranets. we have way too much code to go through and add cfid and cftoken to the url or to form vars.. so i'm kinda stuck. the only thing i have going for me is that the users must log in using challange response, so i know who is who in the application. and with that, i could add a structure to the application class which bears the name of the user.. then add variables to the structure from there... thereby creating a session that lasts untill the server is rebooted.. but i'd much rather create a session taht times out and expunges the data etc etc. so my thought would be to create 2 variables in the application.#username# class that are cfid and CFtoken then use those to refrence the session... i'm not sure if that'll work tho.. any other thoughts on how this could be done? -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
SQL - Count Function Error
Hello, I am trying to run this MS SQL query and I keep getting the following error: The count function requires 1 arguments... her is my query: cfquery name=QRYEventTotals datasource=#request.ProjectAceDB# Select cd1.vCodeDecodeDesc as EventTypeDesc, ISNull(count(go.dMonthlyEventDate, 0)) as EventCount, IsNull(count(go2.dMonthlyEventDate, 0)) as EventCount2 From CMGoal go, , CMgoal go2, CodeDecode cd1 where (go.cEventTypeID = cd1.icodedecodeid AND go.dMonthlyEventDate = #variables.dMonthYear# AND (go.dStartDate 0) OR (go2.cEventTypeID = cd1.icodedecodeid AND go2.dMonthlyEventDate = #variables.dMonthYear# AND go2.dAchieveDate 0) Group by EventTypeDesc /cfquery Does anyone know what it doesnt like? TIA Julie ~~ 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: [RE: Database/CF easy problem for someone.]
I tried the Group By in both the SQL statement, and the Output. It now gives me one Franchise # and one Name, but it does not fill in the rest of the responsibilities! FSC # Franchise Controller Analyst Revenue AP Payroll Processor 1 PAC PIZZA Bob 3 IQ Investments (3) Erin 4 IQ Investments (4) Darla 5 WKRP Charlie 7 IQ Investments (7) Erin 8 IQ Investments (8) Erin 9 IQ Investments (9) Erin 12 Sky Ventures LLC Randy 13 Sky Ventures (2 in 1)Randy -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 3:05 PM To: CF-Talk Subject: Re: [RE: Database/CF easy problem for someone.] try the group attribute in cfoutput Corrine Clark [EMAIL PROTECTED] wrote: Actually I have no problem with my IFs, they do what I want, which is display the firstname of the person associated with the Dept. I want one table row for each Company number and Name on a line with the Responsibility, like so: FSC # Franchise Controller Analyst Revenue AP PayrollProcessor 95 2JR TonySheryl Vickie Tim Virginia Not each on its own line. And not all in one line. Message-id: 850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2 I am pulling info from my database and trying to display in a table. Here is my code cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Order By Coname ASC /cfquery table cellspacing=2 cellpadding=2 border=1 tr tdFSC #/td tdFranchise/td tdController/td tdAnalyst/td tdRevenue/td td align=centerAP/td tdPayroll Processor/td /tr cfoutput query=getDeptR tr td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td tr /cfoutput /table Here is what displays Department Responsibilities ... FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG HospitalitiesVirginia 69 AG HospitalitiesCharlie 69 AG HospitalitiesJoanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ 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: SQL - Count Function Error
Count doesn't need the ISNull check. I believe that Count will count all non-null fields so you just need: count(go.dMonthlyEventDate) -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 1:36 PM To: CF-Talk Subject: SQL - Count Function Error Hello, I am trying to run this MS SQL query and I keep getting the following error: The count function requires 1 arguments... her is my query: cfquery name=QRYEventTotals datasource=#request.ProjectAceDB# Select cd1.vCodeDecodeDesc as EventTypeDesc, ISNull(count(go.dMonthlyEventDate, 0)) as EventCount, IsNull(count(go2.dMonthlyEventDate, 0)) as EventCount2 From CMGoal go, , CMgoal go2, CodeDecode cd1 where (go.cEventTypeID = cd1.icodedecodeid AND go.dMonthlyEventDate = #variables.dMonthYear# AND (go.dStartDate 0) OR (go2.cEventTypeID = cd1.icodedecodeid AND go2.dMonthlyEventDate = #variables.dMonthYear# AND go2.dAchieveDate 0) Group by EventTypeDesc /cfquery Does anyone know what it doesnt like? TIA Julie ~~ 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
