Verity Search Results - formatting issues

2007-11-07 Thread Peterson, Andrew S.
Hello, I've got some verity search results from a query and am outputting the #Context# variable The context variable returns as formatted text, but however the text is formatted, if there is no corresponding end tag, such as an /span, the formatting carries over to the next search result.

autocomplete musings

2007-06-04 Thread Peterson, Andrew S.
I used to have a grand ol' time in ColdFusion Studio (I think) setting up trigger text such as '#var and then CFStudio would add iables.#' and put the cursor prior to the last pound sign so that I could type the variable. I think there's something in CFEclipse (snips) and DW (keyboard shortcuts)

Form Fields - storing unsaved values.

2006-10-12 Thread Peterson, Andrew S.
Got a form with a list of rows coming from a database. User enteres new data, then realizes he needs to add a row to this form. User click sa hyperlink to do just that - and a popup window opens for him to add a row. User closes the popup window after successful addition, and form must refresh

Regular Expression : Positive Integer

2006-02-27 Thread Peterson, Andrew S.
Hi, My cfinput form field validates via regular_expression, and I want only positive integers accepted. I'm trying various things, such as 0*[1-9][0-9]*, but cannot get a regex yet that only allows positive numbers. For example, I can still enter a -5 and it will be accepted under this regex.

RE: Regular Expression : Positive Integer

2006-02-27 Thread Peterson, Andrew S.
Massimo wrote: Try this: ^\d\d*$ Brilliant! And now my quest to figure out why the heck this works begins :-) Sincerely, Andrew -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 3:34 PM To: CF-Talk Subject: Re: Regular Expression :

RE: Regular Expression : Positive Integer

2006-02-27 Thread Peterson, Andrew S.
OK, I think I know why this works: ^ = anchors the expression to beginning of the string \d = any digit \d = any digit * = match 0 or more occurrences of previous item $ = anchors the expression to the end of the string Therefore the regexp = every item must be numeric. Thanks! Sincerely,

RE: Regular Expression : Positive Integer

2006-02-27 Thread Peterson, Andrew S.
Massimo wrote: Try this: ^\d\d*$ FYI - I also tested ^\d*$ (removed one set of \d) and it too seems to work. Sincerely, Andrew -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 3:34 PM To: CF-Talk Subject: Re: Regular Expression :

RE: cfstoredproc and cache

2006-01-20 Thread Peterson, Andrew S.
, January 19, 2006 10:45 AM To: CF-Talk Subject: RE: cfstoredproc and cache You can put the results into the session/application scope and manage it yourself or call the stored procedure using cfquery tags and make use of the cache attributes of the cfquery tag. Mike From: Peterson, Andrew S. [mailto

cfstoredproc and cache

2006-01-19 Thread Peterson, Andrew S.
Is there a way to cache the results of a stored procedure in or around the cfstoredproc tag? Sincerely, Andrew ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229980 Archives:

OT: SQL Server Full-Text Search issue

2006-01-03 Thread Peterson, Andrew S.
Hello all, After the full-text search index process concludes, aren't your like queries supposed to be *faster*? Surely I've done nothing wrong :-)... I've created a full text index on my tblReceipts table with 800K records, which took SQL Server 2000 about 6 hours to complete. I selected

OT: SQL Server Full-Text Search issue

2006-01-03 Thread Peterson, Andrew S.
Hi, After the full-text search index process concludes, aren't your like queries supposed to be *faster*? Surely I've done nothing wrong :-)... I've created a full text index on my tblReceipts table with 800K records, which took SQL Server 2000 about 6 hours to complete. I selected two

RE: SQL Server Full-Text Search issue

2006-01-03 Thread Peterson, Andrew S.
Oh man, nevermind. I found the solution: WHERE CONTAINS(tblReceipts.LastOnlyName, 'FORTA') Sincerely, Andrew Webmaster Illinois Office of the Comptroller IllinoisComptroller.com -Original Message- From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03

OT: How long? SQL Server Full Text Index Population process

2005-12-30 Thread Peterson, Andrew S.
Hi, I'm creating a full text index on two fields in a 800,000 row table. The population has been in progress for 18 hours now, or so it says in SQL Server 2000's Catalog Status. Any indication on when this will conclude? Would I have better luck with Verity? Thanks in advance for any advice.

OT: SQL Server Index Won't 'Take'

2005-12-07 Thread Peterson, Andrew S.
Hi, I placed a clustered index on field strName in a table of 800,000 records. I run a query with a LIKE clause on a wildcard and it takes 20 seconds to return a result. I remove the index and it takes the exact same amount of time. In other words, adding the index on the searched field does

RE: Man, I'm just really banging my head over this one...

2005-11-29 Thread Peterson, Andrew S.
www.springfieldfirst.com/calendar.zip has the capacity to add events every day, every other day, every third day, every week, every other week, every third week, every month, every other month, every third month, every sixth month, every year, and every other year for a repeatable duration from

ColdFusion (sub)report woes

2005-11-23 Thread Peterson, Andrew S.
Hi, I posted this to the the Macromedia forums without luck so I'm trying here. From what I've read, it seems like the following scenario is common, and there may not be a known solution. Maybe you guys can help. Prior to upgrading to 7.0.1, my CF reports didn't hang like they do now

RE: Calendar Application

2005-11-18 Thread Peterson, Andrew S.
, Peterson, Andrew S. [EMAIL PROTECTED] wrote: From: Peterson, Andrew S. [mailto: [EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Thu, 17 Nov 2005 12:48:30 -0600 Subject: RE: Calendar Application Jeff,brbrLong lng ago I incorporated a calendar app into a CMS I built. It'sbrnot

OT: Multiple sites in IIS - Modifying DNS

2005-11-18 Thread Peterson, Andrew S.
, 2005 11:12 AM To: CF-Talk Subject: RE: Multiple sites in IIS Yes, use different host headers instead of ports. Use a subdomain off your primary domain for your dev server, Russ -Original Message- From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] Sent: 15 November 2005 15:29 To: CF

RE: Multiple sites in IIS - Modifying DNS

2005-11-18 Thread Peterson, Andrew S.
Regarding the additional site we created, I might also add that we are able to ping it successfully. Sincerely, Andrew Webmaster Illinois Office of the Comptroller IllinoisComptroller.com -Original Message- From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] Sent: Friday, November 18

application-specific debugging info?

2005-11-17 Thread Peterson, Andrew S.
Hello, Is there a way to place debugging information for a specific application (folder) without having sitewide debugging info turned on in the Administrator? Thank you. Sincerely, Andrew ~| Logware (www.logware.us): a

RE: Calendar Application

2005-11-17 Thread Peterson, Andrew S.
Jeff, Long lng ago I incorporated a calendar app into a CMS I built. It's not fusebox, and the backend is MS Access. Do you (or anyone) still want it? If so, I'll zip it up and send you a link. Sincerely, Andrew -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED]

RE: Calendar Application

2005-11-17 Thread Peterson, Andrew S.
:-) Sincerely, Andrew -Original Message- From: Dan Blickensderfer [mailto:[EMAIL PROTECTED] Sent: Thursday, November 17, 2005 12:54 PM To: CF-Talk Subject: Re: Calendar Application Andrew, I would also like a copy. Thanks, Dan - Original Message - From: Peterson, Andrew S

Content delivered/retrieved across internet

2005-11-15 Thread Peterson, Andrew S.
Hello all, I have the need for some content on one server to be accessed by another server across the internet. Both servers are running CF. This content is currently in html (it's all text with perhaps one or two images), but I plan to make these pages database driven. The content on the

OT: Multiple sites in IIS

2005-11-15 Thread Peterson, Andrew S.
Hi, We have one development server, and multiple production servers. For each separate server in production, I'm just creating a New Site in IIS on the development server, each using a different port. Is there a better way/best practices approach to keeping these servers separate in the

Installation issues CFMX 7

2005-10-31 Thread Peterson, Andrew S.
Hi all, I've installed cfmx 7 on a server that has just been upgraded from Win 2000 to Win 2k3 Server standard and am receiving a JRun Closed Connection error. The Docs say to upgrade the JVM to the latest version to try to solve the problem. Does the CFMX installation process already do that,

ODBC Agent and ODBC Server Services - not installed?

2005-10-31 Thread Peterson, Andrew S.
Hi, I'm trying to figure out why upon accessing the CF Administrator for the first time after re-install of CFMX 7 Enterprise on Win2K3 I'm getting a JRun Closed Connection error, and noticed that the ODBC Agent and ODBC Server Services are not shown at all in Start Control Panel

RE: ODBC Agent and ODBC Server Services - not installed?

2005-10-31 Thread Peterson, Andrew S.
-Original Message- From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] I'm trying to figure out why upon accessing the CF Administrator for the first time after re-install of CFMX 7 Enterprise on Win2K3 I'm getting a JRun Closed Connection error, and noticed that the ODBC Agent

RE: ODBC Agent and ODBC Server Services - not installed?

2005-10-31 Thread Peterson, Andrew S.
In the installation, you choose to install or not install the ODBC services I'm pretty sure I chose to install the ODBC services. I believe the checkbox to install them is selected by default. You'd think after the 4th attempt I'd know by heart...

RE: ODBC Agent and ODBC Server Services - not installed?

2005-10-31 Thread Peterson, Andrew S.
WIN2000 server. Is this correct as in the thread it sounds like you had CF7 on a 2000 box. Can you put CF5 on a 2003 box as well? -Original Message- From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] Sent: Monday, October 31, 2005 9:20 AM To: CF-Talk Subject: RE: ODBC Agent and ODBC Server

Free Installation Support - Where?

2005-10-31 Thread Peterson, Andrew S.
Hi, I'm having trouble locating the link to the free installation support given by Macromedia. Does anyone have a link or an email address? Thanks. Sincerely, Andrew Webmaster Illinois Office of the Comptroller IllinoisComptroller.com -Original Message- From: Peterson, Andrew S

RE: Disregard - Free Installation Support - Where?

2005-10-31 Thread Peterson, Andrew S.
Please disregard - I just located the link. Sincerely, Andrew ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client

OT: No cache meta tags not working

2005-03-16 Thread Peterson, Andrew S.
Hi All, I've got the following meta tags in the header of my doc to prevent the page from caching, but the page is still being cached (IE 6 and Firefox tested): meta HTTP-EQUIV=pragma CONTENT=no-cache meta HTTP-EQUIV=cache-control CONTENT=no-cache meta HTTP-EQUIV=expires CONTENT=0 I'm

Easy NumberFormat Question

2004-11-24 Thread Peterson, Andrew S.
Hello, Is there a number formatting function that will show a maximum of two decimal places when a remainder exists and no decimal places if it doesn't exist? Right now I'm using numberformat and it's showing two decimal places when there is no remainder. I'd just like for those cases to show up

RE: Easy NumberFormat Question

2004-11-24 Thread Peterson, Andrew S.
Thanks guys. I checked cflib but missed this. Sincerely, Andrew -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 10:24 AM To: CF-Talk Subject: Re: Easy NumberFormat Question Sierra Bufe submitted this udf to cflib.org: function

RE: Undeliverable CFMAIL

2004-11-09 Thread Peterson, Andrew S.
C:\cfusionmx\mail\undelivr Not sure of your path, but look for the undelivr folder. When the mail server goes back online, cut and paste those files into the Spool folder in the same directory Sincerely, Andrew -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED]

jrun.security.NTAuth question

2004-11-03 Thread Peterson, Andrew S.
Hello, If you log someone in using jrun.security.NTAuth, how do you log them out? Sincerely, Andrew ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area.

RE: Dan Switzer

2004-10-28 Thread Peterson, Andrew S.
Is he Mr. PengoWorks? Man I love those qForms. Macromedia should have bought qForms for embedded Blackstone form validation :-) Sincerely, Andrew -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 6:52 AM To: CF-Talk Subject: Dan

RE: Select distinct record - help

2004-10-20 Thread Peterson, Andrew S.
Hi CFCoder, Try taking out the unique ID, if that is the 1 and the 2 in your query result. Or, maxrows=1? Hope this helps. Sincerely, Andrew -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 7:30 AM To: CF-Talk Subject: Select distinct

RE: Another Is this Homesite feature in DW? question

2004-10-20 Thread Peterson, Andrew S.
Ewok Wrote: The closest thing I can get is the snippets with a hotkey. Have you looked at those yet Andrew? No I haven't. I will let you know if I do. Sincerely, Andrew ~| Purchase from House of Fusion, a Macromedia

Another Is this Homesite feature in DW? question

2004-10-19 Thread Peterson, Andrew S.
Hi, Homesite has a nice AutoCompletion feature whereby you enter a trigger string and it spits out the remainder of the code for you. For instance, you enter '#att and it will automatically add ributes.# and even place the cursor before the pound sign and after the period. I cannot find this

RE: Dreamweaver Autocomplete

2004-10-19 Thread Peterson, Andrew S.
. Sincerely, Andrew -Original Message- From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 7:35 AM To: CF-Talk Subject: Another Is this Homesite feature in DW? question Hi, Homesite has a nice AutoCompletion feature whereby you enter a trigger string

Using a form field name as part of the name of a session variable

2004-10-19 Thread Peterson, Andrew S.
Hi, I'm hoping this is just a question of syntax. Is it possible to set part of the name of a session variable using the name of a form variable? The form name is dynamic too. Here's the code that ain't working: cfset session.qNum#form.qNum# = form.answer ^ For

RE: Using a form field name as part of the name of a session variable

2004-10-19 Thread Peterson, Andrew S.
To: CF-Talk Subject: RE: Using a form field name as part of the name of a session variable Try this cfset session[qNum#form.qNum#] = form.answer Or something like that... maybe without quotes? But I think with. -Original Message- From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED

RE: dhtml and div question

2004-10-19 Thread Peterson, Andrew S.
Just a guess, but could you make the display setting dynamic so that the button click would set a session variable that would change the setting? Sorry if I'm way off base. Sincerely, Andrew -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004

Homesite's Wizards in DW?

2004-10-15 Thread Peterson, Andrew S.
Hi all, There are some (arguably) handy wizards in HomeSite that I sometimes miss - particlularly the good ol' Record Viewer Wizard with it's data manipulation abilities. I was wondering if there was any way to get that functionality in DWMX. I looked in th exchange but found nothing

Changing text in undelivrable .cfmail file and resending

2004-10-06 Thread Peterson, Andrew S.
Hello all, About 1000 emails (.cfmail) are sitting in my Undelivr folder because I've got the wrong mail server set. With a simple change on the 2nd line of every .CFMail file, these email files would be OK. Using code from evolt, I've managed to replace the offending line with the correct mail

RE: Changing text in undelivrable .cfmail file and resending

2004-10-06 Thread Peterson, Andrew S.
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 9:19 AM To: CF-Talk Subject: Changing text in undelivrable .cfmail file and resending Hello all, About 1000 emails (.cfmail) are sitting in my Undelivr folder because I've got the wrong mail server set

Logging into CF App with NT Username and password

2004-10-04 Thread Peterson, Andrew S.
Sorry in advance - I'm a bit confused here. I am creating an intranet app and would like to make the log in process as simple for the user as possible by having them log in with their Windows username and password. I am looking for a solution that will provide for: 1. The user logging in with

Distribute cf as java bytecode atop a J2EE server: What do I need?

2004-09-23 Thread Peterson, Andrew S.
Hi, I love the idea of being able to distribute compiled Java bitecode, without CFML source, on top of a J2EE server. Blackstone will let me do this. However, I have no knowledge regarding the building of a J2EE server. What do I need? This J2EE server will be used internally, and the web apps

Writing the data from a query to a file - Page 1 to Page 2

2004-07-26 Thread Peterson, Andrew S.
Hi, I would like to add the ability for a user to download the data from a query. For example, if the user fills out a query form and the results are returned, how do I get that result into a file for them to download? What I can do use Cffile to create a file based on query results - that's

OT: Which to use as primary key?

2004-07-01 Thread Peterson, Andrew S.
Hi, I'm wondering from a performance perspective as well as a practical perspective the best way to set up primary keys and indexes in a table which will be used to drive a data entry/edit/retrieval-reporting application. I've got four columns that can be used as the primary key. I also have a

RE: Which to use as primary key?

2004-07-01 Thread Peterson, Andrew S.
-Original Message- From: Todd [mailto:[EMAIL PROTECTED] I believe he means that the combination of those four columns creates a unique identifier that can be used as the primary key, much as FirstName + MiddleName + LastName + DateOfBirth would go a long way to uniquely

RE: cffile question

2004-06-25 Thread Peterson, Andrew S.
Tony, Are your cfmx services running under the localSystem account or an administrator account? I think that sometimes your LocalSystem account may not have rights to mapped drives, whereas if your CFMX services is running under an administrator account, you'll have better luck. Sincerely,

RE: Printing Labels from a Web Application?

2004-04-19 Thread Andrew S. Peterson
Any thoughts would be appreciated. If you have Crystal Reports, perhaps you could use that: http://www.windowatch.com/2004/april/crystal10_4.html Sincerely, Andrew Tim. -- --- CF_CodingContest mode=judging newentries=false Maze

RE: SOT: Flash Remoting vs Web Services vs XML

2004-04-14 Thread Andrew S. Peterson
Chris, There's a good (IHMO) ramp-up article in MXDJ (vol 2 issue 4) (http://sys-con.com/mx/ - I can't find the exact link to the article) ) entitled FlashFusion that describes how to consume webservices based around SOAP. A short comparison to Remoting is included as well. Sincerely,

RE: VB6 Application, Cold Fusion Coral

2004-01-29 Thread Andrew S. Peterson
Hi Ben, I've been contemplating the same thing for an old Access application of mine. My main reason for doing so would be to overcome the great difficulty of distributing an Access app. However, with VB, you don't really have that problem, or do you? In any event, I'm curious as to your

RE: VB6 Application, Cold Fusion Coral

2004-01-29 Thread Andrew S. Peterson
-Original Message- Sorry, Never heard of Coral. What is Coral and where can you find it? Shawn, From Defusion: Have you ever wanted to run Cold Fusion without Cold Fusion? Coral Web Application Builder is a new product that allows you to run Cold Fusion, (CFML) and portions of (ASP),

RE: OT:Anyone ever see this?? SteelArrow?

2004-01-29 Thread Andrew S. Peterson
it would seem strange to type anything else other than CF... or CFA_ Yes, but it seems you get to keep on using those pound signs! TH COLSPAN=2I#PARAM.first+1# to #PARAM.first+3# of #SESSION.faqQuery.RowCount()#/I/TH Sincerely,   Andrew [Todays Threads] [This Message] [Subscription]

CFContent, Mapped Drive, ftp server

2004-01-09 Thread Andrew S. Peterson
Hi, Can you use cfContent to pull down data from a mapped drive? I think I've done this successfully before but I'm wondering if the reason I'm getting the error (below) has anything to do with the fact that the mapped drive happens to be on an ftp server. Does it even matter? The error I am

RE: cfc questions

2003-12-09 Thread Andrew S. Peterson
Hi Ray, For example, for a db insert, can I create one cffunction with a returntype of any, an access value dynamically inserted (or remote if it'll work), and cfargument tags for all data passed in, and use it from both? What exactly is the method doing? I will be building a simple

RE: cfc questions

2003-12-09 Thread Andrew S. Peterson
Yes, returnType=struct would work if you want to return the values as a structure, but that seems kind of odd. Why would a method return exactly what it was passed? Normally when I do an insert in a method, I return the ID of the new record. I see. I'm looking at Macromedia's NoteBoard Flash

Do CFCs cache?

2003-06-27 Thread Andrew S. Peterson
If I go into a cfc and modify a function, save it, reload the page that calls it, the page that does the calling still pulls up the old version of the function that existed before I made the changes. For instance, if I call a function called getEntries but modify the code within getEntries, the

Restart after X Unresponsive Requests (MX)

2003-03-31 Thread Andrew S. Peterson
Hi, Is the ability to Restart after X Unresponsive Requests available in MX? I don't see it in the docs or CFIDE. Thanks in advance. Sincerely, Andrew ~| Archives:

MX cannot connect to IBM DB2 Datasource

2003-03-28 Thread Andrew S. Peterson
Hi, I'm trying to connect to DB2 version 7.1 using DB2 Connect version 7 into our MVS. Our ColdFusion 5 Enterprise automatically identifies the connection in CFIDE, which is great. However, MX does not - it simply doesn't appear as a datasource, and so I cannot see DB2 with CFMX. I've tried

Websphere HATS and CFMXJ2EE

2003-02-21 Thread Andrew S. Peterson
Hi, Our office is looking into using HATS to transform our green screens to GUIs. It is apparently wizard driven. Can anyone shed some light on how it works? As a coldFusion/Flash developer, could I piggyback onto the HATS application to access and modify our enterprise applications with CFMX

RE: HEEEEEEEEELLLLLLLLLLLLPPPPPPPPPPPPPP! Access Memory Error

2000-10-12 Thread Andrew S
Using The CFServer Admin control panel turn on maintain db connection and set the number of connections to 1. This way Coldfusion manages the Queued requests and not the Acess ODBC Driver. It seems that the Access driver has a memory leak problem where it does not want to let go of a

RE: SESSION Vars to FORM vars

2000-10-11 Thread Andrew S
Put all the sesion variables in a structure and convert it to a wddx packet using cfwddx action="cfml2wddx" input="structure" output="wddxpack" form method="post" action="x.cfm" input type="hidden" name="wddxpack" value="#wddxpack#" input type="submit" /form