Re: Error converting data type varchar to numeric

2008-09-26 Thread Larry Juncker
I was under the understanding that if null="Yes", then the value was igored and not sent to the SP -- Larry Juncker ALJ Computer Services, LLC 10 No 11th Street Fort Dodge, IA 50501-4010 (515) 576-8510 President & CEO >LJJ> I've had problems in the past passing "" to numeric fields. >LJJ> >LJ

Re: CTO Opportunity

2008-09-26 Thread Adam Haskell
Good point ;) Adam On Fri, Sep 26, 2008 at 6:10 PM, Eric Roberts < [EMAIL PROTECTED]> wrote: > Then you would be perfect for an executive position *ducking* > > Eric > ~| Adobe® ColdFusion® 8 software 8 is the most important a

Re: CF 8 Standard and Exchange Integration

2008-09-26 Thread James Holmes
All of the restricted features are served via the Enterprise Feature Router, which means they are single threaded. Multiple requests involving these features get queued up. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/9/27 Kevin Miller <[EMAIL PROTECTED]>

Re: Error converting data type varchar to numeric

2008-09-26 Thread Sam Roach
I've had problems in the past passing "" to numeric fields. EX: cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="FIELD_GOAL" value="" null="YES" try putting a value in as a test to see if this is where your error is. EX: cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="FIEL

RE: CTO Opportunity

2008-09-26 Thread Eric Roberts
Then you would be perfect for an executive position *ducking* Eric /*-Original Message- /*From: Adam Haskell [mailto:[EMAIL PROTECTED] /*Sent: Friday, September 26, 2008 3:26 PM /*To: cf-talk /*Subject: Re: CTO Opportunity /* /*Thanks I am what you would call a moron. /* /*Adam :) /* /*On

Re: Ordered Argument names

2008-09-26 Thread C S
> Well it has to really - unnamed arguments in a random order would be > impossible to use. > But it'd be handy if they made named arguments work in the right order > too. {Smack} Of course the reason it works has nothing to do with arguments object itself. Talk about "Friday density" ;-) >

Re: (ot) Best development laptop

2008-09-26 Thread Charlie Griefer
hehe i knew that bit was gonna catch a mac person's attention :) On Fri, Sep 26, 2008 at 2:47 PM, J.J. Merrick <[EMAIL PROTECTED]>wrote: > Andy, > > Could you expand on the small apps that you need? I am just curious as > to what they are. I made the switch back in Feb and have found that > 9

Re: (ot) Best development laptop

2008-09-26 Thread J.J. Merrick
Andy, Could you expand on the small apps that you need? I am just curious as to what they are. I made the switch back in Feb and have found that 99% of my needs have been met... the 1% is for TortoiseSVN :-) J.J. On Fri, Sep 26, 2008 at 4:12 PM, Andy Matthews <[EMAIL PROTECTED]> wrote: > @Joch

Re: (ot) Best development laptop

2008-09-26 Thread Mark Mandel
I second the choice to gets something with a 17" screen. I've been running a Dell XPS M1710 (they have since updated) as my laptop, and it is a beefy machine, and its been really nice! When I was looking around, the beefiest machine, with the highest screen resolution was the Dell XPS, and it was

RE: Error converting data type varchar to numeric

2008-09-26 Thread Larry Juncker
Anybody This is something that I really need help on... Thanks Again in advance -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 2:50 PM To: cf-talk Subject: Error converting data type varchar to numeric Can anyone help me with

RE: Error converting data type varchar to numeric

2008-09-26 Thread Larry Juncker
Anybody This is something that I really need help on... Thanks Again in advance -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 2:50 PM To: cf-talk Subject: Error converting data type varchar to numeric Can anyone help me with

Re: Ordered Argument names

2008-09-26 Thread Charlie Griefer
On Fri, Sep 26, 2008 at 2:08 PM, Peter Boughton <[EMAIL PROTECTED]> wrote: > > >don't believe structs are inherently meant to be 'ordered'. > > > > Yes, that is my understanding too. Interesting that it does seem to > > return the correct order if you do not use named arguments. > > Well it has t

RE: (ot) Best development laptop

2008-09-26 Thread Andy Matthews
@Jochem...unlikely that we'd have all 4 concurrent, but it's possible. Probably not for long periods of time though. Mostly working from desks, but I would be doing graphics work ala Photoshop and Flash, and screen real estate is of crucial importance. I'd rather deal with the additional weight, an

Re: Ordered Argument names

2008-09-26 Thread Peter Boughton
> >don't believe structs are inherently meant to be 'ordered'. > > Yes, that is my understanding too. Interesting that it does seem to > return the correct order if you do not use named arguments. Well it has to really - unnamed arguments in a random order would be impossible to use. But it'

Re: (ot) Best development laptop

2008-09-26 Thread Jochem van Dieten
Andy Matthews wrote: > It's been suggested that the dev dept at our company (of which I am a part) > get rid of our desktop machines and replace them with laptops. I'd like to > run it past you guys and see what you thought about good, beefy development > machines. How mobile is your team? Will

Re: (ot) Best development laptop

2008-09-26 Thread J.J. Merrick
Aqua Data Studio allows you to hook in to MSSQL... I just use a parallels VM for whenever I need to run enterprise manager. J.J. On Fri, Sep 26, 2008 at 12:38 PM, Andy Matthews <[EMAIL PROTECTED]> wrote: > I wouldn't be adverse to this, but I think we probably want to avoid the > expense of a

Re: (ot) Best development laptop

2008-09-26 Thread J.J. Merrick
If you can then obviously I am going to say that the MBP are the way to go. if you HAVE to have PC then I second the Dell D series. I just moved from a 4 year old D400 with 2 gigs of ram and I loved all the peripherals you could get. Having a docking station was awesome and they are just good soli

Re: (ot) Best development laptop

2008-09-26 Thread Jim Rising
i would also vote for the MBP ... and you can install vmware or parallels and run MSSQL (along with all the tools) within a virtualization instance... and yes... there are awesome db tools available for MSSQL ... Razor: http://www.razorsql.com/download_mac.html DB Solo2: http://www.dbsolo.com/dow

Re: CTO Opportunity

2008-09-26 Thread Adam Haskell
Thanks I am what you would call a moron. Adam :) On Fri, Sep 26, 2008 at 3:41 PM, Maureen <[EMAIL PROTECTED]> wrote: > FYI - You sent this message to the entire list. The employer's > contact info is at the bottom of the message. > > > On Fri, Sep 26, 2008 at 12:30 PM, Adam Haskell <[EMAIL PRO

RE: Ordered Argument names

2008-09-26 Thread Weidler, Wilfred C.
@Dan - Good question. If you are sending the argument name in the call to the cffunction then they can be in any order and the cffunction will figure it out. -Chuck ~| Adobe® ColdFusion® 8 software 8 is the most important and

Re: Ordered Argument names

2008-09-26 Thread C S
>That's pretty funky (the difference in behavior between hotfixes). Altho i >don't believe structs are inherently meant to be 'ordered'. Yes, that is my understanding too. Interesting that it does seem to return the correct order if you do not use named arguments.

RE: Ordered Argument names

2008-09-26 Thread Dan G. Switzer, II
>>You should be able to loop through the arguments array: >> >> >> >> >> >> >> > >Nope, that gives values not names (assuming 1 -> i) > >Also, it doesn't come out in the same order each time. > >It *should* since arrays are supposed to be ordered, but in my version of >CF the values are switc

Re: (ot) Best development laptop

2008-09-26 Thread Gerald Guido
Best development laptop? Huh... that's not a loaded question? The two factors (other than price) that drove my decision was RAM and screen real estate. RAM is obvious, especially if Vista and Java come into play. Java reminds me of the scene from Austin Powers where Fat Bastard was eating in bed.

Re: Ordered Argument names

2008-09-26 Thread Peter Boughton
>You should be able to loop through the arguments array: > > > > > > > Nope, that gives values not names (assuming 1 -> i) Also, it doesn't come out in the same order each time. It *should* since arrays are supposed to be ordered, but in my version of CF the values are switching around e

Re: Ordered Argument names

2008-09-26 Thread Charlie Griefer
On Fri, Sep 26, 2008 at 12:52 PM, C S <[EMAIL PROTECTED]> wrote: > >using your code on CF8 (8,0,0,176276), i get the structs returned in the > >same order (alpha by key name) each time. neither arbitrary nor random. > > With 8,0,1,195765 I get a different order each time. Unless I drop the > arg

RE: Ordered Argument names

2008-09-26 Thread Weidler, Wilfred C.
Here try this. Notice the cfset in the cffunction. -Chuck ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doublecl

Re: Ordered Argument names

2008-09-26 Thread Peter Boughton
>using your code on CF8 (8,0,0,176276), i get the structs returned in the >same order (alpha by key name) each time. Odd. I'm on 8,0,1,195765 and it's definitely not alphabetic. For first, second and fourth I get "c,a,b", "y,z,x" and "d,f,b" Oddly, the third one switches between "y,a,b,x" or "y,b

Re: Inserting an image in a PDF?

2008-09-26 Thread Aaron C
Thanks! That works quite well. I just have to fine tune the positioning, but it seems to be working exactly as I was wanting. On Thu, Sep 25, 2008 at 3:10 PM, Andrew Powell <[EMAIL PROTECTED]> wrote: > We've been using "watermark" for this > foreground="no" opacity="10" pages="1" position = "0,

Re: Ordered Argument names

2008-09-26 Thread C S
>using your code on CF8 (8,0,0,176276), i get the structs returned in the >same order (alpha by key name) each time. neither arbitrary nor random. With 8,0,1,195765 I get a different order each time. Unless I drop the argument names.

Error converting data type varchar to numeric

2008-09-26 Thread Larry Juncker
Can anyone help me with this? I have no VARCHAR values going into any numeric fields.The error seems to be coming form my cfprocresult tag All values in the table can be null except the automatic column which is not even mentioned in this SP Any help would be gretly appreciated. Thanks

Re: Ordered Argument names

2008-09-26 Thread Charlie Griefer
using your code on CF8 (8,0,0,176276), i get the structs returned in the same order (alpha by key name) each time. neither arbitrary nor random. i understand this isn't necessarily what you want... but it does seem to be consistent (for whatever that's worth). On Fri, Sep 26, 2008 at 12:21 PM, P

RE: Ordered Argument names

2008-09-26 Thread Dan G. Switzer, II
>Does anyone know how to make CF provide a list of the names of Arguments in >the order provided and without using cfargument tag? > >StructKeyList/StructKeyArray returns an arbitrary order in CF8, and a >random order every time in CF7. > >Using Array functions on the Arguments scope results in a r

Ordered Argument names

2008-09-26 Thread Peter Boughton
Does anyone know how to make CF provide a list of the names of Arguments in the order provided and without using cfargument tag? StructKeyList/StructKeyArray returns an arbitrary order in CF8, and a random order every time in CF7. Using Array functions on the Arguments scope results in a random

Re: cfdocument font problem

2008-09-26 Thread BJ McShane
Thanks! That did it. I put the cfdocumentsction around each include and each page came out the way I wanted it to. I'll need to mess around with the cfpdf tag in the future to see what I can do with that. bj >try putting them in different cfdocumentsection's. one section for each >program

CF 8 Standard and Exchange Integration

2008-09-26 Thread Kevin Miller
Can someone describe the differences in capability for Microsoft Exchange integration between CF 8 Standard and Enterprise? Adobe's site is very vague, and I'm not sure to what extent the Standard version is feature crippled. Thanks, Kevin ~

Re: 404 onMissingTemplate works with html, not with cfm

2008-09-26 Thread Justin Scott
> Can you explain this in greater detail? As you know, requests come through IIS. For a simple page such as whatever.htm, it looks on the hard drive for whatever.htm, and if it's found, it is read and sent to the visitor. If it's not found, IIS goes to the error control settings to see what i

RE: (ot) Best development laptop

2008-09-26 Thread Dave Watts
> I wouldn't be adverse to this, but I think we probably want > to avoid the expense of a full MBP, plus we only use SQL > Server and there's no tools for the Mac, for MSSQL are there? There are no native tools (obviously), but there are third-party tools that are sufficient for building queries

Re: List and count from a database

2008-09-26 Thread daniel kessler
>Use SQL to do this: That worked great - thanks Michael ~| 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

RE: (ot) Best development laptop

2008-09-26 Thread Eric Roberts
BTW...it's a 2.33gig Centrino Duo, 3 gig of ram and an ATI Radeon FireGL card. It also has an 80gig drive on board. At work I hook it up to a 17" widescreen lcd. I have also hooked it up at home to my 37" widescreen LCD TV (it has a vga hookup on it) and played World of Warcraft and it looks awe

RE: (ot) Best development laptop

2008-09-26 Thread Eric Roberts
I have a maxed out Lenovo T60p and kicks a**. Their newer model, T61p is even better. Eric /*-Original Message- /*From: Andy Matthews [mailto:[EMAIL PROTECTED] /*Sent: Friday, September 26, 2008 11:28 AM /*To: cf-talk /*Subject: (ot) Best development laptop /* /*It's been suggested that

Re: 404 onMissingTemplate works with html, not with cfm

2008-09-26 Thread Paul Ihrig
Justin Can you explain this in greater detail? thanks On Fri, Sep 26, 2008 at 11:49 AM, Justin Scott <[EMAIL PROTECTED]> wrote: >> but if it is a missing .cfm >> i just get the cf debugger, and not a 404.cfm page > > If you're running IIS, you can set the ISAPI filter and extension > handler to

Re: 404 onMissingTemplate works with html, not with cfm

2008-09-26 Thread Paul Ihrig
i have a Missing Template Handler in cf admin /404.cfm also the default 404 in IIS points to 404.cfm every thig works well UNLESS it is a missing *.cfm file then the 404.cfm seems to be ignored and i get the cf debugger looking thing saying file not found. 404 URL /404.cfm ~~

RE: (ot) Best development laptop

2008-09-26 Thread Andy Matthews
I wouldn't be adverse to this, but I think we probably want to avoid the expense of a full MBP, plus we only use SQL Server and there's no tools for the Mac, for MSSQL are there? andy -Original Message- From: Wil Genovese [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 12:09

RE: (ot) Best development laptop

2008-09-26 Thread Dave Watts
> It's been suggested that the dev dept at our company (of > which I am a part) get rid of our desktop machines and > replace them with laptops. I'd like to run it past you guys > and see what you thought about good, beefy development > machines. Here's a partial list of the things that would n

RE: List and count from a database

2008-09-26 Thread Dawson, Michael
Use SQL to do this: SELECT category ,COUNT(category) AS categoryCount FROM MyTable GROUP BY category m!ke -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 12:31 PM To: cf-talk Subject: List and count from a database I a

Re: (ot) Best development laptop

2008-09-26 Thread Dana Kowalski
For my personal laptop I use the 17in MBP and its incredible. I had some issues initially configuring CF 8 + Apache but once I overcame that hurdle it works great. I've never encountered a slowdown or any hangs. For work we stick with the Dell D series. If you put enough ram in, they've worked

List and count from a database

2008-09-26 Thread daniel kessler
I am querying a db and it worked fine. The results are of a single field, category, and they're in ascending order I want to loop through the results, count up how many of each item are repeated, then put out the item and the count. So the record set currently looks like this: Health in the

RE: (ot) Best development laptop

2008-09-26 Thread Dave Watts
> I would ONLY try this with XP though. I have since gone to > an HP Quad-core with 3G RAM running Vista and it's PAINFUL. > It's been a year and I'm close to having to reinstall with XP. Have you tried disabling Aero Glass? My Vista machines perform as well as they did with XP. Dave Watts, CTO

Re: (ot) Best development laptop

2008-09-26 Thread Josh Nathanson
I've used my Toshiba Tecra A4 laptop for over three years now, toting it back and forth to the office every day, and I've had absolutely no problems with it. My particular machine isn't super beefy, but just as a brand, I'd highly recommend Toshiba products. If you got one of their higher end

Re: (ot) Best development laptop

2008-09-26 Thread Wil Genovese
For myself I switched to a MacBook Pro back in February. It runs fast without crashing and can easily handle CF8 64bit Dev edition, PostgreSQL 8.xx DB server, CfEclipse, and all my other apps including iTunes playing music at the same time. All this on a 2.2Ghz Intel Duo CPU and 2Gb RAM.

Re: (ot) Best development laptop

2008-09-26 Thread Greg Morphis
I use a Dell D630 2Ghz intel core 2 duo processor, 2 GB of RAM for work. It could use another gig of RAM to make it sweeter but it's not bad at all. I run multiple instances of Toad, IE, Firefox, Eclipse, CF (development), at times add Dreamweaver to that list.. all with no problems. At home I have

Re: (ot) Best development laptop

2008-09-26 Thread Greg Luce
I have used a HP ZD7000 for 4+ years. 3 years as a primary development machine. I would run it in the docking station with another 19" flat panel next to it with CF7-8/MSSQL2005/WAMP/CS3... This was a nice rig. It has a P4 3GHz CPU and 2G RAM. If you can find something modern like that with an upri

(ot) Best development laptop

2008-09-26 Thread Andy Matthews
It's been suggested that the dev dept at our company (of which I am a part) get rid of our desktop machines and replace them with laptops. I'd like to run it past you guys and see what you thought about good, beefy development machines. Here's a partial list of the things that would need to run

Re: Using session variable data to create a chart?

2008-09-26 Thread Rob Parkhill
Why can't you use the session variables in the Cfchart tag? if you really can't, you could assign the session variables to a page variable, and use those in the cfchart. although I would be surprised if you couldn't just use the session variables. Rob On Fri, Sep 26, 2008 at 11:51 AM, Fawzi Amad

Using session variable data to create a chart?

2008-09-26 Thread Fawzi Amadu
I have written a query of queries that returns the required results. From those results I find aggregates of the various data groupings being returned (these are stored in session variables). What I need to do now is to use the aggregate results that exist in session variables to create a pie

Re: 404 onMissingTemplate works with html, not with cfm

2008-09-26 Thread Justin Scott
> but if it is a missing .cfm > i just get the cf debugger, and not a 404.cfm page If you're running IIS, you can set the ISAPI filter and extension handler to "check if file exists" (off by default) which will cause IIS to actually look for the file on disk and only pass the request to ColdFu

Re: 404 onMissingTemplate works with html, not with cfm

2008-09-26 Thread Charlie Griefer
you need to set a sitewide missing template handler in the cf admin. if you're on CF 8, you can add an onMissingTemplate method to your Application.cfc on a per-application basis (if need be). On Fri, Sep 26, 2008 at 8:32 AM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > ok.. > i am not sure what to lo

404 onMissingTemplate works with html, not with cfm

2008-09-26 Thread Paul Ihrig
ok.. i am not sure what to look at. if you type a file like whatever.htm our custom 404 page pops up just fine. but if it is a missing .cfm i just get the cf debugger, and not a 404.cfm page you know The web site you are accessing has experienced an unexpected error. Please contact the website

Re: cfdocument font problem

2008-09-26 Thread Yuliang Ruan
try putting them in different cfdocumentsection's. one section for each program ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;294

Re: cfdocument font problem

2008-09-26 Thread BJ McShane
Thanks, I'm on CF8 so I'll go ahead and try and set that up. bj ~| 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 Archiv

Re: cfdocument font problem

2008-09-26 Thread Ian Skinner
BJ McShane wrote: > My guestion is am I doing something wrong or is there a trick to force it to > behave one way for one program and another way for another program. I like > the cfdocument tag but it seems like it still has a lot of problems. I guess > I'm going to break the printable button

cfdocument font problem

2008-09-26 Thread BJ McShane
I'm trying to deliver a packet of information to my user in a cfdocument format. I have five programs and each program will build a printable page. I created a program and have cfdocument tag around it and this program I use the cfinclude tag to include the 5 programs. I do it this way because

How to create force.com contact?

2008-09-26 Thread Rob Sherman
Hi, I'm having trouble finding any good examples of using coldfusion 8 to create a salesforce / force.com contact record. I'm using the Enterprise WSDL and I specifically don't want leads (at least the client doesn't), just contacts. I've poked around and found a few soap examples because force s

Re: ColdFusion Consultant as a Java Consultant?

2008-09-26 Thread Adam Haskell
Let me know how much repeat business you get with that tactic please. Adam On Fri, Sep 26, 2008 at 3:31 AM, Jochem van Dieten <[EMAIL PROTECTED]>wrote: > Dakota Burns wrote: > > Thanks all for the followup! I'm sorry, but it was "My Bad" on the > subject > > line. I wasn't trying to suggest th

Re: ColdFusion Consultant as a Java Consultant?

2008-09-26 Thread James Holmes
Just remember to include the cost of the CF license in your quote. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/9/26 Jochem van Dieten <[EMAIL PROTECTED]> > Dakota Burns wrote: > > Thanks all for the followup! I'm sorry, but it was "My Bad" on the > subjec

Re: cfargument type equals 1 of 2 options

2008-09-26 Thread Richard White
thanks Micheal, will look into this. >You could use a type of "string", then have a regex that test for the >allowed values. > >Mike > >Hi > >in one of our functions we need someone to pass in one of 2 options >("exist" or "not exists") > >we have thought about making the argument type a boolea

Re: Chrome: Cfinput text area: fckeditor

2008-09-26 Thread Tom Chiverton
On Thursday 25 Sep 2008, Paul Ihrig wrote: > the fckeditor in cf8 dosnt seem to render in chrome. > any ideas? Stop caring ? Unless you're user base is *very* weird, no one is using that browser. -- Tom Chiverton Helping to widespreadedly facilitate industry-wide dot-com advanced high-yield app

Re: My first attempt to install 64bit CF did not go well...

2008-09-26 Thread denstar
On Thu, Sep 25, 2008 at 10:02 AM, Ian Skinner wrote: > All the logs we have looked at show now errors... > > We can run ColdFusion from the command line /jrun4/bin/jrun -start > cfusion... > Nothing out of the ordinary happens during this. > > But when running Apache dies.. and will not even serve

Re: ColdFusion Consultant as a Java Consultant?

2008-09-26 Thread Jochem van Dieten
Dakota Burns wrote: > Thanks all for the followup! I'm sorry, but it was "My Bad" on the subject > line. I wasn't trying to suggest that a CF Developer could present him or > herself as a Java developer, but rather present the idea of a CF Developer > persuading a company to use ColdFusion versus

Re: Chrome: Cfinput text area: fckeditor

2008-09-26 Thread Mike Kear
I've taken another look at this, and it seems fairly straightforward to me. I think most of the differences between a default installation of FCKEditor and the one delivered with ColdFusion are either files omitted because they're unnecessary - related to the ASP or PHP implementation for example