:[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.org
Subject: RE: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db
Dan, the problem you've hit is not a syntax problem but rather a security
issue Access, it seems. For instance, if you tried that SQL statement WITHIN
Access, did it work? It did for me, yet trying to pass it in from
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
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