CFLAP extensionAttribute1 comma
Hello, I have a need to add staff title's to the extensionAttribute1 field in Active Directory. I found that titles that contain commas cause an error. I have tried to escape the comma using \, and even \\, but no dice. The CFLDAP code looks like this: cfldap server=#AD.server# username=#AD.username# password=#AD.password# port=#AD.port# action=modify modifytype=replace dn=#AD.dn# attributes=extensionAttribute1=Director, Information Technology / Please ad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: contentsubtype issue
Well so much for that, apparently not related as I tested this same thing on a local box that didn't have the hotfix with the same result. These machines are all on the University Network so I suspect it's something that might have been pushed out via a policy somewhere. sigh Thanks for the tip though. Bob -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, February 07, 2012 8:54 PM To: cf-talk Subject: Re: contentsubtype issue it could be something to do with commons-fileupload-1.2.jar which was updated in that hotfix. you could try rolling this back to previous version and see if that helps. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
contentsubtype issue
Hoping somebody here has run into this or can shed some light on a issue I just encountered with a upload tool that's been working without fail for the longest time; that is until last week. It looks like CF is seeing the contentSubType on a pdf form that gets uploaded as XM and it uploads but errors out. I'm guessing this should be seeing it as XML and not XM? I don't exactly when the last time was that this worked but the hotfix here http://kb2.adobe.com/cps/918/cpsid_91836.html was applied a short time ago. I suspect this might be related but honestly I'm just guessing. Has anyone out there run into this before or can somebody shed some light here for me please? TIA Bob Imperial043 Macnider Hall, CB 7005 Application SpecialistUNC Chapel Hill, NC 27599 Department of Medicine (919) 843-6151 DOM-IS Helpline: 919.843.2331 Support: http://medicine.med.unc.edu/dom-is-support ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Upgraded from CFMX7 to CF9
Hello folks, I recently upgraded 2 servers we have here to CF9 from CFMX7 and noticed the CFMX7 was left installed. Are there any issues I might run into uninstalling the earlier version before I pull the trigger here? Better safe than sorry. Thanks! [cid:image001.gif@01CB2DAB.47FFE000] Bob Imperial125 Macnider Hall, CB 7005 Application SpecialistUNC Chapel Hill, NC 27599 Department of Medicine (919) 843-6151 DOM-IS Helpline: 919.843.2331 Support: http://medicine.med.unc.edu/dom-is-support ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335777 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
upgraded to 9 standard from cfmx 7
Hi folks, I recently upgraded a couple of our windows 2003 servers from CFMX 7 to 9 and noticed in the services window to see both 7 and 9 running, is this something that I will need to disable or uninstall? Seems added weight on the box but I do not know enough about it to proceed one way or the other. I noticed this after an issue with receiving duplicate email notices for a scheduled task that runs nightly on one of the boxes. I've stopped the 7 instance to see if this affects 9 running properly and it appears to be serving up cf pages just fine. Can someone shed some light on what should be done with this or point me in the right direction on what to do with this? Thanks! Bob ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfdpfform checkboxes
Hi folks, Can anyone shed some light on how to set a checkbox to checked in a pdfform? I've just started playing with populating a existing pdfform using cfpdfform source=MyPDF.pdf overwrite=yes action=populate and query data (what a time saver). I've googled the checkbox deal but no love here yet. Anyone?? Thanks! Bob ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfdpfform checkboxes
Ok after putzing around with some conditional logic just before the checkboxes I was able to get them checked using On/Off :-). Bob -Original Message- From: Imperial, Bob [mailto:bob_imper...@med.unc.edu] Sent: Thursday, February 18, 2010 10:47 AM To: cf-talk Subject: cfdpfform checkboxes Hi folks, Can anyone shed some light on how to set a checkbox to checked in a pdfform? I've just started playing with populating a existing pdfform using cfpdfform source=MyPDF.pdf overwrite=yes action=populate and query data (what a time saver). I've googled the checkbox deal but no love here yet. Anyone?? Thanks! Bob ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dealing With Spiders/Bots/Crawlers
I'm at an odd crossroads here. Up until now, I've kept my application off-limits to search engines. I've used a couple of techniques found on Ben Nadel's blog for giving them short sessions and such. Been working well. With respect to human users, I've been VERY diligent about using URLSessionFormat to keep session variables across page requests with cookies disabled. Also been working well. So here's my quandary - I now want open up my application to allow search engines to index. However, I've got session variables embedded everywhere in my URLs due to URLSessionFormat()! So what's going to occur is this: the robots will grab all of these URLs, index them, then pass them as hijacked sessions through their results and I won't be able to track new visitors! I just ran across a recent mention by Michael Dinowitz of a technique for setting CFID and CFToken to 1 whenever it's a bot, mentioned here: http://www.anujgakhar.com/2010/01/26/what-is-the-best-way-to-deal-with-spidersbotscrawlers/ Bottom line: how can I make the URLs NOT pass the session management variables when it's a search engine? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dealing with Spiders/Bots/Crawlers
I'm at an odd crossroads here. Up until now, I've kept my application off-limits to search engines. I've used a couple of techniques found on Ben Nadel's blog for giving them short sessions and such. Been working well. With respect to human users, I've been VERY diligent about using URLSessionFormat to keep session variables across page requests with cookies disabled. Also been working well. So here's my quandary - I now want open up my application to allow search engines to index. However, I've got session variables embedded everywhere in my URLs due to URLSessionFormat()! So what's going to occur is this: the robots will grab all of these URLs, index them, then pass them as hijacked sessions through their results and I won't be able to track new visitors! I just ran across a recent mention by Michael Dinowitz of a technique for setting CFID and CFToken to 1 whenever it's a bot, mentioned here: http://www.anujgakhar.com/2010/01/26/what-is-the-best-way-to-deal-with-spidersbotscrawlers/ Bottom line: how can I make the URLs NOT pass the session management variables when it's a search engine? Bob Hendren President/CEO ListingWare, Inc. http://www.listingware.com 800-867-4707 bhend...@listingware.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dealing With Spiders/Bots/Crawlers
First, sorry for dual post earlier. Second, not a stupid question about cookies, but just trying to deal with the possibility that a user has cookies turned off. I'm using URLSessionFormat on all of my links to pass their session info around so the system isn't constantly treating them like a new user. By the way, I say MY application because I wrote it, but it's a service we provide as a plugin to other websites. So, we have to try and make things as open as possible for all of my users' users. This may be a stupid question, but are cookies really not an option for your site users? I would only be passing session ids around the URL as a last resort. I mean, it _is_ 2010 and cookies are kind of the standard for maintaining session. (Note: they preclude the necessity of putting session info in all your URLs) There are other pitfalls with placing the session IDs in every URL other than bot traffic: http://kb2.adobe.com/cps/172/tn_17255.html ~Brad Bottom line: how can I make the URLs NOT pass the session management variables when it's a search engine? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Turning spaghetti code into properly indented code easily
Hey CF Developers -- Just a quick heads up that I have created a product that will easily take someone else's malformed, ugly code and turn it into a thing a beauty in a matter of seconds. My HTML Formatter (with CF Support) fixes any HTML/CFML files in less than a second and can be run against entire directories of code. It works easily with your favorite IDE (CFEclipse, Eclipse, Dreamweaver, Homesite, etc) and will literally save you hours of debugging time by formatting code so logic is easy to understand and will tell you when you are missing tags (this one really saves you on the debugging front). You can check out the product at http://www.logichammer.com There is a screencast on the site so you can see how easy it is to use and see the entire list of features. Some real quotes from users: - not what i expected... even simpler! it is a self-executing file (no installation) and it has virtually no interface. Configuration is easy and done within a single .ini text file. This thing is awesome. I just ran a huge directory - an entire CF application . It took about 20 seconds and the report showed where there might have been any missing tags (just a few). Now all of the code is neatly indented, whitespace removed, comments aligned just right... that single use was worth the price, easy! I'm offering House Of Fusion users a discounted price for the next week so if you hit this URL when you are ready to buy, you will get the reduced price: http://www.logichammer.com/html-formatter/houseOfFusion.php Enjoy! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion Client Variables - HITCOUNT
Here's an oldie but a goodie: I long ago drank the Kool-Aid on Client variables being stored in a DB and disabling global client variable updates. No problems there. But I'm just wondering when exactly are HITCOUNT and LVISIT updated in this situation? Is it on the first page of a return visit? If so, exactly how does CF determine a 'return' visit? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion Client Variables
Here's an oldie but a goodie: I long ago drank the Kool-Aid on Client variables being stored in a DB and disabling global client variable updates. No problems there. But I'm just wondering when exactly are HITCOUNT and LVISIT updated in this situation? Is it on the first page of a return visit? If so, exactly how does CF determine a 'return' visit? -- Bob Hendren President/CEO ListingWare, Inc. Phone/Fax: 800.867.4707 Email: bhend...@listingware.com http://smartcall.me/bobhendren ListingWare Support: supp...@listingware.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325968 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eliminating repeated data in CFoutput field
Thanks guys, some useful tips that led me to this ... http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets.cfm CFquery name=qEmpAssets datasource=bs3578 SELECT concat(e.firstname, ' ', e.lastname) AS eName, LEFT(a.assetdescription,30) AS aTitle, c.assetcategory AS cCategory FROM employees e INNER JOIN assets a ON e.employeeID = a.employeeID INNER JOIN assetcategories c ON a.assetcategoryID = c.assetcategoryID ORDER BY e.lastname /CFquery table tr th width=20% Name /th th width=30% Asset /th th width=30% Category /th /tr tr CFset LastEmp = * CFoutput query=qEmpAssets CFif VARIABLES.LastEmp IS NOT trim(qEmpAssets.eName) CFset VARIABLES.LastEmp = trim(qEmpAssets.eName) CFelse CFset #qEmpAssets.eName# = /CFif td #qEmpAssets.eName# /td td #aTitle# /td td #cCategory# /td /tr /CFoutput /table from this output, I would like to eliminate repeated names eName aTitle cCategory Doug Briggs HP Omni 510Notebook PC Nick Heap IBM Netfinity Server Desktop PC Nick Heap HP Omni 510Notebook PC Nick Heap Motorola T60Mobile Phone Audrey Ibbotson Toshiba Satelite XL Notebook PC Karen Kear Viglen 733 Desktop PC Karen Kear HP Omni 510 Notebook PC Office Manager HP LaserJet XLLaser Printer Office Manager Epson Phaser Laser Printer Glyn Martin Toshiba Tecra 8000Notebook PC Glyn Martin Nokia 7650 Mobile Phone Bluetooth I am trying to use a variable LastEmp and CFif CFset but the output is just the same as the original. My script is ... table tr th Name /th th Asset /th th Category /th /tr tr CFoutput query=qEmpAssets CFif VARIABLES.LastEmp IS eName CFset eName = ' ' CFelse CFset VARIABLES.LastEmp = eName /CFif td #eName# /td td #aTitle# /td td #cCategory# /td /CFoutput /tr /table Am in anyway close to achieving it ? -- I am using the free version of SPAMfighter. We are a community of 6 million users fighting spam. SPAMfighter has removed 12747 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320686 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 sourceless deployment tool
@James I don't think such tools exist for PHP , only for Java and .NET applications. but i didn't mention PHP cause it has them ... just to point out how much i prefer CF over other popular languages , and would like to see it as capable in terms of Deployment as it is in other areas . @Peter extension manager , would be great if it was supported by Adobe .  From: James Holmes james.hol...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, March 2, 2009 9:55:23 AM Subject: Re: CF sourceless deployment tool Can you point out the tools available for PHP that fulfill these criteria so we can compare? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/2 Bob sol_xp...@yahoo.com: Why isnât there a tool to help deploy (compile and obfuscate) coldfusion applications??? Cfencrypt is not secure or practical since you can decrypt and deployment is a mess. Cfcompile is not secure or practical since you can decompile into servlets and deployment is a mess ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319987 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF sourceless deployment tool
Hello , Every developer who uses Coldfusion gets addicted to itâs power ! I am one of those developers who develop apps in PHP/JSP/.NET and other languages But I always prefer CF and enjoy using it , that being said , brings the reason for my Question : Why isnât there a tool to help deploy (compile and obfuscate) coldfusion applications??? Cfencrypt is not secure or practical since you can decrypt and deployment is a mess. Cfcompile is not secure or practical since you can decompile into servlets and deployment is a mess. I agree with Jason Delmore, When all you want is a wiki or a blog... all you want to do is check a box and have it work. I think we need to make applications in general easier to install. No offense to Ray Camden, BlogCFC is a very cool app, but it should only take me 1 minute to install and I shouldn't need to understand the slightest bit about how the code works! Adobe, along with the community, needs to work on a standard method for installing and managing applications that is flexible enough to support all the different ways of creating applications... but consistent enough to just work. http://www.cfinsider.com/index.cfm/2007/11/1/Key-Market-Trends-Surrounding-ColdFusion as a developer i ask , what is the best practice to neatly and securely deploy a CF application ? your feedback and suggestions are highly appreciated . regards Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319983 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflayout annoying issue
I think what you need is as follows : html head /head body leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0 marginwidth=0 marginheight=0 cflayout name=outerlayout type=vbox style=height:100%; cflayoutarea style=height:15%; background-color:##FFCCFF h3header/h3 /cflayoutarea cflayoutarea style=height:80%; cflayout name=thelayout type=border cflayoutarea position=left This is text in layout area 2: leftbr / You can close and collapse this area. /cflayoutarea cflayoutarea position=center This is text in layout area 3: centerbr / /cflayoutarea cflayoutarea position=right This is text in layout area 4: rightbr / You can collapse this, but not close it.br / It is initially collapsed. /cflayoutarea /cflayout /cflayoutarea cflayoutarea style=height:5%; background-color:##FFCCFF CENTERfooter/CENTER /cflayoutarea /cflayout /body /html regards Bob From: MS madsy...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, February 18, 2009 12:41:43 AM Subject: cflayout annoying issue Hi all Quick cflayout question. I have a normal layout (positions = TOP, LEFT, CENTER, RIGHT, BOTTOM) page. Problem: if the center inside the CENTER cflayoutarea is larger than the screen, I'm getting a scroll bar just in that CENTER cflayoutarea. Instead, the whole page should expand to accommodate the height of CENTER. I tried playing with height:100% everywhere and I can't do the trick. cflayout cflayoutarea position=top Top /cflayoutarea cflayoutarea position=left Left /cflayoutarea cflayoutarea position=center BIG CONTENT (in height) BIG CONTENT (in height) BIG CONTENT (in height) ** I want this to expand and cause scrollbars to appear on the whole page, not just on this DIV /cflayoutarea cflayoutarea position=right Right /cflayoutarea /cflayout Hope it makes sense. Cheers, MS ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
You never did clarify if by flat file you mean text file? Yes, you are correct about that, sorry. I mean a delimited text file. Specifically, I am precluded from installing any database, including using access database files. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flat File as a Database?
Hello everyone, I have a need to build a site which will not have access to a database. Instead, the client has specified that I must use a flat file. On this flat file, I need to be able insert, update, and select Honestly, I don't even know where to start. Anyone have any idea how to go about this? Is there a udf or cfc out there that would help me? Thank you for your time. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flat File as a Database?
Why can't you use a database? Is the client just being an idiot, or is there a legitimate reason for it? If you're on CF8 or Railo, you can serialize/deserialize your query objects, so you could store the data as a flat CFML/JSON file, but act on it using Query of Queries. But first I would explore why you apparently can't use a database. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flat File as a Database?
Thanks all for the replies. It sounds like some of you are in a position to fire clients. But since I get paid by the job, I can't just do that. Maybe someday, but not today. Besides, the client is not an idiot. I'm sorry, I can't go into detail about the reasons why we are limited to a flat file. But the reasons are legitimate, and cannot be circumvented. Absolutely no database can be installed. It is what it is. Yes, I get that if I can find a solution here, the flat file will be effectively a database. But hey, it's all about meeting the criteria. And a flat file absolutely will do just that. As far as what we need to accomplish, it is nothing more than basic CRUD via web forms with data download capabilities. Nothing fancy. No interface to other applications or products. Just simple CRUD on a stand-alone application. Gerald, I had not thought of ODBC text file thing. I have seen it over the years, but never messed with it. I'll look into that, thanks. Nitai, H2 looks interesting, but I can't use it here. Thanks anyway. Peter, I did reply to you earlier (from the house of fusion website). Not sure what happened. Basically, I said that all I had available to me was CF7. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flat File as a Database?
Hi Kym, thanks for the reply. Very good question. The criteria is really No Database. There is more detailed and specific language than that, but it pretty much sums it up. As you pointed out, a filesystem is certainly a database, of sorts. I have been pondering it. It seems a bit messy though. Still, it is my fall-back plan, if I can't get find a flat file solution. But, it is not my preference. We expect not more than ten thousand entries. Likely not more than a few thousand. I would not want to risk keeping the data in memory, with periodic writes to disc. Not with this project. Thanks again. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Express ... Syntax error - CFQUERY - UPDATE Options
Can anyone tell me exactly what is causing this error ? !---Update using a CFQUERY with SQL UPDATE --- CFquery NAME=qUpdate DATASOURCE=learncfe!--- error --- UPDATE GuestBook SET (GuestName = '#Form.GuestName#', Email = '#Form.Email#', FirstVisit = #Form.FirstVisit#, GotHere = '#Form.GotHere#', Rating = '#Form.Rating#', Comments = '#trim(Form.Comments)#') WHERE GuestBook_ID = #Form.GuestBook_ID# /CFquery ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (43:5) to (43:88). Date/Time: 12/28/08 12:20:44 Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 Remote Address: 127.0.0.1 HTTP Referer: http://localhost/tt380/GuestMaint.cfm?op=ugid=1 Template: c:\inetpub\wwwroot\tt380\GuestUpdate.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion 8 developer edition installation issue
I posted something here last week about this but never saw any response to my post. I'm thinking maybe the subject line may have thrown some off so I'm posting the issue again here in hopes I can get this resolved as it's driving me nuts trying to get CF8 installed. This is CF 8 developer edition and I am trying to install it on a new box I have running Vista Ultimate. When I try to run the installation the package makes it to 99% extraction then bombs out with Windows error 216 occurred while loading the Java VM and never makes any further. I did google this and found this bit here http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1catid=2threadid=1381512enterthread=y . According to the couple of posts I found there supposedly installing Java SE was the path they took but they really weren't very specific about which Java SE package was needed. This has me confused as I have the JDK 6 Update 7 w/NetBeans 6.1 installed and NetBeans installed and runs fine. Am I not installing the correct package to get this dog to install? Can anyone out there please enlighten me as to the specific java se package thats needed so I can get on with actually getting some work done. Thanks in advance! Bewildered Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion 8 developer edition installation issue
to be honest I don't know, I can tell you it has 4gig ram so from what I've read it's 64bit? Vista is new to me so I'm having to hunt for everything in this new UI. This was so much easier with an XP box. Is your Vista machine 32 bit or 64 bit? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion 8 developer edition installation issue
it's a 32bit and coldfusion-801-win64.exe is what I've been try to install, pulling down the correct version now. We'll see how it goes :) Thanks! -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2008 4:15 AM To: CF-Talk Subject: Re: Coldfusion 8 developer edition installation issue The standard computer properties will tell you what processor you are running, and what version of the OS. RMB on the my computer icon, select properties and you'll see the information you require. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Windows error 216 occurred while loading the Java VM
Hoping somebody can shed a little more light on this issue I'm having trying to install CF8 developer edition on Vista Ultimate. I googled it and found a tidbit about it here http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1catid=2threadid=1381512messid=5037067 and I've tried installing the following packages with no change and no install, only the error message. I don't know if I've just not hit the right Java SE package or what but any help would be greatly appreciated. jre-6u10-rc-windows-i586-p-iftw jdk-6u7-nb-6_1-windows-ml jxpiinstall TIA! Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Install Hangs on Installing Web Connectors
First install CF with the builtin webserver and verify that everything works correctly, then install the connectors from the command line with the verbose option to see some debug output. Thank you for the reply, Jochem. I can't find anywhere how to install the web connectors from the command line. Might you be able to point me in the right direction? The stand-alone install appears to work correctly. Thank you very much for your help! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Install Hangs on Installing Web Connectors
Hello again. I am sorry to re-post this, but I am at my wits end, and I have to get this server up tomorrow. Can anyone here please help me? -Bob Hello everyone. I am stuck and am hoping someone here can help. I am trying to install CF8 x64 on a Windows Server 2008 x64 box. Unfortunately, The installer hangs when trying to install the web connectors. Before the install, I disabled Windows' firewall. I also made sure that ISAPI Filters and IIS 6 Management Compatibility roles were installed. Anyone here know how to get through this? The deadline looms... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion Install Hangs on Installing Web Connectors
Hello everyone. I am stuck and am hoping someone here can help. I am trying to install CF8 x64 on a Windows Server 2008 x64 box. Unfortunately, The installer hangs when trying to install the web connectors. Before the install, I disabled Windows' firewall. I also made sure that ISAPI Filters and IIS 6 Management Compatibility roles were installed. Anyone here know how to get through this? The deadline looms... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mail problem
And there's only so much stupidity you can program for :) -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 4:30 PM To: CF-Talk Subject: Re: Mail problem Can people be this stupid? There is sadly no limit on how stupid people can get... If you need to see it for yourself, go work in retail for a weekend... =] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfpod overflow in IE
Good day! I'm having a problem with the cfpod tag in coldfusion 8 - seems to be an issue in IE only. When the pod contents exceed the pod's defined width, Firefox correctly maintains the width of the pod and adds a horizontal scroll bar to the bottom of the pod. IE, on the other hand, displays the full width of the content, causing the pod body to be wider than it should be (although the header maintains the defined width.) The culprit in IE appears to be the 'ypod' class on the 1st div that coldfusion generates - it has an inline style which includes an overflow: visible; attribute. If I change that in the generated code so that first div has overflow:auto and view with IE, it looks the way it should, i.e. it stays within the defined pod boundaries. Any ideas on how I can override this to get pods to display correctly in IE? Here is some sample coldfusion code that demonstrates the problem: this is a test of pod size cfpod name=test overflow=auto width=100 height=100 title=Test Pod div style=width:200px test - this is a test of a long line in a small pod /div /cfpod ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309382 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 help with restoring from .bak
Thanks for the quick reply Jochem, but after trying to run the following I get an error(see below) cfquery name=dorestore datasource=grandRounds RESTORE DATABASE [DCCRegistry] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\DCCRegistry_db_200806110200.BAK' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10 /cfquery Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. The error occurred in D:\WebNew\centers\dump.cfm: line 1 1 : cfquery name=dorestore datasource=grandRounds 2 : RESTORE DATABASE [DCCRegistry] 3 : FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\DCCRegistry_db_200806110200.BAK' Don't know if it makes any difference here but this MSSQL Server 2k and running CF Standard 7,0,2,142559 Any ideas? Bewildered Bob -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2008 2:34 PM To: CF-Talk Subject: Re: Need help with restoring from .bak Imperial, Robert wrote: Scrambling here trying to restore a db on a ms sql server and cannot connect with Enterprise Manager (another story). Is there a command line utility out there anywhere that will let me restore a db from a .bak file on a windows box? Or is there a way to do this from a CF query? TIA cfquery ... RESTORE DATABASE [database_name] FROM DISK = N'path_to_full_backup_file' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10 /cfquery Make sure you connect to a database that is not the one you are trying to restore. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error in url parameter
I don't think Gerald meant it as a solution but a step in identifying where there problem might be. You know it's being passed, I would check the db to see what datatype that field is to be sure of what it's expecting? Bob -Original Message- From: Shivhare Yogendra [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 3:14 PM To: CF-Talk Subject: Re: Error in url parameter I tried and below is the result so I do have values but error is still there struct FORM_ID 67 IO_MODE 1 KEY_ID 71241 KEY_TYPE VPMO_ID SBCUID dw4694 UIID 86972628 WINSIZE 1000x690 Â ThanksÂYogendra Shivhare Programmer Analyst INFOSYS TECHNOLOGIES Ltd. â?~Life is what happens when youâ?Tre making other plansâ?¦!â?T --- On Wed, 6/4/08, Gerald Guido [EMAIL PROTECTED] wrote: From: Gerald Guido [EMAIL PROTECTED] Subject: Re: Error in url parameter To: CF-Talk cf-talk@houseoffusion.com Date: Wednesday, June 4, 2008, 11:09 PM try this Put this before the cfquery and see if you are passing the correct URL vars. cfdump var=#url# cfabort On Wed, Jun 4, 2008 at 12:25 PM, Yogendra Shivhare [EMAIL PROTECTED] wrote: I am getting following error in my applicationElement FORM_ID is undefined in URL. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Best Coldfusion Formatters or Coldfusion Beautifiers
Hey there -- I'm wondering if other folks have recommendations for Coldfusion code formatters? When you inherit code from other folks and it isn't indented properly, it can be very hard to understand the flow of the page. I found the HTML Formatter which has ColdFusion support and works really well but am wondering what folks normally do in the situation? Do you spend a lot of time formatting the code? Here's the link if you are curious: http://www.logichammer.com/html-formatter/ Thanks, Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: digital signatures
Thanks Dave this is exactly the kind of kick-start I need on this as it is all new to me at this point. These utilities are running on windows server 2003 standard w/CF7 standard at the moment. I have full access to the box so this should help speed things along for me I would think. Currently I have 107 users/physicians using these utilities and I don't see that list getting much longer for now. Any suggested reading on this would help out here as well since I am so new to this, so anything you can recommend would be a good thing. Thanks! Bob PDF supports digital signatures to sign and certify documents. Certification prevents the document from being changed; if the document is changed, the certification breaks. Signing simply attests that the user with that certificate did in fact interact with that document at a specific time, providing nonrepudiation, etc. To use digital signatures, each signer will have to have a certificate installed locally. You can either purchase individual certificates for your users, or you can create a certificate infrastructure. Your certificate infrastructure can be completely internal, or it can be based upon a root certificate from a public certificate vendor like Verisign. If your certificate infrastructure doesn't have a public root certificate from a third-party vendor, you will be able to verify signatures within your organization, but when you pass a signed PDF to someone outside your organization the certificate will not verify for those external users - it'll still show the document as signed, but the signature itself will be unverifiable. If you have a Windows server infrastructure (AD, etc), you can add a certificate authority (CA) server to that fairly easily. This will allow you to generate and issue client certificates to all your users very easily. If you have a fairly small number of users, you could simply purchase individual certificates for them to use directly. These are about $20 per user per year. Verisign has a specific certificate product for PDF signing. You can build a server interface for programmatically signing PDFs using the Adobe LiveCycle ES rights management server. This can be integrated with other LiveCycle products to build a workflow process that includes digital signatures. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
Thanks to all for the replies. It really shockes me that a simple mechanism to change the timezone of a particular app was never added to CF. I'm sure this has been a problem for many over the years. Dave pointed me to a simple UDF that did the trick. Thanks Dave! Regarding the question about remembering to change the offset when we go back to standard time, I don't think this that is an issue, is it? As long as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right? Again, thanks all for your replies. Bob If you know of a bandage that doesn't need changing, please do share. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com SPAMTRAP] When applying a bandage over a 'wound' (beware, analogy here), you must be prepared to need change the bandage from time to time -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Have you ever read a book that changed your life? Go to: http://www.winninginthemargins.com Use PassKey: GoldenGrove You'll be glad you did. ::-Original Message- :: ::Sent: Monday, May 12, 2008 4:32 PM ::To: CF-Talk ::Subject: Re: Help! Can't I set a specific time zone for a CF App? [heur ::SPAMTRAP] :: ::Bobby Hartsfield wrote: :: You could store the time offset within an application variable then use ::that :: along with dateadd() within all of your dateformat and tiemformat calls :: throughout the application. :: ::what about DST changes? :: :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
Right: east coast server's offset of 4+1 = 5, the offset for the mid-west client. Well, actually it's -5, but you get the point. :) If you are getting the offset from the gettimezoneinfo(), that is the servers offset, not the remote locations offset. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com SPAMTRAP] Thanks to all for the replies. It really shockes me that a simple mechanism to change the timezone of a particular app was never added to CF. I'm sure this has been a problem for many over the years. Dave pointed me to a simple UDF that did the trick. Thanks Dave! Regarding the question about remembering to change the offset when we go back to standard time, I don't think this that is an issue, is it? As long as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right? Again, thanks all for your replies. Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help! Can't I set a specific time zone for a CF App?
Hi... I'm new here. I've been programming CF for a while but I have never come across this problem yet. I am really hoping someone here can help me. I built an application for a client in the mid-west, but serve it on a shared server on the east coast. The client wants all the times on the site to show in central time not eastern time. But I can't change the time on the server. And, I use time-math in so many places in this particular application. Isn't there some way to easily change the time zone of a particular application - like in the cfapplication or something? Surely I can't be the first person to deal with this problem! There must be an easy fix yes? Help? Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Accessing SSIS package
Happy Saturday! I created an SSIS package and deployed it to my SQL Server, but what I am trying to figure out is how to trigger it using ColdFusion. Do I need to create an SP or a trigger to do this? I know in the past with DTS packages we would use the CFOBJECT tag to invoke it. Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Accessing SSIS package
You should be able to run it using CFEXECUTE to run an app called DTEXEC.exe. Check out the docs here: http://msdn2.microsoft.com/en-us/library/ms162810.aspx --Bob Happy Saturday! I created an SSIS package and deployed it to my SQL Server, but what I am trying to figure out is how to trigger it using ColdFusion. Do I need to create an SP or a trigger to do this? I know in the past with DTS packages we would use the CFOBJECT tag to invoke it. Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303832 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 8.0.1 Update and CFMENU
I asked this over the weekend, but didn't see any responses. Anyone have ANY clues? Thanks! -- Bob Hendren President/CEO ListingWare, Inc. http://www.listingware.com 800-867-4707 x 706 [EMAIL PROTECTED] -Original Message- From: Bob Hendren [mailto:[EMAIL PROTECTED] Sent: Saturday, April 12, 2008 7:10 AM To: CF-Talk Subject: CF 8.0.1 Update and CFMENU Has anyone experience trouble with CFMENU since the 8.0.1 Updater? I've noticed a few of things: 1) The submenu indicator arrow appears beneath the display text in a vertical menu in Internet Explorer. 2) There seems to be an improperly nested DIV that causes a thick top border in vertical format. 3) The TYPE attribute for 'vertical' or 'horizontal' MUST be lowercase - 'Vertical/Horizontal' or 'VERTICAL/HORIZONTAL' cause it to render incorrect. 4) If I use an image in a top-level CFMENUITEM, it will also try to display that same image as part of a group of child CFMENUITEMs, so that if there are 5 child items, a single image of the parent menu item will display once for all 5 items. (It's obviously not supposed to be there, because as you mouseover the child menu items, the mouseover color appears over the image.) 5) An underline now appears for the active menu item. The behavior of having a mouseover color for the active menu item is desired, and I supposed I could live with the underline, but I'd rather not. There could be others, but I was SO bummed! The update fixed a couple of things that were a problem, but introduced other issues! I might be able to solve a couple of these by tinkering with the YUI CSS, but a couple are clearly beyond that. One thing that DOES seem to be fixed is the odd behavior you got on a horizontal menu, where it would be rendered vertically (mostly in IE) to begin with, then resolve to horizontal - it was a weird and distracting behavior, but seems OK now. -- Bob Hendren President/CEO ListingWare, Inc. http://www.listingware.com http://www.listingware.com/ 800-867-4707 x 706 [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303275 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 8.0.1 Update and CFMENU
Bhakti -
Thanks for the reply. I've gone through your responses and provided further
info of my own below, denoted by .
--
Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com
800-867-4707 x 706
[EMAIL PROTECTED]
-Original Message-
From: Bhakti Pingale [mailto:[EMAIL PROTECTED]
Sent: Monday, April 14, 2008 9:12 AM
To: CF-Talk
Subject: RE: CF 8.0.1 Update and CFMENU
Hi Bob,
Please find my comments inline.
Hope these inputs help you.
Thanks for your feedback.
Thanks,
Bhakti
-Original Message-
From: Bob Hendren [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 12, 2008 4:40 PM
To: CF-Talk
Subject: CF 8.0.1 Update and CFMENU
Has anyone experience trouble with CFMENU since the 8.0.1 Updater? I've
noticed a few of things:
1) The submenu indicator arrow appears beneath the display text in a
vertical menu in Internet Explorer.
- Setting the menu width appropriately should solve this problem for you. I
am however not able to repro this one. May be you can give me some more
inputs.
Try viewing http://lw1dbserver1.listingware.com in IE and then another
browser. The vertical menu on the left side has the submenu indicators
underneath the text. A horizontal menu in a similar site is rendering
properly.
2) There seems to be an improperly nested DIV that causes a thick top
border in vertical format.
- We did a YUI upgrade in CF 8.0.1 because of which there have been small
little UI changes. This is one of them.
I am not too sure if I have understood you perfectly, but I also see a
border added which can be removed.Under the
/CFIDE/scripts/ajax/resources/yui/yui.css file, the line border-width (as
shown below) has to be changed to border-width:0 0 0 0;
...yuimenu ul {
list-style-type:none;
border:solid 1px #c4c4be;
border-width:1px 0 0 0;
margin:0;
padding:4px 0;
}
If this is not the one you are talking about then could you please explain
it again so that I can give you a workaround.
This did fix the issue.
3) The TYPE attribute for 'vertical' or 'horizontal' MUST be lowercase
-
'Vertical/Horizontal' or 'VERTICAL/HORIZONTAL' cause it to render incorrect.
-Agreed. I will log a bug for this one.
OK, thanks. I can live without images until fixed.
4) If I use an image in a top-level CFMENUITEM, it will also try to display
that same image as part of a group of child CFMENUITEMs, so that if there
are 5 child items, a single image of the parent menu item will display once
for all 5 items. (It's obviously not supposed to be there, because as you
mouseover the child menu items, the mouseover color appears over the
image.)
- This one is a known bug. I guess we have documented it.
5) An underline now appears for the active menu item. The behavior of
having a mouseover color for the active menu item is desired, and I supposed
I could live with the underline, but I'd rather not.
- This again is because of the YUI upgrade. The workaround is as follows.
The css change is required to correct the underline issue
Under the /CFIDE/scripts/ajax/resources/yui/yui.css file, the line
text-decoration has to be taken off
...yuimenuitem a.selected,
...yuimenubaritem a.selected {
background-color:#AADEFF;
text-decoration:underline;
color:#fff;
}
I did this, but it's still a problem. If you View Source on that same web
site, you see the statement where the YUI CSS file is included, then
directly after it is a new STYLE statement that had never been there before.
That seems to be where the underline is coming from. I found that if I took
all attributes except type=vertical out of the CFMENU declaration, the new
STYLE element went away and so did the underline. However, the submenu
indicator issue from above still exists.
There could be others, but I was SO bummed! The update fixed a couple of
things that were a problem, but introduced other issues! I might be able to
solve a couple of these by tinkering with the YUI CSS, but a couple are
clearly beyond that.
One thing that DOES seem to be fixed is the odd behavior you got on a
horizontal menu, where it would be rendered vertically (mostly in IE) to
begin with, then resolve to horizontal - it was a weird and distracting
behavior, but seems OK now.
--
Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com http://www.listingware.com/
800-867-4707 x 706
[EMAIL PROTECTED]
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303315
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF 8.0.1 Update and CFMENU
Has anyone experience trouble with CFMENU since the 8.0.1 Updater? I've noticed a few of things: 1) The submenu indicator arrow appears beneath the display text in a vertical menu in Internet Explorer. 2) There seems to be an improperly nested DIV that causes a thick top border in vertical format. 3) The TYPE attribute for 'vertical' or 'horizontal' MUST be lowercase - 'Vertical/Horizontal' or 'VERTICAL/HORIZONTAL' cause it to render incorrect. 4) If I use an image in a top-level CFMENUITEM, it will also try to display that same image as part of a group of child CFMENUITEMs, so that if there are 5 child items, a single image of the parent menu item will display once for all 5 items. (It's obviously not supposed to be there, because as you mouseover the child menu items, the mouseover color appears over the image.) 5) An underline now appears for the active menu item. The behavior of having a mouseover color for the active menu item is desired, and I supposed I could live with the underline, but I'd rather not. There could be others, but I was SO bummed! The update fixed a couple of things that were a problem, but introduced other issues! I might be able to solve a couple of these by tinkering with the YUI CSS, but a couple are clearly beyond that. One thing that DOES seem to be fixed is the odd behavior you got on a horizontal menu, where it would be rendered vertically (mostly in IE) to begin with, then resolve to horizontal - it was a weird and distracting behavior, but seems OK now. -- Bob Hendren President/CEO ListingWare, Inc. http://www.listingware.com http://www.listingware.com/ 800-867-4707 x 706 [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: qoq date formating
Will DateFormat() give you what you need? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, April 10, 2008 11:59 AM To: CF-Talk Subject: qoq date formating Is there any dateformating functions when doing a query of a query? Like in MS SQL I can use the CONVERT function. SELECT JOBNOTE, CONVERT(varchar, DateCreated, 108) AS DateCreatedAsTime FROM JobNotes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open Source CF Shopping Carts
Dave, I originally thought about writing my own shell until I found CFWebstore. The bang for the buck is great. And their yahoo group is a great source of support. Between the community and CFWebstore quickly responding to all questions, it's the best way to get tech support. I have no affiliation with the company--just a satisfied user. Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open Source CF Shopping Carts
Forgot to mention All the source is open and available. I've been doing a lot of customizing the code for ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open Source CF Shopping Carts
Forgot to mention All the source is open and available. I've been doing a lot of customizing the code for Damned Enter key ;-) Anyway, you get the idea. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Controlling the font output in a cfdocument... created pdf
Ditto on that, I resorted to wrapping everything in divs then using inline style attributes to set whatever I need for formatting. My 2 cents. Bob Ian, I have had formatting problems with cfdocument in the past. I remember reading somewhere that cfdocument has it's own html/css rendering engine, or something to that effect. You may want to try wrapping it with something else like a div or a span tag or maybe even (shudder) a font tag . hth G On Tue, Apr 8, 2008 at 2:14 PM, Ian Skinner [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: New To CF
Just responded to the same posting on cf-newbie but will that response in here as well. Bruce, That will get you started with basic CF but to build data driven sites you'll also need some sort of RDMS such as MSSQL, Access, MySQL or some other such product. If you're a visual learner, MS Access is great for getting started as it lends itself to creating visual models or prototyping if you will. As for the best way to learn CF really depends on your learning style, if you're more a visual learner then perhaps what is offered at http://lynda.com/ would be a good starting point for you. If you're fine with have printed materials as a guide then I would suggest purchasing a copy of the latest CF WACK http://www.forta.com/books/0321125169/ will work for you. IMHO having a copy of WACK is a tool worth having in your box and well worth the investment. There are a number of sites out there that can help you jump right in a get up a running quickly. One site I used a good bit to start with was easycfm.com http://www.easycfm.com/ with lots of real world examples and tutorials. The short answer to what is the best way to learn CF is by doing :) I might add that http://cflearn.com might also provide an opportunity to learn about debugging :) HTH Bob Imperial art design development 6204 Lead Mine Road Raleigh, NC 27612 919-602-3118 www.imperialart.com -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2008 3:37 PM To: CF-Talk Subject: RE: New To CF Welcome to CF. You are on your way and in the right direction. I would suggest, before you do any 'major' reading on the subject, that: 1. First you create a very simple .cfm page and test to verify your installation is working. Open a text editor, type in cfoutput#now()#/cfoutput and save it as index.cfm in the webroot of your local site. Open that new page in a browser and verify that you do not see the actual text you typed in, but you see the current time in 'timestamp' format. 2. Go to a good online tutorial site and follow the steps exactly so that you can get a feel for the language. I have heard some good things about http://cflearn.com/ 3. If you are an experienced web developer, take a page you have built in another language (PHP, .NET, ASP, etc) and translate its functionality into ColdFusion. Feel free to ask any questions of us here. This list and the house of fusion's CF-Newbie list can be very helpful to you. Good Luck!! William ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server performance problem since upgrading to CF8
Every since upgrading to CF8 I've been having a frustrating problem. After starting CF, it will run for a while (sometimes serveral hours, sometimes less than an hour) at about 1% - 3% in terms of processor load. (It's a 2 cpu - 4 core system.) Then, all of a sudden, the processor load will jump up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. I have had this EXACT problem! Have you found a solution? A fire-breathing, quad-processor, dual core Dell that just locks up - weird! Anyone seen this, or have any ideas. BTW, I'm running the standard edition of CF so I don't have access to the server monitor. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: Where to buy CF8 WACK (probably again)
Sometimes it pays to wait a little. I know for Part 1, I was able to buy it used from Amazon and with shipping it still only cost me $20- less than half price! --Bob I just got a notice from Amazon.com that Parts 2 and 3 of the CF8 WACK are being delayed - Part 2 is scheduled to arrive between 11/29 and 12/1. Part 3 is scheduled to arrive between 12/28 and 12/31 This represents almost a month's delay! I did a quick look at BN.com and they're showing November ship dates... have they just not updated their product info or would it be worth it for me to tell Amazon to cancel the order and re-order from BN? Or is there a better place to order from? Thanks! Hatton ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Where to buy CF8 WACK (probably again)
Sometimes it pays to wait a little. I know for Part 1, I was able to buy it used from Amazon and with shipping it still only cost me $20- less than half price! --Bob ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292731 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Link Generator Tool / Problem solved
I'm a little late here, but you could also do
a href=javascript:; onClick=action()link/a
Problem solved. The trick was to get rid of the href altogether. This string
works in all browsers and passes around fine in CF and DBs or static HTML.
a
onclick=openPopUp('http://myurl.com/glossary.cfm?glossary=1term=2','glossa
ry','410','300','110','35') style=cursor: pointer;This Term /a
Of course, you need the OpenPopUp script as a global for the site... but
that's easy enough.
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be .
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287109
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Time for another CF hosting site thread...
I have several clients hosted with dantor.com with all the bells and whistles at a fraction of what you'll find elsewhere. They're hosting wholesalers and have a nice reseller matrix. I've used these guys for about 6 years now with very few issues and are always ready to help even though they're wholesalers. Dantor.com not a lot of warm fuzzies on their site design, but I really don't care about glitz and glamour, their service has been such that I haven't even looked elsewhere. Oh, I have about 40 domains hosted there and roughly half are active sites. My two cents ... Bob -Original Message- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 5:07 PM To: CF-Talk Subject: Time for another CF hosting site thread... I have a client that wants a fairly simple website. I REALLY want to use CFdynamics but I am not going to tell him it's $50/month just for CFFILE. So...If you all can direct me to who you use, I will gladly look at them and give you the referal. Thanks, Brian Yager ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Time for another CF hosting site thread...
Mark ... their response times have always been within an hour or so during regular business hours. As I said they're not terribly touchy feely, but I like them. There are 3 principals and all 3 are involved in what they do. They are Coldfusion developers as well as web hosts so they know the product. You won't get any automated responses from them, just answers to your questions toot sweet. My site is running 7,0,2,142559 and all the others I have hosted there. Drop them a line, I think you'll be surprised what they allow. Bob -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 7:29 PM To: CF-Talk Subject: Re: Time for another CF hosting site thread... Bob - Dantor looks like it might be decent, a few quick questions (I'll contact them directly too) - Does it run cfmx7? it only seems to list 6.1 on the site? - can you run createObject? I see cfobject is disabled? (can that be turned on?) - What is their support response time like? Mark ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't see the trees for the forest here ...
Resolved .. I have seen the error of my way ... ;) found a single variable nested inside a collapsed if statement that was spelled differently. Bob ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: css not working in CF file
Ditto , might even play around with navbar a bit
#navBar{
margin: 0 0 0 79%;
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 08, 2007 11:21 PM
To: CF-Talk
Subject: Re: css not working in CF file
It looks almost as if the width of the left side floated item is too wide
to accomodate the right. So it pushes it down below it. Just for the
heckuvit, shrink the width of the left side to see if it brings the right
back up.
Will
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283215
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: css not working in CF file
Setting the #navBar{ margin: 0 0 0 79%; to 78% allows it room to display at
the top of that div, or at least it does locally ;)
Bob
I have two different pages:
http://www.ocbin.org/index.cfm
And
http://www.ocbin.org/index.html
They are EXACTLY the same (checked page source).
When I run them (.cfm and html) in firefox, they render exactly the
same - no problem.
When I run them in Explorer 7, note that the sidebar is screwed up on
the right in the CFM version, but not in the html version.
Since the page source is exactly the same, I am at a loss to explain
how this is happenening.
Any help greatly appreciated.
Richard
Colman
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283216
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: video gallery / audio gallery?
Dwayne, Take a little time to go through the tutorials at the bottom of this page. I'm sure you'll find it worth the time spent as it explains much better than I can how to accomplish what you're after ... I think ;). I could be wrong, but I don't think you'll find a solution for what you want that works right out of the box. You may find that you can build what you want, tailored to your specific needs. http://gotoandlearn.com/download.php HTH Bob -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 1:06 PM To: CF-Talk Subject: RE: video gallery / audio gallery? I'm a newbie, nobie, better yet tried-to-be user of Flash, so are you saying I should just import the movie file into flash, save it as a .swf file then configure the xml to pull in the .swf file instead of the .jpg files? Well what about the play back controlls etc. -- Original Message -- From: Bob Imperial [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Fri, 29 Jun 2007 11:56:13 -0400 You can simply import your video clips into a flash movie clip, then pull those into slideshow pro via the xml file? -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 10:11 AM To: CF-Talk Subject: RE: video gallery / audio gallery? Almost. I use slideShowPro but it's a photo Gallery I'm looking for a video gallery and an audio gallery. -- Original Message -- From: Imperial, Robert [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Fri, 29 Jun 2007 09:52:33 -0400 Sounds like something you could probably do with SlideShow Pro http://www.slideshowpro.net/ Bob Imperial DOM-IS Web Developer Department of Medicine 125 Macnider Hall, CB 7005 UNC at Chapel Hill Chapel Hill, NC 27599 Phone: (919) 843-6151 -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 9:41 AM To: CF-Talk Subject: video gallery / audio gallery? I am working on a site for a small church that would like to broacast video excerpts of the pastor's sermons and audio excerpts of the churh chior. Does any one know of a video display gallery of the likes of cnn.com, video.yahoo.com, or youTube. I do not need a full application, I just need something that I can feed an xml file. Likewise I am looking for a similar audio gallery that supports mp3 files. Dwayne ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: video gallery / audio gallery?
You can simply import your video clips into a flash movie clip, then pull those into slideshow pro via the xml file? -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 10:11 AM To: CF-Talk Subject: RE: video gallery / audio gallery? Almost. I use slideShowPro but it's a photo Gallery I'm looking for a video gallery and an audio gallery. -- Original Message -- From: Imperial, Robert [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Fri, 29 Jun 2007 09:52:33 -0400 Sounds like something you could probably do with SlideShow Pro http://www.slideshowpro.net/ Bob Imperial DOM-IS Web Developer Department of Medicine 125 Macnider Hall, CB 7005 UNC at Chapel Hill Chapel Hill, NC 27599 Phone: (919) 843-6151 -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 9:41 AM To: CF-Talk Subject: video gallery / audio gallery? I am working on a site for a small church that would like to broacast video excerpts of the pastor's sermons and audio excerpts of the churh chior. Does any one know of a video display gallery of the likes of cnn.com, video.yahoo.com, or youTube. I do not need a full application, I just need something that I can feed an xml file. Likewise I am looking for a similar audio gallery that supports mp3 files. Dwayne ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
retrieve mac address with CF?
Good morning folks ... or at least it's morning here ;) I was just asked if I could retrieve mac addresses via coldfusion and have no idea. Is this possible with cf, if so or if someone knows of a good reference to point me in the direction of, I would appreciate it greatly. Thanks! Bob ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282033 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 training
Aye, been there done that, just thought somebody from the area might be aware of something new available here. Bob -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 13, 2007 9:45 PM To: CF-Talk Subject: RE: CF training Go to the adobe site and they should have a listing of classes... Eric -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 13, 2007 10:06 AM To: CF-Talk Subject: CF training Does anyone out there know of any instructor led CF courses in the Raleigh/Durham/Chapel Hill area of NC? Bob ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF training
Does anyone out there know of any instructor led CF courses in the Raleigh/Durham/Chapel Hill area of NC? Bob ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281010 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 help with updating date field
Thanks all for the quick responses, I've changed the field name from Date to AccessDate, makes more sense too. I used cfqueryparam on my insert and just trying to get this thing to work in the raw first ;). As for using jdbc instead of odbc, I have yet to get cf to register the ds using the SQL driver it offers. I'm not an admin and have very little to go on where configuring cf is concerned since there's not anyone here that has the know how to get it working correctly using jdbc drivers. Thank you all for the help, update statement working now ;) Bob ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279611 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 Server connecting to MySQL v5
This worked for me ... http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7 HTH Bob -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 7:17 AM To: CF-Talk Subject: CF Server connecting to MySQL v5 Hi All I have been using CF v7.02 standard for some time and have recently installed CF 7 enterprise. I am unable to connect to a MySQL v5 database. I have added the mysql-connector-java file as I had to in CF v7.02. But I am still however unable to connect to a MySQL datasource. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279466 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 Server connecting to MySQL v5
I was using 7 standard at the time I found the blog entry on it, though I am running 8 at the moment and copied the jar to C:\ColdFusion8\lib and still works here for the moment, though I hadn't seen anything specifically on enterprise edition. B -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 4:24 PM To: CF-Talk Subject: RE: CF Server connecting to MySQL v5 Are you using CF 7 Standard or enterprise. Where did you copy the jar file to if using Enterprise version? Regards -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 May 2007 1:15 AM To: CF-Talk Subject: RE: CF Server connecting to MySQL v5 This worked for me ... http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7 HTH Bob -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 7:17 AM To: CF-Talk Subject: CF Server connecting to MySQL v5 Hi All I have been using CF v7.02 standard for some time and have recently installed CF 7 enterprise. I am unable to connect to a MySQL v5 database. I have added the mysql-connector-java file as I had to in CF v7.02. But I am still however unable to connect to a MySQL datasource. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279527 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 Server connecting to MySQL v5
Yes, though I don't think it's released yet, was on the beta program ;) I can hardly wait, lots of new goodies to play with. -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 6:33 PM To: CF-Talk Subject: RE: CF Server connecting to MySQL v5 Coldfusion 8 ??? Is that the new release of CF. I had CF7 standard running perfectly, just cant get enterprise to talk to MySQL. Not sure whether I should be including the jar file in the same place as standard or including it in a similar place in the jrun folder or both. -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 May 2007 6:47 AM To: CF-Talk Subject: RE: CF Server connecting to MySQL v5 I was using 7 standard at the time I found the blog entry on it, though I am running 8 at the moment and copied the jar to C:\ColdFusion8\lib and still works here for the moment, though I hadn't seen anything specifically on enterprise edition. B -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 4:24 PM To: CF-Talk Subject: RE: CF Server connecting to MySQL v5 Are you using CF 7 Standard or enterprise. Where did you copy the jar file to if using Enterprise version? Regards -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 May 2007 1:15 AM To: CF-Talk Subject: RE: CF Server connecting to MySQL v5 This worked for me ... http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7 HTH Bob -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 7:17 AM To: CF-Talk Subject: CF Server connecting to MySQL v5 Hi All I have been using CF v7.02 standard for some time and have recently installed CF 7 enterprise. I am unable to connect to a MySQL v5 database. I have added the mysql-connector-java file as I had to in CF v7.02. But I am still however unable to connect to a MySQL datasource. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS SQL 2000 and ntext
I ran into something similar a week or so ago, don't know if this will work for your issue, but instead of SELECT *, try selecting the specific fields you need and put the ntext field as the very last in your select statement. Maybe maybe not shrug Bob Hi there, I'm running CF7 and MS SQL 2000 on this project I'm working on. I'm using a simple cfquery to get a row of data. cfquery datasource=DB name=Data SELECT * FROM datatable WHERE id = 439 /cfquery Very, very simple query Now, one of these fields is of type ntext. It contains xml data. What I'm trying to do is to retrieve the xml data from this field... what seems to happen, is that the xml isn't returned in it's entirety. It's cut off at a certain point. Any ideas? This table is actually used by (and created with) a .NET program my employer purchased, and the data is used in this program without a problem. I know this is slightly vague Thanks, -- Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Edit excel on line
I was hoping to find something with this functionality that could be installed within a site and administer it myself, though I don't know if this even exists in the open source community yet. My uses this functionality via a company called HyperOffice at the moment. They've not been all that happy with the support thus far so I was really hoping to find something to work with myself. Bob I'd take a look at docs.google.com Depending on what you are trying to do, this works fairly well for most excel functions. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Edit excel on line
Meant to say My wife uses ...fat fingers, slow brian ;) I was hoping to find something with this functionality that could be installed within a site and administer it myself, though I don't know if this even exists in the open source community yet. My uses this functionality via a company called HyperOffice at the moment. They've not been all that happy with the support thus far so I was really hoping to find something to work with myself. Bob I'd take a look at docs.google.com Depending on what you are trying to do, this works fairly well for most excel functions. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GUI for WebApplications
Don't know that I've ever seen any galleries specific to admin ui stuff, but it seems you could adapt any layout to suit your need. Email me off list about this if you like, not a solicitation for work ;) just help. Bob -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Saturday, May 19, 2007 3:54 AM To: CF-Talk Subject: GUI for WebApplications I am ready to redesign the user interface for a content management system that I built about 4 years ago. I looking for some nice layouts. I am aware of plenty of front end web gallery sites but but I don't know of any galleries of admin panels. Are there any suggestions? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query of query - clob error
Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue. HTH Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 8:07 AM To: CF-Talk Subject: query of query - clob error I have a nice little query of query going (brilliant little tool query of queries are). Unfortunately, it seems that if my SELECT specifies a field that's a CLOB, then I receive an error. Here's the error: Query Of Queries runtime error. Unsupported SQL type java.sql.Types.CLOB. Oddly, If I don't specify a list of fields and only do SELECT * then everything works a-okay. Whatup with that? Any help? daniel ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query of query - clob error
These settings are found under the advanced setting tab when you register your datasource. Not sure what the default setting is for your buffer, 64k maybe? It's been suggested to me to double that, at any rate mine is set to 128. Hope this helps. CLOB -- Enable long text retrieval (CLOB). BLOB -- Enable binary large object retrieval (BLOB). Long Text Buffer (chr) Blob Buffer(bytes) Bob -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 9:34 AM To: CF-Talk Subject: Re: query of query - clob error Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue. Yes, I did try listing the two of them last. I also removed one, just for testing, and the last field is a CLOB and it still fails. I can ask to have a setting enabled. What setting would that be? Any other thoughts? thanks so far. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Scorpio to help with CFMyAdmin
Ok Rick ;), I was there last night as well and I'm trying to put names with faces, which one were you? LOL Bob -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 7:58 AM To: CF-Talk Subject: Scorpio to help with CFMyAdmin The new feature mentioned at the TACFUG/RDAUG user group meeting last night involved updated database drivers across the board, and a new tag called CFDBINFO which will provide all kinds of database introspection stuff. So whoever was planning to write a CFMyAdmin type utility... it might be a whole lot easier in CF8! Rick -- ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Blob/clob issue
Well . it's almost Friday and none to soon for me. I have an issue I've run into I'm hoping someone out there might have a solution for. First off I'm working with CFMX 7, MSSQL 2k on a Win 2003 Web Server and using an ODBC driver. I have an ntext field that's not returning any data to me for display, I've dumped my query and there are actually a couple of ntext fields that just return and empty string. The thing is, this ntext field displays fine in an aspx page within an old site I am rebuilding (or trying to anyway) using ColdFusion. Anyone ever run into this and more importantly, can anyone offer a solution? I've done a google or two on it with no real luck on a solution yet. Oh and the query is as simple as it gets, doing SELECT * Thanks! Tired Bob ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
Unfortunately, I've not been able to successfully register a ds in cf w/ms sql drivers, yet another story ;). So, off to pull down jdbc drivers from ms and see what I can break. Gracias! -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 8:57 AM To: CF-Talk Subject: RE: Blob/clob issue Bob, First I would try the built in MS SQL driver, and if that still fails give the Microsoft JDBC driver a shot. Chris -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 8:56 AM To: CF-Talk Subject: Blob/clob issue ://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=22382.15322.4 ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277612 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
Dave this is what I've run into with every attempt so far: Connection verification failed for data source: Faculty_Profile2 java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect If you're unable to use the DataDirect drivers that come with CF to connect, you will likely not be able to use any other JDBC drivers to connect, either. What error do you get when you try to set up the connection? 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! This email has been processed by SmoothZap - www.smoothwall.net ..com/cf_lists/unsubscribe.cfm?user=28108.19997.4 ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
It is enabled, although I'm definitely not a db admin by a long shot. I know the basics of to get around and work within enterprise manager and such. But I'm always willing to break things ;) Bob -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 3:23 PM To: CF-Talk Subject: RE: Blob/clob issue Check your SQL server configuration and make sure that TCP/IP access is enabled (its off by default) Chris Peterson ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
Well ... looks like there might be an issue with TCP/IP although it is enabled, in fact, I unchecked it a rechecked it, restarted SQL Server. Couldn't connect trying to telnet in using the IP of the box it's on and the standard 1433 on the port ... I'm going to reboot the server in a bit after everyone has left for the day and see what if any effect that might have. Bob -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 5:08 PM To: CF-Talk Your problem is likely one of these things: - you don't have the TCP/IP listener enabled on the database server, - you are specifying the wrong server and/or port in the CF datasource, - there is a firewall blocking either your application server's outbound traffic or your database server's inbound traffic on the port in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ user=22382.15322.4 ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: iSeries point to ColdFusion server direction...
Bob, I'm not familiar with the iSeries Apache Web server, but if you are using a standard apache web server, you would use the wsconfig program that gets installed with apache to connect to coldfusion. You can also manually copy over the mod_jrun22.so or mod_jrun2.so files and manually put in the configuration. Something like this: LoadModule jrun_module C:/JRun4/lib/wsconfig/mod_jrun22.so # JRun Settings IfModule mod_jrun22.c JRunConfig Verbose true JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore C:/JRun4/lib/wsconfig/1/jrunserver. store JRunConfig Bootstrap x.x.x.x:51002 #JRunConfig Errorurl optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 #JRunConfig ConnectTimeout 15 #JRunConfig RecvTimeout 300 #JRunConfig SendTimeout 15 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Hope this helps, Russ -Original Message- From: Bob Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 4:24 PM To: CF-Talk Subject: Re: iSeries point to ColdFusion server direction... I found an article on Adobe's site talking about Distributed configuration but it was for version 5. Anyone have anything newer that they've seen and what I would need to do to the Apache on the iSeries to point correctly to ColdFusion on W2K3? Thanks. I hope someone can point me in the right direction or fill me in... Currently where I work we donââ¬â¢t use ColdFusion but Iââ¬â¢m putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donââ¬â¢t want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iSeries point to ColdFusion server direction...
Thank you for the reply Russ. So, how in Apache to I actually point it to the ColdFusion server? Is there a line in the config where I would say that it needs to go to the W2K3 server for ColdFusion pages. Thanks again. This is new to me. Bob Bob, I'm not familiar with the iSeries Apache Web server, but if you are using a standard apache web server, you would use the wsconfig program that gets installed with apache to connect to coldfusion. You can also manually copy over the mod_jrun22.so or mod_jrun2.so files and manually put in the configuration. Something like this: LoadModule jrun_module C:/JRun4/lib/wsconfig/mod_jrun22.so # JRun Settings IfModule mod_jrun22.c JRunConfig Verbose true JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore C:/JRun4/lib/wsconfig/1/jrunserver. store JRunConfig Bootstrap x.x.x.x:51002 #JRunConfig Errorurl optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 #JRunConfig ConnectTimeout 15 #JRunConfig RecvTimeout 300 #JRunConfig SendTimeout 15 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Hope this helps, Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
iSeries point to ColdFusion server direction...
I hope someone can point me in the right direction or fill me in... Currently where I work we donât use ColdFusion but Iâm putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donât want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: iSeries point to ColdFusion server direction...
I hope someone can point me in the right direction or fill me in... Currently where I work we donât use ColdFusion but Iâm putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donât want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iSeries point to ColdFusion server direction...
I found an article on Adobe's site talking about Distributed configuration but it was for version 5. Anyone have anything newer that they've seen and what I would need to do to the Apache on the iSeries to point correctly to ColdFusion on W2K3? Thanks. I hope someone can point me in the right direction or fill me in... Currently where I work we donât use ColdFusion but Iâm putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donât want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple Query Totals
Hello! I have a page setup that lists data about certain records in a DB2 database. The user can choose between two different methods of showing data. The first (ONLY Mode) shows orders for a specific account. (This is working fine) The second mode (Called Normal) shows all of the order for the specific account along with orders from the parent company and any other children companies associated with the parent company. This is working fine except for the paging feature. The user can page back an forward to see a user defined amount of records on each page. I've modified the code so that it properly shows Showing 1 - 20 of 913Next 20. But, it is listing the first 20 of the first query and then the first 20 of the second query. Then when the user clicks next it shows the next 20 of each query. How to I take two queries and combine them so they paging will work? Should I use an array and stick all of the results into this array? Thanks for any direction. Bob ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiple Query Totals
Thanks, but that is not what I am asking. The queries have multiple tables combined with the UNION command. I can't get all of the data from one query. I have to create a query to get the child/parent relationship and then use another query to extract record info. Bob On Fri, 30 Mar 2007 17:28:04 +0200, Jochem van Dieten [EMAIL PROTECTED] said: Bob Johnson wrote: How to I take two queries and combine them so they paging will work? Check your database manual for UNION. Jochem ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Multiple Query Totals
Thanks everyone. I misunderstood the last UNION post. The UNION ALL is working perfectly. Thanks for helping me out. Bob On Fri, 30 Mar 2007 11:30:55 -0400, Peterson, Chris [EMAIL PROTECTED] said: Yea, in DB2 you can just do SELECT col1, col2, col3 FROM file UNION ALL SELECT col1, col2, col3 FROM file2 ORDER BY col1 Note the order by goes after all your UNION's, and sorts the entire result set. Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 11:28 AM To: CF-Talk Subject: Re: Multiple Query Totals Bob Johnson wrote: How to I take two queries and combine them so they paging will work? Check your database manual for UNION. Jochem ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Multiple Query Totals
Thanks Chris! I am going to remember this. This is extremely useful!! Bob On Fri, 30 Mar 2007 11:39:47 -0400, Peterson, Chris [EMAIL PROTECTED] said: You don't have to do it that way. Try using sub-selects to get the child data. I do this in DB2 all the time, here is an example. SELECT Col1, Col2, Col3, (SELECT SUM(Revenue) FROM rev WHERE Order = A.Order) as TotalRevenue FROM ORDER A WHERE Col1 = 'Whatever' You can do as many of those sub-select as columns you need. Just ensure that the data set is returning only a single record. Also, you could do a nice Union All on your QoQ, if the fields are the same. If we still are not getting what your trying to do, maybe post some code? Chris ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Debugging?
Sure is, in cfadmin under debugging settings Debugging Logging Debugging IP List , add the IP address for debug output. Bob -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:30 AM To: CF-Talk Subject: Debugging? Is there a way to have Debugging turned OFF for one site but on for everything else? I am building an internal application and would like the Debugging on that site off. Since developers are using the same server for other applications, the debugging (CF Admin settings) is turned on. TIA! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfhttp/xml help
Hi Folks, I'm just getting started with learning the basics on pulling xml feeds with cfhttp and am in need of some help with an error I get with some feeds I'm playing with. Here's the code block I'm working with and I get the following error on this feed and a couple of others... Content is not allowed in prolog. The error occurred in C:\Inetpub\wwwroot\testing\rss.cfm: line 10 8 : body 9 : cfhttp url=http://www.nranews.com/rss/rss.xml; method=GET resolveurl=No /cfhttp 10 : cfset MyXML=XMLParse(cfhttp.FileContent)--- doesn't seem to like this cfhttp url=http://www.nranews.com/rss/rss.xml; method=GET resolveurl=No /cfhttp cfset MyXML=XMLParse(cfhttp.FileContent) !---cfdump var =#MyXML#--- !-- cfoutput cfloop index=x from=1 to=#ArrayLen(MyXML.rss.channel.item)# Title: #MyXML.rss.channel.item[x].title.xmlText# a href=#MyXML.rss.channel.item[x].link.xmlText#click here/a #MyXML.rss.channel.item[x].description.xmlText# /cfloop /cfoutput While this same block of code works fine using the feed from http://www.tfc.edu/radio/podcasting/music.xml I'm confused here, any help in understanding this is appreciated! Bob ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query on cfdirectory
Hi folks, in need of some help with a couple of things here that I'm wanting to do. Not really sure where or how to start ..Firstly, I have a couple of directories (songs,docs) that I do a simple display of with cfdirectory and cfloop query to display names. What I am attempting to do is provide a way for people to select a number of songs/docs from each of these directories to store or write to a file for others to view as a current song type thing. I'm thinking about just doing a simple form/checkbox scenario to flag the items, then store in a db and pulling those for display on the other end? I guess I'm asking what might be the best approach for this? Secondly, my mind is wandering/wondering and trying to get a better understanding of what is returned by a query in this situation, are the only things returned, the elements outlined in livedocs?? I'm needing a somewhat visual between the whole array/query thing and what I've been reading so far seems too vague for my feeble mind to figure out. Any help or direction on any of the above would be greatly appreciated. TIA Bob ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query on cfdirectory
Thanks for the quick response! This will keep me from cleaning out the shed for a while ;) unless of course the wife decides we need to do CFDUMP VAR=TheShed Bob -Original Message- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 11:28 AM To: CF-Talk Subject: RE: query on cfdirectory To see all elements returned in a query structure: CFDUMP VAR=#query_name# You are on track with the form/checkbox option by storing the filename in a db to be displayed later. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
need insert help please
First off...shouldn't you all be out doing something other than working? ;-)
Since you're not out somewhere having way too much fun, I could use some
enlightenment here.
I have a form passing multiple values via some checkboxes, I think I've got
the insert down ok for that with the following: I'm working with MySql and
the week_of field I have set to unique in the db.
cfloop list=#Form.songTitle# index=item
cfquery name=current_week datasource=#dsdata# username=me
password=mypwd
INSERT INTO current_week (song_title)
VALUES ('#item#')
/cfquery
/cfloop
My question comes in with a form field that only needs to be inserted once
for each group of songs, this value is also being passed via the form, how
would I go about handling this? To muddy this up a tad more, I have a second
for that handles song docs that need to be inserted and associated with the
week_of insert from the first insert statement. Any help would of course be
greatly appreciated! I work alone so my only source for
feedback/help/direction is this and a few other lists.
Thanks! Bob
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272284
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 insert help please
Dave...sorry for the lack of information, after read what I posted I thought
I should have given a little more information. My form looks like this:
form action=#self#?fuseaction=admin.selectSongs name=songSelect
method=post
input type=text name=week_of size=25 maxlength=50 value= /
This is generated from doing a read with cfdirectory
cfloop query=songs
a href=songs/#name##name#/anbsp;input type=checkbox
name=songTitle value=#name# /
/cfloop
input type=submit name=submit_songs value=Submit Songs /nbsp;input
type=reset value=Clear Selections /
/form
I am passing this to:
cfloop list=#Form.songTitle# index=item
cfquery name=current_week datasource=#dsdata# username=myname
password=mypwd
INSERT INTO current_week (song_title)
VALUES ('#item#')
/cfquery
/cfloop
Working with mysql, song_id(pk) week_of, song_title and doc_title are all 3
varchars, I hope this enough information to get a better understanding of
what I'm trying to do. In addition to the form above, I also have a second
form setup the same way for the accompanying docs, this also built from a
cfdirectory read. I guess my main question is, since the week_of field in my
form is outside the loop, how do I handle that value? I sure hope this is
making sense to someone ;)
Thanks ...Bob
What exactly do you mean by a group of songs? More information about your
form and database schema would be helpful here.
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!
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272291
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 insert help please
This was copied from a separate display page I setup for band members to
download their songs from, just hadn't pulled out the link refs yet. This
isn't for the public, actually it's for members of a worship band from
church...to make It a little easier for folks to get to their material for
the coming week.
This will be displayed on another page, probably only 5 or 6 as opposed to
150+ on my archive page, so the whole week_of thing comes into play there,
displaying songs for that date..yada yada yada.
This is a bit off your point, but why do you have links in there? If someone
clicks on one of the links, they'll leave your form without finishing it.
I am passing this to:
cfloop list=#Form.songTitle# index=item cfquery
name=current_week datasource=#dsdata# username=myname
password=mypwd
INSERT INTO current_week (song_title)
VALUES ('#item#')
/cfquery
/cfloop
I'm not seeing where to shoe-horn the week_of value into the above loop,
there may be 5 or 6 song_title(s) just not seeing the syntax for it..
Thanks Dave.wellat least I survived the 60s. Which may explain
some of my difficulty here ;)
I'm not sure what you're doing with week_of, but it doesn't matter whether
the field is inside or outside your loop if you only want it to have one
value. In your action page, you'll have week_of along with songTitle.
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!
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272297
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: need insert help please
I got it, or at least it did what I've been trying to get it to do ;) May
not be elegant but it worked
For some reason it didn't like #form.week_of# so I tried this and it worked
cfset thisWeek = form.week_of
cfloop list=#Form.songTitle# index=item
cfquery name=current_week datasource=#dsdata#
INSERT INTO current_week (week_of,song_title)
VALUES ('#thisWeek#','#item#')
/cfquery
/cfloop
Thanks for your patience and feedback Dave! It is much appreciated!
Bob
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 10, 2007 8:03 PM
To: CF-Talk
Subject: RE: need insert help please
I am passing this to:
cfloop list=#Form.songTitle# index=item cfquery
name=current_week datasource=#dsdata# username=myname
password=mypwd
INSERT INTO current_week (song_title) VALUES ('#item#') /cfquery
/cfloop
I'm not seeing where to shoe-horn the week_of value into the above
loop, there may be 5 or 6 song_title(s) just not seeing the syntax for
it..
Is week_of a field in the current_week table? If so, you can add it to
that INSERT statement. If it's a field in another table, and you want to
update the value, put another query outside your CFLOOP to do this.
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!
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2.
Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272299
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: writing xml files
Ben, This isn't something I see being under a constant load with multiple calls, so this may be something for me to explore, if nothing else, it will be an opportunity for me to learn another way to do this. Thanks! Bob -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 2:33 PM To: CF-Talk Subject: RE: writing xml files Bob, You could also just have the flash movie call the CFM page directly and have the CFM page return XML data. The downside to that though is that is requires CF processing every time the flash movie loads. The upside is that it cuts out the middle man and you don't have to worry about the XML file being created PRIOR to the flash movie being loaded. cfcontent type=text/xml reset=true /data item / /data Just trying to give you options. ... Ben Nadel ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
writing xml files
Working on a little flash slideshow here for a client and at present, I'm pulling the images and some captions in via an XML file. What I'm looking to do is make it easy for them to upload their images and use a text field to pass their captions along as well. I want to write the XML file with CF. Has anyone out there done this or something like it that can offer some direction or point me in the direction of some decent tutorials on this? TIA Bob ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http: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:269977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: writing xml files
Aye...playing around with that nowwas hoping for a tutorial of sorts. Thanks for the reply ;) -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 12:56 AM To: CF-Talk Subject: RE: writing xml files I want to write the XML file with CF. cfxml? http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/w whelp.htm?context=ColdFusion_Documentation http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/ wwhelp.htm?context=ColdFusion_Documentationfile=0352.htm file=0352.htm -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2007 9:46 PM To: CF-Talk Subject: writing xml files Working on a little flash slideshow here for a client and at present, I'm pulling the images and some captions in via an XML file. What I'm looking to do is make it easy for them to upload their images and use a text field to pass their captions along as well. I want to write the XML file with CF. Has anyone out there done this or something like it that can offer some direction or point me in the direction of some decent tutorials on this? TIA Bob ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http: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:269980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
