Flash Forms
Is there any extra code that I have to add to get flash forms to show in Windows IE? I have a flash form chart, which works in Firefox Safari, but when I checked IE, not chart at all! The chart is at: http://www.johnbarrett.net/ I just assumed that the flash forms worked as long as the computer had the right flash player(I think FP 7 for cf forms), there is nothing about IE for flash, right? That is the flash player is a client program, and is not depended on the browser that is used? John ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Galleon ColdFusion Forums updated
Raymond Camden wrote: Many of the new features are based on Rick Root's CFMBB, which was based on Galleon, so it's all good. :) All hail open source! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Galleon ColdFusion Forums updated
Hail ! -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Saturday, November 04, 2006 7:58 AM To: CF-Talk Subject: Re: Galleon ColdFusion Forums updated Raymond Camden wrote: Many of the new features are based on Rick Root's CFMBB, which was based on Galleon, so it's all good. :) All hail open source! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using CFHTTP to login
The reason is the html form (login1.cfm) is working well and I try to simulate the login process exactly as we login as that html form. Yes, but you are doing it from your browser. If the login procedure uses tricks to detect if the form really comes from a browser, or from a server, they may use some other characteristics you didn't think of. remember you asked me to try to disable cookie and submit the form that works? I got the same screen as I do with cfhttp which is login form WITHOUT any error message. I would suggest that the problem might be is the asp.net think that the cookie is disabled and the login process does not happen. I think this is it indeed. There must be something not perfect in the way you return the cookies to the .Net application. I would concentrate my efforts on this. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flash Forms
This comes up every few weeks. IE suffered from a patent issue; MS had to alter the browser in a way which prevents some types of flash from working properly unless written out to the browser via javascript. CF 7.0.2 fixes this, but you need the CFIDE folder correctly mapped or you need to copy the JS files from the relevant folders there to your own CFIDE folders. On 11/4/06, John Barrett [EMAIL PROTECTED] wrote: Is there any extra code that I have to add to get flash forms to show in Windows IE? I have a flash form chart, which works in Firefox Safari, but when I checked IE, not chart at all! The chart is at: http://www.johnbarrett.net/ I just assumed that the flash forms worked as long as the computer had the right flash player(I think FP 7 for cf forms), there is nothing about IE for flash, right? That is the flash player is a client program, and is not depended on the browser that is used? John ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JS Rollover Not Opening New Browser Window
Hi, Matt...no offense taken whatsoever..(not enough time
or energy to be wasted in this world by taking offense at
needing or getting help or an ego that prevents me from
realizing or getting the help I do need!)
Anyway..I figured out what the problem was...and you're right
that it's not the javascript that's handling the new window,
it would be the a href tag, the HTML. (I think that's an accurate view)
The problem came when the HTML was rendered with a space before
the Target=_blank part. The browser was making it
a href=http://www.fl.living.net/idxfirm/3087550%20Target=_blank; ...
As soon as I removed the blank space before Target, 3087550Target=_blank,
it worked fine...not sure why but at least it solved the problem.
The space doesn't affect other links using the space before Target=_blank,
but
it does keep this one from opening a new window.
Thanks for the work on the code...I'll keep that hand for future use.
Rick
-Original Message-
From: Matt Williams [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 04, 2006 12:27 AM
To: CF-Talk
Subject: Re: JS Rollover Not Opening New Browser Window
Rick, I don't mean to offend in any way, but you did say your
javascript was generated. Honestly I don't see how your javascript
does anything. Here's a simple example of how you can do a link with
an image. When you mouse over the image, it changes to the 02 version
of the image. When you mouse off, it goes back to 01.
When you mouse over the image and click on it, it will first change as
described above based on the onMouseOver javascript event. The a
href tag handles opening the link in a new window (based on
target=_blank).
The main difference in what I have here is that the onMouseOver and
onMouseOut event calls are in the img tag, not the a href tag.
Also the this.id part is case sensitive, so this.ID won't work.
script type=text/javascript!--
function switchImage(imgID, imgSrc) {
document.getElementById(imgID).src = imgSrc;
}
//--/script
a href=http://www.fl.living.net/idxfirm/3087550; Target=_blank
img id=PictureRollover36 height=21 width=170
src=./Florida_Properties_01.jpg border=0 alt=
onMouseOver=switchImage(this.id,'./Florida_Properties_02.jpg')
onMouseOut=switchImage(this.id,'./Florida_Properties_01.jpg') /
/a
Hope this helps.
Matt
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259161
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ImageMagick
Has anyone had problems with ImageMagick converting images for thumbnails? I just upgraded it to the latest version and now it converts some images and not others. Jenny -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.27/517 - Release Date: 03/11/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ImageCFC
Trying to find code examples/docs for the image cfc, can anyone post me a link/s, please? Thanks, Jenny -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.27/517 - Release Date: 03/11/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259163 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 CF7 Hosting company
I can speak for HostMySite; they are good, especially since they take Linux hosting seriously and you get a good deal more on Linux than on Windows for the same price. They take CF really seriously and they were willing to make security better when a few of us raised some issues. Another popular host (I won't name it) was clueless about the same security issues (confirmed with testing). On 11/4/06, John Morgan [EMAIL PROTECTED] wrote: I can't speak for HostMySite either, but I do know that have a pretty good reputation and some snazzy print ads. For me my experience with ViUX has been good and so they keep my business. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using CFHTTP to login
Yes, but you are doing it from your browser. Another try: When you call the login action from your CF login form, the request is actually sent by your browser. Then, if may have some cookie in it set previously by the server, it will recognize it and the login is accepted. When calling from CFHTTP, you don't have these cookies, and the login fails. Now, can you try again your CF login form just after having erased all your cookies. If some check cookie was set initially by the normal login form, your CF form should fail now. Then you know what you have to look for. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ImageCFC
Hi Jenny, I have this here http://johnnyle.no-ip.com/list.cfm?qa_id=210 It may not be what you are looking for, but you could use it as a starting point. This one can only resize an image. Johnny Trying to find code examples/docs for the image cfc, can anyone post me a link/s, please? Thanks, Jenny -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.27/517 - Release Date: 03/11/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Advanced SQL question
Hi, I know that COLUMN LIKE '%MORE MESSAGES TO FIND%' will find all the data that has the phrase 'more messages to find' in it. Now how do I find all the data that either has 'more', 'messages', 'to', 'find', 'more messages', 'messages to', 'to find', 'more messages to','message to find', or 'more message to find' in it? I know this is invalid %COLUMN% LIKE 'MORE MESSAGES TO FIND', but is there a way to do it? Thank you. Johnny ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Where Date Statement in MySQL
Hi Guys, I am running into a problem that I have tried to solve for 3 hours now with no avail...I have the following statements and query: cfset startdate=#DateFormat(rsGetCustOrders.order_Date,'-mm-dd')# cfset enddate=#DateFormat(DateAdd(d,90,rsGetCustOrders.order_Date),'-mm-dd')# cfquery name=Recordset1 datasource=#request.dsn# SELECT * FROM tbl_picks Where LEFT(tbl_picks.Pick_SKU,4) != and tbl_picks.Pick_SKU != FREE and Left(tblpicks.Pick_SKU,10) between #startdate# and #enddate# /cfquery The query works without the last where clause and Left(tblpicks.Pick_SKU,10) between #startdate# and #enddate#; in the Pick_SKU the first 10 char are the DATE 2006-11-03 Thanks, Cornel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Advanced SQL question
Just use multiple LIKE statements COLUMN LIKE '%MORE MESSAGES TO FIND%' OR COLUMN LIKE '%MORE%' Etc - Snake -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: 04 November 2006 15:15 To: CF-Talk Subject: Advanced SQL question Hi, I know that COLUMN LIKE '%MORE MESSAGES TO FIND%' will find all the data that has the phrase 'more messages to find' in it. Now how do I find all the data that either has 'more', 'messages', 'to', 'find', 'more messages', 'messages to', 'to find', 'more messages to','message to find', or 'more message to find' in it? I know this is invalid %COLUMN% LIKE 'MORE MESSAGES TO FIND', but is there a way to do it? Thank you. Johnny ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Where Date Statement in MySQL
First, use CFQUERYPARAM with CF_SQL_VARCHAR as the type. There are various security/performance reasons, but it will also prevent MySQL from doing an implict conversion to a date. I don't know if it's happening, but it might be. Also consider that you're doing string comparisons, not date comparisons, so things might not be quite as you'd expect. cheers, barneyb On 11/4/06, Cornel Ivanescu [EMAIL PROTECTED] wrote: Hi Guys, I am running into a problem that I have tried to solve for 3 hours now with no avail...I have the following statements and query: cfset startdate=#DateFormat(rsGetCustOrders.order_Date,'-mm-dd')# cfset enddate=#DateFormat(DateAdd(d,90,rsGetCustOrders.order_Date),'-mm-dd')# cfquery name=Recordset1 datasource=#request.dsn# SELECT * FROM tbl_picks Where LEFT(tbl_picks.Pick_SKU,4) != and tbl_picks.Pick_SKU != FREE and Left(tblpicks.Pick_SKU,10) between #startdate# and #enddate# /cfquery The query works without the last where clause and Left(tblpicks.Pick_SKU,10) between #startdate# and #enddate#; in the Pick_SKU the first 10 char are the DATE 2006-11-03 Thanks, Cornel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ImageCFC
Are the actual examples on this site not good enough? http://www.opensourcecf.com/imagecfc/example.cfm ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFMBB 1.11 Released
Ray updating Galleon made me feel embarassed that I released version 1.1 of CFMBB 3 months ago and haven't fixed any of the bugs that were in it. So CFMBB 1.11 is now available. You can download it from http://www.cfmbb.org It is only a bug fix release over 1.1 If you were using the stable 1.01 version, this version includes private messaging, moderator support, and announcement topic types. My next release will PROBABLY focus on adding multilingual support. Anyone out there want to volunteer to write translations, please email me! Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Where Date Statement in MySQL
First, use CFQUERYPARAM with CF_SQL_VARCHAR as the type. There are various security/performance reasons, but it will also prevent MySQL from doing an implict conversion to a date. I don't know if it's happening, but it might be. Also consider that you're doing string comparisons, not date comparisons, so things might not be quite as you'd expect. cheers, barneyb On 11/4/06, Cornel Ivanescu [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Where Date Statement in MySQL
I actually got it to stop giving me an error by putting the first Left stateement in between quotes, however it does not compare them as dates but strings...I saw that once the error stopped showing up... How do I change it so MySQL does compare them as dates? as that was the original intent. Cornel First, use CFQUERYPARAM with CF_SQL_VARCHAR as the type. There are various security/performance reasons, but it will also prevent MySQL from doing an implict conversion to a date. I don't know if it's happening, but it might be. Also consider that you're doing string comparisons, not date comparisons, so things might not be quite as you'd expect. cheers, barneyb On 11/4/06, Cornel Ivanescu [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Where Date Statement in MySQL
Convert them to dates. On the SQL side use the convert() function, on the CF side use the CreateODBCDate() fucntion. Russ -Original Message- From: Cornel Ivanescu [mailto:[EMAIL PROTECTED] Sent: 04 November 2006 18:40 To: CF-Talk Subject: Re: Where Date Statement in MySQL I actually got it to stop giving me an error by putting the first Left stateement in between quotes, however it does not compare them as dates but strings...I saw that once the error stopped showing up... How do I change it so MySQL does compare them as dates? as that was the original intent. Cornel First, use CFQUERYPARAM with CF_SQL_VARCHAR as the type. There are various security/performance reasons, but it will also prevent MySQL from doing an implict conversion to a date. I don't know if it's happening, but it might be. Also consider that you're doing string comparisons, not date comparisons, so things might not be quite as you'd expect. cheers, barneyb On 11/4/06, Cornel Ivanescu [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Where Date Statement in MySQL
First, use CFQUERYPARAM with CF_SQL_VARCHAR as the type. There are various security/performance reasons, but it will also prevent MySQL from doing an implict conversion to a date. I don't know if it's happening, but it might be. Also consider that you're doing string comparisons, not date comparisons, so things might not be quite as you'd expect. cheers, barneyb On 11/4/06, Cornel Ivanescu [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advanced SQL question
Indeed, though to be honest LIKE could cause peformance issues depending on record size, Maybe more advanced search needs to be taken out of the DB and into a search engine. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Snake To: CF-Talk Sent: Sat Nov 04 17:44:07 2006 Subject: RE: Advanced SQL question Just use multiple LIKE statements COLUMN LIKE '%MORE MESSAGES TO FIND%' OR COLUMN LIKE '%MORE%' Etc - Snake -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: 04 November 2006 15:15 To: CF-Talk Subject: Advanced SQL question Hi, I know that COLUMN LIKE '%MORE MESSAGES TO FIND%' will find all the data that has the phrase 'more messages to find' in it. Now how do I find all the data that either has 'more', 'messages', 'to', 'find', 'more messages', 'messages to', 'to find', 'more messages to','message to find', or 'more message to find' in it? I know this is invalid %COLUMN% LIKE 'MORE MESSAGES TO FIND', but is there a way to do it? Thank you. Johnny ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Where Date Statement in MySQL
Ok... I got it to work comparing it as a string (you were right)... which is not the intended action.I was missing the quotes around the left statement - putting them in got it working to compare... Now how do i compare it as a date? I have no way of changing the field to date type so I have to do it in the where statement somehow... Cornel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Saving a non en_US locale date to MSAccess
Sorry to bump this, but I could really use some input and advice on the post below from the gurus on the list. An european locale (it_IT) shows the date as d/m/yyy in a form field. At the moment of retrieving from the MSAccess db it will not be recognized. So, before saving, I parse the date with DatePart(...), recompose it with CreateDateTime(...) and finally create the dateobject with CreateODBCDateTime(...) This way the date is saved correctly. Couldn't find any LS function to restore it to local date format. Am I wrong? Is there a less cumbersome way to do it? Thank you very much. ContiW ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Network speed
I have been with a particular CF hosting company for a number of years. Recently I sent them two machines for co-location. The first, which I sent months ago, is connected to the Internet at 100Mbps. The second, which I sent days ago, is connected at 10Mbps. They told me there was a policy change because they didn't want people going to far over their bandwidth limit for the month. They also told me that there should be no visible difference for my CF applications doing work on the Internet. 1) Maybe I don't understand this but I don't see the relationship between the network connection speed and the total bandwidth usage in a month, only that if you have a higher network speed, you have the potential of using the bandwidth at a greater rate. Is that right? 2) Developers have told me that the CF applications on the new server seem to do work on the Internet more slowly. Could this be the case or are we just imagining this? Is there anyway to test this difference in speed? I did some tests using the CNET bandwidth measurement, but besides that I'm not sure how to test it to show them that there is a difference in speed. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Network speed
I have been with a particular CF hosting company for a number of years. Recently I sent them two machines for co-location. The first, which I sent months ago, is connected to the Internet at 100Mbps. The second, which I sent days ago, is connected at 10Mbps. They told me there was a policy change because they didn't want people going to far over their bandwidth limit for the month. They also told me that there should be no visible difference for my CF applications doing work on the Internet. 1) Maybe I don't understand this but I don't see the relationship between the network connection speed and the total bandwidth usage in a month, only that if you have a higher network speed, you have the potential of using the bandwidth at a greater rate. Is that right? 2) Developers have told me that the CF applications on the new server seem to do work on the Internet more slowly. Could this be the case or are we just imagining this? Is there anyway to test this difference in speed? I did some tests using the CNET bandwidth measurement, but besides that I'm not sure how to test it to show them that there is a difference in speed. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best CF7 Hosting company
Another popular host (I won't name it) was clueless about the same security issues (confirmed with testing). oh you mean Crystaltech!! haha I dont think you can get better than hostmysite, i just got a vps server there and its sure nice having control over everything. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Network speed
The difference is the throughput. Imagine like having 512k ADSL or 2MB ADSL. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 November 2006 21:19 To: CF-Talk Subject: Network speed I have been with a particular CF hosting company for a number of years. Recently I sent them two machines for co-location. The first, which I sent months ago, is connected to the Internet at 100Mbps. The second, which I sent days ago, is connected at 10Mbps. They told me there was a policy change because they didn't want people going to far over their bandwidth limit for the month. They also told me that there should be no visible difference for my CF applications doing work on the Internet. 1) Maybe I don't understand this but I don't see the relationship between the network connection speed and the total bandwidth usage in a month, only that if you have a higher network speed, you have the potential of using the bandwidth at a greater rate. Is that right? 2) Developers have told me that the CF applications on the new server seem to do work on the Internet more slowly. Could this be the case or are we just imagining this? Is there anyway to test this difference in speed? I did some tests using the CNET bandwidth measurement, but besides that I'm not sure how to test it to show them that there is a difference in speed. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Saving a non en_US locale date to MSAccess
Couldn't find any LS function to restore it to local date format. Am I wrong? LSDateFormat? Is there a less cumbersome way to do it? LSParseDateTime? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Network speed
1) Maybe I don't understand this but I don't see the relationship between the network connection speed and the total bandwidth usage in a month, only that if you have a higher network speed, you have the potential of using the bandwidth at a greater rate. Is that right? Presumably, you could consume more of your ISP's network bandwidth, although I would be a bit surprised since most hosting providers I've seen segment separate customers' networks. 2) Developers have told me that the CF applications on the new server seem to do work on the Internet more slowly. Could this be the case or are we just imagining this? Is there anyway to test this difference in speed? I did some tests using the CNET bandwidth measurement, but besides that I'm not sure how to test it to show them that there is a difference in speed. This could be caused by all sorts of things. Try to eliminate them one-by-one. Measure server execution times, database connectivity times, wire time, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Network speed
It depends on what their internet bandwidth is compared to their internal network speed. For example, at our University, we run all desktops at 100Mb. Our servers are connected at 1Gb. The servers need the faster connections because we are throwing data all around the server room. However, our desktops don't constantly use all of their 100Mb bandwith. Now, our internet connection allows for 24Mb. So, where is the bottleneck? Our internet connection. In most places, the bottleneck will always be the internet connection. The only time that 100Mb or 1Gb bandwidth helps is on a local network. However, when sending data across the internet, you are always limited by your internet connection bandwidth. It's like driving a Corvette on a straight highway, but with a state police cruiser right behind you. You want to speed, but you can't. So, my guess is that if they only have 10Mb, or less, of bandwidth allocated to your account, you should be fine with a 10Mb connection. My guess is that you are not moving a lot of data between servers in their LAN, so it's not an issue. Now, however, I think they are bullsh*tting you about dropping to 10Mb to keep people from going over their bandwidth usage. That is the wrong way to do that. They should limit you using a throttle or shaper, but not by cutting your network speed. Regardless, as I mentioned earlier, if your available bandwidth is 10Mb or less, then they haven't gained anything. On the other hand, you haven't lost anything, either. M!ke -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 November 2006 21:19 To: CF-Talk Subject: Network speed I have been with a particular CF hosting company for a number of years. Recently I sent them two machines for co-location. The first, which I sent months ago, is connected to the Internet at 100Mbps. The second, which I sent days ago, is connected at 10Mbps. They told me there was a policy change because they didn't want people going to far over their bandwidth limit for the month. They also told me that there should be no visible difference for my CF applications doing work on the Internet. 1) Maybe I don't understand this but I don't see the relationship between the network connection speed and the total bandwidth usage in a month, only that if you have a higher network speed, you have the potential of using the bandwidth at a greater rate. Is that right? 2) Developers have told me that the CF applications on the new server seem to do work on the Internet more slowly. Could this be the case or are we just imagining this? Is there anyway to test this difference in speed? I did some tests using the CNET bandwidth measurement, but besides that I'm not sure how to test it to show them that there is a difference in speed. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using CFHTTP to login
Thx Claude, here is what I have been trying 1- Delete all Fire fox cookies 2- Go to http://localhost/SingleLogin/login.cfm (which is the login form) 3- View Cookies: There is a cookie has been written by CF with CFID, CFTOKEN, JSESSIONID. Note: No cookie from ASP.net 4- Click Submit Result: Is redirected to member home page: successful 5- View cookie: There are cookies .ASPXAUTH=59EDCFD5BF... and ASP.NET_SessionId=yynrg545cibzz4554zrsfh45 6- Logout 7- View cookie: There is only ASP.NET_SessionId=yynrg545cibzz4554zrsfh45, the .ASPXAUTH has been expired and doesn't exist. Is there anything you think of? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, 5 November 2006 3:04 AM To: CF-Talk Subject: Re: Using CFHTTP to login Yes, but you are doing it from your browser. Another try: When you call the login action from your CF login form, the request is actually sent by your browser. Then, if may have some cookie in it set previously by the server, it will recognize it and the login is accepted. When calling from CFHTTP, you don't have these cookies, and the login fails. Now, can you try again your CF login form just after having erased all your cookies. If some check cookie was set initially by the normal login form, your CF form should fail now. Then you know what you have to look for. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using CFHTTP to login
2- Go to http://localhost/SingleLogin/login.cfm (which is the login form) 3- View Cookies: There is a cookie has been written by CF with CFID, No, you must check with the original login form on the .NET application. The CF template you've made does not set any cookie (except the one set by CF). The idea is the check if the ORIGINAL login form in the .NET application sets a cookie, because this is the one you must fake when you simulate the login form by CFHTTP. The thing that is weird is that, with cookies disabled, the login action will fail. The question then is how does the login action know that cookies are disabled? The only way I have in mind is that the action will verify the presence of a cookie set by the form. There is also a Javascript property cookieEnabled that the system can also check. You told me that the login fails when cookies are disabled, but what if they are enabled, but Javascript is disabled ? Finally, is there an address (and some code + password) I could use to test the real application by myself? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using CFHTTP to login
You know in the amount if time it is taking to debug a your single sign in, and you haven't even touched the SP side of things yet. You would have been better of looking at ADS (Active Directory Services) or apaches equivalant. Or even look at a 3rd part solution where they deal in this all the time. All your headache so far is one way. Of course I am assuming that the asp.net application is yours to login into, if it isn;t then you better check with the onwer of the website to make sure you are not breaking any of their conditions to the website. On 11/5/06, Claude Schneegans [EMAIL PROTECTED] wrote: 2- Go to http://localhost/SingleLogin/login.cfm (which is the login form) 3- View Cookies: There is a cookie has been written by CF with CFID, No, you must check with the original login form on the .NET application. The CF template you've made does not set any cookie (except the one set by CF). The idea is the check if the ORIGINAL login form in the .NET application sets a cookie, because this is the one you must fake when you simulate the login form by CFHTTP. The thing that is weird is that, with cookies disabled, the login action will fail. The question then is how does the login action know that cookies are disabled? The only way I have in mind is that the action will verify the presence of a cookie set by the form. There is also a Javascript property cookieEnabled that the system can also check. You told me that the login fails when cookies are disabled, but what if they are enabled, but Javascript is disabled ? Finally, is there an address (and some code + password) I could use to test the real application by myself? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Saving a non en_US locale date to MSAccess
And do not forget to set locale into your locale before using LS* functions. CFMX 7 cfset temp = SetLocale(it_IT) For old CFs cfset temp = SetLocale(Italian (Standard)) Dave Watts wrote: Couldn't find any LS function to restore it to local date format. Am I wrong? LSDateFormat? Is there a less cumbersome way to do it? LSParseDateTime? OÄuz Demirkapı TeraTech Inc. | Senior Developer 405 East Gude Dr Suite 207, Rockville, MD 20850, USA Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185 Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~~~ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259190 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 imagesize
The bottom line is that you can greatly improve the end user experience with javascript. A little goes a long way, and as long as you test on IE6+ and FF 1+ you have most users covered. You need to gracefully fall back in case the user doesn't have it enabled though. I had no idea how many folks have it turned off until I started my current job working on a public facing site. Plus, sometimes it seems to blocked at the LAN level so adjusting their browser settings has no effect. Now I have a noscript warning in the header that lets them know that their javascript is disabled and many useful features of the site won't work because they don't have javascript enabled. -- Josh - Original Message - From: Claude Schneegans [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, November 01, 2006 12:02 PM Subject: Re: Get imagesize but because of the lack of control that we as web developers have over the client configuration. In my case, I don't rely on JS for anything important on the public site. For the admin part, I have test for cookies enabled, JS enabled and anti-popup disabled. A user is not allowed in with a crippled Browser. And they all comply with no problem. The only cases I had with users not complying was only because they didn't know some tool was disabled in their 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. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259191 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 - CSS Float Image Bottom Right corner of DIV
On 11/1/06, Josh Nathanson [EMAIL PROTECTED] wrote: Caveat: It's not a true float as you have to fix the width of the outer table. But, if you can do that you can achieve the desired effect. Not sure if this is easier than doing the same thing with a div or not. Another little cheat, but not sure if it would work in your case: div id=container style=width: 200px; height: 300px; div id=right style=float: right; padding-top: 270px; img src=foo.bar height=50 widht=50 alt=foo / /div div id=left Your Text /div /div Obviously, you would need to have an idea of the height of the container, or a relative idea of the height of the left div. It should still float right and wrap around the image at the padding that you specify, if i am not mistaken. jc ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: coldfusion forum application
OÄuz Demirkapı wrote: I know Ray does not have enough time to make it multi language enabled but you can do it easily by using PaulH's ResourceBundle CFC. http://www.sustainablegis.com/unicode/resourceBundle/javaRB.cfm OÄuz already knows this but it's worth pointing out again that just translating text isn't enough. you need to consider date/number/currency formatting (thankfully cf7 handles a huge number of locales), even calendars (the gregorian calendar isn't the only one in the world) if the locales you need to support require it, as well as collation, writing system directionality, etc. and of course you need to just use unicode which cf makes a breeze these days. I don't believe any of the other cf forum apps have multilingual support either. boardfusion will eventually. www.boardfusion.org building language independent code is a PITA, makes it hard to read the code if you ask me. i disagree w/rick too (of course ;-). it's no harder to read than anything else. but more to the point, the days of ignoring the rest of the world or making them work the way we do is long past. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion forum application
Hi Paul, Good to hear you again. :) Paul Hastings wrote: OÄuz Demirkapı wrote: I know Ray does not have enough time to make it multi language enabled but you can do it easily by using PaulH's ResourceBundle CFC. http://www.sustainablegis.com/unicode/resourceBundle/javaRB.cfm OÄuz already knows this but it's worth pointing out again that just translating text isn't enough. you need to consider date/number/currency formatting (thankfully cf7 handles a huge number of locales), even calendars (the gregorian calendar isn't the only one in the world) if the locales you need to support require it, as well as collation, writing system directionality, etc. and of course you need to just use unicode which cf makes a breeze these days. Yes I know it needs lots of work to create a fully i18N supported application but if you just need forum application in a different language, i think it is not so complicated to convert it into your target language. We have also discussed with Ray long time ago. I have suggested to use same method like in BlogCFC but he mentioned that he did not have any time at that time and there was is not a huge amount of request for this process. I don't believe any of the other cf forum apps have multilingual support either. boardfusion will eventually. www.boardfusion.org I also created a forum application 4 years ago but after that time I could not find a chance to make it a product. You can see working copy of it via http://motorspor.com/index.cfm?fuseaction=forum.home It was designed for CF 5 (there was no CFMX) but converted CFMX later. It is a Fusebox 3 based application. building language independent code is a PITA, makes it hard to read the code if you ask me. i disagree w/rick too (of course ;-). it's no harder to read than anything else. but more to the point, the days of ignoring the rest of the world or making them work the way we do is long past. I was just discussing this week with one of my coworker about CFStudio/Homesite usage. I pleased not using these applications which create trouble for my Unicode pages. I am also explaining every day and every day, why we need to use Unicode as a standard. :) I am planning also to prepare a full day class at next CFUnited about i10n i18N and best practices. OÄuz Demirkapı TeraTech Inc. | Senior Developer 405 East Gude Dr Suite 207, Rockville, MD 20850, USA Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185 Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~~~ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Saving a non en_US locale date to MSAccess
Thank you Dave. How embarassing. I thought I have tried LSParseDateTime and didn't works. It works perfectly. RTFM to me. Thanks again. ContiW Couldn't find any LS function to restore it to local date format. Am I wrong? LSDateFormat? LSParseDateTime? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Network speed
Jim Miller wrote: 1) Maybe I don't understand this but I don't see the relationship between the network connection speed and the total bandwidth usage in a month, only that if you have a higher network speed, you have the potential of using the bandwidth at a greater rate. Is that right? That is correct. But what you have to factor in is that most likely the upstream of your hoster is chaging your hoster based at the 95th percentile of his use. So for him, configuring his customers at 10 Mbps instead of 100 Mbps can be a real money safer. 2) Developers have told me that the CF applications on the new server seem to do work on the Internet more slowly. Could this be the case or are we just imagining this? Is there anyway to test this difference in speed? Iperf Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Network speed
Dawson, Michael wrote: The only time that 100Mb or 1Gb bandwidth helps is on a local network. However, when sending data across the internet, you are always limited by your internet connection bandwidth. You think so? As far as I can tell, when I am talking to your servers, the slowest part is the 24 Mbps of your servers, not the 100 Mbps of my desktop. When you get colo, make sure you get a picture of the layout of your hosters network, including mrtg graphs of the bandwidth utilization on the relevant upstreams. It takes the guessing out of the game. Now, however, I think they are bullsh*tting you about dropping to 10Mb to keep people from going over their bandwidth usage. That is the wrong way to do that. They should limit you using a throttle or shaper, but not by cutting your network speed. And what exactly is the difference between a port configured at 10 Mbps and a port shaped at 10% of 100 Mbps? Except that the latter will have packetloss on UDP because shaping on UDP is a no-go? Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using CFCHART to generate batch charts?
Does anyone know if there is a way to use CFCHART on CFMX to generate a set of chart JPEGs and save them to disk? The idea would be to generate 1000 charts in this manner once a week. This way, simple IMG tags can then be used to link to the charts, and the data gathering / CFCHART engine can be entirely bypassed for that week. There doesn't appear to be a documented way to do this, but perhaps someone has worked out how to... Regards, Terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Second Server
Should I just move over the DB or would I be better off Load balancing across the two boxes? Or is the something else you'd recommend? Make sure that you also take into consideration how much you care about maintenance / administration time. IMO it's often worth paying a little more for a couple of larger boxes than an army of cheaper ones just so that you can save time keeping them in order. All depends on what your priorities are, and what you expect your future traffic growth to be. If you're getting any sort of load, get that db off the CF box. It's like night and day. I just upgraded my CF setup from a single dual Xeon to a pair of Opterons, 1 acting as a mysql server, the other for httpd/cfmx. Stick a switch between them, and watch in amazement. My experience is that you'll tend to be disk/IO bound if you're running your DB on a busy CFMX server. Fast disks might help, but giving the DB a new home is going to be worth it. If your db server is light loaded, you can pile other tasks on it like sendmail, backups, etc and take even more pressure off the CF server. Personally I wouldn't consider load balancing at all until a 3rd server was required, unless failover is important to you. Of course, if availability is critical then your requirements will vary, in which case you're going to want failover of both cf and the db. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
help with some cfe and adobe rds genereated code
alrightt
There are all these cfc generators for the cfc, bean gateways but have no
idea how to interact with them. (thats the basic question here..)
trying to learn my way into doing cfcs better and right now im trying the rds
cfc generated code in eclipse. Starting with the active record one.
I'm also trying to learn cfscript a bit but am kinda lost on how you call the
cfc this way to do the usual crud stuff. I can get it partially functioning on
the inserts (if you dont count any data going in!! haha but the rows are being
made). Im sure I can get it but id rather see some of the better practices.
what would my main starting points be?
if my cfc is:
cfcomponent output=false alias=components.test1.test
!---
These are properties that are exposed by this CFC object.
These property definitions are used when calling this CFC as a
web services,
passed back to a flash movie, or when generating documentation
NOTE: these cfproperty tags do not set any default property
values.
---
cfproperty name=id type=numeric default=0
cfproperty name=theName type=string default=
cfproperty name=theEmail type=string default=
cfscript
//Initialize the CFC with the default properties values.
variables.id = 0;
variables.theName = ;
variables.theEmail = ;
/cfscript
cffunction name=init output=false returntype=test
cfargument name=id required=false
cfscript
if( structKeyExists(arguments, id) )
{
load(arguments.id);
}
return this;
/cfscript
/cffunction
cffunction name=getId output=false access=public
returntype=any
cfreturn variables.Id
/cffunction
cffunction name=setId output=false access=public
returntype=void
cfargument name=val required=true
cfif (IsNumeric(arguments.val)) OR (arguments.val EQ )
cfset variables.Id = arguments.val
cfelse
cfthrow message='#arguments.val#' is not a valid
numeric/
/cfif
/cffunction
cffunction name=getTheName output=false access=public
returntype=any
cfreturn variables.TheName
/cffunction
cffunction name=setTheName output=false access=public
returntype=void
cfargument name=val required=true
cfset variables.TheName = arguments.val
/cffunction
cffunction name=getTheEmail output=false access=public
returntype=any
cfreturn variables.TheEmail
/cffunction
cffunction name=setTheEmail output=false access=public
returntype=void
cfargument name=val required=true
cfset variables.TheEmail = arguments.val
/cffunction
cffunction name=save output=false access=public
returntype=void
cfscript
if(getid() eq 0)
{
create();
}else{
update();
}
/cfscript
/cffunction
cffunction name=load output=false access=public
returntype=void
cfargument name=id required=true
cfset var qRead=
cfquery name=qRead datasource=ddd
select id, theName, theEmail
from test
where id = cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#arguments.id# /
/cfquery
cfscript
setid(qRead.id);
settheName(qRead.theName);
settheEmail(qRead.theEmail);
/cfscript
/cffunction
cffunction name=create output=false access=private
returntype=void
cfset var qCreate=
cfset var local1=gettheName()
cfset var local2=gettheEmail()
cftransaction isolation=read_committed
cfquery name=qCreate datasource=d
insert into test(theName, theEmail)
values (
cfqueryparam value=#local1#
cfsqltype=CF_SQL_VARCHAR /,
cfqueryparam value=#local2#
cfsqltype=CF_SQL_VARCHAR /
)
/cfquery
!--- If your server has a better way to get the ID
that is more reliable, use that instead ---
cfquery name=qGetID datasource=dd
