e...@it-werks.com]
Sent: Wednesday, 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 woul
PDATE items
SET sortOrder =
WHERE (ID = )
On 9/25/13 4:42 PM, te...@it-werks.com te...@it-werks.com wrote:
> 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
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
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 encl
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
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:
...
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 Adobe
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 not
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 a
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 wrote:
>
> I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One
> of the propert
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.
>
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.
If
gt; > > 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
> > &
t; 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
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 datas
ing of the sort as well.
HTH
On Thu, Jan 19, 2012 at 11:54 AM, HCI wrote:
>
> 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 d
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 a
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
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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/143
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
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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430
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
> - 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 sub
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
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 wrote:
>
> 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.
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 variat
I have no need for remote access. I RDP into the machine over VPN already.
-Original Message-
From: Russ Michaels
To: cf-talk
Date: Mon, 16 May 2011 22:17:39 +0100
Subject: Re: MySQL install
that would depend if you want to open up remote access.
If you do then at least restrict
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 wrote:
>
> Not sure I'd recommend phpmyadmin - wouldn&
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 wrote:
>
> You shoul
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
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 connec
: 11 May 2011 19:48
>>To: cf-talk
>>Subject: 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,
>&g
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
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 Se
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 t
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.fig
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
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 wouldn'
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 wrote:
>
> No. Not all DB's are equal just because they all run SQL.
>
>
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 wrote:
>
> They are all "real" databases. The majority of the problems that
> website databases have are caused by badly written code,
Works for me.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 11 May 2011 11:26, 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.
> 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 Busines
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 wrote:
>
> You could alway
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 wrote:
>
> lol, of course not :-)
> We will have to agre
t;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
unds to me 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
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 m
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
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 on the server, but
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 rec
orge.org/
>
>
>
> On 10 May 2011 22:31, Russ Michaels wrote:
> >
> > The common problems and issues can be googled, like this for example.
> >
> http://www.google.co.uk/search?q=mysql+corrupted+tables&am
is for example.
> http://www.google.co.uk/search?q=mysql+corrupted+tables&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a
~|
Order the Adobe Coldfusion Anthology now!
http://www.ama
years, so 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+tables&ie=utf-8&oe=u
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 Navica
.
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 that
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 y
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
I imagine :-)
>
>
> On Tue, May 10, 2011 at 12:12 AM, Gerald Guido wrote:
>
>>
>> > Russ Michaels wrote:
>> >
>> > don't forget that MSSQL express is also free and more powerful than mysql
>>
>>
>> >Jordan Michaels wrote:
>>
>&
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
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 wrote:
>
> > Russ Michaels wrote:
> >
> > don't forget that MSSQL express is also free and more powerful than mysql
>
> Russ Michaels wrote:
>
> don't forget that MSSQL express is also free and more powerful than mysql
>Jordan Michaels 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,
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-
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
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
yes.
>
>From: Bobby Hartsfield
>To: cf-talk
>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())
>
>.:.:
: 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
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
That did it. Thanks Azadi!
Scott
From: Azadi Saryev
To: cf-talk
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, ..., colN)
SELECT col1, col2, ..., colN
FROM
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 on
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, T
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 h
> 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
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
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.
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.
If
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 chang
> 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 h
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,
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 wrote:
So you want : (13 + 192) / 2?
Or do you need 192/13 ?
On Thu, Mar 10, 2011 at 2:07 PM, Torrent Girl 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 aggregate
> >function
>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 m
>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, M
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 a
>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!
http://www.amazon.com/Ado
>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
SELECT avg(da.connects)+avg(sum(ad.acd)) as averageTotalCalls
FROM dialeragent da, agentDaily ad
WHERE da.employeeID =
also, shouldn't those 2 tables be joined together some how?
On Wed, Mar 9, 2011 at 8:00 PM, Torrent Girl wrote:
>
> Hi All
>
> I have the following function that I am TRYING to get the average of a sum
> of 2 added values.
>
>
>
>
>
>
>SELECT avg(da.connects)+avg(sum(ad.acd)) as
ject: using sum with average with mySQL
>
>
> Hi All
>
> I have the following function that I am TRYING to get the average of a sum
of
> 2 added values.
>
>
> required="yes">
>
>
>
> SELECT avg(da.connects)+avg(sum(ad.acd)) a
Hi All
I have the following function that I am TRYING to get the average of a sum of 2
added values.
SELECT avg(da.connects)+avg(sum(ad.acd)) as averageTotalCalls
FROM dialeragent da, agentDaily ad
WHERE da.employeeID =
So basically, I need
, 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
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
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
> documentati
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
ed (in fact just put 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
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
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 u
19-11 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 colum
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 thes
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
Can you show me your column config
-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent: January-18-11 11:21 AM
To: cf-talk
Subject: Re: ExtJS Text Area, MySQL, ColdFusion and Enter Key
thanks for your reply, yes im using firebug and ext straight up
>myStore
And if you remove that column then it works?
-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent: January-18-11 11:21 AM
To: cf-talk
Subject: Re: ExtJS Text Area, MySQL, ColdFusion and Enter Key
thanks for your reply, yes im using firebug and ext straight up
1 - 100 of 3179 matches
Mail list logo