> 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 Wa
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
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...
This returns the INT values i need to begin with (-,0,
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 i
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.
It appears the query is overriding the values/valuesdisplay option. Any ideas?
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 wrote
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 8
Hi,
Can anybody explain why the return value is '0' when determining the difference
in dates between today and tommorow?
IE...
What i interpret from the datediff statement is that I need the difference in
(days) between now() which is 11/03/2008 and 11/04/2008...Should be 1...Keep
gettin
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 scrip
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
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. Does
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 = value="#form.postalCode#">
> ) AS de
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
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 s
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 declaration in udfs
I have a udf, to
I have a udf, to force a query in the udf to be local, I jsut do a 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???
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" r
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 =
) AS deliveryCost
FROM products p
WHERE p.productid IN ( )
#product_name# [#weight# lbs]: $#delive
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 ste
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:
> 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:3
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 running into dead
> ends trying to ha
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
If its EPOCH time then this will work. I wrote a simple function for that
ages ago.
/*#
# epochtime by Wil
Genovese #
#take a time format and convert either to or fr
>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
http://www.cflib.org/index.cf
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 tri
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
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 name
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 determi
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 tha
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 accou
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, pho
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:
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
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.
~
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 most
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...), installatio
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
> 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 to
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 important
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 se
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 benchma
41 matches
Mail list logo