RE: [ACFUG Discuss] Clone a SQL Server Database? Solved!
Peyton: I assume that the the SQL servers are on seperate networks and hence cannot see each other. In that case I don't think DTS will work. In this case you may need to go to a much older utility call Bulk Copy Program (BCP). BCP allows you to dump and reload a table. The table is dumped into a text format. Put the dump on a memory stick and reload the table on the new server. See: http://msdn2.microsoft.com/en-us/library/aa174646(SQL.80).aspx for more information Sincerely, Brooks Wilson 640K ought to be enough for anybody. - Bill Gates (1981) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] McTure, Greg [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/22/2008 10:07 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] Clone a SQL Server Database? Solved! Then why not create that table in the second database on the production box and then back fill it (you can use SSIS or DTS to quickly do this). Since the CF and ASP websites will be using two different tables (same data structure), will the ASP site be deactivated? I ask because the next step will depend on if both sites are actively writing to both tables and if you want the data to be consistent between them or not. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peyton Todd Sent: Monday, April 21, 2008 6:17 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Clone a SQL Server Database? Solved! Hi Greg - responses below in all CAPS. -Original Message- From: McTure, Greg [EMAIL PROTECTED] Sent: Apr 21, 2008 5:34 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Clone a SQL Server Database? Solved! Hi Peyton: I think you may have trade one problem for another here in solving this. Let me make sure that I understand your situation. You have a table on an MSSQL 2000 instance that is being shared by a CF app and a ASP app and you want the CF app to access the same data but in a different table (preferably on a MSSQL 2005 instance). Is that correct? NO, NOT EXACTLY. MY OWN PC HAS MSSQL 2005. THE PRODUCTION SITE IS ENTIRELY MSSQL 2000, AND BOTH DATABASES WILL BE ON THAT INSTANCE. First, with the restore you have solved the problem of getting the data loaded into a table that is now separate but how will any new data written to the old table get to the new table with this solution. Don't you want the data to be consistent between the two tables? You may need to consider the use of triggers (if the new restored table is on the same server as the old table) or replication (if different servers). SEE MY RESPONSE TO STEVEN FOR A LOT MORE DETAIL ON THE SITUATION. I WILL BE QUIZZING THE CLIENT MORE ABOUT THE EXACT NATURE OF THE OTHER TWO SITES, BUT AT THIS POINT THE POSSIBLITY EXISTS THAT THE TABLE REALLY ISN'T USED IN THE OTHER SITES AT ALL. AND EVEN IF IT IS, THERE'S THE PRACTICAL FACT THAT - PAINFUL THOUGH IT MAY BE TO OUR PROGRAMMERS'S SENSE OF ASETHETICS - THE DATA COULD SIMPLY BE ENTERED SEPARATELY (IT'S A TOTAL OF 17 COURT REPORTERS AT PRESENT, AND NOT A RAPID TURNOVER). IF THE REPORTERS' INFORMATION IS BEING USED AT ALL IN THE OTHER TWO SITES, MY GUESS IS (KNOWING THE BOSS AS I DO, SINCE IT WAS I, OVER A PERIOD OF 20 YEARS, WHO WROTE ALL THE FOXPRO CODE FOR RUNNING MOST OF HIS BUSINESS), HE WILL OPT FOR SIMPLY MAKING THOSE UPDATES RIGHT IN MSSQL 2000 ITSELF. (THE OFFICE MANAGER IS SOMEWHAT COMPUTER-LITERATE). BUT I'LL GET BACK TO YOU IF THE SITUATION CHANGES! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peyton Todd Sent: Monday, April 21, 2008 4:51 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Clone a SQL Server Database? Solved! Something I read on a Microsoft User Forum cued me to the correct answer: Instead of establishing the new DB first, all you have to do is just say you want to 'restore' to it, even when it doesn't exist yet. Key in the name you wish to assign to it into the 'To database' text field of the wizard, and then select the existing DB in the 'From database' drop-down list and click Okay. Evidently this so-called 'restore' does not even get its info from a backup, but gets it from the live DB. -Original Message- From: Peyton Todd [EMAIL PROTECTED] Sent: Apr 21, 2008 4:30 PM To: discussion@ACFUG.org Subject: [ACFUG Discuss] How Clone a SQL Server Database? Are there any SQL Server Wizards in the crowd (the human kind, I mean)? I have discovered that the site I'm building accesses a SQL Server table also accessed by an ASP site on the same server, and I want to separate them. So I want to make a clone of that SQL Server database for the exclusive use of my site - one which will reside in the same SQL Server installation. Part of the problem is that I have a SQL Server 2005 installation but my only manual is for SQL Server
[ACFUG Discuss] CFGRID CF8
I was trying to put together a CFGRID as part of a business case to upgrade
to CF8 at my company. I've played with it before and have a working example
and when I try to recreate it using different component and data I get this
message in the CFdebug, window:*global*: Exception thrown and not caught
Here is my code broken down to as simplistic as possible and I'm still
getting it:
cfoutput
cfform name=myform
cfgrid name=reportsGrid format=html pageSize=5 selectmode=row
bind=cfc:acct_db.GetPOsCF8({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})
cfgridcolumn name=POreqid display=No/
cfgridcolumn name=formnumber header=formnumber
cfgridcolumn name=project_number header=Project
cfgridcolumn name=project_name header=Project Name
cfgridcolumn name=market header=Market
cfgridcolumn name=request_by header=Request By
/cfgrid
/cfform
/cfoutput
the function I'm calling:
CFFUNCTION name=GetPOsCF8 access=remote
cfargument name=page required=yes
cfargument name=pageSize required=yes
cfargument name=gridsortcolumn required=yes
cfargument name=gridsortdirection required=yes
CFQUERY name=q datasource=#REQUEST.dsn#
SELECT POreqid, formnumber, project_number, project_name, market,
request_by
FROM tblacct_POrequests
cfif gridsortcolumn neq ''
order by #gridsortcolumn# #gridsortdirection#
/cfif
/CFQUERY
cfreturn queryconvertforgrid(q,page,pagesize)/
/CFFUNCTION
that's all of my code. Can somebody please tell me what I'm missing or
doing wrong?
Thanks,
Jeff
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
[ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method
*Hi, * In our application, we have pdf batch creation process, wherein mulitple pdf's are merged together to create a single pdf i.e. a batch document. We are using CF 7 on Windows and we use *active pdf* to create pdf documents. Everything was working fine and nothing has changed anywhere i.e. code etc. Plus, this error is happening for a batch which has 32 pdf docs. I have tried creating the batch for some other pdf documents and its working fine. Dont know if its one of the pdf documents in that 32 pdf docs that is causing this issue. See error below. ** *Error Message:* An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80010105 - The server threw an exception.. The error occurred on line 121. Thanks, -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method
Are you using the IE rendering engine or the native rendering engine of ActivePDF? If you're using the IE engine, it depends on the version of IE on the server to render the pdf and can be affected by Windows Updates to the server. - Original Message From: Ajas Mohammed [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, April 23, 2008 10:53:58 AM Subject: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method Hi, In our application, we have pdf batch creation process, wherein mulitple pdf's are merged together to create a single pdf i.e. a batch document. We are using CF 7 on Windows and we use active pdf to create pdf documents. Everything was working fine and nothing has changed anywhere i.e. code etc. Plus, this error is happening for a batch which has 32 pdf docs. I have tried creating the batch for some other pdf documents and its working fine. Dont know if its one of the pdf documents in that 32 pdf docs that is causing this issue. See error below. Error Message: An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80010105 - The server threw an exception.. The error occurred on line 121. Thanks, -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method
Well, I dont know if this information helps, but this is what I know. We have ActivePDF server installed on our server in production, so I guess the answer to your question is Native Rendering Engine of ActivePDF. If you think I have wrong information then let me know about IE rendering Engine and How can I find if its IE or native rendering engine. Thanks, Ajas. On 4/23/08, shawn gorrell [EMAIL PROTECTED] wrote: Are you using the IE rendering engine or the native rendering engine of ActivePDF? If you're using the IE engine, it depends on the version of IE on the server to render the pdf and can be affected by Windows Updates to the server. - Original Message From: Ajas Mohammed [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, April 23, 2008 10:53:58 AM Subject: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method *Hi, * In our application, we have pdf batch creation process, wherein mulitple pdf's are merged together to create a single pdf i.e. a batch document. We are using CF 7 on Windows and we use *active pdf* to create pdf documents. Everything was working fine and nothing has changed anywhere i.e. code etc. Plus, this error is happening for a batch which has 32 pdf docs. I have tried creating the batch for some other pdf documents and its working fine. Dont know if its one of the pdf documents in that 32 pdf docs that is causing this issue. See error below. ** *Error Message:* An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80010105 - The server threw an exception.. The error occurred on line 121. Thanks, -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method
If your code didn't change and the part of the environment you manage (configuration) didn't change, then it would appear that configuration you don't actively manage changed. From using ActivePDF with clients for about 6 years leads me to point the finger at a Windows Update patch specific to IE. Or possibly something in a CF updater. Here are a couple of KB articles I found that seem to apply: http://www.activepdf.com/support/knowledgebase/viewKb.cfm?id=10539tk=sp http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18623sliceId=2 - Original Message From: Ajas Mohammed [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, April 23, 2008 11:24:01 AM Subject: Re: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method Well, I dont know if this information helps, but this is what I know. We have ActivePDF server installed on our server in production, so I guess the answer to your question is Native Rendering Engine of ActivePDF. If you think I have wrong information then let me know about IE rendering Engine and How can I find if its IE or native rendering engine. Thanks, Ajas. On 4/23/08, shawn gorrell [EMAIL PROTECTED] wrote:Are you using the IE rendering engine or the native rendering engine of ActivePDF? If you're using the IE engine, it depends on the version of IE on the server to render the pdf and can be affected by Windows Updates to the server. - Original Message From: Ajas Mohammed [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, April 23, 2008 10:53:58 AM Subject: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method Hi, In our application, we have pdf batch creation process, wherein mulitple pdf's are merged together to create a single pdf i.e. a batch document. We are using CF 7 on Windows and we use active pdf to create pdf documents. Everything was working fine and nothing has changed anywhere i.e. code etc. Plus, this error is happening for a batch which has 32 pdf docs. I have tried creating the batch for some other pdf documents and its working fine. Dont know if its one of the pdf documents in that 32 pdf docs that is causing this issue. See error below. Error Message: An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80010105 - The server threw an exception.. The error occurred on line 121. Thanks, -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com
Re: [ACFUG Discuss] CFChart and printing
Thanks everyone for the info, it has been a large help. I ended up modifying the webcharts3d.xml file so that the timeout is longer, that seems to solve the short term problem. The user can now print images as well as view them up to 2 minutes after they are created. For future pages, I will probably do what Brooks is suggesting and save off the image so it is always around (atleast until I no longer need it). Thanks again everybody. Mike: Here a trick I developed that might help you. I needed to create a pie chart showing the results of an on-line poll. I used Macromedia Pollster to create and maintain the polls. Pollster uses a Flash user interface, but my client want an HTML equivalent. So I used an HTML form to collect the data and cfchart to display it. I ran into the same problem with the chart image expiring. Also, the site is heavily cached. The solution that I came up with is a little clunky but it works. Use cfsavecontent to capture the output of the cfgraph call. Parse the cfsavecontent output and recover the image file name that was created with cfgraph. It looks something like '/CFIDE/GraphData.cfm?graphCache=wc50graphID=Imagesid=Images_123456789'. Once I have the image file name and location, I made a copy of the image in my cache directory with cffile. Pollster uses UUIDs to id the polls, so I named them image cache/UUID.png. I go through the above logic whenever someone takes the poll, thereby refreshing the image. Lastly, to force the browser to refresh the image I append the vote count as a URL parameter in the image statement: img src=cache/UUID.png?total=#totalVotes#/ This seems to solve the problem of the expiring image and allows me keep the site cached. You can see the browser side of the code in action at http://www.frbatlanta.org/. I generated a png but it will work with jpg (or gif). Sincerely, Brooks Wilson 640K ought to be enough for anybody. - Bill Gates (1981) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] Ajas Mohammed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/22/2008 10:52 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] CFChart and printing Hi, Try this I guess you need to increase the timeout value. The charts/images are cached and the timeout value says how long to cache the chart/images. go to cf install path\lib\webcharts.3d.xml look for the code below at the top ?xml version=1.0 encoding=UTF-8? server image=PNG cache=Memory minTimeout=5000 maxTimeout=3 so on. time is in millisecs we had same issue and setting timeout value fixed the issue. Hope it helps. Try it out. -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. On 4/21/08, Mike Staver [EMAIL PROTECTED] wrote: An application I'm working on uses the CFChart tag to generate a bar graph based on a query. The graph looks great on the screen. This graph is inside a loop, and the graph gets generated approximately 1 to 6 times in most cases. When the user tries to print the screen, some of the images print and some don't. When the system really starts acting up, not a single image will print. The message being displayed in the images place on the print out is Image Expired, etc. The standard message when you hit a back button to view a page without refreshing the page. Some other info to note: 1) This webserver is NOT clustered. 2) ColdFusion version MX 7.0.2. 3) The cfchart tag is generating a jpeg image. 4) The browser in question is IE 7. 5) The webserver is IIS 6 on Windows 2003, using SSL. 6) The user is immediately trying to print the page, not letting it sit for more than 10 seconds max. 7) The site is not under any kind of heavy load. 8) I don't immediately have access to IIS or ColdFusion logs. All the research I've done points to the problem of having a clustered site, which does not fit my case here. Has anybody else had to deal with this issue before? - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - Annual Sponsor - Figleaf
Re: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method
Hi Shawn, Thanks for the links. I did search on google before I posted here and those 2 were the only links that came up along with this link which is for same error but related to excel http://groups.google.com/group/macromedia.coldfusion.advanced_techniques/browse_thread/thread/24dd3e20bc547a3e/d1716ea3ffd4ca8d?hl=enlnk=stq=coldfusion+An+exception+occurred+when+executing+a+Com+method+AutomationException%3A+0x80010105#d1716ea3ffd4ca8d I will look into updates issue but as I said earlier in my email, I am able to create batch for some other pdf documents, which makes me believe its something else. If it was exactly because of the updates, then the new batches would not have run. Meanwhile, I tried to manually merge the 32 pdf documents using Adobe Professional and I got an error saying one of the pdf has error and it wont merge. I removed that pdf and tried merge and it worked. So I guess the culprit is that one error prone pdf document. I have to research more and see whats wrong with that pdf. It goes without sayin, but I will say it... Thanks for the quick reply. ;-) Ajas. On 4/23/08, shawn gorrell [EMAIL PROTECTED] wrote: If your code didn't change and the part of the environment you manage (configuration) didn't change, then it would appear that configuration you don't actively manage changed. From using ActivePDF with clients for about 6 years leads me to point the finger at a Windows Update patch specific to IE. Or possibly something in a CF updater. Here are a couple of KB articles I found that seem to apply: http://www.activepdf.com/support/knowledgebase/viewKb.cfm?id=10539tk=sp http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18623sliceId=2 - Original Message From: Ajas Mohammed [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, April 23, 2008 11:24:01 AM Subject: Re: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method Well, I dont know if this information helps, but this is what I know. We have ActivePDF server installed on our server in production, so I guess the answer to your question is Native Rendering Engine of ActivePDF. If you think I have wrong information then let me know about IE rendering Engine and How can I find if its IE or native rendering engine. Thanks, Ajas. On 4/23/08, shawn gorrell [EMAIL PROTECTED] wrote: Are you using the IE rendering engine or the native rendering engine of ActivePDF? If you're using the IE engine, it depends on the version of IE on the server to render the pdf and can be affected by Windows Updates to the server. - Original Message From: Ajas Mohammed [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, April 23, 2008 10:53:58 AM Subject: [ACFUG Discuss] pdf creation - code was working fine, now it gives error An exception occurred when executing a Com method *Hi, * In our application, we have pdf batch creation process, wherein mulitple pdf's are merged together to create a single pdf i.e. a batch document. We are using CF 7 on Windows and we use *active pdf* to create pdf documents. Everything was working fine and nothing has changed anywhere i.e. code etc. Plus, this error is happening for a batch which has 32 pdf docs. I have tried creating the batch for some other pdf documents and its working fine. Dont know if its one of the pdf documents in that 32 pdf docs that is causing this issue. See error below. ** *Error Message:* An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80010105 - The server threw an exception.. The error occurred on line 121. Thanks, -- Ajas Mohammed / http://ajashadi.blogspot.com No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. Live as if you were to die tomorrow. Learn as if you were to live forever. - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For
[ACFUG Discuss] Re: CFGRID CF8
Ok, after much looking I found an answer to the question in a Forta blog. *Many people in these threads are getting the error listed below: window:global: Exception thrown and not caught (url, line 787) The reason for this is because although you are calling a CFC, your are ultimately sending a full HTTP GET request to the server. In doing so, application.cfm/application.cfc is still being processed. If you are including ANY content via application.cfm/cfc, then your call via AJAX is actually returning the result of the CFC function as well as all content being included in your requests The workaround that Im using is to check the value of the CGI.SCRIPT_NAME and if it ends w/ cfc, DONT include any content... that way your CFC is only returing the data that you want returned. Oh yeah... make sure its in JSON format (SerializeJSON) Happy coding :-) * *#*http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-2-Related-Selects#cEF126C41-3048-80A9-EF5B761397335120 * Posted By **Jared* http://www.myspace.com/bodyboarder20* | 12/18/07 4:04 PM * - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Re: CFGRID CF8
My own solution to a somewhat similar Ajax situation, where I wanted to pass parms back to a callback function (though that's not possible as such) was to put the following line at the very bottom of the CF page that was sending its output to the call back function:cfoutput~#.parmstring#/cfoutputThen in the callback function, I simply discard all output up to the tilde as shown below (in a situation where I could be sure no tildes would come back other than the one just above). function MyCallback(parmstring){ p=parmstring.indexOf('~'); // get rid of anything in the data stream up to what we're interested in parmstring = parmstring.substr(p+1)You could of course include a wierder combination of characters, though 'tis true, there could be some situations where you could not be 100% certain you would never get your wierd that string coming back in the output you want to get rid of. Maybe that wouldn't work for you, though, I don't know...-Original Message-
From: Jeff Howard <[EMAIL PROTECTED]>
Sent: Apr 23, 2008 2:38 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Re: CFGRID CF8
Ok, after much looking I found an answer to the question in a Forta blog.
Many people in these threads are getting the error listed below:window:global: Exception thrown and not caught (url, line 787)The reason for this is because although you are calling a CFC, your are ultimately sending a full HTTP GET request to the server. In doing so, application.cfm/application.cfc is still being processed. If you are including ANY content via application.cfm/cfc, then your call via AJAX is actually returning the result of the CFC function as well as all content being included in your requests
The workaround that Im using is to check the value of the CGI.SCRIPT_NAME and if it ends w/ cfc, DONT include any content... that way your CFC is only returing the data that you want returned.Oh yeah... make sure its in JSON format (SerializeJSON)
Happy coding :-)
# Posted By Jared | 12/18/07 4:04 PM
-
Annual Sponsor - Figleaf Software
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-
-Annual Sponsor FigLeaf Software - http://www.figleaf.comTo unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com-
