Re: Huh? EMBED and OBJECT Tags Get Modified During CFFILE WRITE?
Jochem's tersely abbreviated post at first seemed to read as if the solution was to ENABLE Global Script Protection (which didn't make sense), but James you made me realize that he meant to point me in that general direction and that the real solution was to NOT ENABLE Global Script Protection. My hosting provider implemented the change and everything is fine again. Take-home lesson: if you ever find your EMBED and OBJECT tags getting mysteriously converted to InvalidTag in a CFFILE WRITE operation, disable Global Script Protection in the CF Administrator. Now if we could just get this houseoffusion.com forum to actually record posts the first time instead of nothing nothing nothing and then suddenly three copies of the same thing appear... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading Excel..
I like jExcel. You could try this simple script with jExcel(instantiated
with javaLoader):
!--- path to Excel sheet ---
cfset filepath = C:\Inetpub\wwwroot2\tryExcel_CF.xls
cfscript
wfile = createObject(java,java.io.File).init(filepath);
workbookPai = server.javaLoader.create(jxl.Workbook);
wworkbook = server.javaLoader.create(jxl.write.WritableWorkbook);
wworkbook = workbookPai.getWorkbook(wfile);
sheetPai = server.javaLoader.create(jxl.write.WritableSheet);
//get sheet named cf_xl_integration - change to the name in your
workbook
sheet = wworkbook.getSheet(cf_xl_integration);
/cfscript
cfset rowslen = sheet.getRows()
cfset columnslen = sheet.getColumns()
cfoutput
cfloop from=0 to=#columnslen-1# index=c
#sheet.getCell(javacast('int',c),0).getContents()#
br /
/cfloop
/cfoutput
Will need to download jExcel.jar and include in your directory for this
script.
Cheers
Marco Antonio
On Wed, Feb 13, 2008 at 10:54 PM, Jaime Metcher
[EMAIL PROTECTED] wrote:
Brian,
I would also recommend POI with Ben Nadel's POIUtility, but if you want to
stick with a DSN, the following includes a way to unlock the datasource:
http://cfregex.com/cfcomet/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9
004033E03EF9http://cfregex.com/cfcomet/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9
No idea if it still works in CFMX 6/7/8.
Jaime Metcher
-Original Message-
From: Brian Dumbledore [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 February 2008 2:05 AM
To: CF-Talk
Subject: Reading Excel..
I made the subject look easy so I can have more viewers ;) But
here is my problem.. After having trouble with working
cfx_Excel2Query ( I finally reverted to it in the end and got it
working), I thought why not do this:
1) Create a odbc dsn to a excel file
2) Create a cf dsn to this odbc dsn
3) User uploads his file, I copy it as the file to which the dsn
si specified.
4) I query the file using [sheet$1] as the table, and so on.
This method works fine, however, sometimes (most of the times),
it appears the file being used as the dsn gets 'locked'. I cann't
delete, rename etc, 'next' upload of file fails to overwrite this
file because it is locked.
Basically this method is too inconsistent.
My question is, is there anything I need to do to make sure the
file is 'released' after the query has run? If this one thing is
solved, I no longer have to use third party solutions, I can just
create a dsn to the file and keep overwriting the file with the
new file whenever.
Any suggestions?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299054
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Last Updated
Hey all, I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008 9:00 AM ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last Updated
If you don't fancy going back to the DB, Query of Query. Adrian -Original Message- From: Scott Stewart Sent: 15 February 2008 13:41 To: CF-Talk Subject: Last Updated Hey all, I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated Thanks sas -- Scott Stewart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Last Updated
select top 1 last_updated from some_table order by last_updated_desc Unless you need to display each one and depending on db platform -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 8:41 AM To: CF-Talk Subject: Last Updated Hey all, I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008 9:00 AM ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Last Updated
The solution varies by database, which one are you using? This would would work on MSSQL SELECT TOP 1 * FROM your_table_name ORDER BY updated_date DESC On Fri, Feb 15, 2008 at 8:40 AM, Scott Stewart [EMAIL PROTECTED] wrote: Hey all, I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008 9:00 AM ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Last Updated
Scott, Hope this helps. http://sqlzoo.net/howto/source/z.dir/tip181635/oracle Eugene Dew Information Technology Specialist II - Web Developer Purchasing Department University of Oklahoma 2750 Venture Drive Norman, Oklahoma 73069 Email: [EMAIL PROTECTED] Tel: 405.325.6703 Fax: 405-329-8394 Confidentiality Notice: This email message, including attachments, contains or may contain confidential information intended only for the addressee. If you are not an intended recipient of this message, be advised that any reading, dissemination, forwarding, printing, copying or other use of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by reply message and delete this email message and any attachments from your system. Thank you. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 7:41 AM To: CF-Talk Subject: Last Updated Hey all, I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008 9:00 AM ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse - mimic amp;quot;automatically upload files to server on saveamp;quot;
Have you looked at Aptana Studio? Its a free downloadable plugin for Eclipse. Not only do you get handy tools like CSS and JavaScript syntax completion and highlighting but there's also a 'view' called Sync Manager. There you set up a remote ftp connection [snip] Apparently you missed the part where FTP is not an option. No, if I can't do it with the OS to a UNC mapping, it's a non-starter for me. (At this job, anyway.) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help with CF-8 db connection string for MySQL 5
Having a few problems migrating to CF-8 and MySQL 5 on Red Hat. We have always used a connection string in CF that allowed dates like 00-00- to be treated as nulls. Found out that we needed a second connection string to enable some of the features of stored procedures but haven't been able to find a syntax that works to concatenate the two strings on Linux. Either one works separately, just not together. Someone has suggested just turning strict mode off altogether which does both those things and more. But I am wary of creating other problems because I don't know what else it adds much less the syntax for doing so. Rick Maosn ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last Updated
It's MSSQLServer.. this should work Thanks all :) sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 8:47 AM To: CF-Talk Subject: Re: Last Updated The solution varies by database, which one are you using? This would would work on MSSQL SELECT TOP 1 * FROM your_table_name ORDER BY updated_date DESC On Fri, Feb 15, 2008 at 8:40 AM, Scott Stewart [EMAIL PROTECTED] wrote: Hey all, I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008 9:00 AM ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFEclipse - mimic amp;quot;automatically upload files to server on saveamp;quot;
Have you tried this file sync plugin? http://andrei.gmxhome.de/eclipse.html On Fri, Feb 15, 2008 at 8:42 AM, Al Everett [EMAIL PROTECTED] wrote: Have you looked at Aptana Studio? Its a free downloadable plugin for Eclipse. Not only do you get handy tools like CSS and JavaScript syntax completion and highlighting but there's also a 'view' called Sync Manager. There you set up a remote ftp connection [snip] Apparently you missed the part where FTP is not an option. No, if I can't do it with the OS to a UNC mapping, it's a non-starter for me. (At this job, anyway.) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
debugging not displaying in IE
Anyone run into this problem and have a fix? Sometimes in IE when I hit a page that has an error in it the CF Debugging does not display. All I get is an IIS 500 error. In firefox I always see the debugging. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Component issues
Hey all, Im back :-) Ive got a page set up that seems to be causing component issues. The page is called index.cfm Theres a header and footer that are called from a Custom tag Components are called in index,cfm A return variable is needed in the footer from a component called in index.cfm 1) even with the Custom Tag arent the templates processed sequentially (header, index, footer) 2) Shouldnt the return values be in memory and available to any template? 3) Why wont the variable display in the footer.cfm? HAAALLPP!! -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008 9:00 AM ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Component issues
It depend whether the custom tag can access the variables. Are you passing them in? Are they in a scope the custom tag has access to? Adrian -Original Message- From: Scott Stewart Sent: 15 February 2008 15:26 To: CF-Talk Subject: Component issues Hey all, Im back :-) Ive got a page set up that seems to be causing component issues. The page is called index.cfm Theres a header and footer that are called from a Custom tag Components are called in index,cfm A return variable is needed in the footer from a component called in index.cfm 1) even with the Custom Tag arent the templates processed sequentially (header, index, footer) 2) Shouldnt the return values be in memory and available to any template? 3) Why wont the variable display in the footer.cfm? HAAALLPP!! -- Scott Stewart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last Updated
I still think if you have the query already, query of query it. Adrian. -Original Message- From: Scott Stewart Sent: 15 February 2008 14:11 To: CF-Talk Subject: RE: Last Updated It's MSSQLServer.. this should work Thanks all :) sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Sonny Savage Sent: Friday, February 15, 2008 8:47 AM To: CF-Talk Subject: Re: Last Updated The solution varies by database, which one are you using? This would would work on MSSQL SELECT TOP 1 * FROM your_table_name ORDER BY updated_date DESC On Fri, Feb 15, 2008 at 8:40 AM, Scott Stewart [EMAIL PROTECTED] wrote: Hey all, I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated Thanks sas -- Scott Stewart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFDIV and ThickBox ;)
Hey GUys, for months Ive been calling thickbox (jquery plugin) from inside
cfdivs using
cfloop query=mydsn
a href=javascript:tb_show('My Image
Caption','/img/#fetchgallery.ImageName#') rel=The Name of my gallery
class=thickbox
img src=/img/#fetchgallery.ThumbNailImageName# border=0/
/a
/cfloop
Simple enough.. I have a loop that setsup a list of thumbnails that have links
to them, they are all grouped together with rel. When ThickBox loads it
SHOULD produce a gallery inside the cfdiv that this is loaded in. Thick box
will load them one at a time but it looses its gallery function - not paging
forward or backward.
Anyone had any experiance with this... CFDIV has made my world so much simpler
and made me look soo much smarter than I really am I feel that I MUST be doign
somethign wrong...
Thanks ;)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Losing Cookies with IE Browsers
Hello Guys, I was just wondering if anyone here have experienced the same situation I'm in right now. In a nutshell, I'm noticing on my ecommerce website the cookie holding the shopping cart ID is being dropped after several clicks through the website only with IE browsers. With the same code, it works just fine with FireFox/Netscape browers. Here's how my database driven shopping cart works on my site. In the Application.cfm I have these lines of code: cfif NOT IsDefined(COOKIE.LastCartID) cfset newCCID = #CreateUUID()# cfcookie name=LastCartID value=#newCCID# expires=NEVER cflock timeout=30 throwontimeout=No name=#SESSION.SessionID# type=EXCLUSIVE cfset SESSION.CartID = COOKIE.LastCartID /cflock /cfif A first time visitor will have a new cart ID created and saved to a cookie (COOKIE.LastCartID) and to a session variable (SESSION.CartID). Once the mini shopping cart is reached, a query is made to the cart database to find contents of the cart and will display the data. New customers will return 0 contents obviously but returning customers who added items in a previous session will display as such. Now, what I noticed is after adding an item to the cart and making about 20 or so click throughs on the site, the cart returns 0 items and with my debugging code on, a whole new cookie ID is created as well as other session variables (CFID, CFTOKEN, etc.) I'm just wondering if anyone else experienced this and what strategies should I undertake to resolve this. This is an issue specific to IE browsers. Thanks. Orlando ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFwhaturl?
For the life of me I can't remember the tag needed to identify the refering URL name. I have two names pointing to the same domain IP but I want to use only one, so if: Urlname is OLDURLNAME - cfredirect to NEWURLNAME What is the tag to get url? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last Updated
Another thought... If ordered by the date field ASC: #myquery['datecolumn'][myquery.recordcount]# If ordered by the date field DESC: #myquery['datecolumn'][1]# ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 11:24 AM To: CF-Talk Subject: RE: Last Updated Also, wouldn't it be pmore portable to use: SELECT MAX(date_field) AS recentDate FROM TableName m!ke -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 9:34 AM To: CF-Talk Subject: RE: Last Updated I still think if you have the query already, query of query it. Adrian. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Last Updated
Also, wouldn't it be pmore portable to use: SELECT MAX(date_field) AS recentDate FROM TableName m!ke -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 9:34 AM To: CF-Talk Subject: RE: Last Updated I still think if you have the query already, query of query it. Adrian. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFwhaturl?
#cgi.server_name# ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 11:19 AM To: CF-Talk Subject: CFwhaturl? For the life of me I can't remember the tag needed to identify the refering URL name. I have two names pointing to the same domain IP but I want to use only one, so if: Urlname is OLDURLNAME - cfredirect to NEWURLNAME What is the tag to get url? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFwhaturl?
Dump the CGI scope. You want the referrer, spelled referer. m!ke -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 10:19 AM To: CF-Talk Subject: CFwhaturl? For the life of me I can't remember the tag needed to identify the refering URL name. I have two names pointing to the same domain IP but I want to use only one, so if: Urlname is OLDURLNAME - cfredirect to NEWURLNAME What is the tag to get url? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFwhaturl?
CGI.HTTP_REFERER, CGI.SERVER_NAME? Adrian -Original Message- From: Robert Harrison Sent: 15 February 2008 16:19 To: CF-Talk Subject: CFwhaturl? For the life of me I can't remember the tag needed to identify the refering URL name. I have two names pointing to the same domain IP but I want to use only one, so if: Urlname is OLDURLNAME - cfredirect to NEWURLNAME What is the tag to get url? Thanks Robert B. Harrison ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Component issues
Shouldn't the return values be in memory and available to any template? In short, no. In terms of design too, custom tags should be highly reusable which suggests being self contained which rules out having dependencies on variables being set elsewhere. Assuming these are your homemade custom tags, I would added the variables you need as attributes of the tag and pass them in in the calling page. As a side note, cfmodule works in the same way and for the same good reason (self containment and reusability). HTH Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last Updated
cfquery dbtype=query maxrows=1 Select whatever from myOriginalQuery order by theDateField desc /cfquery ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 11:24 AM To: CF-Talk Subject: RE: Last Updated Also, wouldn't it be pmore portable to use: SELECT MAX(date_field) AS recentDate FROM TableName m!ke -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 9:34 AM To: CF-Talk Subject: RE: Last Updated I still think if you have the query already, query of query it. Adrian. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFwhaturl?
I didn't know there was a tag... But I am still in the old 4.0 days... :) I used the CGI Variable #CGI.HTTP_Referer# to see where they came from and #CGI.HTTP_Host# to see what URL they typed. Rick -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: February 15, 2008 10:19 AM To: CF-Talk Subject: CFwhaturl? For the life of me I can't remember the tag needed to identify the refering URL name. I have two names pointing to the same domain IP but I want to use only one, so if: Urlname is OLDURLNAME - cfredirect to NEWURLNAME What is the tag to get url? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFwhaturl?
But I am still in the old 4.0 days. Gee! Are you related to Rick Faircloth? ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: regex help
If you don't manage to get what you're after. Just loop over the array and
look for the string.
Adrian
-Original Message-
From: cf coder
Sent: 15 February 2008 17:11
To: CF-Talk
Subject: regex help
Hello everybody,
I need some help with regular expressions.
I'm trying to write a reqular expression that will return all the links on a
page that contain a string in the query string.
I found a UDF on cflib that returns a list of all the anchor tags on a page
but I want to only return all href tags that contain the word ProductID in
the query string ex:
a href=somesite.com/index.cfm?action=getproductID=1test/a
Here is the udf, that returns all the links on the page.
function hrefsToList(inputString) {
var pos=1;
var tmp=0;
var linklist = ;
var delimiter = ,;
var endpos = ;
if(arrayLen(arguments) gte 2) delimiter = arguments[2];
while(1) {
tmp = reFindNoCase(a[^]*[^]*/a, inputString, pos);
if(tmp) {
pos = tmp;
endpos = findNoCase(/a, inputString, pos)+4;
linkList = listAppend(linkList, mid(inputString, pos,
endpos-pos),
delimiter);
pos = endpos;
}
else break;
}
return linkList;
}
Can someone please show me how to change the modify expression to return
what I've explained above please?
Thanks,
cfcoder
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299084
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last Updated
I have a query that returns a list of dates, how would I find the most recent. to post as Last Updated This depends on several things. If you are not going to generate another query then how is the existing query sorted? If sorted by Last Updated date either ascending or descending then the last updated will be either the first or last row in the query column_name[1] or column_name[#recordcount#]. If sorted by some other method then either use a query of query to obtain the Last Updated date, loop over the query to find the Last Updated date, or go back to the DB with another query. SELECT TOP 1 columns FROM table ORDER BY Last_Updated_date DESC Best Regards, Dennis Powers UXB Internet - A website design and Hosting Company 690 Wolcott Road P.O. Box 6029 Wolcott, CT 06716 Tel: (203)879-2844 http://www.uxbinternet.com/ http://www.uxb.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: regex help
pardon me saying this but it looks very complicated. I rather just write a regex that will do this effortlessley. Regards, cfcoder I need some help with regular expressions. What you need is the kind of requirement I made CF_REextract for. See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last Updated
Over a QoQ? Not really, it's CF not SQL. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 15 February 2008 16:24 To: CF-Talk Subject: RE: Last Updated Also, wouldn't it be pmore portable to use: SELECT MAX(date_field) AS recentDate FROM TableName m!ke -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 9:34 AM To: CF-Talk Subject: RE: Last Updated I still think if you have the query already, query of query it. Adrian. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
regex help
Hello everybody,
I need some help with regular expressions.
I'm trying to write a reqular expression that will return all the links on a
page that contain a string in the query string.
I found a UDF on cflib that returns a list of all the anchor tags on a page but
I want to only return all href tags that contain the word ProductID in the
query string ex:
a href=somesite.com/index.cfm?action=getproductID=1test/a
Here is the udf, that returns all the links on the page.
function hrefsToList(inputString) {
var pos=1;
var tmp=0;
var linklist = ;
var delimiter = ,;
var endpos = ;
if(arrayLen(arguments) gte 2) delimiter = arguments[2];
while(1) {
tmp = reFindNoCase(a[^]*[^]*/a, inputString, pos);
if(tmp) {
pos = tmp;
endpos = findNoCase(/a, inputString, pos)+4;
linkList = listAppend(linkList, mid(inputString, pos,
endpos-pos), delimiter);
pos = endpos;
}
else break;
}
return linkList;
}
Can someone please show me how to change the modify expression to return what
I've explained above please?
Thanks,
cfcoder
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299082
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: regex help
If tmp 0, it's there! reFindNoCase(a[ ]+href[ -~]+productID[ -~]+/a,inputString, pos) Warren Koch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT - Box has been attacked by cowboy
Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFwhaturl?
Man, I'm never going to shake this reputation for being a CF luddite! I'm using CF 8 for my dev box and VPS now! :o) (I do have to admit that my in-house server is running CF 4.5 until I can migrate all sites over to the VPS...) I'm trying! :o) That's ok, however. I'm getting a CF T-Shirt from Will! Ha! Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 12:24 PM To: CF-Talk Subject: Re: CFwhaturl? But I am still in the old 4.0 days. Gee! Are you related to Rick Faircloth? ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFwhaturl?
It was CGI.SERVER_NAME. That's why I couldn't find it. I was looking for a CF tag. Forgot that was a CGI var. Duh! Thank You Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Component issues
I've got a page set up that seems to be causing component issues. The page is called index.cfm There's a header and footer that are called from a Custom tag Components are called in index,cfm A return variable is needed in the footer from a component called in index.cfm 1) even with the Custom Tag aren't the templates processed sequentially (header, index, footer) Yes. 2) Shouldn't the return values be in memory and available to any template? Each file - your page, the component, the custom tag - has its own local scope. If you want to access a variable from within your custom tag, and that variable is in the page that calls the custom tag, you have three options: 1. Use the Caller scope to refer to it from within the custom tag. This is usually not the optimal choice, because it creates a tight coupling between your page and the custom tag. 2. Pass the value to the custom tag as an attribute. This is usually the best choice. 3. Place the variable in a scope that's equally accessible from both files. The Request scope was created explicitly for this purpose. Other choices include Client, Session, Application and Server scopes. Usually, this is not as good a choice as passing the value to the custom tag, but since custom tags can't really return values without a hack of sorts, the Request scope can be very convenient if you have multiple levels of nesting. 3) Why won't the variable display in the footer.cfm? Because it's not in a scope that both files can see the same way. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: regex help
Sorry -- you only wanted it if productid was in a query string. Try this reFindNoCase(a[ ]+href[ -~]+\?[ -~]+productID=[ -~]+/a,inputString, pos) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
You should contact softlayer.com and tell them that one of their (10,000) dedicated servers has been compromised. http://www.softlayer.com/ I have been hacked before. No fun at all. b) inform FBI. Good luck on that. Prolly one of 10 a bazzion script kiddies bouncing off of 1/2 a dozen proxies. Just sayin'. ;) I recommend getting a bunch of antivirus, spyware, root kit recovery programs and get busy. You are going to be at it for a while. These will get you going. Dr. Web AVG Unhackme root kit reveler Good luck and don't take it personally. Gerald On Fri, Feb 15, 2008 at 12:52 PM, Don L [EMAIL PROTECTED] wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SPAM: OT - Box has been attacked by cowboy
Is this ongoing or has it already stopped? I'm guessing that alerting the FBI will give you no results. I doubt that this would rank very high on their threat list. And a law suit? Have you simply tried contacting this company and talking to them? I'd be willing to bet that they don't even know it's happening as it's probably a trojan of some sort. Why jump straight to law sutis and the FBI when a simple phone call might resolve the issue? -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 11:52 AM To: CF-Talk Subject: SPAM: OT - Box has been attacked by cowboy Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
No 64-bit on Windows for CF8?
Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8 (http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=5E205E BA-1372-FA49-99C83B22E3A9AA30). So, it isn't available on windows, right? (My angle is to give more memory to the JVM, and 64-bit is the quickest/only way to do it.) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: No 64-bit on Windows for CF8?
64bit CF8 is in final beta, watch for an announcement in the very near future. --- Ben -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:32 PM To: CF-Talk Subject: No 64-bit on Windows for CF8? Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8 (http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=5E205E BA-1372-FA49-99C83B22E3A9AA30). So, it isn't available on windows, right? (My angle is to give more memory to the JVM, and 64-bit is the quickest/only way to do it.) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: regex help
I use the QuickREx plugin for Eclipes. Very handy. RegEx's make my brain hurt. http://www.bastian-bergerhoff.com/eclipse/features/web/QuickREx/toc.html There is a stand alone version http://www.bastian-bergerhoff.com/eclipse/features/web/QuickREx/standalone.html -- All you need in this life is ignorance and confidence; then success is sure. - Mark Twain ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Box has been attacked by cowboy
Don, We have also had attacks against our servers by Ips traced to SoftLayer (and their clients) and would be very interested in seeing this stopped. Let us know how we can support you. Also, I assume that you have contacted SoftLayer to have them take action as well? I would also be interested in hearing what can be done in situations like this. Best, Nick . .. -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 12:52 PM To: CF-Talk Subject: OT - Box has been attacked by cowboy Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: No 64-bit on Windows for CF8?
HELP! I just bought a 64-bit windows server. What versions of CF7 or CF8 can I run on this machine? Rick Colman -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 10:36 AM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? 64bit CF8 is in final beta, watch for an announcement in the very near future. --- Ben -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:32 PM To: CF-Talk Subject: No 64-bit on Windows for CF8? Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8 (http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=5E205E BA-1372-FA49-99C83B22E3A9AA30). So, it isn't available on windows, right? (My angle is to give more memory to the JVM, and 64-bit is the quickest/only way to do it.) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: No 64-bit on Windows for CF8?
Hey Ben, When you say 'soon-to-be-released' can the timeframe to the release be counted in months, weeks, days, hours, etc? How long would Rick need to wait (obviously an estimate, not actual time...) William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 10:53 AM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? Regular CF8 can run on it, using a 32bit JVM. If you can wait a little longer, you'll be able to use the soon-to-be-released 64bit version of CF8. --- Ben -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:48 PM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? HELP! I just bought a 64-bit windows server. What versions of CF7 or CF8 can I run on this machine? Rick Colman -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 10:36 AM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? 64bit CF8 is in final beta, watch for an announcement in the very near future. --- Ben -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:32 PM To: CF-Talk Subject: No 64-bit on Windows for CF8? Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8 (http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=5E205E BA-1372-FA49-99C83B22E3A9AA30). So, it isn't available on windows, right? (My angle is to give more memory to the JVM, and 64-bit is the quickest/only way to do it.) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FCK Editor Issue
Good morning/afternoon everyone. So I pretty much have my FCK Editor working on our site but one issue is still puzzling me. When I try to load a document (word doc in this case), I get an error invalid file. I updated the config.js pages to allow the following files: config.allowedExtensions[File] = doc,rtf,pdf,ppt,pps,xls,csv,vnd,zip; and still I get the error. I checked on-line and cannot find the answer to this issue. All others have been answered by Google. Thanks and have a happy Presidents Day in the US and happy Family Day to our friends up North. Bruce -- Throttle Jockey - Why golf courses should be motocross tracks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: regex help
EDIT: The regex should be this one instead. The one above would not handle any thing between the href= and the closing . (a[^]*href=['](([^']*)?([^']ProductID=?([^']*)[^']*))['][^]*([^]*)\/a) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Box has been attacked by cowboy
c. Figure out how they got in, reinstall the box, get a firewall and keep up on the latest patches. More then likely you are running sql on a default port on a public ip (a major no no). This combined with weak passwords for one of your accounts led to the compromise. BTW, FBI won't get involved btw unless there's over 10k in damages. Russ -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 12:52 PM To: CF-Talk Subject: OT - Box has been attacked by cowboy Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No 64-bit on Windows for CF8?
I wish I could answer that question, but I really can't. I will, however, say that we're not expecting any additional beta releases. --- Ben -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:59 PM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? Hey Ben, When you say 'soon-to-be-released' can the timeframe to the release be counted in months, weeks, days, hours, etc? How long would Rick need to wait (obviously an estimate, not actual time...) William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 10:53 AM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? Regular CF8 can run on it, using a 32bit JVM. If you can wait a little longer, you'll be able to use the soon-to-be-released 64bit version of CF8. --- Ben -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:48 PM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? HELP! I just bought a 64-bit windows server. What versions of CF7 or CF8 can I run on this machine? Rick Colman -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 10:36 AM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? 64bit CF8 is in final beta, watch for an announcement in the very near future. --- Ben -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:32 PM To: CF-Talk Subject: No 64-bit on Windows for CF8? Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8 (http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=5E205E BA-1372-FA49-99C83B22E3A9AA30). So, it isn't available on windows, right? (My angle is to give more memory to the JVM, and 64-bit is the quickest/only way to do it.) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: regex help
Hi here is a regex that should do the job. It does a little more that you are asking for. I felt like playing around with the regex. cfsavecontent variable=regex(a[^]*href=['](([^']*)?([^']ProductID=?([^']*)[^']*))[']([^]*)\/a)/cfsavecontent cfsavecontent variable=text a style=mystyle:as; href=index.cfm?x=1ProductID=5y=2I am link 1/abr / a href=index.cfm?x=1z=5y=2I am link 2/abr / a href=index.cfm?ProductID=1z=5y=2I am link 3/abr / a href=index.cfm?x=1z=5ProductID=2I am link 4/abr / a href=index.cfm?x=1ProductIDy=2I am link 5/abr / /cfsavecontent fieldset legendText/legend cfoutput#text#/cfoutput /fieldset cfset result = ReFindNoCase(regex,text,1,true) / cfset resultArray = ArrayNew(1) / cfloop condition=#result[len][1]# neq 0 cfset info = StructNew() / cfset info.match = Mid(text,result[pos][2], result[len][2]) / cfset info.href= Mid(text,result[pos][3], result[len][3]) / cfset info.hrefbeforeProductID= Mid(text,result[pos][4], result[len][4]) / cfset info.hreffromProductIDPlus = Mid(text,result[pos][5], result[len][5]) / cfset info.ProductID = Mid(text,result[pos][6], result[len][6]) / cfset info.LinkText = Mid(text,result[pos][7], result[len][7]) / cfset ArrayAppend(resultArray, info) / cfset text = removeChars(text,result[pos][1], result[len][1]) / cfset result = ReFindNoCase(regex,text,1,true) / /cfloop cfdump var=#resultArray# Thanks, Jason Morgan. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Box has been attacked by cowboy
I'd like to thank those who put forward thoughtful notes rather than put up a firwall, so, you think when you're being attacked you didn't have a firewall? this kind of 'move on' nonsense does not help anything, pay attention when you follow up, the attention should be of help/value. To Hatton, yes, I immediately blocked them once detected attack. To Nick, we'll see. Don Yesterday around 7pm EST my box has been ruthlessly attacked (port ... Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No 64-bit on Windows for CF8?
Thanks for the heads-up... This is very helpful for planning purposes. Mark -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:36 PM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? 64bit CF8 is in final beta, watch for an announcement in the very near future. --- Ben -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:32 PM To: CF-Talk Subject: No 64-bit on Windows for CF8? Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8 (http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=5E205E BA-1372-FA49-99C83B22E3A9AA30). So, it isn't available on windows, right? (My angle is to give more memory to the JVM, and 64-bit is the quickest/only way to do it.) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Box has been attacked by cowboy
On Fri, Feb 15, 2008 at 5:52 PM, Don L [EMAIL PROTECTED] wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. We get scans, SSH attempts, injection attempts, hack attempts all the time - it's part of life on the web. Make sure your machine is secure, get a firewall in, move on. -- mac jordan www.webhorus.net www.nibblous.com www.kestrel.org www.jordan-cats.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: regex help
I would prefer the regular expression to do this. Can you show me how to do
what you are suggesting please?
If you don't manage to get what you're after. Just loop over the array and
look for the string.
Adrian
Hello everybody,
I need some help with regular expressions.
I'm trying to write a reqular expression that will return all the links on a
page that contain a string in the query string.
I found a UDF on cflib that returns a list of all the anchor tags on a page
but I want to only return all href tags that contain the word ProductID in
the query string ex:
a href=somesite.com/index.cfm?action=getproductID=1test/a
Here is the udf, that returns all the links on the page.
function hrefsToList(inputString) {
var pos=1;
var tmp=0;
var linklist = ;
var delimiter = ,;
var endpos = ;
if(arrayLen(arguments) gte 2) delimiter = arguments[2];
while(1) {
tmp = reFindNoCase(a[^]*[^]*/a, inputString, pos);
if(tmp) {
pos = tmp;
endpos = findNoCase(/a, inputString, pos)+4;
linkList = listAppend(linkList, mid(inputString, pos,
endpos-pos),
delimiter);
pos = endpos;
}
else break;
}
return linkList;
}
Can someone please show me how to change the modify expression to return
what I've explained above please?
Thanks,
cfcoder
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299085
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
Have you blocked traffic from that IP at the firewall yet? Also, when I did a lookup of the IP, it was traced to a different domain for a company that provides hosting (gege-hosting.com) but it is not coming up any more. An online scan of the IP shows that the only open access is via windows Remote Desktop The company that you traced it to is a hosting company, they sell dedicated machines. My first step would be to contact them at http://www.softlayer.com/about.html. Best of luck! Hatton On Fri, Feb 15, 2008 at 12:52 PM, Don L [EMAIL PROTECTED] wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
A little CFEXECUTE help
Hey all, I'm trying to do a little CFEXECUTE magic on a Linux box, gzipping an xml file on the fly. All is well except that the resulting file is occasionally empty. It seems to work about 50% of the time, then the other 50% I get an empty .gz file. My code looks like this: cfexecute name=#pathtogzip# arguments=#pathtofile# outputfile=#pathtofile#.gz /cfexecute The paths are all correct -- as I mentioned it does work about half the time so there are no path or permission issues. I also tried adding in the arguments -f (force) and -q (quiet), but it doesn't seem to make a difference. Any thoughts? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: regex help
I need some help with regular expressions. What you need is the kind of requirement I made CF_REextract for. See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
Are you on a windows box? On Fri, Feb 15, 2008 at 12:52 PM, Don L [EMAIL PROTECTED] wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Box has been attacked by cowboy
I'd like to thank those who put forward thoughtful notes rather than put up a firwall, so, you think when you're being attacked you didn't have a firewall? this kind of 'move on' nonsense does not help anything, pay attention when you follow up, the attention should be of help/value. On the contrary, it's the only useful answer. If you have a known vulnerability, you have to fix it. The answer may not be as simple as put up a firewall, but if someone from Texas was able to get to your database server directly to change your schema, that indicates a clear problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: regex help
I wasn't very strict with ensuring that the string was found in a/a
tags... although it would be simple to add if you need that... I only made
sure that it was either productid=NUMBER or ?productID=NUMBER (regardless
of case)
I just wanted to make sure that I got a simple solution posted before anyone
had the chance to fall for the inevitable reextract sales pitch that seems
to follow every regex question on this list these days.
cfscript
function freeFunction(str)
{
var tmp = '';
var tmpArr = arrayNew(1);
while(refindnocase(.*?(|\?)productID=([0-9]{1,})[^0-9], str))
{
str = rereplacenocase(str,
.*?(|\?)productID=([0-9]{1,}).*?[^0-9], [**\2**]);
tmp = arrayappend(tmpArr, rereplacenocase(str,
\[\*\*([0-9].*?)\*.*, \1));
}
return tmpArr;
}
/cfscript
cfdump var=#freeFunction(myString)# /
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299114
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anyone still using iMS-SE mail server?
We used to use IMS lite until we moved to CF7 Enterprise. CF7 Standard is slow when sending mail (only 1 thread), CF7 Enterprise is very fast (much faster then our ims-lite was which was only 5 threads). We do use a dedicated linux box to actually send out the mail, but cfmail to push it through to our mail box. Russ -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 2:38 PM To: CF-Talk Subject: Anyone still using iMS-SE mail server? Just curious. I did a search through my old cf-talk messages and it looks like it's been almost 3 years since iMS-SE has been mentioned on this list. And it looks like Howie Hamlin has been absent from the list for about the same amount of time. We have a version of iMS-SE installed on our CF8 server, using it mostly for mass mailings, while using CFMAIL for most one-off messages. But CFMAIL continues to frustrate the out of me. Although the spooling time has been set to 15 seconds in the Administrator, messages sit for up to 10 minutes before being sent. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
I don't know how experienced with admining a windows box and do not want to offend. But if you are on a win box I wrote up a little security 101 off the top of my head. It is has been a few years since I did any sys admin work so others might want to chime in on things I over looked. - Disable the administrator account - Restrict access to remote desktop to one account with an obscure username - Make failed login attempts wait at least thirty seconds or a minute before logging in again - Run the Security Configuration Wizard (SCW) and lock down all ports, services and apps - Shut down all unneeded services. - Use ridiculous usernames and passwords. - Only allow local access (or one IP for dedicated DB) to database servers - Use an external, *hardware* based firewall - Keep everything patched and make sure you are on the security mailing lists for all third part apps, scripts and servers that you used. - Use AV, anti-spyware and anti-intrusion software And/Or get a server security suite by a reputable vender. To paraphrase: The price of a maintaining a server is eternal vigilance. On Fri, Feb 15, 2008 at 12:52 PM, Don L [EMAIL PROTECTED] wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Box has been attacked by cowboy
Your techniques are appreciated. From what I understand, you can't disable the admin account. I think you mean rename the administrator acct. Changing things from default ports would go a long way too. You can change the ports of RDP and SQL without really affecting functionality, and it would cut down on 99.% hack attempts. Further, if you can afford a hardware firewall, you can lock down access to said ports to trusted ips only and/or use a vpn login to the firewall first. Only have ports open to the public that need to be open to the public, which in most cases is just http/https. Russ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Box has been attacked by cowboy
Don L wrote: pay attention when you follow up, the attention should be of help/value. On public forums people will give you the advice they think you need, not the advice you want. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Box has been attacked by cowboy
I don't think that anything said here is libelous in the least. He is only describing what happened. Hacks were done from an IP registered to SoftLayer. People /should/ be talking about these sorts of things so that ISPs hosting bad actors will tighten up security. We've seen a number of incidents traced back to softlayer ourselves and they should feel some heat when that happens. You have no idea whether this ISP is hosting bad actors. All you know is that attacks have been logged from their IP addresses. If Don's servers have been compromised, others may now log attacks from his servers. Is he a bad actor? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Box has been attacked by cowboy
I'm unsure if it's 'your' server or a company that you work for, but if you don't know something, ignoring the problem doesn't constitute a solution and sure isn't a justifiable excuse. And you don't need to be an expert at security to handle this, because there are experts that tell you how to do it for free, including the companies / organizations that build the software you run. http://www.google.com/search?hl=enq=how+to+secure+a+windows+servermeta= http://www.google.com/search?hl=ensafe=offq=how+to+secure+a+SQL+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+a+mysql+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+an+apache+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+an+IIS+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+a+mail+server !k -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 2:10 PM To: CF-Talk Subject: Re: OT - Box has been attacked by cowboy . On the contrary, it's the only useful answer. If you have a known vulnerability, you have to fix it. The answer may not be as simple as put up a firewall, but if someone from Texas was able to get to your database server directly to change your schema, that indicates a clear problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Here's the thing, if I were a security professional, would I be in a better position to attack and/or defend my machine or any machines for that matter? Given the opportunity cost, could any of us be all and being experts in all? A clear and difficult challenge. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
Nick Gleason wrote: I don't think that anything said here is libelous in the least. I guess that depends on what jurisdiction you live. Hacks were done from an IP registered to SoftLayer. People /should/ be talking about these sorts of things so that ISPs hosting bad actors will tighten up security. We've seen a number of incidents traced back to softlayer ourselves and they should feel some heat when that happens. So did you block all of softlayer on your firewall? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Box has been attacked by cowboy
On the contrary, it's the only useful answer. If you have a known vulnerability, you have to fix it. The answer may not be as simple as put up a firewall, but if someone from Texas was able to get to your database server directly to change your schema, that indicates a clear problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Here's the thing, if I were a security professional, would I be in a better position to attack and/or defend my machine or any machines for that matter? Given the opportunity cost, could any of us be all and being experts in all? A clear and difficult challenge. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Box has been attacked by cowboy
Don L wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. My course of actions would have been: - take box down; - remove harddisk; - lock compromised harddisk in safe for later analysis; - put in new harddisk; - rebuild from backups; - analyze harddisk; - fix the security problem; - get back in business; - file a police report if considerable damages. I would have made very certain I didn't point fingers in public because it would ruin my chances in a lawsuit and it most likely meets the legal definition of libel. BTW, did you check to see if the attacker used your system to attack others? There may be people somewhere online blaming you for attacking them and filing reports to the FBI about you. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Box has been attacked by cowboy
Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Who exactly do you plan to sue? You have no idea who's responsible. All you know is the IP address used to launch the attack. Maybe you could sue SoftLayer for negligence - for not having adequate security in place - but then again, you obviously don't have adequate security in place either. You are equally negligent, at least. What are your monetary damages? The FBI will generally only pursue cases where there are significant, demonstrable monetary damages. Finally, strictly speaking, a port scan isn't really an attack, although it may be malicious in intent and may set off IDS alarms. I strongly recommend that you focus your efforts on securing your systems, rather than a legal approach. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Box has been attacked by cowboy
I don't think that anything said here is libelous in the least. He is only describing what happened. Hacks were done from an IP registered to SoftLayer. People /should/ be talking about these sorts of things so that ISPs hosting bad actors will tighten up security. We've seen a number of incidents traced back to softlayer ourselves and they should feel some heat when that happens. Just my $.02. N . .. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:15 PM To: CF-Talk Subject: Re: OT - Box has been attacked by cowboy Don L wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. My course of actions would have been: - take box down; - remove harddisk; - lock compromised harddisk in safe for later analysis; - put in new harddisk; - rebuild from backups; - analyze harddisk; - fix the security problem; - get back in business; - file a police report if considerable damages. I would have made very certain I didn't point fingers in public because it would ruin my chances in a lawsuit and it most likely meets the legal definition of libel. BTW, did you check to see if the attacker used your system to attack others? There may be people somewhere online blaming you for attacking them and filing reports to the FBI about you. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Box has been attacked by cowboy
Here's the thing, if I were a security professional, would I be in a better position to attack and/or defend my machine or any machines for that matter? Well, uh, yeah. Just like, presumably, you'd be better at writing CF apps than they would. Given the opportunity cost, could any of us be all and being experts in all? Probably not. But that's irrelevant, because there are plenty of qualified people who can do this sort of thing for you. If you don't know how to do it, you should get someone who does. That will let you get back to doing what you're good at. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Box has been attacked by cowboy
I don't think any insult was meant, but you have to understand that for many companies, this is just one of the things they deal with on a regular basis. If you have a firewall and were breached, you need to find out how specifically how they got in. If you weren't breached, than for all intents and purposes, no harm... no foul, which by the way is exactly what the FBI or CSIS will tell you. If you don't have a firewall, than you might as well have posted your IP on craigslist asking to be hacked... !k -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:00 PM To: CF-Talk Subject: Re: OT - Box has been attacked by cowboy I'd like to thank those who put forward thoughtful notes rather than put up a firwall, so, you think when you're being attacked you didn't have a firewall? this kind of 'move on' nonsense does not help anything, pay attention when you follow up, the attention should be of help/value. To Hatton, yes, I immediately blocked them once detected attack. To Nick, we'll see. Don Yesterday around 7pm EST my box has been ruthlessly attacked (port ... Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No 64-bit on Windows for CF8?
Regular CF8 can run on it, using a 32bit JVM. If you can wait a little longer, you'll be able to use the soon-to-be-released 64bit version of CF8. --- Ben -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:48 PM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? HELP! I just bought a 64-bit windows server. What versions of CF7 or CF8 can I run on this machine? Rick Colman -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 10:36 AM To: CF-Talk Subject: RE: No 64-bit on Windows for CF8? 64bit CF8 is in final beta, watch for an announcement in the very near future. --- Ben -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:32 PM To: CF-Talk Subject: No 64-bit on Windows for CF8? Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8 (http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=5E205E BA-1372-FA49-99C83B22E3A9AA30). So, it isn't available on windows, right? (My angle is to give more memory to the JVM, and 64-bit is the quickest/only way to do it.) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Box has been attacked by cowboy
I would say that if SoftLayer's boxes are being compromised to launch attacks, then yes they are bad actors. Since we have seen many attacks coming from different Ips that are registered to them, I feel confident in making that assertion. I may also have some sympathy for them that they are the source of the problem. Perhaps they are doing their best or have great intentions. But, the results also matter and what is undeniable is that SL is the source of a lot of attacks. That is important and their should be some culpability for that sort of thing. If Don met the same criteria, then I would say the same thing. Respectfully, N . .. Nick Gleason | CitySoft, Inc. | http://www.citysoft.com Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. . .. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:36 PM To: CF-Talk Subject: RE: OT - Box has been attacked by cowboy I don't think that anything said here is libelous in the least. He is only describing what happened. Hacks were done from an IP registered to SoftLayer. People /should/ be talking about these sorts of things so that ISPs hosting bad actors will tighten up security. We've seen a number of incidents traced back to softlayer ourselves and they should feel some heat when that happens. You have no idea whether this ISP is hosting bad actors. All you know is that attacks have been logged from their IP addresses. If Don's servers have been compromised, others may now log attacks from his servers. Is he a bad actor? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf8 query weirdness
I remember getting this error but not sure if and how I resolved it (I am no longer getting this error). I am currently doing: Select IsNull(SCOPE_IDENTITY(), 0) as someid HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf8 query weirdness
That would help if for some reason no row was inserted. In my case, however, a row is being inserted, but it just doesn't work. I believe I'm running the latest version of CF8 (8,0,0,176276). Any other suggestions? Russ -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 4:11 PM To: CF-Talk Subject: Re: cf8 query weirdness I remember getting this error but not sure if and how I resolved it (I am no longer getting this error). I am currently doing: Select IsNull(SCOPE_IDENTITY(), 0) as someid HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cf8 query weirdness
That seemed to work, but I don't think for the reason you specified. I have also gotten it to work this way My original query was something like this: cfquery name=someqry datasource=somedns Insert into sometable (somefields) Select somefields from someothertable Select SCOPE_IDENTITY() as someid Where someID=cfqueryparam cfsqltype=cf_sql_integer value=#arguments.someId# /cfquery I have changed it to the following: cfquery name=someqry datasource=somedns Declare @someid integer Set @someid=cfqueryparam cfsqltype=cf_sql_integer value=#arguments.someId# Insert into sometable (somefields) Select somefields from someothertable Select SCOPE_IDENTITY() as someid Where [EMAIL PROTECTED] /cfquery I think the cf engine has somewhere code similar to the following: If qrytext startswith insert or qrytext startswith update or qrytext startswith delete //null the query variable Qrynameref=null; Basically this is a bug in CF... how do we get them to fix it? I don't think we can roll out our app to CF8 until this is fixed... we potentially have dozens of these. Russ -Original Message- From: C S [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 4:16 PM To: CF-Talk Subject: Re: cf8 query weirdness Any other suggestions? Wrap the whole thing in a set nocount on/set nocount off to prevent rowcounts from interfering with the query results. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf8 query weirdness
Why do you have both selects? The first one may be interfering. I assume you want the result set returned by the second? ~Brad -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:09 PM To: CF-Talk Subject: cf8 query weirdness I have something like that following (which I believe works on our cf7 servers). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf8 query weirdness
Any other suggestions? Wrap the whole thing in a set nocount on/set nocount off to prevent rowcounts from interfering with the query results. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: A little CFEXECUTE help
Log all the paramters when making your cfexecute call, and whether it successfully created the file or not. Then look at both lists (the ones that worked, and the ones that didn't), and I'll bet a pattern will emerge. Spaces or bad characters in a filename perhaps? Surround the filenames with double quotes. Or perhaps output over a certain size is failing? I haven't seen it done the way you are doing it there (not that its wrong), passing the binary data through coldfusion by using the outputfile attribute. What attributes are you passing to gzip? By default it deletes the file you are compressing, so this should work: cfexecute name=/bin/gzip arguments=#pathtofile# / This should create a new file named #pathtofile#.gz, and the original #pathtofile# will have been deleted. -Ryan Josh Nathanson wrote: Hey all, I'm trying to do a little CFEXECUTE magic on a Linux box, gzipping an xml file on the fly. All is well except that the resulting file is occasionally empty. It seems to work about 50% of the time, then the other 50% I get an empty .gz file. My code looks like this: cfexecute name=#pathtogzip# arguments=#pathtofile# outputfile=#pathtofile#.gz /cfexecute The paths are all correct -- as I mentioned it does work about half the time so there are no path or permission issues. I also tried adding in the arguments -f (force) and -q (quiet), but it doesn't seem to make a difference. Any thoughts? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf8 query weirdness
My original query was something like this: cfquery name=someqry datasource=somedns Insert into sometable (somefields) Select somefields from someothertable Select SCOPE_IDENTITY() as someid Where someID=cfqueryparam cfsqltype=cf_sql_integer value=#arguments.someId# /cfquery Is there a typo in there? You have got the WHERE clause after the SCOPE_IDENTITY(). I would not expect that to work even with MX7. Do you mean this? SET NOCOUNT ON Insert into sometable (somefields) Select somefields from someothertable Where someID=cfqueryparam cfsqltype=cf_sql_integer value=#arguments.someId# Select SCOPE_IDENTITY() as someid SET NOCOUNT OFF ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Box has been attacked by cowboy
I would say that if SoftLayer's boxes are being compromised to launch attacks, then yes they are bad actors. Since we have seen many attacks coming from different Ips that are registered to them, I feel confident in making that assertion. Their name is strangely apropos. Soft Layer indeed. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
I would say that if SoftLayer's boxes are being compromised to launch attacks, then yes they are bad actors. They rent dedicated servers (10,000 of them according to them). That is the moral equivolent of holding a car rental company liable for accidents caused by people that rent the cars. The responsibility for the security for *unmanaged* servers the the person that operates the server, not the company from which it is rented. Just like you are responsible for securing your own desktop at home. Not if it were *managed* dedicated servers being compromised that would be another case entirely. On Fri, Feb 15, 2008 at 4:15 PM, Nick Gleason [EMAIL PROTECTED] wrote: I would say that if SoftLayer's boxes are being compromised to launch attacks, then yes they are bad actors. Since we have seen many attacks coming from different Ips that are registered to them, I feel confident in making that assertion. I may also have some sympathy for them that they are the source of the problem. Perhaps they are doing their best or have great intentions. But, the results also matter and what is undeniable is that SL is the source of a lot of attacks. That is important and their should be some culpability for that sort of thing. If Don met the same criteria, then I would say the same thing. Respectfully, N . .. Nick Gleason | CitySoft, Inc. | http://www.citysoft.com Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. . .. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:36 PM To: CF-Talk Subject: RE: OT - Box has been attacked by cowboy I don't think that anything said here is libelous in the least. He is only describing what happened. Hacks were done from an IP registered to SoftLayer. People /should/ be talking about these sorts of things so that ISPs hosting bad actors will tighten up security. We've seen a number of incidents traced back to softlayer ourselves and they should feel some heat when that happens. You have no idea whether this ISP is hosting bad actors. All you know is that attacks have been logged from their IP addresses. If Don's servers have been compromised, others may now log attacks from his servers. Is he a bad actor? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf8 query weirdness
Ok, I get it. The sometable stuff had thrown me off. You could call a stored proc instead and send out the identity column as an output parameter, but I'm guessing you don't want to have to re-write all that... ~Brad -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:44 PM To: CF-Talk Subject: RE: cf8 query weirdness The first select is part of the insert statement, the second select just gets the identity out. Russ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf8 query weirdness
You could call a stored proc instead and send out the identity column as an output parameter, but I'm guessing you don't want to have to re-write all that... Yes, but an insert / select .. from table should work just by adding set nocount. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
Yep. They basically let you do whatever. We used to host with them. --Ben Doom Josh Nathanson wrote: That is the moral equivolent of holding a car rental company liable for accidents caused by people that rent the cars. The responsibility for the security for *unmanaged* servers the the person that operates the server, not the company from which it is rented. Just like you are responsible for securing your own desktop at home. In that case I take back my jab at them. I didn't realize they were unmanaged. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf8 query weirdness
What is this nocount and why do I have to use it. Also can we confirm that this is a cf8 bug? Russ -Original Message- From: C S [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 4:44 PM To: CF-Talk Subject: Re: cf8 query weirdness You could call a stored proc instead and send out the identity column as an output parameter, but I'm guessing you don't want to have to re-write all that... Yes, but an insert / select .. from table should work just by adding set nocount. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf8 query weirdness
Personally, I see zero value in stored procedures. In fact I believe they're a detriment, as you can't' easily store them in source control. Russ -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 4:49 PM To: CF-Talk Subject: RE: cf8 query weirdness Ok, I get it. The sometable stuff had thrown me off. You could call a stored proc instead and send out the identity column as an output parameter, but I'm guessing you don't want to have to re-write all that... ~Brad -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:44 PM To: CF-Talk Subject: RE: cf8 query weirdness The first select is part of the insert statement, the second select just gets the identity out. Russ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
That is the moral equivolent of holding a car rental company liable for accidents caused by people that rent the cars. The responsibility for the security for *unmanaged* servers the the person that operates the server, not the company from which it is rented. Just like you are responsible for securing your own desktop at home. In that case I take back my jab at them. I didn't realize they were unmanaged. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Creating a JS Library Init
I would like to create a factory.js file that has an init method that
accepts an attribute of which library to load.
So say I had a string library called string.js and a library called
date.js. I would like to include one default.js file in the site and
dynamically load up the functions from string.js and/or date.js via an
init method. Basically I want to load all libraries into one
(factory.js) file.
So say I had a function customSplitString(myString, delim) in string.js
and a createCustomDate(month, day, year) function in date.js. Now I
want someone to be able to write a function in their CFML that calls
these functions. Here are a few examples:
Inline in CFML. This example should only load date.js
script
Function createSomeDate() {
Var myDateMonth=2;
Var myDateYear=2007;
Var myDateDay=1;
Return factory.date.createCustomDate(myDateMonth,
myDateYear, myDateDay);
}
/script
Inline in CFML. This example should only load string.js
script
Function returnMyName(myName, delim){
Var myNameArr=factory.string.customSplitString(myString,
delim);
Return myNameArr.length();
}
/script
Inline in CFML This example would load string and date.
script
Function returnMyName(myName, delim){
Var myNameArr=factory.string.customSplitString(myString,
delim);
Return myNameArr.length();
}
Function createSomeDate() {
Var myDateMonth=2;
Var myDateYear=2007;
Var myDateDay=1;
Return factory.date.createCustomDate(myDateMonth,
myDateYear, myDateDay);
}
/script
So in the end nobody would call the string or date libraries
independently. There would only be one script include in the header of
the application that loads factory.js.
I've done this years ago but I can't remember how I did it.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299142
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Anyone still using iMS-SE mail server?
Just curious. I did a search through my old cf-talk messages and it looks like it's been almost 3 years since iMS-SE has been mentioned on this list. And it looks like Howie Hamlin has been absent from the list for about the same amount of time. We have a version of iMS-SE installed on our CF8 server, using it mostly for mass mailings, while using CFMAIL for most one-off messages. But CFMAIL continues to frustrate the out of me. Although the spooling time has been set to 15 seconds in the Administrator, messages sit for up to 10 minutes before being sent. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Box has been attacked by cowboy
I realized that this last post seemed harsh, so I thought I'd clarify. My point is that since you're in the middle of this, there's better things to do than assess blame. I understand that you're upset and frustrated, but looking to point the finger to blame will not lead to anyone but yourself and that's not going to help you deal with this. If you desperately need to keep the server online, a quick fix is a small home based router / firewall that can hold you through while you sort this out. They're built to be easy to configure via browser and generally you can get them for quite cheap. Configuring it would be much easier than trying to learn how to console into a Cisco Pix... If you don't need it up, than take it down immediately so that you don't cause the same grief to others online. !k -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 2:38 PM To: CF-Talk Subject: RE: OT - Box has been attacked by cowboy I'm unsure if it's 'your' server or a company that you work for, but if you don't know something, ignoring the problem doesn't constitute a solution and sure isn't a justifiable excuse. And you don't need to be an expert at security to handle this, because there are experts that tell you how to do it for free, including the companies / organizations that build the software you run. http://www.google.com/search?hl=enq=how+to+secure+a+windows+servermeta= http://www.google.com/search?hl=ensafe=offq=how+to+secure+a+SQL+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+a+mysql+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+an+apache+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+an+IIS+server http://www.google.com/search?hl=ensafe=offq=how+to+secure+a+mail+server !k -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 2:10 PM To: CF-Talk Subject: Re: OT - Box has been attacked by cowboy .. On the contrary, it's the only useful answer. If you have a known vulnerability, you have to fix it. The answer may not be as simple as put up a firewall, but if someone from Texas was able to get to your database server directly to change your schema, that indicates a clear problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Here's the thing, if I were a security professional, would I be in a better position to attack and/or defend my machine or any machines for that matter? Given the opportunity cost, could any of us be all and being experts in all? A clear and difficult challenge. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfmail recommendation
Need to allow visitors to a site the ability to send a unique personalized email to 30 different recipients from one form entry. Can you recommend a method or set of code for sale that can do this? thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008 9:00 AM ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cf8 query weirdness
The first select is part of the insert statement, the second select just gets the identity out. Russ -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 4:35 PM To: CF-Talk Subject: RE: cf8 query weirdness Why do you have both selects? The first one may be interfering. I assume you want the result set returned by the second? ~Brad -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:09 PM To: CF-Talk Subject: cf8 query weirdness I have something like that following (which I believe works on our cf7 servers). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Box has been attacked by cowboy
From what I understand, you can't disable the admin account. I think you mean rename the administrator acct. Changing things from default ports would go a long way too. You can change the ports of RDP and SQL without really affecting functionality, and it would cut down on 99.% hack attempts. Further, if you can afford a hardware firewall, you can lock down access to said ports to trusted ips only and/or use a vpn login to the firewall first. Only have ports open to the public that need to be open to the public, which in most cases is just http/https. Russ -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 3:00 PM To: CF-Talk Subject: Re: OT - Box has been attacked by cowboy I don't know how experienced with admining a windows box and do not want to offend. But if you are on a win box I wrote up a little security 101 off the top of my head. It is has been a few years since I did any sys admin work so others might want to chime in on things I over looked. - Disable the administrator account - Restrict access to remote desktop to one account with an obscure username - Make failed login attempts wait at least thirty seconds or a minute before logging in again - Run the Security Configuration Wizard (SCW) and lock down all ports, services and apps - Shut down all unneeded services. - Use ridiculous usernames and passwords. - Only allow local access (or one IP for dedicated DB) to database servers - Use an external, *hardware* based firewall - Keep everything patched and make sure you are on the security mailing lists for all third part apps, scripts and servers that you used. - Use AV, anti-spyware and anti-intrusion software And/Or get a server security suite by a reputable vender. To paraphrase: The price of a maintaining a server is eternal vigilance. On Fri, Feb 15, 2008 at 12:52 PM, Don L [EMAIL PROTECTED] wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: A little CFEXECUTE help
Or perhaps output over a certain size is failing? I haven't seen it done the way you are doing it there (not that its wrong), passing the binary data through coldfusion by using the outputfile attribute. What attributes are you passing to gzip? By default it deletes the file you are compressing, so this should work: Ryan, your suggestion worked perfectly. I wasn't aware that the default behavior of gzip was to delete the file being compressed and write the compressed file automatically, thus making the outputfile attribute unnecessary. Probably what was happening was a threading/race condition issue of some sort, where sometimes the outputfile attribute was overwriting the compressed file and sometimes not. Thanks a bunch, I probably never would have figured that out. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Neef CF 6.1
Hi all, I sent this to the cf-server list first, but I thought maybe someone on list could help as well. I'm in dire need of ColdFusion 6.1. We're migrating a server that currently runs ColdFusion 6.1 (Windows 2000) to a new server (Windows 2003), but we don't have the CF 6.1 installer so we can't install CF on the new server. We have a legit license, serial and CD for CF 6.0, however Adobe no longer provides the download for 6.1. We don't have the $$ to upgrade to 7 or 8, so right now our only option is to somehow obtain the 6.1 installer. I've called Adobe, was on the phone for an hour+ and got nowhere.talked to 4 different people and no one would give me access to a download for 6.1. Does anyone have the 6.1 installer file still around? I would be forever grateful for any help anyone can provide! Thanks in advance. Ross ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf8 query weirdness
What is this nocount and why do I have to use it. Also can we confirm that this is a cf8 bug? Drivers process the results of each statement. Including those that only return a rowcount like updates or inserts: ie (1) row inserted. Cfquery is only supposed to return one resultset. Rowcounts can interfere with that. Using set nocount avoids that problem. That is not a bug IMO. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
