, September 25, 2013 7:43 PM
To: cf-talk
Subject: Saving updated sort order in mysql jquery list to update database
I have a cfm page that displays a drag and drop ul list and I do not know how
to create an array of that sorted list to the mysql database.
Any help would be greatly appreciated. I
I have a cfm page that displays a drag and drop ul list and I do not know how
to create an array of that sorted list to the mysql database.
Any help would be greatly appreciated. I am new to the jquery, jquery-ui
plugins, but loving it all so far.
Thanks in advance,
Terry
that displays a drag and drop ul list and I do not know how
to create an array of that sorted list to the mysql database.
Any help would be greatly appreciated. I am new to the jquery, jquery-ui
plugins, but loving it all so far.
Thanks in advance,
Terry
Should be a simple one for a mysql guru. What is the mysql equivalent of the
following?
select datePart(dd,timestamp) as dayOfMonth, count(timestamp) as
searchesPerDay
from mytable
where (timestamp between '5/1/2012 00:00:00' and '5/31/2012 23:59:59')
group by datePart(dd,timestamp)
order
select day(`timestamp`) as dayOfMonth, count(`timestamp`) as searchesPerDay
from mytable
where `timestamp` between '2012-05-01 00:00:00' and '2012-05-31 23:59:59')
group by dayOfMonth
order by dayOfMonth asc
iirc, timestamp is a reserved word in MySQL - hence it's enclosed in
ticks above (note
I sure thought about that Russ. The only thing is where and how to set the
struct with the cfcatch errors in order to return the struct. If you have an
idea let me now. I will look into that in the meantime.
~|
Order the
This sure worked Russ, but I noticed that I made a mistake earlier in my
function. I placed the cftry tags in the wrong place. Anyway, here is what I
did returning a struct and a string.
USING A STRING:
cffunction name=NAME returntype=any
cfset var result = /
cftry
Hello all,
I have this situation. I am trying to send an error message from a cfquery
doing an update in a cffunction. The update is supposed to throw a duplicate
record error message, but even when a try a cftry and cfcatch, ajaxCFC just
return the Invalid Reply from Server message.
Does
if you are return a struct from the cfc, then just put the error into the
struct.
e.g.
cfset returnstruct.error = cfcatch
then check for the existence of this key in your page and display the error.
if your trying to debug an error then there are several ways to do this.
call the cfc directly
I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One of
the properties of my object is a start date. Everything inserts and updates to
the MySQL database without a problem. This issue that I am having is when I try
to perform any CF date functions on the stored date
Nevermind. Stupid mistake. I was looping over a number of records and it turns
out that one of the records had a null value set which was what caused the
error. Had nothing to do with MySQL dates at all. Ugh.
I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM.
One
can you perform any date functions on it at all ?
Try running it through CreateDate() or CreateODBCDate() first and see if
that helps
On Sun, Jan 22, 2012 at 8:48 PM, Dean Lawrence dean...@gmail.com wrote:
I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One
Hi all:
I've been presented with an interesting problem for which I seem to have hit a
wall. I have an app wherein it would be very handy to be able to have the CF
code create a new database as needed IN MySQL. I've tried the straight CREATE
DATABASE AAA in a CFQUERY with an existing
as needed IN MySQL. I've tried the
straight CREATE DATABASE AAA in a CFQUERY with an existing datasource and
get an exception error reading Encountered DATABASE at line xxx. I've
tried doing the entire SQL string as a variable. I'm considering putting
it in as a stored proc on an existing
problem for which I seem to have hit
a wall. I have an app wherein it would be very handy to be able to have the
CF code create a new database as needed IN MySQL. I've tried the straight
CREATE DATABASE AAA in a CFQUERY with an existing datasource and get an
exception error reading
problem for which I seem to have
hit a wall. I have an app wherein it would be very handy to be able to
have the CF code create a new database as needed IN MySQL. I've tried
the
straight CREATE DATABASE AAA in a CFQUERY with an existing datasource and
get an exception error reading
handy to be able to
have the CF code create a new database as needed IN MySQL. I've tried
the
straight CREATE DATABASE AAA in a CFQUERY with an existing datasource
and
get an exception error reading Encountered DATABASE at line xxx.
I've
tried doing the entire SQL string
Saw the oAuth library at RIAForge, and it appears to support errything BUT
MySQL. Has anyone done it before? Should I just port all of the table
generation and sql myself?
Thanks!
~|
Order the Adobe Coldfusion Anthology now
Hi, guys...
I've been writing, research, and re-writing a query
over and over trying to get the correct (ie, trustworthy)
results, but can't make it work.
How would I write a query that would:
- find all propertyID's from a table that had duplicate photo200 field
values
I've tried every
Doesn't the count have to be count(*) but otherwise it looks fine to me.
On Sat, Aug 13, 2011 at 3:44 AM, Rick Faircloth r...@whitestonemedia.comwrote:
Hi, guys...
I've been writing, research, and re-writing a query
over and over trying to get the correct (ie, trustworthy)
results, but
I'd think grouping by propertyID as well would be a good
startotherwise you're just getting ALL duplicate photo200 values
across ALL properties.
What is wrong with your results? that may help us help you Rick ;-)
A brute force way is to:
select propertyID, count(photo200) as NumPhoto200
- find all propertyID's from a table that had duplicate
photo200 field values
If you mean _different_ propertyID's sharing the same photo200 value, you would
need to count by the photo200 column instead. Then match it with the
propertyID.
One option is using a join. Another would be a
Thanks, guys...
I decided to try Leigh's suggestion first, and it worked.
Thanks for the suggestions, everyone!
Rick :o)
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Friday, August 12, 2011 2:02 PM
To: cf-talk
Subject: Re: How to write this MySQL query
Rick - If you do not need the TimesUsed count, you might also try the WHERE
EXISTS approach to compare performance.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
and show them
why photos were appearing with the wrong properties.
Thanks for your help!
Rick
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Friday, August 12, 2011 4:05 PM
To: cf-talk
Subject: RE: How to write this MySQL query...
Rick - If you do not need the TimesUsed
Ah. Ad-hoc. Gotcha.
(Can you tell I have been tuning monster sql queries all day? Here is to a sql
free weekend! ;-)
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
As suggested by Raymond, I am going to install MySQL server. Is there
anything special I need to know security wise? It's going onto a win2k8
box.
How do I setup a datasource in CFAdmin for MySQL? I've only ever dealt with
MS SQL, Access, Excel, ODBC connections, etc
You should real the notes on the various install modes/settings to make sure
you install it configured with the best options for your needs, it isn't
really as straight forward as MSSQL.
I would suggest you block remote access to mysql in your firewall and use
phpmyadmin to access it or just
Not sure I'd recommend phpmyadmin - wouldn't that also imply
installing PHP? MySQL has free tools for management - why not just use
them? (And yeah - they kinda suck in terms of UX but you can deal with
it. :)
On Mon, May 16, 2011 at 12:34 PM, Russ Michaels r...@michaels.me.uk wrote:
You
that would depend if you want to open up remote access.
If you do then at least restrict it by IP or use a VPN.
MySQL ports are regularly scanned for and attacked if found open.
On Mon, May 16, 2011 at 8:01 PM, Raymond Camden rcam...@gmail.com wrote:
Not sure I'd recommend phpmyadmin
I have no need for remote access. I RDP into the machine over VPN already.
-Original Message-
From: Russ Michaels r...@michaels.me.uk
To: cf-talk cf-talk@houseoffusion.com
Date: Mon, 16 May 2011 22:17:39 +0100
Subject: Re: MySQL install
that would depend if you want to open up
Works for me.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 11 May 2011 11:26, Dave Watts dwa...@figleaf.com wrote:
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
Your DB2 link is
No. Not all DB's are equal just because they all run SQL.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 11 May 2011 10:45, Maureen mamamaur...@gmail.com wrote:
They are all real databases. The majority of the problems that
website databases have are caused by
Funnily enough I looked into Oracle Express recently for a client, and it is
not actually suitable for web apps. It is primarily intended for mobile
platforms or portable media.
On Wed, May 11, 2011 at 8:58 AM, James Holmes james.hol...@gmail.comwrote:
No. Not all DB's are equal just because
Will, I pinched some of Gerald's popcorn and had a good read, thanks for all
the replies. It has been very interesting reading the discussion on the
various DB's.
Overall, SQL Server Express is coming out on top for me. My existing
databases don't get anywhere near the 10GB limit, and I
Here is a complete feature matrix.
http://msdn.microsoft.com/en-us/library/cc645993.aspx
I'm sure I used SSIS with 2005 Express, so I would expect it is with 2008.
You certainly have import/export services anyway.
Just make sure you get SQL Server Express with Tools.
If you find features missing
lol. ;-)
On 5/10/2011 8:26 PM, Dave Watts wrote:
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
Your DB2 link is broken.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
I second the comment on Navicat. It's intuitive and easy to use and the new
Premium edition supports MS-SQL as well as MySQL, Postgre, Oracle and SQLite.
And no, I don't have any affiliation with them, I just love their product :-)
I've converted several databases from MS-SQL to MySQL
While installing the trial of SQL Server 2008 will get you the full
Management Studio and Business Development Studio (or whatever it is
called in 2008, and is required for developing SSIS solutions), SQL
Server Express does not have the SSIS service. You have to have at
least one full SQL
FWIW, here's some code for automating the backup process in SQL Server
Express:
http://www.cfgears.com/index.cfm/2010/7/20/Automating-backups-for-SQL-Server-Express
Thanks,
Eric Cobb
http://www.cfgears.com
Help me make a difference this summer -http://bit.ly/i8dJvQ
On 5/11/2011 1:36 PM, Carl
: Re: Migrating a DB from MS SQL 2000 into MySQL latest release
I second the comment on Navicat. It's intuitive and easy to use
and the new Premium edition supports MS-SQL as well as MySQL,
Postgre, Oracle and SQLite. And no, I don't have any affiliation
with them, I just love their product
.
MySQL databases corrupt quite easily and need to be repaired (even on
dedicated machines)
Never had a MSSQL corruption problem since MSSQL 2000
MySQL will easily get overloaded by a single database and consume 100% CPU
requiring a restart, only experienced this on v4 so far though.
Never had
I've been using MySQL for over 10 years and never had any problems with it.
Get PremiumSoft's Navicat for your GUI and management is a breeze. Never
had anything corrupted and MySQL only overloads the CPU when code is not
working correctly.
Backups can easily be automated with Navicat, as well
it is not really just my own opinion/experience, but all the
experience of all those other customers as well, I am more of a messenger
really.
The common problems and issues can be googled, like this for example.
http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq=trls=org.mozilla:en
this for example.
http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq=trls=org.mozilla:en-GB:officialclient=firefox-a
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology
2011 22:31, Russ Michaels r...@michaels.me.uk wrote:
The common problems and issues can be googled, like this for example.
http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq=trls=org.mozilla:en-GB:officialclient=firefox
simultaneously on the same
server with my sites.
I don't have a lot of complex code (at least not to me) running on these
servers accessing the database, so that cuts down on coding problems that
might cause MySQL to spike the CPU. I did have more issues with that a
few years ago, and even once recently
a lot of complex code (at least not to me) running on these
servers accessing the database, so that cuts down on coding problems that
might cause MySQL to spike the CPU. I did have more issues with that a
few years ago, and even once recently on the server, but the CPU spiking
has always been
All true... now as far as all your code was good... I don't know
about that, but it gets the job done. :o)
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 12:26 PM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest
Re: good code:
I've done this once (and am about to do it again) so I'll share a few
bits that I learned re: code changes:
99% of my code was fine. But I had to adjust some syntax.
MSSQL vs MySQL:
LEN needs to be LENGTH
CHARINDEX needs to be LOCATE
There probably are more differences like
you're basing your more powerful
comments off of some bad experiences you had with MySQL. I respect that,
but I wouldn't call a very clearly hobbled DB engine more powerful
then an enterprise class DB engine because of it. Maybe you were
thinking of MS SQL Server in a more general term then MS SQL
experiences you had with MySQL. I respect that,
but I wouldn't call a very clearly hobbled DB engine more powerful
then an enterprise class DB engine because of it. Maybe you were
thinking of MS SQL Server in a more general term then MS SQL Express?
-Jordan
On 05/09/2011 04:20 PM, Russ Michaels wrote
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
:-O
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 11 May 2011 08:51, Russ Michaels r...@michaels.me.uk wrote:
lol, of course not :-)
We
They are all real databases. The majority of the problems that
website databases have are caused by badly written code, inefficient
queries and poor performance tuning, and have nothing to do with the
database platform.
On Tue, May 10, 2011 at 6:24 PM, James Holmes james.hol...@gmail.com
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
Your DB2 link is broken.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business
I'm interested in any info. Pit falls to avoid, best practises, etc.
Many thanks,
Jenny
No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11
19:34:00
don't forget that MSSQL express is also free and more powerful than mysql
community edition so there is no need to migrate to MySQL unless your also
moving to Linux.
There are however free migration tools on the mysql site that will do it for
you.
On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin
I find the more powerful comment humorous.
SQL Express limits are here:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
Migration from MS SQL to MySQL documentation is here:
http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html
Russ Michaels wrote:
don't forget that MSSQL express is also free and more powerful than mysql
Jordan Michaels jor...@viviotech.net wrote:
I find the more powerful comment humorous.
This should be fun to watch :) I am making some popcorn. Anyone want some?
G!
On Mon, May 9, 2011 at 6
Perhaps you tried to run MSSQL on linux Jordan, that would certainly
be humorous I imagine :-)
On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.comwrote:
Russ Michaels wrote:
don't forget that MSSQL express is also free and more powerful than mysql
Jordan Michaels
Well, it is pretty damn funny.
I've migrated from MS SQL to MySql before and it generally isn't too
bad. There are various migration tools available, I like the ones from
Red Gate. MySql has some funkiness that comes into play if you want to
combine foreign keys and full text indexing from what
imagine :-)
On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.comwrote:
Russ Michaels wrote:
don't forget that MSSQL express is also free and more powerful than mysql
Jordan Michaels jor...@viviotech.net wrote:
I find the more powerful comment humorous.
This should
Many people often wrongly assume that MySQL is simply FREE, which is not
correct. Many people are also completely unaware that there is a FREE MSSQL
Express edition.
The FREE version is the community edition, which also has limitations, look
them up, If you want enterprise features then you have
MySql is free though licensing is a bit complicated because of a
dual-license model. The community edition includes many enterprise
sorts of features like replication and partitioning. If I recall,
there are additional backup tools and monitoring in the paid
enterprise edition. If you want to go
Hi geniuses!
I have a MySQL table with a field (fieldtype = timestamp) named DateTime, and
whenever a record is added to this table, the DateTime field automatically
enters the current date and time.
In a query, I want to choose only those records that were entered today, like
this:
WHERE
: Choosing Today's Records from a MySQL Database
Hi geniuses!
I have a MySQL table with a field (fieldtype = timestamp) named DateTime,
and whenever a record is added to this table, the DateTime field
automatically enters the current date and time.
In a query, I want to choose only those records
yes.
From: Bobby Hartsfield bo...@acoderslife.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Friday, April 29, 2011 7:40 PM
Subject: Re: Choosing Today's Records from a MySQL Database
Something like this?
Where date(columnName) = date(now
INSERT INTO maintable
(col1, col2, ..., colN)
SELECT col1, col2, ..., colN
FROM table2
Azadi
On 23/04/2011 11:51 , Scott Williams wrote:
Hello geniuses!
I've been largely successful exporting my Access database into MySQL, but
have one problem. The SQL dump file for one of my tables
That did it. Thanks Azadi!
Scott
From: Azadi Saryev azadi.sar...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Saturday, April 23, 2011 2:41 AM
Subject: Re: Appending Data into a Table from Another Table in MySQL
INSERT INTO maintable
(col1, col2
Hello geniuses!
I've been largely successful exporting my Access database into MySQL, but have
one problem. The SQL dump file for one of my tables is just a smidge too large
to import (the host limits the size to 2048, and my sql file is 2137).
Anyway, I just broke the table into two, Table1
If you have no gaps in the autoid field in Access, you can create am
additional field in MySQL for your Access ID, and order the Access
table in ID order, then import it and the MYSQL autonumber field
should match the Access ID field. if that is the case, you can then
delete the extra field
how are you migrating your db?
mysql used to have a migration toolkit as part of mysql gui tools bundle
which handled access-mysql migration very well.
the gui tools have now been replaced by mysql workbench, but you can
still download them from mysql website.
gui tools: http://dev.mysql.com
You would probably find it easier to upgrade to MSSQL, which is better
anyway in so many ways than MySQL esp if you are on windows (speed,
performance, reliability, scheduled backups, automated maintenance, no table
corrupting issues, no horrid SQL dumps to name a few). Presumably if your
using
then remember that MSSQL Express is also FREE
limited to 4GB in size.
if you definitely want to end up with MySQL then it would be easier to
use the built in wizard to upsize from MSAccess to MSSQL then (if you
still want to) ... convert from MSSQL to MySQL
i would bother trying to use
Yes mysql has a 4gb limit, for MSSQL there is also a limit of 10GB, please
see this url
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
which is more than enough for most people. In fact we have been hosting
Oy -- I shouldn't have started this one until the weekend.
I'm converting from MS Access to MySQL on one of my ColdFusion sites, and
having problems converting my Autonumbered Access tables to MySQL format. They
just won't import at all. If I remove the primary key and change the format
Howdy,
We're moving an app from CF7 to CF9 on Linux 64-bit (Red Hat Enterprise).
I've seen mention that the driver that ships with CF9 has difficulty
maintaining connections to MySQL, and the recommended fallback is to install
the CF8 MySQL driver.
Is this still the case, and, if so
I've seen mention that the driver that ships with CF9 has difficulty
maintaining connections to MySQL,
and the recommended fallback is to install the CF8 MySQL driver.
Is this still the case, and, if so, are there instructions or posts anywhere
that describe how to do this?
I don't use
also, shouldn't those 2 tables be joined together some how?
They are...not sure why the first post didn't include all of the query
cffunction name=getAverageTotalCalls access=public
cfargument name=employeeID type=numeric required=yes
cfargument name=dateWorked
Shouldn't it be?
SELECT avg(da.connects+ sum(ad.acd)) as averageTotalCalls
I changed it and still got the same error:
Invalid use of group function
~|
Order the Adobe Coldfusion Anthology now!
can you provide a couple rows of data with no functions? just the ad.acd and
the da.connects?
and what you would like for it to show? whenever you use an aggregate
function like avg you have to use group by
like
select studentId, avg(grade)
from grades
group by studentId
On Thu, Mar 10, 2011
can you provide a couple rows of data with no functions? just the ad.acd and
the da.connects?
and what you would like for it to show? whenever you use an aggregate
function like avg you have to use group by
like
select studentId, avg(grade)
from grades
group by studentId
On Thu, Mar 10, 2011
can you provide a couple rows of data with no functions? just the ad.acd and
the da.connects?
and what you would like for it to show? whenever you use an aggregate
function like avg you have to use group by
like
select studentId, avg(grade)
from grades
group by studentId
Yes sorry I misread
So you want : (13 + 192) / 2?
Or do you need 192/13 ?
On Thu, Mar 10, 2011 at 2:07 PM, Torrent Girl moniqueb...@gmail.com wrote:
can you provide a couple rows of data with no functions? just the ad.acd
and
the da.connects?
and what you would like for it to show? whenever you use an
select avg(connects + acd) from (
SELECT da.connects as connects, sum(ad.acd) as acd
FROM dialeragent da, agentDaily ad WHERE da.employeeID = ? AND da.employeeID
= ad.employeeID AND da.dateWorked = ? AND ad.dateWorked = ? group by
connects
)
On Thu, Mar 10, 2011 at 2:20 PM, Greg Morphis
Hi All
I have the following function that I am TRYING to get the average of a sum of 2
added values.
cffunction name=getAverageTotalCalls access=public
cfargument name=employeeIDtype=numeric required=yes
cfargument name=dateWorkedtype=string required=yes
with mySQL
Hi All
I have the following function that I am TRYING to get the average of a sum
of
2 added values.
cffunction name=getAverageTotalCalls access=public
cfargument name=employeeID type=numeric
required=yes
cfargument name=dateWorked type=string
also, shouldn't those 2 tables be joined together some how?
On Wed, Mar 9, 2011 at 8:00 PM, Torrent Girl moniqueb...@gmail.com wrote:
Hi All
I have the following function that I am TRYING to get the average of a sum
of 2 added values.
cffunction name=getAverageTotalCalls access=public
live into production recently) is
MySQL on EC2 using two micro instances in a Master-Slave setup. Arguably this
will work fine for small to medium sized sites which run less complex queries.
So far it is working a treat for a site that pushes around 2,000 daily sessions
and a few thousand
You'll most likely want your CF server in close proximity to the cloud based
MySQL server, i.e. your server would want to be an EC2 instance.
I've a few servers setup in the Amazon cloud and for the most part it is
really neat. Things to be aware of though are outages, servers have a habit
On Fri, Feb 18, 2011 at 5:57 AM, Chris wrote:
Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept
from what I'm reading at least, sounds great.
I currently use shared hosting with CF and MySQL. I'm pouring over the
documentation but most of it is over my head
I would presume you are not using amazon for a 24/7 database connection as
this would be prohibitively expensive, much more than having your own VPS
or using database hositng, so I presume you are using it only for occasional
access, in which case caching your queries is a must and will overcome
, Jochem van Dieten wrote:
On Fri, Feb 18, 2011 at 5:57 AM, Chris wrote:
Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept
from what I'm reading at least, sounds great.
I currently use shared hosting with CF and MySQL. I'm pouring over the
documentation
Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept
from what I'm reading at least, sounds great.
I currently use shared hosting with CF and MySQL. I'm pouring over the
documentation but most of it is over my head as I'm not familiar with Amazon
web services
it seems more to do with the ext store as there is no column displaying the
data for this field.
the reason for this setup is that i have a grid showing the main record
information, then when the user double clicks a row it opens a window with a
form inside it. The form is then populated with
whats strange is that even if i remove that field from the store, the store
still doesnt load, its like the line breaks are causing an error in the json
being passed
Can you show me your column config
thanks for your reply, yes im using firebug and ext straight up
i included these 2
9:00 AM
To: cf-talk
Subject: Re: ExtJS Text Area, MySQL, ColdFusion and Enter Key
whats strange is that even if i remove that field from the store, the store
still doesnt load, its like the line breaks are causing an error in the json
being passed
Can you show me your column config
thanks
if I take out the enter key and enter a normal string then everything is fine.
This is throughout the software and not just on this store. so it is definitely
how the enter key is being passed
in the cfm file i have a query that pulls out the data then converts it to JSON
and sends it to ext
Telling us what the error is would help... I have not had any problems with
line breaks and Ext.data.Store... + Ext.Grid
its strange as there isnt actually an error being thrown by firebug. In the
text area i entered:
Testing
Testing
... then if i dump out the JSON text it displays it as
-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent: January-18-11 2:38 AM
To: cf-talk
Subject: Re: ExtJS Text Area, MySQL, ColdFusion and Enter Key
Telling us what the error is would help... I have not had any problems
with line breaks and Ext.data.Store... + Ext.Grid
its strange as there isnt
1 - 100 of 3156 matches
Mail list logo
