Re: CFParam vs. IsDefined
Yes it does :-). In .virc set up aliases for anuything you want. use them in update mode not insert mode. --S ^ On Thu, Sep 2, 2010 at 8:16 AM, Rick Root rick.r...@gmail.com wrote: On Thu, Sep 2, 2010 at 5:00 AM, Peter Boughton bought...@gmail.com wrote: That coupled with StructKeyExists is a pain to type! Why on earth would you *type* it!? vi doesn't do code completion? lol ~| 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:336757 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion barcode
There are several methods that integrate well with CF. First, what type of barcode are you using? If it is 3 of 8, 7 of 9, or posta or MICR l you can just grab a barcode font (there are some free ones out there) and embed the font into a pdf document cfdocument type=pdf That is the easiest method. Stepping up in difficulty would be to purchase a bar code control. Do a google search, there are many different vendors/products out there. You then would call the dll or ocx using cfmethod. You can set up any of the attributes necessary and there is usually an output method of some kind that you would call to place the bar code in your document. The advantage of using a control is they usually can handle all bar code types including 2D types and international postal codes along with UPC, GS1-128 and all the others. The disadvantage is it is a bit more programming to make it all work. There are third party bar code generation programs out there as well that can generate the code and pass it back to you as an object which you would then embed in your document. These can be costly if you run high volume. Another option to consider though depending on your situation. I do bar codes all the time right now. It really isn't that difficult. --S ^ On Fri, Sep 18, 2009 at 9:02 AM, Richard White rich...@j7is.co.uk wrote: hi our software needs to have the ability to generate a barcode gif and place it on a document. has anyone done this before, and what is the best method? thanks richard ~| 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:326431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with CFEXECUTE
I am running the following code: cfset File_Directory = ExpandPath(/download/) cfset runpath=D:\Additional Software\plink.exe cfset argslist= -v -batch -ssh 12.144.48.30 -l user -pw pwd /usr/local/bin/load-prod #uploadfile.serverfile# #variables.sessionuid# cftry cfexecute name = #runpath# arguments = #argslist# outputfile=#file_directory#fcdc.out timeout=2 / cfcatch cfdump var=#cfcatch# /cfcatch /cftry If I run it with no timeout, I get the display page but the execute never runs. If I put anything in the timeout parameter, the process times out no matter what. I have tried values from 1 - 200 for timeouts with consistent results. Does anyone know the magic trick to making this work? Thanks --S ^ -- Stephen Leacock - I detest life-insurance agents: they always argue that I shall some day die, which is not so. - http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html ~| 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:325957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Syntax error in SQL statement
I am not a SQL expert but I play one on TV :) I have the following query select DataLoadStatus,DataLoadData,DataLoadFileLineNumber,exception.description from PUB.DataCenterDataload left outer join PUB.DataCenterHoldingArea on(DataCenterDataload.DataLoadNumber = DataCenterHoldingArea.DataLoadnumber left outer join DataCenterLoadError on(DataCenterHoldingArea.DataLoadNumber = DataCenterLoadError.DataLoadNumber and DataCenterHoldingArea.DataLoadFileLineNumber = DataCenterLoadError.DataLoadFileLineNumber) left outer join exception on(DataCenterLoadError.DataLoadError = exception.excepcode) where DataCenterDataLoad.DataLFileName = '#vfile#' order by DataLoadFileLineNumber I am getting a syntax error on or after 'left outer join DataCenterLoadError' The table relationships are correct as are the join structures left outers. Can someone point me to where I am going wrong. I have been staring at it for most of the past hour. Thanks --S ^ -- Erma Bombeck - Never have more children than you have car windows. - http://www.brainyquote.com/quotes/authors/e/erma_bombeck.html ~| 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:323459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
steve.lichtenberg has invited you to Spokeo
Hi cf-talk,br/br/ steve.lichtenb...@gmail.com has invited you to try Spokeo, which finds your friends' updates across the Web. Your friends are already using Spokeo to follow you on Web Results. Try Spokeo today to find what your friends are doing across 30 different social networks! Click http://www.spokeo.com/public/join?c=196f3020e5846612e24cdd1d906880891de47a18 to accept your invitation. - This invitation was sent with steve.lichtenberg's approval. If you wish to opt out of all future emails, go to http://www.spokeo.com/optout?c=c494955495048564949 Copyright (c) 2009 Spokeo, Inc. All rights reserved. 1685 Plymouth Street #200, Mountain View, CA 94043 ~| 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:322167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Syntax error
I forgot the code snippet. cfquery name=qTransCheck datasource=#DSN# dbtype=odbc select distinct(count prodcode) from product where product.manufid = '#scan.manufid#' cfif variables.stError.v010.occurred AND product.famcode2 matches '#left(scan.famcode, 2)#.' /cfif cfif variables.stError.v012.occurred ANDproduct.famcode2 matches '#left(scan.famcode,1)#..' /cfif cfif variables.stError.v008.occurred!--- Nothing ---/cfif cfif not variables.stError.v010.occurred and not variables.stError.v012.occurred and not variables.stError.v008.occurred AND product.famcode2 = '#scan.famcode#' /cfif and product.famcode '000' and product.prodcode not in (select prodcode from product where manufid='#scan.manufid#' cfif variables.stError.v010.occurred and product.famcode matches '#left(scan.famcode, 2)#.') /cfif cfif variables.stError.v012.occurred and product.famcode matches '#left(scan.famcode,1)#..') /cfif cfif variables.stError.v008.occurred ) !--- Nothing --- /cfif cfif not variables.stError.v010.occurred and not variables.stError.v012.occurred and not variables.stError.v008.occurred AND product.famcode = '#scan.famcode#' ) /cfif /cfquery On Mon, Mar 16, 2009 at 3:45 PM, Steve Lichtenberg slich...@starpower.net wrote: Can anyone point me to the error in this code and the generated query? I am kind of stuck right now as it all looks ok to me. Thanks --S ^ [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about prodcode) from product where product.man (10713) The error occurred in C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 189 : not variables.stError.v008.occurred 190 : AND product.famcode = '#scan.famcode#' ) 191 : /cfif 192 : /cfquery 193 : /cfif SQLselect distinct(count prodcode) from product where product.manufid = '030030' AND product.famcode2 = '111' and product.famcode '000' and product.prodcode not in (select prodcode from product where manufid='030030' AND product.famcode = '111' ) -- Jean Anouilh - What you get free costs too much. -- Jean Anouilh - What you get free costs too much. ~| 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:320553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Syntax error
Can anyone point me to the error in this code and the generated query? I am kind of stuck right now as it all looks ok to me. Thanks --S ^ [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about prodcode) from product where product.man (10713) The error occurred in C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 189 : not variables.stError.v008.occurred 190 : AND product.famcode = '#scan.famcode#' ) 191 : /cfif 192 : /cfquery 193 : /cfif SQLselect distinct(count prodcode) from product where product.manufid = '030030' AND product.famcode2 = '111' and product.famcode '000' and product.prodcode not in (select prodcode from product where manufid='030030' AND product.famcode = '111' ) -- Jean Anouilh - What you get free costs too much. ~| 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:320554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Syntax error
Thanks. I found it finally. The right syntax (for this issue) is select count(distinct prodcode) as prodcnt There was a second issue with computed_field_1 the was being bounced by the ODBC driver as well. On Mon, Mar 16, 2009 at 3:54 PM, Jason Fisher ja...@wanax.com wrote: This is invalid: distinct(count prodcode) Are you trying to do a DISTINCT on the aggregate function COUNT()? Not sure that would work, but it would have to be DISTINCT COUNT(prodcode) if that's what you're after. ~| 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:320556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Syntax error
worked for me. Plus, that is what Adobe shows in their docs. 2009/3/16 Jason Fisher ja...@wanax.com: Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in handy some day. Thanks! ~| 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:320559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Point me in the right direction - expand a category from a query...
The easiest library I have found to accomplish this is HTMLXtree. They have a good set of other widgets (tabs, editors etc) but the tree view is excellent. You can set it to output only the trunk nodes and query later for the leaves as a user opens the folder. It also allows for custom graphics and includes a folder metaphor and character listing (+/_ graphics). There is a free version that doesn't handle XML output or a paid version that does. There is a slight learning curve but overall very powerful and easy to use. Support is excellent as well. Just post your questions and within a day someone will answer. --S ^ On Thu, Jan 8, 2009 at 6:21 PM, Dominic Watson watson.domi...@googlemail.com wrote: Yeh, I'm with Adrian, though whatever js library you're most familiar with will do. If there is a CF tag for doing this it would either be outputting some javascript or a generating flash which, while good for quick solutions, doesn't really fit into a long-term client-side way of coding in my opinion; there simply isn't the completeness or flexibility that is offered from the various js libraries. Also, as Adrian demonstrated; with a working knowledge of any of the libraries, not using CF for such things is really just as quick and simple. Truly seperating display logic and business logic, added with crossing the js noob / js journeyman border is quite a light-bulb moment I think. My tuppence, Dominic ~| 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:317644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4