CF ParagraphFormat-like function for ASP?

2003-02-04 Thread Paul Sinclair
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

Question re Caching Settings

2002-12-10 Thread Paul Sinclair
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

Downside to disabling Maintain Database Connections

2002-11-06 Thread Paul Sinclair
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

SLOW! What is hanging up Cold Fusion?

2002-11-05 Thread Paul Sinclair
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

RE: SLOW! What is hanging up Cold Fusion?

2002-11-05 Thread 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

RE: SLOW! What is hanging up Cold Fusion?

2002-11-05 Thread Paul Sinclair
: -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

RE: SLOW! What is hanging up Cold Fusion?

2002-11-05 Thread Paul Sinclair
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

RE: SLOW! What is hanging up Cold Fusion?

2002-11-05 Thread Paul Sinclair
. : 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

cfgridcolumn - Can I format the contents of a column?

2002-10-14 Thread Paul Sinclair
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

How to: Pass query string from frameset page

2002-04-19 Thread Paul Sinclair
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

Using a spreadsheet structure to update database

2002-04-15 Thread 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

CFGRID with clickable URLs - Can't get this working

2002-03-04 Thread Paul Sinclair
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

SQL ?: Counting number of times for this

2002-02-10 Thread Paul Sinclair
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

RE: SQL ?: Counting number of times for this

2002-02-10 Thread Paul Sinclair
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

RE: SQL ?: Counting number of times for this

2002-02-10 Thread Paul Sinclair
; 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

Re: SQL ?: Counting number of times for this

2002-02-10 Thread Paul Sinclair
(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

RE: HTML okay in browser

2001-12-12 Thread Paul Sinclair
. 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

RE: HTML okay in browser

2001-12-12 Thread Paul Sinclair
: 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

RE: HTML okay in browser

2001-12-09 Thread Paul Sinclair
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

RE: HTML okay in browser

2001-12-09 Thread Paul Sinclair
-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

HTML okay in browser

2001-12-08 Thread Paul Sinclair
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

Updating only records checked on output page

2001-12-07 Thread 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

RE: If anyone else needs zip codes just speak up.

2001-12-07 Thread Paul Sinclair
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

RE: Updating only records checked on output page

2001-12-07 Thread Paul Sinclair
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

No cfquery output within cfquery output - but I need to

2001-12-07 Thread Paul Sinclair
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

Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Paul Sinclair
/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

CF to Word

2001-09-21 Thread Paul Sinclair
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

CF to Word to Email to Fax

2001-09-14 Thread Paul Sinclair
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

Suggestions for scrolling news headlines

2001-07-23 Thread 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

RE: Comparing value against a list of values

2001-06-13 Thread Paul Sinclair
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

RE: Comparing value against a list of values

2001-06-13 Thread Paul Sinclair
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

RE: Comparing value against a list of values

2001-06-13 Thread Paul Sinclair
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

Problems with forms in MSIE 5 Mac?

2001-05-08 Thread Paul Sinclair
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

Db to web: Replacing odd ascii characters in db to web

2001-04-24 Thread Paul Sinclair
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

189,000K memory use - Way too high for CFAS 4.5.1?

2001-04-20 Thread 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

RE: CF4.5.1 SP2 is chewing up memory

2001-04-19 Thread Paul Sinclair
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

CF4.5.1 SP2 is chewing up memory

2001-04-12 Thread Paul Sinclair
. 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

SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.

2001-04-06 Thread Paul Sinclair
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

RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.

2001-04-06 Thread Paul Sinclair
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

RE: How to create image caption and wrap text around it

2001-03-22 Thread Paul Sinclair
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

How to create image caption and wrap text around it

2001-03-21 Thread Paul Sinclair
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:

Getting rid of last line return in a cfoutput block

2001-03-20 Thread Paul Sinclair
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

IIS Permissions/Rights Problem Accessing cfm templates on one site

2001-03-07 Thread Paul Sinclair
? 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

RE: IIS Permissions/Rights Problem Accessing cfm templates on one site

2001-03-07 Thread Paul Sinclair
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

Adserver with proportional serving of ads?

2001-03-02 Thread Paul Sinclair
; 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

SQL: How to get distinct number where other fields not distinct

2001-03-01 Thread Paul Sinclair
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

Tag or function to import csv file to db

2001-02-16 Thread Paul Sinclair
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

Search Engines Dynamic Sites - Best Course

2001-01-08 Thread Paul Sinclair
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

RE: Problem w/Frames Netscape

2001-01-07 Thread Paul Sinclair
. 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

RE: Anybody using cf_htmlarea_one interested in helping?

2001-01-04 Thread Paul Sinclair
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-

Anybody using cf_htmlarea_one interested in helping?

2001-01-03 Thread Paul Sinclair
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

RE: Anybody using cf_htmlarea_one interested in helping?

2001-01-03 Thread 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

One step method to check then increment a value in db?

2000-12-28 Thread Paul Sinclair
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

RE: One step method to check then increment a value in db?

2000-12-28 Thread 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

RE: One step method to check then increment a value in db?

2000-12-28 Thread Paul Sinclair
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

RE: One step method to check then increment a value in db?

2000-12-28 Thread Paul Sinclair
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

RE: One step method to check then increment a value in db?

2000-12-28 Thread Paul Sinclair
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,

Am I understanding locking via CF Server properly?

2000-12-26 Thread Paul Sinclair
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

RE: cfgrid showing up as gray Java block

2000-12-24 Thread 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

cfgrid showing up as gray Java block

2000-12-23 Thread Paul Sinclair
ems" query="queryname" insert="No" delete="Yes" sort="Yes" selectmode="EDIT" picturebar="No" sortascendingbutton="Sort Ascending" sortdescendingbutton="Sort Desce

RE: Who wants a CF-SQL Mailing List?

2000-12-21 Thread Paul Sinclair
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

cfgrid showing up as gray block in IE

2000-12-21 Thread Paul Sinclair
ems" query="queryname" insert="No" delete="Yes" sort="Yes" selectmode="EDIT" picturebar="No" sortascendingbutton=&qu

RE: Session Variables

2000-12-21 Thread Paul Sinclair
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

Refreshing images without refreshing page

2000-12-20 Thread Paul Sinclair
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

Trying to get price in Dollar format from Access db

2000-12-15 Thread Paul Sinclair
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

RE: Trying to get price in Dollar format from Access db

2000-12-15 Thread Paul Sinclair
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

Using JavaScript to validate non-cfinput fields in a cfform

2000-12-11 Thread 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

SQL DateAdd function - how do I?

2000-12-05 Thread Paul Sinclair
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

RE: Time Stamp on CFMAIL email

2000-12-01 Thread Paul Sinclair
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 for banner ad managers

2000-11-27 Thread Paul Sinclair
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

Structures: Where is data kept

2000-11-25 Thread Paul Sinclair
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

Anyplace to pick up outdated browser versions for testing

2000-11-22 Thread 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

Is CFMODULE = CF_CustomTag?

2000-11-21 Thread Paul Sinclair
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

Any good way to index/search pdf docs via CF

2000-11-21 Thread Paul Sinclair
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

RE: Web server for Win2kP?

2000-11-20 Thread Paul Sinclair
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

Any good update/navigate/archive apps for large CF site?

2000-11-17 Thread Paul Sinclair
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

SQL query to aggregate these?

2000-11-07 Thread Paul Sinclair
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

Help building simply sql query expression

2000-11-03 Thread Paul Sinclair
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

Accessing db query via Cold Fusion?

2000-11-01 Thread Paul Sinclair
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

Any easy way to use fractions, not decimals?

2000-11-01 Thread Paul Sinclair
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

String manip: Using fractions rather than decimals for output

2000-10-31 Thread 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

RE: String manip: Using fractions rather than decimals for output

2000-10-31 Thread 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

Getting/manipulating data for multiple records, multiple tables

2000-10-27 Thread Paul Sinclair
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

RE: Getting/manipulating data for multiple records, multiple tables

2000-10-27 Thread Paul Sinclair
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

RE: Help with ArraySum

2000-10-26 Thread Paul Sinclair
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

Help with ArraySum

2000-10-25 Thread Paul Sinclair
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

Strange behavior in cfmail message body: no hard returns [CF-Talk]

2000-09-20 Thread Paul Sinclair
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

cfmail putting wrong time header in message?

2000-09-02 Thread Paul Sinclair
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

Problems with CFINSERT and Date/Time fields

2000-08-04 Thread Paul Sinclair
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

RE: CFLOOP'ing FORM Field Names Problem

2000-08-01 Thread Paul Sinclair
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

RE: CFLOOP'ing FORM Field Names Problem

2000-08-01 Thread Paul Sinclair
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

CFLOOP'ing FORM Field Names Problem

2000-07-31 Thread Paul Sinclair
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#

Studio: Any way to have File Open folder follow current file?

2000-07-12 Thread Paul Sinclair
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

RE: Studio: Any way to have File Open folder follow current file?

2000-07-12 Thread Paul Sinclair
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

Checking zip codes against USPS

2000-07-07 Thread Paul Sinclair
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