:[EMAIL PROTECTED] On Behalf Of Tom Chambers
Sent: Sunday, November 26, 2006 4:45 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db
did you try single quotes?
[EMAIL PROTECTED] wrote:
I have an Access datasource for movie listings. mTitle
: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db
Dan? Any thoughts on this?
/Charlie
http://www.carehart.org/blog/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart
Sent: Monday, November 27, 2006 10:39 AM
To: discussion
Sent: Sunday, November 26, 2006 4:45 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db
did you try single quotes?
[EMAIL PROTECTED] wrote:
I have an Access datasource for movie listings. mTitle is the
column/field for the movie's Title. I
I have an Access datasource for movie listings. mTitle is the column/field
for the movie's Title. I need to output the records ordered by mTitle,
however I need to ignore the when it is the first word.
For example: The Big Lebowski should be ordered by B in Big, not T in The.
My solution
did you try single quotes?
[EMAIL PROTECTED] wrote:
I have an Access datasource for movie listings. mTitle is the
column/field for the movie's Title. I need to output the records
ordered by mTitle, however I need to ignore the when it is the first
word.
For example: The Big Lebowski
: Sunday, November 26, 2006 4:45 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db
did you try single quotes?
[EMAIL PROTECTED] wrote:
I have an Access datasource for movie listings. mTitle is the
column/field for the movie's Title. I need
@acfug.org
Subject: Re: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db
did you try single quotes?
[EMAIL PROTECTED] wrote:
I have an Access datasource for movie listings. mTitle is the
column/field for the movie's Title. I need to output the records
ordered by mTitle, however I need