ColdFusion Talk (CF-Talk) Mailing List RSS Feed

Date Range Without Year

Tue, 02 Dec 2008 02:39:00 GMT

Select all events between February 12th and June 10th:

select *
from eventTable
where dateCol between 212 and 610

cheers,
barneyb

On Tue, Dec 2, 2008 at 11:14 AM, Jim McAtee wrote:
> That representation makes sense
[more]

cfpop using hotmail

Tue, 02 Dec 2008 02:33:00 GMT

Two things:
1) There's no need to "bump" a message twice in the span of a minute.
2) If you're getting that error message that means a few things:
a) the port is correct
b) CF is communicating correctly with the "MSN Live" server
c) From the brief
[more]

Date Range Without Year

Tue, 02 Dec 2008 02:31:00 GMT

That representation makes sense, but there needs to be a way to use it to
construct SELECT queries using >=, <=, or BETWEEN. Using expressions with
MySQL functions in the SELECT would be ok, if it can be done.

----- Original Message -----
From
[more]

Date Range Without Year

Tue, 02 Dec 2008 02:00:00 GMT

You could just use numbers to represent the dates. Year runs from 101
to 1231 (thats MDD), and easily create from a date like this:
#month(now()) * 100 + day(now())#. Strings would also work instead of
numbers: "0101" to "1231", and created via #
[more]

Date Range Without Year

Tue, 02 Dec 2008 01:52:00 GMT

The DBMS that I'm using is MySQL 5.0.

I have a table where I want to store begin and end dates _without_ a year.
For example, 'Dec 4' through 'Jun 15'. How can I best represent this in
the database?

I'll be doing selects of the nature

SELECT
[more]

cfpop using hotmail

Tue, 02 Dec 2008 01:52:00 GMT

Bump.

King
[more]

cfpop using hotmail

Tue, 02 Dec 2008 01:51:00 GMT

Bump.

King
[more]

IntelliJ CFML Plugin

Tue, 02 Dec 2008 01:36:00 GMT

With all the excitement over Bolt, I thought this would be a good time to let everyone know the smart guys at JetBrains have been working on a CFML plugin.

It has only been released for a month, but it is rapidly improving. In my opinion IntelliJ is
[more]

charts in pdf's

Tue, 02 Dec 2008 12:28:00 GMT

here is what it looks like:

http://www.flickr.com/photos/tonyweeg/3077068319/sizes/l/

-- tony

Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama

On Tue, Dec 2, 2008 at 12:13 PM, Tony [more]

charts in pdf's

Tue, 02 Dec 2008 12:21:00 GMT

btw, that 77600 is a typo on my paste... not actually the code im
using, and to add
to this, im simply wrapping up this code below in a cfdocument tag.

-- tony

Better than a thousand hollow words, is one word that brings peace.
-- siddhartha
[more]

charts in pdf's

Tue, 02 Dec 2008 12:17:00 GMT

hi bry

nothing.... simply blank white space... well, ill put up a screen cap
of what it looks like...
as there is something that kinda looks like a

that really isnt there.

-- tony

Better than a thousand hollow words, is one word that
[more]

charts in pdf's

Tue, 02 Dec 2008 12:16:00 GMT

xaxistitle="Vehicle"
yaxistitle="Idle time (hrs)"

chartheight="250"
chartwidth="77600"
show3d="no"
sortxaxis="
[more]

charts in pdf's

Tue, 02 Dec 2008 11:42:00 GMT

Hi Tony,
Could you please send code? It would be difficult to troubleshoot without
seeing how you are inserting the chart.

thanks,
speeves

On Tue, Dec 2, 2008 at 10:23 AM, Tony wrote:

> hi there.
>
> i am having an
[more]

There has never been a better time to be a ColdFusion Developer

Tue, 02 Dec 2008 03:43:37 GMT

Adobe® ColdFusion® 8 software is a must-have release for developers to create compelling internet applications that fit in today's enterprise environment. Now you can build rich and engaging application experiences for users that do more and look better faster than ever. There has never been a better time to be a ColdFusion Developer. Get the Free Trial

charts in pdf's

Tue, 02 Dec 2008 11:40:00 GMT

Any broken image icons?

Does anything show?
-

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: bryan@electricedgesystems.com
[more]

charts in pdf's

Tue, 02 Dec 2008 11:31:00 GMT

hi there.

i am having an issue, and ive googled all i can google.
i simply cannot get a png chart to show up in a pdf :(

i can def give you code, but the facts are, that it all
works well and dandy in a browser on a page, but
as soon as i try to
[more]

SQL between dates problem

Tue, 02 Dec 2008 09:54:00 GMT

"datetime" would be your variable or another column to which you would
compare the coupon start/end dates.

Mike

-----Original Message-----
From: Will Tomlinson [mailto:will@wtomlinson.com]
Sent: Monday, December 01, 2008 7:00 PM
To: cf-talk

[more]

Verity writing stuff to my text files

Tue, 02 Dec 2008 09:47:00 GMT

Are they always the same number of lines - like 7?

If they do come back and you don't want to fool with permissions - I'd just strip the last 7 lines before you display the story.

Not elegant but a quick band aid
[more]

IIS Application Pools and ColdFusion

Tue, 02 Dec 2008 09:14:00 GMT

Also give recreate wsconfig another try. Remove the cf instance from IIS and
add the connection again...
This helped me in the past with these weird IIS crashes.

Michael

2008/12/2 Gaulin, Mark

> Another easy thing to
[more]

IIS Application Pools and ColdFusion

Tue, 02 Dec 2008 09:04:00 GMT

Another easy thing to try: Drop and recreate your app pool. It sounds
stupid but we had one server where one app pool wasn't stable but all of
the other servers we had (running the same app) were fine. Recreating
the app pool resolved the issue.

[more]

SQL between dates problem

Tue, 02 Dec 2008 07:08:00 GMT

Screw it. I'm just telling my client to enter the day after as the expiration date of the coupon. It works.

But one thing I noticed and tested is, you can insert a date like so into SQL server and it accepts it and converts it to the right format
[more]

cfautosuggest copying the CFIDE folder problems

Tue, 02 Dec 2008 04:26:00 GMT

Hi

I'm using cfautosuggest and I want to edit the css to change the default
colours.
I have done so on my local server copying the CFIDE folder to the current folder
then using cfajaximport to point to that folder.
This works fine.

I then
[more]

display field in autosuggest

Tue, 02 Dec 2008 04:15:00 GMT

You won't be able to do that with the cfautosuggest unless you make
your own js to compliment it. If you're willing to go that far, you're
probably better off finding a js widget that already does what you're
after; ie. there may something on Yahoo UI
[more]

Simple ecommerce -- not exactly ColdFusion but may be relevant

Tue, 02 Dec 2008 01:06:00 GMT

The company that you will be using to validate and process the card
will take care of telling you if the card is accepted or rejected and
then you code your user response accordingly.  You usually have a
large number of setup options that lets
[more]

Simple ecommerce -- not exactly ColdFusion but may be relevant

Tue, 02 Dec 2008 12:58:00 GMT

About a few weeks ago I asked a question related to cc processing, silly me, I forgot the CFform family's CFinput has an attribute of cc validation, so, say, 85% customers provide good card and up front say something like if your card is rejected (you
[more]

Cfdocumentitem broken

Tue, 02 Dec 2008 12:55:00 GMT

Fixed it. It turns out the server wasn't configured for headless mode
properly. Adding the headless flag cleared up the root cause of the
problem:

Exception in thread "AWT-EventQueue-0" java.awt.HeadlessException:
No X11 DISPLAY variable was set,
[more]

Verity writing stuff to my text files

Tue, 02 Dec 2008 12:15:00 GMT

Thanks for all your advice, Dave.

I refreshed my articles collection today after uploading backup versions of the text files (hurray, I had them) and it didn't add that text to them.. so looks like, for now at least, it has stopped. Possibly I did
[more]

Cfdocumentitem broken

Mon, 01 Dec 2008 11:10:00 GMT

If I use a cfdocumentitem in a doc to create a footer in CF 8.01
Enterprise (with all the updaters) the doc generation churns for
minutes and eventually causes a page load error. While the doc is
being produced, FusionReactor shows this for the request
[more]

cfpop using hotmail

Mon, 01 Dec 2008 10:32:00 GMT

Hi, Im working on a prof of concept using the pop service on hotmail. I've found info on Google saying that hotmail give pop access to premium access users - i have a one of those accounts. I heard that it does SSL only and cfpop does not right off the
[more]

display field in autosuggest

Mon, 01 Dec 2008 10:15:00 GMT

Hi

I'm using cfautosuggest and I am displaying surname first_name fields in the dropdown box.

However these 2 fields appear to be the only 2 fields that are passed onto the form action page. I need the contact-id field (as there are sometimes more
[more]

cfautosuggest copying the CFIDE folder problems

Mon, 01 Dec 2008 10:14:00 GMT

Hi

I'm using cfautosuggest and I want to edit the css to change the default colours.
I have done so on my local server copying the CFIDE folder to the current folder then using cfajaximport to point to that folder.
This works fine.

I then
[more]

What's wrong with my ?

Mon, 01 Dec 2008 10:00:00 GMT

Crap, it goes back to my stupid date/time datatype for the field. All the times are different, and CF IS group the data, but they're all different so it output each row. I used Michael's example from my other thread to do this. Seems to work:

SELECT
[more]

What's wrong with my ?

Mon, 01 Dec 2008 09:48:00 GMT

I don't recall ever having a problem with the group attribute. But I can't figure out why it isn't woring right here.

My table looks like this:

ID Date ZIP code
---------------------------------
1 12/01/2008 27403

[more]

ColdFusion Objective() 2009 Call for Speakers (Topics) is open!

Mon, 01 Dec 2008 08:19:00 GMT

The cf.Objective() Steering Committee just opened the Call for Speakers
and Topics. Instructions may be found here:
http://www.cfobjective.com/callforspeakers.cfm

Thanks,
Nic
[more]

SQL between dates problem

Mon, 01 Dec 2008 08:08:00 GMT

>If you are using MS SQL...
>
>SELECT CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime)
>
>This will remove any time part from a datetime field.

I'm getting an error from the SQL. I've played around with it with no luck.

SELECT couponpercdisc,
[more]

IIS Application Pools and ColdFusion

Mon, 01 Dec 2008 05:11:00 GMT

Any shutdown in an IIS application pool is a process crash and needs to be debugged with a post-mortem userdump. My recommendation is that you open a support ticket with Microsoft to identify the root cause. Be aware, however, that in 90% of the cases
[more]

The Fusion Authority Quarterly Update Volume 2, Issue 4 is out now

Tue, 02 Dec 2008 03:43:37 GMT

If you want your ColdFusion skills to be up-to-date then you need the Fusion Authority Quarterly Update. The current issue is all about Best Practices and Development Environments. Just what we all need. Order now