Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread Matthew Williams
My guess would be it's a Standard, vs an Enterprise install. Those native Oracle drivers are just not up to par with the DataDirect ones. Matthew Williams Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Images Inside of CFDocument Look Awful/Fuzzy

2008-11-03 Thread Peter Boughton
When I attempt to generate the PDF, however, the images are fuzzy, unsharp, and some appear to have compression artifacts. 1) Has anyone noticed this? 2) If so, how did you fix it? How can you get crisper images from the PDF generated from CFDocument? It's because the images are too

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread James Holmes
I'm assuming Enterprise because of this: J2EE server:Weblogic8.1u6 The only way to get CF running on that is via the Enterprise WAR/EAR deployment. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/11/3 Matthew Williams [EMAIL PROTECTED]: My guess would be

coldfusion8 is amazing!

2008-11-03 Thread Don L
It's no wonder why so many developers like it (no, not meant to apple-polish Adobe), just a quick reflection. Just tried silient installation of cf8 on XP Home edition beta 2 (unfortunately can't find a XP Home Edition -- released copy and can't wait to purchase it over the net...),

Re: Images Inside of CFDocument Look Awful/Fuzzy

2008-11-03 Thread Tom Chiverton
On Thursday 30 Oct 2008, Matthew Reinbold wrote: When I attempt to generate the PDF, however, the images are fuzzy, unsharp, and some appear to have compression artifacts. I bet they have to be resized to fit the page or something, right ? -- Tom Chiverton Helping to paradigmatically

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread Matthew Williams
That begs the question then of why is the OP using the data source capability into WebLogic over the datasource that you can define in ColdFusion? Matthew Williams Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the

Adobe Certified ColdFusion Developer Directory

2008-11-03 Thread Dave Phillips
Hi all, Macromedia had a page on their site that allowed someone to verify that a person was a Certified ColdFusion MX 7 Developer or Advanced Certified ColdFusion MX 7 Developer. Does anyone know where this page can be found? I have not been able to located it on Adobe's website.

Re: Adobe Certified ColdFusion Developer Directory

2008-11-03 Thread Mike Kear
they pulled it down . They alleged it was something to do with privacy. But i think it had more to do with the total disarray the certification is in. and continues to be in. Either way - by design or incompetence, the page has gone Cheers Mike Kear Windsor, NSW, Australia Adobe Certified

RE: LDAP Query Performance question

2008-11-03 Thread Burns, John D
Mike- When you do this is this a loop that runs 5500 queries or 1 query that updates 5500 records? Just curious what the impact is for each connection. John -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 3:45 PM To: cf-talk Subject:

RE: LDAP Query Performance question

2008-11-03 Thread Dawson, Michael
My current process is to query AD using CFLDAP. That returns about 5,500 user objects. Then, I loop over those results and perform a CFQUERY to a SQL 2005 database. Our SQL server is pretty beefy, so we haven't had any performance issues. My goal of this process is to compare names, titles,

Re: conditional cfchartseries

2008-11-03 Thread Tom Chiverton
On Thursday 30 Oct 2008, Jason Fisher wrote: Just keep/set a variable before you define the chart: This is *much* clearer and more maintainable than iif()/de(). -- Tom Chiverton Helping to synergistically envisioneer ROI This email is

RE: LDAP Query Performance question

2008-11-03 Thread Burns, John D
See, I'm doing the opposite. I'm getting a list of accounts from a SQL database and trying to then perform a read query to get those user accounts from AD. However, I can't find an elegant way to do that in 1 query so I'm looping over my results and doing individual queries to the AD for each

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread Tom Chiverton
On Monday 03 Nov 2008, Matthew Williams wrote: That begs the question then of why is the OP using the data source capability into WebLogic over the datasource that you can define in ColdFusion? We used data sources defined in WebLogic because they could then be managed by the same stuff that

RE: LDAP Query Performance question

2008-11-03 Thread Dawson, Michael
Would it help if you used some sort of group membership? For example, your SQL query would add all accounts to a domain group, or remove accounts, as needed. Then, you would just pull all members of that group in one CFLDAP query. I do something similar to this every morning. My process

Post Code Check

2008-11-03 Thread Jason Congerton
I am trying to create a postal code and delivery cost app for my company, I have set the tables up as tbl name au_zones: au_zone_id, au_zone(postal zone), au_basic(min cost), au_costpk(cost per kilo) tbl name postCodes: post_code_id, postcode(postal code), pc_zoneid(link to au-zones) tbl

Parsing timestamp set by phpBB

2008-11-03 Thread Jason Durham
I have a date represented as 993124800 in my database that php's date() function is able understand and format. I'm running into dead ends trying to have ColdFusion parse this date correctly. That date should work out to... June 21, 2001, 7:00 am I've searched Google, RiaForge and CFLib.

Alternatives for Assembla's SVN

2008-11-03 Thread Rick Faircloth
Hi, all... I've been using Assembla's SVN service and it's worked well, espeically for a free service. However, they're now becoming a paid service unless the spaces are made public. I don't mind paying (it would cost me $17.30 per month under the new plans) for a good service. I've never

Re: Parsing timestamp set by phpBB

2008-11-03 Thread C S
I have a date represented as 993124800 in my database that php's date() function is able understand and format. I'm running into dead ends trying to have ColdFusion parse this date correctly. That date should work out to... That looks like an epoch time. Try

Re: Parsing timestamp set by phpBB

2008-11-03 Thread Wil Genovese
If its EPOCH time then this will work. I wrote a simple function for that ages ago. cfscript /*# # epochtime by Wil Genovese # #take a time format and convert either

RE: Parsing timestamp set by phpBB

2008-11-03 Thread Jason Durham
Thank you Wil and CS. I was able to output the date how I want it with... #DateFormat(DateAdd(s, 993124800, January 1 1970 00:00:00),long)# #TimeFormat(DateAdd(h,-getTimeZoneInfo().utcHourOffset,DateAdd(s, 993124800, January 1 1970 00:00:00)),long)# Now I'll go back through it to simplify its

Re: Parsing timestamp set by phpBB

2008-11-03 Thread Eric Haskins
?php echo date(F d, Y,g:i a,'993124800'); ? Gives me this output??? June 21,2001,8:00 am Eric Haskins On Mon, Nov 3, 2008 at 11:31 AM, Jason Durham [EMAIL PROTECTED] wrote: I have a date represented as 993124800 in my database that php's date() function is able understand and format. I'm

Re: Parsing timestamp set by phpBB

2008-11-03 Thread Eric Haskins
Sorry misread able as unable :) its monday but yeah it is Epoch Eric On Mon, Nov 3, 2008 at 12:11 PM, Eric Haskins [EMAIL PROTECTED] wrote: ?php echo date(F d, Y,g:i a,'993124800'); ? Gives me this output??? June 21,2001,8:00 am Eric Haskins On Mon, Nov 3, 2008 at 11:31 AM, Jason

Re: How can you have a variable topmargin height on CF8 CFDOCUMENT so that you can have 2 differently sized headers?

2008-11-03 Thread Chris Johnson
I did find one possible solution that I don't like, but should support most report templates that need differently sized primary and secondary headers. I'm creating two cfdocumentsections with different topmargin values. Each cfdocumentsection has their own cfdocumentitem headers. The next

Re: Post Code Check

2008-11-03 Thread Jason Fisher
Do it all in one query: SELECT p.product_name, p.weight, ( SELECT (z.au_basic + (z.au_costpk * p.weight)) FROM au_zones z INNER JOIN postCodes c ON z.au_zone_id = c.pc_zone_id WHERE c.postcode = cfqueryparam= cfsqltype=CF_SQL_VARCHAR value=#form.postalCode# ) AS deliveryCost FROM products p

Re: Parsing timestamp set by phpBB

2008-11-03 Thread Paul Hastings
Eric Haskins wrote: Sorry misread able as unable :) its monday but yeah it is Epoch just fyi, there are more than one Epoch. java uses ms since 1-jan-1970, unix uses seconds since 1-jan-1970, cf/db2/excel use decimal days since 31-dec-1899. you need to be careful to get the units Epoch right.

variables declaration in udfs

2008-11-03 Thread Brian Dumbledore
I have a udf, to force a query in the udf to be local, I jsut do a cfset var qname = before I do the cfquery, I have a bunch of queries and variabels in the udf, is there no other easier way than to put as many cfsets as there are variables???

RE: variables declaration in udfs

2008-11-03 Thread Adrian Lynch
cfset var LOCAL = StructNew() or {} if on CF8. Then reference all your local vars as LOCAL.queryName etc. Adrian Building a database of ColdFusion errors at http://cferror.org/ -Original Message- From: Brian Dumbledore Sent: 03 November 2008 19:50 To: cf-talk Subject: variables

Cf8 bug?

2008-11-03 Thread Don
Perhaps you've ran into this before. Within a cfc I'm simply looping over a query object and using the ID value from the query to call an external cfc method that eventually calls a method contained within the same CFC as the code below appears. The problem is that using dot notation or array

RE: Cf8 bug?

2008-11-03 Thread Mark Kruger
Looks to me like you need a row number in your query call Consider this code: local[qryItems][id]) This will always get the first row - yes? Since you are in a loop... Shouldn't this be just id (wich would give you local.qryItems['id'][currentrow]). I would also say that you better have a

Re: Post Code Check

2008-11-03 Thread Jason Congerton
excellent, thank you very much. works a treat. Do it all in one query: SELECT p.product_name, p.weight, ( SELECT (z.au_basic + (z.au_costpk * p.weight)) FROM au_zones z INNER JOIN postCodes c ON z.au_zone_id = c.pc_zone_id WHERE c.postcode = cfqueryparam= cfsqltype=CF_SQL_VARCHAR

Script to move email to from undelivr to spool?

2008-11-03 Thread Nick Gleason
Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck.

Re: Script to move email to from undelivr to spool?

2008-11-03 Thread Shannon Peevey
What platform are you on, and what is the criteria needed to move the messages? Speeves On 11/3/08, Nick Gleason [EMAIL PROTECTED] wrote: Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk

Re: Script to move email to from undelivr to spool?

2008-11-03 Thread AJ Mercer
This might give you some ideas http://www.coldfusionjedi.com/index.cfm/2006/1/16/Yet-another-project--announcing-SpoolMail you can manage your undelivered emails from within CFIDE On Mon, Nov 3, 2008 at 10:27 PM, Nick Gleason [EMAIL PROTECTED]wrote: Hi folks, We need to develop a script

CF DATEDIFF Function

2008-11-03 Thread LSD 4Me
Hi, Can anybody explain why the return value is '0' when determining the difference in dates between today and tommorow? IE... cfset showdiff = #datediff('d',now(),'11/04/2008')# cfdump var=#showdiff# What i interpret from the datediff statement is that I need the difference in (days)

RE: Script to move email to from undelivr to spool?

2008-11-03 Thread Nick Gleason
Shannon, Hey there. We're on IIS. But I was imagining that this would be a CF file run by scheduled task once a day or so. However, I'm open to other approaches as well. Nick -Original Message- From: Shannon Peevey [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008

Re: CF DATEDIFF Function

2008-11-03 Thread Azadi Saryev
because your server time is different from your computer's time? your server may be in a timezone where it is already 'tomorrow' while where you are it is still 'today', so now() on the server will return your 'tomorrow' date... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ LSD 4Me

Re: cfgridcolumn

2008-11-03 Thread Alex Yohn
I am having the exact same problem. I populate the GRID from a query, but on the select box columns, if a value is already selected, I do not get the drop down of all the possible values, only the value selected. cfgridcolumn name=misc_cd header=Misc Cd select=true

Re: CF DATEDIFF Function

2008-11-03 Thread Paul Hastings
Azadi Saryev wrote: because your server time is different from your computer's time? your well there's that or that dateDiff returns results for *whole* days (or whatever). try using hours. ~| Adobe® ColdFusion® 8 software 8

Re: CF DATEDIFF Function

2008-11-03 Thread LSD 4Me
Problem is that im not storing time with the date... Also, the return value is '0' for today, and tommorow...i.e Today #datediff(d,now(),now())# Tommorow #datediff(d,now(),now()+1)# I managed to resolve this with another solution... cfset currentdate = #dateformat(now(),'mm,dd,')#

Re: CF DATEDIFF Function

2008-11-03 Thread Azadi Saryev
it's a bad idea to store dates in your db as text. store them as dates. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ LSD 4Me wrote: Problem is that im not storing time with the date... Also, the return value is '0' for today, and tommorow...i.e Today #datediff(d,now(),now())#

Re: Script to move email to from undelivr to spool?

2008-11-03 Thread Dave Watts
Hey there. We're on IIS. But I was imagining that this would be a CF file run by scheduled task once a day or so. However, I'm open to other approaches as well. Why not just write a batch file and schedule that using the Windows scheduler? That would likely be far more efficient. Dave

is ColdFusion still alive in Atlanta

2008-11-03 Thread Michael Firth
Hi all, Man, I have been pounding the job boards here in Atlanta, but seems like all positions are for .Net or PHP. This begs to ask the question is Coldfusion still alive in the Atlanta, area. I've seen a lot of jobs for other locations around the country but all searches come up with