CF Auction Tool?
Does anyone know of a good auction tool written in CF that would also be customizable? I remember an add from the Coldfusion Developer's Journal that would sometimes appear on the inside front page, but can't remember the name. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFPOP fails on unicode-1-1-utf-7 ????
if i recall correctly unicode-1-1-utf-7 is obsolete Obsolete maybe, but still one of the most prevalent character set encodings for bounce messages :( MS mail servers produce mails encoded with this character set for instance... Overall about 70% of bounce messages I deal with are encoded with unicode-1-1-utf-7 followed up with a mix of US-ASCII, WINDOWS-1252 and very rarely utf-8. If I didn't handle them (utf-7 encoded mails) by choosing to skip or delete them, the effectiveness of tracking bounce messages would be pretty much killed. Paul ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183689 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP fails on unicode-1-1-utf-7 ????
Unfortunately, afaik, you can't do anything. You can delete the message however. On Tue, 09 Nov 2004 01:02:47 -0500, Anders Green [EMAIL PROTECTED] wrote: Raymond Camden wrote: You can, however, get one msg at a time wrapped in cftry. And when it craps out, do what with the message? Still can't read it. :( At 12:26 AM 11/9/2004, Paul Hastings wrote: if i recall correctly unicode-1-1-utf-7 is obsolete so don't expect much action from anybody on this. Ahhh. Sounds about right. I bought the CFX_POP3 tag as mentioned. It handled the problem email without any problems. Also it managed the .eml attachments, which CF_POP didn't. So I'm back in business. :) Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183690 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Formatting problems
Hi guys, I've got a fairly basic problem I have a form with a text area tag whereby I can cut and paste a word doc. This form then inserts into a SQL database. However when I try to cfoutput query the information all my carriage returns are missing and everything is wrapped and no paragraphing or anything. Any ideas how to fix this problem? Thanks in advance, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183691 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Formatting problems
Have you tried cfoutput#ParagraphFormat(qry.column)#/cfoutput On Tue, 09 Nov 2004 12:39:58 +, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I've got a fairly basic problem I have a form with a text area tag whereby I can cut and paste a word doc. This form then inserts into a SQL database. However when I try to cfoutput query the information all my carriage returns are missing and everything is wrapped and no paragraphing or anything. Any ideas how to fix this problem? Thanks in advance, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183692 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Formatting problems
No I hadn't but I have now! It works. :) Thanks very much and have a good Tuesday! Saturday On 9/11/04 12:47 pm, Mark Drew [EMAIL PROTECTED] wrote: Have you tried cfoutput#ParagraphFormat(qry.column)#/cfoutput On Tue, 09 Nov 2004 12:39:58 +, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I've got a fairly basic problem I have a form with a text area tag whereby I can cut and paste a word doc. This form then inserts into a SQL database. However when I try to cfoutput query the information all my carriage returns are missing and everything is wrapped and no paragraphing or anything. Any ideas how to fix this problem? Thanks in advance, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183693 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Session vars and IFRAME
Hi, I am developing an app for a local printing firm allowing them to resell their products through a range of resellers sites. The way I'm doing it is to use an IFRAME to pull in the menus and products direct from the clients site. The problem I have is that the IFRAME is not saving session variables which causes big problems as the cart cannot be retained, logins, etc. It looks like to me that when you refresh the main IFRAME pane, the CFID is being regenerated each time thus clearing the vars. My question is is this the best way forward? Why are the session vars not being kept? How do I get them to stay? Why is the sky blue! ;-) TIA! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183694 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session vars and IFRAME
Are both locations in the same domain? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183695 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
Phil Williams wrote: I am developing an app for a local printing firm allowing them to resell their products through a range of resellers sites. The way I'm doing it is to use an IFRAME to pull in the menus and products direct from the clients site. IFRAMEs might not be a good idea in the light of the latest developments :-) The problem I have is that the IFRAME is not saving session variables which causes big problems as the cart cannot be retained, logins, etc. Do you have this problem with every browser? Can you try it with FireFox and the LiveHTTPHeaders plugin so you can see what exactly you are sending to the server? Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183696 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session vars and IFRAME
IFRAMEs might not be a good idea in the light of the latest developments :-) They still are... trust me, in a big web application you'll beg for iframes. ;) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183697 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Farcry CMS: How well does farcry scale?
Has anyone done scalability/performance testing with farcry cms? I'm considering implementing it for my site, but am concerned about performance on a highly hit sites... Anyone who has done some testing and could provide some feedback, it would be greatly appreciated. Thanks dbk NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Oracle native drivers stop verifying (CF5)
For some functions we use the native Oracle 8.0 drivers supplied with CF 5.0 Enterprise to access Oracle 8i. They worked fine till Monday, now none of them work and they will not verify. If we submit a query using one of the native data sources it just never comes back - we do not get an error message. Recreating the native data sources does not fix the problem. Our Oracle people insist no changes were made in their area. Our server guy says the same. Yet some of these data sources worked fine on Friday and none worked on Monday . . . Any ideas what might be going on? We're running CF 5.0 Enterprise on Windows 2000 Adv Server . . . George ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183699 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfmx odbc socket
We have Coldfusion 6.1. Enterprise on a Linux/UNIX Apache server. In the available database drivers the ODBC Socket (and MS Access) is missing. Does anybody know if this is supposed to be so? Is there a solution to connect to an ODBC database anyway? I don't know if the SequeLink package, which is what CFMX uses for ODBC, is available for Unix. However, in your datasource driver list, I think you should have a Unicode driver for Access that doesn't rely on SequeLink. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183700 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
Micha Schopman wrote: IFRAMEs might not be a good idea in the light of the latest developments :-) They still are... trust me, in a big web application you'll beg for iframes. ;) In a big network environment I beg for a proxy that removes all iframes for user agents that identify themselves as MSIE. I prefer some broken applications over an infected network. Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183701 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session vars and IFRAME
Jochem, Thanks for the LiveHttpHeaders info. I just installed it. It rocks!! Do you have this problem with every browser? Can you try it with FireFox and the LiveHTTPHeaders plugin so you can see what exactly you are sending to the server? Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183702 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Oracle native drivers stop verifying (CF5)
For some functions we use the native Oracle 8.0 drivers supplied with CF 5.0 Enterprise to access Oracle 8i. They worked fine till Monday, now none of them work and they will not verify. If we submit a query using one of the native data sources it just never comes back - we do not get an error message. Recreating the native data sources does not fix the problem. Our Oracle people insist no changes were made in their area. Our server guy says the same. Yet some of these data sources worked fine on Friday and none worked on Monday . . . Perhaps there were some network changes made? You might try connecting from the CF server console using SQL*Plus. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183703 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
On Tuesday 09 Nov 2004 13:17 pm, Jochem van Dieten wrote: IFRAMEs might not be a good idea in the light of the latest developments :-) Which ones are they then ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Primary Key Justification
I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183705 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session vars and IFRAME
Iframes give you the ability to split your web application into smaller pieces. With IE as well as FireFox you reach certain limits for what a single document canvas can handle. Especially IE because it still lacks a good garbage collector (currently implemented method is mark sweep). If you put all the components like dhtml menu's, dhtml treeview, dhtml listviews, as well as the data and the rest of your interface including several listeners, events, and stuff in only 1 window, you'll definitely cripple the browser. Now try this out with an interface separated into iframes, and notice the huge improvements in speed. A pitty for the networks department and their Tux dolls, but I care more about my customer satisfaction levels on using the web application. :) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183706 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
Thomas Chiverton wrote: On Tuesday 09 Nov 2004 13:17 pm, Jochem van Dieten wrote: IFRAMEs might not be a good idea in the light of the latest developments :-) Which ones are they then ? http://isc.sans.org/diary.php?date=2004-11-08 http://www.uniras.gov.uk/l1/l2/l3/alerts2004/alert-3804.txt http://www.edup.tudelft.nl/~bjwever/InternetExploiter.zip Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183707 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session vars and IFRAME
A pitty for the networks department and their Tux dolls, but I care more about my customer satisfaction levels on using the web application. :) Unfortunately, many customers are unsatisfied by having their machines compromised. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183708 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
Are both locations in the same domain? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 The data is being drawn from a dedicated IP address as opposed to a domain. There is an application.cfm file in there to retail the vars ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183709 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
Ask this person how they plan to remove duplicates, should they be accidentally created. For that matter, ask how they plan to detect duplicates. If that doesn't work, insist that you be referred to by your full name, date of birth, and social security number. Don't answer to anything else. Seriously? Come up with a couple of scenarios where they're indespensible (like the duplicates) and lay them out. If that doesn't work, scream and pull your hair out. --Ben Dawson, Michael wrote: I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183710 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session vars and IFRAME
O ofcourse.. but the exploitable abilities of iframes have been over exaggerated by security firms. Security firms which take every opportunity to get in the news no matter what needs to be done to exploit such features. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Primary Key Justification
Personally I use an individual primary key myself. In the past I have seen oracle databases with two fields as the primary key, but never a whole record. The only justification I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. On modern servers storage is not usually a problem, particularly with such a small field. On older mainframes, it was. One major justification for a single primary key is replication. If you have multiple fields as a primary key, on a replicated system, there is a higher chance that the same values will appear. It will at least cause more headaches and more setting up initially. Gavin -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 14:01 To: CF-Talk Subject: Primary Key Justification I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183712 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
On Tuesday 09 Nov 2004 14:22 pm, Dave Watts wrote: A pitty for the networks department and their Tux dolls, but I care more about my customer satisfaction levels on using the web application. :) Unfortunately, many customers are unsatisfied by having their machines compromised. FireFox supports IFRAME, and you can't be exploited by looking at a page unrelated to the exploit email, so what are you on about ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183713 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session vars and IFRAME
Jochem ofcourse refers to the buffer overflow vulnerability found in Iframes :) And yes, it is a vulnerability but still I believe you must take those not to seriously. Software always contains bugs, IE contains them, FireFox contains them, Safari contains them, Opera contains them, etc.etc. We can't browse with a piece of paper and a pencil, or clear our apps from everything coming out as vulnerable. If that is the case we all should stop writing for browsers .. ;) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183714 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Primary Key Justification
From: Gavin Brook [mailto:[EMAIL PROTECTED] Personally I use an individual primary key myself. In the past I have seen oracle databases with two fields as the primary key, but never a whole record. The only justification I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. On modern servers storage is not usually a problem, particularly with such a small field. On older mainframes, it was. I can not speak to AS400 as that was the technology in text books 10 years prior my college experience (yes I'm a youngin'). Anyway, any space you might save will be lost when you do updates or selects in which you want a specific record assuming there is a comparable stored procedure concept on AS400. Consider the extra lines needed to determine which record to update or select: UPDATE SET WHERE a=1, b=2, c=3, e=4, f=5 etc etc etc. SELECT FROM .. WHERE a=1, b=2, c=3, e=4, f=5 etc etc etc. Compared to UPDATE SET WHERE a=1 SELECT FROM .. WHERE a=1 That's not to say that there is never a need for compound keys comprised of 2 or 3 columns such as those found in join tables, etc... ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183715 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
The primary key should flow from the question: What uniquely defines a record? Compound primary keys are fairly common (at least in my company's ugly Informix tables). I don't really see a scenario where the entire table represents the primary key though. Primary keys uniquely identify some piece of dataif the entire table is the key, what piece of data is being uniquely identified From: Gavin Brook [mailto:[EMAIL PROTECTED] Personally I use an individual primary key myself. In the past I have seen oracle databases with two fields as the primary key, but never a whole record. The only justification I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. On modern servers storage is not usually a problem, particularly with such a small field. On older mainframes, it was. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183716 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Primary Key Justification
Since I have a little experience with older (as in early 90s) AS400 and Business Basic development, I can attest to the fact that the tables are done differently. I have had to use an employee table that required a primary key based upon 3 fields out of nine. I defined a new primary key for my relational work. Older (see above) AS400 and RPG developers do not make good relational database designers in general. The relational model sometimes just is beyond their comprehension. Remind this developer that a web application has less horsepower than a comparable AS400 application. Because of that the database needs a single field primary key. Russel Madere Webmaster 504.832.9835 SunShine Pages by EATEL www.sunshinepages.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 8:01 AM To: CF-Talk Subject: Primary Key Justification I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183717 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
Dawson, Michael wrote: I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. That is probably not smart performance wise: - you will have 6-fold foreign keys which will have to cascade on every change to the record - your PK-index will be huge - some of the fields are bound to be non-unique thus reducing the efficiency of an index Additional storage requirements of adding a field are easily offset by the reduced storage requirements of having an index over all six fields. Add in a bit off application developer convenience and your co-worker has to come with better arguments to convince me. Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
Dawson, Michael wrote: I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. There's no justification for doing that. None! This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) Say it with my, kids: Most. Useless. Table. Indexing. Ever. I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... Moreover, what use is the table when you have to pass around whole tuples to do lookups on it? A few things spring to mind: your cow-orker has no clue what normalisation is; they A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. The thing is, they should know this *anyway*! Take the example of a users table, like this CREATE TABLE users ( user_name VARCHAR(16) NOT NULL PRIMARY KEY, user_password VARCHAR(32) NOT NULL, -- Holds MD5 hash of password -- ...other fields... ); user_name makes sense as a primary key: it's uniques for each tuple, and it's never going to change. What is this person doing designing table schemas anyway? Now, I'm creating the table myself to do it right. ;-) Do, and if they complain then do some benchmarking to show them that your schema is just better. Then tell them that's how it's done. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183719 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
I may be way out there, but I think using the whole row as a primary key is exactly the opposite of a primary key. Primary Key: A key that uniquely identifies each record and is used as the primary method of accessing the records - File Structures ISBN 0-201-87401-6 So, unless the intention is to give every single field every time you want any record - the suggestion is crazy talk - and a very bad hashing algorithm at that :). Tell'em to look here: http://www.google.com/search?hl=enq=Primary+Key+best+practice Cheers rob On Tue, 9 Nov 2004 08:01:18 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183720 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
Gavin Brook wrote:
Personally I use an individual primary key myself. In the past I have seen
oracle databases with two fields as the primary key, but never a whole
record.
In a many-to-many relation I often to have something like:
CREATE TABEL author_article {
authorID INT NOT NULL,
articleID INT NOT NULL,
CONSTRAINT author_article_pk PRIMARY KEY (authorID, articleID),
CONSTRAINT author_fk FOREIGN KEY (authorID) REFERENCES author,
CONSTRAINT article_fk FOREIGN KEY (articleID) REFERENCES article
);
One major justification for a single primary key is replication. If you have
multiple fields as a primary key, on a replicated system, there is a higher
chance that the same values will appear.
A combination of fields is unique or not, replication has nothing
to do with that.
Jochem
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183721
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RE: Primary Key Justification
I'm not sure I completely agree with that statement about RPG programmers - I began my career doing Relational Database design and programming for OS400 using RPG. Their design and development (if done right) should be completely sound, maybe more so than what's produced by others. One thing you've got to keep in mind is that the old school RPG developers dealt with machines that had serious memory limitations... and so OS400 also had these limitations. For example, variable names couldn't exceed 6 characters... allowing more characters meant using up extra memory. The same line of thought applies to table, procedure, and column names as well. That said, anyone with a lot of experience in RPG needs to do a little reading and get with the times if they want to do database design using modern hardware and/or modern software... and I'd encourage them to do so. Developers that have never worked within the limitations that older systems used to apply don't really appreciate how easy they've got it ;) ~Simon Since I have a little experience with older (as in early 90s) AS400 and Business Basic development, I can attest to the fact that the tables are done differently. I have had to use an employee table that required a primary key based upon 3 fields out of nine. I defined a new primary key for my relational work. Older (see above) AS400 and RPG developers do not make good relational database designers in general. The relational model sometimes just is beyond their comprehension. Remind this developer that a web application has less horsepower than a comparable AS400 application. Because of that the database needs a single field primary key. Russel Madere Webmaster 504.832.9835 SunShine Pages by EATEL www.sunshinepages.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 8:01 AM To: CF-Talk Subject: Primary Key Justification I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
This sounds familiar - strictly speaking, 3rd normal form databases are typically sufficiently normalised for everyday use. I do not remember all the terminology (dependencies, etc), but 4th/5th/Boyce-Codd (spelling?) normal form would lead to an entity/table design not unlike the one you are describing - each tuple/record can only be described uniquely by the combination of 1 or more fields and no other way. This theory is something we learnt at university, and imo, for 99% of cases in the real world, the theory should be left there. The co-worker is designing a fully normalised database table, but this does not mean it is programmer / web / etc friendly. It is quite possible a throw-back to AS400 / IBM development mentality where things are done the right way. The AS400 hardware is a case in point, they are as old as the hills and still going strong. I have no experience in AS400 development so this is pure conjecture. Neither of you are wrong per se. You have an opportunity to learn elite db design and configuration. In return you can teach your AS400 co-worker about web development and some nifty short-cuts (identity/sequences) that may make his life at work a little easier. Just some thoughts. HTH Aaron - Original Message - From: Dawson, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 1:01 AM Subject: Primary Key Justification I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183723 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Oracle native drivers stop verifying (CF5)
At 08:40 AM 11/9/2004 -0500, you wrote: For some functions we use the native Oracle 8.0 drivers supplied with CF 5.0 Enterprise to access Oracle 8i. They worked fine till Monday, now none of them work and they will not verify. If we submit a query using one of the native data sources it just never comes back - we do not get an error message. Recreating the native data sources does not fix the problem. What are you seeing in the CF logs (server, application, exception) when the lost queries are happening? On the Oracle side, what are they seeing in the listener.log file? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183724 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
How to return values from a non-script module?
I've been looking around and I can't find the non-cfscript version of return(). The docs on CFModule seem a little short on this. ;) I want to return the .recordcount of a query that gets run in a module. Thanks guys, Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183725 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
Jochem ofcourse refers to the buffer overflow vulnerability found in Iframes :) And yes, it is a vulnerability but still I believe you must take those not to seriously. Software always contains bugs, IE contains them, FireFox contains them, Safari contains them, Opera contains them, etc.etc. We can't browse with a piece of paper and a pencil, or clear our apps from everything coming out as vulnerable. If that is the case we all should stop writing for browsers .. ;) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 I really appreciate the discussion this has spawned on the use of IFRAMEs but it won't be an issue in this case as all the resellers are invited guests so the security implications are minimal. Any ideas however on how to tackle the session vars problem would be greatly appreciated! ;-) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183726 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
phil williams wrote: Any ideas however on how to tackle the session vars problem would be greatly appreciated! ;-) What does LiveHTTPHeaders tell you? If you need help decrypting the headers just send the log to the list. Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183727 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
Overhead. By defining every column a a primary key, you are basically creating an index of the entire table. So any column that gets updated, forces the index to update. Hence making the indexes pretty worthless. -Adam On Tue, 9 Nov 2004 09:42:31 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: From: Gavin Brook [mailto:[EMAIL PROTECTED] Personally I use an individual primary key myself. In the past I have seen oracle databases with two fields as the primary key, but never a whole record. The only justification I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. On modern servers storage is not usually a problem, particularly with such a small field. On older mainframes, it was. I can not speak to AS400 as that was the technology in text books 10 years prior my college experience (yes I'm a youngin'). Anyway, any space you might save will be lost when you do updates or selects in which you want a specific record assuming there is a comparable stored procedure concept on AS400. Consider the extra lines needed to determine which record to update or select: UPDATE SET WHERE a=1, b=2, c=3, e=4, f=5 etc etc etc. SELECT FROM .. WHERE a=1, b=2, c=3, e=4, f=5 etc etc etc. Compared to UPDATE SET WHERE a=1 SELECT FROM .. WHERE a=1 That's not to say that there is never a need for compound keys comprised of 2 or 3 columns such as those found in join tables, etc... ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How to return values from a non-script module?
If you are using a module then set the caller.yourvar value as the result... cfset caller.myrecordcount = myquery.recordcount Paul ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to return values from a non-script module?
From within a module you would use the caller scope to set variables in the page that called the module - meaning [page 1] cfmodule template... [in the module] cfquery name=yadda... ... caller.myvar = yadda.recordcount [page 1 again] cfdump var=#myvar# It can get kind of hairy doing that, especially on larger system where you looking at a page going... where the hell did that variable come from - if your using cfmx I'd suggest checking out cffunction if possible (that's beside the point though I guess) On Tue, 09 Nov 2004 10:07:35 -0500, Anders Green [EMAIL PROTECTED] wrote: I've been looking around and I can't find the non-cfscript version of return(). The docs on CFModule seem a little short on this. ;) I want to return the .recordcount of a query that gets run in a module. Thanks guys, Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183730 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. Not even, you may save the space of an integer key in the table, but think about the index! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
This is how it's done, is the reply I get. Tell them the Titanic sunk because of the way it was done! ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183732 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to return values from a non-script module?
Another option is to make the return variable dynamic. I talked about this at my presentation at MAX. Typically I build my custom tags so that the result variable is dynamic, with a default: cfparam name=attributes.result default=result type=variableName This lets me then call my tag like so, cf_foo result=theResult You can set a dynamic variable back a few ways, here is one: cfset caller[attributes.result] = whatever On Tue, 9 Nov 2004 15:20:51 -, Paul Vernon [EMAIL PROTECTED] wrote: If you are using a module then set the caller.yourvar value as the result... cfset caller.myrecordcount = myquery.recordcount Paul ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183733 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Primary Key Justification
Michael: I see three basic problems with this assuming that other tables need to be linked to this table: 1. Size - Since the entire table needs to be replicated in each table that it is linked to, this is highly inefficient 2. Seek Performance - Searching and comparing long text fields can become prohibitive depending on the size of the tables 3. Update time - if the table is updated frequently, then each of the linked tables need to be updated as well as do their indices If this table is not linked to anything or is rarely changed and if disk space and performance are not issues, then a re-writing is not worth it. But if the table has too be modified, it is probably worth adding a primary key and rolling to each linked table as either performance becomes an issue or other maintenance is performed. Andy -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 8:01 AM To: CF-Talk Subject: Primary Key Justification I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183734 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using Like Keyword for searching
I'm building in somewhat of a keyword search into a site I'm working on. The search basically looks at what was typed into the search field, does a query on a particular field in the database using the like keyword and then returns a code or codes that is associated with that particular field in the database. The issue I'm having is if the value that is sotred in the db is something like Cases: 24 - 30 and a person types in 24 cases in the search field the query doesn't find anything. My query looks like: cfquery name=search datasource=ds Select someFields from someTable where searchField Like '%#form.search#%' /cfquery Now if you type 24 or 24 for example it will return the Cases: 24 - 30. I wanted to do either a verity or Full text search but the client doesn't want me to. Does anyone have any ideas on what I can do to get the query to find anything that matches what is typed in? Thanks, Ben ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183735 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Like Keyword for searching
Perhaps something like this? cfquery name=search datasource=ds Select someFields from someTable where cfset x=0 cfloop list=#form.search# index=searchItem delimiters= Cfset x=x+1 cfif x gt 1AND/cfif searchField Like '%#searchItem#%' /cfloop /cfquery -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 10:48 AM To: CF-Talk Subject: Using Like Keyword for searching I'm building in somewhat of a keyword search into a site I'm working on. The search basically looks at what was typed into the search field, does a query on a particular field in the database using the like keyword and then returns a code or codes that is associated with that particular field in the database. The issue I'm having is if the value that is sotred in the db is something like Cases: 24 - 30 and a person types in 24 cases in the search field the query doesn't find anything. My query looks like: cfquery name=search datasource=ds Select someFields from someTable where searchField Like '%#form.search#%' /cfquery Now if you type 24 or 24 for example it will return the Cases: 24 - 30. I wanted to do either a verity or Full text search but the client doesn't want me to. Does anyone have any ideas on what I can do to get the query to find anything that matches what is typed in? Thanks, Ben ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Like Keyword for searching
This should work... -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 15:48 To: CF-Talk Subject: Using Like Keyword for searching I'm building in somewhat of a keyword search into a site I'm working on. The search basically looks at what was typed into the search field, does a query on a particular field in the database using the like keyword and then returns a code or codes that is associated with that particular field in the database. The issue I'm having is if the value that is sotred in the db is something like Cases: 24 - 30 and a person types in 24 cases in the search field the query doesn't find anything. My query looks like: cfquery name=search datasource=ds Select someFields from someTable where searchField Like '%#form.search#%' /cfquery Now if you type 24 or 24 for example it will return the Cases: 24 - 30. I wanted to do either a verity or Full text search but the client doesn't want me to. Does anyone have any ideas on what I can do to get the query to find anything that matches what is typed in? Thanks, Ben ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183737 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Like Keyword for searching
Ok, actual code on this one! cfquery name=search datasource=ds select someFields from someTable where 1=1 cfloop index=currKeyword list=#form.search# delimiters= AND searchField Like '%#currKeyword#%' /cfloop /cfquery -Original Message- From: Gavin Brook [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 16:05 To: '[EMAIL PROTECTED]' Subject: RE: Using Like Keyword for searching This should work... -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 15:48 To: CF-Talk Subject: Using Like Keyword for searching I'm building in somewhat of a keyword search into a site I'm working on. The search basically looks at what was typed into the search field, does a query on a particular field in the database using the like keyword and then returns a code or codes that is associated with that particular field in the database. The issue I'm having is if the value that is sotred in the db is something like Cases: 24 - 30 and a person types in 24 cases in the search field the query doesn't find anything. My query looks like: cfquery name=search datasource=ds Select someFields from someTable where searchField Like '%#form.search#%' /cfquery Now if you type 24 or 24 for example it will return the Cases: 24 - 30. I wanted to do either a verity or Full text search but the client doesn't want me to. Does anyone have any ideas on what I can do to get the query to find anything that matches what is typed in? Thanks, Ben ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183738 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Delimeter problem
|153564587|0|SAT|FREEDMAN|||1|||10/17/2004|10/18/2004 I need to move all the valus in a into individual Structure/Array Keys. so I can display them individually. The above result I have it in a Varilable. If I use the listGetAt() I can't move value becuase two || are todather(no space between them). What is the best way to acheive this?? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183739 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Like Keyword for searching
excellent. That worked like a charm. Thanks guys. Ben On Tue, 9 Nov 2004 16:06:45 -, Gavin Brook [EMAIL PROTECTED] wrote: Ok, actual code on this one! cfquery name=search datasource=ds select someFields from someTable where 1=1 cfloop index=currKeyword list=#form.search# delimiters= AND searchField Like '%#currKeyword#%' /cfloop /cfquery -Original Message- From: Gavin Brook [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 16:05 To: '[EMAIL PROTECTED]' Subject: RE: Using Like Keyword for searching This should work... -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 15:48 To: CF-Talk Subject: Using Like Keyword for searching I'm building in somewhat of a keyword search into a site I'm working on. The search basically looks at what was typed into the search field, does a query on a particular field in the database using the like keyword and then returns a code or codes that is associated with that particular field in the database. The issue I'm having is if the value that is sotred in the db is something like Cases: 24 - 30 and a person types in 24 cases in the search field the query doesn't find anything. My query looks like: cfquery name=search datasource=ds Select someFields from someTable where searchField Like '%#form.search#%' /cfquery Now if you type 24 or 24 for example it will return the Cases: 24 - 30. I wanted to do either a verity or Full text search but the client doesn't want me to. Does anyone have any ideas on what I can do to get the query to find anything that matches what is typed in? Thanks, Ben ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183740 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Delimeter problem
Asim, I need to move all the valus in a into individual Structure/Array Keys. so I can display them individually. If you're using MX, check this thread: http://www.mail-archive.com/dev@lists.cfdeveloper.co.uk/msg16596.html Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183741 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Delimeter problem
I would use cfset variableArray = #listToArray(|153564587|0|SAT|FREEDMAN|||1|||10/17/2004|10/18/2004, |)# then use #variableArray[1]# #variableArray[2]# #variableArray[3]# #variableArray[4]# and so on... Thanks, David -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 10:21 AM To: CF-Talk Subject: Delimeter problem |153564587|0|SAT|FREEDMAN|||1|||10/17/2004|10/18/2004 I need to move all the valus in a into individual Structure/Array Keys. so I can display them individually. The above result I have it in a Varilable. If I use the listGetAt() I can't move value becuase two || are todather(no space between them). What is the best way to acheive this?? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183742 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Problem with Quotation Marks in Textarea Formfield
When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183743 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Delimeter problem
I tried this and it worked. cfset list = |153564587|0|SAT|FREEDMAN|||1|||10/17/2004|10/18/2004 cfdump var=#listtoarray( replace( list, '||', '| |', 'All' ), '|' )# On Tue, 09 Nov 2004 11:20:41 -0400, Asim Manzur [EMAIL PROTECTED] wrote: |153564587|0|SAT|FREEDMAN|||1|||10/17/2004|10/18/2004 I need to move all the valus in a into individual Structure/Array Keys. so I can display them individually. The above result I have it in a Varilable. If I use the listGetAt() I can't move value becuase two || are todather(no space between them). What is the best way to acheive this?? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183744 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Delimeter problem
David, cfset variableArray = #listToArray(|153564587|0|SAT|FREEDMAN|||1|||10/17/2004|1 0/18/2004, |)# then use #variableArray[1]# #variableArray[2]# #variableArray[3]# #variableArray[4]# and so on... This is exactly what Asim tried to do without success -- the CF list functions ignore empty list elements, but my understanding is that he needs to retain those empty elements, hence my previous pointer to an identical thread. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Application Variables
Hi Everyone I have an application that is storing information in applications variables. I need each of this variables to be available for about 1 hour . I have created a application.cfm file with a CFAPPLICATION tag as follows: cfapplication name=theWebSite applicationTimeout=#CreateTimeSpan(0,1,0,0)# Will this automatically remove variables after the timeout time if they are not re-wrote, or will they stay there until the whole application is not used by anyone for 1 hour? Thanks Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Delimeter problem
Qasim, listtoarray(replace(list, '||', '| |', 'All'), '|') This wouldn't work because there is actually an empty element *before* the 153564587 item -- your code only replaces empty elements in the middle of the series and would ignore those at the beginning or end. Of course you could simply add a space at both the beginning and end of the string before it is parsed, which would get around the problem. You still have the slight inconvenience of empty elements actually containing a single space; what happens if one of the elements did actually contain a single space? You'd have no way of knowing the difference between the real element and those that have been padded. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183747 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Quotation Marks in Textarea Formfield
HTMLEditFormat() On Tue, 9 Nov 2004 11:29:31 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183748 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Quotation Marks in Textarea Formfield
use function preservceinglequotes if you are inserting those values in a DB On Tue, 9 Nov 2004 11:29:31 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183749 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application Variables
The latter, you will have to do something more sophisticated to remove the variables. Something along the lines of storing their creation data/time and then removing the values after the hour is up. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183750 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
phil williams wrote: Any ideas however on how to tackle the session vars problem would be greatly appreciated! ;-) What does LiveHTTPHeaders tell you? If you need help decrypting the headers just send the log to the list. Jochem OK this has totally freaked me out now. The damn app just decided to strat working! I tested it with Firefox and the session vars were being kept. I then tested with IE and it still worked... I powered down my machine, unplugged it and threw it in the car, drove round the block for time, plugged it back in and the damn thing still worked! :-) I'm really not sure why this has suddenly decided to play nioce when I didn't change a thing but thanks anyway for everyone fixing my app via brainwaves! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183751 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
Claude Schneegans wrote: I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. Not even, you may save the space of an integer key in the table, but think about the index! But there's no sense if saving space like that when you need a whole tuple to do a lookup. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183753 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Session vars and IFRAME
power of positive thinking my friend =) we need of it in the world. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183752 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problem with Quotation Marks in Textarea Formfield
I believe his issue is double quotes not single. for instance. input type=text name=name value=some textand some more The quote in the middle of the value will cause a problem. I am not positive but have you tried HTMLEditFormat or URLDecode? Cant remember exactly and I cant test anything at the moment. David -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:40 AM To: CF-Talk Subject: Re: Problem with Quotation Marks in Textarea Formfield use function preservceinglequotes if you are inserting those values in a DB On Tue, 9 Nov 2004 11:29:31 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problem with Quotation Marks in Textarea Formfield
sorry I meant URLEncodeFormat not URLDecode -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:52 AM To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield I believe his issue is double quotes not single. for instance. input type=text name=name value=some textand some more The quote in the middle of the value will cause a problem. I am not positive but have you tried HTMLEditFormat or URLDecode? Cant remember exactly and I cant test anything at the moment. David -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:40 AM To: CF-Talk Subject: Re: Problem with Quotation Marks in Textarea Formfield use function preservceinglequotes if you are inserting those values in a DB On Tue, 9 Nov 2004 11:29:31 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183755 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Delimeter problem
http://www.cflib.org/udf.cfm?ID=507 Pascal -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 16:21 To: CF-Talk Subject: Delimeter problem |153564587|0|SAT|FREEDMAN|||1|||10/17/2004|10/18/2004 I need to move all the valus in a into individual Structure/Array Keys. so I can display them individually. The above result I have it in a Varilable. If I use the listGetAt() I can't move value becuase two || are todather(no space between them). What is the best way to acheive this?? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183756 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problem with Quotation Marks in Textarea Formfield
HTMLEditFormat() Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 17:30 To: CF-Talk Subject: Problem with Quotation Marks in Textarea Formfield When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Search Results: Pagination Not Working
I'm going out of my mind... this used to work, and I can't figure out
what I've changed to make it stop. What -should- be happening: the
first 25 search results show, click 'next' and the next 25 show, etc.
Instead, ALL results show on the first page... when somebody clicks
next, they get ALL the results PLUS the 25 'next' results they should be
seeing.
My code:
!--- Advanced Search Include ---
!--- Determine the collection(s) to use for the search. ---
cfif IsDefined('form.collection')
cfset collection_list = form.collection
cfelseif IsDefined('url.collection')
cfset collection_list = url.collection
/cfif
cflock timeout=30 throwontimeout=no name=timeperiod
!---
Have we paginated past results?
If so, use URL variables instead
of the old form variables.
---
cfif IsDefined(url.timeperiod)
cfset timeperiod = #url.timeperiod#
cfelse
cfset timeperiod = #form.timeperiod#
/cfif
cfif ((IsDefined(url.startdate))
AND (len(url.startdate) is not 0))
cfset startdate = #url.startdate#
cfelse
cfset startdate = None
/cfif
cfif ((IsDefined(url.enddate))
AND (len(url.enddate) is not 0))
cfset enddate = #url.enddate#
cfelse
cfset enddate = None
/cfif
cfif ((IsDefined(form.startdate))
AND (len(form.enddate) is not 0))
cfset startdate = #form.startdate#
cfelse
cfset startdate = None
/cfif
cfif ((IsDefined(form.enddate))
AND (len(form.enddate) is not 0))
cfset enddate = #form.enddate#
cfelse
cfset enddate = None
/cfif
/cflock
!--- search for special char . is delimiter ---
cfset BadCharacterList =
,.[EMAIL PROTECTED](.)._.=.:.;.../.\.|.].[.}.{.~
cfloop index=BadChar list=#BadCharacterList# delimiters=.
cfif SearchInput CONTAINS BadChar
!--- View the Bad Character (for testing) ---
cfoutputBAD: #BadChar#/cfoutput
table border=0 cellpadding=0 cellspacing=0
tr
td
span class=small
Search text cannot contain special characters
such as [EMAIL PROTECTED]br
br /Special characters allowed are .*'
/span
/td
/tr
/table
cfinclude
template=/epi_root/templates/generic_footer.cfm
/td/tr/table/td/tr/table/td/tr/table
cfabort /
/cfif
/cfloop
cflock timeout=30 throwontimeout=no name=search1
cfset newzzz =
!--- make input sting all lower case ---
!--- cut begining and ending spaces ---
!--- standardize input quotes used ---
cfset newzzz = Replace(trim(lcase(SearchInput)),','',ALL)
!--- count quotes in input ---
!--- divide quote count by 2 ---
!--- drop decimal if odd quote and add 1 more loop ---
cfset qoutecount =
SpanExcluding(ArrayLen(ListToArray(newzzz,''))/2, .)+1
/cflock
!--- use for testing
cfoutput
Loop Count: #qoutecount#br /
Newzzz: #newzzz#
/cfoutput
---
!--- start loop here ---
!--- loop to reformat search phrases ---
cflock timeout=30 throwontimeout=no name=search2
cfloop index=LoopCount from=1 to=#qoutecount#
!--- find info quoted ---
cfset str =
ReFind('[[:alnum:][:space:]\*\.\?-]*',newzzz,1,true)
!--- use for testing positon in input
string pos = #str.pos[1]#br
string length = #str.len[1]#br
---
cfif str.pos[1] neq 0
!--- cut info quoted ---
cfset theString = Mid(newzzz, str.pos[1],
str.len[1])
!--- if space found in cut quote replace with ~
---
cfset theString1 = Replace(theString,
,~,ALL)
!--- change cut quote from double to single
---
cfset theString1 =
Replace(theString1,'',',ALL)
!--- replace found phrase with cut phrase ---
cfset newzzz =
Replace(newzzz,theString,theString1,ALL)
!--- use for testing
Cut String: #theString#BR
---
/cfif
/cfloop
/cflock
!--- delete non-paired quote ---
cflock timeout=30 throwontimeout=no name=search3
cfset newzzz = trim(Replace(newzzz,'','',ALL))
!--- convert search operatives ---
cfset newzzz = ReplacenoCase(newzzz, AND ,~AND~,ALL)
cfset newzzz = ReplacenoCase(newzzz, OR ,~OR~,ALL)
cfset
Re: Primary Key Justification
Keith Gaughan wrote: Claude Schneegans wrote: I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. Not even, you may save the space of an integer key in the table, but think about the index! But there's no sense if saving space like that when you need a whole tuple to do a lookup. I think that was the point. -- Registration for MX Europe 2005 is now open. http://www.mxeurope.org/go/registration Early bird discounts available. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Primary Key Justification
I want to thank everyone for their input. There were many great justifications and some pretty funny remarks! Thanks again! M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183760 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Delimeter problem
Thanks Tim and everyone. That post really helpful and cflib UDF looks like a solution. -A Qasim, listtoarray(replace(list, '||', '| |', 'All'), '|') This wouldn't work because there is actually an empty element *before* the 153564587 item -- your code only replaces empty elements in the middle of the series and would ignore those at the beginning or end. Of course you could simply add a space at both the beginning and end of the string before it is parsed, which would get around the problem. You still have the slight inconvenience of empty elements actually containing a single space; what happens if one of the elements did actually contain a single space? You'd have no way of knowing the difference between the real element and those that have been padded. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183761 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
invalid signature errors?
Running CFMX 6.1 with the latest updater. Got the below errors showing up, anyone see these before? Nov 9, 2004 12:13 PM Error 0 aopscorecard Invalid method signature: /Object; The specific sequence of files included or processed is: D:\Inetpub\wwwroot\sales\aop\index.cfm Nov 9, 2004 12:13 PM Error 0 Invalid method signature: ava/lang/String;)V The specific sequence of files included or processed is: D:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\CFIDE\administrator\settings\server_settings.cfm Nov 9, 2004 12:13 PM Error 0 Invalid method signature: /tagext/BodyTag;ILjavax/servlet/jsp/JspWriter;)Ljavax/servlet/jsp/JspWriter; The specific sequence of files included or processed is: D:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\CFIDE\administrator\settings\server_settings.cfm -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183762 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfqueryparam Don't Work for Dates
Hi there :
I was using a cfqueryparam tag to work with my queries and when i set some
Datetime values coldfusiion raise this error ,
note : sorry about the field names , i'm working on a Spanish database.
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
SQL = SET DATEFORMAT DMY; INSERT INTO pla06_caratula
(pla06_tipo_cliente,pla06_id_cliente_sp,pla06_ejecutivo_placement,
pla06_poliza_anterior,pla06_compania_anterior,pla06_ramo,
pla06_vigencia_desde,pla06_vigencia_hasta,pla06_vigencia_hora,
pla06_fecha_limite_cotizar,pla06_moneda,pla08_id_tipo_cotizacion)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Query Parameter Value(s) -
Parameter #1 = 1
Parameter #2 = 77046420-K
Parameter #3 = 1
Parameter #4 = 41234123
Parameter #5 = 12
Parameter #6 = 69
Parameter #7 = {d '2004-11-09'}
Parameter #8 = {d '2005-11-09'}
Parameter #9 = 12:00 Hrs local
Parameter #10 = {d '2004-11-23'}
Parameter #11 = 1
Parameter #12 = 1 Data Source = PLACEMENT
if i use a direct variable instead of cfqueryparam (type date)
this query works fine..
Any ideas?
The environment
Coldfusion 5 professional
MS SQL Server 2000
MDAC 2.8
Windows 2000 server
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183763
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Java to CFMX Question
I am working with some Java code that I am trying to convert to CFMX again. This time, I am running into issues with a Java enumeration. How do you declare an enumeration in CFMX? CreateObject only works with classes (as far as I can tell). The Java code I am attempting to duplicate is IProject iProject = projectManager.GetProject(126); IRole leaderRole = iProject.GetRole(Plumtree.Remote.PRC.Collaboration.Security.RoleTypes.Leader); ... where Plumtree.Remote.PRC.Collaboration.Security.RoleTypes.Leader is an enumeration with 3 members (Guest, Leader, Member). Can anybody offer any pointers? Thanks -- Jeff Chastain ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Primary Key Justification
Stephen Moretti (cfmaster) wrote: Keith Gaughan wrote: But there's no sense if saving space like that when you need a whole tuple to do a lookup. I think that was the point. I know that's the point: I was just agreeing with the bloke. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183765 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problem with Quotation Marks in Textarea Formfield
Thanks for all the input everyone... HTMLEditFormat() is helpingbut... Before adding that code, my statement was #Replace(Application.Article.Body, #Chr(13)#, br, All)# to create paragraphs... Now with HTMLEditFormat() added, I've got: #HTMLEditFormat(Replace(Application.Article.Body, #Chr(13)#, br, All))# This code solves the quote issue, and leaves my paragraphs intact, but not I've got br showing up in the text. Does using HTMLEditFormat() make Replace() unnecessary? Or how should the code be changed? Thanks, Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:56 AM To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield HTMLEditFormat() Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 17:30 To: CF-Talk Subject: Problem with Quotation Marks in Textarea Formfield When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183766 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam Don't Work for Dates
David Manriquez wrote:
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
SQL = SET DATEFORMAT DMY; INSERT INTO pla06_caratula
(pla06_tipo_cliente,pla06_id_cliente_sp,pla06_ejecutivo_placement,
pla06_poliza_anterior,pla06_compania_anterior,pla06_ramo,
pla06_vigencia_desde,pla06_vigencia_hasta,pla06_vigencia_hora,
pla06_fecha_limite_cotizar,pla06_moneda,pla08_id_tipo_cotizacion)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Query Parameter Value(s) -
Parameter #1 = 1
Parameter #2 = 77046420-K
Parameter #3 = 1
Parameter #4 = 41234123
Parameter #5 = 12
Parameter #6 = 69
Parameter #7 = {d '2004-11-09'}
Parameter #8 = {d '2005-11-09'}
Parameter #9 = 12:00 Hrs local
Does MS SQL Server implement timezones? Does it even implement a
TIME datatype?
Jochem
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183767
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Quotation Marks in Textarea Formfield
I'm stabbing in the dark here, but I think you need to remove from around br ??? Help from CF'ers with more experience out there??? ~ Donna On Tue, 9 Nov 2004 12:39:36 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for all the input everyone... HTMLEditFormat() is helpingbut... Before adding that code, my statement was #Replace(Application.Article.Body, #Chr(13)#, br, All)# to create paragraphs... Now with HTMLEditFormat() added, I've got: #HTMLEditFormat(Replace(Application.Article.Body, #Chr(13)#, br, All))# This code solves the quote issue, and leaves my paragraphs intact, but not I've got br showing up in the text. Does using HTMLEditFormat() make Replace() unnecessary? Or how should the code be changed? Thanks, Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:56 AM To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield HTMLEditFormat() Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 17:30 To: CF-Talk Subject: Problem with Quotation Marks in Textarea Formfield When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183768 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Quotation Marks in Textarea Formfield
use HTMLEditFormat() for displaying the data in the text area only, not for inserting into the DB. Use cfqueryparam for DB insert/updates to automagically escape stuffs. Doug On Tue, 9 Nov 2004 12:39:36 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for all the input everyone... HTMLEditFormat() is helpingbut... Before adding that code, my statement was #Replace(Application.Article.Body, #Chr(13)#, br, All)# to create paragraphs... Now with HTMLEditFormat() added, I've got: #HTMLEditFormat(Replace(Application.Article.Body, #Chr(13)#, br, All))# This code solves the quote issue, and leaves my paragraphs intact, but not I've got br showing up in the text. Does using HTMLEditFormat() make Replace() unnecessary? Or how should the code be changed? Thanks, Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:56 AM To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield HTMLEditFormat() Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 17:30 To: CF-Talk Subject: Problem with Quotation Marks in Textarea Formfield When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183769 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problem with Quotation Marks in Textarea Formfield
The problem is that HTMLEditFormat is stripping CR/LF. Look at http://www.cflib.org/udf.cfm?ID=664 Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 18:40 To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield Thanks for all the input everyone... HTMLEditFormat() is helpingbut... Before adding that code, my statement was #Replace(Application.Article.Body, #Chr(13)#, br, All)# to create paragraphs... Now with HTMLEditFormat() added, I've got: #HTMLEditFormat(Replace(Application.Article.Body, #Chr(13)#, br, All))# This code solves the quote issue, and leaves my paragraphs intact, but not I've got br showing up in the text. Does using HTMLEditFormat() make Replace() unnecessary? Or how should the code be changed? Thanks, Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:56 AM To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield HTMLEditFormat() Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 17:30 To: CF-Talk Subject: Problem with Quotation Marks in Textarea Formfield When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Quotation Marks in Textarea Formfield
you don't need br's in the textarea output. use your replace() function when you are displaying the data back to the user. On Tue, 9 Nov 2004 12:46:06 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: use HTMLEditFormat() for displaying the data in the text area only, not for inserting into the DB. Use cfqueryparam for DB insert/updates to automagically escape stuffs. Doug On Tue, 9 Nov 2004 12:39:36 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for all the input everyone... HTMLEditFormat() is helpingbut... Before adding that code, my statement was #Replace(Application.Article.Body, #Chr(13)#, br, All)# to create paragraphs... Now with HTMLEditFormat() added, I've got: #HTMLEditFormat(Replace(Application.Article.Body, #Chr(13)#, br, All))# This code solves the quote issue, and leaves my paragraphs intact, but not I've got br showing up in the text. Does using HTMLEditFormat() make Replace() unnecessary? Or how should the code be changed? Thanks, Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:56 AM To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield HTMLEditFormat() Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 17:30 To: CF-Talk Subject: Problem with Quotation Marks in Textarea Formfield When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam Don't Work for Dates
David Manriquez wrote: Does MS SQL Server implement timezones? Does it even implement a TIME datatype? Jochem Timezones, no (i guess) at least not in the systypes table Time yes use a TimeStamp MS SQL Built-In data Types. bigint binary bit char datetime decimal float image int money nchar ntext numeric nvarchar real smalldatetime smallint smallmoney sql_variant sysname text timestamp tinyint uniqueidentifier varbinary varchar ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
When two tables go to war (JOIN)
Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: When two tables go to war (JOIN)
cfquery name=showArticle datasource=user020 SELECT a.*, b.authorID, b.authorFirstName, b.authorSurname FROM Articles a, Authors b WHERE a.authorID = b.authorID AND a.articleID = '#url.updateID# /cfquery On Tue, 09 Nov 2004 18:22:27 +, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
flashpaper printing
While at the MAX conference, I spoke to a support engineer about the print problems with flashpaper. It was also brought up in our Get Ready for Blackstone session. Nobody at Macromedia seemed to be like Yeah we know that's a problem Let's tell them. The support person suggested sending email to [EMAIL PROTECTED] to suggest that they speed up the printing, and the more requests they get, the more the issue will be noticed. I just sent my request. If you think flashpaper printing is slow, send one yourself. Let's use the power of community to enact some change! Flashpaper is a cool product, but if my users can't print a four page document in under 30 minutes, I won't be using it. - Rick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Exposing the operating system
One of our other developers has a weird project The jist of which is gathering document s to burn to CD. Has anyone worked with operating system components , in this case exposing IMAPI? Thanks all sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183776 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: invalid signature errors?
ok, this error seems to be surfacing around the use of Evaluate(), according to a stack trace. Odd. Maybe the updater introduces a new bug, eh? Doug On Tue, 9 Nov 2004 12:16:57 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: Running CFMX 6.1 with the latest updater. Got the below errors showing up, anyone see these before? Nov 9, 2004 12:13 PM Error 0 aopscorecard Invalid method signature: /Object; The specific sequence of files included or processed is: D:\Inetpub\wwwroot\sales\aop\index.cfm Nov 9, 2004 12:13 PM Error 0 Invalid method signature: ava/lang/String;)V The specific sequence of files included or processed is: D:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\CFIDE\administrator\settings\server_settings.cfm Nov 9, 2004 12:13 PM Error 0 Invalid method signature: /tagext/BodyTag;ILjavax/servlet/jsp/JspWriter;)Ljavax/servlet/jsp/JspWriter; The specific sequence of files included or processed is: D:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\CFIDE\administrator\settings\server_settings.cfm -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183777 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Exposing the operating system
You should be able to do alot via either COM (windows) or CFEXECUTE (*nix). i don't know what the windows side looks like, but it wouldn't be too much work to collect files and burn to disk on linux. The bigger problem would be single threading access (or at least not letting more threads than you've got burners), and switching the CDs in and out. cheers, barneyb On Tue, 9 Nov 2004 13:42:43 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: One of our other developers has a weird project The jist of which is gathering document s to burn to CD. Has anyone worked with operating system components , in this case exposing IMAPI? Thanks all sas Scott A. Stewart, -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: CC Gateway question
Among the online gateways out there - who does everyone like? I'm having trouble with Atuhorize.net. Using an auth_only followed by a batch previous auth capture. Recenty we turned on Address verification. If I do an auth only and it comes back as declined due to AVS, it turns out that the auth is still created on the customers card. It is up to the issuing bank to decline and remove it. Authorize.net provides no way to VOID an auth_only that has been declined due to AVS. My customer does high dollar transactions (usually between 500 and 1200 per transaction). So if they get the Address wrong that auth sits on the card for days until the bank officially declines the card. Do all the gateways work this way? Do any of them have a way to remove an auth from a card if it's declined via AVS? The irony is, if they turn off the AVS they can often void the transaction before it's shipped (sigh). Does anyone out there have any ideas on this? Any one know of a gateway that works differently or gives different options? -mark Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When two tables go to war (JOIN)
Don't join them, there is no reason to in this case. Use 2 queries. Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 19:22 To: CF-Talk Subject: When two tables go to war (JOIN) Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183780 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When two tables go to war (JOIN)
Doesn't that create more overhead? Ray At 01:59 PM 11/9/2004, you wrote: Don't join them, there is no reason to in this case. Use 2 queries. Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 19:22 To: CF-Talk Subject: When two tables go to war (JOIN) Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: When two tables go to war (JOIN)
I'm sorry I have to disagree... I'd much rather make one call to the DB and get all of my results in 1 query. It's faster. On Tue, 9 Nov 2004 19:59:14 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Don't join them, there is no reason to in this case. Use 2 queries. Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 19:22 To: CF-Talk Subject: When two tables go to war (JOIN) Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: When two tables go to war (JOIN)
Think about how much more crap you gotta send back to the app server if you do it in one query. Not to mention the fact that you're requestion to totally different types of data that have exactly zero to do with eachother. Say you've got 50 authors. If you do a join, you're going to be pulling the full text of the article back across the network 50 times, rather than once if you do it with separate queries. No ifs, ands, or buts, two separate queries is the way to go. cheers, barneyb On Tue, 9 Nov 2004 13:08:05 -0600, Greg Morphis [EMAIL PROTECTED] wrote: I'm sorry I have to disagree... I'd much rather make one call to the DB and get all of my results in 1 query. It's faster. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When two tables go to war (JOIN)
I don't see why. He is talking about an update/insert form with a select populated by authors. To Let's say we have 100 authors, this would mean that we get the article info 100x. We also need to make an outer join to get all the authors. For such a form: 1 query to get the article's data 1 query to get the authors to fill the select. Pascal -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 20:02 To: CF-Talk Subject: RE: When two tables go to war (JOIN) Doesn't that create more overhead? Ray ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183784 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When two tables go to war (JOIN)
I seriously doubt that. The article body is most likely a CLOB. So you want to retrieve that 100x just because you have 100 authors Don't tell me this would be faster. Pascal -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 20:08 To: CF-Talk Subject: Re: When two tables go to war (JOIN) I'm sorry I have to disagree... I'd much rather make one call to the DB and get all of my results in 1 query. It's faster. On Tue, 9 Nov 2004 19:59:14 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Don't join them, there is no reason to in this case. Use 2 queries. Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 19:22 To: CF-Talk Subject: When two tables go to war (JOIN) Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When two tables go to war (JOIN)
Depending on the app, if this is a key feature, it'd be worth caching (either via the provided attributes in the cfquery tag or by storing the results in a scope (application or session). Doing it as one query just to save calls to the DB is rediculous. That's like saying to put all of your business logic, display code, etc in one file because then you know where everything is. It may make it easier to have everything in one place, but that doesn't make it right. Unless the data is truly related and requires a join, I would do it as 2 separate queries. Think of all of the overhead in this example that would come with all of the authors that don't have an article in the record set. You'd still have blank columns for all of the article fields. John Burns -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 2:08 PM To: CF-Talk Subject: Re: When two tables go to war (JOIN) I'm sorry I have to disagree... I'd much rather make one call to the DB and get all of my results in 1 query. It's faster. On Tue, 9 Nov 2004 19:59:14 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Don't join them, there is no reason to in this case. Use 2 queries. Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 19:22 To: CF-Talk Subject: When two tables go to war (JOIN) Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183786 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When two tables go to war (JOIN)
If one query is a lookup query (authors) it can be safely cached - over time this can be less overhead. Plus, if I understand what he is trying to do, he would end up with an outer join and the longText field would be duplicated in every row. That is not efficient by any means. If you really want 1 call to the db - put both queries in a stored proc and return 2 result sets : ) -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 1:08 PM To: CF-Talk Subject: Re: When two tables go to war (JOIN) I'm sorry I have to disagree... I'd much rather make one call to the DB and get all of my results in 1 query. It's faster. On Tue, 9 Nov 2004 19:59:14 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Don't join them, there is no reason to in this case. Use 2 queries. Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 19:22 To: CF-Talk Subject: When two tables go to war (JOIN) Hi guys, I've got two tables: 1 is full of articles (articleID, articleName, articleBody, authorID) 2 is full of authors (authorID, authorFirstName, authorSurname) I would like to join them. cfquery name=showArticle datasource=user020 SELECT * FROM Articles WHERE articleID = '#url.updateID# /cfquery And cfquery name=getAuthor datasource=user020 SELECT authorID, authorFirstName, authorSurname FROM Authors /cfquery Could somebody please explain how to join them so I only retrieve certain articles (where articleID = #url.updateID#) but get all the Authors (as I want to populate a list whereby the user can select who is the author of this particular article). Thanks very much guys, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183787 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
