RE: imageCFC imaging component
ImageCFC already has that capability. http://tutorial483.easycfm.com/ I believe that tutorial terms it as "scaling" images. -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 1:21 AM To: CF-Talk Subject: imageCFC imaging component Hello I am looking for an imaging component that can do all that imageCFC does http://www.opensourcecf.com/imagecfc/ but also with the ability to make a thumbnail. At the same cost as imageCFC would be good ;-) can anyone advise on my options? Thanks for reading. cheers Martin ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
imageCFC imaging component
Hello I am looking for an imaging component that can do all that imageCFC does http://www.opensourcecf.com/imagecfc/ but also with the ability to make a thumbnail. At the same cost as imageCFC would be good ;-) can anyone advise on my options? Thanks for reading. cheers Martin ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: purchasing CF7 license
Oh man,I didn;t want this thread to turn into another "doomsday for CF" thread. God knows we've had enough of those lately. For the record, purchasing through Paul at Qulldesign was a breeze, about as good a price as one could get without getting some edu version, and it will be here, in the box for a little under 1200 USD. Thanks Oh, and Carl, we're just a little CF shop here in NH, I doubt we'd have any clout in the "big boy" world... On 9/28/06, Phillip Holmes <[EMAIL PROTECTED]> wrote: > > Daniel.. Yeah that's crazy... > > Adobe is killing ColdFusion with this insanely high pricing. > $5999.00... Like the 999.99 makes a difference in your purchasing > decision.. > LOL. > > If someone from Adobe reads this list, please have the vision to lower > your > pricing before .NET forces the product into non-existence or entirely open > source. I love CF, but I can see it's market share dwindling away day by > day. > > IMHO.. No version of CF should be over 1000.00 or 999.99 to all you Adobe > marketing geniuses. > > --Phil > > ==> > > > -Original Message- > From: Daniel Lancelot [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 4:45 PM > To: CF-Talk > Subject: Re: purchasing CF7 license > > All places are not the same price > > Adobe (and Macromedia before them) has an "interesting" pricing policy, > depedant on what part of the world you live in... > > CFMX 7 Enterprise, bought as a download from the online store: > > US price: $5,999 (USD) - roughly £3,197 (GBP) UK price: £4,225 (GBP) - > roughly $7,928 (USD) > > So.. the same product - bought in the same online store - costs nearly > $2,000 extra, if you are based iin the uk. > Note this is for the download product - so there are no additional > shipping > costs to take into account - and this does not include any addtional VAT > etc. > > I was pleased to see that New Atlanta do not appear to charge any > additional > "Dirty Foreigner" tax - the price for BlueDragon 6.2 for Microsoft .NET > Framework 1-CPU Server appears to be $2,999 wherever you are based... > > Not impressed > > On 9/27/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > > > > Where's the cheapest place to buy a CF7 license? Or, are all places > > pretty much the same price? > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOLVED: DB2 mainframe queries still not working properly! =(
Awesome! I bet you feel like a million bucks right now. I always love these sorts of victories. M!ke ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: purchasing CF7 license
Daniel.. Yeah thats crazy... Adobe is killing ColdFusion with this insanely high pricing. $5999.00... Like the 999.99 makes a difference in your purchasing decision.. LOL. If someone from Adobe reads this list, please have the vision to lower your pricing before .NET forces the product into non-existence or entirely open source. I love CF, but I can see it's market share dwindling away day by day. IMHO.. No version of CF should be over 1000.00 or 999.99 to all you Adobe marketing geniuses. --Phil ==> -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 4:45 PM To: CF-Talk Subject: Re: purchasing CF7 license All places are not the same price Adobe (and Macromedia before them) has an "interesting" pricing policy, depedant on what part of the world you live in... CFMX 7 Enterprise, bought as a download from the online store: US price: $5,999 (USD) - roughly £3,197 (GBP) UK price: £4,225 (GBP) - roughly $7,928 (USD) So.. the same product - bought in the same online store - costs nearly $2,000 extra, if you are based iin the uk. Note this is for the download product - so there are no additional shipping costs to take into account - and this does not include any addtional VAT etc. I was pleased to see that New Atlanta do not appear to charge any additional "Dirty Foreigner" tax - the price for BlueDragon 6.2 for Microsoft .NET Framework 1-CPU Server appears to be $2,999 wherever you are based... Not impressed On 9/27/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > > Where's the cheapest place to buy a CF7 license? Or, are all places > pretty much the same price? > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfchart
Richard, You should read about AJAX and Flex (in particular, Flex Data Services). Both of these allow for communication between the client browser and app server without having to refresh the page. I am not terribly familiar with either AJAX or Flex, but I know that AJAX is JavaScript and XML based while Flex is a proprietary language developed by Macromedia/Adobe and also makes use of Flash and Flash remoting. Here's a link to a good article that Ben Forta wrote about Flex data services which can do exactly what you're looking to do: http://www.adobe.com/devnet/coldfusion/articles/fr_fds.html - Justin On 9/28/06, Richard White <[EMAIL PROTECTED]> wrote: > > hi, just wanted to clarify something really. I am using cfcharts but on > one of the pages i need the chart to dynamically change as the user changes > the data on the form. > > I know coldfusion is all server side so i am assuming that there is no way > of getting the chart to redisplay with the data that the user is entering on > the page without reloading the page. If i want this to be done without the > page refreshing am i going to have to use a javascript chart in order to > achieve this? > > thanks > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Handling "Marketing URLs"
Here's the 404 redirector code that I developed for a couple of my sites:
attemptedURL = "http://"; & CGI.server_name & CGI.script_name;
generatedURL = getToken(CGI.query_string, 2, ";");
if (len(trim(generatedURL)) EQ 0) {
generatedURL = attemptedURL;
}
if (findNoCase(":80", generatedurl) NEQ 0) {
generatedurl = replacenocase(generatedurl, ":80", "");
}
SELECT R.goodURL
FROMtblRedirects R
WHERE R.badURL = '#generatedURL#' AND
((R.goodurl IS NOT NULL) OR
(R.goodurl != ''))
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254698
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: select * (star) caching
This problem existed prior to CFMX, so its not CFQUERYPARAM related. Snake -Original Message- From: Porter, Benjamin L. [mailto:[EMAIL PROTECTED] Sent: 28 September 2006 18:08 To: CF-Talk Subject: RE: select * (star) caching Ask for them all by name. That is not a good reason. It does not let anyone else reading your code know what you are doing. I am not sure if this is a coldfusion problem or the fact that if you use the db driver uses sp_prepexec on SQL servers which caches an execution plan for the query, and uses bind variables. This may cause SQL server to return the exact same results for the query even if the table structure changes. Again the right way to deal with this is to not use SELECT * ever. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 2:20 PM To: CF-Talk Subject: RE: select * (star) caching How about if you need all the columns? -Original Message- From: Porter, Benjamin L. [mailto:[EMAIL PROTECTED] Sent: 27 September 2006 19:19 To: CF-Talk Subject: RE: select * (star) caching This is a known issue. For best practices you should never use select *. There is no good business or coding reason to do so, it should be transparent what data you are asking for. I'm not sure if flushing the template cache will correct this. It is simple enough to test in a dev environment. -Original Message- From: Brent Shaub [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 12:57 PM To: CF-Talk Subject: select * (star) caching Is this new to CF 7? I've got a handful of "select *" queries that when I modify the underlying table, the results do not include the new column(s). If this is a known issue, how can I refresh the cache for CF to pull the new fields? Since I inherited the app, listing all the columns and ideally reviewing which columns are needed (which is further time-consuming since many queries are in reused .cfcs) would be less than ideal. As part of new development rollouts, I'd just flush the cache after changing the database. Thanks in advance, Brent ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: good file/folder icons?
I like the Glyfx icons http://www.glyfx.com/ On 9/28/06, Che Vilnonis <[EMAIL PROTECTED]> wrote: > Try... http://www.famfamfam.com/lab/icons/silk/preview.php > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 12:28 PM > To: CF-Talk > Subject: good file/folder icons? > > > Anybody got any good icons (for web, gifs preferable) for files and folders? > > > > > Ray > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: slightly OT? CF based print driver?
Peterson, Chris wrote: > Has anyone ever looked into writing some form of windows print driver > before? > > What I would like is to have a printer installed on the end user's > machine that, when they print, an image is inserted into my database, > with a screen to allow them to index it (maybe have the print driver > make a tiff, and upload the tiff to a web service done in CF to allow > indexing and saving to the DB) I don't have any idea even what language > I would write a simple print driver that could pass an image to a web > service. Any thoughts or directions would be helpful! > > Chris This is similar to an idea I have had where a user could print a document to PDF, and part of the print process would be to put in some meta data about the file, and then it would be directed to some web based storage where it could be easily searched for and distributed. I haven't ever pursued it very far, but I was starting to look at PDFCreator as the basis for the print driver... http://sourceforge.net/projects/pdfcreator/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Handling "Marketing URLs"
This may be somewhat off topic but... I am trying to figure out the best way to handle "marketing URLs", or URLs like: www.domain.com/easytoremember where easytoremember doesen't exist as a directory on the server. Would it be recommended to use a special 404 error handler on the server, URL rewrites or something else? I have tried defining a .cfm file as a 404 error handler in which I tried to parse out the requested URL as entered into the browser using cgi.request_uri (apache), but it only provides me with the path of the error handler itself. I am using CFMX 7/apache/solaris. Thanks, Nate ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help displaying a query result
Doug, Even though someone already posted a solution to your particular problem, I thought I'd share a technique I've used in the past to do arbitrary sorting of query results. This method invloves using ColdFusion's Query of Queries functionality. I will use your query as an example, and for the sake of this example, lets assume you have the category ID of the "Other" category stored in a variable called "otherCatID". In reality, you'ld probablly want to save this as some kind of shared scope "pseudo" constant, but it doesn't really make any difference. Anyways, here's the example code: SELECT categories.cat_id, categories.category, categories.parent_id FROM categories WHERE categories.parent_id = SELECT *, 0 as sortOrder FROMget_child_categories WHERE cat_id <> UNION SELECT *, 1 as sortOrder FROMget_child_categories WHERE cat_id = ORDER BY sortOrder, category Of course, you can do as many unions as you want. The idea is just to break up the original result set into small pieces, where each piece is assigned a "sortOrder", and then just using a union to lump them all back together again. In your case, the example using the CASE statement in the original SQL Order By clause is a simpler solution. However, there are many cases where ordering will greatly slow down the execution time of your query, and in such cases, it may be beneficial to do the ordering using a query of queries. It can also be a good way to re-order the same result set in a modular way where you wouldn't need to have a bunch of different conditional statements lumped in to the original query. Hope this was helpful. - Justin On 9/27/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > I have a list of categories, and I want to sort them ascending, but I need > to have the category (other) always listed last. Anyone have ideas on how to > accomplish this? > > IE: > Baby Backpacks > Baby Carriers and Slings > Baby Jumpers > Play Pens > Vibrating Chairs > Other > > My current query is like so... > > > SELECT > categories.cat_id, > categories.category, > categories.parent_id > FROM > categories > WHERE > categories.parent_id = > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
slightly OT? CF based print driver?
Has anyone ever looked into writing some form of windows print driver before? What I would like is to have a printer installed on the end user's machine that, when they print, an image is inserted into my database, with a screen to allow them to index it (maybe have the print driver make a tiff, and upload the tiff to a web service done in CF to allow indexing and saving to the DB) I don't have any idea even what language I would write a simple print driver that could pass an image to a web service. Any thoughts or directions would be helpful! Chris ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: purchasing CF7 license
All places are not the same price Adobe (and Macromedia before them) has an "interesting" pricing policy, depedant on what part of the world you live in... CFMX 7 Enterprise, bought as a download from the online store: US price: $5,999 (USD) - roughly £3,197 (GBP) UK price: £4,225 (GBP) - roughly $7,928 (USD) So.. the same product - bought in the same online store - costs nearly $2,000 extra, if you are based iin the uk. Note this is for the download product - so there are no additional shipping costs to take into account - and this does not include any addtional VAT etc. I was pleased to see that New Atlanta do not appear to charge any additional "Dirty Foreigner" tax - the price for BlueDragon 6.2 for Microsoft .NET Framework 1-CPU Server appears to be $2,999 wherever you are based... Not impressed On 9/27/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > > Where's the cheapest place to buy a CF7 license? Or, are all places > pretty > much the same price? > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfchart
hi, just wanted to clarify something really. I am using cfcharts but on one of the pages i need the chart to dynamically change as the user changes the data on the form. I know coldfusion is all server side so i am assuming that there is no way of getting the chart to redisplay with the data that the user is entering on the page without reloading the page. If i want this to be done without the page refreshing am i going to have to use a javascript chart in order to achieve this? thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Webservice hell
while following this thread I tested my logger http://localhost:8500/Util_logger.cfc?method=LogTester&location=C:\\helloURL.log&message=heyheyhey so I get back "logged" so that worked, cool So I tried my jws example and .. http://localhost:8500/LogTest.jws?method=LogTester&location=C:\\helloURL.log&message=heyheyhey / by zero so that did not work :( wonk wonk Does anyone have the http invocation syntax for java web service? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Arghhhh!!
parent_id IS NULL Nic Doug Brown wrote: > I get an error > > Query Of Queries syntax error. > Encountered "parent_id = NULL. Incorrect conditional expression, Expected > one of [like|null|between|in|comparison] condition, > > > > - Original Message - > From: "Zaphod Beeblebrox" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Thursday, September 28, 2006 10:23 AM > Subject: Re: Arg!! > > > >> oops, that last line should be >> >> On 9/28/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: >> >>> >>> >>> >>> >>> >>> >>>SELECT catID,category,parent_id >>>FROMcategories >>>WHERE parent_id = >> null="#(parentID eq "")/> >>> >>> >>> >>> >>> >>>#category# >>> >>> - Hide quoted text - >>>>> list_items.recordcount> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: >>> See, there I go again not making my self clear. The table actually has > more > than just makes and models of cars. It has antiques, autos, furniture, blah blah. each parent category has > it's > child category and each child has it's own child. As an example, > Antiques > would have a child of asian antiques and it would have a child of all > the > different asian antiques you could think of. I hope this makes more > sense. > Anyhow the first group of childs I can refer back to their parent, but > the > second group of childs are referenced back to the child of the parent > and > not the parent directly. Doug - Original Message - From: "Jim Wright" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, September 28, 2006 9:43 AM Subject: Re: Arg!! > Doug Brown wrote: > >> Hey Jim...I have one more quick question for you. >> >> As I stated before I have just the one table to display the makes >> > and > models >> for the menu, and I am kinda dumbfounded as to how to display all >> > the > makes >> on one page with their corresponding models beneath them. Can this >> > be > >> accomplished with one table? >> >> IE: >> >> cat_id >> category >> parent_id >> >> Right now the data looks like so >> >> cat_idcategoryparent_id >> 1chevynull >> 2 ford null >> 3Camaro1 >> 4Escort2 >> > Something like... > > SELECT a.category AS make, b.category AS model > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > WHERE a.parent_id IS NULL > ORDER BY a.category,b.category > > > > >> > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dateFormat
I think that was the point he was making - do the formatting server side and just return it nicely to Flash. That's what I've done for Spry - since there wasn't a simple way to format dates in JavaScript, I just used CF to handle it. And no - I don't post here. This is a clone. ;) On 9/28/06, cathy shapiro <[EMAIL PROTECTED]> wrote: > Thanks Matt! > This seems to work on the coldfusion side: > > > > SELECT newsdate FROM news > > > > > > Now if I can only get it to work in flash! > > > >Using DateFormat() in your query as you have it performs the SQL > >dateFormat() function. You'll need to change it with > >#dateFormat(productDetailQuery.newsdate, " dd, ")# after the query > >has run to do it in CF. > > > >Oh, and yes, Ben posts here as well :-) > > > > > >-Original Message- > >From: Cathy Coggin [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, September 27, 2006 11:42 PM > >To: CF-Talk > >Subject: dateFormat > > > >Wow! Ray Camden posts here... next you'll tell me Ben Forta does too. > >I am in the process of reading their excellent book on Coldfusion MX7 and > >was surprised to see his post today. > > > >I have a bit of a problem that is causing major hair loss and was wondering > >if someone might help me with it. > >Please help me save some hair! > > > >I am trying to do a bit of flash remoting using flash 8 and coldfusion mx7. > >Here's the problem. The newsdate record of my database displays in flash as: > >Fri Jan 20 00:00:00 GMT-0600 2006 > >when I want it to display as just plain ole Jan 20, 2006. I was trying to > >accomplish the change with actionscript when someone on the actionscript > >forum at chattyleaf suggested I try to change the format in my cfc. > > > >Here's the cfc: > > >output="true"> > > > > > >SELECT * FROM news WHERE newsID = #newsID# > > > > > > > > > >I tried to change it to > >SELECT DateFormat(newsdate,' dd, '), title, article, newsId FROM > >news but that didn't work > > > >As you can see I haven't read *enough* of their excellent book yet! > >Anyone have any ideas? > >thanks in advance! > >Camden-Forta Fan > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOLVED: DB2 mainframe queries still not working properly! =(
Rick Root wrote:
> I'm just going to vent to the list here for a second.
>
> This is a bug that I'vek now about for a while, and have reported to
> adobe several times, but I haven't bothered to verify its existence in
> Coldfusion 7 since we haven't beeing using hte DB2 JDBC drivers until
> recently.
>
> Consider the following coldfusion code:
>
>
> select TABLKEY AS USERID, TABLFLD AS FULLNAME
> from ADUADS01.TMOTB905
> WHERE TABLKEY='ADSRJR'
>
>
>
>
> The column names returned by this query are "TABLKEY" and "TABLFLD"
i've solved this problem! After 3 years or frustration and avoiding
general use of DB2 via JDBC.
Our mainframe application was a "packaged" application ("ADVANCE" from
BSR). The original table designs included column labels. Like "Foreign
code" when the column name was "FORGNCOD"
3-4 years ago when we first migrated to CFMX and attempted to use the
JDBC drivers, we noticed the issue, and updated all of the column labels
to be equal to the column names. Which solved a large part of the
problem, but never did fix the aliasing problem. The inability to alias
columns was a dealbreaker, and we ended up going with ODBC using
DB2/Connect.
Years have past, and I really want to get rid of DB2/Connect, so I
started investigating the whole issue again.
I tried aliasing a function, because computed columns don't have names
OR labels so I did "select coalesce(ENTITYID,'') AS EID ..." and
that worked. And that became my "workaround solution".. I could use
CHAR() or COALESCE() pretty much anywhere, so I could get around the
issue by using these functions when I needed to alias a column.
But that led me to wonder about the lack of column labels, so I looked
at our database schema, and tried to alias a column in a table that had
no labels.. and it worked!
Turns out, column aliasing works fine - AS LONG AS THE COLUMN DOESN'T
HAVE A LABEL. (sysibm.syscolumns -> label)
So my solution - wipe out the column labels, and POOF! Everything works.
**
It's worth noting that if Adobe didn't use the JDBC
getColumnLabels() instead of getColumnNames() none
of this would be a problem.
**
Rick
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Breeze presentation on Virtualisation to help CF Development - starting in 15 minutes
The Scottish ColdFusion User Group and the UK ColdFusion User Group are holding a joint meeting. The meeting is being held in BSkyB's Offices in London where members of the UKCFUG will be attending and broadcast via breeze (Adobe Connect) for the benefit of everyone else. Presentation With Virtual Machine Software costing so little its time for all development houses large and small to utilise the benefits of virtualisation. The presentation will cover how and why to use virtual machines, for both Client and Server side. From testing your application and websites from a user point of view to Separate Environments for Development, Staging, User Acceptance Testing & Production Date & Time Thursday 28th September at 20:00 BST (19:00 GMT) Breeze Details Breeze Presentation Login : http://adobechats.adobe.acrobat.com/r12588949/ About Kev McCabe Kev McCabe is a Senior Software Engineer at British Sky Broadcasting. He has been working with ColdFusion since 1996 (Version 2) He has been at BSkyB since October 1999 and has worked on a number of high profile projects including: * Sky Sports Football Active * Ryder Cup Interactive * Champions League Interactive * Sky Movies Active * Sky News Active 2005 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Webservice hell
Mark, This is just a shot in the dark, but you have a wildcard application mapping configured for the site containing the webservice? I've run into something similar with Flash Remoting accessing a cfc service. Something to do with the way that IIS implements the local security policy on the LAN vs outside of it. You can check in the IIS snap-in by viewing the site properties>Home Directory>Configuration. If you don't have a wildcard mapping, you can create one to C:\CFusionMX7\runtime\lib\wsconfig\1 \jrun_iis6_wildcard.dll (or wherever CF root is located). HTH -Jon On Sep 28, 2006, at 1:33 PM, Mark Drew wrote: > I get WSDL description > > MD > > On 9/28/06, Snake <[EMAIL PROTECTED]> wrote: >> What happens when u browse the filename.cfc?wsdl in your browser ? >> >> - >> Snake >> >> -Original Message- >> From: Mark Drew [mailto:[EMAIL PROTECTED] >> Sent: 28 September 2006 17:25 >> To: CF-Talk >> Subject: Webservice hell >> >> Halloa >> >> Right, I have got to the end of my teather and google hasnt helped. >> >> I have a webservice, its a simple and happy webservice such as: >> >> >> > returntype="String"> >> >> >> >> >> I run it from my local machine, it is fine, says howdy. I run it >> in my local >> network, its fine, it says howdy! >> >> if I run it outside of my local network on another server, the >> howdy fails >> to materialise. I have been running different tests and using >> www.soapui.com >> I see that when I hit the server with a request for a greeting, I >> get a: >> >> "HTTP/1.1 302 Moved Temporarily[\r][\n]" >> >> and after a few cookies are set I get: >> 17:21:53 : DEBUG : << "Location: >> http://someserver:80/CFIDE/componentutils/ >> cfcexplorer.cfc;jsessionid=ec309c5 >> 47f963d5306f7? >> method=getcfcinhtml&name=cms.components.ws.cmsbrowser&path=/cm >> s/components/ws/CMSBrowser.cfc[\r][\n]" >> >> Which is basically a redirect, err.. no thanks, I dont want to >> redirect to >> the cfcexplorer, and of course the service fails. >> >> Has anyone encountered this? I am sure its something to do with the >> firewall, but WHAT? >> >> Have been packet sniffing all afternoon with no joy. >> >> Obi-One, you are my only hope! (I mean.. cf-talk... you are my >> only hope) >> >> *removes danish's from ears* >> >> >> >> -- >> Mark Drew >> Blog: http://www.markdrew.co.uk/blog/ >> LinkedIn: http://www.linkedin.com/in/mdrew >> >> >> >> > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFMX7 Search Service Won't Start
I posted this a while back, but didn't get any response. Because it's still happening and I still can't figure out the reason, I thought I'd try to post it again. Any suggestions or insight would be greatly appreciated... >Anyone ever seen this message? > >= >The ColdFusion MX 7 Search Server service failed to start due to the >following error: >The pipe state is invalid. >= > >It's just started happening for me and I can't seem to dig up anything >about it. Nor can I recall doing anything CFMX-related to my server >that would give me a good place to start debugging. > >Thanks. The error message appears in my System Event Viewer after a reload and, as indicated, the search service isn't started. Thanks again. -- Rob Wilkerson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dateFormat
Thanks Matt! This seems to work on the coldfusion side: SELECT newsdate FROM news Now if I can only get it to work in flash! >Using DateFormat() in your query as you have it performs the SQL >dateFormat() function. You'll need to change it with >#dateFormat(productDetailQuery.newsdate, " dd, ")# after the query >has run to do it in CF. > >Oh, and yes, Ben posts here as well :-) > > >-Original Message- >From: Cathy Coggin [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 27, 2006 11:42 PM >To: CF-Talk >Subject: dateFormat > >Wow! Ray Camden posts here... next you'll tell me Ben Forta does too. >I am in the process of reading their excellent book on Coldfusion MX7 and >was surprised to see his post today. > >I have a bit of a problem that is causing major hair loss and was wondering >if someone might help me with it. >Please help me save some hair! > >I am trying to do a bit of flash remoting using flash 8 and coldfusion mx7. >Here's the problem. The newsdate record of my database displays in flash as: >Fri Jan 20 00:00:00 GMT-0600 2006 >when I want it to display as just plain ole Jan 20, 2006. I was trying to >accomplish the change with actionscript when someone on the actionscript >forum at chattyleaf suggested I try to change the format in my cfc. > >Here's the cfc: >output="true"> > > >SELECT * FROM news WHERE newsID = #newsID# > > > > >I tried to change it to >SELECT DateFormat(newsdate,' dd, '), title, article, newsId FROM >news but that didn't work > >As you can see I haven't read *enough* of their excellent book yet! >Anyone have any ideas? >thanks in advance! >Camden-Forta Fan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inner Join Across Two Data Sources?
Tim Claremont wrote: > I see where I can create the linked server, but the foxpro database and the > SQL database are on the same server. When I enter the name of the server, it > says I cannot create the local server as a linked server. > > To clarify, the FoxPro database is in a directory on the same server as the > SQL Server installation. > You will need to choose the ODBC driver in the Provider box, then provide the necessary info to connect to a Foxpro ODBC dsn. But I'm guessing that this method won't have any real advantage over using QoQ (and possibly some serious disadvantages in terms of performance). ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Inner Join Across Two Data Sources?
Maybe try by IP? The linked server thing is neat, I'm going to have to look into it some more. > -Original Message- > From: Tim Claremont [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 1:40 PM > To: CF-Talk > Subject: Re: Inner Join Across Two Data Sources? > > I see where I can create the linked server, but the foxpro database and > the SQL database are on the same server. When I enter the name of the > server, it says I cannot create the local server as a linked server. > > To clarify, the FoxPro database is in a directory on the same server as > the SQL Server installation. > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: JDBC connection pooling
If each of those instances is in its own JVM, then yes, they would be 5 separate connections being used concurrently. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:31 AM To: CF-Talk Subject: JDBC connection pooling coldfusion does jdbc connection pooling, right? so if I have 100 people browsing my web site, coldfusion will send queries over the DSN's existing connection right? And if "Maintain DB connection" is checked, that connection will always be there once it's been accessed at least once.. Now, if I have 5 instances of coldfusion, each of them with a DSN to the same database, then I would (potentially) have 5 concurrent connections... is that right? The reason I'm asking is because of the licensing model for Starquest's StarSQL for Java DB2 driver... it's licensed on a "per concurrent connection" basis Just trying to figure out how many concurrent connections I might have... Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inner Join Across Two Data Sources?
I see where I can create the linked server, but the foxpro database and the SQL database are on the same server. When I enter the name of the server, it says I cannot create the local server as a linked server. To clarify, the FoxPro database is in a directory on the same server as the SQL Server installation. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Poor mans Logger
Can you guys please place your discussion under a separate thread?
For Example:
OT: Secure Hosting worries or CF worries in general
My post was about logging custom error messages and using inner classes
and web services with AJAX and writing those results to the local file
system.
I posted 1.cfm 2. jws and now a cfc.
http://www.cfide.org/Util_logger.txt download it add to it use it! change
the txt to cfc
The call:
http://localhost:8500/Util_logger.cfc?wsdl";).LogTester("C:\\helloCFC.log","HELLO
CFC")>
#logged#
http://www.cfide.org/helloCFC.log view the ouput its not very good because
you have to make a seperate
custom class (inner) to make it look good.
Even better is to connect it with my text to speech CFC which then uses
flash at runtime to play the audio
file.
So when something goes wrong you can play an audio file and hear the error
message over the load speaker.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254677
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Inner Join Across Two Data Sources?
You can create Linked servers in ms sql. I'm not sure if you could do that to a fox pro database. The caveat is linked severs suck performance wise. You could use query of queries in cold fusion to accomplish your task, however be careful that the original two query record sets are not so large that they crash cf. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:52 AM To: CF-Talk Subject: Re: Inner Join Across Two Data Sources? How do you setup the link between MS SQL and FoxPro? Seems like that is the only way that could be done in a single query. On 9/28/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Should be able to. Reference the fields like so: > > SELECT dt.fieldname > FROM database1.table1 d1t1 > INNER JOIN database2.table1 d2t1 > ON d2t1.id = d2t1.id > > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Tim Claremont [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 11:15 AM > To: CF-Talk > Subject: Inner Join Across Two Data Sources? > > > I have two databases. One is in SQL Server, and the other is in FoxPro. > > Can I perform a single CFQUERY that includes one table in each data source > and joins the two based on say... ClientNum? > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL/FORM var Obfuscation techniques
That is exactly what I do as well. Btw, I have also used hash() for passing passwords and other validators. Of course, I always wonder if what I do is the most effective way, or is it even the only way. Thank you, Teddy. > -Original Message- > From: Teddy Payne [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 10:05 AM > To: CF-Talk > Subject: Re: URL/FORM var Obfuscation techniques > > Yeah, for PK identifiers encrypt() works pretty well. I have not really > seen other ways to hide these as you pass them between files. > > URLEncodedFormat(Encrypt(string,key)) to > Decrypt(URLDecode(url.variable),key) > is pretty common when attemtping to hide them. > > If there are other ways, I would be curious to try soemthing new. > > Teddy > > On 9/28/06, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > > > To be quite honest, its nothing really too sensitive like index ID keys > > (ie: > > product ids, employee ids, order numbers, etc). Even so, there are > > already > > layers of access security built in that validates the user to the data. > > For > > more sensitive data, I use session vars. > > What I was thinking is that to discourage potential hacks to even > consider > > looking into the URL or hidden fields on the page source to figuring > > anything out. > > 'Hope that makes sense. Thanks Teddy. > > > > > > > > > > > > > > > -Original Message- > > > From: Teddy Payne [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, September 28, 2006 5:41 AM > > > To: CF-Talk > > > Subject: Re: URL/FORM var Obfuscation techniques > > > > > > The question here is what are you trying to hide in the URL or a > hidden > > > form > > > field? > > > > > > Teddy > > > > > > On 9/27/06, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > > > > > > > Besides encrypt/decrypt and URLencodedformat/URLdecode, are there > are > > > > other > > > > techniques out there to obfuscate URL variables. I just wanted to > > know > > > if > > > > there are other ways to make it even more difficult for hacks to > > figure > > > > out > > > > passed URL or even hidden FORM vars. Thanks in advance. > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web service hell
Yep yep I have a file (on the server) that consumes that webservice, and it prints out all fine, if I have a similar file on my machine, the webservice errors. I think its either a CF or firewall issue, but I need more details to try and fix it. MD It could also be an IIS security issue. If you have integrated windows security (maybe even any IIS security, but I've only dealt with integrated windows) on at any level that covers the web service CFC file, a cfc accessed remotely as a web service can not properly handle the integrated windows protocol exchange while cfc files accessed locally can. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Webservice hell
I get WSDL description MD On 9/28/06, Snake <[EMAIL PROTECTED]> wrote: > What happens when u browse the filename.cfc?wsdl in your browser ? > > - > Snake > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 28 September 2006 17:25 > To: CF-Talk > Subject: Webservice hell > > Halloa > > Right, I have got to the end of my teather and google hasnt helped. > > I have a webservice, its a simple and happy webservice such as: > > > returntype="String"> > > > > > I run it from my local machine, it is fine, says howdy. I run it in my local > network, its fine, it says howdy! > > if I run it outside of my local network on another server, the howdy fails > to materialise. I have been running different tests and using www.soapui.com > I see that when I hit the server with a request for a greeting, I get a: > > "HTTP/1.1 302 Moved Temporarily[\r][\n]" > > and after a few cookies are set I get: > 17:21:53 : DEBUG : << "Location: > http://someserver:80/CFIDE/componentutils/cfcexplorer.cfc;jsessionid=ec309c5 > 47f963d5306f7?method=getcfcinhtml&name=cms.components.ws.cmsbrowser&path=/cm > s/components/ws/CMSBrowser.cfc[\r][\n]" > > Which is basically a redirect, err.. no thanks, I dont want to redirect to > the cfcexplorer, and of course the service fails. > > Has anyone encountered this? I am sure its something to do with the > firewall, but WHAT? > > Have been packet sniffing all afternoon with no joy. > > Obi-One, you are my only hope! (I mean.. cf-talk... you are my only hope) > > *removes danish's from ears* > > > > -- > Mark Drew > Blog: http://www.markdrew.co.uk/blog/ > LinkedIn: http://www.linkedin.com/in/mdrew > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254674 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: select * (star) caching
Ask for them all by name. That is not a good reason. It does not let anyone else reading your code know what you are doing. I am not sure if this is a coldfusion problem or the fact that if you use the db driver uses sp_prepexec on SQL servers which caches an execution plan for the query, and uses bind variables. This may cause SQL server to return the exact same results for the query even if the table structure changes. Again the right way to deal with this is to not use SELECT * ever. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 2:20 PM To: CF-Talk Subject: RE: select * (star) caching How about if you need all the columns? -Original Message- From: Porter, Benjamin L. [mailto:[EMAIL PROTECTED] Sent: 27 September 2006 19:19 To: CF-Talk Subject: RE: select * (star) caching This is a known issue. For best practices you should never use select *. There is no good business or coding reason to do so, it should be transparent what data you are asking for. I'm not sure if flushing the template cache will correct this. It is simple enough to test in a dev environment. -Original Message- From: Brent Shaub [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 12:57 PM To: CF-Talk Subject: select * (star) caching Is this new to CF 7? I've got a handful of "select *" queries that when I modify the underlying table, the results do not include the new column(s). If this is a known issue, how can I refresh the cache for CF to pull the new fields? Since I inherited the app, listing all the columns and ideally reviewing which columns are needed (which is further time-consuming since many queries are in reused .cfcs) would be less than ideal. As part of new development rollouts, I'd just flush the cache after changing the database. Thanks in advance, Brent ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Webservice hell
I do indeed I can call methods from the URL on that webservice but I dont recieve anything else. I am just confused as to why and what is being stripped out before it hits the webserver to make it think that the soap call is invalid There is something going on down the wire... MD On 9/28/06, Brad Wood <[EMAIL PROTECTED]> wrote: > What if you access it with ?wsdl at the end? Do you get an XML doc back > in the browser? > > > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 11:25 AM > To: CF-Talk > Subject: Webservice hell > > Halloa > > Right, I have got to the end of my teather and google hasnt helped. > > I have a webservice, its a simple and happy webservice such as: > > > returntype="String"> > > > > > I run it from my local machine, it is fine, says howdy. I run it in my > local network, its fine, it says howdy! > > if I run it outside of my local network on another server, the howdy > fails to materialise. I have been running different tests and using > www.soapui.com I see that when I hit the server with a request for a > greeting, I get a: > > "HTTP/1.1 302 Moved Temporarily[\r][\n]" > > and after a few cookies are set I get: > 17:21:53 : DEBUG : << "Location: > http://someserver:80/CFIDE/componentutils/cfcexplorer.cfc;jsessionid=ec3 > 09c547f963d5306f7?method=getcfcinhtml&name=cms.components.ws.cmsbrowser& > path=/cms/components/ws/CMSBrowser.cfc[\r][\n]" > > Which is basically a redirect, err.. no thanks, I dont want to > redirect to the cfcexplorer, and of course the service fails. > > Has anyone encountered this? I am sure its something to do with the > firewall, but WHAT? > > Have been packet sniffing all afternoon with no joy. > > Obi-One, you are my only hope! (I mean.. cf-talk... you are my only > hope) > > *removes danish's from ears* > > > > -- > Mark Drew > Blog: http://www.markdrew.co.uk/blog/ > LinkedIn: http://www.linkedin.com/in/mdrew > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Webservice hell
Strange thing is that it works if I call it from a script on the server, if I create a similar script on my local machine pointing to the webserver, it fails e..g http://somewebserver/test.cfc?wsdl";)> the SAME file runs on the server, but from my local version of coldfusion (calling the webservice on the server) it fails MD On 9/28/06, Tom Kitta <[EMAIL PROTECTED]> wrote: > You can try to modify the WSDL auto generated code and use fileName.wsdl as > the hook for your WS -> sometimes the auto generated WSDL is not 100% right > as far as path to data is concerned. > > TK > http://www.tomkitta.com > > -Original Message- > From: Snake [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 12:41 PM > To: CF-Talk > Subject: RE: Webservice hell > > > What happens when u browse the filename.cfc?wsdl in your browser ? > > - > Snake > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 28 September 2006 17:25 > To: CF-Talk > Subject: Webservice hell > > Halloa > > Right, I have got to the end of my teather and google hasnt helped. > > I have a webservice, its a simple and happy webservice such as: > > > returntype="String"> > > > > > I run it from my local machine, it is fine, says howdy. I run it in my local > network, its fine, it says howdy! > > if I run it outside of my local network on another server, the howdy fails > to materialise. I have been running different tests and using www.soapui.com > I see that when I hit the server with a request for a greeting, I get a: > > "HTTP/1.1 302 Moved Temporarily[\r][\n]" > > and after a few cookies are set I get: > 17:21:53 : DEBUG : << "Location: > http://someserver:80/CFIDE/componentutils/cfcexplorer.cfc;jsessionid=ec309c5 > 47f963d5306f7?method=getcfcinhtml&name=cms.components.ws.cmsbrowser&path=/cm > s/components/ws/CMSBrowser.cfc[\r][\n]" > > Which is basically a redirect, err.. no thanks, I dont want to redirect to > the cfcexplorer, and of course the service fails. > > Has anyone encountered this? I am sure its something to do with the > firewall, but WHAT? > > Have been packet sniffing all afternoon with no joy. > > Obi-One, you are my only hope! (I mean.. cf-talk... you are my only hope) > > *removes danish's from ears* > > > > -- > Mark Drew > Blog: http://www.markdrew.co.uk/blog/ > LinkedIn: http://www.linkedin.com/in/mdrew > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Arghhhh!!
Yeah, that query needs to be done something like this: SELECT catID,category,parent_id FROMcategories WHERE parent_id is null parent_id="#parentid#" again, this has not been tested On 9/28/06, Ian Skinner <[EMAIL PROTECTED]> wrote: > parent_id = NULL > > I am not sure about QofQ's but in other DBMS I work with you are not allowed > to use the equal [=] with a NULL. I would write that as parent_id IS NULL in > my oracle queries. > > Again I'm not sure if this applies to a CF QofQ. > > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > - > | 1 | | > - Binary Soduko > | | | > - > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL/FORM var Obfuscation techniques
Yeah, for PK identifiers encrypt() works pretty well. I have not really seen other ways to hide these as you pass them between files. URLEncodedFormat(Encrypt(string,key)) to Decrypt(URLDecode(url.variable),key) is pretty common when attemtping to hide them. If there are other ways, I would be curious to try soemthing new. Teddy On 9/28/06, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > To be quite honest, its nothing really too sensitive like index ID keys > (ie: > product ids, employee ids, order numbers, etc). Even so, there are > already > layers of access security built in that validates the user to the data. > For > more sensitive data, I use session vars. > What I was thinking is that to discourage potential hacks to even consider > looking into the URL or hidden fields on the page source to figuring > anything out. > 'Hope that makes sense. Thanks Teddy. > > > > > > > > -Original Message- > > From: Teddy Payne [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 28, 2006 5:41 AM > > To: CF-Talk > > Subject: Re: URL/FORM var Obfuscation techniques > > > > The question here is what are you trying to hide in the URL or a hidden > > form > > field? > > > > Teddy > > > > On 9/27/06, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > > > > > Besides encrypt/decrypt and URLencodedformat/URLdecode, are there are > > > other > > > techniques out there to obfuscate URL variables. I just wanted to > know > > if > > > there are other ways to make it even more difficult for hacks to > figure > > > out > > > passed URL or even hidden FORM vars. Thanks in advance. > > > > > > > > > > > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Webservice hell
You can try to modify the WSDL auto generated code and use fileName.wsdl as the hook for your WS -> sometimes the auto generated WSDL is not 100% right as far as path to data is concerned. TK http://www.tomkitta.com -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 12:41 PM To: CF-Talk Subject: RE: Webservice hell What happens when u browse the filename.cfc?wsdl in your browser ? - Snake -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 28 September 2006 17:25 To: CF-Talk Subject: Webservice hell Halloa Right, I have got to the end of my teather and google hasnt helped. I have a webservice, its a simple and happy webservice such as: I run it from my local machine, it is fine, says howdy. I run it in my local network, its fine, it says howdy! if I run it outside of my local network on another server, the howdy fails to materialise. I have been running different tests and using www.soapui.com I see that when I hit the server with a request for a greeting, I get a: "HTTP/1.1 302 Moved Temporarily[\r][\n]" and after a few cookies are set I get: 17:21:53 : DEBUG : << "Location: http://someserver:80/CFIDE/componentutils/cfcexplorer.cfc;jsessionid=ec309c5 47f963d5306f7?method=getcfcinhtml&name=cms.components.ws.cmsbrowser&path=/cm s/components/ws/CMSBrowser.cfc[\r][\n]" Which is basically a redirect, err.. no thanks, I dont want to redirect to the cfcexplorer, and of course the service fails. Has anyone encountered this? I am sure its something to do with the firewall, but WHAT? Have been packet sniffing all afternoon with no joy. Obi-One, you are my only hope! (I mean.. cf-talk... you are my only hope) *removes danish's from ears* -- Mark Drew Blog: http://www.markdrew.co.uk/blog/ LinkedIn: http://www.linkedin.com/in/mdrew ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Arghhhh!!
parent_id = NULL I am not sure about QofQ's but in other DBMS I work with you are not allowed to use the equal [=] with a NULL. I would write that as parent_id IS NULL in my oracle queries. Again I'm not sure if this applies to a CF QofQ. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inner Join Across Two Data Sources?
> Yup. I am aware of that. I was hoping to get away with one > query, but apparently I am doing it as efficiently as > possible already. In enterprise manager go into "security > Linked Servers". I have never tried with fox pro but I have my MySQL server and MSSQL servers working together nicely. -- Jay ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web service hell
Yep yep I have a file (on the server) that consumes that webservice, and it prints out all fine, if I have a similar file on my machine, the webservice errors. I think its either a CF or firewall issue, but I need more details to try and fix it. MD On 9/28/06, Ian Skinner <[EMAIL PROTECTED]> wrote: > You get redirected to the cfc explorer when you call the cfc directly in the > url without a method. That is what CF thinks you want. Try adding a method > to the url, or consume the web service in another CF file that access the > method. > > To call in the url, something like this is what you want. > http://url.to.my/webservice.cfc?method=sayHello > > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > - > | 1 | | > - Binary Soduko > | | | > - > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL/FORM var Obfuscation techniques
https. Since your end-user is going to be submitting forms/going to the site, there's really no point in hiding form/url variable names from them. This will hide it from anyone else. - Carl L ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254666 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Arghhhh!!
okayI had adapted some code from another project that used a parent_id of 0 instead of nulls. If you could change yours form nulls to zeros, then change the last line to , that would work. Unfortunately, I'm writing this blindly since I don't have the datasource :) On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: > I get an error > > Query Of Queries syntax error. > Encountered "parent_id = NULL. Incorrect conditional expression, Expected > one of [like|null|between|in|comparison] condition, > > > > - Original Message - > From: "Zaphod Beeblebrox" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Thursday, September 28, 2006 10:23 AM > Subject: Re: Arg!! > > > > oops, that last line should be > > > > On 9/28/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > > > >SELECT catID,category,parent_id > > >FROMcategories > > >WHERE parent_id = > > null="#(parentID eq "")/> > > > > > > > > > > > > > > > > > >#category# > > > > > > - Hide quoted text - > > > > > list_items.recordcount> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > > > See, there I go again not making my self clear. The table actually has > more > > > > than just makes and models of cars. > > > > It has antiques, autos, furniture, blah blah. each parent category has > it's > > > > child category and each child has it's own child. As an example, > Antiques > > > > would have a child of asian antiques and it would have a child of all > the > > > > different asian antiques you could think of. I hope this makes more > sense. > > > > Anyhow the first group of childs I can refer back to their parent, but > the > > > > second group of childs are referenced back to the child of the parent > and > > > > not the parent directly. > > > > > > > > > > > > > > > > > > > > Doug > > > > > > > > > > > > > > > > - Original Message - > > > > From: "Jim Wright" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" > > > > Sent: Thursday, September 28, 2006 9:43 AM > > > > Subject: Re: Arg!! > > > > > > > > > > > > > Doug Brown wrote: > > > > > > Hey Jim...I have one more quick question for you. > > > > > > > > > > > > As I stated before I have just the one table to display the makes > and > > > > models > > > > > > for the menu, and I am kinda dumbfounded as to how to display all > the > > > > makes > > > > > > on one page with their corresponding models beneath them. Can this > be > > > > > > accomplished with one table? > > > > > > > > > > > > IE: > > > > > > > > > > > > cat_id > > > > > > category > > > > > > parent_id > > > > > > > > > > > > Right now the data looks like so > > > > > > > > > > > > cat_idcategoryparent_id > > > > > > 1chevynull > > > > > > 2 ford null > > > > > > 3Camaro1 > > > > > > 4Escort2 > > > > > > > > > > Something like... > > > > > > > > > > SELECT a.category AS make, b.category AS model > > > > > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > > > > > WHERE a.parent_id IS NULL > > > > > ORDER BY a.category,b.category > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: good file/folder icons?
Thanks guys. > -Original Message- > From: Jim Wright [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 12:39 PM > To: CF-Talk > Subject: Re: good file/folder icons? > Importance: High > > Ray Champagne wrote: > > Anybody got any good icons (for web, gifs preferable) for files and folders? > > > > http://www.famfamfam.com/lab/icons/ > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Debugging JavaScript
>>i basically develop in firefox first, using firebug and the console.log() stuff, and then integrate with ie afterwards. This is indeed one way to do things. Personally I do the opposite, because I'm using an IE emulator in Mozilla. Most of the functionalities available in IE are then compatible with Mozilla, which makes development even easier. Unfortunately, functions to define a "Mozilla emulator" in IE do not exist. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URL/FORM var Obfuscation techniques
To be quite honest, its nothing really too sensitive like index ID keys (ie: product ids, employee ids, order numbers, etc). Even so, there are already layers of access security built in that validates the user to the data. For more sensitive data, I use session vars. What I was thinking is that to discourage potential hacks to even consider looking into the URL or hidden fields on the page source to figuring anything out. 'Hope that makes sense. Thanks Teddy. > -Original Message- > From: Teddy Payne [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 5:41 AM > To: CF-Talk > Subject: Re: URL/FORM var Obfuscation techniques > > The question here is what are you trying to hide in the URL or a hidden > form > field? > > Teddy > > On 9/27/06, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > > > Besides encrypt/decrypt and URLencodedformat/URLdecode, are there are > > other > > techniques out there to obfuscate URL variables. I just wanted to know > if > > there are other ways to make it even more difficult for hacks to figure > > out > > passed URL or even hidden FORM vars. Thanks in advance. > > > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inner Join Across Two Data Sources?
Yup. I am aware of that. I was hoping to get away with one query, but apparently I am doing it as efficiently as possible already. Thanks Tim >No, but you could do three queries and end up with the same result using >query of queries. > >> ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Webservice hell
What happens when u browse the filename.cfc?wsdl in your browser ? - Snake -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 28 September 2006 17:25 To: CF-Talk Subject: Webservice hell Halloa Right, I have got to the end of my teather and google hasnt helped. I have a webservice, its a simple and happy webservice such as: I run it from my local machine, it is fine, says howdy. I run it in my local network, its fine, it says howdy! if I run it outside of my local network on another server, the howdy fails to materialise. I have been running different tests and using www.soapui.com I see that when I hit the server with a request for a greeting, I get a: "HTTP/1.1 302 Moved Temporarily[\r][\n]" and after a few cookies are set I get: 17:21:53 : DEBUG : << "Location: http://someserver:80/CFIDE/componentutils/cfcexplorer.cfc;jsessionid=ec309c5 47f963d5306f7?method=getcfcinhtml&name=cms.components.ws.cmsbrowser&path=/cm s/components/ws/CMSBrowser.cfc[\r][\n]" Which is basically a redirect, err.. no thanks, I dont want to redirect to the cfcexplorer, and of course the service fails. Has anyone encountered this? I am sure its something to do with the firewall, but WHAT? Have been packet sniffing all afternoon with no joy. Obi-One, you are my only hope! (I mean.. cf-talk... you are my only hope) *removes danish's from ears* -- Mark Drew Blog: http://www.markdrew.co.uk/blog/ LinkedIn: http://www.linkedin.com/in/mdrew ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inner Join Across Two Data Sources?
How do you setup the link between MS SQL and FoxPro? Seems like that is the only way that could be done in a single query. On 9/28/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Should be able to. Reference the fields like so: > > SELECT dt.fieldname > FROM database1.table1 d1t1 > INNER JOIN database2.table1 d2t1 > ON d2t1.id = d2t1.id > > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Tim Claremont [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 11:15 AM > To: CF-Talk > Subject: Inner Join Across Two Data Sources? > > > I have two databases. One is in SQL Server, and the other is in FoxPro. > > Can I perform a single CFQUERY that includes one table in each data source > and joins the two based on say... ClientNum? > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Arghhhh!!
I get an error Query Of Queries syntax error. Encountered "parent_id = NULL. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, - Original Message - From: "Zaphod Beeblebrox" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, September 28, 2006 10:23 AM Subject: Re: Arg!! > oops, that last line should be > > On 9/28/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > >SELECT catID,category,parent_id > >FROMcategories > >WHERE parent_id = > null="#(parentID eq "")/> > > > > > > > > > > > >#category# > > > > - Hide quoted text - > > > list_items.recordcount> > > > > > > > > > > > > > > > > > > > > On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > > See, there I go again not making my self clear. The table actually has more > > > than just makes and models of cars. > > > It has antiques, autos, furniture, blah blah. each parent category has it's > > > child category and each child has it's own child. As an example, Antiques > > > would have a child of asian antiques and it would have a child of all the > > > different asian antiques you could think of. I hope this makes more sense. > > > Anyhow the first group of childs I can refer back to their parent, but the > > > second group of childs are referenced back to the child of the parent and > > > not the parent directly. > > > > > > > > > > > > > > > Doug > > > > > > > > > > > > - Original Message - > > > From: "Jim Wright" <[EMAIL PROTECTED]> > > > To: "CF-Talk" > > > Sent: Thursday, September 28, 2006 9:43 AM > > > Subject: Re: Arg!! > > > > > > > > > > Doug Brown wrote: > > > > > Hey Jim...I have one more quick question for you. > > > > > > > > > > As I stated before I have just the one table to display the makes and > > > models > > > > > for the menu, and I am kinda dumbfounded as to how to display all the > > > makes > > > > > on one page with their corresponding models beneath them. Can this be > > > > > accomplished with one table? > > > > > > > > > > IE: > > > > > > > > > > cat_id > > > > > category > > > > > parent_id > > > > > > > > > > Right now the data looks like so > > > > > > > > > > cat_idcategoryparent_id > > > > > 1chevynull > > > > > 2 ford null > > > > > 3Camaro1 > > > > > 4Escort2 > > > > > > > > Something like... > > > > > > > > SELECT a.category AS make, b.category AS model > > > > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > > > > WHERE a.parent_id IS NULL > > > > ORDER BY a.category,b.category > > > > > > > > > > > > > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web service hell
You get redirected to the cfc explorer when you call the cfc directly in the url without a method. That is what CF thinks you want. Try adding a method to the url, or consume the web service in another CF file that access the method. To call in the url, something like this is what you want. http://url.to.my/webservice.cfc?method=sayHello -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254652 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: good file/folder icons?
I have sent u some off list Snake -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 28 September 2006 17:28 To: CF-Talk Subject: good file/folder icons? Anybody got any good icons (for web, gifs preferable) for files and folders? Ray ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: good file/folder icons?
Ray Champagne wrote: > Anybody got any good icons (for web, gifs preferable) for files and folders? > http://www.famfamfam.com/lab/icons/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inner Join Across Two Data Sources?
Should be able to. Reference the fields like so: SELECT dt.fieldname FROM database1.table1 d1t1 INNER JOIN database2.table1 d2t1 ON d2t1.id = d2t1.id -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:15 AM To: CF-Talk Subject: Inner Join Across Two Data Sources? I have two databases. One is in SQL Server, and the other is in FoxPro. Can I perform a single CFQUERY that includes one table in each data source and joins the two based on say... ClientNum? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Arghhhh!!
Doug Brown wrote: > See, there I go again not making my self clear. The table actually has more > than just makes and models of cars. > It has antiques, autos, furniture, blah blah. each parent category has it's > child category and each child has it's own child. As an example, Antiques > would have a child of asian antiques and it would have a child of all the > different asian antiques you could think of. I hope this makes more sense. > Anyhow the first group of childs I can refer back to their parent, but the > second group of childs are referenced back to the child of the parent and > not the parent directly. > > Well, if it is just three levels, then you could possibly just add in another join... SELECT a.category AS level1, b.category AS level2, c.category AS level3 FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id AND a.parent_id IS NULL LEFT JOIN categories c ON b.cat_id = c.parent_id AND b.parent_id IS NOT NULL ORDER BY a.category,b.category,c.category If you are dealing with a indeterminate number of levels and still want it returned in a single dataset, then you probably want to go to a SP...I'd google on something like "SQL parent child recursion" to get some ideas. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inner Join Across Two Data Sources?
No, but you could do three queries and end up with the same result using query of queries. > -Original Message- > From: Tim Claremont [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 12:15 PM > To: CF-Talk > Subject: Inner Join Across Two Data Sources? > > I have two databases. One is in SQL Server, and the other is in FoxPro. > > Can I perform a single CFQUERY that includes one table in each data source > and joins the two based on say... ClientNum? > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Webservice hell
What if you access it with ?wsdl at the end? Do you get an XML doc back in the browser? -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:25 AM To: CF-Talk Subject: Webservice hell Halloa Right, I have got to the end of my teather and google hasnt helped. I have a webservice, its a simple and happy webservice such as: I run it from my local machine, it is fine, says howdy. I run it in my local network, its fine, it says howdy! if I run it outside of my local network on another server, the howdy fails to materialise. I have been running different tests and using www.soapui.com I see that when I hit the server with a request for a greeting, I get a: "HTTP/1.1 302 Moved Temporarily[\r][\n]" and after a few cookies are set I get: 17:21:53 : DEBUG : << "Location: http://someserver:80/CFIDE/componentutils/cfcexplorer.cfc;jsessionid=ec3 09c547f963d5306f7?method=getcfcinhtml&name=cms.components.ws.cmsbrowser& path=/cms/components/ws/CMSBrowser.cfc[\r][\n]" Which is basically a redirect, err.. no thanks, I dont want to redirect to the cfcexplorer, and of course the service fails. Has anyone encountered this? I am sure its something to do with the firewall, but WHAT? Have been packet sniffing all afternoon with no joy. Obi-One, you are my only hope! (I mean.. cf-talk... you are my only hope) *removes danish's from ears* -- Mark Drew Blog: http://www.markdrew.co.uk/blog/ LinkedIn: http://www.linkedin.com/in/mdrew ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254651 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: good file/folder icons?
Try... http://www.famfamfam.com/lab/icons/silk/preview.php -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 12:28 PM To: CF-Talk Subject: good file/folder icons? Anybody got any good icons (for web, gifs preferable) for files and folders? Ray ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: access photoshop metadata via CF - XMP
For general EXIF metadata, Drew Noakes' Java library is the best I've seen at delivering consistent data from all makes/mfrs of cameras (http://www.drewnoakes.com/code/exif/). You will need access to the server to install the library, though. I haven't really tested it with Photoshop XMP metadata so I couldn't tell you what information it sends back. Also, you might be able to roll your own function library using Adobe's SDK: http://partners.adobe.com/public/developer/xmp/sdk/ index.html HTH Jon On Sep 28, 2006, at 12:14 PM, Nick Tong - TalkWebSolutions.co.uk wrote: > Does anyone know how one can access meatdata from photos. In > photoshop you > can access it via XMP (browse - right click - file info). I have a > photographer who wishes to put his photos online and has entered a > lot of > data this way (location, keywords etc). It would be great to > extract that > data and populate the database/form when he uploads a photo. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
good file/folder icons?
Anybody got any good icons (for web, gifs preferable) for files and folders? Ray ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Webservice hell
Halloa Right, I have got to the end of my teather and google hasnt helped. I have a webservice, its a simple and happy webservice such as: I run it from my local machine, it is fine, says howdy. I run it in my local network, its fine, it says howdy! if I run it outside of my local network on another server, the howdy fails to materialise. I have been running different tests and using www.soapui.com I see that when I hit the server with a request for a greeting, I get a: "HTTP/1.1 302 Moved Temporarily[\r][\n]" and after a few cookies are set I get: 17:21:53 : DEBUG : << "Location: http://someserver:80/CFIDE/componentutils/cfcexplorer.cfc;jsessionid=ec309c547f963d5306f7?method=getcfcinhtml&name=cms.components.ws.cmsbrowser&path=/cms/components/ws/CMSBrowser.cfc[\r][\n]"; Which is basically a redirect, err.. no thanks, I dont want to redirect to the cfcexplorer, and of course the service fails. Has anyone encountered this? I am sure its something to do with the firewall, but WHAT? Have been packet sniffing all afternoon with no joy. Obi-One, you are my only hope! (I mean.. cf-talk... you are my only hope) *removes danish's from ears* -- Mark Drew Blog: http://www.markdrew.co.uk/blog/ LinkedIn: http://www.linkedin.com/in/mdrew ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: access photoshop metadata via CF - XMP
There are a couple of cfx's google will throw at you but if you have the choice http://pel.sourceforge.net/ for php is MUCH better than the cf options. -- Jay > -Original Message- > From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] > Sent: 28 September 2006 17:15 > To: CF-Talk > Subject: access photoshop metadata via CF - XMP > > Hi List, > > Does anyone know how one can access meatdata from photos. In > photoshop you can access it via XMP (browse - right click - > file info). I have a photographer who wishes to put his > photos online and has entered a lot of data this way > (location, keywords etc). It would be great to extract that > data and populate the database/form when he uploads a photo. > > Many thanks in advance > > -- > Nick Tong > > web: http://talkwebsolutions.co.uk > blog: http://succor.co.uk > short urls: http://wapurl.co.uk > green link: http://wapurl.co.uk/?4Z2YDLX > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inner Join Across Two Data Sources?
I have two databases. One is in SQL Server, and the other is in FoxPro. Can I perform a single CFQUERY that includes one table in each data source and joins the two based on say... ClientNum? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Arghhhh!!
oops, that last line should be On 9/28/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > > > > > >SELECT catID,category,parent_id >FROMcategories >WHERE parent_id = null="#(parentID eq "")/> > > > > > >#category# > > - Hide quoted text - > list_items.recordcount> > > > > > > > > > > On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > See, there I go again not making my self clear. The table actually has more > > than just makes and models of cars. > > It has antiques, autos, furniture, blah blah. each parent category has it's > > child category and each child has it's own child. As an example, Antiques > > would have a child of asian antiques and it would have a child of all the > > different asian antiques you could think of. I hope this makes more sense. > > Anyhow the first group of childs I can refer back to their parent, but the > > second group of childs are referenced back to the child of the parent and > > not the parent directly. > > > > > > > > > > Doug > > > > > > > > - Original Message - > > From: "Jim Wright" <[EMAIL PROTECTED]> > > To: "CF-Talk" > > Sent: Thursday, September 28, 2006 9:43 AM > > Subject: Re: Arg!! > > > > > > > Doug Brown wrote: > > > > Hey Jim...I have one more quick question for you. > > > > > > > > As I stated before I have just the one table to display the makes and > > models > > > > for the menu, and I am kinda dumbfounded as to how to display all the > > makes > > > > on one page with their corresponding models beneath them. Can this be > > > > accomplished with one table? > > > > > > > > IE: > > > > > > > > cat_id > > > > category > > > > parent_id > > > > > > > > Right now the data looks like so > > > > > > > > cat_idcategoryparent_id > > > > 1chevynull > > > > 2 ford null > > > > 3Camaro1 > > > > 4Escort2 > > > > > > Something like... > > > > > > SELECT a.category AS make, b.category AS model > > > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > > > WHERE a.parent_id IS NULL > > > ORDER BY a.category,b.category > > > > > > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Arghhhh!!
SELECT catID,category,parent_id FROMcategories WHERE parent_id = #category# - Hide quoted text - On 9/28/06, Doug Brown <[EMAIL PROTECTED]> wrote: > See, there I go again not making my self clear. The table actually has more > than just makes and models of cars. > It has antiques, autos, furniture, blah blah. each parent category has it's > child category and each child has it's own child. As an example, Antiques > would have a child of asian antiques and it would have a child of all the > different asian antiques you could think of. I hope this makes more sense. > Anyhow the first group of childs I can refer back to their parent, but the > second group of childs are referenced back to the child of the parent and > not the parent directly. > > > > > Doug > > > > - Original Message - > From: "Jim Wright" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Thursday, September 28, 2006 9:43 AM > Subject: Re: Arg!! > > > > Doug Brown wrote: > > > Hey Jim...I have one more quick question for you. > > > > > > As I stated before I have just the one table to display the makes and > models > > > for the menu, and I am kinda dumbfounded as to how to display all the > makes > > > on one page with their corresponding models beneath them. Can this be > > > accomplished with one table? > > > > > > IE: > > > > > > cat_id > > > category > > > parent_id > > > > > > Right now the data looks like so > > > > > > cat_idcategoryparent_id > > > 1chevynull > > > 2 ford null > > > 3Camaro1 > > > 4Escort2 > > > > Something like... > > > > SELECT a.category AS make, b.category AS model > > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > > WHERE a.parent_id IS NULL > > ORDER BY a.category,b.category > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX and cross-site scripting attack?
Yah, as of right now, we have the
access photoshop metadata via CF - XMP
Hi List, Does anyone know how one can access meatdata from photos. In photoshop you can access it via XMP (browse - right click - file info). I have a photographer who wishes to put his photos online and has entered a lot of data this way (location, keywords etc). It would be great to extract that data and populate the database/form when he uploads a photo. Many thanks in advance -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Poor mans Logger
On Wednesday 27 September 2006 16:34, Snake wrote: > Choir Ahh, didn't realise you were a host yourself :-) > time. But the problem is that sometimes customers want to use > CreateObject(java) and you have to try an explain to them why this is > disabled. I imagine their response is either to go to a less secure host, or pay you more money for a dedicated instance ? In which case why not offer a less-secure service yourself (at least then you get their custom) ? -- Tom Chiverton Helping to conveniently orchestrate user-centric clusters This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Arghhhh!!
See, there I go again not making my self clear. The table actually has more than just makes and models of cars. It has antiques, autos, furniture, blah blah. each parent category has it's child category and each child has it's own child. As an example, Antiques would have a child of asian antiques and it would have a child of all the different asian antiques you could think of. I hope this makes more sense. Anyhow the first group of childs I can refer back to their parent, but the second group of childs are referenced back to the child of the parent and not the parent directly. Doug - Original Message - From: "Jim Wright" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, September 28, 2006 9:43 AM Subject: Re: Arg!! > Doug Brown wrote: > > Hey Jim...I have one more quick question for you. > > > > As I stated before I have just the one table to display the makes and models > > for the menu, and I am kinda dumbfounded as to how to display all the makes > > on one page with their corresponding models beneath them. Can this be > > accomplished with one table? > > > > IE: > > > > cat_id > > category > > parent_id > > > > Right now the data looks like so > > > > cat_idcategoryparent_id > > 1chevynull > > 2 ford null > > 3Camaro1 > > 4Escort2 > > Something like... > > SELECT a.category AS make, b.category AS model > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > WHERE a.parent_id IS NULL > ORDER BY a.category,b.category > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Interesting new MSSQL problem.
DURETTE, STEVEN J (ASI-AIT) wrote: > Actually, this can be done like this... > > > Select top 5 field1, field2 >>From (select distinct t1.Field1, t2.Field2 > from t1 join t2 on (some id's)) > Order by newID() > > The inner query takes care of the distinct and makes the outer query > believe that it is a single table you are pulling from. > > Steve > This is probably a better/cleaner solution than the one I sent...I also just realized that in the case of the one I sent, the TOP 5 needs to be moved down to the second query. But even so, I'm betting the derived table as above will be optimized better. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Debugging JavaScript
Claude Schneegans wrote: > > >>and for IE, try te Microsoft Script Debugger > > In about 10 years of development using IE, I've never been able to get > this piece of *&?%! > working, either under W98 or XP. I gave up. > Yeah, it's not exactly intuitive or anything. I found this article: http://www.jonathanboutelle.com/mt/archives/2006/01/howto_debug_jav.html very useful. By and large, i basically develop in firefox first, using firebug and the console.log() stuff, and then integrate with ie afterwards. I find the best strategy is *not* to wait until the whole thing is done in firefox before trying to get it to work in ie, or you will have built up so many problems that you will debug all night. Tools like selenium are really useful here as they allow you to run the same tests in firefox and ie - saves a lot of time when you are trying to test stuff that's a pain to get to. /t -- View this message in context: http://www.nabble.com/OT%3A-Debugging-JavaScript-tf2348857.html#a6549124 Sent from the Cold Fusion - Technical mailing list archive at Nabble.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Arghhhh!!
Doug Brown wrote: > Hey Jim...I have one more quick question for you. > > As I stated before I have just the one table to display the makes and models > for the menu, and I am kinda dumbfounded as to how to display all the makes > on one page with their corresponding models beneath them. Can this be > accomplished with one table? > > IE: > > cat_id > category > parent_id > > Right now the data looks like so > > cat_idcategoryparent_id > 1chevynull > 2 ford null > 3Camaro1 > 4Escort2 Something like... SELECT a.category AS make, b.category AS model FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id WHERE a.parent_id IS NULL ORDER BY a.category,b.category ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Interesting new MSSQL problem.
Actually, this can be done like this... Select top 5 field1, field2 >From (select distinct t1.Field1, t2.Field2 from t1 join t2 on (some id's)) Order by newID() The inner query takes care of the distinct and makes the outer query believe that it is a single table you are pulling from. Steve -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 7:57 AM To: CF-Talk Subject: Interesting new MSSQL problem. I am trying to select rows from a database that are both random AND distinct... Simple no? Well... No. I can select distinct records using SELECT DISTINCT TOP 5 t1.Field1, t2.Field2 FROM t1 JOIN t2 ON (some id's) Now normally to get random records you would just order by newid()... SELECT DISTINCT TOP 5 t1.Field1, t2.Field2 FROM t1 JOIN t2 ON (some id's) ORDER BY newID() But when the DISTINCT keyword is used the "order by" fields must be part of the select... SELECT DISTINCT TOP 5 t1.Field1, t2.Field2, newID() FROM t1 JOIN t2 ON (some id's) ORDER BY newID() Unfortunately, this makes all records unique as they all now have a random field in them! How can I randomise these records while having them remain distinct? -- Jay ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Arghhhh!!
Hey Jim...I have one more quick question for you. As I stated before I have just the one table to display the makes and models for the menu, and I am kinda dumbfounded as to how to display all the makes on one page with their corresponding models beneath them. Can this be accomplished with one table? IE: cat_id category parent_id Right now the data looks like so cat_idcategoryparent_id 1chevynull 2 ford null 3Camaro1 4Escort2 - Original Message - From: "Jim Wright" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, September 28, 2006 9:17 AM Subject: Re: Arg!! > Doug Brown wrote: > > BadaBing. That did the trick. I think I need to brush up on my SQL a bit. > > :-p > > Thanks alot Bud > > Doug > > I'm glad you figured it out...it would be a real shame for a car like > this to just disappear... > http://en.wikipedia.org/wiki/Image:SC06_Aston_Martin_Vanquish_green.jpg > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JDBC connection pooling
coldfusion does jdbc connection pooling, right? so if I have 100 people browsing my web site, coldfusion will send queries over the DSN's existing connection right? And if "Maintain DB connection" is checked, that connection will always be there once it's been accessed at least once.. Now, if I have 5 instances of coldfusion, each of them with a DSN to the same database, then I would (potentially) have 5 concurrent connections... is that right? The reason I'm asking is because of the licensing model for Starquest's StarSQL for Java DB2 driver... it's licensed on a "per concurrent connection" basis Just trying to figure out how many concurrent connections I might have... Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX and cross-site scripting attack?
Not neccisarily, some fixes you have to apply to each instance. Anyway is it possible that the cross site scripting protection was not triggered until now? Has the
Re: OT: Debugging JavaScript
>>and for IE, try te Microsoft Script Debugger In about 10 years of development using IE, I've never been able to get this piece of *&?%! working, either under W98 or XP. I gave up. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JVM & Server Memory
On 9/28/06, Richard Kroll <[EMAIL PROTECTED]> wrote: > Hello all, > > I remember a post not too long ago talking about the JVM and it's max > size on a windows 32bit server having a celing of 1.3gb. We've got a > server that has 3gb of ram, and about 1.8gb of that is going unused even > under peak load. One of my colleagues decided to up the -XmxNx value of > the JVM to 2gb to attempt to allocate more memory and increase > performance. This caused CF to fail on startup, and once the setting > was lowered, CF started fine again. As is understand it there are three > major settings to tweak in the JVM (where N is the memory size) and > please forgive me as I'm new to JVM configuration: > > > > -XmsNm - minimum GC size > > -XmxNm - maximum GC size > > -XX:MaxPermSize=Nm - the maximum permanent size > > > > For our application we have quite a large number of objects stored in > the application scope and would like to increase the amount of ram > allocated to jrun / JVM. Am I correct in that increasing the > MaxPermSize from its default of 128m to a larger amount (say 512m) will > increase the available memory of the JVM for objects being stored for a > much longer period of time (like those in application scope)? Our > current settings for our JVM are: > > > > -Xms512m > > -Xmx1024m > > -XX:MaxPermSize=128m > > > > We are not getting a ton of GC that is degrading performance, but we > seem to be having the system slow down dramatically when JRun / JVM hits > the 1gb mark. So our thought was to raise the amount of memory in the > JVM available to JRun. Am I right in my understanding of the > differences in the settings? > > > Hi Rich, I think this blog entry by Robi Sen is something you might want to read through (and follow some of the reference links in it, too). It's really is a great source of information regarding JVM and JRun tuning: http://www.robisen.com/index.cfm?mode=entry&entry=FD4BE2FC-55DC-F2B1-FED0717CC1C7E0AF One thing I remember somebody from Adobe saying (I think it was Sarge at CFUNITED, but I could be wrong) is that using the application scope doesn't necessarily mean that the object is placed in the Permanent Generation. So don't assume that a lot of application variables means that you need to have a larger Perm Heap size. Also, you definitely want to have your min and max Heap size set to equal values. This avoids the JVM having to incrementally allocate the appropriate memory resources as the application memory usage grows. One other thing to note. The default settings that come in the jvm.config file, according to Adobe, are settings that they have observed over thousands of hours of testing to be the optimal settings. I don't necessarily agree with that because hardware resources vary greatly as do the applications themselves, but definitely use them as a reference check to make sure you're not going of the deep end. Hope this helps? Regards, Dave. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Arghhhh!!
Doug Brown wrote: > BadaBing. That did the trick. I think I need to brush up on my SQL a bit. > :-p > Thanks alot Bud > Doug I'm glad you figured it out...it would be a real shame for a car like this to just disappear... http://en.wikipedia.org/wiki/Image:SC06_Aston_Martin_Vanquish_green.jpg ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JVM & Server Memory
No, Permanent Memory is not where long-lived objects are stored. These objects are stored in the Tenured memory space. PermGen simply holds the reflective data about your objects and classes (which is why it's so large for ColdFusion apps). To increase the size of your Tenured memory, you could specify the ration of new vs. old. -XX:NewRatio=n (where n is the ratio of old to new. Ex: value of 3 means that Tenured takes up 3/4 of total heap) You can also give the new generation an explicit size, allocating the rest for old generation -Xmn90m (this tell the JVM to allocation exactly 90 MB for Eden an Survivor spaces) Hope that helps. Here some helpful links. http://www.caucho.com/resin-3.0/performance/jvm-tuning.xtp http://java.sun.com/j2se/1.5.0/docs/guide/vm/gc-ergonomics.html Steve Brownlee http://www.fusioncube.net/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX and cross-site scripting attack?
We have not. We talked about it but we haven't. Even if we did, both instances on the same server should be affected, not just one. Johnny >Did you recently apply a hotfix, as there is one that fixes an issue with >the cross site scripting, perhaps this wa sthe issue. > >Russ > >-Original Message- >From: Johnny Le [mailto:[EMAIL PROTECTED] >Sent: 28 September 2006 14:53 >To: CF-Talk >Subject: CFMX and cross-site scripting attack? > >Hi, > >We have 3 development servers and 3 production servers on 3 different >networks. We deployed an application across all 6 servers. All of them >have the "enable global script protection" setting in CFAdmin checked. >Everything was working great. Suddenly today, the app on one of the >production server changed
RE: Init Explanation
I would suspect this is just a variable to signify that all the application scope variables have been created. And if the url variable reinit is sent, this re-creates all the variables -- Snake -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 September 2006 15:33 To: CF-Talk Subject: Init Explanation Can someone help me understand what init is what it does and why it's used? For example, in a application.cfm D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX and cross-site scripting attack?
Did you recently apply a hotfix, as there is one that fixes an issue with the cross site scripting, perhaps this wa sthe issue. Russ -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: 28 September 2006 14:53 To: CF-Talk Subject: CFMX and cross-site scripting attack? Hi, We have 3 development servers and 3 production servers on 3 different networks. We deployed an application across all 6 servers. All of them have the "enable global script protection" setting in CFAdmin checked. Everything was working great. Suddenly today, the app on one of the production server changed
RE: Init Explanation
I'm assuming it's being used either for session work or for a flag of some sort in the application used to reset application variables. It's just a variable really, so you need to trace the variable through the page request to find out what conditions it's used in and why. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 10:33 AM > To: CF-Talk > Subject: Init Explanation > > Can someone help me understand what init is what it does and why it's > used? > > For example, in a application.cfm > > > > > D > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254621 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: select * (star) caching
And thanks to everyone else who posted their ideas. I appreciate your insights and willingness to help! And to HoF for existing. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254619 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Init Explanation
D, Take a look at this page: http://www.bennadel.com/index.cfm?dax=skinspider:0.it1thecode&code_updat e=2006-09-27 In the description, click on the "Application.cfm" link (in the page content). This will pop up a window with the Application.cfm code. In it, I use the variable "reset"... But same idea as "init". Read the comments in the file. Hope that helps. -b .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 10:33 AM To: CF-Talk Subject: Init Explanation Can someone help me understand what init is what it does and why it's used? For example, in a application.cfm D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: select * (star) caching
ANSWER FOUND By updating the datasource's "Max Connection Pooling" property to 0, each change to the db is reflected dynamically on the next front-end page refresh. This is exactly how I expected "select *" to work... find the columns real time and gimme 'em all. Thank you Brian Rinaldi for your answer!! Totally saved the day. And tomorrow and at good week or two of testing the 524 legacy *s not to mention all the typing involved in spelling out columns... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254618 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Init Explanation
Can someone help me understand what init is what it does and why it's used? For example, in a application.cfm D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: IBM's DB2 JDBC Driver
Were using the DB 2 connect JDBC type 4 drivers without having to have them bound or having this problem. The DB2 instance is 7 something and the DB 2 client is 8 something. > -Original Message- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 10:26 AM > To: CF-Talk > Subject: Re: IBM's DB2 JDBC Driver > > In order to get the IBM DB2 JDBC driver working properly, I had to run > the DB2Binder, according to the following instructions: > > http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/co > m.ibm.db2.doc.java/bjnkmstr165.htm > > I had to specify a collection, so my JDBC URL ended up being: > > jdbc:db2://HOST:PORT/DBNAME:jdbcCollection=JDBCPKG; > > Of course, for some reason, this didn't solve my problem with "SELECT > FOO AS BAR FROM TABLE" returning "foo" as a column name. > > So far, the only driver I've tried that doesn't have this problem is the > HiT JDBC/DB2 driver from HiT Software. > > Rick > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: select * (star) caching
Brian, setting "Max Pooled Statements" to 0 worked the first time I ran the query, but not any times after that. How crazy. I even tried setting the "Timeout" and "Interval" to 0s and no luck at all. I also have "Maintain Connections" unchecked. >I believe this can be accomplished by setting "Max Pooled Statements" in the >advanced properties on your datasource to 0. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IBM's DB2 JDBC Driver
In order to get the IBM DB2 JDBC driver working properly, I had to run the DB2Binder, according to the following instructions: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.java/bjnkmstr165.htm I had to specify a collection, so my JDBC URL ended up being: jdbc:db2://HOST:PORT/DBNAME:jdbcCollection=JDBCPKG; Of course, for some reason, this didn't solve my problem with "SELECT FOO AS BAR FROM TABLE" returning "foo" as a column name. So far, the only driver I've tried that doesn't have this problem is the HiT JDBC/DB2 driver from HiT Software. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254614 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: select * (star) caching
>Somehow this thread seems to have gotten split. Yes, I goofed when I created the post because I wasn't subscribed. Previously it would not have added to HoF. Now it does subscribe a non-subscriber automatically and it refreshing the Talk page, my post wasn't there. No sooner than I post a second thread of the same content, does my first one appear. Now I know it will subscribe me automatically. What you are saying makes a lot of sense from what I am experiencing. Some layer with CF that is not dynamic like a true SQL-executed "select *". I'm going to find this max pooled thing you make reference to. Thank you very much for your ideas. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: select * (star) caching
Has anyone out there had any experience with the Microsoft JDBC Type IV driver? When I delete a column referenced in a .* query, I get a "value cannot be converted to the requested datatype" error from the default JDBC driver. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254612 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: browser accessibility
On Thursday 28 September 2006 02:04, Richard White wrote: > I have recently heard that as long as you develop your > css and xhtml to the correct standards then this will not be a problem. Shoot/fire who ever told you that. Even the most recent IE and Firefox browsers have their own quirks. 90% of the time you don't need to worry about the differences, but that remaining 10% can be headache on pure-CSS sites. I'd recommend a good read on AListApart.com. -- Tom Chiverton Helping to advantageously innovate ubiquitous ROI This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: select * (star) caching
Here's an example query. select *, 'x' as a_test from sc where sid = So, yes, cfqueryparams in the where clause. What was your solution? Seems quite relevant to the situation at hand. Thanks for your input. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFMX and cross-site scripting attack?
Hi, We have 3 development servers and 3 production servers on 3 different networks. We deployed an application across all 6 servers. All of them have the "enable global script protection" setting in CFAdmin checked. Everything was working great. Suddenly today, the app on one of the production server changed
Re: select * (star) caching
Right, another guy here suggested the same thing. That would essentially bypass the way CF is mapping out the "*" translation and allow SQL a chance to built the field list. The query would be copied-and-pasted into a SQL stored procedure so that's easy. The truth of it told, there are 524 stars in a ballpark 500 queries. That's going to take some time! Thanks for your help. Keep the good ideas rollin'. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254607 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: select * (star) caching
Russ, I tried unchecking the "Maintain Connection" checkbox from CF Admin for this datasource and no luck. I even set the max cached queries to 0. I had high hopes because it makes sense that something with a CF optimization algorithm is over-caching. Any other ideas? These are good ones... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF consulting/development shops in the Philadelphia area
Hi, I've been tasked by my boss to find some help for a couple of CF projects that we have in the pipeline. What we need is an experienced ColdFusion shop that is able to take on support, maintenance, and added feature functionality. Sorry, not looking for individual freelancers, we need a shop with depth that we can count on. We are located in Center City Philadelphia and would be looking to develop a lasting relationship. Projects are primarily CFMX7 on Windows with SQL Server or MySQL as a back end. Email me if you fit the bill. Thanks, Pete ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: select * (star) caching
Thanks, Andrew, Nope, not using cachewithin or cachedafter in any of the queries (unless that's something that is hidden in there by default). I am using v7.0.1 at this moment. I'm going to upgrade to 7.0.2 soon. Is this an issue with 7.0.1? I have set the Maximum number of cached queries to 0 in CF Admin, restarted IIS, restarted all CF services and the query ran fine... once. After it ran, I modified the table and back to the "value cannot be converted to the requested type error". I have unchecked the Maintain Connection associated with the datasource... Thanks for your ideas. I hope something soon works. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
