I am not sure the best way to phrase this question but I'll try here.
I have a table that records checks I am breaking the check down in the
database to show where each dollar goes so I have 3 lines with the same
check number
Example:
Check_Num, Issued_To, Amount, Expense_Type
1234,
Select Check_Num, Issued_To, sum(Amount) as Total
From TableName
Group by Check_Num, Issued_To
Order by Check_Num, Issued_To
Regards
Dale Fraser
http://learncf.com
-Original Message-
From: Travis Haley [mailto:[EMAIL PROTECTED]
Sent: Monday, 1 October 2007 4:43 PM
To: CF-Talk
Subject:
Yes that works if there is only these three entries in the database however
there are more than three here is a full sample of data
Check_Num, Issued_To, Amount
1234, Travis, 100.00
1234, Travis, 1.00
1234, Travis, 6.00
1235, Kim, 300.00
1235, Kim, 6.00
1236, Adam, 100.00
1237, Travis, 200.00
On Thursday 27 Sep 2007, [EMAIL PROTECTED] wrote:
I think Adobe did a POOR job integrating FCKEditor. Besides basic mapping
of the CFINPUT tag, all they did is hide (and poorly) features which they
didn't want to support for it (specifically file and image management).
Yeah, because only you
it should make no difference how many records you have in your table.
Dale's code will return the results you want.
Azadi
Travis Haley wrote:
Yes that works if there is only these three entries in the database however
there are more than three here is a full sample of data
Check_Num,
On Sunday 30 Sep 2007, [EMAIL PROTECTED] wrote:
We have some customers.. who prefer to browse OFFLINE rather than connect
to the internet. Now... how can I save (or convert) all those dynamic pages
into html pages and save them into a CD. ?
wget -m
--
Tom Chiverton
Helping to enormously
Thanks for all the posting.
I will try this wget -m
I had tried httrack.. but it did not work perfectly. (don't know why...)
But.. all these program... can download ONLY FROM PUBLIC INTERNET ? ...
I am in Japan...and my website is in US... to download (10.000 pictures) takes
quite a bit time...
Thanks for all your help i now understand how to tackle this
thanks
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
But.. all these program... can download ONLY FROM PUBLIC
INTERNET ? ...
I am in Japan...and my website is in US... to download
(10.000 pictures) takes quite a bit time... and we have to
update regularly.
but like Dave watts said.. there is NO better way than this.
I just wondered if
I get occasional SQL deadlocks on an application.
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 65) was
deadlocked on lock | communication buffer resources with another process and
has been chosen as the deadlock victim. Rerun the transaction.
I noticed that some of my
I don't believe so.
You should check your lock type(s) you are using. By default sql server
uses row locking but you may be in a situation where page or table locking
is taking place.
Check out this
http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx for some
good advice.
--
Hi,
Having just moved one of our sites from CF7 to CF8 I've noticed that the
connection pooling (Maintain Connections) setting is not working (I've unticked
and ticked again to check!). The sites left on the CF7 installation are still
working with the same driver as I would expect.
This is
What is the best way to handle taking in an excel sheet from a person. Then
importing it into a database?
I have a client that their data starts on excel and I don't want them to
re-type it into our web app. It would be nice to import the data from excel
directly into the database.
Is this
If you have a copy of the website running locally you could point one
of these programs to your localhost and it will run just the same as
if it was looking on a public server.
J.J.
On 10/1/07, Dave Watts [EMAIL PROTECTED] wrote:
But.. all these program... can download ONLY FROM PUBLIC
If you have a copy of the website running locally you could point one
of these programs to your localhost and it will run just the same as
if it was looking on a public server.
Oh... Thanks...
how stupid I am... never thought about that.
will try..
Thanks for all your suggestion.
Chad,
Excel is a binary type format so reading it with CFFILE isn't going to
get your very far. You have 2 choice. The first one being have the
client convert it to a CSV and then use something such as the
Ostermiller library to parse the CSV into an array which you can then
convert into a query.
You could try this: http://www.bennadel.com/projects/poi-utility.htm
-- Andrew
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 10:48 AM
To: CF-Talk
Subject: import excel
What is the best way to handle taking in an excel sheet from a person.
On Monday 01 Oct 2007, [EMAIL PROTECTED] wrote:
Having just moved one of our sites from CF7 to CF8 I've noticed that the
connection pooling (Maintain Connections) setting is not working (I've
unticked and ticked again to check!).
How do you know it's not working ? Poor performance could be a
You could use the Excel ODBC driver, or import directly into Access and then
work some magic.
I'm assuming you're working in Windows since we're talking aobut Excel.
- Matt
You could try this: http://www.bennadel.com/projects/poi-utility.htm
-- Andrew
What is the best way to handle
Hey guys,
Well, I'm presented with a problem here. My client needs me to create a form,
where the user will input the information, and then that information goes to a
database. All fair and simple, but then he wants to be able to hit a button,
and this data will magically go into a word
Okay, so I upgraded my server from CF7 to Cf8 this weekend. In an
effort to avoid problems, I manually shut down the web server and all
instances of coldfusion.
I ran the install, and it hung on Configuring web server
connectors... fine.. I killed the install process, and just for SG,
restarted
Chad,
You should always var your query name and use a query name to make it
a local variable and avoid race conditions.
With that said, that is not the cause of your problem.
The deadlock is occurring at the database level. Normally I can get
rid of deadlocks by tuning the query. There are
We have a vendor that is providing text messaging for our campus. They
provide both SOAP and REST web services. I'm trying to connect to the
REST service to pull some information. The service requires SSL.
When I try to consume the REST service from CF7, the service throws an
error. However,
Yeah, because only you know your sites security policy.
I certainly don't want Joe Blogs able to upload files on a default CF8
install.
Hi Tom,
Did you try using the file/image upload feature?
It wasn't like it was a flag which was disabled. The CFM file was compiled
and SAVED as disabled.
Thanks for all the help so far I know I'm almost there
I figured out that all the items in the select need to be in the group by
clause, however what is causing the problem is the date. When I run the
query without the date it runs fine (actually I had to remove the FullName
and break it into
Hi, I hope someone out there can be of help.
I've been provided a .dll with a number of procedures written in VB5. The
function I'm trying to access requires three inputs as arrays, the last one
being an empty array (with a length) for it to store the results and return.
The function requires
It is my understanding that the 1.1 ExtJS components are built-in to CF8 (in
use for the CFFORM stuff). Is that what you were asking?
Would do I find Ext components for CF 8?
Rick
That's what I have heard. This is great, because as Rey has stated, you
can't simply abandon jQuery in low
Ok...
So Normally I would just not map the whole cfide/ directory and then create
a mapping to the scripts folder. This was great pre-cf8. now I'm stuck with
a bunch of ajax ui stuff not working like it should. Even cflayout doesn't
work without at least something in cfide directory...
If I were
Using the example I linked, you can change the name of the file.
Dave Watts, CTO, Fig Leaf Software
Dave, none of the examples on your page appear to do what I'm requesting.
You're using .cfm files to download .csv or .pdf files, but your examples also
throw a security excetion, asking the
Hi Rick,
Did you check with the Port numbers that verity is running and what is
configured in CF8 Admin ??
CF8 has default Verity port changed and is not same as it used to be in
CF7.
CF8 verity ports = (CF7 Verity ports + 1)
CF8CF7
K2 Admin Port 9951
We have been running CF 8 in our dev environment without any problems.
After upgrading to CF 8 on one of our production boxes, we are having
lots of problems.
The first page hit seems to take an extreme amount of time. We have
been watching these requests using Fusion Reactor and have seen the
Ah... now that is what im talking about!
Thanks for the link Andrew, and Ben for the CFC!
-Original Message-
From: Andrew Clark [mailto:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 10:57 AM
To: CF-Talk
Subject: RE: import excel
You could try this:
Having just moved one of our sites from CF7 to CF8 I've
noticed that the connection pooling (Maintain Connections)
setting is not working (I've unticked and ticked again to
check!). The sites left on the CF7 installation are still
working with the same driver as I would expect.
This is
Jose,
The Google map API maybe the answer here is a demo script I
did a while backas an example of integrating a google map into a page:
Thank you. Being and a JavaScript novice it was very helpful to see an
example of the API in action. It helped me better understand the actual
simplicity
Why not use a pdf is there a specific reason for word?
If it is for formatting I had the same problem and used extra document info
fields to do this.
Travis Haley
-Original Message-
From: George Linderman [mailto:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 5:05 PM
To: CF-Talk
Could not specifying a name on the CFQuery cause these deadlocks?
No, that won't cause a deadlock. What will cause a deadlock is two
transactions running at the same time, that need to use the same resources,
such that the first transaction locks something needed by the second
transaction, which
Remove the date from the query.
On 10/2/07, Travis Haley [EMAIL PROTECTED] wrote:
Thanks for all the help so far I know I'm almost there
I figured out that all the items in the select need to be in the group by
clause, however what is causing the problem is the date. When I run the
query
-Original Message-
From: George Linderman [mailto:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 7:05 PM
To: CF-Talk
Subject: Inserting data into a word document
Hey guys,
Well, I'm presented with a problem here. My client needs me to create a
form, where the user will
Hi,
I have applied the latest patch from Adobe (ColdFusion 8.0 Cumulative Hot
Fix
1http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402466sliceId=1)
and now I get the following error:
errorDiagnostic:
coldfusion.filter.FusionContext.getSecureJSONPrefix()Ljava/lang/String;
null
The
We have noticed longer initial compilation times under CF8 as well, so
you are not alone.
Once the files have been compiled, it's generally easy going from there on in.
Mark
On 10/2/07, Ryan Duckworth [EMAIL PROTECTED] wrote:
We have been running CF 8 in our dev environment without any
Hi,
If you don't have your template compiled then at first time it will
under go compilation which takes a few (mili)seconds depending upon your
template size.
If you clear the Template cache then CF will re-load templates into
memory the next time they are requested and recompile them again if
No the version of Ext included in CF8 is v1.0.
Rey
Jeff Fleitz wrote:
It is my understanding that the 1.1 ExtJS components are built-in to CF8 (in
use for the CFFORM stuff). Is that what you were asking?
Would do I find Ext components for CF 8?
Rick
That's what I have heard. This
But I need the date, should I run this in a second query?
Travis Haley
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 6:45 PM
To: CF-Talk
Subject: Re: Adding Small sections of a query
Remove the date from the query.
Which date do you want? You have multiple entries - which one should
the query return?
On 10/2/07, Travis Haley [EMAIL PROTECTED] wrote:
But I need the date, should I run this in a second query?
Travis Haley
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent:
depending on your database, you should have various functions available
to you to extract just the date part from your datetime field.
like DATE(yourdatefield) in mysql, for example...
Travis Haley wrote:
But I need the date, should I run this in a second query?
Travis Haley
-Original
Yes, the newer keystore in CF8 could well contain a CA cert that isn't
in the older one that came with CF7. Get the CA cert from the vendor
and import it into the CF7 keystaore and you should be fine - you can
print the list of certs in each keystore if necessary.
On 10/2/07, Dawson, Michael
Thanks! That was very helpful.
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 11:02 PM
To: CF-Talk
Subject: Re: CFHTTP SSL Difference Between CF7 and CF8
Yes, the newer keystore in CF8 could well contain a CA cert that isn't
in the older
If you want the date,
And the date is the same per record, then just add it to the group by.
If the date is different per record then you need to either
1. Return multiple records
2. Use Max( or Min( on the date to get the oldest or newest
Since your original sample had no dates, not sure what
The date part of the datetime is the same the time part differs but the time
part is irrelevant to this report. I was able to get this to work by
dropping the date out of the first query then running a second query in the
cfoutput of the first query:
cfquery name=rsGetPurchaseDate
49 matches
Mail list logo