Re: Deleting Attachments Immediately After CFMAIL
Nathan Wells wrote: Does anybody know how attachments work in CF 8? Same as in 7. Has anyone heard of future plans by Adobe to allow attached files to be automatically deleted after the spool file has been processed. Maybe something similar to the cfcontent tag? cfmailparam file=#theFullFilePath# delete=yes I like that idea. Did you submit it? http://www.adobe.com/go/wish/ And finally, has anyone ever tried to somehow force the contents of the file into the body of the email so it is indeed written to the spool file? I couldn't get it to work with the CF mail spool. It is pretty easy to use another mail spool or Javamail. Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Stored Procedure Help!
Jessica Kennedy wrote: I have looked over the various methods for displaying hierarchal data with MySql, and there don't really seem to be many elegant solutions-- the best method (according to many) seemed to be creating a column for lft rgt values as a nested tree structure That is called a nested set and is pretty much optimized for reading. which is completely impractical in this situation because I would have to re-assign those variable every single time somebody inserted a record into my database (which should be many times/day). How many is many? Let's say that recalculating your nested set is going to take 15 seconds every time it is updated. Is that really a problem? I found the syntax here: http://www.evolt.org/node/4047 however, I know basically nothing about proper syntax for stored procedures, and have really not found a lot that has helped. Why, oh, why is this syntax giving me errors? Because that syntax is for MS SQL Server 6.5 and you are using MySQL. Equally as important, does this method of creating a temp table seem like an appropriate solution to my problem? Not if you intend to do this on every request. What I have done before is used a denormalized model where the records themselves had an adjacency list model, but I maintained a nested set in a separate table. With a trigger on the records themselves that only fired when the ID and/or parentID fields changed and updated the nested set the rest of my code could use either the adjacency list or the nested set depending on what was easiest. The only thing to watch out for is the way you handle concurrency issues in your trigger code. Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF7 verity indexing of PDFs
I can't seem to get verity to index PDFs properly. I can index a PDF, check the collection in CFADMIN which shows the doc is indexed. I can the pick a phrase from the PDF, seach against it and I get 1 result. The problem is the result only shows a summary. If a CFDUMP the context field is empty. The fact the the correct document is identified by a phrase search tells me Verity has indexed the doc and knows the phrase exists (and where). But it won't yield this information back in the returned results query. Any ideas where I'm going wrong? Any other advice on how to get the best from Verity would be much appreciated. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sending data to Actionpage
Thanks Dale its working perfectly!!! ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfinput button image
Hi, just wondering if it is possible if i can have a cfinput of type button and then place a small image in the button instead of text. i have tried the cfinput type image but of course it only shows the image and not the appearance of the button with an image in it thanks ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with login in the Application.cfc (saving additional info in the session scope)
The problem is not when the session ends, but when the user enters again to the system after his(her) session ended. The applications shows the login template, the user enter the user name and password and the application (I do not know how) authenticates the user and let him(her) to enter without running my: cfset roles=session.security.login(cflogin.name,cflogin.password) Nor my: cfloginuser name=#cflogin.name# Password=#cflogin.password# roles =#roles# And that is why I end up with a loged in user without my âsession.userInfoâ variable. I already try loging out the user in the onSessionEnd but it did not work either. My solution works but I want to know why is this happening because sometimes its authenticates and sometimes not. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I want to re-authenticate the user
Have you ticked the j2ee session variables checkbox in the cf administrator under memory variables. not sure if this will help it but i have had alot of problems with session variables if this is not ticked as the session remains active even if you close the browser. when this is ticked it deletes all session variables when the browser closes ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Submit button is adding more documents! Help!
When I click on the button I have reviewed and understand this document, the #endnum# and #countnum# add a higher number of documents than what is actually there. For example, if I went to the page, it would display the correct info Viewing records 1 - 6 of 6 total. As soon I click on one of the documents button, it will display, Viewing records 1 - 15 of 41 total. I'm not sure why its adding extra documents and why the counts are increasing. cfif parameterexists(orderBy)ORDER BY #orderBy# cfelseORDER BY docTitle/cfif /cfquery cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex# cfelseif parameterexists(URL.startindex) cfset startnum = #URL.startindex# cfelse cfset startnum=1 /cfif cfset count = 0 cfoutput query=getdocs cfset count=#count#+1/cfoutput cfoutput cfset endnum = #startnum# +14 cfif #endnum# GT #count#cfset endnum = #count#/cfif cfset prev=#startnum# - 15 cfset next=#endnum# +1 p align=centerb#getdocs.RecordCount# documents found./b br cfif getdocs.RecordCount GT 0 Viewing records #startnum# - #endnum# of #count# total.br table tr tdcfif #startnum# GTE 15 cfform action=documents.cfm?#CGI.QUERY_STRING# method=POST enablecab=Yes input type=hidden name=startindex value=#prev# input type=hidden name=DepartmentID value=#DepartmentID# input type=hidden name=subdirectory value=#subdirectory# cfif parameterexists(docType)input type=hidden name=docType value=#docType#/cfif input border=0 src=../docs/prev.jpg type=image vspace=4 /cfform /cfif/td tdcfif #count# GTE #next# cfform action=documents.cfm?#CGI.QUERY_STRING# method=POST enablecab=Yes input type=hidden name=startindex value=#next# input type=hidden name=DepartmentID value=#DepartmentID# input type=hidden name=subdirectory value=#subdirectory# cfif parameterexists(docType)input type=hidden name=docType value=#docType#/cfif input border=0 src=../docs/next.jpg type=image vspace=4 /cfform /cfif/td /tr /table /cfif cfset reccount = #startnum# - 1 cfoutput query=getdocs maxrows=15 startrow=#startnum# cfset reccount = #reccount# +1 p align=left !---b#reccount#.nbsp;/b--- cfif #getdocs.deptRestriction# EQ 0 OR #session.deptID# NEQ #getdocs.deptRestriction# a href=#docstorage#/#docName# target=_blankb#docTitle#/b /a cfelseb#docTitle# (Secured Document) /b /cfif font size=-2Date: #DateFormat(lastupdate, MM/DD/YY)# Rev ##: cfif #revision# is 0Initialcfelse#revision#/cfif nbsp;nbsp;nbsp;nbsp;nbsp;/font font size=-1brb#docNumber#/bbr/font font size=-2Summary: i#Left(summary, 125)#nbsp;nbsp;nbsp;(a href=../docs/view.cfm?docID=#docID#see more/a)/i/font cfif ActionType NEQ 'R' cfform action=../docs/docActionLog.cfm?#CGI.QUERY_STRING# input type=hidden name=startnum value=#startnum# input type=hidden name=DocName value=#docName# input type=hidden name=DocID value=#DocID# input type=hidden name=DocAction value=R input type=submit value=I have reviewed and understand this document /cfform /cfif /p /cfoutput cfoutput p align=center cfif getdocs.RecordCount GT 0 Viewing records #startnum# - #endnum# of #count# total.br table tr tdcfif #startnum# GTE 15 cfform action=documents.cfm?#CGI.QUERY_STRING# method=POST enablecab=Yes input type=hidden name=startindex value=#prev# input type=hidden name=DepartmentID value=#DepartmentID# input type=hidden name=subdirectory value=#subdirectory# cfif parameterexists(docType)input type=hidden name=docType value=#docType#/cfif input border=0 src=../docs/prev.jpg type=image vspace=4 /cfform /cfif/td tdcfif #count# GTE #next# cfform action=documents.cfm?#CGI.QUERY_STRING# method=POST enablecab=Yes input type=hidden name=startindex value=#next# input type=hidden name=DepartmentID value=#DepartmentID# input type=hidden name=subdirectory value=#subdirectory# cfif parameterexists(docType)input type=hidden name=docType
Re: Returning and object from a Web Service
Does anyone else have any thoughts on how to return an object directly with a CF based web service without having to convert it to a structure or query? Thanks, Dean On 10/24/07, Dean Lawrence [EMAIL PROTECTED] wrote: Hi Brad, I'm running CF8 on Windows 2003 and yes it is a CFC. I can return structures, arrays, queries and single values, but I can't return the object itself. I can access the object from within the method and use it to populate the structures and values, but if I try to just return the object, it throws the error. Is there any additional attributes that I need to set to serialize the CFC in CF8? Thanks, Dean On 10/24/07, Brad Wood [EMAIL PROTECTED] wrote: What version of CF? Does the object happen to be a CFC? CFC's are not serializable in CF 8. Try returning a struct of values if can. ~Brad -Original Message- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 4:30 PM To: CF-Talk Subject: Returning and object from a Web Service When calling a web service that I created (which is being used as a gateway), if I try to return an object I get an error that states org.xml.sax.SAXException: No deserializer for and then my object name. If I get the object and then return individual values from that object, it works fine. But if I try to return the whole object, I get the error. From Googling, I believe that I somehow have to some additional reference to the location of the object definition but I don't know where that would be. In the wsdl file? If this is the case, where in the file does it go? Can anyone point me in the right direction? Thanks, Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfinput button image
hi matt thanks for the feedback very good idea, ill just do the graphic, i thought that maybe there was a way to do it with the cfinput but never mind, thanks again ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
Janet MacKay wrote: What version are you using? I don't notice the problem with mx 7.0.2 ColdFusion Server Developer 7,0,2,142559 on SQL Server 9.0.3054 via ODBC connection. Dave Watts wrote: Why do you have SET NOCOUNT in the first place? The resulset generated by the insert can prevent cfquery from picking up the SELECT @@identity statement. SET NOCOUNT supresses the insert's resulset. Sounds good to me. Truth is, that's how I had learned to do it years back and it's stuck. Though they should be using SCOPE_IDENTITY() Learn something new everyday... thanks. I'm now using SCOPE_IDENTITY(). Interestingly enough, I tried running the query without SET NOCOUNT and it seems to be working fine (with @@IDENTITY and SCOPE_IDENTITY() ). So now I'm confused by the need for it. Have later versions of CF learned how to deal the extra data? Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Stored Procedure Help!
Jessica Kennedy wrote: I have looked over the various methods for displaying hierarchal data with MySql, and there don't really seem to be many elegant solutions-- the best method (according to many) seemed to be creating a column for lft rgt values as a nested tree structure That is called a nested set and is pretty much optimized for reading. Well, there will be three functions I intend to use this thing for... finding the first available slot for placing someone in a downline- which will probably be used between 20 50 times/day, viewing a particular person's downline, which could be used hundreds or thousands of times per day, calculating bonuses for each person based on their own particular downline, which will be done once weekly. I guess reading will be what is done most in this instance. which is completely impractical in this situation because I would have to re-assign those variable every single time somebody inserted a record into my database (which should be many times/day). How many is many? Let's say that recalculating your nested set is going to take 15 seconds every time it is updated. Is that really a problem? Well... that IS a good point... =) I found the syntax here: http://www.evolt.org/node/4047 however, I know basically nothing about proper syntax for stored procedures, and have really not found a lot that has helped. Why, oh, why is this syntax giving me errors? Because that syntax is for MS SQL Server 6.5 and you are using MySQL. Still don't know the syntax... but it looks like this model is out anyway, so it doesn't matter. Equally as important, does this method of creating a temp table seem like an appropriate solution to my problem? Not if you intend to do this on every request. well, that was the plan. so yeah, guess this is out. What I have done before is used a denormalized model where the records themselves had an adjacency list model, but I maintained a nested set in a separate table. With a trigger on the records themselves that only fired when the ID and/or parentID fields changed and updated the nested set the rest of my code could use either the adjacency list or the nested set depending on what was easiest. The only thing to watch out for is the way you handle concurrency issues in your trigger code. This paragraph confused me to no end, could you please explain a little more? thanks! Jessica ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 verity indexing of PDFs
Did you remember to enable it in your cfsearch tag? By default cfsearch won't return context information. You have to specify contextPassages with a # greater than 0. On 10/26/07, Matt Barfoot [EMAIL PROTECTED] wrote: I can't seem to get verity to index PDFs properly. I can index a PDF, check the collection in CFADMIN which shows the doc is indexed. I can the pick a phrase from the PDF, seach against it and I get 1 result. The problem is the result only shows a summary. If a CFDUMP the context field is empty. The fact the the correct document is identified by a phrase search tells me Verity has indexed the doc and knows the phrase exists (and where). But it won't yield this information back in the returned results query. Any ideas where I'm going wrong? Any other advice on how to get the best from Verity would be much appreciated. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfinput button image
Hello Richard, You could do with with css just do: div id=mydiv img id=myimg src=blah.. / cfinput ... / /div then in head or stylesheet of presentation page style div#mydiv {position: relative} img#myimg {position: absolute; top 5px; left 75px;} /style Obviously amend top, left to suit. I haven't tested, but you may have an issue with what is on top the image or the button. If you have an issue try adding z-index:10. You would have to verify you happy with the results x-browser. Whilst possible this not a good way to go about things! I would suggest a better approach is simply to create your button graphic with the appopriate image in it already as this is much more standards compliant. Placing an image on top of a button is likely to affect clicking of the button if the image obscures a large part of the button. The way around this would be to assign an event handler to the onclick event of the image, but this is a whole load of work when you could simple create the button with the appropriate image in it already!! Thanks, Matt -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: 26 October 2007 14:39 To: CF-Talk Subject: cfinput button image Hi, just wondering if it is possible if i can have a cfinput of type button and then place a small image in the button instead of text. i have tried the cfinput type image but of course it only shows the image and not the appearance of the button with an image in it thanks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfdocument and a bar code graphic
I am trying to create a pdf which will be the cover sheet for a job system. On the PDF is a bar code graphic, the problem is that, once the pdf is created, unless you view the pdf at about 30% scale, you either don't see the graphic or is looks faded. Has anyone had problems with graphics appearing on a PDF created by cfdocument. More to the point, how does it look when the PDF is printed out? Is it a requirment to scan the barcode on a screen? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Submit button is adding more documents! Help!
Wow, old code... Before I even attempt to answer the question. What version of ColdFusion are you running this on? The reasons I ask are as follows: ParameterExists has been deprecated since version 4/4.5 or thereabouts. - use isDefined or even better, StructKeyExists instead. Code like this: cfif #endnum# GT #count#cfset endnum = #count#/cfif Can and should be written like this cfif endnum GT count cfset endnum = count /cfif and cfset count=#count#+1 Should read at least as cfset count = count + 1 and if you have CF8 you could use the new ++ operator :-) Now onto answering your question... It appears the critical part of your code is missing from your post. I cannot see the cfquery that actually retrieves the documents from the database cfquery name=getDocs ... Without seeing that (which is most likely where the logic error is), it's almost impossible to answer this question. Yours Paul ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Deleting Attachments Immediately After CFMAIL
Nathan, Thanks a lot for the references. They both look very promising for our needs. Our applications don't send that many emails, but I knew I wasn't the first one to run into problems like this. You saved me some time searching in the dark. I went ahead and blogged an fully working example using the technique Jon Wolski pointed out on Charlie Arehart's blog: http://blog.pengoworks.com/blogger/index.cfm?action=blog:610 My example also shows using embedded images in an HTML message. -Dan ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Returning and object from a Web Service
When calling a web service that I created (which is being used as a gateway), if I try to return an object I get an error that states org.xml.sax.SAXException: No deserializer for and then my object name. If I get the object and then return individual values from that object, it works fine. But if I try to return the whole object, I get the error. What type of CFC object are you trying to return... More the case is it in the same directory as the webservice? Or does it use a mapping? If a mapping, try using a CFC that is in the same directory as the web service. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQueryParam apostrophe problem when using SET NOCOUNT
Interestingly enough, I tried running the query without SET NOCOUNT and it seems to be working fine (with @@IDENTITY and SCOPE_IDENTITY() ). So now I'm confused by the need for it. Have later versions of CF learned how to deal the extra data? It could be that you're using ODBC. I usually use jdbc and most versions I've used won't return the second SELECT to cfquery unless I use SET NOCOUNT. I assume its because cfquery detects the first resultset (ie rows affected by the insert) and ignores any further resultsets. Perhaps ODBC behaves differently? Janet ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Returning and object from a Web Service
What type of CFC object are you trying to return... More the case is it in the same directory as the webservice? Or does it use a mapping? If a mapping, try using a CFC that is in the same directory as the web service. It is a simple User object that I created (usrname, password, etc.). It is located in a subdirectory below the web service itself. I can call it and use it within the webservice method call, but if I try to return it directly or as an element of an array (i.e. cfreturn User /), I get the error message that I originally posted. Instead I need to break it apart and either need to return individual element values, place each value into a structure, or return a query instead. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Submit button is adding more documents! Help!
Wow, old code... Before I even attempt to answer the question. What version of ColdFusion are you running this on? The reasons I ask are as follows: ParameterExists has been deprecated since version 4/4.5 or thereabouts. - use isDefined or even better, StructKeyExists instead. Code like this: cfif #endnum# GT #count#cfset endnum = #count#/cfif Can and should be written like this cfif endnum GT count cfset endnum = count /cfif and cfset count=#count#+1 Should read at least as cfset count = count + 1 and if you have CF8 you could use the new ++ operator :-) Now onto answering your question... It appears the critical part of your code is missing from your post. I cannot see the cfquery that actually retrieves the documents from the database cfquery name=getDocs ... Without seeing that (which is most likely where the logic error is), it's almost impossible to answer this question. Yours Paul Paul, Here is the query: I'm using version MX which i think is 5; thanks cfquery datasource=#data# name=getdocs SELECT * FROM docs LEFT OUTER JOIN DocActionLog DAL ON docs.docID = DAL.DocID and DAL.EmployeeID = #session.EmployeeID# and DAL.ActionType = 'R' WHERE docResponseID = '#getDept.DeptResponsibleID#' cfif parameterexists(docType)AND docTypeID in (#PreserveSingleQuotes(docType)#)/cfif cfif parameterexists(startsWith)AND cfif #startsWith# is 0 (docTitle between '0' AND 'A') cfelseif #startsWith# is A (docTitle between 'A' and 'E') cfelseif #startsWith# is E (docTitle between 'E' and 'I') cfelseif #startsWith# is I (docTitle between 'I' and 'M') cfelseif #startsWith# is M (docTitle between 'M' and 'Q') cfelseif #startsWith# is Q (docTitle between 'Q' and 'T') cfelseif #startsWith# is T (docTitle between 'T' and 'W') cfelseif #startsWith# is W (docTitle 'W') cfelse docTitle IS NOT Null /cfif /cfif cfif parameterexists(orderBy)ORDER BY #orderBy# cfelseORDER BY docTitle/cfif /cfquery ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
Interestingly enough, I tried running the query without SET NOCOUNT and it seems to be working fine (with @@IDENTITY and SCOPE_IDENTITY() ). So now I'm confused by the need for it. Have later versions of CF learned how to deal the extra data? I've never had to use SET NOCOUNT with @@IDENTITY or SCOPE_IDENTITY(). I've been using INSERT INTO followed by SELECT ... @@IDENTITY since SQL Server 6.5 and CF 1.5. 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! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Calendar with Recurring Events
Can anyone suggest a CF calendar that allows for recurring events? I am working on a project which requires this. The project is Farcry-based but Im just looking for an example of how to manage the data. Anything will help. Thanks! _ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 HYPERLINK http://www.cfwebtools.comhttp://www.cfwebtools.com 402-408-3733 x103 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.11/1093 - Release Date: 10/25/2007 5:38 PM ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Returning and object from a Web Service
Dean, A shot in the dark, but do you have cfproperty .. defined for the attributes of your User object that you are trying to return? Thanks Qasim On 10/26/07, Dean Lawrence [EMAIL PROTECTED] wrote: What type of CFC object are you trying to return... More the case is it in the same directory as the webservice? Or does it use a mapping? If a mapping, try using a CFC that is in the same directory as the web service. It is a simple User object that I created (usrname, password, etc.). It is located in a subdirectory below the web service itself. I can call it and use it within the webservice method call, but if I try to return it directly or as an element of an array (i.e. cfreturn User /), I get the error message that I originally posted. Instead I need to break it apart and either need to return individual element values, place each value into a structure, or return a query instead. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFML engine compatibility - a possible solution?
I've just started a bit of a spat on the BD list about CFML syntax compatibility and consistency... for instance how there are at least 3 different implementations of CFTHREAD (CF7 POC, CF8 and BD7). Anyway as I was replying it occured to me that life and support for developing CFML based code that ran safely and reliably on all CFML engines would be much easier if we had the equivalent of compiler directives for CFML engines... Comments welcome :-) Paul ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Stored Procedure Help!
Jessica Kennedy wrote: Jochem van Dieten wrote: What I have done before is used a denormalized model where the records themselves had an adjacency list model, but I maintained a nested set in a separate table. With a trigger on the records themselves that only fired when the ID and/or parentID fields changed and updated the nested set the rest of my code could use either the adjacency list or the nested set depending on what was easiest. The only thing to watch out for is the way you handle concurrency issues in your trigger code. This paragraph confused me to no end, could you please explain a little more? Suppose you have the following datamodel for pages on your website: pageID INTEGER, parent_pageID INTEGER, pageRank INTEGER, title TEXT, body TEXT, author INTEGER, lastChangeDate TIMESTAMP, etc. You build a tree from this for displaying with the elements where parent_pageID equals pageID as the root elements sorted by pageRank. Every page with a pageID X has children with parent_pageID X ordered by pageRank. This is your basic adjacency list model. Easy to change, unlimited depth and width, but you have to do something recursive to read the tree. So we add the following table: pageTree: lft INTEGER, rgt INTEGER, pageID INTEGER Now we write a procedure to update the pageTree table: DELETE FROM pageTree; INSERT INTO pageTree (lft, rgt, pageID) SELECT recursive or 22 left join query goes here; Then we create a trigger on the pages table so that on every insert or delete and every update where pageID or parent_pageID changed the procedure to update pageTree is called so the pageTree table is always in sync with the pages table. And as the last step we make sure that all reads that read the entire tree are changed so they don't use the original recursive solution anymore but use a simple query against the join of pageTree and pages. Jochem ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Calendar with Recurring Events
Hi Jake- A couple years back, I was involved with a project where had to do this exact thing for a client. Here's a few things that might help get you started. The calendar allowed for both recurring and concurring events, although I don't have the ability to do recurring events that span multiple days (yikes!). Here's the basic database structure I used. There's actually more, but I left only the parts that deal with recurrence: Events -- EventID (int) PK Name (varchar) StartDate (date) EndDate (date) Recurring (boolean) RecurringValue (int) RecurringInterval (varchar) RecurringEndDate (date) RecurringParentID (int) EventDays - EventDayID (int) EventID (int) FK DayInterval (int) Obviously, when the Recurring field is true, then we're dealing with a recurring event. RecurringValue and RecurringInterval work together, so let's say you have an event that recurs every 3 days, RecurringValue would be 3 and RecurringInterval would be day RecurringInterval can be day, week, month, or year. RecurringEndDate is the day when the recurring event ends, obviously. In my system this is optional, so a RecurringEndDate that is NULL never ends! RecurringParentID is used when there is a split, either if someone changes information about the recurring event mid stream (like apply these changes to this and all future dates) or deletes a single occurrence, etc. That's really one of the biggest pains in the system is dealing with those. The EventDays table keeps track of things like lets say you want an event to take place every two weeks on Monday, Wednesday, and Friday. Then I would have three DayInterval entries for 2 (Mon), 4 (Wed), and 6 (Fri) in the database. It also keeps track of Monthly settings like Every second Tuesday of the week. I hope this helps get you going in the right direction. I would love to share the code base with you, but don't think the client would appreciate that much, but please let me know if you have any more questions and I'll be happy to help! -- Ryan J. Heldt Senior Web Developer Global Reach Internet Productions http://www.globalreach.com Phone: 515-296-0792, Fax: 515-296-3748 -Original Message- From: Jake Churchill [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 10:05 AM To: CF-Talk Subject: Calendar with Recurring Events Can anyone suggest a CF calendar that allows for recurring events? I am working on a project which requires this. The project is Farcry-based but I'm just looking for an example of how to manage the data. Anything will help. Thanks! _ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 HYPERLINK http://www.cfwebtools.comhttp://www.cfwebtools.com 402-408-3733 x103 ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Create a webservice to accept an array of structures/components
Goal: To create a webservice that can accept an array of structures/components. Problem: The webservice will not accept the array of structures/components passed to it. Code: 1) The following is the code that creates the array of structures/components and invokes the webservice. (Testws.cfm) cfoutput !--- Creat Test Game Object --- cfset arrGame = ArrayNew(1) cfloop index=i from=1 to=5 cfset arrGame[i] = CreateObject(component, gameTest) cfset arrGame[i].setGameID(ToString(i)) cfset arrGame[i].setHomeSSID(OHSSTEST i) /cfloop barrGame:/bbrcfdump var=#arrGame# cfinvoke webservice=http://dev.schedulestar.com/Tim/webservicetest.cfc?wsdl; method=complextype1 returnvariable=serviceResult Games=#arrGame# brbrbserviceResult:/bbrcfdump var=#serviceResult# /cfoutput 2) The following is the code for the web service (webservicetest.cfc) cfcomponent cffunction name=complextype1 returntype=gameTest[] access=remote cfargument name=Games type=gameTest[] required=yes cfset arrGame = arraynew(1) !--- Return Variable --- !--- Creat Game --- cfloop index=s from=1 to=#arraylen(Games)# cfset arrGame[s] = CreateObject(component, gameTest) cfset arrGame[s].setGameID(ToString(s)) cfset arrGame[s].setHomeSSID(Games[s].getHomeSSID) /cfloop cfreturn arrGame /cffunction /cfcomponent 3) The following is the component. An array of this component is made and passed to the webservice. (gameTest.cfc) cfcomponent cfproperty name=GameID type=string cfproperty name=HomeSSID type=string !--- Initialize --- cfscript this.GameID = 0; this.HomeSSID = ; /cfscript !--- Methods --- cffunction name=getGameID access=public returntype=string cfreturn this.GameID /cffunction cffunction name=setGameID access=public cfargument name=game type=string required=yes cfset this.GameID = game /cffunction cffunction name=getHomeSSID access=public returntype=string cfreturn this.HomeSSID /cffunction cffunction name=setHomeSSID access=public cfargument name=ssid type=string required=yes cfset this.HomeSSID = ssid /cffunction /cfcomponent Basically, the testWS.cfm file creates an array of the component and passes it to the webservice. No matter what I try to do, errors continue to be thrown. I believe the problem is in the code for the webservice. Thank you for your help. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
Dave, I have always used the SET NOCOUNT when doing an insert followed by a select - especially if there is a logic block in the query. But you make me wonder if that choice was superflous. -mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 10:11 AM To: CF-Talk Subject: RE: CFQueryParam apostrophe problem when using SET NOCOUNT Interestingly enough, I tried running the query without SET NOCOUNT and it seems to be working fine (with @@IDENTITY and SCOPE_IDENTITY() ). So now I'm confused by the need for it. Have later versions of CF learned how to deal the extra data? I've never had to use SET NOCOUNT with @@IDENTITY or SCOPE_IDENTITY(). I've been using INSERT INTO followed by SELECT ... @@IDENTITY since SQL Server 6.5 and CF 1.5. 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! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deleting Attachments Immediately After CFMAIL
Dan G. Switzer, II wrote: I went ahead and blogged an fully working example using the technique Jon Wolski pointed out on Charlie Arehart's blog: http://blog.pengoworks.com/blogger/index.cfm?action=blog:610 My example also shows using embedded images in an HTML message. Unfortunately your example produces messages that will not result in the desired rendering on conforming MUAs. Your attachments should be on the outermost MIME part, not nested somewhere in the middle. I.e, you have: multipart/alternative multipart/mixed HTML txt pdf img (attachment) img (inline) application/unsupported It should be: multipart/mixed multipart/alternative multipart/related HTML img (inline) txt pdf img (attachment) In Thunderbird I see a message with 4 attachments for your example. Jochem ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
It could be that you're using ODBC. I usually use jdbc and most versions I've used won't return the second SELECT to cfquery unless I use SET NOCOUNT. I assume its because cfquery detects the first resultset (ie rows affected by the insert) and ignores any further resultsets. Perhaps ODBC behaves differently? It's worked fine for me with ODBC and JDBC. The INSERT doesn't return a recordset, the SELECT does. I may well have just been extremely lucky, I guess, but I wouldn't think this is required. You are aliasing the @@IDENTITY value, right? 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! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFML engine compatibility - a possible solution?
Anyway as I was replying it occured to me that life and support for developing CFML based code that ran safely and reliably on all CFML engines would be much easier if we had the equivalent of compiler directives for CFML engines... It would be easier to standardize all the CFML engines to behave the same way than it would be to standardize them all to behave differently (that is, recognize compiler directives). But that is the point I originally raised on the BD list... At the moment I'm getting a hiding for it! For me though looking at other languages that are in a similar position, compiler directives seem to work very well indeed... Delphi and FreePascal for instance are both basically object pascal and with judicious use of compiler directives the same source code can compile on both platforms. Seeing as CF for the most part is now compiled (to a point), it makes sense that compiler directives would work given the already fractured state of the development of the CFML language itself. Paul ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFML engine compatibility - a possible solution?
Anyway as I was replying it occured to me that life and support for developing CFML based code that ran safely and reliably on all CFML engines would be much easier if we had the equivalent of compiler directives for CFML engines... It would be easier to standardize all the CFML engines to behave the same way than it would be to standardize them all to behave differently (that is, recognize compiler directives). 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! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQueryParam apostrophe problem when using SET NOCOUNT
I've never had to use SET NOCOUNT with @@IDENTITY or SCOPE_IDENTITY(). I've been using INSERT INTO followed by SELECT ... @@IDENTITY since SQL Server 6.5 and CF 1.5. I believe it. It works for me without SET NOCOUNT in 7.0.2. But I seem to recall using some version or combination where it didn't work without using SET NOCOUNT. CF would report #queryName.columnName# was undefined. I don't know enough about the inner workings to say whether it was due to the CF version, datasource type, MS SQL version or one of its settings. But after that experience I always used SET NOCOUNT to ensure cfquery always detected the SELECT as the one and only resultset returned by the enclosed sql statements. Even if it wasn't necessary. Janet ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Calendar with Recurring Events
On 10/26/07, Jake Churchill [EMAIL PROTECTED] wrote: Can anyone suggest a CF calendar that allows for recurring events? I am working on a project which requires this. The project is Farcry-based but I'm just looking for an example of how to manage the data. Anything will help. http://kalendar.riaforge.org/ -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinput button image
If you do this and then do anything like isdefined(form.submit) or structkeyexists that you either need to use a different form field or put a hidden filed in called submit. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
Yes... Of course - @@Identity won't come back without an alias... Nor will scope_identity() Perhaps this is one of those settings that defaults on the server or in the driver and therefore it could blow up if the setting is changed. I could swear that I had to set it OFF in order to get back @@Identity. I've been doing it since CF 4.x. But perhaps I just borrowed it from Query analyzer or a stored proc or something. -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 12:03 PM To: CF-Talk Subject: RE: CFQueryParam apostrophe problem when using SET NOCOUNT It could be that you're using ODBC. I usually use jdbc and most versions I've used won't return the second SELECT to cfquery unless I use SET NOCOUNT. I assume its because cfquery detects the first resultset (ie rows affected by the insert) and ignores any further resultsets. Perhaps ODBC behaves differently? It's worked fine for me with ODBC and JDBC. The INSERT doesn't return a recordset, the SELECT does. I may well have just been extremely lucky, I guess, but I wouldn't think this is required. You are aliasing the @@IDENTITY value, right? 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! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Windows/SQL Server error, anyone have any ideas?
One of our 4 servers all of a sudden started throwing CryptoAPI errors. Literally one second it was working, the next it wasn't. Our guys are looking into it, but I thought I might ask the list and see if anyone had any ideas. The exact error: [Macromedia][SQLServer JDBC Driver][SQLServer]CryptoAPI function 'CryptAcquireContext' failed. Error 0x57: The parameter is incorrect. Anyone? Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQueryParam apostrophe problem when using SET NOCOUNT
It's worked fine for me with ODBC and JDBC. The INSERT doesn't return a recordset, the SELECT does. I may well have just been extremely lucky, I guess, but I wouldn't think this is required. You are aliasing the @@IDENTITY value, right? Yes, I was using an alias. I think what I'm remembering has to do with plain jdbc and how it handles this statement: INSERT INTO TheTable (Column) VALUES ('test'); SELECT @@IDENTITY AS TheIdentityValue; A statement.execute() would return two results (loosely speaking). The first being a count of rows affected by the INSERT and the second the resultset returned by the SELECT. If you were to assume the resultset was in the first position, and simply called statement.getResultSet(), you wouldn't find the column TheIdentityValue. For that you have to cycle through the results using statement.getMoreResults(). I could be totally wrong here, but I think that might have been the cause of the problem I'm remembering. ie cfquery was only expecting a single set of results and ignored anything after the first one. That would explain why #queryName.columnName# was reported undefined. Janet ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
Dave Watts wrote: It's worked fine for me with ODBC and JDBC. The INSERT doesn't return a recordset, the SELECT does. I may well have just been extremely lucky, I guess, but I wouldn't think this is required. You are aliasing the @@IDENTITY value, right? Dave: Yes, aliasing it as follows: SELECT ThisID = @@IDENTITY And then after the CFQUERY ends, just using queryName.ThisID. Also, I don't think the problem has to do with a returned record set but with SQL Server returning some other meta-data and information (i.e., X rows inserted/affected, etc.). -- Mosh Teitelbaum evoch, LLC WWW: http://www.evoch.com/ ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
Janet MacKay wrote: I believe it. It works for me without SET NOCOUNT in 7.0.2. But I seem to recall using some version or combination where it didn't work without using SET NOCOUNT. CF would report #queryName.columnName# was undefined. I don't know enough about the inner workings to say whether it was due to the CF version, datasource type, MS SQL version or one of its settings. But after that experience I always used SET NOCOUNT to ensure cfquery always detected the SELECT as the one and only resultset returned by the enclosed sql statements. Even if it wasn't necessary. I also started using it because I ran into a situation where simply adding a SELECT after the INSERT didn't work. I don't remember which products or versions I was using at the time but it had to have been at least 5-6 years ago if not longer. So I also just started using it whenever I had to determine the new ID after an INSERT. -- Mosh Teitelbaum evoch, LLC WWW: http://www.evoch.com/ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Windows/SQL Server error, anyone have any ideas?
One of our 4 servers all of a sudden started throwing CryptoAPI errors. Literally one second it was working, the next it wasn't. Our guys are looking into it, but I thought I might ask the list and see if anyone had any ideas. The exact error: [Macromedia][SQLServer JDBC Driver][SQLServer]CryptoAPI function 'CryptAcquireContext' failed. Error 0x57: The parameter is incorrect. Is this just happening from CF queries? Are you using Windows authentication? Are you able to log onto the server console? 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
Also, I don't think the problem has to do with a returned record set but with SQL Server returning some other meta-data and information (i.e., X rows inserted/affected, etc.). which your client shouldn't confuse with a recordset. I'm not saying that all clients behave properly, though. 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! ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Windows/SQL Server error, anyone have any ideas?
ColdFusion is throwing errors showing the string I posted. Supposedly using SQL Server Auth Login yes, but when we try to expand the node containing this specific database, it returns the same error. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 2:04 PM To: CF-Talk Subject: RE: Windows/SQL Server error, anyone have any ideas? One of our 4 servers all of a sudden started throwing CryptoAPI errors. Literally one second it was working, the next it wasn't. Our guys are looking into it, but I thought I might ask the list and see if anyone had any ideas. The exact error: [Macromedia][SQLServer JDBC Driver][SQLServer]CryptoAPI function 'CryptAcquireContext' failed. Error 0x57: The parameter is incorrect. Is this just happening from CF queries? Are you using Windows authentication? Are you able to log onto the server console? 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! ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Windows/SQL Server error, anyone have any ideas?
Supposedly using SQL Server Auth Login yes, but when we try to expand the node containing this specific database, it returns the same error. When you're expanding that node in Enterprise Manager, are you using the same login as CF? If not, can you try another login - ideally a Windows login? 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF7 Verity Issues. Any help/comments would be appreciated
I have a few Verity Collections on a Windows 2003 server running CFMX 7.0.2 with hotfix 3 installed,that index documents on my site. I set up a scheduled task to index the documents nightly. This had been working great, but now the index fails with the error. The collection is not available: com.verity.coll.VCollectionNotAvailableException: Collection down after opening. (10) When a user searches the site they get an error: Error executing the CFSearch Tag Collection (Status Code): mycollection(-1705). I can not find any doc on Verity error codes on Adobe's site that explains this error other than The Collection is down. No resolutions, nothing. The only solution I have found that works is stopping the Search Services, deleting the collection folder under cfmxroot/verity/collections restarting the service and re-creating the collection, then doing a manual index. I am pulling out what hair I have left trying to figure out what this issue is and how to correct it. Anyone else have any similar issues/advice. Thanks, Rich Sloan E-Business Development Specialist The TriZetto Group, Inc., Naperville ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
URLEncodedFormat question
Hi Everyone, I've been trying to solve this for a couple hours, and am getting nowhere fast. If anyone here as an idea that could point me in the right direction I would be very grateful. I have this HTML table which is being output to the users browser, and its got data from several queries in it. (see below for the table) and it works fine to output normally, but what I need to do is URL encode the entire table (After its been rendered with the data from the queries) and stuff the whole thing into a form variable that I can pass into Lotus Notes using a cfhttp method=Post The table (with query data) will then be unencoded by Lotus Notes and displayed as part of an email that will be sent to whoever. The whole passing into Lotus Notes part works fine. I have a rendered, hard coded, URL Encoded string as part of a cfhttp method=Post that I used for testing and works fine. I just don't know how to URL encode the table with the query values on the fly in my code so I can stuff it into the form field value. table width=664 border=1 cellpadding=5 cellspacing=0 bordercolor=#CC tbody tr td width=462 bgcolor=#CC h2 align=center class=style1Question/h2/td td width=196 bgcolor=#CC h2 align=center class=style1Answer/h2/td /tr tr tdProduct Market Segment/td tdstrongcfif isDefined(pnums.MARKETSEGMENTS)cfoutput#pnums.MARKETSEGMENTS#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted Revenue/td tdstrongcfif isDefined(totalEC)cfoutput#dollarformat(totalEC)#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted Quantity/td td width=196strongcfif isDefined(getParts.qtrlyFcstQty)cfoutput#getParts.qtrlyFcstQty#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted G Margin/td td strongcfif isDefined(metaFinance.SH_FIN_GROSSMARGIN)cfoutput#metaFinance.SH_FIN_GROSSMARGIN#/cfoutput/cfif/strong/td /tr tr tdMinimum Pull Quantity/td td width=196 strongcfif isDefined(metaHubMgt.SH_JHM_MINPULLQTY)cfoutput#metaHubMgt.SH_JHM_MINPULLQTY#/cfoutput/cfif/strong/td /tr tr tdCost Per Unit for __ pulls/td td width=196 pstrongMin Pull QTY:/strong cfif isDefined(metaHubMgt.SH_JHM_minPullQty)cfoutput#metaHubMgt.SH_JHM_minPullQty#/cfoutput/cfif /p pstrongCost Per Pallet:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitPallPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitPallPull#/cfoutput/cfif/p pstrongCost Per Carton:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitCartPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitCartPull#/cfoutput/cfif/p pstrongCost Per Layer:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitLayPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitLayPull#/cfoutput/cfif/p /td /tr tr tdAdder/td td width=196 strongcfif isDefined(metapricing.SH_PRI_ADDER)cfoutput#metapricing.SH_PRI_ADDER#/cfoutput/cfif/strong/td /tr tr tdp class=style2Stakeholder - Does Not Qualify Comments/p /td td width=196 cfinclude template=Q-doesNotQualify.cfm/td /tr tr tdHub Justification/td td width=196strongcfif isDefined(metaRequest.REQ_HUBJUST)cfoutput#metaRequest.REQ_HUBJUST#/cfoutput/cfif/strong/td /tr /tbody /table Any ideas would be greatly appreciated. Thanks John ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Windows/SQL Server error, anyone have any ideas?
I just got confirm that it's the SQL Server auth. Windows login works just fine. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 2:46 PM To: CF-Talk Subject: RE: Windows/SQL Server error, anyone have any ideas? Supposedly using SQL Server Auth Login yes, but when we try to expand the node containing this specific database, it returns the same error. When you're expanding that node in Enterprise Manager, are you using the same login as CF? If not, can you try another login - ideally a Windows login? 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL 2005 and CF problem suggestion
Anyone have a work around for this problem. Is there a way to write a query different versus doing something on the cf admin side? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 (): Data type 0x38 is unknown. Thanks Steve ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL 2005 and CF problem suggestion
Steve Kahn wrote: Anyone have a work around for this problem. Is there a way to write a query different versus doing something on the cf admin side? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 (): Data type 0x38 is unknown. Log in the administrator and switch the select method from cursor to direct. Jochem ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Combining Verity Sql Server searches
Our jobbank program needs an upgrade. Currently, the resumes are pasted into FCKeditor and stored in a database in HTML format. However, this doesn't seem to be getting the job done, and we've received a deluge of complaints and demands for the ability to just upload a pdf/word document. Many of the job seekers have had trouble getting their resume looking just write because of all the spaces other weird stuff people put in word documents. We've gone through several upgrades and filters the post processing of resumes, but we still can't get it to look right. Here's how the search results work now: http://www.producejobsource.com/index.cfm?event=SearchUsersquery=salesx=0y=0submit=location=jobtype=radius=school= The solution we're considering now is to allow job seekers to cut paste their resume OR just upload it. But that will mean indexing the folder of resumes (all PDFs or Word Docs) as a collection so it can be searched on. I've made collections before and its no big deal, but I've never had to combine it with a SQL search too. Basically, I need to upgrade my resume search program from a strict SQL search based on like'%string% to one that combines SQL searchs with searches on a directory full of word and PDF documents and is somehow able to link those documents back to a user, and then display the search results in exactly the same way it currently does. Has anyone done anything like this and do you have any suggestions for how to proceed? ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Calendar with Recurring Events
The Vivio Calendar does this. You can even add recurring events that happen on out-of-order dates. http://calendar.viviotech.net/ HTH Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Jake Churchill wrote: Can anyone suggest a CF calendar that allows for recurring events? I am working on a project which requires this. The project is Farcry-based but Iâm just looking for an example of how to manage the data. Anything will help. Thanks! _ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 HYPERLINK http://www.cfwebtools.comhttp://www.cfwebtools.com 402-408-3733 x103 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.11/1093 - Release Date: 10/25/2007 5:38 PM ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URLEncodedFormat question
Look into using cfstorecontent to grab the table into a variable. Then you only have to make one urlencodedformat() call on it. --Ben Doom john mcdonald wrote: Hi Everyone, I've been trying to solve this for a couple hours, and am getting nowhere fast. If anyone here as an idea that could point me in the right direction I would be very grateful. I have this HTML table which is being output to the users browser, and its got data from several queries in it. (see below for the table) and it works fine to output normally, but what I need to do is URL encode the entire table (After its been rendered with the data from the queries) and stuff the whole thing into a form variable that I can pass into Lotus Notes using a cfhttp method=Post The table (with query data) will then be unencoded by Lotus Notes and displayed as part of an email that will be sent to whoever. The whole passing into Lotus Notes part works fine. I have a rendered, hard coded, URL Encoded string as part of a cfhttp method=Post that I used for testing and works fine. I just don't know how to URL encode the table with the query values on the fly in my code so I can stuff it into the form field value. table width=664 border=1 cellpadding=5 cellspacing=0 bordercolor=#CC tbody tr td width=462 bgcolor=#CC h2 align=center class=style1Question/h2/td td width=196 bgcolor=#CC h2 align=center class=style1Answer/h2/td /tr tr tdProduct Market Segment/td tdstrongcfif isDefined(pnums.MARKETSEGMENTS)cfoutput#pnums.MARKETSEGMENTS#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted Revenue/td tdstrongcfif isDefined(totalEC)cfoutput#dollarformat(totalEC)#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted Quantity/td td width=196strongcfif isDefined(getParts.qtrlyFcstQty)cfoutput#getParts.qtrlyFcstQty#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted G Margin/td td strongcfif isDefined(metaFinance.SH_FIN_GROSSMARGIN)cfoutput#metaFinance.SH_FIN_GROSSMARGIN#/cfoutput/cfif/strong/td /tr tr tdMinimum Pull Quantity/td td width=196 strongcfif isDefined(metaHubMgt.SH_JHM_MINPULLQTY)cfoutput#metaHubMgt.SH_JHM_MINPULLQTY#/cfoutput/cfif/strong/td /tr tr tdCost Per Unit for __ pulls/td td width=196 pstrongMin Pull QTY:/strong cfif isDefined(metaHubMgt.SH_JHM_minPullQty)cfoutput#metaHubMgt.SH_JHM_minPullQty#/cfoutput/cfif /p pstrongCost Per Pallet:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitPallPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitPallPull#/cfoutput/cfif/p pstrongCost Per Carton:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitCartPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitCartPull#/cfoutput/cfif/p pstrongCost Per Layer:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitLayPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitLayPull#/cfoutput/cfif/p /td /tr tr tdAdder/td td width=196 strongcfif isDefined(metapricing.SH_PRI_ADDER)cfoutput#metapricing.SH_PRI_ADDER#/cfoutput/cfif/strong/td /tr tr tdp class=style2Stakeholder - Does Not Qualify Comments/p /td td width=196 cfinclude template=Q-doesNotQualify.cfm/td /tr tr tdHub Justification/td td width=196strongcfif isDefined(metaRequest.REQ_HUBJUST)cfoutput#metaRequest.REQ_HUBJUST#/cfoutput/cfif/strong/td /tr /tbody /table Any ideas would be greatly appreciated. Thanks John ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Windows/SQL Server error, anyone have any ideas?
I just got confirm that it's the SQL Server auth. Windows login works just fine. This might be your problem: http://support.microsoft.com/kb/811886 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF7 verity indexing of PDFs
Hello Ray, Thanks for the advice and it worked, but has given way to a more curious problem. Say I have one PDF Learning how to use the CFFORCE by R. Camden then if I search on a phrase conained therein, then the context field correctly returns the paragraph containing the required wisdom. Say I have a different PDF Learning how to use CFFORCE by M. Barfoot. If I search on a particular phrase contained therein, then the context field is the same as Summary field, which doesn't contain my phrase at all. Seems as though the CFForce is working against me. My Verity has gone darth. Any ideas? Thanks, Matt -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 26 October 2007 15:25 To: CF-Talk Subject: Re: CF7 verity indexing of PDFs Did you remember to enable it in your cfsearch tag? By default cfsearch won't return context information. You have to specify contextPassages with a # greater than 0. On 10/26/07, Matt Barfoot [EMAIL PROTECTED] wrote: I can't seem to get verity to index PDFs properly. I can index a PDF, check the collection in CFADMIN which shows the doc is indexed. I can the pick a phrase from the PDF, seach against it and I get 1 result. The problem is the result only shows a summary. If a CFDUMP the context field is empty. The fact the the correct document is identified by a phrase search tells me Verity has indexed the doc and knows the phrase exists (and where). But it won't yield this information back in the returned results query. Any ideas where I'm going wrong? Any other advice on how to get the best from Verity would be much appreciated. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URLEncodedFormat question
You can wrap the output in cfsavecontent variable=myVar OUTPUT THE TABLE HERE /cfsavecontent Then you can send #urlencodedformat(myVar)# off via your cfhttp post ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: john mcdonald [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 4:48 PM To: CF-Talk Subject: URLEncodedFormat question Hi Everyone, I've been trying to solve this for a couple hours, and am getting nowhere fast. If anyone here as an idea that could point me in the right direction I would be very grateful. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server Issue
Seeing as we have so many multi-talented people on this list, and we are stumped in finding an answer at this point, I thought I would post the following issue. Currently we utilize MS SQL 2000 with multiple databases. One of our CF servers (one of the 6.1 boxes) recycled it's cached ds connections and was no longer able to authenticate to the db's. We were also no longer able to connect via Enterprise Manager, receiving the (essentially) same error: detail = [Macromedia][SQLServer JDBC Driver][SQLServer]CryptoAPI function 'CryptAcquireContext' failed. Error 0x57: The parameter is incorrect. My fear is that our other CF servers will cycle their cached db connections soon, and begin receiving the same type of errors. We would restart the SQL server, but then there's the fear that it won't come back at all, and none of our servers will reconnect. Has anyone come across this before? Any suggestions? Google isn't helping much, and MS has had us on hold for a while now, so any help would be appreciated. -- Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URLEncodedFormat question
Er, cfsavecontent rather. --Ben Doom Ben Doom wrote: Look into using cfstorecontent to grab the table into a variable. Then you only have to make one urlencodedformat() call on it. --Ben Doom ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URLEncodedFormat question
If I understand your question then you could use cfsavecontent to grab the table being generated and store it in a string, which you could then put into a form field or encode as an url param or whatever. Thanks Mark -Original Message- From: john mcdonald [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 4:48 PM To: CF-Talk Subject: URLEncodedFormat question Hi Everyone, I've been trying to solve this for a couple hours, and am getting nowhere fast. If anyone here as an idea that could point me in the right direction I would be very grateful. I have this HTML table which is being output to the users browser, and its got data from several queries in it. (see below for the table) and it works fine to output normally, but what I need to do is URL encode the entire table (After its been rendered with the data from the queries) and stuff the whole thing into a form variable that I can pass into Lotus Notes using a cfhttp method=Post The table (with query data) will then be unencoded by Lotus Notes and displayed as part of an email that will be sent to whoever. The whole passing into Lotus Notes part works fine. I have a rendered, hard coded, URL Encoded string as part of a cfhttp method=Post that I used for testing and works fine. I just don't know how to URL encode the table with the query values on the fly in my code so I can stuff it into the form field value. table width=664 border=1 cellpadding=5 cellspacing=0 bordercolor=#CC tbody tr td width=462 bgcolor=#CC h2 align=center class=style1Question/h2/td td width=196 bgcolor=#CC h2 align=center class=style1Answer/h2/td /tr tr tdProduct Market Segment/td tdstrongcfif isDefined(pnums.MARKETSEGMENTS)cfoutput#pnums.MARKETSEGMENTS#/cfou tput/cfif/strong/td /tr tr tdQuarterly Forecasted Revenue/td tdstrongcfif isDefined(totalEC)cfoutput#dollarformat(totalEC)#/cfoutput/cfif /strong/td /tr tr tdQuarterly Forecasted Quantity/td td width=196strongcfif isDefined(getParts.qtrlyFcstQty)cfoutput#getParts.qtrlyFcstQty#/cf output/cfif/strong/td /tr tr tdQuarterly Forecasted G Margin/td td strongcfif isDefined(metaFinance.SH_FIN_GROSSMARGIN)cfoutput#metaFinance.SH_FI N_GROSSMARGIN#/cfoutput/cfif/strong/td /tr tr tdMinimum Pull Quantity/td td width=196 strongcfif isDefined(metaHubMgt.SH_JHM_MINPULLQTY)cfoutput#metaHubMgt.SH_JHM_M INPULLQTY#/cfoutput/cfif/strong/td /tr tr tdCost Per Unit for __ pulls/td td width=196 pstrongMin Pull QTY:/strong cfif isDefined(metaHubMgt.SH_JHM_minPullQty)cfoutput#metaHubMgt.SH_JHM_m inPullQty#/cfoutput/cfif /p pstrongCost Per Pallet:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitPallPull)cfoutput#metaHubMgt ..SH_JHM_costPerUnitPallPull#/cfoutput/cfif/p pstrongCost Per Carton:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitCartPull)cfoutput#metaHubMgt ..SH_JHM_costPerUnitCartPull#/cfoutput/cfif/p pstrongCost Per Layer:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitLayPull)cfoutput#metaHubMgt. SH_JHM_costPerUnitLayPull#/cfoutput/cfif/p /td /tr tr tdAdder/td td width=196 strongcfif isDefined(metapricing.SH_PRI_ADDER)cfoutput#metapricing.SH_PRI_ADDE R#/cfoutput/cfif/strong/td /tr tr tdp class=style2Stakeholder - Does Not Qualify Comments/p /td td width=196 cfinclude template=Q-doesNotQualify.cfm/td /tr tr tdHub Justification/td td width=196strongcfif isDefined(metaRequest.REQ_HUBJUST)cfoutput#metaRequest.REQ_HUBJUST# /cfoutput/cfif/strong/td /tr /tbody /table Any ideas would be greatly appreciated. Thanks John ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
[OT] Populating a MySQL Database from Active Directory
I have an internal app that is working pretty well. Users log in using credentials stored in Active Directory and the App runs on a MySQL DB. As I expand the app I find I am running into problems with talking to AD. My bigest issue is with my Dev Enviro. I have to code in a way to circumvent checking usernames and passwords against AD and pull them from a DB instead. This is a pain and ends up adding a ton of extra lines to maintain. Is there a way to populate the database from info stored in AD and then keep it synchronized? I'd love to keep my user info stored in the DB since that would let me start developing my app without worrying about where the app is running. Thanks yall. ~Steve ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: [OT] Populating a MySQL Database from Active Directory
I have some code that can pull down the entire contents of an active directory domain from ldap. From there you could do anything you want with it. (Including inserting it into mysql. ) Care for a look? Terrence Ryan I.T. Director Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] -Original Message- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 4:54 PM To: CF-Talk Subject: [OT] Populating a MySQL Database from Active Directory I have an internal app that is working pretty well. Users log in using credentials stored in Active Directory and the App runs on a MySQL DB. As I expand the app I find I am running into problems with talking to AD. My bigest issue is with my Dev Enviro. I have to code in a way to circumvent checking usernames and passwords against AD and pull them from a DB instead. This is a pain and ends up adding a ton of extra lines to maintain. Is there a way to populate the database from info stored in AD and then keep it synchronized? I'd love to keep my user info stored in the DB since that would let me start developing my app without worrying about where the app is running. Thanks yall. ~Steve ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URLEncodedFormat question
Er, cfsavecontent rather. --Ben Doom Damn, I thought I just learned a new cool tag! :) Will ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: weird message on logs (CF8)
Hi Jon, thanks for your help, I'll try that monday morning see if it fixes the problem. It's trully weird because in never happened before. we'll see if switching the storage option will fix the problem. Thanks -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Returning and object from a Web Service
Hi Qasim, My object does have the cfproperties set for each of its elements. I've been doing some additional testing, stripping away anything extra that is not needed and I was actually able to return the object by itself. I am using a base object to manage my results and for some reason is causing the issue. I'll need to research a little deeper to find out why. Thanks to you, Brad, and d c for your suggestions. Dean On 10/26/07, Qasim Rasheed [EMAIL PROTECTED] wrote: Dean, A shot in the dark, but do you have cfproperty .. defined for the attributes of your User object that you are trying to return? Thanks Qasim On 10/26/07, Dean Lawrence [EMAIL PROTECTED] wrote: What type of CFC object are you trying to return... More the case is it in the same directory as the webservice? Or does it use a mapping? If a mapping, try using a CFC that is in the same directory as the web service. It is a simple User object that I created (usrname, password, etc.). It is located in a subdirectory below the web service itself. I can call it and use it within the webservice method call, but if I try to return it directly or as an element of an array (i.e. cfreturn User /), I get the error message that I originally posted. Instead I need to break it apart and either need to return individual element values, place each value into a structure, or return a query instead. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [OT] Populating a MySQL Database from Active Directory
I would LOVE to see this! Thank you for the offer! On 10/26/07, Ryan, Terrence [EMAIL PROTECTED] wrote: I have some code that can pull down the entire contents of an active directory domain from ldap. From there you could do anything you want with it. (Including inserting it into mysql. ) Care for a look? Terrence Ryan I.T. Director Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] -Original Message- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 4:54 PM To: CF-Talk Subject: [OT] Populating a MySQL Database from Active Directory I have an internal app that is working pretty well. Users log in using credentials stored in Active Directory and the App runs on a MySQL DB. As I expand the app I find I am running into problems with talking to AD. My bigest issue is with my Dev Enviro. I have to code in a way to circumvent checking usernames and passwords against AD and pull them from a DB instead. This is a pain and ends up adding a ton of extra lines to maintain. Is there a way to populate the database from info stored in AD and then keep it synchronized? I'd love to keep my user info stored in the DB since that would let me start developing my app without worrying about where the app is running. Thanks yall. ~Steve ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Create a webservice to accept an array of structures/components
Hi Etwan, I think your problem is that gameTest[] is not a valid data type. It is the name of an array, but it is not a datatype. The datatype would simply be an array. This array holds multiple instances of the gameTest object, but still the datatype itself would simply be an array. Dean On 10/26/07, Etwan Sherdloo [EMAIL PROTECTED] wrote: Goal: To create a webservice that can accept an array of structures/components. Problem: The webservice will not accept the array of structures/components passed to it. Code: 1) The following is the code that creates the array of structures/components and invokes the webservice. (Testws.cfm) cfoutput !--- Creat Test Game Object --- cfset arrGame = ArrayNew(1) cfloop index=i from=1 to=5 cfset arrGame[i] = CreateObject(component, gameTest) cfset arrGame[i].setGameID(ToString(i)) cfset arrGame[i].setHomeSSID(OHSSTEST i) /cfloop barrGame:/bbrcfdump var=#arrGame# cfinvoke webservice=http://dev.schedulestar.com/Tim/webservicetest.cfc?wsdl; method=complextype1 returnvariable=serviceResult Games=#arrGame# brbrbserviceResult:/bbrcfdump var=#serviceResult# /cfoutput 2) The following is the code for the web service (webservicetest.cfc) cfcomponent cffunction name=complextype1 returntype=gameTest[] access=remote cfargument name=Games type=gameTest[] required=yes cfset arrGame = arraynew(1) !--- Return Variable --- !--- Creat Game --- cfloop index=s from=1 to=#arraylen(Games)# cfset arrGame[s] = CreateObject(component, gameTest) cfset arrGame[s].setGameID(ToString(s)) cfset arrGame[s].setHomeSSID(Games[s].getHomeSSID) /cfloop cfreturn arrGame /cffunction /cfcomponent 3) The following is the component. An array of this component is made and passed to the webservice. (gameTest.cfc) cfcomponent cfproperty name=GameID type=string cfproperty name=HomeSSID type=string !--- Initialize --- cfscript this.GameID = 0; this.HomeSSID = ; /cfscript !--- Methods --- cffunction name=getGameID access=public returntype=string cfreturn this.GameID /cffunction cffunction name=setGameID access=public cfargument name=game type=string required=yes cfset this.GameID = game /cffunction cffunction name=getHomeSSID access=public returntype=string cfreturn this.HomeSSID /cffunction cffunction name=setHomeSSID access=public cfargument name=ssid type=string required=yes cfset this.HomeSSID = ssid /cffunction /cfcomponent Basically, the testWS.cfm file creates an array of the component and passes it to the webservice. No matter what I try to do, errors continue to be thrown. I believe the problem is in the code for the webservice. Thank you for your help. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 verity indexing of PDFs
You've got me there. I'd have to look at the PDF and try to guess why. If the match is good - but the context is off - I'd probably just ignore. On 10/26/07, Matt Barfoot [EMAIL PROTECTED] wrote: Hello Ray, Thanks for the advice and it worked, but has given way to a more curious problem. Say I have one PDF Learning how to use the CFFORCE by R. Camden then if I search on a phrase conained therein, then the context field correctly returns the paragraph containing the required wisdom. Say I have a different PDF Learning how to use CFFORCE by M. Barfoot. If I search on a particular phrase contained therein, then the context field is the same as Summary field, which doesn't contain my phrase at all. Seems as though the CFForce is working against me. My Verity has gone darth. Any ideas? Thanks, Matt -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 26 October 2007 15:25 To: CF-Talk Subject: Re: CF7 verity indexing of PDFs Did you remember to enable it in your cfsearch tag? By default cfsearch won't return context information. You have to specify contextPassages with a # greater than 0. On 10/26/07, Matt Barfoot [EMAIL PROTECTED] wrote: I can't seem to get verity to index PDFs properly. I can index a PDF, check the collection in CFADMIN which shows the doc is indexed. I can the pick a phrase from the PDF, seach against it and I get 1 result. The problem is the result only shows a summary. If a CFDUMP the context field is empty. The fact the the correct document is identified by a phrase search tells me Verity has indexed the doc and knows the phrase exists (and where). But it won't yield this information back in the returned results query. Any ideas where I'm going wrong? Any other advice on how to get the best from Verity would be much appreciated. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Server Issue
Currently we utilize MS SQL 2000 with multiple databases. One of our CF servers (one of the 6.1 boxes) recycled it's cached ds connections and was no longer able to authenticate to the db's. We were also no longer able to connect via Enterprise Manager, receiving the (essentially) same error: detail = [Macromedia][SQLServer JDBC Driver][SQLServer]CryptoAPI function 'CryptAcquireContext' failed. Error 0x57: The parameter is incorrect. My fear is that our other CF servers will cycle their cached db connections soon, and begin receiving the same type of errors. We would restart the SQL server, but then there's the fear that it won't come back at all, and none of our servers will reconnect. Has anyone come across this before? Any suggestions? Google isn't helping much, and MS has had us on hold for a while now, so any help would be appreciated. Someone else here on the list today had a similar problem, and I found this: http://support.microsoft.com/kb/811886 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! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT but... any one using a bot trap?
Hi, I tried to implement a bad robot trap, I mean those that do not honor the robots.txt file. Here is the robots.txt file: User-agent: * Disallow: /noBots.cfm Disallow: /bulleltin Disallow: /admin in /noBots.cfm, for the time being I just display this: This page was illegitimately indexed by #agFullName#. But making a search on the string This page was illegitimately indexed reveals that most legitimate robots have found it: Netsacpe, Google, AOL, Compuserve,... you name it. So is it really working ? IMO it is not safe to ban any robot on that only basis. Has any one a better method to submit? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server Issue
Dave, Thanks for responding on this. After almost six hours on the phone with MS, it looks like the best guess option is to restart services. Since the release of MS SQL 2000 their support has received one call for this issue, so they aren't really sure. We'll find out in another twenty min when we finally kick the services ... Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com The best way to predict the future is to help create it Dave Watts wrote: Someone else here on the list today had a similar problem, and I found this: http://support.microsoft.com/kb/811886 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4