ColdFusion and E-Test

[Vaughan Evans]

I am thinking about using RSW Software's E-Test suite to running various
checks, tests and monitoring on our ColdFusion apps.

Has anyone had any experience with this tool?

Would you recommend it? why/why not?

Thanks in advance,

Vaughan Evans.

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

OT SQL 7.0 Performance Question.

[Sean Renet]

I have two stored procedures that do the same thing.  I would think the
latter would be faster than the former. Can anyone explain why it is not?
First one...

CREATE PROCEDURE old_webclientacctholddaily @caccountid int, @OrderBy
varchar(50)
AS
DECLARE @mySQL nvarchar(500)
SET @mySQL = N'SELECT holdings.*,securities.* FROM holdings, securities
WHERE holdings.secid = securities.secid AND holdings.accountID=@xparam ORDER
BY '+ @OrderBy
EXEC sp_executeSQL @mySQL , N'@xparam int', @caccountid
 (Records=162, Time=942ms)
SQL = old_webclientacctholddaily


Second one...

CREATE PROCEDURE webclientacctholddaily @caccountid int, @OrderBy
varchar(50)
AS

IF @orderBy = 'sector'
 SELECT *
 FROM   holdings,
   securities
 WHERE holdings.secid = securities.secid
 AND  holdings.accountID=@caccountid
 ORDER BY sector,
   secName
ELSE
IF @orderBy = 'pctport'
 SELECT *
 FROM   holdings,
   securities
 WHERE holdings.secid = securities.secid
 AND  holdings.accountID=@caccountid
 ORDER BY pctport desc

ELSE
IF @orderBy = 'country'
 SELECT *
 FROM   holdings,
   securities
 WHERE holdings.secid = securities.secid
 AND  holdings.accountID=@caccountid
 ORDER BY country,
   secName
ELSE
 SELECT *
 FROM   holdings,
   securities
 WHERE holdings.secid = securities.secid
 AND  holdings.accountID=@caccountid
 ORDER BY secName

(Records=162, Time=971ms)
SQL = webclientacctholddaily



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

Re: WWW.E-BURSA.COM

[Capolinea]

It took 1'30 minutes to load in paris France with ADSL

Regards,
Rémi van der Deure

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

RE: cftransaction error ? HELP.

[Anthony Geoghegan]

|++
|ODBC Error Code = 23000 (Integrity constraint violation)
|
|[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
|constraint 'PK__nxstar_e__076C2375': Attempt to insert duplicate key 
|in object 'nxstar_e'.

Hi Miles
I think your solution is probably an index in your SQL table with a "unique"
setting.  This means you cant create a situation where the index entries
have a duplicate "key".
Try changing the index settings or check your code for why this event could
occur.

BTW just a tip if you are genuinely looking for assistance try and keep your
posts short and sweet, we're working stiffs here and it takes time to peruse
these lists.  It just means nobody will assist you if you write complete
dissertations.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

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

Re: encrypt url

[CF-Help _India]

Hey Ramesh,,,

When u can pass values using hidden fields or sessions or clients if
u
dont want the users to see the values... & i dont think any one will
send the password using using query strings...

If not clear pls mail back to me...

Regards
Vikram


 Deva Ramesh <[EMAIL PROTECTED]> wrote:
> Hai
> 
> I am trying to open report with follwoing code. and i don't want show
> userid
> and password of database in address location bar. then in my current
> system
> it is working fine( i mean userid and password converting into encryption
> format).
> but problem is when i open an others system then it is 
> populating dialogbox and saying that "plese enter userid and password
> for
> database" .
> so i don't want to populate this dialogbox to users. 
> 
> Plese can any one help me na.
> This is my code.
> 
> 
>  
> 
> 
> 
> Thanx
> Ramesh
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in the body.
> 

__
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

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

RE: Authenication using NT

[Reynolds, Adam]

CGI.AUTH_USER

> --
> From: Bost, Tracy[SMTP:[EMAIL PROTECTED]]
> Sent: 17 July 2000 15:59
> To:   '[EMAIL PROTECTED]'
> Subject:  Authenication using NT
> 
> When a user logs into the intranet site, I would like for coldfusion to
> authenicate it using the person's NT domain username/password. Can this be
> done ?
> 
>   Thanks,
> Tracy Bost
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

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

Re: WWW.E-BURSA.COM

[FARHANAHMAD]

 
It took 1'45 minutes to complete download at Islamabad Pakistan.
 
Regards
Farhan


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

CF_radius ??

[Len Conrad]

There is one tag in the gallery for AAA radius going back to 1997?

Anybody know of a more recent tag tested with more radius servers?

Thanks,
Len

http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5  installable binary for NT4
http://IMGate.MEIway.com:  Build free, hi-perf, anti-spam mail gateways

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

Finally!

[Erki Esken]

http://www.allaire.com/search/

---
Site is down for maintenance 

We're sorry...due to some minor technical difficulties we have
taken our search functionality off line for a short period of
time. We will have this problem resolved shortly. We appreciate
your patience in this matter and apologize for any inconvenience
this may cause.
---

Finally they're doing something..


Erki

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

Aaarrrgh! CF4.5 screws up ASP on WIN2K

[Nicklas af Ekenstam]

After tearing my hair for almost a week I found this article:

"Cold Fusion 4.5
After installing Cold Fusion 4.5 with the Advanced Security Features, you 
begin to receive one of the error messages:
Error in DLL
-or-
Provider can not be found. Ensure that the provider has been installed 
properly.
Currently the only way to correct the problem is to reinstall the operating 
system.
You can choose the Upgrade option to retain all your applications and 
settings."

This is exactly what happened to us and I am so very annoyed (to say the 
least) at Allaire for not including a warning or something that this will 
happen.

Does anybody here know of another solution than reinstalling the OS?

//Nille

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

cf-talk@houseoffusion.com

[Nicklas af Ekenstam]

Hi!

I'm trying to download  from allaire using:

Can't seem to find the download link...
Anybody here have the tag and wouldn't mind mailing it to me offlist or a 
valid download url?

Thanks!

//Nille


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

RE: Why Cant i see, linked Tables in the DB tab in studio?

[Marc Lippman]

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 9:14 AM
To: '[EMAIL PROTECTED]'
Subject: Why Cant i see, linked Tables in the DB tab in studio?

OK!
I am able to use linked tables in access in CF Studio!
Never knew that! Saves me a lot of time & keeps my stuff normalized I think.

But WHY can't I see the linked table in the DataBase Tab in CF Studio?

Is there a work around, cheat or quick fix for this?

I use the DB Tab on a regular basis to build my SQL statements & to
visualize my DB

Any suggestions would be great!

Thanks

-paul

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

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

Escaping quotes, cf-tags etc

[Nicklas af Ekenstam]

Hi!

What is the best way to accomplish something like:

#someothervar#">

and not having cf evaulate everything in the statement?
I want to have included cf-files setting variables holding html and cold 
fusion code and have them evaluated when they are outputed only.

Thanks!

//Nille


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

RE: List slowdown problems and solutions

[Paul Ihrig]

I have learned more about web development in general & CF to boot from this
list.
Other then WACK it is my greatest resource, that I use on an hourly basis
here at work.
I would defiantly kick in a few bucks a month or so to help out.

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

RE: Listing column names in a table

[Daye, Marianne]

There was an article in the ColdFusion Developer's Journal called Dynamic
Table & Query Engine that gives you what you need, and then some (provided
you're NOT using Access).  I couldn't find the complete article on line, but
you can get the source code listings at http://www.sys-con.com/coldfusion/.
Click on SOURCE CODE in the header, select volume 1, Issue 6, and select
Dynamic Table & Query Engine.

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org


-Original Message-
From: Nille af Ekenstam [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 8:56 AM
To: [EMAIL PROTECTED]
Subject: Listing column names in a table


Hi

Anybody know of a good way to find out the column names in a database table 
and outputing them using CF?
What I want to achieve is to use all columns in a table to construct some 
variiables (columnname = value) with without having to know exactly how 
many there are or what they are called.

Thanks!

//Nille



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

Re: cookies?? or what to use

[Lewis Steven]

This is a multi-part message in MIME format.
--BE503D82797F5FE2D22281E4
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Why would you want to use session variables when the CGI.HTTP_REFERER seems to a more 
logical solution.



Anthony Geoghegan wrote:

> Hi Kim,
> Session Variables can be used for this purpose.
>
> Regards,
> Anthony Geoghegan.
> Lead Developer,
> IFTN
> www.wow.ie
> mailto:[EMAIL PROTECTED]
>
> |-Original Message-
> |From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
> |Sent: 15 July 2000 19:07
> |To: [EMAIL PROTECTED]
> |Subject: cookies?? or what to use
> |
> |
> |Ok, I'm new to the list...and new to using coldfusion.  I need
> |to ensure
> |that users can only go through the system in a certain order
> |(they must fill
> |out forms in a particular order and should not be allowed to
> |come into any
> |page of the system without first going through the previous
> |pages).  Does
> |anyone know how this is best achieved.  Any advice will be helpful.
> |
> |Thanks, Kim
> |[EMAIL PROTECTED]
> |___
> |_
> |Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
>
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--BE503D82797F5FE2D22281E4
Content-Type: text/x-vcard; charset=us-ascii;
 name="lewis_steven.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steven Lewis
Content-Disposition: attachment;
 filename="lewis_steven.vcf"

begin:vcard 
n:Lewis;Steven
tel;fax:703-845-3939
tel;work:703-845-3996
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Steven Lewis
end:vcard

--BE503D82797F5FE2D22281E4--

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

Re: List slowdown problems and solutions

[David Shadovitz]

On Tue, 18 Jul 2000 Paul Ihrig <[EMAIL PROTECTED]> writes:
> I would defiantly kick in a few bucks a month or so to help out.

We'll come over and force it out of you.

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: cookies?? or what to use

[Dave Hannum]

Not all servers will give you the CGI.HTTP_REFERER.  Some Sys Admins turn
that off.

Dave

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

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



- Original Message -
From: Lewis Steven <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 8:56 AM
Subject: Re: cookies?? or what to use


This is a multi-part message in MIME format.
--BE503D82797F5FE2D22281E4
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Why would you want to use session variables when the CGI.HTTP_REFERER seems
to a more logical solution.



Anthony Geoghegan wrote:

> Hi Kim,
> Session Variables can be used for this purpose.
>
> Regards,
> Anthony Geoghegan.
> Lead Developer,
> IFTN
> www.wow.ie
> mailto:[EMAIL PROTECTED]
>
> |-Original Message-
> |From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
> |Sent: 15 July 2000 19:07
> |To: [EMAIL PROTECTED]
> |Subject: cookies?? or what to use
> |
> |
> |Ok, I'm new to the list...and new to using coldfusion.  I need
> |to ensure
> |that users can only go through the system in a certain order
> |(they must fill
> |out forms in a particular order and should not be allowed to
> |come into any
> |page of the system without first going through the previous
> |pages).  Does
> |anyone know how this is best achieved.  Any advice will be helpful.
> |
> |Thanks, Kim
> |[EMAIL PROTECTED]
> |___
> |_
> |Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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

--BE503D82797F5FE2D22281E4
Content-Type: text/x-vcard; charset=us-ascii;
 name="lewis_steven.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steven Lewis
Content-Disposition: attachment;
 filename="lewis_steven.vcf"

begin:vcard
n:Lewis;Steven
tel;fax:703-845-3939
tel;work:703-845-3996
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Steven Lewis
end:vcard

--BE503D82797F5FE2D22281E4--


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

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

Re: cookies?? or what to use

[Randy Adkins]

One thing on using CGI.HTTP_REFERER is that NOT
all businesses, networks (admins) pass those variables.
I have experienced where I used that cgi variable
and various of networks either block that variable
or something as it is not being established or passed
when a user goes from one page to another.


- Original Message -
From: "Lewis Steven" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 8:56 AM
Subject: Re: cookies?? or what to use


: This is a multi-part message in MIME format.
: --BE503D82797F5FE2D22281E4
: Content-Type: text/plain; charset=us-ascii
: Content-Transfer-Encoding: 7bit
:
: Why would you want to use session variables when the CGI.HTTP_REFERER
seems to a more logical solution.
:
:
:
: Anthony Geoghegan wrote:
:
: > Hi Kim,
: > Session Variables can be used for this purpose.
: >
: > Regards,
: > Anthony Geoghegan.
: > Lead Developer,
: > IFTN
: > www.wow.ie
: > mailto:[EMAIL PROTECTED]
: >
: > |-Original Message-
: > |From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
: > |Sent: 15 July 2000 19:07
: > |To: [EMAIL PROTECTED]
: > |Subject: cookies?? or what to use
: > |
: > |
: > |Ok, I'm new to the list...and new to using coldfusion.  I need
: > |to ensure
: > |that users can only go through the system in a certain order
: > |(they must fill
: > |out forms in a particular order and should not be allowed to
: > |come into any
: > |page of the system without first going through the previous
: > |pages).  Does
: > |anyone know how this is best achieved.  Any advice will be helpful.
: > |
: > |Thanks, Kim
: > |[EMAIL PROTECTED]
: > |___
: > |_
: > |Get Your Private, Free E-mail from MSN Hotmail at
: > http://www.hotmail.com
: >
:
> --
--
: > --
: > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: > To Unsubscribe visit
: > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
: > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
: > the body.
:
> --

: > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: > To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
:
: --BE503D82797F5FE2D22281E4
: Content-Type: text/x-vcard; charset=us-ascii;
:  name="lewis_steven.vcf"
: Content-Transfer-Encoding: 7bit
: Content-Description: Card for Steven Lewis
: Content-Disposition: attachment;
:  filename="lewis_steven.vcf"
:
: begin:vcard
: n:Lewis;Steven
: tel;fax:703-845-3939
: tel;work:703-845-3996
: x-mozilla-html:FALSE
: adr:;;
: version:2.1
: email;internet:[EMAIL PROTECTED]
: fn:Steven Lewis
: end:vcard
:
: --BE503D82797F5FE2D22281E4--
:
: --

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

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

Setting global variables

[Gavin Myers]

Okay, I know how to do this is director lingo, fairly easy. I want to keep a
few variables global so I dont have to keep passing them through the link
structure.

Example:

I have a site that is either accessed through a banner ad, or a print ad. If
it is a banner ad the link will look like this
http://www.mylocation.com/index.cfm?banner=yes but, if it is a print ad the
person will only be typing in http://www.mylocation.com Now, I have a
session opened up with a cfapplication. But how do i set up global
variables? I want that banner variable to be global once a person accesses
the site right now i do this:













And I have to do this on each site. But not just with that, with like 5
other variables... its a big mess.

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

RE: ColdFusion and E-Test

[mherbene]

I have not used it in production, but I evaluated E-Tester & E-Load (a few
months ago, YMMV).

Strengths: 
1) Good at setting dynamic data
2) Upon re-run can set actual as baseline
3) Can double-click on "errors" to see highlighted HTML diffs
4) handles cookies, redirects properly
5) Can feed data from a file

Weaknesses:
1) IE-based; must redefine tests for Netscape
2) Can't handle multi-window apps well (where you dynamically open and close
extra browser windows)



-Original Message-
From: Vaughan Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 3:08 AM
To: [EMAIL PROTECTED]
Subject: ColdFusion and E-Test


I am thinking about using RSW Software's E-Test suite to running various
checks, tests and monitoring on our ColdFusion apps.

Has anyone had any experience with this tool?

Would you recommend it? why/why not?

Thanks in advance,

Vaughan Evans.


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

RE: Escaping quotes, cf-tags etc

[Larry Juncker]

Have you tried the following?



This seemed to work for me.

H   Larry Juncker
 L  Senior Cold Fusion Programmer
  I Heartland Communications Group
  Internet Division

-Original Message-
From: Nicklas af Ekenstam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 7:37 AM
To: [EMAIL PROTECTED]
Subject: Escaping quotes, cf-tags etc


Hi!

What is the best way to accomplish something like:

#someothervar#">

and not having cf evaulate everything in the statement?
I want to have included cf-files setting variables holding html and cold
fusion code and have them evaluated when they are outputed only.

Thanks!

//Nille



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


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

RE: 5 Blank Lines in Excel

[Kevin Plexico]

Your probably getting the blank lines from a application.cfm file that is
executing.  You need to wrap your application.cfm code in a

  (providing you don't have any display
code in the application.cfm).

Kevin


-Original Message-
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 11:33 AM
To: CF Forum
Subject: 5 Blank Lines in Excel


Thanks, everyone, with your questions and answers I got my cfcontent to open
a page in excel.  However, I tried everything to get the five blank lines on
the top of the page to disappear.  Can anyone tell me what is causing them
or better yet how to get rid of them.

Thanks,
 
 ---miriam


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

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

CFMAIL and recordsets

[Matt Taylor]

 Hi all,
I have a query that returns a record set of username, password and email.  I
then use  to send each person their correct authentication, no big
deal.  My problem is when I want my message text to come from a form field,
 does not parse my #'s at all.

Ex: form field 'name=document'



Any CF variables I put into the form field like "Hello #username#,"
are not parsed by CF.  Does anyone know why this is occurring?

 TIA,
 Matt

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

RE: WWW.E-BURSA.COM

[Paul Ihrig]

25 seconds from columbus ohio on a t1
-paul

-Original Message-
From:   Gunawan Hadikusumo [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 12, 2000 6:01 AM
To: '[EMAIL PROTECTED]'
Subject:WWW.E-BURSA.COM

IS ANY BODY HERE ANY DIFFICULTY IN ACCESSING MY SITE:

WWW.E-BURSA.COM   ?

I WANT TO KNOW WHERE DO YOU ACCESS MYSITE ( COUNTRY ,PUBLIC INTERNET
CAFÉ OR
PERSONAL),
AND HOW FAST  YOU GOT.


THANK'S FOR ALL PARTICIPANTS


GUNAWAN


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

search

[Iztok Polanic]

Hi!

I'm looking for  in CFHTTP.FileContent but I'm 
getting errors. Here's my code:

',CFHTTP.FileContent,1)>

What's wrong?

Bye,

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

RE: WWW.E-BURSA.COM

[Ray, James A]

Seems to be a bit slow. 60 secs on my T1 from Huntington Beach, Calif.  Each
page seems to be the same. Can't read it though.

Jim Ray
Delta Program NT Administrator 
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/



-Original Message-
From: Gunawan Hadikusumo [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 12, 2000 3:01 AM
To: '[EMAIL PROTECTED]'
Subject: WWW.E-BURSA.COM


IS ANY BODY HERE ANY DIFFICULTY IN ACCESSING MY SITE:

WWW.E-BURSA.COM   ?

I WANT TO KNOW WHERE DO YOU ACCESS MYSITE ( COUNTRY ,PUBLIC INTERNET CAFE OR
PERSONAL),
AND HOW FAST  YOU GOT.


THANK'S FOR ALL PARTICIPANTS


GUNAWAN

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

Re: List slowdown problems and solutions

[Angél Stewart]

*nod*
See??
When something goes wrong on E-Groups..who do ya call?
No one. You just sit and wait, maybe send off an email or two to tech
support and hope for the best.

When something goes wrong on the CF List? Who do ya call!!
MIKE!
=)
We have our own private tech support person, dedicated just to us..and all
for FREE too.

I mean..what MORE could you want??
;-P

Lets hear it for Mike!!
HIP HIP HOOORAAAYY
For he's a jolly good fe-llow..for he's a jolly good fe-llow!
*throws bits of confetti in the air*

We can all go over to the CF-DrunkenDebauchery list and have a REALLY good
time later!
;-P

-Gel
p.s. if you are having some method for donations etc. to keep the list
upgraded and running, there appear to be a lot of contributors to the list
from non-us organisations and companies. Don't forget to take easy
international donations into account ;-P

- Original Message -
From: Michael Dinowitz <[EMAIL PROTECTED]>

> The point is, I am working on keeping things going fast and upgrading
> services. I'm hoping that those who were effected by the slowdown (which
was
> only about 1/3 of the list) will understand and be patient with me.



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

RE: CFMAIL and recordsets

[Paul Ihrig]

Do you have a:
Hello #username# 

Hope that helps.
-paul

-Original Message-
From:   Matt Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, July 18, 2000 7:34 AM
To: ColdFusion Discussion List
Subject:CFMAIL and recordsets

 Hi all,
I have a query that returns a record set of username, password and
email.  I
then use  to send each person their correct authentication,
no big
deal.  My problem is when I want my message text to come from a form
field,
 does not parse my #'s at all.

Ex: form field 'name=document'



Any CF variables I put into the form field like "Hello #username#,"
are not parsed by CF.  Does anyone know why this is occurring?

 TIA,
 Matt



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

RE: Escaping quotes, cf-tags etc

[Nicklas af Ekenstam]

>-Original Message-
>From: Nicklas af Ekenstam [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, July 18, 2000 7:37 AM
>To: [EMAIL PROTECTED]
>Subject: Escaping quotes, cf-tags etc
>
>
>Hi!
>
>What is the best way to accomplish something like:
>
>javascript=do.it('1')>#someothervar#">
>
>and not having cf evaulate everything in the statement?
>I want to have included cf-files setting variables holding html and cold
>fusion code and have them evaluated when they are outputed only.
>
>Thanks!

At 08:21 2000-07-18 -0500, Larry Juncker wrote:
>Have you tried the following?
>
>
>
>This seemed to work for me.

Problem is that I need to keep the <>"'#:s and use them later on. Plus; I 
don't know what strings I'm going to deal with.
I need to find a way to have cf ignore everything  and 
just accept it. Quotes, brackets, single quotes, html and so on. Otherwise 
I can't use it to output what i need later down in the script.

//Nille


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

Re: cookies?? or what to use

[Lewis Steven]

This is a multi-part message in MIME format.
--AB6BDC84D546A4427FCD8ACE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Oh, ok. Thanks I didn't know that CGI.HTTP_REFER could be disabled by a SYSADMIN.

But then if the CGI.HTTP_REFER can be disabled, then what other CGI variable can be 
disabled then?

Steve

Dave Hannum wrote:

> Not all servers will give you the CGI.HTTP_REFERER.  Some Sys Admins turn
> that off.
>
> Dave
>
> =
> "What we need is a list of specific unknown problems we will encounter"
>
> David Hannum
> Web Analyst/Programmer
> Ohio University
> [EMAIL PROTECTED]
> (740) 597-2524
>
> - Original Message -
> From: Lewis Steven <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 18, 2000 8:56 AM
> Subject: Re: cookies?? or what to use
>
> This is a multi-part message in MIME format.
> --BE503D82797F5FE2D22281E4
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Why would you want to use session variables when the CGI.HTTP_REFERER seems
> to a more logical solution.
>
> Anthony Geoghegan wrote:
>
> > Hi Kim,
> > Session Variables can be used for this purpose.
> >
> > Regards,
> > Anthony Geoghegan.
> > Lead Developer,
> > IFTN
> > www.wow.ie
> > mailto:[EMAIL PROTECTED]
> >
> > |-Original Message-
> > |From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
> > |Sent: 15 July 2000 19:07
> > |To: [EMAIL PROTECTED]
> > |Subject: cookies?? or what to use
> > |
> > |
> > |Ok, I'm new to the list...and new to using coldfusion.  I need
> > |to ensure
> > |that users can only go through the system in a certain order
> > |(they must fill
> > |out forms in a particular order and should not be allowed to
> > |come into any
> > |page of the system without first going through the previous
> > |pages).  Does
> > |anyone know how this is best achieved.  Any advice will be helpful.
> > |
> > |Thanks, Kim
> > |[EMAIL PROTECTED]
> > |___
> > |_
> > |Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> >
> > --
> --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > the body.
> > --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --BE503D82797F5FE2D22281E4
> Content-Type: text/x-vcard; charset=us-ascii;
>  name="lewis_steven.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Steven Lewis
> Content-Disposition: attachment;
>  filename="lewis_steven.vcf"
>
> begin:vcard
> n:Lewis;Steven
> tel;fax:703-845-3939
> tel;work:703-845-3996
> x-mozilla-html:FALSE
> adr:;;
> version:2.1
> email;internet:[EMAIL PROTECTED]
> fn:Steven Lewis
> end:vcard
>
> --BE503D82797F5FE2D22281E4--
>
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--AB6BDC84D546A4427FCD8ACE
Content-Type: text/x-vcard; charset=us-ascii;
 name="lewis_steven.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steven Lewis
Content-Disposition: attachment;
 filename="lewis_steven.vcf"

begin:vcard 
n:Lewis;Steven
tel;fax:703-845-3939
tel;work:703-845-3996
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Steven Lewis
end:vcard

--AB6BDC84D546A4427FCD8ACE--

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

RE: search

[lsellers]

> Hi!
>
> I'm looking for  in CFHTTP.FileContent but I'm
> getting errors. Here's my code:
>
>  ('',CFHTTP.FileContent,1)>

You might want to do some error checking first. The mime type. The content
length. Etc. It might not be getting any data.

This is some old ugly, unoptimized, brute force code, but It's been working
for over a year so :)



",CFHTTP.FileContent)>
",CFHTTP.FileContent)>




",">","ALL")>









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


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

Re: cookies?? or what to use

[Dave Hannum]

I believe any and all can be disabled.

Dave


- Original Message -
From: Lewis Steven <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 9:54 AM
Subject: Re: cookies?? or what to use


This is a multi-part message in MIME format.
--AB6BDC84D546A4427FCD8ACE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Oh, ok. Thanks I didn't know that CGI.HTTP_REFER could be disabled by a
SYSADMIN.

But then if the CGI.HTTP_REFER can be disabled, then what other CGI variable
can be disabled then?

Steve

Dave Hannum wrote:

> Not all servers will give you the CGI.HTTP_REFERER.  Some Sys Admins turn
> that off.
>
> Dave
>
> =
> "What we need is a list of specific unknown problems we will encounter"
>
> David Hannum
> Web Analyst/Programmer
> Ohio University
> [EMAIL PROTECTED]
> (740) 597-2524
>
> - Original Message -
> From: Lewis Steven <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 18, 2000 8:56 AM
> Subject: Re: cookies?? or what to use
>
> This is a multi-part message in MIME format.
> --BE503D82797F5FE2D22281E4
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Why would you want to use session variables when the CGI.HTTP_REFERER
seems
> to a more logical solution.
>
> Anthony Geoghegan wrote:
>
> > Hi Kim,
> > Session Variables can be used for this purpose.
> >
> > Regards,
> > Anthony Geoghegan.
> > Lead Developer,
> > IFTN
> > www.wow.ie
> > mailto:[EMAIL PROTECTED]
> >
> > |-Original Message-
> > |From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
> > |Sent: 15 July 2000 19:07
> > |To: [EMAIL PROTECTED]
> > |Subject: cookies?? or what to use
> > |
> > |
> > |Ok, I'm new to the list...and new to using coldfusion.  I need
> > |to ensure
> > |that users can only go through the system in a certain order
> > |(they must fill
> > |out forms in a particular order and should not be allowed to
> > |come into any
> > |page of the system without first going through the previous
> > |pages).  Does
> > |anyone know how this is best achieved.  Any advice will be helpful.
> > |
> > |Thanks, Kim
> > |[EMAIL PROTECTED]
> > |___
> > |_
> > |Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> >
>
> --
> --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
>
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --BE503D82797F5FE2D22281E4
> Content-Type: text/x-vcard; charset=us-ascii;
>  name="lewis_steven.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Steven Lewis
> Content-Disposition: attachment;
>  filename="lewis_steven.vcf"
>
> begin:vcard
> n:Lewis;Steven
> tel;fax:703-845-3939
> tel;work:703-845-3996
> x-mozilla-html:FALSE
> adr:;;
> version:2.1
> email;internet:[EMAIL PROTECTED]
> fn:Steven Lewis
> end:vcard
>
> --BE503D82797F5FE2D22281E4--
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --

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

--AB6BDC84D546A4427FCD8ACE
Content-Type: text/x-vcard; charset=us-ascii;
 name="lewis_steven.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steven Lewis
Content-Disposition: attachment;
 filename="lewis_steven.vcf"

begin:vcard
n:Lewis;Steven
tel;fax:703-845-3939
tel;work:703-845-3996
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Steven Lewis
end:vcard

--AB6BDC84D546A4427FCD8ACE--


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

--

Custom session management

[Bryan Batchelder]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFF0C0.7B8AAA00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi guys--

I am working on writing Palm Query Applications (PQAs).  One of the
big nasty deals with them is the lack of cookie support, so that means =
CF
sessions don't work.  One saving grace for the palm, however, is that =
it has
a unique identifier called the DeviceID - it is unique to each palm and =
can
be used as a number to key a session off of.

Can anyone give me any pointers to creating a session management
system that is as easy to use as the native CF sessions?

My current thinking is along these lines:

1.  User logs in, DeviceID is sent and put in a table that
links username to deviceid.
2.  We have another table which has 4 columns:
id(IDENTITY), username, variable_name, variable_contents.
3.  Write a custom tag that takes in the name of a variable.
It then adds this variable and the variables current contents to the =
table,
so if we have:








The table now has
  ID   Username Variable_Name   Variable_Contents
---
1  |  bbatchel  |  action   |  monkey

4.  Then, the script can do whatever it wants with that
variable
5.  At the end of the script, a file is included that
contains code which will updade the values of all variables registered =
with
the system to the current state of the variables after execution.
6.  At the begining of the next page, a file is included
that will re-instate the variables in the table so they are available =
to the
script.
7.  a  will be
available to remove variables from the session scope.

8,  It is also relevant that in every URL I am including a
?deviceid=3D(deviceid from palm) so that the session is able to know =
who I am.
I will probably change this to a randomly generated number so that my
session key is not predictable.

Does anyone think this is an effective way of faking sessions?

Anyone have any better ideas?

There is a tool that will act as a proxy for PQAs that will maintain
cookies, and hence real CF sessions would work, but I am afraid that =
will
cause other problems later on.

Thanks,
--b


   Bryan D. Batchelder =20
Palm Wireless/Internet Application Developer
W: 813.935.7100
W: 813-936-8844 x 423 (after 5:30PM EST)
H: 727-547-1322

ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618


-Original Message-
From: Ang=E9l Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 9:39 AM
To: [EMAIL PROTECTED]
Subject: Re: List slowdown problems and solutions


*nod*
See??
When something goes wrong on E-Groups..who do ya call?
No one. You just sit and wait, maybe send off an email or two to tech
support and hope for the best.

When something goes wrong on the CF List? Who do ya call!!
MIKE!
=3D)
We have our own private tech support person, dedicated just to us..and =
all
for FREE too.

I mean..what MORE could you want??
;-P

Lets hear it for Mike!!
HIP HIP HOOORAAAYY
For he's a jolly good fe-llow..for he's a jolly good fe-llow!
*throws bits of confetti in the air*

We can all go over to the CF-DrunkenDebauchery list and have a REALLY =
good
time later!
;-P

-Gel
p.s. if you are having some method for donations etc. to keep the list
upgraded and running, there appear to be a lot of contributors to the =
list
from non-us organisations and companies. Don't forget to take easy
international donations into account ;-P

- Original Message -
From: Michael Dinowitz <[EMAIL PROTECTED]>

> The point is, I am working on keeping things going fast and upgrading
> services. I'm hoping that those who were effected by the slowdown =
(which
was
> only about 1/3 of the list) will understand and be patient with me.



=

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

--_=_NextPart_001_01BFF0C0.7B8AAA00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Custom session management



Hi guys--


    I am =
working on writing Palm Query Applications (PQ

Re: CFMAIL and recordsets

[Matt Taylor]

Yes, actually I tried #username# and #query.username#
and #username, of course that bombed because of the
nested queries.  I seemed to have found a temp work around by using
 and inserting a CFM template.  But I'm still baffled as to why
the other way wasn't working.

- Original Message -
From: Paul Ihrig <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 9:50 AM
Subject: RE: CFMAIL and recordsets


> Do you have a:
> Hello #username# 
>
> Hope that helps.
> -paul
>
> -Original Message-
> From: Matt Taylor [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 18, 2000 7:34 AM
> To: ColdFusion Discussion List
> Subject: CFMAIL and recordsets
>
> Hi all,
> I have a query that returns a record set of username, password and
> email.  I
> then use  to send each person their correct authentication,
> no big
> deal.  My problem is when I want my message text to come from a form
> field,
>  does not parse my #'s at all.
>
> Ex: form field 'name=document'
>
>  #document#
> 
>
> Any CF variables I put into the form field like "Hello #username#,"
> are not parsed by CF.  Does anyone know why this is occurring?
>
> TIA,
>  Matt
>
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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

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

RE: 5 Blank Lines in Excel

[Miriam Hirschman]

Thanks, that eliminated about 2 lines, any other ideas??

Miriam

-Original Message-
From: Kevin Plexico [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 9:23 AM
To: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel


Your probably getting the blank lines from a application.cfm file that is
executing.  You need to wrap your application.cfm code in a

  (providing you don't have any display
code in the application.cfm).

Kevin


-Original Message-
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 11:33 AM
To: CF Forum
Subject: 5 Blank Lines in Excel


Thanks, everyone, with your questions and answers I got my cfcontent to open
a page in excel.  However, I tried everything to get the five blank lines on
the top of the page to disappear.  Can anyone tell me what is causing them
or better yet how to get rid of them.

Thanks,

 ---miriam


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


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

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

Verity Search Engine

[Robert Everland]

Anyone have a Verity search engine for thier website. If so would
you mind sharing?


Robert Everland III
Web Developer
Dixon Ticonderoga

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

help with file distribution

[Andy Lambert]

I am working on a project where we need to modify existing code that moves
files across a LAN using cffile to code that moves files across the Internet
based on IP address. We are considering using cfftp as a last resort, but
would rather use a third party component or custom tag that is http based so
that we do not have to setup ftp on the remote machine(s). Does anyone know
of a good ColdFusion/Java/Com component that we could use to handle this
(something similar to ASPUpload for CF)? The ideal component will have error
checking, and the ability to pick up where it left off if the transmission
is cut short.

Any help would be greatly appreciated.
Please CC my email address in your response. I won't get a CF Talk digest
update until later today. Thanks!

Andy
[EMAIL PROTECTED]


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

Re: CFMAIL and recordsets

[Deanna L. Schneider]

Did you reference a query in the cfmail tag? Try adding that if you didn't
have it before.

i.e.:


your content, including #username#


Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



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

CF Express

[John Allred]

Can anyone give me a URL where I can download CF Express? I found it on
Allaire's site previously using search, but that's currently disabled.

Thanks,
John Allred

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

RE: List slowdown problems and solutions

[Gregory Gooden (Annex)]

If you need processor and bandwidth, I'd be MORE than happy to provide! We
use Vircom's VOPMAIL mail servers for our lists (very robust, only missing
digest support), and post.office as well (which does support digests).. We
maintain our own datacenter in-house on a 10megabit pipe connected to a
90megabit fiber ring out here in Los Angeles. 

I get a LOT out of this list, and can do whatever is needed to assist. No
ads, no ownership, no strings, no need for recognition or donations. :)

Gregory

--- 
annex.com, Inc. - http://www.annex.com/ 
--- 
- If you EcoBuild it, they will come. - 
- http://www.ecobuilder.com/ - 
--- 


> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 17, 2000 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: Re: List slowdown problems and solutions
> 
> 
> Basically, you've nailed the issue right on the head (in both 
> cases). I am
> quite attached to the list ever since it was handed over to 
> me a few years
> back (4?). I don't want to do the corporate route because I 
> feel this should
> be an open, community driven list with no ads or limitations. 
> Additionally,
> your address is NEVER given to others or used in any way 
> other than for this
> list. The same can not be said in either case for egroups, 
> onlist, etc. As
> for community support, we (the FA editorial staff) have been 
> discussing both
> a location for donations as well as a compiled digest version 
> to make it
> easier to look through the weeks mail and get to the content you want.
> The point is, I am working on keeping things going fast and upgrading
> services. I'm hoping that those who were effected by the 
> slowdown (which was
> only about 1/3 of the list) will understand and be patient with me.
> 
> > Mike has probably become quite attached to maintaining and 
> running the
> > list..
> > it's..sort of his baby you know?
> > And those massive Mailing list providers have their 
> problems as well from
> > time to time.
> >
> > -Gel
> >
> > - Original Message -
> > From: Chris Montgomery <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, July 17, 2000 9:42 PM
> > Subject: RE: List slowdown problems and solutions
> >
> >
> > > The last time this list had problems a temporary one was created
> > > (Talk-CF) at egroups (and is still active).  Why not make the move
> > > permanent to egroups or Topica?  That would free up Mike from the
> > > constant burden of having to manage a list on a 
> shoestring budget and
> > > would probably make the list more reliable.  Good/bad idea?
> > >
> > > Chris Montgomery [EMAIL PROTECTED]
> > >
> >
> >
> > 
> --
> 
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>


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

RE: Picture Cache

[Al Musella, DPM]

The problem with this approach is you lose the ability for search engines 
to index the content of your pages.. most won't go into a frameset, because 
if they index a page in a frame, they have no way of loading the frameset 
then inserting the desired file into that frame.
   Frames have their uses sometimes, (rarely:), but I wouldn't give up 
search engines to avoid a little javascript. I would rather just reduce the 
size of the graphics or eliminate them. The best looking site in the world 
is useless if nobody find it.

One of the sites we did required the use of frames to hide URL parameters. 
One of the special features we offer our clients is high search engine 
position. This was the only site we did where we couldn't get them in the 
top 10.  We wound up having to do some strange things - a lot of extra work 
- to create pages just for the search engines to index - that no real 
people would ever see:)

Al Musella
a1webs.com

At 03:55 PM 7/17/2000 -0400, you wrote:

>One trick I've used in the past was to load the images in a hidden frame.
>Create a frameset with cols="100%,*" and use the * frame to load a document
>that contains the images to preload.
>
>
>- Sean


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

RE: CF Express

[David Gassner]

http://www.allaire.com/cfexpress


> -Original Message-
> From: John Allred [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 18, 2000 8:25 AM
> To: [EMAIL PROTECTED]
> Subject: CF Express
>
>
> Can anyone give me a URL where I can download CF Express? I found it on
> Allaire's site previously using search, but that's currently disabled.
>
> Thanks,
> John Allred
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

Re: CF Express

[Erki Esken]

> Can anyone give me a URL where I can download CF Express? I
> found it on Allaire's site previously using search, but that's
> currently disabled.

http://www.allaire.com/products/coldfusion/cfexpress/

btw: does anyone know then CF Express 4.5 for Win/Linux will be
available?


erki

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

RE: List slowdown problems and solutions

[Nicklas af Ekenstam]

Gregory:

>If you need processor and bandwidth, I'd be MORE than happy to provide! We
>use Vircom's VOPMAIL mail servers for our lists (very robust, only missing
>digest support), and post.office as well (which does support digests).. We
>maintain our own datacenter in-house on a 10megabit pipe connected to a
>90megabit fiber ring out here in Los Angeles.
>
>I get a LOT out of this list, and can do whatever is needed to assist. No
>ads, no ownership, no strings, no need for recognition or donations. :)
>
>Gregory

The same goes for me:
If you need some redundance in Europe I'd be more than happy to help out.
Haven't been on the list for a year or so (just got back on the cf 
bandwagon), but I remember how helpful this awesome list is.

I manage a couple of monster unix servers running qmail/ezmlm (fast, very 
fast, and scalable) on a 155megabit pipe with a 10megabit backup pipe.

//Nille





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

RE: Aaarrrgh! CF4.5 screws up ASP on WIN2K

[Dave Watts]

> > "Currently the only way to correct the problem is to reinstall
> > the operating system. You can choose the Upgrade option to retain
> > all your applications and settings."
...
> Does anybody here know of another solution than reinstalling the OS?

No, but this isn't as bad a process as it sounds. You'll simply have to
reinstall any third-party device drivers again after you're done.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

Re: CFMAIL and recordsets

[Matt Taylor]

 I had tried that in a little different order:   the #email# get parsed correctly but that's it, the
message body, only if it comes from a form field, has query variables that
are ignored by CF???

  Thank though...

  -Matt



- Original Message -
From: Deanna L. Schneider <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 11:14 AM
Subject: Re: CFMAIL and recordsets


> Did you reference a query in the cfmail tag? Try adding that if you didn't
> have it before.
>
> i.e.:
> 
>
> your content, including #username#
> 
> 
> Deanna Schneider
> Interactive Media Developer
> UWEX Cooperative Extension Electronic Publishing Group
> 103 Extension Bldg
> 432 N. Lake Street
> Madison, WI 53706
> (608) 265-7923
>
>
>
> --

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

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

new PDF license

[jegan]

with the new adobe license that their products aren't supposed to be installed on the 
server, how can I dynamically create a pdf document from a tab delimited file?

?? - thank you,
je

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

Re: Select list Question and javascript

[Ricq Pattay]

Use Joe Cheng's custom tag ConfirmButton. Very simple to use and just what
you need.

Go to http://devex.allaire.com/developer/gallery/index.cfm and search on
confirmbutton to download it.



Ricq Pattay <[EMAIL PROTECTED]>
Univ of MN College of Veterinary Medicine


- Original Message -
From: Olson, Kelly <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 17, 2000 4:16 PM
Subject: Select list Question and javascript


> Second Question:
> When I delete I would like a popup box for something like "You are about
> to Deleted -  to continue  to return" before an actual
> delete takes place."  How is the best way to do this? I would assume
> that it would be a javascript, but I haven't figured on how to pass
> values to the next cfm page.
>


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

Oracle... ODBC error messages different than native drivers?

[Mike Amburn]

Error messages returned from the Oracle ODBC driver do not provide much
information. For example, the message "invalid argument" doesn't provide any
information about the table or field that causes the error, which is very
helpful in a large join. However, when I plug the query into something like
SQL Plus and run it directly against the database, I get a much better error
message pointing to the offending field.

Which leads me to ask... Would the native driver return a different (or even
better) error message than the Oracle ODBC driver? How exactly does
ColdFusion process database errors?

thanx for any insight
-mike

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

Re: CFMAIL and recordsets

[Deanna L. Schneider]

Wait, the body has variables that are coming from a form - not a query?
There's your problem. You can't reference both a query and a form in the
cfmail tag. I've done workarounds where you create local variables instead.
Maybe someone else knows of a better way to handle this, though.

-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



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

sales tax custom tag

[Eli Shechter]

Hi

does anyone know where i can pick up a custom tag to calculate sales tax in
New York?

Thanx
-Eli Shechter-

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

Re: new PDF license

[Justin MacCarthy]

Have a look at

www.activePDF.com

and also the FDF tags in the Tag Gallery (or the Dev exchange as they call
these days.)

~Justin



- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 4:44 PM
Subject: new PDF license


> with the new adobe license that their products aren't supposed to be
installed on the server, how can I dynamically create a pdf document from a
tab delimited file?
>
> ?? - thank you,
> je
>
> This message sent using EMUmail.  http://EmuMail.com
> --

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

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

Re: new PDF license

[Rey Bango]

je,

Go to ActivePDF.com. They have tools for handling PDFs w/out having to load
Acrobat on the server. We use their tools for our site, OnlineDemocracy.com.

HTH.

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 11:44 AM
Subject: new PDF license


> with the new adobe license that their products aren't supposed to be
installed on the server, how can I dynamically create a pdf document from a
tab delimited file?
>
> ?? - thank you,
> je
>
> This message sent using EMUmail.  http://EmuMail.com
> --

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

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

NT4 vs W2K for CF - benchmarks?

[mherbene]

Has anyone done detailed benchmarks for CF 4.51 on NT 4 vs W2K with
identical hardware?  I'm doing some lightweight benchmarking and see W2K
using a little more processor and having slightly higher Avg Req Time; I
don't currently have the tools or the time to do serious comparisons.

---
Martin Herbener
[EMAIL PROTECTED]
Kentucky Department of Education


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

Re: CFMAIL and recordsets

[Matt Taylor]

 Excellent, I knew it was something like that, thanks for putting it into
words. I did find a little workaround by including a CFM template, that was
defined by the form, and then use cfinclude. It aint too pretty but it
works

  -Matt


- Original Message -
From: Deanna L. Schneider <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 12:03 PM
Subject: Re: CFMAIL and recordsets


> Wait, the body has variables that are coming from a form - not a query?
> There's your problem. You can't reference both a query and a form in the
> cfmail tag. I've done workarounds where you create local variables
instead.
> Maybe someone else knows of a better way to handle this, though.
>
> -d
>
>
>
> 
> Deanna Schneider
> Interactive Media Developer
> UWEX Cooperative Extension Electronic Publishing Group
> 103 Extension Bldg
> 432 N. Lake Street
> Madison, WI 53706
> (608) 265-7923
>
>
>
> --

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

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

application.cfm

[Peter Benoit]

I hear so much about it, yet I'm not sure what I can do with it.  Any online
tutorials or examples I can see?

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

RE: List slowdown problems and solutions

[Diana . Burns]

Hi,

I unsubscribed yesterday morning and received confirmation of the
unsubscribe.  Late yesterday afternoon, PST, I received many e-mails from
the listserv with the same time stamp.  Now I'm continuing to receive them
in batches like this.  I had to resubscribe to post the problem, which is
what I'm doing now.

Is this a problem with the server or is there something else wrong?

This listserve is really great, but just generates too many e-mails for me
to manage effectively.

Thanks,

Diana Burns
[EMAIL PROTECTED]
JDS Uniphase






"Chris Montgomery" <[EMAIL PROTECTED]> on 07/17/2000 05:42:35 PM

Please respond to [EMAIL PROTECTED]

To:   [EMAIL PROTECTED]
cc:(bcc: Diana Burns/US/UNIPHASE)
Subject:  RE: List slowdown problems and solutions




The last time this list had problems a temporary one was created
(Talk-CF) at egroups (and is still active).  Why not make the move
permanent to egroups or Topica?  That would free up Mike from the
constant burden of having to manage a list on a shoestring budget and
would probably make the list more reliable.  Good/bad idea?

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner & NetObjects Reseller
210-490-3249/888-745-7603Fax 210-490-4692
Find a Job in San Antoniohttp://www.sajobnet.com


>-Original Message-
>From: Jennifer [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 17, 2000 5:50 PM
>To: [EMAIL PROTECTED]
>Subject: Re: List slowdown problems and solutions
>
>
>At 03:21 PM 7/17/00 -0700, you wrote:
>>Well this is yet another lag day for the list, where I get
>bombarded with
>>its email all at once, Mike I offer you the following solutions:
>>


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






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

chi.path_info under apache

[Tieying Liu]

This is a multi-part message in MIME format.

--=_NextPart_000_0167_01BFF09E.3DF4B6D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I tried many times to get cgi.path_info under apache but no success. I =
read the Allaire support forum and get a temp solution to get the =
path_info as query_string but it seems ugly. Anyone has better soultion?

Thanks!=20

--=_NextPart_000_0167_01BFF09E.3DF4B6D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









I tried many times to get cgi.path_info =
under=20
apache but no success. I read the Allaire support forum and get a =
temp=20
solution to get the path_info as query_string but it seems ugly. Anyone =
has=20
better soultion?
 
Thanks! 

--=_NextPart_000_0167_01BFF09E.3DF4B6D0--

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

RE: Oracle... ODBC error messages different than native drivers?

[Dave Watts]

> Which leads me to ask... Would the native driver return a
> different (or even better) error message than the Oracle
> ODBC driver?

In my experience, the Oracle native drivers return a different error message
than the ODBC error messages - they're even more obtuse. In fact, the
Allaire knowledge base recommends using ODBC instead of native drivers when
you're trying to figure out why something isn't working.

> How exactly does ColdFusion process database errors?

CF never really communicates directly with the database, as I believe
SQL*Plus does. It returns whatever message the middleware layer sends, as
far as I can tell.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

cgi.path_info under apache

[Tieying Liu]

(Sorry for the previous post...)

I tried many times to get cgi.path_info under apache but no success. I read
the Allaire support forum and get a temp solution to get the path_info as
query_string but it seems ugly. Anyone has better soultion?

Thanks!

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

Re: Oracle... ODBC error messages different than native drivers?

[Ricq Pattay]

Just an additional bit of info:

If I send a malformed query to Oracle using native drivers, and the error
occurs *after* the column headings are returned by the query (this happens
with certain types of errors), the CF server evidently believes the query is
still executing and therefore *no* error is returned to your browser. It
appears as if the server was hanging at this point. This was driving me
crazy until my server guru set the maximum query timeout on the CF server
from 0 to 60 seconds. If I run the same query in SQL Plus, Oracle returns
the column headings with an immediate error message, so anytime I have a
questionable query I always test drive it in SQL Plus first.


Ricq Pattay <[EMAIL PROTECTED]>
Univ of MN College of Veterinary Medicine


- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 11:56 AM
Subject: RE: Oracle... ODBC error messages different than native drivers?


> > Which leads me to ask... Would the native driver return a
> > different (or even better) error message than the Oracle
> > ODBC driver?
>
> In my experience, the Oracle native drivers return a different error
message
> than the ODBC error messages - they're even more obtuse. In fact, the
> Allaire knowledge base recommends using ODBC instead of native drivers
when
> you're trying to figure out why something isn't working.
>
> > How exactly does ColdFusion process database errors?
>
> CF never really communicates directly with the database, as I believe
> SQL*Plus does. It returns whatever message the middleware layer sends, as
> far as I can tell.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --

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

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

RE: NEED HELP Encrypt Url ?

[Karl Simanonok]

Original Message:
===
Date: Mon, 17 Jul 2000 16:47:57 -0400
From: "Steve Bernard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: NEED HELP Encrypt Url ?
Message-ID: <[EMAIL PROTECTED]>

Could you share your solution with the class?

Steve


Sure, but you'll have to adapt it to your specific circumstances.  I
used this custom encryption method when passing around an encrypted
email address in the URL to create a unique identifier for a user.  You
could use it to encrypt almost anything, but you probably don't want it
to be terribly long because this method can expand the email address
into a pretty long string already.



   SELECT DISTINCT
  ConstituentID,
  Password,
  Email
   FROM Auth
   WHERE ConstituentID = '#FORM.UserName#' AND Password =
'#FORM.Password#'





Show error message explaining case-sensitivity of usernames and
passwords
  
   
   








   







   
   
   
  
   














===
DECRYPTION:
===



   
   





   










   










   SELECT AuthID
   FROM Auth
   WHERE ConstituentID = #ListFirst(U,'|')#
   AND Email = '#decodedEmail#'




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

RE: cookies?? or what to use

[Dave Watts]

> Oh, ok. Thanks I didn't know that CGI.HTTP_REFER could be
> disabled by a SYSADMIN.
>
> But then if the CGI.HTTP_REFER can be disabled, then what
> other CGI variable can be disabled then?

You can't count on the existence of CGI variables, in general. There's only
one that will always exist from the browser, and that's the one that
contains the IP address of the browser, CGI.REMOTE_ADDR or CGI.REMOTE_HOST.
Anything else that the browser may provide is optional, so to speak, and can
be removed by proxy servers. As for what's available from the server, that
will depend on how the server is configured, and of course, you can see what
variables your server provides.

All of the variables that begin with "HTTP_" come from the browser.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

RE: CFMAIL and recordsets

[Bill Killillay]

> Wait, the body has variables that are coming from a form - not a query?
> There's your problem. You can't reference both a query and a form in the
> cfmail tag. I've done workarounds where you create local
> variables instead.

Sure you can if you fully qualify the scope of the variable.  Example in
your CF Mail you would reference the form variables by #form.variablename#
and then any other variables by either #session.variablename# or
#client.variablename# or even #query.vairablename#.  In fact I have several
cfmail setups where I use two or three variable sources and as long as I
fully qualify the source I don't have any problems with it.


> Maybe someone else knows of a better way to handle this, though.
>
> -d
>

Bill

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

RE: Installation Error - SmSetRegistry not loaded

[James]

This happens with some 4.01 installations.
The workaround is to copy the CF files for installation to a directory on
your hard drive and then run the installation. After setup has finished,
delete the installation files.

This error was due to a bug in the installation routine. CF is fine.

-Original Message-
From: Brett Payne-Rhodes [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 7:54 AM
To: cf-talk
Subject: Installation Error - SmSetRegistry not loaded


I'm installing a new server with NT4, Apache and ColdFusion Server (of
course!). When I get to the ColdFusion installation I get the message
'SmSetRegistry not loaded: 126' with the title 'UseDLL Failed'.

I've searched Microsoft with no luck. I tried to search Allaire but
search is *still* not working! And I've searched the cf-talk archive,
also with no result...

Any help would be greatly appreciated.

Thanks

Brett Payne-Rhodes
B)

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

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

trim function needed for Oracle

[Jeff Fongemie]

Does anyone know if the trim function with output is needed for an oracle
database?

Jeff Fongemie


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

RE: CFSEARCH and CUSTOM fields

[James]

Francisco,

It is possible to use more than value for custom1 and custom2. When you
write the query
that creates your index,use aggregate functions to build a list of those
values. Then use listgetat() to build your .


Select field1+ ',' + field2 as fieldlist.
..




mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 1:30 AM
To: [EMAIL PROTECTED]
Subject: CFSEARCH and CUSTOM fields


This is a multi-part message in MIME format.

--=_NextPart_000_0071_01BFEFD9.F8721130
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I wonder if someone else had this "little" problem with Verity and the =
CUSTOM1 and CUSTOM2 fields returned after a CFSEARCH.

I don=B4t know if it can be possible. I just want to go into more detail =
on a verity results page, that is, for every resource i show as a result =
i want to show more information about it than just the Name and the id =
from a table to retrieve it at a later time.

For example a resource can have several properties that are represented =
with little icons. If they were two i could use both custom fields to =
store them...  but what if i want to store more than two? or even =
something else? Is there a way of encoding a "list" of values to put in =
these custom fields in order to retrieve all the information i want in a =
results page without actually having to make an extra query to get it?

Comments?

Francisco J. Montes


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









Hi,
 
I wonder if someone else had this=20
"little" problem with Verity and the CUSTOM1 and CUSTOM2 =
fields=20
returned after a CFSEARCH.
 
I don´t know if it can be =
possible. I just=20
want to go into more detail on a verity results page, that is, for every =

resource i show as a result i want to show more information about it =
than just=20
the Name and the id from a table to retrieve it at a later =
time.
 
For example a resource can have =
several=20
properties that are represented with little icons. If they were two i =
could use=20
both custom fields to store them...  but what if i want to store =
more than=20
two? or even something else? Is there a way of encoding a =
"list" of=20
values to put in these custom fields in order to retrieve all the =
information i=20
want in a results page without actually having to make an extra query to =
get=20
it?
 
Comments?
 
Francisco J. Montes
 

--=_NextPart_000_0071_01BFEFD9.F8721130--


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

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

RE: 5 Blank Lines in Excel

[Kevin Plexico]

You probably have the same issue on the page your pulling up (ie the actual
CFM page your executing that has the CFCONTENT tag on it.  You should hide
the output above your CFCONTENT tag with the same CFSETTING.  Just make sure
you turn it off (set it to no) before the CFCONTENT tag.



-Original Message-
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 10:23 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel


Thanks, that eliminated about 2 lines, any other ideas??

Miriam

-Original Message-
From: Kevin Plexico [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 9:23 AM
To: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel


Your probably getting the blank lines from a application.cfm file that is
executing.  You need to wrap your application.cfm code in a

  (providing you don't have any display
code in the application.cfm).

Kevin


-Original Message-
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 11:33 AM
To: CF Forum
Subject: 5 Blank Lines in Excel


Thanks, everyone, with your questions and answers I got my cfcontent to open
a page in excel.  However, I tried everything to get the five blank lines on
the top of the page to disappear.  Can anyone tell me what is causing them
or better yet how to get rid of them.

Thanks,

 ---miriam


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


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


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

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

RE: 5 Blank Lines in Excel

[Miriam Hirschman]

Hi Kevin,

Thanks for your time.  This is my code.





#Form.txtSql#
#preserveSingleQuotes(Form.txtDate)#
ORDER BY Niin







#strGood#   #Activity#  #DateFormat('#MaxOfmyDate#','mm/dd/yyy')#   
#strComment#
#EquipmentValue##DeficitQuantity#




If I put the end  tag any earlier, then I get five lines in
between every row in Excel.

Thanks,

Miriam Hirschman

-Original Message-
From: Kevin Plexico [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 2:28 PM
To: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel


You probably have the same issue on the page your pulling up (ie the actual
CFM page your executing that has the CFCONTENT tag on it.  You should hide
the output above your CFCONTENT tag with the same CFSETTING.  Just make sure
you turn it off (set it to no) before the CFCONTENT tag.



-Original Message-
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 10:23 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel


Thanks, that eliminated about 2 lines, any other ideas??

Miriam

-Original Message-
From: Kevin Plexico [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 9:23 AM
To: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel


Your probably getting the blank lines from a application.cfm file that is
executing.  You need to wrap your application.cfm code in a

  (providing you don't have any display
code in the application.cfm).

Kevin


-Original Message-
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 11:33 AM
To: CF Forum
Subject: 5 Blank Lines in Excel


Thanks, everyone, with your questions and answers I got my cfcontent to open
a page in excel.  However, I tried everything to get the five blank lines on
the top of the page to disappear.  Can anyone tell me what is causing them
or better yet how to get rid of them.

Thanks,

 ---miriam


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


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


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


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

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

dvdmon.com

[Levi Wallach]

Hello,

I've been using Interland (shared hosting) for a few months now, but it
seems like my site is often very slow.  I was wondering if folks could let
me know if they are experiencing the same sluggishness.  I think it's a
connection to the database server as html files and some cfm files that do
not accesss the database seem to come up very fast.  Has anyone had a
similar experience with Interland or any other shared host?


| Levi Wallach - [EMAIL PROTECTED]  P:(703) 237-0443 F: 703-237-3490|
| Senior Webmaster, Tran Interactive Design Group - http://www.tidg.com |

| Creator, DVDMON.com - http://www.dvdmon.com - [EMAIL PROTECTED] |
| DVD News, Views & Reviews, Music & Book Reviews, PDA Channel Content, |
| Contests, DVD Buying Guide and more!  |
-


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

RE: dvdmon.com

[Shane Witbeck]

I do not have a site on Interland because of the simple fact that I have had
nothing but trouble with them in the past.

Sincerely,

Shane Witbeck
Webmaster


-Original Message-
From: Levi Wallach [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 3:06 PM
To: [EMAIL PROTECTED]
Subject: dvdmon.com


Hello,

I've been using Interland (shared hosting) for a few months now, but it
seems like my site is often very slow.  I was wondering if folks could let
me know if they are experiencing the same sluggishness.  I think it's a
connection to the database server as html files and some cfm files that do
not accesss the database seem to come up very fast.  Has anyone had a
similar experience with Interland or any other shared host?


| Levi Wallach - [EMAIL PROTECTED]  P:(703) 237-0443 F: 703-237-3490|
| Senior Webmaster, Tran Interactive Design Group - http://www.tidg.com |

| Creator, DVDMON.com - http://www.dvdmon.com - [EMAIL PROTECTED] |
| DVD News, Views & Reviews, Music & Book Reviews, PDA Channel Content, |
| Contests, DVD Buying Guide and more!  |
-



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

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

Tier 1 ISP's in Los Angeles

[Scott Williams]

Hi all,

I'm looking for a Tier 1 ISP located in Los Angeles to host a couple of
websites.

Any suggestions?

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

a CFText input device

[Rod Tosten]

To All-

has anyone implemented a CFTextArea that would have these parameters
Validated=""
Maxlength=""
Required="Yes/No"
along with the normal HTML textarea attributes

some thing consistent with CFINPUT, etc...

thanks,

-rod

Associate Professor, Gettysburg College
Programmer/Architect, CNAV Systems

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

Re: Tier 1 ISP's in Los Angeles

[Rey Bango]

Scott,

Tier 1 ISPs like Exodus & AboveNet can be very pricey. Is your site a huge
endeavor?

Also, any specific reason that you need one based in LA? You should be able
to host your site just about anywhere. One the best hosting companies that
I've found is VirtualScape. They also know their CF.

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: "Scott Williams" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 4:43 PM
Subject: Tier 1 ISP's in Los Angeles


> Hi all,
>
> I'm looking for a Tier 1 ISP located in Los Angeles to host a couple of
> websites.
>
> Any suggestions?
>
> Scott
> --

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

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

RE: 5 Blank Lines in Excel

[Dave Watts]

> Thanks for your time.  This is my code.
>
> 
> 
> 
> #Form.txtSql#
> #preserveSingleQuotes(Form.txtDate)#
> ORDER BY Niin
> 
> 
> 
> 
> 
> 
> 
> #strGood# #Activity#
> #DateFormat('#MaxOfmyDate#','mm/dd/yyy')# #strComment#
> #EquipmentValue#  #DeficitQuantity#
> 
> 
>
>
> If I put the end  tag any earlier, then I get five lines in
> between every row in Excel.

Try this:



...



"#REReplace(niin, "[[:cntrl:]]", " ",
"ALL")#","#Activity#","#DateFormat(MaxOfMyDate,
"mm/dd/")#","#REReplace(Comment, "[[:cntrl:]]", " ",
"ALL")#","#EquipmentValue#",#DeficitQuantity#


This will output the data in CSV format, so you might want to name the file
as a CSV file. Since this'll wrap in your mail client, put all the variables
on the first line, and put the closing CFOUTPUT tag on the following line.
Don't put any HTML tags in the page, and put the CFHEADER before the
CFCONTENT tag. If you're using CF 4.5.x, you could use CFSILENT instead of
CFSETTING; it might work a bit better. In any case, it shouldn't matter if
there are a couple of blank lines before your data; Excel shouldn't have any
trouble opening the file.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

Insert INTO syntax error - HELP

[Erika Foster]

I can't find the syntax error in the following INSERT INTO
statement - someone with good eyes, please help me out!


 INSERT INTO OWS (owsid, type, date, capacity, length, width, height,
manufacturer, serial,
discharge, repairs, repairdates, cleaning1, cleaning2, contractorname,
contractoraddress,
contractorPOC, contractorphone, license, sludge, sample, locationid,
siteid)

VALUES ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
'#thislength#',
 '#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
'#thisdischarge#',
 '#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
'#thiscleaning2#', '#Thiscontractorname#',
 '#thiscontractoraddress#', '#thiscontractorPOC#',
'#thiscontractorphone#', '#thislicense#',
 '#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
  

gives this result with dummy data:

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.


SQL = "INSERT INTO OWS (owsid, type, date, capacity, length, width, height,
manufacturer, serial, discharge, repairs, repairdates, cleaning1, cleaning2,
contractorname, contractoraddress, contractorPOC, contractorphone, license,
sludge, sample, locationid, siteid) VALUES ('1', 'jkl', 'jkl', 'jkl', 'jk',
'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
'jk', 'jk', 'jk', 'jk', '02', '27A25')"



Thanks for you help!


Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]

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

Re: dvdmon.com

[Mooner Ent]

I have a $5K a quarter account with them right now and can't wait to move!
The problems are endless.

Regardless, the database driven sites I have over there are running well, I
just checked them a second ago and all is well.

Rick




- Original Message -
From: "Shane Witbeck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 12:11 PM
Subject: RE: dvdmon.com


> I do not have a site on Interland because of the simple fact that I have
had
> nothing but trouble with them in the past.
>
> Sincerely,
>
> Shane Witbeck
> Webmaster
>
>
> -Original Message-
> From: Levi Wallach [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 18, 2000 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: dvdmon.com
>
>
> Hello,
>
> I've been using Interland (shared hosting) for a few months now, but it
> seems like my site is often very slow.  I was wondering if folks could let
> me know if they are experiencing the same sluggishness.  I think it's a
> connection to the database server as html files and some cfm files that do
> not accesss the database seem to come up very fast.  Has anyone had a
> similar experience with Interland or any other shared host?
>
> 
> | Levi Wallach - [EMAIL PROTECTED]  P:(703) 237-0443 F: 703-237-3490|
> | Senior Webmaster, Tran Interactive Design Group - http://www.tidg.com |
> 
> | Creator, DVDMON.com - http://www.dvdmon.com - [EMAIL PROTECTED] |
> | DVD News, Views & Reviews, Music & Book Reviews, PDA Channel Content, |
> | Contests, DVD Buying Guide and more!  |
> -
>
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --

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


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Insert INTO syntax error - HELP

[Dave Watts]

> SQL = "INSERT INTO OWS (owsid, type, date, capacity, length,
> width, height, manufacturer, serial, discharge, repairs,
> repairdates, cleaning1, cleaning2, contractorname,
> contractoraddress, contractorPOC, contractorphone, license,
> sludge, sample, locationid, siteid) VALUES ('1', 'jkl',
> 'jkl', 'jkl', 'jk', 'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk',
> 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
> '02', '27A25')"

Are the owsid and siteid fields string fields? If not, that's probably your
problem.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

RE: Insert INTO syntax error - HELP

[mherbene]

Good chance that you're using some Access reserved words, especially date
and type; you can check Access help for a list of reserved words.  Change
the names of any fields that are reserved words.

-Original Message-
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 4:52 PM
To: [EMAIL PROTECTED]
Subject: Insert INTO syntax error - HELP


I can't find the syntax error in the following INSERT INTO
statement - someone with good eyes, please help me out!


 INSERT INTO OWS (owsid, type, date, capacity, length, width, height,
manufacturer, serial,
discharge, repairs, repairdates, cleaning1, cleaning2, contractorname,
contractoraddress,
contractorPOC, contractorphone, license, sludge, sample, locationid,
siteid)

VALUES ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
'#thislength#',
 '#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
'#thisdischarge#',
 '#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
'#thiscleaning2#', '#Thiscontractorname#',
 '#thiscontractoraddress#', '#thiscontractorPOC#',
'#thiscontractorphone#', '#thislicense#',
 '#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
  

gives this result with dummy data:

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.


SQL = "INSERT INTO OWS (owsid, type, date, capacity, length, width, height,
manufacturer, serial, discharge, repairs, repairdates, cleaning1, cleaning2,
contractorname, contractoraddress, contractorPOC, contractorphone, license,
sludge, sample, locationid, siteid) VALUES ('1', 'jkl', 'jkl', 'jkl', 'jk',
'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
'jk', 'jk', 'jk', 'jk', '02', '27A25')"



Thanks for you help!


Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]


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

Re: Insert INTO syntax error - HELP

[Erika Foster]

Yeah - everything is a string field in this table because it has to be -
OWSID and siteid could both be alphanumeric.

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 3:03 PM
Subject: RE: Insert INTO syntax error - HELP


: > SQL = "INSERT INTO OWS (owsid, type, date, capacity, length,
: > width, height, manufacturer, serial, discharge, repairs,
: > repairdates, cleaning1, cleaning2, contractorname,
: > contractoraddress, contractorPOC, contractorphone, license,
: > sludge, sample, locationid, siteid) VALUES ('1', 'jkl',
: > 'jkl', 'jkl', 'jk', 'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk',
: > 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
: > '02', '27A25')"
:
: Are the owsid and siteid fields string fields? If not, that's probably
your
: problem.
:
: Dave Watts, CTO, Fig Leaf Software
: http://www.figleaf.com/
: voice: (202) 797-5496
: fax: (202) 797-5444
:

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

Re: Insert INTO syntax error - HELP

[Sean Renet]

I assume owsid and locationid are numbers, they should not have single
quotes around them.
- Original Message -
From: "Erika Foster" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 1:52 PM
Subject: Insert INTO syntax error - HELP


> I can't find the syntax error in the following INSERT INTO
> statement - someone with good eyes, please help me out!
>
> 
>  INSERT INTO OWS (owsid, type, date, capacity, length, width, height,
> manufacturer, serial,
> discharge, repairs, repairdates, cleaning1, cleaning2, contractorname,
> contractoraddress,
> contractorPOC, contractorphone, license, sludge, sample, locationid,
> siteid)
>
> VALUES ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
> '#thislength#',
>  '#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
> '#thisdischarge#',
>  '#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
> '#thiscleaning2#', '#Thiscontractorname#',
>  '#thiscontractoraddress#', '#thiscontractorPOC#',
> '#thiscontractorphone#', '#thislicense#',
>  '#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
>   
>
> gives this result with dummy data:
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
>
>
> SQL = "INSERT INTO OWS (owsid, type, date, capacity, length, width,
height,
> manufacturer, serial, discharge, repairs, repairdates, cleaning1,
cleaning2,
> contractorname, contractoraddress, contractorPOC, contractorphone,
license,
> sludge, sample, locationid, siteid) VALUES ('1', 'jkl', 'jkl', 'jkl',
'jk',
> 'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
> 'jk', 'jk', 'jk', 'jk', '02', '27A25')"
>
>
>
> Thanks for you help!
>
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
>
> --

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

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

Re: Insert INTO syntax error - HELP

[Deanna L. Schneider]

Right off the bat, I'd say...do you have any number fields? Like, for
instance, your id field? If it's a number, leave off the ' marks. Also,
you'll probably need to do something like this:

createodbcdate(thisdate) to convert the date field into an odbc format
(assuming an odbc type database such as access.

Also, "date" is a reserved word, so you'll want to change it in your
database to something like "mydate" or "thisdate." Hm...type might be a
reserved word, too...but I'm not sure on that one.

Hope that helps you along.

-Deanna




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



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

Cold Fusion ISP search

[Karl Simanonok]

I'm looking for an ISP who supports CF 4.5.1 and SQL Server 7 for an
application I'm ready to bring online.  I need at least 50MB for the
database at the outset (it's 37 MB starting out), and probably only 5MB
for templates, but the DB will grow over time so in 6 months it may be
100MB or so.

Strong Preferences: unlimited bandwidth (but 10GB/mo is okay),
high-speed connection to the backbone, servers not crowded with too many
apps, FTP access, SQL Server Enterprise Manager remote access.

Dream ISP: access to CF Administrator, CFFILE allowed, unlimited domain
names (perhaps a small setup fee for each, but no monthly recurring
costs).

I'd appreciate any recommendations for providers meeting these specs,
especially 'Dream ISPs'.

Thanks,

Karl Simanonok

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

Re: Insert INTO syntax error - HELP

[Erika Foster]

Thanks everyone!

Changing the DATE field name did the trick.

Erika
- Original Message -
From: "Deanna L. Schneider" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 3:15 PM
Subject: Re: Insert INTO syntax error - HELP


: Right off the bat, I'd say...do you have any number fields? Like, for
: instance, your id field? If it's a number, leave off the ' marks. Also,
: you'll probably need to do something like this:
:
: createodbcdate(thisdate) to convert the date field into an odbc format
: (assuming an odbc type database such as access.
:
: Also, "date" is a reserved word, so you'll want to change it in your
: database to something like "mydate" or "thisdate." Hm...type might be a
: reserved word, too...but I'm not sure on that one.
:
: Hope that helps you along.
:
: -Deanna
:
:
:
: 
: Deanna Schneider
: Interactive Media Developer
: UWEX Cooperative Extension Electronic Publishing Group
: 103 Extension Bldg
: 432 N. Lake Street
: Madison, WI 53706
: (608) 265-7923
:
:
:
: --

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

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

Re: Tier 1 ISP's in Los Angeles

[Scott Williams]

Hi Rey,

Yes, it's a big endeavor. And one of the requirements is that it be in
LA. I know we could host a site anywhere, but we want to be able to stop
by and visit it and the people managing it.

Thanks!

Scott

BTW -- Exodus is in Santa Clara and AboveNet is in La Jolla, neither of
which are in LA.

Rey Bango wrote:
> 
> Scott,
> 
> Tier 1 ISPs like Exodus & AboveNet can be very pricey. Is your site a huge
> endeavor?
> 
> Also, any specific reason that you need one based in LA? You should be able
> to host your site just about anywhere. One the best hosting companies that
> I've found is VirtualScape. They also know their CF.
> 
> Rey...
> Certified Allaire Instructor
> Member of Team Allaire
> 
> "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> 
> - Original Message -
> From: "Scott Williams" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 18, 2000 4:43 PM
> Subject: Tier 1 ISP's in Los Angeles
> 
> > Hi all,
> >
> > I'm looking for a Tier 1 ISP located in Los Angeles to host a couple of
> > websites.
> >
> > Any suggestions?
> >
> > Scott
> > --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Cold Fusion ISP search

[Nrhorwitz]

Try www.powersurge.net

I love them, I've had few minor problems and they certainly paid attention to 
my requests right away. Overall their quality of service is up there high.

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

CF Logs & error numbers

[JF]

Greetings -

Is there a definitive list somewhere that correlates error numbers logged 
by CF to what the problem really is?  I've been chasing some errors showing 
up in my various logs but can't trace it back to what caused the problem, 
or even what the problem (if any) is.

There aren't any matching entries in application.log or scheduler.log with 
the same TID or date stamp, so not sure where else to look.

Examples:

Server.log
"Error","TID=130","07/18/00","07:53:53","Error number 232 occurred while 
attempting to write the reply to the web server."
"Error","TID=130","07/18/00","07:53:53","Windows NT error number 232 occurred."

Webserver.log
"Error","TID=240","07/18/00","08:19:52","Error attempting to write location 
redirection to web server (Windows NT error number 16389 occurred)"

This is a fairly busy box with lots of scheduled tasks, and everything 
appears to be working fine (plus very low CPU and process queue numbers), 
just bugs me to see these errors stacking up.

BTW, this is CF Enterprise 4.01, NT 4.0 SP6a, IIS4, dual P-II w/256MB 
(156MB free).

Thanks in advance!

Jay

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

RE:

[Dan G. Switzer, II]

Nicklas,

It's available off my web site:
http://www.pengoworks.com/

-Dan
++---+
|   name | Dan G. Switzer, II|
|company | PengoWorks.com|
|www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED]   |
++---+


-Original Message-
From: Nicklas af Ekenstam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 8:18 AM
To: [EMAIL PROTECTED]
Subject: 

Hi!

I'm trying to download  from allaire using:

Can't seem to find the download link...
Anybody here have the tag and wouldn't mind mailing it to me offlist or a
valid download url?

Thanks!

//Nille



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

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

RE: Tier 1 ISP's in Los Angeles

[Steve Pierce]

Lots of places claim to be a Tier1, but they end up being a shared node in a
big data center or one of hundreds of hosts all sharing the same 45MB T3
line. Test the links to their sites from several different sites over a
period of time to look at performance. I have seen hosts with a single
1.54Mb T1 beat the pants off a supposed Tier1 DS3 155Mb ATM host. They had
better connectivity upstream and fewer people sharing the connection.

I don't claim to be a Tier1, but we run a multi-point T3 out of our center
and I usually can beat most of the Tier1 in ping times and I charge $199 a
month for a 1U rack with no setup fee. Whatever you do don't sign a long
term contract, try out your host for a couple of months and make sure it is
easy to get back your equipment if it doesn't work out. Finally, check
references

Good Luck,

 - Steve


-Original Message-
From: Scott Williams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 4:43 PM
To: [EMAIL PROTECTED]
Subject: Tier 1 ISP's in Los Angeles


Hi all,

I'm looking for a Tier 1 ISP located in Los Angeles to host a couple of
websites.

Any suggestions?

Scott

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

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

Re: Tier 1 ISP's in Los Angeles

[Scott Williams]

Thanks for the tips, Steve!

Scott

Steve Pierce wrote:
> 
> Lots of places claim to be a Tier1, but they end up being a shared node in a
> big data center or one of hundreds of hosts all sharing the same 45MB T3
> line. Test the links to their sites from several different sites over a
> period of time to look at performance. I have seen hosts with a single
> 1.54Mb T1 beat the pants off a supposed Tier1 DS3 155Mb ATM host. They had
> better connectivity upstream and fewer people sharing the connection.
> 
> I don't claim to be a Tier1, but we run a multi-point T3 out of our center
> and I usually can beat most of the Tier1 in ping times and I charge $199 a
> month for a 1U rack with no setup fee. Whatever you do don't sign a long
> term contract, try out your host for a couple of months and make sure it is
> easy to get back your equipment if it doesn't work out. Finally, check
> references
> 
> Good Luck,
> 
>  - Steve
> 
> -Original Message-
> From: Scott Williams [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 18, 2000 4:43 PM
> To: [EMAIL PROTECTED]
> Subject: Tier 1 ISP's in Los Angeles
> 
> Hi all,
> 
> I'm looking for a Tier 1 ISP located in Los Angeles to host a couple of
> websites.
> 
> Any suggestions?
> 
> Scott
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Tier 1 ISP's in Los Angeles

[Steve Aylor]

What  you didnt here that everything south of San Fran is LA? Come on
man get with the times :-)

The only people that come to mind is EPOCH - doubt they will meet your needs
but they may be good for a recommendation.

James 949.862.8284 - this office is in Irvine, CA - but I beleive they have
"goings on" in LA County

HTH,

Steve

- Original Message -
From: "Scott Williams" <[EMAIL PROTECTED]>

> Hi Rey,
>
> Yes, it's a big endeavor. And one of the requirements is that it be in
> LA. I know we could host a site anywhere, but we want to be able to stop
> by and visit it and the people managing it.
>
> Thanks!
>
> Scott
>
> BTW -- Exodus is in Santa Clara and AboveNet is in La Jolla, neither of
> which are in LA.
>
> Rey Bango wrote:
> >
> > Scott,
> >
> > Tier 1 ISPs like Exodus & AboveNet can be very pricey. Is your site a
huge
> > endeavor?
> >
> > Also, any specific reason that you need one based in LA? You should be
able
> > to host your site just about anywhere. One the best hosting companies
that
> > I've found is VirtualScape. They also know their CF.
> >
> > Rey...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."


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

Re: Cold Fusion ISP search

[Karl Simanonok]

--5667575D024EBE5A43669D4F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Shanje.com would be perfect, except they don't support SQL Server.  I tested my
application with Access, and it's too slow to process the 200,000 or so records
in a reasonable time.

Thanks for the suggestion anyway, Steve.  Does anyone else know an ISP that
meets the requirements below?

Thanks,

Karl Simanonok

Steve Pierce wrote:

> www.shanje.com
>
> -Original Message-
> From: Karl Simanonok [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 18, 2000 5:16 PM
> To: [EMAIL PROTECTED]
> Subject: Cold Fusion ISP search
>
> I'm looking for an ISP who supports CF 4.5.1 and SQL Server 7 for an
> application I'm ready to bring online.  I need at least 50MB for the
> database at the outset (it's 37 MB starting out), and probably only 5MB
> for templates, but the DB will grow over time so in 6 months it may be
> 100MB or so.
>
> Strong Preferences: unlimited bandwidth (but 10GB/mo is okay),
> high-speed connection to the backbone, servers not crowded with too many
> apps, FTP access, SQL Server Enterprise Manager remote access.
>
> Dream ISP: access to CF Administrator, CFFILE allowed, unlimited domain
> names (perhaps a small setup fee for each, but no monthly recurring
> costs).
>
> I'd appreciate any recommendations for providers meeting these specs,
> especially 'Dream ISPs'.
>
> Thanks,
>
> Karl Simanonok
>
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.

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



Shanje.com would be perfect, except they don't support SQL Server. 
I tested my application with Access, and it's too slow to process the 200,000
or so records in a reasonable time.
Thanks for the suggestion anyway, Steve.  Does anyone else know
an ISP that meets the requirements below?
Thanks,
Karl Simanonok
Steve Pierce wrote:
www.shanje.com
-Original Message-
From: Karl Simanonok [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 5:16 PM
To: [EMAIL PROTECTED]
Subject: Cold Fusion ISP search
I'm looking for an ISP who supports CF 4.5.1 and SQL Server 7 for an
application I'm ready to bring online.  I need at least 50MB for
the
database at the outset (it's 37 MB starting out), and probably only
5MB
for templates, but the DB will grow over time so in 6 months it may
be
100MB or so.
Strong Preferences: unlimited bandwidth (but 10GB/mo is okay),
high-speed connection to the backbone, servers not crowded with too
many
apps, FTP access, SQL Server Enterprise Manager remote access.
Dream ISP: access to CF Administrator, CFFILE allowed, unlimited domain
names (perhaps a small setup fee for each, but no monthly recurring
costs).
I'd appreciate any recommendations for providers meeting these specs,
especially 'Dream ISPs'.
Thanks,
Karl Simanonok

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


--5667575D024EBE5A43669D4F--

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

Problems With CFGRID Display

[Double Down]

Having a problem displaying CFGRID in Netscape and in some versions of IE.
When the grid loads this error comes up: Applet
allaire.controls.cfGridFormApplet class allaire.controld.cfGridFormApples
could not be loaded.

CFIDE is loaded in the root of the directory.

Any ideas on how to get this to work?

TIA
DDINC

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

RE: Cold Fusion ISP search

[Shane Witbeck]

Other than a dedicated server solution it sounds like Virtualscape.com would
be your best bet for the robust features you are looking for.

Sincerely,

Shane Witbeck
Webmaster



-Original Message-
From: Karl Simanonok [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 5:16 PM
To: [EMAIL PROTECTED]
Subject: Cold Fusion ISP search


I'm looking for an ISP who supports CF 4.5.1 and SQL Server 7 for an
application I'm ready to bring online.  I need at least 50MB for the
database at the outset (it's 37 MB starting out), and probably only 5MB
for templates, but the DB will grow over time so in 6 months it may be
100MB or so.

Strong Preferences: unlimited bandwidth (but 10GB/mo is okay),
high-speed connection to the backbone, servers not crowded with too many
apps, FTP access, SQL Server Enterprise Manager remote access.

Dream ISP: access to CF Administrator, CFFILE allowed, unlimited domain
names (perhaps a small setup fee for each, but no monthly recurring
costs).

I'd appreciate any recommendations for providers meeting these specs,
especially 'Dream ISPs'.

Thanks,

Karl Simanonok


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

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

Cookie interpretation in JavaScript.

[OleBlighty]

He guys,

I provide a help function in my application and set a Cookie with the full
path of the help template.  When I  the contents I get the correct
value..ie

C:\INETPUB\WWWROOT\SITES\FRP\Help\Temp_hlp.cfm

But, when I use this value in JavaScript (a simple alert("#Cookie.Help#")
for testing purposes), I get the following value...

C:INETPUBWWWROOTSITESFRPHelpTemp_hlp.cfm

I am obviously missing a trick here, can anyone tell me what I am doing
incorrectly.  Thanks very much guys.

Mark.


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

RE: Tier 1 ISP's in Los Angeles

[Gregory Gooden (Annex)]

We're not what you'd call "TIER 1", but we maintain our OWN cozy datacenter
in Sherman Oaks (in our offices) via a 10megabit CAT5 ethernet to a Catalyst
router with 90Megabits of bandwidth through the Los Nettos Network (a fiber
ring in LA with lots of major peering points).. :)

We're a development house that just happens to have some great bandwidth. :)

Gregory


--- 
annex.com, Inc. - http://www.annex.com/ 
--- 
- If you EcoBuild it, they will come. - 
- http://www.ecobuilder.com/ - 
--- 


> -Original Message-
> From: Scott Williams [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 18, 2000 1:43 PM
> To: [EMAIL PROTECTED]
> Subject: Tier 1 ISP's in Los Angeles
> 
> 
> Hi all,
> 
> I'm looking for a Tier 1 ISP located in Los Angeles to host a 
> couple of
> websites.
> 
> Any suggestions?
> 
> Scott
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

cfhttp and SSL - A new twist??

[Bud]

Hi. I'm aware of the cfhttp and SSL problems with CF and NT. I 
installed IE 5 as soon as I heard about it. Haven't had a problem 
since with any connection.

BUT!

I'm trying to with a custom tag to connect with a new transaction 
processor of a client of mine. It works great on my Win 98 box, and 
it works great on virtualscape's NT servers running CF 4.5, but it 
won't work on MY NT box (SP 5) with CF 4.01. If I take the 's' off of 
https, it works fine. I went and tested a couple others I use, 
authorizenet, processingnet, gochargetit, etc, and they all connect 
fine through https.

What could it be about this one processor that causes me a problem? 
If I open IE itself on the machine and go to the url it connects fine 
without any warnings or anything.

HELP!
-- 

Bud Schneehagen - Tropical Web Creations

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

RE: trim function needed for Oracle

[Dan Haley]

I'm not sure what you mean.  As far as pulling data out of Oracle and using
it in CF there has never been a need to trim the data.  We have run into
bugs with the Oracle apps that require us to trim data going into certain
fields or the apps croak on it . . . no idea why, but that was Oracle's
solution.

Again, the database itself has never required us to trim data for any kind
of output or input.

Dan

-Original Message-
From: Jeff Fongemie
To: Cf-Talk
Sent: 7/18/2000 11:21 AM
Subject: trim function needed for Oracle 

Does anyone know if the trim function with output is needed for an
oracle
database?

Jeff Fongemie



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

Re: Insert INTO syntax error - HELP

[Dick Applebaum]

Are all your fields character/text fields?



At 2:52 PM -0600 7/18/2000, Erika Foster wrote:
>I can't find the syntax error in the following INSERT INTO
>statement - someone with good eyes, please help me out!
>
>
>  INSERT INTO OWS (owsid, type, date, capacity, length, width, height,
>manufacturer, serial,
> discharge, repairs, repairdates, cleaning1, cleaning2, contractorname,
>contractoraddress,
> contractorPOC, contractorphone, license, sludge, sample, locationid,
>siteid)
>
>VALUES ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
>'#thislength#',
>  '#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
>'#thisdischarge#',
>  '#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
>'#thiscleaning2#', '#Thiscontractorname#',
>  '#thiscontractoraddress#', '#thiscontractorPOC#',
>'#thiscontractorphone#', '#thislicense#',
>  '#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
>   
>
>gives this result with dummy data:
>
>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
>statement.
>
>
>SQL = "INSERT INTO OWS (owsid, type, date, capacity, length, width, height,
>manufacturer, serial, discharge, repairs, repairdates, cleaning1, cleaning2,
>contractorname, contractoraddress, contractorPOC, contractorphone, license,
>sludge, sample, locationid, siteid) VALUES ('1', 'jkl', 'jkl', 'jkl', 'jk',
>'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
>'jk', 'jk', 'jk', 'jk', '02', '27A25')"
>
>
>
>Thanks for you help!
>
>
>Erika Foster
>engineering-environmental Management
>Applications Developer
>(505) 866-1654
>[EMAIL PROTECTED]
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal 
>k or send a message to [EMAIL PROTECTED] with 
>'unsubscribe' in the body.

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