Re: columnlist value
I can't use mysqldump as client wants an interface to select the tables. I tried with the following code: cfloop list=#selec.columnlist# index=columnname #selec[columnname][currentRow]# /cfloop but this will display one column name at a time, but i need to write something like this Insert into table values (#id#,#name#) any help would be appreciated You'll need something like this: cfloop list=#selec.columnlist# index=field #selec[columnList][currentRow]# /cfloop Though I'd recommend you use a dump/import rather than a SELECT/INSERT mechanism to do it. Be a lot faster, and probably easier on your brain. MySQL has a very nice 'mysqldump' utility that'll output your data in raw format that is customizable up the wazoo, and then you can just import that into SQL Server directly. cheers, barneyb On 9/25/05, simmyana a [EMAIL PROTECTED] wrote: -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219218 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
comparing dates
Hello, I have to create a appliaction with time based visibility. So I have a start date and end date for the period in which the article should be visible. How can I check, if the actual sysdate is between the start and end date or out of this range? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219219 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: comparing dates
Hello, I have to create a appliaction with time based visibility. So I have a start date and end date for the period in which the article should be visible. How can I check, if the actual sysdate is between the start and end date or out of this range? I forgot, the Date is stored in this format at the database: Sep 15 2005 12:00AM Sep 28 2005 12:00AM ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219220 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: comparing dates
I would limit your query to only applications that fall within the date range for currently active apps. That would probably be your best option as it would eliminate having to check the data on the app side. What database are you using? If you must do it in CF, check out the DateCompare function... Jeff -Original Message- From: Alexander Diedler [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:11 AM To: CF-Talk Subject: Re: comparing dates Hello, I have to create a appliaction with time based visibility. So I have a start date and end date for the period in which the article should be visible. How can I check, if the actual sysdate is between the start and end date or out of this range? I forgot, the Date is stored in this format at the database: Sep 15 2005 12:00AM Sep 28 2005 12:00AM ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219221 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: hit tracking service
DeepMetrix has all the eye candy anyone could need... it's exactly what you want. Kevin Thank you Kevin, that does look rather promising. /t ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219222 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: comparing dates
In SQL it would be SELECT * FROM yourTable WHERE yourDate BETWEEN startDateColumn AND endDateColumn In CF it would be cfif dateCompare( date1, date2 ) EQ 1 date 1 is greater thandate 2 Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development -Original Message- From: DIEDLER Alexander [mailto:[EMAIL PROTECTED] Sent: Monday, 26 September 2005 4:59 PM To: CF-Talk Subject: comparing dates Hello, I have to create a appliaction with time based visibility. So I have a start date and end date for the period in which the article should be visible. How can I check, if the actual sysdate is between the start and end date or out of this range? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 : New Features Survey
A more work safe analogy couldn't have been used? I mean really. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 1:57 PM To: CF-Talk Subject: Re: ColdFusion MX 7 : New Features Survey I agree its written in such a way as to provide skewed results. This is going OT (please CF_comunity paranoids abstain...;-), but I remember a survey I had to compile when I was working in the Computer Center at university. snip ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Weird Encrypt/Decrypt problem!
Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219225 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
From: Andy Mcshane [mailto:[EMAIL PROTECTED] This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? Check to ensure that the length of the column in your database is large enough to hold the encrypted string since the length of the encrypted string does not always equal the length of the original string. HTH, Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
Checked that, both the variable in my stored procedure and the column in my DB table are set to nvarchar(100). I did originally think that this may be it but when I tried different length strings, strings that were longer shorter than 10 characters worked fine, that is what is so weird. If you use my example data you can easily replicate the issue. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 26 September 2005 12:57 To: CF-Talk Subject: RE: Weird Encrypt/Decrypt problem! From: Andy Mcshane [mailto:[EMAIL PROTECTED] This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? Check to ensure that the length of the column in your database is large enough to hold the encrypted string since the length of the encrypted string does not always equal the length of the original string. HTH, Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Multiple ColdFusion WARs or EARs
I have a question about configuring multiple ColdFusion Applications within the same JRun Instance. I have read plenty of information about setting up multiple instances of JRun/ColdFusion, but I recently discovered that I could configure/install multiple ColdFusion WARs within one JRun Instances. There are several reasons why I would consider doing this and maybe someone on the list could help verify my intuitions. Benefits: 1. Conserve memory by using only one JVM instead of several 2. Sandboxing is inherent since each application contains its own ColdFusion Administrator. Disadvantages: 1. All ColdFusion Applications are sharing the same JVM and one application could affect the performance of another application. Also what would be the benefit of configuring multiple ColdFusion EARs within one JRun instance? I would appreciate other comments or suggestions. Thanks, Troy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: View source
On Sunday 25 September 2005 23:55, Marlon Moyer wrote: yep, if ms designed cars, in order to check under the hood, you'd need to recline the passenger seat. I was fixing someones PC at the weekend, and IE had default to a gig of cache ! -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SPAM-LOW: Re: SPAM-LOW: Re: RSS Parser
True but then I'll bet somebody's got an XSL sheet somewhere that simply converts the various formats to a single consistent format and you could just run the feeds through that and then parse them with CF. At least -- if it'd been something I had to deal with routinely, that's exactly what I would have created... I hope I'm not the only one. That'd be included in another text format, but anyway. Wouldn't be a very nice way to do it though, because chances are good that if you're going to store the feed data in a DB for later use, you'll probably want to do some processing to it. Might be parsing dates and adjusting the time zone, maybe stripping HTML to plain text, or maybe something totally different. Nothing that can't be done with XSL, undoubtedly, but CF is a hell of a lot easier to use. ;) cheers, barneyb On 9/25/05, s. isaac dealey [EMAIL PROTECTED] wrote: That's not true either... because SQL queries are text, you could create (or modify) an XSL sheet that formats the information to insert it into a database. XSL'll only help you if you want to format the RSS in another text format, not if you want to rip it out for some other purpose (store in DB, or whatever). cheers, barneyb s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: String Search!!!!
Ok to be a bit more specific I have a of titles that have one similarity they contain similar words like Similar Words Found, Or Words Found. The names are written out in the following format: John Doe Similar Words Found Jane Similar Words Found Alex Words Found I would like to search through the text for any of the words matching Similar or Words or Found and return only the name for example: John Doe Similar Words Found = John Doe (the search would stop at Similar since it is the first word matching the criteria) Jane Similar Words Found = Jane (the search would stop at Similar since it is the first word matching the criteria) Alex Words Found = Alex (the search would stop at Words since it is the first word matching the criteria) Thanks Al -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 2:27 PM To: CF-Talk Subject: RE: String Search You said you needed to find the first instance of a space in a string, but your example showed finding the 3rd instance of a string. Which is it? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Aldon [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 1:22 PM To: CF-Talk Subject: RE: String Search The string is dynamic so the value changes! -Original Message- From: Aldon Moore [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 2:16 PM To: CF-Talk Subject: String Search How do I search a string for the first space between characters? This should be so easy converted to This should ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: weird cfdocument issues
Another issue is that cfdocument is executing incredibly slow (no queries, just html). I've been going back and forth with my internet host, but they can't seem to fix it either. Anyone run into this? Hey guys, I have two problems with the following application. http://www.ionizedesign.com/sysmex/test_card.cfm If you enter a name with a descender (try John King), the g gets cut off. Also, it's creating two pages for some reason. I've tried all manner of combinations with the margins but it still creates two pages. Any ideas? Thanks Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Weird Encrypt/Decrypt problem!
Whoa. So weird I also tested here, and the encoded johnmurray was decoded to johnmurrax! It's not with all 10 charcs. string, by the way. I think this is a CF default algorithm (CFMX_COMPAT, which is compatible do earlier versions of CF) implementation bug. You should use a more secure and standard algorithm, like TripleDES. Check out the Encrypt() documentation. -- Fabio Terracini Andy Mcshane wrote: Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Help with cfselect
Good Morning, I am having trouble with the selected attribute of the cfselect tag. I am trying to get it to display what is currently in the table if there is a value already there or select one if there currently is no value. I started out with the select tag, but it doesn't seem to have a similar attribute. So, I tried the cfselect. It is working as I need, except the existing value is not selected. Any help would be appreciated. Thanks, Mark Here is the code on my page: cfquery name=areaPaints datasource=mdfinish SELECT AreaId, AreaName, WallPaint, TrimPaint, CeilingPaint FROM Areas WHERE areas.JobId = #session.JobId# /cfquery cfquery name=paintList datasource=mdfinish SELECT JobPaintList.color, JobPaintList.JobPaintListId, JobPaintList.CustomColorName, PaintColor.ColorName, PaintColor.colorNumber, JobPaintList.line, JobPaintList.sheen, JobPaintList.manufacturer, PaintLines.PaintLineName, PaintSheen.PaintSheen FROM PaintSheen INNER JOIN (PaintLines INNER JOIN (PaintColor INNER JOIN JobPaintList ON PaintColor.ID = JobPaintList.color) ON PaintLines.PaintLineId = JobPaintList.line) ON PaintSheen.PaintSheenId = JobPaintList.sheen WHERE JobPaintList.job = #session.jobId# /cfquery cfmodule template=#Request.layout#/Header.cfm pageType=JobAdmin cfset i=1 cfform name=setcolor action=paintScheduleSetColorsAction.cfm table width=100% tr thArea Name/th thWall Paint/th thCeiling Paint/th thTrim Paint/th /tr cfoutput cfloop query=areaPaints trcfset i = i + 1 td#areaName#/td td cfselect name=wallPaint#i# option value=Select One/option cfloop query=paintList option value=#JobPaintListId##PaintList.colorName#, #Paintlist.ColorNumber# #PaintList.PaintLineName# #PaintList.PaintSheen# #PaintList.CustomColorName#/option /cfloop /cfselect /td td cfselect name=ceilingPaint#i# selected=#areaPaints.ceilingPaint# option value=Select One/option cfloop query=paintList option value=#JobPaintListId##PaintList.colorName#, #Paintlist.ColorNumber# #PaintList.PaintLineName# #PaintList.PaintSheen# #PaintList.CustomColorName#/option /cfloop /cfselectnbsp;/td td cfselect name=trimPaint#i# option value=Select One/option cfloop query=paintList option value=#JobPaintListId##PaintList.colorName#, #Paintlist.ColorNumber# #PaintList.PaintLineName# #PaintList.PaintSheen# #PaintList.CustomColorName#/option /cfloop /cfselectnbsp;/td /tr /cfloop /cfoutput tr td /tr /table button type=submitsubmit/button /cfform cfmodule template=#Request.layout#/Footer.cfmcfmodule template=#Request.layout#/Footer.cfm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
I am glad at least that somebody else has managed to replicate it and I am not going mad! Probably just my luck that it only affected the 10 character strings that I tried. I will have to look into a more robust encryption method. -Original Message- From: Fabio Terracini [mailto:[EMAIL PROTECTED] Sent: 26 September 2005 14:45 To: CF-Talk Subject: Re: Weird Encrypt/Decrypt problem! Whoa. So weird I also tested here, and the encoded johnmurray was decoded to johnmurrax! It's not with all 10 charcs. string, by the way. I think this is a CF default algorithm (CFMX_COMPAT, which is compatible do earlier versions of CF) implementation bug. You should use a more secure and standard algorithm, like TripleDES. Check out the Encrypt() documentation. -- Fabio Terracini Andy Mcshane wrote: Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: String Search!!!!
Hi Al, You could use the replace function to replace the words you do not require with an empty string. cfset newstring = replace(oldstring,Similar,ALL) you may need to drop this into a loop and repeat for all the words to be removed. can use trim(newstring) to remove any trailing spaces. MikeT On 9/26/05, Aldon [EMAIL PROTECTED] wrote: Ok to be a bit more specific I have a of titles that have one similarity they contain similar words like Similar Words Found, Or Words Found. The names are written out in the following format: John Doe Similar Words Found Jane Similar Words Found Alex Words Found I would like to search through the text for any of the words matching Similar or Words or Found and return only the name for example: John Doe Similar Words Found = John Doe (the search would stop at Similar since it is the first word matching the criteria) Jane Similar Words Found = Jane (the search would stop at Similar since it is the first word matching the criteria) Alex Words Found = Alex (the search would stop at Words since it is the first word matching the criteria) Thanks Al ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: String Search!!!!
sorry should be replace(oldstring,Similar,,ALL) On 9/26/05, Michael Traher [EMAIL PROTECTED] wrote: Hi Al, You could use the replace function to replace the words you do not require with an empty string. cfset newstring = replace(oldstring,Similar,ALL) you may need to drop this into a loop and repeat for all the words to be removed. can use trim(newstring) to remove any trailing spaces. MikeT On 9/26/05, Aldon [EMAIL PROTECTED] wrote: Ok to be a bit more specific I have a of titles that have one similarity they contain similar words like Similar Words Found, Or Words Found. The names are written out in the following format: John Doe Similar Words Found Jane Similar Words Found Alex Words Found I would like to search through the text for any of the words matching Similar or Words or Found and return only the name for example: John Doe Similar Words Found = John Doe (the search would stop at Similar since it is the first word matching the criteria) Jane Similar Words Found = Jane (the search would stop at Similar since it is the first word matching the criteria) Alex Words Found = Alex (the search would stop at Words since it is the first word matching the criteria) Thanks Al ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
javascript timer countdown...
I've got a custom CMS codebase that I'm always looking to improve. A client of mine is having some issues with getting logged out at what appears to be irregular intervals. So I suggested to her that she keep note of how long she had been logged in so that we could determine if there's a pattern. Anyway, that led me to think that it would be nice if I provided a countdown to the time I have set in my application tag (30 minutes I think). When zero is reached, it would fire off a function which would return the user to the login page (which logs them out). Does anyone have something like this and would be willing to share? Or better yet, does anyone have a better idea of how to accomplish this? Thanks in advance. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
green and seemingly brain dead, please help
Hey there, In the body of a cfloop, this works: cfif isdefined (form.ceilingpaint#i#). Do I need to use the evaluate function to get the value of that same variable for use in an update query? What is the correct way to write the cfquery below. Thank you very much. Mark cfloop index=i from=1 to=#paintListRecordCount# cfif isdefined (form.ceilingpaint#i#) ceiling #i# is defined br cfquery name=ceiling datasource=mdfinish UPDATE Areas SET CeilingPaint = #form.ceilingpaint + i# where areaId = #form.ceilingareaId + i# /cfquery /cfif /cfloop ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: find identical records
You can also do Select serialnumber From inventory Where serialnumber not in(select distinct serialnumber from inventory) I may have the syntax a little wrong, but look up the IN() syntax and do a subquery. Basically grabs a distinct listing of serial numbers and then grabs all rows that are not in that distinct list. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 2:27 PM To: CF-Talk Subject: Re: find identical records SELECT serialnumber, count(*) AS rowCount FROM inventory GROUP BY serialnumber HAVING rowCount 1 That should give you a list of serials that exist more than once, along with how many instances there are. And update your AVG, it says it's out of date. cheers, barneyb On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote: I know this one must be easy, but I'm not a guru w/SQL yet. How do I construct an SQL query that will list all records that have an identical field? For example, listing all records that contain an identical number in the serialnumber column. I did: Select distinct serialnumber from inventory order by serialnumber asc to get the unique records. Robert O. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
source control setup
Tried posting this on Friday, but it never seemed to have made it through: We're already using subversion pretty successfully on our servers, but the way we're using it, we're running into a few problems. We have a dev server, which has the production tree checked out, with development changes made straight on the server through ftp. Once the code is ready to be deployed, it gets committed to the repository, and then the svn update is run on the production server (which also has the production tree checked out). Now, if there is some code that is worked on for a long time, or never gets approved to be deployed, then we have code sitting on development for a long time and never being in source control. Sometimes ftp will screw up and overwrite the file, and all the changes get lost. I heard that it's possible to set up svn with webdav through apache. Is it possible to have a set up where we are editing files through webdav or something, and every time we save it gets saved to the development branch or repository and also gets updated in the file system? Then once we're ready to deploy, we would commit it to the production repository as usual. Also what editors support webdav? Homesite doesn't seem to support it, and I've been using CFEclipse lately, which is a little buggy with the ftp support, but I'm assuming there is a webdav plugin for it somewhere. Is it possible to set it up through windows somehow? I read something about web folders, but have not been able to figure out how to set it up in XP Pro. Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: green and seemingly brain dead, please help
Nope, try: FORM[ceilingPaint i] -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: 26 September 2005 16:20 To: CF-Talk Subject: green and seemingly brain dead, please help Hey there, In the body of a cfloop, this works: cfif isdefined (form.ceilingpaint#i#). Do I need to use the evaluate function to get the value of that same variable for use in an update query? What is the correct way to write the cfquery below. Thank you very much. Mark cfloop index=i from=1 to=#paintListRecordCount# cfif isdefined (form.ceilingpaint#i#) ceiling #i# is defined br cfquery name=ceiling datasource=mdfinish UPDATE Areas SET CeilingPaint = #form.ceilingpaint + i# where areaId = #form.ceilingareaId + i# /cfquery /cfif /cfloop ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: green and seemingly brain dead, please help
Try this... cfloop index=i from=1 to=#paintListRecordCount# cfif isdefined (form.ceilingpaint#i#) ceiling #i# is defined br cfquery name=ceiling datasource=mdfinish UPDATE Areas SET CeilingPaint = #form[ceilingpaint i]# where areaId = #form[ceilingareaId i]# /cfquery /cfif /cfloop ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:20 AM To: CF-Talk Subject: green and seemingly brain dead, please help Hey there, In the body of a cfloop, this works: cfif isdefined (form.ceilingpaint#i#). Do I need to use the evaluate function to get the value of that same variable for use in an update query? What is the correct way to write the cfquery below. Thank you very much. Mark cfloop index=i from=1 to=#paintListRecordCount# cfif isdefined (form.ceilingpaint#i#) ceiling #i# is defined br cfquery name=ceiling datasource=mdfinish UPDATE Areas SET CeilingPaint = #form.ceilingpaint + i# where areaId = #form.ceilingareaId + i# /cfquery /cfif /cfloop ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: green and seemingly brain dead, please help
#form.ceilingpaint + i# should be #form[ceilingpaint i]# -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: green and seemingly brain dead, please help
Hey there, This seems to work, is it the best way? I read somewhere I should avoid the evaluate function. Thanks, Mark cfloop index=i from=1 to=#paintListRecordCount# cfif isdefined (form.ceilingpaint#i#) ceiling #i# is defined br cfquery name=ceiling datasource=mdfinish UPDATE Areas SET CeilingPaint = #evaluate(form.ceilingpaint#i#)# where areaId = #evaluate(form.ceilingAreaId#i#)# /cfquery /cfif /cfloop -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:20 AM To: CF-Talk Subject: green and seemingly brain dead, please help Hey there, In the body of a cfloop, this works: cfif isdefined (form.ceilingpaint#i#). Do I need to use the evaluate function to get the value of that same variable for use in an update query? What is the correct way to write the cfquery below. Thank you very much. Mark cfloop index=i from=1 to=#paintListRecordCount# cfif isdefined (form.ceilingpaint#i#) ceiling #i# is defined br cfquery name=ceiling datasource=mdfinish UPDATE Areas SET CeilingPaint = #form.ceilingpaint + i# where areaId = #form.ceilingareaId + i# /cfquery /cfif /cfloop ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: javascript timer countdown...
This is slightly different. It will timeout the session after 7 minutes of
inactivity.
var closeTimer = null;
var timeout = 420; // 7 minutes in seconds.
function onloadFunctions()
{
startTimer();
body = document.getElementsByTagName(body);
body[0].onmouseover = startTimer;
}
function startTimer()
{
if (closeTimer != null)
clearTimeout(closeTimer);
closeCounter = timeout;
closeTimer = setTimeout(closeWindow(), 1000);
}
function closeWindow()
{
closeCounter = closeCounter - 1
window.status = closeCounter;
if (closeCounter = 0)
window.location.replace(http://; + location.host +
/logoff.cfm);
else
closeTimer = setTimeout(closeWindow(), 1000);
}
window.onload = onloadFunctions;
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219247
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: green and seemingly brain dead, please help
Hey there, This seems to work, is it the best way? I read somewhere I should avoid the evaluate function. Thanks, Mark Yes, it works but it is not the best way. See previous three posts that suggest #form[ceilingpaint i]# -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: green and seemingly brain dead, please help
Thanks Guys, I changed it to #form[ceilingPaint i]#. Mark ps I have a really tired, over-burdened laptop, but on my laptop, it actually took a little longer this way than using evaluate. I thought I heard somewhere that evaluate was really slow. Is there another reason to avoid it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
iseries as400 question
Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt/Decrypt Suggestions (WAS Weird Encrypt/Decrypt problem!)
OK, follow up to this, can anybody suggest ways that they currently encrypt/decrypt sensitive data? I need to encrypt the data to save into the database and then at a later date retrieve that data, decrypt it and let the user edit it. I have looked at using the various algorithms excluding CFMX_COMPAT but I notice that uses the GenerateSecretKey function. I am assuming that the key that is generated is different every time therefore once I have encrypted the data, if I do not save the original key then when I come to decrypt the data it will use a different key and so fail? Or am I completely wrong here? Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: iseries as400 question
I've used it in the past but can't remember the specifics. Sorry. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: iseries as400 question
Well if you can't google it, have you tried sniffing the information? Either do netstat or put on ethereal or something while you're connected to the datasource... you'll see which port the packets are going to... -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: iseries as400 question
yeah, we tried that (or at least one of the db guys did) and he said he couldnt discern anything meaningful from it. But ill try that again, maybe he missed something. On 9/26/05, Russ [EMAIL PROTECTED] wrote: Well if you can't google it, have you tried sniffing the information? Either do netstat or put on ethereal or something while you're connected to the datasource... you'll see which port the packets are going to... -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: product name
-Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 24, 2005 1:01 PM To: CF-Talk Subject: RE: product name [snip] Personally I'd try to stick with your broader convention... so right now that means something onTap. Personally, I'm waiting for the Beer onTap application to come out. C'mon, Isaac! -- //SIGNED// Chris Montgomery, Contractor HQ AF Security Forces Center, Antiterrorism Branch 1517 Billy Mitchell Blvd, Bldg 954 Lackland AFB, TX 78236-0119 DSN 312.945.7150 Comm 210.925.7150 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: find identical records
You can also do Select serialnumber From inventory Where serialnumber not in(select distinct serialnumber from inventory) that will give you 0 records every time - the subquery select distinct serialnumber from inventory returns ALL the serialnumbers used, so you won't find any serialnumbers (in that table) that aren't in that set. /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: find identical records
Ahh, good point. I know I've done this before and I did something along the lines of grabbing the IDs in the subquery for all distinct serialnumbers and then in the outer query grab the serial numbers whose ids don't match the id list from the subquery. If someone wants to use that logic, they can figure out the syntax or I can try to dig up the code I used to do it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Tanguy Rademakers [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:19 PM To: CF-Talk Subject: Re: find identical records You can also do Select serialnumber From inventory Where serialnumber not in(select distinct serialnumber from inventory) that will give you 0 records every time - the subquery select distinct serialnumber from inventory returns ALL the serialnumbers used, so you won't find any serialnumbers (in that table) that aren't in that set. /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: iseries as400 question
Netstat -a should give you all the network connections that your computer has at this time... issue a long running query, and run netstat -a to see what connections you have to the db computer... that should give you the port # as well -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:04 PM To: CF-Talk Subject: Re: iseries as400 question yeah, we tried that (or at least one of the db guys did) and he said he couldnt discern anything meaningful from it. But ill try that again, maybe he missed something. On 9/26/05, Russ [EMAIL PROTECTED] wrote: Well if you can't google it, have you tried sniffing the information? Either do netstat or put on ethereal or something while you're connected to the datasource... you'll see which port the packets are going to... -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: iseries as400 question
There is a JDBC driver for the as400. We used to install Client Access Express on the servers, but I hated that. When I found the JDBC driver, I was delighted. I don't think the DB2 driver would have worked for us, but I was able to get the JDBC driver working quite quickly. If you are interested in that, I can send you the driver file(s) and what you need to enter in the CF administrator. M! -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 10:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: source control setup
If I understand you correctly, you've got each developer with a copy of the source on their workstation, and then they FTP it to the dev server? That's a bad way to do it; you should have a working copy per-developer, and keep them synchronized with svn, rather than using FTP (since as you say, you can easily overwrite stuff). If you overwrite something with svn, which is very difficult to do accidentally, you can always get it back, because everything is versioned. This will also alleviate the need to use webdav directly. Second, you need to check out branches. Branches let you do parallel development, so if someone needs to go off in some new direction, they can create a branch that doesn't interfere with anyone else (or the production code), and then when they're all done, the branch's changes can be merged back into the main line of development. The benefit is that while workin gon the branch, you can commit to the repository, so you won't ever lose anything. cheers, barneyb On 9/26/05, Russ [EMAIL PROTECTED] wrote: Tried posting this on Friday, but it never seemed to have made it through: We're already using subversion pretty successfully on our servers, but the way we're using it, we're running into a few problems. We have a dev server, which has the production tree checked out, with development changes made straight on the server through ftp. Once the code is ready to be deployed, it gets committed to the repository, and then the svn update is run on the production server (which also has the production tree checked out). Now, if there is some code that is worked on for a long time, or never gets approved to be deployed, then we have code sitting on development for a long time and never being in source control. Sometimes ftp will screw up and overwrite the file, and all the changes get lost. I heard that it's possible to set up svn with webdav through apache. Is it possible to have a set up where we are editing files through webdav or something, and every time we save it gets saved to the development branch or repository and also gets updated in the file system? Then once we're ready to deploy, we would commit it to the production repository as usual. Also what editors support webdav? Homesite doesn't seem to support it, and I've been using CFEclipse lately, which is a little buggy with the ftp support, but I'm assuming there is a webdav plugin for it somewhere. Is it possible to set it up through windows somehow? I read something about web folders, but have not been able to figure out how to set it up in XP Pro. Russ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt/Decrypt Suggestions (WAS Weird Encrypt/Decrypt problem!)
There is no bug in encrypt/decrypt, the problem is that in that instance, the encrypt result contains a space at the end. As you can see with the following code, the key is not *5)V%5*.Z59RR$, but *5)V%5*.Z59RR$ cfset foo = encrypt(johnmurray, wibble) CFOUTPUT[#htmlEditFormat(foo)#], #decrypt(foo, wibble)#, #decrypt(*5)V%5*.Z59RR$, wibble)# #decrypt(*5)V%5*.Z59RR$ , wibble)# /CFOUTPUT Then you have to make sure the value will not be trimmed at any step. I can also foresee some potential problem when the encrypted key contains quotes, single or double. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt/Decrypt Suggestions (WAS Weird Encrypt/Decrypt problem!)
Does your database itself provide encrypted storage? That'd certainly be easier if it does. On a different topic, executing the code you listed demonstrated the error with 'y' becoming 'x', but if the decrypt operation is changed to use the foo variable directly, the proper result is returned. The difference is that they encrypted string has a trailing space that you're truncating. So you're not actually decrypting the right encrypted value, which is why you're getting the invalid result. cheers, barneyb On 9/26/05, Andy Mcshane [EMAIL PROTECTED] wrote: OK, follow up to this, can anybody suggest ways that they currently encrypt/decrypt sensitive data? I need to encrypt the data to save into the database and then at a later date retrieve that data, decrypt it and let the user edit it. I have looked at using the various algorithms excluding CFMX_COMPAT but I notice that uses the GenerateSecretKey function. I am assuming that the key that is generated is different every time therefore once I have encrypted the data, if I do not save the original key then when I come to decrypt the data it will use a different key and so fail? Or am I completely wrong here? Hi all, I am trying to store specific data into a database in an encrypted format. This data also has to be decrypted so as to be displayed and edited onscreen therefore ruling out using the hash function. The problem that I am having is on the decrypt. Example: cfset foo = encrypt(johnmurray, wibble) foo then equals *5)V%5*.Z59RR$ I save this text to the database. An unusual thing happens when I try to decrypt this text as follows; cfset foo = decrypt(*5)V%5*.Z59RR$, wibble) foo then equals johnmurrax as you can see the 'y' has become an 'x'. Now here is the strange thing, cfset foo = encrypt(johnmurray , wibble) - with an extra space at the end of johnmurray everything encrypts/decrypts correctly using an 11 character string. also cfset foo = encrypt(johnmurra, wibble) - if I make it only 9 characters then this also encrypts/decrypts correctly. It seems to only happen with 10 letter strings? This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: source control setup
Not a direct answer, but having implemented source control here recently and considered all these matters, I would say your setup is not ideal. A better structure is to have developers working on their own workstations. Each PC/MAC is setup with its own web server and cf server running plus access to any dev databases. Each developer checksout a copy of the system they are working on and works on their assignment testing locally. They can do updates to see thier colleagues committed changes. Once they commit you can now checkout this code to a shared server for testing - I would rather call this the staging or test server. From here once tested you can deploy to live. This way you remove the ftp issue and take advantage of the SVN repository being the central copy of the code. Any code not checked in remains on the developers machine. You may want to consider using branches to cater for more major/longterm developments but that is a whole separate topic. We use CVS rather than SVN but the principles are the same i believe. MikeT On 9/26/05, Russ [EMAIL PROTECTED] wrote: Tried posting this on Friday, but it never seemed to have made it through: We're already using subversion pretty successfully on our servers, but the way we're using it, we're running into a few problems. We have a dev server, which has the production tree checked out, with development changes made straight on the server through ftp. Once the code is ready to be deployed, it gets committed to the repository, and then the svn update is run on the production server (which also has the production tree checked out). Now, if there is some code that is worked on for a long time, or never gets approved to be deployed, then we have code sitting on development for a long time and never being in source control. Sometimes ftp will screw up and overwrite the file, and all the changes get lost. I heard that it's possible to set up svn with webdav through apache. Is it possible to have a set up where we are editing files through webdav or something, and every time we save it gets saved to the development branch or repository and also gets updated in the file system? Then once we're ready to deploy, we would commit it to the production repository as usual. Also what editors support webdav? Homesite doesn't seem to support it, and I've been using CFEclipse lately, which is a little buggy with the ftp support, but I'm assuming there is a webdav plugin for it somewhere. Is it possible to set it up through windows somehow? I read something about web folders, but have not been able to figure out how to set it up in XP Pro. Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: iseries as400 question
We tried this and it came back with two port numbers. one local and one remote. We tried them both and neither worked :( On 9/26/05, Russ [EMAIL PROTECTED] wrote: Netstat -a should give you all the network connections that your computer has at this time... issue a long running query, and run netstat -a to see what connections you have to the db computer... that should give you the port # as well -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:04 PM To: CF-Talk Subject: Re: iseries as400 question yeah, we tried that (or at least one of the db guys did) and he said he couldnt discern anything meaningful from it. But ill try that again, maybe he missed something. On 9/26/05, Russ [EMAIL PROTECTED] wrote: Well if you can't google it, have you tried sniffing the information? Either do netstat or put on ethereal or something while you're connected to the datasource... you'll see which port the packets are going to... -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: iseries as400 question
Absolutely! That would be perfect Michael. On 9/26/05, Dawson, Michael [EMAIL PROTECTED] wrote: There is a JDBC driver for the as400. We used to install Client Access Express on the servers, but I hated that. When I found the JDBC driver, I was delighted. I don't think the DB2 driver would have worked for us, but I was able to get the JDBC driver working quite quickly. If you are interested in that, I can send you the driver file(s) and what you need to enter in the CF administrator. M! -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 10:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: product name
I'll drink to that ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Montgomery Chris Ctr AFSFC/SFPA [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:13 PM To: CF-Talk Subject: RE: product name -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 24, 2005 1:01 PM To: CF-Talk Subject: RE: product name [snip] Personally I'd try to stick with your broader convention... so right now that means something onTap. Personally, I'm waiting for the Beer onTap application to come out. C'mon, Isaac! -- //SIGNED// Chris Montgomery, Contractor HQ AF Security Forces Center, Antiterrorism Branch 1517 Billy Mitchell Blvd, Bldg 954 Lackland AFB, TX 78236-0119 DSN 312.945.7150 Comm 210.925.7150 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: javascript timer countdown...
Thanks for the post Ian, but that wasn't quite what I wanted. Here's the
full code if anyone cares for it. It's a bit of a kludge, but it does what I
want. Just drop the code into a js file and call it like so:
script language=JavaScript type=text/JavaScript
src=includes/countdown.js/script
--
var targetURL=index.cfm?logout
//time in seconds
var countDownInterval=1800;
var message=Logout in;
var countDownTime=countDownInterval+1;
function countDown(){
countDownTime--;
if (countDownTime =0){
countDownTime=countDownInterval;
clearTimeout(counter)
window.location=targetURL
return
}
if (document.all) //if IE 4+
document.all.countDownText.innerText =
secToMin(countDownTime)+ ;
else if (document.getElementById) //else if NS6+
document.getElementById(countDownText).innerHTML=secToMin(countDownTime)
+
else if (document.layers){ //TEXT FOR NS4.x
document.c_redirect.document.c_redirect2.document.write(message
+ ' b
id=countDownText'+secToMin(countDownTime)+' /b seconds')
document.c_redirect.document.c_redirect2.document.close()
}
counter=setTimeout(countDown(), 1000);
}
function startit(){
if (document.all||document.getElementById) { //TEXT FOR IE
document.write(message + ' b id=countDownText' +
secToMin(countDownTime) +' /b seconds');
countDown();
}
}
function secToMin (theseconds) {
var theTime = new String();
var minutes = Math.floor(countDownTime / 60)
var seconds = countDownTime % 60
theTime = minutes + Minutes + seconds;
return theTime;
}
if (document.all||document.getElementById)
startit()
else
window.onload=startit
--
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219267
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Weird Encrypt/Decrypt problem!
The pre CF7 encrypt() function does not create dbsafe strings. You have to toake it a further step for that: Wrap the string in toBase64() before you store the data. IIRC (its been awhile) you use tostring() when decrypting. I think the new algorithm options in cfencrypt()/cfdecrypt() could be enough features to upgrade right then and there. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt/Decrypt Suggestions (WAS Weird Encrypt/Decrypt problem!)
and that trailing space is being trimmed out by the db. Sooner or later you would have other issues even if you work around this one somehow. See my post on this in the other thread. Its an easy fix but you won't make the 'classic' CF algorithm any more secure. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion MX 7 : New Features Survey
Anyone esle find it interesting Macromedia ia asking about the .NET stuff...heh just found it funny Adam H On 9/26/05, Calvin Ward [EMAIL PROTECTED] wrote: A more work safe analogy couldn't have been used? I mean really. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 1:57 PM To: CF-Talk Subject: Re: ColdFusion MX 7 : New Features Survey I agree its written in such a way as to provide skewed results. This is going OT (please CF_comunity paranoids abstain...;-), but I remember a survey I had to compile when I was working in the Computer Center at university. snip ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 : New Features Survey
Yet the one question that I wanted .NET to appear in (what languages do you want CF to interoperate with) the only choices were PHP and Python! At least they provided an 'other' text box for write in votes. Mike -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:38 PM To: CF-Talk Subject: Re: ColdFusion MX 7 : New Features Survey Anyone esle find it interesting Macromedia ia asking about the .NET stuff...heh just found it funny Adam H On 9/26/05, Calvin Ward [EMAIL PROTECTED] wrote: A more work safe analogy couldn't have been used? I mean really. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 1:57 PM To: CF-Talk Subject: Re: ColdFusion MX 7 : New Features Survey I agree its written in such a way as to provide skewed results. This is going OT (please CF_comunity paranoids abstain...;-), but I remember a survey I had to compile when I was working in the Computer Center at university. snip ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Weird Encrypt/Decrypt problem!
Whoops its not tostring that takes something out of base64. Its decode(). I have a template that I built up years ago from the CF example that displays a bunch of different ways to skin this cat. You can pick it apart to bulletproof your use of CF encryption. CFSET variables.mystring=CreateUUID() CFSET variables.tempstring=CreateUUID() CODE HTMLHEADTITLEEncrypt Example/TITLE/HEADBODY H3Encrypt Example/H3 PThis function allows for the encryption and decryption of a string. Try it out by entering your own string and a key of your own choosing and seeing the results. CFIF isdefined (url.Action) CFSET string = FORM.myString CFSET key = FORM.myKey CFSET encrypted = encrypt(string, key) CFSET urlencrypted = URLEncodedFormat(encrypt(string, key)) CFSET base64encrypted = ToBase64(encrypt(string, key)) CFSET UrlBase64encrypted = URLEncodedFormat(base64encrypted) CFSET decrypted = decrypt(encrypted, key) CFSET urldecrypted = URLDecode(urlencrypted) CFSET urldecrypted = decrypt(urldecrypted, key) CFSET dbsafedecrypted = decrypt(tostring(tobinary(base64encrypted)),key) CFSET urldbsafedecrypted = URLDecode(urlbase64encrypted) CFSET urldbsafedecrypted = decrypt(tostring(tobinary(urldbsafedecrypted)),key) CFOUTPUT UL LIBThe string:/B #string#/LI LIBThe key:/B #key#/LI LIBEncrypted in normal format:/B #encrypted#/LI LIBEncrypted in URLEncodedFormat:/B #urlencrypted#/LI LIBEncrypted in Base64 format:/B #base64encrypted#/LI LIBEncrypted in UrlEncoded Base64 format:/B #urlbase64encrypted#/LI HR WIDTH=80% LIBDecrypted from normal format:/B #decrypted#/LI LIBDecrypted from UrlEncoded format:/B #urldecrypted#/LI LIBDecrypted from Base64 format:/B #dbsafedecrypted#/LI LIBDecrypted from UrlEncoded Base64 format:/B #urldbsafedecrypted#/LI /UL FORM ACTION=#cgi.script_name#?Action=1ssn=#urlbase64encrypted# METHOD=post Input your key:BR INPUT TYPE=Text NAME=myKey VALUE=#form.myKey# SIZE=40 PInput your string to be encrypted:BR textArea NAME=myString cols=40 rows=5 WRAP=VIRTUAL#form.myString#/textArea PHere's an html link with the base64 urlencoded string:BR textArea NAME=myLink cols=40 rows=5 WRAP=VIRTUALlt;A HREF=http://mydomain/mypage.cfm?ssn=#urlbase64encrypted#gt;Click Herelt;/Agt;/textAreaBR Here's another UUID: #variables.TempString# /CFOUTPUT CFELSE cfoutputFORM ACTION=#cgi.script_name#?Action=1 METHOD=post/cfoutput Input your key:BR INPUT TYPE=Text NAME=myKey SIZE=40 PInput your string to be encrypted (this is a UUID):BR textArea NAME=myString cols=40 rows=5 WRAP=VIRTUALCFOUTPUT#variables.MyString#/CFOUTPUT/textAreaBR Here's another UUID: CFOUTPUT#variables.TempString#/CFOUTPUT /CFIF BRINPUT TYPE=Submit VALUE=Encrypt my String /FORM/CODE/BODY/HTML ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
OR...I found a useful, hidden function in the guts of the cfadmin itself. The encrypt function returns JUST an alphanumeric string, instead of with punctuation and other chars. cfset string = coldfusion rules cfset seed = four score and seven years ago cfset encrypt = CFusion_Encrypt(string,seed) cfset decrypt = CFusion_Decrypt(encrypt,seed) cfoutput encrypt: #encrypt#br decrypt: #decrypt#br /cfoutput !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:30 PM To: CF-Talk Subject: Re: Weird Encrypt/Decrypt problem! The pre CF7 encrypt() function does not create dbsafe strings. You have to toake it a further step for that: Wrap the string in toBase64() before you store the data. IIRC (its been awhile) you use tostring() when decrypting. I think the new algorithm options in cfencrypt()/cfdecrypt() could be enough features to upgrade right then and there. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Weird Encrypt/Decrypt problem!
Those 'undocumented' functions have been documented for some time in various places, including houseoffusion.com. There has been plenty of discussion of them over the years. The trouble with them is they are not guaranteed to be there in future versions, and if they do remain their behavior is in no way guaranteed to stay the same. Better IMHO to work with the published language than to rely on stuff like this. Are they still in CFMX7 or were they finally removed? -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt/Decrypt Suggestions (WAS Weird Encrypt/Decrypt problem!)
There is no bug in encrypt/decrypt, the problem is that in that instance, the encrypt result contains a space at the end. Yeah. It's true. I totally missed that! No bug at all! :-) []s Fabio Terracini ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Weird Encrypt/Decrypt problem!
Its actually not a bug. The encrypted string that is generated is *5)V%5*.Z59RR$ with a space at the end. When you decrypt the string, if you use the same string it will work as it should. In your case, the string was trimmed and hence this behaviour. You can verify this using this code snippet. cfset foo = encrypt(johnmurray, wibble) cfset bar = decrypt(foo, wibble) cfoutputfoo is '#foo#'/cfoutput cfoutputbar is #bar#/cfoutput By default encrypt uses UU-encoding to encode the encrypted data. So to ensure that there is no trailing spaces, you should use Base-64 encoding. you can specify that in Encrypt/Decrypt function. Other solution is to base-64 encode the data you get after encrypt and persist. And when you retrieve it frm DB, base-64 decode and then pass it to decrypt. Thanks Rupesh. Whoa. So weird I also tested here, and the encoded johnmurray was decoded to johnmurrax! It's not with all 10 charcs. string, by the way. I think this is a CF default algorithm (CFMX_COMPAT, which is compatible do earlier versions of CF) implementation bug. You should use a more secure and standard algorithm, like TripleDES. Check out the Encrypt() documentation. -- Fabio Terracini Andy Mcshane wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Call cfscript inside cfc - its possible?
Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All)# What's wrong? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Call cfscript inside cfc - its possible?
You should be able to use any CF function inside a CFC. I think though that you might have it flipped around. Are you trying to use a custom function, which you have created, inside cfscript? If so, then as long as you've defined the function and instantiated it, you should be able to call it from anywhere on the page. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 2:41 PM To: CF-Talk Subject: Call cfscript inside cfc - its possible? Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All )# . What's wrong? Cheers MD ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Call cfscript inside cfc - its possible?
You don't have implicit access to the request's 'variables' scope inside a CFC instance. You'll need to move the UDF into a scope where the CFC internals can reference (request, application, etc.). Though I wouldn't recommend doing it that way. A better route would be to put your UDF in a 'utilities' CFC, and then use that CFC in both your current CFC and in your normal page processing. Better encapsulation that way. cheers, barneyb On 9/26/05, Michel Deloux [EMAIL PROTECTED] wrote: Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All)# What's wrong? Cheers MD -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Call cfscript inside cfc - its possible?
On 9/26/05, Michel Deloux [EMAIL PROTECTED] wrote: Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All)# What's wrong? There's really no such thing as a cfscript-only tag. In your case, using a cfset will handle the job: cfif arguments.UserField is not cfset myCleanedValue = REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All) / /cfif Be sure to propertly var scope the myCleanedValue, but that'll get you going. Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Call cfscript inside cfc - its possible?
i do one of two things... http://www.revolutionwebdesign.com/blog/index.cfm?mode=entryentry=F198C61E-A5EF-DAA0-5EC6F1AB9C7357F7 or for the link impaired... http://www.antiwrap.com/?724 or, what i do, is refactor the udf, into a new component or function of the cfc im using, and then i have it to use as a cfc anyway :) tw On 9/26/05, Andy Matthews [EMAIL PROTECTED] wrote: You should be able to use any CF function inside a CFC. I think though that you might have it flipped around. Are you trying to use a custom function, which you have created, inside cfscript? If so, then as long as you've defined the function and instantiated it, you should be able to call it from anywhere on the page. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 2:41 PM To: CF-Talk Subject: Call cfscript inside cfc - its possible? Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All )# . What's wrong? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion and Jakarta Structs Framework
Has anyone implemented a ColdFusion Application using the Jakarta Structs Framework? Does anyone know where I can find more information about this? Thanks, Troy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219282 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion and Jakarta Structs Framework
It's actually Jakarta Struts (no 'c'), and there's at least one article on macromedia.com about using it with CF. A search on their site should turn it up. cheers, barneyb On 9/26/05, Troy Simpson [EMAIL PROTECTED] wrote: Has anyone implemented a ColdFusion Application using the Jakarta Structs Framework? Does anyone know where I can find more information about this? Thanks, Troy -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion and Jakarta Structs Framework
Matt Woodward did a blog entry a while back about it too: here: http://www.mattwoodward.com/blog/index.cfm?commentID=153 and especially here: http://www.mattwoodward.com/blog/index.cfm?commentID=151 On 9/26/05, Barney Boisvert [EMAIL PROTECTED] wrote: It's actually Jakarta Struts (no 'c'), and there's at least one article on macromedia.com about using it with CF. A search on their site should turn it up. cheers, barneyb On 9/26/05, Troy Simpson [EMAIL PROTECTED] wrote: Has anyone implemented a ColdFusion Application using the Jakarta Structs Framework? Does anyone know where I can find more information about this? Thanks, Troy -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Search Issues...
Hey Guys... It's been a long time since I have posted here... I was wondering if anyone could help steer me in the right direction. I am currently redesigning our internal Intranet which is basically ASP and .Net. I am converting it to CF and I need to add a Search function. I no this is easy to do using Verity or some other search engine but what I am having problem with is that our Intranet has different levels of security based on what we call a user rank. So if you are rank 10 then you only see rank 10 pages if you are a rank 80 then you can see just about everything. I am trying to figure out a way to search our site but I want the search results to be restricted to the users rank. So if they are a rank 10 then they only see pages and info based on their rank. Any ideas.. Hope all this made sense... Neal Bailey Internet Marketing Manager UGA-Association Field Services ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: source control setup
No, the copy of the code is on the dev server, and each developer edits the code directly using ftp. As we are a small shop, we have not had a lot of issues with people messing up each other's code. I am fine with all the code being on the same server. We have some people working remotely, and having the code on each developers laptop would be fairly hard to set up (we need to install iis, coldfusion, and then the database would probably be an issue, as we'd have to access it over the internet.) Although this would be possible in theory, it is probably out of our reach for the time being. I am more worried about not having a copy of the development branch in a repository until someone is ready to deploy the code. We've had issues where the file was saved as a 0 byte file and work had to start from the beginning or at least from an older backup. Is anyone using the setup I'm talking about? I.e. Everything you save the file through webdav, it goes into the repository and gets put into the file system at the same time. Once we're ready to deploy stuff, it goes into a different repository (production). Is this setup even possible? What I've read so far leads me to believe that it is, but I wanted to see if anyone is using it this way and if there are any gotchas, etc.. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:44 PM To: CF-Talk Subject: Re: source control setup If I understand you correctly, you've got each developer with a copy of the source on their workstation, and then they FTP it to the dev server? That's a bad way to do it; you should have a working copy per-developer, and keep them synchronized with svn, rather than using FTP (since as you say, you can easily overwrite stuff). If you overwrite something with svn, which is very difficult to do accidentally, you can always get it back, because everything is versioned. This will also alleviate the need to use webdav directly. Second, you need to check out branches. Branches let you do parallel development, so if someone needs to go off in some new direction, they can create a branch that doesn't interfere with anyone else (or the production code), and then when they're all done, the branch's changes can be merged back into the main line of development. The benefit is that while workin gon the branch, you can commit to the repository, so you won't ever lose anything. cheers, barneyb On 9/26/05, Russ [EMAIL PROTECTED] wrote: Tried posting this on Friday, but it never seemed to have made it through: We're already using subversion pretty successfully on our servers, but the way we're using it, we're running into a few problems. We have a dev server, which has the production tree checked out, with development changes made straight on the server through ftp. Once the code is ready to be deployed, it gets committed to the repository, and then the svn update is run on the production server (which also has the production tree checked out). Now, if there is some code that is worked on for a long time, or never gets approved to be deployed, then we have code sitting on development for a long time and never being in source control. Sometimes ftp will screw up and overwrite the file, and all the changes get lost. I heard that it's possible to set up svn with webdav through apache. Is it possible to have a set up where we are editing files through webdav or something, and every time we save it gets saved to the development branch or repository and also gets updated in the file system? Then once we're ready to deploy, we would commit it to the production repository as usual. Also what editors support webdav? Homesite doesn't seem to support it, and I've been using CFEclipse lately, which is a little buggy with the ftp support, but I'm assuming there is a webdav plugin for it somewhere. Is it possible to set it up through windows somehow? I read something about web folders, but have not been able to figure out how to set it up in XP Pro. Russ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: iseries as400 question
Remote port is the one you want to use. Not sure why it wouldn't work, perhaps the driver is not configured to work that way... maybe there's some kind of encryption going on as well... -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 1:00 PM To: CF-Talk Subject: Re: iseries as400 question We tried this and it came back with two port numbers. one local and one remote. We tried them both and neither worked :( On 9/26/05, Russ [EMAIL PROTECTED] wrote: Netstat -a should give you all the network connections that your computer has at this time... issue a long running query, and run netstat -a to see what connections you have to the db computer... that should give you the port # as well -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:04 PM To: CF-Talk Subject: Re: iseries as400 question yeah, we tried that (or at least one of the db guys did) and he said he couldnt discern anything meaningful from it. But ill try that again, maybe he missed something. On 9/26/05, Russ [EMAIL PROTECTED] wrote: Well if you can't google it, have you tried sniffing the information? Either do netstat or put on ethereal or something while you're connected to the datasource... you'll see which port the packets are going to... -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:50 AM To: CF-Talk Subject: iseries as400 question Hey guys, Is anyone else out there in cftalk land using iseries as400 for a datasource? We have about 15 that we are connecting to currently and we have them set up just fine through the odbc client access connections. But we were looking at maybe switching it over to the native coldfusion db2 driver. Only problem is, we can't seem to figure out what the port needs to be. the client access odbc administrator doesn't ask for a port (its not an option anywhere.) I am thinking that it must be a standard thing because of that fact. Anyone have any suggestions or know where I could look. several google searches haven't yeilded anything. The default db2 port when you pull it up in cf is 5 and it isn't right. thanks for any help. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: source control setup
I'd really, really, really recommend you don't do what you propose. By doing automatic commits (via webdav), you're going to be updating your repository on every save, which means that every time you save a file it's available to be synced to your production server. You explicitly say you DON'T want that behaviour, so stay away from that arrangement. If you don't want to use working directories per-developer that's fine (though foolhardy, if you ask me). However, you NEED to take a look at branches, as they're the only way you're going to get the security you want, because it will allow you to commit to the repository (to avoid losing work), without the code accidentally being sent into production until you're ready. cheers, barneyb On 9/26/05, Russ [EMAIL PROTECTED] wrote: No, the copy of the code is on the dev server, and each developer edits the code directly using ftp. As we are a small shop, we have not had a lot of issues with people messing up each other's code. I am fine with all the code being on the same server. We have some people working remotely, and having the code on each developers laptop would be fairly hard to set up (we need to install iis, coldfusion, and then the database would probably be an issue, as we'd have to access it over the internet.) Although this would be possible in theory, it is probably out of our reach for the time being. I am more worried about not having a copy of the development branch in a repository until someone is ready to deploy the code. We've had issues where the file was saved as a 0 byte file and work had to start from the beginning or at least from an older backup. Is anyone using the setup I'm talking about? I.e. Everything you save the file through webdav, it goes into the repository and gets put into the file system at the same time. Once we're ready to deploy stuff, it goes into a different repository (production). Is this setup even possible? What I've read so far leads me to believe that it is, but I wanted to see if anyone is using it this way and if there are any gotchas, etc.. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Search Issues...
Neal, I would recommend taking advantage of on of the Custom fields (Custom1,Custom2 etc) in Verity and including the required rank in that field. Then after you run the search, you can filter out results based on comparing the users user rank to that field. blatant_plug You could use easily extend my Searcher component (which is free but requires my free DataMgr component to work) to do that. The Searcher component encapsulates common search functionality and keeps track of what users search for and what they choose from their searches. That is, if you have a predelection for using CFCs. http://www.bryantwebconsulting.com/cfcs/ blatant_plug Hope that helps! Steve Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ Hey Guys... It's been a long time since I have posted here... I was wondering if anyone could help steer me in the right direction. I am currently redesigning our internal Intranet which is basically ASP and .Net. I am converting it to CF and I need to add a Search function. I no this is easy to do using Verity or some other search engine but what I am having problem with is that our Intranet has different levels of security based on what we call a user rank. So if you are rank 10 then you only see rank 10 pages if you are a rank 80 then you can see just about everything. I am trying to figure out a way to search our site but I want the search results to be restricted to the users rank. So if they are a rank 10 then they only see pages and info based on their rank. Any ideas.. Hope all this made sense... Neal Bailey Internet Marketing Manager UGA-Association Field Services ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Search Issues...
Depending on how you're storing your user ranks, wouoldn't something like work: SELECT info FROM tablename WHERE info LIKE %#searchterm#% AND user_rank = #session.user_rank# !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 3:14 PM To: CF-Talk Subject: Search Issues... Hey Guys... It's been a long time since I have posted here... I was wondering if anyone could help steer me in the right direction. I am currently redesigning our internal Intranet which is basically ASP and .Net. I am converting it to CF and I need to add a Search function. I no this is easy to do using Verity or some other search engine but what I am having problem with is that our Intranet has different levels of security based on what we call a user rank. So if you are rank 10 then you only see rank 10 pages if you are a rank 80 then you can see just about everything. I am trying to figure out a way to search our site but I want the search results to be restricted to the users rank. So if they are a rank 10 then they only see pages and info based on their rank. Any ideas.. Hope all this made sense... Neal Bailey Internet Marketing Manager UGA-Association Field Services ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Search Issues...
Hey Steve ok I think I understand and that's kind of what I was thinking, but I'm just not familiar enough with Verity yet. Are there any good resources for setting this up using spiders to collect the data? Also another issue is that half the site will still continue to use .Net apps. I'm not sure if there is way to run .Net in ColdFusion, so for not we just simply open them in another window. This Site is somewhat of a mess of different languages and its time to clean it up. Neal Bailey Internet Marketing Manager UGA-Association Field Services -Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 3:29 PM To: CF-Talk Subject: Re: Search Issues... Neal, I would recommend taking advantage of on of the Custom fields (Custom1,Custom2 etc) in Verity and including the required rank in that field. Then after you run the search, you can filter out results based on comparing the users user rank to that field. blatant_plug You could use easily extend my Searcher component (which is free but requires my free DataMgr component to work) to do that. The Searcher component encapsulates common search functionality and keeps track of what users search for and what they choose from their searches. That is, if you have a predelection for using CFCs. http://www.bryantwebconsulting.com/cfcs/ blatant_plug Hope that helps! Steve Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ Hey Guys... It's been a long time since I have posted here... I was wondering if anyone could help steer me in the right direction. I am currently redesigning our internal Intranet which is basically ASP and ..Net. I am converting it to CF and I need to add a Search function. I no this is easy to do using Verity or some other search engine but what I am having problem with is that our Intranet has different levels of security based on what we call a user rank. So if you are rank 10 then you only see rank 10 pages if you are a rank 80 then you can see just about everything. I am trying to figure out a way to search our site but I want the search results to be restricted to the users rank. So if they are a rank 10 then they only see pages and info based on their rank. Any ideas.. Hope all this made sense... Neal Bailey Internet Marketing Manager UGA-Association Field Services ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Studio Updater for MX 6.1
[answering myself...] I installed the updaters last night to update my CF Studio 5 to include the MX 6.1 extensions, tag definitions, etc. The Help files don't seem to have been updated, nor do all the new tags seem to be available in the tag definitions. Has anyone else had this problem? -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED] Sent: Sunday, September 25, 2005 7:40 PM To: CF-Talk Subject: Re: CF Studio Updater for MX 6.1 HOFLee _ said the following on 9/23/2005 7:25 PM: Do you mean these? From MX6.1 home page http://www.macromedia.com/software/coldfusionmx61/downloads/ Macromedia HomeSite+ (ColdFusion Studio) Tag Updater http://download.macromedia.com/pub/coldfusion/tag_updates/Home siteTags.zip http://download.macromedia.com/pub/coldfusion/tag_updates/HomeSiteExtensions ..zip Yes, thanks much. Chris Montgomery -- //SIGNED// Chris Montgomery, Contractor HQ AF Security Forces Center, Antiterrorism Branch 1517 Billy Mitchell Blvd, Bldg 954 Lackland AFB, TX 78236-0119 DSN 312.945.7150 Comm 210.925.7150 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: javascript timer countdown...
Not directly on topic, but I have found this method of adding methods to window.onload to be really handy: http://www.onlinetools.org/articles/unobtrusivejavascript/chapter4.html Steve Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ if (document.all||document.getElementById) startit() else window.onload=startit ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Search Issues...
It is possible to spider the site and use that for searching, but you need a way to recognize which pages need which user rank. As far as I know, you could do that with a spider. If the data for your pages is in a database, you can query the data (with the URL) and use that to populate a Verity collection. If the data is in files, you can load the files into a Verity collection (remembering to set the custom field to reflect the required user rank. Keep in mind, that it is possible to search multiple collections at one time, so if you need to create more than on collection to accomplish your needs, don't let that discourage you. A Google on ColdFusion Verity search should get you started on the basics, but feel free to ask the list when you run into trouble as well. Hope that helps! Steve Hey Steve ok I think I understand and that's kind of what I was thinking, but I'm just not familiar enough with Verity yet. Are there any good resources for setting this up using spiders to collect the data? Also another issue is that half the site will still continue to use .Net apps. I'm not sure if there is way to run .Net in ColdFusion, so for not we just simply open them in another window. This Site is somewhat of a mess of different languages and its time to clean it up. Neal Bailey Internet Marketing Manager UGA-Association Field Services ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: source control setup
Well maybe I wasn't very clear. What I was thinking is having the automatic commit via webdav on a different repository (dev): Basically this: User edits file through webdav. File gets saved to the dev repository (so every save, and every change is in this repository), and also saved to the disk. File gets tested through the browser in the regular way, and then committed through from the pc to the production repository. I'm not very sure how webdav is set up, so I'm assuming that the settings for that lie in apache instead of on the disk. This way I can have the same file in the dev repository and production repository at the same time. Is this possible? -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 4:26 PM To: CF-Talk Subject: Re: source control setup I'd really, really, really recommend you don't do what you propose. By doing automatic commits (via webdav), you're going to be updating your repository on every save, which means that every time you save a file it's available to be synced to your production server. You explicitly say you DON'T want that behaviour, so stay away from that arrangement. If you don't want to use working directories per-developer that's fine (though foolhardy, if you ask me). However, you NEED to take a look at branches, as they're the only way you're going to get the security you want, because it will allow you to commit to the repository (to avoid losing work), without the code accidentally being sent into production until you're ready. cheers, barneyb On 9/26/05, Russ [EMAIL PROTECTED] wrote: No, the copy of the code is on the dev server, and each developer edits the code directly using ftp. As we are a small shop, we have not had a lot of issues with people messing up each other's code. I am fine with all the code being on the same server. We have some people working remotely, and having the code on each developers laptop would be fairly hard to set up (we need to install iis, coldfusion, and then the database would probably be an issue, as we'd have to access it over the internet.) Although this would be possible in theory, it is probably out of our reach for the time being. I am more worried about not having a copy of the development branch in a repository until someone is ready to deploy the code. We've had issues where the file was saved as a 0 byte file and work had to start from the beginning or at least from an older backup. Is anyone using the setup I'm talking about? I.e. Everything you save the file through webdav, it goes into the repository and gets put into the file system at the same time. Once we're ready to deploy stuff, it goes into a different repository (production). Is this setup even possible? What I've read so far leads me to believe that it is, but I wanted to see if anyone is using it this way and if there are any gotchas, etc.. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219295 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: source control setup
That's impossible. With a webdav share, there isn't a filesystem. You save to the share, the file is sent over the network to apache, which hands it off to SVN, and then stores it in the repo. There isn't a copy of the file on disk anywhere. That means you can't run the code with CF (since CF needs a file), and you can't have the .svn folders that you'd need for the working directory of the main repo. cheers, barneyb On 9/26/05, Russ [EMAIL PROTECTED] wrote: Well maybe I wasn't very clear. What I was thinking is having the automatic commit via webdav on a different repository (dev): Basically this: User edits file through webdav. File gets saved to the dev repository (so every save, and every change is in this repository), and also saved to the disk. File gets tested through the browser in the regular way, and then committed through from the pc to the production repository. I'm not very sure how webdav is set up, so I'm assuming that the settings for that lie in apache instead of on the disk. This way I can have the same file in the dev repository and production repository at the same time. Is this possible? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Recursive Functions in CFC
Hi Folks, I'm using a CFC as a proxy for Flash remoting calls to Google Adwords API. I've found that the Google SOAP services choke on complex object types and Arrays sent from Flash unless I rebuild those objects in the CFC before invoking the Google webservice (despite the fact CF has no trouble with the datatypes!). So, I'm trying to write a couple of recursive methods for the CFC that I can use to sanitise these Flash datatypes for the webservice. Having trouble getting it working though as I'm far more comfortable with Actionscript than CF. On top of which I am sure there is a much more elegant way to handle this. I'd really appreciate if anyone out there could take a quick look over my attempts at recursion and tell me where I'm going wrong. Right now using these functions I am getting unwanted duplicate nested structs and arrays. Thanks for any guidance, Clark !-- Method to sanitise Flash Arrays for Google adwords API webservice -- cffunction name=sanitiseFlashArray access=private returnType=any cfargument name=flashArr type=array required=yes cfset newArr = Arraynew(1) cfloop index=i from=1 to=#Arraylen(flashArr)# cfset tmpItem = #flashArr[i]# cfif IsArray(tmpItem) cfinvoke method=sanitiseFlashArray flashArr=#tmpItem# returnvariable=newItem cfset #newArr[i]# = #newItem# cfelseif IsStruct (tmpItem) cfinvoke method=sanitiseFlashObject flashArr=#tmpItem# returnvariable=newItem cfset #newArr[i]# = #newItem# cfelse cfset #newArr[i]# = #tmpItem# /cfif /cfloop cfreturn #newArr# /cffunction !-- Method to sanitise Flash Objects for Google adwords API webservice -- cffunction name=sanitiseFlashObject access=private returnType=any cfargument name=flashObj type=struct required=yes cfset newObj = StructNew() cfloop collection=#flashObj# item=key cfset tmpItem = #flashObj[key]# cfif IsStruct(tmpItem) cfinvoke method=sanitiseFlashObject flashArr=#tmpItem# returnvariable=newItem cfset #newObj[key]# = #newItem# cfelseif IsArray (tmpItem) cfinvoke method=sanitiseFlashArray flashArr=#tmpItem# returnvariable=newItem cfset #newObj[key]# = #newItem# cfelse cfset #newObj[key]# = #tmpItem# /cfif /cfloop cfreturn #newObj# /cffunction ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Server monitoring tools
The operations side of the house here has no performance monitoring software in place (unbelievable but true). As we build and deploy new Web Servers we would like to get a performance baseline before we install CF. Then again after it's installed. We would then use the same tool to monitor daily performance. #1. What cheap or free monitoring software would you recommend? #2. If we could pay for it what would you recommend? PS. All of our boxes are Windows boxes. We are moving from win2k server to win2003 servers. We are also moving from cf mx 6.1 Standard to 7.0 Enterprise. Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SPAM-LOW: Re: SPAM-LOW: Re: SPAM-LOW: Re: RSS Parser
Umm... An XSL sheet... It's all XML -- any given module is xml -- pick the nodes you want to recongize and decide on a strategy for converting those into your own preferred consistent format. This can all be done in a single XSL sheet, with the possible exception of date/time formats, though there's a good chance you could figure out a way to reformat many if not all of these in XSL also. For dates/times you can't format with XSL you can append a name-spaced attribute or node of your own with an attribute to indicate the format and then use CF (or whatever server tech) to convert the value of that node into the proper date format for your database or whatever else you want to do with it. How would you deal with all the different modules out there? -Adam On 9/26/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: True but then I'll bet somebody's got an XSL sheet somewhere that simply converts the various formats to a single consistent format and you could just run the feeds through that and then parse them with CF. At least -- if it'd been something I had to deal with routinely, that's exactly what I would have created... I hope I'm not the only one. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: product name
-Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 24, 2005 1:01 PM To: CF-Talk Subject: RE: product name [snip] Personally I'd try to stick with your broader convention... so right now that means something onTap. Personally, I'm waiting for the Beer onTap application to come out. C'mon, Isaac! Well once we have a system for storing international contact information, we can amass a huge database of all the contact information for breweries and microbreweries the world over and... :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: iseries as400 question
Here is what I have in the CF admin: JDBC URL: jdbc:as400://10.1.1.1 (use your as400 IP address) Driver Class: com.ibm.as400.access.AS400JDBCDriver Driver Name: AS400 JDBC (this is an arbitrary name) User Name: (as needed) Password: (as needed) I'm working at home today, so I don't have a good connection to the server with my documentation that has the link to the JDBC files, but google either the JDBC URL or Driver Class values and you might find them on IBM's site. If you can't find them, reply back and I'll either send you the link or the files themselves. (Actually, I think there is only one .class file.) M!ke -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:01 PM To: CF-Talk Subject: Re: iseries as400 question Absolutely! That would be perfect Michael. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: product name
How about sixDegrees onTap? Maybe sixDegrees of Kevin Bacon onTap? That could be for a special drinking-game release... Hi all, sorry for the OT, but I wanted to get more opinions on this, it won't take long: I'm working on a contact manager application, and I have several possible names: 1) ConMan 2) People onTap 3) Colleagues onTap Feel free to suggest any other names, although here's a short list of what's already been eliminated from contention: Friends onTap Buddies onTap Clients onTap Associates onTap Contacts onTap Connections onTap Connect onTap s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Weird CFENCODE Problem
Hey all, I know I've done this beofre and it worked. But this time is went all weird on me. I need to provide someone with a bunch of code and we don't want them messing with it. So I used the command line utility CFENCODE to encode/encrypt all of the files. It worked fine, I used \v 2 like the documentations says to, but when I put the apps in place the rendered as the encoded text from the file. Here is how they are used. All of the apps are designed to be modular and included from above the web root using cfmodule and a cold fusion mapping. The calling page below the webroot then calls the apps public file using a cfmodule call similar to this cfmodule template=#Application.ObjPath#/MyApp/public.cfm/cfmodule Has anyone else run into this? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: product name
Sixdegrees - I like that one!! We have six degrees of kevin bacon here on a local fm station. Classic. -Original Message- From: Robert Munn [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 September 2005 10:41 a.m. To: CF-Talk Subject: Re: product name How about sixDegrees onTap? Maybe sixDegrees of Kevin Bacon onTap? That could be for a special drinking-game release... Hi all, sorry for the OT, but I wanted to get more opinions on this, it won't take long: I'm working on a contact manager application, and I have several possible names: 1) ConMan 2) People onTap 3) Colleagues onTap Feel free to suggest any other names, although here's a short list of what's already been eliminated from contention: Friends onTap Buddies onTap Clients onTap Associates onTap Contacts onTap Connections onTap Connect onTap s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Call cfscript inside cfc - its possible?
Thanks all. Works fine now. Do you know how? Simple. Raymond Camden answers for us: http://ray.camdenfamily.com/index.cfm?mode=entryentry=395FCD72-D363-A830-680B85D89C078C0A After create an utility cfc and insert: cfcomponent output=false cfset init() cffunction name=init access=public cfreturn this /cffunction cfscript function blablabla(path) /cfscript /cfcomponent and so on ...bingo! Now you can call all UDF inside utility with cfinvoke. Thanx Ray and all folks. Cheers MD 2005/9/26, Tony [EMAIL PROTECTED]: i do one of two things... http://www.revolutionwebdesign.com/blog/index.cfm?mode=entryentry=F198C61E-A5EF-DAA0-5EC6F1AB9C7357F7 or for the link impaired... http://www.antiwrap.com/?724 or, what i do, is refactor the udf, into a new component or function of the cfc im using, and then i have it to use as a cfc anyway :) tw On 9/26/05, Andy Matthews [EMAIL PROTECTED] wrote: You should be able to use any CF function inside a CFC. I think though that you might have it flipped around. Are you trying to use a custom function, which you have created, inside cfscript? If so, then as long as you've defined the function and instantiated it, you should be able to call it from anywhere on the page. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 2:41 PM To: CF-Talk Subject: Call cfscript inside cfc - its possible? Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All )# . What's wrong? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Server monitoring tools
Check out http://www.paessler.com/ We've been using the whole suite of products for a while now. Pretty good for the price. You can also do some nice stuff with http://www.cacti.net/ if you have the technical know how. It's free. -e -Original Message- From: Ken Ketsdever [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 6:07 PM To: CF-Talk Subject: Server monitoring tools The operations side of the house here has no performance monitoring software in place (unbelievable but true). As we build and deploy new Web Servers we would like to get a performance baseline before we install CF. Then again after it's installed. We would then use the same tool to monitor daily performance. #1. What cheap or free monitoring software would you recommend? #2. If we could pay for it what would you recommend? PS. All of our boxes are Windows boxes. We are moving from win2k server to win2003 servers. We are also moving from cf mx 6.1 Standard to 7.0 Enterprise. Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Server monitoring tools
Quoting Ken Ketsdever [EMAIL PROTECTED]: The operations side of the house here has no performance monitoring software in place (unbelievable but true). Not so unbelievable. Pretty common, actually. As we build and deploy new Web Servers we would like to get a performance baseline before we install CF. Then again after it's installed. We would then use the same tool to monitor daily performance. Makes sense. #1. What cheap or free monitoring software would you recommend? If you have the ability to build yourself a Linux box (I'm totally happy to help), I can thoroughly recommend Nagios (www.nagios.org). We use it here at work to monitor a distributed environment (three cities) of around 200 hosts including switches, routers and servers on multiple platforms - Win2K/2K3, Cisco IOS, SuSE, Solaris, Oracle DB, etc. With a little work, you can even get it to monitor process-level activity on hosts. It's *extremely* powerful, if a little laborious to set up initially. Once it's done, however, you have as good a monitoring system as you'll get anywhere, no matter what you pay. #2. If we could pay for it what would you recommend? I wouldn't - use Nagios. PS. All of our boxes are Windows boxes. We are moving from win2k server to win2003 servers. We are also moving from cf mx 6.1 Standard to 7.0 Enterprise. Not a challenge. Like I said, if you'd like some help getting this set up I'm happy to give you a hand via email or IM. It's definitely worth it. Steve -- Steve Collins E [EMAIL PROTECTED] W www.stephencollins.org ICQ 1014940 | MSN [EMAIL PROTECTED] | Yahoo trib Google Talk [EMAIL PROTECTED] | Skype trib22 The ACME Guide - Best practice development using Apache - ColdFusion MX - MySQL - Eclipse/CFEclipse www.stephencollins.org/acme/ This message was sent using IMP, the Internet Messaging Program. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
2 Spaces causing problems for CFMX 6.1
Hi All, I have just run into something weird and I was wondering if anybody could shed some light. Not sure if it is a CF6.1 problem, CF6.1/7 or an underlying Java problem. If I try any CFFILE operation on a file that has 2 sequential spaces in the file name, CFFILE fails. Windows does not have this problem but CF does. So when a user uploads a file with 2 spaces such as My File.gif I cant work with it. Cant rename, delete etc Anybody else notice this? Dan. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219308 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 2 Spaces causing problems for CFMX 6.1
What if you specify a filename to upload into with the CFFILE tag, rather than just a directory? I haven't run into the problem myself, but that might alleviate it. cheers, barneyb On 9/26/05, Daniel Mackey [EMAIL PROTECTED] wrote: Hi All, I have just run into something weird and I was wondering if anybody could shed some light. Not sure if it is a CF6.1 problem, CF6.1/7 or an underlying Java problem. If I try any CFFILE operation on a file that has 2 sequential spaces in the file name, CFFILE fails. Windows does not have this problem but CF does. So when a user uploads a file with 2 spaces such as My File.gif I cant work with it. Cant rename, delete etc Anybody else notice this? Dan. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: product name
Six degrees of onTap is pretty good imho. On 9/26/05, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: Sixdegrees - I like that one!! We have six degrees of kevin bacon here on a local fm station. Classic. -Original Message- From: Robert Munn [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 September 2005 10:41 a.m. To: CF-Talk Subject: Re: product name How about sixDegrees onTap? Maybe sixDegrees of Kevin Bacon onTap? That could be for a special drinking-game release... Hi all, sorry for the OT, but I wanted to get more opinions on this, it won't take long: I'm working on a contact manager application, and I have several possible names: 1) ConMan 2) People onTap 3) Colleagues onTap Feel free to suggest any other names, although here's a short list of what's already been eliminated from contention: Friends onTap Buddies onTap Clients onTap Associates onTap Contacts onTap Connections onTap Connect onTap s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 2 Spaces causing problems for CFMX 6.1
Hi Barney, That was just an example. Lets say I have user files somewhere that got there other than through CF and then I have to work with them. I cant do anything with them if there are 2 sequential spaces. If you have time, you may try it on your box for me. Create a file in a folder and add 2 spaces in the middle of it using Windows Explorer and do a simple CFFILE action=delete or rename and see the problem. Dan. Barney Boisvert wrote: What if you specify a filename to upload into with the CFFILE tag, rather than just a directory? I haven't run into the problem myself, but that might alleviate it. cheers, barneyb On 9/26/05, Daniel Mackey [EMAIL PROTECTED] wrote: Hi All, I have just run into something weird and I was wondering if anybody could shed some light. Not sure if it is a CF6.1 problem, CF6.1/7 or an underlying Java problem. If I try any CFFILE operation on a file that has 2 sequential spaces in the file name, CFFILE fails. Windows does not have this problem but CF does. So when a user uploads a file with 2 spaces such as My File.gif I cant work with it. Cant rename, delete etc Anybody else notice this? Dan. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 2 Spaces causing problems for CFMX 6.1
This code ran just dandy on my CF6.1/Apache2/RedHat 8.0 box: cfset filename = #getDirectoryFromPath(getCurrentTemplatePath())#/test space.tmp / cffile action=write file=#filename# mode=664 output=hello, world / cffile action=delete file=#filename# / cheers, barneyb On 9/26/05, Daniel Mackey [EMAIL PROTECTED] wrote: Hi Barney, That was just an example. Lets say I have user files somewhere that got there other than through CF and then I have to work with them. I cant do anything with them if there are 2 sequential spaces. If you have time, you may try it on your box for me. Create a file in a folder and add 2 spaces in the middle of it using Windows Explorer and do a simple CFFILE action=delete or rename and see the problem. Dan. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: product name
or we could amass a huge db of TV shows and call it ... Pap onTap I like the possibility of a name like ConMan. Its short and sweet in the sense of few syllables. Easy to say and write. But you'll have to get and stay creative when it comes to copywriting. Make sure you are up to that. If you plan on releasing a family of products giving them all linked names can have recognition benefits as well. I like 'People On Tap' for the general image it evokes, but it seems like too many syllables. Faces On Tap? Bear in mind this 'keep-it-short' stuff is coming from a guy who sells stuff named 'GridMonger' and 'AccessMonger'... I started sticking a 'monger' on the end of my free tags as a light-hearted thing, but over time it grew to a point where now I'm kind of stuck with it. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursive Functions in CFC
Doh! I wasn't using var to declare the local variable so the recursion was overwriting the variable representing my new array and object. Clark Hi Folks, I'm using a CFC as a proxy for Flash remoting calls to Google Adwords API. I've found that the Google SOAP services choke on complex object types and Arrays sent from Flash unless I rebuild those objects in the CFC before invoking the Google webservice (despite the fact CF has no trouble with the datatypes!). So, I'm trying to write a couple of recursive methods for the CFC that I can use to sanitise these Flash datatypes for the webservice. Having trouble getting it working though as I'm far more comfortable with Actionscript than CF. On top of which I am sure there is a much more elegant way to handle this. I'd really appreciate if anyone out there could take a quick look over my attempts at recursion and tell me where I'm going wrong. Right now using these functions I am getting unwanted duplicate nested structs and arrays. Thanks for any guidance, Clark !-- Method to sanitise Flash Arrays for Google adwords API webservice -- cffunction name=sanitiseFlashArray access=private returnType=any cfargument name=flashArr type=array required=yes cfset newArr = Arraynew(1) cfloop index=i from=1 to=#Arraylen(flashArr)# cfset tmpItem = #flashArr[i]# cfif IsArray(tmpItem) cfinvoke method=sanitiseFlashArray flashArr=#tmpItem# returnvariable=newItem cfset #newArr[i]# = #newItem# cfelseif IsStruct (tmpItem) cfinvoke method=sanitiseFlashObject flashArr=#tmpItem# returnvariable=newItem cfset #newArr[i]# = #newItem# cfelse cfset #newArr[i]# = #tmpItem# /cfif /cfloop cfreturn #newArr# /cffunction !-- Method to sanitise Flash Objects for Google adwords API webservice -- cffunction name=sanitiseFlashObject access=private returnType=any cfargument name=flashObj type=struct required=yes cfset newObj = StructNew() cfloop collection=#flashObj# item=key cfset tmpItem = #flashObj[key]# cfif IsStruct(tmpItem) cfinvoke method=sanitiseFlashObject flashArr=#tmpItem# returnvariable=newItem cfset #newObj[key]# = #newItem# cfelseif IsArray (tmpItem) cfinvoke method=sanitiseFlashArray flashArr=#tmpItem# returnvariable=newItem cfset #newObj[key]# = #newItem# cfelse cfset #newObj[key]# = #tmpItem# /cfif /cfloop cfreturn #newObj# /cffunction ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: product name
You know it's impossible to find the rules for the drinking game on google... I found plenty of comments about it -- where it came from, etc... but not one that mentions how the game is played when alcohol is involved... You know... it's a sad state of affairs when our miracle indexing engine, the font of all human knowledge can't produce such a trivial piece of information. :) How about sixDegrees onTap? Maybe sixDegrees of Kevin Bacon onTap? That could be for a special drinking-game release... Hi all, sorry for the OT, but I wanted to get more opinions on this, it won't take long: I'm working on a contact manager application, and I have several possible names: s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: product name
or we could amass a huge db of TV shows and call it ... Pap onTap Okay, that one lost me... heh ... The only thing pap brings to my mind is a womens health thing, and I'm guessing that's not the context you intended. :) Bear in mind this 'keep-it-short' stuff is coming from a guy who sells stuff named 'GridMonger' and 'AccessMonger' ... I started sticking a 'monger' on the end of my free tags as a light-hearted thing, but over time it grew to a point where now I'm kind of stuck with it. Yeah, with the recent move of CF to the Java world, I'm surprised you haven't released a WarMonger Pro. :) Of course, the alternative EarMonger Pro sounds a bit disturbing. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RSS Parser
Not sure if its any use but I did something related. Its been available for download for some time. Basically its a coldfusion equivalent of carp wrapped in a cfc. You can check it out here. http://webmachineinc.com/rss/countme.cfm. It works on all flavors of rss that I could find and most atom. DRE On 9/25/05, Barney Boisvert [EMAIL PROTECTED] wrote: XSL'll only help you if you want to format the RSS in another text format, not if you want to rip it out for some other purpose (store in DB, or whatever). cheers, barneyb On 9/25/05, s. isaac dealey [EMAIL PROTECTED] wrote: Why would you need it? RSS is XML, you should be able to just write your own parser... Isaac: Unfortunately, there are rafts of broken syndication apps out there from authors who made the same assumption. :D RSS is a series of specifications, most of which come with all sorts of common practices baggage. (A number of which contradict one another.) If you don't know both specs and practices, you can't effectively write a generic parser. Particularly when you factor in Atom. Now, if you're just trying to make use of a single feed from a known, consistent producer, or if you're really, truly dedicated to diving into syndication minutiae, then rolling your own makes some sense. But I promise, it ain't simple. If it were, we wouldn't have spent two years building Atom 1.0. Well yeah, but I would expect there to be a good free free XSL sheet available _somewhere_ given the ubiquity of RSS. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
