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 w

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 > rea

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 b

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 addres

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 in

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 Date: Thu, November 19, 2009 9:55 pm To: cf-talk

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, plea

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 w

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: cf-tal

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: 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): 2) remove your current $(document).ready(...) block (completely if it is in the page loaded in cfwindow, or just the part of it that creates the sortable lists if it is in the main page and also has other functi

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: 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 wrote: > > > I used Keytool to inspect the cacerts from two servers and randomly > checked > >

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: 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: 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 the

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: 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 Fusio

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 wrote: > > > Hmmm. not sure what the

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: 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 po

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 wrote: > > > the certs are already there. I compared the server working with the one >

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: 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

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 lon

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 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 confer

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=981&mode=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 othe

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 Orig

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 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 y

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. Da

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 i

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 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 clien

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

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 may

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 Softwar

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
://www.austin-williams.com > >Great advertising can't be either/or.  It must be &. > >Plug in to our blog: A&W Unplugged >http://www.austin-williams.com/unplugged > > >__ Information from ESET Smart Security, version of virus sig

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 Robert Harrison
on from ESET Smart Security, version 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

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

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 Aus

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 lo

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 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 Date: Thu, November 19, 2009 2:22 pm To: cf-talk I ra

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 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

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: Thursday

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 wrote: > > 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.c

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 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: Thursda

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: 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 Date: Thu, November 19, 2009 11:15 am To: cf-talk No pro

RE: Internet Explorer and @ signs in link text

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

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 C

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 @ symbol

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 Date: Thu, November 19, 2009 10:27 am To: cf-talk Hi

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] ca

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 he

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 Date: Thu, November 19, 2009 9:08 am To:

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

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: 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 ti

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 t

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 > pa

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

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:

Re: CF and MS Access support

2009-11-19 Thread Casey Dougall
On Thu, Nov 19, 2009 at 8:17 AM, Stephens, Larry V wrote: > > 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 new

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 Ma