Re: ms sql stored procedure call returns columns in different order?

2010-12-08 Thread rex
query.getColumnNames() should be able to get your columns in the original order I can see some cases where the original order is needed, like when outputting dynamic SQL and you want to preserve the column order, i.e. in a SQL client app. On 12/8/2010 1:48 PM, Janet Whittredge wrote: > I call

Re: ms sql stored procedure call returns columns in different order?

2010-12-08 Thread Rick Root
How do you know the column order changed? By doing ? If so, that's not SQL Server changing the column order, that's Try calling #getMetaData(qry)# instead and you'll see the actual column order as it is returned by sql server. Rick ~~~

Re: ms sql stored procedure call returns columns in different order?

2010-12-08 Thread John M Bliss
Order of columns should not matter. Why does it in your case? On Wed, Dec 8, 2010 at 3:48 PM, Janet Whittredge wrote: > > I call a stored procedure in and the result set returned has all > of the > data the stored procedure generated, but, the column order is changed to > alphabetical order. W

ms sql stored procedure call returns columns in different order?

2010-12-08 Thread Janet Whittredge
I call a stored procedure in and the result set returned has all of the data the stored procedure generated, but, the column order is changed to alphabetical order. Why is the resultset changed? Is there any way to get the data back as it was generated in the stored procedure? ColdFusion 8

RE: CF and a Remote PHP Site...

2010-12-08 Thread Russ Michaels
If the client vars are stored in db then u can manipulate the db directly. For complex vars just store them as wddx or json. Russ -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 08 December 2010 20:56 To: cf-talk Subject: Re: CF and a Remote PHP Site

Re: CF and a Remote PHP Site...

2010-12-08 Thread Dominic Watson
Yeh, sounds fun ;) On 8 December 2010 20:42, Che Vilnonis wrote: > > Thanks Dominic. Yeah, that helps. > I think the hardest part might be the session mgmt. with the client vars > that the legacy CF app uses. > > -Original Message- > From: Dominic Watson [mailto:watson.domi...@googlemai

RE: CF and a Remote PHP Site...

2010-12-08 Thread Che Vilnonis
Thanks Dominic. Yeah, that helps. I think the hardest part might be the session mgmt. with the client vars that the legacy CF app uses. -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Wednesday, December 08, 2010 3:18 PM To: cf-talk Subject: Re: CF an

Re: .NET errors after CF 9.01 Update

2010-12-08 Thread Rick Root
On Wed, Dec 8, 2010 at 11:03 AM, Russ Michaels wrote: > > I have never used any of the .net features in CF, is this a CF setting, or > is it simply asp.net settings in IIS you had to change? > No... See the example here http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172

Re: CF and a Remote PHP Site...

2010-12-08 Thread Dominic Watson
So it sounds like the data will need to be processed in the same request as the user visiting some page on your site (so that you can associate the data with the client in session / client scope). Something that occurs to me off the top of my head: * User finishes with 3rd party site and ready t

RE: CF and a Remote PHP Site...

2010-12-08 Thread Russ Michaels
A listener page would imply that they will be sending you all the information in bulk at a non-determined time, if that is the case them yes that would work. However if this needs to happen in real time when someone is placing an order then you would need to be calling a web service of some kind t

RE: CF and a Remote PHP Site...

2010-12-08 Thread Che Vilnonis
Thanks Russ. Let me explain further. The third party PHP site would mimic the entire line of products that the picture framing company sells. (IDs and SKUs would be the same.) I would then pass a "Frame ID" to the third party PHP site. Over a period of time, the customer would build his/her frame.

RE: CF and a Remote PHP Site...

2010-12-08 Thread Russ Michaels
>From what you have said this sounds really simple to achieve. You presumably have pictures of the frames. User chooses the frame. User uploads their photo Resize the photo to fit in the frame, and overlay it on top of the frame image using a div and position it. Russ -Original Message-

CF and a Remote PHP Site...

2010-12-08 Thread Che Vilnonis
We have a client that sells custom built picture frames on an older CF app. His competition uses software that allows customers to upload photos and to "visually" see the picture frames they are building. He wants to add this functionality to his web site. I was put in touch with a company that s

RE: checking for active links/pages (OT)

2010-12-08 Thread DURETTE, STEVEN J (ATTASIAIT)
You could write something that parses out cfm files looking for the cflocation, cfinclude and a href tags and grab the filenames. Then you could filter that to be a distinct list. Then as everyone else suggested, search the logs to see if they have been hit recently. Steve -Original Message

Re: checking for active links/pages (OT)

2010-12-08 Thread Mack
> Actually neither of those would work because I'm not checking to see if the > links are valid, I would like to return a list of all .cfm files that are > used within a website. Maybe that's a better way of stating what I'm trying > to do. Depends on how much time you want to dedicate to this yo

Re: Memory Usage Question (HEAPDUMP Included)

2010-12-08 Thread Mack
On Wed, Dec 8, 2010 at 6:09 PM, Brook Davies wrote: > > One again my memory usage was steady at 20%, something happened and now its > up and down from 15% to 90% and back down within minutes. Here is a screen > shot of the memory graph in seeFusion. GC seems to be doing its job, but > this does n

Re: checking for active links/pages (OT)

2010-12-08 Thread Greg Morphis
Actually neither of those would work because I'm not checking to see if the links are valid, I would like to return a list of all .cfm files that are used within a website. Maybe that's a better way of stating what I'm trying to do. On Wed, Dec 8, 2010 at 10:44 AM, Greg Morphis wrote: > I'll ch

Re: checking for active links/pages (OT)

2010-12-08 Thread Greg Morphis
I'll check out the link thanks, checking logs wouldn't help. On the server their might be a header2.cfm and a header10232010.cfm. The header10232010.cfm is never used so it wouldn't show up in the logs but it's an inactive page that I'd like to remove. On Wed, Dec 8, 2010 at 10:18 AM, Russ Michae

RE: checking for active links/pages (OT)

2010-12-08 Thread Russ Michaels
For links in pages Use a link checker service such as http://validator.w3.org/checklink/ For cfincludes and the likes, if they contain invalid path then the page would throw an error, so you should check your coldfusion logs for errors and resolve them, which you should be doing regularly anyway.

Re: Is this expected behaviour for a table in a cfc passed back?

2010-12-08 Thread morgan l
Are you doing a 'view source' in the browser, or 'inspect element' in Firebug? Firebug will report the HTML as what you posted as your results. It's reporting the HTML as what Firefox rendered; the will either need to include the entire table, or be entirely inside a to render properly in most b

checking for active links/pages (OT)

2010-12-08 Thread Greg Morphis
I'm working on a website where they've done some development work on the production server and I'm trying to clean it up. Does anyone have any ideas on how they would accomplish this aside from opening up each and every file and checking for and tags? ~

RE: Memory Usage Question (HEAPDUMP Included)

2010-12-08 Thread Brook Davies
One again my memory usage was steady at 20%, something happened and now its up and down from 15% to 90% and back down within minutes. Here is a screen shot of the memory graph in seeFusion. GC seems to be doing its job, but this does not seem normal or does it!? http://screencast.com/t/6SkU3bF9Gs

Re: Is this expected behaviour for a table in a cfc passed back?

2010-12-08 Thread Casey Dougall
On Sun, Dec 5, 2010 at 6:31 AM, Stephen Cassady wrote: > > >test > > > Fieldset is a Form tag item not a Table item. Month Savings Sum $180 January $100 February

RE: .NET errors after CF 9.01 Update

2010-12-08 Thread Russ Michaels
I have never used any of the .net features in CF, is this a CF setting, or is it simply asp.net settings in IIS you had to change? Russ -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 08 December 2010 13:18 To: cf-talk Subject: Re: .NET errors after CF 9.01 Update

Re: Is this expected behaviour for a table in a cfc passed back?

2010-12-08 Thread Stephen Cassady
>so doing a quick test showed the result as it should (on CF8), the > did not move in the source code but I should point out that >Kym Thanks Kym - I should have mentioned that I'm on CF9, but knowing it is as appropriate in CF8 is a great benchmark. I'm just totally perplexed why this seems t

Re: .NET errors after CF 9.01 Update

2010-12-08 Thread Rick Root
On Wed, Dec 8, 2010 at 6:27 AM, Russ Michaels wrote: > > Perhaps you could clarify how you make sure you call a 64bit dll first to > avoid this issue. > > Gladly! the assembly / DLL path is different... C:\Windows\Microsoft.NET\Framework\* vs C:\Windows\Microsoft.NET\Framework64\* rick

RE: .NET errors after CF 9.01 Update

2010-12-08 Thread Russ Michaels
Rick, Perhaps you could clarify how you make sure you call a 64bit dll first to avoid this issue. Russ -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 07 December 2010 22:06 To: cf-talk Subject: Re: .NET errors after CF 9.01 Update Alright, thanks to the kind fo