Anybody know a function in ASP that does a similar thing as the
ParagraphFormat function? I've got a SQL database that has fields with large
blocks of text (many paragraphs long). In the sql tables, the paragraphs are
separated by dual carriage returns.
I need to bring the text out of the
ballpark figure? Any reason not to calculate the
total size of all templates and then add some more breathing room to the
setting?
Thanks for some opinions/recommendations.
Paul Sinclair
~|
Archives: http://www.houseoffusion.com
in
the ODBC configuration for these Access databases that it seems to take care
of the problem for the most part. I am just wondering what the downside is
to disabling that setting?
Thanks for advice.
Paul Sinclair
~|
Archives: http
which site is being accessed - they are all slow.
I've looked at app log, server log, etc. to get any clues but am mystified. If anybody
could suggest some things to look at, I would sure appreciate it. I've searched the
archives over and over and haven't found a solution yet.
Thanks,
Paul Sinclair
hanging. You may just
: be losing your threads or something.
:
: Adam Wayne Lehman
: Web Systems Developer
: Johns Hopkins Bloomberg School of Public Health
: Distance Education Division
:
:
: -Original Message-
: From: Paul Sinclair [mailto:lists;mail1.kingcrest.com]
: Sent: Tuesday, November
: -Original Message-
: From: Paul Sinclair [mailto:lists;mail1.kingcrest.com]
: Sent: Tuesday, November 05, 2002 11:29 AM
: To: CF-Talk
: Subject: RE: SLOW! What is hanging up Cold Fusion?
:
:
: It is CF 4.5, Enterprise. I have rebooted the system several times - still
: goes slow. Client vars
Message-
: From: Paul Sinclair [mailto:lists;mail1.kingcrest.com]
: Sent: Tuesday, November 05, 2002 10:29 AM
: To: CF-Talk
: Subject: RE: SLOW! What is hanging up Cold Fusion?
:
:
: It is CF 4.5, Enterprise. I have rebooted the system several times - still
: goes slow. Client vars not stored
.
: Often they are generated by a user stopping the request because it
: takes
: too long. What about your server processes and swap file etc. Have you
: checked to see what's eating it?
:
: -mk
:
: -Original Message-
: From: Paul Sinclair [mailto:lists;mail1.kingcrest.com]
: Sent: Tuesday
or even it is possible to do it.
Thanks,
Paul Sinclair
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http
frame name=bottom src=that.cfm?section=#url.section#
marginwidth=10 marginheight=10 scrolling=auto frameborder=0
/frameset
Problem is that the url variables passed through to this page disappear
before they arrive at the sub-pages. Is there any way to accomplish this?
Thanks,
Paul Sinclair
something
like:
update tblname
set price='12.95'
where id=100
But I can't figure out how to loop through the Excel spreadsheet the way you
loop through a list. How is it done?
Thanks for any help.
Regards,
Paul Sinclair
__
Your ad
is exactly
for this purpose, but I can't get it to work properly Here is sample code
for a gridcolumn that I want to have clickable:
cfgridcolumn name=id href=ItemPriceList_Editcfm hrefkey=id
target=_new select=No display=Yes
Is there something more to this that I am missing?
Thanks for any help
Paul
with the various aggregate functions. I think I've lost site of the
forest through the trees here.
Thanks,
Paul Sinclair
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant
sing something. All that does for me is list the records in whatever order
I selected them but it doesn't count them and then order them by which page
s were viewed most often.
Thanks for your help - sorry to be thick.
Paul Sinclair
-- Original Message
;
Ian
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 2:32 PM
To: CF-Talk
Subject: RE: SQL ?: Counting number of times for this
Ian,
I'm sorry - I don't know what you mean. What is COUNTER and TITLE? I'm
assuming you're meaning
(begindate)#
AND #CreateODBCDate(enddate)#
GROUP BY script_name
ORDER BY Count(script_name) DESC
Jim
- Original Message -
From: Paul Sinclair [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, February 10, 2002 7:36 PM
Subject: RE: SQL ?: Counting number of times
.
FYI, the mailserver is iMail v6.
Thanks if you have any ideas what I can do to fix this. I've got
scheduled deliveries of this starting this weekend so I would really
like to get it working right before then obviously!
Regards,
Paul Sinclair
-Original Message-
From: Jochem van Dieten
: Wednesday, December 12, 2001 3:42 PM
To: CF-Talk
Subject: Re: HTML okay in browser
Paul Sinclair wrote:
I've put up the chopped version of the file up as well as
the version
that was trapped in the undelivr folder. The chopped
version is a
sample of what is getting to the email
lunchtime and then picks up a couple of paragraph codes
later. I have looked at this in a version mailed to a Hotmail account
and I get the same clipping in the email sent there.
Thanks for any ideas what could be causing this.
Regards,
Paul Sinclair
-Original Message-
From: Jochem van
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 09, 2001 10:34 AM
To: CF-Talk
Subject: Re: HTML okay in browser
Paul Sinclair wrote:
Jochem,
Thanks for your reply on this subject.
Can you see in the source of the email whether
truncated. I can't figure out why
these specific paragraphs are getting truncated, but it happens each
time I generate the newsletter and in exactly the same place(s)
everytime.
Anything unusual about the cfmail function that might be causing this?
Paul Sinclair
I have an output page that may have dozens or hundreds of records on it.
I want to put all the records into a single form with a checkbox by each
record so that a user can: edit any or all records on the page; click
the checkbox to identify the records modified; and submit the form to a
page that
Thanks for the offer Doug. I could use a copy please.
Regards,
Paul Sinclair
-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 4:39 PM
To: CF-Talk
Subject: If anyone else needs zip codes just speak up.
Just though I would
this is straightforward and I think I even have some pages where
I have done it but I can't for the life of me remember how to do it!
Thanks for any more help.
Best,
Paul Sinclair
-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 11:40 AM
I am setting up a form page that requires a drop down selection box. The dropdown box
is generated dynamically in a cfoutput query section. But the dropdown box is itself
to be inserted within another cfoutput query section of the page.
I've tried using cfset above the first cfoutput section
/cfloop
Thanks for any help.
Regards,
Paul Sinclair
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe
file so that my fax program will be able to fax it out.
Thanks for any suggestions.
Paul sinclair
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail
to convert an html/cfm document to Word so that I can
then fax that out.
Is there some module or something that I could use that would take an
existing html document on the server and convert that to a Word format
document that I could then fax out?
Thanks for any suggestions.
Paul Sinclair
to do it.
Any suggestions for something like this?
Thanks for your help.
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion
in the comparison list against discrete values
in the the field value list. Only if one of the discrete values matches do I
want to the record.
Any ideas on how to accomplish this?
Thanks for ideas!
Paul Sinclair
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
normalization!
I've been trying to figure out a simple way to extract the field contents
from the non-normalized table and move the contents to a new, normalized
table with a single record for each. Is there a good way to do this?
Regards,
Paul Sinclair
-Original Message-
From: Paul Smith [mailto
the following (make
sure the list is in parentheses);
SELECT
*
FROM
tbl
WHERE
csvList IN (10,11,21,100)
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 7:17 AM
To: CF-Talk
Subject: SQL: Comparing value against a list
and versions on a
PC and I can't duplicate the problem.
Anybody else noticed this problem and figured out what is going on?
Thanks,
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com
body and by and large
it works. But I don't have any way of knowing what kind of odd characters
are going to be in the database so I can't anticipate every odd character.
Is there some way to handle this type problem?
Thanks for any suggestions/solutions.
Paul Sinclair
if 189,000K is
abnormally high? Should I look at my applications to see if there is
something causing excessive memory use or is this within reasonable bounds?
Thanks,
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get the official book
be an application I'm running that is
causing problems. But I'd just be interested to know for sure whether that
memory useage is out of normal range or not. If it is out of normal range, I
need to look into it further obviously.
Thanks,
Paul Sinclair
-Original Message-
From: David Frentrup [mailto
. But I need to figure out why
it memory use is creeping up so high.
How can I determine where the memory sinkhole is occurring?
Thanks,
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
with
a letter in that range and output the results.
I think I recall a simple way to do this, but right now can't think of it.
Could anyone jog my memory for me?
Thanks,
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get
Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: 06 April 2001 16:25
To: CF-Talk
Subject: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
I am trying to get a db output where a user selects an
alphabetical range in
a form and then the sql selects all
caption and wrap text around it
Paul, does the image have to be right aligned?
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 7:56 PM
To: CF-Talk
Subject: How to create image caption and wrap text around it
I need to create
text
Thanks for help.
Paul Sinclair
~~
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:
ot;b","c"
But it winds up like this:
1. "field1","field2","field3"
2. "1","2","3"
3. "a","b","c"
4.
I need to get rid of the last line
?
Thanks,
Paul Sinclair
~~
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: http
appreciate any help.
Paul Sinclair
-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 8:02 PM
To: CF-Talk
Subject: RE: IIS Permissions/Rights Problem Accessing cfm templates on
one site
I have seen this many times with newer versions
;
and so on until the cycle starts again?
Thanks for any suggestions.
Paul Sinclair
~~
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
for the instances of IDNum 1 and 2 are
distinct, I get 3 rows with IDNum 1 and 2 rows with IDNum 2 if I do a SQL
query such as:
select distinct IDNum, Description
from myTable
How do you do a select query that will give you just 1 row for each distinct
IDNum in this type of situation?
Thanks,
Paul
and each morning
I am manually importing the data to the db. I'm sure that CF can do this via
a cfm template that is run as a scheduled task but I haven't figured out how
to do it.
Thanks for any help.
Paul Sinclair
~~
Structure your ColdFusion code
the
archives. But perhaps something new has come up that would be of some help.
Thanks.
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail
. Could be the missing body/body tagset.
Paul Sinclair
-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 07, 2001 10:01 PM
To: CF-Talk
Subject: Problem w/Frames Netscape
Hello All and Happy New Year,
I have been working with a some new
from.
Also, there is a vtm file included but when I use CF Studio to create a
template and try to open the tag editor for the tag, it gives me an error. I
posted a bug report on this problem at the developers' site.
I'll keep plugging away at it I guess.
Paul Sinclair
-Original Message-
it will
perform as advertised. But the configuration/setup instructions could use
some tweaking.
If anyone is using this tag successfully, I'd love to run a few of my issues
by you. Send mail offlist unless deemed to be suitable for list discussion.
Regards,
Paul Sinclair
o charge for support.
Thanks very much for your note! Maybe there is another support form on the
site that I have overlooked that does allow me to get a few simple questions
answered?
Best regards,
Paul Sinclair
-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
the record with the incremented value.
The method above would require 2 cfquery actions as I see it: one to check
the current value; one to update the field with the incremented value. Is
there some way to do this without requiring 2 separate actions?
Thanks for any ideas.
Paul Sinclair
MSSQL db for the project I am working on right now. I can think of times
when I will need with MS Access as well though.
Paul Sinclair
-Original Message-
From: Lord, Heath [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 3:46 PM
To: CF-Talk
Subject: RE: One step method
whenever a
particular ad is served or clicked. Could involve thousands of ads on
thousands of pages so I am trying to figure out the simplest method of doing
the check + increment in one step.
Thanks for any ideas.
Paul Sinclair
-Original Message-
From: Scott Weikert [mailto:[EMAIL
Thanks Joe. This does it exactly. Also thanks for the reference to the
BannerMan tutorial. I will probably wind up using alot of that code (or at
least the structure) for the banner management thing I am working on.
Regards,
Paul Sinclair
-Original Message-
From: Joseph Thompson
where pageid = #thispage#
/CFQUERY
/cftransaction
- Original Message -
From: "Paul Sinclair" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, December 28, 2000 4:21 PM
Subject: RE: One step method to check then increment a value in db?
Scott,
with
this setting I will have to use cflock anytime I am using cfset to
create a session variable or WRITING to a session variable; but that for any
templates that are merely reading the session variable, I do not need a
cflock tag?
Thanks for clarification on this for me.
Paul Sinclair
Pan,
Thanks for the help. Do you know which classes are needed for the cfgrid
applet? Can the classes be placed anywhere in the URL space?
Paul Sinclair
-Original Message-
From: pan [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 23, 2000 5:02 PM
To: CF-Talk
Subject: Re
ems"
query="queryname"
insert="No"
delete="Yes"
sort="Yes"
selectmode="EDIT"
picturebar="No"
sortascendingbutton="Sort Ascending"
sortdescendingbutton="Sort Desce
for future
use]. I'd prefer to have this list continue as is with a general scope so
that I don't have to track several different lists to have the benefits
listed.
Having said that, yes - I would subscribe to CF-SQL if this list is
subdivided to exclude such topics.
Paul Sinclair
-Original
ems"
query="queryname"
insert="No"
delete="Yes"
sort="Yes"
selectmode="EDIT"
picturebar="No"
sortascendingbutton=&qu
Based on some of the comments in this thread, am I correct in assuming that
cookies must be enabled in the client's browser in order for session
variables to work?
Paul Sinclair
-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 4
of the
entire page.
Anyone come up with a good way to handle this type of thing?
Thanks,
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http
formatted but this dollar thing is avoiding
me. The field gets displayed simply as 25..
Thanks for what is I am sure a simple answer that I have just stupidly
overlooked.
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get
Matthieu,
Thanks. I know about the DollarFormat using CF, but I couldn't see how to
use it when outputting the data to a cfgrid (not via cfoutput). I now
see in looking closer at cfgrid that you can use cfgridcolumn which has
an option for NumberFormat. That does the trick.
Paul Sinclair
validation for cfinput fields?
Thanks for some help.
Paul Sinclair
~~
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
alculation in the WHERE clause?
Thanks for help.
Paul Sinclair
~~
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@houseof
Athelene,
I am running CF Enterprise 4.5.1 and had this problem. When I applied SP1 it
took care of it. I don't know what version you are running but you might
want to apply the latest Service Pack for it and see if that takes care of
it for you also.
Paul Sinclair
-Original Message
recommendations/experiences with any that would be helpful in deciding which
way to go on this. Also, are there other CF based systems that aren't listed
in the DevEx gallery?
Thanks for assistance.
Paul Sinclair
~~
Structure your ColdFusion code
Once a structure has been created and populated, where is the data kept? I
can't find it in the registry anywhere but it persists across server reboots
so it is obviously somewhere in the machine. If I need to get at it to move
it to a different server, where do I go to get it?
Paul Sinclair
browser versions.
Paul Sinclair
~~
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: http
hese being the same?
Paul Sinclair
~~
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: http://www.houseof
I've got about 1500 pdf documents that need to be indexed so as to be
searchable via a web search form. Can you/how do you index these things so
as to do a search on them? Can you create a Verity collection out of them
and then search the Verity collection?
Thanks for any pointers.
Paul
limitation on the PRO
version v. the Server version that is installed but I haven't a clue what
the differences are. But I do know that you can install it from your Win2000
PRO setup CD.
Paul Sinclair
-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 20
te.
Any suggestions will be appreciated.
Paul Sinclair
~~
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: http://w
table for tblDoubles and/or tblSingles, but I can't
figure out how to combine all points into one summary table. Is it possible?
Thanks for any help.
Paul Sinclair
Archives: http://www.mail-archive.com
h abc under "win" and "nopname" with nop under
"win") but if this is not easily done, I can run two different queries, one
for each. But if possible I'd like to get query results like this:
Adam - 2
Bart - 1
Ca
I have a db with a number of queries. Is it possible to access these queries
using CF and cfoutput the results? If so, a primer on the code would be
very helpful.
Thanks.
Paul Sinclair
Archives
this using a function? I've been forced to do a
whole bunch of string manipulation in several cfm templates in order to get
the output as I want it and it is getting tedious. I am hoping there is a
function that I am overlooking.
Thanks for your help.
Paul Sinclair
a series of string manipulation exercises to get the left side of the
decimal point and then append the proper fraction to the right side. It's
getting to be a real pain.
I'm hoping there is some simple function that I haven't found yet?
Paul Sinclair
I should have noted in my original message that the numbers I am working
with are coming from a cfquery to a database. The db fields are number
fields. They need to be number fields so that I can do some math with them.
Paul
-Original Message-
From: Paul Sinclair [mailto:[EMAIL
probably overlooking something simple - not seeing the forest through
the trees. Any help would be great.
Paul Sinclair
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http
to this I can figure out everything else
that I've asked in my question below.
Paul Sinclair
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 27, 2000 7:09 AM
To: CF-Talk
Subject: Getting/manipulating data for multiple records, multiple tables
I'm having trouble figuring out
Message-
From: pan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 11:14 PM
To: CF-Talk
Subject: Re: Help with ArraySum
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
I'm setting an array and trying to get the sum of the values.
The array is
populated from
gument contains only real values"
When I convert the array to a list, it outputs the following as the contents
of the array:
3.0,2.0,0.0,3.5,0.5,0.0,1.0,0.0,3.0,2.0,2.0,4.5,3.0,0.0,0.0,6.0,4.5,9.0,0.0,
3.0,
What might be the tro
in
the block of the message where I am regurgitating the form's contents. Here
is the code.
CFMAIL FROM="[EMAIL PROTECTED]"
TO="#FORM.email#"
SUBJECT="Your submission#SpanExcluding(FORM.Name," ")#,
Thank you for submitting your information.
Regar
ike to fix if possible.
Paul Sinclair
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message
Values('FORM.startTime', 'FORM.endTime', 'FORM.place')
/cfquery
But this is giving me problems as well.
What am I missing?
Thanks.
Paul Sinclair
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.c
at was entered. What I want it to output is:
NAME - John Doe
NAME - Joe Smith
NAME - Mary Jones
How can I make it so that in the loop, #FORM.Evaluate("tempvar")# becomes
#FORM.full_name_1# (#FORM.full_name_2#, etc.)? In other words - shows me the
value entered, not the field name.
Thanks f
Steve,
That's got it. Thanks. I forgot about getting rid of the quotes in the
#Evaluate("tempvar")# thing. When I changed it to #Evaluate(tempvar)#, it
gives me the value I need.
Paul Sinclair
-Original Message-
From: Steve Martin [mailto:[EMAIL PROTECTED]]
Sent: Tuesd
ation is drawn gets
incremented up with each loop? In the case where 4 people are registered, I
need to get it so that the cfloop portion winds up with loops for:
#FORM.Full_Name_1#
#FORM.Full_Name_2#
#FORM.Full_Name_3#
in either (1) folder last opened in
Resource Tab; (2) folder last opened in File Open dialog; (3) hard coded
folder. I'm hoping there is a way to configure it so the File Open Dialog
follows the currently active file. Don't see it any
Philip,
The "Files" tab doesn't change as I move from file to file in the edit
window. If I have several files open in the edit window from several
different directories, I'm looking for a way that when I hit "File/Open", I
get a list of files that are in the same directory as the currently
basis?
Thank you for any suggestions.
Paul Sinclair
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send
95 matches
Mail list logo