Was just reading how to do an INSERT INTO from another table in SQL
Server 2000 (like SELECT INTO, but without creating a new table) like this:
INSERT INTO tablename (the table you want to copy into)
SELECT * from tablename (the table you want to copy from)
WHERE Field = (some condition)
and
Sure, just explicitly list your columns. In fact, I would recommend ALWAYS
doing that since if you script a table and the columns get into an different
order it will really screw up your insert into table select * stuff.
Just do this:
INSERT INTO backup_name (col1,col2,col3,timestamp)
(SELECT
Yea you're right Ike. Story of my life - I relax for once and make
a smart-alec comment and it whips around and bites me.
But in my own defence, mine takes less typing! LOL .
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
Put this on the page you are working on. Put the content that you want in
the pdf in the cfsavecontent block.
cfoutput
a href=#Script_Name#?action=gimmie/a
/cfoutput
cfsavecontent variable=MyContent
Your content goes here
/cfsavecontent
cfoutput
#MyContent#
/cfoutput
cfif URL.Action
Thanks, Jayesh.
Hi Brad,
This is a known issue to us. We already have a bug logged for the same.
Thanks
Jayesh Viradiya
Adobe CF Team
I am having an issue with large file sizes on pdf documents created with
cfdocument. I have narrowed the issue down to images as the file size
culprit (or at
So...anyone *not* using the Bolt beta, please raise your hands...
I don't see any hands, so it must be out.
Is anyone allowed to confirm that it's out and being used and therefore
I didn't get a chance to work with the beta? :o(
Rick
I signed up for the beta. No word from the mothership yet.
On Thu, Dec 4, 2008 at 8:36 AM, Rick Faircloth [EMAIL PROTECTED]wrote:
So...anyone *not* using the Bolt beta, please raise your hands...
I don't see any hands, so it must be out.
Is anyone allowed to confirm that it's out and being
On Thu, Dec 4, 2008 at 2:39 PM, John M Bliss [EMAIL PROTECTED] wrote:
I signed up for the beta. No word from the mothership yet.
Ditto.
--
mac jordan
www.webhorus.net | www.reactivecooking.com | www.nibblous.com |
www.jordan-cats.org
Had there been word, Adobe's normal NDA would prevent you from saying so.
-Original Message-
From: mac jordan [mailto:[EMAIL PROTECTED]
Sent: Thu 12/4/2008 14:47
To: cf-talk
Subject: Re: Adobe's CF IDE, Bolt
On Thu, Dec 4, 2008 at 2:39 PM, John M Bliss [EMAIL PROTECTED] wrote:
I
So...anyone *not* using the Bolt beta, please raise your hands...
I don't see any hands, so it must be out.
Is anyone allowed to confirm that it's out and being used and therefore
I didn't get a chance to work with the beta? :o(
I'm not - not even sure if I'm going to until I see a good
+1
-Original Message-
From: John M Bliss [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 6:39 AM
To: cf-talk
Subject: Re: Adobe's CF IDE, Bolt
I signed up for the beta. No word from the mothership yet.
On Thu, Dec 4, 2008 at 8:36 AM, Rick Faircloth
[EMAIL PROTECTED]wrote:
I'm not saying anything. ;^)
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 8:49 AM
To: cf-talk
Subject: RE: Adobe's CF IDE, Bolt
Had there been word, Adobe's normal NDA would prevent you from saying
so.
HI everybody
Is there a way of uploading file on a different server other than what i'm
using.. if i try to upload it locally with a cffile it works but my plan is
uploading it to another one because of space problems..
thanks for any help
There is/was a problem in CF7 regarding using named arguments to call UDFs that
were in the request scope (also mentioned here, for reference
http://www.coldfusionjedi.com/index.cfm/2005/10/27/CFMX-7-and-Super-Fixes).
The function produces this error, Cannot invoke method [x] on an object of
And ditto ...
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
There is/was a problem in CF7 regarding using named arguments to call UDFs that
were in the request scope (also mentioned here, for reference
http://www.coldfusionjedi.com/index.cfm/2005/10/27/CFMX-7-and-Super-Fixes).
The function produces this error, Cannot invoke method [x] on an object of
Is there a way of uploading file on a different server other than what i'm
using.. if i try
to upload it locally with a cffile it works but my plan is uploading it to
another one
because of space problems..
Well, the file will initially be uploaded to your server, because
that's where the
Well, if there's a lot who say they haven't gotten the beta...
Tom Chiverton wrote:
Had there been word, Adobe's normal NDA would prevent you from saying so.
-Original Message-
From: mac jordan [mailto:[EMAIL PROTECTED]
Sent: Thu 12/4/2008 14:47
To: cf-talk
Subject: Re: Adobe's
Oops, browser was set to auto-refresh, hence the double post. Sorry 'bout
that...
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Maybe they have to rebrand since Disney's latest non-Pixar movie is named
'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie.
But on a technical note... Is this IDE targeted to current Eclipse users, or
is Adobe trying to convert programmers who are using Dreamweaver?
i was under the impression that at MAX they announced an alpha/beta wouldn't
be available 'til early 2009.
On Thu, Dec 4, 2008 at 7:49 AM, Rick Faircloth [EMAIL PROTECTED]wrote:
Well, if there's a lot who say they haven't gotten the beta...
Tom Chiverton wrote:
Had there been word, Adobe's
@Dominic
Nice idea! Same result though :-(
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote:
Maybe they have to rebrand since Disney's latest non-Pixar movie is named
'Bolt'. I wouldn't want *my* IDE to share a name with a stupid movie.
But on a technical note... Is this IDE targeted to current Eclipse users,
or
is
from what I understand, from reading the little bit of internet
scuttlebutt that's out there,.. it's supposed to be the CF Studio
Replacement
What that means... who knows?
Billy Cox wrote:
Maybe they have to rebrand since Disney's latest non-Pixar movie is named
'Bolt'. I wouldn't want *my*
I don't care if they call it Elmer Fudd as long as it works well and
has code folding...that feature
alone is worth $100 at least to me...
Charlie Griefer wrote:
On Thu, Dec 4, 2008 at 7:52 AM, Billy Cox [EMAIL PROTECTED] wrote:
Maybe they have to rebrand since Disney's latest non-Pixar
Bolt is only the code name, I guess, so the clash doesn't matter.
-Original Message-
From: Billy Cox [mailto:[EMAIL PROTECTED]
Sent: Thu 12/4/2008 15:52
To: cf-talk
Subject: RE: Adobe's CF IDE, Bolt
Maybe they have to rebrand since Disney's latest non-Pixar movie is named
'Bolt'. I
I'm not sure, but have you tried something like:
cfset args = StructNew() /
cfset args.foo = bar /
cfset args.bar = foo /
cfset result = request.myUdf( argumentCollection=args ) /
Quite possibly brings out the same result but worth a shot...
Dominic
Has anyone deployed Apache Roller http://roller.apache.org/ on a ColdFusion
installation? I'm wondering how to install and configure it for JRun but I've
found no luck with a google search on the topic.
~|
Adobe® ColdFusion® 8
I wouldn't want *my* IDE to share a name with a stupid movie.
It wasn't a stupid movie. IMHO it was actually rather good... and it was
about BOLT having superpowers, as I hope the new BOLT IDE does.
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite
I have a form which is throwing the following error upon submit:
Element NAME is undefined in FORM
The field is set to allow nulls in the database. Is there something else I
should be doing to allow a null value to be passed?
Thanks
that's got nothing to do with your database. you're referencing a form
field (#form.name#) that doesn't exist.
according to the error, you have no form field with the name name. if
there is one and it's a checkbox or radio group (and none are checked or
selected), they don't get passed into the
So, then it would be called EF Studio?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 10:02 AM
To: cf-talk
Subject: Re: Adobe's CF IDE, Bolt
I don't care if they call it Elmer Fudd as long as it works well and
has code folding...that
Thanks Charlie, it was a group of radio buttons.
cfparam name=form.name default= type=string /
did the trick.
that's got nothing to do with your database. you're referencing a form
field (#form.name#) that doesn't exist.
according to the error, you have no form field with the name
I have a form that is using a cfloop query to produce a input field for
productid quantity. It can produce several input fields depending on the query.
Example -
tdinput type=text size=3 name=QTY_cfoutput#prodid#/cfoutput/td
In the submit processing page I need to take the productid's that have a
I'm using cfcontent to generate reports in MS Excel. Previously the useres had
MS Excel 2003 to open the files, but now, some have upgraded to MS excel 2007
and they are getting error messages.
They are along the lines of The xxx.cfm file you are attempting to download is
incompatible with
Sounds good to me... hopefully, short for
Everyone's Favorite Studio...
Dawson, Michael wrote:
So, then it would be called EF Studio?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 10:02 AM
To: cf-talk
Subject: Re: Adobe's CF
I am using a CFDiv to bind a cfselect in a form. Some of the form fields are
hidden when the page loads. For Firefox, Chrome and Opera this isn't a problem.
In IE, all the binds fail because it can't find the hidden cfdivs. I tried
setting bindonload=false which did remove half of the errors
You realize that Eclipse has code folding right?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 10:02 AM
To: cf-talk
Subject: Re: Adobe's CF IDE, Bolt
I don't care if they call it Elmer Fudd as long as it works well and has
code
he wants it to remember the stuff he folded (e.g. select code, collapse,
close IDE, take a nap, walk the dog, open IDE, open file, and the folded
code will still be folded).
he's mentioned it on the cfeclipse mailing list once or twice :)
On Thu, Dec 4, 2008 at 9:57 AM, Andy Matthews [EMAIL
1) 'Bolt' was a good movie.
2) 'Bolt' (the IDE codename) is probably a reference to the logo that
ColdFusion had in the Allaire days. I'm hoping the keep the codename,
and start 'branding' ColdFusion again.
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7
No abbreviations. Flat out: Elmer Fudd Studio
I'd buy that for a dollar.
In the spirit of Blue Monster Reserve
http://www.gapingvoid.com/Moveable_Type/archives/004170.html
G!
On Thu, Dec 4, 2008 at 11:40 AM, Dawson, Michael [EMAIL PROTECTED]wrote:
So, then it would be called EF Studio?
While it does offer manual folding, it doesn't maintain the folds
when a file is closed...that's worthless...
Andy Matthews wrote:
You realize that Eclipse has code folding right?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008
I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up
the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a
datasource using Windows Authentication (I have no user/password assigned in
the datasource configuration; it's passing the ColdFusion service
Bolt would be an okay name...but I still like Elmer Fudd Studio. :o)
Cutter (CFRelated) wrote:
1) 'Bolt' was a good movie.
2) 'Bolt' (the IDE codename) is probably a reference to the logo that
ColdFusion had in the Allaire days. I'm hoping the keep the codename,
and start 'branding'
Worthless to have persistent folding? While I never have used it, even
though it does exist in DW which I do use, I could see how some people might
like it after having it. If perhaps they are working on something that they
cannot finish in one day and they do not leave their machine in stand by
Well, I mean it's worthless in the manner I want to use it, not that it's
worthless to everyone else...
I use to organize, quickly scan, and navigate sections of code, especially
when I first open a file.
Aaron Rouse wrote:
Worthless to have persistent folding? While I never have used it,
I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up
the Microsoft SQL Server 2005
JDBC driver, and have successfully set up a datasource using Windows
Authentication (I have no user/password
assigned in the datasource configuration; it's passing the ColdFusion
http://sph.umd.edu/news/blog2.cfm
I am recreating a blog. I am able to read in several xml files and
populate the content. To do this, I copied code from other
functionality and it's using CFHTTP. In the blog's functionality,
I'm supposed to be able to click on the title of a posting to
I tested a little bit further by going into SQL Server Management Studio and
removing permissions to the database for the ColdFusion service login account.
When I attempt to run the query, it does attempt to use the username I'm
passing, but then gives me an error:
Cannot open database GDI
You can use Windows authentication with JDBC.
In the Advanced Settings Connection String box, enter in:
AuthenticationMethod=Type2
Then, clear any username/password from that DSN. (Just to be sure.)
Confirm that your CF service account can access SQL Server's databases.
Then, Bob's your
Ooops. I missed a critical part of your message. You said you did
get Windows Authentication to work, but you want to specify individual
credentials, per query.
Sorry for the confusion.
However, one thing you may try is create a domain group, then grant
database access to that group. In that
If you have not created each user's SQL login, it won't work. However,
I wouldn't want to have to manage all those SQL logins (and database
permissions), in addition to their AD accounts.
As I mentioned in another message, you may try adding a domain group as
a SQL login/DB user.
That said...
May I ask why you are ditching the xml declaration before parsing the
xml? Ie. these lines:
cfset nodeToReplace = mid(XMLText, 1, evaluate(find(?, XMLText) + 1))
cfset XMLText = replaceNoCase(XMLText, nodeToReplace, , ALL)
If you are on CF7 or greater, and there isn't a good reason to parse
out
Ooops. I missed a critical part of your message. You said you did
get Windows Authentication to work, but you want to specify individual
credentials, per query.
Sorry for the confusion.
However, one thing you may try is create a domain group, then grant
database access to that group. In that
I wouldn't want *my* IDE to share a name with a stupid movie.
It wasn't a stupid movie. IMHO it was actually rather good... and it
was about BOLT having superpowers, as I hope the new BOLT IDE does.
I thought it was about Bolt being deluded
and only thinking he had superpowers. ;)
--
s.
Yea you're right Ike. Story of my life - I relax for once and make
a smart-alec comment and it whips around and bites me.
Yer lucky you added the my dad can beat up your dad comment at the end,
otherwise I might not have picked up on the fact that you were jokin'
around. :)
But in my own
Part of the larger WB Studio suite. :)
So, then it would be called EF Studio?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 10:02 AM
To: cf-talk
Subject: Re: Adobe's CF IDE, Bolt
I don't care if they call it Elmer Fudd as
I have a MySQL query to pull all products from the database, no problem. I am
trying to get it to only display prodcuts that are in stock, the value should
be sold p.quantity in the following query. however, when sold appears as
null (very often) it removes the full record, which I don't
In the spirit of Blue Monster Reserve
http://www.gapingvoid.com/Moveable_Type/archives/004170.html
I think it's hilariously ironic that Microsoft employees are trying to
change the world and convince the corporate suits to become more open
and stop maintaining their monopoly-esque
Hello,
Im new to this mailing list, so please go easy on me. :)
I am having trouble running the coldfusion 8 line debugger against my
application. After following the livedocs instructions and some instructions
on forta.com, I got it up and running. The RDS connection tests fine, and in
some
Hello,
Im new to this mailing list, so please go easy on me. :)
I am having trouble running the coldfusion 8 line debugger against my
application. After following the livedocs instructions and some instructions on
forta.com, I got it up and running. The RDS connection tests fine, and in some
The only reason I was even trying this was to ensure secure access to a
particular database
that only certain users have permissions to write to. I guess I'll have to
manage the
permissions through my CF application, rather than at the SQL Server level.
Is this how most
developers deal
Try this, I think it's what you're looking for:
SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points,
p.short_description, p.quantity, p.image
FROM tblproducts as p LEFT JOIN
tblorder_list as o ON p.sku = o.sku #can_afford#
WHERE SUM(ISNULL(o.qty, 0)) p.quantity
GROUP BY p.sku
In Exchange 2003, recurring events produce the same UID for each
instance of the event. Even though each instance's start time is
different, the UID is still the same. Therefore, it is impossible to
uniquely identify a calendar item using only the UID.
An example of the UID is:
Does anyone have experience or know if Open BlueDragon or Railo are suitable
for use in a high traffic e-commerce site? During the busiest times there are
about 100,000 visitors between 8 AM and 7 PM during a day. The highest
concentration is between 10 AM and 2 PM. There are lots of
The formal Bolt beta has not yet started, so the fact that you've heard
nothing yet does not mean that you won't be. Hang in there ...
--- Ben
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 9:52 AM
To: cf-talk
Subject: Re:
If you're interested, I've got some code for JExcelAPI that does stuff
like take a structure of queries and turns them into sheets in a
workbook, and vice versa.
:Denny
--
You will never do anything in this world without courage. It is the
greatest quality of the mind next to honor.
Aristotle
Dunno if it will help, but I've done some stuff with ical4j, and had a
similar deal:
http://m2.modularity.net.au/projects/ical4j/apidocs/index.html
The text you're after may be:
The full range of calendar components specified by a recurrence set
is referenced by referring to just the
Hi all,
So I'm getting ready to publish the results any my thoughts on the
results of the framework survey that I posted a little while ago. I'd
like to take a moment before I do however to solicit some more casual
(less structured) feedback from the community.
From those of you familiar with
Thanks for the info, Ben!
Rick
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 6:59 PM
To: cf-talk
Subject: RE: Adobe's CF IDE, Bolt
The formal Bolt beta has not yet started, so the fact that you've heard
nothing yet does not mean
care to post a code sample or a simple test case?
i do not recall having a problem in any browser with binding hidden
elements...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Ian Rutherford wrote:
I am using a CFDiv to bind a cfselect in a form. Some of the form fields are
hidden
in the form's action page, loop through #form.fieldnames#, if the
fieldname starts with qty_ and has a value - get the prodid from field
name using removechars() or listlast() and update the db. something like
this:
cfloop list=#form.filednames# index=field
cfif left(field, 4) is QTY_ AND
or, if possible, you could use CFFTP to put the uploaded file to another
server...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Dave Watts wrote:
Is there a way of uploading file on a different server other than what i'm
using.. if i try
to upload it locally with a cffile it works
i believe the correct function to use is IFNULL(), not ISNULL()...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Jason Fisher wrote:
Try this, I think it's what you're looking for:
SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points,
p.short_description, p.quantity,
I am part of the OpenBD project so I will try to keep my opionions out of it
when it comes to OpenBD. They are both suitable for high traffic websites.
BlueDragon powers CarFax.com, as well as blog-city both of which are high
traffic. I am not sure what sites Railo runs but from my personal
I need to gather information about CF and web services. Could anybody
point me to some resources about best practices when implementing web
services in CF? Any lessons learned, gotchas from your own experience
are even better.
I know already a bit about the complex data types and their problems in
Couple of thoughts rick. You could take a stab at adding the feature. There
is mechanism in eclipse to do this, and I can't imagine it would be overly
difficult. Also, have you considered using the outline view? It is very nice
and allows one to scan a file rather quickly. I was jut talking about
Contract to hire position for a Sr. Web Applications Developer -
ColdFusion in Patuxent River, MD.
If interested in applying for this position, please contact Aru Valecha at
1800 - 216 - 1904 or [EMAIL PROTECTED]
Thank you!
Aru Valecha
Sr. Technical Recruiter
Acro Service Corporation
1800 -
78 matches
Mail list logo