Re: URgent CFServer maxing CPU and JIT error on Production Server.

2000-09-30 Thread Rahul Joshi
Just try by removing sp6a & installing sp5. Also if doesn't work remove MDAC 2.5 & install the original 2.3 which comes with CF Server. Rahul > The environment is NT4, SP6a, CF4.51 Enterprise, 99% Access db's, MDAC 2.5, > IIS4.0 > > The code was working totally error free on the previous mach

Which is Faster?

2000-09-30 Thread paul smith
Which do you expect to be faster? 1 or 2? Why? 1. 2. best, paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&bod

Upsizing Problems using access 2000 to sql

2000-09-30 Thread AustralianAccommodation.com Pty. Ltd.
I am trying to upsize some of my tables that are full of data upsized fine according to the upsize report whilst other tables with little data did not table one table as an example Properties Categories it has 2 fields in it an id field that is the primary key and a category field the id field

Re: Client & Session variables?

2000-09-30 Thread paul smith
Well, there are cookies. They're in the browser only, and not set on the user's machine. So they can maintain state in a session, but not be useful from one session to another. best, paul At 08:56 PM 9/30/00 -0400, you wrote: >On 9/30/00, paul smith penned: > >"Accept only cookies that get se

Re: A Rookie Question??

2000-09-30 Thread Dick Applebaum
Best short answer you'll ever find is Ch. 6 of Forta's book CFWAK HTH Dick At 11:19 PM -0400 9/30/00, HappyToad.com wrote: >I am learning Cold Fusion using the MS Access database and learning more and >more each day. What is the difference between using Access and SQL? Is is >just that SQL is

A Rookie Question??

2000-09-30 Thread HappyToad.com
I am learning Cold Fusion using the MS Access database and learning more and more each day. What is the difference between using Access and SQL? Is is just that SQL is for larger applications? Is it just as easy to use SQL? I am in the dark on this, please shed some light. Thanks, Rich -

Wantad/ Classifieds program

2000-09-30 Thread Gregg Kachel
Hello, Was wondering if anyone knows of a good CF or perhaps perl Want Ad program. It needs it to beable to take credit cards, notify people when there ad is about to expire and allows them to edit/ and ad pictures to there ad. Price probably around $300.00 or below ? ---

Re: Client & Session variables?

2000-09-30 Thread Bud
On 9/30/00, paul smith penned: >I just noticed that a comma-delimited List of numerals can be stored as a >Client variable in a database without having to be >WDDX-serialized. Cool. This saves some processing overhead. Anything that's a string can be stored as a client variable without WDDX. I

Re: Client & Session variables?

2000-09-30 Thread Bud
On 9/30/00, paul smith penned: >"Accept only cookies that get sent back to the originating server" > >Then state is maintained from one click to the next (and I assume no cookie >is set on the users machine). Really? If they can maintain state from one click to the next without cookies and witho

Re: Client & Session variables?

2000-09-30 Thread paul smith
I just noticed that a comma-delimited List of numerals can be stored as a Client variable in a database without having to be WDDX-serialized. Cool. This saves some processing overhead. best, paul At 09:15 AM 9/30/00 -0400, you wrote: >The biggest difference in the setup is, if you have comp

Re: Reading a file one line at a time with CFfile?

2000-09-30 Thread Terry - it-werks.com
Jim, Thanks for the lightening quick reply. I totally forgot about the carraige return. I will work with your method as it sure looks sound. Thanks again Terry Troxel - Original Message - From: Jim McAtee <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Cc: "Terry - it-werks.com" <[

Re: Client & Session variables?

2000-09-30 Thread paul smith
Right. New cfid/cftoken every click (in IE). However, if the user selects the following in Netscrape: "Accept only cookies that get sent back to the originating server" Then state is maintained from one click to the next (and I assume no cookie is set on the users machine). best, paul At 0

Re: Reading a file one line at a time with CFfile?

2000-09-30 Thread Jim McAtee
With CFFILE you're only able to read the entire file into a variable. Treat the file contents as a list, using carriage returns and/or line feeds as delimiters. Because of the way CF handles lists and delimiters, the following code works regardless of whether carriage returns, line feeds or any

Re: Client & Session variables?

2000-09-30 Thread Bud
On 9/30/00, W Luke penned: >Am I right in saying that using the database as the Client Storage method, >if the user doesn't have Cookies enabled it will still work? (i.e. pull >client's token from database, and client. variables). Or am I way off the >mark? As long as you pass cfid and cftoken i

Reading a file one line at a time with CFfile?

2000-09-30 Thread Terry - it-werks.com
I have a text file that is 1315 characters wide, which is an exported Cobol database that I reed to go through one record/line at a time and do some mid() calls to retreive certain fields and insert them into an Access table. I am unsure how to walk thru the file line by line. I do know how to use

Re: storing CF code in a database

2000-09-30 Thread Peter Theobald
Sure. It's easy. Just use a query to store it and later retrieve it and run it with evaluate(variable). At 03:07 PM 9/30/00 -0500, Camden Spiller wrote: >This is a multi-part message in MIME format. > >--=_NextPart_000_010C_01C02AF0.368B7280 >Content-Type: text/plain; >charset="iso-

Re: query caching?

2000-09-30 Thread Dick Applebaum
At 3:08 PM -0400 9/30/00, Jon Hall wrote: >Unfortunately with the large amount of items that the customer has control >of, they can add and delete items at will. Letting CF cache queries wont >work since there are no static queries The large # of items and the ability to update/insert/delete item

storing CF code in a database

2000-09-30 Thread Camden Spiller
This is a multi-part message in MIME format. --=_NextPart_000_010C_01C02AF0.368B7280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it possible to store CF code in a database and then pull it out with = a query and run the code? Camden

Re: query caching?

2000-09-30 Thread paul smith
CF caches dynamic queries, too. It includes the SQL to distinguish one dynamic query from another. For example, since #REQUEST.alpha# has the value of each of the 26 letters in the alphabet, the following query is chached in 26 different Queries, even though in my CF code I refer to all as RE

Worldpay

2000-09-30 Thread W Luke
Hi all, I wonder, has anyone used Worldpay for any of their Clients or apps with Cold Fusion - have you had any problems with it? Cheers :) Will -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Un

RE: creating word docs and excel sheets on the fly...

2000-09-30 Thread Warrick, Mark
I like the HTML idea. That's a good one. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://w

RE: creating word docs and excel sheets on the fly...

2000-09-30 Thread Peter Stolz
Another idea: For Word: Run the queries, create an HTML file and save it to disk. Then open it in Word and save it as a Word doc.(mailto:[EMAIL PROTECTED]] Sent: Saturday, September 30, 2000 3:14 PM To: CF-Talk Subject: creating word docs and excel sheets on the fly... I asked this question a co

RE: creating word docs and excel sheets on the fly...

2000-09-30 Thread Shane Witbeck
Seems as if you need to run some VB scripts to accomplish this. I recently read an article (in CFDJ i think) that talked about this using a combination of WDDX and VB. Good luck! Sincerely, Shane Witbeck Webmaster mailto:[EMAIL PROTECTED] www.digitalsanctum.com -Original Message- Fro

RE: creating word docs and excel sheets on the fly...

2000-09-30 Thread Peter Stolz
This is certainly possible using and VBA. Do a search for 'Working with Tables' in Word's VB editor help to see code samples. ASP is probably a better choice than CF for this one. P. -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 30, 2000 3:1

creating word docs and excel sheets on the fly...

2000-09-30 Thread Warrick, Mark
I asked this question a couple days ago and received no responses, so I'm beginning to believe this is not possible. I need to create a word doc or excel spreadsheet based upon a set of queries. I know how to pass raw data into these new documents, that's no problem. The problem is that I'd

Re: query caching?

2000-09-30 Thread Jon Hall
Unfortunately with the large amount of items that the customer has control of, they can add and delete items at will. Letting CF cache queries wont work since there are no static queries (unless..just had a thought, see below). Maybe as we go on and collect some statistics as to what is popular.

Re: Client & Session variables?

2000-09-30 Thread W Luke
> The problem with this, client variables can be set to be purged from > the database after a set period, so unless you have your own server, > you're at the mercy of the host. Am I right in saying that using the database as the Client Storage method, if the user doesn't have Cookies enabled it

Re: Client & Session variables?

2000-09-30 Thread Bud
--_-1241783480==_ma Content-Type: text/plain; charset="us-ascii" ; format="flowed" On 9/30/00, W Luke penned: >For example on one of my sites I have a Members section which they can >personalise - they login in using their username and password... > > > >So if the user a

Re: [Re: Client & Session variables?]

2000-09-30 Thread JL
Good articles. But it's almost the same as the one in Cold Fusion Journal. I'm not sure which one was written first. Also, some of the query will not work in this article. For instance, those ideas about checking client.LastVisit are wrong. Also, you need to do something to the User on the lo

Re: Authentication

2000-09-30 Thread Dick Applebaum
If all you want is CC authorization before adding a record to the db, then you can do it easily with CF and a call to Cybercash (for example). Most ISPs provide this linkage through a custom CF tag. There are some in the tag gallery. Dick At 11:39 AM -0400 9/30/00, Chuck wrote: >This is a m

Re: Client & Session variables?

2000-09-30 Thread paul smith
I just noticed the URLed article contains the following: Personally, I require cookies on all of my sites, and I then provide adequate security and cookie information to the users who are refusing or unable to accept cookies so they know why we require them.

Re: Client & Session variables?

2000-09-30 Thread W Luke
Thanks for that Paul. Now as a complete beginner with Session Management (never had to use it). I've followed instructions on the site below, and it's working fine afaik. But how about implementing it straight into a site? For example on one of my sites I have a Members section which they can pe

URgent CFServer maxing CPU and JIT error on Production Server.

2000-09-30 Thread Dave Wilson
Hi all, We've recently moved a number of production sites onto a new server and are now experiencing instances where the CPU is maxing out and lots of instances of the following error throughout the different sites at seemingly random places and times. Error Diagnostic Information Just in time c

Re: Client & Session variables?

2000-09-30 Thread paul smith
Yeah, it was written in March before CFLOCKing exploded around here ;-) best, paul At 12:52 PM 9/30/00 -0400, you wrote: >Good article, but it doesn't impress the point that session variables >must be locked. -- Archiv

Re: Client & Session variables?

2000-09-30 Thread Bud
On 9/30/00, paul smith penned: >Detailed docs on setting up client vars in a DB and more are here: > >http://www.advantex.net/ColdFusion/CFClusteringDoc.htm Good article, but it doesn't impress the point that session variables must be locked. Which is why I switched to client variables. The fact

Re: query caching?

2000-09-30 Thread Dick Applebaum
Yeah. By the way these columns are searched (and named) it indicates that they likely (pun intended) contain multiple values: RecordID #00022 Keywords='this,that,another...' A column with multiple values violates the first normal form: each column should be atommic. or anot

Authentication

2000-09-30 Thread Chuck
This is a multi-part message in MIME format. --=_NextPart_000_00C5_01C02AD3.28F36640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone know of a CF based application like the one Flicks software = sells for ASP. It is an authentic

Re: Client & Session variables?

2000-09-30 Thread paul smith
Detailed docs on setting up client vars in a DB and more are here: http://www.advantex.net/ColdFusion/CFClusteringDoc.htm best, paul At 09:15 AM 9/30/00 -0400, you wrote: >On 9/29/00, W Luke penned: > > > Use client variables, written to a database, whenever possible. > > > >Is there any docu

Re: query caching?

2000-09-30 Thread Bud
On 9/30/00, Dick Applebaum penned: >Hmmm... 10 seconds to query sounds like some db redesign may be in order. > >This will vary with the db engine, but there are things you can do. > >I noticed that your db is denormalized (ProductsCategory, >ProductsKeyWords, and maybe ProductsStyleNumber). If y

Re: Client & Session variables?

2000-09-30 Thread Bud
--_-1241802732==_ma Content-Type: text/plain; charset="us-ascii" ; format="flowed" On 9/29/00, W Luke penned: > > Use client variables, written to a database, whenever possible. > >Is there any documentation about writing client variables to a database? Or >do you have a

Re: Query Advise

2000-09-30 Thread W Luke
Thanks guys. I've used a combination of your help to come up with the following code, which works (to an extent): SELECT messages.mID, messages.to_email, members.email, members.password FROM messages, members WHERE messages.mID = #form.ID# AND members.password = '#form.password#' AND me

RE: DB vs. text file

2000-09-30 Thread Bob Silverberg
Why don't you try loading the query into an application variable? In your application.cfm (or equivalent) check to see if the variable is initialized (remember to use a read-only lock for this). If it isn't, do your database read, and then load the results of that query into an application varia

Re: query caching?

2000-09-30 Thread Dick Applebaum
Depending on the totality of what you anticipate is going to be happening at any given time, you can: 1) let CF cache the queries... this is especially good if you anticipate that there will be a lot of similar queries as in drill-downs, or several users making identical queries (skewed popul

Re: Infusion Mail Server

2000-09-30 Thread Adrian Cooper
- Original Message - From: "Kym Kovan" <[EMAIL PROTECTED]> Sent: Saturday, September 30, 2000 8:09 AM > > >What does IMS do exactly with CF. We are running Exchange and our mail > >admin is a little nervous about installing a second mail server. > > iMS itself is a set of NT services w

RE: How can I do this (Query external data source)?

2000-09-30 Thread Dick Applebaum
I second Chris' suggestion. I use a stub program that runs on the remote server. it is invoked via CFHTTP It receives a WDDX packet containing only SQL Statements (you probably should not pass the userid and pw) It deserializes the WDDX packet, issues the SQL query, and serializes the recor

RE: TO ALL: Request for ColdFusion SP2 Input

2000-09-30 Thread James Sleeman
---Reply to mail from Steve Martin about TO ALL: Request for ColdFusion SP2 Input > You may be aware that when calling custom tags, either using the "CF_" > syntax, or using "CFMODULE", you can pass a special attribute called > "ATTRIBUTECOLLECTION", which is a struct of attributes. We use it qui

RE: Infusion Mail Server

2000-09-30 Thread Kym Kovan
>What does IMS do exactly with CF. We are running Exchange and our mail >admin is a little nervous about installing a second mail server. iMS itself is a set of NT services which provide the base protocol functions of SMTP, POP and POST servers. They also can talk to CF templates. The CF temp