RE: Infusion Mail Server
>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 templates provide the intelligence and functionality to enable the 3 services to act as a full-bloodied mail server. The whole package looks and behaves like a normal mail server but as all the brains are in cf templates you can do what you want with it for special functions, adding web-mail, whatever. Our associated hosting company, mbcomms.net.au , uses iMS as its production mail server and it works well. We have added a lot of extra functionality to do things like a bulk-mail handler for some of our clients and it is a dream to add things like that. -- Yours, Kym -- 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: TO ALL: Request for ColdFusion SP2 Input
---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 quite a > lot when using optional parameters, as it allows a collection of parameters > to be created, and then sent "en masse" to a module, e.g. > > The change has come in how repeated variables are treated, e.g. > > > Here X is specified twice, once in the attributecollection, once as a normal > parameter. > > The problem (for me at least, moving code from 4.01 to 4.5) is that in 4.01 > the "normal" parameter has precedence, whereas in 4.5 the "struct" parameter > has precedence, resulting in: > > 4.01 > 4.5 > > Was there a reason for the initial change and if so, why was it done and why > wasn't it documented? If not, can we have the original behaviour back > please? :-) Are you sure of this ? I use repeating variables like this all the time (CF 4.5) to over-ride same named variables in an ATTRIBUTECOLLECTION structure (generally fuseaction) ?? --- James Sleeman -- 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: How can I do this (Query external data source)?
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 record set into another WDDX packet which is returned to the CFHTTP. As a variation, you don't even need CF on the remote machine... the stub could be written in Perl, ASP, PHP, whatever. It is a great tool for migrating a db from one server to another, back-ending one site with another, etc. Dick At 5:35 PM -0400 9/29/00, Christopher Olive, CIO wrote: >why not use WDDX or something like that? > >write a robot like action page (no HTML) that queries the DB and wraps the >results in a WDDX package. then on your internal page, CFHTTP to that >external robot page, grab the packet, decode it, and go nuts. > >chris olive, cio >cresco technologies >[EMAIL PROTECTED] >http://www.crescotech.com > > > >-Original Message- >From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] >Sent: Friday, September 29, 2000 11:13 AM >To: CF-Talk >Subject: How can I do this (Query external data source)? > > >Please pardon the lousy subject line. I did not know how to paraphrase what >I need to do! > >I have an internal web page here at work that I made in coldfusion. I also >have another page that I made for the real world. > >My external site has a table with a bunch of information that website >visitors can enter information into. (It is a registry for old Pontiacs). > >I want to run a query on that external site that just returns the number of >records in the registry table. Hence, Here on my internal web page (Actually >the "Outlook Today" page) I just want a line that says "There are X records >in your Pontiac Registry". > >The dilemma, as I see it, is querying a datasource that is not on my local >coldfusion server. If I have to, I will add a new DSN to the server that >points to the database out there on the internet. Is this possible? > > >Tim Claremont >Xerox Corporation > > >-- >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_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.
Re: Infusion Mail Server
- 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 which provide the base protocol > functions of SMTP, POP and POST servers. They also can talk to CF > templates. The CF templates provide the intelligence and functionality to > enable the 3 services to act as a full-bloodied mail server. Yes indeed. The core mail services are extremely efficient as they are (I know, because I have used alot eof MTA's - both NT and UNIC based - extensively), but add those to the power of CF and SQL and anything is possible - and more. Adrian Cooper. -- 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: query caching?
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 popularity of certain items), e.g. today's specials, hot items, etc. 2) cache the queries yourself... more work for you, less for the db server 3) spew the recordset to the client (easy with WDDX), then do the drill-down at the client. OK, if the user has the bandwidth, and a fast client machine (you can often assume/dictate this in a B2B application) 4) spew the recordset to the client as JavaScript array: more work for you at the CF server much less bandwith than a WDDX packet much less work at the client 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 you haven't already tried it, you might experiment with normalizng these... & let the db engine do its thing. (you might be surprised by the results) HTH Dick At 6:38 PM -0400 9/29/00, Jon Hall wrote: >This is a multi-part message in MIME format. > >--=_NextPart_000_03AA_01C02A44.87489EC0 >Content-Type: text/plain; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > >Ok, maybe someone could point me in the right direction here. I am = >working with a database with 750,000 diferent products (yes 750,000). = >The database has been tweaked so that even the most complicated search = >only takes 10 seconds to return data on the development server.This wil = >lspeed up when it is live. That is fairly acceptable... >The problem is that each page takes 10 seconds...so when someone hits = >clicks "Next" to go to the next page, it has to requery. >Is there a way to optimize this? Perhaps some sort of read ahead = >caching? Any suggestions would be helpful. I am including the query code = >below. > >dbtype=3D"ODBC"> >SELECT cLinesID, cProductsNo, cProductsStyleNumber, cProductsName, = >cDescription, cProductsCategorys,cProductimage,cProductsPriceRange >FROM dbo.tProducts=20 >WHERE 0=3D0=20 >and (cProductimage > '')=20 > > > and (cProductsCategorys like '%#user_category#%') > > > > and (cProductsStyleNumber LIKE '%#user_style#%') > > > > and (cProductsKeyWords LIKE '%#user_keyword#%') > > > > and (cProductspricerange >=3D #user_min#) > > > > and (cProductspricerange <=3D #user_max#) > > > > >maxrows=3D#maxdisplay#> > >--=_NextPart_000_03AA_01C02A44.87489EC0 >Content-Type: text/html; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > > > >http-equiv=3DContent-Type> > > > > >Ok, maybe someone could point me in the = >right=20 >direction here. I am working with a database with 750,000 diferent = >products (yes=20 >750,000). The database has been tweaked so that even the most = >complicated search=20 >only takes 10 seconds to return data on the development server.This wil = >lspeed=20 >up when it is live. That is fairly acceptable... >The problem is that each page takes 10 = >seconds...so=20 >when someone hits clicks "Next" to go to the next page, it has to=20 >requery. >Is there a way to optimize this? = >Perhaps some sort=20 >of read ahead caching? Any suggestions would be helpful. I am including = >the=20 >query code below. > >datasource=3D"#dsn#"=20 >maxrows=3D500 = >dbtype=3D"ODBC">SELECT cLinesID,=20 >cProductsNo, cProductsStyleNumber, cProductsName, cDescription,=20 >cProductsCategorys,cProductimage,cProductsPriceRangeFROM &= >nbsp; =20 >dbo.tProducts WHERE 0=3D0 = >and=20 >(cProductimage > '') > > > >""> and (cProductsCategorys like=20 >'%#user_category#%') > >""> and (cProductsStyleNumber LIKE=20 >'%#user_style#%') > >""> and (cProductsKeyWords LIKE=20 >'%#user_keyword#%') > >""> and (cProductspricerange >=3D=20 >#user_min#) > >""> and (cProductspricerange <=3D=20 >#user_max#) >startrow=3D#startr# = >maxrows=3D#maxdisplay#> > >--=_NextPart_000_03AA_01C02A44.87489EC0-- > >-- >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 Unsubscrib
RE: DB vs. text file
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 variable (this will require an exclusive lock - but just lock the CFSET, not the CFQUERY). That way, the only time that the query will need to be executed is when the application times out. You will also need to use a read-only lock whenever you reference this application variable, but that shouldn't be too complicated or add too much overhead. If you want to force a refresh of the values, set up a task that simply requeries and reloads that application variable. I'm doing this on a couple of sites with a bunch of queries that populate drop down list boxes and it's working well for me. Bob -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 5:29 PM To: CF-Talk Subject: Re: DB vs. text file We recently ran into a problem where the database was so huge that pulling a list box was too slow. The solution was to perform a query that wrote the contents of the select box to a comma delimited file once a day. In this case, it was much much faster to read the box from a file. jon - Original Message - From: "Robert M. Saxon, Jr." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 29, 2000 3:55 PM Subject: DB vs. text file > I am thinking about populating a select box with a list from a text file. > Is that faster than querying a database, or should I import the text file > into a table? > > I'm sure there is no absolute answer to this question, but generalities are > acceptable. > > Thanks, > > 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. -- 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: Query Advise
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 members.email = '#form.email#' AND messages.to_email = '#form.email#' I'm over-complicating what I actually have to do (It's an "anonymous" messaging system, to hide email addresses, inserts message into Database). Thanks for all your help. Will - Original Message - From: "W Luke" <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Friday, September 29, 2000 10:07 PM Subject: Query Advise > Hi, > > For me, SQL is either thoroughly straightforward, or bizarrely confusing. > As soon as I try to do something remotely complicated, I run into trouble, > simply cannot work it out, and come to you guys. As well as advising me how > to fix my latest Query - can anyone tell me of a decent SQL website for > advanced queries, or a book? I'd be really grateful. > > OK the query in question is as follows: > > > SELECT mID,from_email,email,password FROM messages,members WHERE > messages.mID = #form.ID# AND messages.from_email = '#form.email#' AND > members.password = '#form.password#' AND members.email = '#form.email#' > > > mID and from_email are fields in the "messages" table. Password and email > are fields in the members Table. mID is originally set from a url variable, > and for example might be set to 5. This would return an email address > 'from_email' - what I need to do is validate this email against one stored > in members, check the pass, and if all is OK then move on. > > I've spent the whole day on this, on and off, and still it's saying "wrong > password"! > > Advise much appreciated.. > > Cheers > > Will > > -- > 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: Client & Session variables?
--_-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 any "starter for tens"?! What kind of documentation? CF will create the necessary tables if you just give it an empty database. The tables and columns it creates are, in Access, I can't remember off the top of my head what the matching data types are in SQL: CDATA cfid (text, 20 characters, no index) app (text, 64 characters, indexed, duplicates OK) data (memo) CGLOBAL cfid (text, 20 characters, indexed, duplicates OK) data (memo) lvisit (date/time, indexed, duplicates OK) The biggest difference in the setup is, if you have complex objects other than simple strings you have to serialize them into WDDX packets. Then deserialize them into a local variable. I do it like this: To create the initial variable if it hasn't been created (my shopping cart for example, this will probably wrap bad): Then when adding something to the basket, whereas with sessions I would just create a new basket called newbasket then set that to session.basket, it's a tad more complex: But well worth it. Clustered server ready and NO CFLOCKS! YIPEEE! Then I can just cfoutput or loop on variables.basket and access the different items with variables.basket.product_id, etc. instead of session.basket.etc Oh, and if you want to give it a timeout, you can't just do it like sessiontimeout=. You have to create a start time, then update it at every click and delete the client variables if it's past the allotted timeout (30 minutes in the example below). I do it like this: -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 --_-1241802732==_ma Content-Type: text/html; charset="us-ascii" Re: Client & Session variables? 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 any "starter for tens"?! What kind of documentation? CF will create the necessary tables if you just give it an empty database. The tables and columns it creates are, in Access, I can't remember off the top of my head what the matching data types are in SQL: CDATA cfid (text, 20 characters, no index) app (text, 64 characters, indexed, duplicates OK) data (memo) CGLOBAL cfid (text, 20 characters, indexed, duplicates OK) data (memo) lvisit (date/time, indexed, duplicates OK) The biggest difference in the setup is, if you have complex objects other than simple strings you have to serialize them into WDDX packets. Then deserialize them into a local variable. I do it like this: To create the initial variable if it hasn't been created (my shopping cart for example, this will probably wrap bad):Then when adding something to the basket, whereas with sessions I would just create a new basket called newbasket then set that to session.basket, it's a tad more complex: But well worth it. Clustered server ready and NO CFLOCKS! YIPEEE! Then I can just cfoutput or loop on variables.basket and access the different items with variables.basket.product_id, etc. instead of session.basket.etc Oh, and if you want to give it a timeout, you can't just do it like sessiontimeout=. You have to create a start time, then update it at every click and delete the client variables if it's past the allotted timeout (30 minutes in the example below). I do it like this: Re: query caching? 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 you haven't >already tried it, you might experiment with normalizng these... & let >the db engine do its thing. (you might be surprised by the results) Normalized? Can you expand on that? -- 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: Client & Session variables?
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 documentation about writing client variables to a database? Or > >do you have any "starter for tens"?! > >What kind of documentation? CF will create the necessary tables if >you just give it an empty database. The tables and columns it creates >are, in Access, I can't remember off the top of my head what the >matching data types are in SQL: -- 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.
Authentication
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 authentication software that easily ties into = processing houses like Ibill. I need an app like this for a client who = wants to put up a membership site, and wants the client added to the DB = only after their Credit card has been approved. Here is the link to = webquota. http://www.flicks.com/msystems/webquota/ =20 Chuck Hergenroeder =20 --=_NextPart_000_00C5_01C02AD3.28F36640 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone know of a CF based = application like the=20 one Flicks software sells for ASP. It is an authentication = software that=20 easily ties into processing houses like Ibill. I need an app like=20 this for a client who wants to put up a membership site, and wants = the=20 client added to the DB only after their Credit card has been = approved. =20 Here is the link to webquota. http://www.flicks.com/msystems/webquota/">http://www.flicks.com/m= systems/webquota/ Chuck Hergenroeder --=_NextPart_000_00C5_01C02AD3.28F36640-- -- 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: query caching?
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 another common approach: RecordID #00022 Keyword1='this' Keyword2='that' Keyword3='another' ... Here the record contains repeating columns of "like" data. as opposed to separate occurrences of a single column in a child table: keyword ParentID record #7 this00022 record #99 that00022 record #2 another 00022 From a performance view, it generally means that the db engine needs to read each record in the db and scan each of these fields for the desired values to, satisfy the query. Here, each record must be accessed and then scanned to determine whether it is accepted or eliminated. With a normalized situation, the target records can be located by manipulating the indexes with no need to scan the fields (unless partial keywords are used). Records which do not contain the desired keyword(s) do *not* need to be accessed, to be eliminated. Most modern db engines are optimized to handle this situation quite efficiently. HTH Dick At 9:19 AM -0400 9/30/00, Bud wrote: >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 you haven't >>already tried it, you might experiment with normalizng these... & let >>the db engine do its thing. (you might be surprised by the results) > >Normalized? Can you expand on that? >-- > >Bud Schneehagen - Tropical Web Creations > -- 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: Client & Session variables?
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 that the application becomes clusterable is simply a nice side-effect for me. :) I do like the idea of adding the timeout query as a stored procedure. -- 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: Client & Session variables?
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. -- 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.
URgent CFServer maxing CPU and JIT error on Production Server.
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 compilation error unknown parser error The last successfully parsed CFML construct was the CFML template beginning occupying document position (1:1) to (1:1). Can anyone shed any light on what might be causing this? 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 machine before moving. Regards, Dave Dave Wilson Internet Technology Manager BizNet Solutions Lisburn Road Belfast email: [EMAIL PROTECTED] web: http://www.biznet-solutions.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: Client & Session variables?
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 personalise - they login in using their username and password... So if the user and pass is OK, the rest of the page is displayed. What I'd like to do is after successful validation, use client vars in a DB so that they will be logged in automatically next time. How should I do this? Thanks Will - Original Message - From: "paul smith" <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Saturday, September 30, 2000 4:36 PM Subject: Re: Client & Session variables? > 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 documentation about writing client variables to a database? Or > > >do you have any "starter for tens"?! > > > >What kind of documentation? CF will create the necessary tables if > >you just give it an empty database. The tables and columns it creates > >are, in Access, I can't remember off the top of my head what the > >matching data types are in SQL: > > -- > 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: Client & Session variables?
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. I prefer setting CFID and CFTOKEN to a "session-only" cookie so that the session is destroyed when the user closes their browser: I then detect whether the user is able/willing to accept cookies, and redirect them to an information page if they are not, using some permutation of: === I did some testing recently, and found if the browser was set to NOT accept cookies, that the above session-only/browser-only cookies were accepted. Did I screw up in my test? best, paul At 12:52 PM 9/30/00 -0400, you wrote: >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 >that the application becomes clusterable is simply a nice side-effect >for me. :) > >I do like the idea of adding the timeout query as a stored procedure. >-- > >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. -- 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: Authentication
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 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 authentication software that easily ties into = >processing houses like Ibill. I need an app like this for a client who = >wants to put up a membership site, and wants the client added to the DB = >only after their Credit card has been approved. Here is the link to = >webquota. http://www.flicks.com/msystems/webquota/ =20 > >Chuck Hergenroeder >=20 -- 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: [Re: Client & Session variables?]
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 login page. Otherwise those two tables in CVR DB are wrong. [EMAIL PROTECTED] (paul smith) wrote: > 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 documentation about writing client variables to a database? Or > > >do you have any "starter for tens"?! > > > >What kind of documentation? CF will create the necessary tables if > >you just give it an empty database. The tables and columns it creates > >are, in Access, I can't remember off the top of my head what the > >matching data types are in SQL: > > -- > 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. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- 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: Client & Session variables?
--_-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 and pass is OK, the rest of the page is displayed. What I'd >like to do is after successful validation, use client vars in a DB so that >they will be logged in automatically next time. > >How should I do this? 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. I believe the default is 10 days. I have my server set to expunge after one day because that's all I need for any app on my server. Now if someone requested I keep them longer, I may give them a week, but not much more than that because then the database just gets larger and larger. And I don't think there's any guarantee that the person will have the same cfid and cftoken generated by their browser (still a little confused by that one) if they've shut it down and come back a few days later. I use cookies. Then they can click a checkbox if they want their password to be stored. Then you check like this (just an example from one of my apps): SELECT Cust_ID,Cust_FirstName FROM Customers WHERE Cust_ID = '#variables.member_id#' and password = '#variables.member_password#' Welcome Back #Get_Id.Cust_FirstName#! Login Failed Show Login Form Then as long as client.mem_id is not "" then they are logged in. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 --_-1241783480==_ma Content-Type: text/html; charset="us-ascii" Re: Client & Session variables? 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 and pass is OK, the rest of the page is displayed. What I'd like to do is after successful validation, use client vars in a DB so that they will be logged in automatically next time. How should I do this? 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. I believe the default is 10 days. I have my server set to expunge after one day because that's all I need for any app on my server. Now if someone requested I keep them longer, I may give them a week, but not much more than that because then the database just gets larger and larger. And I don't think there's any guarantee that the person will have the same cfid and cftoken generated by their browser (still a little confused by that one) if they've shut it down and come back a few days later. I use cookies. Then they can click a checkbox if they want their password to be stored. Then you check like this (just an example from one of my apps): SELECT Cust_ID,Cust_FirstName FROM Customers WHERE Cust_ID = '#variables.member_id#' and password = '#variables.member_password#' Welcome Back #Get_Id.Cust_FirstName#!
Then as long as client.mem_id is not "" then they are logged in. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 --_-1241783480==_ma-- -- 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. Login Failed Show Login Form
Re: Client & Session variables?
> 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 will still work? (i.e. pull client's token from database, and client. variables). Or am I way off the mark? >I believe the default is 10 days. I > have my server set to expunge after one day because that's all I need > for any app on my server. Now if someone requested I keep them > longer But why would you need to allow them to keep them longer? If you set a reasonably satisfactory limit (7 days seems fine to me), then the database doesn't clog up, and 7 days is long enough. > I use cookies. Then they can click a checkbox if they want their > password to be stored. Then you check like this (just an example from > one of my apps): Could the same not be done with Database Client Storage means? To me it seems the best way - I don't have any figures on Cookie usage at hand (anyone?) but some people are scared of the cookie monster, even nowadays. Will -- 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: query caching?
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. This will also be a consumer based site, not b2b. So 56k must be taken into account. The data structure as it came from the client was horrible, we have done quite a bit of tweaking, but I liked the idea of indivual keywords per field. That would definately be more efficient, but each item can have many keywords attached to it. These are like that company that does the url keywords for msn...you type it in and you get the products that match that keyword. We have a keyword search that searches all item descriptions also... I had a thought as I was typing this...What if I queried 20 records at a time and displayed only 10. Then took the remaining ten and assigned them to an array. When the user clicked next I could display the contents of the array...seems very doable to me. What do you think? Thanks for your help jon - Original Message - From: "Dick Applebaum" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, September 30, 2000 8:08 AM Subject: Re: query caching? > 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 > popularity of certain items), e.g. today's specials, hot items, etc. > > 2) cache the queries yourself... more work for you, less for the db server > > 3) spew the recordset to the client (easy with WDDX), then do the > drill-down at the client. OK, if the user has the bandwidth, and a > fast client machine (you can often assume/dictate this in a B2B > application) > > 4) spew the recordset to the client as JavaScript array: > > more work for you at the CF server > > much less bandwith than a WDDX packet > > much less work at the client > > 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 you haven't > already tried it, you might experiment with normalizng these... & let > the db engine do its thing. (you might be surprised by the results) > > > HTH > > Dick > > At 6:38 PM -0400 9/29/00, Jon Hall wrote: > >This is a multi-part message in MIME format. > > > >--=_NextPart_000_03AA_01C02A44.87489EC0 > >Content-Type: text/plain; > > charset="iso-8859-1" > >Content-Transfer-Encoding: quoted-printable > > > >Ok, maybe someone could point me in the right direction here. I am = > >working with a database with 750,000 diferent products (yes 750,000). = > >The database has been tweaked so that even the most complicated search = > >only takes 10 seconds to return data on the development server.This wil = > >lspeed up when it is live. That is fairly acceptable... > >The problem is that each page takes 10 seconds...so when someone hits = > >clicks "Next" to go to the next page, it has to requery. > >Is there a way to optimize this? Perhaps some sort of read ahead = > >caching? Any suggestions would be helpful. I am including the query code = > >below. > > > > >dbtype=3D"ODBC"> > >SELECT cLinesID, cProductsNo, cProductsStyleNumber, cProductsName, = > >cDescription, cProductsCategorys,cProductimage,cProductsPriceRange > >FROM dbo.tProducts=20 > >WHERE 0=3D0=20 > >and (cProductimage > '')=20 > > > > > > and (cProductsCategorys like '%#user_category#%') > > > > > > > > and (cProductsStyleNumber LIKE '%#user_style#%') > > > > > > > > and (cProductsKeyWords LIKE '%#user_keyword#%') > > > > > > > > and (cProductspricerange >=3D #user_min#) > > > > > > > > and (cProductspricerange <=3D #user_max#) > > > > > > > > > > >maxrows=3D#maxdisplay#> > > > >--=_NextPart_000_03AA_01C02A44.87489EC0 > >Content-Type: text/html; > > charset="iso-8859-1" > >Content-Transfer-Encoding: quoted-printable > > > > > > > > >http-equiv=3DContent-Type> > > > > > > > > > >Ok, maybe someone could point me in the = > >right=20 > >direction here. I am working with a database with 750,000 diferent = > >products (yes=20 > >750,000). The database has been tweaked so that even the most = > >complicated search=20 > >only takes 10 seconds to return data on the development server.This wil = > >lspeed=20 > >up when it is live. That is fairly acceptable... > >The problem is that each page takes 10 = > >seconds...so=20 > >when someone hits clicks "Next" to go to the next page, it has to=20 > >requery. > >Is there a way to optimize this? = > >Perhaps some sort=20 > >of read ahead caching? Any suggestions woul
creating word docs and excel sheets on the fly...
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 also like to pass along formatting codes for things like creating tables in Word and shading certain rows. Does anyone know if this is even possible? ---mark -- 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://www.fusioneers.com ICQ: 346566 -- -- 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: creating word docs and excel sheets on the fly...
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:14 PM To: CF-Talk Subject: creating word docs and excel sheets on the fly... 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 also like to pass along formatting codes for things like creating tables in Word and shading certain rows. Does anyone know if this is even possible? ---mark -- 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://www.fusioneers.com ICQ: 346566 -- -- 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.
RE: creating word docs and excel sheets on the fly...
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- From: Warrick, Mark [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 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 also like to pass along formatting codes for things like creating tables in Word and shading certain rows. Does anyone know if this is even possible? ---mark -- 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://www.fusioneers.com ICQ: 346566 -- -- 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.
RE: creating word docs and excel sheets on the fly...
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 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 also like to pass along formatting codes for things like creating tables in Word and shading certain rows. Does anyone know if this is even possible? ---mark -- 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://www.fusioneers.com ICQ: 346566 -- -- 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.
RE: creating word docs and excel sheets on the fly...
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://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: Peter Stolz [mailto:[EMAIL PROTECTED]] > Sent: Saturday, September 30, 2000 12:44 PM > To: CF-Talk > Subject: RE: creating word docs and excel sheets on the fly... > > > 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.( It should look decent if the formatting isn't too complicated. > > For Excel: > Save the file as HTML. > Do a web query programmatically ( This makes an HTTP call and reads a preformatted web page into > EXCEL. Then > save it as xls. > For more info search for 'web query' in Excel help. > > > P. > > -Original Message- > From: Warrick, Mark [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 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 also like to pass along formatting codes > for things like creating tables in Word and shading certain rows. > > Does anyone know if this is even possible? > > ---mark > > -- > 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://www.fusioneers.com > ICQ: 346566 > -- > > -- > -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/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. -- 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.
Worldpay
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 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: query caching?
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 REQUEST.GetHeadingsFirstLetter: SELECT Class_ID,Class_Name,Pages FROM YellowPages (nolock) WHERE Class_Name LIKE '#REQUEST.alpha#%' ORDER BY Class_Name In addition, there is no limit on the number of queries CF will cache. (The oft-noted limit of 100 is wrong.) Of course, whether you want to, or should, cache queries in this way depends on many factors such as available memory, use a Structure instead, etc. best, paul At 03:08 PM 9/30/00 -0400, you 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 (unless..just had a thought, see >below). -- 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.
storing CF code in a database
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 --=_NextPart_000_010C_01C02AF0.368B7280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it possible to store CF code in a = database and=20 then pull it out with a query and run the code? Camden --=_NextPart_000_010C_01C02AF0.368B7280-- -- 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: query caching?
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 items at will, does not *necessarily* mean than CF caching wont help... follow me on this: There is an old rule that often applies to parts, inventories, etc... the 80-20 rule. After observing activity against large inventories it was found that: about 80% of the activity was against 20% of the items, and vice-versa You often can apply this same "rule" to query activity. If so, you will have a few high-activity, similar, queries; and many, many low-activity dissimilar queries. drill-down accentuates this, as you will be repeating the high-activity queries. So, if you can let CF cache the queries. The similar, high-activity queries will tend to remain cached. So, you can significantly improve performance of a significant part (80%) of the overall system... even if the components of the queries change frequently (requiring re-caching) Now, the probability is that the "changes affecting caching" will be a small (or zero) percentage of the queries during peak periods... then you *do* have "static" queries... at least for a useful amount of time. I have done this successfully using cachedafter on the queries. set an application variable for each main table (used in all the queries) application.PartsLastUpdatedAt = now() update this each time you add/delete/change anything which will affect the queries reference this variable as the cachedafter designation in all the queries. The beauty of this is that it is sell-tuning. There is much potential gain & very little overhead, Here is the best part, you can easily try this, with a little timing routine, and see if you have enough similar queries to benefit. In a similar way, you can experiment with normalized child tables for the keywords, etc, without affecting the existing db structure... Just create a (bastard) child table (no foreign key constraint) for testing. Populate the child table by extracting the keywords from the parent. Then write a simple query template to time the same query with the child and without. If this gives improvement, then look into the indexing options of your specific database... you may be able to improve it even more. >(unless..just had a thought, see >below). >Maybe as we go on and collect some statistics as to what is popular. > >This will also be a consumer based site, not b2b. So 56k must be taken into >account. That is not necessarily a problem... if you can efficiently send the data to the browser. One bigger browser-server connection may be faster than many smaller browser-server connections. This is especially significant when the network is congested & it could take 2-3 seconds to establish each connection. Also you would not need to repeat the queries for drill-down. For example, your code indicated that you would return a max of 500 rows. If each row required 100 characters to be transmitted to the browser that's 10-20 seconds for the largest query. (and no additional browser-server connections to do the drill down). >The data structure as it came from the client was horrible, we have done >quite a bit of tweaking, but I liked the idea of indivual keywords per >field. That would definately be more efficient, but each item can have many >keywords attached to it. all the more reason to normalize it... this is a performance storage tradeoff (as well as some others). If you have the disk storage to afford a child table, the db engine can process this much more efficiently. Try it... I think you'll be amazed at the results. >These are like that company that does the url >keywords for msn...you type it in and you get the products that match that >keyword. We have a keyword search that searches all item descriptions >also... > >I had a thought as I was typing this...What if I queried 20 records at a >time and displayed only 10. Then took the remaining ten and assigned them to >an array. When the user clicked next I could display the contents of the >array...seems very doable to me. What do you think? The first 20 I can see... how are you going to get the next 20? HTH Dick >Thanks for your help >jon > > >- Original Message - >From: "Dick Applebaum" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, September 30, 2000 8:08 AM >Subject: Re: query caching? > > >> 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 >> popularity of certain items), e.g. today's specials, ho
Re: storing CF code in a database
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-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 > >--=_NextPart_000_010C_01C02AF0.368B7280 >Content-Type: text/html; >charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > > >Is it possible to store CF code in a = database and=20 then pull it out with a query >and run the code? > >Camden > >--=_NextPart_000_010C_01C02AF0.368B7280-- > >-- >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. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- 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.
Reading a file one line at a time with CFfile?
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 mid() though. I could sure use some help here. Terry Troxel -- 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: Client & Session variables?
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 in every link, just like with session variables. :) > >I believe the default is 10 days. I >> have my server set to expunge after one day because that's all I need >> for any app on my server. Now if someone requested I keep them >> longer > >But why would you need to allow them to keep them longer? If you set a >reasonably satisfactory limit (7 days seems fine to me), then the database >doesn't clog up, and 7 days is long enough. Sure, but like I said. You are at the mercy of the host if it's not your machine. I have mine set to die in one day. > > I use cookies. Then they can click a checkbox if they want their >> password to be stored. Then you check like this (just an example from >> one of my apps): > >Could the same not be done with Database Client Storage means? To me it >seems the best way - I don't have any figures on Cookie usage at hand >(anyone?) but some people are scared of the cookie monster, even nowadays. If they don't have cookies enabled, then I believe a new cfid and cftoken will be created on every click since CF won't know that it's the same person clicking. Even if you pass cfid and cftoken, it's only going to be good until they leave the site. Next visit they will be given a NEW cfid and cftoken. So to summarize, as long as they have cookies enabled and come back before the client variables are deleted from the database, then yes, your method will work. If they don't have cookies enabled or come back after the data is purged, it won't. -- 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: Reading a file one line at a time with CFfile?
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 comibination of the two were used between lines. ... Jim - Original Message - From: "Terry - it-werks.com" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, September 30, 2000 3:33 PM Subject: Reading a file one line at a time with CFfile? > 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 > mid() though. I could sure use some help here. > > Terry Troxel -- 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: Client & Session variables?
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 05:46 PM 9/30/00 -0400, you wrote: >If they don't have cookies enabled, then I believe a new cfid and >cftoken will be created on every click since CF won't know that it's >the same person clicking. Even if you pass cfid and cftoken, it's >only going to be good until they leave the site. Next visit they will >be given a NEW cfid and cftoken. -- 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: Reading a file one line at a time with CFfile?
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" <[EMAIL PROTECTED]> Sent: Saturday, September 30, 2000 2:55 PM Subject: Re: Reading a file one line at a time with CFfile? > 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 comibination of the two were used between lines. > > > > > ... > > > Jim > > > - Original Message - > From: "Terry - it-werks.com" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, September 30, 2000 3:33 PM > Subject: Reading a file one line at a time with CFfile? > > > > 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 > > mid() though. I could sure use some help here. > > > > Terry Troxel > > -- > 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: Client & Session variables?
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 complex objects >other than simple strings you have to serialize them into WDDX >packets. Then deserialize them into a local variable. -- 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: Client & Session variables?
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 without variables being passed, why isn't that done all the time? -- 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: Client & Session variables?
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. If you can type it, you can store it. Arrays, structures, etc, no. -- 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.
Wantad/ Classifieds program
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 ? -- 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 Rookie Question??
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 -- 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: A Rookie Question??
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 for larger applications? Is it just as easy to use SQL? I >am in the dark on this, please shed some light. > >Thanks, >Rich > -- 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: Client & Session variables?
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 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 without variables being passed, why isn't that done all >the time? >- -- 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.
Upsizing Problems using access 2000 to sql
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 is auto number (and yes I have converted it to just number and still not go same error) and the category field is simply a text field in the upsize report it says table was skipped or upsize failed in comparison I then have a guest comments table with around 15 fields that has around 40 records in the table its id field is set to auto number there is a data/time field as well along with plenty of differ text fields in the upsize report this table "guest comment" upsized perfectly. your words of wisdom would be appreciated also does anyone know a url link where I can download enterprise manager. As I do not have a copy of sql server I was wanting to admin the sql database via the access 2000 front end without having to buy sql and also learn a new database package Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [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.
Which is Faster?
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&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: URgent CFServer maxing CPU and JIT error on Production Server.
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 machine before > moving. > > Regards, > Dave > > Dave Wilson > Internet Technology Manager > > > BizNet Solutions > > Lisburn Road > Belfast > > email: [EMAIL PROTECTED] > web: http://www.biznet-solutions.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.