CF and MS Access support

2009-11-19 Thread Stephens, Larry V
I'm helping someone with a project and she elected to use GoDaddy as her host. They now tell her they have upgraded to the latest version of CF and it no longer supports MS Access databases. Have I missed something? This is news to me. Larry V. Stephens Indiana University Office of Risk

Re: CF and MS Access support

2009-11-19 Thread Casey Dougall
On Thu, Nov 19, 2009 at 8:17 AM, Stephens, Larry V steph...@indiana.eduwrote: I'm helping someone with a project and she elected to use GoDaddy as her host. They now tell her they have upgraded to the latest version of CF and it no longer supports MS Access databases. Have I missed

Jpg as a Watermark

2009-11-19 Thread Damo Drumm
Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im using at the moment:

Report Builder

2009-11-19 Thread Scott Stewart
I'm starting to play around with Report Builder. can the .cfr files see application variables, such as data sources or do I have to hard code the data source name into each report -- Scott Stewart IT Consultant/ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (919) 874-6229

Re: Jpg as a Watermark

2009-11-19 Thread Billy Cox
I am presuming that a watermark doesn't have to use many colors. So, you might want to try gif instead of jpg. Damo Drumm wrote: Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page.

Re: Jpg as a Watermark

2009-11-19 Thread Matthew Friedman
Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im using at the

Re: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph

2009-11-19 Thread Dominic Watson
An update on this, for my own reference as well as for people googling. I have, following various people's advice, changed the memory profile of our application quite dramatically and I will summarize what I changed and the tools I used to find the problems. I shall properly blog this later, no

RE: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph

2009-11-19 Thread Mark Kruger
Dom, That is a GREAT play by play... Thanks! Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Thursday, November 19, 2009 9:09 AM To: cf-talk

Re: Jpg as a Watermark

2009-11-19 Thread Damo Drumm
Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im

RE: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph

2009-11-19 Thread brad
Thanks for the good follow up info. I'll be interested in your learning curve for figuring out JConsole. ~Brad Original Message Subject: Re: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph From: Dominic Watson watson.domi...@googlemail.com Date: Thu,

CF8, Vista, SQL 2005

2009-11-19 Thread A D
Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. Any

Internet Explorer and @ signs in link text

2009-11-19 Thread Scott Brady
We're working with the eBay search APIs to do product searches and we're running into a problem. A lot of the item names have @ signs in the name (a lot of L@@K! or @ L@@K @. We use the item name as the link to the product, but in IE, the @ sign [under certain conditions, described below]

RE: CF8, Vista, SQL 2005

2009-11-19 Thread brad
What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad Original Message Subject: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009

RE: Internet Explorer and @ signs in link text

2009-11-19 Thread brad
haha, I've had my fair share of troubles trying search Google for information on punctuation. In fact you're probably pretty safe that anyone else having this problem will never ever find this thread. :) ~Brad I've tried to Google it, but it's hard because the search basically ignores @

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad Hi, I have CF8

RE: Internet Explorer and @ signs in link text

2009-11-19 Thread Robert Harrison
Great advertising can't be either/or.  It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4622 (20091119) __ The message was checked by ESET Smart Security

RE: CF8, Vista, SQL 2005

2009-11-19 Thread brad
Run a trace on the DB while you run the query in CF and see if the statement is ever making it to the database. It may be a data source driver issue. ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009

CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~|

RE: CFHTTP Connection Failure

2009-11-19 Thread Mark Kruger
I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent:

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is different and there is a TCP setting you have to change. You may want to look at your firewall also. Chad

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.comwrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105

RE: CFHTTP Connection Failure

2009-11-19 Thread Mark Kruger
Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent:

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
Chad I think the datasource connection is ok as I can select single individual columns in a query. Thanks SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. Thanks Run a trace on the DB while you run the query in CF and see if the statement is ever making it to the database. It may be a data source driver issue. ~Brad No problems in

RE: CF8, Vista, SQL 2005

2009-11-19 Thread brad
In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query? ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009

Re: CF and MS Access support

2009-11-19 Thread Dave Watts
I'm helping someone with a project and she elected to use GoDaddy as her host. They now tell her they have upgraded to the latest version of CF and it no longer supports MS Access databases. Have I missed something? This is news to me. It's possible that they're using 64-bit CF, which

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further - The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? In the trace does the statement complete? If you

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Robert Harrison
What's quite a few? I have a couple of SQL tables with more than 100 columns, one with over 200 columns, and have no problems at all... and that's SQL 2005, Vista, CF8. You may have a problem with available memory or disk space. Robert B. Harrison Director of Interactive Services

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Thanks What's quite a few? I have a couple of SQL tables with more than 100 columns, one with over 200 columns, and have no problems at all... and that's SQL 2005, Vista, CF8. You may have a

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Robert Harrison
of virus signature database 4623 (20091119) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
Just a guess, but maybe do some maintenance on the database. Try a shrink. Rebuild the indexs. Is the database from SQL 2005 or an earlier version? Sound like it is more on the CF end than the database through. Check the DSN setting in CFadministrator also. Remove it and add it back using

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __ The message was checked by ESET Smart Security. http://www.eset.com

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Forgive me if you've already answered this in the thread, but have you tried explicitly selecting all 40 of the columns? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
Also try restarting the CF ODBC services. There are two of them in the services control panel. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, November 19, 2009 5:04 PM To: cf-talk Subject: RE: CF8, Vista, SQL 2005 Just a guess, but maybe do

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
Selecting the 40 colums results in the same, but selecting a few coulumns is ok. Ive tried restarting services. Thanks Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Forgive me if you've already answered this in the thread, but have you tried

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC drivers. Are you able to select an entire row from a native SQL Server client?

jQuery Sortable list not working in CFWINDOW

2009-11-19 Thread Joshua Rowe
Hello! I have a page where a user can select other users to assign to a project. The user drags and drops a user from a list on the left side into another list on the right side. This is all handled using an unordered list and jQuery's sortable() function. This works great by itself, but I

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Then it's almost certainly a JDBC issue. You could try to find information about it in the DataDirect documentation (CF uses DataDirect Connect for JDBC) or you could try a different JDBC driver for SQL Server. Dave

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
How can I setup a different JDBC driver Thanks Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Then it's almost certainly a JDBC issue. You could try to find information about it in the DataDirect documentation (CF uses DataDirect Connect for JDBC) or you could

Amazon S3 - HTTPS and Live Stats

2009-11-19 Thread brad
I'm looking into moving over to Amazon S3 for hosting static content on a site that is currently hosted internally. We see wildly varying amounts of bandwidth from day to day, so S3 seems to be a natural solution to cut bandwidth costs. I will need to be able to access the files over HTTPS AND

RE: CF8, Vista, SQL 2005

2009-11-19 Thread brad
Place its JAR in your class path, restart CF and add the data source by constructing the JDBC URL and specifying the driver class name. I've always used the data direct drivers for SQL Server, but this might get you started: http://msdn.microsoft.com/en-us/data/aa937724.aspx ~Brad

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
How can I setup a different JDBC driver Here are some examples: http://www.bpurcell.org/blog/index.cfm?ENTRY=981mode=entry http://blog.demirkapi.net/post.cfm/installing-jtds-sql-server-jdbc-driver-for-coldfusion Here's the Adobe documentation for CF 7 - it works basically the same way in other

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long

Re: Amazon S3 - HTTPS and Live Stats

2009-11-19 Thread Dave Watts
I'm looking into moving over to Amazon S3 for hosting static content on a site that is currently hosted internally.  We see wildly varying amounts of bandwidth from day to day, so S3 seems to be a natural solution to cut bandwidth costs.   I will need to be able to access the files over

Re: CFHTTP Connection Failure

2009-11-19 Thread Dave Watts
the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Jaime Metcher
It might be worth looking at the connection settings in SQL studio. SQL studio by default will truncate long fields, which may be hiding row size limitations. If you bump up the field length limit in SQL studio and it still works, that would point even more strongly to JDBC. Jaime On Fri, Nov

Store Flash File in database then load into Flash?

2009-11-19 Thread Kim Hoopingarner
I have a client that required the flash file to be stored in an Oracle database. And now I am required to load Flash using an xml file that should be pulling its data from the database. I cannot store files on the server - so I'm trying to figure out if what I'm attempting is even possible.

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
Hmmm. not sure what the intermediate cert is. Shouldn't it also affect the one server that can connect? All four of them have the exact same config and cacerts file On Thu, Nov 19, 2009 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: the certs are already there. I compared the server

Re: Store Flash File in database then load into Flash?

2009-11-19 Thread Dave Watts
I have a client that required the flash file to be stored in an Oracle database.  And now I am required to load Flash using an xml file that should be pulling its data from the database.  I cannot store files on the server - so I'm trying to figure out if what I'm attempting is even

Re: CFHTTP Connection Failure

2009-11-19 Thread Dave Watts
Hmmm. not sure what the intermediate cert is. Shouldn't it also affect the one server that can connect? All four of them have the exact same config and cacerts file All the servers would presumably require the intermediate certs. Are you absolutely sure they all have the exact same list of

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
I used Keytool to inspect the cacerts from two servers and randomly checked lines and they all match. I can go back and check it again but why would 3 out of 4 work before 4:00 PM yesterday and keep failing since? On Thu, Nov 19, 2009 at 3:27 PM, Dave Watts dwa...@figleaf.com wrote: Hmmm.

Re: Store Flash File in database then load into Flash?

2009-11-19 Thread Kim Hoopingarner
I'll give that a try. I'm not supposed to write anything to the server. Sure makes the easy stuff tricky. Thanks, Dave! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of

Re: jQuery Sortable list not working in CFWINDOW

2009-11-19 Thread Tony Bentley
Try this: function sortLists(el){ var mylist = $(el); var listitems = mylist.children('li').get(); listitems.sort(function(a, b){ var compA = $(a).text().toUpperCase(); var compB = $(b).text().toUpperCase(); return (compA compB) ? -1 :

Re: jQuery Sortable list not working in CFWINDOW

2009-11-19 Thread Tony Bentley
Here is an example. It does not feature drag/drop but it works like a charm. http://tonybentley.com/projects/sortedlist.cfm?download=true ~| Want to reach the ColdFusion community with something they want? Let them know on

Re: Store Flash File in database then load into Flash?

2009-11-19 Thread denstar
Just pull the content, and use cfcontent + cfheader. If the data is base64()ed, toBinary() it first, but other than that, it's pretty straight forward. Basically a example of serving images from a DB will get you there. I've even got an example lying around here somewhere, if needed. It's way

Re: CFHTTP Connection Failure

2009-11-19 Thread Dave Watts
I used Keytool to inspect the cacerts from two servers and randomly checked lines and they all match. I can go back and check it again but why would 3 out of 4 work before 4:00 PM yesterday and keep failing since? I don't know. What happens if you attempt to browse those HTTPS URLs from the

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
Works fine accessing the service from the browser on all 4 servers. I even have small .net app on the servers, which connects just fine to this webservice. On Thu, Nov 19, 2009 at 4:19 PM, Dave Watts dwa...@figleaf.com wrote: I used Keytool to inspect the cacerts from two servers and

RE: CFHTTP Connection Failure

2009-11-19 Thread Mark Kruger
H. So the call to HTTP works, but HTTPS does not URLs are exactly the same I assume you have pinged around and made sure that the 4 servers resolve the domain exactly the same right? And you have tried a CF Restart? Sometimes the DNS cache for the JVM will have the wrong address

Re: jQuery Sortable list not working in CFWINDOW

2009-11-19 Thread Azadi Saryev
try this: 1) create a js function in your main page (the one that opens a cfwindow): script type=text/javascript createSortables = function() { // users available and assigned lists: $(ul#sListAvailable, ul#sListAssigned).sortabl e({ connectWith: ul.userList, placeHolder: ul.userList,

Converting an AJAX response to coldfusion object

2009-11-19 Thread Developer MediaDoc
Hi all, I am probably not using the correct 'language' here -- forgive me new to the AJAX world. I have a lovely cfgrid populated by binding it to a CFC. Everything works great. I have some 'filters' that let the users filter the data in the grid. Now the client has asked to have a 'download

RE: Converting an AJAX response to coldfusion object

2009-11-19 Thread lists
Any remote call to a CFC will return WDDX (unless otherwise specified). You could serialize the JS object into JSON, then pass it to ColdFusion as a struct. -Original Message- From: Developer MediaDoc [mailto:skings...@media-doc.com] Sent: Thursday, November 19, 2009 9:32 PM To:

Re: Internet Explorer and @ signs in link text

2009-11-19 Thread Scott Brady
The problem isn't that it's breaking the URL. It's that the @ sign in the _text_ of the link (i.e., the text displayed on screen that the user clicks on) is causing the mess-up in the link (so that the URL is displayed as the link instead).. So, if we URL encode the @ symbol with %40, the user

RE: Amazon S3 - HTTPS and Live Stats

2009-11-19 Thread brad
Are you planning to use Amazon Cloudfront in front of your S3 content? At this point in time, no. Our business is confined to the US and CAN so I'm not too worried about people on the other side of the world. I'm making bet that the latency will be acceptable for this continent. Of course,

RE: Internet Explorer and @ signs in link text

2009-11-19 Thread brad
Can you paste in the HTML if a sample link in its broken form for us to see? I mean the actual anchor tag in its completeness. ~Brad Original Message Subject: Re: Internet Explorer and @ signs in link text From: Scott Brady dsbr...@gmail.com Date: Thu, November 19, 2009 9:55

RE: Converting an AJAX response to coldfusion object

2009-11-19 Thread brad
a) if I don't specify returnFormat in my CFC, what format does cfgrid data come back as? (JSON, WDDX?). A naked call to a CFC usually returns WDDX. However, if you are binding to it with a cfgrid, returnformat=json is probably being added to the URL. b) how can I convert the javascript object

Re: CF and MS Access support

2009-11-19 Thread Maureen
GoDaddy doesn't support Access databases on on Windows IIS 7 accounts running ColdFusion. They support neither Access nor Coldfusion on their Grid Web Hosting accounts. If she will log into her GoDaddy account, go to the help center and search on Coldfusion, there are several articles that

Re: Converting an AJAX response to coldfusion object

2009-11-19 Thread Azadi Saryev
see if this helps: http://www.coldfusionjedi.com/index.cfm/2007/9/4/Exporting-from-CFGRID Azadi Saryev On 20/11/2009 11:32, Developer MediaDoc wrote: Hi all, I am probably not using the correct 'language' here -- forgive me new to the AJAX world. I have a lovely cfgrid populated by

Re: Amazon S3 - HTTPS and Live Stats

2009-11-19 Thread Dave Watts
At this point in time, no.  Our business is confined to the US and CAN so I'm not too worried about people on the other side of the world. I'm making bet that the latency will be acceptable for this continent.  Of course, please tell if you have found otherwise, or have a really good reason

RE: Amazon S3 - HTTPS and Live Stats

2009-11-19 Thread brad
My understanding is that you would not have to pay for end-user access to S3 content if you're using Cloudfront. You'd pay for end-user access to that content via Cloudfront, and you'd have to pay the normal S3 upload and storage fees for your own access to your bucket. That said, I would