RE: IP Address Locator
Can you check their locale? -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, 25 February 2002 8:03 AM To: CF-Talk Subject: IP Address Locator Hi all, I have a client that would like to deny any order placed from Indonesia. Is there an easy way to do this? Is there some way to match an IP address up to a country? Thanks, jeff __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Divide record output cleanly when printing?
Yeah, we've done a HTML-based reporting thing here that counted the number of lines in a report and inserted a footer then a new header each time the line limit was met. We used CSS to force page breaks and ensure line height consistency. There's also a table trick with two rows (bottom being the footer) that ensured exact footer placement from page to page. Darryl -Original Message- From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 February 2002 6:28 AM To: CF-Talk Subject: Divide record output cleanly when printing? Does anyone have any tricks that will not split up the results of a record output when printing, but will instead be smart and know that if the entire record won't fit on one page, to begin it on the next one? In my particular situation, each record is fully contained (formatted) in its own table. As well, if it helps, I am exporting the html to a pdf via the custom tag html2pdf3. TIA, ~Val __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any Javascript people out there? I need help with select bo xes...
Refer to the msdn dhtml reference library.. There are a number of functions that enable you to add options to select boxes. For instance, this works in IE.. oElement = document.createElement(OPTION); document.all.selectboxname.children(0).insertAdjacentElement(BeforeBegi n,oElement); oElement.innerText = 'whatever'; oElement.value = 'whatever'; Hope this helps. Darryl -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 February 2002 7:48 AM To: CF-Talk Subject: RE: Any Javascript people out there? I need help with select bo xes... I tried that and got this error... selectCtrl.options[i] has no properties. Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Brian Rosenstock [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 3:48 PM To: CF-Talk Subject: RE: Any Javascript people out there? I need help with select bo xes... I think you'd need to do: selectCtrl.options[i].value = i+1; selectCtrl.options[i].text = i+1; instead of just: selectCtrl.options[i] = i+1; Brian Rosenstock -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 4:39 PM To: CF-Talk Subject: OT: Any Javascript people out there? I need help with select bo xes... sorry about the OT post..I need help with a select box. I am making 2 select boxes (Month and Day). when the user changes the month, I want the javascript to delete what is in the day select box and fill it with the number of days in that month. I have the deleting part working. It just won't add. I'm not sure what I need to do. Here is my code(Please ignore that I HAVE to use ASP for this).. select name=month size=1 onChange=changeMonth(this.form,this.form.day,this.form.month.options[ this.f orm. month.selectedIndex].value); option value=1 SELECTEDJanuary/option option value=2February/option option value=3March/option option value=4April/option option value=5May/option option value=6June/option option value=7July/option option value=8August/option option value=9September/option option value=10October/option option value=11November/option option value=12December/option /select/td tdDay:/tdtdselect name=day size=1 %for i = 1 to 31% option value=%=i%%=i%/option %next%/select/td script language=JavaScript1.2 function changeMonth(theform,selectCtrl,iValue) { var oNewOption; iSelection = iValue; iOptLen=selectCtrl.length + 1; for (i=0;i=iOptLen;i=i+1) { selectCtrl.options[0] = null; } if (iSelection == 1 || iSelection == 3 || iSelection == 5 ||iSelection= 7 || iSelection == 8 || iSelection == 10 || iSelection == 12) { for (i=0;i=30;i=i+1) { selectCtrl.options[i] = i+1; } } if (iSelection == 2) { for (i=0;i=27;i=i+1) { selectCtrl.options[i] = i+1; } } if (iSelection == 4 || iSelection == 6 || iSelection == 9 ||iSelection= 11) { for (i=0;i=29;i=i+1) { selectCtrl.options[i] = i+1; } } } /script Someone please drop me a line and tell me what I am doing wrong. I am absolutely clueless Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Foreign keys
Remove the quotes around the date (preferably use VALUES (#CreateODBCDate(form.date)#,#techs.id#,etc...) Darryl -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 February 2002 8:53 AM To: CF-Talk Subject: RE: Foreign keys Thanks for the reply. I tried that, and I still got an error with this query: Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY)... I know that this table exists in my ODBC source, and that the column names match what I have in the query. -Jake --- Steve Oliver [EMAIL PROTECTED] wrote: If the ID's are integers, you don't want to put quotes around them. CFQUERY NAME=AddLogEntry DATASOURCE=Software Updates INSERT INTO log (date, tech, software, comments) VALUES ('#form.date#', #techs.id#, #software.id#, '#form.comments#') /CFQUERY __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 7:38 PM To: CF-Talk Subject: Foreign keys Hi guys, How can I insert the id field of a query into another table? What I am wanting is to use the id from one table as a foreign key in another table. To do this, I run a query on the two tables, and then I want to insert the primary keys (field named id) from these two tables as foreign keys in the second table. Below is the code I have written that ins't working. cfquery datasource=Software Updates name=techs SELECT * FROMtechs WHERE tech='#form.tech#' /cfquery cfquery datasource=Software Updates name=software SELECT * FROMsoftware WHERE software='#form.software#' /cfquery CFQUERY NAME=AddLogEntry DATASOURCE=Software Updates INSERT INTO log (date, tech, software, comments) VALUES ('#form.date#', '#techs.id#', '#software.id#', '#form.comments#') /CFQUERY Thanks. -Jake __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL indexing
Indexing any field that is used to search with on a regular basis is always a good idea. For instance, I had a database full of users (about 27,000 of them) and the login process would take forever. Placing an index on the username and password fields increases the query execution speed by over 1000% (used to take over a minute, now around 1 second). The same principle would apply to any field where the server needs to lookup the table and return records based on the field in the where clause. If it has a pre-built index of rows where these values are, your query will run faster. Inserts of course will be a little slower as the index has to be rebuilt each time a new row is inserted. Regards Darryl -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Monday, 18 February 2002 5:26 AM To: CF-Talk Subject: OT: SQL indexing Is there any benefit to indexing a tinyint field that is used as a boolean (either 1 or 0)? I have four fields that work this way and I use them heavily in queries for reporting. They are used in aggregate functions (count and sum) as well as in the where clauses for various queries. I know I could play with the indexes and test the timing, but I only have a live database to work with and don't want to disrupt anything until I feel there will be some significant benefit. Also, along the same lines, I report by grouping output (in SQL - not CF's group=) using the DAY, HOUR and MONTH parts of a datetime stamp. Will indexing help when using portions of a datetime field in this way, as opposed to considering the entire field? BTW - this is using SQL Server 2000 (and I guess the same theory would apply to SQL 7). Thanks! Jeff __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing a dts package
You've set up an SQL Job for running the DTS package I am assuming? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 February 2002 7:15 AM To: CF-Talk Subject: executing a dts package Here's the deal. We have a DTS package that needs to be executed on a monthly basis. The problem is that SQL server 7 can't execute it. It fails every time. If we run the package manually it works just fine. Any ideas? Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursive help!!!!
Try secretagents.com and look for the nested hierarchy tute for SQL. It's what I use and its incredibly powerful (e.g. one-query hierarcy display, tree walks, etc) Darryl -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 February 2002 9:32 AM To: CF-Talk Subject: Recursive help My mind just isn't working, I need help with some logic here if any of you would I have a table that houses all employees and each is unique by employee number, there is a hierarchy of management by storing each employee's supervisors employee number in the record. For example my bosses emp num is 24, I am emp num 44. My record looks like this. empnum fname lnamesupvnum 44 ray Bujarski 24 I need to create a structure that has a hierarchy list of employees, I have people reporting to me so, my supervisor should have all my employees listed in his list of employees along with myself. Can anyone help me with this logicI am at nerves end. Thank you! Ray __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cold fusion reporting...
SELECT YEAR(datefield) as year, MONTH(datefield) as month, DAY(datefield) as day, COUNT(anotherfield) as nr FROMtablename WHERE datefield BETWEEN @start AND @end GROUP BY YEAR(datefield), MONTH(datefield), DAY(datefield) ORDER BY year, month, day *should* work. The reason I split up the date was because you can then do what you pretty much like with it -- like change it do each month for instance.. You could also ORDER BY the nr column as well to get the top hits. Is this what you wanted? Darryl. -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 15 January 2002 3:19 PM To: CF-Talk Subject: cold fusion reporting... does anyone have a good sample of SQL code that does in essence the following: A. takes and groups the total records on a per date basis where the date is a date/time field.. so we want Jan 11, Jan 12, Jan 13, etc. broken out... (yeah we store date and time.. much easier if we would have stored time in another field)... so only group where records exist for day.. B. Calculates the total number of records found for each date... so Jan 11 = 21, Jan 12=31... an Access database sort of SQL piece will be fine... sounds simple... perhaps I should get some rest and come back... :) __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: verity and html comments
Yeah it does. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 7:56 AM To: CF-Talk Subject: verity and html comments Does anyone know if verity indexes text within html comments !-- does it index me? -- thanks, phillip __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is Their a Standard Way of Preventing Users from Entering Dou ble Records by Refreshing Browser?
cflocation to a success page (or any template other than the action template) Darryl -Original Message- From: PHP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 9 January 2002 10:57 AM To: CF-Talk Subject: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on the page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common Practice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating ZIP archives
There's number of CFX tags on http://devex.allaire.com/developer/gallery/ that will do this (one is even free I believe). -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 January 2002 9:39 AM To: CF-Talk Subject: Creating ZIP archives Hi, I have a requirement to zip up some image files together and FTP them to another server. The FTP bit is easy, but I'm wondering if anyone knows how (or whether there are any modules) that will create a ZIP file. Thanks Nick -- Nick Texidor __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Formating to HTML output
ParagraphFormat(variable) Darryl -Original Message- From: atlantis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 January 2002 8:32 AM To: CF-Talk Subject: Formating to HTML output I have data in a memo field in my access database that has carriage returns in it to separate different paragraphs. How do I get the formatting to come through as BR or P when the data is output on a webpage? Right now all the data runs together. Thanks, Jason __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Formating to HTML output
Disregard my last post :) -Original Message- From: atlantis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 January 2002 8:32 AM To: CF-Talk Subject: Formating to HTML output I have data in a memo field in my access database that has carriage returns in it to separate different paragraphs. How do I get the formatting to come through as BR or P when the data is output on a webpage? Right now all the data runs together. Thanks, Jason __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Long Live Cold Fusion and...
Thomas, I'd listen to Andrew as he is completely correct.. Are you saying that you'd like a multi-user license version of a product that is only meant to run on a localhost? Because realistically that's all they can really do to stop people from placing a full-featured application server on a web server. Darryl -Original Message- From: Thomas Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 December 2001 4:22 PM To: CF-Talk Subject: RE: Long Live Cold Fusion and... There is a lot more to life than to be such a complainer. Maybe you are inhaling too much smoke from the raging fires. Anyway, have a good 2002. At 12/31/2001, Andrew Scott wrote: Well then maybe you should see what happens after the trial then, because it becomes a single user license that will do exactly as you want it to do. Good for developing, playing, experimenting. If you have not read this on the website then that is your bad luck! Don't make a complaint about something that it already does. -Original Message- From: Thomas Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 December 2001 4:49 PM To: CF-Talk Subject: RE: Long Live Cold Fusion and... I know that it has a 30 day trail. This is not the same as having a no limited time and functionality version for learning. The software could be so designed so that it could not be used for production. My idea is that the more affordable the learning of CF the more users and more future sales. I think that there will be enough customers to pay for the modification and development costs. Thomas __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Security
I agree.. Stored procedures already filter input based on the type of data it is, so you don't really have to worry about people adding ; DELETE FROM table to form fields or Url strings. You don't even have to give them EXECUTE rights over the Stored procedure if the database only has one user set up. If on the other hand you've got an application that required raw SQL input then I'd be changing that :) Darryl -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Friday, 28 December 2001 7:33 AM To: CF-Talk Subject: RE: SQL Security The way I prefer to do this is by using Strored Procs. You only give the user access to execute stored procs, then you don't have to worry so much about hacking attempts where somebody tries to execute their own SQL.. You can usually verify size limits in the HTML for the form fields, and then you can do numeric and date validation using both JavaScript on the client and simple CF on the server. I have found this to be a very secure and stable way to do things. It also helps to speed up many operations and to a lesser extent helps to guarantee transactional integrity. just my $0.02 The reasoning is very simple. Even supposing that you limit permissions as much as possible, within a typical web application you're still going to have a single user (and by user, I mean a database user account that you specify within your CF datasource settings) with the rights to select, insert, update and delete from all user tables. For various reasons, you may not want to use individual database user accounts for each actual web application user who runs your app. So, it may not be possible for a malicious end-user to drop tables or run xp_cmdshell (my favorite, personally), that end-user could potentially run code that you, the developer, doesn't want them to. To prevent that, you need to filter input before you use it in an SQL statement. The importance of input filtering is hard to overemphasize - if you need further convincing, check out what CERT (http://www.cert.org/) has to say about it. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does anyone see a problem with this query?
Well for one, get rid of the WHERE clause as you're effectively cancelling out the INNER JOIN. It's probably the topc.topics, bit of the query, but I can't be sure. Darryl -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 December 2001 8:12 PM To: CF-Talk Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL Spooling
We've written our own 'spooling system' using SQL Server and an event script to fire off Jmail every five minutes. We've found this works a lot better than CF for bulk mail as you can use Microsoft's SMTP server and the pickup directory. Darryl -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 4 December 2001 12:06 PM To: CF-Talk Subject: Re: CFMAIL Spooling Thanks, Tom. Not even through a registry setting, eh? Looks like any CF applications we had written for CF4 which were doing a self-paced delivery of messages should be rewritten. There's not much sense in it if CF has a maximum delivery speed of 400 messages per minute. I suppose 24,000 messages per hour is reasonable, but if you've got the processing power and adequate bandwidth, I don't understand why they'd want to impose this limit. The 64k limit of email message files in the spool directory, if I recall, is due to CF's file-naming convention. Is CF smart enough to re-use file names in a cyclic manner - moving files out of the spool in a way that lets it re-use file names such that you can always get 64k files in the spool? Jim - Original Message - From: tom muck [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 03, 2001 6:37 PM Subject: Re: CFMAIL Spooling There is no setting for the number of emails. The spooler delivers 100 mails every 60 seconds. You can change the interval to 15 seconds, but no lower. Also, there is a limit of 65,535 emails that can be delivered to the spool folder at one time. tom www.basic-ultradev.com Jim McAtee [EMAIL PROTECTED] wrote in message 02b501c17c57$ec7da220$352fa8ce@jim">news:02b501c17c57$ec7da220$352fa8ce@jim... In the CF5 Administrator there's a parameter that controls how often the server checks the mail spool. Is there a fixed number of messages that CF relays to the mail server in each interval? Doing a mass mailing (40k messages), it seems that mail is moving rather slowly from the CF spool. The mail server being used is _very_ idle and could easily be relaying messages faster. Is this a registry setting, or is there something else limiting how fast CF moves these messages? Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session and Client Variables
The main obstacle w/ session variables in scalability is if you're going to cluster your servers. Because client vars are in the database (and they should be) are avaiable across all servers running the same app. -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 November 2001 12:47 PM To: CF-Talk Subject: Re: Session and Client Variables And yes, client variables DO time out. What's the timeout period? I wasn't aware of this, would be nice to know for when I do use them. Bottom line: session variables suck. I hate them. They are the bane of CF. I hate how people put gigantic structures in session variables and then use them like simple variables. I hate how people forget to lock session variables. I hate how people don't know when to use type=exclusive vs. type=readonly. I hate all the workarounds so that you don't have to lock session vars (talk about doing extra work to be lazy). I hate how they make deployment of scalable apps a huge headache. I use session variables with no hassle. Seems odd to hate something because of other people's misuse of them. I don't use them for large structures and I know how to lock them properly. They're fine! :) Curious to know how they might affect scalability, though. Doesn't affect much of my current work, but - of course - it might in the future. What are the precise scalability pro's of client variable storage in a DB? Why/how would you use them when you want to store session-specific variables whose timeout period you can control? - Gyrus ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can CF do multiple DB connection?
Don't think so as you've generally got one datasource per access database.. I'm not really an Access-using person.. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 November 2001 10:05 AM To: CF-Talk Subject: Re: can CF do multiple DB connection? Can Access support cross-database joins? Will - Original Message - From: Darryl Lyons [EMAIL PROTECTED] Newsgroups: gradwell.lists.cftalk Sent: Sunday, November 04, 2001 8:23 PM Subject: RE: can CF do multiple DB connection? If your using db like SQL Server you can do cross database joins by doing this: SELECT n.name FROM Dbname.dbo.tablename r, dbname2.dbo.tablename2 n WHERE r.id = n.r_id AND n.id = @id Etc etc Is that what you mean? Darryl -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 November 2001 2:55 AM To: CF-Talk Subject: Re: can CF do multiple DB connection? It sounds like you are confused by why the application.cfm has the DSN connection defined -- the main reason is so that you don't have to define it on every page and can change it in one place if you need to change it for any reason. If you want to use more than one, simply define more than one variable on the application.cfm page or hard-code the DSNs into the cfquery tags. You can have as many database connections as you need. Also, in CF 5 you can do a query of a query so that you can do queries across mulitple databases if you need to. tom han peng [EMAIL PROTECTED] wrote in message 003301c1654d$e04aa500$5b9a15a5@qubitsonyvaio">news:003301c1654d$e04aa500$5b9a15a5@qubitsonyvaio... hi... ppl... i will like to check with u..ppl can cold fusion link to multiple database at the same time..?? i noticed under application.cfm .. we normally put only 1 DSN connection. juz wonder.. is it possible to create multiple DSN connection..? and is it possible to do multiple database query from a single query statement? hmm.. is there any gd website.. where i can find more info abt this..?!! coz i need to do a recommendation which software to use for our new project. cheers han ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strangest Problem in a long time
If you use _date appended to your field names CF will try to validate the field. Therefore the form field is in fact called ticketXXdue rather than ticketXXdue_date. Just change the name of the field to not end with _date (_required or a few other reserved names). Darryl -Original Message- From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 7:36 AM To: CF-Talk Subject: Strangest Problem in a long time People, I've encountered the strangest problem in a long time using Cold Fusion. I've got a form which posts to a Cold fusion page. One of the form elements is: INPUT SIZE=25 NAME=ticketXXdue_date TYPE=text MAXLENGTH=50 SIZE=25 VALUE= MAXLENGTH=50 When I look at my Cold Fusion Debugging information on the page that is supposed to use this form: FIELDNAMES=TICKETXXTYPE_ID,TICKETXXCATEGORY_ID,TICKETXXDESCRIPTION,TICKET_AC TIONXXTICKET_OWNER_ID,TICKET_ACTIONXXTECHGROUP_ID TICKET_ACTIONXXTECHGROUP_ID=0 TICKET_ACTIONXXTICKET_OWNER_ID=1 TICKETXXCATEGORY_ID=4 TICKETXXDESCRIPTION=dink TICKETXXDUE_DATE=10-26-01 TICKETXXREMIND_DATE= TICKETXXTYPE_ID=2 When I go through the output from the form.fieldnames: TICKETXXTYPE_ID,TICKETXXCATEGORY_ID,TICKETXXDESCRIPTION,TICKET_ACTIONXXTICKE T_OWNER_ID,TICKET_ACTIONXXTECHGROUP_ID As you can see, the due_date (along with the remind_date) are not showing up! Consequently my Database is not inserting this field and my application is not behaving the way I want it. When I change the fieldname to anything but due_date (say TICKETXXDUE_DODO) It will show up. It seems to me like there is something that the Cold fusion server does to form entries that contain a _date in their name. But I cannot verify this. Has anyone else had experience with this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Unicode
Has anyone had abny experience with Unicode-based dynamic web sites? It seems to me that Unicode is the only option when dealing with a one-system multilingual site that stores Japanese/Chinese/etc information.. Can you convert a Double-byte record to Unicode? --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Best Bulk Emailers
What are the best bulk email programs out there that integrate with CF? E.g. Dear functionality --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JMAIL
Any ideas how many emails JMAIL can handle? Ie. Could it send 80,000? If not, most likely worth looking into a complete listserv/mailing list system? --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf 5 can't join fields
Maybe a stupid question, but does TermID exist in either or both tables? Darryl -Original Message- From: Aimee Abbott [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 7:44 AM To: CF-Talk Subject: cf 5 can't join fields Hello all, I used cold fusion 5 and the Merant database drivers to create a new database (is this dbase V?) Anyway, now I have created four tables and I am trying to join two of them. What I would like to do is: select TERMS.termID, TERMS.term, CROSSREF.crossText from TERMS, CROSSREF where TERMS.termID = CROSSREF.termID but I get an error: An error occurred retrieving data: ODBC Error Code =S0022 (column not found) [MERANT]{ODBC dBase driver]Field not found TERMID Do I need to do joins in some different way with this driver? I have looked at the odbc*.pdf file that comes with CF5 and it looks like what I am doing should work just fine. Is there something I need to setup on the server in some different way Aimee ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf 5 can't join fields
You don't need to SELECT something in order to use it in the WHERE clause. I'm guessing that TermID doesn't exist in one of the tables, although I could be wrong. -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 7:44 AM To: CF-Talk Subject: Re: cf 5 can't join fields It looks like you're not even selecting crossref.termID to use in your where statement. -Bill brainbox - Original Message - From: Aimee Abbott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 17, 2001 5:44 PM Subject: cf 5 can't join fields Hello all, I used cold fusion 5 and the Merant database drivers to create a new database (is this dbase V?) Anyway, now I have created four tables and I am trying to join two of them. What I would like to do is: select TERMS.termID, TERMS.term, CROSSREF.crossText from TERMS, CROSSREF where TERMS.termID = CROSSREF.termID but I get an error: An error occurred retrieving data: ODBC Error Code =S0022 (column not found) [MERANT]{ODBC dBase driver]Field not found TERMID Do I need to do joins in some different way with this driver? I have looked at the odbc*.pdf file that comes with CF5 and it looks like what I am doing should work just fine. Is there something I need to setup on the server in some different way Aimee ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf 5 can't join fields
terms isn't a reserved word? -Original Message- From: Aimee Abbott [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 8:11 AM To: CF-Talk Subject: RE: cf 5 can't join fields No, I don't think that is it. I have been playing with it some more over the past few minutes and am finding it seems to have something to do with the table.field syntax. If I even do: SELECT crossref.TERMID, crossref.CROSSTID, crossref.CROSSTTEXT FROM crossref or just: SELECT terms.TERMID, terms.TERM, terms.DEFINE FROM terms (which I copied straight from the query builder) I get the same error message. How can this be? --Aimee At 07:40 AM 9/18/2001 +1000, you wrote: You don't need to SELECT something in order to use it in the WHERE clause. I'm guessing that TermID doesn't exist in one of the tables, although I could be wrong. -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 7:44 AM To: CF-Talk Subject: Re: cf 5 can't join fields It looks like you're not even selecting crossref.termID to use in your where statement. -Bill brainbox - Original Message - From: Aimee Abbott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 17, 2001 5:44 PM Subject: cf 5 can't join fields Hello all, I used cold fusion 5 and the Merant database drivers to create a new database (is this dbase V?) Anyway, now I have created four tables and I am trying to join two of them. What I would like to do is: select TERMS.termID, TERMS.term, CROSSREF.crossText from TERMS, CROSSREF where TERMS.termID = CROSSREF.termID but I get an error: An error occurred retrieving data: ODBC Error Code =S0022 (column not found) [MERANT]{ODBC dBase driver]Field not found TERMID Do I need to do joins in some different way with this driver? I have looked at the odbc*.pdf file that comes with CF5 and it looks like what I am doing should work just fine. Is there something I need to setup on the server in some different way Aimee ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mailing List Server/Bulk Mailer
Hey guys, What do you use for your bulk emailers or mailing list servers? We have a newsletter system here but we obviously don't want to use CFMAIL to send potentially thousands of HTML emails out at once. MOre specifically what about opt-in/opt-out, archives, etc, and integration with CF/databases.. Jmail? --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Username/password attribs on CFQUERY
Has anyone got any thoughts on what the implications are for using username/password attribs in the CFQUERY tag. Obviously on a shared environment do not want to be placing a username/password on the actual datasource.. Any other ways of securing datasources? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: protect downloadble documents
Is there anyway to change the filename? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 25, 2001 8:52 AM To: CF-Talk Subject: RE: protect downloadble documents Darn, forgot you can't get at it. I'll put it up on the web Monday if anyone needs it. URL will be http://128.121.22.104/CFCONTENT_types.cfm JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 6:39 PM To: CF-Talk Subject: RE: protect downloadble documents Here is a file with the different types you can use with the CFCONTENT - Thanks to Steve who pointed me to the web page - I reformatted it in Word. JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 6:17 PM To: CF-Talk Subject: protect downloadble documents Hi, I'm building a password protected extranet that allows someone, once logged int to view .doc, .pdf and .ppt's. But can I use ColdFusion somehow to prevent someone from linking directly to the .doc, .pdf, .ppt without having to log in? Thanks Sal ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: protect downloadble documents
the file for download will be the CFM file that is pushing the content back to the browser -- any ideas if there is a work around with this? I'm pretty sure there isn't, but just wanted to see if anyone had a workaround.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 10:24 AM To: CF-Talk Subject: RE: protect downloadble documents Which filename? JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 7:58 PM To: CF-Talk Subject: RE: protect downloadble documents Is there anyway to change the filename? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 25, 2001 8:52 AM To: CF-Talk Subject: RE: protect downloadble documents Darn, forgot you can't get at it. I'll put it up on the web Monday if anyone needs it. URL will be http://128.121.22.104/CFCONTENT_types.cfm JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 6:39 PM To: CF-Talk Subject: RE: protect downloadble documents Here is a file with the different types you can use with the CFCONTENT - Thanks to Steve who pointed me to the web page - I reformatted it in Word. JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 6:17 PM To: CF-Talk Subject: protect downloadble documents Hi, I'm building a password protected extranet that allows someone, once logged int to view .doc, .pdf and .ppt's. But can I use ColdFusion somehow to prevent someone from linking directly to the .doc, .pdf, .ppt without having to log in? Thanks Sal ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing list to Stored Procedure..
Umm, it asks for a username/password :) -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 5:06 PM To: CF-Talk Subject: Re: Passing list to Stored Procedure.. Ok I put them out there as is. I am no SQL Server Guru so I make no guarantees about efficiency. Also I wrote the functions to use any delimitter but I only use commas in my site. I have unit tested them with other delimitters but nothing extensive. They are I am in a hurry and I am the only one who uses them documented They were wriiten in SQL Server 2000 but AFAIK they should work in 7 also. http://www.cyberroomies.com/data/listfunctions.zip Enjoy - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 8:02 PM Subject: Re: Passing list to Stored Procedure.. i routinely pass a comma delimited list to SQL Server stored procs. I just wrote a few simple udfs in sql server to parse the list when it gets it. - Original Message - From: Darryl Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 4:50 PM Subject: SOT: Passing list to Stored Procedure.. Does anyone know if you can pass a list of values to a stored procedure via CF? This is mainly needed because the list values would be drawn from an unspecified datasource (e.g. a list of user groups stored in a session var).. --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: Passing list to Stored Procedure..
Does anyone know if you can pass a list of values to a stored procedure via CF? This is mainly needed because the list values would be drawn from an unspecified datasource (e.g. a list of user groups stored in a session var).. --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing list to Stored Procedure..
Yeah, I'd love an example, as queries containing lists as CF vars are the only thing holding me back from putting all db interactions in a stored proc. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 1:05 PM To: CF-Talk Subject: RE: Passing list to Stored Procedure.. Any chance of an example on how to do this for us not so gurus of SQL/PL.. -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, 23 August 2001 12:02 PM To: CF-Talk Subject: Re: Passing list to Stored Procedure.. i routinely pass a comma delimited list to SQL Server stored procs. I just wrote a few simple udfs in sql server to parse the list when it gets it. - Original Message - From: Darryl Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 4:50 PM Subject: SOT: Passing list to Stored Procedure.. Does anyone know if you can pass a list of values to a stored procedure via CF? This is mainly needed because the list values would be drawn from an unspecified datasource (e.g. a list of user groups stored in a session var).. --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedure Question
CREATE PROCEDURE qGetStates @state_ID int AS SELECT First you should only one input parameter for state_ID, as I assume you are doing a select statement.. If you need the two values, than rename one of the parameters. Second, make sure you've actually set the stored procedure to expect params. Darryl -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 8:25 AM To: CF-Talk Subject: Stored Procedure Question I have the following code: cfstoredproc datasource=#WME.DSN# procedure=qGetStates returncode=Yes cfprocparam type=In dbvarname=@State_ID value=#license_state_ID# cfsqltype=CF_SQL_INTEGER cfprocparam type=In dbvarname=@State_ID value=#state_ID# cfsqltype=CF_SQL_INTEGER cfprocresult name=qGetStates /cfstoredproc I have the SP on the SQl Server and it works. However, when I run the page, I receive the following error message: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure qGetStates has no parameters and arguments were supplied. SQL = qGetStates Data Source = WME The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (7:1) to (7:77). I have debugging on and the form variables are being passed. I have also prefixed the values with Form. and it still does not work. Thanks, -bs ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disappearing queries
Thanks. -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 18, 2001 1:10 AM To: CF-Talk Subject: RE: disappearing queries I believe that CFQuery will not handle SQL that returns/processes more than one recordset. So if you do an INSERT then a SELECT in a proc/query, you won't get any results back. For stored procedures, you should be using CFSTOREDPROC/CFPROCPARAM/CFPROCRESULT instead. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 7:33 PM To: CF-Talk Subject: disappearing queries Has anyone ever had any problems displaying result sets from a stored procedure using temporary tables? The query works fine in SQL Query Analyser, but CF just won't bring back results. Even stranger is that as soon as the query is run, the debug info comes up with 0 results, and then CF says the query doesn't exist.. Error below. (Note that the asdasdsadsd is referenced properly in the cfoutput tag) asdasdsadsd (Records=0, Time=15ms) Bottom of Form 0 Error Occurred While Processing Request SQL = { CALL cm_qry_listing_obj('1','47','1','1') } Error Diagnostic Information QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (5:1) to (5:30). Date/Time: 08/17/01 10:31:58 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: 210.11.100.2 --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : (07) 3230 8811 'merging business + technology' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disappearing queries
In SQL 7.0 or ? -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 1:43 PM To: CF-Talk Subject: RE: disappearing queries There is a way around this. Look up SET NOCOUNT -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: August 19, 2001 6:47 PM To: CF-Talk Subject: RE: disappearing queries Thanks. -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 18, 2001 1:10 AM To: CF-Talk Subject: RE: disappearing queries I believe that CFQuery will not handle SQL that returns/processes more than one recordset. So if you do an INSERT then a SELECT in a proc/query, you won't get any results back. For stored procedures, you should be using CFSTOREDPROC/CFPROCPARAM/CFPROCRESULT instead. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 7:33 PM To: CF-Talk Subject: disappearing queries Has anyone ever had any problems displaying result sets from a stored procedure using temporary tables? The query works fine in SQL Query Analyser, but CF just won't bring back results. Even stranger is that as soon as the query is run, the debug info comes up with 0 results, and then CF says the query doesn't exist.. Error below. (Note that the asdasdsadsd is referenced properly in the cfoutput tag) asdasdsadsd (Records=0, Time=15ms) Bottom of Form 0 Error Occurred While Processing Request SQL = { CALL cm_qry_listing_obj('1','47','1','1') } Error Diagnostic Information QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (5:1) to (5:30). Date/Time: 08/17/01 10:31:58 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: 210.11.100.2 --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : (07) 3230 8811 'merging business + technology' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How can I merge the results of two queries. (tds)
You can use the UNION operator to merge two queries together. --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 1:57 PM To: CF-Talk Subject: Re: How can I merge the results of two queries. (tds) You can do one more thing as they say there are many ways to skin a cat convert both the queries into list or array and then merge them and make them in to one single array or list and then use the combined one for your manipulation hope it works --- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -- Phoenix Global Solutions (India) Pvt Ltd., www.pgsolutions.com - Troy Simpson Troy_SimpsonTo: CF-Talk [EMAIL PROTECTED] @ncsu.edu cc: Subject: How can I merge the results of two queries. (tds) 08/20/01 01:39 AM Please respond to cf-talk I have two queries result sets and would like to merge the data together using ColdFusion. What would be an approprate method to accomplish this task? I have ColdFusion Enterprise Edition 4.5.x Here is an example: I have one query result set like so: ID, author, ACCNO 1, Jack, 2 2, Mo, 4 3, Emma, 6 4, Sydney, 8 5, Mary, 11 ... I have another query result set like this: ACCNO, Title 1, The board 2, The walk 3, The sand 4, The beach 5, The ocean 6, The frost 7, The building 8, The house 9, The grass 10, The mud 11, The car ... I want to join these two result sets so that I get a third query result set like this: ACCNO, Title, ID, Author 1, The board, , 2, The walk, 1, Jack 3, The sand, , 4, The beach, 2, Mo 5, The ocean, , 6, The frost, 3, Emma 7, The building, , 8, The house, 4, Sydney 9, The grass, , 10, The mud, , 11, The car, 5, Mary I know that in this example I could use the database to perform an outer join, but the real query sets are not comming from a database. Thanks in advance. Sincerely, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 Some people change when they see the light. Others, when they feel the heat. -- corvis advertisement ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How can I merge the results of two queries. (tds)
Sorry, didn't read until the last sentance -- my solution was DB orientated.. -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 2:01 PM To: CF-Talk Subject: RE: How can I merge the results of two queries. (tds) You can use the UNION operator to merge two queries together. --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 1:57 PM To: CF-Talk Subject: Re: How can I merge the results of two queries. (tds) You can do one more thing as they say there are many ways to skin a cat convert both the queries into list or array and then merge them and make them in to one single array or list and then use the combined one for your manipulation hope it works --- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -- Phoenix Global Solutions (India) Pvt Ltd., www.pgsolutions.com - Troy Simpson Troy_SimpsonTo: CF-Talk [EMAIL PROTECTED] @ncsu.edu cc: Subject: How can I merge the results of two queries. (tds) 08/20/01 01:39 AM Please respond to cf-talk I have two queries result sets and would like to merge the data together using ColdFusion. What would be an approprate method to accomplish this task? I have ColdFusion Enterprise Edition 4.5.x Here is an example: I have one query result set like so: ID, author, ACCNO 1, Jack, 2 2, Mo, 4 3, Emma, 6 4, Sydney, 8 5, Mary, 11 ... I have another query result set like this: ACCNO, Title 1, The board 2, The walk 3, The sand 4, The beach 5, The ocean 6, The frost 7, The building 8, The house 9, The grass 10, The mud 11, The car ... I want to join these two result sets so that I get a third query result set like this: ACCNO, Title, ID, Author 1, The board, , 2, The walk, 1, Jack 3, The sand, , 4, The beach, 2, Mo 5, The ocean, , 6, The frost, 3, Emma 7, The building, , 8, The house, 4, Sydney 9, The grass, , 10, The mud, , 11, The car, 5, Mary I know that in this example I could use the database to perform an outer join, but the real query sets are not comming from a database. Thanks in advance. Sincerely, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 Some people change when they see the light. Others, when they feel the heat. -- corvis advertisement ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Caching..
Ahh, so basically caching a query with the same name and application within an application that uses different templates (e.g. dsp_list.cfm and dsp_list2.cfm) but the same query is pointless? Darryl -Original Message- From: Daniel Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 4:32 PM To: CF-Talk Subject: Re: Query Caching.. The cached query will persist for the template it was run from, and the only way to override it (even if CF gets newer info from the database in an identical query elsewhere) is to use the cfobjectcache tag (5.0 only) like this: cfobjectcache action=clear The syntax is as follows: cfquery name=get_content datasource=#request.www_ds# maxrows=1 dbtype=ODBC cachedwithin=#CreateTimeSpan(1,0,0,0)# ... where the timespan arguments are days,hours,minutes,seconds. - Original Message - Just a quick question about query caching (using CACHEDWITHIN attrib) -- Is the cached query tied to a particular application? Sincerely, Daniel Larson [ [EMAIL PROTECTED] | www.larsoninternet.org ] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
disappearing queries
Has anyone ever had any problems displaying result sets from a stored procedure using temporary tables? The query works fine in SQL Query Analyser, but CF just won't bring back results. Even stranger is that as soon as the query is run, the debug info comes up with 0 results, and then CF says the query doesn't exist.. Error below. (Note that the asdasdsadsd is referenced properly in the cfoutput tag) asdasdsadsd (Records=0, Time=15ms) Bottom of Form 0 Error Occurred While Processing Request SQL = { CALL cm_qry_listing_obj('1','47','1','1') } Error Diagnostic Information QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (5:1) to (5:30). Date/Time: 08/17/01 10:31:58 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: 210.11.100.2 --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : (07) 3230 8811 'merging business + technology' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: got hack !! Hacked By Chinese!
Refer to the messages in this list about IIS hacks and red worm.. Your problem is related to an index server security hole. You can get the patch from: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/ bulletin/MS01-033.asp Darryl -Original Message- From: nyon [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:17 PM To: CF-Talk Subject: got hack !! Hacked By Chinese! Hi, I got this while trying to access my CF pages. Welcome to http://www.worm.com ! Hacked By Chinese! Please. 1. What is the cause ? 2. How to I get it corrected ? Nyon ~~ 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: GROUP BY gives an error?
Should have been: SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename, modeldescription, modelname, year -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:18 AM To: CF-Talk Subject: RE: GROUP BY gives an error? you need to include all of the columns in the SELECT in the GROUP BY also. e.g. SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename, modeldescription, modelname, year -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:31 AM To: CF-Talk Subject: GROUP BY gives an error? Hello cf-Talk, I have a simple query. cfquery name=best datasource=#Application.dsn# SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename /cfquery It keeps giving me this error:ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'modelname' as part of an aggregate function. What the heck am I missing here? The makename field is a lookup field in an Access database, would this have anything to do with it? So far the lookup has worked fine in queries. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ 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: GROUP BY gives an error?
you need to include all of the columns in the SELECT in the GROUP BY also. e.g. SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename, modeldescription, makename, year -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:31 AM To: CF-Talk Subject: GROUP BY gives an error? Hello cf-Talk, I have a simple query. cfquery name=best datasource=#Application.dsn# SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename /cfquery It keeps giving me this error:ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'modelname' as part of an aggregate function. What the heck am I missing here? The makename field is a lookup field in an Access database, would this have anything to do with it? So far the lookup has worked fine in queries. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ 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 hijacking - help!
cflock scope=session type=exclusive timeout=30 also does the same job, as this supersedes the old syntax. Darryl -Original Message- From: Chris Straight [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 7:04 AM To: CF-Talk Subject: RE: Session hijacking - help! just a thought are you using cflock to lock the session variables. We just had this issue because one of our systems was a rush job. Once I added cflock tags everything was ok again. It only started doing it when a lot of people were using it. CF doesn't seem to handle it very well (It wasn't designed to). when you create a cflock you should use the #session.sessionID# as the name which takes the client cfid and cftoken and combines them to make a unique ID for that session. cflock name=#session.sessionID# type=exclusive timeout=30 Hope this helps if not I really couldn't tell you off the top of my head what it would be. Chris Straight Web Developer University of Oregon Bookstore 895 E. 13th Ave Eugene, OR 97401 (541) 346-4331 http://www.uobookstore.com -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 1:13 PM To: CF-Talk Subject: Session hijacking - help! Hey gang, I've got a really WEIRD thing going on... a true stumper. Got a CF/SQL7 box. It's sitting on a client's internal LAN. Hence, their users on their LAN (and they're nationwide - I believe users in the field dial in and/or have dedicated lines, I'm not 100% sure - not my problem) hit this box pretty quick when they're using the app that's running on it (it's a computer-based training app). The app keeps track of users via session variables - tuck the userID in a session var, etc. No sweat. The thing is... occasionally, when there are multiple people accessing the training app at the same time, sessions get hijacked. To wit: Joe is in the training app. His 'session.userid' is 123. Mary comes along, logs in, starts using the app. Her userid is 456. At some point, Joe's computer all of a sudden thinks its session.userid is 456 - Mary's. Why? On top of all this... this only happens INSIDE THEIR LAN. Those of us on the outside (in our office, and in the office of the partner company who develops the content for the system) have NO problems like this. I've put in some debug display code and would have the company's propellerheads go through the app, from within their LAN, and boom - the output of the session.userid changes. The IP info for the client boxes is fine - I was spitting that out with the rest of the info - and it went unchanged. I understand that session info is stored in the server's RAM. I'm considering trying to swap over to a client variable-based method, and storing that info in the database. Thoughts? --Scott ~~ 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
Dynamic content (pages) being served from SQL Server 2000
What are people's opinions on serving a page (i.e. info from a text data type) from a database over serving it from a text file. For instance, we're working on a content management system where the page information is being stored in the database rather than a text file. I guess the main question is which is quicker and more efficient over which is the easiest to search. --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : (07) 3230 8811 'merging business + technology' ~~ 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: Dynamic content (pages) being served from SQL Server 2000
Dick, Actually case 2 is exactly what we're doing.. Probably didn't make that clear in my post. We're keeping the actual content in the database, not the page itself. I guess I was after something like you described in your case 2 explaination. I see this type of content management system is pretty powerful and easy to maintain. Darryl -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 7:26 PM To: CF-Talk Subject: Re: Dynamic content (pages) being served from SQL Server 2000 Darryl Case 1: Storing static xxx.html pages in a text field of database as opposed to storing them as xxx.html pages on the server. 1) User requests a page with: href=GetPage.cfm?PageName=xxx 2) Your program retrieves page from db and serves with cfcontent tag + Some gain in page management of pages with db + Can search without need to rebuild index (ala Verity) - Much additional overhead of CF server and SQL Server - inefficient use of SQL db - More complex page creation/maintenance interface than straight html (copy/paste between html editor and data entry form) = no real advantage of updating redundant information (same information appears in multiple pages) = no real navigational advantage Case 2: Database-Driven Dynamic Content - The information used to dynamically generate pages (as opposed to the pages themselves) is stored in the db. 1) User requests information (usually as part of a search and drill-down), with: href=GetInfo.cfm?Table=NewsField=anyAction=containsValue=Fusion 2) Your program: Analyzes the request and builds a query Queries the db formats a list of candidates - those records satisfying the search, from information in the db presents re-presents next/previous groups of candidates formats detail of candidate selected as result of drill-down. Combines data from fields in db with markup, headings, etc. from template presents detail of selected candidate + Large gain in management of information with db + Very flexible search/sort capability + Easy to impose/change format and presentation standards... they are in the template not in the data + Content can be created/maintained by non-techies + Queries can be cached by CF + Eliminates redundant information and all the associated problems + Simplifies creation/maintenance data + Great advantage in efficiency of navigation and drill-down + Great improvement in user control and user experience... the site works the way he wants to work + Great flexibility in what information is presented and how it is presented (as compared to programs like Verity). For example in a drill-down for suppliers of a certain product you present a next/prev list of candidates. When a candidate is selected, you show the detail information and: other products he sells news articles where he is mentioned... + Easy to enter data in advance of its being made public, then later, making it available (release date, etc). For example: 10 % price increase in all products. introducing a new product line publishing This Week's News Articles + Easy to maintain statistics/ monitor site activity in real time + Ability to create/update content from wherever; whenever! - Slight additional overhead of CF server and SQL Server There are probably many other points that could be made. Case 2, IMHO, is where CF and SQL really shine! HTH Dick At 5:30 PM +1000 6/4/01, Darryl Lyons wrote: What are people's opinions on serving a page (i.e. info from a text data type) from a database over serving it from a text file. For instance, we're working on a content management system where the page information is being stored in the database rather than a text file. I guess the main question is which is quicker and more efficient over which is the easiest to search. --- Regards, Darryl Lyons ~~ 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: Client variables
If you store your vars in a database, then yes. -Original Message- From: Haryono ... [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 12:07 PM To: CF-Talk Subject: Client variables does it accessible or not when client variables from one site is going to accessed by the other site? Thank you for your answer ~~ 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 Pro okay for shopping carts?
Cold Fusion express can handle a small shopping cart app :) -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 1:26 PM To: CF-Talk Subject: Re: CF Pro okay for shopping carts? On 3/7/01, Sean Faulkner penned: This may be today's dumbest question, but is CF Pro robust enough to handle a small shopping cart app? Yes it is. Robust enough that is, not today's dumbest question. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: File upload vs. Virus protection
Anyone gotten that going with NT? -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 1:28 PM To: CF-Talk Subject: Re: File upload vs. Virus protection We installed McAfee VirusScan for Linux and call a script with CFEXECUTE that scans just the one file that was uploaded. Based on the results we can delete the file and display a warning. At 02:57 PM 2/28/01 -0800, [EMAIL PROTECTED] wrote: If I allow a web user to upload files (MSword docs)is there a way of checking them for viruses on the upload? Mike -- iWon http://www.iwon.com/ - Voted the #1 portal on the Web! ~~ 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 query
Why don't you make it a stored procedure? -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 7:57 AM To: CF-Talk Subject: sql query can anyone help me translate this FROM in my SQL query so CF will like it? it works fine in SQL but bombs in CF with syntax errors. FROM INT_AUX_LISTING LEFT JOIN int_aux_listing as CompanyListing ON (int_aux_listing.company_list_id = CompanyListing.Listing_ID) AND (int_aux_listing.Company_list_src_id = CompanyListing.Listing_src_id)) left JOIN INT_AUX_LST_ADDR ON (INT_AUX_LISTING.LISTING_SRC_ID = INT_AUX_LST_ADDR.LISTING_SRC_ID) AND (INT_AUX_LISTING.LISTING_ID = INT_AUX_LST_ADDR.LISTING_ID)) left JOIN INT_AUX_ADDRESS ON (INT_AUX_LST_ADDR.ADDRESS_SRC_ID = INT_AUX_ADDRESS.ADDRESS_SRC_ID) AND (INT_AUX_LST_ADDR.ADDRESS_ID = INT_AUX_ADDRESS.ADDRESS_ID) left JOIN INT_AUX_LST_PHONE ON (int_aux_listing.LISTING_ID = INT_AUX_LST_PHONE.LISTING_ID) AND (int_aux_listing.LISTING_SRC_ID = INT_AUX_LST_PHONE.LISTING_SRC_ID)) left JOIN INT_AUX_PHONE ON (INT_AUX_PHONE.PHONE_ID = INT_AUX_LST_PHONE.PHONE_ID) AND (INT_AUX_PHONE.PHONE_SRC_ID = INT_AUX_LST_PHONE.PHONE_SRC_ID)) left join int_phone_typ on (int_aux_phone.phone_typ_id = int_phone_typ.phone_typ_id) left join int_relation_typ as Phone_Relation_TYP on (int_aux_lst_phone.rltn_typ_id = phone_relation_typ.rltn_typ_id) i was working with the query builder and it seemed like it was using { instead of (. thanks for your help ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Two functions with a single onClick?
or you can just call both functions from the onClick event like so: onclick="doOne(); doTwo()" -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 9:27 AM To: CF-Talk Subject: RE: Two functions with a single onClick? Les, here's some code for you. HTH. david - !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleUntitled/title script language="JavaScript" !-- function doTwo(){ doFirst(); doSecond(); } function doFirst(){ alert("I'm the first function"); } function doSecond(){ alert("I'm the second function"); } // -- /script /head body form name="myForm" run two javascript functions by clicking on this button: input type="Button" name="clickMe" onclick="doTwo();" value=" Click Me! " /form /body /html -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:58 PM To: CF-Talk Subject: Two functions with a single onClick? Can more than one javascript function be performed with a single onClick? If so, how would it be written? Thanks, Les ~~ 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
When you set up an SQL datasource (usually OLEDB in CFADMIN), you specify which server the database in on -- e.g. www.servername.com.. You reference the datasource the same way in the CFQUERY. However I do recommend not setting up the datasource with the username and password and instead specifying this in the CFQUERY tag. Otherwise other people can access your datasource outside of your app.. Darryl -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 3:55 AM To: CF-Talk Subject: SQL How do you query a SQL database on another server? I do local querys on my Access DB's, and im thinking about setting up a MS SQL box or MY SQL box. Is it just a matter of setting up the datasource in the CFQUERY different? Thanks, Chad ~~ 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: Detect browser type
Use CF_Browser -- it does all the work for you. You can get it from the allaire dev exchange. -Original Message- From: Karen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 5:41 PM To: CF-Talk Subject: Detect browser type Good day ppl. I'm not sure if this is a "waste-time-question" but I'm going to give it a try here as I'm all new to ColdFusion. May I consult the expertise out there of how to detect a browser type by using ColdFusion ? I've got the user agent value by calling the environmental variable #cgi.HTTP_USER_AGENT# and initially I've thought to do like this, CFSWITCH EXPRESSION=#cgi.HTTP_USER_AGENT# CFCASE VALUE="Netscape" /CFCASE CFCASE VALUE="MSIE" /CFCASE CFDEFAULTCASE /CFDEFAULTCASE /CFSWITCH This wouldn't work as the user agent value that I've got is (I'm using Netscape under Linux) - Mozilla/4.61 [en] (X11; I; Linux 2.2.12-20 i686) How do I split the line into some informations that I want ? And how should I check against the browser types (is "Netscape" / "MSIE" the correct parameters to check against with ?) ? Thank you in advance for the helps. Regards, 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: CFHTTP Link Checker?
You could use CFHTTP to do a GET on the URL. If it fails then it's not valid.. (I'd keep a running log of the number of times, then you can say after 4 times in a week, then the link must be down.) Darryl Lyons -Original Message- From: John B Venable Jr [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 2:00 PM To: CF-Talk Subject: CFHTTP Link Checker? Is there any way to check for the validity of HTML links by using Cold Fusion. If so, any resources to explain how would be of great help. TIA. -- John B. Venable Jr. it took men about five thousand years, counting from the beginning of number symbols, to think of a symbol for nothing. --Isaac Asimov 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: Killing Single Session Variable
cfset StructDelete(Session, "varname") -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 3:16 AM To: CF-Talk Subject: Killing Single Session Variable how do u kill a single session variable? ~~ 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
Login failed for user CFADMIN
has anyone ever gotten this error - "Login failed for user CFADMIN"? --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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: Login failed for user CFADMIN
Hard to tell.. I'd say it would be for a query though.. -Original Message- From: S C [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:20 PM To: CF-Talk Subject: Re: Login failed for user CFADMIN When do you get this error? With a query? --- Darryl Lyons [EMAIL PROTECTED] wrote: has anyone ever gotten this error - "Login failed for user CFADMIN"? --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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: Web Chat using CF?
http://www.cfchat.net/cfchat/ Very good one.. -Original Message- From: Phil Palmer [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 11:29 AM To: CF-Talk Subject: Web Chat using CF? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C08992.D7408AF0 Content-Type: text/plain; charset="iso-8859-1" Dear all I am looking for a 'web chat' facility which I can use on our web page such that people can contact us via our web page and chat with a rep rather than phoning. I know that one could do this with M$ Net Meeting but I would like to use CF or a java applet perhaps that doesnt require you to have Net Meeting installed. Is anyone aware of a CF based approach to this?? Regards Phil Palmer --_=_NextPart_001_01C08992.D7408AF0 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.00.2314.1000" name=GENERATOR/HEAD BODY DIVFONT face=Arial size=2SPAN class=862372201-29012001Dear all/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001I am looking for a 'web chat' facility which I can use on our web page/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001such that people can contact us via our web page and chat with a rep/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001rather than phoning.nbsp; I know that one could do this with M$ Net Meeting/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001but I would like to use CF or a java applet perhaps that doesnt require/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001you to have Net Meeting installed./SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001Is anyone aware of a CF based approach to this??/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001Regards/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001Phil Palmer/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=862372201-29012001/SPAN/FONTnbsp;/DIV/BODY/HTML --_=_NextPart_001_01C08992.D7408AF0-- 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: stop reposting of form data
Fusebox does do that... You simply make the form action piont to an action fuse, (act_xxx_post or something) and then cfinclude the action template and then cflocation to a success page or anywhere else.. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 20, 2001 1:35 AM To: CF-Talk Subject: Re: stop reposting of form data I think this is how Fusebox gets around the problem of having all requests go to the same page (index.cfm) (dont quote me on that... I dont know much about Fusebox...) But the problem with this is you are causing another round-trip from the client to server and back again. Does anyone have a method that DOESN'T cause this delay? At 02:17 AM 11/19/00 -0600, Phoeun Pha wrote: this is how i handle my stuff. let's say we have 2 templates. First template has the form fields and stuff. template 2 sends the information to a database and also displays a "Thank You!" message. if the user were to click "Refresh",the information could be entered twice, thats bad! The solution is to have 3 templates. First template has the form fields. The second template does the dirty work, ya know, inserting stuff into database. At the end of that template, do a CFLOCATION to template 3, which says 'Thanx man, you've made me richer!". Now, if the user refreshes, they get the same message, but no form data is reposted. cool eh? Considerations: if u need to display some data from the form variables on that last page, like "Thank you, [Name], yo've made me richer!" , i say do a CFlocation (ex. url="thanxpage.cfm?name="Form.name") in the middle template with URL variables and display them on the third page. hope this helps! - Original Message - From: Mike Grey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 12:41 PM Subject: stop reposting of form data What method is used to stop data from being reposted when a user attemps to reload an action page. Thanks Mike Grey ~~ 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
Login Failed for User CFADMIN
Has anyone periodically gotten the error "login failed for user CFADMIN" when trying to access templates? It only happens occasionly, but is still a pain. I assume it has something to do with the datasource? Login limits problem? --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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: Multi-language Content Management
Yeah, I've pretty much being going down the same path. I've got multi-language storage happening quite well. A note though, make sure you attach language attrib to your page, that way you can specify the char set to use for the page, therefore making sure the user loads the correct charset. Now, searching it all is going to be interesting :) -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 12:17 AM To: CF-Talk Subject: RE: Multi-language Content Management I have been considering this myself. What I may implement is storing all of the web text in a database table for each language (CF doesn't support unicode right now) and use a URL variable to determine which language to retrieve from the database and then server the page using CF. I haven't gotten much beyond the concept stage, but any meb content management system should be able to be modified for this purpose. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 18:05 To: CF-Talk Subject: Multi-language Content Management Has anybody developed an architecture or worked out a multi-language content Management system in CF. I guess the main question is regarding the display of numerous languages within the same 'site' or even the same 'page'. I've basically worked out that English and Japanese or Chinese on the same page won't affect the display, but chinese and japanese on the same page looks to be pretty hard. (All of the data is kept in the database btw). Any ideas or suggestions? --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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
Multi-language Content Management
Has anybody developed an architecture or worked out a multi-language content Management system in CF. I guess the main question is regarding the display of numerous languages within the same 'site' or even the same 'page'. I've basically worked out that English and Japanese or Chinese on the same page won't affect the display, but chinese and japanese on the same page looks to be pretty hard. (All of the data is kept in the database btw). Any ideas or suggestions? --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT, but helpful maybe
Any chance of getting the source code? I love the way it works, but I'd like to customise the form/query output.. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 3:48 PM To: CF-Talk Subject: OT, but helpful maybe Howdy all. I built myself a cool little template for creating forms, cfparam and cfset tags, and insert and update queries. Just paste in a comma delimited list of field names, then on the next screen you can specify the type of field, whether it is required, enter your option tags for select fields, set the field size and maxlength, cols and rows in textarea and all kinds of neat stuff. It will then make you a nice little table you can copy and paste into your template. Then you can choose which fields you want to include and make your insert and update queries, specifying the column type (Date, Number, etc.) You can also make cfset and cfparam tags from the field names. Took me all day, but it should save an hour or two every time I use it. Feel free to play with it and use it all you like. http://www.twcreations.net/makeform/ -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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: Securing SQL 7.0 database
I think the second option of specifying the username and password in the query tag would work best - as it really isn't a globally available file - especially in an ISP environment. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 9:22 PM To: CF-Talk Subject: RE: Slightly OT: Securing SQL 7.0 database What's the best way to secure a database against access from other applications? I know you can specify the username and password in the datasource admin, but that allows other apps to use the datasource.. Specifying the username and password int he cfquery tag seems the best way to go, but that doesn't seem to work.. Not sure as to the best way, but we use this method and it works 1. Create SQL Server 7 database 2. Create a login account for the application that's going to read from/write to that database 3. Give that account the required permissions and access to that database 4. Go to the box that the site is going to be hosted on 5. Set up a SQL Server DSN from that machine to the SQL box 6. In the ODBC DSN settings, specify that is uses a SQL Server login (not NT) and provide the username/password combo for the account you previously created. 7. Also, click on Client Configuration and make sure it's using TCP/IP and not Named Pipes (the default, I think) 8. Test the datasource connects successfully 9. Go into the ColdFusion Administrator on the same box 10. Click on ODBC 11. Click on the DSN you've just created 12. Click on CF Settings 13. Enter the username and password into the username and password fields and update 14. Your queries should now by just referring to DATASOURCE="#YourDSNVarHere#" As you mentioned, all users now have access to the login account by just referring to the DSN. Not sure how to combat this. The alternative is to do everything described above without doing the CF Administrator bit. Then you have to add USERNAME="" and PASSWORD="" in all your CFQUERY tags. But then if someone peeks at your templates (or Application.cfm if you set it globally there), you've also given them access to your database. Each method seems to have its vulnerabilities. Maybe someone else could advise... ? -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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
Multi-language CF sites
Hi, Has anybody successfully built a multi-language dynamic website - where the page data, etc, is kept within the database? How did you display the languages on screen, in the database, etc.. --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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
Stopping people doing the 'I clicked submit twice' thing..
Has anybody found a way around this? It seems that whenever someone clicks submit twice, data is inserted twice (updates are ok). --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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: Stopping people doing the 'I clicked submit twice' thing..
Can you explain more about database flags and how they may come in handy? -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 12:01 PM To: CF-Talk Subject: Re: Stopping people doing the 'I clicked submit twice' thing.. Hi Darryl, Has anybody found a way around this? It seems that whenever someone clicks submit twice, data is inserted twice (updates are ok). You can use javascript to make sure it only happens once or, better but more overhead, write some cf code to make sure you are not doing it twice. Depending on whether you are using client/session variables or not setting a flag is easy, if not then database flags come in very handy :-) -- Yours, Kym ~~ 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: Stopping people doing the 'I clicked submit twice' thing..
That's a great solution, but unfortunately it doesn't work with client-side validation in place using the standard cfinput required="yes" -Original Message- From: Tim Fields [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 11:21 AM To: CF-Talk Subject: RE: Stopping people doing the 'I clicked submit twice' thing.. Darryl, Here's the best solution we've found. It's amazingly simple and it does the job! Note that it's not simply changing the name of the button to "Please Wait" - it actually disables it. Here's the code: input type="submit" value="Submit" onClick="if(this.value == 'Submit') this.form.submit(); this.value = 'Please Wait.';" Good luck, Tim Fields President RGB Studios, Inc. -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 8:25 PM To: CF-Talk Subject: Stopping people doing the 'I clicked submit twice' thing.. Has anybody found a way around this? It seems that whenever someone clicks submit twice, data is inserted twice (updates are ok). ------- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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
Slightly OT: Securing SQL 7.0 database
What's the best way to secure a database against access from other applications? I know you can specify the username and password in the datasource admin, but that allows other apps to use the datasource.. Specifying the username and password int he cfquery tag seems the best way to go, but that doesn't seem to work.. --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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: Allaire, Macromedia merger
Could you do a searh and replace on the text looking for chr(10) and replace it with a br then apply paragraphformat() to it? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 8:21 AM To: CF-Talk Subject: Allaire, Macromedia merger Allaire has been acquired by Macromedia: http://www2.marketwatch.com/quotes/articles.asp?symb=ALLRsid=129237source= htx/http2_mwview=detailedguid=%7BDE0E69E1%2DAC03%2D4326%2D9D1C%2D1EB7A9B69 4EC%7D (credit to Enayet Rasul for this info) 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: Recursive Tree Structure
You could build a recursive template that simply displays data in a tree structure - although it wouldn't look like the CFTREE output. We use a multi-select box here to build parent-child relationships for certain data. With this method though you have to dynamically name the queries otherwise CF gets confused.. Darryl -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 7:16 AM To: CF-Talk Subject: Recursive Tree Structure Okay, I'm coming up empty here. I'm using the cf_selectboxbuildtree tag with some modifications to show our db of publications. All is well. Now, my boss wants me to create a page that will pull out just the publications that are identified by a 1 in a field in a corresponding table, but still use the tree format. Thoughts? Thanks. d Tree table looks like this: nodeid, nodename, parentid, pubid (pubid is null if it's just a branch of the tree and not an actual publication) pubid is the matching field in the pubs table. Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 ~~ 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
Merging Verity and Table search results
Has anyone gotten something like this working? Basically I'm trying to work out a simple way of merging the results within a Verity Index with a normal table query. This would be useful for searching across a content management system for instance where your page data is stored in TXT files and everything else is in the database..?? --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ 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: CAB extracting
Java applets are used within CFFORM if your using a CFTREE or CFSLIDER control. -Original Message- From: Dian Oktosoma [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 1:38 PM To: CF-Talk Subject: RE: CAB extracting I c. Thanks How if I set parameter ENABLECAB="No". What feature of CFFORM will not be available ? What are Java applet-based CFFORM controls used for ? thanks -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 9:35 AM To: CF-Talk Subject: Re: CAB extracting That happens if you use cfform... I avoid cfform for that reason..people using a slow connection sometimes don't realize that the java applets are downloading and just leave, since it takes so long. Al a1webs.com At 09:08 AM 1/12/2001 +0700, you wrote: When someone enter a page in my site for the first time, then a "CAB extracting" window appears. What was that ? Can it be removed ? thanks ~~ 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: request scope revisted
I use request scopes for most of my page level data, ie. mapping names, paths, dsns, site name, contact emails, etc.. I also duplicate most of the session vars into a request structure and use them throughout the app to get around the infamous CFLOCK problems.. Darryl -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 8:44 AM To: CF-Talk Subject: request scope revisted Anyone out there set a request.dsn instead of an application.dsn? If so is there an advantage? Won ~~ 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: ORDER BY question
Is it possible to create a paragraph number field? -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 11:48 PM To: CF-Talk Subject: ORDER BY question I have a table that has three fields: Paragraph, Title, Content. The Paragraph field is a text field, but is the outline number for the particular paragraph in a document. For example, 7.1.1, 7.1.2, etc. I need to output these paragraphs in outline order as they appear in the printed material. Of course, if the paragraphs go past 9, it gets all muffed up because its a text field and not a number field. Example: 7.1, 7.10, 7.11, 7.2, 7.3... Is there any easy way to accomplish this? Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [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: Newbie Question about Application.cfm
Remove the HTML code from the application.cfm file. (And BTW it would have come up with a blank page the first time wouldn't it?) The application.cfm is really where you should be storing your variable declarations - your global variables. E.g. Your login management would be placed within this file. -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 7:52 AM To: CF-Talk Subject: Newbie Question about Application.cfm I'm trying to use session variables for the first time. I've gone into CF Administrator and registered the ODBC to use session and client variables. I also added an Application.cfm file to the top directory where the app resides. The following is all I have in that file: !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleApplication Template/title /head cfapplication name="ISBudgetApp" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" body /body /html The application seems to work fine until I refresh. When I do that, the page just comes up blank, no error message, and the title on the browser is "Application Template". Sorry to ask what should be a simple question. But I've read through my books and can't figure this out. Help, please? ~~ 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_Activedit alternatives??
SiteObjects has just released a FREE WYSIWYG editor which is pretty much as good as Active Edit: http://www.siteobjects.com/index.cfm?fuseaction=showezedit Darryl -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 6:04 AM To: CF-Talk Subject: RE: CF_Activedit alternatives?? That may be true but considering that there are few number of people that will actually be doing the editing and they only have to download the plug-in once, its not that bad. When you edit a second time it's blazing fast. The benefits far outweigh the time to download. It just requires instilling some confidence and security to the client on your part. Usually what I do is sit down at the client's computer and show them what happens while explaining this is only done once. After it's loaded I let the client sit down and let them start playing with it and their 'wonderment' and excitement quickly replace any fears of the initial download. -Sold- Give it a try with them and see if that helps. Some developers work in environments and with companies that are far too large and distributed to sit down and coddle all of the clients/employees. For me, the biggest issue with eWebEdit is the pricing model or lack there of. We inquired with them several times about purchasing many licenses but their fees were fairly exorbitant and, though they informed us they were undergoing a pricing change, we never received that information. In the mean time, several cheaper (free) alternatives have shown up. eWebEdit still has an advantage as far as the Spectra integration goes, but then the new Spectra has fixed the problems and functionality of it's own WYSIWYG HTML editor. What does eWebEdit offer that the ActiveEdit doesn't? Of course, we've actually decided to go with ezEdit because all we really cared about (besides the HTML Editor) was the custom tag and source code availability. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Sincerely, Rob Sherman Allaire Certified Developer Instructor CFDude, Inc. http://www.cfdude.com CF_Office (310) 543-1622 CF_Fax (310) 543-0512 ~~ 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: LOCKING revisited...
So something like cfset request.userinfo.member_id = StructCopy(session.member_id) should work fine? -Original Message- From: Ben Lowndes [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:54 AM To: CF-Talk Subject: RE: LOCKING revisited... Is the duplicate() function supported in 4.01? -- er... unfortunatly not. StructCopy() will be sufficent so long as your not trying to copy a nested structure. Duplicate() is an undocumented feature only present in CF4.5 upwards. Ben. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this even possible?
Just have the image filename in the products table.. pretty simple if that's what you meant. -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 8:51 AM To: CF-Talk Subject: Is this even possible? Hi all, I am wondering if this will even be possible or if I just have a pie in the sky dream. Here it goes: Let's say that you have an online store with a huge inventory of products, we're talking close to 10'000 distinct items. your site has everything we have come to expect from an e-store application (search features, shopping carts, etc..). if by some miracle i had a good quality and not too big (under 10k each) .jpg or .gif for each item in my inventory. would it be possible for me to some how link each of those pictures to its corresponding part in my database? this way when a customer searched for an item, a nice picture could come along with it. again, is this even possible, if so how? thanks in advance for your time and help, nelson ~~ 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: Help!!! Cooke Monster!!
You'd have to set the cookie domain to .beachin.net, otherwise only test.beachin.net could read it (or subdomains of test). -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:58 AM To: CF-Talk Subject: Re: Help!!! Cooke Monster!! If you use CFCOOKIE, there is a domain attribute. If you set a domain cookie from: test.beachin.net You should be able to read it from *.beachin.net It looks as if you are doing it correctly, but I haven't used the meta tag syntax to set cookies, so I can't be sure. If you drop down to CFCOOKIE, make sure you do not use CFLOCATION on the same page. Emmet McGovern wrote: Is there a way to set up a cookie on one domain and read it from another domain? I have 2 servers, one is unix and the other is cf. I need to secure the cf server by only allowing access to it if a cookie has been set by the linux server, only im having problems reading the cookie on the cf side. The linux servers domain would be content.beachin.net while the cf server is files.beachin.net right now im trying to meta set the cookie on the unix server (content.beachin.net) META HTTP-EQUIV="Set-Cookie" Content= "beachfile=10"; domain=".beachin.net" and check its existence on the cf server (files.beachin.net) with cfif isdefined("cookie.beachfile") blah blah blah /cfif Am i doing something wrong? Or should i be doing this another way? Thanks, Emmet McGovern Systems Admin Byte Size 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: session variables
Just to let you know, you can also setup a request structure for each of your session variables and duplicate the values in the application.cfm/app_globals.cfm file. i.e. cflock ... cfset request.userinfo.member_id = duplicate(session.member_id) /cflock That way you only have to lock your session vars once.. Any comments or further explainations on this? Darryl Lyons -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 9:30 PM To: CF-Talk Subject: RE: session variables Ensure that wherever you reference or set session variables that you lock them by enclosing the code with: CFLOCK TIMEOUT="30" NAME="#Session.SessionID#" TYPE="ReadOnly" your code /CFLOCK regards, Nick Betts PoulterNet Leeds UK. -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 07 December 2000 11:21 To: CF-Talk Subject: session variables I am getting a strange occurrences with session variables on a project. On some systems that login to the project it looses the session variables and on others it does not loose any of the session variables. Anyone have any ideas? Dominic ~~ 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: CFFILE and IE 5.0 on a Mac doesn't work
CFTRY and CATCH the error? I only had this problem when the file field was optional... -Original Message- From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 6:06 AM To: CF-Talk Subject: CFFILE and IE 5.0 on a Mac doesn't work Hello, I'm wondering if anyone has found a workaround to the following situation...we are using CFFILE to upload .gif and .jpg files to our server. The scripts work fine on Netscape and IE on a PC, but only work with Netscape on a Macintosh. The mac OS is 9.0 and we are using IE 5.0. I have a couple of links with relevant information below, but have not been able to find (nor do I know) if a workaround to this problem exists. We get the following error code: "Error attempting to save uploaded file to path 'D:\inetpub\websites\oursite\.' Access is denied. (error 5)" Microsoft has a knowledge base article (which doesn't look promising) at: http://support.microsoft.com/support/kb/articles/Q161/3/95.asp?LN=EN-USSD=g nFR=0qry=RFC%201867rnk=3src=DHCS_MSPSS_gn_SRCHSPR=IE A thread in the forums about this is at: http://forums.allaire.com/devconf/Index.cfm?Message_ID=428762 THANK YOU FOR ANY HELP!! IT IS GREATLY APPRECIATED! Cheers, Craig Craig A. Zingerline Advanced Media Productions Web Application Developer ~~ 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: Single Thread
The other thing to note though is that if you're an ISP and people are not locking their variables properly then the alternative is probably going to be worse (i.e. possible server crashes). I've set our server to Single Threads mainly becuase we've got a lot of cold fusion sites hosted and you never know what their code will have. If you've got a dedicated server or only for inhouse devleopment (e.g. you know what's on there) then I'd agree with Philip.. Any thoughts on this? Darryl -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 5:07 AM To: CF-Talk Subject: RE: Single Thread Is there any performance hit by setting CF to Single Thread? If it's a real-world site, then hell yeah! Think about this - if you're reading from a database and your queries and calculations take 2-3 seconds, then nobody else can get a result from your server until that process has finished! Allaire has guidelines on how many threads you should set your server to (I think it's something like 3-4 per processor), but I still think that's a little low (especially if your machine only server CF and the website) HTH Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Application.cfm
Do you use the fusebox methodology? -Original Message- From: Benjamin Fitts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 10:01 AM To: CF-Talk Subject: RE: Application.cfm Regarding Application variables. When my code wasn't properly written I thought custom tags couldn't read application variables but I figured out I was doing something wrong. Custom tags can read application variables; just scope the variable as application.variablename. You need to scope the variable BOTH in the application.cfm and the custom tag. In your application cfset application.variablename = "variable" In your custom tag #application.variablename# Scoping it as request.variablename is BAD! The request scope is set for each PAGE request and is not the same thing as application scope. Before I figured out my application scoping problem I set everything to request scope only to have to go back and change it later. This is a big performance issue if you run a big site. If your variables aren't available to your custom_tag I think you have another problem with your code that should be examined. Also remember to always try and scope your variables. Local variables are variables.scope application are application.scope session variables are session.scope etc. Benjamin Fitts Web Developer uClick [EMAIL PROTECTED] -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 3:19 PM To: CF-Talk Subject: RE: Application.cfm No, I don't believe so - custom tags - called by cf_ or cfmodule are run on a separate thread, so they aren't aware of application variables (like #dsn# for your datasource). The datasource is usually what I ran into trouble with, so I passed it as an attribute: cfmodule template="test.cfm" userid="10" dsn="#dsn#" Then attributes.userid and attributes.dsn would be available to me in my tag test.cfm. hope this helps. je -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 11:19 AM To: CF-Talk Subject: Application.cfm Would application variables be available to a module (i.e. a template called by CFModule) ? And if they are how far up the tree will CF look for the application.cfm file? My problem is I set a variable called datasource equal to my DSN name. I attempt to reference #datasource# and even #application.datasource# in my module and it isn't available. Any help or suggestions would be appreciated. Neil ~~ 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: Display execution time
Query time is easy = simply add debug="yes" to the cfquery tag -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 6:58 AM To: CF-Talk Subject: Display execution time Forgive my ignorance, but is there a way to display page and/or query execution time within a web page? I do not have access to the server that the page is running on and therefore cannot turn on "Show processing time" in the Debug settings of the Administrator. Thanks in advance, Andy ~~ 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: cfstored procedure problem
I'm pretty sure you don't need the quotes in your SQL statement -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 7:46 AM To: CF-Talk Subject: cfstored procedure problem Hi everyone, I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 This is my stored procedure in SQL: @SAMAccountName varchar AS SELECT UserID FROM PasUsers WHERE SAMAccountName = '@SAMAccountName' Here is my CF Code: CFLDAP NAME="GetUser" SERVER="LDAPSERVER.COM" ACTION="QUERY" ATTRIBUTES="SAMAccountName" SCOPE="subtree" FILTER="SAMAccountName=#cgi.auth_user#" START="" USERNAME="mydomain\sal.rosales" PASSWORD="password" PORT="" TIMEOUT="30" CFSTOREDPROC DATASOURCE="#application.datasource#" DBNAME="userpreferences" PROCEDURE="GetUserID" CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@SAMAccountName" VALUE="#GetUser.SAMAccountName#" TYPE="In" CFPROCPARAM TYPE="Out" DBVARNAME="@UserID" VARIABLE="UserID" CFSQLTYPE="CF_SQL_INTEGER" /CFSTOREDPROC cfoutput#UserID#/cfoutput I keep getting a 'Data Access Error Unknown data' Sal ~~ 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