Re: PostgreSQL vs. MSSQL
Jon, Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on Windows boxes? If so, what version(s) for both the db server and windows servers? The cost is currently not an issue, although it certainly has the potential to become one in the relatively near future, at the current database growth rate. Thus my looking into my options :-) Also, just to clarify on the case-sensitivity point you made, am I correctly understanding that the following query **typically** would not have any issues? cfquery SELECT my_field FROM my_table; /cfquery Even if the field was named as 'my_Field' (minus the quotes) in the database? Thanks, Matt ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cracking the RDS protocol?
On Monday 08 January 2007 20:42, Anthony Cole wrote: I started looking into this matter a little and the protocol is easy to crack. I only coded 3 functions, but I found many other operations by playing with IIS logs. Cool. What would rock would be writing up a list of which methods have been enginered and how to constuct the URL and parameters for that method. -- Tom Chiverton Helping to quickly strategize total functionalities 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cfqueryparam on ALL values or just user definable ones?
even then, I have not seen a way to create sql injection attacks with CF Russ, One particularly nasty example I have seen in action is an attack against mssql db's using EXEC sp_cmdshell. You can then run any dos command via mssql I agree with Matt, - its better to err on the side of caution in this situation. (just in case you havent anticipated every possible form of attack that might ever exist!) On 08/01/07, Matt Robertson [EMAIL PROTECTED] wrote: I am all for reducing attack surfaces. Even if cfqueryparam's sole purpose in life is to enhance security, its worth it. Never mind the speed given under load. Use it as a cheap way to bulletproof your code and minimize your own personal liability in case it turns out the hacker is smarter than you thought they would be. That includes inputs like #getsite.ID# Sure the input *should* come from where you think it does... but if some clown moves something into the middle of the picture then you have created a hole that someone can toss a grenade thru. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
Matt Quackenbush wrote: Thanks for the reply. I forgot to post his specific gripes about it. Here is a quick summary: - non-standard sql I think that depends on what you call 'standard sql'. To me, standard SQL is what is defined in ISO/IEC 9075 and few do better then PostgreSQL in that respect. But if you take 'standard sql' to mean 'the SQL in product X', you may discover many differences. - difficult to backup / migrate What is difficult about scheduling pg_dumpall -f dumpfile? For migration he may have a point. PostgreSQL will not allow you to shut down the database, pack up the data files, put them on another machine and start up there. While this technically is possible in some circumstances, it is not a documented procedure because it is guaranteed not to work when you move from for instance Windows to an AIX mainframe. Other products that only run on limited platforms and do not have to worry about memory alignment and the endianness of the host operating system do not have this limitation. - user authenication is weak PostgreSQL allows the DBA to use anything from no authentication to Kerberos and you can even create single-signon with a Windows domain. User authentication is as weak as the DBA configured it to be. And if we extend this to security in general you might want to Google a bit. PostgreSQL is highly regarded for its security track record and is often an example to other databases. For instance, while many databases install themselves under an account with elevated privileges by default even when that is technically not necessary, PostgreSQL refuses to run if it has more permissions then it needs. - difficult to setup http://www.suite101.com/article.cfm/oracle/115560 - difficult to manage To manage PostgreSQL you need to do a few things that are clearly spelled out in the manual: http://www.postgresql.org/docs/8.2/static/maintenance.html http://www.postgresql.org/docs/8.2/static/backup.html Again I would have to ask what is so hard about setting up a scheduled task. In short: you may want to ask him if he is not confusing PostgreSQL with some other database. Your post was most informative, for sure. But there's one thing that you mentioned that I was unaware of that is pretty much an instant turn-off for me: cAsE sEnSiTiViTy. PostgreSQL identifiers are only case sensite if you make them case sensitive by enclosing them between double quotes. The following code will run just fine: CREATE TABLE fOo (BaR INTEGER); SELECT bAr FROM foo; Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RDS in CFECLIPSE. What's Wrong?
On Friday 05 January 2007 15:59, Dwayne Cole wrote: Thanks Tom for what ever help you can give. Right. Try with Eclipse 3.2 and the new Flex 2.0.1 :-) -- Tom Chiverton Helping to efficiently administrate six-generation IPOs 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: A question about CFCFactory objects as a singleton ....
Hi Mike I would take the approach of passing the user object in as part of your DAO save (or create and update) method. cfset widgetDAO = application.factory.getBean(WidgetDAO) cfset widgetDAO.save(widget,session.currentUser) Just as you only need a singleton factory, you also only need singleton DAOs. Best regards Kevan Stannard -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 January 2007 5:24 AM To: CF-Talk Subject: Re: A question about CFCFactory objects as a singleton yes as a matter of routine, my tables usually have fields for: createdby (the userid of the person who created this record) datecreated (timestamp) updatedby (The userid of the last person to alter this record) dateupdated (timestamp) So the methods in the DAOs that manipulate the records need to be told who's doing it. Since DAOs dont know anything about the application, request or session scopes, they have to be told what they need to know. In this case they dont need to know the curent time (thats from the getdate() function in the database) but they do need to know the userid of the person initiating this action.My question was about the best way to pass this info in, since the application doesnt .instantiate the dao directly, but through a CFCFactory which knows everything it needs to know to instantiate any CFC required. When someone logs in, there is a userbean created in their session scope, containing their name, userid, access rights and lots more depending on what else happens in this site. So the question is about this .if there is only one CFCFactory created as a singleton in the Application scope, all the users on the site are using the same instance of the CFC to instantiate whatever CFCS they need. Each time, the CFC being created will need to be told who's the user, so it can update any records it needs to update correctly. Or perhaps it's better to pass the userID into each method as it's called rather than into the init method of the DAO cfc. The options in my first post were the ones that came to mind as i wrote it, but there are probably other possibilities What's brought this to mind now is that i'm working on an app that will have maybe 150-200 concurrent users, all accessing, creating and updating records. In the past i've had plenty of reasonably high traffic sites, but none with that many users creating and updating records simultaniously. The high traffic has all been in the read only category,with the write/update being one or two people at a time max. Under those low traffic situations it doesnt really matter to have everyone with their own CFCFactory. One or two fo them in RAM isnt a big deal 100-200 of them would definitely have a performance hit on the site so i can't do that here. Thats' the background to my question. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 1/9/07, Josh Nathanson [EMAIL PROTECTED] wrote: It seems like option [B] would use a lot less memory resources. A little more detail about how your objects are set up would be helpful to get a clearer picture. Do you have multiple tables which each store which user/ when created? It seems like you could have a userID property in each of your objects that needs to maintain the user info, then do: myObject.setUserID(session.userbean.getUserID()) before commiting. Then have timestamp field in the db. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
Matt Quackenbush wrote: I've always used MSSQL and quite frankly am quite fond of it - except for licensing costs. I've read a few posts here and there where people have talked highly of PostgreSQL, so I'm thinking about giving it a shot on a new server (windows box). I mentioned this to a buddy of mine who is a DBA, and he said to steer well clear of it. While I value his opinion greatly, I was wondering if the users here would care to share their personal + vs. - arguments for PostgreSQL? + rich SQL support + easy to install / configure + portable + low resource usage + excellent documentation + great community support + many options for commercial support + liberal license + understandable source code The only thing I miss in PostgreSQL is eager update-everywhere replication. There are commercial offerings for that, but all the community offerings are either lazy or master-slave. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cfqueryparam on ALL values or just user definable ones?
Russ wrote: In my experience, it only slowed things down. Now, YMMV, but I've noticed that the more cfqueryparams you have in your query, the slower it will run. What did you test? How did you test it? How many simultaneous users? Although theoretically the sql engine should have an easier time caching an execution plan for your query, the only reason I have found to use cfqueryparams is for security. And even then, I have not seen a way to create sql injection attacks with CF, unless you're doing something stupid, like preserveSingleQuotes(). I have seen plenty. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cfqueryparam on ALL values or just user definable ones?
Andy Matthews wrote: A query has an incoming value which is the result of a previous query: WHERE id = #Val(getsite.id)# Should something like this be using a cfqueryparam or is it okay to leave as is? What happens if getsite does not return any rows? If you have that covered and getsite.id is a numeric type in the database, it is technically OK to leave it in. Performance is another issue. In general, if you want the DB to be able to reuse an execution plan, convert this to a cfqueryparam. If you don't want the database to reuse the execution plan, don't convert it. But without knowing a lot more about the schema and the usage pattern it is a bit hard to say whether execution plan reuse would be a win for you. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PostgreSQL vs. MSSQL
Jochem van Dieten wrote: wondering if the users here would care to share their personal + vs. - arguments for PostgreSQL? + rich SQL support + easy to install / configure + portable + low resource usage + excellent documentation + great community support + many options for commercial support + liberal license + understandable source code you forgot postGIS :-) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
retrieve db into variables
Alright! This works fine thanks. I don't want do rewrite my variable scoping for this app, but I'll consider having everything in Variables for the future as I write this up as a general include. It may be helpful to know/recall that all local variables live in a scope structure called Variables. So you can just use that instead of the structure you create yourself: cfset Variables[col] = the_db[col][currentRow] This should also be faster, because of the explicit scoping. The syntax mentioned in the other replies works just fine, though: cfset #col# = the_db[col][currentRow] -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting SQL Server onto XP Pro machine
Of the four versions of SQL Server 2000 that are available, only the personal version of SQL Server 2000 can be installed on aWinXP machine. All other versions must be installed on a Windows server system (Win2K, Win2K3, SBS, etc.) No, you can also install SQL Server 2000 Developer on Windows XP. And, if you're developing for SQL Server 2000 Standard or Enterprise, that's the version you should use, as it's a closer match to those versions than is the Personal version. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PostgreSQL vs. MSSQL
I agree, I think every database has some non-standard SQL. An example in MS SQL is the isNull() function, which is functionally equivalent to the ANSI standard coalesce(). Why did MS make their own? Who knows, maybe because they liked their name better? SQL Server also supports COALESCE. And, while the two are very similar, they aren't identical in functionality. A Google search on coalesce vs isnull turns up all sorts of mildly interesting stuff. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server Error 8179: Could not find prepared statement with handle x
Hi all, One of our CFMX 7 applications (which was working fine before) suddenly started throwing this error - SQL Server Error 8179: Could not find prepared statement with handle x. The funny part is, it throws the error at pretty much any point in the application without any apparent reason in the sequence of code. If I comment out that code, then the some other query code will malfunction the same way with a different value for x. I looked around for solutions, but could not get any usable ones. One thing that worked for us is to increase the maximum number of pooled statements by 1 in the datasource and then the problem went away. However it would be nice to know why the heck it happened in the first place. Thanks, George ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Server Error 8179: Could not find prepared statement with handle x
George, We ran into the same problem a few months ago. What we found was the error was thrown on random queries that had CFQUERYPARAMs in them (which was almost every query in our application). Somewhere on the net I found an article explaining that it had something to do with the drivers. We switched our drivers to the jTDS JTDS drivers for MS SQL 2k and the problem went away. HTH Rich Kroll -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 8:38 AM To: CF-Talk Subject: SQL Server Error 8179: Could not find prepared statement with handle x Hi all, One of our CFMX 7 applications (which was working fine before) suddenly started throwing this error - SQL Server Error 8179: Could not find prepared statement with handle x. The funny part is, it throws the error at pretty much any point in the application without any apparent reason in the sequence of code. If I comment out that code, then the some other query code will malfunction the same way with a different value for x. I looked around for solutions, but could not get any usable ones. One thing that worked for us is to increase the maximum number of pooled statements by 1 in the datasource and then the problem went away. However it would be nice to know why the heck it happened in the first place. Thanks, George ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Werid cfqueryparam error...
I've seen this before but just worked around it with a cfif in the SQL. SQL Server, smallmoney data type for this field. Here's the SQL: prodconsignmentprice = cfqueryparam cfsqltype=cf_sql_money value=#ARGUMENTS.prodconsignmentprice# If you submit a blank value, you get this error: Invalid data for CFSQLTYPE CF_SQL_DOUBLE. Umm ok... I'm not using any cfqueryparams with double. Just money. It works fine, unless you submit an empty value. I usually just wrap it with a cfif. Am I doing somethin wrong though? Thanks, Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
On Jan 9, 2007, at 3:23 AM, Matt Quackenbush wrote: Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on Windows boxes? If so, what version(s) for both the db server and windows servers? Both. 8.2 for Postgres and 5.1 for MySQL.XP Pro and Server 2003 for the OS. Also, just to clarify on the case-sensitivity point you made, am I correctly understanding that the following query **typically** would not have any issues? cfquery SELECT my_field FROM my_table; /cfquery Even if the field was named as 'my_Field' (minus the quotes) in the database? Actually, the other way around. When you convert your tables over to Postgres, you'll have to lowercase them. Once again, though if you don't quote the table names in the script, Pg will automatically take care of lower casing that for you when you run the Create's. Then any queries you have with mixed case names for the table attributes will still run. If you uppercase any of the table/column names, you will have to quote them. HTH, Jon ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
SQL Server also supports COALESCE. And, while the two are very similar, they aren't identical in functionality. A Google search on coalesce vs isnull turns up all sorts of mildly interesting stuff. You're right on both counts, Dave. My main point was that MS even bothered to make a non-standard function. IIRC, Coalesce does more than isNull, but the basic thing that most people use isNull() for is this: isNull(mname,'blank') so you don't have nulls in your return values, and this works the same as coalesce. However, I can't justly bash MS for this, because Oracle, MySQL and DB2 have proprietary functions for this as well. I just wanted to point out that all the popular DB platforms have non-standard SQL to some degree. -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FarCry and TinyMCE issue
Adrian, Sorry, I didn't get a chance to dig around the FarCry admin yesterday. My mission for the day took me longer than I expected. :-) I'll see if I can't help out today. Jon On Jan 9, 2007, at 2:01 AM, Adrian Wagner wrote: Just to keep you in the loop. We were actually using TinyMCE 2.0.6. and I had a look at the 2.0.8 version of it. This version has been adapted to IE7 requirements (it's now sniffing for IE7 as well in the JS). However, it still loses the position when a link is inserted from the FarCry tree. and going back to it Adrian [EMAIL PROTECTED] 8/01/2007 3:14:12 pm Adrian, I'll see if I can take a look at it tomorrow a bit more. In the meantime,I dug through the javascript in the admin for a sec and there are two places, I would start to look; In /farcry_core/admin/includes/lib/tinymce/jscripts/tiny_mce/ tiny_mce.jsthere is a whole lot of browser sniffing going on. If your clients are using IE7, you may be able to redefine this.isMSIE to get it to work since any unknown version is served the IE 5 stuff. The function insertHTML( html ) is delivered inline from / farcry_core/admin/edittabedit.cfm. It's the one that sends the commands to the TinyMCE js functions on inserting HTML. You may be able to dial down to the problem though the function calls in there. Regards, Jon On Jan 7, 2007, at 9:56 PM, Adrian Wagner wrote: Jon, FarCry 3.01, TinyMCE 2.0.8. I just got an answer on the FarCry list - he has the same issue and claims it's an IE JS bug - which my test seem to confirm. In Firefox the cursor position within TinyMCE is remembered, in IE 7 and 6 the position is not remembered. Argh..looks like I'll have to jump into the JS. Or just tell them to use Firefox. ;) But, still any help would be appreciated - am not excactely the biggest JS guru. Adrian [EMAIL PROTECTED] 8/01/2007 11:43:55 am Adrian, I just did a test on one of my live sites running FarCry v3.1 and one on my dev box running a beta of v4 with no problems. The cursor position seems to be remebered as long as you don't click on anything else between the textarea and right-clicking the site tree object. Which version of TinyMCE and FarCry is this site on? Jon On Jan 7, 2007, at 9:11 PM, Adrian Wagner wrote: After trying the FarCry and the TinyMCE communities - without success, I now got to plead to the CF people. It might be a bit obscure though - but who knows, maybe someone here does work with TinyMCE in FarCry 3. We've implemented TinyMCE in our FarCry 3 CMS. Implementation and settings all work without a problem so far. There is one matter however, that derails some of our contributors.The FarCry Admin is built with frames. When editing the body of a document (with TinyMCE in the 'main' frame) the user can right-click a particular page in the navigation tree ('navigation' frame) and choose 'insert' - which will add the link to that page to the document body (TinyMCE). It basically works all ok, however when doing this the current cursor position within TinyMCE is not being remembered and the link is simply added at the top of the page. This causes CSS class issues, which are a bit difficult to deal with for the rather html/css-illiterate contributors.How can I easily make TinyMCE 'remember' the cursor position when leaving the frame so that the link will be inserted there? Has anyone come up with a solution to this? Is even anybody out there who works with the FarCry 3 / TinyMCE combination?Thanks for your help. Adrian Wagner Web Analyst Programmer Curtin Business School d: +61 (0) 8 9266 4220 m: +61 (0) 40 110 3252 e: [EMAIL PROTECTED] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server Error 8179: Could not find prepared statement with handle x
Hmm, we did have other problems with the current drivers we are using that was shipped with the product by (then) Macromedia. Mayve we can look at this driver you mention. Thanks, George On 1/9/07, Richard Kroll [EMAIL PROTECTED] wrote: George, We ran into the same problem a few months ago. What we found was the error was thrown on random queries that had CFQUERYPARAMs in them (which was almost every query in our application). Somewhere on the net I found an article explaining that it had something to do with the drivers. We switched our drivers to the jTDS JTDS drivers for MS SQL 2k and the problem went away. HTH Rich Kroll -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 8:38 AM To: CF-Talk Subject: SQL Server Error 8179: Could not find prepared statement with handle x Hi all, One of our CFMX 7 applications (which was working fine before) suddenly started throwing this error - SQL Server Error 8179: Could not find prepared statement with handle x. The funny part is, it throws the error at pretty much any point in the application without any apparent reason in the sequence of code. If I comment out that code, then the some other query code will malfunction the same way with a different value for x. I looked around for solutions, but could not get any usable ones. One thing that worked for us is to increase the maximum number of pooled statements by 1 in the datasource and then the problem went away. However it would be nice to know why the heck it happened in the first place. Thanks, George ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Needed: opinions on use of reserved words
I'm pretty sure you can use the brackets around the column name in queries from Access tables also. Not so sure how far this fix would go though--updates to the tables, etc.? If it were me, I'd require them to rework to avoid the reserved words. That's just plain bad practice. It would not be hard to grep or wingrep which template or queries use the wrong columns names and replace them with just a slight variation. SQL Server does this nicely by putting square brackets around reserved word columns. I am not sure that is Access compatible. e.i. [year] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Server Error 8179: Could not find prepared statement with handle x
The drivers we used are located at http://jtds.sourceforge.net/ Rich Kroll -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 10:02 AM To: CF-Talk Subject: Re: SQL Server Error 8179: Could not find prepared statement with handle x Hmm, we did have other problems with the current drivers we are using that was shipped with the product by (then) Macromedia. Mayve we can look at this driver you mention. Thanks, George ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Werid cfqueryparam error...
Have you tried using the NULL attribute of CFQUERYPARAM? I've done something like NULL=#NOT YesNoFormat(LEN(ARGUMENTS.prodconsignmentprice))# to handle this type of thing. Rich Kroll -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 8:28 AM To: CF-Talk Subject: Werid cfqueryparam error... I've seen this before but just worked around it with a cfif in the SQL. SQL Server, smallmoney data type for this field. Here's the SQL: prodconsignmentprice = cfqueryparam cfsqltype=cf_sql_money value=#ARGUMENTS.prodconsignmentprice# If you submit a blank value, you get this error: Invalid data for CFSQLTYPE CF_SQL_DOUBLE. Umm ok... I'm not using any cfqueryparams with double. Just money. It works fine, unless you submit an empty value. I usually just wrap it with a cfif. Am I doing somethin wrong though? Thanks, Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PostgreSQL vs. MSSQL
Coalesce is a WAY cooler name. Those guys at MS must have been smoking crack! Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com -Original Message- From: Jacob Munson [mailto:[EMAIL PROTECTED] Sent: Monday, January 08, 2007 7:41 PM To: CF-Talk Subject: Re: PostgreSQL vs. MSSQL - non-standard sql Indeed. This is true in some rare cases (like case sensitivity) however, it seems all databases take some liberties in regards to this. I agree, I think every database has some non-standard SQL. An example in MS SQL is the isNull() function, which is functionally equivalent to the ANSI standard coalesce(). Why did MS make their own? Who knows, maybe because they liked their name better? Back to your regularly scheduled programming. :) -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: retrieve db into variables
Daniel Kessler wrote: I don't want do rewrite my variable scoping for this app, but I'll consider having everything in Variables for the future as I write this up as a general include. You wouldn't have to - his point is, every var called variablename is also referenceable as variables[variablename] and vice versa. So you could just rig your db-to-variables code to work like the example given, and still reference your variables straight up later on. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Werid cfqueryparam error...
If you submit a blank value, you get this error: Invalid data for CFSQLTYPE CF_SQL_DOUBLE. An empty value is not a number. Use the NULL attribute as Richard suggested, if your database column accepts nulls. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
Hi Mark, Thank you for the additional information there. I really appreciate it. Are you aware of anyone who currently runs MS SQL in case sensitive mode? I'd be curious to know how often that happens. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] Mark A Kruger wrote: Jordan, One note - MS SQL is not case insensitive. In it's default collation it is case insensitive - but it can be either case sensitive OR case insensitive depending on install options and collations. -mark -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Monday, January 08, 2007 6:10 PM To: CF-Talk Subject: Re: PostgreSQL vs. MSSQL MS SQL is a fine database, and will get the job done. However, why pay for a database like that when you can get essentially the same thing for free? I've got nothing but positive things to say about PostgreSQL, and I'd be very interested to hear what your friend has against it. In my experience, usually these kinds of opinions are derived from a lack of understanding about how something operates. With PostgreSQL, there are two items that generally end up as road blocks for most MS SQL users who try it out. 1) User permissions: PostgreSQL is not forgiving as far as user/access permissions go. This is both good (for security purposes) and bad (because it can be frustrating to learn). However, like most things, once you understand how it's permission system works, it's not that difficult - it's just different. 2) Case sensitivity: Unlike MS SQL, PostgreSQL is a case sensitive database. This can be the deciding factor when choosing to port an application from MS SQL to PostgreSQL. If you have a database called User in PostgreSQL, your queries will need to have that database name in quotes. Here's an example: Database: User Field Names: ID, UserName, Password MS SQL Query: CFQUERY name=GetUser datasource=MSSQL SELECT id, username, password FROM user /CFQUERY PostgreSQL Query: CFQUERY name=GetUser datasource=PostgreSQL SELECT ID, UserName, Password FROM User /CFQUERY In our shop we user lowercase names for everything in our databases, so I haven't had to do that for a long time when working with PostgreSQL. As such, I cannot remember if it was single quotes, or double-quotes that I had to use when dealing with names that had uppercase values in them. Still, you get the idea. With the exception of those two items, PostgreSQL is wonderful. The price is great, the performance is great, and the community support is great. I would highly recommend PostgreSQL to *anyone* looking for a high-performance, low cost alternative to MS SQL. Hope this helps! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] Matt Quackenbush wrote: Hello, I've always used MSSQL and quite frankly am quite fond of it - except for licensing costs. I've read a few posts here and there where people have talked highly of PostgreSQL, so I'm thinking about giving it a shot on a new server (windows box). I mentioned this to a buddy of mine who is a DBA, and he said to steer well clear of it. While I value his opinion greatly, I was wondering if the users here would care to share their personal + vs. - arguments for PostgreSQL? Thanks, Matt ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
App Organizational Question...
Hi, all. Would it be better to identify users of a common app by CGI.HTTP_HOST and put in my Application.cfm (yes, .cfm. CF 4.5 here) lines such as: CFIF CGI.HTTP_HOST contains bodaford_homes.com CFSET DSN = bodaford_homes CFIF or Should I automate the process of DSN identification by using a MID function to select the domain name from the CGI.HTTP_HOST variable. (Pseudo code, because I can't remember right off how to select the string to the left of the last . in the domain name). :o/ ) CFSET DSN = (characters to the left of the last . and, if present, after the next . to the left, or the / to the left of the domain, in case someone types in the URL without using www, such as http://bodafordhomes.com) With this second approach, I don't have to modify the .cfm every time I add a new client to use the app. The first approach requires a new CFIF statement based on the domain name and DSN that I set up. Which way would be preferable? Pitfalls to each? Perhaps a better approach than either of these two? (It's too bad CF 8 isn't out now so I could make this major shift in how I develop apps along with learning to employ CF8. but alas, I have to strike while the iron's hot.) Thanks, Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
downloading a WSDL
I have a .net web service that I believe has an invalid WSDL. I have been previously told (by Dave Watts) that you can download a WSDL locally and create a web service form that. This seems like the solution for me to fix and test the WSDL, but how exactly does one do this. Just saving the WSDL file and pointing to that doesn't work. Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Getting changed fields from database using an audit table
Hi folks, The environment is SQL Server 2000 and CFMX 7.0.1 Here's the scenario. I have two tables. One is the primary table of data (let's call it USERS), the other is a table (say, USERS_UPDATED) with identical columns that stores a date in each column representing the last updated date of the corresponding column in the Users table. The USERS table also has a single lastupdated field. I am looking for the most efficient way to extract all changed fields from USERS from a given date, using the date values in USERS_UPDATED. Now, the issue isn't getting the information - I have working code to do this. The issue is performance with large resultsets. Currently, I am 1. selecting the records from USERS with lastupdated = (some date) 2. selecting the corresponding records from USERS_UPDATED 3. Looping over the result of the USERS query 4. within the USERS loop, looping over the list of columns, and comparing the date in USERS_UPDATED with (some date) to build the output result. Works fine until there are a lot of changed records in the USERS table for the provided date. A couple of real numbers: USERS has 89 columns. There are ~12000 updated records. This means my current code does 12000*89 loop iterations or 1068000 total iterations. It's WAY too slow for our needs. There has to be a better approach, but I am coming up blank. Anyone have any ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
UPS Scripts
does anyone know of some good tags out there to get real time UPS shipping rates? The tag i am currently using doesnt seem to be working well. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS Scripts
http://cfups.riaforge.org/ On 1/9/07, Chris Musial [EMAIL PROTECTED] wrote: does anyone know of some good tags out there to get real time UPS shipping rates? The tag i am currently using doesnt seem to be working well. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UPS Scripts
http://cfups.riaforge.org/ On 1/9/07, Chris Musial [EMAIL PROTECTED] wrote: does anyone know of some good tags out there to get real time UPS shipping rates? The tag i am currently using doesnt seem to be working well. where CF 7 isnt required... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting changed fields from database using an audit table
Try joining the two user tables rather than doing tons of single-row queries on the updated table. Unfortunately you will have to alias all of the columns from one of the tables to get unique column names. (You might do a single query of the users table that returns zero records just to get the column names... Then you could build the aliasing SQL in code and then just execute it.) Mark -Original Message- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 11:50 AM To: CF-Talk Subject: Getting changed fields from database using an audit table Hi folks, The environment is SQL Server 2000 and CFMX 7.0.1 Here's the scenario. I have two tables. One is the primary table of data (let's call it USERS), the other is a table (say, USERS_UPDATED) with identical columns that stores a date in each column representing the last updated date of the corresponding column in the Users table. The USERS table also has a single lastupdated field. I am looking for the most efficient way to extract all changed fields from USERS from a given date, using the date values in USERS_UPDATED. Now, the issue isn't getting the information - I have working code to do this. The issue is performance with large resultsets. Currently, I am 1. selecting the records from USERS with lastupdated = (some date) 2. selecting the corresponding records from USERS_UPDATED 3. Looping over the result of the USERS query 4. within the USERS loop, looping over the list of columns, and comparing the date in USERS_UPDATED with (some date) to build the output result. Works fine until there are a lot of changed records in the USERS table for the provided date. A couple of real numbers: USERS has 89 columns. There are ~12000 updated records. This means my current code does 12000*89 loop iterations or 1068000 total iterations. It's WAY too slow for our needs. There has to be a better approach, but I am coming up blank. Anyone have any ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: downloading a WSDL
nevermind, I sorted it :-) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: UPS Scripts
How old of a version are you looking for? I have ups script for version 4 or 5 Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Chris Musial [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 10:49 AM To: CF-Talk Subject: Re: UPS Scripts http://cfups.riaforge.org/ On 1/9/07, Chris Musial [EMAIL PROTECTED] wrote: does anyone know of some good tags out there to get real time UPS shipping rates? The tag i am currently using doesnt seem to be working well. where CF 7 isnt required... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting changed fields from database using an audit table
Sorry if I was unclear: I'm not doing any single row queries...here's the code which may make it clearer. It's a bit out of context, since this is part of a CFC which is being called as a web service. I'm making it procedural for simplicity: The queries (no performance issues here - they execute quite fast enough): !--- This is to get the column list from USER_UPDATE, which has fewer columns that USERS --- cfquery name=collist datasource=#application.ds# maxrows=1 select * from user_update /cfquery !--- Using an Array here, rather than just the columnlist list. An attempt to improve performance in the loops at the end --- cfloop list=#collist.columnlist# index=i cfset ArrayAppend(variables.columns,i) /cfloop cfquery name=getusers datasource=#application.ds# select #collist.columnlist# from USERS where lastupdated = cfqueryparam cfsqltype=cf_sql_date value=#createodbcdate(since)# order by userid /cfquery cfset variables.userRecords = getusers !--- The subquery here may seem redundant when I could just use valuelist and the pk result from the previous query, but with 12000 results, this way is MUCH faster than a huge list string) --- cfquery name=getupdated datasource=#application.ds# select * from USERS_UPDATE where userid IN (select userid from users where lastupdated = cfqueryparam cfsqltype=cf_sql_date value=#createodbcdate(since)#) /cfquery cfset variables.updatedRecords = getUpdated Now, the loops to generate what I need. I am doing this entirely in cfscript, again for performance: cfscript var since = arguments.sincedate; var counter = 1; getData(since); // calls the above queries // Loop over each record for(x=1;x LTE variables.userRecords.recordCount;x=x+1) { // Loop through each column for (i=1;i LTE ArrayLen(variables.columns);i=i+1){ if(variables.updatedRecords[variables.columns[i]][x] gte createodbcdate(since)) { counter = counter + 1; //just a counter - even with this as the only output, it's WAY too slow. } } } /cfscript -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 12:10 PM To: CF-Talk Subject: RE: Getting changed fields from database using an audit table Try joining the two user tables rather than doing tons of single-row queries on the updated table. Unfortunately you will have to alias all of the columns from one of the tables to get unique column names. (You might do a single query of the users table that returns zero records just to get the column names... Then you could build the aliasing SQL in code and then just execute it.) Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server Error 8179: Could not find prepared statement with handle x
Thanks, George On 1/9/07, Richard Kroll [EMAIL PROTECTED] wrote: The drivers we used are located at http://jtds.sourceforge.net/ Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UPS Scripts
How old of a version are you looking for? I have ups script for version 4 or 5 Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Chris Musial [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 10:49 AM To: CF-Talk Subject: Re: UPS Scripts shipping where CF 7 isnt required... Coldfusion 6.1 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UPS Scripts
I believe I have used this version for 6.1 and it works. If you are interested how would you like me to send it to you? Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Chris Musial [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 12:05 PM To: CF-Talk Subject: Re: UPS Scripts How old of a version are you looking for? I have ups script for version 4 or 5 Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Chris Musial [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 10:49 AM To: CF-Talk Subject: Re: UPS Scripts shipping where CF 7 isnt required... Coldfusion 6.1 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Remove datefield calendar icon
I'm making a flash form that contains an input field of type datefield, which puts in that cool little flash calendar date selector. The problem is that I've got limited space in the form, and I would like to remove that little calendar icon that shows up by the date. Is this possible? I've googled and searched the archives with no success. -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting changed fields from database using an audit table
In a SQL query without the dynamic column list, is this what you are trying to achieve? SELECT u.id FROMusers u INNER JOIN users_updated up ON u.id = up.id AND up.lastupdated = cfqueryparam cfsqltype=cf_sql_date value=#since# WHERE u.id IN ( SELECT id FROMUSER_UPDATE up1 WHERE u.cola up1.cola OR u.colb up1.colb OR u.colc up1.colc OR etc etc ) Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS Scripts
I believe I have used this version for 6.1 and it works. If you are interested how would you like me to send it to you? Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Chris Musial [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 12:05 PM To: CF-Talk Subject: Re: UPS Scripts How old of a version are you looking for? I have ups script for version Coldfusion 6.1 Thanks. i appreciate it...you can email it to me: [EMAIL PROTECTED] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFC Question
I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On the live server though the root directory is SynergyDale. So of course my CFC's cannot be found. Do I need to change the directory name on my laptop to SynergyDale or is there a way for me to keep my directory the same name and still reference the CFC. I am going to guess that I have to change my local directory since the CFC is referenced as NASCAR.CFC.Queries? -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC Question
Can you add mappings? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Bruce Sorge To: CF-Talk Sent: Tue Jan 09 18:39:16 2007 Subject: CFC Question I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On the live server though the root directory is SynergyDale. So of course my CFC's cannot be found. Do I need to change the directory name on my laptop to SynergyDale or is there a way for me to keep my directory the same name and still reference the CFC. I am going to guess that I have to change my local directory since the CFC is referenced as NASCAR.CFC.Queries? -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC Question
Nope. Cannot add mappings. On 1/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Can you add mappings? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Bruce Sorge To: CF-Talk Sent: Tue Jan 09 18:39:16 2007 Subject: CFC Question I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On the live server though the root directory is SynergyDale. So of course my CFC's cannot be found. Do I need to change the directory name on my laptop to SynergyDale or is there a way for me to keep my directory the same name and still reference the CFC. I am going to guess that I have to change my local directory since the CFC is referenced as NASCAR.CFC.Queries? -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC Question
Bruce, Create a mapping in the CF Admin on your local machine for / SynergyDale pointing to the /nascar/ directory. Then use SynergyDale.cfc as your cfc object reference. You can also do the reverse on the remote server if you wish. HTH, Jon On Jan 9, 2007, at 1:39 PM, Bruce Sorge wrote: I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On the live server though the root directory is SynergyDale. So of course my CFC's cannot be found. Do I need to change the directory name on my laptop to SynergyDale or is there a way for me to keep my directory the same name and still reference the CFC. I am going to guess that I have to change my local directory since the CFC is referenced as NASCAR.CFC.Queries? -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC Question
Straight from livedocs http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/buildi12.htm Specifying the CFC location When you instantiate or invoke a component, you can specify the component name only, or you can specify a *qualified* path. To specify a qualified path, separate the directory names with periods, not slashes; for example, myApp.cfcs.myComponent specifies the component defined in myApp\cfcs\myComponent.cfc. ColdFusion uses the following rules to find the specified CFC. - If you use a cfinvokehttp://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p67.htm#wp2650065or cfobjecthttp://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pb5.htm#wp1810139tag, or the CreateObjecthttp://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi42.htm#wp1102241function to access the CFC from a CFML page, ColdFusion searches directories in the following order: 1. Local directory of the calling CFML page 2. Directories specified on the ColdFusion Mappings page of the ColdFusion MX Administrator 3. Web root 4. Directories specified on Custom Tag Paths page of the Administrator If you specify only a component name, ColdFusion searches each of these directories, in turn, for the component. *Note: *If you use only the component name to specify the CFC, ColdFusion does not search the directories specified in the Administrator on the ColdFusion Mappings page. If you specify a qualified path that starts with a mapped directory name, ColdFusion does find the component. If you specify a qualified path, such as myApp.cfcs.myComponent, ColdFusion looks for a directory matching the first element of the path in each of these directories (in this example, myApp). If it finds a matching directory, it then looks for a file in the specified path beneath that directory, such as myApp\cfcs\myComponent.cfc relative to each of these directories. *Note: *If ColdFusion finds a directory that matches the first path element, but does not find a CFC under that directory, ColdFusion returns a not found error and does *not* search for another directory. - If you invoke a CFC method remotely, using a specific URL, form field, Flash Remoting MX, or a web service invocation, ColdFusion looks in the specified path relative to the web root. For form fields and URLs specified directly on local web pages, ColdFusion also searches relative to the page directory. *Note: *On UNIX and Linux systems, ColdFusion MX attempts to match a CFC name or Custom tag name with a filename as follows: First, it attempts to find a file with the name that is all lowercase. If it fails, it then tries to find a file whose case matches the CFML case. For example, if you specify cfobject name=myObject Component=myComponent, ColdFusion first looks for mycomponent.cfc and, if it doesn't find it, ColdFusion looks for myComponent.cfc. -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC Question
I figured it out. Just droped the SynergyDale and use CFC.Queries. On 1/9/07, Jon Clausen [EMAIL PROTECTED] wrote: Bruce, Create a mapping in the CF Admin on your local machine for / SynergyDale pointing to the /nascar/ directory. Then use SynergyDale.cfc as your cfc object reference. You can also do the reverse on the remote server if you wish. HTH, Jon On Jan 9, 2007, at 1:39 PM, Bruce Sorge wrote: I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On the live server though the root directory is SynergyDale. So of course my CFC's cannot be found. Do I need to change the directory name on my laptop to SynergyDale or is there a way for me to keep my directory the same name and still reference the CFC. I am going to guess that I have to change my local directory since the CFC is referenced as NASCAR.CFC.Queries? -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC Question
My particular way around this is to set a CFC path variable in the application scope. So I call CFC's like this: cfset application.CFCpath = cfc / Or cfset application.CFCpath = synergydale.cfc / cfobject component=#application.cfcPath#.nascar name=nascarObj Yeah it's extra typing, but is a lot easier to maintain. If that option is palatable to you. Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 1:39 PM To: CF-Talk Subject: CFC Question I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On the live server though the root directory is SynergyDale. So of course my CFC's cannot be found. Do I need to change the directory name on my laptop to SynergyDale or is there a way for me to keep my directory the same name and still reference the CFC. I am going to guess that I have to change my local directory since the CFC is referenced as NASCAR.CFC.Queries? -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting changed fields from database using an audit table
Thanks Unfortunately, simply having the two tables joined doesn't help. The issue isn't getting the correct data, it's simply that to get the output I need, I have to loop over each column in each record to see which column has been updated in a given time period, and output the info about that column. USERS has a single lastupdated column, just so we know when it was updated. USER_UPDATED has most of the same columns as USERS, but each column just holds a date stamp of the last time the corresponding field was updated in USERS The data looks something like this: USERS: UserIDFirstnameLastname ------ 1 John Doe 2 JaneSmith USER_UPDATE: UserIDFirstnameLastname ---- --- 1 07/08/2005 10/31/2006 2 05/10/20067/15/2006 The output I am looking for is this, given an input date of 01/01/2006: UserID FieldNameValue --- --- --- 1 Lastname Doe 2 Firstname Jane 2 Lastname Smith The code produces the exact output I need, so the basic logic is fine (if not as fast as I need it to be). The queries run in a few milliseconds, so they aren't the bottleneck. It's the looping through each column in each record of the resultset to check the updated date of each field when it's 12000 records x 89 columns that's the bottleneck. -Original Message- From: Richard Kroll [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 1:26 PM To: CF-Talk Subject: RE: Getting changed fields from database using an audit table In a SQL query without the dynamic column list, is this what you are trying to achieve? SELECTu.id FROM users u INNER JOINusers_updated up ON u.id = up.id AND up.lastupdated = cfqueryparam cfsqltype=cf_sql_date value=#since# WHERE u.id IN ( SELECT id FROMUSER_UPDATE up1 WHERE u.cola up1.cola OR u.colb up1.colb OR u.colc up1.colc OR etc etc ) Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
GoDaddy Hosting Issue
If anyone plans on using GoDaddy for CF hosting, be careful There are some tags that they do not suport, like CFDUMP. I have in my Application.cfc a cftry-catch block that does a query on a table on only the first row to make sure that there is a connection to the database, and if not it throws a friendly error message to the user and sends me an email. I am dumping the information into the mail. Well it works fine on my test server but gives me a java.lang error message. I checked their support site for this and there is nothing there. So I am assuming they do not support that tag just as they do not support CFOBJECT and some others. No big deal since I am not using CFOBJECT anyway, but it sucks that I cannot dump out variables and such if there is an error on the live site. -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GoDaddy Hosting Issue
that seems...odd. can you just throw a template up there with a cfdump var=#cgi# just for shits and giggles? On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: If anyone plans on using GoDaddy for CF hosting, be careful There are some tags that they do not suport, like CFDUMP. I have in my Application.cfc a cftry-catch block that does a query on a table on only the first row to make sure that there is a connection to the database, and if not it throws a friendly error message to the user and sends me an email. I am dumping the information into the mail. Well it works fine on my test server but gives me a java.lang error message. I checked their support site for this and there is nothing there. So I am assuming they do not support that tag just as they do not support CFOBJECT and some others. No big deal since I am not using CFOBJECT anyway, but it sucks that I cannot dump out variables and such if there is an error on the live site. -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GoDaddy Hosting Issue
I would look into this a little deeper. There would be no reason for a host to block cfdump. The cfobject tag I understand though. Just so you are aware Bruce, it is pretty common for hosts (not just GoDaddy) to block certain tags or take the route of implementing security sandboxes. Dan Vega http://www.danvega.org/blog On 1/9/07, Charlie Griefer [EMAIL PROTECTED] wrote: that seems...odd. can you just throw a template up there with a cfdump var=#cgi# just for shits and giggles? On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: If anyone plans on using GoDaddy for CF hosting, be careful There are some tags that they do not suport, like CFDUMP. I have in my Application.cfca cftry-catch block that does a query on a table on only the first row to make sure that there is a connection to the database, and if not it throws a friendly error message to the user and sends me an email. I am dumping the information into the mail. Well it works fine on my test server but gives me a java.lang error message. I checked their support site for this and there is nothing there. So I am assuming they do not support that tag just as they do not support CFOBJECT and some others. No big deal since I am not using CFOBJECT anyway, but it sucks that I cannot dump out variables and such if there is an error on the live site. -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GoDaddy Hosting Issue
OK. I was mistaken. The error seems to be with the onApplicationStart section of the Application.cfc. Funny thing is that it works on my laptop and testing server. More troubleshooting. Gotta love it. BTW, here is where you can see the error: www.dalethemovie.com/Offers On 1/9/07, Dan Vega [EMAIL PROTECTED] wrote: I would look into this a little deeper. There would be no reason for a host to block cfdump. The cfobject tag I understand though. Just so you are aware Bruce, it is pretty common for hosts (not just GoDaddy) to block certain tags or take the route of implementing security sandboxes. Dan Vega http://www.danvega.org/blog On 1/9/07, Charlie Griefer [EMAIL PROTECTED] wrote: that seems...odd. can you just throw a template up there with a cfdump var=#cgi# just for shits and giggles? On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: If anyone plans on using GoDaddy for CF hosting, be careful There are some tags that they do not suport, like CFDUMP. I have in my Application.cfca cftry-catch block that does a query on a table on only the first row to make sure that there is a connection to the database, and if not it throws a friendly error message to the user and sends me an email. I am dumping the information into the mail. Well it works fine on my test server but gives me a java.lang error message. I checked their support site for this and there is nothing there. So I am assuming they do not support that tag just as they do not support CFOBJECT and some others. No big deal since I am not using CFOBJECT anyway, but it sucks that I cannot dump out variables and such if there is an error on the live site. -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PostgreSQL vs. MSSQL
Jon, Thanks for the clarification. Matt On 1/9/07, Jon Clausen [EMAIL PROTECTED] wrote: On Jan 9, 2007, at 3:23 AM, Matt Quackenbush wrote: Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on Windows boxes? If so, what version(s) for both the db server and windows servers? Both. 8.2 for Postgres and 5.1 for MySQL.XP Pro and Server 2003 for the OS. Also, just to clarify on the case-sensitivity point you made, am I correctly understanding that the following query **typically** would not have any issues? cfquery SELECT my_field FROM my_table; /cfquery Even if the field was named as 'my_Field' (minus the quotes) in the database? Actually, the other way around. When you convert your tables over to Postgres, you'll have to lowercase them. Once again, though if you don't quote the table names in the script, Pg will automatically take care of lower casing that for you when you run the Create's. Then any queries you have with mixed case names for the table attributes will still run. If you uppercase any of the table/column names, you will have to quote them. HTH, Jon ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
Jochem, I was hoping that you would respond. I've seen a number of your posts regarding PostgreSQL, and certainly wanted your opinion. :-) We all know what opinions are like, which is why I didn't want to just take my friend's opinion as the end-all official truth. Thanks to you all, I believe that I'm going to give Postgre a shot and see how I like it myself. My intent is to have a dedicated db server (windows server 2003 - std ed.), which will run only the db. However, in a test/dev environment, I don't have that luxury. So, are there any issues that I need to be aware of when running on XP Pro along with IIS and CF 7.x in my dev environment? Thanks, Matt On 1/9/07, Jochem van Dieten [EMAIL PROTECTED] wrote: Matt Quackenbush wrote: Thanks for the reply. I forgot to post his specific gripes about it. Here is a quick summary: - non-standard sql I think that depends on what you call 'standard sql'. To me, standard SQL is what is defined in ISO/IEC 9075 and few do better then PostgreSQL in that respect. But if you take 'standard sql' to mean 'the SQL in product X', you may discover many differences. - difficult to backup / migrate What is difficult about scheduling pg_dumpall -f dumpfile? For migration he may have a point. PostgreSQL will not allow you to shut down the database, pack up the data files, put them on another machine and start up there. While this technically is possible in some circumstances, it is not a documented procedure because it is guaranteed not to work when you move from for instance Windows to an AIX mainframe. Other products that only run on limited platforms and do not have to worry about memory alignment and the endianness of the host operating system do not have this limitation. - user authenication is weak PostgreSQL allows the DBA to use anything from no authentication to Kerberos and you can even create single-signon with a Windows domain. User authentication is as weak as the DBA configured it to be. And if we extend this to security in general you might want to Google a bit. PostgreSQL is highly regarded for its security track record and is often an example to other databases. For instance, while many databases install themselves under an account with elevated privileges by default even when that is technically not necessary, PostgreSQL refuses to run if it has more permissions then it needs. - difficult to setup http://www.suite101.com/article.cfm/oracle/115560 - difficult to manage To manage PostgreSQL you need to do a few things that are clearly spelled out in the manual: http://www.postgresql.org/docs/8.2/static/maintenance.html http://www.postgresql.org/docs/8.2/static/backup.html Again I would have to ask what is so hard about setting up a scheduled task. In short: you may want to ask him if he is not confusing PostgreSQL with some other database. Your post was most informative, for sure. But there's one thing that you mentioned that I was unaware of that is pretty much an instant turn-off for me: cAsE sEnSiTiViTy. PostgreSQL identifiers are only case sensite if you make them case sensitive by enclosing them between double quotes. The following code will run just fine: CREATE TABLE fOo (BaR INTEGER); SELECT bAr FROM foo; Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GoDaddy Hosting Issue
So if I comment out the CFDUMP tag, then all works fine. If I put the #Arguments.Exeption# in a CFOUTPUT, I getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any thoughts? Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GoDaddy Hosting Issue
do what Charlie said.. just do something like cfset fooVar = Goo / cfdump var=#fooVar# / If that doesnt work, then it's a problem with Google. On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: So if I comment out the CFDUMP tag, then all works fine. If I put the #Arguments.Exeption# in a CFOUTPUT, I getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any thoughts? Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GoDaddy Hosting Issue
cfdump var=#arguments#? see if that works and if so, what it displays. should the variable be spelled exception (as opposed to exeption)? On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: So if I comment out the CFDUMP tag, then all works fine. If I put the #Arguments.Exeption# in a CFOUTPUT, I getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any thoughts? Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GoDaddy Hosting Issue
I did what Charlie said and it worked. So there is someting else wrong. I am working on it now. On 1/9/07, Greg Morphis [EMAIL PROTECTED] wrote: do what Charlie said.. just do something like cfset fooVar = Goo / cfdump var=#fooVar# / If that doesnt work, then it's a problem with Google. On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: So if I comment out the CFDUMP tag, then all works fine. If I put the #Arguments.Exeption# in a CFOUTPUT, I getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any thoughts? Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GoDaddy Hosting Issue
Thanks for the extra set of eyes Charlie. It works now. On 1/9/07, Charlie Griefer [EMAIL PROTECTED] wrote: cfdump var=#arguments#? see if that works and if so, what it displays. should the variable be spelled exception (as opposed to exeption)? On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: So if I comment out the CFDUMP tag, then all works fine. If I put the #Arguments.Exeption# in a CFOUTPUT, I getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any thoughts? Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GoDaddy Hosting Issue
So I need to retract the lack of support for CFDUMP. They do support it. CFOBJECT though they do not. Not a problem though really. GoDaddy is pretty good otherwise though. Inexpensive to host. The only complaint that I would have is lack of support for using Enterprise Manager on the SQL Server. You have to use their web client. I noticed though that a lot of sites are doing this. On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: Thanks for the extra set of eyes Charlie. It works now. On 1/9/07, Charlie Griefer [EMAIL PROTECTED] wrote: cfdump var=#arguments#? see if that works and if so, what it displays. should the variable be spelled exception (as opposed to exeption)? On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: So if I comment out the CFDUMP tag, then all works fine. If I put the #Arguments.Exeption# in a CFOUTPUT, I getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any thoughts? Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF and OOP - Controller
Rich, Thanks for the kick-ass reply. Somehow it got buried beneath the piles of email, and I just now saw it; sorry about that. Your post is most informative, and very helpful. As of a couple of days ago, being 6+ weeks behind on a project that I was going to run on my new framework has made me put it (framework development) on hold, and I picked up MG:U and began studying it. I have found precisely what you were saying to be true. By studying the MG:U framework, and by working with it, many more things (including controllers, traffic cops, etc) are becoming quite clear. And, like you said, by focusing more on the model itself, it's 1) alleviating most of the headaches, and 2) helping me understand the other portions s much better. Anyways, sorry for the delayed response! Back to my OO adventure for now :-) Thanks, Matt ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: capture a signature in a mobil web form
I'm not sure whether or not the 8125 has Flash, but if it does, you can capture the signature, save the bitmapData and convert it to an image with CF than save it to a DB. You'd have to be clear that the signature you get no matter the interface, won't be as good as one captured by pen. Cheers, !k -Original Message- From: Keith McGee [mailto:[EMAIL PROTECTED] Sent: Monday, January 08, 2007 10:13 AM To: CF-Talk Subject: capture a signature in a mobil web form Is there anyway to use the cingular 8125 to capture a signature in a mobil web form and transfer it into database via coldfusion? Thanks Keith ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Exam Certification Study Gruop
Same here, I am in NY, so definitly through the Adobe Connect, if that can get set up. A very good idea, by the way. On 1/3/07, Dan Vega [EMAIL PROTECTED] wrote: If you get connect setup I would defiantly be interested in attending as long as it doesnt conflict with current user group meetings! Dan On 1/3/07, Nicholas M Tunney [EMAIL PROTECTED] wrote: Would anyone be interested in attending a ColdFusion MX 7 Developer Certification http://www.adobe.com/support/training/certified_professional_program/cfmx7_developer.html exam study group^* ? There would be no cost to attend (unless we all chip in for pizza or something). I am thinking it would be a three night class located somewhere near Rockville/Bethesda MD (anyone who is willing to donate or suggest a location let me know!). We would be concentrating on the 4 primary sections of the Adobe ColdFusion MX 7 Developer exam http://www.adobe.com/support/training/certified_professional_program/cfmx7_developer.html (Application Development, Database Concepts, Client State Management and Data Exchange) as well as discussing common hang ups and testing techniques. If I can get this set up via Adobe Connect, I will extend the invitation to those not available to attend in person. If you are interested, please send me your contact information mailto:[EMAIL PROTECTED] or comment on this post. * - This is not an Adobe course -- Nicholas M Tunney Senior Software Architect, AboutWeb LLC - http://www.AboutWeb.com Certified Advanced ColdFusion MX 7 Developer Blog - http://www.nictunney.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF and OOP - Controller
Matt, Glad I could help. Good luck on your project and the OO adventure! Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Design Question.
I think this is a bit of an OOD type question. I'm developing a project for managing structured news content that is currently done with the separate tools for different type of news. I've created a front end I am fairly happy with that allows me to define the structure of each of the news types and a form for entering and editing the specific content is generated. I then see using a DAO concept for storing the content, currently in XML files. But I'm stuck in the middle on a Preview requirement that shows the content formatted as it will be displayed. The trouble I'm having is with taking the form data and structuring it. I envision this as a function of the DAO. Is this a good assumption? If it is, how do I use the DAO to structure the data for the preview step, before it is ready to be committed to data storage? Or is this more a function belonging to a different layer? Should I create a separate function to convert the form data to the storage structure? Do I do this once and send the converted data to the DAO for committing after the preview or send the unstructured form data to the DAO for formatting and storage? Is any of this understandable? -- 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cfqueryparam and Oracle
When I use CFQUERYPARAM with an Oracle database, I receive the error query not properly ended. ALWAYS use CFQUERYPARAM...it's not just for stopping SQL injection attacksit also increases query speed by using BIND variables (at least with Oracle and MS SQL Server.not Accessnot sure about mySQL). HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cfqueryparam and Oracle
When I use CFQUERYPARAM with an Oracle database, I receive the error query not properly ended. When I use CFQueryParam with several Oracle databases (8.x to 10g), it works exactly is it is supposed to. Maybe more details about your code and the exact error and we could help. -- 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PostgreSQL vs. MSSQL
Are you aware of anyone who currently runs MS SQL in case sensitive mode? I'd be curious to know how often that happens. Quite a few people do this, in my experience. You can specify different collations for each database within an instance. Collations determine other things in addition to case sensitivity. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
On 1/8/07 7:29 PM, Matt Quackenbush wrote: - non-standard sql It is different to SQL Server, but that doesn't mean that SQL Server is standard compliant either. In 8.x they've made many tweaks to make it even more standards compliant in its syntax, so please have him check his facts. - difficult to backup / migrate The backup seems straight forward using pg_dump, what were his specific issues? - user authenication is weak No it isn't, it just doesn't link into Active Directory :-P - difficult to setup No it isn't :-P - difficult to manage Both PGAdmin III and phpPgAdmin (latest betas) are great, and then there's the command-line tools, what else does he want? mentioned that I was unaware of that is pretty much an instant turn-off for me: cAsE sEnSiTiViTy. It depends on how you write your code, please RTFM: pages 26 and 27 or sections 4.1.2.1 and 4.1.2.2. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PostgreSQL vs. MSSQL
On 1/8/07 8:40 PM, Jacob Munson wrote: I agree, I think every database has some non-standard SQL. An example in MS SQL is the isNull() function, which is functionally equivalent to the ANSI standard coalesce(). Why did MS make their own? Now() vs GetDate(), etc. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting changed fields from database using an audit table
Doug, After seeing your intended output the query will need to change a bit, but I think I understand what you are after. Could you do something like this: (beware this SQL psudeo-code it's untested) declare @User_modify table( UserID int, FieldName nvarchar(50), NewValue nvarchar(50) ) declare @col sysname declare colList cursor local fast_forward for select COLUMN_NAME fromINFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'USER_UPDATED' open colList -- loop over the column list @col will hold the current column fetch next from colList into @col while (@@fetch_status = 0) begin -- insert matching records into the temp table insert into @User_Modify(UserId, FieldName, newValue) SELECT userid, @col, cast(@col as sysname) as newValue FROM users where @col cfqueryparam type=cf_sql_date value=#since# fetch next from colList into @col end close colList deallocate colList select * from @user_modify This way you could offload a lot of the processing onto the SQL server. HTH, Rich Kroll -Original Message- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 1:59 PM To: CF-Talk Subject: RE: Getting changed fields from database using an audit table Thanks Unfortunately, simply having the two tables joined doesn't help. The issue isn't getting the correct data, it's simply that to get the output I need, I have to loop over each column in each record to see which column has been updated in a given time period, and output the info about that column. USERS has a single lastupdated column, just so we know when it was updated. USER_UPDATED has most of the same columns as USERS, but each column just holds a date stamp of the last time the corresponding field was updated in USERS The data looks something like this: USERS: UserIDFirstnameLastname ------ 1 John Doe 2 Jane Smith USER_UPDATE: UserIDFirstnameLastname ---- --- 1 07/08/2005 10/31/2006 2 05/10/20067/15/2006 The output I am looking for is this, given an input date of 01/01/2006: UserID FieldNameValue --- --- --- 1 Lastname Doe 2 Firstname Jane 2 Lastname Smith The code produces the exact output I need, so the basic logic is fine (if not as fast as I need it to be). The queries run in a few milliseconds, so they aren't the bottleneck. It's the looping through each column in each record of the resultset to check the updated date of each field when it's 12000 records x 89 columns that's the bottleneck. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PostgreSQL vs. MSSQL
On 1/9/07 6:03 AM, Jochem van Dieten wrote: The only thing I miss in PostgreSQL is eager update-everywhere replication. There are commercial offerings for that, but all the community offerings are either lazy or master-slave. I'll second that, I read through the manual and instantly wanted to elope ;-) but the lack of more solid replication / clustering abilities are a bit limiting. At the very least you can start off with the basic system and migrate / upgrade to EnterpriseDB in the future if you need to, which'll give you more flexible replication support. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Design Question.
Ian, I hope I'm understanding you correctly; but I'm assuming you mean that the form data, taken together, essentially constitutes a record in your data source. If so, I think you want to use a transfer object that receives and carries that data along. While I'm not educated enough to give you a good explanation of transfer objects, value objects and beans, they can all provide an object that lets you move the data around. And you'll find lots of discussion of them on the CFC-DEV list, and on the lists for Model-Glue, Mach-II, Reactor, Transfer, et al. In your case, you'd need to place the form data into the transfer object (if it's a bean, it would have methods like getHeadline() and setHeadline(), for instance). Some frameworks like Model-Glue and Mach-II can populate these objects automatically as long as the form field names match the names in the bean. Once you have the object populated, you can do anything you want: you can save it to your database (by passing to a DAO), you can turn around and feed it to a page that displays a preview, or you can send it to an Edit form for revision. To answer your question a little further, yes, you would need another layer (or two) to handle the form data, populate the bean, then decide what to do with it. The DAO would just handle the INSERT or UPDATE when it was time to do so. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help with CFXML and Flash 8
I have a flash menu that is being dynamically created using an XML file with the navigation schema. The XML file is currently hard coded, but I would like to make the url path attributes dynamic so that I don't have to maintain two different xml files (one for my local environment and one for the remote). Is it possible to use the CFXML tag to generate XML markup and have Flash 8 treat that file as XML? Here is what the template would look like that would generate my XML: cfprocessingdirective suppresswhitespace=Yes cfcontent type=text/xml; charset=utf-8 cfxml variable=theXML cfloop ... menu name=navigation item name=#subname# link=#sublink# / /menu /cfloop /cfxml cfoutput#ToString(theXML)#/cfoutput /cfprocessingdirective The only apparent problem is that the file would have a .cfm extension and not a .xml extension, which I'm not sure if Flash will accept. Thanks in advance, Aaron ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JS and Radio Button Issue
I have a form that has two radio buttons. Their function is to show one of two hidden divs. The JS is this: script language=JavaScript function toggle('with', 'without') { if (document.getElementById) { withvbm= document.getElementById('with'); withoutvbm= document.getElementById('without'); } if (withvbm.style.display == none){ withvbm.style.display = ; withoutvbm.style.display = none; } else if (withoutvbm.style.display == none){ withoutvbm.style.display = ; withvbm.style.display = none; } } /script The radio buttons look like this: input type=radio name=VBM value=1 id=with onclick=toggle('with', 'without')WithBRBR input type=radio name=VBM value=2 id=without onclick=toggle('without', 'with')With Out And the divs look like this: div id='with' style=display:none; With vote by mail options here /div div id='without' style=display:none; without vote by mail options here /div When I click either button, I get an error that and Object is expected. The error is on the radio buttons. From what I can tell everything looks OK. Can anyone see any issues with this? Also, I tried changing the first div's style to display:block assuming that the page needed to see one of them and of it did not work, but then I though no, that cannot be it since I want both div's hidden until the user clicks one of the buttons. Thanks, -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JS and Radio Button Issue
few things i can see would be a problem. you have multiple elements with ids with and without (the radio buttons and the divs). the code below should work. script language=JavaScript function toggle(divToShow) { if (document.getElementById) { if (divToShow == with) { document.getElementById('withdiv').style.display = inline; document.getElementById('withoutdiv').style.display = none; } else { document.getElementById('withdiv').style.display = none; document.getElementById('withoutdiv').style.display = inline; } } } /script input type=radio name=VBM value=1 id=with onclick=toggle('with') / With br /br / input type=radio name=VBM value=2 id=without onclick=toggle('without') / Without br /br / div id=withdiv style=display:none; With vote by mail options here /div div id=withoutdiv style=display:none; without vote by mail options here /div On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: I have a form that has two radio buttons. Their function is to show one of two hidden divs. The JS is this: script language=JavaScript function toggle('with', 'without') { if (document.getElementById) { withvbm= document.getElementById('with'); withoutvbm= document.getElementById('without'); } if (withvbm.style.display == none){ withvbm.style.display = ; withoutvbm.style.display = none; } else if (withoutvbm.style.display == none){ withoutvbm.style.display = ; withvbm.style.display = none; } } /script The radio buttons look like this: input type=radio name=VBM value=1 id=with onclick=toggle('with', 'without')WithBRBR input type=radio name=VBM value=2 id=without onclick=toggle('without', 'with')With Out And the divs look like this: div id='with' style=display:none; With vote by mail options here /div div id='without' style=display:none; without vote by mail options here /div When I click either button, I get an error that and Object is expected. The error is on the radio buttons. From what I can tell everything looks OK. Can anyone see any issues with this? Also, I tried changing the first div's style to display:block assuming that the page needed to see one of them and of it did not work, but then I though no, that cannot be it since I want both div's hidden until the user clicks one of the buttons. Thanks, -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FarCry and TinyMCE issue
Jon, I actually lodged a bug report on sourceforge. This is the reply I got: IE:s selection gets lost sometimes if you focus another iframe inside thesame document. The inline popup plugin has this issue but it's resolvedusing the following method: Use the var b = inst.selection.getBookmark();and inst.selection.moveToBookmark(b); functions before and after a insert.It will store away the current selection and then restore it. Consult theAPI docs for details.I'm currently trying to apply this - but all attempts have failed so far. ;)Adrian ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Itext-Coldfusion Error
I am trying to use the iText with coldfusion to dynamically generate a PDF on the fly (cfdocument is way too limited). I have no problem setting the images at absolute positions, however when I try to set text at absolute positions using various methods, I get an error that says Class coldfusion.runtime.java.JavaProxy can not access a member of class com.lowagie.text.pdf.PdfWriter with modifiers protected.Does anyone have any insight on this? Need help desperately. Thanks! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting changed fields from database using an audit table
Thanks - I'll give that a try. -Original Message- From: Richard Kroll [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: 1/9/07 5:03 PM Subject: RE: Getting changed fields from database using an audit table Doug, After seeing your intended output the query will need to change a bit, but I think I understand what you are after. Could you do something like this: (beware this SQL psudeo-code it's untested) declare @User_modify table( UserID int, FieldName nvarchar(50), NewValue nvarchar(50) ) declare @col sysname declare colList cursor local fast_forward for select COLUMN_NAME fromINFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'USER_UPDATED' open colList -- loop over the column list @col will hold the current column fetch next from colList into @col while (@@fetch_status = 0) begin -- insert matching records into the temp table insert into @User_Modify(UserId, FieldName, newValue) SELECT userid, @col, cast(@col as sysname) as newValue FROM users where @col cfqueryparam type=cf_sql_date value=#since# fetch next from colList into @col end close colList deallocate colList select * from @user_modify This way you could offload a lot of the processing onto the SQL server. HTH, Rich Kroll -Original Message- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 1:59 PM To: CF-Talk Subject: RE: Getting changed fields from database using an audit table Thanks Unfortunately, simply having the two tables joined doesn't help. The issue isn't getting the correct data, it's simply that to get the output I need, I have to loop over each column in each record to see which column has been updated in a given time period, and output the info about that column. USERS has a single lastupdated column, just so we know when it was updated. USER_UPDATED has most of the same columns as USERS, but each column just holds a date stamp of the last time the corresponding field was updated in USERS The data looks something like this: USERS: UserIDFirstnameLastname ------ 1 John Doe 2 Jane Smith USER_UPDATE: UserIDFirstnameLastname ---- --- 1 07/08/2005 10/31/2006 2 05/10/20067/15/2006 The output I am looking for is this, given an input date of 01/01/2006: UserID FieldNameValue --- --- --- 1 Lastname Doe 2 Firstname Jane 2 Lastname Smith The code produces the exact output I need, so the basic logic is fine (if not as fast as I need it to be). The queries run in a few milliseconds, so they aren't the bottleneck. It's the looping through each column in each record of the resultset to check the updated date of each field when it's 12000 records x 89 columns that's the bottleneck. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JS and Radio Button Issue
Thanks Charlie. That did it. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 4:20 PM To: CF-Talk Subject: Re: JS and Radio Button Issue few things i can see would be a problem. you have multiple elements with ids with and without (the radio buttons and the divs). the code below should work. script language=JavaScript function toggle(divToShow) { if (document.getElementById) { if (divToShow == with) { document.getElementById('withdiv').style.display = inline; document.getElementById('withoutdiv').style.display = none; } else { document.getElementById('withdiv').style.display = none; document.getElementById('withoutdiv').style.display = inline; } } } /script input type=radio name=VBM value=1 id=with onclick=toggle('with') / With br /br / input type=radio name=VBM value=2 id=without onclick=toggle('without') / Without br /br / div id=withdiv style=display:none; With vote by mail options here /div div id=withoutdiv style=display:none; without vote by mail options here /div On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: I have a form that has two radio buttons. Their function is to show one of two hidden divs. The JS is this: script language=JavaScript function toggle('with', 'without') { if (document.getElementById) { withvbm= document.getElementById('with'); withoutvbm= document.getElementById('without'); } if (withvbm.style.display == none){ withvbm.style.display = ; withoutvbm.style.display = none; } else if (withoutvbm.style.display == none){ withoutvbm.style.display = ; withvbm.style.display = none; } } /script The radio buttons look like this: input type=radio name=VBM value=1 id=with onclick=toggle('with', 'without')WithBRBR input type=radio name=VBM value=2 id=without onclick=toggle('without', 'with')With Out And the divs look like this: div id='with' style=display:none; With vote by mail options here /div div id='without' style=display:none; without vote by mail options here /div When I click either button, I get an error that and Object is expected. The error is on the radio buttons. From what I can tell everything looks OK. Can anyone see any issues with this? Also, I tried changing the first div's style to display:block assuming that the page needed to see one of them and of it did not work, but then I though no, that cannot be it since I want both div's hidden until the user clicks one of the buttons. Thanks, -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looking for Ray Camden's Application.cfc breezo
I'm trying to find the excellent breeze presentation Ray Camden gave on Application.cfc - there's someone at my client's office i'd like to see it.Today it seems, google is NOT my friend because i can't bring up any reference to it. Can anyone point me at the recording of Ray's presentation please? (I have the files downloaded from Ray's blog but can't see a reference to the breezo there either) -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JS and Radio Button Issue
Indeed, by their very nature you should not have dupe ids on a page. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Charlie Griefer To: CF-Talk Sent: Wed Jan 10 00:19:47 2007 Subject: Re: JS and Radio Button Issue few things i can see would be a problem. you have multiple elements with ids with and without (the radio buttons and the divs). the code below should work. script language=JavaScript function toggle(divToShow) { if (document.getElementById) { if (divToShow == with) { document.getElementById('withdiv').style.display = inline; document.getElementById('withoutdiv').style.display = none; } else { document.getElementById('withdiv').style.display = none; document.getElementById('withoutdiv').style.display = inline; } } } /script input type=radio name=VBM value=1 id=with onclick=toggle('with') / With br /br / input type=radio name=VBM value=2 id=without onclick=toggle('without') / Without br /br / div id=withdiv style=display:none; With vote by mail options here /div div id=withoutdiv style=display:none; without vote by mail options here /div On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: I have a form that has two radio buttons. Their function is to show one of two hidden divs. The JS is this: script language=JavaScript function toggle('with', 'without') { if (document.getElementById) { withvbm= document.getElementById('with'); withoutvbm= document.getElementById('without'); } if (withvbm.style.display == none){ withvbm.style.display = ; withoutvbm.style.display = none; } else if (withoutvbm.style.display == none){ withoutvbm.style.display = ; withvbm.style.display = none; } } /script The radio buttons look like this: input type=radio name=VBM value=1 id=with onclick=toggle('with', 'without')WithBRBR input type=radio name=VBM value=2 id=without onclick=toggle('without', 'with')With Out And the divs look like this: div id='with' style=display:none; With vote by mail options here /div div id='without' style=display:none; without vote by mail options here /div When I click either button, I get an error that and Object is expected. The error is on the radio buttons. From what I can tell everything looks OK. Can anyone see any issues with this? Also, I tried changing the first div's style to display:block assuming that the page needed to see one of them and of it did not work, but then I though no, that cannot be it since I want both div's hidden until the user clicks one of the buttons. Thanks, -- Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need CF 5 Studio studio media
I've done a global search/replace with eclipse many times, but it has to be within a project, not within an arbitrary filesystem. Russ -Original Message- From: RobG [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 27, 2006 2:27 PM To: CF-Jobs-Talk Subject: Re: Need CF 5 Studio studio media Wish I could help you, but maybe this is a time to suggest you take a look at Eclipse. I switched to Eclipse about 6 mos ago and haven't looked back. The ONLY thing Eclipse doesn't do (at least as far as I can tell), that CFStudio/Homesite does, are global search/replace through a filesystem. That's why I keep an old copy of CFStudio 4.5.2 around... Rob Dick Price wrote: Looking for CD containg CF 5 Studio. Can download or pay $$ too get CD copied and sent to me. Someone sat on my copy and backup copy was flawed... Thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3225 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Coldfusion Jobs:DEV89467: Sr. Application Developer: Detroit, MI (2positions)
Greetings! My name is Raj I am a technical recruiter for ICONMA and have the following position requirement with our direct client. Pl let me know your interest in the following position and pl call me 1 888 309 7572 (24x7)for any info you may need. Please e-mail your resume to [EMAIL PROTECTED] with your expectations. Please find the requirement details as follows: Best regards Raj Muppalla Corporate Recruiter ICONMA Offices in CA, CT, GA, NY/NJ, MI, VA/DC/MD Tel: (888) 309-7572 ; Alt: (770) 239 1790 ; Fax: (800) 489-8046 e-mail: [EMAIL PROTECTED] ; www.iconma.com DEV89467: Sr. Application Developer: Detroit, MI Location: Detroit, MI Duration: 3 months Description/ Required Skills: - The candidate will work with our team supporting a customer base that uses the Business User Development (BUD) system as well as the Voice Interactive Data System (VIDS). - The candidate will also be responsible for supporting and improving the infrastructure that supports these systems. Languages: - Proficient in: ColdfusionMX, HTML, HTML Forms, SQL, JavaScript, Dreamweaver, Frontpage - Familiar with: CSS, XML, JavaScript, ActionScript, Fireworks and Photoshop to document a process support/customer service skills Other: - Development: Fireworks, Dreamweaver, Flash Professional - Methodologies: Fusebox 3 - Database: SQL Server 2000 and Access - Platforms: Windows 2000, Windows XP, IIS 5 - Demonstrated ability to develop, document and support processes in a customer service-driven environment Qualifications ââ¬â Preferred Skills: - Knowledge of database technologies. - Knowledge of Windows Installer technologies and processes - Knowledge of NT and UNIX administration - Familiarity with client-server concepts and the SDLC. - Five to seven years experience supporting a web environment. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3226 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: Coldfusion Jobs:DEV89467: Sr. Application Developer: Detroit, MI (2positions)
Hi Raj, Do you prefer people from India? Regrads, Glence -Original Message- From: Raj Muppalla [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 6:05 AM To: CF-Jobs-Talk Subject: Coldfusion Jobs:DEV89467: Sr. Application Developer: Detroit, MI (2positions) Greetings! My name is Raj I am a technical recruiter for ICONMA and have the following position requirement with our direct client. Pl let me know your interest in the following position and pl call me 1 888 309 7572 (24x7)for any info you may need. Please e-mail your resume to [EMAIL PROTECTED] with your expectations. Please find the requirement details as follows: Best regards Raj Muppalla Corporate Recruiter ICONMA Offices in CA, CT, GA, NY/NJ, MI, VA/DC/MD Tel: (888) 309-7572 ; Alt: (770) 239 1790 ; Fax: (800) 489-8046 e-mail: [EMAIL PROTECTED] ; www.iconma.com DEV89467: Sr. Application Developer: Detroit, MI Location: Detroit, MI Duration: 3 months Description/ Required Skills: - The candidate will work with our team supporting a customer base that uses the Business User Development (BUD) system as well as the Voice Interactive Data System (VIDS). - The candidate will also be responsible for supporting and improving the infrastructure that supports these systems. Languages: - Proficient in: ColdfusionMX, HTML, HTML Forms, SQL, JavaScript, Dreamweaver, Frontpage - Familiar with: CSS, XML, JavaScript, ActionScript, Fireworks and Photoshop to document a process support/customer service skills Other: - Development: Fireworks, Dreamweaver, Flash Professional - Methodologies: Fusebox 3 - Database: SQL Server 2000 and Access - Platforms: Windows 2000, Windows XP, IIS 5 - Demonstrated ability to develop, document and support processes in a customer service-driven environment Qualifications âââ‰â¬Å Preferred Skills: - Knowledge of database technologies. - Knowledge of Windows Installer technologies and processes - Knowledge of NT and UNIX administration - Familiarity with client-server concepts and the SDLC. - Five to seven years experience supporting a web environment. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3227 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11