Re: CFParam vs. IsDefined

2010-09-02 Thread Steve Lichtenberg
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

Re: coldfusion barcode

2009-09-18 Thread Steve Lichtenberg
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

Problem with CFEXECUTE

2009-09-02 Thread Steve Lichtenberg
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#

Syntax error in SQL statement

2009-06-12 Thread Steve Lichtenberg
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 =

steve.lichtenberg has invited you to Spokeo

2009-05-05 Thread steve . lichtenberg
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

Re: SQL Syntax error

2009-03-16 Thread Steve Lichtenberg
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

SQL Syntax error

2009-03-16 Thread Steve Lichtenberg
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

Re: SQL Syntax error

2009-03-16 Thread Steve Lichtenberg
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:

Re: SQL Syntax error

2009-03-16 Thread Steve Lichtenberg
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Ā®

Re: Point me in the right direction - expand a category from a query...

2009-01-09 Thread Steve Lichtenberg
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