I had to do this the other day not sure if it's the best way but it worked:
cfset local={} /
cfquery datasource=central name=local.query
selectname, expectedDate
frompeople
/cfquery
Why not do it in the query select statement by adding a column
expression to format the date there?
the way I read it, Steve is trying to squeeze a bit of code inbetween
an untouchable SQL statement returning a query and some code further
downstream to consume that query. You're right tho, if
What i was doing was using DE() to output variables in a string (block of
content). One of the vars is a date and i wanted to format the date. What
i was doing was doing some date formatting in the SQL statement but because
of the limitation of the SQL data functions i couldnt do it, like i
OK people I have not really used the PDF features in CF8 so I have a couple of
questions.
I have a PDF document that I want to insert data into , i.e.name etc. Can I
insert place holders into the PDF and have CF8 replace these with data. Or is
there a better way to add data to an existing
A pdf form with pre-populated fields/data or a static pdf document
you'd just like to populate from CF?
Cheers
Kai
OK people I have not really used the PDF features in CF8 so I have a
couple of questions.
I have a PDF document that I want to insert data into , i.e.name
etc. Can I
2008/12/16 Steve Onnis st...@cfcentral.com.au:
of the limitation of the SQL data functions i couldnt do it, like i wanted
Have you thought about writing you own SQL date function (in pl/SQL)
and then use it in your select statement?
btw which database are you using?
Chris
--
Chris Velevitch
I am using MSSQL 2005 in this instance
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Chris Velevitch
Sent: Wednesday, 17 December 2008 12:02 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Changing the data type of a column
It's a static form that I just want to insert some values into.
Brian Knott
ext 61984
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of
Kai Koenig
Sent: Wednesday, 17 December 2008 10:49 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Working with PDF's
A
@Chris
ah ha! yes of course.
http://sql.dzone.com/news/custom-date-formatting-sql-ser
http://www.xmlx.net/software/2005/02/custom_date_for.html
it may seem a bit heavy handed, but if the need calls...
On Wed, Dec 17, 2008 at 11:01 AM, Chris Velevitch
chris.velevi...@gmail.com wrote: