IS NULL VS = NULL
SQL Server - I had a situation where I needed to make sure a field was NULL. So I used WHERE the field = NULL. It didn't return any records, but it should've. So I changed it to WHERE thefield IS NULL, and it works fine. Why is this? What's the difference between = NULL and IS NULL? Thanks, Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231714 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IS NULL VS = NULL
This is expected. =NULL will never work as NULL is not a value, it isn't anything really. - and therefore it cannot be equal to anything. You always have to use IS NULL. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 09 February 2006 10:27 To: CF-Talk Subject: IS NULL VS = NULL SQL Server - I had a situation where I needed to make sure a field was NULL. So I used WHERE the field = NULL. It didn't return any records, but it should've. So I changed it to WHERE thefield IS NULL, and it works fine. Why is this? What's the difference between = NULL and IS NULL? Thanks, Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231715 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFreport problems
Hi, I was wondering if anyone could tell me what this means Report data binding error Error evaluating expression : textField_2 Source text : query.invon Te query im running is SELECT DATE_FORMAT(c.invited_on, '%Y %M %D') AS 'invitedOn', count(id) AS 'cnt' FROM delegates c WHERE c.company_id = 1 GROUP BY invitedOn In the report (created by the wizard) it references the field as 'query.invitedOn', but when I run it I get the above error. Cheers, Andy J ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231716 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: passing multiple values from the same form field
As was mentioned before, you could set parameters to make sure you have all the form fields on the action page. What is the mechanism by which you determine how many option groups are on the form? I'm assumiing it's something dynamic based on the user using the form. If it is, then I'd use whatever that same mechanism is on the action page to set your params. Or, if it's just a matter of the number of options, pass that as a hidden field and loop through it like so: cfloop from=1 to=#formCount# index=i cfif isDefined(form.option#i#) cfquery datasource=#request.dsn# INSERT cart_options (optionID, cartLineID) VALUES ('#Evaluate(form.option#i#)#', #LastID#) /cfquery /cfif /cfloop On 2/8/06, j s [EMAIL PROTECTED] wrote: I was able to figure out how to do the multi insert. Here are the steps I took. To make sure the form values where passed I setup an actionpage.cfminstead of going directly to a cfc. On the top of the page I added cfdump var=#form# label=Form variables /. Once I knew extactly what formfields where passed I created a variable to hold the number of mulitple fields for insert. cfset formCount = ListLen('#FORM.FieldNames#', ,) !--- minus hidden and other fields that are not part of the multi insert -- cfset formCount = formCount - 4 !--- Query to insert into the fist table. These values are not part of the multi insert. --- cftransaction cfquery datasource=#request.dsn# INSERT INTO cart (cart_custcart_ID, productID, qty, cart_dateadded) VALUES ('#Client.CartID#',#FORM.productid# ,#FORM.qty# ,#CreateODBCDateTime(Now())#) /cfquery !--- Get the last id for use in the multi insert --- cfquery name=lastRec datasource=#request.dsn# SELECT LAST_INSERT_ID() as lastid /cfquery !--- I set the lastID cause without it I get an error message --- cfset lastID = lastRec.lastid !--- Here is where the multi insert is done. The formCount is used to setup loop for the Options --- cfloop from=1 to=#formCount# index=i cfquery datasource=#request.dsn# INSERT cart_options (optionID, cartLineID) VALUES ('#Evaluate(form.option#i#)#', #LastID#) /cfquery /cfloop /cftransaction I still have a problem I hope someone can answer. On the form if their are 3 options to select from (radio buttons) and I select option 1 and 3, I get an error message because the options are not concurrent . This is because the loop goes thru 2 options; option1 and option2 instead of option1 and option3 and gives an error stating their is no value for option2. Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231717 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Looping over dynamic checkboxes
I'm sorry. I didnt mean to abandon you like that. I just couldnt get back to the computer yesterday :-/ There are a couple ways that might work for you. 1) You can name all the checkboxes the same and when it is submitted, you'll have a comma delimited list of the values selected. (This looks like what you are going for) cfparam name=form.checkboxes default=#valuelist(getCheckboxes.checkboxid)# / cfloop query=getCheckboxes input type=checkbox name=checkboxes value=#checkboxid#cfif listfind(checkboxid, form.checkboxes) checked / /cfloop When you first hit this form... the checkboxes will ALL be selected since the query returns every value that was used to make the checkboxes and those values were also used to create the form variable. Once you submit it, the form scope will take over and the values will be checked against that. One down side is that if you deselect ALL boxes, this method will select them ALL again. 2) You can build and name them dynamically. cfloop query=getCheckboxes input type=checkbox name=form.checkbox#checboxid#cfif isdefined(form['checkbox' checkboxid] checked / /cfloop Then use the same query and loop to on the action side to determine if the checkbox exists (they only exist in the form scope if they were checked) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Cameron Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:45 AM To: CF-Talk Subject: Re: Looping over dynamic checkboxes Thanks for that suggestion, Bobby. I'm still missing something, and I think I've taken a step back. The following code only gives me one checked checkbox when first editing the form and no checked checkboxes during the error checking: cfloop query=getCheckboxes cfset local.currentCheckboxID = getCheckboxes.checkboxID / input name=checkboxList type=checkbox value=#getCheckboxes.checkboxID# cfloop query=queryUser cfparam name=form.checkboxList default=#queryUser.checkboxID# / cfif local.currentCheckboxID EQ form.checkboxList checked /cfif /cfloop /cfloop Something is eluding me. Any other help? Cameron Use the same loop to declare cfparams for your form fields using the query results as the default Then in all of your form fields, use the form scope for the values When the user first hits the form, the query populates the form scope. When the user submits, THEIR information overrides the cfparams and stays in the form scope Works every time :-) (not to mention... it will get rid of all those cfif statements ;-) .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
xmlhttp.Open in coldfusion
Hi all, Is there an equivalent tag or call in coldfusion the achieve the asp below, namely the xmlhttp.Open bit. I am integrating a solution for WorldPay / Streamline Royal Bank of Scotland using the Redirect Method. And have to post some xml to the url https://secure-test.streamline-esolutions.com/jsp/merchant/xml/paymentService.jsp .. Many thanks for any help :-) *** eg * sub XML2Streamline(sXML) Response.Write PRE server.HTMLEncode(sXML) /preBRsending XML... HR ' check what you're sending Response.flush 'Send the XML-- Set xmlhttp = Server.CreateObject(Msxml2.ServerXMLHTTP) ' the MS parser HTTP component ' use ServerXMLHTTP - Check http://support.microsoft.com/support/kb/articles/Q237/9/06.ASP ' if you get 'Err = Access is denied.' then try Msxml2.XMLHTTP (less reliable) xmlhttp.Open POST,sURL, false, sUser, sPass xmlhttp.setRequestHeader Content-Type, text/xml on error resume next xmlhttp.Send(sXML) if err then Response.Write Err = err.description BR Response.Write Send Status : xmlhttp.status BR Response.End end if Response.Write Send Status (200 = OK) : B xmlhttp.status /bBR 'Response.write Headers : BR xmlhttp.getAllResponseHeaders sUrl = ParseResponse(xmlhttp.responseText) if instr(sUrl,ERROR) then Response.Write sURL Response.Write BRError received from Streamline eSolutions : Response.Write BRPRE server.htmlencode(xmlhttp.responseText) else Response.Write BRRedirect URL : A HREF= sUrlsUrl /A 'Response.redirect url ' go to Streamline eSolutions payment selection page end if end sub '-- ** eg end ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231719 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFUNITED and Microsoft
I don't know about you guys, but when I went to CFUNITED, I was somewhat surprised to see Microsoft as a major sponsor. They were kind enough to give us copies of Visual Studio, and an ASP.NET book. The presentation about IIS7 was cool since that actually will have some effect on us as coldfusion developers. It seems though like their presence at CFUNITED is getting to be a little much. One of the keynotes, by Microsoft, is about developing apps with Microsoft Atlas, which is their implementation of AJAX, using ASP.NET and Visual Studio. And then there is a 3 hour session titled Building a complete web application using ASP.NET, Visual Studio 2005, and IIS7, End-to-end. What does that have to do with Coldfusion? I know *I* won't be signing up for either of those sessions! I'm not an ASP.NET programmer and I have no intention of becoming one. I suppose M$ is paying good money ;) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231720 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IS NULL VS = NULL
Hey Will... I've experienced the same thing and would be curious to know as well... I've just chalked it up to just being a pure syntax thing... nothing more than that's just the way it is in SQL server... let's see if anybody can clarify Tim -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 5:27 AM To: CF-Talk Subject: IS NULL VS = NULL SQL Server - I had a situation where I needed to make sure a field was NULL. So I used WHERE the field = NULL. It didn't return any records, but it should've. So I changed it to WHERE thefield IS NULL, and it works fine. Why is this? What's the difference between = NULL and IS NULL? Thanks, Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: xmlhttp.Open in coldfusion
I have done a little more digging and found an example as follows but it throws an error, anyone out there offer any clues? cfset xmlHTTP = CreateObject(com, Msxml2.XMLHTTP) cfscript xmlHttp.open(POST, https://secure-test.streamline-esolutions.com/jsp/merchant/xml/paymentService.jsp;, false); res = xmlHttp.responseText; /cfscript But I get an error An exception occurred when accessing a Com object field. The cause of this exception was that: AutomationException: 0x80004005 - Unspecified error in 'msxml3.dll'. I assume I need to install the dll somewhere, any pointers on where this should go AND am I heading in the right direction? - On 09/02/06, Paul Kathryn [EMAIL PROTECTED] wrote: Hi all, Is there an equivalent tag or call in coldfusion the achieve the asp below, namely the xmlhttp.Open bit. I am integrating a solution for WorldPay / Streamline Royal Bank of Scotland using the Redirect Method. And have to post some xml to the url https://secure-test.streamline-esolutions.com/jsp/merchant/xml/paymentService.jsp. Many thanks for any help :-) *** eg * sub XML2Streamline(sXML) Response.Write PRE server.HTMLEncode(sXML) /preBRsending XML... HR ' check what you're sending Response.flush 'Send the XML-- Set xmlhttp = Server.CreateObject(Msxml2.ServerXMLHTTP) ' the MS parser HTTP component ' use ServerXMLHTTP - Check http://support.microsoft.com/support/kb/articles/Q237/9/06.ASP ' if you get 'Err = Access is denied.' then try Msxml2.XMLHTTP (less reliable) xmlhttp.Open POST,sURL, false, sUser, sPass xmlhttp.setRequestHeader Content-Type, text/xml on error resume next xmlhttp.Send(sXML) if err then Response.Write Err = err.description BR Response.Write Send Status : xmlhttp.status BR Response.End end if Response.Write Send Status (200 = OK) : B xmlhttp.status /bBR 'Response.write Headers : BR xmlhttp.getAllResponseHeaders sUrl = ParseResponse(xmlhttp.responseText) if instr(sUrl,ERROR) then Response.Write sURL Response.Write BRError received from Streamline eSolutions : Response.Write BRPRE server.htmlencode( xmlhttp.responseText) else Response.Write BRRedirect URL : A HREF= sUrlsUrl /A 'Response.redirect url ' go to Streamline eSolutions payment selection page end if end sub '-- ** eg end -- Paul Kathy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFUNITED and Microsoft
From: Rick Root [mailto:[EMAIL PROTECTED] I don't know about you guys, but when I went to CFUNITED, I was somewhat surprised to see Microsoft as a major sponsor. They were kind enough to give us copies of Visual Studio, and an ASP.NET book. The presentation about IIS7 was cool since that actually will have some effect on us as coldfusion developers. It seems though like their presence at CFUNITED is getting to be a little much. One of the keynotes, by Microsoft, is about developing apps with Microsoft Atlas, which is their implementation of AJAX, using ASP.NET and Visual Studio. And then there is a 3 hour session titled Building a complete web application using ASP.NET, Visual Studio 2005, and IIS7, End-to-end. What does that have to do with Coldfusion? I know *I* won't be signing up for either of those sessions! I'm not an ASP.NET programmer and I have no intention of becoming one. I suppose M$ is paying good money ;) I don't see a problem with MS being there, especially if their sponsorship money goes to the overall benefit of the conference itself. I think it's nice to have a good mix of technologies at CFUNITED as it is very rare that CF is the sole technology used for every aspect of a project. For instance, we have some very well written applications that make use of a slew of MS SQL Servers. The reporting requirements for some of these applications are pretty intense and we have found that Visual Studio 2005 and Reporting Services actually help us in the reporting area of things. Sure, the new reporting features in CF 7 are extremely helpful and nice to have but when reporting requirements dictate more robust reports along with off-line availability, there are other products/technologies/tools that are nice to use. Many people have stated it before and I will state it again, it can't hurt to expand your skills into other areas; especially when you can find ways to use all your tools together. Also, the books MS handed out at CFUNITED were worth a shitload at Borders. They gave me almost $200 in store credit which went to some books I was really interested in along with the Mazzy Star CD. :-) Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231723 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IS NULL VS = NULL
I'm guessing that it is just a syntax thing...somewhere in the SQL Server engine, it makes it easier for them to handle the comparison. Oddly, the update isn't like that...when you set a column to NULL, you use col_name = NULL, not something like col_name TO BE NULL On the subject, here is a pretty good article about why NULL should be avoided http://www.aspfaq.com/show.asp?id=2073 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231724 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IS NULL VS = NULL
You might have missed it.. **This is expected** =NULL will never work as NULL is not a value, it isn't anything really. - and therefore it cannot be equal to anything. You always have to use IS NULL. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 09 February 2006 14:20 To: CF-Talk Subject: Re: IS NULL VS = NULL I'm guessing that it is just a syntax thing...somewhere in the SQL Server engine, it makes it easier for them to handle the comparison. Oddly, the update isn't like that...when you set a column to NULL, you use col_name = NULL, not something like col_name TO BE NULL On the subject, here is a pretty good article about why NULL should be avoided http://www.aspfaq.com/show.asp?id=2073 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231725 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IS NULL VS = NULL
Hi, I'm guessing that it is just a syntax thing...somewhere in the SQL Server engine, it makes it easier for them to handle the comparison. well, as Neil already said, NULL is not a value and thus can not be compared to any other value or field content. NULL actually means the field content is not existing. Taken from MySQL documentation: [quote]In SQL, the NULL value is never true in comparison to any other value, even NULL. An expression that contains NULL always produces a NULL value unless otherwise indicated in the documentation for the operators and functions involved in the expression.[/quote] And a little further: [quote] If you want to search for column values that are NULL, you cannot use an expr = NULL test. The following statement returns no rows, because expr = NULL is never true for any expression: mysql SELECT * FROM my_table WHERE phone = NULL;[/quote] Oddly, the update isn't like that...when you set a column to NULL, you use col_name = NULL, not something like col_name TO BE NULL No offense intended, but the difference between assingment and comparison should be obvious. This is absolutely not just the way it is in SQL server, but pure database and SQL fundamentals. The ppl. who developed SQL by no way made it like this by mistake or by accident. It was meant to be this way, and not just in SQL server. Again, absolutely no offense intended, but, if NULLs are unclear to you guys, I recommend you get yourself a good book on database basics, unless you want to run into some serious trouble with databases sooner or later. Best, Chris ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231726 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IS NULL VS = NULL
Maybe if you SET the filed to the string 'NULL' but NULL has never been tested by '=' that I've seen. It's not a value. I doubt an update would change that. If it does, I'll be extremely ticked off as I'm changing tons of queries :-) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 9:20 AM To: CF-Talk Subject: Re: IS NULL VS = NULL I'm guessing that it is just a syntax thing...somewhere in the SQL Server engine, it makes it easier for them to handle the comparison. Oddly, the update isn't like that...when you set a column to NULL, you use col_name = NULL, not something like col_name TO BE NULL On the subject, here is a pretty good article about why NULL should be avoided http://www.aspfaq.com/show.asp?id=2073 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231727 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Rules Engine?
Has anyone written a cf-based rules engine type of thing? I have a client that has the wonkiest business rules for pricing products that I've ever seen. It's stuff like: this product is free if you live in Wisconsin, but priced and not subject to discounts if you don't this product is free unless you order 200 of them at once, then it's priced authors get their own products free, but only up until they've met their quota of products Stuff like that, and every time we talk they come up with another one. There are about a jillion discount options that are combinations of product and purchaser or product or purchaser. I _could_ put this all into a pricing CFC. But, then I'd be changing code every time they want to add a new product with another funky rule. So, I'm trying to come up with a more flexible approach. Thoughts? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is there a way to maintain formated text
I'd think that it was maybe bold in a Word doc and then copy n pasted into a text area at which point it lost its formating. Ah ok,... well in that case, if it comes from Word, it is not a bad idea to strip HTML code ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rules Engine?
You might poke through some of these: http://java-source.net/open-source/rule-engines On 2/9/06, Deanna Schneider [EMAIL PROTECTED] wrote: Has anyone written a cf-based rules engine type of thing? I have a client that has the wonkiest business rules for pricing products that I've ever seen. It's stuff like: this product is free if you live in Wisconsin, but priced and not subject to discounts if you don't this product is free unless you order 200 of them at once, then it's priced authors get their own products free, but only up until they've met their quota of products Stuff like that, and every time we talk they come up with another one. There are about a jillion discount options that are combinations of product and purchaser or product or purchaser. I _could_ put this all into a pricing CFC. But, then I'd be changing code every time they want to add a new product with another funky rule. So, I'm trying to come up with a more flexible approach. Thoughts? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231730 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rules Engine?
Has anyone written a cf-based rules engine type of thing? This sounds like a backward chaining engine would be an efficient solution. I made one in another life in Clipper, and another one in C callable from Internet in a CGI module. So I guess this could be worked out in CF as well. You've got to know a minimum about expert systems and backward chaining engines however. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: xmlhttp.Open in coldfusion
Can't you just use CFHTTP to do the post? On 2/9/06, Paul Kathryn [EMAIL PROTECTED] wrote: I have done a little more digging and found an example as follows but it throws an error, anyone out there offer any clues? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231732 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Homesite 5.5 and external browsers (one more thing)
Are you using cgi.auth_user? -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 9:01 PM To: CF-Talk Subject: RE: Homesite 5.5 and external browsers (one more thing) OK, now I switched the mapping to localhost and it works in IE but opera NS and FF all want username and password still. I haven't a clue what this could be Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 10:33 PM To: CF-Talk Subject: OT: Homesite 5.5 and external browsers Hi, Does anyone know why viewing the pages locally on localhost or 127.0.0.1 both ask me for a username and password? it happens in every browser I use. Thanks This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231733 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rules Engine?
Well, that gives me stuff to research at least. Thanks. On 2/9/06, Claude Schneegans [EMAIL PROTECTED] wrote: Has anyone written a cf-based rules engine type of thing? This sounds like a backward chaining engine would be an efficient solution. I made one in another life in Clipper, and another one in C callable from Internet in a CGI module. So I guess this could be worked out in CF as well. You've got to know a minimum about expert systems and backward chaining engines however. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231734 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rules Engine?
I've written a few for the lists. RegEx based ones, logic tree ones, etc. The easiest way to do this is to write the rules up as 'plug-ins' for a CFIF and then go through them one by one to see which fits the criteria or not. Has anyone written a cf-based rules engine type of thing? I have a client that has the wonkiest business rules for pricing products that I've ever seen. It's stuff like: this product is free if you live in Wisconsin, but priced and not subject to discounts if you don't this product is free unless you order 200 of them at once, then it's priced authors get their own products free, but only up until they've met their quota of products Stuff like that, and every time we talk they come up with another one. There are about a jillion discount options that are combinations of product and purchaser or product or purchaser. I _could_ put this all into a pricing CFC. But, then I'd be changing code every time they want to add a new product with another funky rule. So, I'm trying to come up with a more flexible approach. Thoughts? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231735 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is there a way to maintain formated text
Yes, Aaron was right. I didn't state clearly. I pasted the text into the textarea field and the html and formatted stuff went away. The FCKeditor Ray pointed to will be helpful. --Nathan -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 9:49 PM To: CF-Talk Subject: Re: Is there a way to maintain formated text I'd think that it was maybe bold in a Word doc and then copy n pasted into a text area at which point it lost its formating. On 2/8/06, Claude Schneegans [EMAIL PROTECTED] wrote: Sometimes the original text contains formated text such as words in bold, with bullet points, and even with url behind it. When the text goes to the database, they are stripped away. How come? HTML is pure texte, database fields that can take text can take HTML. Who strips the code away? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
FW: [CF-Dev] £ sign in cfmail
I am posting this for a colleague. --- Hi everyone, I hope someone can help me with this problem as its really doing my head in! My client sends out adverts in either plaintext or HTML format and we use a template to create each version which is then mass-mailed. I am having problems representing the pound sign in the emails. It was easy to fix the problem in the HTML emails, as I just replaced the ASCII code with the HTML code. However, it is not so easy for the text emails. When a text email that contains a £ sign is viewed in Outlook Express it looks fine on screen; but if you view the source (ALT+ Enter, Click message source) you will see that where the pound sign should be, there are A3s instead!! This may not seem a problem as the email display is fine, but my client runs macros that look at the message source and import data from it, and the rogue characters are causing all sorts of problems. I am using charset ISO8859-1 in the cfmail tag and I have tried various other charsets as well, with no success. We didnt have this problem with CF5, the £ sign was intact both in the display and in the message source. Has anyone got any ideas please? Thanks Regards Hooman ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231737 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: xmlhttp.Open in coldfusion
CFHTTP is your go-to tag in this situation. Remember that all official CF documentation is available for free at livedocs.macromedia.com - it's INSANELY useful to flip through the reference manual and read the one line description of each tag and function. You'll be amazed at how many things CF can do. Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231738 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
TMT validator, date validation...
I'm trying to use the TMT validator to validate a text field which needs to contain just a year. For some stupid reason the client doesn't want to use a dropdown (which is dead simple) and insists on being able to type in the date manually. I told him that eventually someone is going to want to type in a 2 digit year. So I'm left with trying to validate 1997 as opposed to 97. I've got this line in place on the text field: tmt:datepattern= And I'm typing in the full year but it's not working properly. Does anyone have any ideas? Is this going to require a custom filter? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231739 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Flash forms checkbox question
Hey, thanks for being a member! I'm looking to do a DB update, I was using CFUPDATE, which automatically converts true/false to 1/0. CFUPDATE doesn't seem to work with this table on our database, so I was trying to write the SQL and having T/F in the form variables blows up when it hits our bit field. Hey, I'm a PSEA member! Just got certified to teach English, planning ahead for the day when nobody will hire me as a developer anymore... What about creating a UDF that converts a true/false to a 1/0? What are you doing, inserting the data into a database as individual values, or are you doing something else with the structure? Pete On 2/8/06, Smith, Daron [PA] [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231740 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IS NULL VS = NULL
Ahh I see you meant an update QUERY not an update for sql server. At any rate... setting a column with '=' in an update isnt the same as testing for equality and '=' is the ONLY way to set a columns value in an update. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 9:43 AM To: CF-Talk Subject: RE: IS NULL VS = NULL Maybe if you SET the filed to the string 'NULL' but NULL has never been tested by '=' that I've seen. It's not a value. I doubt an update would change that. If it does, I'll be extremely ticked off as I'm changing tons of queries :-) ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 9:20 AM To: CF-Talk Subject: Re: IS NULL VS = NULL I'm guessing that it is just a syntax thing...somewhere in the SQL Server engine, it makes it easier for them to handle the comparison. Oddly, the update isn't like that...when you set a column to NULL, you use col_name = NULL, not something like col_name TO BE NULL On the subject, here is a pretty good article about why NULL should be avoided http://www.aspfaq.com/show.asp?id=2073 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231741 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: xmlhttp.Open in coldfusion
I dont think that cfhttp gives me what I require. I am using this to pass xml to a worldpay system and all the asp, jsp and java examples use xmlhttp methods. I have got a bit further with this now, the dll is registered but now the following code is cfset xmlHTTP = CreateObject(com, Msxml2.XMLHTTP) cfscript xmlhttp.setRequestHeader(Content-Type, text/xml); xmlHttp.open(POST, https://secure-test.streamline-esolutions.com/jsp/merchant/xml/paymentService.jsp;, false, username,password); //xmlHttp.send(); //res = xmlHttp.responseText; /cfscript It is failing on the setRequestHeader with An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80004005 - Unspecified error in 'msxml3.dll'. Any clues out there??? Paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231742 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FW: [CF-Dev] £ sign in cfmail
Hi, I am having problems representing the pound sign in the emails. It was easy to fix the problem in the HTML emails, as I just replaced the ASCII code with the HTML code. However, it is not so easy for the text emails. I am using charset ISO8859-1 in the cfmail tag and I have tried various other charsets as well, with no success. Did he try UTF-8? Works for me for german umlauts, pound signs and the like. Actually UTF-8 is the best way for special characters. Best, Chris ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231743 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: xmlhttp.Open in coldfusion
cfset xmlHTTP = CreateObject(com, Msxml2.XMLHTTP) Should be cfset xmlHTTP = CreateObject(com, Msxml3.XMLHTTP) ? That's how I have mine written. Just curious if that makes a difference. Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: www.ejhassociates.com tel: 651.207.1526 fax: 651.207.1536 mob: 651.245.2717 This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -Original Message- From: Paul Kathryn [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 10:10 AM To: CF-Talk Subject: Re: xmlhttp.Open in coldfusion I dont think that cfhttp gives me what I require. I am using this to pass xml to a worldpay system and all the asp, jsp and java examples use xmlhttp methods. I have got a bit further with this now, the dll is registered but now the following code is cfset xmlHTTP = CreateObject(com, Msxml2.XMLHTTP) cfscript xmlhttp.setRequestHeader(Content-Type, text/xml); xmlHttp.open(POST, https://secure-test.streamline-esolutions.com/jsp/merchant/xml/paymentSe rvice.jsp, false, username,password); //xmlHttp.send(); //res = xmlHttp.responseText; /cfscript It is failing on the setRequestHeader with An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80004005 - Unspecified error in 'msxml3.dll'. Any clues out there??? Paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231744 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IS NULL VS = NULL
OK, I guess I stepped on a nerve here...and in retrospect, I should have thought out my post more -I should not have made a reference to SQL Server...the IS NULL operator is part of the ANSI-92 standard, and would be used in any database that conforms to that(but the original post was referring to SQL Server :-)) . But the question was why IS NULL...it is a syntax thing...the IS operator is used for nothing else that I know of. It allows the database engine to override the rule that NULL = NULL resolves to Unknown and actually do the comparison, treating NULL as a value (value is in quotes so no one jumps down my throat, going...NULL has no value!!!...that is understood). -The assignment issue is not completely obvious to meand this is more of an overall issue with the ANSI-92 standard than with assignment vs comparison...in some ways, I think having a special syntax for the assignment of NULL would have helped people understand the concept. I also don't think database systems should default fields to allow NULL if it is not specified(as SQL Server does). -This is part of the SQL Standard, and IS probably the best way to handle NULLs, but there are exceptions...that is why you have conditions like SET ANSI_NULLS OFF. The fact is that the concept of three value logic is not that straight forward to everyone, and including it in the SQL spec has probably confused a lot of people. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: A way to set a dynamic anchor in a div?
Rick, I don't know if this will work, you might want to look at which html elements can actually take this function, but I would suggest that you assign your 'anchored' element an id and then write a js function to focus() on the element. Then you could call the js function from where ever you would usually place your anchor call (i.e.: a href=javascript:void(0); onclick=anchorFunction(anchoredElementID);link to anchor/a Cutter Rick Faircloth wrote: Hi, all... I'm working on an web-based office application, so I'm trying to put as much functionality on a single screen as possible. I've using scrolling div's for areas to add, update, and delete content. Everythings going well except for trying to place an anchor inside a div for client contact entries. I think I'm coding everything correctly...I've done this before, but the anchor was on a full page of html, not in a particular div. Is there some way I can target the anchor to affect the content in a particular div? I think that's why the anchor's not working, because it's not an anchor for the whole HTML page, just the content in that particular div. It's a dynamic CF-generated anchor, but I've done that before, too. The div just seems to ignore the anchor... Ideas? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: xmlhttp.Open in coldfusion
CFHTTP offers the child tag CFHTTPPARAM to do everything you need, I think. Use it with the type=header to set a request header. I really can't see anything you're doing that CFHTTP (with the proper CFHTTPPARAMs) can't do. Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231747 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is there a way to maintain formated text
The FCKeditor Ray pointed to will be helpful. Exact, and it does have a tool to clean up so called HTML coming from Word. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231748 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: ColdFusion and Flex
Ben Forta is doing a tour promoting Flex 2 and ColdFusion, and I really think people should contact their local user group, find out when he's going to be there, and go. (Details are available on http://www.forta.com.) I'd like to invite anyone in the New York area to come to the NYCFUG Meeting on Tuesday, February 21st, at 6:30 PM. Seating is limited, so please RSVP at http://www.nycfug.org as early as possible. Attend this presentation (or one in your local area) to learn about the new Flex, as well as the new ColdFusion integration functionality, which will make ColdFusion an ideal back-end for Flex. Flex 2 is on the way, and this is your invitation to be one of the first to experience the future of rich Internet application development. A lot has changed in Flex 2, and you can read more about it on http://labs.macromedia.com/. With new pricing options, new deployment options, new back-end integration options, and a slew of new features, Flex 2 is going to change the way we build applications. And for ColdFusion developers, there has never been a better time to experience it. When? Tuesday, February 21st, 2006, 6:30 PM (the third Tuesday of the month) Where? NYU Medical Center, 550 1st Avenue (corner of E. 31st Street) Room: Alumni Hall A A copy of ColdFusion 7 Standard will be raffled off to one lucky attendee! We will be ordering food. Please RSVP on our site (http://www.nycfug.org) so that we can plan accordingly. Judith Dinowitz Co-Manager New York ColdFusion User Group (NYCFUG)http://www.nycfug.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231749 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is there a way to maintain formated text
I have had a couple of people rave to me about this one as well: http://tinymce.moxiecode.com/ I was told that their example online is poor in that it loads up too slow due to all the stuff they are trying to show off in it. On 2/9/06, Nathan Chen [EMAIL PROTECTED] wrote: Yes, Aaron was right. I didn't state clearly. I pasted the text into the textarea field and the html and formatted stuff went away. The FCKeditor Ray pointed to will be helpful. --Nathan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231750 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IS NULL VS = NULL
It's proper SQL Willsimple as that. ;-) The reason is NULL is nothing...and something cannot equal nothingbut it can be NULL...so we sqay IS NULL or IS NOT NULL. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231751 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
calling any Verity experts - 2nd request
Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ..doc ..ppt ..pdf ..rtf And I got not a single bite. I've searched and searched, but either I'm using the wrong search terms, or this is a really ambiguous topic. Every answer I find says that Verity will assign a title if one is found - WTF does that mean? If I knew where it was trying to find the title, that might help me a little more. Any ideas? Even if it's a brainstorm, throw it out there. This is such a simple problem, it would seem. Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231752 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: calling any Verity experts - 2nd request
Have you created any test files to see? I reckon docs take it from the first line or prominent line. Maybe create a file of each and see what you get. Adrian -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 09 February 2006 16:46 To: CF-Talk Subject: calling any Verity experts - 2nd request Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ...doc ...ppt ...pdf ...rtf And I got not a single bite. I've searched and searched, but either I'm using the wrong search terms, or this is a really ambiguous topic. Every answer I find says that Verity will assign a title if one is found - WTF does that mean? If I knew where it was trying to find the title, that might help me a little more. Any ideas? Even if it's a brainstorm, throw it out there. This is such a simple problem, it would seem. Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231753 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling any Verity experts - 2nd request
It is my understanding that Verity has code for each situation. So for PDF, it most likely looks in the metadata. For HTML, it uses stuff between title tags. I'd be surprised if you could modify this though. Have you tried simply editing the PDF properties (or doc), indexing,and then testing? On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ..doc ..ppt ..pdf ..rtf And I got not a single bite. I've searched and searched, but either I'm using the wrong search terms, or this is a really ambiguous topic. Every answer I find says that Verity will assign a title if one is found - WTF does that mean? If I knew where it was trying to find the title, that might help me a little more. Any ideas? Even if it's a brainstorm, throw it out there. This is such a simple problem, it would seem. Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling any Verity experts - 2nd request
I know that if you have the 'Title' set on Page Properties, it will use that (For PDF and DOC). On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ..doc ..ppt ..pdf ..rtf And I got not a single bite. I've searched and searched, but either I'm using the wrong search terms, or this is a really ambiguous topic. Every answer I find says that Verity will assign a title if one is found - WTF does that mean? If I knew where it was trying to find the title, that might help me a little more. Any ideas? Even if it's a brainstorm, throw it out there. This is such a simple problem, it would seem. Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231755 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: calling any Verity experts - 2nd request
MS Office documents have some sort of meta data they store like title, subject, category, author, and stuff you can get to by right clicking on a word doc, clicking properties and going to the summary tab. I wonder if they use that. Can you make some test documents, run verity on them and see which pieces of text get picked up as a title? ~Brad -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 10:46 AM To: CF-Talk Subject: calling any Verity experts - 2nd request Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ...doc ...ppt ...pdf ...rtf ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231756 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
check out this CS response
My shared server is constantly going down, so I wrote to my hosting company, and this is the answer they gave me. Now, I'm no CF expert or anything, but doesn't this answer seem like a bunch of BS? I've left the name out of it, as I'm not here to slander anyone, but I will say that this is a large, reputable company that is hosting my site(s). Dear Ray, We have restarted your Shared Server. Unfortunately ColdFusion is not very stable in shared environment and unfortunately there is nothing we can do about it except to restart it when it crashes. There is no way to make ColdFusion servers more reliable then they are now. At least none of our experiments with ColdFusion allowed us to improve reliability considerably. The main problem is that all customers' scripts are running in a single process and a single customer with faulty scripts can keep shutting down the server. Moving the customer from server to server will not help as this problem is exhibited by all ColdFusion servers. We have automatic server monitoring in place that restarts Cold Fusion whenever it crashes. Please let us know if we can be of further assistance or you have any other questions. Regards, XX Technical Support ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling any Verity experts - 2nd request
OK...since you said to just brainstormI'm guessing that it would first look at the meta data of the document...in Word, there is data under File/Properties...in Acrobat there is data under File/Document Properties...both have a Title field. After that, it probably looks through the text and has some rules it goes by where certain styles/font sizes are considered the title in descending order. On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ..doc ..ppt ..pdf ..rtf And I got not a single bite. I've searched and searched, but either I'm using the wrong search terms, or this is a really ambiguous topic. Every answer I find says that Verity will assign a title if one is found - WTF does that mean? If I knew where it was trying to find the title, that might help me a little more. Any ideas? Even if it's a brainstorm, throw it out there. This is such a simple problem, it would seem. Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231758 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: A way to set a dynamic anchor in a div?
I've done something like this recently. I didn't do anything particularly complicated. The anchors where written in the basic form such as a href='#RBC' onClick='popup();'RBC/a Then near the end of the page I had a div div id='defList' that is controlled by JavaScript to popup in the middle of the screen when a anchor is selected. Inside the difList is a dl list with dt's which contains anchors such as a id='RBC'RBC Definationa. This works just as I want. When the defList division is displayed, the selected term is displayed at the top of the div container. Feel free to reply to me if you would like more details of my code. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: xmlhttp.Open in coldfusion
I dont think that cfhttp gives me what I require. I am using this to pass xml to a worldpay system and all the asp, jsp and java examples use xmlhttp methods. Why do you think that CFHTTP won't work? There's no reason why it shouldn't. Also, I don't see where in your sample COM code you're actually putting in any string of XML to send to the server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231760 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFUNITED and Microsoft
I'm going to ditto the other persons reply. While I don't think the ..Net stuff will be highly attended, I know that last year their IIS keynote was very interesting. On 2/9/06, Rick Root [EMAIL PROTECTED] wrote: I don't know about you guys, but when I went to CFUNITED, I was somewhat surprised to see Microsoft as a major sponsor. They were kind enough to give us copies of Visual Studio, and an ASP.NET book. The presentation about IIS7 was cool since that actually will have some effect on us as coldfusion developers. -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231761 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling any Verity experts - 2nd request
Ray, are you building the collection using cfindex, or are you building it outside cf yourself using verity tools? On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ..doc ..ppt ..pdf ..rtf ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231762 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling any Verity experts - 2nd request
Well well wellI have no idea why I didn't think of this in the first place. Duh! MetaData! Why you little. :) That seems to be it. Here I was using test ppt's and docs...I never even thought of meta data. Now I feel like a tool. Thanks all! Ray Raymond Camden wrote: It is my understanding that Verity has code for each situation. So for PDF, it most likely looks in the metadata. For HTML, it uses stuff between title tags. I'd be surprised if you could modify this though. Have you tried simply editing the PDF properties (or doc), indexing,and then testing? On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ..doc ..ppt ..pdf ..rtf And I got not a single bite. I've searched and searched, but either I'm using the wrong search terms, or this is a really ambiguous topic. Every answer I find says that Verity will assign a title if one is found - WTF does that mean? If I knew where it was trying to find the title, that might help me a little more. Any ideas? Even if it's a brainstorm, throw it out there. This is such a simple problem, it would seem. Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231763 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: check out this CS response
Well that is true of CF professional edition; since with professional a single instance of CF runs all applications on the box. Bad code, such as an endless loop, in any application will crash the entire box and all applications on it. We had this problem with our internal servers here a BloodSource. Unfortunately I was the one who usually found very creative ways to create endless loops that would bring down the entire box. This can be mitigated somewhat by Hosting Companies by discouraging development on shared hosted boxes. But I'm sure that is something that is difficult to detect and enforce. For us, the solution was to go to CF enterprise so that we could create separate instances for each application. Now causing one instance to lock up with an endless loop does not affect the rest of the applications. This has saved me much embarrassment. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling any Verity experts - 2nd request
using cfindex. Jerry Johnson wrote: Ray, are you building the collection using cfindex, or are you building it outside cf yourself using verity tools? On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: Hey all: A while back, I asked if anyone knows where exactly Verity gets the Title field from when searching the following docs: ..doc ..ppt ..pdf ..rtf ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231765 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: check out this CS response
We did the trial of ReactorFusion, and now we're buying several licenses. There were some processes (related to java libraries used by a few apps) that occasionally would over flood the system(s) with long running thread processes. Upon installing ReactorFusion, our uptime improved considerably because it automatically reigned in many of those processes, without additional configuration of the utility. We can further extend that functionality if we define some specific crash protection rules. Ray, I'm not going to say that they're FOS, just that they might be ignorant of all of their options. Feel free to forward my message on to them, maybe they'll be willing to give it a look, and maybe it will take care of your issues. As a 'large, reputable company', I would hope that their server health would be worth them taking the time to explore any suggestions you might provide. Cutter Ray Champagne wrote: My shared server is constantly going down, so I wrote to my hosting company, and this is the answer they gave me. Now, I'm no CF expert or anything, but doesn't this answer seem like a bunch of BS? I've left the name out of it, as I'm not here to slander anyone, but I will say that this is a large, reputable company that is hosting my site(s). Dear Ray, We have restarted your Shared Server. Unfortunately ColdFusion is not very stable in shared environment and unfortunately there is nothing we can do about it except to restart it when it crashes. There is no way to make ColdFusion servers more reliable then they are now. At least none of our experiments with ColdFusion allowed us to improve reliability considerably. The main problem is that all customers' scripts are running in a single process and a single customer with faulty scripts can keep shutting down the server. Moving the customer from server to server will not help as this problem is exhibited by all ColdFusion servers. We have automatic server monitoring in place that restarts Cold Fusion whenever it crashes. Please let us know if we can be of further assistance or you have any other questions. Regards, XX Technical Support ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231766 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFPop Gmail
Hi, I am having trouble CFPOP'ing my gmail account. I think it may have to do with the fact that an SSL connection is required. Has anyone got it to work? Cheers, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: check out this CS response
I would say that this company would be using an enterprise edition, although I can't be certain. They sure are big enough... I also don't deny the fact that there are dumbasses that will develop horrible, resource-sucking, wasteful apps (hell, I've done it too) on the same box as me, but we've been dealing with this same problem since April. I'm actually in the process of moving this site to a new host to see if I can prove that it indeed is their configuration that's making it spit out JRun errors every couple hours or so. It's just frustrating to have to do all this. The real answer is to get ourselves a dedicated box, then at least I know when it's throwing errors, I can attribute it to something I'm doing, and not some arbitrary setup. Ian Skinner wrote: Well that is true of CF professional edition; since with professional a single instance of CF runs all applications on the box. Bad code, such as an endless loop, in any application will crash the entire box and all applications on it. We had this problem with our internal servers here a BloodSource. Unfortunately I was the one who usually found very creative ways to create endless loops that would bring down the entire box. This can be mitigated somewhat by Hosting Companies by discouraging development on shared hosted boxes. But I'm sure that is something that is difficult to detect and enforce. For us, the solution was to go to CF enterprise so that we could create separate instances for each application. Now causing one instance to lock up with an endless loop does not affect the rest of the applications. This has saved me much embarrassment. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231768 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Need ASP configuration help...
I inherited an OLD CF system (4.5). I am moving everything to a new server with CF MX 7. Problem is, there are a few folders that have ASP and I can't get those to work. The borwser says that the page is missing. I am thinking it has something to do with the ASP.NET tab in IIS. I have no idea what I am doing to get this to work. Can anyone help or lead me in the right direction? Thanks Brian Brian Yager S3, IT Manager President North Alabama ColdFusion Users Group http://www.nacfug.com PF Data Management (256) 842-0280 [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231769 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling any Verity experts - 2nd request
Nevermind then. On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: using cfindex. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: check out this CS response
It sure can't hurt. Google doesn't give me any results for ReactorFusion. URL? Cutter (CF-Talk) wrote: We did the trial of ReactorFusion, and now we're buying several licenses. There were some processes (related to java libraries used by a few apps) that occasionally would over flood the system(s) with long running thread processes. Upon installing ReactorFusion, our uptime improved considerably because it automatically reigned in many of those processes, without additional configuration of the utility. We can further extend that functionality if we define some specific crash protection rules. Ray, I'm not going to say that they're FOS, just that they might be ignorant of all of their options. Feel free to forward my message on to them, maybe they'll be willing to give it a look, and maybe it will take care of your issues. As a 'large, reputable company', I would hope that their server health would be worth them taking the time to explore any suggestions you might provide. Cutter Ray Champagne wrote: My shared server is constantly going down, so I wrote to my hosting company, and this is the answer they gave me. Now, I'm no CF expert or anything, but doesn't this answer seem like a bunch of BS? I've left the name out of it, as I'm not here to slander anyone, but I will say that this is a large, reputable company that is hosting my site(s). Dear Ray, We have restarted your Shared Server. Unfortunately ColdFusion is not very stable in shared environment and unfortunately there is nothing we can do about it except to restart it when it crashes. There is no way to make ColdFusion servers more reliable then they are now. At least none of our experiments with ColdFusion allowed us to improve reliability considerably. The main problem is that all customers' scripts are running in a single process and a single customer with faulty scripts can keep shutting down the server. Moving the customer from server to server will not help as this problem is exhibited by all ColdFusion servers. We have automatic server monitoring in place that restarts Cold Fusion whenever it crashes. Please let us know if we can be of further assistance or you have any other questions. Regards, XX Technical Support ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: check out this CS response
On Thursday 09 February 2006 16:55, Ray Champagne wrote: Unfortunately ColdFusion is not very stable in shared environment and Virtual servers anyone ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: check out this CS response
NM...found it after searching for FusionReactor. Thanks, Ray It sure can't hurt. Google doesn't give me any results for ReactorFusion. URL? Cutter (CF-Talk) wrote: We did the trial of ReactorFusion, and now we're buying several licenses. There were some processes (related to java libraries used by a few apps) that occasionally would over flood the system(s) with long running thread processes. Upon installing ReactorFusion, our uptime improved considerably because it automatically reigned in many of those processes, without additional configuration of the utility. We can further extend that functionality if we define some specific crash protection rules. Ray, I'm not going to say that they're FOS, just that they might be ignorant of all of their options. Feel free to forward my message on to them, maybe they'll be willing to give it a look, and maybe it will take care of your issues. As a 'large, reputable company', I would hope that their server health would be worth them taking the time to explore any suggestions you might provide. Cutter Ray Champagne wrote: My shared server is constantly going down, so I wrote to my hosting company, and this is the answer they gave me. Now, I'm no CF expert or anything, but doesn't this answer seem like a bunch of BS? I've left the name out of it, as I'm not here to slander anyone, but I will say that this is a large, reputable company that is hosting my site(s). Dear Ray, We have restarted your Shared Server. Unfortunately ColdFusion is not very stable in shared environment and unfortunately there is nothing we can do about it except to restart it when it crashes. There is no way to make ColdFusion servers more reliable then they are now. At least none of our experiments with ColdFusion allowed us to improve reliability considerably. The main problem is that all customers' scripts are running in a single process and a single customer with faulty scripts can keep shutting down the server. Moving the customer from server to server will not help as this problem is exhibited by all ColdFusion servers. We have automatic server monitoring in place that restarts Cold Fusion whenever it crashes. Please let us know if we can be of further assistance or you have any other questions. Regards, XX Technical Support ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: check out this CS response
fusionReactor http://www.fusion-reactor.com It is pretty awesome, and am hoping to get it for all our servers in the next budget cycle. On 2/9/06, Ray Champagne [EMAIL PROTECTED] wrote: It sure can't hurt. Google doesn't give me any results for ReactorFusion. URL? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFUNITED and Microsoft
I like that they are involved in it and just wish that I could make it to the conference to get some exposure to what they have to offer. On 2/9/06, Raymond Camden [EMAIL PROTECTED] wrote: I'm going to ditto the other persons reply. While I don't think the ..Net stuff will be highly attended, I know that last year their IIS keynote was very interesting. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: check out this CS response
Ian, For us, the solution was to go to CF enterprise so that we could create separate instances for each application. Now causing one instance to lock up with an endless loop does not affect the rest of the applications. This has saved me much embarrassment. correct me if I'm wrong, but, if a hosting company used separate instances for their customers wouldn't they have to buy a separte license for each? Best, Chris ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231776 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need ASP configuration help...
You must enable ASP support in IIS on W2k3. IIS WebServer (local computer) Web Service Extensions. Select Active Server Pages then click the Allow button. M!ke -Original Message- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 10:18 AM To: CF-Talk Subject: Need ASP configuration help... I inherited an OLD CF system (4.5). I am moving everything to a new server with CF MX 7. Problem is, there are a few folders that have ASP and I can't get those to work. The borwser says that the page is missing. I am thinking it has something to do with the ASP.NET tab in IIS. I have no idea what I am doing to get this to work. Can anyone help or lead me in the right direction? Thanks Brian ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231777 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: check out this CS response
No, CF Enterprise allows multiple instances, and each customer can indeed have their own. With no extra license needed. CF is licensed by the box (well, CPUs on the box), not by the application or user. --- Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 12:33 PM To: CF-Talk Subject: RE: check out this CS response Ian, For us, the solution was to go to CF enterprise so that we could create separate instances for each application. Now causing one instance to lock up with an endless loop does not affect the rest of the applications. This has saved me much embarrassment. correct me if I'm wrong, but, if a hosting company used separate instances for their customers wouldn't they have to buy a separte license for each? Best, Chris ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: check out this CS response
CF Ent is licensed per server with as many instances as possible on that particular server. M!ke -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 11:33 AM To: CF-Talk Subject: RE: check out this CS response Ian, For us, the solution was to go to CF enterprise so that we could create separate instances for each application. Now causing one instance to lock up with an endless loop does not affect the rest of the applications. This has saved me much embarrassment. correct me if I'm wrong, but, if a hosting company used separate instances for their customers wouldn't they have to buy a separte license for each? Best, Chris ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need ASP configuration help...Solved
Thanks Mike! I owe you a beer! Brian You must enable ASP support in IIS on W2k3. IIS WebServer (local computer) Web Service Extensions. Select Active Server Pages then click the Allow button. M!ke -Original Message- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 10:18 AM To: CF-Talk Subject: Need ASP configuration help... I inherited an OLD CF system (4.5). I am moving everything to a new server with CF MX 7. Problem is, there are a few folders that have ASP and I can't get those to work. The borwser says that the page is missing. I am thinking it has something to do with the ASP.NET tab in IIS. I have no idea what I am doing to get this to work. Can anyone help or lead me in the right direction? Thanks Brian ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231780 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: check out this CS response
I would say that this company would be using an enterprise edition, although I can't be certain. They sure are big enough... Well, even if they are using enterprise. If they have just set up one root instance and run all applications/web sites off that root, then you are still SOL if one of those other pieces of software brings down the instance/box. They would need to be setting up an individual instance for each and every application/web site. And of course this is only one possible way a bad configuration could be causing these kinds of problems. From monitoring this list I have defiantly heard of many others. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: check out this CS response
correct me if I'm wrong, but, if a hosting company used separate instances for their customers wouldn't they have to buy a separate license for each? Best, Chris No, the license is per 2/cpus per box, you can have as many websites as you are comfortable stuffing on that box under the CF license(s) of that box. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is there a way to maintain formated text
I have had a couple of people rave to me about this one as well: http://tinymce.moxiecode.com/ We use this one with no major complaints. I'm sure FCKeditor is also good, just have yet had the opportunity to play with it yet. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion and Flex
I'd like to invite anyone in the New York area to come to the NYCFUG Meeting on Tuesday, February 21st, at 6:30 PM. Seating is limited, so please RSVP at http://www.nycfug.org as early as possible. And if the NYCFUG fills up by next Tuesday, February the 14th and one can somehow make a 3000 mile journey to Sacramento, CA. Ben will be speaking at the SACCFUG that evening. BloodSource is hosting SACFUG that evening and we have plenty of room. Also, for all of the HOF members who happen to be in the Northern CA area you are welcome as well. The next evening Ben is at BACFUG in San Francisco if you miss ours. I am really looking forward to this presentation. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231784 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Patric Stumpe wrote: Man, sometimes I wonder if I should search a bit for coding Web/CF outside germany. The possibilities are very limited here for someone like me. Makes me a little bit jealous :) europe's a big place. should be work everywhere. i'd get good w/flex/flashforms as soon as i could. going to be VERY big. we really aren't that experienced but have project offers/recruiters every week. Only a few were. I always thought of some kind of filter prepending the db inser like those wysiwyg editors use to clean up pasted content. nope. Will try this tomorrow. are you using that URL string (useUnicode, etc.) for your db driver? know if the new SQL2k5 Express Edition (because it's free) throws any problems when developing and then copying over to a SQL2k live db? don't know, but msde didn't. well off to bed. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Webservice woes.
When ever I attempt to make a webservice, I have to pull out an unresonalbe amount of my remaing hair to get it to work. Every time. I crete a CFC, test it out locally, get it working as I like. Change the access to the appropiate methods to remote. Write some test code such as: cfinvoke webservice =http://infoweb/resources/cfcs/unit_no.cfc?wsdl; method =Unit_No_Type unit_no = d12312312d returnvariable=foo OR cfset something = createObject(webservice, http://infoweb/resources/cfcs/unit_no.cfc?wsdl;) cfdump var=#something# And I get errors about Could not generate stub objects for web service invocation. What is this all about. Is there some basic webservice development step I am munging or what? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231786 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion and Flex
Any chance of a public Breeze web room for this presentation? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 11:58 AM To: CF-Talk Subject: RE: ColdFusion and Flex I'd like to invite anyone in the New York area to come to the NYCFUG Meeting on Tuesday, February 21st, at 6:30 PM. Seating is limited, so please RSVP at http://www.nycfug.org as early as possible. And if the NYCFUG fills up by next Tuesday, February the 14th and one can somehow make a 3000 mile journey to Sacramento, CA. Ben will be speaking at the SACCFUG that evening. BloodSource is hosting SACFUG that evening and we have plenty of room. Also, for all of the HOF members who happen to be in the Northern CA area you are welcome as well. The next evening Ben is at BACFUG in San Francisco if you miss ours. I am really looking forward to this presentation. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231787 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Webservice woes.
My feeling is that CF6 has some kind of bug regarding this stuff... we went through a lot to get it to work with CF6 with ASP.NET as the webservice we were trying to consume... and so far no problems with CF7. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 12:05 PM To: CF-Talk Subject: CF Webservice woes. When ever I attempt to make a webservice, I have to pull out an unresonalbe amount of my remaing hair to get it to work. Every time. I crete a CFC, test it out locally, get it working as I like. Change the access to the appropiate methods to remote. Write some test code such as: cfinvoke webservice =http://infoweb/resources/cfcs/unit_no.cfc?wsdl; method =Unit_No_Type unit_no = d12312312d returnvariable=foo OR cfset something = createObject(webservice, http://infoweb/resources/cfcs/unit_no.cfc?wsdl;) cfdump var=#something# And I get errors about Could not generate stub objects for web service invocation. What is this all about. Is there some basic webservice development step I am munging or what? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Webservice woes.
and so far no problems with CF7. Well this is on a CF7 system and it is CF consuming a CF web service so it is even more frustrating. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: TMT validator, date validation...
I'm trying to use the TMT validator to validate a text field which needs to contain just a year. For some stupid reason the client doesn't want to use a dropdown (which is dead simple) and insists on being able to type in the date manually. I told him that eventually someone is going to want to type in a 2 digit year. So I'm left with trying to validate 1997 as opposed to 97. I've got this line in place on the text field: tmt:datepattern= And I'm typing in the full year but it's not working properly. Does anyone have any ideas? Is this going to require a custom filter? Custom date validation still require day and month: http://www.massimocorner.com/validator/samples/custom_date_validation.htm Sounds like you need a custom pattern: http://www.massimocorner.com/validator/samples/custom_pattern.htm Something along these lines (I haven't test it!): script type=text/javascript tmt_globalPatterns.year = new RegExp(^\([0-9]{2,4}\)$); /script Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Webservice woes.
Not an answer, but just so you know. On my dev box I had a test web service, I hadn't touched it in about a month, when I did, it threw the same error you're talking about. I deleted the registration of it from with cf admin and it started working again. That's not the first time I've seen the error. I remember in 6 there was a problem with caching. Let us know how you get on. Adrian -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 09 February 2006 18:33 To: CF-Talk Subject: RE: CF Webservice woes. and so far no problems with CF7. Well this is on a CF7 system and it is CF consuming a CF web service so it is even more frustrating. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Webservice woes.
Your example did not have this, but are you by chance trying to connect over https? We ran into all sorts of issues trying to do them with https and ultimately went to http and fixed the issues. Root of our problem was our https certs are made in house and even manually importing them will not get them to work with the CF(Jrun?) server. On 2/9/06, Ian Skinner [EMAIL PROTECTED] wrote: and so far no problems with CF7. Well this is on a CF7 system and it is CF consuming a CF web service so it is even more frustrating. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231792 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Webservice woes.
Yeah, forgot about this, run into sometimes when we change something in the CFC. You can run this if you do not have access to the CF administrator, which is the case around here. cfobject type=JAVA action=Create name=factory class=coldfusion.server.ServiceFactory cfset RpcService = factory.XmlRpcService cfset RpcService.refreshWebService(*http://www.mysite.com/* Components/MyFile.cfc?WSDLhttp://www.mysite.com/Components/BATtoSCT.cfc?WSDL ) On 2/9/06, Adrian Lynch [EMAIL PROTECTED] wrote: Not an answer, but just so you know. On my dev box I had a test web service, I hadn't touched it in about a month, when I did, it threw the same error you're talking about. I deleted the registration of it from with cf admin and it started working again. That's not the first time I've seen the error. I remember in 6 there was a problem with caching. Let us know how you get on. Adrian -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 09 February 2006 18:33 To: CF-Talk Subject: RE: CF Webservice woes. and so far no problems with CF7. Well this is on a CF7 system and it is CF consuming a CF web service so it is even more frustrating. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Webservice woes.
Let us know how you get on. Adrian No joy on deleting the web service registration. I am still getting the same error. PS. Following the suggestion in the error message of connecting directly to the WSDL seems to produce a correct WSDL document to the best of my knowledge. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: TMT validator, date validation...
Well thanks Massimo! Awesome of you to give me that. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 12:37 PM To: CF-Talk Subject: Re: TMT validator, date validation... I'm trying to use the TMT validator to validate a text field which needs to contain just a year. For some stupid reason the client doesn't want to use a dropdown (which is dead simple) and insists on being able to type in the date manually. I told him that eventually someone is going to want to type in a 2 digit year. So I'm left with trying to validate 1997 as opposed to 97. I've got this line in place on the text field: tmt:datepattern= And I'm typing in the full year but it's not working properly. Does anyone have any ideas? Is this going to require a custom filter? Custom date validation still require day and month: http://www.massimocorner.com/validator/samples/custom_date_validation.htm Sounds like you need a custom pattern: http://www.massimocorner.com/validator/samples/custom_pattern.htm Something along these lines (I haven't test it!): script type=text/javascript tmt_globalPatterns.year = new RegExp(^\([0-9]{2,4}\)$); /script Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231795 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Webservice woes. SOLVED
Let us know how you get on. Adrian OK I had my DOH moment of the day. CF can not consume a web service that is in an IIS resource that is locked down with Integrated Windows security. The CF service can not respond to the authentication challenge. But putting the web service WSDL URL into a browser on our client computer, which can respond to the challenge with our credentials, works just fine. We put the CFC into a directory that we currently just removed security from so that it can be accessed anonymously and all is well. FOR THE ARCHIVES Check the security setting of the webservice CFC if you receive this error. Could not generate stub objects for web service invocation. Thanks for all the help. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: TMT validator, date validation...
Worked perfectly too. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 1:15 PM To: CF-Talk Subject: RE: TMT validator, date validation... Well thanks Massimo! Awesome of you to give me that. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 12:37 PM To: CF-Talk Subject: Re: TMT validator, date validation... Custom date validation still require day and month: http://www.massimocorner.com/validator/samples/custom_date_validation.htm Sounds like you need a custom pattern: http://www.massimocorner.com/validator/samples/custom_pattern.htm Something along these lines (I haven't test it!): script type=text/javascript tmt_globalPatterns.year = new RegExp(^\([0-9]{2,4}\)$); /script Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: TMT validator, date validation...
Worked perfectly too. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- Just to point out, on the off chance others do not realize it. The provided regex will also accept a three digit year; 997 or 007. This may or may not be a problem depending on the use. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Fusion-Reactor?
Ok I noticed a lot of talk about www.fusion-reactor.com and was Wondering who all uses this utility and how is it working out for you? We have a client that is having server related issues and by the sounds of it, the product will work well for the given case if in fact it is solid enough. All comments welcome... ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: TMT validator, date validation...
Just to point out, on the off chance others do not realize it. The provided regex will also accept a three digit year; 997 or 007. This may or may not be a problem depending on the use. Yes, RegExp aren't the perfect solution for that, maybe validating using a range of valid numbers could be a better approach. The validator allows this as well: http://www.massimocorner.com/validator/samples/custom_validation.htm Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfdocument and images
Hello, I'm trying to create a flash paper report and I'm trying to embbed a jpeg in it and it won't display. Is this not supported? Thanks, - charles ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231801 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusion-Reactor?
We downloaded and installed the 10-day trial. In those ten days, we were able to find and solve all of the issues that were making our server unstable. We haven't needed to hand-restart CF since we finished. I can't say anything better than that. On 2/9/06, Adkins, Randy [EMAIL PROTECTED] wrote: Ok I noticed a lot of talk about www.fusion-reactor.com and was Wondering who all uses this utility and how is it working out for you? We have a client that is having server related issues and by the sounds of it, the product will work well for the given case if in fact it is solid enough. All comments welcome... ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231802 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
The videos are neat on the labs site, and it really does look powerful, but until they release pricing information (did I miss it somewhere?) then I won't even consider it. With the pressure Ajax is putting on things, Adober had better get the pricing figured out soon if Flex is ever to get decent developer mindshare. $15K was a joke for Flex1. Will it be dramatically different for Flex 2? Review of Flex 1 saying that MM isFlex expensive and that MM has a bad track record: http://www.digital-web.com/articles/macromedia_flex_and_flex_builder/ And another: http://www.lordalex.org/2004/12/macromedia-flex-is-it-really-flexible.php Anyone know what the pricing is going to be? I don't know how folks can get excited about it without this information. John McKown President, Delaware.Net ICQ: 1812513 We host Fusebox.org and all of our apps are Fusebox/ColdFusion/BlueDragon compliant. Judith Dinowitz wrote: Ben Forta is doing a tour promoting Flex 2 and ColdFusion, and I really think people should contact their local user group, find out when he's going to be there, and go. (Details are available on http://www.forta.com.) I'd like to invite anyone in the New York area to come to the NYCFUG Meeting on Tuesday, February 21st, at 6:30 PM. Seating is limited, so please RSVP at http://www.nycfug.org as early as possible. Attend this presentation (or one in your local area) to learn about the new Flex, as well as the new ColdFusion integration functionality, which will make ColdFusion an ideal back-end for Flex. Flex 2 is on the way, and this is your invitation to be one of the first to experience the future of rich Internet application development. A lot has changed in Flex 2, and you can read more about it on http://labs.macromedia.com/. With new pricing options, new deployment options, new back-end integration options, and a slew of new features, Flex 2 is going to change the way we build applications. And for ColdFusion developers, there has never been a better time to experience it. When? Tuesday, February 21st, 2006, 6:30 PM (the third Tuesday of the month) Where? NYU Medical Center, 550 1st Avenue (corner of E. 31st Street) Room: Alumni Hall A A copy of ColdFusion 7 Standard will be raffled off to one lucky attendee! We will be ordering food. Please RSVP on our site (http://www.nycfug.org) so that we can plan accordingly. Judith Dinowitz Co-Manager New York ColdFusion User Group (NYCFUG)http://www.nycfug.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231803 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: TMT validator, date validation...
Yeah... Forgot to mention that I removed the 2, from inside the brace set. I only want a 4 digit year. So the resulting regex read liks so: tmt_globalPatterns.year = new RegExp('^\([0-9]{4}\)$'); !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 1:30 PM To: CF-Talk Subject: RE: TMT validator, date validation... Worked perfectly too. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- Just to point out, on the off chance others do not realize it. The provided regex will also accept a three digit year; 997 or 007. This may or may not be a problem depending on the use. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231804 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Webservice woes.
Everytime you change a web service argument list or details of the arguments (like type) you MUST refresh the web service via CF Admin. Now stop pulling out your hair ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231805 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusion-Reactor?
That sounds well worth a lousy $99. Thanks for pointing out this product and for the feedback on it! -Jordan Jerry Johnson wrote: We downloaded and installed the 10-day trial. In those ten days, we were able to find and solve all of the issues that were making our server unstable. We haven't needed to hand-restart CF since we finished. I can't say anything better than that. On 2/9/06, Adkins, Randy [EMAIL PROTECTED] wrote: Ok I noticed a lot of talk about www.fusion-reactor.com and was Wondering who all uses this utility and how is it working out for you? We have a client that is having server related issues and by the sounds of it, the product will work well for the given case if in fact it is solid enough. All comments welcome... -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231806 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
Flex builder will be priced less than $1000 per developer. You will be able to get the compiler and framework for free. You will be able to get a limited version of Flex Enterprise services for free. Check out MXNA (http://weblogs.macromedia.com/mxna) for information. On 2/9/06, John McKown [EMAIL PROTECTED] wrote: The videos are neat on the labs site, and it really does look powerful, but until they release pricing information (did I miss it somewhere?) then I won't even consider it. With the pressure Ajax is putting on things, Adober had better get the pricing figured out soon if Flex is ever to get decent developer mindshare. $15K was a joke for Flex1. Will it be dramatically different for Flex 2? Review of Flex 1 saying that MM isFlex expensive and that MM has a bad track record: http://www.digital-web.com/articles/macromedia_flex_and_flex_builder/ And another: http://www.lordalex.org/2004/12/macromedia-flex-is-it-really-flexible.php Anyone know what the pricing is going to be? I don't know how folks can get excited about it without this information. John McKown President, Delaware.Net ICQ: 1812513 We host Fusebox.org and all of our apps are Fusebox/ColdFusion/BlueDragon compliant. Judith Dinowitz wrote: Ben Forta is doing a tour promoting Flex 2 and ColdFusion, and I really think people should contact their local user group, find out when he's going to be there, and go. (Details are available on http://www.forta.com.) I'd like to invite anyone in the New York area to come to the NYCFUG Meeting on Tuesday, February 21st, at 6:30 PM. Seating is limited, so please RSVP at http://www.nycfug.org as early as possible. Attend this presentation (or one in your local area) to learn about the new Flex, as well as the new ColdFusion integration functionality, which will make ColdFusion an ideal back-end for Flex. Flex 2 is on the way, and this is your invitation to be one of the first to experience the future of rich Internet application development. A lot has changed in Flex 2, and you can read more about it on http://labs.macromedia.com/. With new pricing options, new deployment options, new back-end integration options, and a slew of new features, Flex 2 is going to change the way we build applications. And for ColdFusion developers, there has never been a better time to experience it. When? Tuesday, February 21st, 2006, 6:30 PM (the third Tuesday of the month) Where? NYU Medical Center, 550 1st Avenue (corner of E. 31st Street) Room: Alumni Hall A A copy of ColdFusion 7 Standard will be raffled off to one lucky attendee! We will be ordering food. Please RSVP on our site (http://www.nycfug.org) so that we can plan accordingly. Judith Dinowitz Co-Manager New York ColdFusion User Group (NYCFUG)http://www.nycfug.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231807 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfdocument and images
Charles E. Heizer wrote: Hello, I'm trying to create a flash paper report and I'm trying to embbed a jpeg in it and it won't display. Is this not supported? JPG is supported: http://www.it.dev.duke.edu/temp/flashpaper_with_jpeg.cfm However, if I remember correctly, flash does not support progressive jpegs so you might want to check into that. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fusion-Reactor?
I do agree. If the 10-day trial version did that. I would not Delay in obtaining a license copy to run and monitor any problems That could surface in the future. -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 2:59 PM To: CF-Talk Subject: Re: Fusion-Reactor? That sounds well worth a lousy $99. Thanks for pointing out this product and for the feedback on it! -Jordan Jerry Johnson wrote: We downloaded and installed the 10-day trial. In those ten days, we were able to find and solve all of the issues that were making our server unstable. We haven't needed to hand-restart CF since we finished. I can't say anything better than that. On 2/9/06, Adkins, Randy [EMAIL PROTECTED] wrote: Ok I noticed a lot of talk about www.fusion-reactor.com and was Wondering who all uses this utility and how is it working out for you? We have a client that is having server related issues and by the sounds of it, the product will work well for the given case if in fact it is solid enough. All comments welcome... -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231809 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
flex is supposed to now be $1000 ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! From: John McKown [EMAIL PROTECTED] Sent: Thursday, February 09, 2006 2:53 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: OT: ColdFusion and Flex The videos are neat on the labs site, and it really does look powerful, but until they release pricing information (did I miss it somewhere?) then I won't even consider it. With the pressure Ajax is putting on things, Adober had better get the pricing figured out soon if Flex is ever to get decent developer mindshare. $15K was a joke for Flex1. Will it be dramatically different for Flex 2? Review of Flex 1 saying that MM isFlex expensive and that MM has a bad track record: http://www.digital-web.com/articles/macromedia_flex_and_flex_builder/ And another: http://www.lordalex.org/2004/12/macromedia-flex-is-it-really-flexible.php Anyone know what the pricing is going to be? I don't know how folks can get excited about it without this information. John McKown President, Delaware.Net ICQ: 1812513 We host Fusebox.org and all of our apps are Fusebox/ColdFusion/BlueDragon compliant. Judith Dinowitz wrote: Ben Forta is doing a tour promoting Flex 2 and ColdFusion, and I really think people should contact their local user group, find out when he's going to be there, and go. (Details are available on http://www.forta.com.) I'd like to invite anyone in the New York area to come to the NYCFUG Meeting on Tuesday, February 21st, at 6:30 PM. Seating is limited, so please RSVP at http://www.nycfug.org as early as possible. Attend this presentation (or one in your local area) to learn about the new Flex, as well as the new ColdFusion integration functionality, which will make ColdFusion an ideal back-end for Flex. Flex 2 is on the way, and this is your invitation to be one of the first to experience the future of rich Internet application development. A lot has changed in Flex 2, and you can read more about it on http://labs.macromedia.com/. With new pricing options, new deployment options, new back-end integration options, and a slew of new features, Flex 2 is going to change the way we build applications. And for ColdFusion developers, there has never been a better time to experience it. When? Tuesday, February 21st, 2006, 6:30 PM (the third Tuesday of the month) Where? NYU Medical Center, 550 1st Avenue (corner of E. 31st Street) Room: Alumni Hall A A copy of ColdFusion 7 Standard will be raffled off to one lucky attendee! We will be ordering food. Please RSVP on our site (http://www.nycfug.org) so that we can plan accordingly. Judith Dinowitz Co-Manager New York ColdFusion User Group (NYCFUG)http://www.nycfug.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusion-Reactor?
What type of problems did it show you that fixed your issues? I have not had a chance to really read through the site, but is it essentially a monitoring tool to allow you to see problems or does it do more than that? On 2/9/06, Jerry Johnson [EMAIL PROTECTED] wrote: We downloaded and installed the 10-day trial. In those ten days, we were able to find and solve all of the issues that were making our server unstable. We haven't needed to hand-restart CF since we finished. I can't say anything better than that. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231811 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusion-Reactor?
On 2/9/06, Adkins, Randy [EMAIL PROTECTED] wrote: I do agree. If the 10-day trial version did that. I would not Delay in obtaining a license copy to run and monitor any problems That could surface in the future. It should be noted that there is another product out there called SeeFusion which is in the same exact space and is a very solid product (and cheaper). I am in the process of evaluating both and hope to blog my experience with each when all is said and done. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Passing LAST_INSERT_ID() from one fuction to another
I'm having trouble passing LAST_INSERT_ID() from one function to another. I'm new to CFC and not sure how this is done or if I have layout the cfc correctly with THIS. cfcomponent cfset THIS.contactID = cfset THIS.firstName = cfset THIS.lastName = cffunction name=addContact access=public cftransaction cfquery name=qaddContact datasource=#dsn# INSERT INTO Contacts (firstName ,lastName ) VALUES ('#(THIS.firstName)#' ,'#(THIS.lastName)#' ) /cfquery cfquery name=lastRec datasource=kroad SELECT LAST_INSERT_ID() as lastid /cfquery cfset THIS.contactID = lastRec.lastid /cftransaction /cffunction cffunction name=getLastContact returntype=query access=public cfquery name=qGetLastContact datasource=#dsn# SELECT * FROM contacts WHERE contacts.contactID = #THIS.contactID# /cfquery cfreturn qGetLastContact /cffunction /cfcomponent ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231816 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54