Unable to create Datasource ColdFusion8
Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfpdfform and PDF Dynamic XML Forms
TJ - Just some random thoughts - 1) if you run cf from the console, do you see any errors in there? An exception stack trace may be helpful. 2) If you put a try/catch around it, and dump the cfcatch, do you see anything special? Sometimes it can show you Java errors you wouldn't otherwise see. Mark On Sat, Feb 14, 2009 at 2:43 PM, TJ Downes koldfu...@gmail.com wrote: Hi all, I have been banging my head on this issue for a couple of days and hope someone has some experience to offer. We are replacing PDFs generated by cfdocument with PDF templates developed in LiveCycle Designer, due to the issues we have had trying to get our results to be consistent. I have what I feel is a solid PDF Form template going,and I can populate the form using cfpdfform. The one issue I am having is trying to get flowable content working. If you have worked with LiveCycle Designer you will know what flowable content is. If you haven't, its the ability to allow users to fill in data in a PDF form and the PDF will expand to fit the content. I have this working (flowable content) in the PDF only when I save it as a Dynamic XML Form. I can add data to my form fields and the document expands as expected. This behavior does not occur when saved as a standard PDF Form. From the limited information i have read, this is by design. When I save the document as a Dynamic XML Form and try to populate it with CF I get the following error: An exception has occurred in the processing of PDF forms. '' Pretty vague. Yes, this is even with debugging enabled :) I can't seem to do anything to populate the Dynamic PDF Form without causing this error. What's odd is that I can read the document just fine. I can populate it manually, and a cfdump shows the data as an XML structure (that's good!). I can also use the same method to populate a standard PDF Form, both using XML and cfpdfformparam. The only thing that isn't working is populating the Dynamic XML Form from CF. Can someone tell me if this is unsupported, or if there is a workaround? We sincerely hate the cfdocument method we have been using, cfpdfform has made this so much faster, cleaner and more reliable. I would be happy to provide a copy of my template from LiveCycle Designer as well as a code sample. Thanks TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unable to create Datasource ColdFusion8
What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
http://www.google.com/search?q=coldfusion+sql+server+expressie=utf-8oe=utf-8aq=trls=com.ubuntu:en-US:unofficialclient=firefox-a Mark On Sat, Feb 14, 2009 at 9:28 PM, Priya Koya priya23...@gmail.com wrote: Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maybe I need a SQL Service Consultant...
Wow! I didn't know that. So would it be safer to use all nchar fields in the database instead of char, then no matter what the paramater came in as, it is faster to convert the parameter to unicode once than to convert every value in the index? At 01:41 AM 2/14/2009, you wrote: This isn't a bug in SQL Server. Rick said that his primary key column was a char field and so was the index. Since Unicode support was enabled, parameters were coming in as nchars or nvarchars. SQL Server cannot compare a char to an nchar so it must convert one so the data types match. http://www.codersrevolution.com/index.cfm/2009/2/13/SQL-Server-Gotcha-Implicit-Unicode-Conversion ~Brad That's fascinating. But why would sql server create an index in a codeset that didn't match the column? You'd think that the index would match the declared type of the column automatically. I would think of that as a bug in sql server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
I am using SQL SERVER 2005 to create a datasource. On Sat, Feb 14, 2009 at 6:01 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfpdfform and PDF Dynamic XML Forms
Hey Mark, thanks for the suggestion. Not sure why i didn't think of that. It did give me some additional info, albeit I don't think it gets me any further ahead. java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at java.lang.String.substring(String.java:1938) at coldfusion.pdf.XFADataXMLGenerator.createFormXMLData(XFADataXMLGenerator.java:94) at coldfusion.tagext.lang.PDFFormTag.doEndTag(PDFFormTag.java:276) at cfjustareminder2ecfm765021945._factor10(C:\Inetpub\wwwroot\wma.org\members\forms\repository\print\justareminder.cfm:27) at cfjustareminder2ecfm765021945._factor11(C:\Inetpub\wwwroot\wma.org\members\forms\repository\print\justareminder.cfm:24) at cfjustareminder2ecfm765021945.runPage(C:\Inetpub\wwwroot\wma.org\members\forms\repository\print\justareminder.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfinterface2ecfm27561726._factor43(C:\Inetpub\wwwroot\wma.org\members\forms\interface.cfm:493) at cfinterface2ecfm27561726._factor46(C:\Inetpub\wwwroot\wma.org\members\forms\interface.cfm:489) at cfinterface2ecfm27561726._factor16(C:\Inetpub\wwwroot\wma.org\members\forms\interface.cfm) at cfinterface2ecfm27561726._factor50(C:\Inetpub\wwwroot\wma.org\members\forms\interface.cfm:482) at cfinterface2ecfm27561726.runPage(C:\Inetpub\wwwroot\wma.org\members\forms\interface.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet..ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx..scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. On Sat, Feb 14, 2009 at 6:01 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
By default the SQL Server Express port is dynamic, meaning i changes. You need to use the SQL Server configuration tool to set a static port and use the port number, generally 1433, in the DSN admin interface. Have you done this? TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Did you read any of the Google results that Mark pointed you towards? Chances are since you are using SQL Server Express, you are trying to connect on the wrong port or SQL Server is not configured for TCP connections at all. You can use netstat -a on your machine to verify what ports are being listened on. But firstly, read a few of the many blog entries out there on the topic. http://www.fusioncube.net/index.php/coldfusion-sql-server-express ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 12:47 PM Subject: Re: Unable to create Datasource ColdFusion8 This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Yes, I did.. Set tje port 1433..i tested with telnet localhost 1433 .. its connectivity is working fine On Sat, Feb 14, 2009 at 1:51 PM, TJ Downes koldfu...@gmail.com wrote: By default the SQL Server Express port is dynamic, meaning i changes. You need to use the SQL Server configuration tool to set a static port and use the port number, generally 1433, in the DSN admin interface. Have you done this? TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Unable to create Datasource ColdFusion8
Here's what comes to mind for me Did you test it by telneting from the web server? I also leave TCP/IP and shared enabled, but disable named pipes and any other network libraries (using the sql config tool). Also make sure that you create a user name for CF using standard security (not AD security) and make sure that when you create it you set it so that the password does not need to be changed on first usage. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: Saturday, February 14, 2009 1:08 PM To: cf-talk Subject: Re: Unable to create Datasource ColdFusion8 Yes, I did.. Set tje port 1433..i tested with telnet localhost 1433 .. its connectivity is working fine On Sat, Feb 14, 2009 at 1:51 PM, TJ Downes koldfu...@gmail.com wrote: By default the SQL Server Express port is dynamic, meaning i changes. You need to use the SQL Server configuration tool to set a static port and use the port number, generally 1433, in the DSN admin interface. Have you done this? TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Brad, I followed the link and now I am unable to restart service and error I get is sql server(SQLEXPRESS) service on Local Computer started and then stopped. SOme services stop automatically if they are not in use by other services or programs.http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=da75d676b6b6f110VgnVCM104718190aRCRDvgnextchannel=68439c7755cb9010VgnVCM1045f3d6a1RCRD On Sat, Feb 14, 2009 at 2:00 PM, Brad Wood b...@bradwood.com wrote: Did you read any of the Google results that Mark pointed you towards? Chances are since you are using SQL Server Express, you are trying to connect on the wrong port or SQL Server is not configured for TCP connections at all. You can use netstat -a on your machine to verify what ports are being listened on. But firstly, read a few of the many blog entries out there on the topic. http://www.fusioncube.net/index.php/coldfusion-sql-server-express ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 12:47 PM Subject: Re: Unable to create Datasource ColdFusion8 This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
Wow, we've really made it angry now, huh? I've got to say I didn't have this much trouble, so I don't know how much help I can offer at this point. If I were you, I would start by looking in your windows system and application logs for clues. Also see if you have this log file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG I have SQL Server 2005 express installed on my machine, and that appears to be the location of the log file. Something must be preventing the service from starting properly so I'm guessing you will need to find the real error message and make a trip to Google with it. As for the 11 Arrested, Indicted in Multi-State Operation Targeting Visa and Mail Fraud-- that really too bad for them. I don't suppose they would have been much help to your SQL server set up anyway. :) ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 2:03 PM Subject: Re: Unable to create Datasource ColdFusion8 Brad, I followed the link and now I am unable to restart service and error I get is sql server(SQLEXPRESS) service on Local Computer started and then stopped. SOme services stop automatically if they are not in use by other services or programs.http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=da75d676b6b6f110VgnVCM104718190aRCRDvgnextchannel=68439c7755cb9010VgnVCM1045f3d6a1RCRD ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfpdfform and PDF Dynamic XML Forms
I figured this out. For some reason, when working with Dynamic XML Forms, you must specify overwritedata=true to the cfpdfform tag. The PDFs are now generating correctly. As a side note, when you use Dynamic XML Forms for your PDFs it does not look like you can use cfpdf to flatten the documents. The resulting document, when opened, states you need a newer version of Acrobat to view the document. If anyone knows a way around this it would be appreciated ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFPDF import vector graphcis
Couldn't find it anywhere so thought to ask. I have couple of illustrator files (which can be export to EPS on any other vector format). I am building dynamic PDF file using CFPDF tag and want to have this EPS or illustrator graphic import in my pdf. How can I do that? is there any sample out there? can someone please post the link? Thanks, ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319320 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maybe I need a SQL Service Consultant...
On Sat, Feb 14, 2009 at 8:38 AM, Al Musella, DPM muse...@virtualtrials.com wrote: I didn't know that. So would it be safer to use all nchar fields in the database instead of char, then no matter what the paramater came in as, it is faster to convert the parameter to unicode once than to convert every value in the index? It would seem that way. My rule of thumb is now: Always use nchar even if you know it will NEVER have unicode data in it (like you're storing a coldfusion UUID) because CF will do all unicode or all non-unicode. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maybe I need a SQL Service Consultant...
Rick Root wrote: It would seem that way. My rule of thumb is now: Always use nchar even if you know it will NEVER have unicode data in it (like you're storing a coldfusion UUID) because CF will do all unicode or all non-unicode. ..or you might look to a newer JDBC driver that knows about n datatypes. it's not cf, its the db driver. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Simple Webservice error under CF V8
Can anyone help me understand why the following simple code is throwiing an error. I get this error: Detail The fault returned when invoking the web service operation is:br pre'' java.lang.NullPointerException/pre Message Cannot perform web service invocation authenticate. when this routine routine: cfset ws = CreateObject(webservice, http://localhost/opensource/QBWC_Shell.cfc;) / cfset ret = ws.clientVersion(strVersion=2.0.0.135) / cfset soapresp = GetSOAPResponse(ws) h2SOAP Response for clientVersion/h2 cfdump var=#soapresp# cfset ret = ws.authenticate(strUserName=User, strPassword=PW) / cfset soapresp = GetSOAPResponse(ws) h2SOAP Response for authenticate/h2 cfdump var=#soapresp# Calls this WebService: CFCOMPONENT style=RPC namespace=http://developer.intuit.com/; cffunction access=remote name=clientVersion returntype=String cfargument name=strVersion type=string required=yes cfreturn O:2.0.0.135 /cffunction cffunction access=remote name=authenticate returntype=array cfargument name=strUserName type=string required=yes cfargument name=strPassword type=string required=yes cfset var aryReturn = arrayNew(1) / cfset arrayAppend(aryReturn, ) cfset arrayAppend(aryReturn, nvu) cfreturn aryReturn /cffunction /CFCOMPONENT Any help much appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple Webservice error under CF V8
Ok, I've traced the issue down to trying to return an array. How do I do this under V8? I had no issues with 7.5. Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maybe I need a SQL Service Consultant...
So you are saying it wasn't that the index was a different codepage than the column but rather that the data stream had to be converted because the data was coming in as Unicode? I can see that. Obscure but I can see it. Judah On Fri, Feb 13, 2009 at 10:41 PM, Brad Wood b...@bradwood.com wrote: This isn't a bug in SQL Server. Rick said that his primary key column was a char field and so was the index. Since Unicode support was enabled, parameters were coming in as nchars or nvarchars. SQL Server cannot compare a char to an nchar so it must convert one so the data types match. http://www.codersrevolution.com/index.cfm/2009/2/13/SQL-Server-Gotcha-Implicit-Unicode-Conversion ~Brad That's fascinating. But why would sql server create an index in a codeset that didn't match the column? You'd think that the index would match the declared type of the column automatically. I would think of that as a bug in sql server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inserting an array of structs into a database table
Hey everyone, I am pulling a song listing from another website that's in JSON format. I already figured out how to bring it into CF with deserializeJSON(), but now I need to put all that data into my database. There are over 60,000 songs in their database so that means I have to insert over 60,000 structs (song title, artist, id, etc) into my database. What is the most efficient way to do this? I am able to pull down chunks of song data (i.e. pull first 1000 songs, then pull then next 1000, etc), and then would I loop through the array and individually insert each struct into the database? It seems like that would be like a slow process but I don't know how else I'd do it. Any suggestions would be much appreciated! thanks! Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting an array of structs into a database table
On Sat, Feb 14, 2009 at 8:28 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey everyone, I am pulling a song listing from another website that's in JSON format. I already figured out how to bring it into CF with deserializeJSON(), but now I need to put all that data into my database. There are over 60,000 songs in their database so that means I have to insert over 60,000 structs (song title, artist, id, etc) into my database. What is the most efficient way to do this? I am able to pull down chunks of song data (i.e. pull first 1000 songs, then pull then next 1000, etc), and then would I loop through the array and individually insert each struct into the database? It seems like that would be like a slow process but I don't know how else I'd do it. Any suggestions would be much appreciated! thanks! Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFML to clean up Word HTML
On an old site, I'm moving from http://www.zrinity.com/activedit/ to http://tinymce.moxiecode.com and having issue described here: http://tinymce.moxiecode.com/punbb/viewtopic.php?id=15002 I searched riaforge.org and cflib.org for CFML to clean up Word HTML without affecting the way the HTML appears in modern browsers but could not find anything. Anyone ever written/used something like this? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inserting an array of structs into a database table
Which database? Do you have bulk insert capabilities? On Sat, Feb 14, 2009 at 5:28 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey everyone, I am pulling a song listing from another website that's in JSON format. I already figured out how to bring it into CF with deserializeJSON(), but now I need to put all that data into my database. There are over 60,000 songs in their database so that means I have to insert over 60,000 structs (song title, artist, id, etc) into my database. What is the most efficient way to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
question about cfproperty
Does anyone use cfproperty? I've been doing a lot of reading on CFCs and I've noticed that nobody uses that tag to document their CFCs. Is it just easy enough to look at the init's arguments to figure out the properties for a class? Just curious.. Thanks! Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inserting an array of structs into a database table
mysql.. I have admin access to my instance... Maureen wrote: Which database? Do you have bulk insert capabilities? On Sat, Feb 14, 2009 at 5:28 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey everyone, I am pulling a song listing from another website that's in JSON format. I already figured out how to bring it into CF with deserializeJSON(), but now I need to put all that data into my database. There are over 60,000 songs in their database so that means I have to insert over 60,000 structs (song title, artist, id, etc) into my database. What is the most efficient way to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting an array of structs into a database table
I found the following for mysql: http://dev.mysql.com/doc/refman/5.1/en/load-data.html I'm assuming I'd just wrap that with a cfquery statement? Any idea on how to convert an array of structs to a comma-delimited text file? thanks! Mike Mike Soultanian wrote: mysql.. I have admin access to my instance... Maureen wrote: Which database? Do you have bulk insert capabilities? On Sat, Feb 14, 2009 at 5:28 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey everyone, I am pulling a song listing from another website that's in JSON format. I already figured out how to bring it into CF with deserializeJSON(), but now I need to put all that data into my database. There are over 60,000 songs in their database so that means I have to insert over 60,000 structs (song title, artist, id, etc) into my database. What is the most efficient way to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question about cfproperty
IIRC... It is for self documentation and for constructing the WSDL for web services. You can skip it entirely for a regular CFC as it has no effect on the the functionality of the CFC. G! On Sat, Feb 14, 2009 at 9:59 PM, Mike Soultanian msoul...@csulb.edu wrote: Does anyone use cfproperty? I've been doing a lot of reading on CFCs and I've noticed that nobody uses that tag to document their CFCs. Is it just easy enough to look at the init's arguments to figure out the properties for a class? Just curious.. Thanks! Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with CF admin index.cfm page not getting executed
I am setting up a new box and I screwed up the Apache install and had to re-install Apache (XAMPP actually) and then used the Web Server Configuration Tool but now every time I hit the CF admin the index page is not getting executed and when I DL it it is source code. I can fix it with a total reinstall of CF 8.01 but that takes forever. I am on my third Apache install (for non CF reasons). Anyone know a work around for this? And yes, I did the reboots and restarting the services... Thanx G! -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Replication Models
Question for anyone that handles SQL Replication: What effect would setting up transactional replication from a large Windows 2000 database (17 Gb) with moderate usage (18-20 max simultaneous connections) to a Windows 2005 server have on the performance of the Windows 2000 machine? The reason behind the question - We use Microsoft Dynamics GP with 4 different SQL databases housed on a SQL 2000 server. We are building a web application to query those databases (read only) as well as store some data that they are not set up to manage. It uses a SQL 2005 server. Right now the app is running slow because the queries are running through the SQL 2005 as a linked server. My thought in speeding things up is to set up replicated copies of the 4 databases on the SQL 2005 server. This would be a transactional replication so we have instant access to any changes made in the main system. Additionally, the remote possibility of an injection attack running back to the live Dynamics databases would be removed. Our worry is that setting up the replication would place a noticeable strain on the main server, something we cannot afford to have. Any thoughts, ideas or suggestions? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Maybe I need a SQL Service Consultant...
In short, yes. Read my blog post that I linked to. I explained the whole thing and even provided code samples you can use to reproduce it on your own server. But basically you have it right-- the data in the table had to be converted one row at a time which defeated the index. ~Brad Original Message Subject: Re: Maybe I need a SQL Service Consultant... From: Judah McAuley ju...@wiredotter.com Date: Sat, February 14, 2009 6:41 pm To: cf-talk cf-talk@houseoffusion.com So you are saying it wasn't that the index was a different codepage than the column but rather that the data stream had to be converted because the data was coming in as Unicode? I can see that. Obscure but I can see it. Judah On Fri, Feb 13, 2009 at 10:41 PM, Brad Wood b...@bradwood.com wrote: This isn't a bug in SQL Server. Rick said that his primary key column was a char field and so was the index. Since Unicode support was enabled, parameters were coming in as nchars or nvarchars. SQL Server cannot compare a char to an nchar so it must convert one so the data types match. http://www.codersrevolution.com/index.cfm/2009/2/13/SQL-Server-Gotcha-Implicit-Unicode-Conversion ~Brad That's fascinating. But why would sql server create an index in a codeset that didn't match the column? You'd think that the index would match the declared type of the column automatically. I would think of that as a bug in sql server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inserting an array of structs into a database table
Not exactly what I had in mind. Instead of doing a loop over the array of structures and doing an insert each for each structure, you can do cfquery name=blah datasource=dsn insert (field1, field2, field3) values ( cfloop index=x from=1 to=lenarray arrayname[x,value1], arrayname[x,value2], arrayname[x,value3] /cfloop ) /cfquery Note: syntax not correct - just for illustration. On Sat, Feb 14, 2009 at 7:08 PM, Mike Soultanian msoul...@csulb.edu wrote: I found the following for mysql: http://dev.mysql.com/doc/refman/5.1/en/load-data.html I'm assuming I'd just wrap that with a cfquery statement? Any idea on how to convert an array of structs to a comma-delimited text file? thanks! Mike Mike Soultanian wrote: mysql.. I have admin access to my instance... Maureen wrote: Which database? Do you have bulk insert capabilities? On Sat, Feb 14, 2009 at 5:28 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey everyone, I am pulling a song listing from another website that's in JSON format. I already figured out how to bring it into CF with deserializeJSON(), but now I need to put all that data into my database. There are over 60,000 songs in their database so that means I have to insert over 60,000 structs (song title, artist, id, etc) into my database. What is the most efficient way to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319337 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 CF admin index.cfm page not getting executed
I'm just kind of guessing here, but are the Jrun mappings for .cfm files still in the Apache httpd.conf file? Also is the proper connector module being loaded into Apache as well? See if you can just run the Apache connector wizard again. ~Brad Original Message Subject: Problem with CF admin index.cfm page not getting executed From: Gerald Guido gerald.gu...@gmail.com Date: Sat, February 14, 2009 10:43 pm To: cf-talk cf-talk@houseoffusion.com I am setting up a new box and I screwed up the Apache install and had to re-install Apache (XAMPP actually) and then used the Web Server Configuration Tool but now every time I hit the CF admin the index page is not getting executed and when I DL it it is source code. I can fix it with a total reinstall of CF 8.01 but that takes forever. I am on my third Apache install (for non CF reasons). Anyone know a work around for this? And yes, I did the reboots and restarting the services... Thanx G! -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting an array of structs into a database table
Maureen wrote: Not exactly what I had in mind. Instead of doing a loop over the array of structures and doing an insert each for each structure, you can do cfquery name=blah datasource=dsn insert (field1, field2, field3) values ( cfloop index=x from=1 to=lenarray arrayname[x,value1], arrayname[x,value2], arrayname[x,value3] /cfloop ) /cfquery Neat - I didn't know you could run a loop in a query. I will give that a try! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting an array of structs into a database table
Maureen wrote:
Instead of doing a loop over the array of structures and doing an
insert each for each structure, you can do
cfquery name=blah datasource=dsn
insert (field1, field2, field3)
values (
cfloop index=x from=1 to=lenarray
arrayname[x,value1], arrayname[x,value2], arrayname[x,value3]
/cfloop
)
/cfquery
Hey Maureen,
Are you sure this functionality exists within SQL? It would seem like
you'd either end up with
INSERT INTO Tracks (ProductID) VALUES ('2343234','223432432','123213')
or
INSERT INTO Tracks (ProductID) VALUES ('2343234'), ('223432432'), ('123213')
depending on where you put the parenthesis and neither version works.
Thanks,
Mike
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319340
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
