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 is
My first time using created queries, I can't understand why this is putting
the same value on every row.
cfset stock = QueryNew(StockTitle, Varchar)
cfoutput
cfloop from=1 to=#stockTable.recordcount# index=R
cfset newrow = QueryAddRow(stock,1)
cfset temp = QuerySetCell(Stock, stockTitle,
You are using a simple cfloop from to, instead of a cfquery or a cfloop
query.
Because of this, when you call #stockTable.stockTitle#, it defaults to the
first line of the query.
Either change your loop to a cfloop query=stockTable
Or change your data call to #stockTable.stockTitle[R]#
William
Hi All -
I have a IIS/coldfusion question. I am working with a client, who has both
production and development stuff on the same machine. He has two drives, C and
E. C drive has development files and E drive has production. The IIS
configuration points to E drive.
C drive the has the
Hi All -
I have a IIS/coldfusion question. I am working with a client, who has both
production and development stuff on the same machine. He has two drives, C and
E. C drive has development files and E drive has production. The IIS
configuration points to E drive.
C drive the has the
You'd likely want to defined two iis sites, one for dev and one for prod.
For each site, the home directory should be the respective code base for each,
and you'd want to add a virtual directory pointing to cfide on each. The
differing drives should be no problem.
Hope that helps!
Charlie
Right click the web site in IIS and click on click on the home directory path.
This will tell you where IIS is looking on a per site basis.
Hope this helps.
Thanks,
Brian
On Apr 23, 2011, at 1:15 PM, fun and learning funandlrnn...@gmail.com wrote:
Hi All -
I have a IIS/coldfusion
But confused if IIS can point to two different drives? How to find out which
drive the IIS point out to.. I hope I am not vague with my question
A single IIS server can have many IIS sites, or virtual servers. These
can point to wherever you want them to point. Presumably, this machine
has at
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,
as you are running both development and production on the same server I
would also suggest you take measures to isolate them as this is a very bad
setup you have as your untested development code could take down CF and thus
the live site.
I suggest you run CF multi in server mode and run 2
Many thanks, Will. Obvious now I look at it again, duh me.
Anyhoo, I had this (probably dumb) idea of combining sever fulltext search
query results into one table, turning into a lot more work than I expected
(+ learning curve).
Maybe there is a better way of going about this:-
Scenario -
Seems to me it would a lot more efficient to make a view in your
database that only returns the two fields you want to search on plus
any fields you need for search criteria. Or do a select with a join
that returns the fields. Once you do that, they are already in a
query, so you wouldn't need
Hi Russ,
See your point, but the actual likely hood of taking down a server with code
is pretty small.
You can always set up IIS/CF on your local PC anyway and avoid the problem.
The only issue then is the database, as you are unlikely to be running a
server o/s on your pc, assuming the
Jenny i'm not sure what evidence you have to quality that statement, but you
couldn't be more wrong, bad code sure can take down a web server and even a
database server, it happens every day.
With 10+ years in the hosting business I personally see it happen all the
time and consult with many
Hi Maureen,
Many thanks for the reply.
Taking the first two queries.
In Product I search on title, short description and long description.
In Product Options I search on the option title and description.
I tried some tests joining the tables:-
cfquery dbtype=query name=product
select stockID
Russ,
I agree with you 100% but in Jenny's defense perhaps she meant this code
rather than code in general. I have a few sites that are so simple I could
see them in that light I suppose. Still as best practice I totally agree
with you. In fact, such code is what keeps our business growing (ha).
The physical directory location is listed in the configuration. You can
have multiple directories from multiple drives listed in a web site. When
you point to a directory that is outside of the root, you are creating
virtual directories (aka aliases in Apache), so yes, you can have files in
I have certainly done it before :-D
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Saturday, April 23, 2011 06:43 PM
To: cf-talk
Subject: Re: IIS Question
Jenny i'm not sure what evidence you have to quality that statement, but you
couldn't be more wrong,
Hi Russ,
With 30 years in the IT business and over 20 of them as an IT Manager I am
fully aware of the implications of server vulnerability.
A hosting environment is a very different scenario to a single developer
using a single server for testing and live applications.
Sure, in an ideal world
@ the original poster who left no name.
Don't forget to set up your virtual CFIDE directories for each site.
Jenny
No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/11
07:36:00
I think what you want is an inner join. An inner join gives you ONLY
the records in the Product Table that have matching ids in the Product
Options table.
An outer join will give you all the records in the Product Table but
only those in Product Options that with matching ids.
So if your
On Sat, Apr 23, 2011 at 4:58 PM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
As I understand it FREETEXTTABLE can only search on one table at a time?
I can't use a database view in the fulltext catalogue? If I can it answers
all my problems.
I've never used FREETEXTTABLE on a
Hi Maureen,
I found it is possible to create indexed views and add them to a fulltext
catalog, however, among a longgg list of constraints MS say that the views
cannot contain Ntext fields, which rules out that option for me.
http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx
Are you still running SQL Server 2000, and if not, is that still the
case for the version of SQL you are running?
On Sat, Apr 23, 2011 at 5:29 PM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
Hi Maureen,
I found it is possible to create indexed views and add them to a fulltext
I'm still on SQL 2000.
Sadly it can't be done in SQL 2008 either:
The view cannot include text, ntext, or image columns, even if they are not
referenced in the CREATE INDEX statement.
http://msdn.microsoft.com/en-us/library/ms191432.aspx
-Original Message-
From: Maureen
So you believe that code can only bring a server down in a hosted
environment and that hosting a live production site off your local
development machine (presumably running off a ADSL connection) is not better
than a server in a data centre with monitoring, power generators,
professional peering
Darn. That bites. Maybe a different searching mechanism if the
simple query doesn't work.
Or a temp table.
On Sat, Apr 23, 2011 at 5:45 PM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
I'm still on SQL 2000.
Sadly it can't be done in SQL 2008 either:
The view cannot include
Change all your ntext to nvarchar(MAX), if you can.
And run an UPDATE to free up space after the conversion, too ;)
ALTER TABLE myTable
ALTER COLUMN myNText nvarchar(MAX);
UPDATE myTable
SET myNText = myNText;
That lets SQL keep the first set of chars locally, and only points to
the LOB when
See your point, but the actual likely hood of taking down a server with code
is pretty small.
My experience has been directly the opposite of this over the last
fifteen years or so.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a
Russ,
1. No, I do not believe that it is only possible for code to bring a server
down in a hosted environment, I never said that.
2. The bandwidth requirement I have matches my needs, thanks for asking.
3. I don't take holidays and I'm pretty much here 24/7 so my support to my
customers is
Point taken, but I can only speak from my own experience.
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: 24 April 2011 02:27
To: cf-talk
Subject: Re: IIS Question
See your point, but the actual likely hood of taking down a server with
code
is pretty small.
My
Hi Maureen,
I really like your thinking, but I'm not sure that will achieve what I need,
I'll definitely test it out tomorrow though, many thanks for your input,
much appreciated.
One niggle is that having to use two queries really messes up using the
Ranking.
Jenny
-Original
Hi Jason,
Many thanks for your reply, it would be great if this will work on SQL 2000.
I tried testing this:
ALTER TABLE testing
ALTER COLUMN testing nvarchar(MAX);
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'MAX'.
I Googled a bit and found a couple of postings
Varchar(max) was added to mssql 2005 2000 has a limit of Varchar(8060)
Sent from my iPhone
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Actually Jenny I was ONLY quoting your own statements BACK, so I did not
make any assumptions, you may want to read back your own emails to avoid
contradictions like this.
A little friendly advice, If you want your business to be private and think
it is not anyone else's business what you do,
Hi Kamru,
Sorry for my late reply.
This link will give you a good idea of what a VPN could do for you:
http://technet.microsoft.com/en-us/library/bb742566.aspx
It is unlikely to be a cheap solution, but it will have the potential to be
a robust and secure solution.
Something you could
If you are using SQL Server 2000, to avoid truncation you can use TEXT or
nText fields instead. These are BLOBS and are not contained by the max row
length. The combined max row size for all other fields is 8060, anything
above this will be truncated.
Since SQL Server 2005 these were depreciated
Ah, yeah, pretty sure nvarchar(MAX) was added in SQL 2005, unfortunately.
So, to explain further, ntext holds only a pointer to the actual content
elsewhere on the server, held in a Large Object (LOB). nvarchar(MAX)
holds the first 8k of data in the table, so to speak, and then only
pushes
Be sure to enable the blob/clob option(s) on the CF datasource if you go
with those datatypes.
That one bites me all the time.
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
She's already using ntext. She is trying to figure a way to search
two different ntext fields in two different related tables returned by
the same query using FREETEXTTABLE
On Sat, Apr 23, 2011 at 7:28 PM, Russ Michaels r...@michaels.me.uk wrote:
If you are using SQL Server 2000, to avoid
You're not worth my time.
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: 24 April 2011 03:21
To: cf-talk
Subject: Re: IIS Question
Actually Jenny I was ONLY quoting your own statements BACK, so I did not
make any assumptions, you may want to read back your
That's awesome, Jason, many thanks for explaining.
I'm not using ntext fields extensively, so if I upgrade my SQL later it's
not going to be a big head ache.
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: 24 April 2011 03:30
To: cf-talk
Subject: Re: Problem Using
Thanks Bobby, I did indeed miss that!
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: 24 April 2011 03:38
To: cf-talk
Subject: RE: Problem Using QueryNew
Be sure to enable the blob/clob option(s) on the CF datasource if you go
with those datatypes.
That
I wish all countries followed Australia's example.
-Original Message-
From: Kym Kovan [mailto:dev-li...@mbcomms.net.au]
Sent: 21 April 2011 02:32
To: cf-talk
Subject: Re: OT question - is this real or phishing?
On 21/04/2011 09:49, Russ Michaels wrote:
anyone can register any
44 matches
Mail list logo