RE: CFHTTP and Caching
This is the error I am getting below even though weather_xml has been defined in the application.cfm page i.e. CFSET APPLICATION.weather_xml =XMLParse(cfhttp.FileContent) ERROR IS Element WEATHER_XML is undefined in APPLICATION. My application.cfm page is cfset Application.TimeStamp=#TimeFormat(now(), 'hh:mm:ss')# CFIF (APPLICATION.TimeStamp EQ ) OR (DateDiff(n, APPLICATION.TimeStamp, TimeFormat(NOW(), hh:mm:s)) GT 20) CFSET APPLICATION.TimeStamp = CreateTime(TimeFormat(NOW(), hh), TimeFormat(NOW(), mm), TimeFormat(NOW(), s)) cfhttp url=http://feeds.bbc.co.uk/weather/feeds/rss/5day/id/3314.xml; method=GET resolveurl=No/cfhttp CFSET APPLICATION.weather_xml =XMLParse(cfhttp.FileContent) /CFIF My weather page is head /head body cfdump var=#application.weather_xml# cfoutput img src=#application.weather_xml.rss.channel.image.url.xmlText# alt=#application.weather_xml.rss.channel.item.DESCRIPTION.xmlText# cfloop index=x from=1 to=#ArrayLen(application.weather_xml.rss.channel.item)# br #replace(application.weather_xml.rss.channel.item[x].title.xmlText, ',', 'br', 'ALL')# br /cfloop /cfoutput ~| 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:295169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Calendar
hi thanks very much for these richard ~| 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:295170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dealing with timezones
Dealing with time zones was a major PITA a recent project I did. Eventually I decided to store all dates in UTC and format them as needed for the current user. This made it much easier to deal with those dreaded daylight savings time shifts, when local time jumps around and offsets just don't cut it. (My project was CF and java, and most of the database reads were done in java. This simplified some things for me, I think.) So, I'd say you first big decision is whether to store dates in UTC or not, and if you are serious about trying to make local time feel right to any user then I'd say UTC is the way to do. Either way you decide, you will probably be frustrated at some point by something that should be easy but isn't. Thanks Mark -Original Message- From: Mik Muller [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 19, 2007 3:56 PM To: CF-Talk Subject: dealing with timezones Hey, So I'm thinking of how to deal with timezones. My server's clock is set to US west coast time, and I serve many, many sites that are all in different timezones. They're all running the same code which subscribes (in a fashion) to a central application to verify the site's status. I'm thinking of doing a sr on now() and replacing it with noww(), which would be a UDF that would create the effective local time for that site based upon (1) the server local time and (2) the site offset from that local time. Any crazy red flags anyone can think of? Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| 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:295171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dynamic ID's
Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic ID's
If someone has a better idea for a unique ID, I'm open to suggestions. Well, if the id is for records in a table, how about using an auto counter field? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic ID's
If you need an absolute unique id that isn't tied to a database, feel free to use the createUUID() function. Otherwise, what you're asking for can be done via SQL... so... not sure why this is overcomplicated. Do you have a unique situation? care to explain? On Dec 20, 2007 9:23 AM, Rick Sanders [EMAIL PROTECTED] wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic ID's
What exactly are you trying to do? 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 . -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 9:23 AM To: CF-Talk Subject: Dynamic ID's Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic ID's
Your db platform doesn't support autonumber? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Rick Sanders wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic ID's
cfquery declare @newid int select @newid = max(id) from Members if @newid is null begin set @newid=1 end else begin set @[EMAIL PROTECTED] end INSERT INTO Members ... /CFQUERY On 12/20/07 9:23 AM, Rick Sanders [EMAIL PROTECTED] wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dynamic ID's
I know of someone who uses a Sequence table for the ID functions: Sequence table: table_name (varchar) last_sequence (int) next_sequence (int) Query the table based on table name get the next_sequence and then update The sequence table after the insert -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 9:23 AM To: CF-Talk Subject: Dynamic ID's Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dynamic ID's
The database does support autonumber, but this is a legacy app and database. Also, there are many times where autonumber isn't useful because when you delete a record, the database re-numbers everything changing the ID which we didn't want. Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: December-20-07 10:31 AM To: CF-Talk Subject: Re: Dynamic ID's Your db platform doesn't support autonumber? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Rick Sanders wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic ID's
I'd let the database create the number. But anyway, you can do it like this: cfquery name=getnumbers datasource=#variables.dsn# SELECT max(tableID) as Lastnumber from tablename /cfquery cfset newID = getNumbers.Lastnumber + 1 / I have functions where i do this, but generally you'd be best to let the databaes do it for you. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 12/21/07, Cutter (CFRelated) [EMAIL PROTECTED] wrote: Your db platform doesn't support autonumber? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Rick Sanders wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic ID's
How about an Identity field (in MS SQL) Or alternatively CreateUUID() ? On 20/12/2007, Rick Sanders [EMAIL PROTECTED] wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dynamic ID's
Hey guys, Yup, this is a unique situation, it's a new application on top of an old database built in Pervasive SQL. The Primary key holds ID numbers that aren't auto generated. The legacy app that sat on top of it was Tango 2000, and the way the ID was done was by querying the database, sorting the ID's in the resultset in numeric order, grabbing the last ID number and adding 1 to it. This actually worked very well. Kind regards, Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: December-20-07 10:31 AM To: CF-Talk Subject: Re: Dynamic ID's If you need an absolute unique id that isn't tied to a database, feel free to use the createUUID() function. Otherwise, what you're asking for can be done via SQL... so... not sure why this is overcomplicated. Do you have a unique situation? care to explain? On Dec 20, 2007 9:23 AM, Rick Sanders [EMAIL PROTECTED] wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic ID's
Or, if you really need to do it the way you describe, the SQL could look like this: -- SELECT A NEW ID SELECT Max(idField) + 1 FROM myTable But yeh, if you can set an auto id in the db I'd go with that. Dominic On 20/12/2007, JediHomer [EMAIL PROTECTED] wrote: How about an Identity field (in MS SQL) Or alternatively CreateUUID() ? On 20/12/2007, Rick Sanders [EMAIL PROTECTED] wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: memory issues
CFFILE reads the entire file into memory before acting on it. Even appending to the file requires it be read into memory first. That's where your memory usage is likely coming from -- though not sure why it's not being freed in a timely manner. Chris On Dec 17, 2007, at 7:58 PM, Jonathon Stierman [EMAIL PROTECTED] wrote: An application of mine has recently been acting up -- memory has been shooting up at a fairly rapid pace this past week, and I'm at my wits end! Can't seem to find any way to fix it. Here's the symptoms: After rebooting the CF service, memory starts out at about 60mb for the jrun.exe process. After that all hell breaks loose ;) It continues to consume about 4 megs a minute until it plateau's at about 590mb. At that point, the server starts delivering 500 null errors, and my application/exception.log files fill up with java.lang.OutOfMemoryError messages. ...each one has to read a text file that is between 200k and 5 megs, and that seems to correlate with the memory jumps -- but why wouldn't that memory be released after the request is complete? It just keeps piling up. Is this to be expected from high volumes of file-reading/parsing requests? ~| 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:295184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfquery order by question
You need to set the sortORD for the remaining values to greater than the last important item for that query. If you had 3 item that were important, you would need to set the sortORD to 4 for the rest of the items, that would allow the secondary sort to actually sort. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 19, 2007 12:44 PM To: CF-Talk Subject: cfquery order by question i have an adin form that allows a client to specify the sort order of a returned collection of results. Easy enough, but I've run into a slight snag... Here's the basic query... cfquery name=sortCARDS Select name, amount, date FROM COLLECTIONS WHERE collection_id = '#url.colID#' ORDER BY sortORD ASC cfif IsDefined(getPAGE.sortMETH) AND #getPAGE.sortMETH# NEQ ,#getPAGE.sortMETH# /cfif /cfquery #getPAGE.sortMETH# allows you to sort by name, amount, or date - ascending or descending - if you define that. sortORD is a field in the table itself where you can specify a specific order outside the sortMETH above by putting in 1, 2, 3 OK, the problem: 1. let's say there's 15 returned records 2. I've entered name asc as my sortMETH 3. I've got three specific records I want FIRST, outside the alpha sort, so I enter 1, 2, 3 in the sortORD fields too. It will sort by sortORD like it's supposed to, but it returns those LAST in the recordset after the alpha sort. If I don't define a sortMETH - it will place all records with NO sortORD *first*, THEN the ones with sortORD defined. How do I get my numberic sort fields to take priority and come up first without maybe having TWO queries defined and two output blocks? TIA! ~| 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:295185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic ID's
The database does support autonumber, What database is it? there are many times where autonumber isn't useful because when you delete a record, the database re-numbers everything Really? I've never seen such a database that re-numbers auto numbers. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SQL Full-Text Searching
CF8 and MS SQL 2000 I would like to implement Google-esque searching on our Intranet against our database. To do this I enabled Full-Text on the table I want to search (customers) and use a query like this: SELECT * FROM Customer where CONTAINS (*, ' search ') This works somewhat but one problem I am having is that: John Doe will not locate a record where firstname=John and lastname=Doe. It does find [EMAIL PROTECTED] however. Both behaviors I find odd. Does anyone know either how to correct the inability to find that record or a better way of doing this all together? BTW, we will be upgrading to MS SQL 2008 in a few months, maybe that has some built in capability that will make this easy? ~| 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:295186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFGRID in CFWINDOW behind CFLAYOUT
Has anyone had problems using cflayout/cfwindow/cfgrid together? Everything loads fine, but I have a cfgrid in a cfwindow off of a page using cflayout. When you drag the window up into the browser, the cfgrid in the popup gets hidden behind the cflayout. It will work if you use html format for the cfgrid but makes it clunky, especially when you are querying a table with thousands of records in the cfgrid. Any ideas?? Thanks, Chad ~| 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:295188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFGRID in CFWINDOW behind CFLAYOUT
I have this trouble with any flash object. The flash object always stays in front of my CFWINDOW. Are you using a flash grid? -Original Message- From: Chad Baloga [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 7:07 AM To: CF-Talk Subject: CFGRID in CFWINDOW behind CFLAYOUT Has anyone had problems using cflayout/cfwindow/cfgrid together? Everything loads fine, but I have a cfgrid in a cfwindow off of a page using cflayout. When you drag the window up into the browser, the cfgrid in the popup gets hidden behind the cflayout. It will work if you use html format for the cfgrid but makes it clunky, especially when you are querying a table with thousands of records in the cfgrid. Any ideas?? Thanks, Chad ~| 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:295189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Best way to do this...
Here is the situation: There is a conference in March. The customer wants to have an application where when the registrants come in they can immediately print out their information, tickets to events (maybe up to 5 events at the most) and their ID tag (name and logo) First of all we need to have a printer that can handle a huge load (most likely 3,000 registrants a night) and of course the logos have to be in color (ugh!) We are trying to figure out the best way to have the layout. I have never done a conference like this before. If anyone has and has any advice for me that would be great. I am sure more information is needed but I wanted to get the general idea of what I was looking for. Thanks in advance for any advice/recommendations. Lori ~| 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:295190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFGRID in CFWINDOW behind CFLAYOUT
In my case, the flash formatted cfgrid which is in a popup cfwindow, goes behind the cflayout on the main browser window when dragged around ~| 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:295191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic ID's
Yup, this is a unique situation, it's a new application on top of an old database built in Pervasive SQL. The Primary key holds ID numbers that aren't auto generated. I think I see the situation and you're approach is valid but long winded ;). You can insert a record with a new ID with one SQL statement (and select the ID, should you need it, with another). Lets say your table has two columns, ID(int) and Title(varchar 50): cfquery name=qry_newThing datasource=#request.dsn# INSERT INTO thing (ID,Title) SELECT Max(ID) + 1, cfqueryparam cfsqltype=cf_sql_varchar value=#newTitle# maxlength=50 FROM thing !--- then select the id for reference if you like --- SELECT Max(ID) as ID FROM thing /cfquery !--- redundant line of code but you get the point: --- cfset myNewThingID = qry_newThing.ID 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:295192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Full-Text Searching
I think it indexes individual columns only, and treats them as separate fields... It does not combine column1 with column2, so firstname=john, lastname=doe will not match john doe, but [EMAIL PROTECTED] will match. Apparently (with SQL 2000 anyway) you cannot index computed columns (first name + last name) so you may be stuck unless you create a real column with both fields combined (or a row in a different table where all of the fields are combined). I have read that SQL 2008 will have a different interface to full text searching (at least, for defining full text indexes) but I don't know if the capabilities will be different. Thanks Mark -Original Message- From: Dustin M. Snell [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 10:10 AM To: CF-Talk Subject: OT: SQL Full-Text Searching CF8 and MS SQL 2000 I would like to implement Google-esque searching on our Intranet against our database. To do this I enabled Full-Text on the table I want to search (customers) and use a query like this: SELECT * FROM Customer where CONTAINS (*, ' search ') This works somewhat but one problem I am having is that: John Doe will not locate a record where firstname=John and lastname=Doe. It does find [EMAIL PROTECTED] however. Both behaviors I find odd. Does anyone know either how to correct the inability to find that record or a better way of doing this all together? BTW, we will be upgrading to MS SQL 2008 in a few months, maybe that has some built in capability that will make this easy? ~| 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:295193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dealing with timezones
True, but willing to take the risk. I actually just had one of our systems adjusted for timezone differences and need to see how he went about it. I know he used the Oracle TZ table and some pointers or data from that table stored in one of the applications tables so that queries could then adjust the time as needed. As a rule we do not use CF(or the Java it is running on) for TZ adjustments. We already have time problems with our CF7 boxes because the JVM that adjusts for the TZ changes in the past 1-2 years conflicts with our LDAPS cert which forces us to run on an older JVM. On Dec 19, 2007 9:07 PM, Paul Hastings [EMAIL PROTECTED] wrote: Aaron Rouse wrote: Another problem might be if time zone rules change for one area vs another, didn't this happen recently(past year or so) stateside? We store the time it happens *all* the time someplace in the world. see: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=A2FD1153-20ED-7DEE-2AF4254F9675C7B9 http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=1D291D83-20ED-7DEE-2AF9BB636B9B253C http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=F7FB9896-20ED-7DEE-2A48EE57400DFEDD in GMT and store the offsite needed for the location the users are at. that's a good idea but depending on the tz you need to cast to you could end up in timezone hell: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77 ~| 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:295194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic ID's
Beware of doing it this way... You will need cftransaction or some other way of ensuring that the ID is unique. Consider the situation where 2 inserts from 2 different people are happening nearly simultaneously. The second request for the max(ID) could occur before the first is inserted -mark -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 8:47 AM To: CF-Talk Subject: Re: Dynamic ID's I'd let the database create the number. But anyway, you can do it like this: cfquery name=getnumbers datasource=#variables.dsn# SELECT max(tableID) as Lastnumber from tablename /cfquery cfset newID = getNumbers.Lastnumber + 1 / I have functions where i do this, but generally you'd be best to let the databaes do it for you. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 12/21/07, Cutter (CFRelated) [EMAIL PROTECTED] wrote: Your db platform doesn't support autonumber? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Rick Sanders wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dealing with timezones
Gaulin, Mark wrote: dreaded daylight savings time shifts, when local time jumps around and offsets just don't cut it. (My project was CF and java, and most of the why would using offsets not work w/DST changes? if your server's tz isn't UTC then storing datetimes as epoch offsets is probably the best choice. database reads were done in java. This simplified some things for me, I think.) cf doesn't know anything about timezones, it uses the server's. if you cast your datetimes to UTC the server tz isn't UTC it implements DST then for datetimes on the cusp of DST those datetimes will *always* be wrong. ~| 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:295197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JREE Servers (was Session Management - sticky sessions)
Interesting. Updater 7, huh? Isn't it about time for JRun 5? :) ~Brad -Original Message- From: Matthew Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 19, 2007 9:22 PM To: CF-Talk Subject: Re: JREE Servers (was Session Management - sticky sessions) But wait! Adobe just released updater 7 for JRun 4. It's supposed to have vastly improved on the clustering interfacing by reducing a bunch of the overhead. I'm slated to test this on my shared servers for this coming year. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| 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:295198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic ID's
Rick, Autonumber doesn't re-number existing ids (does it??) ... Although it does mean that the numbers are not tightly sequential (there will be gaps). -mark -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 8:47 AM To: CF-Talk Subject: RE: Dynamic ID's The database does support autonumber, but this is a legacy app and database. Also, there are many times where autonumber isn't useful because when you delete a record, the database re-numbers everything changing the ID which we didn't want. Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: December-20-07 10:31 AM To: CF-Talk Subject: Re: Dynamic ID's Your db platform doesn't support autonumber? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Rick Sanders wrote: Hello list, I've done dynamic ID's before in .net and xml. I can't seem to figure out how to do it in CF. Here's what I want to do: - Query the database with the ID's. - Sort the ID's in proper numerical order - Grab the last ID (largest number which will be the last row of the query) - Then, add 1 to the number If someone has a better idea for a unique ID, I'm open to suggestions. Happy Holidays! Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.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:295196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
pop an alert when trying to leave a page
I would like to have a user fill out a form. So say they start filling it out and decided they want to leave with out submitting the form. Is there any way to pop a javascript alert saying something like please fill out the form or call this phone number?? ~| 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:295199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Calendar
http://calendar.viviotech.net/ Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Rob Parkhill wrote: Richard, http://www.cfkalendar.com/ or http://calendarinfusion.riaforge.org/ are two that I found. Can't say that I have used either of them, but you can look into them. Rob ~| 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:295200 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: pop an alert when trying to leave a page
pop up an alert on the onunload event if the form isn't filled out properly? http://www.w3schools.com/jsref/jsref_onunload.asp On Dec 20, 2007 9:19 AM, Chad Gray [EMAIL PROTECTED] wrote: I would like to have a user fill out a form. So say they start filling it out and decided they want to leave with out submitting the form. Is there any way to pop a javascript alert saying something like please fill out the form or call this phone number?? ~| 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:295201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dealing with timezones
Aaron Rouse wrote: True, but willing to take the risk. if cf touches any of your datetimes along the way, then you've fallen into tz hell. if your servers are in tz that implement DST scan your cf touched UTC datetimes you won't find *any* on the cusp of DST, they were all rolled into DST. it won't matter that you're converting to UTC, cf doesn't know about any tz except the server's. I actually just had one of our systems adjusted for timezone differences and need to see how he went about it. I know he used the Oracle TZ table and whether that's a good idea depends on what tz you need whether oracle is on top of things. As a rule we do not use CF(or the Java it is running on) for TZ adjustments. We already have time problems with our CF7 boxes because the core java icu4j (ibm) are usually on top of this sort of stuff. java/i18n folks are are very picky about tz, fist fights often break out ;-) JVM that adjusts for the TZ changes in the past 1-2 years conflicts with our LDAPS cert which forces us to run on an older JVM. um, i'd try to fix that ;-) ~| 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:295202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dealing with timezones
Trust me, the JVM issue has had a lot of man hours invested in trying to fix it and the only solution found was to go to CF8 and that was just more fuel to the people pushing to trashcan CF completely and go to .NET Actually in all reality I do not see us needing to worry about it much since I believe any of our apps that need to worry about this will end up getting retired in less than a years time as Exchange, SharePoint and a whole slew of other MS products are pushed out and CF is trashcanned as quickly as the IT Architects can make it happen. All CF does is display a character from the database, it has no clue that the character is a date/time within that string. CF does collect a time in the form of HH:MI DD-MMM- but it never considers anything in regards to TZ's because really the application does not care about that at all. all of the business logic around the TZ's is done in the database. The database sees what physical location is dealing with a record insert/update and the database looks at its mapping between a physical location and its TZ system tables and then it deals with any manipulation/calculations that need to be done from there. Since Oracle runs on top of Java, I'd imagine they too are on top of things. The nice thing about us relying on Oracle and not CF is we know CF has issues due to conflicts outside of its control, the Oracle boxes have yet to present a problem and if they did I have far greater confidence in the people administering those boxes vs the whoever the contractor is this week for the CF boxes. On Dec 20, 2007 11:36 AM, Paul Hastings [EMAIL PROTECTED] wrote: Aaron Rouse wrote: True, but willing to take the risk. if cf touches any of your datetimes along the way, then you've fallen into tz hell. if your servers are in tz that implement DST scan your cf touched UTC datetimes you won't find *any* on the cusp of DST, they were all rolled into DST. it won't matter that you're converting to UTC, cf doesn't know about any tz except the server's. I actually just had one of our systems adjusted for timezone differences and need to see how he went about it. I know he used the Oracle TZ table and whether that's a good idea depends on what tz you need whether oracle is on top of things. As a rule we do not use CF(or the Java it is running on) for TZ adjustments. We already have time problems with our CF7 boxes because the core java icu4j (ibm) are usually on top of this sort of stuff. java/i18n folks are are very picky about tz, fist fights often break out ;-) JVM that adjusts for the TZ changes in the past 1-2 years conflicts with our LDAPS cert which forces us to run on an older JVM. um, i'd try to fix that ;-) ~| 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:295203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic ID's
Beware of doing it this way... You will need cftransaction or some other way of ensuring that the ID is unique. Consider the situation where 2 inserts from 2 different people are happening nearly simultaneously. The second request for the max(ID) could occur before the first is inserted Is that definately true with the select insert as I exampled? I imagine (but that is all I do, quite willing to be wrong) that the single SQL statement must complete before another is allowed to run..? I.e. I imagine that this SQL will not run into the problem you describe: INSERT INTO myTable (id, title) SELECT Max(id) + 1, 'Some title' FROM myTable Cheers, 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:295204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Another RegEx question...
In a sea of data, I need to pull the first image tag. It looks like this... img src=http://images.craigslist.org/01010001150701030720071219cd6f3ea36b5b712d 2f00d0d9.jpg I am using... cfset imageLink = REReplaceNoCase(cfhttp.fileContent, img[^]+([a-z0-9_]\.(?:jpg|jpeg|gif|png))[^]*, , ONE) But it does not work. Can anyone help? Thanks, Che ~| 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:295205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another RegEx question...
listLast(URL,'/') ? You're just complicating something simple with Regex here in this case. On Dec 20, 2007 2:55 PM, Che Vilnonis [EMAIL PROTECTED] wrote: In a sea of data, I need to pull the first image tag. It looks like this... img src= http://images.craigslist.org/01010001150701030720071219cd6f3ea36b5b712d 2f00d0d9.jpg I am using... cfset imageLink = REReplaceNoCase(cfhttp.fileContent, img[^]+([a-z0-9_]\.(?:jpg|jpeg|gif|png))[^]*, , ONE) But it does not work. Can anyone help? Thanks, Che ~| 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:295206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Another RegEx question...
Todd, not sure that that would work. If you look at my code, I am cfhttp-ing a page and searching for the first image tag. I simply gave an example of the format of the img src in the returned HTML. RegEx would be best for that, right? -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 2:58 PM To: CF-Talk Subject: Re: Another RegEx question... listLast(URL,'/') ? You're just complicating something simple with Regex here in this case. On Dec 20, 2007 2:55 PM, Che Vilnonis [EMAIL PROTECTED] wrote: In a sea of data, I need to pull the first image tag. It looks like this... img src= http://images.craigslist.org/01010001150701030720071219cd6f3ea36b5b712 d 2f00d0d9.jpg I am using... cfset imageLink = REReplaceNoCase(cfhttp.fileContent, img[^]+([a-z0-9_]\.(?:jpg|jpeg|gif|png))[^]*, , ONE) But it does not work. Can anyone help? Thanks, Che ~| 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:295207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another RegEx question...
The first thing I see is that you are only allowing for single-character names. You don't have a + or * (+ would be better) after [a-z0-9_]. There may be more, but that's what I see at first glance. --Ben Doom Che Vilnonis wrote: In a sea of data, I need to pull the first image tag. It looks like this... img src=http://images.craigslist.org/01010001150701030720071219cd6f3ea36b5b712d 2f00d0d9.jpg I am using... cfset imageLink = REReplaceNoCase(cfhttp.fileContent, img[^]+(\.(?:jpg|jpeg|gif|png))[^]*, , ONE) But it does not work. Can anyone help? Thanks, Che ~| 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:295208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JREE Servers (was Session Management - sticky sessions)
Interesting. Updater 7, huh? Isn't it about time for JRun 5? :) ~Brad You'd think. However, JRun is dead as an independent platform. From hence force forward, no new updates unless CF requires it. Not many care, however ;). Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| 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:295209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another RegEx question...
I think you need ReFindNoCase, otherwise it will return empty string. -- Josh - Original Message - From: Todd [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 20, 2007 11:58 AM Subject: Re: Another RegEx question... listLast(URL,'/') ? You're just complicating something simple with Regex here in this case. On Dec 20, 2007 2:55 PM, Che Vilnonis [EMAIL PROTECTED] wrote: In a sea of data, I need to pull the first image tag. It looks like this... img src= http://images.craigslist.org/01010001150701030720071219cd6f3ea36b5b712d 2f00d0d9.jpg I am using... cfset imageLink = REReplaceNoCase(cfhttp.fileContent, img[^]+([a-z0-9_]\.(?:jpg|jpeg|gif|png))[^]*, , ONE) But it does not work. Can anyone help? Thanks, Che ~| 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:295210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: JREE Servers (was Session Management - sticky sessions)
You'd think. However, JRun is dead as an independent platform. From hence force forward, no new updates unless CF requires it. Not many care, however ;). I see. There never seems to be an over-abundance of people on the list willing to answer questions about JRun, let along other J2EE servers. Maybe that is because most people are using single-instance installs and don't know/care about the man behind the Java curtain. Can I get a show of hands (off-list probably) from people out there using any JRE other than JRUN? Sometimes I think Dave W, Sean, and Jochem are the only people with experience in that realm. (And their help is always much appreciated!) Heck, raise your hand if you use JRun in Multi-Server mode too. One thing I don't want to do is move to another J2EE platform because it think it has more features and then find myself all alone. :) Thanks. ~Brad ~| 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:295211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another RegEx question...
I am cfhttp-ing a page and searching for the first image tag. This is a job for CF_REextract : http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm You can even test it on line : 1) set INPUTMODE = to http 2) go to http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm 3) enter src= in RE1 4) enter in RE2 5) set EXTRACT = to first 6) enter the address of your page in the URL field click on Test, ... et voilà ! -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Another RegEx question...
Claude, that brings back the javascript script tag. Neat custom tag, I just want the RegEx though. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 3:36 PM To: CF-Talk Subject: Re: Another RegEx question... I am cfhttp-ing a page and searching for the first image tag. This is a job for CF_REextract : http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm You can even test it on line : 1) set INPUTMODE = to http 2) go to http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm 3) enter src= in RE1 4) enter in RE2 5) set EXTRACT = to first 6) enter the address of your page in the URL field click on Test, ... et voilà ! -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: COM Object Method Not Found (Cybersource)
For anyone still reading this thread, I downloaded the java API from cybersource's site, extracted it and there is a coldfusion folder in there. If you view the readme file it has a section about configuring coldfusion and what class paths to add to the java.config file. I couldn't get CF to restart when manually modifying the java.config file like it instructed so I instead entered the class paths into the CF Administrator (Java and JVM page) and then I could restart CF. Then you just go through the steps of generating your key, putting that into the keys directory, enter your merchantID into the cybs.properties file and put the dir path to your key file and your done. Works beautifully and saved me tons of time. Tech support said that they just implemented the coldfusion piece so thats why it is no where to be found in their documentation or site. Any resolution on this? I am trying to connect ColdFusion to Cybersource. http://www.fusiontap.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:295214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: COM Object Method Not Found (Cybersource)
For anyone still reading this thread, I downloaded the java API from cybersource's site, extracted it and there is a coldfusion folder in there. If you view the readme file it has a section about configuring coldfusion and what class paths to add to the java.config file. I couldn't get CF to restart when manually modifying the java.config file like it instructed so I instead entered the class paths into the CF Administrator (Java and JVM page) and then I could restart CF. Then you just go through the steps of generating your key, putting that into the keys directory, enter your merchantID into the cybs.properties file and put the dir path to your key file and your done. Works beautifully and saved me tons of time. Tech support said that they just implemented the coldfusion piece so thats why it is no where to be found in their documentation or site. Any resolution on this? I am trying to connect ColdFusion to Cybersource. Joe, 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:295215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JREE Servers (was Session Management - sticky sessions)
+1 for Mutli-Instance on JRun ~| 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:295216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic ID's
Dominic, Not really... Databases do a lot of things concurrently. The statement below should be safe, but locking, and other issues on a very busy database could cause deadlocks if 2 simultaneous processes are trying to update the same row. Having said that, I suspect that the identity or autonumber field is doing something quite similar to this under the hood. Perhaps Jochem or one of the other super SQL guru's could tell us more :) -Mark -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 1:37 PM To: CF-Talk Subject: Re: Dynamic ID's Beware of doing it this way... You will need cftransaction or some other way of ensuring that the ID is unique. Consider the situation where 2 inserts from 2 different people are happening nearly simultaneously. The second request for the max(ID) could occur before the first is inserted Is that definately true with the select insert as I exampled? I imagine (but that is all I do, quite willing to be wrong) that the single SQL statement must complete before another is allowed to run..? I.e. I imagine that this SQL will not run into the problem you describe: INSERT INTO myTable (id, title) SELECT Max(id) + 1, 'Some title' FROM myTable Cheers, 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:295217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JREE Servers (was Session Management - sticky sessions)
+1 for Mutli-Instance on JRun Here as well. Also running clustering. Matthew Williams ~| 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:295218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another RegEx question...
Claude, that brings back the javascript script tag Ah ok, then you have to include the img tag in the RE1 expression. I just want the RegEx though. I wrote this tag because it is sometimes much easier to find what's between two very simple expressions than to describe what you want in only one more complicated expression, and I was tired of designing complex expressions. So now, do not count on me to do it for others ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
getAdminHash was not found
I got this error when I used the administrator to clear the cache. This is on the server at work which was a clean install (ver 7.0.2) The cferror information is as follows: Diagnostics: The selected method getAdminHash was not found. Either there are no methods with the specified method name and argument types, or the method getAdminHash is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. The error occurred on line 263. Template:/CFIDE/administrator/index.cfm Any idea of what causes this? BTW I did not set up the server so I don't have all details on particulars.. but it is running on a virtual box.. I have tried to recreate it in my dev machine at work and at home but have not been able so hard to track down the cause. Any ideas? TIA Mark Holm ~| 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:295220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JREE Servers (was Session Management - sticky sessions)
We use clustered CF servers, most sitting behind F5 switches. We do sticky sessions with Jboss and WebSphere and have session replication with WebSphere. Not being an admin I like jboss as websphere is not easy to admin for a non admin type, its also expensive and heavy. You might note though that as far as I recall Jboss is only offically supported in non-cluster, if I recall this is more due to a lack of testing rather than a statement that it doesn't work. In Feburary we are migrating all our servers to WebSphere, mainly for a cost advantage over Red Hat's support price hike on Jboss. I'm still a huge Jboss fan as Websphere does not supply a good development environment, unless you use WASD ($$ and bloated). The community edition of Websphere is completely different technology so do not think you can deploy to that locally and have the same results in production. For CF development I wouldn't expect it to be an issue but if you are doing Java development as well the Websphere Community edition is no good, for now you are just as well of developing on Jboss. If anyone ever has questions about CF on Websphere or Jboss I'm always happy to help, I'm a big fan of developing on jboss + CF. Adam Haskell On Dec 20, 2007 3:26 PM, Brad Wood [EMAIL PROTECTED] wrote: You'd think. However, JRun is dead as an independent platform. From hence force forward, no new updates unless CF requires it. Not many care, however ;). I see. There never seems to be an over-abundance of people on the list willing to answer questions about JRun, let along other J2EE servers. Maybe that is because most people are using single-instance installs and don't know/care about the man behind the Java curtain. Can I get a show of hands (off-list probably) from people out there using any JRE other than JRUN? Sometimes I think Dave W, Sean, and Jochem are the only people with experience in that realm. (And their help is always much appreciated!) Heck, raise your hand if you use JRun in Multi-Server mode too. One thing I don't want to do is move to another J2EE platform because it think it has more features and then find myself all alone. :) Thanks. ~Brad ~| 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:295221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Session Management - sticky sessions
I'm not a sys admin so I might be off here but couldn't you get around this with a switch that ensures requests coming off a certain server gets routed properly? Adam Haskell On Dec 19, 2007 6:18 PM, Jochem van Dieten [EMAIL PROTECTED] wrote: Sean Corfield wrote: The issue here is that if you do not have sticky session, you have to be able to manage sessions that move between servers at will. That means that either: 1) you use client scope instead of session scope (with all the attendant restrictions) 2) you write your own session management based on cookies 3) you rely on session replication (and, if you're not on CF8, make sure you don't put CFCs in session scope - and if you are on CF8, make sure you don't put arrays in the CFCs that are in session scope - and whatever other restrictions there are) No queries either. 4. You do not use cfimage, cfpresentation, and other tags that rely on 2 subsequent requests to be directed to the same instance. 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:295222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic ID's
cfquery declare @newid int select @newid = max(id) from Members if @newid is null Oddly enough that's actually more complicated than is necessary if you're using SQL Server -- i.e. insert into members (memberid,x,y,z) values ( (select 1+isnull(max(memberid),0) from members), valx, valy, valz ) I'm pretty certain that (or some variation) works for SQL Server... which of course is totally unnecessary on SQL Server if you're using identity columns. :) But then Rick replied later to say that he's not using an identity/autonumber capable database with his legacy app... although if the db has some equivalent of isnull() then the above might work out fairly well. In failing that, this should work: cftransaction isolation=serializable cfquery name=next datasource=blah select max(memberid) from members /cfquery cfquery datasource=blah insert into members (memberid,x,y,z) values ( cfqueryparam value=#next.memberid+1# cfsqltype=integer /, xval, yval, zval ) /cfquery /cftransaction The serializable transaction is important to ensure that there's not a race condition between when the max is retrieved and when it's inserted into the table. However I will say one other thing about this. There's another race-condition-esque problem with this strategy that may crop up. If a user deletes the record which is currently last in the database, then the next record that gets inserted will have the same id as the deleted record, which may be confusing if someone has bookmarked a page with that id in the url and/or may cause some data related to the deleted record to show up erroneously as having been associated to the new record if the application doesn't use foreign key constraints (which I personally almost always use) and doesn't do a great job of cleaning up the data in those related tables when a record is deleted. This may or may not be a big concern for you, given that it's a legacy application and it may not have a huge user database and the likelyhood of these things happening (or being problematic) may not be very high. However if you want to avoid that situation, what I would recommend is as at least one other guy on the list mentioned, creating a second table just to hold the new id's. The very simple table would just contain two columns - tablename varchar(x) currentidentity int - and instead of select max(memberid) from members, you would use select currentidentity from [identitytable] where tablename = 'members' (or whatever your table is). You would also need to add a 3rd query in your transaction between the 2 above to insert or update that row of the identity table, i.e. cfquery dsn=blah cfif val(next.identity) update [identitytable] set currentidentity = currentidentity+1 where tablename = 'members' cfelse insert into [identitytable] (tablename,currentidentity) values ('members',1) /cfif /cfquery Although this does involved 3 queries instead of 2, its performance won't change as the size of the database grows (as opposed to max() getting slower as the table gets larger, which, with a legacy app is probably not a real big issue). If you end up doing this sort of thing for several tables you may want to create a CFC to abstract this so you don't have so much duplicated or copy/pasted code. hth, ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.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:295223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic ID's
The database does support autonumber, but this is a legacy app and database. Also, there are many times where autonumber isn't useful because when you delete a record, the database re-numbers everything changing the ID which we didn't want. Oh I misread that the first time... I thought you'd said it didn't support autonumbers. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.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:295224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dealing with timezones
As a rule we do not use CF(or the Java it is running on) for TZ adjustments. We already have time problems with our CF7 boxes because the JVM that adjusts for the TZ changes in the past 1-2 years conflicts with our LDAPS cert which forces us to run on an older JVM. Boy unless I'm really confused, it sure sounds like it'd be a lot easier for somebody to just spring the $50 for a better cert. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.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:295225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic ID's
Beware of doing it this way... You will need cftransaction or some other way of ensuring that the ID is unique. Consider the situation where 2 inserts from 2 different people are happening nearly simultaneously. The second request for the max(ID) could occur before the first is inserted ARGH! Why can't anyone design a *good* email client? They all suck! Is that definately true with the select insert as I exampled? I imagine (but that is all I do, quite willing to be wrong) that the single SQL statement must complete before another is allowed to run..? I.e. I imagine that this SQL will not run into the problem you describe: INSERT INTO myTable (id, title) SELECT Max(id) + 1, 'Some title' FROM myTable As far as I know, at least with SQL Server that's true, the server snapshots the environment, executes the query and then moves forward, so in theory, this single-query approach wouldn't have the race condition. I would expect that also to be true of Oracle, although I don't know for certain. MySQL I honestly would say it's up in the air -- I know MySQL does a lot of things rather differently than other databases, like allowing you to specify a different engine for each table, which I believe was a large part of the reason why it took them so gosh darned LNNN to add support for views. Similarly, their table names were at one time case-sensitive or could be (which was non-standard behavior). That being the case, I don't like to make any claims about what I expect MySQL to do. :P And similar with any other databases, most of which I've had no exposure to. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.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:295226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another RegEx question...
cfset imageLink = REReplaceNoCase(cfhttp.fileContent, img[^]+([a-z0-9_]\.(?:jpg|jpeg|gif|png))[^]*, , ONE) In addition to Ben's comment, it doesn't look like you're finding the beginning of the src attribute, see: img[^]+ and then straight into the regex for the url ... so there's no mention of src= ... there's also no allowance for the protocol (https?://) and the : in (?:jpg| seems erroneous... I might suggest a slightly different tac ... instead of trying to get it with one expression, how about this? cfset img = rereplacenocase(cfhttp.filecontent, ^.*?(img[^]+).*$,\1) cfset img = rereplace(img,[^/],/) cfset img = xmlparse(img) / cfset img = img.img.xmlAttributes.src Usually an image tag doesn't contain any characters that aren't xml safe, since it's just got the src (no url parameters usually), class, style and potentially an alt or title tag. It's really the alt or title tag that might potentially have non-xml safe characters, but still not very often. The 2nd rereplace checks to see if the image has an xml closing and if not then it closes it so that the xmlparse() will work properly. Of course, if you don't want to do the xml thing, once you have the tag by itself, then it's a lot easier to just get the src attribute via regex,i.e. cfset img = rereplace(img,^.*src=([^]+).*$,\1) Although that runs some other potential risks of getting content from a site that's using xml where the author used single-quotes instead of doublequotes (minor change to the above regex I admit). I'm just saying, 6 of 1, 1/2-doz of the other there are a number of potential points of failure either way. hth, ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.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:295227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to do this...
Boy I wish I had any advice to offer... mostly 'cause I've noticed that it seems like you haven't had any response to this question... I suspect folks are in general just kinda stumped at what advice to offer, like I am. I've never done anything for a conference like that -- I can offer advice about how to solve specific problems related to the insertion of those registrant records if you have specific questions, although at this point, the info I have is too vague for me to offer anything useful that anyone else wouldn't recommend... essentially use best practices would be the advice at this point... heh :P Sorry to be so unhelpful. Glad to help with more specific questions if you have them tho. ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.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:295228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best way to do this...
What type of advice are you looking for, software layout (architecture) , UI layout, Physical layout? I think that would help me understand you question better. Adam On Dec 20, 2007 10:22 AM, Lori Stone [EMAIL PROTECTED] wrote: Here is the situation: There is a conference in March. The customer wants to have an application where when the registrants come in they can immediately print out their information, tickets to events (maybe up to 5 events at the most) and their ID tag (name and logo) First of all we need to have a printer that can handle a huge load (most likely 3,000 registrants a night) and of course the logos have to be in color (ugh!) We are trying to figure out the best way to have the layout. I have never done a conference like this before. If anyone has and has any advice for me that would be great. I am sure more information is needed but I wanted to get the general idea of what I was looking for. Thanks in advance for any advice/recommendations. Lori ~| 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:295229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to do this...
Lori, Here's my thoughts on your problem: 1) Have the static elements of the tickets and ID's printed professionally by a printer on blanks - it will be much cheaper than paying for ink outright. It will also take less time to print. Maybe a perforated blank with the ticket on once side and the badge on the other.I know this is what SXSW does, for example. 2) When the registrant arrives, send their information to the printer where the blanks are pre-loaded and print their personal information, logo, and picture out on the blank. A separate color logo (which I am assuming is what you mean) throws a wrench into the whole deal, because it means the printer hardware is much more costly as is the cost - per - print job. I might suggest doing a cost breakdown for the customer on color vs. greyscale logos factoring the cost of ink and hardware capable of handling both color printing and an acceptable page per minute rate for registering 3000 applicants in a single night.On an event of that scale the difference probably runs into the thousands. Another option would be to print the badges out in advance and file them and then just use blanks for the tickets where the printing will only be done in B/W. Pull the badge from the file and print the ticket out at check-in. HTH, Jon On Dec 20, 2007, at 10:22 AM, Lori Stone wrote: Here is the situation: There is a conference in March. The customer wants to have an application where when the registrants come in they can immediately print out their information, tickets to events (maybe up to 5 events at the most) and their ID tag (name and logo) First of all we need to have a printer that can handle a huge load (most likely 3,000 registrants a night) and of course the logos have to be in color (ugh!) We are trying to figure out the best way to have the layout. I have never done a conference like this before. If anyone has and has any advice for me that would be great. I am sure more information is needed but I wanted to get the general idea of what I was looking for. Thanks in advance for any advice/recommendations. Lori ~| 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:295230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Session Management - sticky sessions
Sure. The switch would do so via sticky sessions, so we're back to where we started - sticky sessions are necessary for a lot of functionality. On Dec 21, 2007 10:56 AM, Adam Haskell [EMAIL PROTECTED] wrote: I'm not a sys admin so I might be off here but couldn't you get around this with a switch that ensures requests coming off a certain server gets routed properly? Adam Haskell On Dec 19, 2007 6:18 PM, Jochem van Dieten [EMAIL PROTECTED] wrote: Sean Corfield wrote: The issue here is that if you do not have sticky session, you have to be able to manage sessions that move between servers at will. That means that either: 1) you use client scope instead of session scope (with all the attendant restrictions) 2) you write your own session management based on cookies 3) you rely on session replication (and, if you're not on CF8, make sure you don't put CFCs in session scope - and if you are on CF8, make sure you don't put arrays in the CFCs that are in session scope - and whatever other restrictions there are) No queries either. 4. You do not use cfimage, cfpresentation, and other tags that rely on 2 subsequent requests to be directed to the same instance. 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:295231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Best way to do this...
On Dec 20, 2007 10:22 AM, Lori Stone [EMAIL PROTECTED] wrote: Here is the situation: There is a conference in March. The customer wants to have an application where when the registrants come in they can immediately print out their information, tickets to events (maybe up to 5 events at the most) and their ID tag (name and logo) First of all we need to have a printer that can handle a huge load (most likely 3,000 registrants a night) and of Not for nothing, but have you done the math on that? Even if each registration only took 20 seconds it would take over 16 hours to register everybody if there were 3000 people. Sounds like you want to have SEVERAL printers. ;^) But it does lead you to a good place to start: determine your registration process and how long it will take (padding high). Multiply that by the number of people you expect - that's how long your registration time will be. You need to weigh that value against the amount of time you'll be accepting registrations (taking popular times into consideration) and determine the number of stations/printers you'll need to provide service... then add 20%. Assuming you want portable then I think most high-capacity, high-speed printers are out of the question. Consumer level printers (if there's enough of them and if there's somebody to do basic maintenance like change ink and load paper) should do fine. course the logos have to be in color (ugh!) We are trying to figure out the best way to The best bet here, if at all possible, would be to print black and white over pre-printed color stationary. The printing will be MUCH faster (and much cheaper). Cheap black and white laser (or even inkjet) printers would do fine - anything you can find today can print at least several pages per minute in BW. Printing color on the spot adds a lot of complexity to an already complex process. Think about the conferences you've been too: none of them print in color - they all print in BW over color stationary. A redundant set of cheap printers is probably going to be more reliable overall than a single monster printer. If a big printer goes down you're stopped dead but if a cheapy dies you just replace it or close that one station. You should also ask the venue - many places that support large conferences have this kind of gear already - you pay extra to lease/rent it but they tend to know their stuff. Jim Davis ~| 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:295232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Want to move into .Net?
moving this where it belongs. Jesse - with all due respect, the original poster posted an ad to a COLDFUSION list, which clearly insinuated that .NET is the better technology. What sort of response did you expect he'd get? If that particular company is looking to move to .NET, that's 100% their perogative. I understand that they are currently on CF, so they want a CF developer who will ultimately make the transition with them. That's fair. But to promote it as taking the next step professionally well again, that's their opinion and they have their right to it. But on a CF mailing list, Adam's response was 100% warranted, and I'd say the tool is the person who posted the ad originally using the tone they did. Oh, I'd say you're a tool as well for continuing to post to that thread in cf-jobs after the list owner asked you not to. On Dec 20, 2007 6:49 PM, Jesse B [EMAIL PROTECTED] wrote: Please forgive me Michael but I can't help but reply. Adrocknaphobia... you are a complete tool. If you were smart enough to know anything about .Net you would not have posted that worthless snippet of garbage. Seeings how CF is so easy for you then you should have a few days to spare to really dig into .Net and see what it's about. Microsoft provides far more support and far better dev tools to the .Net community than CF ever did or ever will. I am not a .Net programmer but I am smart enough to see what it has to offer to me as a developer. If at some point when you are not so narrow minded and have some worth while experience in both .Net and CF then and only then will you be able to make a comparison of the two that does not make you sound foolish. As far as Rapid Application Development I'll challenge your Dreamweaver/HomeSite/Eclipse/WhatEver against Visual Studio. I am pretty certain that in the right hands the latest version of VS will generate more code for more things then all of your tools together. Your inability to provide an educated comparison of CF to .Net is a pretty good indication of your severe short comings as a developer. Maybe you should have a talk with Mr Churvis, he can offer you a good comparison that may give you a different mind set. And lastly, the guy with .Net experience will have far more opportunity than yourself and also be able to earn a fair bit more money than you. Dear sir, I would love the opportunity to learn .NET! ColdFusion is just too easy and too powerful. My current employer thinks I'm lazy because I'd rather write fewer lines of code and finish my projects early. I used to take solace in the fact that as a ColdFusion developer I helped defined the Rapid Application Development movement and built some of the very first Rich Internet Applications (years before Flex and AJAX). But the recent launch of ColdFusion 8 is just too much! Now my boss is expecting me to leverage AJAX in addition to Flex and AIR, integrate with MS Exchange and .NET, build document driven applications with PDF, debug and performance tune existing applications with the built-in server monitor, generate images on the fly, etc. It's just too much! I'm tired of writing code once that can be accessed from anywhere. I want to write code that only gets deployed on Windows and only works in IE. Screw this write once, run anywhere, access from anywhere crap. It's too much power! I'm not Spiderman, I can't handle this responsibility! Sigh. It'll be great to become a .NET developer. With such a limited toolset, people won't expect much from me -Adam PS. Do they make Visual Studio for OSX? PSS. My resume is _not_ attached because ColdFusion pwns .NET! On Dec 20, 2007 4:44 PM, Sam Mandolfo [EMAIL PROTECTED] wrote: ~| 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-Jobs-Talk/message.cfm/messageid:3500 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Want to move into .Net?
So you think I am a tool, your intitled to that opinion but no where in the original post does it mention .Net is better. If anything one might gather that they are assuming a CF developer learning .Net is taking ones career to the next level. I think it's pretty safe to say that if one only knows CF that adding another language to your tool set is in fact a great benefit to that developer, hence the Next Level comment. Or maybe they feel so strongly about their company that they are stating that by joining them is taking ones career to the next level? So before you flame the original poster you might re-read the original post with a clear mind and see if you can pick up where they are emplying .Net is better. I have read it 5 times and see nothing of the sort. So as a tool I might also ask that if a client handed you a spec for an application, after reading through it would you also insinuate functionality in said application because you choose to assume the writers intentions even though the spec does not mention it? moving this where it belongs. Jesse - with all due respect, the original poster posted an ad to a COLDFUSION list, which clearly insinuated that .NET is the better technology. What sort of response did you expect he'd get? If that particular company is looking to move to .NET, that's 100% their perogative. I understand that they are currently on CF, so they want a CF developer who will ultimately make the transition with them. That's fair. But to promote it as taking the next step professionally well again, that's their opinion and they have their right to it. But on a CF mailing list, Adam's response was 100% warranted, and I'd say the tool is the person who posted the ad originally using the tone they did. Oh, I'd say you're a tool as well for continuing to post to that thread in cf-jobs after the list owner asked you not to. On Dec 20, 2007 6:49 PM, Jesse B [EMAIL PROTECTED] wrote: ~| 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-Jobs-Talk/message.cfm/messageid:3501 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Want to move into .Net?
Charlie Griefer wrote: moving this where it belongs. Jesse - with all due respect, the original poster posted an ad to a COLDFUSION list, which clearly insinuated that .NET is the better technology. What sort of response did you expect he'd get? I'd expect he'd get no responses. But on the other hand, it's not out of the realm of thought to think that there may be a few interested parties who work with both .NET and CF. Or a few who perceive that learning .NET is a good long term career move. If that particular company is looking to move to .NET, that's 100% their perogative. I understand that they are currently on CF, so they want a CF developer who will ultimately make the transition with them. That's fair. But to promote it as taking the next step professionally Learning a new technology often is a next step or a professional programmer. Right? -- Jeffry Houser, Technical Entrepreneur, Software Developer, Author, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Company: http://www.dot-com-it.com My Podcast: http://www.theflexshow.com My Blog: http://www.jeffryhouser.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-Jobs-Talk/message.cfm/messageid:3503 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Want to move into .Net?
the take the next step professionally certainly could be taken at a promotion of .NET over CF... OR as a reference to the fact that anyone who's applying to his post is taking the next step, professionally. That is, after all, what you do anytime you change employers or careers, isn't it? Adam, I've got to say I was fairly shocked by what you wrote. Not for what it said so much as because it was you who wrote it. It's not surprising where your thoughts on the matter would be, given your employer and position there, but that's also what makes the aggressiveness of your response so surprising. I love CF, I don't think anyone would ever question that, but I would never berate a company or developer for using one technology over another. Sometimes there's good reason for using what you use. Yes, even when it's not CF. When there isn't a good reason and CF would have been a better choice, that approach doesn't do anyone any good - it certainly doesn't change anyone's decision to use a technology. What's worse, this is a guy posting employment opportunities. He may be a 3rd party recruiter, a manager, an HR employee, or any number of folks who could care less whether the position is .NET or CF... they may not even know the difference between the two. Either way, attacking the job poster certainly isn't going to make the company stop using .NET. I'm not sure what you hoped to gain? I also think it's worth noting that the position was for someone who knows CF but wants to learn .NET as that's the technology being used for new development. What's wrong with posting that position on CF-Jobs? Why would any CF developer NOT want to learn another skill? I wish I had the opportunity to learn more about tons of languages besides CF - I know I try my best to do so whenever the opportunity presents itself. That's how I grow, how I stay fresh, how I continue to become more marketable. What was is Sun Tzu said? Something like Keep your friends close and your enemies closer. Knowing more about different languages also gives me a better perspective of and appreciation for ColdFusion. just my $0.02 ~Simon Simon Horwith Adobe Community Expert Adobe Certified Master Instructor http://www.horwith.com Jesse B wrote: So you think I am a tool, your intitled to that opinion but no where in the original post does it mention .Net is better. If anything one might gather that they are assuming a CF developer learning .Net is taking ones career to the next level. I think it's pretty safe to say that if one only knows CF that adding another language to your tool set is in fact a great benefit to that developer, hence the Next Level comment. Or maybe they feel so strongly about their company that they are stating that by joining them is taking ones career to the next level? So before you flame the original poster you might re-read the original post with a clear mind and see if you can pick up where they are emplying .Net is better. I have read it 5 times and see nothing of the sort. So as a tool I might also ask that if a client handed you a spec for an application, after reading through it would you also insinuate functionality in said application because you choose to assume the writers intentions even though the spec does not mention it? moving this where it belongs. Jesse - with all due respect, the original poster posted an ad to a COLDFUSION list, which clearly insinuated that .NET is the better technology. What sort of response did you expect he'd get? If that particular company is looking to move to .NET, that's 100% their perogative. I understand that they are currently on CF, so they want a CF developer who will ultimately make the transition with them. That's fair. But to promote it as taking the next step professionally well again, that's their opinion and they have their right to it. But on a CF mailing list, Adam's response was 100% warranted, and I'd say the tool is the person who posted the ad originally using the tone they did. Oh, I'd say you're a tool as well for continuing to post to that thread in cf-jobs after the list owner asked you not to. On Dec 20, 2007 6:49 PM, Jesse B [EMAIL PROTECTED] wrote: ~| 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-Jobs-Talk/message.cfm/messageid:3504 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Want to move into .Net?
Lighten up Greg. Quote Take the next step professionally and join an exceptional team. Software Engineering Services is a leading IT consulting company seeking individuals who want to come on board with a large Omaha, Nebraska client. End Quote If this guy is guilty of anything it's that he is assuming that his client is a better place to work than your current position. No where in that statement does it say .Net is better than CF nor would anyone be able to say that it assumes or insinuates that it is. So you think I am a tool, your intitled to that opinion but no where in the original post does it mention .Net is better. If anything one might gather that they are assuming a CF developer learning .Net is taking ones career to the next level. I think it's pretty safe to say that if one only knows CF that adding another language to your tool set is in fact a great benefit to that developer, hence the Next Level comment. Or maybe they feel so strongly about their company that they are stating that by joining them is taking ones career to the next level? So before you flame the original poster you might re-read the original post with a clear mind and see if you can pick up where they are emplying .Net is better. I have read it 5 times and see nothing of the sort. So as a tool I might also ask that if a client handed you a spec for an application, after reading through it would you also insinuate functionality in said application because you choose to assume the writers intentions even though the spec does not mention it? moving this where it belongs. Jesse - with all due respect, the original poster posted an ad to a COLDFUSION list, which clearly insinuated that .NET is the better technology. What sort of response did you expect he'd get? If that particular company is looking to move to .NET, that's 100% their perogative. I understand that they are currently on CF, so they want a CF developer who will ultimately make the transition with them. That's fair. But to promote it as taking the next step professionally well again, that's their opinion and they have their right to it. But on a CF mailing list, Adam's response was 100% warranted, and I'd say the tool is the person who posted the ad originally using the tone they did. Oh, I'd say you're a tool as well for continuing to post to that thread in cf-jobs after the list owner asked you not to. On Dec 20, 2007 6:49 PM, Jesse B [EMAIL PROTECTED] wrote: ~| 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-Jobs-Talk/message.cfm/messageid:3505 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Want to move into .Net?
to all: yes, i can see where the take the next step wasn't meant to imply that .NET was the next step *up* over ColdFusion. But... that's (obviously) how i originally read it. for the record, i would never in a million years tell somebody -not- to learn something new. it's all about being marketable and having more tools in your toolbelt. with that being said... if i was the original poster, i might have phrased the post a bit differently just to err on the side of caution. i took it one way (i won't say the wrong way because i still see how it can be taken either way), as did others (apparently). c'mon... would it have been so hard to have just said, Add a new tool to your tool belt? :) Charlie Griefer wrote: moving this where it belongs. Jesse - with all due respect, the original poster posted an ad to a COLDFUSION list, which clearly insinuated that .NET is the better technology. What sort of response did you expect he'd get? I'd expect he'd get no responses. But on the other hand, it's not out of the realm of thought to think that there may be a few interested parties who work with both .NET and CF. Or a few who perceive that learning .NET is a good long term career move. If that particular company is looking to move to .NET, that's 100% their perogative. I understand that they are currently on CF, so they want a CF developer who will ultimately make the transition with them. That's fair. But to promote it as taking the next step professionally Learning a new technology often is a next step or a professional programmer. Right? -- Jeffry Houser, Technical Entrepreneur, Software Developer, Author, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Company: http://www.dot-com-it.com My Podcast: http://www.theflexshow.com My Blog: http://www.jeffryhouser.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-Jobs-Talk/message.cfm/messageid:3506 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11