RE: Linkpoint API

2002-05-06 Thread Joseph DeVore

They would be using the CFX tag.


-Original Message-
From: Kevin Langevin [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 11:11 AM
To: CF-Talk
Subject: RE: Linkpoint API


I've used it a bit.  Are you going to use the ColdFusion app they've built,
or just the simple HTML version?  They also have Java and XML code you can
use.

-Kevin

> -Original Message-
> From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 06, 2002 2:11 PM
> To: CF-Talk
> Subject: Linkpoint API
>
>
> Anyone here ever used the Linkpoint API?
>
> Any feedback on Linkpoint's services?
>
> I have a client who might want to use them but, he would like
> some feedback
> first.
>
> Any comments/suggestions appreciated.
>
>
> Thank you,
>
>
> Joseph DeVore
> VeloxWeb Technologies
>
>
>
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Linkpoint API

2002-05-06 Thread Joseph DeVore

Anyone here ever used the Linkpoint API?

Any feedback on Linkpoint's services?

I have a client who might want to use them but, he would like some feedback
first.

Any comments/suggestions appreciated.


Thank you,


Joseph DeVore
VeloxWeb Technologies



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: checking security updates

2002-04-16 Thread Joseph DeVore

The utility is called hfnetchk.

You can read about it here:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q303215


HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Simon Whittaker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 12:45 AM
To: CF-Talk
Subject: checking security updates


Hello there,

Someone posted a url a few weeks ago which helped a sysadmin check what
patches etc were installed on a win 2k machine and what was still needed. I
have lost the address - any clues?

Cheers

Simon



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: What IDE are you using for Java CFX?

2002-04-08 Thread Joseph DeVore

Forte for Java CE is what I like.

The Community Edition is free:
http://www.sun.com/forte/ffj/buy.html


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:24 PM
To: CF-Talk
Subject: OT: What IDE are you using for Java CFX?


What IDE are you folks out there using for developing Java CFX?  I am
currently using CF Studio and the command line compiler (pain in the @$$).
I was considering buyin' a copy of JRun Studio, but wanted to see what the
masses think.  Thanks!

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]


-Original Message-
From: James McCullough [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 6:08 PM
To: CF-Talk
Subject: OT: Borland JBuilder6 for CFX


Has anyone here used Jbuilder to build CFX tags? I am trying to setup a
project environment to import the com.allaire.cfx.* classes and Jbuilder
says that it cannot find the classes. When I use the command line compiler
with the classpath attributes supplied,  the tag compiles and works. However
I don't want to use CF Studio and would like to take advantage of the
features in JBuilder. Any ideas on how to set it up? New to JBuilder.



__
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: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF-Talk-list V1 #223

2002-03-28 Thread Joseph DeVore

I hate these auto-responders!
But that's just my opinion..

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 7:23 PM
To: CF-Talk
Subject: RE: CF-Talk-list V1 #223

Thank you for the email.  I am out of the office until Monday April 1st.   I
will receive your email when I return and respond to you at that time.

If you have questions while I am out, please feel free to contact Janelle
Schneider in our Client Services Department.  She can be reached by email at
[EMAIL PROTECTED] or by phone at 206-548-9295 x10.


__
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: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Checking an email

2002-03-28 Thread Joseph DeVore

cfusion_verifymail(server, port, timeout)

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:23 PM
To: CF-Talk
Subject: RE: Checking an email


Hidden treasures =)

what are the 3 arguments that cfusion_verifymail() takes?

Thanks again,
Jeff

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:04 PM
To: CF-Talk
Subject: RE: Checking an email


its one of those undocumented hidden functions

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 5:05 PM
To: CF-Talk
Subject: RE: Checking an email


cfusion_verifymail() a UDF?

jeff

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:52 PM
To: CF-Talk
Subject: RE: Checking an email


cfpop will work fine, but you have to know the username and password in
advance.  You can use cfusion_verifymail() to determine if an address is a
mail server in the first place, but that isn't quite what the guy asked for.


I think he's looking for a CF-based way to do an SMTP VRFY.  If there's a
way to do that I'm curious to see it myself - although I agree its shut off
on a lot of servers these days.  I certainly switched it off on mine.






   ... mail acct found.  do stuff...

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: "Shawn Grover" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Thu, 28 Mar 2002 14:42:12 -0700

why not just use the pop services?  Most servers allow you to query for mail
headers without downloading the actual message itself.  You might be able to
do this through CFPOP (never used it, so I'm not sure).  If not, then you
will need to look into the POP or SMTP protocols, or another tool/component.

hth

Shawn Grover

-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:13 PM
To: CF-Talk
Subject: Re: Checking an email


Depends on the Email Server's Configuration. Its not as common to be able to
do
that nowadays as it used to be. Most of the time Email Administrators are
going
to have the vrfy command disabled on the email server.

Quoting Jeff Green <[EMAIL PROTECTED]>:

> Hi all,
>
> Is it possible to check to see if an email exists without sending the
> email
> address an actual email?
>
> TIA,
> jeff
>






__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFX_Zip Doc

2002-03-26 Thread Joseph DeVore

OVERWRITE -
Overwrite files when performing UNZIP and file already exists in destination
directory. Valid values are "Yes" and "No". Default value is "No". This
attribute is optional.

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 1:35 PM
To: CF-Talk
Subject: CFX_Zip Doc


Okay, I'm tired of searching for our copy of the doc for this tag... can
someone please tell me what the default action is when a duplicate file
is found in the destination direction for CFX_Zip (does it overwrite the
file or skip the extraction?)

Thanks!
Hatton


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Time Issue

2002-03-25 Thread Joseph DeVore

You might want to check the SMTP servers date/time

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 1:46 PM
To: CF-Talk
Subject: Time Issue


I am using cfmail to send some emails - when I receive the email it says it
was sent at 1:30 this morning instead of the appropriate time this afternoon
(that I sent it).  The system time is correct. Any ideas?

Thanks


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Whats the best way to expire session variables when browser not closed?

2002-03-23 Thread Joseph DeVore

Pardeep,

One way you could accomplish this task is to add code like this to your
Application.cfm file.


 


Any time the session information isn't available, it will send the user to a
template that you set the session variables in.

HTH,
Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 11:41 AM
To: CF-Talk
Subject: Re: Whats the best way to expire session variables when browser
not closed?


Hi, I'm having a problem using session variables. They are set to time out
at 120 (2 hours).

However if someone does NOT close his browser and then they try to come back
to the site after a couple of hours, they get an error message.

Is there a way to flush and totally expire session variables with some code
so that when they revisit after 2 hours, a new CFID and CFTOKEN are
automatically assigned?

I'm new to session variables, so maybe I'm misssing something obvious here.
Thanks.


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: asc() to identify line break characters

2002-03-22 Thread Joseph DeVore



#replace(string,crlf,'','all')#


HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 11:46 AM
To: CF-Talk
Subject: asc() to identify line break characters


I have a bunch of articles stored in a DB that need to be presented on the
web.

I'm trying to replace line breaks with and html line break.

I've tried #replace(string,chr(10),'')# and
#replace(string,chr(13),'')#   .

The strings appear with hard breaks instead of .  Are there any other
characters that can be used for a line break?
I cut and paste them into Studio, do a #asc()# on them, and they read as
"10".  Yet when I try to replace 10, nothing happens.

HELP :)

Eric Carlisle
Web Site Developer
Progress Energy IT Systems Delivery
E-mail: [EMAIL PROTECTED]
Phone: (919) 546-4739


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: HELP: Cold Fusion returns 404 when using POST (solved)

2002-03-13 Thread Joseph DeVore

-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 7:10 PM
To: Joseph DeVore
Subject: Re: HELP: Cold Fusion returns 404 when using POST


One of those little ironies of life - I found the UrlScan thing shortly
after
sending the email, after spending 4 hours trying to solve it. Argh. I had
actually fixed the problem accidentally by restoring the old IIS state, and
when
I went to reinstall UrlScan I found the log file, complete with denied
posts.
The other machine I installed it on did *not* deny posts by default. I have
no
idea why.

Thanks!

David

Joseph DeVore wrote:
>
> David,
>
> Have you checked to see if you have an URLSCAN.INI file?
> winnt\system32\inetsrv\urlscan\urlscan.ini
>
> If so, you may want to look at [options] and the [Deny Extensions] list.
>
> Also, have you checked that the .CFM application mapping in IIS?
>
> It should point to: cfusion\bin\iscf.dll and not to
> winnt\system32\inetsrv\404.dll
> You may want to check the 'All Verbs' radio button and the Script Engine
> checkbox
>
> HTH,
>
> Joseph DeVore
> VeloxWeb Technologies
>
> -Original Message-
> From: David Cummins [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 4:47 PM
> To: CF-Talk
> Subject: HELP: Cold Fusion returns 404 when using POST
>
> Hi all,
>
> We have a server here which we recently ran the IIS 5 lockdown on, and
we're
> not
> sure if this is related, but now all posts to CF pages return 404s! The
same
> pages will execute fine with a get. The site has GET, HEAD, POST and DEBUG
> enabled, so I wouldn't think it would be that. And why a 404? I might
expect
> an
> access forbidden or something, but a 404? We've done a complete CF 5
> reinstall,
> with no luck.
>
> David Cummins
>
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: HELP: Cold Fusion returns 404 when using POST

2002-03-13 Thread Joseph DeVore

David,

Have you checked to see if you have an URLSCAN.INI file?
winnt\system32\inetsrv\urlscan\urlscan.ini

If so, you may want to look at [options] and the [Deny Extensions] list.

Also, have you checked that the .CFM application mapping in IIS?

It should point to: cfusion\bin\iscf.dll and not to
winnt\system32\inetsrv\404.dll
You may want to check the 'All Verbs' radio button and the Script Engine
checkbox

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:47 PM
To: CF-Talk
Subject: HELP: Cold Fusion returns 404 when using POST


Hi all,

We have a server here which we recently ran the IIS 5 lockdown on, and we're
not
sure if this is related, but now all posts to CF pages return 404s! The same
pages will execute fine with a get. The site has GET, HEAD, POST and DEBUG
enabled, so I wouldn't think it would be that. And why a 404? I might expect
an
access forbidden or something, but a 404? We've done a complete CF 5
reinstall,
with no luck.

David Cummins


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: is there a way to get a count of elements in a list??

2002-03-10 Thread Joseph DeVore

It sounds like you are looking for the listLen() function.



HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 10, 2002 4:38 PM
To: CF-Talk
Subject: is there a way to get a count of elements in a list??


Hello everyone,

I have a list that is populated by a form sumbit and it looks like
this, but will have more names.

  

  Is there a way to count the elements in that list?

  I have a form with 10 name textboxes. A user may only submit 2. So
  my namelist will be jo, bob,,.

  What I would like is something like, and the existing functions do
  not seem to help with this:

  CFSET numberofelelents =numberofelents(namelist)


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: WAY OT: Virus or not GOTCHA

2002-03-07 Thread Joseph DeVore

Oh your suggestion is so kind.
Yeah, just go ahead and format your C drive.
That will certainly fix your GOTCHA problem (as well as any others your
system may be having)

People..


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 2:10 PM
To: CF-Talk
Subject: Re: WAY OT: Virus or not GOTCHA


is it a button on the web browser (like an HTML button)? is the button
just floating around on the desktop? try format c: to fix it.

On Thu, 7 Mar 2002, Matthew R. Small wrote:

> Hi all...
>   OK, this is ridiculous, but my boss's son got stupid and opened
> up a program that puts some sort of thing on his machine that has a
> button on it and moves when you go near it.  It says something like
> "Gotcha" when you go near it.  Any ideas what it is?  Help on how to get
> rid of it or find out what it is is appreciated.  I'm not anywhere near
> the computer, and don't intend to go near it unless the boss says to.
>
> I'm really sorry for the off topic post, but I can't find any info on
> this.
>
> Thank you,
> - Matt Small
>
>
>
>
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Spiders and Cold Fusion

2002-03-07 Thread Joseph DeVore

IMO, there is only one search engine that matters anymore and it's Google.
They clearly index CF sites since they have 17,600,000 of them listed when
you search for .cfm

http://google.com/search?hl=en&q=%2B.cfm

IMO, the people your client hired are idiots and really don't know up from
down.

IMO, Search engine safe URL's are pretty much a thing of the past.
Almost all bots index pages with query strings..

Of course it's not a bad idea to use SES URL's if you can.

In regards to creating a static site, that's more work for you.
It shouldn't be too hard either using CFHTTP and saving the files to disk.

- JD



-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 1:57 PM
To: CF-Talk
Subject: Spiders and Cold Fusion


One of out clients has hired an Internet Marketing company to help get them
more hits.

I just got a call from one of their reps, and they were trying to tell me
"Cold Fusion will not work with search engine spiders" because the pages
are "fused together".

I was ready to laugh in her face.  Does anyone know of problems with CF and
Search Engine spiders?  She wants us to generate an alternative site that
is static.


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: site performance questions

2002-03-04 Thread Joseph DeVore

FYI:
Dynamic functions take longer to parse and optimize than most functions.
Beware, your app will take a performance hit when using dynamic functions
like IIF()

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 2:09 PM
To: CF-Talk
Subject: Re: site performance questions


Not alot of performance issues, but you could consider using iif()
instead of a bunch of 




Doug Brown
- Original Message -
From: "Gilbert Midonnet" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 1:41 PM
Subject: site performance questions


> I'm redesigning a site and I have questions regarding how the use of
>  and  affects performance.
>
> 1. I have a drop-down navigation in a top frame. I would like to put
the
> graphics in the nav to change according to the section the user is in
and am
> wondering about how my alternatives affect load time.
>
> a.  For each navigation element use an if-else. If user is in
> directory A show {graphicA_on} else {graphicA_off}. If user is in
directory
> B show {graphicB_on} else (graphicB_off}.
> b. Use 
>
> 2. Each page has a hardcoded left-side navigation with each page
having the
> corresponding link highlighted. Of course this leads to maintenance
> problems. I would like to use
>
> if this.document.url = url then X else Y in an include file or
> cfapplication file.
>
>
> The coding is simple. I'm concerned about performance.  How does much
does
> this if-elses and includes slow things down? On average there are
20,000
> page hits/day.
>
> TIA
>
>
> Gilbert Midonnet
> BrokerTec USA, LLC
> (201) 209-7843
>
>
>
>
>
-
---
> ---
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission.
If
> you receive this message in error, please immediately delete it and
all
> copies of it from your system, destroy any hard copies of it and
notify the
> sender. You must not, directly or indirectly, use, disclose,
distribute,
> print, or copy any part of this message if you are not the intended
> recipient.
>
>
>
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Next/Previous???

2002-03-04 Thread Joseph DeVore

Kelly,

Take a look at my custom tag and let me know if this is what you are looking
for.
http://www.cfxtras.com/SalesComponentDetail.cfx?componentid=221

If it is, hit me up off list for a copy.

Thank you,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 8:49 AM
To: CF-Talk
Subject: Next/Previous???


Does anyone know of an unencrypted tag that will do next/previous start/end
type navigation.

The type that outputs like   <<  <   >   >>

Anyone?
-Kelly

~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
~~


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Adding text to an image

2002-02-23 Thread Joseph DeVore

I generate dynamic images using CFX_IMAGE in this example code:
http://cftags.veloxweb.com/cards/


(A while back someone asked how to dynamically generate upside down text
over a background image, so I whipped up this example)


HTH,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 23, 2002 2:32 PM
To: CF-Talk
Subject: Adding text to an image


Hi,

Is cfx_image capable of adding some formatted text to an image - I realise a
graphics program could probably do this in batches, but I ideally need CF to
manage it all

Cheers

Will


---
"A woman drove me to drink and I didn't even have the decency to thank
her." --W.C. Fields


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Multiple domains going to one webspace

2002-02-18 Thread Joseph DeVore

You just need to setup host headers.
What version of IIS you using?
I can show you how to set this up fairly easily.

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Bill Davidson [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 7:14 PM
To: CF-Talk
Subject: Re: Multiple domains going to one webspace


Rick - can you expand on this?  I can't get IIS to allow multiple sites on
the same IP.

We've been having to do a bunch of CF magic to get multiple sites to live on
the same IP.  CFlocating (as suggested by Thane) gets the beginning done,
but what about subsequent requests to a "virtual" domain require detection
and handling (like images, references to links, etc...)

Our "domain router" does the job well, but it is a bit of overhead that I
would like to avoid.

Thanks.
-Bill
brainbox

- Original Message -
From: "Rick Eidson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 18, 2002 2:23 PM
Subject: RE: Multiple domains going to one webspace


> Tell IIS to forward all request to the main URL. Its in the same place
> you
> specify Home Directory.
>
> Rick
>
> -Original Message-
> From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 18, 2002 1:24 PM
> To: CF-Talk
> Subject: Multiple domains going to one webspace
>
>
> Is there a way to have multiple domains pointed at one block of
> webspace
> and use CF to direct the person to a specific folder based on the
> domain
> typed in?
>
> Example:
> www.fred.com and www.bob.com both hosted at the same spot and space.
> But
> when I type www.fred.com I want to go to www.maindomainname.com/fred
> and if
> I type www.bob.com I want to go to www.maindomainname.com/bob.
>
> T
>
>

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



quicksell commerce

2002-02-18 Thread Joseph DeVore

Have any of you gurus used the POS software called QUICKSELL COMMERCE by
SMS?
If so, have you used it with CF or do you have any feedback on the product?

PROS/CONS/OPINIONS welcome!


Thank you,

Joseph DeVore
VeloxWeb Technologies

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: variable to reference HTML generated so far by CF Server?

2002-02-12 Thread Joseph DeVore

Ooops, validater isn't a word..

-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 11:41 AM
To: CF-Talk
Subject: variable to reference HTML generated so far by CF Server?


Is there a way of referencing all the HTML generated so
far in a request by CF Server (5)?

I'm fed up of saving out from View Source in order to
validate pages (via the W3C validator) on a locally hosted
intranet. I thought I could put an OnRequestEnd.cfm in
an app, and at the end of every request it writes the
HTML that's just about to be sent to the client to a
temporary file (same each time, e.g. 'validate.html').

Then all I need to do is view the page, go to the W3C
validator page and upload the same page each time.

How could I access the generated HTML before it gets
sent?

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: variable to reference HTML generated so far by CF Server?

2002-02-12 Thread Joseph DeVore

Sounds like you might be able to use CFHTTP and save the output to disk.
Then run your validater on the local static file.

It would more less work that same as viewing the source, saving it and then
checking it against your validation routine.

HTH,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 11:41 AM
To: CF-Talk
Subject: variable to reference HTML generated so far by CF Server?


Is there a way of referencing all the HTML generated so
far in a request by CF Server (5)?

I'm fed up of saving out from View Source in order to
validate pages (via the W3C validator) on a locally hosted
intranet. I thought I could put an OnRequestEnd.cfm in
an app, and at the end of every request it writes the
HTML that's just about to be sent to the client to a
temporary file (same each time, e.g. 'validate.html').

Then all I need to do is view the page, go to the W3C
validator page and upload the same page each time.

How could I access the generated HTML before it gets
sent?

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cf_mail, cf_NoTags and too much extra whitespace!

2002-02-12 Thread Joseph DeVore

Yes,
in the custom tags that strip out the html, wrap all non output with
CFSILENT.

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 10:11 AM
To: CF-Talk
Subject: cf_mail, cf_NoTags and too much extra whitespace!


We have an HTML and a text-only version for each of our email newsletters.
The content is pulled in from a database.  The problem is that when the
editor enters the content into the database, he occasionally sprinkles in
some HTML with it (style definitions, blockquote tags, etc)so of course
the recipients of the text-only versions get HTML in their email -- not a
good thing.  I've tried using a couple of different custom tags that will
strip out the HTML, but when those tags are run within the cf_mail tag, they
add in lots of extra whitespace -- which is fine for the HTML version, but
which really messes up the text version.  Can anyone see a way out of this?

TIA,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Linkpoint CF tag problem

2002-02-07 Thread Joseph DeVore

Pardeep,

I can help you with this, hit me up off list.

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:37 PM
To: CF-Talk
Subject: Re: Linkpoint CF tag problem


Hi, does anyone here have any experience with the Linkpoint Cold Fusion tag.

Their documentation is really poor and I can't figure out:

1. Precisely how you define the total amount for a transaction that does not
have any shipping or tax info involved.

2. Which field provides the result of the transaction and

3. The variable codes of the transaction result, i.e. 0 = declined, 1 =
approved, 2 = customer sucks, etc, etc

Again, the documentation doesn't clarify any of these points and their
online staff aren't able to help out so far. Thanks in advance if anyone has
an idea on this.

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Graphics Custom tag

2002-02-04 Thread Joseph DeVore

Check out CFX_IMAGE; you will be very happy with it once you understand it.

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Graham Lewis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 9:12 AM
To: CF-Talk
Subject: Re: Graphics Custom tag


Yes it occured to me and its a good fallback but if there is a tag that
makes it even easier

Graham

Graham Lewis
Centre for Academic Practice
University of Warwick
CV4 7AL
Tel: 024 765 73109
Mobile: 07733450022

>>> [EMAIL PROTECTED] 02/04/02 05:01pm >>>
If you're doing bar graphs you can do them easily without a tag.

The basic idea is to have a transparent 1x1 pixel gif.  Do your calculation
s on your data.then
dynamically set the height of the 1 pixel gif (and set different bgcolors
on the td's for different
bars) and manually set the width.  The gif will stretch to the desired bar
sizes.

HTH

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com

- Original Message -
From: "Graham Lewis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 8:21 AM
Subject: Graphics Custom tag


> I am stuck with CF 4.5 so do not have the luxury of CFGRAPH that comes
> with v5.  Is there a free custom tag around that will allow me to do
> simple graphs?
>
> Graham
>
>
>
> Graham Lewis
> Centre for Academic Practice
> University of Warwick
> CV4 7AL
> Tel: 024 765 73109
> Mobile: 07733450022
>


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Searching for links related to topics

2002-02-02 Thread Joseph DeVore

You can accomplish this with CF; though in my experience, I have found PERL
to be much faster.


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Melanie Maddix [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 02, 2002 1:50 PM
To: CF-Talk
Subject: Searching for links related to topics


Hi,

I have a task to complete and I was hoping you guys could tell me how
possible it is with Cold Fusion.

What I have to do is search the web for all links relating to a particular
topic, retrieve the url and site description, and save it to a database.
This is something that would be run on a regular basis, so I'd have to avoid
adding the same ones again. I've been looking at custom tags that use
google, etc., but wondered if there was a better way to go about it.

Thank you,
Melanie

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Borders in cfx_image

2002-02-02 Thread Joseph DeVore

Hey Will,

This how you could do it:







Let me know if you have any questions..

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 02, 2002 12:28 PM
To: CF-Talk
Subject: Re: Borders in cfx_image


Thanks Joseph.  Can this be used in conjunction with resizing, as below?  It
didn't seem to work just now when I tried it, although no errors were
reported either..



Will

- Original Message -
From: "Joseph DeVore" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Saturday, February 02, 2002 8:12 PM
Subject: RE: Borders in cfx_image


> Yes, it is possible to add borders to images with CFX_Image
>
> this command will set the border color:
>
> setbordercolor 00
>
> this command will draw a solid colored rectangle with the border color
above
>
> bfrect x,y,x2,y2,FF
>
>
> HTH,
>
> Joseph DeVore
> VeloxWeb Technologies
>
>
>
>
> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 02, 2002 9:58 AM
> To: CF-Talk
> Subject: Borders in cfx_image
>
>
> Hi.
>
> Is it possible to draw a thin black border around images using cfx_image?
I
> have about 100 need doing, and it would be nice to batch-process them if
> cfx_image is capable of this.
>
> Will
>
>
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Borders in cfx_image

2002-02-02 Thread Joseph DeVore

Yes, it is possible to add borders to images with CFX_Image

this command will set the border color:

setbordercolor 00

this command will draw a solid colored rectangle with the border color above

bfrect x,y,x2,y2,FF


HTH,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 02, 2002 9:58 AM
To: CF-Talk
Subject: Borders in cfx_image


Hi.

Is it possible to draw a thin black border around images using cfx_image?  I
have about 100 need doing, and it would be nice to batch-process them if
cfx_image is capable of this.

Will


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFmail Text/HTML

2002-02-01 Thread Joseph DeVore

Hey Paul,

I am the one that wrote the code you are trying to use.
I use it in many applications without any problems as do many others.

Can you send me the cfmail part of your code off list, so that I can help
you get this working correctly?

Thank you,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Paul Melanophy [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 6:07 AM
To: CF-Talk
Subject: RE: CFmail Text/HTML


Hi,

I've been trying to get this bit of code below working for an e-zing
on an estate agents web site but it does not seem to function correctly.
I am trying to send HTML formatted emails with text version as backup. I
get html to my hotmail account, text to my outlook and both to a text
only email account - anyone any ideas ?

Thanks in advance,

Paul Melanophy . . .



 Original Message 

Subject: RE: HTML EMAIL

Date: Wed, 19 Dec 2001 16:55:39 -0800

From: "Joseph DeVore" <[EMAIL PROTECTED]>

Reply-To: [EMAIL PROTECTED]

To: CF-Talk <[EMAIL PROTECTED]>

References: <[EMAIL PROTECTED]>

This code should get you on your way.

For simplicity I use 3 includes for the mime parts.

* TEXT.CFM (plain text version for text only clients)

* AOL.CFM (aol version for older version of aol - limited html tags)

* HTML.CFM (html version)









--veloxweb

Content-Type: text/plain; charset=us-ascii



--veloxweb

Content-Type: text/x-aol; charset=us-ascii



--veloxweb

Content-Type: text/html; charset=us-ascii



--veloxweb--



HTH,

Joseph DeVore

VeloxWeb Technologies



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: WDDX feeds

2002-01-31 Thread Joseph DeVore

they have a wddx section (or had if not anymore)


-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:17 PM
To: CF-Talk
Subject: RE: WDDX feeds


Yeah that's the site that I found earlier, I was hoping there might be
another site that serves WDDX news.

Or, since it's not hard to parse RDF's, does anyone know of any sites
that serves those, besides the typical Linux sites?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-----
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:13 PM
To: CF-Talk
Subject: RE: WDDX feeds


Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com




__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: WDDX feeds

2002-01-31 Thread Joseph DeVore

Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Stored proc query

2002-01-30 Thread Joseph DeVore

John,

Try:




HTH,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 3:09 AM
To: CF-Talk
Subject: Stored proc query


Hi all,

I was just wondering, the  tag returns the recordset from the
procedure.
Can you have more than one of these, if you have more than one query within
your procedure.

For instance, I call like so,










Then this is my procedure, simple like,

CREATE PROCEDURE p_Get_Customer_Vehicles

(
@customerID INT,
@cfid INT,
@cftoken INT
)

AS

SELECT  customerID, vehicleid, callsign, registration
FROMdbo.vehicles
WHERE   customerid = @customerID
AND vehicleid
NOT IN  (SELECT vehicleid
FROMdbo.vehicleSelection
WHERE   customerid = @customerID
AND cfid = @cfid
AND cftoken = @cftoken)

SELECT *
FROMdbo.vehicleSelection
WHERE   customerid=@customerID
AND cfid=@cfid
AND cftoken=@cftoken

as you can see it has two selects,

so in the stored proc call at the top, if I wanted to add another


how would I make sure  was
referencing my first select

and the second ,
 was referencing my second
select.

Thanks for any advice and help

Jmc

.
.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Studio makes me log in to 127.0.0.1

2002-01-29 Thread Joseph DeVore

I would check your development mappings.

In Studio hit F8 and then click Browse
then click the Development mappings button


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 10:41 AM
To: CF-Talk
Subject: Studio makes me log in to 127.0.0.1


Tuesday, January 29, 2002, 1:38:47 PM
Hello cf-talk,

  Just recently, when I browse in studio, it makes me log in to my
  local domain 127.0.0.1. Not always, but sometimes. It seems almost
  random. Anyone else get this?




Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: how to do Google-like search??

2002-01-29 Thread Joseph DeVore

Han,

I would suggest taking a look at SQL server's Full Text Searching and the
Verity engine built into CFAS.


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 2:01 AM
To: CF-Talk
Subject: how to do Google-like search??


Hi ppl..
is there a built in function or wat in MSSQL to perform search query
like Google..??

for example.. i need to search for "Hello beautiful World"...

how to write the query to search thru a column of a table
where the return results can be...

Beautiful Hello World
World Helllo Beautiful
Helllo World beautiful


how to do it??


han


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How do u insert data/time in SQL 2000

2002-01-28 Thread Joseph DeVore

Pardeep,

Use the GetDate() function and make sure ALLOW NULLS is *not* checked.

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 11:09 PM
To: CF-Talk
Subject: Re: How do u insert data/time in SQL 2000


In SQL 2000, what code do you type in the default field so that the current
date and time is inserted into a field.

I have one field for DATE and another for TIME so we know the date and time
a form was submitted.

Thanks.

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: where to find MS SQL Commands

2002-01-28 Thread Joseph DeVore

Yes, I agree with you.
I recommend Ben Forta's book as well.

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: list peters [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 9:48 PM
To: CF-Talk
Subject: Re: where to find MS SQL Commands


i find ben forta's "sams teach yourself SQL in 10 minutes" to be helpful.

maybe good for you because it has both transact/jet sql and oracle sql so
you can compare with what you are used to.

chad


> On the SQL server 7 CD there's "Books Online" which has massive
information
> about SQL Server..
> All of the functions and syntax you need..
>
> HTH,
>
> Joseph DeVore
> VeloxWeb Technologies
>
>
> -Original Message-
> From: han peng [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 28, 2002 5:37 PM
> To: CF-Talk
> Subject: where to find MS SQL Commands
>
>
> Hihi.. i know this is not suppose to be here...
>  but i just dunno where to find the list of SQL commands for MSSQL.
>
> its so different from Oracle command..
> sigh..
>
> Thanx in advance..!!
>
>
>
> Cheers
> han
>
>
>
>

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: where to find MS SQL Commands

2002-01-28 Thread Joseph DeVore

On the SQL server 7 CD there's "Books Online" which has massive information
about SQL Server..
All of the functions and syntax you need..

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 5:37 PM
To: CF-Talk
Subject: where to find MS SQL Commands


Hihi.. i know this is not suppose to be here...
 but i just dunno where to find the list of SQL commands for MSSQL.

its so different from Oracle command..
sigh..

Thanx in advance..!!



Cheers
han



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Check if sent

2002-01-28 Thread Joseph DeVore

Yes, you could try SMTP DSN (Delivery Status Notifications) and CFMAILPARAM
Search Google for RFC 1891 to read about it.

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 2:57 PM
To: CF-Talk
Subject: Check if sent


I have a little CF script (CFMAIL tag executed by a scheduled task in CF
Server) running on a box that emails a file to a specified mail box each
day. I also get it to cc me so that I can keep an eye on it working but I
don't want a 500K file choking up my mail box each day. Is there a way I can
validate that its sent and just get some type of validation message.

TIA!


**

Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]
www.workcover.com

p: 08 82332548
f: 08 82332000
m: 0418 806 166

**




This e-mail is intended for the use of the addressee only. It may
contain information that is protected by legislated confidentiality
and/or is legally privileged. If you are not the intended recipient you
are prohibited from disseminating, distributing or copying this e-mail.

Any opinion expressed in this e-mail may not necessarily be that of the
WorkCover Corporation of South Australia. Although precautions have
been taken, the sender cannot warrant that this e-mail or any files
transmitted with it are free of viruses or any other defect.

If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any
copies.

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Mental Block

2002-01-14 Thread Joseph DeVore

You would use CURRENTROW to find out what position you are at in the queries
recordset.

If the CURRENTROW is equal to the last record in the recordset, set the NEXT
link to 1 (which will put you back at the beginning of the recordset)

If you need a better explanation, let me know.

HTH,
Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 8:02 PM
To: CF-Talk
Subject: Mental Block


Hello Awesome List-ers,
I am suffering mental block. I cannot envision a creative solution to the
following item. I am hopeful that someone here can offer an insightful
thought trigger...

I am building a system to view documents in a few categories. You will
select a document and see that one entry. I want to have [next doc] [prev
doc] buttons to move through the other documents in the chosen category.
Trouble is that depending on the original document selected you could be in
the middle, at the end or beginning of the subset and the unique id from the
database is not sequential for the category subset.

I know I will be embarrassed when someone points out the obvious to me but I
am at an impasse. All thoughts are welcome.

Tony Gruen


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFMail and html/text

2002-01-09 Thread Joseph DeVore

Yes, I have had the same problem. That is why I wrote CFX_SMTPMAIL to send
straight to the SMTP server and skip CFMAIL and it's SPOOL altogether.. It
supports multipart messages, cc, bcc, x-headers, replyto, smtp
authentiaction, attachments and more.. It works very well when the CFAS and
SMTP server are on the same network.

Anyhow, my point really is that I agree with Sheila.

- Joseph


-Original Message-
From: Sheila Handler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 3:01 PM
To: CF-Talk
Subject: CFMail and html/text


>From experience with a project a while ago, I 'd say there would be a big
problem -- the time it takes to actually send out those emails using cfmail,
or even aspqmail.

I remember some horrendous figures like 5 hours to send out 30,000 emails.


Original message:
Date: Tue, 8 Jan 2002 09:18:27 -0700
From: <[EMAIL PROTECTED]>
Subject: Re: CFMail and html/text
Message-ID: <00a201c19860$1cae9390$5a33a8c0@webdivaw2k>

Does anyone know if there is a limit to the number of emails cf can handle
processing?  Example, if I wanted to use cfmail to send out a blast to
150,000 users, would there be a problem?





__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Open Multiple Rich Text Format (RTF) Files On One Page

2002-01-08 Thread Joseph DeVore

If you have the actual RTF code stored in the db then this could work for
you.




  


You would then need to output the output variable to a temp file and use
CFCONTENT to serve that file to the client.

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 6:47 PM
To: CF-Talk
Subject: RE: Open Multiple Rich Text Format (RTF) Files On One Page


If you have the actual RTF code stored in the db then this could work for
you.




  


You would then need to output the output variable to a temp file and use
CFCONTENT to serve that file to the client.

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Gary Groomer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 6:25 PM
To: CF-Talk
Subject: Open Multiple Rich Text Format (RTF) Files On One Page


Does anyone know how to open multiple Rich Text Format (RTF) files on one
html page?  The text for the RTF files will be stored in a database and each
file will have it's own fonts and layout that needs to be maintained.  Any
ideas would be greatly appreciated.

Gary Groomer


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Open Multiple Rich Text Format (RTF) Files On One Page

2002-01-08 Thread Joseph DeVore

If you have the actual RTF code stored in the db then this could work for
you.




  


You would then need to output the output variable to a temp file and use
CFCONTENT to serve that file to the client.

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Gary Groomer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 6:25 PM
To: CF-Talk
Subject: Open Multiple Rich Text Format (RTF) Files On One Page


Does anyone know how to open multiple Rich Text Format (RTF) files on one
html page?  The text for the RTF files will be stored in a database and each
file will have it's own fonts and layout that needs to be maintained.  Any
ideas would be greatly appreciated.

Gary Groomer

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Creating ZIP archives

2002-01-07 Thread Joseph DeVore

Ben Forta's CFX tag works great:
http://www.cfxtras.com/SalesComponentDetail.cfx?componentid=23


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Nick Texidor [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 3:39 PM
To: CF-Talk
Subject: Creating ZIP archives


Hi,

I have a requirement to zip up some image files together and FTP them to
another server.  The FTP bit is easy, but I'm wondering if anyone knows
how (or whether there are any modules) that will create a ZIP file.

Thanks

Nick


--
Nick Texidor

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFMail and html/text

2002-01-07 Thread Joseph DeVore

You may want to try putting the HTML (text/html) version before the AOL
(text/x-aol) like so:







--veloxweb
Content-Type: text/plain; charset=us-ascii



--veloxweb
Content-Type: text/html; charset=us-ascii



--veloxweb
Content-Type: text/x-aol; charset=us-ascii



--veloxweb--



HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 8:51 AM
To: CF-Talk
Subject: Re: CFMail and html/text


Why does the email send the AOL version as an attachment?

- Original Message -
From: "Joseph DeVore" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 06, 2002 10:45 PM
Subject: RE: CFMail and html/text


> Mike,
> See the code below...
>
> Nick,
> thanks for reposting this earlier.
>
> - Joseph
>
>
>
>  Original Message 
> Subject: RE: HTML EMAIL
> Date: Wed, 19 Dec 2001 16:55:39 -0800
> From: "Joseph DeVore" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
>
> This code should get you on your way.
> For simplicity I use 3 includes for the mime parts.
>
> * TEXT.CFM (plain text version for text only clients)
> * AOL.CFM (aol version for older version of aol - limited html tags)
> * HTML.CFM (html version)
>
> 
> 
> 
> 
>
> --veloxweb
> Content-Type: text/plain; charset=us-ascii
>
> 
>
> --veloxweb
> Content-Type: text/x-aol; charset=us-ascii
>
> 
>
> --veloxweb
> Content-Type: text/html; charset=us-ascii
>
> 
>
> --veloxweb--
> 
>
> HTH,
>
> Joseph DeVore
> VeloxWeb Technologies
>
>

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFMail and html/text

2002-01-07 Thread Joseph DeVore

I haven't ever seen this happen.
What server OS, version of CFAS and type of email client are you using?

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 8:26 AM
To: CF-Talk
Subject: Re: CFMail and html/text


I am testing the code below - is there something missing?  When I get the
email I get:

--veloxweb
Content-Type: text/plain; charset=us-ascii

This is the text email.

--veloxweb

Content-Type: text/x-aol; charset=us-ascii

This is the aol version.

--veloxweb

Content-Type: text/html; charset=us-ascii

This is the HTML version.

--veloxweb--





- Original Message -
From: "Joseph DeVore" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 06, 2002 10:45 PM
Subject: RE: CFMail and html/text


> Mike,
> See the code below...
>
> Nick,
> thanks for reposting this earlier.
>
> - Joseph
>
>
>
>  Original Message 
> Subject: RE: HTML EMAIL
> Date: Wed, 19 Dec 2001 16:55:39 -0800
> From: "Joseph DeVore" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
>
> This code should get you on your way.
> For simplicity I use 3 includes for the mime parts.
>
> * TEXT.CFM (plain text version for text only clients)
> * AOL.CFM (aol version for older version of aol - limited html tags)
> * HTML.CFM (html version)
>
> 
> 
> 
> 
>
> --veloxweb
> Content-Type: text/plain; charset=us-ascii
>
> 
>
> --veloxweb
> Content-Type: text/x-aol; charset=us-ascii
>
> 
>
> --veloxweb
> Content-Type: text/html; charset=us-ascii
>
> 
>
> --veloxweb--
> 
>
> HTH,
>
> Joseph DeVore
> VeloxWeb Technologies
>
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFMail and html/text

2002-01-07 Thread Joseph DeVore

If you are sending HTML mail then yes, using CFCONTENT and  you can
accomplish this.

Thank you,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 9:22 AM
To: CF-Talk
Subject: Re: CFMail and html/text


Is there a way to tell how many people actually open the email that was
sent?

- Original Message -
From: "Michael Wilson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 06, 2002 10:43 PM
Subject: RE: CFMail and html/text


> Hi,
>
> Could you post this to the list. I must have missed this while I was on
> vacation.
>
> Thank you,
>
> Mike
>
> > -Original Message-
> > You bet!!   Joseph DeVore posted exactly that a couple of
> > weeks ago.  I
> > will email it to you directly.
>

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFMail and html/text

2002-01-06 Thread Joseph DeVore

Mike,
See the code below...

Nick,
thanks for reposting this earlier.

- Joseph



 Original Message 
Subject: RE: HTML EMAIL
Date: Wed, 19 Dec 2001 16:55:39 -0800
From: "Joseph DeVore" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>

This code should get you on your way.
For simplicity I use 3 includes for the mime parts.

* TEXT.CFM (plain text version for text only clients)
* AOL.CFM (aol version for older version of aol - limited html tags)
* HTML.CFM (html version)






--veloxweb
Content-Type: text/plain; charset=us-ascii



--veloxweb
Content-Type: text/x-aol; charset=us-ascii



--veloxweb
Content-Type: text/html; charset=us-ascii



--veloxweb--


HTH,

Joseph DeVore
VeloxWeb Technologies

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Password Protecting an Access ODBC connection

2001-12-21 Thread Joseph DeVore

Not at all.

I just want to stress *DO NOT STORE PLAIN TEXT CC NUMBERS* in a db.
IMO, It's a bad, bad thing. But that's only one opinion..


Happy holidays


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 12:21 PM
To: CF-Talk
Subject: RE: Password Protecting an Access ODBC connection


thanks Joseph. i hope i didn't sound snippy. thanks for the tips.

tgif and happy holidays,
duane

-Original Message-----
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 3:09 PM
To: CF-Talk
Subject: RE: Password Protecting an Access ODBC connection


You said, "Already had that discussion, about not storing CC nums etc and
encryption
but they still want to store the cc info anyway. I was asked if it was
possible to setup some sort of secure connection the DB. I haven't used
Access outside of simple proto-typing in a long time."

In the CF administrator when you add a datasource you can enter the
databases password but if someone had access to the registry they could get
that password in no time.

Also, I didn't say don't store cc's. I said if you have to store them at I
would at least encrypt them. Especially when it's easy. It only takes a few
minutes to implement encryption/decryption and can save you a heck of a lot
more time, money and hassle later (oh and lawsuits)..

That code I sent you in my last message works great and it would not take
more than a few minutes to implement. Maybe run that by them.

Anyhow, good luck.

- Joseph


-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 10:46 AM
To: CF-Talk
Subject: Password Protecting an Access ODBC connection


A colleague asked if it is possible to password protect an ODBC connection
to an access database, but its been so long since I've used MS Access that
cant remember. Is this possible?



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Password Protecting an Access ODBC connection

2001-12-21 Thread Joseph DeVore

You said, "Already had that discussion, about not storing CC nums etc and
encryption
but they still want to store the cc info anyway. I was asked if it was
possible to setup some sort of secure connection the DB. I haven't used
Access outside of simple proto-typing in a long time."

In the CF administrator when you add a datasource you can enter the
databases password but if someone had access to the registry they could get
that password in no time.

Also, I didn't say don't store cc's. I said if you have to store them at I
would at least encrypt them. Especially when it's easy. It only takes a few
minutes to implement encryption/decryption and can save you a heck of a lot
more time, money and hassle later (oh and lawsuits)..

That code I sent you in my last message works great and it would not take
more than a few minutes to implement. Maybe run that by them.

Anyhow, good luck.

- Joseph


-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 10:46 AM
To: CF-Talk
Subject: Password Protecting an Access ODBC connection


A colleague asked if it is possible to password protect an ODBC connection
to an access database, but its been so long since I've used MS Access that
cant remember. Is this possible?

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Password Protecting an Access ODBC connection

2001-12-21 Thread Joseph DeVore

IMO, If they plan to store credit card numbers in a database *don't* do it
in plain text. Especially if it's an Access database.

What I would do at the very least is encrypt the card number before storing
it and then decrypt it when you need to use it.


This code will encrypt your card number:
CC ->    
ECC-> 556274467958045A73655A77464D7E605F5110










#encrypted#





to decrypt





#decrypted#


HTH,

Joseph DeVore



-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 11:23 AM
To: CF-Talk
Subject: RE: Password Protecting an Access ODBC connection


once the odbc connection is created on the box, if anyone knows the dsn name
they have access to the db. *I THINK* they are planning on storing CC
numbers in the db.

Duane

-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 2:09 PM
To: CF-Talk
Subject: Re: Password Protecting an Access ODBC connection


You can password protect the Access database.  I don't really understand
what you mean by password protecting an ODBC connection.

At 01:45 PM 12/21/2001 -0500, you wrote:
>A colleague asked if it is possible to password protect an ODBC connection
>to an access database, but its been so long since I've used MS Access that
>cant remember. Is this possible?


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: RE: SQL SERVER 7 FOR SALE

2001-12-20 Thread Joseph DeVore

Just to clarify so the Microsoft police don't call me up.

I bought a full version of SQL SERVER 2000 and I am selling my old full
version of SQL SERVER 7

(no upgrades involved)  :)

- Joseph




-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 6:33 PM
To: CF-Talk
Subject: OT: SQL SERVER 7 FOR SALE


Sorry for the OT.

But I just bought MSSQL server 2000 and I want to sell my MSSQL server 7 10
cal for like half price.

Any takers? Any offers?


Joseph DeVore
VeloxWeb Technologies


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: SQL SERVER 7 FOR SALE

2001-12-20 Thread Joseph DeVore

Sorry for the OT.

But I just bought MSSQL server 2000 and I want to sell my MSSQL server 7 10
cal for like half price.

Any takers? Any offers?


Joseph DeVore
VeloxWeb Technologies

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cfsilent

2001-12-20 Thread Joseph DeVore

I use CFSILENT all the time since it seriously suppresses whitespace.
I personally have not seen any noticeable time difference, just cleaner
code.

If you hear otherwise please forward me the message - I'm interested in
knowing.

Thank you,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 11:54 AM
To: CF-Talk
Subject: cfsilent


Has anyone noticed any ill effects from using cfsilent? speed reduction?

Thanks,


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cfhhttp

2001-12-20 Thread Joseph DeVore

What does your CFHTTP code look like?
What does the file that you are fetching look like?



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 11:17 AM
To: CF-Talk
Subject: RE: cfhhttp


heres the link to my entire text file:

http://webmaster.wsboces.org/test.cfm

This doesn't work. Now, if I reduce the number of links to 225 it will
work?
I checker the 226th line for anything that would cause it to error and
i
also moved the lines around and it still appears to always break after
the
225th line...

any ideaS?

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]


-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 2:12 PM
To: CF-Talk
Subject: Re: cfhhttp


Also be aware of the load time - as a timeout will kill the load.  Make

sure you allow plenty of time in the requestTimeout.

Jerry Johnson

>>> [EMAIL PROTECTED] 12/20/01 01:31PM >>>
There's definitely a 'practical' limit, since cfhttp (to the best of my
knowledge), like a cffile read, works within RAM.  It's not difficult
to
totally swamp, or even crash a server using either tag if the file is
big
enough.  Generally, it's in the megabytes.  Depending on the server and

the
CPU load, it may be many megabytes.

Jim


- Original Message -
From: "Kris Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 8:54 AM
Subject: cfhhttp


> Is there a limit to the size or amount of records that a txt file can

have
> when using cfhttp?
>
>
>
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Reading header variables in Cold Fusion

2001-12-20 Thread Joseph DeVore

If you want to read the raw headers, you can use cfhttp.

If your header is a simple value you can output it like so:
#cfhttp.responseHeader[your_header_key]#

Otherwise loop over the key array:


  
#x# - #key[x]#
  


In regards to your question, Is CFHTTP specifically used for reading text
files?
No, it can - but it is not used specifically for that purpose.

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Alan Walker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 11:11 AM
To: CF-Talk
Subject: Reading header variables in Cold Fusion


Hello All,

I am developing an application that requires variables passed from an
existing system.  The existing system is behind a firewall so I am
unable to write an LDAP query to get to the information.  The have
informed me that they can send the information needed via a set of
header variables.

Does anyone know what CF function allows you to read header variables?
I know there has been some discussion about CFHTTP but isn't that
specifically used to read a text file?

Your input in much appreciated.

Regards,

Alan Walker
Technical Lead
Vérité Multimedia, Inc.
http://www.verite.com
DVD * CD * Web * Print * Film * Sound




__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: HTML EMAIL

2001-12-19 Thread Joseph DeVore

This code should get you on your way.
For simplicity I use 3 includes for the mime parts.

• TEXT.CFM (plain text version for text only clients)
• AOL.CFM (aol version for older version of aol - limited html tags)
• HTML.CFM (html version)






--veloxweb
Content-Type: text/plain; charset=us-ascii



--veloxweb
Content-Type: text/x-aol; charset=us-ascii



--veloxweb
Content-Type: text/html; charset=us-ascii



--veloxweb--


HTH,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 4:28 PM
To: CF-Talk
Subject: HTML EMAIL


Forgive the redundancy - I saw this q answered here weeks ago yet cannot
find it in the FAQ or archives.

I am trying to nail down the syntax for HTMl formatted emails with text
version as backup. You know, the proper way to do it.

I thought about using the custom tag CF_HTMLMAIL but we are using iSMail SE
and I don't know that I can combine the two.







__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: HTML EMAIL

2001-12-19 Thread Joseph DeVore

This code should get you on your way.
For simplicity I use 3 includes for the mime parts.

• TEXT.CFM (plain text version for text only clients)
• AOL.CFM (aol version for older version of aol - limited html tags)
• HTML.CFM (html version)






--veloxweb
Content-Type: text/plain; charset=us-ascii



--veloxweb
Content-Type: text/x-aol; charset=us-ascii



--veloxweb
Content-Type: text/html; charset=us-ascii



--veloxweb--


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 4:28 PM
To: CF-Talk
Subject: HTML EMAIL


Forgive the redundancy - I saw this q answered here weeks ago yet cannot
find it in the FAQ or archives.

I am trying to nail down the syntax for HTMl formatted emails with text
version as backup. You know, the proper way to do it.

I thought about using the custom tag CF_HTMLMAIL but we are using iSMail SE
and I don't know that I can combine the two.







__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE:

2001-12-17 Thread Joseph DeVore

I just whipped this up for you - hopefully you can get the idea from this..


function calculate() {
var f1=document.x.f1.value;
var f2=document.x.f2.value;
var f3=eval(f1*f2);
document.x.f3.value=f3;
}


enter a number in the first 2 fields:







HTH,
Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 17, 2001 9:55 PM
To: CF-Talk
Subject: 


All,

Sorry to post this here.  Does anyone know of a
JavaScript lists like CF-Talk?

I'm trying to multiply two form field values and show
the result in a third without a submit action. So when
the curser moves to the third form field, the calulation
is done automatically.

Thanks for the list recommendations in advance.



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: 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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How to take only a CUSTID number from XML code

2001-12-14 Thread Joseph DeVore

Pardeep,
The example code below will do what you need very quick and easy.


  // input string
  in='http://tempuri.org/";>892028';

  // parse string
  out=rereplacenocase(in, ']*)>([^<]*)', '\2','one');


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 14, 2001 12:06 PM
To: CF-Talk
Subject: Re: How to take only a CUSTID number from XML code


How would you take out only the customer ID number from the following XML
response from a CFHTTP post:

This is the response that comes from the server we do the CFHTTP post to.



http://tempuri.org/";>892028


We need to take out only the '892028' number and insert it into our
database. Right now it tries to insert all the XML code. The customer ID is
always in the same place in the code as far as position in the code. Thanks
in advance for any help.

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



RE: Christmas cards? (OT/HTML) W/DOWNLOAD

2001-12-12 Thread Joseph DeVore

Due to the responses that I've received (many people asking me to post the
code) and seeing as how I am feeling generous since it's the holidays, I
have decided to let who ever is interested in it, download it:
http://cftags.veloxweb.com/cards/download/

Let me know if you have questions.

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: David Groth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 4:08 PM
To: [EMAIL PROTECTED]
Subject: RE: Christmas cards? (OT/HTML) W/EXAMPLE


Would you mind sharing the code on how you did this?

Thanks,



David Groth, Analyst/Programmer III
HSC Library & Informatics Center, University of New Mexico
505.272.8406  e-mail: [EMAIL PROTECTED]


~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Christmas cards? (OT/HTML) W/EXAMPLE

2001-12-12 Thread Joseph DeVore

I setup an example that actually was a lot easier than I had anticipated.

I followed the steps in my last email and it worked great.

You can test it out here:
http://cftags.veloxweb.com/cards/


FYI: You can accomplish this with less than 20 lines of code using CFX_Image


If you have any questions let me know.


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1:45 PM
To: CF-Talk
Subject: Christmas cards? (OT/HTML)


I was wondering what would be the easiest way to display text "upside down".

To print a card that you fold into shape the one quadrant needs to be
"upside down".

I was hoping there was a CSS property.. or maybe simply using CFX_Image?
Flash?

Thanks!

~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Christmas cards? (OT/HTML)

2001-12-12 Thread Joseph DeVore

I'm not sure if this is the easiest way to do it (since I'm not an IML pro)
but, you could use CFX_Image to create the original upside down image. This
image would contain the entire upside down background graphic without the
upside down text (see CFX_Image file="")

Save it to a temp file.
Write the dynamic text over the temp image.
Flip the temp image again.
Save it to disk.

You would now have an image that has a right side up background graphic with
upside down text over top of it.

If you set up the background graphic correctly this could easily work out.

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1:45 PM
To: CF-Talk
Subject: Christmas cards? (OT/HTML)


I was wondering what would be the easiest way to display text "upside down".

To print a card that you fold into shape the one quadrant needs to be
"upside down".

I was hoping there was a CSS property.. or maybe simply using CFX_Image?
Flash?

Thanks!

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: XLS as a DSNless Connection

2001-12-12 Thread Joseph DeVore

:)

Access
Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\temp\sample.mdb

dBASE III
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=21

dBASE IV
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=277

dBASE 5.0
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=533

Excel 3.0/4.0
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp; DriverID=278

Excel 5.0/7.0
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=22

Excel 97
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=790

Oracle
Driver={Microsoft ODBC Driver for
Oracle};Server=OracleServer.world;Uid=demo;Pwd=demo

Paradox 3.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=26

Paradox 4.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=282

Paradox 5.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=538

SQL Server
Driver={SQL Server};Server=myserver;Database=pubs;Uid=sa;Pwd=

Text/CSV
Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=c:\temp


Thank you,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Kurt Ward [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1:35 PM
To: CF-Talk
Subject: RE: XLS as a DSNless Connection


Excel ODBC:

ConnectionString="Driver={Microsoft Excel Driver (*.xls)};
  DriverId=790;
  Dbq=c:\somepath\mySpreadsheet.xls;
  "DefaultDir=c:\somepath;"

Excel OLEDB via MS Jet

ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;
  Data Source=c:\somepath\myExcelSpreadsheet.xls;
  Extended Properties=""Excel 8.0;HDR=Yes;"";"




-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 4:33 PM
To: CF-Talk
Subject: RE: XLS as a DSNless Connection


If you are running CFAS 5.0:


   ...


FYI: Connect string properties are specific to the database you are
connecting to

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1:17 PM
To: CF-Talk
Subject: XLS as a DSNless Connection


Hi All,

Does anyone have a code snippet that shows how to connect to an excel spread
sheet as a dnsless connection?

Thanks,
Duane



~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: XLS as a DSNless Connection

2001-12-12 Thread Joseph DeVore

If you are running CFAS 5.0:


   ...


FYI: Connect string properties are specific to the database you are
connecting to

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1:17 PM
To: CF-Talk
Subject: XLS as a DSNless Connection


Hi All,

Does anyone have a code snippet that shows how to connect to an excel spread
sheet as a dnsless connection?

Thanks,
Duane

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Double Precision FP's

2001-12-11 Thread Joseph DeVore

Have you tried the numberformat() function?

numberformat("0.494994344721917",'.9999')

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Fred Anderson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 8:47 PM
To: CF-Talk
Subject: Double Precision FP's


Does anyone know how to work with double precision floating point (64
bit) number in Cold Fusion?
Numbers such as this 0.494994344721917 Cold Fusion seems to chop these
off after 12 significant digits. This is all well and good when
calculating sales tax on your grocery list. But when you convert it
hex/binary the last 2 bytes are wrong. One last thing, I need to call
this about over 1,000 times when running the script.
Thanks, Fred

Fred Anderson
[EMAIL PROTECTED]



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



RE: Page processing twice

2001-12-10 Thread Joseph DeVore

when you use cfmodule are you using a closing tag?


Or are you using closing tags in any of your CT's?
If so that will make the page execute twice.

HTH,
Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 4:25 PM
To: CF-Talk
Subject: RE: Page processing twice


> Are you using CFMODULE or any custom tags?
> It's possible that it's loading twice because of thistag.executionmode

I'm using cfmodule in several locations but at no point am I using, setting,
or testing executionmode in the site at all


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Page processing twice

2001-12-10 Thread Joseph DeVore

Are you using CFMODULE or any custom tags?
It's possible that it's loading twice because of thistag.executionmode


Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 3:43 PM
To: CF-Talk
Subject: Page processing twice


Anyone know what might cause a ColdFusion page to process twice?

I'm using cflocation to redirect to a page that then does a CFHTTP post
request.

This page, post request and a subsequent query both get processed twice.

I've eliminated all the obvious solutions (no header refresh commands, no
multiple requests to any includes) and we've even added a cfabort command at
the end of the code and while it does abort the process it still runs the
page twice.

Any ideas would be greatly appreciated.


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



RE: OT: Keep search engine spyders from following links

2001-12-10 Thread Joseph DeVore

Jim,

It is possible to UNICODE HREFs and a lot of bots ignore these types of
links. I use unicoded HREFs for all of my email addresses so spam bots don't
grab them. I haven't tested unicoded HREFs in all browsers, just Netscape
4.08 and IE 4+ on Windows

If you want to take a look at a unicoded href you can use this form to
generate them:

http://cftags.veloxweb.com/unicode/


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 3:35 PM
To: CF-Talk
Subject: Re: OT: Keep search engine spyders from following links


IIS.  What exactly would the ISAPI application do?

I suppose within my redirection template I _could_ parse the cgi.useragent
string and neither record nor redirect known spyders.  Keeping an up-to-date
list of agents might be a pain, though.  I'd rather just tell the syders
(even if only the well-behaved ones) not to follow the link.

Jim


- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 10, 2001 3:39 PM
Subject: Re: OT: Keep search engine spyders from following links


> what's your web server? You can write an apache module to do this and I
> would assume you could do the same with ISAPI
>
> On Mon, 10 Dec 2001, Jim McAtee wrote:
>
> > On a couple of web pages, I run links to outside web sites through a CF
> > template that records the click-through along with some browser and
referer
> > stats in a table, then redirects the browser to the target URL.  Is
there
> > any way to prevent search engine spyders from following these links?  If
I'm
> > not mistaken, there's no way to use a robots.txt to prevent this
behavior,
> > or is there?
> >
> > Thanks,
> > Jim

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How do people work around the current limited cfmail

2001-12-10 Thread Joseph DeVore

That's what I wanted to hear!
Thanks~

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 1:07 PM
To: CF-Talk
Subject: Re: How do people work around the current limited cfmail


Joseph DeVore wrote:

> Hey Jochem,
>
> Off hand do you know how many email messages your custom tag can handle
per
> day? I like the idea of having the SMTP server do what it does best. What
> are the cons to using this tag aside from the undeliverables?


I have heard numbers between 15 and 40 per second (1 to 3 million a day
roughly). If that isn't enough you should have a look at using a
RAM-drive for the pickup dir since I/O seems to be the limiting factor.

Jochem

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How do people work around the current limited cfmail

2001-12-10 Thread Joseph DeVore

Hey Jochem,

Off hand do you know how many email messages your custom tag can handle per
day? I like the idea of having the SMTP server do what it does best. What
are the cons to using this tag aside from the undeliverables?


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 12:26 PM
To: CF-Talk
Subject: Re: How do people work around the current limited cfmail


Larry W. Virden wrote:

> from: "BILLY CRAVENS" <[EMAIL PROTECTED]>
>
>>Easily done - CFSCHEDULE  a task that checks the undeliverable folder,
loops
>>through the files, and emails them to whoever, and then deletes them from
>>the folder
>>
>
> Not so easy, since it is relatively difficult, as far as I can tell, to
> determine what application generated the mails - or did I miss
> an option somewhere?


No you didn't, it is something that has to be explicitly enabled, for
instance by writing it as a header in the email.

As a hosting provider I require everybody using cfmail to write 2 extra
headers for each email.

Header number 1 is the X-Originating-IP which should always read
#cgi.remote_addr# to track down people abusing (badly designed) email
facilities.


Header number 2 is the X-Complaints-To header which should have the
emailaddress of either the webmaster or the postmaster of the site.
This header is intended to make sure that even people that host without
their own domain get to handle their own email complaints.

But the Complaints header gives a nice second option. Policy is to run a
scheduled script at midnight which reads the contents of the undelivr
folder. Each individual email is parsed for the presence of an
X-Complaints-To header. If present the reason for the email being
undeliverable is parsed from the mail.log and the email together with
the reason are send to the X-Complaints-To address and are no longer my
problem.

People have been informed that email without an X-Complaints-To header
that is found in the undelivr directory will be deleted.

And the second way to solve the problem is that I have modified
cf_advancedemail to be able to write to the pickup dir of any SMTP
server, some of which perform quite a bit better than dart.dll. But
processing of undeliverable emails remains the same.

Jochem

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



RE: using ASPMail component

2001-12-10 Thread Joseph DeVore

If you output objMail.Response you will see what the error is.

It might tell you something like "This evaluation component has expired."


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: nagraj [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:49 AM
To: CF-Talk
Subject: using ASPMail component


Hi  C'Fers,

I am trying to use the aspcomponent given by  www.serverobject.com I written
the following code in my page
It is really driving crazy, The code is as follows,




















CWebException: Error: Attempting to call a method as a PROPERTYGET
assignment. For methods with no arguments please use empty parenthesis !
Explanation:

unknown error while executing a tag.

I tried same using CDONTS. I simply worked out with out any problem.

Any Help is really appreciated.

With Regards

Nagaraj.A


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Accessing ColdFusion Execution Time Values

2001-12-09 Thread Joseph DeVore

If it's a query in question you can use cfquery.executiontime

If you want to know how long an entire template took to process you can use
gettickcount(). You can also turn on debugging in the CF Administrator for
much more useful debugging info.




  
  




Execution Time #exectime# MS


Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Christopher Dawes [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 09, 2001 5:00 PM
To: CF-Talk
Subject: Accessing ColdFusion Execution Time Values



  Does anyone know of a way to access the coldfusion server execution
  times or the processing time data?

Christopher Dawes
Dawes International

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


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



RE: IIS Issue

2001-12-07 Thread Joseph DeVore

In IIS there is a section on the 'Web Site' tab when viewing the properties
of a web site

It says 'Connections' and under it are 2 radio buttons.

Have you checked to see if it has a low number in the 'Limited to:' field?


Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Benjamin Falloon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 7:25 PM
To: CF-Talk
Subject: OT: IIS Issue


Hi all,

Does anyone have this problem and know how to solve it...

IIS Issue:
I've just reinstalled windows 2000 with IIS 5 as a development
workstation/server running CF 4.5. Every now and then, I get a error:

Error Message: Access Forbidden: Too Many Users Are Connected 403.9

Now this is really impossible because its just me viewing web pages... just
localled refreshing the same document every now and then...

The problem seems to be preceeded by the pages not loading correctly i.e.
not all of the graphics will load and refreshing doesn't help this... and
then the error message occurs and I cannot get any pages.

At this point, I try to restart IIS to solve the problem and this fails
saying the the services IIS did no start in a 'timely fashion'

It's annoying the hell out of me... I have to restart my machine each time
and then I get about 20 mins of productive time before it occurs again

Any help would be greatly appreciated!!

Benjamin



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



RE: Custom Tag to resize JPG on the fly...

2001-12-07 Thread Joseph DeVore

CFX_IMAGE by Jukka Manner can do this for you.

You can download it from Lewis Sellers website at
http://intrafoundation.com/3rdparty/CFX_Image.zip


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 2:10 PM
To: CF-Talk
Subject: Custom Tag to resize JPG on the fly...


I have been looking on the Allaire website for a tag to thumbnail JPG
images on the fly.  I've found one that does GIF, but I need JPG.
Anyone know of a good one that they can recommend?  I must admit that
I'm tacaño(AKA cheap), and I'm looking for a free one.

Thanks,
Jared


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



RE:

2001-12-06 Thread Joseph DeVore

Gonzo

You just need to set a variable and focus. That way if the user clicks a
link for help, the window will always focus and return to the front.

var helpdoc=window.open(...)
helpdoc.focus();


Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 9:16 PM
To: CF-Talk
Subject: http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Random passwords

2001-12-06 Thread Joseph DeVore

sorry, cf-talk chopped the code from last email:
http://cftags.veloxweb.com/passwords.cfm

It's a custom tag called CF_RandomPassword
written by Rob Bilson ([EMAIL PROTECTED])

HTH,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 10:56 AM
To: CF-Talk
Subject: RE: Random passwords


uh what code would that be? :) seems to have gotten cut off

-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:52 PM
To: CF-Talk
Subject: RE: Random passwords


This code will generate mixed case passwords:


http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Random passwords

2001-12-06 Thread Joseph DeVore

This code will generate mixed case passwords:


http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Problem converting expression result to a string in a URL

2001-12-05 Thread Joseph DeVore

Pardeep,

The error message sounds like you are trying to output a variable that isn't
a simple value.

The function isSimpleValue() will tell you if is or not.


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 4:48 PM
To: CF-Talk
Subject: Re:Problem converting expression result to a string in a URL


Am having a problem getting a variable to show up in a URL link. Can't
figure out what the problem is:

Error Occurred While Processing Request
  Error Diagnostic Information
  Expression result cannot be converted to a string

  Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must
evaluate to a value that can be converted to a string for output or dynamic
text accumulation purposes. Complex objects, such as queries, arrays, and
COM/DCOM objects, cannot be represented as strings.

  The error occurred while processing an element with a general
identifier of (#sideimage#), occupying document position (138:62) to
(138:72).


  Date/Time: 12/05/01 15:52:55
  Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)




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



RE: CF And Images

2001-12-04 Thread Joseph DeVore

Lewis Sellers has a cool *free* CFX tag that does this:
http://intrafoundation.com/freeware.html#cfx_imageinfo

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Double Down [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 8:56 PM
To: CF-Talk
Subject: CF And Images


Does anyone know if or how Cold Fusion can read the dimensions of an
image in a gif or jpg format?

Thanks



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



RE: Evaluate function

2001-12-04 Thread Joseph DeVore

Leon,


  
  

  
  #evaluate("#i#_ListVals")#



Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Leon Greeff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 1:50 AM
To: CF-Talk
Subject: Evaluate function


Hi there,

I am trying to use the evaluate function to output dynamically created
variables. Ex. I have a list say list=a,b,c,d I want to create variables
from it.

loop through list a,b,c,d

I want to create variable named a_ListVals and b_ListVals and c_ListVals
etc.


Can someone give me some advice how to do it.

TIA


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



RE: first web db with coldfusion5

2001-12-02 Thread Joseph DeVore

It looks like you need to add some logic to dynamically build your SQL
statements

Basically, check if a field exists; if it exists then add that field to your
sql statement

This code might help you get the idea:


  select departments.department.name, employees.firstname
  from departments, employees
  where departments.department_id = employees.department_id

  
   and departments.department_name = 'form.department_name'
  



Refer to the CFDOCS for more info.

- Joseph



-Original Message-
From: Spaminator [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 02, 2001 1:42 AM
To: CF-Talk
Subject: RE: first web db with coldfusion5


I've got a book and finally found the info in it to get started.

Using the drop down wizard i was easily able to create the search and
results pages.

Only problem is each field is required for searching, if any fields are
blank im getting errors.

How can i modify the code so these fields are not required?

The search page is at:
http://www.sapaa.com/memdb/sapaa_search.cfm

Thanks,
Sean

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 01, 2001 9:04 PM
To: CF-Talk
Subject: RE: first web db with coldfusion5


Picking up a copy of one of the many ColdFusion development books would be a
great first step and would get you on your way real fast. Bookpool
http://www.bookpool.com tends to have the best prices from what I've seen
but all the major book sites offer a range of CF books.

Ken




-Original Message-
From: Spaminator [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 01, 2001 11:28 PM
To: CF-Talk
Subject: RE: first web db with coldfusion5


I've done some other database driven sites but nothing in coldfusion.

I now need to host a simple access file and make it searchable. I have cold
fusion studio 5 and macromedia ultradev 4.

Can any point me in the right direction for doing that?

Thanks,


Sean Percival
Owner
Paragon Matrix - Web and Graphic Design
877.498.6072 - phone
[EMAIL PROTECTED] - email
[EMAIL PROTECTED] - wireless email
www.paragonmatrix.com - web



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



RE: Rounding a value UP

2001-11-26 Thread Joseph DeVore

The CF function you are looking for is
ceiling()

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Benjamin Falloon [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 7:56 PM
To: CF-Talk
Subject: Rounding a value UP


Hi all,

Who knows the function for rounding UP to the nearest number?
Eg. If I have the number 2.33 etc, what's the CF syntax for rounding
this number UP to 3 (instead of  down to 2)?

Thanks in advance,

Benjamin Falloon

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How do u send color & text fallover emails

2001-11-22 Thread Joseph DeVore

Pardeep,

Basically you need to create a multipart message.
If the client can *not* read HTML then they will see the ASCII text version
of the message.

You can create includes or you can hard code the different messages.
This should get you on your way:






--MULTIPART_BOUNDARY
Content-Type: text/plain; charset=us-ascii



--MULTIPART_BOUNDARY
Content-Type: text/html; charset=us-ascii




--MULTIPART_BOUNDARY--




Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 22, 2001 10:35 PM
To: CF-Talk
Subject: How do u send color & text fallover emails


Need to send color and text emails, so that the recipient sees one of the
two depending upon their email client. i.e. AOL users typically cannot see
HTML emails.

Does anyone know of a good solution or tag to accomplish this. The ones on
the Allaire site so far are very buggy and don't work. Appreciate any tips.

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



RE: Suppressing white space

2001-11-21 Thread Joseph DeVore

If the code is just logic and you aren't outputting anything then wrap it in
 

This will suppress all CFOUTPUT and whitespace.

If you need to output something that's in the code block, consider setting
variables and outputting them after the closing 

That's what I do anyhow.


Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 8:09 PM
To: CF-Talk
Subject: Suppressing white space


I have a page that when rendered in netscape, has about 1000 lines of
whitespace. what is the best way to suppress it? I have enabled suppress
whitespace in CF Admin, but no help.




http://www.carnivorepc.com";>


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: VTM Files

2001-11-21 Thread Joseph DeVore

This message is to simplify my last example since it was a bit much to
understand:

Add the ColorPicker control (to the panel container)




Then you just need to output the value of the users selection where you want
it:


$$SpacingGap$${DefaultCase('color')}="$$colorColor"




Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 6:01 PM
To: CF-Talk
Subject: Re: VTM Files


> Ummm...are you talking CF Studio?  It already has a colour picker built in

I realize that, but when the user selects 'Edit Tag' and pulls up the
tageditor dialog, I want them to fill one of the fields with a color value.
How can I access the color picker from within the VTM?

Thanks,
Steve


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: RDS

2001-11-21 Thread Joseph DeVore

RDS needs to be running on the target server.
You need CF Studio.

In studio go to Allaire|Macromedia FTP & RDS
Right click, choose add RDS server
Enter a description for this RDS connection.
Enter the target servers IP.
Enter the CF studio password (if set in CFAS admin)
Click OK

You should now have an RDS connection in studio.
If you don't see it, click on the Allaire|Macromedia FTP & RDS and hit F5
This will refresh your list of RDS/FTP servers.

Click the plus next to the RDS:// server that you just created.
If you have the correct permissions you should see a list of drives.

Select your webroot's drive and drill down to the directory you want to work
in.


HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 7:09 PM
To: CF-Talk
Subject: RE: RDS


Do you have to setup RDS?  If so, can you point me to some documentation to
do it?

Mike


-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 8:47 PM
To: CF-Talk
Subject: Re: RDS


Mike,

What makes it more useful than mapped network drives and FTP is that you
can view database connections through it... That's what the database tab
in Studio is for.

HTH,
K.

"Bryan Love" <[EMAIL PROTECTED]> wrote:
> It stands for Remote Development Server.  Basically you can set up a
> machine to be a remote development server and then connect to it with
> CF Studio. The whole thing is similar in concept to a VPN connection.

> -Original Message-
> From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 21, 2001 3:57 PM
> To: CF-Talk
> Subject: RDS
>
>
> Hi everyone.. Happy Thanksgiving.
>
> This is going to sound very weird to a lot of people, but what exactly

> is RDS and how does it work? I know when I work on my desktop and work

> with files on different servers, the drives are mapped so I just
> access the remote files via the mapped drive. Also, I connect via FTP
> through CF studio. I guess I reall just do not know what RDS is.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: VTM Files

2001-11-21 Thread Joseph DeVore

Steve,

This VTM code will do exactly what you need.

You'll be using a built in control called ColorPicker.

You'll have to open the VTM file that you want the colorpicker in and add
the control and attributes.

If you want to test this file save it as colorpicker.vtm and place it in:
DRIVE:\Program Files\Macromedia\ColdFusion Studio
5\Extensions\TagDefs\Custom
or
DRIVE:\Program Files\Allaire\ColdFusion Studio 4.5\Extensions\TagDefs\Custom

If you have questions, let me know.


It's pretty simple if you examine the code below:






















SELECT A COLOR FROM THE LIST






















<$$tagname
$$SpacingGap$${DefaultCase('color')}="$$colorColor"

$$SpacingGap$$TAGDATAUnknownAttributes
>




Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 6:01 PM
To: CF-Talk
Subject: Re: VTM Files


> Ummm...are you talking CF Studio?  It already has a colour picker built in

I realize that, but when the user selects 'Edit Tag' and pulls up the
tageditor dialog, I want them to fill one of the fields with a color value.
How can I access the color picker from within the VTM?

Thanks,
Steve


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



RE: What is wrong with this CFIF Date Calculation?

2001-11-21 Thread Joseph DeVore

Why don't you use the datecompare() function?

datecompare() performs a full date/time comparison of two dates.

It returns:
-1 if date1 is less than date2
0 if date1 is equal to date2
1 if date1 is greater than date2


You can set the optional datepart parameter as well.


less than

greater than

is equal



Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 4:43 PM
To: CF-Talk
Subject: Re: What is wrong with this CFIF Date Calculation?


You are missing a # in your dateFormat



DB



- Original Message -
From: "Brunt, Michael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 4:24 PM
Subject: What is wrong with this CFIF Date Calculation?


> I am trying to validate a date change point and am getting an objection
from
> CF in using LT can ayone see what I am doing wrong here?
>
> 
>
> Mike Brunt
> Sempra Energy
> 213.244.5226
>
> "Prediction is hard, especially when it's about the future."
>
>
>

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Studio memory leaks.

2001-11-21 Thread Joseph DeVore

I'm with you William.
Aside from the part of CF5S not ever crashing.

I have crashed CF5S ten or so times since I bought it.


Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 4:32 PM
To: CF-Talk
Subject: Re: CF Studio memory leaks.


Then you're just lucky ;)

Its died on me STUDIO 3, 4, 4.5 .1 2. 3. 4.4 .4.5 all the way upto 5 :)
still leaks

leaked on 98
on 98SE
on ME
on 2000
on NT
on XP :)

It never crashes on me anymore with studio 5 but it F's up at the worst
times :) when it wants to be restarted lol

but never dies on me anymore


Bill Wheatley
Director of Development
Certified Advanced ColdFusion 5 Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645
- Original Message -
From: "Kevin Langevin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 6:37 PM
Subject: RE: CF Studio memory leaks.


> Strange...I use Studio via RDS with a server I have colocated all the
time,
> and Studio 5 hasn't ever crashed on me.  Not once since I started using
it.
>
> I'm running Win2K Server on my dev machine and Advanced server on the
remote
> machine.
>
>
> Kevin Langevin
> Web Guy In Charge
> UsWebGuys
> 954-327-5780
>
>
> -Original Message-
> From: Maureen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 21, 2001 6:33 PM
> To: CF-Talk
> Subject: RE: CF Studio memory leaks.
>
>
> At 09:26 AM 9/28/01 Michael Brunt wrote:
> >CF Studio 4.5 runs very well on Win 2k and I've used it on 98, NT, ME.  I
> >certainly don't see it as any more "buggy-ass" than any other
html-CF-style
> >sheet editor out there.  In fact Homesite-CFStudio are without doubt the
> >best IDE tools around, they at least do not insert extraneous html tags
all
> >over the place and once you get into VTML the options are amazing. As I
> said
> >CF 4.5-Win 2k is very stable in my experience.
>
> I think if you just use Studio, it's ok.  But if you use the RDS feature
of
> Studio, or the debugger, or the validator, it leaks like a sieve, on all
> versions of the OS.
>
> I've been begging Allaire for a fix for this since 4.5 first hit, without
> luck.  So I reverted to Studio 4.0.  It still crashes, but not as often,
> and usually only if I have a Microsoft application open as well.
>
> This is my absolute biggest gripe with any Allaire product.
>
>
>

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Fusebox - opinions?

2001-11-20 Thread Joseph DeVore

Costas,

Not that you care, others might - the following email is from one of the
founders of Fusebox, Steve Nelson.

His message is in regards to the '6174' counter on the FB site.

Steve says, "That's just the number of people that have created accounts on
Fusebox.org. Since there isn't much of an incentive to create accounts, that
number is probably pretty low. The point of it is that people ARE
standardizing on the free Fusebox framework and that number grows every day.
Hell, it's 6191 right now.

A friend of mine once told me: "You know you're famous when people start
suing you". I wouldn't worry too much about people bashing Fusebox. Bad
press is still press. In the four years I've been doing this, I've found
that people that bash Fusebox tend to bash everything anyway. Very few of
them have looked at Fusebox very closely.

Tell this guy to join in the Fusebox community and voice his concerns on the
Fusebox list. The Fusebox community listens to ideas, if they're good ones,
we
add them into the spec. Nothing will get changed by voicing concerns on
cf-talk."

- Steve Nelson


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 3:07 PM
To: CF-Talk
Subject: RE: Fusebox - opinions?


Here's a quote from fusebox.org:

Fusebox is a FREE web application standard in use by 6174 people from around
the world

6174.  Around the world.  Hmmm...  I know there's 100 or so active cfug
members in Vancouver, BC.  Given the amount of metropolitan areas in US and
Canada, not to mention parts of Europe, I'd think that number is kinda
small...

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 2:26 PM
To: CF-Talk
Subject: RE: Fusebox - opinions?


> I think the difference is that there is a good chance that an outside
> contractor might already know Fusebox.  That won't be the case for
> something custom.

Maybe this is a regional thing but none of the developers I know use Fusebox
at all. Just how many people actively use fusebox?

I hear people mention that developers or contractors will be familiar with
it but has anyone ever done any sort of polling to determine this?

If not its mostly just an anecdotal comment isn't it?


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



RE: SSL

2001-11-20 Thread Joseph DeVore

It depends on how you registered the certificate.
When you bought it, they asked you what the domain name it would be used for
was.

In my case 'secure.veloxweb.com'.

If I try to use any domain other than 'secure.veloxweb.com' it prompts the
client with a certificate mismatch warning.


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 9:23 AM
To: CF-Talk
Subject: OT: SSL


Sorry for the OT question:

Is one SSL certificate valid for one whole domain, or is it valid only
for one fully qualified domain name?

i.e., is it valid for *.mydomain.com, or only mysite.mydomain.com?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Calling all Fusebox Developers

2001-11-19 Thread Joseph DeVore

You should bring this question over to the Fusebox list.

[EMAIL PROTECTED]
[EMAIL PROTECTED]


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 6:43 AM
To: CF-Talk
Subject: Calling all Fusebox Developers


I have a fusebox application that is kickin my butt. It is a simple issue to
resolve I am sure, but I am having a heck of a time with it, and I have too
many other projects to work on. I am willing to pay someone to look at this
and make it work. Please get with me OFF LIST ([EMAIL PROTECTED]) and I can
provide more details.

Thanks,


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How do u prevent pages from caching or how do u auto-refresh pages?

2001-11-19 Thread Joseph DeVore

Pardeep,

Yes, it's quite simple with CFML.

Set the header to expire automatically before the page loads using the
CFHEADER tag.



This will make the browser load fresh content and tell it not to cache it.

Also if you want you can add this META tag to your HTML:




HTH,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 5:40 PM
To: CF-Talk
Subject: How do u prevent pages from caching or how do u auto-refresh
pages?


Does anyone know how to prevent pages from caching in a browser?

Or how to refresh pages in a manner that works in all the browsers? By
refresh I don't mean you massage the page visualizing a Swedish model, but
rather the page is reloaded along with any new versions of graphic files
that have the same file name.

Ideally a CF solution would be better, since some folks may not have
javascript, but I'm open to anything that works.

Thanks,
Pardeep.

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



RE: cfquery and two column output

2001-11-18 Thread Joseph DeVore

You want to split 30 records into 15 in each column?
If that is what you are saying then, this might help.
Let's say your query is named 'q' and it has columns 'title' and 'body' with
30 records total.








#q.title[i]#
#q.body[i]#








#q.title[i]#
#q.body[i]#








Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 18, 2001 10:34 PM
To: CF-Talk
Subject: cfquery and two column output


Hello Everyone.

I have a query that returns say 30 records.  What I am attempting to do is
output the records in two columns but I am not having much luck.
Can someone point me in the right direction?

TIA,
Mike


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Can't send form data with spaces in Netscape 4.61

2001-11-18 Thread Joseph DeVore

Pardeep,

Send me your code off list so I can help you out.
It's pretty quick and easy.


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 18, 2001 4:53 PM
To: CF-Talk
Subject: Can't send form data with spaces in Netscape 4.61


I'm unable to send form data with spaces in Netscape 4.61

Is there a way to URL encode it and then URL decode the message in the
receiving file?

Or is the solution to send to a redirect file with URL encode added to a URL
going to the processing script?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Fusebox - opinions?

2001-11-18 Thread Joseph DeVore

Costas Piliotis,

IMO, The Fusebox 3.0 methodology Rocks!
http://fusebox.org

Have you taken the time to read the spec or create any applications?
Even when NEO comes out, not everyone will have the means to upgrade.

No matter which route CF takes, Fusebox makes a better developer!
It will change the way you plan and code your applications even if you don't
decide to use the methodology.

If you take the time to check it out, I'm sure you will agree!

Gyrus, I would encourage you to read the new spec and forget the book and
it's reviews.
(The book is old and covers Fusebox 1.0)

If you want to purchase something to help you with Fusebox check out the
'Conference in a Box' from Hal Helms: http://halhelms.com/

CIAO,

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 18, 2001 12:49 PM
To: CF-Talk
Subject: RE: Fusebox - opinions?


Since everyone has put their two pennies in...

Fusebox is a nice idea.  IMHO though, Cold Fusion was never intended for
structured programming in the modern, object oriented terms.  New will have
cf classes and stuff, so fusebox may or may not be the way to go.

Here's the best thing about cold fusion:  It allows developers the
flexibility to design using the methodology they deem appropriate.  There
are no "rules" in cold fusion (other than the cf tags and functions).

I'd check the specs on neo (cf6) and hold off.  Fusebox is a methodology
that may not bode well with the stuff in cf6.  Just suggesting you be
careful.

-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 6:41 PM
To: CF-Talk
Subject: Fusebox - opinions?


OK, I think I'm on the verge of knuckling down and getting friendly with
Fusebox for CF. Glancing through the PPT presentations, it seems pretty
cool, and quite close to the systems I've developed anyway, only better
organised :)

A few questions for everyone out there who uses Fusebox:

1. Pros? Cons? Opinions? I've generally only seen good
feedback, but I thought I'd see...

2. Is there any good documentation/literature? I think the
PPT presentations should get me going, but I know I'll
want something a little meatier. I was going to try out
the book but it got so-so reader reviews on Amazon.com.
Anyone think the book's worth it? Alternative deeper
discussions of Fusebox anywhere?

3. I've not really used PHP or ASP. Does anyone know how
the moves to have Fusebox work for these is going? Will
knowing Fusebox in CF help me get going quicker with
PHP/ASP if/when I delve into them (assuming Fusebox has
been adapted for them)?

4. Some clients I have are still hosted with CF 4.0 - does this
pose any problems for using Fusebox 3?

All comments and feedback most welcome :)

- Gyrus




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Client storage woes

2001-11-18 Thread Joseph DeVore

Did you have ColdFusion create the tables on your production server when
switching to ODBC client storage, or did you import them from the dev box?

If you didn't have CF create the tables, it's possible you selected an
incorrect datatype.


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 18, 2001 1:54 PM
To: CF-Talk
Subject: Client storage woes


Our main web server has a registry that is huge because of the CF client
storage.  So, I decide to store client data in a SQL db.  I
can get this to work fine on my development server but when I try to do the
same thing for the production server I get a SQL error
when accessing pages:

ODBC Error Code = 22001 (String data right truncation)
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.

I have no idea why this happens on our production server.  Both production
and test servers are CF5.

Thanks,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
<<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product
>>>
http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm
>>> Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm


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



RE: Mystery?!! Variables not being recognized via CFLOCATION

2001-11-18 Thread Joseph DeVore

Have you tried prefixing your variable with the URL scope?

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 17, 2001 7:29 PM
To: CF-Talk
Subject: Mystery?!! Variables not being recognized via CFLOCATION


This is the actual error message even though the variable 'bannerfile' shows
as being present in the URL with a value also. I'm totally puzzled by this:


Error Occurred While Processing Request

 Error Diagnostic Information

 An error occurred while evaluating the expression:

  bannerfile="#bannerfile#"

 Error near line 2, column 7.


 Error resolving parameter BANNERFILE

 ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:

   1.You have misspelled the parameter name, or
   2.You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or
CFTABLE tag.

 The error occurred while processing an element with a general identifier of
(CFSET), occupying document position (2:1) to
 (2:33).


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Mystery?!! Variables not being recognized via CFLOCATION

2001-11-18 Thread Joseph DeVore

Pardeep,

Are your variables URL encoded?
Wrap this function around each string variable.

URLEncodedFormat()


How's that dynamic image app coming along?

Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 17, 2001 7:17 PM
To: CF-Talk
Subject: Mystery?!! Variables not being recognized via CFLOCATION


I am passing variables to a page that runs some actions, then variables are
sent via CFLOCATION to a display page.

However, on the display page I keep getting an error message saying that the
necessary variables are not present or not recognized.

I only have this problem in Netscape and older versions of Explorer. In the
new version of explorer everything is fine.

This problem is causing a halt in the whole app being developed. Anyone have
any idea what it could be?

Thanks,
Pardeep.

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: traitorous question re VBScript

2001-11-17 Thread Joseph DeVore

Seamus,

I wrote the VBScript you needed, however I have a couple questions.

Will your Title variable ever have spaces in it?

If so, you will need to change your delimiter from
a space to something more reliable like a pipe or comma.

In the sections where I response.write, you will most likely want to change
them to variables, appending each new SQL statement to the previous.


Here is a working VBScript example:



<%
' author: Joseph DeVore
' date: Saturday, November 17, 2001

dim arTitle, arAuthor, i
' create temp list of titles
title="this_example that_example his_example"

' create temp list of authors
author="devore forta helms"

' split lists into arrays
arTitle = split(Title," ")
arAuthor = split(Author," ")

' loop over title array
for i=0 to ubound(arTitle)
' write response to client
response.write("AND Title LIKE '%" & arTitle(i) & "%'" & vbcrlf)
next

' loop over author array
for i=0 to ubound(arAuthor)
' write response to client
response.write("AND Author LIKE '%" & arAuthor(i) & "%'" & vbcrlf)
next

' if length of form.category_id
if len(request.form("category_id")) then
' write response to client
response.write("AND shstock.CategoryID=" & request.form("category_id") & ""
& vbcrlf)
end if
%>





Let me know what you think or if you have any questions.

Joseph DeVore
VeloxWeb Technologies





-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 8:40 PM
To: CF-Talk
Subject: traitorous question re VBScript


Hi

can anyone help me with this rather traitorous question

I'm putting a small search page in a friend's website (which is not
cf-enabled, unfortunately)

The search results code I want is (in coldfusion):


SELECT tbl_category.category, shstock.BOOKNUM, shstock.TITLE,
shstock.Author, shstock.PRICE, shstock.CategoryID
FROM tbl_category INNER JOIN shstock ON tbl_category.category_id =
shstock.CategoryID
WHERE 0=0

   AND Title LIKE
'%#ListGetAt(Title, i, " ")#%' 
   AND Author LIKE
'%#ListGetAt(Author, i, " ")#%' 

AND shstock.CategoryID=#FORM.Category_id#


ORDER BY Title




Is anyone able to translate the middle bit to VBScript for me, please
ie
   AND Title LIKE
'%#ListGetAt(Title, i, " ")#%' 
   AND Author LIKE
'%#ListGetAt(Author, i, " ")#%' 

AND shstock.CategoryID=#FORM.Category_id#



MTIA

Seamus


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



  1   2   >