I've optimized things as much as I could by building a number of
collections and limiting each to a specific doc type.
Next question!!
I'm trying to return a few sentences from each doc with the search term
highlighted. So, I use ContextPassages like below.
cfsearch name=searchResults
I'm going to forget about it and go mow my grass and see what's
happening when I finish.
Well crap, somebody stole my lawnmower. This is why we can't have nice
things
~|
Order the Adobe Coldfusion Anthology now!
That doesn't actually sound unreasonable, but it might be useful to
come up with a document count more specific than very large.
Approx 3000 documents - around 3 gb of data
... it's still running from what I can tell.
~|
I'm working on building a search interface for a document depo on a
site. The document folder has files going all the way back to 2005, and
includes a number of 10+ meg pdf files, a few that are over 20 megs,
countless Word and Excel files, Power Point presentations
I don't have access
On 2/20/2015 5:21 PM, Jon Clausen wrote:
Your background image uses a relative URL:
background: url(img/pdfCARD.gif) left top no-repeat;
Have you tried it with an absolute URL? or, alternately, using CSS box shadow:
.PDFCARD{
box-shadow: 3px 3px 2px #33;
}
Switched to the
Wow - I've spent almost 2 full days trying to figure this out and have
never found one thing anywhere saying .gif files were no longer
supported! Thanks Adobe!!
Wonder why the heck not??? Bet I'm not the only one with a legacy
application that this change broke!!
Swapped it out for a .png and
Afternoon,
Have an older application that's using cfdocument to push a pdf to the
user. Last time I checked the app, it was working great, but it's been
awhile and since then the server has been upgraded to CF 10.
The pdf is basically a collection of business cards. A card consist of a
Running a page that reads a text file into an array - then writes the
array to the database.
I get the following error:*
Detail:* [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming
tabular data stream (TDS) remote procedure call (RPC) protocol stream is
incorrect. Too many parameters
You can either remove your CFQUERYPARAMs (which might be ok if your
data isn't coming from an untrusted source), or you can limit your
batch size so you don't exceed 2100 parameters per CFQUERY tag.
Might try this first. It's from inside a client admin system, and
there's a specifically
You can either remove your CFQUERYPARAMs (which might be ok if your data
isn't coming from an untrusted source)
This works. Tried it with a list of roughly 1000 records.
Will try my 15,000 record sheet later this evening and see what happens.
Added 4 threads to split all list up as well.
Ended up finally creating a VIEW in the database to handle the problem.
Even on a 15,000 record list, runs in just a few seconds...
| SELECT DISTINCT nl_catREL.groups_id, duplicates.ml_id
FROM nl_catREL
INNER JOIN
nl_mailgroupsON nl_mailgroups.ml_id = nl_catREL.ml_id
I'm still fighting with my Excel Import application a
bit. Basically, it works pretty well, as long as
there's a limited number of records being imported.
Was testing last night with the 15,000 record Excel sheet.
If I comment out the two filter queries in the code, it will read in the
On 11/15/2014 12:42 PM, Roger Austin wrote:
Any chance to have the database engine do all that record logic?
After killing myself on this, I finally realiaed I was doing it ALL
WRONG! All those loops and everything to filter the array, then do the
insertwas taking forever.
I'm revising - BULK
Evening,
I'm still fighting with my Excel Import application a bit. Basically, it
works pretty well, as long as there's a limited number of records being
imported.
Problem is, the client tried to import a list with almost 15,000
addresses today, and it eventually timed out or the server reset
On 10/10/2014 1:50 AM, Mike K wrote:
You do know that Microsoft changed the insert syntax as from SQLServer 2008
dont you?now you can insert multiple records in one go like this:
INSERT into Tablename (field1, field2, field3, field4 ) Values
( value1, value2, value3, value4 ... ;
I've got an application that imports email list from Excel sheets.
Mostly working fine, but I've got one spot where I'd like to optimize
things if I could.
Once the data is imported I run two queries against each email address:
1. see if the email address is already in the group in question
2.
Have you investigated using a Stored Procedure that does both inserts?
This seems the way to go.
Writing Transact-SQL is outside my area of expertise.
I'm looking at example code now.
Give me a bit and maybe I'll figure it out...
Thanks to everybody that replied.
On 10/9/2014 1:49 PM, Cameron Childress wrote:
Most databases will let you issue multiple SQL statements in a single
request/transaction. You just have to separate them with a semicolon.
If you did it this way, how would you get the ID from the first insert
for use in the 2nd ... (because I'm
On 10/9/2014 5:00 PM, Cameron Childress wrote:
A few years ago I stopped using numerics and auto-increment and started
using UUID for all PK/FK columns.
On new stuff, this is what I'm doing as well. Unfortunitely, this is a
pre-existing app and would take a good bit of rewrite to do that.
On 10/9/2014 5:16 PM, William Seiter wrote:
What kind of database? MSSql? Mysql? Oracle? ...
SQL Server 10
~|
Order the Adobe Coldfusion Anthology now!
On 10/9/2014 5:20 PM, William Seiter wrote:
Off the top of my head...
To insert the last inserted unique id in a transaction...
cfquery
INSERT dbo.table(column) SELECT 1;
SELECT @newID = SCOPE_IDENTITY();
INSERT dbo.table_2 (column) SELECT @newID;
/cfquery
I'll give this a try. It's
Not knowing much about your overall process, I'll try to stick to some
generic ideas. Let's assume you don't need this stuff dumped into the
database the very second it gets sent to you.
This is actually part of a client's admin system on their website. They
send out legal newsletters.
So what is the specific error? Is it in CF or Excel. If Excel are you getting
this message?
Excel actually opens. So, it's an Excel error. However, it just says
There's an error with no further information. I *wish* it was the
error below, because then I'd have something to go on.
The
I've got an application running on CF8 that's been successfully
generating Excel reports for a good amount of time.
Recently, the user upgraded Office (using 2013 now) - and now it no
longer functions for them.
Pretty simple stuff:
cfsetting enablecfoutputonly=Yes
cfheader
On 8/18/2014 12:36 AM, Eric Bourland wrote:
Has anyone here tried out the ColdFusion SIM* sample code from authorize.net?
I
A version of the below has been working great for me. I use it as a
include on my form processing page that also records the appropriate
data to the customers record
Had a site go down in the early morning hours the last two days -
Coldfusion hangs - requiring a restart to get it back up again.
Running CF 10 on Windows Server 2008 R2
1. No major errors in the log files.
2. Log files are set to relatively small size limits
3. Something seems to be eating a
an
increase in traffic as the system tries to remove a boatload of client vars.
-Mark
-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: Wednesday, July 23, 2014 8:52 AM
To: cf-talk
Subject: Insite Help on CF Hanging?
Had a site go down in the early
I've got an app that's been generating Excel without any problems for a
number of years (pre cfspreadsheet tags)
Hosting recently migrated the site to a new server, and suddenly the
client can no longer open the Excel files on their end.
They're using Excel 2010, and have been before the
Some of the forms we use CF to email out are getting hit
with spam garbage. I'm seeing patterns in them I can use
to catch it now, but wondered if there is a more general
approach available I'm not aware of? Thanks much!
I've had very good luck with a simple math (or other) question,
Most new clients see CF as old and outdated technology with no future...
I recently lost a client because the sales folks from that approached
them told them Your site is using an ancient language called
'Coldfusion' that nobody is supporting any more, and it's /*KILLING YOUR
SEARCH
The best solution, in my opinion, is to switch to J2EE sessions,
assuming you can invest the time and effort to do that.
I'm having almost the exact same problem. My login system, had been
working perfectly (CF8) until we moved everything to a new server with
CF10 on it.
Now, Chrome will
Got a site currently running on CF8 that we're migrating to a completely
new server with a fresh CF10 install. There's an informal members only
section with user/pass login that we're having trouble with. No code
changes - no problems on the CF8 server.
But, in various browsers, it seems the
On 2/20/2014 8:22 PM, Byron Mann wrote:
Try using setdomaincookie=yes only instead of both. I seem to remember
something like this going from 8 to 9.
Done - didn't fix it
Any redirects after the login? Like going from httpîªto https? Or from
domain.com to secure.domain.com?
Hmm ... OK,
On 7/23/2013 12:51 AM, Justin Scott wrote:
Which brings up another security question. How does other sites
handle something like this automatically? I mean, if I see an
attack from an IP address, is it even worth blocking at the firewall?
I had an interesting attack yesterday ...
A bot hit
On 6/18/2013 9:31 PM, Mike K wrote:
Again, I might be wrong here, but if you make ColdFusion
sites, Dreamweaver CC is impossible to use
Not impossible. But Adobe, for one reason or another, has made it dificult...
Do this:
1. Go to preferences
2. In the choose external applications section,
Already posted this - but there seems to be a lot of confused folks (me
too), so thought it needed a new topic
In Dreamweaver CC:
1. Go to preferences
2. In the choose external applications section, hit the + and enter
.cfm.
3. In the editor window, select your Dreamweaver app and make it
Adobe should open source homesite
This! 10+
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Anyone else seeing a lot of form submissions with -1 or 1 as the name?
Yup - I get that sometimes.
Or, an attempt to enter the same web or email address entered into EVERY
field.
and I'm still getting weird *something* errors sent to me from a
site that look like:
One site of mine for a dance company used to get a ton of spam through
contact forms. Everybody hated CAPTCHA, so I put a simple question with
radio button choices:
A cow goes?
a. quack
b. woof
c. moo
d. chirp
VERY low tech, but believe it or not, we've not gotten a single piece of
bot spam
I just got the below on a site. Not sure how to decrypt to tell exactly
what it's doing though.
Client noticed that Google had flagged the site as 'comprimised.
I'm pointing my finger at the hosting company - they've got a security
issue if this can happen, correct?
So, anybody know what this
Still I am not sure how they are uploading these files
as there is nothing in the logs that indicates this.
For mine in the previous message, the altered file still had the
ORIGINAL creation date on it - 2011 something - although it was altered
last week. So, a search of all the site files
I have two separate queries, basically a table of NEW stuff, and then a
table of OLD stuff that's not been converted to new yet. Not all fields
in the two tables match.
So, first query finds all the matching NEW things
Second query finds all the OLD things that aren't present in the NEW
On 1/29/2013 4:16 PM, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote:
Just create empty columns when they are missing, ie:
'' AS off1_name,
Ahhh - that works! Didn't know you could do that!
Thanks
~|
Order the Adobe
Recently a site of ours got hacked - basically, a Google search the site
was returning viagra info!
What we got was a small script added to the end of a functions.cfm file:
cfset REQUEST.UserAgent = LCase( CGI.http_user_agent ) /cfif (Find(
google, REQUEST.UserAgent ))
cfhttp method=get
Issues like this are typically caused by either SQL injection (i.e.
didn't use cfqueryparam) or
some sort of FTP vulnerability. My first step would be to make sure
that *every*
cfquery that accepts any input of any kind from users is utilizing
cfqueryparam.
Everything is paramed to the
Never seen this before! Script in Application file, as usual, caught it
before it got further...
Here's what was tried:
On 9/25/2012 6:13 PM, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote:
It looks like a search engine which is clumsily redirecting search result to
some of your pages.
Looking up the IP address it came from:
IP: 194.190.33.234
Decimal:3267240426
Hostname: 194.190.33.234
ISP:
In what looks like an injection attempt or something (?), what exactly
does the following do?
somepage.cfm?Result:+using+proxy+177.103.197.203:8080;+no+post+sending+forms+are+found;
I've got a script in my application file that's stopped/caught a bunch
of these over the last few days.
It's always IE...
Have a site that has a number of feeds using Raymond Camdens rss.cfc,
version 0.1
It's been working great in every single browser, cell phone, you name
it, since put into service years ago using an earlier version of the cfc.
IE 9 comes along - when I look at a feed I get a
Need a little assistance with a struct/array problem please!
---
Data in question is coming from ONE row in the database.
There are six fpcomm cells: fpcomm1,fpcomm2, ... and so on
There are also six fpord cells:
cfinput type=text name=xdate_use ex: 05/31/2012
cfinput type=text name=xtime ex: 3:31 PM
Given the values used as examples for the fields above, exactly how
would I go about querying a datetime stamp field (SQL Server) to find
all records dates on or after the date/time above?
No problem
I did two test using the basic code below.
First test exactly like below using a list.
2nd test, modifying the below to build an array instead of a list and
checking for a duplicate value in the array
The query used returned a list of close to 14,000 email addresses
Average total time in
Thanks for this post. I've not had time to get back into this yet, but
will run some experiments against the data I've got to see what actually
works best. Worst case would be three or four email addresses being
searched for in a result list of 4000 or so returned from the database.
I have
When getting the information out of the database, us distinct on the
field.
Only one list is coming from the database, the other is from a
completely different source.
convert your list to an array and loop over that
The small list is the one that will have the operations done to it. The
Got an app that sends out email to various lists - CF8
I'm checking to be sure there are any duplicates between the two lists
req.this list - usually pretty small - ten or so email addresses
req.groupLIST - is the problem - it could be a500 or more addresses at
times.
cfloop
Trying to get the below to work in a loop:
#detail.off1_street#
#detail.off2_street#
#detail.off3_street#
#detail.off4_street#
So, this seems correct...
cfloop from=1 to=4 index=idx
#detail[off#idx#_street]#br /
/cfloop
error: cftComplex object types cannot be converted to simple values
These don't word either:
#detail[offidx_street]#
#detail[off#idx#_street]#
Trying to get the below to work in a loop:
#detail.off1_street#
#detail.off2_street#
#detail.off3_street#
#detail.off4_street#
~|
Order the
On 3/30/2012 12:03 PM, morgan lindley wrote:
Is 'detail' a query? If so, you need
#detail[off#idx#_street] [detail.currentRow]#.
Ahhh - correct! Found a blog entry somewhere by Ray C. verifying as well.
This works:
cfloop from=1 to=4 index=idx
#detail[off#idx#_street][1]#
/cfloop
Trying to figure out how to validate a specific cfinput text input field.
I need this input to NOT allow any previously existing value coming from
a query. (long list of part numbers.)
Is there any way to use the bind parameter to pull this off?
Suggestions?
Looking at jquery ideas, but
I'm in the process of rewriting the admin system for an older website.
On this version, client want to be able to edit/add/delete anything at
will, and have it NOT got live until he's decided he's done with that
part.
My current thought is to use a temp table(s) that:
a. when visiting an edit
Is CF9 limited to the versions of Excel it will work with?
I've got an application running in CF8 to import email/name lists using
the POI Utility (thanks Ben Nadlel). When (and it's not often) the
client normalizes their data and removes all formatting, AND uses a pre
Excel 2007 file
Best-practices questions re: achieving borders with curved corners.
At some point (...and I have this problem with clients too), we've GOT
to convince our clients that degrade gracefully isn't a bad thing.
They see some wizz-bang widget they want, and then scream when it won't
work in IE6
The issue that Crockford brought up though is a valid one. It's
not the browser manufacturers that are the problem, it's the
users and corporate IT departments that don't/won't upgrade.
My largest client has offices in 15 different cities - and every PC they have
is running IE7 and they
What's the proper method of adding multiple reply-to addresses with
cfmail?
I've tried a couple of things:
cfmail
to=#req.emailTO#
from=m...@myaddress.com
replyto=m...@myaddress.comcfif
len(form.additionalreplyto),#form.additionalreplyto#/cfif
On 9/27/2011 10:06 AM, Russ Michaels wrote:
it is not valid to have multiple reply-to addresses, if you want it to
go to multiple users then set the reply-to to a LIST/MRA address.
Interestingly enough, in Thunderbird I can add multiple reply-to
addresses when composing an email, and they
Is there any way to send data as form values without
actually using a form? Thanks, Pete
I've had good success with WDDX myself. You can cram almost anything in
there and extract it on the other end.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=XML_18.html
I've got a site using an .htaccess file for friendly URLs.
The index page of the site controls everything, so the .htaccess file
simply converts the the url into variables and redirects back to the index.
User sees:
www.mysite.com/newsletters/march
Get's directed to:
On 8/11/2011 10:15 AM, Che Vilnonis wrote:
I know how to call/import different CSS files using statements like this:
!--[if lte IE 7]
I've been avoiding hacks if possible myself. Microsoft tends to break
them with each new release. I've started using a conditional in the body
of my
On 8/11/2011 11:39 AM, Russ Michaels wrote:
there should be some additional headers that are added by Apache with the
original requested url, they may not be in the CGI scope though, or perhaps
you need to specifically enable them in the Apache config.
Figured out a way to do it. Maybe not
Below is for a search interface I'm working on.
A single word into the query works fine.
I've a function that cleans the input, removes common words, and builds
a list. The list is getting built properly.
If I input bob,ted I get an vague syntax error (shared hosting - robut
reporting is
On 5/4/2011 8:15 PM, Greg Morphis wrote:
the double quotes?
like '%bob%' or '%ted%'
That's just in the outputted version.
I've rewritten it again though. Output is now:
WHERE section 'news'
AND ( headline LIKE '%barnett%'
OR content LIKE '%barnett%' OR headline LIKE '%shale%'
OR content
On 5/4/2011 9:11 PM, Greg Morphis wrote:
Take your query and wrap it in a cfoutput tag instead of cfquery.
Remove the cfqueryparams and just have the variables.
That's this:
WHERE section 'news'
AND ( headline LIKE '%bob%'
or content LIKE '%bob%' OR headline LIKE '%robert%'
or content LIKE
This did the trick:
WHERE section 'news'
cfif ListLen('#myLIST#') gt 1
AND (
cfloop list=#mylist# index=i
cfset #thisROW# = #thisROW# + 1 /
headline LIKE cfqueryparam value=%#i#%
cfsqltype=cf_sql_varchar
or content LIKE cfqueryparam value=%#i#%
It is fake...NO registrar works in this manner.
I got one of these too. I offered to sell them the domain in question
for $25,000 US if they wanted it. Even offered to take four equal
payments over the period of a year.
Needless to say, they didn't go for it!!!
Client is requesting that hosting *has* to be in Texas. I've NO idea
why. But - anybody familiar with good reliable, CF hosting in Texas with
*helpful* 24/7 tech support?
Most of my stuff is either at hosting.com or CrystalTech, niether in Texas
TIA
SET Name =cfqueryparam cfsqltype=cf_sql_varchar value=#form.name# /
Do the below. Will insert a null if the field is empty..
cfqueryparam
value=#trim(myFormField)#
cfsqltype=CF_SQL_VARCHAR
null=#not len(myFormField)#
Hosting.com is all over the search engines
When it was still HostMySite my experiences were very positive. I could
call them with a problem at 2:30am, somebody would actually answer the
phone, and that very person would usually fix my problem while I was
online. Email support requests were
What's the difference between
1. --
SELECT nl_id
FROM vw_newsletters
WHERE
(paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer /)
AND (nl_status = 'published' OR nl_status = 'archived')
2. --
SELECT nl_id
FROM vw_newsletters
On 10/18/2010 3:33 PM, Michael Grant wrote:
In this case specifically the parenthesis should make no difference at all.
Are you sure the two queries are exactly as you've shown them?
Yup.
Database is SQL Server
I can run the query with the paranths, and get the expected results.
Edit the
I've got a section of a site where a user can access a number of logo
downloads, including tiff, jpeg, ai, or gif formats.
There are thumbs on the download page, with links on each thumb like:
a href=resource_download.cfm?logo=72-dpi-jpg target=_blank
This takes them to the resource_download
On 10/18/2010 4:40 PM, Wil Genovese wrote:
Have you tried this directly in the DB from SQL Manager? If it still happens
then ColdFusion is not part of the issue.
Directly in the DB will pull the expected/correct data set either way.
Looks like the server needs a reboot!
On 10/18/2010 7:53 PM, Michael Grant wrote:
cfheader name=Content-Disposition value=attachment;
filename=#YourFile.FileName#
cfcontent type=image/jpg file=#YourDirectory#\#YourFile.FileName#
I had that actually - not using the type though as there's a number of
different file types
Nope:
http://www.bloomberg.com/news/2010-10-07/reback-says-adobe-purchase-by-microsoft-unlikely-video.html
~|
Order the Adobe Coldfusion Anthology now!
I just think that there are cases where it makes sense to
do URL rewriting in CF.
Getting off topic, how does this affect SEO? What does googlebot or
another search engine bot see when it's done this way?
~|
Order the Adobe
Ria Ragam wrote:
Hi,
I am trying to build dropdown in a dropdown selection.
Try:
http://tutorial196.easycfm.com/
or (a little more with the times):
http://www.coldfusionjedi.com/index.cfm/2008/9/14/Triple-Related-Selects-and-interesting-CFDIV-trick
some AJAX here:
Scott Brady wrote:
There's probably a way to do it just in the query (using subqueries
perhaps), but here's one option:
It's not that easy!
Change your query to this:
Select catg, nltitle, nldate
from newsletters
order by catg, nldate DESC
Then, for your output:
cfoutput
Kris Jones wrote:
Take a look at the CROSS APPLY operator in T-SQL.
I don't have direct access to the database itself, so will need to do
this in Coldfusion. Can't use Cross Apply there, right?
This has got me totally befuddled at this point, to be honest...
Gotta be some goof ball query of
OK, the below *mostly* gives me the correct output in the correct order:
cfquery name=getIDLIST
SELECT max(id) as id, nl_hed
FROM nl_master
WHERE nl_status='pub'
group by nl_hed
order by nl_hed, id
/cfquery
cfset myLIST = #valuelist(getIDLIST.id)# /
cfquery name=get_newsletters
I'm trying to output a list of the most recent newsletters sorted by
DATE. There are a number of categories that they fall under, and I must
show only the newest 1 from each category..
Select catg, nltitle, nldate
from newsletters
order by date
Might return this:
nldate catg
If I'm passing an URL Variable - with the variable name itself being
dynamic, what's the best was to extract the variable name (not the
value) on the receiving page?
As in:
for: index.cfm?somevar=somevalue
I need to return somevar on the receiving page as a value.
or for:
Not 100% sure how to do this...
Need to return a list of folks ordered by last_name (no problem), EXCEPT
for 2 of them. They need to be LAST regardless of their last names
(problem)...
Perhaps something with their 2 ID numbers?
Ideas?
__ Information from ESET NOD32 Antivirus,
Works the charm:
SELECT * FROM judges
ORDER BY CASE WHEN judge_id IN (2589,7555) THEN 1 ELSE 0 END,
judge_lname
Thanks folks...
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5241 (20100630) __
The message was checked by ESET NOD32 Antivirus.
b...@bradwood.com wrote:
Paul, now's a good time to start a select * rant. :)
No - I SPECIFY which fields I want and cfueryparam the hell out of
everything too.
I just put select * here for brevity. The below is NOT the live query!
SELECT * FROM judges
ORDER BY CASE WHEN judge_id IN
It won't even be mainstream then. There's still an awful lot of people out
there running XP
XP isn't broke. I've seen no reason to fix it myself so far. Guess I'm
one of those awful lot of people. If MS had given me an upgrade path
from XP instead of a delete everything start from scratch
Right - don't do this. Can only end in tears...
OK, designer has come up with a fixed size box on the index page of a
site that will hold X amount of stuff from a feature story on another
page of the site. Like:
yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda
yadda
Sean Corfield wrote:
If you know how many characters will fit in the box (which may be font
dependent?), then start there and work back to the next space and
truncate there. That way you'll always have complete words and the
number of words will vary depending on the total number of
Client configured fonts are a PAIN in these situations. Plus you have to
account for HTML in your count.
First thing I do to the text is strip all HTML!! The client cuts/pastes
from Word like CRAZY, and we all know what that crap looks like ... I
clean it on the way into the database to
Working on setting up a site search - (SQL Server).
Query below won't work as feature_text is a TEXT field
mylst will ALWAYS be a comma delimited list (cleaned of all unwanted
crap and common words)
cfquery name=features
SELECT
id_feature,
feature_headline,
feature_date,
Hmmm - this will return NO results, though I know the terms I'm looking
for exists:
WHERE CAST(feature_text as VARCHAR)
like
cfqueryparam value=%#form.searchTERM#% cfsqltype=CF_SQL_VARCHAR /
cfquery name=features
SELECT
id_feature,
feature_headline,
feature_date,
This ended up doing it:
XOXO is always the last list item...
cfquery name=features
datasource=#req.data#
username=#req.user#
password=#req.pass#
SELECT
id_feature,
feature_headline,
feature_date,
year(feature_date) as theYEAR,
feature_text
1 - 100 of 1021 matches
Mail list logo