List alive?
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could
I have a ColdFusion app that is dynamically managing a SQL Server 2K
database. What I am running into is the need to change a column
data type - specifically an ntext data type. Anybody got any
suggestions?
It appears that I cannot used ALTER TABLE/COLUMN with an ntext data
type, so
Hi,
Could someone tell me where I'm going wrong with the below
cfquery?
cfquery name=qUpdateProfile datasource=prefs
UPDATE tblProfiles
(
strSelect,
strShowMe
)
VALUES
(
cfqueryparam value=#No_Access_List#
cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam
Does anyone else on the [EMAIL PROTECTED] list use
spamcop.net to filter their mail? I'm finding that quite a number of
messages from this list get blocked but messages from other
lists do not.
Any ideas?
Regards,
Stephen
~|
Hello,
I'm working on a project where records will be added to a single
table, and each record will be assigned to one of six categories
(using a category column). Is there a way I can do a single query to
pull the most recent record from each of the six categories? Or is
my only option to
HI,
I have the following radio buttons:
input type=radio name=Yesnbsp;Yesbr
input type=radio name=Nonbsp;No
Currently I can click on both the yes and no and they both get
selected. I don't want that to happen. The user should only be able
to select one. How can
Can someone assist me with a quick SQL statement.
I have a table with 3 columns: A, B, C (A would be the primary key)
I need to swap the values in column B with the values in column C
and vice versa.
This should work with MS SQL assuming columns b and c are
the same data type:
UPDATE t1
I'm doing a report page, with all the sales grouped by month.
Select SUM(OrderTotal) as Total, MONTH(OrderDate) as M
from orders
GROUP BY Month(OrderDate)
That returns the month and the total as follow:
01(january) 15
02(feb) 40
03(mar) 50
05(may) 20
and so.
Could this have something to do with MX treating this somewhat
differently in terms of case than earlier versions?
This is from a run down I saw recently about issues involved with
upgrading to MX at:
http://www.cfconf.org/cfun-02/talks/cfun02_migrating_from_cf5.ppt
Form.FiledNames
- returns
Unfortunately, tech support has gone downhill quite a bit from its
glory days - I remember getting phone resolution for a WordPerfect
issue where the guy spent hours on the phone with me, debugging some
silly problem that easily cost them more than they ever made off of
me. There's probably a
I have a table with columns named q1,q2,q3, through q19. Each
question can have a value of 1, 2, or 3. How can I generate a
query/cfcode that will tell me how many people answered 1, 2, and 3
for question 1 through question 19 without having a ton of queries?
I know it needs to loop somehow,
I have W2K Pro running IIS 5 with virtual directories
as follows:
mydir mapped to c:\inetpub\wwwroot\mydir
mydir2 mapped to c:\inetpub\wwwroot\mydir2
I can browse the contents of both these directories with
the URLs:
http://127.0.0.1/mydir/
http://127.0.0.1/mydir2/
I've
If you need to run each project within a separate virtual server,
you can always use Apache instead of the limited IIS in Win2K Pro.
Dave Watts, CTO, Fig Leaf Software
Good suggestion. Thanks.
Stephen
~|
Archives:
Which version of Apache for W2K is best to use with CF5?
Thanks,
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
I need to develop with both CF and ASP - is there a way to do
this on W2K with Apache? If I run Apache with CF5, do I then
also need to somehow run IIS for ASP?
Sorry if that sounds stupid :-)
Stephen
Which version of Apache for W2K is best to use with CF5?
Thanks,
Stephen
Has anyone encountered this problem and, if so, did you find a
resolution?
I have W2K Pro running IIS 5 with virtual directories as follows:
mydir mapped to c:\inetpub\wwwroot\mydir
mydir2 mapped to c:\inetpub\wwwroot\mydir2
I can browse the contents of both these directories with the URLs:
of these two values or remove the
slash from the end of the Browser Path value.
Paul Kenney
[EMAIL PROTECTED]
-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 11:17 AM
To: CF-Talk
Subject: Studio 5 development mappings
.
Paul Kenney
[EMAIL PROTECTED]
-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 11:17 AM
To: CF-Talk
Subject: Studio 5 development mappings problem
Has anyone encountered this problem and, if so, did you find
See comment below; hope it helps:
I am not being able to make this (left) or the previous suggestion
of LIKE work. Stripped down SQL code below ...
Table IssueUpdates.Owner (3 records) =
'Doe, Jones'
'James'
'Doe, James'
The data I need is (3 records) - Doe, James, Doe
Neither
I have seen references to being able to use cfdump to see the
contents of the server variables structure but when I try using it
(CF5) I get an error. Is there an easy way to get a listing of all the
server scope variables and their values?
TIA,
Stephen
You can only cfdump the Server scope in CFMX.
Thanks
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ:
Programmers File Editor is a long-time fave. If you can find it you
might like it for Perl.
I also find I'm using EditPad Pro a lot these days. It has a variety
of modules for color coding and formatting in different languages
- Perl, ASP, CFML, SQL, etc.
Stephen
Does anyone know if
This should work with SQL Server
update table1
set price = b.price
from table1 a join table2 b on a.productid = b.productid
and a.modelno = b.modelno
I have two tables in a DB containing information about the same
products. Table 1 is comprehensive and has complete details about
the
This might help:
For those suffering problems with IE6 (and other browsers)
especially using CFTREE, there is a new tech note just published
describing the problem and available workarounds / fixes.
ColdFusion Server 5 : Hot Fix for Applets When Using Java Plug-
in Versions Greater Than
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, 28 June 2002 9:13 AM
To: CF-Talk
Subject: OT: Flowchart program
Recently I have found myself wanting to use some kind of flowchart
program to visualize my application logic, but I haven't been able
to
I'm not sure if this will help but I've been dealing with a similar
issue recently relating to CFGRID which also relies on a java
applet. The problem we were having was not so much browser
version related as it was JDE version related (java runtime
environment). The JDE version that seems to
Dave Watts wrote:
There are a couple of options that might work for you. If this is a
one-time thing, and you can stop the source database server, you can
simply copy the database and log files to the new server, and use
sp_attach_db to attach each to the new server. snip
Another
Thanks for the quick response.
Stephen
If cfapplication specifies a sessiontimeout of 10 minutes,
will any session variables be destroyed after 10 minutes
or only after 10 minutes of inactivity?
After ten minutes of inactivity.
Dave Watts, CTO, Fig Leaf Software
Does anyone attempt to warn a user that their session will
shortly expire? Could javascript with a timer allow popping up a
window, say, when the session will expire in 2 minutes? Are
there any better approaches?
TIA,
Stephen
If cfapplication specifies a sessiontimeout of 10 minutes, will any
session variables be destroyed after 10 minutes or only after 10
minutes of inactivity?
TIA,
Stephen
__
Your ad could be here. Monies from ads go to support
One way to isolate these not distinct rows would be something
like this:
SELECT myColumn, count(myColumn)
FROM myTable
WHERE count(myColumn) 1
This would give you only return rows where where there was more
than one instance.
HTH,
Stephen
I want to output all records in a table where a
are right there under wwwroot without any name changes (ie, mapping
a browser directory name to the 'real' directory name).
Chuck McElwee
etech solutions inc
www.etechsolutions.com
-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 16, 2002 5:25 PM
Check out Intrafoundation's Intranet Hosting Toolkit (IHTK) at
http://www.intrafoundation.com/
This let's you see groups and group memberships for NT
authenticated users. It might be helpful.
Regards,
Stephen
i want only users that are apart of an Admin group that i created to
be a ble to
Yes. It costs over $2,000. But if you need more graphing
capability than comes currently with ColdFusion, it could be
worth it.
Stephen
Does this app cost money. I don't see on the website where you can
buy it, just a free download. It looks nice, and would be cool to
use, but I'll stick
Does anyone have any experience using SQL 2K and CONNX together and
then using CF to output the data?
We are using CONNX to access DataFlex data with SQL7. We
can also set up an ODBC connection to the CONNX-connected
DataFlex data and access this via CF if needed. I don't know how
this
I've been wondering about using stored
procedures in templates instead of
embedding queries. Is there a good reason
for this if the queries are only select
statements?
Stephen
__
Why Share?
Dedicated Win 2000 Server ยท PIII
Jon, thanks for your response.
Stephen
If you are concerned about performance, converting cfquery's to
stored procedures is the best way to optimize an application. Even
for selects.
jon
Stephen Hait wrote:
I've been wondering about using stored
procedures in templates instead
My favorite is the original AVP now available from Kaspersky
Labs:
http://www.kaspersky.com/
Hi All -
I have heard horror stories about certain anti virus
programs not playing will with ColdFusion. I am asking for
recommendations for an anti virus program to use my
computer.
I have
One way to approach this is to use intermediate tables that
contain groups of valid values.
As a simple example, let's take sizes and assume that one
product comes in S,M,L and another product comes in S,M,L,XL.
You could create a size table containing a row for each possible
size:
Crashes on me (5.0) almost as bad as with 4.5. The only
program I run that causes a need to reboot my system at least a
couple of times a day. Win98 so maybe that's the problem but
then why do other resource intensive progs (photoshop6,
sqlserver7, etc.) not have these problems? When it's
system.
I've run Studio 3.1, 4.0, 4.5 and now 5 and the only one I ever had
any trouble with was 4.0 (threw error on closing). I ran 4.5 on Win
98 forever a year and never had a problem with it.
Dave
- Original Message -
From: Stephen Hait [EMAIL PROTECTED]
To: CF-Talk [EMAIL
O'Reilly's site says 4th edition will be published 11/2001.
Amazon lists 12/15/2001.
Stephen
The JavaScript book I recommend most often is the O'Reilly
one, JavaScript:
The Definitive Guide. It really explains JavaScript in a
coherent, organic
way - as a language, not just a bunch
Try adding:
WHERE BrandID IS NOT NULL
This will eliminate any rows where the value is null. It will have
impact on the calculation of AVG, of course.
If you have multiple BrandID columns, just add AND BrandID2 IS
NOT NULL, etc.
Stephen
I am having a problem trying to think of the correct
Gee, all these years - shoulda guessed :-)
Well, my nickname isn't minimalist for no reason at all. :)
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ:
FWIW, we create Excel spreadsheets by sending table data and
it works fine in NS4.7, too. The main difference is that in IE,
Excel opens in the browser whereas in NS the user is prompted
to either save or view it. If they choose to view it, a new instance
of Excel is opened and the
Was there any Promotion Code provided at the conference that
would be applicable for a discount on a ColdFusion 5 Ultradev 4
Studio Upgrade? I seem to remember seeing a reference to this
but don't have that info now.
Stephen
~~
Get the
You might want to subscribe to the relatively new usenet
newsgroup: alt.comp.lang.coldfusion
This is also searchable from Google Groups and may become
more valuable as content accrues.
Stephen
I'm am very frustrated with the Knowledge Base at
Macromedia/Allaire. If it wasn't for posting
According to Macromedia's website they are offering an
UPGRADE to CF Studio 5 for $169 if you currently own 4.X. Only
a downloadable version is currently available.
Stephen
Why is it that Macromedia insists on bundling CFStudio5 and UltraDev
4 together? Why can't I buy just CFStudio5? I can
The following gives the desired output for me when TELEPHONE
is defined as char(10) in the database. Are you sure you're
retrieving TELEPHONE as character data and not numeric? Are
you able to output TELEPHONE without any formatting? Are you
able to add 1 to TELEPHONE? If yes, you have a
This is not exactly within a cf sql statement, but...
If you can be sure that your phone numbers are 10 digit strings
you can format your output like this:
cfset tel=8005551212
cfoutputtel=(#left(tel,3)#) #mid(tel,4,3)#-#right(tel,4)#/cfoutput
The output would look like this:
tel=(800)
I'd try to format it within the sql statement instead.
-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 2:14 PM
To: CF-Talk
Subject: RE: SQL quicky
This is not exactly within a cf sql statement, but...
If you can be sure
I've used eFax since Feb, 1999. It has worked well for me.
Stephen
Hey Gang,
Is anyone here using an internet faxing service? I've looked at eFax
and EasyLink, but I would like to get some recommendations if there
are any.
Thanks,
Duane
I might be able to help. If you provide the perl code (it might be
helpful to include more than the single line in order to better
understand the context) and, if you can, your understanding of
what you are trying to do I would be glad to see if I can help.
Regards,
Stephen
I need to find
One way would be to rely on group memberships for these users
if that's possible. You could then keep a database of what things
members of various groups have access to and base it on their
NT group memberships.
See www.intranetfoundation.com for tags that allow you to
access this NT info
Just wondering if anyone on this list has tried this editor and, if
so, what your experiences have been with it.
http://www.codecharge.com/index2.html
Regards,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
You could check the value of the variable to see if it's really 'Yes'
or not:
cfoutput
FIELD1='#FIELD1#'br
/cfoutput
Note single quotes surrounding variable output. Check to see if
there might be trailing spaces - this might be the problem.
HTH, Stephen
Hello!
I'm working with SQL
Check out Code Templates - Options, Settings. Under Editor,
click on Code Templates to see a list of default templates. On
my systems, the following code is associated with scriptj and
typing scriptj followed by alt+j pops this text into a document at
the cursor.
SCRIPT LANGUAGE=JavaScript
Actually, the SirCam virus sports its own SMTP application to
send mail, target e-mail addresses may come from a variety of
sources including browser cache. You don't have to be an
Outlook user to spread this. To get infected you must run the
attached file.
Stephen
yeah the virus is
Have a look at CRiSP - www.crisp.com
A bit pricey, though (minimum $150 after 21 day free trial)
Stephen
oh yeah brings back memories of brief
- Original Message -
From: Duane Boudreau [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 29, 2001 10:00 AM
Subject:
On Win98, I have a shortcut in the startup folder:
drive:\MSSQL7\Binn\scm.exe -Action 1 -Silent 1
Stephen
In Windows 95, how do you change the account the Service Manager
uses to try and start SQL Server on boot up, bearing in mind there
is no Services option (as is the case with NT)?
What are some of the tools or methods to use when trying to
debug Fusebox apps?
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Particularly, examples employing drill-down capabilities
and dynamic sizing of graphs similar to what Corda offers.
TIA,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Look into CFFILE. It returns the modified date among other
things.
Stephen
Is there any way to access the attributes of a file, such as when
it was last modified?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Same duplicate problem here. Multiple copies of exactly the
same message, headers and all. So far the largest number of
dupes was 5 for one of Mike Dinowitz's posts.
Still much better than not getting messages g.
Stephen
some messages come as they should - some come with 3-5 copies
no mail from list in over a week - is it alive?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
Does CFGraph provide the ability to create drill-down Flash
graphs similar to how PopChart does?
Regards,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
This might be because desc is a reserved word in MS SQL.
Check the docs for the platform you're on and see if this might be
the problem.
Regards,
Stephen
HTH,
Stephen
Hello cf-talk,
This simple update is generating a syntax error i can't seem to
resolve. What am I missing??
I've just been wrestling with an issue involving problems with
IE4.5 on Macs myself. In my case I was using javascript in
combination with forms for minor error checking. It worked fine on
every other platform/browser combo which presumably supported
javascript we tried, including earlier NS
FWIW - I had the same problem (among others) w/4.52. Never
could get any of them resolved. Have gone back to an earlier
version.
Stephen
I recently formatted my computer and reinstalled CF 4.52. I have
now lost the functionality of the mouse wheel while in CF Studio,
which was previously
How reliable would this scenario be, then:
One application with one application.cfm. Three locations for the
application: local development machine, public production server,
private production server. Only some resources are available on
each platform, need a way to determine which platform
As an alternative, what I generally recommend for machine-specific
application settings is that you store them on the machine itself,
and have your application read those values from wherever you've
stored them. You could store them in a text file, or within the
registry, for example. If
CGI.HTTP_HOST
HTH,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
Why does this list constantly have duplicates posted to its
members? Any thoughts?
Regards,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Try outputing the number already formatted:
#NumberFormat(YourNumberVariable,'_99,999,999')#
HTH,
Stephen
I have a page where I allow users to download an excel file of the
query they have done. I use the CFCONTENT
TYPE="application/vnd.ms-excel" and it works nicely except for one
field.
Just a guess but are you using secure pages for these forms? If
so, IE by design sometimes does not cache the form contents
when the user clicks the back button. Supposedly this is for
security purposes.
HTH,
Stephen
In a form I am using some client side validation as well as server
side,
If you're running a version of Windows, you can also use the free
What's Running program at:
http://www.woodstone.nu/whats
Stephen
I lost the link; perhaps someone can remind me:
Where can I enter a domain name and see what platform it uses and
what web server it is running?
This may not be a bad thing. I installed Studio 4.5.2 and besides
the already mentioned blank help files problem, I now can't
access databases or browse locally from Studio without errors.
Hopefully they will get this together before they put the 4.5.2
upgrade back up.
Regards,
Stephen
I had heard that materials presented at the DC conference such
as code examples, slides, etc. would be made available in some
form after the conference concluded. Does anyone know anything
about this or where these materials might be obtained?
TIA,
Stephen
I've got a client using RaisersEdge. I believe you can use
BlackBaud's RE:Open product to access the data via ODBC but
that it cost $5K.There is also a newer product called RE:API
which only works with version 7 of Raisers Edge (not v.6 or
earlier) which is priced based on a percentage of
try 6
I want to select all records from a table that "do not" contain the
number 6. Sheesh! Why is it so difficult to select records this
way...
the query was
Select *
From CaseDetail, CaseInfo
Where CaseDetail.CaseID=CaseInfo.CaseID
And CaseDetail.StatusID ? 6
I've
Anyone know what the latest release version of CF Studio for
Windows is?
TIA, Stephen
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
Thanks.
Is there any good reason to upgrade from Studio 4.0 at this point?
Is 4.5a an alpha version or an earlier version than 4.5.1?
TIA, Stephen
4.5.1, for production releases. The 4.5.1 SP1 upgrades only apply to
CF Server.
Steve
-Original Message-
From: Stephen Hait
Try this - works w/CF3.1 (the mimeattach is what attaches the
file):
cfmail query="GetSelectedEmail" to="#emailaddr#"
from="[EMAIL PROTECTED]"
subject="#getEmrg.emrg_title#
date: #DateFormat(Now(),'ddd, dd mmm ')#
#TimeFormat(Now())#"
Why are posts from several days ago apparently being resent?
Stephen
Stephen Hait [EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar
lk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
Stephen Hait [EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm
101 - 185 of 185 matches
Mail list logo