CFIF Statements in CFQUERY with CF 6.1
Sorry forgot to mention the error was at line 68 Kev ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFIF Statements in CFQUERY with CF 6.1
Try outputting the text to the screen before the query - see what's being sent to the Dbengine... That usually helps Tried that, with no luck looks ok the query being sent to the DB is correct it just doesn't like the trailing /CFIF take it out and get teh CFIF with no end tag error So Tried a block out side that create a variable that contains the conditions and it doesn't like the #varirables.orderbystring# but looking at the debug info the correct query is being sent its as if the query is sent twice once coded and once not?? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFIF Statements in CFQUERY with CF 6.1
Sorted now, Sorry Long few days starting to catch up I deleted a space for and AND inthe Where clause and thus the expected one error. So to note CF doesn't always give you the exact error location :-) Cheers for your help ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dynamic CF_Customtag Call?
Yeap CF MODULE is the way quite a cool Idea I think. If so a project like mine you need to use XML for display layouts and gadgets you can create gadgets as CUSTOMTAGS and have a Config XML file contain the information using cfmodule call a named tag and then pass all the parameters in using attributeCollection then call them in the customtag and have defaults for each. Quite cool that I can use an XML file that is read by one page to generate a look and feel how you want :-) As this is an internal application is should be fairly save. Many Thanks for you help guys Kev ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: executing dts package...part 2
Is the CF Services Logged in as a User that has rights to the share? I.E. In Windows NT/2K YOu can have the user login as a Local User who has access to the Drive Mapping - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 2:40 PM Subject: RE: executing dts package...part 2 Any chance you can use a UNC path instead of drive mapping? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:42 AM To: CF-Talk Subject: executing dts package...part 2 Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the CF server. So both machines recognize the share as drive-letter:\blah. I believe the problem is SQL server thinks the drive-letter:\blah is on the end-user machine sending the request. How do I get SQL server to understand the share is not on the local machine and to use the mapping on the server? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML to WDDX
You could create a XSLT to do it and using some thing like XALAN to do the convert - Original Message - From: Dian Oktosoma [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 11:31 AM Subject: RE: XML to WDDX I use CF 5 for linux. Is there any free tag for Linux version to do it? thanks mosos Date: Wed, 10 Apr 2002 03:39:48 -0400 From: Pete Freitag [EMAIL PROTECTED] Subject: RE: XML to WDDX Message-ID: [EMAIL PROTECTED] CFX_XMLParser converts XML into a WDDX structure. You could probably write something to convert it back to XML too. http://www.cfdev.com/xml -Original Message- From: Dian Oktosoma [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:27 AM To: CF-Talk Subject: XML to WDDX FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML to WDDX
This is the web site for the open source XALAN http://xml.apache.org/ But there is a tag that will do this any way http://www.cfdev.com/xml/ - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 1:56 PM Subject: RE: XML to WDDX if anyone knows where i could get some documentation on parsing xml and pass it along to me, i wouldn't mind writing an open-source function or tag to do this. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Kevin McCabe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 8:49 AM To: CF-Talk Subject: Re: XML to WDDX You could create a XSLT to do it and using some thing like XALAN to do the convert - Original Message - From: Dian Oktosoma [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 11:31 AM Subject: RE: XML to WDDX I use CF 5 for linux. Is there any free tag for Linux version to do it? thanks mosos Date: Wed, 10 Apr 2002 03:39:48 -0400 From: Pete Freitag [EMAIL PROTECTED] Subject: RE: XML to WDDX Message-ID: [EMAIL PROTECTED] CFX_XMLParser converts XML into a WDDX structure. You could probably write something to convert it back to XML too. http://www.cfdev.com/xml -Original Message- From: Dian Oktosoma [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:27 AM To: CF-Talk Subject: XML to WDDX FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Flush DB Connections
Hi All, I remember there being an undocumented function in CF 4 called some thing like FlushDBConnections() Any one got any info on this or a web site they details it's uses. Cheers Guys Kev __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Reorder List Using Flash.
Hi All, Does any one have an example of a flash movie that woulf take in a Query in WDDX format. Then using Flash allow the user to drag and drop the rows in to an order they require. Then out put the WDDX back to the CF Server? Or any other way of doing this. Many Thanks Kev __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Upgrade from 4.01 to 5
Hi All, I know this question is always being asked, but any central help would be usful. We are currently running Allaire ColdFusion 4.01 and Want to upgrade to Macromedia ColdFusion 5 Does any one hae have any Whitepapers on this or any issues to look out for? Cheers __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic Images
Hi All, I know Generator could do it by as the usual story goes no Budget. Any How What I require is the ability to have a base image for example the out line of a Football Pitch Then the ability to track lets say 4 Round Images around the pitch. When Happy save the image off as a Bitmap and save the X,Y of the top left of eachof the Round Images Any Ideas? Cheers Kev __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion Debugging
This is a multi-part message in MIME format. --=_NextPart_000_000A_01BFA564.75DB1D30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, Just wondered if there was a way in which to get: Execution Time 20 milliseconds Part of the debug to Display in a Different Colour is its over a Certain = Amount. Any Ideas? Kev --=_NextPart_000_000A_01BFA564.75DB1D30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR STYLE/STYLE /HEAD BODY DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Just wondered if there was a way in = which to=20 get:/FONT/DIV DIVnbsp;/DIV DIVSTRONGFONT face=3DArial size=3D2Execution = Time/FONT/STRONG/DIV DIVnbsp;/DIV DIVSTRONGFONT face=3DArial size=3D220 = millisecondsBR/FONT/STRONG/DIV DIVFONT face=3DArial size=3D2Part of the debug to Display in a = Different Colour=20 is its over a Certain Amount./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Any Ideas?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kev/FONT/DIV/BODY/HTML --=_NextPart_000_000A_01BFA564.75DB1D30-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
TEST
-- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.