Hi folks,
I am running CF5 on Win2k and I am trying to debug something in AbleCommerce
(hold your groans).
I have set all debug info to be dumped to the screen in cf administrator.I
would like to see the order that templates are getting processed.However, the
template execution list is in
That's what I was afraid of.Thanks for the info.
We're running version 3.04.Every time I have to troubleshoot anything in this
version I want to quit web development!
--Jeff
_
Jeff LangevinAppalachian Mountain Club
MIS Department5 Joy
You really should only select the individual columns you need. Selecting the
customer ID twice is inefficient since it has the same data. But if you must
have it, try something like:
SELECT orders.customerID as OrdCustomerID,
customers.customerID as CustCustomerID
etc, etc.
And my guess is
Are you on IIS? Perhaps the lockdown tool has been used. Check the settings in
(usually at this path) c:/winnt/system32/inetsrv/urlscan/urlscan.ini if you can.
I had a problem with SES URLs due to the server not allowing multiple . in
the URL and the setting in this file was the culprit.
--Jeff
You could do it on the SQL side with a custom field. At least you would be
offloading the heavy lifting to SQL. Not sure if it makes sense to tackle it
this way, but just I tested this and it works...
cfquery name=testQuery datasource=testdb
SELECT dbo.test.organization,
dbo.test.address,
Hi Jim,
Today's email was actually the third email notification we sent out (in
addition to one from Macromedia, though I do not know the extent of that
mailing). At which email address did you receive today's notice? I do not see
any depressedpress.com email addresses included in the email
Use the aggregate functions GROUP BY and WITH ROLLUP. I just tested this and it
should work just fine for what you're trying to do. Good luck.
SELECT numberColumn,
COUNT(numberColumn) AS total
FROMnumberTable
GROUP BYnumberColumn
WITH ROLLUP
ORDER BYnumberColumn
Actually, didn't need the WITH ROLLUP. It works just fine like this as well. WITH
ROLLUP gives you a grand total as well which you probably don't need.
SELECT number,
COUNT(number) AS total
FROMnumberTable
GROUP BYnumber
ORDER BYnumber
I think changing INNER JOIN csite c to
FULL OUTER JOIN csite c will work.
And I think you might have to add OR c.id IS NULL
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
Try this...
SELECT *
FROMtblEvents
WHERE tblEvents.estarttime '#dateFormat(dateAdd(d,-7,now()),MM/DD/)#'
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
We use ArcIMS for displaying data from our research department.
http://appalachia.outdoors.org/mapping/
So far it works great for us. We also are having discussions about some much
larger projects which would utilize the system. Ironically, we found that the
most tricky part of it all is the
CF5 does not allow for a blank application.cfm. It will throw an error. I in
fact just ran into that last week. :) You can use something simple like cfset
fu = bar and you will be all set.
~|
Archives:
I am trying to implement site-wide error handling on a fusebox 3 site and am
having a problem. The site is working just fine. However, I am simulating
the database being down by turning off execute rights to a stored procedure on
MSSQL. This throws an error a nice error against which I can
Thanks for the info Stephen. That did help clarify things a bit. Due to the
complexity of what I needed to do, I ended up getting it working with MSSQL full
text search and cfquery. At some point (when I have a bit of free time? HA!)
I'll play with QofQ and cfsearch and see what it can do.
Hey Folks,
First, the on-topic question. When using cfstoredproc is there an easy
way to return a recordcount like that which is returned by cfquery?
Now for the SOT question... Sorry for this question, but I have searched
high and low for this info and am now at my wits end so I am posting
When using cfsearch (and CF5) can you do a custom sort order. I am interested
in using verity for full text searching, but I am not interested in the
weighting it gives to results. I would like to dynamically tell it the order of
columns. For instance one time tell it sort on date, then title,
Hmmm... didn't realize that you could do that in admin. Obviously haven't been
spending enough time in there lately... I agree that it makes sense. I was
disabling rights in SQL Server, not in CF admin. However, that confuses me. Then what
is the point of doing so? I assumed that this was
I am trying to write files using CFFILE and I would like to have carriage
returns in the file to make it look something like below:
Workshop Registration Information
startDate: blah
endDate: blah
workshopID: blah
title: blah
...
Right now, I am creating a variable called orderInfo and writing
Thanks folks. chr(10) chr(13) works beautifully!
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ:
cfquery name=qGetSysObjects datasource=#REQUEST.DSN#
SELECT Name
FROMSysObjects
WHERE Type = 'U'
/cfquery
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
When the below line is run from a command prompt, it works flawlessly.
c:\pgpnt\pgp.exe -e -a c:\pgpnt\scratch\myfile.txt [EMAIL PROTECTED] -o
c:\pgpnt\history\myfile.asc
When I run the following, it does create a text file.
cfexecute name=c:\pgpnt\pgp.exe
arguments=-e -a
Also, I've heard that there are security issues with cfexecute. SHould I avoid
that solution and try wirting something as a custom tag in java? While I am not
really strong in Java, I can probably figure it out.
--Jeff
~|
I was wondering what folks do for encrypting files using pgp and ColdFusion. We're
running CF5 on Win2K and I need to be able to encrypt files (using PGP
v6.5.8) which will then be emailed. I don't have the $400 for CFX_PGP off of
the exchange. I came across a reference during a google search
Do you have any access to the server receiving the file?If so you could
write a java client/server app. I am in a somewhat similar position with
integrating a reservation system with our web site.
The reservation system came with a java client/server socket app. The client
passes the data
Hmmm... I didn't read that quite closely enough the first time
Sounds like if the Win32 app is listening on the port, it should be doing the
writing of the file to the file system for you. If that is the case, just open
a socket (using java custom tag perhaps) and send the data in the
I am trying to edit the color coding in Studio 4.5 and am having a problem.
Specifically, I want the background to be black instead of white. That is no
problem. However, I use studio for editing both .cfm and .java files. The
problem is that in the elements for .java files the curly braces,
Here is a link to the install doc for ArcIMS. Not everything you're looking
for, but might help get a feel for the app.
http://arconline.esri.com/arconline/documentation/ims_/Installing_ArcIMS_Windows
pdf
You can buy a copy of the user manual on their site. It's about $30.
We are looking to implement a content management system and am interested what
you folks out there are using. Below are some of the features we would like. We
currently have a Win2k server with CF5 and MSSQL2000. Preferably we would
like to utilize this system. One product which we are
Hi folks,
I am working on setting up a new server which is running Win2K Server, CF
Server 5 Pro, and SQL Server 2K. I have ordered the O'Reilly book on securing
Win 2K for the internet. I have found a few docs on securing SQL as well, but
any suggestions would be helpful. What I really am
Additionally, you'll need to alter the queries in the _emailWsp and _emailWOsp
files in order for your notifications to correctly reflect the totals.
Note: Since we are not currently using the real-time CC processing, this
solution works for us. However, I have yet to look into that process. I
The other day I found an obscure bug in the way AbleCommerce sums pricing for
totals and subtotals. In my case, it exhibited itself when I discounted an ite
m
using a 10% discount. This caused products to have three decimal places in the
discounted price ($14.95 discounted 10% is $13.455). The
31 matches
Mail list logo
