RE: Passing CF5 Structures to Java

2002-11-13 Thread Correa, Orlando (ITSC)
- From: Correa, Orlando (ITSC) [mailto:Orlando.Correa;mail.ihs.gov] Sent: Wednesday, November 13, 2002 1:44 PM To: CF-Talk Subject: Passing CF5 Structures to Java We are experiencing a problem while trying to pass a ColdFusion 5 structure to a java class that was created using CreateObject

Custom Delimiters with DSNless connection

2001-12-12 Thread Correa, Orlando (ITSC)
Anyone know how to set custom delimiters using a DSNless connection in CF? I have the following which does work... except for the fact that it's delimiting based on the commas(,), not the pipes (|). cfset connectstring = Driver={Microsoft Text Driver (*.txt;

ColdFusion Server Slows down... then stops

2001-10-05 Thread Correa, Orlando (ITSC)
Does anyone know if a solution/resolution to CF Server hanging as described/detailing in the following Allaire forum thread has been found? http://forums.allaire.com/coldfusion/messageview.cfm?catid=3threadid=184276 highlight_key=ykeyword1=unresponsive We are currently experiencing this

RE: ColdFusion Server Slows down... then stops

2001-10-05 Thread Correa, Orlando (ITSC)
Energy 213.244.5226 The nice thing about standards is that there are so many to choose from. -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 1:43 PM To: CF-Talk Subject: ColdFusion Server Slows down... then stops Does anyone know

RE: CF_BOOLSEARCH tag

2001-09-13 Thread Correa, Orlando (ITSC)
Look for a file named BOOLSEARCH.cfm in one of your application folders... Custom tags can be called using the syntax CF_ filename.cfm Orlando -Original Message- From: Steven Monaghan [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 8:26 AM To: CF-Talk Subject:

RE: case sensitive sql query

2001-08-30 Thread Correa, Orlando (ITSC)
If the database has been set up to do case-sensitive searching only you may have to get into something ugly like comparing individual ascii codes... For example... SELECT ColumnName FROM tableName WHERE ascii(LEFT(ColumnName,1)) = 84 AND ascii(SUBSTRING(ColumnName,2,1) = 101 etc.. etc...

RE: case sensitive sql query

2001-08-30 Thread Correa, Orlando (ITSC)
the statement at the end -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 4:50 PM To: CF-Talk Subject: RE: case sensitive sql query If the database has been set up to do case-sensitive searching only you may have to get into something

INSERTing multiple rows efficiently

2001-08-23 Thread Correa, Orlando (ITSC)
I have the following query which inserts multiple rows based on a user's choice of checkboxes in an HTML form... This batch of inserts is created by looping over the prepared statement and adding the values and creating a new insert statement for each set, then sending the batch of inserts to

RE: We've been assimilated...

2001-08-22 Thread Correa, Orlando (ITSC)
Looks like it http://www.internet-tips.net/Legal/evil_smarttags.htm -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 4:50 PM To: CF-Talk Subject: We've been assimilated... June Browser Stats (TheCounter.com) 1. MSIE 5.x 547358243

RE: UDF best practices

2001-08-13 Thread Correa, Orlando (ITSC)
/Presentations/cflp.zip Bryan - Original Message - From: Correa, Orlando (ITSC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 9:02 PM Subject: RE: UDF best practices | If I have a page request that calls several templates during the | request

RE: Zip Codes

2001-08-09 Thread Correa, Orlando (ITSC)
Any quantification of execution time for spankin fast? on the 43,000 record table? -Original Message- From: Edward Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 8:50 AM To: CF-Talk Subject: Re: Zip Codes Well, we've used it :) I just cut it out of a page, so it may

UDF best practices

2001-08-08 Thread Correa, Orlando (ITSC)
Anyone know what's the best way to set a UDF as a global function for use by all tags (custom, includes, etc.)... or does one in fact have to include the function code locally in each file that's being called during a page request? Thanks, Orlando

RE: UDF best practices

2001-08-08 Thread Correa, Orlando (ITSC)
If I have a page request that calls several templates during the request... For Example: + application.cfm + myUDF.cfm + index.cfm + cfinclude template1.cfm + cfmodule template2.cfm Should I be able to include myUDF.cfm in the application.cfm file and it will be available to index.cfm,

RE: Scope for returned variables from a tag

2001-08-07 Thread Correa, Orlando (ITSC)
Try variables. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:59 PM To: CF-Talk Subject: Scope for returned variables from a tag I can't remember what it is. I have caller in the tag to send it to the page, but I like to

CFPROC BLOCKFACTOR

2001-08-06 Thread Correa, Orlando (ITSC)
Ok... say I'm using a stored procedure that is, in this case, calling several other stored procedures to return multiple results sets back to cold fusion to reduce the number of round trips to the database... Anyone know if I would calculate the BLOCKFACTOR by adding up the lengths of all the

RE: Help with sql server

2001-08-05 Thread Correa, Orlando (ITSC)
Try prefixing your table name with the database.owner e.g. FROM mydatabase.databaseowner.report2s -Original Message- From: Neo Fusion [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 05, 2001 10:08 PM To: CF-Talk Subject: Help with sql server I have converted a access database to sql

RE: Battle of the Gurus (Re: Blatant advertising (you have been w arned))

2001-07-26 Thread Correa, Orlando (ITSC)
Make sure you shop around... $-) http://www.bookpool.com/.x/py3dqnj3im/sm/1861004540 -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 9:16 AM To: CF-Talk Subject: RE: Battle of the Gurus (Re: Blatant advertising (you have been warned)) Used

RE: date field

2001-07-24 Thread Correa, Orlando (ITSC)
You may also want do this processing in the query with a case statement checking if ISDATE(yourDateColumn). ISDATE returns 1 if the input expression is a valid date; otherwise, it returns 0. (double check syntax in SQL Server) something like: SELECT mycols, newdate = CASE ISDATE(mydate)

RE: using PreserveSingleQuotes

2001-07-20 Thread Correa, Orlando (ITSC)
Have you tried evaluating the value outside of the PSQ function... CFSET myVarWithQuotes = Trim(EVALUATE(#columnname#_#recordnumber#)) CFQUERY name=qname UPDATE tbltable SET tblfield = '#PreserveSingleQuotes(myVarWithQuotes)#' /CFQUERY -Original Message- From: Bruce,

RE: SQL2000 server not recognized by CF 4.5

2001-04-27 Thread Correa, Orlando (ITSC)
Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: Does JavaScript have a Trim function?

2000-12-19 Thread Correa, Orlando (ITSC)
function trim( str ) { // Immediately return if no trimming is needed if( (str.charAt(0) != ' ') (str.charAt(str.length-1) != ' ') ) { return str; } // Trim leading spaces while( str.charAt(0) == ' ' ) { str = '' + str.substring(1,str.length);

Compress HTML output

2000-12-18 Thread Correa, Orlando (ITSC)
Anyone know if ColdFusion supports compressing HTML output on the fly similar to Java? http://coldjava.hypermart.net/servlets/compress.htm Other than using a servlet with ColdFusion? Thanks, Orlando Correa IHS WebTeam Web Applications Developer ~~

RE: [Compress HTML output]

2000-12-18 Thread Correa, Orlando (ITSC)
Cool... I'll check it out! Thanks for the help. -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 2:20 PM To: CF-Talk Subject: RE: [Compress HTML output] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 compression is a web server issue

RE: Scenario

2000-09-14 Thread Correa, Orlando (ITSC)
You might want to take a look at the http://alive.allaire.com stuff... It may give you some ideas on how you could use realplayer in this scenario. Orlando Correa IHS Web Team Web Applications Developer, DBA http://my.ihs.gov -Original Message- From: Tim Bahlke [mailto:[EMAIL

RE: Client Variables: Variable Caching

2000-09-13 Thread Correa, Orlando (ITSC)
al Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 12:39 PM To: '[EMAIL PROTECTED]' Cc: Robar, Joseph (ITSC) Subject:RE: Client Variables: Variab

RE: I GIVE UP!

2000-09-13 Thread Correa, Orlando (ITSC)
Try Select * From CaseDetail, CaseInfo Where CaseDetail.CaseID=CaseInfo.CaseID And CaseDetail.StatusID NOT LIKE '%6%' if you have to -Original Message- From: Geno [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 11:39 PM To: [EMAIL PROTECTED] Subject: I GIVE UP! I

RE: cf_easydate is guhreat! is there a cf_easytime?

2000-09-13 Thread Correa, Orlando (ITSC)
Is there also a cf_easycolor to pop up a color box on click and let the user choose a color, then automatically fill out the input box with the proper hex color? -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:45 PM To: [EMAIL

RE: converting Word docs or PDF's to HTML

2000-09-13 Thread Correa, Orlando (ITSC)
You can drag and drop your Word document into a Frontpage2000 window (yeah I know... but anyway) and FP2000 will convert the document to RTF and then will convert the RTF document to plain vanilla HTML (no MS style sheets). Orlando Correa IHS Web Team Web Applications Developer, DBA

RE: Client Variables: Variable Caching

2000-09-11 Thread Correa, Orlando (ITSC)
, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 10, 2000 10:35 AM To: '[EMAIL PROTECTED]' Subject: Client Variables: Variable Caching Anyone have more information On page 193 of the "Developing Web Applications with ColdFusion 4.5" manual there's a couple

RE: Client Variables: Variable Caching

2000-09-11 Thread Correa, Orlando (ITSC)
in the client cache, so I think whatever the source it was slightly misinformed :)) Jeremy -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 12:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Client Variables: Variable Caching Ok... does

RE: Categories/ Sub Cats, etc.

2000-09-10 Thread Correa, Orlando (ITSC)
I used one a couple years ago at http://www.ihs.gov/misc/links_gateway/sub_categories.cfm?Sub_Cat_ID=050102. Where it uses paired numbers for each category. For example 01=computers, 0101=software, 010101=ColdFusion studio, etc... This simple method allows up to ninety-nine subcategories per

RE: Setting Dynamic Structure Variables

2000-09-07 Thread Correa, Orlando (ITSC)
ge- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 2:26 PM To: '[EMAIL PROTECTED]' Subject: Setting Dynamic Structure Variables I don't know if anyone's run into construct problems when trying to set dynamic structure variables on the fly. I'm creatin

Setting Dynamic Structure Variables

2000-09-06 Thread Correa, Orlando (ITSC)
I don't know if anyone's run into construct problems when trying to set dynamic structure variables on the fly. I'm creating a structure, other["key"]=value but I want to set the whole thing on the fly. For example this works: CFSET other["#suboption#"]=evaluate("#option#_contents") But