Re: Google geocoder and CF5
My guess is that it's an encoding problem. Use an HTTP sniffer/recording proxy/whatever to see what's different. Yeah, this is what I suspect also. I'm considering using another format to access their geocoder. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best google indexing
good content for better search indexing. And also, being referred by sites having a high rank will increase your rank. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates
Ok, how about this, a bit ugly, but should work on any database: WHERE (YEAR #form.from_y# OR (YEAR = #form.from_y# AND (MONTH = 0 OR (MONTH = #form.from_m# AND (DAY = 0 OR DAY = #form.from_d#) AND (YEAR #form.to_y# OR (YEAR = #form.to_y# AND (MONTH = 0 OR (MONTH = #form.to_m# AND (DAY = 0 OR DAY = #form.to_d#) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
delimiters=crlf You're using crlf as delimitior? No wonder c, r, l f are lost. You probably meant CR LF, but these are not the delimiters used to separate field values, the simple comma is used. So just use Faculty Supervisor: cfloop list=#form.fac# index=f#f#/cfloop or more simply: Faculty Supervisor: #form.fac# -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkboxes not passing variables correctly
Is there a list of all possible delimiters value? There only one delimiter: the comma, which is the default delimiter for all list functions, so you don't need to specify one. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checkboxes not passing variables correctly
Is there a list of all possible delimiters value? If you want to know more about forms and how values are passed, use CFDUMP var=#form# in your action template and you'll know everything a young lady should know before wedding ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need Include to be first thing after BODY tag
the javascripts must be included right after the opening body tag. Are you sure they really specify right after the opening body tag or do they just mean inside the body tag? I cannot think of any valuable technical reason the Javascript couldn't be right before the /BODY tag. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need Include to be first thing after BODY tag
to be sure to count the page in the event that a user clicks away to another page before the current page is fully loaded. Ah ok, now this is a valuable reason I didn't think of. ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any Gotcha's in using CF UUID for db record primary key?
I'm thinking about changing from using auto-incrementing integers to CF-generated UUID's for primary keys in my mysql db's. Keep in mind that primary keys are by definition indexed, and in order to maintain an index, keys are compared to others. Now comparing to numbers takes only one machine instruction, while comparing 32 bytes string takes a loop of potentially 32 comparisons. So auto-incrementing integers are much more efficient. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Google geocoder and CF5
Hi, Has anyone succeeded getting the Google geocoder to work underCF5? I have my API working fine under CFMX, but under CF5 Google keeps returning code=610 meaning invalid key. My API calls the geocoder through CFHTTP. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates
How about: and YEAR = #form.from_y# and YEAR = #form.to_y# and ((MONTH = #form.from_m# and MONTH = #form.to_m#) OR MONTH=0) and ((DAY = #form.from_d# and DAY = #form.to_d#) OR DAY=0) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates
Try searching for dates between 10/15/2006 and 04/14/2007 See the problem? Yeah, my answer was a bit too easy ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Google geocoder and CF5
Show us your code. Well the code works under CF 7 and not with CF5, so I suspect it is something like Google expecting UTF-8 in headers or something like that. Any way, the code is: CFHTTP URL=http://maps.google.com/maps/geo?q=#q#output=xmlkey=#googleKey#; METHOD=GET RESOLVEURL=false I doubt it tells you a lot. And YES, the key is correct, the module to display the map works fine, using the same key. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Round Up
Round might round down; Well, as far as I know, this is what round means, no? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images in the database good or bad?
put the table holding the images on it's own file group back that up separately from the main db. you do not have to back up the images along w/the rest of the data. This is true until some one adds a new image to the database, then the whole table with all the images will have to be backed up. If you store images as ordinary files, only the new image will be backed up. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images in the database good or bad?
But, you didn't take into account the amount of time it will take to backup the file system. What's important is that images are generally not modified, only added or deleted, so only new files will have to copied into the backup. Is the images are in a table, the whole table will have to backed up. Unless there exists some backup system that will only copy new records? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images in the database good or bad?
Some databases can automatically extract metadata (EXIF, for example). Now this is completely ridiculous: if you really need things like what's in EXIF, you extract it first and store it in an appropriate record about the file, just as well as width or height etc. This does not justify storing all pixels and colors as well in the database. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images in the database good or bad?
In my opinion, a database is used to organize related data. In this case, a binary file would be related to its metadata that you would normally store in a database. Michael, if you have a table to organize data related to employees, will you store the employees in the employee table? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images in the database good or bad?
Is it better to do a file upload, or better to insert to the database? The basic idea of a database is to organize data in such a way it can be searched and sorted. In principle, there is nothing to be searched or sorted in an image, so put it in the database will just add an overhead on the database engine for nothing. It is considered best practice to use the file storage facilities of the system hosting the application and only store in the database information about the image, like file name, size, type etc. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images in the database good or bad?
In my opinion, a database is used to organize related data. Right. In this case, a binary file would be related to its metadata Right, the *file* is related, but nothing *inside the file* is, so you store a reference to the file (ie; file name) in the database, but not what's inside the file. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301810 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images in the database good or bad?
* Rollbacks of failed data transactions won't leave orphaned binary files. You have to store the file on disk anyway when it is uploaded. If you also store the file content in the database, FIRST you have to copy the file from its temporary location to the database, which is an extra overhead for the server, SECOND, you have to delete the file from its temporary location anyway, whether the transaction succeeds or not. * May simplify migrating a system to a different data store location. May be, but the purpose of a database is to make data manipulation efficient, not to be migrated. This reminds me the big advantage of the Pascal language when it came out (one the first formal language) They said This language makes writing compilers for it much easier. Big deal, the purpose of a language is to make programming easier using it, not to write compilers for it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301814 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: many JS libraries are out there, which one for CF8 is the question.
Look at the code. If you can read it easily and understand it, this is fine, because what ever you choose, soon or later, you will have to modify it, correct a bug, add some new feature, customize to fit your specs, anything. Some libraries are pure jewels on an academic point of view, work smoothly, apparently written by skilled programmers,... but are just not readable. Just my 0.02$ -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: many JS libraries are out there, which one for CF8 is the question.
Is there any *WYSIWYG* editor for one of these? WYSIWYG? For Javascript code? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Baffling Error
There is really nothing you can do to stop them. Te prevent them, you're right, but you can definitely stop them, right after the first attempt: Ban the IP! -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: many JS libraries are out there, which one for CF8 is the question.
Something like what spry extnesions do in DW. Personally I never understood the need for this: Just have your browser on the page you're editing, update the file, refresh the browser. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Baffling Error
That is very interesting. Have you run into these a lot? What do these look like? I'm having such attempts about a dozen every day, all from different hosts, but all with the same user agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; ..NET CLR 1.1.4322) I suspect it's some kind of trojan that infects PCs anywhere. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Back button and Ajax
Thanks all for your replies. These solutions are implemented in very complex framework. So I,m trying to understand how the solution works and implement my own version. I'm trying to keep my applications simple, my AJAX function is just about 12 lines long. I already have a solution working for back/forward for Mozilla with about 5 lines ;-) I'm working on the MSIE, Opera, etc. solution. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301496 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Back button and Ajax
checkout Really Simple History Thanks, I found this one too. But it's still not as simple as it claims. I'm getting the details here: http://ajax.suaccess.org/options-and-efficiencies/fix-the-browser-back-button/ and I'm implementing the solution to my own ajax solution. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reg ex question
Thanks for a quick response. It does work however if I add body as another regex, the head section shows up in body. e.g. Hi, this is definitely a job for CF_REextract: See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm You can test it here: http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm 1. enter \[head\]|\[body\] in RE1 2. enter \[/head\]|\[/body\] in RE2 3. enter [HEAD] titleMy Home Page/title link href=style.css rel=stylesheet type=text/css / [/HEAD] [BODY] h1Home Page/h1 [/BODY] as sample text, 4. hit the Test button, et voilàà ! ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Back button and Ajax
For those who may be interested in the solution, I finally found it: The solution is NOT USE AJAX! Use the Remote scripting with hidden Frames instead ! 100 times simpler! In your main template 1. add an iframe in your main page, that will not display ie: iframe name=historyFrame id=historyFrame width=0 height=0 src=put your initial template here style=visibility: hidden; inline: none; /iframe 2. target every link that will call a sub-page to the hidden iframe, ie: A HREF=subPage.cfm TARGET=historyFrame 3. have some empty DIV that will receive the content for all sub pages: DIV ID=subPage/DIV 4. just have this script in your main template: SCRIPT function historyFrameLoaded (historyFrame) { document.getElementById('subPage').innerHTML = historyFrame.document.body.innerHTML; } In all subpage templates: - BODY onload=parent.historyFrameLoaded(this) any HTML goes here... /BODY THAT'S IT! - only 2 lines of Javascript. - works with ANY browser. - back and forward buttons fully supported - I've not tried yet, but I'm pretty sure that implementing support for bookmarking should be pretty straightforward. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Totally OT: Do you see what I see
do you see a clear 'flaw'? Sure! -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Back button and Ajax
Hi, Ajax is a nice feature, for instance when only some part of a page must be changed, one can populate some internal DIV instead of reloading the entire page. But the problem is when the visitor hits the back button: he then doesn't get back to the previous sub page, but to the page he opened the current page from. Has any one implemented some feature that would allow to 1. check if the back button is hit, 2. go back to the previous sub-page instead of the previous page? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to order appearance of database content...
Would this be the best way to do this? Other ways? In my CMS, there are several items the user can choose the order he wants, ie. paragraphs in a page. In order to do so, he has a list of all of them and he can move them up or down (Javascript). On submit, a list of items is created in order chosen by the user, in a hidden field. In the table, each item has a column seq for a sequence number. In the update template, I simply update all sequence numbers in a loop, ie: CFSET seq = 1 CFLOOP INDEX=paraId LIST=#listPara# CFQUERY DATASOURCE=#application.applicationName# UPDATE paragraphs SET seq = #seq# WHERE paraId = #paraId# /CFQUERY CFSET seq = seq+1 /CFLOOP Then use the seq column to sort by your queries. It may be a little more overhead on the database, but for items in small numbers (say less than 1000), it is marginal. And it is much simpler to handle than leaving holes between numbers and eventually renumber items any way when there are no more holes left. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to order appearance of database content...
I'm guessing the Javascript automatically assigns new values to the hidden field for seq for each paragraph upon reordering? Not exactly. I use a table to display elements, each one in its own row TR element. I use some move up and move down function to switch two TR element in a table. The row has icons like up and down arrows. For example: TR ID=#paraId# TD onclick=move(this, -1)IMG SRC=up.gif WIDTH=16 HEIGHT=13 BORDER=0 ALT=Move up/TD TD onclick=move(this, 1)IMG SRC=down.gif WIDTH=16 HEIGHT=13 BORDER=0 ALT=Move down/TD TD(description of the element)/TD /TR The the onClick function will find the TR parent element, the one before, or after and switch the two rows in the table. Then only on submit, the function setSeq is called. What it does, is get the table containing the elements, find all TRs in the order the use has chosen, each TR has an id which is actually the id of the paragraph. From these, the function set the valu of the listPara hidden field. Pretty simple: function setSeq() { var tb = document.getElementById(tablePara); if (tb) { var tr = tb.rows; var nbTr = tr.length; var val = tr[0].id; for (var i = 1; inbTr ; i++) val += , + tr[i].id document.formul.listPara.value = val; } } -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to order appearance of database content...
but it becomes a pain for the user when they want to move an item (an agent, in this case) several slots up or down. Exact. I favored the arrow method because pages have only a few paragraphs in average. For my menu editor however I use the drag'n drop method. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Naming Forms randomly
The problem is that when i try to refer to the form name in any CF template I may be wrong, but AFAIK, the form name is not transmitted by HTTP, it is only available to Javascript on client side. Even if a page contains several forms, only one can be submitted at a time, and all its fields are referred in the form scope in the action template. So there is no use to name forms differently (is necessary at all). If you need to know which form was submitted, include the id in a hidden field. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Naming Forms randomly
If i make a hidden field and put the ID value in there, Wouldn't the name of the field be the same for every form? Not if you're wise enough to use a separate hidden field with a different id for each form ;-) Keep in mind that only ONE form gets to the action page. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Get a digit out of large number
Mid(getdon.recordcount,2,1) This will in fact return the second digit from the left, same thing only for 5 digit numbers. For the third digit from the right I would rather use this: CFSET digits = left(right(getdon.recordcount, 3),1) ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bots URL Strings...
That said, what do *you* do to fail gracefully I do not fail gracefully, I counter-attack aggressively ;-) This is my code at the beginning of any template that relies on some numeric url parameter. but it can be easily adapted for any kind of string parameter. !--- Check if id contains a numeric value --- !--- if not, http means a SPAM attack, user means an SQL injection attempt --- CFIF val(id) EQ 0 AND (id CONTAINS http OR id CONTAINS user) !--- Store IP address in any ban IP table --- CFABORT CFELSE CFSET id = val(id) /CFIF I use a datasource common to all my applications to store banned IPs. I also use a table to store dumps of sessions, application, url, form scopes in case of error, instead of sending an eMail. Then the only thing the visitor (or bot) sees is something like ps, sorry for the errror. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need full path file browser
Is this possible? With cross compatible code, the answer is no. If you use Explorer, you will have to make some ActiveX component to do so. provided the use will accept to load it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex Advice
I'm using the following URL and working to obtain all the image absolute paths: May be you should have a look at CF_REextract : http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm It will save you lots of coding, and could even CFHTTP the file for you. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regex Advice
I'd never heard of CF_REextract. You should visit us more often ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cffile misbehaving?
they both have the file name and no directory information can be found. I'm surprised there even exists a cffile.clientDirectory variable, since this information is never provided by any browser. If it was it would constitute a serious breach in security. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cffile misbehaving?
Hence it seems that it would have had to know where to get the file from (i.e. the client's directory and file path). The server does not get the file, the client sends the file, therefore the server does not need to know the directory name. The server gets the file name, but this is just because the browser is kind enough to send it with the file. In theory, the server wouldn't even need the original file name. This is how the HTTP protocol goes, nothing you can do about it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficie nt
Have you seriously looked at what Ext offers? What's Ext ? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best WYGIWYG Browser based html text editors for Coldfusion
I saw FCKeditor and it claimes to be the best. And it is probably the best, but that's the problem: it is far too best to be used by low end users. IMHO. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficie nt
3. Use something else that's not integrated. 4. develop your own ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: emails stop being sent by CF
For no apparent reason, emails stop being sent by CF. I'm having this problem about once a year. The problem is cause by an invalid file in the spool. I mean a file that contains no information that could make a valid message. This causes the spooler to loop indefinitely on the problem. The solution is to delete the first file in the spooler, then the rest should be sent. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfFile
Well, one of my users insists he is uploading a pdf It may be in PDF format, but does it have a .pdf extension? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:22 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Interesting idea for next CF - thoughts...
CFPARAM NAME=myVar DEFAULT=233 HINT=myHint What would be the advanteage over simply using CFPARAM NAME=myVar DEFAULT=233 !--- myHint --- ? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC protect from SQL Injection?
Everyone keeps talking about SQL injection this, and SQL injection that, but I would like to see some examples. Exact, and also all the examples I've ever seen suppose that an extra SQL statement is added after some ; character. This won't work with an Acces database, so Access databases are not so evil ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC protect from SQL Injection?
but I don't think everyone will use that as a rationale to switch to text based data storage My intention was not to give the advice to switch to anything, just to mention that if someone is using an Access database, may be mostly for simplicity, he might not worry that much about SQL injection and use solutions simpler that CFQUERYPARAM. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC protect from SQL Injection?
Either way, use cfqueryparam. It makes injection attacks impossible Personnaly, I not only defend my sites against SQL injections, but I definitely close the door. When I have a parameter in a query which should be numeric, like ?id=... I use this test: CFIF val(id) EQ 0 AND (id CONTAINS http OR id CONTAINS user) !--- SQL injection or spam attempt : ban this IP --- CFELSE CFSET id = val(id) /CFIF I've noticed that practically all SQL injections will try something on some user column, and all spam injection will try to plug some alien site somewhere. If this happens, this is the last time a request from this IP address is honored. Otherwise, if the value contains anything not numerical, the id is set to 0 which will always cause a 404 error. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFwhaturl?
But I am still in the old 4.0 days. Gee! Are you related to Rick Faircloth? ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: regex help
I need some help with regular expressions. What you need is the kind of requirement I made CF_REextract for. See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: How to stop bots indexing my dev sites
Use robots.txt: This is correct to control good bots, but bad bots don't read it. Some (very) bad bots even exploit what is in the file to read what's forbidden. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: How to stop bots indexing my dev sites
Once I started reviewing rankings, I found that my development site was ranking higher for the content than my client's main site! Not good! Exact. But robot control is not something trivial. Firstly, there are true and friendly robots, like Google, secondly, there are bad bots, looking for mail addresses, trying to put spam into your sites, chinese bots checking if your site should be banned because they are speaking about human's right, etc. Good bots are easy to recognize: they have a web address in the user agent, ex: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) Bad bots are more tricky to detect, because they don't want to look like a robot, then they mimic standard browsers like MSIE, Mozilla, etc. I've designed my own bad bot detector (robotCop) and it takes several factors in account like: - reads the robots.txt file, - respects instructions in the robots.txt file, - falls in click trap (some link not visible by a human visitor) - average time spend between pages, - reads images, - reads javascript files, - execute Javascript, - support cookis, - listed in black lists... etc. Based on these factors, agents are granted - full access (supposedly human browsers) - text only (supposedly good robots) - banned (supposedly bad or unwanted bots) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: How to stop bots indexing my dev sites
If he is simply trying to prevent search engines from indexing certain folders, he should be fine? Let's say 50% fine, since bad bots (may be 50% of all robot traffic) do not even care reading robots.txt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Generating unique random numbers
The transaction won't actually isolate you from a race condition. Not if all applications use the same template for the transaction. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sending entire Form back on a url string
You should only have to copy structures by value (using either StructCopy or Duplicate) if you want to maintain two separate structures, so that changes to one don't affect the other. That is not the case here. Ok, I see what you mean, but if you do it this way, won't the session.form structure disappear in the same time the form structure will? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sending entire Form back on a url string
You shouldn't have to duplicate the form. Just copy it into the Session scope. I think I tried first with structCopy ans encountered some problem, I don't remember which one, so I changed for StructDuplicate. This was years ago. Anyway, since the form scope is not supposed to contain structures, the two functions are equivalent. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFexecute, batch file calling another batch file
When the first bat file is executed, the default drive/directory are where CF is running, not where the bat file is stored. So you should also set the drive and directory correctly before calling the other bat files. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sending entire Form back on a url string
Stick the form in the session scope maybe? Definitely: To save the form: CFSET session.form = Duplicate(form) Then in the form action template: CFIF isDefined(session.form) !--- For some unknown reason, duplicate() doesn't work here --- CFLOOP COLLECTION=#session.form# ITEM=field CFSET form[field] = session.form[field] /CFLOOP CFSET structDelete (session, form) /CFIF ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sending entire Form back on a url string
but the object will remain in the heap because it has another reference. Ah ok, I see. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload
I check the file name and see if it already exists in the database. If it does, then I return the error. If it doesn't exist, then go and perform the cffile action. This is the way you see it, but not the best and easiest way to do it. This is the way I do it: - upload the file and rename it on the server with a unique local name, ie: CreateUUID() - store in the database both the local name and the original name. This way, you can have several files with the same original name. When a user retrieves a file, you can read it using the local name, and send it under the original name, users will never see the local name. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF and Scheduled Tasks...
Is there anyway to configure the CF to run a scheduled task every M-W-F at a specified time? Schedule the task for everyday, and have the task check for the day and CFABORT on bad days. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Upload progress bar
The progress bar reflects real state of upload (the vault opens an additional connection to receive info from server about upload progress) In this case, the system must know how and where the HTTP server stores the temporary file while it's being loaded. So there should be different version for IIS, Apache, CFMX, etc. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: date problem
i believe Claude meant a date picker That's it! Date picker! ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297621 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: date problem
so we first check with input mask US and if it says invalid date then we pass in input mask EU and if it works Good point. But this is not really 100% proof, since some dates may be valid in US format, although they were meant in EU format. Take 10/11/2008 for instance. So the date may be valid and still not be the good one. To be 100% sure, you could consider a date pick up system. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297542 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date problem
thanks again for all your help claude You're welcome, and congratulation for you wise shopping ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date problem
07/24/1978 is an invalid date format Ok, now I see what your problem is: If you're using LSdateFormat, the function (and here is the difference with dateFaormat) expect a date. Since 07/24/1978 is not a date, but a string, CF will try to convert it to a date, but according the English (UK) standard, which is dd/mm/. Thus 24 is interpreted as the month, this is what causes the error. If you use only dateFormat, the date can be interpreted as an American date and it works. You only have two choices: 1. use createDate and pass independently the day, month, year parts as substrings of the date. 2. spend a few bucks, save lots of time and hurry to get CF_convertDate here: http://www.contentbox.com/claude/customtags/convertDate/viewConvertDate.cfm With only one line of code, you will solve your problem: CF_convertDate inputVariable=myDate inputMask=US outputMask=EU or in function call format: CFSET outputDate = convertDate(myDate, string, string, US, EU) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297491 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: lsdateformat and dateformat clarification
it seems to me that lsdateformat function takes an english uk formated date (dd/mm/) More precisely, I would say it takes a date in the default locale format, or the locale previously defined by setLocale() If your server is English, then yes, you are right. For servers un US, it will take an American date. and it seems that the dateformat function takes a USA formated date (mm/dd/) Yes, if the date is a legal date, otherwise it will try in English (or Eurpean format) i thought that with the lsdateformat i could pass it any formated date and it would format it into dd/mm/ format This is right, if you really pass a date, ie Now(), but 25/01/2008 is NOT a date, it's a string. So the string has to be converted first, and this is where trouble start. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SSL Necessary? Important?
IN NO EVENT WILL ZILLOW.COM OR ANY SUPPLIER BE LIABLE FOR ANY DAMAGES I'm sorry, but just from the very begining, this statement has absolutely no value. I hope you didn't pay a lawyer to write it. Nobody can state, in advance on not that he is not liable or responsible. ONLY a judge in court can make this decision, only based on facts. If you have been careless in an issue, EVEN if you warned the plaintiff that you are not liable, the judge can decide that you are responsible. The only utility of such notice is may be 1. to make unaware customers believe they can't go to court, 2. to make them do their part about security. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flatten out a relational database
I don't just want: permit info,company1 permit info,company2 Why not? If you use the GROUP attribute in CFOUTPUT, you can make your query really look like Permit Info 1-Company1 2-Company2 -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SSL Necessary? Important?
Then, I sign up for your church's web site and use the same username and password combination. Now, if someone sniffs that unsecured connection, they now have my bank username and password. Ok, but it is not the church responsibility to protect you bank username and password. It's your problem. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: SSL Necessary? Important?
But the church is also asking about an encrypted connection using an SSL certificate. What a meanness! Don't they have some sort of divine protection already? ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The _ character in variable names
Is this a legal syntax in ColdFusion Yes it is. And you can even keep all those [EMAIL PROTECTED] dollar signs in front of all variable names ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SSL Necessary? Important?
Of course users may not desire the warning about an untrusted cert and this can be worse than no protection at all. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SSL Necessary? Important?
In a world of paranoia, SSL is *NEVER* overkill for protecting logins of any kind. provided you assume paranoia... -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Limit on cfftp getfile file size?
And how do I adjust the timeout for it? In the template? Somewhere in CFAdmin? In CFAdmin, you have a Timout field you can set. If you schedule the task from CFSCEDULE, this parameter is transmitted though the requestTimeOut attribute. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression To Pull Values From A Commented Area
Is there anybody out there who can help me do this? Sure, there is CF_REextract. It will return all your fields in a list or a query, and even read the file for you. See: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Too Few Parameters, expected 1
Too few parameters. Expected 1 This usually means that one of the column names is erroneous. Password might also be a reserved word. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: SSL Necessary? Important?
Is the SSL encryption overkill for something like this? IMHO yes. Unless they are willing to pay for more protection, because it is not free. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF MX8: This is driving me nuts!!!
doesn't access prefer double quotes? (getUser.UserLogin = paulw) AND (getUser.Password = 2324986) It can take both. Anyway, this is one of the task of the ODBC OR JDBC driver to translate SQL command into local db dialect. For instance, Access needs #...# around dates, but you don't have to care about that from CF. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: writing insert query sql in coldfusion
I'm pretty sure you don't need to use all that concatention. But he still needs preserveSingleQuotes. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: allowable characters
Also beware of quotes and double quotes that may interfere with CF, SQL or HTML statements. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: This evaluate thing always stumps me...
cfif IsDefined(evaluate(form.grp_sort_#myIDX#)) Iiiirk, you're having quotes inside quotes and # inside #... :-( Try this instead cfif IsDefined('evaluate(form.grp_sort_#myIDX#)') Anyway, I doubt this will work: evaluate will either return the value of form.grp_sort_#myIDX# if it is defined, either cause an error if not. Too bad for isDefined :-( What you really want may be more simply: cfif IsDefined(form.grp_sort_#myIDX#) AND evaluate(form.grp_sort_#myIDX#) NEQ -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date problem
i have just tried it by using dateformat instead of lsdateformat and it worked fine. Again, WHERE does is work, and WHERE doesn'it ? If it is in an UPDATE or INSERT SQL statement, it may work, or not, depending of the way CF will interpret the data as a date. In SQL, you should always use CreateODBCDate or CreateODBCDateTime, never submit a date as a formated string. See: http://www.contentbox.com/claude/customtags/convertDate/viewConvertDate.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: date problem
i have dates stored in a mysql db which is in the format /mm/dd First of all, unless your date field has text type and you store the date as a string, the db format is not /mm/dd. It is some floating value specific to the database. Some early db systems would store it as a string MMDD, like dBase, Foxpro, Clipper, etc. when i try to get data out of the db and put it in the dd/mm/ format i use lsdateformat(date,dd/mm/) and it spits out an error: 01/20/2008 is not a valid date format!! Show us some code, especially the line that spits ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: date problem
we use mysql 5.0 and it does store the date as /mm/dd. This this actually how your database will *display* the date, but internally, it is stored as a 3 bytes integer value. (see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html ) But are you sure the field is defined as a *date* type, or as a string? Anyway, CF should be able to recognize the format even if it is passed as a string from the query. I'v tried this code, and it works wit no problem under CF 5 ans CF 7 : cfset SetLocale(English (UK)) CFSET date1 = 16/01/1990 CFSET date2 = 01/16/1990 CFSET date3 = 1990/01/16 CFOUTPUT dateFormat(date1, dd/mm/) = #dateFormat(date1, dd/mm/)#BR dateFormat(date2, dd/mm/) = #dateFormat(date1, dd/mm/)#BR dateFormat(date3, dd/mm/) = #dateFormat(date1, dd/mm/)#BR LSdateFormat(date1, dd/mm/) = #LSdateFormat(date1, dd/mm/)#BR LSdateFormat(date2, dd/mm/) = #LSdateFormat(date1, dd/mm/)#BR LSdateFormat(date3, dd/mm/) = #LSdateFormat(date1, dd/mm/)#BR /CFOUTPUT if i put exactly the same code but take out the ls then it works fine Weird indeed. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date problem
I think that the dateFormat() functions will consider any string passed as a numerical representation of the date unless it's quoted. All CF function will take ANYTHING, strings, numerics or dates (which are float values anyway), if it can be converted to a date, CF will convert it prior passing the value to the function. The only problem is that it will first try to convert it according to the American format. If you're working in American format, then this is not a problem, but for the rest of the world, there is a risk that the date in converted the wrong way. IE: 13/10/2007 will be interpreted as october 13 2007, because it is not a valid date under American format. But just one day before, it would have been interpreted as Dec. 10th 2007! This is a real time bomb. You may have an application working correctly for days, the suddenly (the 13th of each month) it will bug. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: date problem
So it definitely seems like CF treats the input differently somehow. Not really. CF is a typeless language. It is SGML compliant and HTML compatible. So by definition, EVERYTHING is passed as a string in attributes, even if there is no quotation mark. For function calls, it is a bit different: Every function expect values to be passed as numeric, date or string or object,... Like in many languages, if the type of an argument is not what is expected, the argument will be automatically converted into the correct format PRIOR to call the function. It is then an arror to think that a function like dateFormat () can receive a date as a string. It ALWAYS recives date as a date, if the argument was a string, the compiler had it converted before the function was called. This is when it becomes dangerous, because CF has to guess the original format from which it has to make the conversion, and sometimes it guesses wrong. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date problem
so I assume it differs somehow. Well, there is actually a difference: If you pass the date as a date to dateformat(), ie: dateFormat(now()...), there is no ambiguity. It will always work. However, if you pass it as a string, CF will have to convert it, and if you work with dates in ISO format, and do not set up your Locale correctly, you're asking for trouble. there is about 50% chance the conversion will be wrong. So better always explicitly convert the dates yourself. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JavaScript version of listContains()
The guy from leftcorner.com (offline) ported a bunch of CF functions to JS. I still have a copy. Pretty handy. Pretty handy indead. Javascript looks like a retarded language when dealing with strings. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: JavaScript version of listContains()
that's not to say there's not a simple way tho. The only other way I can think of is using regExp, but not really simpler. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: insert/retrieve image into database SQL Server 2005/CF8?
There's nothing wrong with storing images in a modern RDBMS. Except may be people having problems and asking questions in forums ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tags useful to accomplish automating MLS direct feed into MySQL DB?
I will then import the tab delimited info and property filenames into an MySQL database, and place the property photos into the appropriate local server directory. Are you under Windows? The easiest (although not trivial) way to do it is to define an ODBC DSN using the Microsoft Text Driver (*.txt; *.csv) The DSN is defined on some directory in your system and any *.csv file you drop in this directory will become a Table in your DSN, a table you can make queries on. From here, you can read all records and do whatever you need with them. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Tags useful to accomplish automating MLS direct feed into MySQL DB?
Interesting approach. Is there someplace I can read up on this approach? Dunno, I managed to set it horsing around with the ODBC manager in Windows. See Administrative tools -- ODBC manager. You must have a special directory dedicated to your .csv files, then you set your txt csv ODBC driver on this directory. Then define an ODBC datasource on it from CF 8 (More complicated than with CF4.5 hey). As soon as you drop some.csv file in this directory, you get a some table in your DSN. I thing you must have the first record to list the column names however. At least, this is the way my application works. (I update a list of students from an university this way once a year, it works pretty well) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296802 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Tags useful to accomplish automating MLS direct feed into MySQL DB?
I was sent with the property information and I didn't see any column names in the info. It might be a problem, unless there is a possibility to set the ODBC connection not to use the first row, I don't know. But since you get the file by FTP, you can still append it to a one line file containing the column names you want. This is still workable. If you can manage to set up this ODBC DSN, you will appreciate being able to get all your data in a query. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion IDE survey
You don't check in FireFox (20%+ of Europe uses it) ? I was speaking about my own customers. In average and roughly, their sites are visited at 80% by MSIE, 10% Firefox, 10% others. But 100% of the administrators are using MSIE, and none is in Europe. So I FIRST check for MSIE compatibility. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4