Re: ms sql stored procedure call returns columns in different order?
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 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, MS > SQL Server 2005, Windows Server 2003 > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ms sql stored procedure call returns columns in different order?
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 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ms sql stored procedure call returns columns in different order?
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. Why is the resultset changed? Is there any way to get > the data back as it was generated in the stored procedure? ColdFusion 8, > MS SQL Server 2005, Windows Server 2003 > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ms sql stored procedure call returns columns in different order?
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, MS SQL Server 2005, Windows Server 2003 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and a Remote PHP Site...
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... 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...@googlemail.com] > Sent: Wednesday, December 08, 2010 3:18 PM > To: cf-talk > Subject: Re: CF and a Remote PHP Site... > > > 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 to return to you with the > details... > * 3rd party sends the user to your page, providing some token with which > to > fetch the data, e.g. locate to: > yoursite.com/some.cfm?thirdPartyToken=3535A6F4587395EB5B > * the cfm page that the user lands on makes a request to 3rd party, > supplying the token, 3rd party responds with all the relevant data that can > then be stored in the client/session scope as you are still within the > clients visit request > > Alternatively, the url to which the 3rd party redirects your user could > have > all the neccessary data, e.g. locate to: > yoursite.com/some.cfm?width=487height=48&picture=9734857 etc. > > HTH > > Dominic > > On 8 December 2010 18:27, Che Vilnonis wrote: > > > > > 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. > > Once he/she hits "add to cart", the third party PHP site would pass > > back several variables such as the selected frame width, frame height, > > mat width, mat height, second mat width and height, mat style, mat > > cut, plexiglass width and height, foam core width and height, etc. > > Basically, I would need to get back 15-20 variables of data to create > > one custom picture frame. > > Does > > that make more sense? > > > > Would a simple CF "listener" page work where all the data is passed > > back in the query string and then parsed? Would that be the best way to > do > this? > > > > Thanks, Che > > > > -Original Message- > > From: Russ Michaels [mailto:r...@michaels.me.uk] > > Sent: Wednesday, December 08, 2010 1:13 PM > > To: cf-talk > > Subject: RE: CF and a Remote PHP Site... > > > > > > >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- > > From: Che Vilnonis [mailto:ch...@asitv.com] > > Sent: 08 December 2010 17:19 > > To: cf-talk > > Subject: CF and a Remote PHP Site... > > > > > > 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 sells this type of software. It > > is written in PHP. The PHP developer thought we'd be able to "pass > > data" from my site to his. Once the "visualized" frame was built, he'd > "pass data" > > back > > to me and I would add the custom built frame to the shopping cart. > > > > Sending data to the remote site (via XML and CFHTTP) is not an issue. > > > > I'm looking for a solution on how to best "receive" the data. Keep in > > mind, the CF site runs on a CFMX 6 shared server that uses client > > variables for storage. > > > > I realize this is not the best way to do things and there would be > > pitfalls with session timeouts, etc. Any advice would be appreciated. > > > > Thanks, Che > > > > > > > > > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF and a Remote PHP Site...
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...@googlemail.com] > Sent: Wednesday, December 08, 2010 3:18 PM > To: cf-talk > Subject: Re: CF and a Remote PHP Site... > > > 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 to return to you with the > details... > * 3rd party sends the user to your page, providing some token with which > to > fetch the data, e.g. locate to: > yoursite.com/some.cfm?thirdPartyToken=3535A6F4587395EB5B > * the cfm page that the user lands on makes a request to 3rd party, > supplying the token, 3rd party responds with all the relevant data that can > then be stored in the client/session scope as you are still within the > clients visit request > > Alternatively, the url to which the 3rd party redirects your user could > have > all the neccessary data, e.g. locate to: > yoursite.com/some.cfm?width=487height=48&picture=9734857 etc. > > HTH > > Dominic > > On 8 December 2010 18:27, Che Vilnonis wrote: > > > > > 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. > > Once he/she hits "add to cart", the third party PHP site would pass > > back several variables such as the selected frame width, frame height, > > mat width, mat height, second mat width and height, mat style, mat > > cut, plexiglass width and height, foam core width and height, etc. > > Basically, I would need to get back 15-20 variables of data to create > > one custom picture frame. > > Does > > that make more sense? > > > > Would a simple CF "listener" page work where all the data is passed > > back in the query string and then parsed? Would that be the best way to > do > this? > > > > Thanks, Che > > > > -Original Message- > > From: Russ Michaels [mailto:r...@michaels.me.uk] > > Sent: Wednesday, December 08, 2010 1:13 PM > > To: cf-talk > > Subject: RE: CF and a Remote PHP Site... > > > > > > >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- > > From: Che Vilnonis [mailto:ch...@asitv.com] > > Sent: 08 December 2010 17:19 > > To: cf-talk > > Subject: CF and a Remote PHP Site... > > > > > > 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 sells this type of software. It > > is written in PHP. The PHP developer thought we'd be able to "pass > > data" from my site to his. Once the "visualized" frame was built, he'd > "pass data" > > back > > to me and I would add the custom built frame to the shopping cart. > > > > Sending data to the remote site (via XML and CFHTTP) is not an issue. > > > > I'm looking for a solution on how to best "receive" the data. Keep in > > mind, the CF site runs on a CFMX 6 shared server that uses client > > variables for storage. > > > > I realize this is not the best way to do things and there would be > > pitfalls with session timeouts, etc. Any advice would be appreciated. > > > > Thanks, Che > > > > > > > > > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and a Remote PHP Site...
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 and a Remote PHP Site... 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 to return to you with the details... * 3rd party sends the user to your page, providing some token with which to fetch the data, e.g. locate to: yoursite.com/some.cfm?thirdPartyToken=3535A6F4587395EB5B * the cfm page that the user lands on makes a request to 3rd party, supplying the token, 3rd party responds with all the relevant data that can then be stored in the client/session scope as you are still within the clients visit request Alternatively, the url to which the 3rd party redirects your user could have all the neccessary data, e.g. locate to: yoursite.com/some.cfm?width=487height=48&picture=9734857 etc. HTH Dominic On 8 December 2010 18:27, Che Vilnonis wrote: > > 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. > Once he/she hits "add to cart", the third party PHP site would pass > back several variables such as the selected frame width, frame height, > mat width, mat height, second mat width and height, mat style, mat > cut, plexiglass width and height, foam core width and height, etc. > Basically, I would need to get back 15-20 variables of data to create > one custom picture frame. > Does > that make more sense? > > Would a simple CF "listener" page work where all the data is passed > back in the query string and then parsed? Would that be the best way to do this? > > Thanks, Che > > -Original Message- > From: Russ Michaels [mailto:r...@michaels.me.uk] > Sent: Wednesday, December 08, 2010 1:13 PM > To: cf-talk > Subject: RE: CF and a Remote PHP Site... > > > >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- > From: Che Vilnonis [mailto:ch...@asitv.com] > Sent: 08 December 2010 17:19 > To: cf-talk > Subject: CF and a Remote PHP Site... > > > 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 sells this type of software. It > is written in PHP. The PHP developer thought we'd be able to "pass > data" from my site to his. Once the "visualized" frame was built, he'd "pass data" > back > to me and I would add the custom built frame to the shopping cart. > > Sending data to the remote site (via XML and CFHTTP) is not an issue. > > I'm looking for a solution on how to best "receive" the data. Keep in > mind, the CF site runs on a CFMX 6 shared server that uses client > variables for storage. > > I realize this is not the best way to do things and there would be > pitfalls with session timeouts, etc. Any advice would be appreciated. > > Thanks, Che > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: .NET errors after CF 9.01 Update
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/WSc3ff6d0ea77859461172e0811cbec22c24-789c.html Though, in the example, they don't reference a specific DLL because they're using one that is supposed to be included by default, courtesy of the dotnext_coreproxy.config file I think. You actually reference the specific DLL you want to include with the assembly attribute of the cfobject tag. then, you can call the methods just like you would a java class. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF and a Remote PHP Site...
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 to return to you with the details... * 3rd party sends the user to your page, providing some token with which to fetch the data, e.g. locate to: yoursite.com/some.cfm?thirdPartyToken=3535A6F4587395EB5B * the cfm page that the user lands on makes a request to 3rd party, supplying the token, 3rd party responds with all the relevant data that can then be stored in the client/session scope as you are still within the clients visit request Alternatively, the url to which the 3rd party redirects your user could have all the neccessary data, e.g. locate to: yoursite.com/some.cfm?width=487height=48&picture=9734857 etc. HTH Dominic On 8 December 2010 18:27, Che Vilnonis wrote: > > 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. > Once he/she hits "add to cart", the third party PHP site would pass back > several variables such as the selected frame width, frame height, mat > width, > mat height, second mat width and height, mat style, mat cut, plexiglass > width and height, foam core width and height, etc. Basically, I would need > to get back 15-20 variables of data to create one custom picture frame. > Does > that make more sense? > > Would a simple CF "listener" page work where all the data is passed back in > the query string and then parsed? Would that be the best way to do this? > > Thanks, Che > > -Original Message- > From: Russ Michaels [mailto:r...@michaels.me.uk] > Sent: Wednesday, December 08, 2010 1:13 PM > To: cf-talk > Subject: RE: CF and a Remote PHP Site... > > > >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- > From: Che Vilnonis [mailto:ch...@asitv.com] > Sent: 08 December 2010 17:19 > To: cf-talk > Subject: CF and a Remote PHP Site... > > > 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 sells this type of software. It is > written in PHP. The PHP developer thought we'd be able to "pass data" from > my site to his. Once the "visualized" frame was built, he'd "pass data" > back > to me and I would add the custom built frame to the shopping cart. > > Sending data to the remote site (via XML and CFHTTP) is not an issue. > > I'm looking for a solution on how to best "receive" the data. Keep in mind, > the CF site runs on a CFMX 6 shared server that uses client variables for > storage. > > I realize this is not the best way to do things and there would be pitfalls > with session timeouts, etc. Any advice would be appreciated. > > Thanks, Che > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and a Remote PHP Site...
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 to get the info to display to the customer while they are using your site. You need to speak with the 3rd party to find out what they provide by way of an API. Russ -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: 08 December 2010 18:28 To: cf-talk Subject: RE: CF and a Remote PHP Site... 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. Once he/she hits "add to cart", the third party PHP site would pass back several variables such as the selected frame width, frame height, mat width, mat height, second mat width and height, mat style, mat cut, plexiglass width and height, foam core width and height, etc. Basically, I would need to get back 15-20 variables of data to create one custom picture frame. Does that make more sense? Would a simple CF "listener" page work where all the data is passed back in the query string and then parsed? Would that be the best way to do this? Thanks, Che -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, December 08, 2010 1:13 PM To: cf-talk Subject: RE: CF and a Remote PHP Site... >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- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: 08 December 2010 17:19 To: cf-talk Subject: CF and a Remote PHP Site... 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 sells this type of software. It is written in PHP. The PHP developer thought we'd be able to "pass data" from my site to his. Once the "visualized" frame was built, he'd "pass data" back to me and I would add the custom built frame to the shopping cart. Sending data to the remote site (via XML and CFHTTP) is not an issue. I'm looking for a solution on how to best "receive" the data. Keep in mind, the CF site runs on a CFMX 6 shared server that uses client variables for storage. I realize this is not the best way to do things and there would be pitfalls with session timeouts, etc. Any advice would be appreciated. Thanks, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and a Remote PHP Site...
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. Once he/she hits "add to cart", the third party PHP site would pass back several variables such as the selected frame width, frame height, mat width, mat height, second mat width and height, mat style, mat cut, plexiglass width and height, foam core width and height, etc. Basically, I would need to get back 15-20 variables of data to create one custom picture frame. Does that make more sense? Would a simple CF "listener" page work where all the data is passed back in the query string and then parsed? Would that be the best way to do this? Thanks, Che -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, December 08, 2010 1:13 PM To: cf-talk Subject: RE: CF and a Remote PHP Site... >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- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: 08 December 2010 17:19 To: cf-talk Subject: CF and a Remote PHP Site... 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 sells this type of software. It is written in PHP. The PHP developer thought we'd be able to "pass data" from my site to his. Once the "visualized" frame was built, he'd "pass data" back to me and I would add the custom built frame to the shopping cart. Sending data to the remote site (via XML and CFHTTP) is not an issue. I'm looking for a solution on how to best "receive" the data. Keep in mind, the CF site runs on a CFMX 6 shared server that uses client variables for storage. I realize this is not the best way to do things and there would be pitfalls with session timeouts, etc. Any advice would be appreciated. Thanks, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and a Remote PHP Site...
>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- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: 08 December 2010 17:19 To: cf-talk Subject: CF and a Remote PHP Site... 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 sells this type of software. It is written in PHP. The PHP developer thought we'd be able to "pass data" from my site to his. Once the "visualized" frame was built, he'd "pass data" back to me and I would add the custom built frame to the shopping cart. Sending data to the remote site (via XML and CFHTTP) is not an issue. I'm looking for a solution on how to best "receive" the data. Keep in mind, the CF site runs on a CFMX 6 shared server that uses client variables for storage. I realize this is not the best way to do things and there would be pitfalls with session timeouts, etc. Any advice would be appreciated. Thanks, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF and a Remote PHP Site...
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 sells this type of software. It is written in PHP. The PHP developer thought we'd be able to "pass data" from my site to his. Once the "visualized" frame was built, he'd "pass data" back to me and I would add the custom built frame to the shopping cart. Sending data to the remote site (via XML and CFHTTP) is not an issue. I'm looking for a solution on how to best "receive" the data. Keep in mind, the CF site runs on a CFMX 6 shared server that uses client variables for storage. I realize this is not the best way to do things and there would be pitfalls with session timeouts, etc. Any advice would be appreciated. Thanks, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: checking for active links/pages (OT)
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- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Wednesday, December 08, 2010 11:12 AM To: cf-talk Subject: checking for active links/pages (OT) 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? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: checking for active links/pages (OT)
> 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 you can: - find out what .cfm files are access from the logs; - find out what CF files are access by parsing the compiled CF classes after starting with an empty cfclasses directory (each compiled class contains the name of the CF source file - .cfc or .cfm) Creating a list of all the files and the removing the ones that are present in the above 2 lists will give you hopefully a much shorter third list of files that you can check manually to see if they are used. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Memory Usage Question (HEAPDUMP Included)
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 not seem normal or does it!? > > http://screencast.com/t/6SkU3bF9Gsx Considering that the number of requests is not increasing this shouldn't happen (unless requests after 7:00am retrieve much more records from the database for example) > So I did a heapdump and analyzed it in MAT for eclipse: > > When I took the dump memory on the server was reported at 90% by seefusion. > The JVM has 1 gig allocated to it. The dump doesn't show near that much > memory in use, so maybe a GC ran right before I took the dump, I'm not sure. Your total memory seems low in the screenshot (aprox 200M) so I suspect that you took the heap-dump right after a gc. > Does anyone see anything that stands out in these reports? Should there be > that many jdbc.base.preparedStatement items? > > http://screencast.com/t/Th4ZiLZw > http://screencast.com/t/IdGqa6Uh In my experience 2775 is not that big for the number of PreparedStatements. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: checking for active links/pages (OT)
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 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 Michaels wrote: > >> >> 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. >> >> >> Russ >> -Original Message- >> From: Greg Morphis [mailto:gmorp...@gmail.com] >> Sent: 08 December 2010 16:12 >> To: cf-talk >> Subject: checking for active links/pages (OT) >> >> >> 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? >> >> >> >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: checking for active links/pages (OT)
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 Michaels wrote: > > 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. > > > Russ > -Original Message- > From: Greg Morphis [mailto:gmorp...@gmail.com] > Sent: 08 December 2010 16:12 > To: cf-talk > Subject: checking for active links/pages (OT) > > > 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? > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: checking for active links/pages (OT)
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. Russ -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: 08 December 2010 16:12 To: cf-talk Subject: checking for active links/pages (OT) 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? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is this expected behaviour for a table in a cfc passed back?
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 browsers. On Sun, Dec 5, 2010 at 3:48 PM, Stephen Cassady wrote: > > >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 to be happening. > > Stephen > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
checking for active links/pages (OT)
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? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Memory Usage Question (HEAPDUMP Included)
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/6SkU3bF9Gsx So I did a heapdump and analyzed it in MAT for eclipse: When I took the dump memory on the server was reported at 90% by seefusion. The JVM has 1 gig allocated to it. The dump doesn't show near that much memory in use, so maybe a GC ran right before I took the dump, I'm not sure. Does anyone see anything that stands out in these reports? Should there be that many jdbc.base.preparedStatement items? http://screencast.com/t/Th4ZiLZw http://screencast.com/t/IdGqa6Uh On another note, its pretty cool that you can see whats stored in the application scope and its memory usage. This screenshot shows the structs/arrays/strings that are application scoped: http://screencast.com/t/XZyRofWTJNN Brook -Original Message- From: Mack [mailto:mrsmith.w...@gmail.com] Sent: December-06-10 4:07 AM To: cf-talk Subject: Re: Memory Usage Question > I wish I could see WHAT was taking up the ram, i.e a specific array, cfc > instances, etc etc It can be done but it's not easy. Basically you need to do a heap dump of the CF process (you can do that without shutting down the server) and then analyze the heap dump using MAT for Eclipse. MAT can tell you what are the objects on the heap, etc. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is this expected behaviour for a table in a cfc passed back?
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 $80 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: .NET errors after CF 9.01 Update
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 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 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is this expected behaviour for a table in a cfc passed back?
>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 to be happening. Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: .NET errors after CF 9.01 Update
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 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: .NET errors after CF 9.01 Update
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 folks at SupportObjective (www.justcf.com), we figured out this little tidbid. Apparently, Coldfusion's .NET integration when installed on Win7 64 bit can call both 64 bit and 32 bit DLLs. However, it creates the dotnet proxy DLL dynamically when first called - and we were calling a system DLL from the 32 bit framework. So, after stopping the services, deleting all of the cached jar files in the dotnetproxy folder as well as the dotnetcoreproxy.jar in the same instance, and then making sure to FIRST call a DLL from the 64 bit framework... then everything is fine - including calling DLLs from the 32 bit .NET framework Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
