That's exactly what I thought. Worked just fine locally...but blows up with
that error when in production.
andy
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 4:46 AM
To: CF-Talk
Subject: Re: ColdFusion, MySQL 5.0.45, cfqueryparam
On Tuesday 29 Jan 2008, Andy Matthews wrote:
> commenting out various portions of the query, etc. I finally tracked it
> down to my LIMIT keyword, which previously used cfqueryparams1. It appears
i.e.
SELCT a,b,c LIMIT http://thefalken.livejournal.com
*
I've been dealing with a very odd, seemingly fringe issue and wanted to post
about it. I believe I figured out how to get around it, but I'm not sure what's
causing it.
My host is running the following apps/versions:
ColdFusion: 8,0,0,176276
MySQL: 5.0.45-community-nt
I have
alk
> Subject: Re: Tags useful to accomplish automating MLS direct feed into MySQL
> DB?
>
> >>I was sent with the property information and I didn't see any
> column names in the info.
>
> It might be a problem, unless there is a possibility to set the ODBC
&g
AM
To: CF-Talk
Subject: Re: CF / MySQL (Save file path)
On Thursday 17 Jan 2008, ColdFusion wrote:
> I have a feeling that MySQL is interrupting the \T as a RegEx expression.
Not reg. exp., escape sequence. The space is probably a tab char.
--
Tom Chiverton
Helping to apprehensively benchma
On Thursday 17 Jan 2008, ColdFusion wrote:
> I have a feeling that MySQL is interrupting the \T as a RegEx expression.
Not reg. exp., escape sequence. The space is probably a tab char.
--
Tom Chiverton
Helping to apprehensively benchmark world-class designs
on: http://thefalken.livejournal.
>>I was sent with the property information and I didn't see any
column names in the info.
It might be a problem, unless there is a possibility to set the ODBC
connection not to use the first row, I don't know.
But since you get the file by FTP, you can still append it to a one line
file contai
for MS SQL Server 7. I use MySQL. I guess I'll have to set up
the tables manually. That's not such a bad thing any, because
I won't be using all the data they send anyway, and will need to
tweak my tables according to what I want to display on the website.
I guess I'll have to s
>>Interesting approach. Is there someplace I can read up on this approach?
Dunno, I managed to set it horsing around with the ODBC manager in Windows.
See Administrative tools -- ODBC manager.
You must have a special directory dedicated to your .csv files, then you
set your txt csv ODBC driver
Hi, Claude...
Yes, my VPS is Win 2003 Server, MySQL 5.
Interesting approach. Is there someplace I can read up on this
approach? (Probably go google Microsoft Text Driver, huh... ;o)
That would be nice to download the file automatically into a folder
and then have a table created from it then
set thisFilePath =
-- Adrian
>Database: MySQL 5.0
>CF: CF8
>
>I have a form field asking for the file path, I would enter: C:\Temp
>And doing a normal query update set thisFilePath = '#form.filepath#'
>When updated in the database it becomes: "c: emp
Yep even tried: #Rereplace(arguments.resource_folder_path,'\[\]','\\\',)#
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 5:35 PM
To: CF-Talk
Subject: Re: CF / MySQL (Save file path)
Did you try \\?
Bruce
--
Throttl
Did you try \\?
Bruce
--
Throttle Jockey -
Why golf courses should be motocross tracks
ColdFusion wrote:
> This is a simple fix and I have done it in the past but for some reason it
> is escaping me how I did it before.
>
> Hopefully someone can point it out.
>
>
>
This is a simple fix and I have done it in the past but for some reason it
is escaping me how I did it before.
Hopefully someone can point it out.
Database: MySQL 5.0
CF: CF8
I have a form field asking for the file path, I would enter: C:\Temp
And doing a normal query update set
Yes, thanks Adrian. I'll forward this info to our Sysadmin. Can MySQL 3.0
handle CSV files or does it only work in 4.0 or later?
Dave
-Original Message-
From: Adrian Moreno [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 3:24 PM
To: CF-Talk
Subject: Re: Tags usef
>>I will then import the tab delimited info and property filenames into
an MySQL database, and place the property photos into the appropriate
local server directory.
Are you under Windows?
The easiest (although not trivial) way to do it is to define an ODBC DSN
using the "Microsoft
Thanks for the info, Adrian.
Especially on the use of CFLOOP!
Rick
> -Original Message-
> From: Adrian Moreno [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 17, 2008 4:24 PM
> To: CF-Talk
> Subject: Re: Tags useful to accomplish automating MLS direct feed i
http://coldfusion.sys-con.com/read/86121.htm
A client of mine had a 70+Mb inventory CSV that I had to load into MySQL. On CF
4/4.5/5, this process took at least 40 minutes. When we upgraded to CF 6, I
used the Java process and the import was down to less than 3 minutes.
CF 8 has incorporated java.io.FileRe
That's great to hear... I'll have to check on that feature in MySQL.
Thanks!
Rick
> -Original Message-
> From: Jerry Guido [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 17, 2008 12:38 PM
> To: CF-Talk
> Subject: RE: Tags useful to accomplish automating M
Thanks for the feedback, Jerry.
I'll be downloading a .zip file initially, when
then, of course, has to be unzipped, then the data file
with the property info, which I've been told will be a
tab-delimited file, has to be parsed and inserted into a
MySQL database.
Then the photos
and mapped the fields and SQL Server did the rest.
I read that MySQL has a similar built in import feature that does the
same thing.
So never mind my last post ;)
Jerry Guido
Programmer
MGT of America, Inc.
[EMAIL PROTECTED]
The information contained in this electronic communication is
ry 17, 2008 10:27 AM
To: CF-Talk
Subject: Tags useful to accomplish automating MLS direct feed into MySQL
DB?
Hi, all.
I assume some of you work on Real Estate sites where
you have to deal with a direct feed of data from MLS's.
The direct feed for one of my Real Estate sites currently
in develo
a tab delimited
data file for properties and photos whose name will include broker's
MLS numbers so they can be matched to properties.
I will then import the tab delimited info and property filenames into
an MySQL database, and place the property photos into the appropriate
local server direct
Our site allows international / non-ASCII characters (accents, curly quotes,
etc) in database data. We are using MySQL 4.1.
In CF 6.1, it all works great with the following:
AND, using the MySQL 3
driver, useUnicode=true&characterEncoding=ISO-8859-1 in the connection string.
It w
You've almost got it:
JDBC URL - jdbc:mysql://localhost:3306/test
Driver Class - com.mysql.jdbc.Driver
Driver Name - MySQL Connector/J
HTH,
Adrian
>I can't create a mysql datasource in CF Administrator.
>
>If I use the following datasource settings in CF Administrator:
>
What version of ColdFusion are you running. There is a special connector that
you may ahve to install to enable you to connect to a MySQL database.
It is the mysql-connector-odbc-3.51.21-win32 available form the MySQL website.
Download it and instal and then you also have to place a copy in a
I can't create a mysql datasource in CF Administrator.
If I use the following datasource settings in CF Administrator:
JDBC URL: jdbc:mysql://localhost:3306/test
Drive Class: MySQL Connector J
AND (note the emphasis) I set my local and remote folders in my DW site
local folder, remote f
If anyone has purchased MySQL Front in the past and found that they closed
their doors about a year ago. The project has been picked up again. You
current license is still valid also.
http://www.sql-front.com/
Chad
I have several ways to connect...running WAMP, so I have access via
command line. I also have SQLyog and mySQL Administrator.
Chris martin
Mark Flewellen wrote:
>> I just recently reinstalled my OS. After I reinstalled mySQL, I
>> attempted to place my databases in the /data
>I just recently reinstalled my OS. After I reinstalled mySQL, I
>attempted to place my databases in the /data folder. The databases show
>up, but not the tables...any ideas would be greatly appreicated!
>
>--
>Chris Martin
Generally when you want to restore databases wi
I just recently reinstalled my OS. After I reinstalled mySQL, I
attempted to place my databases in the /data folder. The databases show
up, but not the tables...any ideas would be greatly appreicated!
--
Chris Martin
Hi we build our software with coldfusion, Javascript, HTML, and MySQL.
just wondering if anyone has a list of allowable and unallowable characters and
symbols (&,",$, etc...) for all of these languages. and maybe if characters are
not allowable how we can get round these issues if we
Steve Good [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 26, 2007 9:03 PM
> To: CF-Talk
> Subject: Re: [OT] Populating a MySQL Database from Active Directory
>
> I would LOVE to see this! Thank you for the offer!
>
> On 10/26/07, Ryan, Terrence <[EMAIL PROTECTED]>
t: Re: [OT] Populating a MySQL Database from Active Directory
I would LOVE to see this! Thank you for the offer!
On 10/26/07, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
>
> I have some code that can pull down the entire contents of an active
> directory domain from ldap.
>
&g
g inserting
> it into mysql. )
>
> Care for a look?
>
> Terrence Ryan
> I.T. Director
> Wharton Computing and Information Technology
> E-mail: [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Steve Good [mailto:[EMAIL PROTECTED]
> Sent: Friday, Oc
I have some code that can pull down the entire contents of an active directory
domain from ldap.
>From there you could do anything you want with it. (Including inserting it
>into mysql. )
Care for a look?
Terrence Ryan
I.T. Director
Wharton Computing and Information Technology
I have an internal app that is working pretty well. Users log in using
credentials stored in Active Directory and the App runs on a MySQL DB. As I
expand the app I find I am running into problems with talking to AD. My
bigest issue is with my Dev Enviro. I have to code in a way to circumvent
Jessica Kennedy wrote:
>Jochem van Dieten wrote:
>>
>> What I have done before is used a denormalized model where the records
>> themselves had an adjacency list model, but I maintained a nested set in
>> a separate table. With a trigger on the records themselves that only
>> fired when the ID a
> Jessica Kennedy wrote:
> > I have looked over the various methods for displaying hierarchal
> data with MySql, and there don't really seem to be many elegant
> solutions-- the best method (according to many) seemed to be creating
> a column for "lft" & &q
Jessica Kennedy wrote:
> I have looked over the various methods for displaying hierarchal data with
> MySql, and there don't really seem to be many elegant solutions-- the best
> method (according to many) seemed to be creating a column for "lft" & "rgt"
try this link we found it really useful although we built the database tables
slightly different:
http://www.dougboude.com/blog/1/2006/06/Recursive-Functions-in-ColdFusion.cfm
~|
ColdFusion is delivering applications solutions
mysql.
if you need any more help just let me know.
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http
hierarchal data
with MySql, and there don't really seem to be many elegant solutions-- the best
method (according to many) seemed to be creating a column for "lft" & "rgt"
values as a nested tree structure, which is completely impractical in this
situation because I
joining any of the other tables.
>
> On 10/20/07, Toby King <[EMAIL PROTECTED]> wrote:
> >
> > Hi there
> >
> > I have a query that I have created - it works against a MS-Access
> database
> > but does not work with MySQL. I have searched through the MySQL n
>You can not use a column alias you define in the select list as a base
>column to some other calculated column in that same select list, i.e.:
True.
>SELECT A + B AS C, C / D AS E
I have to say I'm surprised Access actually _does_ allow you to do that. I'd
never tried it before now be
; I have a query that I have created - it works against a MS-Access database
> but does not work with MySQL. I have searched through the MySQL notes that I
> have but cant find out why - I think its because of the AS MatTotal section
> of the query.
>
> Thanks in advance for
Peter,
The reason it's not working is not because of the alias, but because
you are trying to use the alias in the SELECT clause. MySQL only
allows you to reference aliases in the GROUP BY, ORDER BY, or HAVING
clauses. (http://dev.mysql.com/doc/refman/5.0/en/problems-with-
alias
>Hi there
>
>I have a query that I have created - it works against a MS-Access database
>but does not work with MySQL. I have searched through the MySQL notes that I
>have but cant find out why - I think its because of the AS MatTotal section
>of the query.
What do you mean by &
Peter Tanswell wrote:
>
> I have a query that I have created - it works against a MS-Access database
> but does not work with MySQL. I have searched through the MySQL notes that I
> have but cant find out why - I think its because of the AS MatTotal section
> of the query.
Yo
Hi there
I have a query that I have created - it works against a MS-Access database but
does not work with MySQL. I have searched through the MySQL notes that I have
but cant find out why - I think its because of the AS MatTotal section of the
query.
Thanks in advance for feedback
SELECT
Hi there
I have a query that I have created - it works against a MS-Access database
but does not work with MySQL. I have searched through the MySQL notes that I
have but cant find out why - I think its because of the AS MatTotal section
of the query.
Thanks in advance for feedback
SELECT
Live and learn...
Thanks,
Rick
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 30, 2007 8:25 PM
To: CF-Talk
Subject: RE: Trouble storing monetary values in MySQL 5
> When was "scale" added? Never heard of that one...
I think it
> When was "scale" added? Never heard of that one...
I think it's been there since the introduction of CFQUERYPARAM.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC,
I knew you'd be proud, Will! :o)
Now I've got to replace my worn CF 4.0 WACK!
Rick
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 30, 2007 6:44 PM
To: CF-Talk
Subject: Re: Trouble storing monetary values in MySQL 5
>Perfect!
>Perfect! Thanks, Dave!
>Thanks for your help, too, Barney!
WOW! CF8!!
We should throw a big party!!
Congrats Rick! :)
Will
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusio
Perfect! Thanks, Dave!
Thanks for your help, too, Barney!
When was "scale" added? Never heard of that one...
Rick
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 30, 2007 2:56 PM
To: CF-Talk
Subject: RE: Trouble storing monetary values
> Here's what I'm using currently, and have used for years with
> MySQL 4.1.
>
> debit_amount = value="#lsparsecurrency(form.debit_amount)#">
>
> I run validation to make sure the input only contains
> numbers, a dollar sign, comma, or period... com
Here's what I'm using currently, and have used for years
with MySQL 4.1.
debit_amount =
I run validation to make sure the input only contains numbers,
a dollar sign, comma, or period... common elements for money.
Then, I use the lsparsecurrency above to make sure the value
is vali
's the "debit_amount" column that is of concern here...
>
> Ideas?
>
> Rick
>
>
>
> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 30, 2007 11:44 AM
> To: CF-Talk
> Subject: Re: Trouble storing
NT=10 DEFAULT CHARSET=latin1;
It's the "debit_amount" column that is of concern here...
Ideas?
Rick
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 30, 2007 11:44 AM
To: CF-Talk
Subject: Re: Trouble storing monetary values in
gt;5.0, and that's the source of the problem, since I know
it works just find on both versions.
Here's a column def I use with MySQL 5:
hourlyRate decimal(10,2) not null
That says use 2 fractional digits and 8 (10 - 2) integral digits.
cheers,
barneyb
On 9/30/07, Rick Faircloth <
Hi, all.
This does actually involve CF 8, (and yes, I'm on CF 8 now, from 4.5
with my new VPS from ahphosting.com!) since I manipulate the value
(typically, MySQL 4.1) before inserting.
I've got a MySQL field of decimal for the monetary value.
Previously, in MySQL 4.1, I
Ahh... it's fixed in the next hotfix. :)
Hi Will,
We have fixed this bug and we are in the process of releasing hotfix for
this bug very soon.
Thanks,
Hemant
Adobe ColdFusion team
~|
Check out the new features and enhancement
Ok, I think I finally figured out this goofy corrupted table error.
I noticed there were no errors in the mySQL log. I thought hmm is this CF8
erroring? It was such a cryptic error message I couldnt tell.
So I looked in the CF error log and there it was. I had also noticed it only
Hi Jochem,
Thats brilliant its working fine now :) thanks for your help
Richard
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion
Richard White wrote:
>
> select functionName('[EMAIL PROTECTED]', 'myPassword')
>
>
> and it gives the error: cannot be indexed correctly.
That is because CF tries to create a column from the result with the
name "functionName('[EMAIL PROTECTED]', 'myPassword')" and that is not
a valid col
this is the error it is giving me:
[Table (rows 1 columns myfunction('[EMAIL PROTECTED]','myPassword')):
[myfunction('[EMAIL PROTECTED]','myPassword')): [EMAIL PROTECTED] ] is not
indexable by myfunction('[EMAIL PROTECTED]'
Thanks again for your help
~~
>
> SELECT function(argument)
>
Thanks for the reply, i am getting an error running this code saying that it
cannot be indexed correctly.
my stored function takes in 2 varchars - an email address and password and
returns a boolean, so when i call the function i write the following:
sele
Richard White wrote:
>> Just like a built-in function:
>> SELECT function(argument)
>
> thanks for your reply. do i have to encapsulate it in cfquery tag, or do i
> have to direct it to the database?
SELECT function(argument)
Jochem
~~~
> Just like a built-in function:
> SELECT function(argument)
thanks for your reply. do i have to encapsulate it in cfquery tag, or do i have
to direct it to the database? can you give me an example with cf code please
and how do i access the variable it returns?
thanks very much
Richard White wrote:
>
> just wondering if anyone knows how to call stored functions in MySQL from
> coldfusion.
Just like a built-in function:
SELECT function(argument)
Jochem
~|
Get involved in the latest C
Hi,
just wondering if anyone knows how to call stored functions in MySQL from
coldfusion.
We have been calling MySQL stored procedures fine using the tag
but have no idea how to call MySQL stored functions.
We have tried doing it through the cfstoredproc tag but of course it tells us
that
Will Tomlinson wrote:
> If I have user comments that could be 500-1000 characters, what datatype
> should I be using with mySQL 5.0?
Some type that accepts unicode.
Jochem
~|
Create robust enterprise, web RIAs.
Upgr
Why not just use VARCHAR()? They can be up to 65,535 characters in length
in MySQL 5.0.3 and later.
http://dev.mysql.com/doc/refman/5.0/en/string-types.html
- Original Message -
From: "Will Tomlinson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday,
My pleasure
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 13, 2007 5:19 PM
To: CF-Talk
Subject: Re: Best data type for comments using MySQL?
>Med text allows for up to 65,535 characters so that should be plenty.
>Longtext allows fo
>Med text allows for up to 65,535 characters so that should be plenty.
>Longtext allows for like millions.
Fixed it!
Thanks dude!
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse an
Med text allows for up to 65,535 characters so that should be plenty.
Longtext allows for like millions.
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 13, 2007 3:32 PM
To: CF-Talk
Subject: Re: Best data type for comments using MySQL
>Medtext I think.
>
Thanks andy! I was using longtext. Just making sure...
Will
~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/p
Medtext I think.
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 13, 2007 3:05 PM
To: CF-Talk
Subject: Best data type for comments using MySQL?
If I have user comments that could be 500-1000 characters, what datatype
should I be using with
If I have user comments that could be 500-1000 characters, what datatype should
I be using with mySQL 5.0?
Thanks,
Will
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
>Will,
>
>one question: is InnoDB tables in your MySQL database? Corrupt table is a
>very old problem related to MyISAM tables.
>
>
Hey, I just ran across my old thread here because this problem has crept up
again.
The table in question is a InnoDB table. It has FK's.
>Will,
>
>one question: is InnoDB tables in your MySQL database? Corrupt table is a
>very old problem related to MyISAM tables.
Yes, the table in question is InnoDB.
Also, the problem disappeared yesterday. It's working properly now.
I
Will,
one question: is InnoDB tables in your MySQL database? Corrupt table is a
very old problem related to MyISAM tables.
Cheers
2007/9/3, Will Tomlinson <[EMAIL PROTECTED]>:
>
> Thanks for the info dude
Thanks for the info dude!
Will
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&pro
em.
> I have used them for years.
>
> >Hi,
> >
> >Just wondering if anyone knows of any good ColdFusion and MySQL web
> hosting companies?
> >
> >We are based in the UK but wouldn
I also have used crystaltech for myself and for my clients and love them. I
have used them for years.
>Hi,
>
>Just wondering if anyone knows of any good ColdFusion and MySQL web hosting
>companies?
>
>We are based in the UK but wouldn't mind hosts in the UK or U
tus ok.
Not 100% on this, but I think that if old MySQL drivers are used on the
server, that can happen? Something like that, and it's vague, but that
is one area (missmatched drivers) where it'll run fine on one box, but
choke on another, at least. Something to check, at least...
When I
ed some things about mySQL bugs,
but that's about it.
Thanks,
Will
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/for
I have had nothing but a good experience with crystaltech for the past 4 years.
On 9/1/07, Richard White <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Just wondering if anyone knows of any good ColdFusion and MySQL web hosting
> companies?
>
> We are based in the UK but wouldn
On 9/1/07, Les Mizzell wrote:
>
>
> The client wants a "do everything" one input search field to run this.
> Adding + or - to words in the search field is way more than most
> customers are going to bother with.
Yeah, I hear it. A dumbed down version might be a simple radio,
that says "all words
Hi,
Just wondering if anyone knows of any good ColdFusion and MySQL web hosting
companies?
We are based in the UK but wouldn't mind hosts in the UK or USA.
Thanks very much
~|
Check out the new features and enhancemen
> With the pluses and everything?
The client wants a "do everything" one input search field to run this.
Adding + or - to words in the search field is way more than most
customers are going to bother with.
But, since the results are returned by relevance, "Harry Potter" is way
down in the lis
asing relevance.
You can see this from the preceding query result: The row with the
highest relevance is the one that contains "MySQL" twice, but it is
listed last, not first.
~|
Get involved in the latest ColdFusion discuss
>> So, how do I be sure the results contain BOTH "potter" and "rabbit",
>> thusly eliminating "Harry Potter"?
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html =]
I tried that already.
=AGAINST (
IN BOOLEAN MODE)
I *still* get "Harry Potter" in the results!
But, th
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html =]
On 9/1/07, Les Mizzell <[EMAIL PROTECTED]> wrote:
> Working Query (finally!)
>
> SELECT title,
> Author,
> Publishers,
> ListPrice,
> ISBN
> FROM booksDATA
> WHERE MATCH (Title, Author, Publishers)
Working Query (finally!)
SELECT title,
Author,
Publishers,
ListPrice,
ISBN
FROM booksDATA
WHERE MATCH (Title, Author, Publishers)
AGAINST ()
If I enter "rabbit potter" (obviously without the quotes) into my search
field, I would expect to see all the "
> Here's my query:
>
>dataSource="#getDATASOURCE">
> SELECT title,
> Author,
> Publishers,
> ListPrice,
> ISBN
> FROM booksDATA
> WHERE MATCH (Title, Author, Publishers)
>AGAINST cfsqltype="cf_sql_varchar"
> value
I've set up a FULLTEXT index in the MySQL database. This part should be
correct as the database shows the below with no errors:
Index Name: textSEARCH
Field Names: Title, Author, Publishers
Index: Full Text
Here's my query:
SELECT title,
Author,
Publishers,
>>
>> SELECT field1, field2
>> FROM myTABLE
>> WHERE MATCH (field1, field2)
>> AGAINST ('#form.searchINPUT#')
>>
> cfqueryparam !
I know! I know!
I was just presenting things in their most simple form
~|
ColdF
On Friday 24 Aug 2007, [EMAIL PROTECTED] wrote:
> >
> > SELECT field1, field2
> > FROM myTABLE
> > WHERE MATCH (field1, field2)
> > AGAINST ('#form.searchINPUT#')
> >
cfqueryparam !
--
Tom Chiverton
Helping to seamlessly iterate revolutionary web-readiness
on: http://thefalken.livejour
501 - 600 of 3179 matches
Mail list logo