Tom Forbes wrote:
I need to modify the below query so that my results are still ordered by
ClassOfService (a number between 1 and 4) - BUT, the CompanyName needs
to be displayed in a RANDOM ORDER each time the query is run, rather than
its current alphabetical order. This will give all
Paul Campano wrote:
I am looking to build a community website for my apartment building of almost 200
units. I would like to have a members area with forums, the ability to add news
stories and other community functions. Could someone recommend a free or low cost
solution? I am doing
Costas Piliotis wrote:
The only way for one to do this is if they know how to pass their own http
headers. And then they need to know that you're looking at that particular
cgi variable, and they need to know what you're comparing to as well. Too
much trouble for a little piece of
Matt Robertson wrote:
If his use doesn't qualify for their free personal edition, then that
will cost at least US$995.
The way I read the license and his requirements he qualifies.
My CMPro cms is US$350. One of my customers
is a private dormitory at UC Berkeley
Berkeley? As in BSD? And
Jamie Jackson wrote:
I've got two replicated databases that I'm doing app-side failover for
in my CFMX app. The gist of my problem is: I've got some catch blocks
which send failure notices to the DB admins. However, when I'm testing
(stopping the DBs), for a single page request in which there
Don't make the explicit distiction between a multiform and a singleform,
the singleform *is* the multiform with i=1. Some more comments are inline.
Form page:
cfparam name=MultiForm default=FALSE
cfparam name=i default=1
!--- use CSS :) --
cfhtmlhead text='
style type=text/css media=screen
Jochem van Dieten wrote:
I missed part of the rewrite:
Action page:
!--- Mixing display code with action code is probably bad, but else I
have to type it twice :) ---
cfoutput
h2
a href=#form.??# target=_blank
Candace Cottrell wrote:
__ On the action page, you have
CFIF Len(Trim(form[Website_authorLNAME#i#]))
What are you checking for? That there is a length?
I am checking that the form field is not empty or just has spaces. It is
pretty much equivalent to the code below, I just prefer the
Dave Jones wrote:
All of our inserts and updates to this database are wrapped in
cftransaction/cftransaction tags (due to multiple tables
involved in the transactions). We are not explicitly issuing any
commits or rollbacks.
My questions are:
1) Given our use of cftransaction, is it
Critz wrote:
using cfmx, I am trying to parse this feed:
http://www.bmezine.com/newsfeed/bmenews.rss
but i keep getting errors. Anyone mind having a quick gander?
Download Mozilla (http://www.mozilla.org/), install the Checky toolbar
(http://checky.mozdev.org/) and you have a few
Scott Mulholland wrote:
I am using the infozip command line utilities (zip.exe, unzip.exe) to do
some zipping and unzipping of files. The zip.exe does not seem to run
when trying to zip files in certain directories and throws the following
error:
java.io.IOException: CreateProcess:
Sean A Corfield wrote:
Shannon's put an RSS feed on his site? That's awesome - I must
subscribe to it! (Once he's fixed those darn links!!! :)
It's interesting to see how RSS is cropping up on non-IT / non-news
sites. Anyone got other interesting examples?
University library here has
Fetter, Brad wrote:
I have video, and image library on our intranet and we want to have a
hyperlink that will allow the
user to download the file to their hard drive without having right click and
select file save as. Is there an easy way to do this?
Use cfcontent with the mime type
James Blaha wrote:
Is below the best and only way to easily find out how many days are
between 2 dates? Im writing a template for a file backup where files
that are older then 5 day will be deleted and Im not sure what the
easiest best practice approach would be for the days check.
James Blaha wrote:
Thanks a million! Does the date format have to be in the -mm-dd format?
It doesn't have to be. But you wrote 6/3/03, and I wouldn't know what
date that is. I presume the 03 means 2003, but how about the rest? Is
that March 6 or June 3? Do you know? Does the next
Eric Creese wrote:
This is a very simple question.
I need to do this in SQL Server from a job not a CF page.
I have a table where I store customer IDs. I want to pull the individual IDs and
loop each ID out of the table and run it against another query and write that output
of the
Bushy wrote:
If I run this command on the server at a command prompt it works just fine.
C:\net print \\SERVERNAME\TESTPRN
Name Job # SizeStatus
---
testprn Queue
Fetter, Brad wrote:
Hmmm, I tryed to force a download of a jpg file with the following code and
browser tried to open the cfm page in Coldfusion Studio... Is there another
way to force a download? Maybe through a Metatage or Javascript?
You need to add a header for the filename:
cfheader
Jochem van Dieten wrote:
cfset ShowQueueExe =c:\winnt\system32\net.exe
cfsavecontent variable=queue
cfexecute name=#ShowQueueExe#
arguments=testprn
outputFile =prn.log
timeOut=60
/cfexecute
/cfsavecontent
cfoutput#queue#/cfoutput
Sorry, that should
Bushy wrote:
Where do I put the print and \\SERVERNAME\PRINTERNAME\ for
c:\winnt\system32\net.exe print \\SERVERNAME\PRINTERNAME
If servername is not the local server, you need to make sure CF runs
under a domain account, not the localsystem account. Then use:
cfsavecontent
Dave Jones wrote:
Thanks for the reply. Can I assume that if the isolation level is
not explicitly stated in the cftransaction tag, the isolation
level defaults to the default setting of the SQL Server (i.e. CF
does not automatically impose a default isolation level)?
I always assume so
Dana Tierney wrote:
Is there a relatively low tech way of converting flat files delimited with
| into a mysql database? I am on a different host now and have cold fusion
asp perl and maybe php available.
http://www.mysql.com/doc/en/LOAD_DATA.html
Jochem
David Collie (itndac) wrote:
As usual checking out what the guru's are talking about... downloaded
Mozilla Firebird guess what. doesn't work on our internal
network...(altho works on all our pages before the proxy/firewall)
What is the error message?
Not very good does it
Calvin Ward wrote:
What are the advantages and/or disadvantages of using mixed methods when
submitting a form?
In otherwords, would doing the following be considered good, bad, or
indifferent, and if not indifferent, why?
form action=dothis.cfm?thisID=1thisType=myType method=post
Ezine wrote:
Macromedia is doing beta testing now of the next updater.. Code named Red
Sky. I'm looking forward to see if it will fix my issue.
Why not join the beta? Then you can make sure it is fixed.
Jochem
~|
Dave Lyons wrote:
I understand its not your fault either but just seeing how the server only
had an ancient video card would lead me to believe that the host is
seriously cutting corners and if I was you I'd be very concerned about that.
Not installing any video drivers except for the
Doug White wrote:
If a software author can add that error trap into his installer package for
software selling for less that $100.00 US, then why cannot MM do exactly the
same with the InstallShield package for CFMX which sells for many thousands of
US dollars??
CF MX U3 uses
Mike Kear wrote:
Never put Beta software on production machines
Never put beta software on critical machines
Never put beta software on machines doing live projects.
Well that covers all the machines in my business.Where do the rest of
you put beta software? Surely you don't all
Jerry Johnson wrote:
[EMAIL PROTECTED] 06/06/03 05:16PM
they didn't tell anyone you had to have more than 16 colours on the graphic card to
install
UD3 and now it is broken.
If you were writing software, would it even occur to you to test on a 16 color
graphics card?
Yes.
Where
Dave Lyons wrote:
hard to disagree with what you say jochem cause ur always right.
Thank you for the compliment. But you know, in investment this would be
the time to start doing the opposite from what I am saying, because you
should never go with the herd :-)
But it brings up two points
Doug White wrote:
I am not proud. I will give someone remote access to my box with full admin
privileges and let them try to install the updater.
If you run 16 colors, it is not going to work. If you run 256 colors,
you can set up pcAnywhere to allow connections from 145.94.154.26
You migt
Ken Wilson wrote:
So all this time the OS that Mike's folks were having trouble installing to
was Windows 2003?
Mike was not the only one having install problems, Doug has had his
share too.
Jochem
~|
Archives:
Blood Python wrote:
I'm using CFMX updater 3, iis5, 512mb ram and mysql 4.0.13.
Should i limit the connections to the datasource in CFMX?
Yes, but it does not work in currently released versions of CF MX. I
don't know if it is fixed in the RedSky beta, but you should be able to
test that
Tony Weeg wrote:
if any of the payments need to be ammended, removed for bad check
reasons, chargeback on a card, operator error, then i need to be able to
go back in the payment history, and make a change that follows the
payment application rules. what i am trying to stay away from are
jon hall wrote:
Is there a way to shut off the new restrictions, or perhaps work
around it?
It will work if you are logged in to the CF Administrator.
Jochem
~|
Archives:
Troy Montour wrote:
was wondering if anyone has written or knows of a good Control panel for IIS web
server
as I want to allow users to change some of there own settings when hosting there
site
with me but I haven't been able to find one that is already written.
Which settings would
Josh Trefethen wrote:
Yep, I can access it with Updater 2.
Any chance you can send me (offlist) a dump of the SecurityService from
your CF MX install? I am seeing several entries on a machine with
Updater 3 it that I don't remember from when I worked with it before,
and which appear to
jon hall wrote:
Ahah! Now to figure out the mechanism
Create a subdirectory under /cfide/administrator and don't put in an
Application.cfm. Not recommended for production use :-)
Jochem
~|
Archives:
FYI and have fun.
Jochem
===
Title: Unchecked Buffer In Windows Component Could Cause
Server Compromise (815021)
Released: 17 Mar 2003
Revised:28 May 2003 (version 3.0)
Software: Microsoft
[EMAIL PROTECTED] wrote:
Does variable and CFQueryParam checking also apply to Access databases? Is it
needed when using MS Access 2000 as a backend?
Yes.
I am not sure whether you get the performance improvements with Access,
but cfqueryparam is still a protection against SQL Injection
Venable, John wrote:
as i was saying...
I have a template that allows one of our folks to upload a word .doc to a
given directory. I have been experiencing a strange error lately.
i get this error when it's run by this person:
The MIME type of the uploaded file (application/octet-stream)
Brad Peloquin wrote:
Hi, so I select data sources from the Data Services in order to define
a MS SQL server database that is running on my PC, and I get the following
error:
=
Element SQLEXECUTIVE is undefined in REQUEST.
Terry Hogan wrote:
CategoryID ParentIDLevel CategoryName
-- -
1 0 1 Animals
2 1 2 Dogs
3 2 3 GermanShepard
4 1
W Luke wrote:
I have a custom-made mailing list which sends out alerts to subscribers.
I need to allow subscribers to choose which days, and times, they wish
to receive their emails. i.e. Monday-Friday between 9am and 6pm.
I was thinking about having Sun-Sat columns in the member's table,
Ryan Mitchell wrote:
cfquery ...
INSERT INTO SavedItems (Item, Quantity, AccountID, Option)
VALUES (
cfqueryparam cfsqltype=cf_sql_varchar
value=#Session.Cart[i].Item#,
cfqueryparam cfsqltype=cf_sql_varchar
value=#Session.Cart[i].Quantity#,
cfqueryparam
[EMAIL PROTECTED] wrote:
I'm not sure how efficient MySQL is with booleans (especially since it
doesn't have real booleans but uses integers), so before going of to
create 168 (7 * 24) separate boolean fields in the table, it might be
worth investigating if you can't store the information in a
Terry Hogan wrote:
cfquery name=test4 datasource=#request.dsn# dbtype=ODBC
SELECT
a.categoryID,
a.CategoryID catID3, a.categoryname cat3, a.level level3,
b.categoryID catID2, b.categoryname cat2, b.level level2,
c.CategoryID catID1, c.categoryname cat1, c.level
Terry Hogan wrote:
Here's the output:
animals/
animals/Cats/
animals/Cats/Tabby/
animals/Dogs/
animals/Dogs/Beagle/
animals/Dogs/German Shepard/
Beagle/
Beagle//
Beagle///
Cats/
Cats/Tabby/
Cats/Tabby//
Dogs/
Dogs/Beagle/
Dogs/Beagle//
Dogs/German Shepard/
Dogs/German Shepard//
Terry Hogan wrote:
Getting closer...
Was perfect with the original data, but I added a new subcategory (Horses)
and a new main category (Colors).
I presumed they were all fully filled (3 levels deep). But if they are
not, you need to test for empty values in the output then:
cfoutput
Ian Skinner wrote:
Any suggestions if you where doing something like this, but did not know the
number of levels before hand?
The presented model (adjacency list model) can be easily extended as
deep as you want by adding more left joins, but performance will suffer
if you add too many. And
Brook Davies wrote:
I am trying to generate some HTML via CF and I want the HTML to come out
clean. But I end up with lots of whitespace and for the life of me, I can
not get proper indentation due to all the CFIFS and related CF code. I have
tried using CFSETTING ENABLECFOUTPUTONLY=NO,
Charlie Griefer wrote:
I just installed MX Professional on my computer. It's running (co-existing)
with CF 5 and IIS.
So MX is on it's own web server, on port 8500.
Yet, I can only access .cfm pages thru localhost (127.0.0.1). This is *not*
a developer's edition. My serial # is in
W Luke wrote:
Now that I'm on MySQL, I don't understand how createtime() works. The
field (TheDate) is DATETIME, and I would need to grab all records
created in the past 24 hours.
WHERE TheDate cfqueryparam cfsqltype=cf_sql_timestamp
value=#DateAdd(d,-1,Now())#
I also need similar
Peter Mayer wrote:
Has there already been set a deadline when the new version of ColdFusion
will be relased? Will there be any important changes (except the very
important bug fixes for several bugs and configuration issues)?
What JVM will be the default one?
I think that everybody who
Matthew Walker wrote:
When using cfqueryparam, you leave off the single quotes. The tag will
format the value in the appropriate way based on the cfsqltype attribute
set.
Actually I don't think it decides whether or not to insert the quotes -- it
uses another mechanism for passing the value
Brad Peloquin wrote:
I'm hoping other people have run into this...I'm running CFMX and that local
version of MS SQL Server 2000. I have a database that I successfully
converted from Access to MS SQL 2000 and the query analyzer works just dandy
on it. However, when I When I go and try to
Matthew Walker wrote:
http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid
=16005forumid=4
Great explanation thanks Jochem. Interested to hear about the dbms
hashing the query and checking if the hash exists as a key to execution
plans.
That was an example, different
David K wrote:
While we're at it here, what's the response header that gets returned with
cfheader name=refresh value=0; URL=foo.cfm ?
Refresh: 0; URL=foo.cfm
Jochem
~|
Archives:
Angel Stewart wrote:
Can we get a list of some of the customer defined issues that are being
dealt with?
(The presentation mentioned over 400)
If you join the beta, you can see the list grow :-)
Jochem
~|
Archives:
Doug White wrote:
One submitted by me is the installation and configuration for different
platforms issues. It is a PITA to have to jump through hoops after running the
install, doing things like starting/stopping services, editing config files,
manually running multiple batch files, and
Damon Cooper wrote:
FYI: (if anyone's keeping track), it looks a lot like the issue Mike's ISP guy was
having was due to running the Updater installer under 16 colors (256 or higher
required, or you can use the silent installer with pre-loaded options).
quote
What's happening is the updater
[EMAIL PROTECTED] wrote:
My apologies for the OT post, I am hoping maybe someone has some
experience or knowledge in the following:
I am trying to find out how much data can be stored on the magnetic stripe
on a credit card.
IIRC 3 tracks, 79, 40 and 107 characters, but characters are only 4
Mike Kear wrote:
Does anyone think it would be a good idea for me to try installing this
version?
After you have made a disk image, yes.
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Mike Kear wrote:
Hands up anyone who would have thought not having enough
colours on the server's display settings would have killed an installation??
Who's going to be brave enough to say they would have picked that?
/me waves hands
Issue #51673, bagged and tagged on May 20 (which is
Tony Weeg wrote:
where do I sign up for the red sky beta prog?
See the presentation:
http://www.macromedia.com/software/coldfusion/presentation/redsky/
Jochem
~|
Archives:
B G wrote:
I monitor Task Manager and CFSTAT at the same time. When CPU usage stays in
the 75%-100% range, requests running NEVER goes below 1. Frequently it
rises until the 25 limit where they go to queue.
At this point I turn off IIS and the CPU stays the same, roughly 50%-75% and
Dennis Powers wrote:
I can use some help. I need a RegEx to determine if there are three or more
invalid HTML tags on a page. Is this just too complex for a RegEx?
It might be a better idea to automate the process of uploading a file to
http://validator.w3.org/ and extracting the number of
Kris Pilles wrote:
Anyone on the list have experience with granting of proprietary rights
to a client?
How to determine its worth
Whatever they are willing to pay for it. You might give them a discount
if you are sure that you can (and are allowed to) sell the code to other
people as well,
Dana Tierney wrote:
well yeah, except that it appears that there is a problem with a specific
KIND of installation, on shared servers.
There is no technical difference between a shared server and a dedicated
server. Only after you have installed CF you create the difference by
configuring it
Mike Townend wrote:
Sorry for the x-post
x-posted to what?
I was wondering if anyone has an idea as to how I can do this. Currently I
have a task system whereby you can allocate jobs to users, we have a table
that can record that you are 0ut of the 0ffice for a specified time, I need
to
Mike Townend wrote:
We're using SQLServer 2K
If it support OVERLAPS (check the manual) it would be something like:
WHERE UserID = 6
AND (0ut0f0fficeFrom,0ut0f0fficeTo) OVERLAPS ('2003-06-06','2003-06-10')
Else, how about:
SELECT *
FROM 0ut0f0ffice
WHERE UserID = 6
AND 0ut0f0fficeFrom
Mike Townend wrote:
SELECT *
FROM OutOfOffice
WHERE UserID = @UserID
AND (
(OutOfOfficeTo BETWEEN @Now AND @DeadLine)
OR
(OutOfOfficeFrom BETWEEN @Now AND @DeadLine)
)
Which gets me all OOO periods
Mike Townend wrote:
Like the sound of the logic, however the code doesn't run on SQL2K as the
Max (and therefore Min) functions only take the one parameter and so is not
running :(
Use CASE.
Jochem
~|
Archives:
Michael Tangorre wrote:
Sorry for the last post that was incomplete.. it was sent before I finished typing.
At anyrate, here is what I nticed when viewing the header information from the email
I retrieve:
Content-Type: multipart/mixed; boundary=PART.BOUNDARY.1055181506
However, if I
Che Vilnonis wrote:
I have a column in a db that stores data with a pipe [|] delimiter.
I would like to write a SQL query that filters data based on a segment
of data within a pipe delimited variable.
Basically, is there SQL code that is equivalent to the psuedo CF code
below? A SQL version
Che Vilnonis wrote:
hmmm...this could be the EASIEST way to do this.
thanks Jochem, I'll check it out!
Actually, it gets easier:
WHERE FinalShipTo LIKE '%|%|%|%|Amsterdam|%|%|%'
I would expect MS SQL Server (just saw your message) to support regular
expressions, in which case you could
Che Vilnonis wrote:
Is it against the NDA to tell me what Red Sky is???
I've been away for a while...and I am clueless.
http://www.macromedia.com/software/coldfusion/presentation/redsky/
This is the official information. Everything else should be regarded as
gossip and would best be
Brook Davies wrote:
I just saw this now for some reason, but thats a great idea. Thanks! BTW,
does Tidy correct mistakes in the HTML also?
No idea. But I would be interested in seeing what you come up with :-)
Jochem
~|
David Collie (itndac) wrote:
You could try to take the value of the buffer in OnRequestEnd, pass it
to a cleanup script (such as the Java version of the HTML Tidy engine)
and return the result from that instead of the original value. YMMV
Could this sort of method be used to auto add
Matt Robertson wrote:
Whats the Big5 charset and
is it relevant/better than GB2312? Utf-8? Or are they all
interchangeable?
They are not interchangeable and UTF-8 is the most versatile one.
I would want to run this on mySQL and CFMX if possible.
Apart from the other issues, unicode
Dave Lyons wrote:
Microsoft announce FrontPage 2003 We've really focused on generating
clean, industry-standard HTML code. they claim.
That would be quite a change. IIRC, during the anti-trust trials Bill
Gates himself has delivered sworn testimony that Frontpage is designed
to only work with
Eric Creese wrote:
I have a query I am trying to run to get a particular record out of the database.
The problem is that one of the fields is
a varchar 255 field that houses a date.
Only a date, or other information as well?
I want to convert the date so I can find out if it is greater
Shawn Regan wrote:
Instead of: value=attachment;#variables.filename#
shouldn't it be value=attachment;#variables.fullpath #
Neither, it should be:
value=attachment; filename=#file#
See RFC 2616, section 19.5.1
Since user agents are explicitly forbidden to use the supplied path, it
doesn't
[sorry if you get this twice, but it doesn't show up here]
Michael Tangorre wrote:
The numbers are of the following size:
range start
00
range end
99
That was one generic example. Basically the number represents a phone number
Michael Tangorre wrote:
The numbers are of the following size:
range start
00
range end
99
That was one generic example. Basically the number represents a phone number range
and I have a range for each country in the world
sebastian palmigiani wrote:
Access to a browser cached page from a password protected site can be
accessed by anyone using the same machine using the back button on the
browser and see those pages even if they're not logged into the site.
Is there some code that will expire the browser
Michael Tangorre wrote:
Basically I just wanted to re-open my issue and it is bigger than I first imagined...
anyways, has anyone tried to calculate using any language, what country a phone
number relates to? Basically I thought I had it until I realized that some country
codes overlap if
Gabriel Robichaud wrote:
I'm new to this list, what is RFC 2616 ?
It is the standard for HTTP 1.1:
http://www.google.com/search?q=rfc%202616
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Michael Tangorre wrote:
Does anyone have a default list of windows services (on windows 2k server) installed
and what they do.. we are trying to turn off and disable any services we do not need
on our test servers
Check out the NSA documentation for securing Win2K:
Owens, Howard wrote:
Connection verification failed for data source: encore
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException:
Earl, George wrote:
I'm having a problem with the ColdFusion product page at MM's website.
If I have the Flash Player installed I cannot see the list of links that
goes down the right side of this page:
http://www.macromedia.com/software/coldfusion/
Dana Tierney wrote:
Anyone with normal access can crash an Access database That's about all
I need to hear in Mysql vs Access
Why? Do you give other people normal access to databases? Or do you
predefine queries where they only get to fill out the parameters?
Besides, crashing goes
Dana Tierney wrote:
I am going by Doug's resource, that is what it says about the MS abd IBM
products. And that would be something I would have to account for, ya,
utterly illiterate clients.
Unfortunately, Doug's resource seems to have been made using the
crash-me utility, which is far
Dana Tierney wrote:
So you are saying his resource is wrong about that?
I am convinced they can all be crashed by people with sufficient
priviledges and destructive tendencies.
They all can be crashed?
Sure. Just do the math on the following query for a 100 row table:
SELECT * FROM table
Venable, John wrote:
Maybe someone can tell me what I'm doing wrong. I have a field in SQL Server
2K that is money datatype. I am building a submission form to populate that
field and I keep getting errors about type. This is what my field insert
looks like:
cfif
Dana Tierney wrote:
Well, I have a couple of different situations going on. In the one case I
will probably keep sole access, alhough gee, I can envision cases where it
would be nice to have a volunteer doing data entry, so I would like to
idiotproof it and make this possible.
But then you
Doug White wrote:
Please detail the inaccuracies. The Crashme authors want to know.
It reports MySQL has a SQL 92 VARCHAR type. Since VARCHAR fields are not
allowed to loose trailing spaces, this is not accurate.
It reports PostgreSQL does not have circular foreign keys or an ANSI SQL
Mike Kear wrote:
I'm about to install some software, and the install notes tell me I have to
have MDAC2.6 SP2 installed, and Visual C++ 6.0 runtimes.
The notes also refer to MS Knowledgebase articles about them but I can't
make head or tail of them. I don't know if I have these components
Rafael Alan Bleiweiss wrote:
OK - so after all that I've read, I still sit here with a fifty fifty
issue, EXCEPT - Did I read correctly? BD's CFQUERY does NOT natively allow
escaping single-quotes?
Yes.
This is about as bad as it can get for developers. CF MX breaks with
cfqueryparam,
Damon Cooper wrote:
What's the issue you're seeing with CFQUERYPARAM in CFMX?
All 4 queries below should return the same value, but the last one
returns a string with 2 quotes.
cfset string = test ' test
cfquery datasource=test name=qTest
SELECT '#string#' AS test
/cfquery
cfdump
901 - 1000 of 4636 matches
Mail list logo
