RE: Database of US Zip Codes

2001-03-12 Thread Brandon Behrens

Here you go.  These are at least 1.5 years old.   They seem to be reasonably
accurate.

Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com/
[EMAIL PROTECTED]

-Original Message-
From: Kent A. Orso [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 8:42 AM
To: CF-Talk
Subject: Re: Database of US Zip Codes

Check out CF_STATE on the Allaire Tag Gallery

- Original Message -
From: "JoshMEagle" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 8:52 AM
Subject: RE: Database of US Zip Codes


Anyone know of a pre-existing database of US zips/cities?

Proabably a shot in the dark, but a shot I'm willing to take.

JoshM

-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 8:26 PM
To: CF-Talk
Subject: RE: Database of US Zip Codes


Put it in a request-scoped cached query instead and you won't have any
locking worries.

best, paul

At 08:26 AM 3/9/01 +1100, you wrote:
>2. Is it good practice to have it as a query in an application.cfm (server
>or application scope)
~~
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.houseoffusion.com/index.cfm?sidebar=lists



Here you have, ;o)

2001-02-12 Thread Brandon Behrens

Hi:
Check This!


~~
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.houseoffusion.com/index.cfm?sidebar=lists



Regular Expression in CF

2000-12-28 Thread Brandon Behrens

Can anyone out there tell me how I can use a regular expression to grab an
entire script block?  Here is what I am using now:
.*|\s
This works for the following:

http://images.foxnews.com/root_js.js">

However, it won't work if there is anything inside the script blocks.  Any
help would be greatly appreciated.

Thanks,

Brandon 


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: how do I show a range of numbers?

2000-12-28 Thread Brandon Behrens

How about this:



Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com/
mailto:[EMAIL PROTECTED]

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 3:02 PM
To: CF-Talk
Subject: how do I show a range of numbers?

For example I have a  statement that looks like this:



could I do something like:


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Regular Expression in CF

2000-12-28 Thread Brandon Behrens

Can anyone out there tell me how I can use a regular expression to grab an
entire script block?  Here is what I am using now:
.*|\s
This works for the following:

http://images.foxnews.com/root_js.js">

However, it won't work if there is anything inside the script blocks.  Any
help would be greatly appreciated.

Thanks,

Brandon



~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Java and CF

2000-12-01 Thread Brandon Behrens

Java.sun.com

Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517

-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 2:22 PM
To: CF-Talk
Subject: RE: Java and CF

ok, for us dough heads (I'm probably the only one) - where would you, or
anyone else, recommend cf developers to start preparing for the new version
if they have only ever programmed in CF?

je

-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 11:18 AM
To: CF-Talk
Subject: RE: Java and CF


The performance comparison Allaire demonstrated at the Conference is not
exhaustive, of course, but, for THAT app, Allaire's new Java-based approach
out-performed its existing C++-based approach.

best, paul

At 10:39 AM 12/1/00 -0500, you wrote:
>There is no WAY a Java server can
>out perform a *well* *written* C++ server.
~~
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.houseoffusion.com/index.cfm?sidebar=lists



RE: GetTicketCount() - where and when

2000-12-01 Thread Brandon Behrens

This is probably what getTicketCount is:The number of milliseconds since
January 1, 1970, or somewhere around there.  All you have to do is set a
variable to its value where you want to start timing.  Set another variable
to the value again when you want to stop timing.  The total number of
milliseconds it took is the 2nd time minus the old time.

HTH,

Brandon

Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517

-Original Message-
From: pan [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 2:07 PM
To: CF-Talk
Subject: Re: GetTicketCount() - where and when


From: "Eric Fickes" <[EMAIL PROTECTED]>
Subject: GetTicketCount() - where and when


> Definition:
> Returns a millisecond clock counter that can be used for timing sections
of
> CFML code or any other aspects of page processing.
>
> 1.This counter is how long it took the CF server to parse the CF code.
EG,
> execution time?
> 2.Is this for the entire page, or just for code contained in between
>  and ?
>

Ticks are based on a server counter that runs the lifetime of the
current boot.
GetTickCount() returns the value of that counter when the
func is called - so it's usefulness is in terms of the diff
between GetTickCount() calls. It is not precise and is
not a diff that equates exactly to x milliseconds of cpu
time - however it is close enough. Doesn't take into
account "server/network burps" or other things that might pause
or delay server ops at the system/network level.
Use the diff under the assumption that the machine and
network are operating smoothly,  is acting on your template with
the highest priority and that there are no "burps".

It's relaible enough.

Pan
~~
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.houseoffusion.com/index.cfm?sidebar=lists



RE: UPDATE on a MS Access Database

2000-11-30 Thread Brandon Behrens

Here are a couple of things.  When you get too few parameters, you have
messed up your SQL statement:  here is where you messed up:

Checkedoutby needs single quotes around it like checked out.
I don't know  if this is mandatory or not, but you might want to switch
JobInfoUpload.FileID and #URLFileID# around.  Field names come first.

HTH

Brandon

Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database

Im trying a UPDATE on a Access database, and im getting an error



 UPDATE JobInfoUpload
 SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' = JobInfoUpload.FileID


Everything is spelled correct, but i get an error below.  I have a feeling
it has something to do with my Yes/No Column in the database.



ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the
fields included in your query exist and that you have specified their names
correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (25:1) to (25:60) in the template
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Query String: JobId=11&LoginID=1&FileID=48

~~
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.houseoffusion.com/index.cfm?sidebar=lists

~~
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.houseoffusion.com/index.cfm?sidebar=lists



RE: Get the last 12 months transactions?

2000-11-30 Thread Brandon Behrens

Take the current date.
Subtract 12 months from it
Select all records that are greater than the result

Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517

-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?

Does anyone know how to test that a date is in the last 12 months?

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

~~
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.houseoffusion.com/index.cfm?sidebar=lists

~~
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.houseoffusion.com/index.cfm?sidebar=lists



Java and CF

2000-11-30 Thread Brandon Behrens

Can CF use Java the way it can with Jrun with other application servers?

Brandon

Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:44 AM
To: CF-Talk
Cc: '[EMAIL PROTECTED]'
Subject: RE: Firewall Question

> personally, i don't agree with network admins claiming
> opening security ports is a risk. ports 80 and 25 are
> almost always open and they offer plenty of risk. the
> question really is, is the admin knowledgeable enough to
> control traffic security. companies like checkpoint (they
> might have been acquired - not sure) make/made great
> products for securing internet/network traffic.

With all due respect, I suspect you're not a network admin!

Any time you open a port, it's a risk - it's another thing that has to be
watched. There are typically limited resources for what a network
administrator can deal with, and no matter what products you buy to help
monitor security issues, they still require human guidance and intervention.
I've seen enough misconfigured firewalls to know that you can't simply buy
hardware and software to solve security issues.

The question here is, do the risks outweigh the rewards? From the network
admin's point of view, probably not - until someone convinces him otherwise.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
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.houseoffusion.com/index.cfm?sidebar=lists

~~
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.houseoffusion.com/index.cfm?sidebar=lists



CF problems with Oracle

2000-11-28 Thread Brandon Behrens

Does anyone know of any issues with Cold Fusion and connecting to a
relational database.  Also, the situation is not a direct connection, they
go out over the internet.



~~
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.houseoffusion.com/index.cfm?sidebar=lists



RE: I am ashamed to ask this question

2000-09-11 Thread Brandon Behrens

Thanks for the input Nick, but that does not quite do it.  I have a
development site and a live site.  One is dev and one is www.  I need to
know which one the user is requesting.  Is there a variable that gives the
full name of the path requested?

Thanks,

Brandon

-Original Message-
From: Nick Slay [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 9:59 PM
To: [EMAIL PROTECTED]
Subject: Re: I am ashamed to ask this question

This is a multi-part message in MIME format.
--504203CF46E683D24535EDA9
Content-Type: multipart/alternative;
 boundary="E2EF1F783A55267E2016B800"


--E2EF1F783A55267E2016B800
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F5353"
Content-Transfer-Encoding: 7bit

You can look at the cgi variable, #CGI.SCRIPT_NAME#.

Nick




Brandon Behrens wrote:

> How do you get the full path of the page the user wants ie
>
> www.xyz.xyz.cfm
>
> Thanks,
>
> Brandon
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--E2EF1F783A55267E2016B800
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



You can look at the cgi variable, #CGI.SCRIPT_NAME#.
Nick
 
 
 
Brandon Behrens wrote:
How do you get the full path of the page the user
wants ie
www.xyz.xyz.cfm
Thanks,
Brandon
-
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mai
[EMAIL PROTECTED]/
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
k">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.


--E2EF1F783A55267E2016B800--

--504203CF46E683D24535EDA9
Content-Type: text/x-vcard; charset=us-ascii;
 name="nickslay.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Nick Slay
Content-Disposition: attachment;
 filename="nickslay.vcf"

begin:vcard
n:Slay;Nick
tel;cell:0414 810284
tel;home:02 4381 0284
tel;work:02 4381 0284
x-mozilla-html:FALSE
url:http://www.webbods.com.au
org:Webbods Pty Ltd
adr:;;PO Box 4054;Copacabana;NSW;2251;Australia
version:2.1
email;internet:[EMAIL PROTECTED]
title:Technical Director
x-mozilla-cpt:;3
fn:Nick Slay
end:vcard

--504203CF46E683D24535EDA9--


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



I am ashamed to ask this question

2000-09-11 Thread Brandon Behrens

How do you get the full path of the page the user wants ie

www.xyz.xyz.cfm

Thanks,

Brandon

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



HTML strip function

2000-09-07 Thread Brandon Behrens

This is a multi-part message in MIME format.

--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello,

I was wondering if there is a built in function in CF to remove any HTML
from a string.

Thanks,

Brandon Behrens

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com


--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

http://www.w3.org/TR/REC-html40">






cid:[EMAIL PROTECTED]">


<!--
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:11.0pt;
mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->







Hello,

 

I
was wondering if there is a built in function in CF to remove any HTML =
from a
string.

 

Thanks,

 

Brandon
Behrens

 

Brandon Behrens

The =
Internet
Design Firm

512.451.=
5225

brandon@=
theidf.com

http://w=
ww.theidf.com

 <=
/p>







--=_NextPart_000_0073_01C018AE.0A58ECF0--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT: Web Objects Newsgroup

2000-08-31 Thread Brandon Behrens

Sorry about this guys, but does anyone know about a good newsgroup or online
reference for web objects?

TIA,

Brandon Behrens

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: SQL JOIN

2000-08-25 Thread Brandon Behrens

Hey guys,

Can anyone help me with this problem?  I need to send an email in text
format.  I also next to attach an HTML file.  The HML file needs to be
created when I am sending the email and contain a link that I generate on
the fly.  Any ideas?

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT: How can you programmatically keep a web browser from caching a page?

2000-08-16 Thread Brandon Behrens

How can you programmatically keep a web browser from caching a page with
HTML?

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Setting a Cookie and Redirecting the Browser

2000-08-08 Thread Brandon Behrens

Been there, done that.  I wound up using a meta tag to refresh the page with
a time of 0.  That was the only way I could get it to work.

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com

-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 3:18 PM
To: [EMAIL PROTECTED]
Subject: Setting a Cookie and Redirecting the Browser

Has anyone come up with a plausible way of setting a cookie and redirecting
the browser from within a ColdFusion 4.01 template using HTTP headers (as
opposed to META tag redirects)?

Specifically, we're trying to redirect an image call from the browser. The
image fails to load when it comes upon a HTTP "Refresh" header, and the
"Location" header seems to negate the setting of the cookie.

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Single quotes in CF

2000-08-07 Thread Brandon Behrens

Hello all,

I am wrapping up my first project in Cold Fusion and I was wondering how CF
handles the single quote issue.  Currently, whenever I insert a record, I do
the following:

Insert into (name) values(replace(argument, "'", "''")) and that seems to
work.

Should I use the preservesinglequotes function to query a value which has a
single quote in it?

Any advice would be greatly appreciated.

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Single quotes in CF

2000-08-07 Thread Brandon Behrens

Hello all,

I am wrapping up my first project in Cold Fusion and I was wondering how CF
handles the single quote issue.  Currently, whenever I insert a record, I do
the following:

Insert into (name) values(replace(argument, "'", "''")) and that seems to
work.

Should I use the preservesinglequotes function to query a value which has a
single quote in it?

Any advice would be greatly appreciated.

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Stored procedures vs other methods

2000-08-06 Thread Brandon Behrens

Hello all,

I was wondering if it was faster to execute a query in cold fusion as a
stored procedure in oracle rather than just executing a query in cold
fusion.  Any opinions, comments would be welcome.

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT: Selecting records at random in Oracle

2000-08-04 Thread Brandon Behrens

Hello all,

I don't know if this is possible but I was wondering if there was a way to
tell oracle (using cold fusion) that I wanted 3 records, but I didn't care
which ones they were.  I guess a good analogy would be you load up a page
and you want to display a banner ad, but you don't care which banner ad you
display.  Any help would be appreciated.

Thanks in advance,

Brandon Behrens

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Functions in Cold Fusion

2000-08-01 Thread Brandon Behrens

That technique sounds like trying to make lemonade from lemons to me.  Why
not just use something else

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com

-Original Message-
From: jeff tapper [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 12:17 PM
To: [EMAIL PROTECTED]
Subject: Re: Functions in Cold Fusion

Many others have addressed creating CF functions, so I'll just bite off the
part of calling java classes.

In CF 4.5, allaire introduced the ability to call java classes directly
with the CFOBJECT tag.  The biggest trick, is getting the correct jvm path
into the CFAdministrator, which involves referencing the jvm.dll directly,
rather than referencing the directory in which it resides.



At 10:39 AM 8/1/00 -0700, you wrote:
>Can I make calls to a Java class or something like that?

==
Jeff Tapper
[EMAIL PROTECTED]
Team Manager / Lead Applications Architect
http://www.gtriad.com
G. Triad
==


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Functions in Cold Fusion

2000-08-01 Thread Brandon Behrens

How about isSocial, isZip

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 10:10 AM
To: [EMAIL PROTECTED]
Subject: Re: Functions in Cold Fusion

OK, I need some community input here. For my article on custom functions,
I've written one for IsEmail and IsPhone. Can people send me a few others to
'add in'. I'd like the article to have a few pre-built functions that can be
used right off the bat. The only limits are that they must be built using
functions in CF. No tags. For example, IsPhone uses this code:
REFindNoCase('([0-9]{3}[-_. /]?)?[0-9]{3}[-_. /]?[0-9]{4}', number)

- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 01, 2000 12:42 PM
Subject: Re: Functions in Cold Fusion


> I'm currently writing an article for the next Fusion Authority (out in the
> next day) on how to write and use custom functions in CF. This is not
using
> modules or any CF tags but is actually using function calls. It's a bit of
a
> hack and can look ugly in places, but it works. The result is that I can
> have something like IsValidEmail(email) and it'll return a value that says
> yes or no.
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Functions in Cold Fusion

2000-08-01 Thread Brandon Behrens

Is there any way you could send me this article when you complete it?

Thanks,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 9:42 AM
To: [EMAIL PROTECTED]
Subject: Re: Functions in Cold Fusion

I'm currently writing an article for the next Fusion Authority (out in the
next day) on how to write and use custom functions in CF. This is not using
modules or any CF tags but is actually using function calls. It's a bit of a
hack and can look ugly in places, but it works. The result is that I can
have something like IsValidEmail(email) and it'll return a value that says
yes or no.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Functions in Cold Fusion

2000-08-01 Thread Brandon Behrens

This is a multi-part message in MIME format.

--=_NextPart_000_0016_01BFFBA4.BF744660
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-MIME-Autoconverted: from 8bit to quoted-printable by bastion.theidf.com id 
e71FbrJ27627

Hello everyone,

This may seem like a rookie question, but I cannot figure out a way to ma=
ke
my own function in Cold Fusion.  Am I missing something?  I have been
working with it for a month and haven=92t seen anything about it.  Can I =
make
calls to a Java class or something like that?

Thanks in advance,

Brandon Behrens

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com


--=_NextPart_000_0016_01BFFBA4.BF744660
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

http://www.w3.org/TR/REC-html40">






cid:[EMAIL PROTECTED]">


<!--
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:11.0pt;
mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->







Hello
everyone,

 

This
may seem like a rookie question, but I cannot figure out a way to make =
my own
function in Cold Fusion.  =
Am I
missing something?  I have =
been
working with it for a month and haven’t seen anything about =
it.  Can I make calls to a Java =
class or
something like that?

 

Thanks
in advance,

 

Brandon
Behrens

 

Brandon Behrens

The =
Internet
Design Firm

512.451.=
5225

brandon@=
theidf.com

http://w=
ww.theidf.com

 <=
/p>







--=_NextPart_000_0016_01BFFBA4.BF744660--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Multiple Select Box Troubles

2000-07-24 Thread Brandon Behrens

Dave,

Thanks for the help, but that is not quite what I am asking for.  My problem
arises when I try to figure out what elements were selected after I submit
the form.  Here is the situation.  I have one of those forms where you have
to select multiple "interests".  The value for each option is the primary
key for the interest in the database.  I need to know every value that is
selected so that I can put it in the database with multiple insert
statements.

Thanks,

Brandon Behrens

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 24, 2000 11:04 AM
To: [EMAIL PROTECTED]
Subject: Re: Multiple Select Box Troubles

This puts the selected value at the top.  Put it at it's proper place in the
list
with CFIF's.



   #output#

   1
   2
   3
   4



=
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524



- Original Message -
From: "Brandon Behrens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 24, 2000 3:53 PM
Subject: Multiple Select Box Troubles


Hello All,

I am having a bit of trouble with a multiple select box.  Could someone
please tell me how I can get every element selected from a multiple select
box.  I tried string functions and they didn't work.  I tried array
functions and they didn't work.  I think the value gets passed as a list but
I am not sure how to manipulate it.

Thanks in advance,

Brandon Behrens
[EMAIL PROTECTED]


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Multiple Select Box Troubles

2000-07-24 Thread Brandon Behrens

Hello All,

I am having a bit of trouble with a multiple select box.  Could someone
please tell me how I can get every element selected from a multiple select
box.  I tried string functions and they didn't work.  I tried array
functions and they didn't work.  I think the value gets passed as a list but
I am not sure how to manipulate it.

Thanks in advance,

Brandon Behrens
[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.