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 wrote: > > On Thu, Sep 2, 2010 at 5:00 AM, Peter Boughton > 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 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: 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, 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
worked for me. Plus, that is what Adobe shows in their docs. 2009/3/16 Jason Fisher : > > 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: 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 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
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 : 192 : 193 : 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
I forgot the code snippet.
select distinct(count prodcode)
from product
where product.manufid = '#scan.manufid#'
AND product.famcode2 matches '#left(scan.famcode, 2)#.'
ANDproduct.famcode2 matches '#left(scan.famcode,1)#..'
AND product.famcode2 = '#scan.famcode#'
and product.famcode > '000'
and product.prodcode not in
(select prodcode from product where manufid='#scan.manufid#'
and product.famcode matches '#left(scan.famcode, 2)#.')
and product.famcode matches '#left(scan.famcode,1)#..')
)
AND product.famcode = '#scan.famcode#' )
On Mon, Mar 16, 2009 at 3:45 PM, Steve Lichtenberg
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 :
> 192 :
> 193 :
>
> 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
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 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
