JavaScript variables passed to ColdFusion
How do I get variables generated by JavaScript to be recognized by ColdFusion? I would like to do different things based on JavaScript results. When ever I try to put a JavaScript variable into a CFSET or CFIF I get an error that says "ColdFusion was unable to determine the value of the parameter". Thanks for any help. Michael Gribbin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (no subject)
Looks like your problem is an HTML one, not a CF one. Where you have: Note the final quotation mark before the >. Otherwise, it's still looking at the href contents. Evan > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 10:23 PM > To: CF-Talk > Subject: (no subject) > > > Hi all, > > I'm still in chptr 11 of Ben Forta's CF Web Construction kit book. The > problem I'm getting is a 2-fold problem. What follows is the code: > > > SELECT EmployeeID, FirstName, LastName, PhoneExtension > FROM Employees > ORDER BY LastName, FirstName > > > > > > Employee List > > > > Employees > > > > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(no subject)
Hi all again, I forget to supply a template, employ1.cfm, that is called by employ2.cfm, in my previous request for help, so here it is: SELECT FirstName, LastName, PhoneExtension FROM Employees ORDER by LastName, FirstName Employee List Employees #LastName#, #FirstName# - Ext. #PhoneExtension# This template, employ1.cfm, is called by employ2.cfm, which was included in the previous submission. I'm sure this stuff is pretty simple to most of you, but I am stumped. Please know that I solve most of my problems on my own, usually syntax problems such as missed code. But some problems just stump me. I'd appreciate your help. Thanks, Steve Carmeli [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(no subject)
Hi all, I'm still in chptr 11 of Ben Forta's CF Web Construction kit book. The problem I'm getting is a 2-fold problem. What follows is the code: SELECT EmployeeID, FirstName, LastName, PhoneExtension FROM Employees ORDER BY LastName, FirstName Employee List Employees http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Brain Fart
I have made a custom tag that checks the length of the chars. entered into a textarea field and produces warnings accordingly. The Allaire custom tag gallery is out of order, so I can't upload it. If you are interested, E-mail me at [EMAIL PROTECTED] and I can send it to you Todd Ashworth You wrote: - Original Message - From: "Tony Gruen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 2:03 PM Subject: OT: Brain Fart > I am having a challenge trying to envision a solution to the following: > > Wherever I have a textarea field in my insert statement I strip commas and > returns in this fashion: > > '#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#', > > Is there a way to check the number of characters that was entered when the > form was submitted? I need to limit it to 255 - I have a specific group > entering war and peace in this field and upon insert it is causing problems > down the line when a data team member (internal) tries to download the form > submissions out of the database for processing. > > Any thoughts, suggestions, ideas? > > Tony Gruen > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DB: Oracle Top-N Queries; Standardizing Stored Procedures
Just passing on two interesting articles. Must earn my top 20 ranking for 2001! -David >From DevX: Performing Top-N Queries in Oracle http://www.devx.com/devxpress/gurl.asp?i=1X1786240X6883 >From ASPToday: Standardize your Code Structure for T-SQL Stored Procedures http://www.asptoday.com/content/articles/20010201.asp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick Image Map logic
yep. but it isn't specific to CF. a couple years ago, i wrote an application that monitored where users clicked in an ad banner to see what visual elements were successful using the x,y data. -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:43 PM To: CF-Talk Subject: Quick Image Map logic Try this one out and see if you just might get some creative sparks flowing. This is just food for thought. Pop the following in an default template with your normal html and body tags, name it test.cfm, run it and click on whatever image you stuck in as your source and make sure you have debugging turned on. The fieldnames that get returned in this instance are IMAGE.X and IMAGE.Y, with their values being the x and y coordinates of wherever you clicked on the image. I can think of all sorts of cf logic to implement with this. Maybe everyone already knew this but I hadn't seen it documented anywhere. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
VTML
I build a custom tag and I'm trying to do an "Edit Tag" wizard for it. I pretty much got an idea on how to do it, but it's a pain. Are there tools to help with this kind of thing? Ruslan Sivak Technologist ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLocation on any page based on Domain Name
I have two domain names pointing to the same IP address. To make things
easier, I'd like to get everyone on the same domain name BUT much
advertising has been placed with the "old" URL AND they point to many
diferent pages. Is there a way move them over to the other URL no matter
what page they come in to?
For example: If they come to www.oldsite.com/price-quote.cfm I want to move
them over to www.newsite.com/price-quote.cfm
Such as the pseudo code below?
cfif FindNoCase("oldwebsite.com", CGI.Server_Name)>
cflocation url="http://www.newsite.com/#SCRIPT_NAME#?#QUERY_STRING#"
addtoken="YES">
/cfif>
What do I need to make this work? If I place this in our application.cfm, am
I on the right track?
Thanks.
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Quick Image Map logic
Try this one out and see if you just might get some creative sparks flowing. This is just food for thought. Pop the following in an default template with your normal html and body tags, name it test.cfm, run it and click on whatever image you stuck in as your source and make sure you have debugging turned on. The fieldnames that get returned in this instance are IMAGE.X and IMAGE.Y, with their values being the x and y coordinates of wherever you clicked on the image. I can think of all sorts of cf logic to implement with this. Maybe everyone already knew this but I hadn't seen it documented anywhere. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The BETA IS OUT!!! (query a query)
> > Just to let you know CF 4.5 does not have a query cache limit. > > Can you set one though? The default number of cached queries allowed is 100. You can change in in the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Brain Fart
http://javascript.internet.com/forms/limit-textarea.html > -Original Message- > From: Tony Gruen [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 1:03 PM > I have a textarea field > Is there a way to check the number of characters that was entered when the > form was submitted? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Best Practice for a persistent variable
A what would/what do you do question: We are developing a site that's got some flash elements. For the non-flash people, there will be html elements that swap into those places. I'd *like* to do a flash detect and then set a variable based on the results and then do something like if flash IS 'yes' insert flash header else insert html header But, I'm concerned about what variables I can use. Here's my thinking. 1. Session variables expire, so I don't want to use those. Since I don't want to have to push a user back to a flash detect again. 2. Cookies are probably my best bet. Then I wouldn't even need to use the flash detect if they come back again. But what if someone has cookies disabled? 3. Client variables have the same problem, right? If a user has cookies disabled, client vars won't get set. 4. CFID and CFTOKEN lend themselves to the same problem, right? So, here I am wondering what I can do. If I'm wrong on #3 or #4, then I'm okay, I suppose. I could also pass an id in the url from page to page, but I'd prefer not to if I can avoid it. Any advice or thoughts is greatly appreciated. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practice for a persistent variable
I'd use cookies if the browser allows, fall back to URL if you have to. You'll need to test for the cookies each time a page loads, and add URL variables to all links/forms if there's no cookie data. Eric -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:47 PM To: CF-Talk Subject: Best Practice for a persistent variable A what would/what do you do question: We are developing a site that's got some flash elements. For the non-flash people, there will be html elements that swap into those places. I'd *like* to do a flash detect and then set a variable based on the results and then do something like if flash IS 'yes' insert flash header else insert html header But, I'm concerned about what variables I can use. Here's my thinking. 1. Session variables expire, so I don't want to use those. Since I don't want to have to push a user back to a flash detect again. 2. Cookies are probably my best bet. Then I wouldn't even need to use the flash detect if they come back again. But what if someone has cookies disabled? 3. Client variables have the same problem, right? If a user has cookies disabled, client vars won't get set. 4. CFID and CFTOKEN lend themselves to the same problem, right? So, here I am wondering what I can do. If I'm wrong on #3 or #4, then I'm okay, I suppose. I could also pass an id in the url from page to page, but I'd prefer not to if I can avoid it. Any advice or thoughts is greatly appreciated. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
changing email dynamically
is that happening on this list? i know i wrote that code properly, is the mailserver changing it so that you cant send out malicious code? if so what software? what's the regex? where is the white paper? thanks, Alexander Sicular Technical Director, Information Technology The Neurological Institute of New York Columbia Presbyterian Medical Center 212.305.1318 [EMAIL PROTECTED] -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 5:17 PM To: CF-Talk Subject: RE: JavaScript Submit try this: Untitled some text | good luck, Alexander Sicular Technical Director, Information Technology The Neurological Institute of New York Columbia Presbyterian Medical Center 212.305.1318 [EMAIL PROTECTED] -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:22 PM To: CF-Talk Subject: OT: JavaScript Submit I am trying to remember how to post a form to different urls depending on which button is clicked on. Can someone help? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disappearing Client Variables
Thanks Bud and Shawnea for your help. Shawnea's comment about cookies and domains prompted me to add domain=".mydomain.com" to the statement. That seems to have solved my problem...I hope I don't speak too soon. Weird, but makes sense. -Original Message- From: Shawnea Carter [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 5:08 PM To: CF-Talk Subject: Re: Disappearing Client Variables My recollection - and someone jump in here if I am off base - is that client variables DO utilize cookies to some extent - and cookies can only set and read by the same domain. The browser doesn't "know" that the domains are 'virtual'. So what is happening is the client variables aren't disappearing when you go to xyz.mysite.com if you set them on www.mysite.com. They were never there to begin with. HTH Shawnea Carter - Original Message - From: "Eron Cohen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 4:34 PM Subject: Disappearing Client Variables > I have a problem that is difficult to explain which > has to do with "disappearing" client variables. I > have a site that makes use of virtual hostnames. I > have a wildcard in my DNS entries so that *.mysite.com > all go to the same server and then ColdFusion takes > that host name from the URL and acts accordingly. In > other words, someone could go to WWW.mysite.com OR to > XYZ.mysite.com and both would actually go to the same > server and would run the same code. I harvest the > first part of the URL and display the right data for > that site. (with me so far?) I have frame with a > navigation menu which lets people "jump" from "site to > site" Its a pulldown menu that targets the other > frame and causes it to load the date for a different > virtual host. When a navigation item is chosen BOTH > frames load using the new virtual host. > > Does anyone think there should be any problems keeping > client variables alive going between virtual hosts? (I > am having one :-) ) I do seem to be maintaining the > client tokens even when the problem is occuring. I > pass the CFID/CFTOKEN around in the URLs like so: > > SESSIONTIMEOUT="#CreateTimeSpan(0, 3, 0, 0)#" > clientmanagement="YES" setclientcookies="NO" > > > > > > > > > > session.session_id="deliveru_#url.cfid#_#url.cftoken#"> > > > > > I know its a long shot, but thanks for any ideas, > > > Eron > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disappearing Client Variables
My recollection - and someone jump in here if I am off base - is that client variables DO utilize cookies to some extent - and cookies can only set and read by the same domain. The browser doesn't "know" that the domains are 'virtual'. So what is happening is the client variables aren't disappearing when you go to xyz.mysite.com if you set them on www.mysite.com. They were never there to begin with. HTH Shawnea Carter - Original Message - From: "Eron Cohen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 4:34 PM Subject: Disappearing Client Variables > I have a problem that is difficult to explain which > has to do with "disappearing" client variables. I > have a site that makes use of virtual hostnames. I > have a wildcard in my DNS entries so that *.mysite.com > all go to the same server and then ColdFusion takes > that host name from the URL and acts accordingly. In > other words, someone could go to WWW.mysite.com OR to > XYZ.mysite.com and both would actually go to the same > server and would run the same code. I harvest the > first part of the URL and display the right data for > that site. (with me so far?) I have frame with a > navigation menu which lets people "jump" from "site to > site" Its a pulldown menu that targets the other > frame and causes it to load the date for a different > virtual host. When a navigation item is chosen BOTH > frames load using the new virtual host. > > Does anyone think there should be any problems keeping > client variables alive going between virtual hosts? (I > am having one :-) ) I do seem to be maintaining the > client tokens even when the problem is occuring. I > pass the CFID/CFTOKEN around in the URLs like so: > > SESSIONTIMEOUT="#CreateTimeSpan(0, 3, 0, 0)#" > clientmanagement="YES" setclientcookies="NO" > > > > > > > > > > session.session_id="deliveru_#url.cfid#_#url.cftoken#"> > > > > > I know its a long shot, but thanks for any ideas, > > > Eron > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
On 2/2/01, Greg Wolfinger penned: >Just to let you know CF 4.5 does not have a query cache limit. Can you set one though? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JavaScript Submit
try this: Untitled some text | good luck, Alexander Sicular Technical Director, Information Technology The Neurological Institute of New York Columbia Presbyterian Medical Center 212.305.1318 [EMAIL PROTECTED] -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:22 PM To: CF-Talk Subject: OT: JavaScript Submit I am trying to remember how to post a form to different urls depending on which button is clicked on. Can someone help? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disappearing Client Variables
On 2/2/01, Eron Cohen penned: >Does anyone think there should be any problems keeping >client variables alive going between virtual hosts? (I >am having one :-) ) I do seem to be maintaining the >client tokens even when the problem is occuring. I >pass the CFID/CFTOKEN around in the URLs like so: Looking at the code you included, there could be a couple problems. 1. A cookie set at www.mysite.com will not be recognized at xyz.mysite.com. Rather than just have all the pages load under different URLs, the easiest thing to do is redirect all to the same www or xyz sub domain. http://www.mydomain.com" addtoken="no"> 2. You have the sessiontimeout set to 3 days. If you're on a shared server, I doubt whether the maximum in CF Administrator is set much higher than a couple hours. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JavaScript Submit
Basically you change the 'action' URL and then force a submit... (I think you put ".value" on the end of "document.formname.action" - it works one way or the other, with or without. Experiment. *grin*) --Scott - Original Message - From: "Nathan Stanford" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 2:22 PM Subject: OT: JavaScript Submit > I am trying to remember how to post a form to different urls depending on > which button is clicked on. > > Can someone help? > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query problem
actually, you WANT a cartesian product for this, since you want every row in members compared to every row in details. that means no join. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 3:24 PM To: CF-Talk Subject: Re: Query problem > Will, > Are you using access? ID is a reserved word, I think. So, number one would > be to change the name of your field in the table. Also, is ID in members the > same as id in fields? If so, you can do something like this: > > SELECTm.email, m.id > FROMmembers m, main_details d > WHERE(d.body LIKE '%m.watch1%' > ORd.body LIKE '%m.watch2%' > ORd.body LIKE '%m.watch3%') > ANDd.id = m.id > > Make sense? Makes perfect sense, and thanks to Eric too - the only problem is d.id and m.id are entirely seperate and can't be joined. I see now that I need to join the tables - what is the thing to do, however, when there aren't any "joinable" fields? Thanks for the help, Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cached queries vs. structures was(Re: ...BETA...!! (query a query))
> Yes, but... [snip] What I am saying is that there are probably not very many situations where it would make sense to use both solutions. The foremost question is not "which is faster", but "which is more practical for my app". It's like saying, which is faster Client or Session variables? The answer is really not relevant because in most situations it really only makes sense to use one or the other. > Right, but can we use the struct functions on a query to the effect of > running a query on it? What? -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 > -Original Message- > From: Jennifer [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 3:36 PM > To: CF-Talk > Subject: RE: cached queries vs. structures was(Re: ...BETA...!! (query a > query)) > > > At 02:38 PM 2/2/01 -0500, you wrote: > > > I'd like to see some statistics on cached queries vs. querying a > > > structure. > > > >It would entirely depend on who you are planning on using your > data. It's > >like comparing apples and oranges. > > Yes, but if I could get some idea what the difference in > performance is for > a given number of queries of a certain size with the contents used a > certain number of times, I could infer how it would affect my particular > system. It wouldn't be exact but it would be a better prediction > than I can > make now. Several sets of circumstances could give me even better > results. > Scientific method and graph interpolation and all that > > >Incidentally, a query in CF can be treated like a structure already. You > >can pull records out of a query using the following format > >QueryName[ColumnName][RowNumber]. > > Right, but can we use the struct functions on a query to the effect of > running a query on it? > > > Now announcing my newly updated website > http://www.blivit.org/mr_urc/index.cfm > Resume: http://www.blivit.org/mr_urc/resume.cfm > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help: WDDX deserialize problem
|What Simon says is correct. ^^ I can't help myself are you *trying* to be punny? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
If you cached the queries by storing them in application scoped structures that refresh on demand or on a timeframe, you can update the cache by sending a command to any page in the application. It would be simple to automate this across multiple servers if you can refer to the server by IP or distinct domain name. In this case, however, this isn't an issue anyway, since the data will probably not be updated for weeks at a time and never as an emergency. At 12:54 PM 2/2/01 -0800, you wrote: >The benefits listed below diminishes if application operates under a load >balanced environment since it's very hard to synchronize large cached >queries or, any cached query for that matter, between servers. You can call >all other servers when one is being updated but performance wise not a good >idea unless you are getting huge returns. > >If you cache a product description and that product description is updated >but since each of the 3 clustered servers are holding a different cache you >might have a public relations nightmare if those orders are placed based on >an out-of-date description. > >xing > >- Original Message - >From: "Jennifer" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, February 02, 2001 9:45 AM >Subject: Re: The BETA IS OUT!!! (query a query) > > > > We have cached queries that hold information that is used on every page >hit > > of the site. Every page returns a random record from the cached record >set. > > Now, each of these records have links to products, and each record has > > several products associated with it. Ordinarily, the first link is > > displayed. However, in one section of the site, all of the products are > > displayed (sometimes these are recipe ingredients so let's assume that's > > the case). Below the section that lists the products is a section that has > > links to all recipes that contain that product. > > > > Now then (what does that phrase mean anyway?), I have cached queries that > > contain the recipes and the associated products but the query is run on >the > > recipe id. However, to get the list of all recipes that contain a >specified > > product, I'd have to use a significantly different query but one that > > contains all of the same fields, joined in a similar way. The only thing > > that changes is the search criteria: you are either searching by recipe id > > or you are searching by product id. In both cases, a lot of the same > > information is returned. > > > > Right now, this sucks. > > > > However, if I could load in a query of all recipe ids joined on the >product > > ids and another list of the copy for the recipes joined on their recipe id > > (including the first product id), I could do this instead: > > 1) display the copy linked to the recipe id where that needs to happen > > (every page of the site) by outputting a random record from the >copy/recipe > > id set > > 2) generate the list of ingredients by querying the recipe id/product id > > list for that recipe id > > 3) generate the list of recipes by querying the recipe id/product id list > > for the product id > > > > That means that instead of caching 100 recipe id/product id queries plus > > 500 product id/recipe id queries (or hitting the db every time or loading > > the records into a structure), I could cache 2 queries and query them as > > appropriate. It would be much simpler and would save resources lost to all > > other methods. > > > > Ding ding ding! > > > > At 03:09 PM 2/1/01 -0800, you wrote: > > >I haven't thought of a kickass problem/solution that would need query a > > >query ability so I'm happy that's it is there to use but not, stoked, at > > >least not yet. =) > > > > > >Have not tested or even had the priv to touch 5.0 yet but isn't just >query a > > >query just a search option? So we can do a search for array values, >structs, > > >and now arrays which are in a way structs. Hmm..actually, I have yet to >use > > >structfind() with queries so I wouldn't know if that works already. > > > > > >Maybe with query a query you can isolate a range of records that fits a >new > > >condition on a existing query? but wouldn't that be a waste of ram and >sql > > >power to return a large query in the first place that you need to do sub > > >queries on? > > > > > >Basically, I'm trying to find a good problem that would really need the > > >feature and would speed up the performance while not wasting resources. > > > > > >Xing > > > > > > > > > > So who's stoked about the Query a Query ability? Pretty damn cool eh? > > > > > > > > Michael Buffington > > > > [EMAIL PROTECTED] > > > > (714) 556-3890 x222 > > > > http://www.price.com > > > > > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lis
Re: [OT: JavaScript Submit]
document.form.submit() Nathan Stanford <[EMAIL PROTECTED]> wrote: I am trying to remember how to post a form to different urls depending on which button is clicked on. Can someone help? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Disappearing Client Variables
I have a problem that is difficult to explain which has to do with "disappearing" client variables. I have a site that makes use of virtual hostnames. I have a wildcard in my DNS entries so that *.mysite.com all go to the same server and then ColdFusion takes that host name from the URL and acts accordingly. In other words, someone could go to WWW.mysite.com OR to XYZ.mysite.com and both would actually go to the same server and would run the same code. I harvest the first part of the URL and display the right data for that site. (with me so far?) I have frame with a navigation menu which lets people "jump" from "site to site" Its a pulldown menu that targets the other frame and causes it to load the date for a different virtual host. When a navigation item is chosen BOTH frames load using the new virtual host. Does anyone think there should be any problems keeping client variables alive going between virtual hosts? (I am having one :-) ) I do seem to be maintaining the client tokens even when the problem is occuring. I pass the CFID/CFTOKEN around in the URLs like so: I know its a long shot, but thanks for any ideas, Eron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cached queries vs. structures was(Re: ...BETA...!! (query a query))
I believe we have to define the problem more accurately, and then test the alternatives, to determine which way to go: Structures vs Cached Queries. I accidently tested Structures vs Cached Queries on a Yellow Pages application. I had planned to use Structures, but developed the app both ways. I then ran into some suspicious results and did a bit of testing. The results are in the archives. So, for example, one page type lists yellow page Headings that start with "A" (Accountants, Attorneys, etc). Structure. I put ALL Headings in a single Structure. I then queried the database to get all Heading IDs for Headings that began with "A", and then CFLOOPed and pulled the Heading Name and other data out of the Structure using the list of IDs. I displayed them 100 at a time on a page, and offered "Next 100" etc. Cached Query. I cached a query for 5 minutes that contained all Headings that began with "A" Again I displayed them 100 at a time on a page, and offered "Next 100? etc. The result? Cached query was faster than Structure. The conclusion? Not a fair test. One alternative is NOT to put ALL Headings in a single Structure. Create StructureA to contain data for those Headings that begin with "A" only. Then StructureB, etc. Then using the Structure approach there would be no trips to the database whatsoever to get all Headings that start with "A". This is just a simple example of what I'll call the de-normalization that potentially can make Structures the better way to go. But to start out, it's hard to beat the flexibility, development simplicity, and speed cached queries offer. I recommend you do what I accidently did: Develop both ways and implement the one you like best. I didn't figure this out for myself. Others here pointed out to me that using Structures to hold de-normalized data was the better way to use them. There's a very informative posting somewhere in the archives. One problem I found with Structures is that it took more than 30 minutes for my app to load up the Structures on startup. There probably is a way for Structures to compete with the flexibility cached queries offer in this respect, but I haven't looked into it. best, paul At 02:51 PM 2/2/01 -0500, you wrote: >To follow this up, queries and structures are both implemented as arrays in >CF, so the performance difference should be negligible. > >Jason > > >Jason Aden >Allaire Certified Developer >[EMAIL PROTECTED] >www.wwstudios.com > > > -Original Message- > > From: Cameron Childress [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 02, 2001 2:38 PM > > To: CF-Talk > > Subject: RE: cached queries vs. structures was(Re: ...BETA...!! (query a > > query)) > > > > > > > I'd like to see some statistics on cached queries vs. querying a > > > structure. > > > > It would entirely depend on who you are planning on using your data. It's > > like comparing apples and oranges. > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Making a form text input box "active"
Scott, That's the ticket! I started to experiment with the 'element.focus' method but I was trying it within the tags and it didn't work. Placing it in the tag solved the puzzle... thanks! John -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:01 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Making a form text input box "active" I think you can use the 'focus' bit of Javascript... perhaps in your BODY tag, put in onLoad='document.formname.fieldname.focus();' Don't quote me on syntax there though :) --Scott - Original Message - From: "John Fix 3rd" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 1:48 PM Subject: OT: Making a form text input box "active" > I'm working on a simple form page to lookup items based on a sku > number. There's a text input and a SUBMIT button. The page is eventually going to be used on a PC running IE in kiosk mode, and I want to eliminate the mouse. I want the text input box to be active by default, so a user can just type a sku number and press ENTER. > > A real quick and dirty version of the page is at http://www.cornells.com/storelink/item.cfm. > > I did some quick browsing in some of my HTML references and can't find > a way to do this. I haven't done much Javascript, but maybe there's a way to solve this problem with JS? ANy suggestions would be appreciated. > > Thanks! > > John > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RFP for state portal
The State of Mississippi is soliciting bids for a state web portal infrastructure. I seriously urge any of the larger vendors to take a look at this and consider bidding on it. If accepted (one would hope, as a Cold Fusion site), you can anticipate that there would be a flood of additional projects from dozens of state agencies, since they're all looking to this portal project to provide direction for the use of web technology within state government. The state is trying to accomplish several things with this project, including central processing of credit cards for online payment of fees and sharing of public data across all agencies that need it. The people who prepared the RFP are very interested in JAVA technologies. Since much of our data resides on the state's mainframe, they would like to make that data accessible via the web. Of course, security is a top issue. The description for RFP 3205 can be found at ftp://www.its.state.ms.us/pub/issinfo/rfps/rfps.htm The RFP is linked from that page, but the direct link is ftp://www.its.state.ms.us/pub/issinfo/rfps/3205.htm There is a mandatory vendor conference in advance of the bids that will be held on February 7, 2001 in Jackson, Mississippi. If you don't attend, you won't be able to bid. You don't have to submit anything prior to the vendor conference, and you will have two days following this meeting to submit questions. Following that, bids will be due by March 2. If a Cold Fusion solution is implemented, guys, this would place CF at the center of our state government's web presence and could result in a lot of work for a number of CF shops for some time to come. The influence would likely ripple out to the web design firms in central Mississippi. PLEASE take a look. After you download the RFP and read it, if you have any questions, contact Wally DeRossette at [EMAIL PROTECTED] The project schedule is on page 25 of the RFP. I'm not directly involved with preparing the RFP or awarding the bid, but this process is handled here in my office, and I'm available to help you in any way I can. Feel free to contact me off list at [EMAIL PROTECTED] Regards, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: JavaScript Submit
I am trying to remember how to post a form to different urls depending on which button is clicked on. Can someone help? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cached queries vs. structures was(Re: ...BETA...!! (query a query))
At 02:38 PM 2/2/01 -0500, you wrote: > > I'd like to see some statistics on cached queries vs. querying a > > structure. > >It would entirely depend on who you are planning on using your data. It's >like comparing apples and oranges. Yes, but if I could get some idea what the difference in performance is for a given number of queries of a certain size with the contents used a certain number of times, I could infer how it would affect my particular system. It wouldn't be exact but it would be a better prediction than I can make now. Several sets of circumstances could give me even better results. Scientific method and graph interpolation and all that >Incidentally, a query in CF can be treated like a structure already. You >can pull records out of a query using the following format >QueryName[ColumnName][RowNumber]. Right, but can we use the struct functions on a query to the effect of running a query on it? Now announcing my newly updated website http://www.blivit.org/mr_urc/index.cfm Resume: http://www.blivit.org/mr_urc/resume.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help: WDDX deserialize problem
What Simon says is correct. XMLForamting the packet replaces all of the < > " ' & symbols with < > The WDDX serializer also attempts to replace all of these symbols in your *conent* inside of the packet. One behavior I have noted that is even given a properly formatted packet before IE submits the form it re-converts all of the non literal values & < with their literal values and THEN submits the form. It does this and no CF code touches it. It is posted to the exact same form with only a CFOUTPUT of the packet and a CFABORT in the application.cfm It does not do this ine very browser (I was using IE 5.5) I think it occurs randomly from browser to browser.. What a pain. I have had several other folks check this out and they all noted the same behavior with certain browsers. So just be wary of this.. I am not exactly sure what causes this behavior ro occur or if it is just me and the people I had test this behaviors imagination. Jeremy Allen elliptIQ Inc. >-Original Message- >From: Carol Bluestein [mailto:[EMAIL PROTECTED]] >Sent: Friday, February 02, 2001 3:36 PM >To: CF-Talk >Subject: Help: WDDX deserialize problem > > >I'm sure this is a Friday problem and I'm just brain dead but I >have no idea >what is going wrong or what the message directs me to correct. >Something is >happening and I've no idea how to fix it or where to look. Would >appreciate it >if someone could point me in right direction. It is probably >right under my >nose but it has eluded me for longer than I care to say. > > > > >Works fine: dump shows all info, no problem (fields that have >NULL in them are >showing up empty) > >#HTMLEditFormat(wddxPacket)# : also shows everything, no problem > >OK. Stick in a form. > > >name="wddxContent" >VALUE="#HTMLEditFormat(wddxPacket)#"> >TITLE="Continue and process" ACCESSKEY="C" > > >Go to Action page: > >Deserialize in "sync_main_action2.cfm" > >input="#Form.wddxContent#" >output="qRowInfo" >action="WDDX2CFML"> > >B! > >Error Diagnostic Information >XML parsing error: not well-formed (error code 4, line 1, column 15, buffer >offset 15) >The error occurred while processing an element with a general identifier of >(CFWDDX), occupying document position (50:1) to (53:20) in the >template file >/albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm >The specific sequence of files included or processed is: >/albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm . >Date/Time: Fri Feb 02 15:32:13 2001 >Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) >Remote Address: 10.57.92.152 >HTTP Referer: http://albwebdev2/cfapps/star/sync/sync_main_action.cfm >Template: /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm > >Thanks, in advance, >Carol > > >Carol L. Bluestein >Senior Programmer >NYS Office of Real Property >518-486-6335 >[EMAIL PROTECTED] > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Making a form text input box "active"
What you are looking for is the following bit of code. The second method
will select any text that is already in the textbox so that it will be
overwritten. This allows you to put something like "Enter SKU here ..." in
the textbox without requiring them to manually delete it before starting to
enter the SKU.
function setFocus()
{
document.myform.mytext.focus();
document.myform.mytext.select();
}
Regards,
Steve
-Original Message-
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 3:48 PM
To: CF-Talk
Subject: OT: Making a form text input box "active"
I'm working on a simple form page to lookup items based on a sku number.
There's a text input and a SUBMIT button. The page is eventually going to
be used on a PC running IE in kiosk mode, and I want to eliminate the mouse.
I want the text input box to be active by default, so a user can just type a
sku number and press ENTER.
A real quick and dirty version of the page is at
http://www.cornells.com/storelink/item.cfm.
I did some quick browsing in some of my HTML references and can't find a way
to do this. I haven't done much Javascript, but maybe there's a way to
solve this problem with JS? ANy suggestions would be appreciated.
Thanks!
John
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
> The benefits listed below diminishes if application operates under a load > balanced environment since it's very hard to synchronize large cached > queries or, any cached query for that matter, between servers. You can call > all other servers when one is being updated but performance wise not a good > idea unless you are getting huge returns. I disagree. If you set up your clustered envirtonment correctly, you should have all the server flush their cache when the database is updated or at a scheduled time. What we have done is actually have one server just run as the "commander" as we call it. When we make a site wide update, we have "the commander" send out to the other servers script commands to run (based on what it is we want them all to do). I don't see how this is "performancely wise" this isn't a good idea. If you don't keep all your servers exactly the same, then data corruption can occur. --=@ greg @=-- - Original Message - From: "Xing Li" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 3:54 PM Subject: Re: The BETA IS OUT!!! (query a query) > The benefits listed below diminishes if application operates under a load > balanced environment since it's very hard to synchronize large cached > queries or, any cached query for that matter, between servers. You can call > all other servers when one is being updated but performance wise not a good > idea unless you are getting huge returns. > > If you cache a product description and that product description is updated > but since each of the 3 clustered servers are holding a different cache you > might have a public relations nightmare if those orders are placed based on > an out-of-date description. > > xing > > - Original Message - > From: "Jennifer" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, February 02, 2001 9:45 AM > Subject: Re: The BETA IS OUT!!! (query a query) > > > > We have cached queries that hold information that is used on every page > hit > > of the site. Every page returns a random record from the cached record > set. > > Now, each of these records have links to products, and each record has > > several products associated with it. Ordinarily, the first link is > > displayed. However, in one section of the site, all of the products are > > displayed (sometimes these are recipe ingredients so let's assume that's > > the case). Below the section that lists the products is a section that has > > links to all recipes that contain that product. > > > > Now then (what does that phrase mean anyway?), I have cached queries that > > contain the recipes and the associated products but the query is run on > the > > recipe id. However, to get the list of all recipes that contain a > specified > > product, I'd have to use a significantly different query but one that > > contains all of the same fields, joined in a similar way. The only thing > > that changes is the search criteria: you are either searching by recipe id > > or you are searching by product id. In both cases, a lot of the same > > information is returned. > > > > Right now, this sucks. > > > > However, if I could load in a query of all recipe ids joined on the > product > > ids and another list of the copy for the recipes joined on their recipe id > > (including the first product id), I could do this instead: > > 1) display the copy linked to the recipe id where that needs to happen > > (every page of the site) by outputting a random record from the > copy/recipe > > id set > > 2) generate the list of ingredients by querying the recipe id/product id > > list for that recipe id > > 3) generate the list of recipes by querying the recipe id/product id list > > for the product id > > > > That means that instead of caching 100 recipe id/product id queries plus > > 500 product id/recipe id queries (or hitting the db every time or loading > > the records into a structure), I could cache 2 queries and query them as > > appropriate. It would be much simpler and would save resources lost to all > > other methods. > > > > Ding ding ding! > > > > At 03:09 PM 2/1/01 -0800, you wrote: > > >I haven't thought of a kickass problem/solution that would need query a > > >query ability so I'm happy that's it is there to use but not, stoked, at > > >least not yet. =) > > > > > >Have not tested or even had the priv to touch 5.0 yet but isn't just > query a > > >query just a search option? So we can do a search for array values, > structs, > > >and now arrays which are in a way structs. Hmm..actually, I have yet to > use > > >structfind() with queries so I wouldn't know if that works already. > > > > > >Maybe with query a query you can isolate a range of records that fits a > new > > >condition on a existing query? but wouldn't that be a waste of ram and > sql > > >power to return a large query in the first place that you need to do sub > > >queries on? > > > > > >Basically, I'm trying to find a good problem that
RE: Making a form text input box "active"
John, The script below will do just what you're looking for. - Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 Amateurs practice until they get it right, Experts practice until they can't get it wrong. -Original Message- From: John Fix 3rd [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:48 PM To: CF-Talk Subject: OT: Making a form text input box "active" I'm working on a simple form page to lookup items based on a sku number. There's a text input and a SUBMIT button. The page is eventually going to be used on a PC running IE in kiosk mode, and I want to eliminate the mouse. I want the text input box to be active by default, so a user can just type a sku number and press ENTER. A real quick and dirty version of the page is at http://www.cornells.com/storelink/item.cfm. I did some quick browsing in some of my HTML references and can't find a way to do this. I haven't done much Javascript, but maybe there's a way to solve this problem with JS? ANy suggestions would be appreciated. Thanks! John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Making a form text input box "active"
Try setting the tab-order to 0 for IE, or add a set focus to the form item in the on-load. -Original Message- From: John Fix 3rd [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 3:48 PM To: CF-Talk Subject: OT: Making a form text input box "active" I'm working on a simple form page to lookup items based on a sku number. There's a text input and a SUBMIT button. The page is eventually going to be used on a PC running IE in kiosk mode, and I want to eliminate the mouse. I want the text input box to be active by default, so a user can just type a sku number and press ENTER. A real quick and dirty version of the page is at http://www.cornells.com/storelink/item.cfm. I did some quick browsing in some of my HTML references and can't find a way to do this. I haven't done much Javascript, but maybe there's a way to solve this problem with JS? ANy suggestions would be appreciated. Thanks! John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Making a form text input box "active"
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi John, Real easy: Going with Dave Watts mentioning today that the best answer to any question is to try it for yourself, another way to do things... look at how others do it, especially in regards to JS or HTML issues. You can find the above script by looking at googles' site or ton's of others. HTH's. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Making a form text input box "active"
I think you can use the 'focus' bit of Javascript... perhaps in your BODY tag, put in onLoad='document.formname.fieldname.focus();' Don't quote me on syntax there though :) --Scott - Original Message - From: "John Fix 3rd" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 1:48 PM Subject: OT: Making a form text input box "active" > I'm working on a simple form page to lookup items based on a sku number. There's a text input and a SUBMIT button. The page is eventually going to be used on a PC running IE in kiosk mode, and I want to eliminate the mouse. I want the text input box to be active by default, so a user can just type a sku number and press ENTER. > > A real quick and dirty version of the page is at http://www.cornells.com/storelink/item.cfm. > > I did some quick browsing in some of my HTML references and can't find a way to do this. I haven't done much Javascript, but maybe there's a way to solve this problem with JS? ANy suggestions would be appreciated. > > Thanks! > > John > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Making a form text input box "active"
in the onload event of the form put "document.formname.fieldname.focus();", which will force the field to be "active" when the document is loaded. DC - Original Message - From: "John Fix 3rd" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 15:48 Subject: OT: Making a form text input box "active" > I'm working on a simple form page to lookup items based on a sku number. There's a text input and a SUBMIT button. The page is eventually going to be used on a PC running IE in kiosk mode, and I want to eliminate the mouse. I want the text input box to be active by default, so a user can just type a sku number and press ENTER. > > A real quick and dirty version of the page is at http://www.cornells.com/storelink/item.cfm. > > I did some quick browsing in some of my HTML references and can't find a way to do this. I haven't done much Javascript, but maybe there's a way to solve this problem with JS? ANy suggestions would be appreciated. > > Thanks! > > John > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Making a form text input box "active"
I'm working on a simple form page to lookup items based on a sku number. There's a text input and a SUBMIT button. The page is eventually going to be used on a PC running IE in kiosk mode, and I want to eliminate the mouse. I want the text input box to be active by default, so a user can just type a sku number and press ENTER. A real quick and dirty version of the page is at http://www.cornells.com/storelink/item.cfm. I did some quick browsing in some of my HTML references and can't find a way to do this. I haven't done much Javascript, but maybe there's a way to solve this problem with JS? ANy suggestions would be appreciated. Thanks! John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help: WDDX deserialize problem
HTML Formatting the XML Packet "breaks" the XML formatting. You shouldn't need to HTMLFormat the variable before passing it. If you wanted to format it at all and still be able to use it as XML, I'd think you'd want to use the XMLFormat() function. ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 3:36 PM To: CF-Talk Subject: Help: WDDX deserialize problem I'm sure this is a Friday problem and I'm just brain dead but I have no idea what is going wrong or what the message directs me to correct. Something is happening and I've no idea how to fix it or where to look. Would appreciate it if someone could point me in right direction. It is probably right under my nose but it has eluded me for longer than I care to say. Works fine: dump shows all info, no problem (fields that have NULL in them are showing up empty) #HTMLEditFormat(wddxPacket)# : also shows everything, no problem OK. Stick in a form. B! Error Diagnostic Information XML parsing error: not well-formed (error code 4, line 1, column 15, buffer offset 15) The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (50:1) to (53:20) in the template file /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm The specific sequence of files included or processed is: /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm . Date/Time: Fri Feb 02 15:32:13 2001 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 10.57.92.152 HTTP Referer: http://albwebdev2/cfapps/star/sync/sync_main_action.cfm Template: /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm Thanks, in advance, Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
The benefits listed below diminishes if application operates under a load balanced environment since it's very hard to synchronize large cached queries or, any cached query for that matter, between servers. You can call all other servers when one is being updated but performance wise not a good idea unless you are getting huge returns. If you cache a product description and that product description is updated but since each of the 3 clustered servers are holding a different cache you might have a public relations nightmare if those orders are placed based on an out-of-date description. xing - Original Message - From: "Jennifer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 9:45 AM Subject: Re: The BETA IS OUT!!! (query a query) > We have cached queries that hold information that is used on every page hit > of the site. Every page returns a random record from the cached record set. > Now, each of these records have links to products, and each record has > several products associated with it. Ordinarily, the first link is > displayed. However, in one section of the site, all of the products are > displayed (sometimes these are recipe ingredients so let's assume that's > the case). Below the section that lists the products is a section that has > links to all recipes that contain that product. > > Now then (what does that phrase mean anyway?), I have cached queries that > contain the recipes and the associated products but the query is run on the > recipe id. However, to get the list of all recipes that contain a specified > product, I'd have to use a significantly different query but one that > contains all of the same fields, joined in a similar way. The only thing > that changes is the search criteria: you are either searching by recipe id > or you are searching by product id. In both cases, a lot of the same > information is returned. > > Right now, this sucks. > > However, if I could load in a query of all recipe ids joined on the product > ids and another list of the copy for the recipes joined on their recipe id > (including the first product id), I could do this instead: > 1) display the copy linked to the recipe id where that needs to happen > (every page of the site) by outputting a random record from the copy/recipe > id set > 2) generate the list of ingredients by querying the recipe id/product id > list for that recipe id > 3) generate the list of recipes by querying the recipe id/product id list > for the product id > > That means that instead of caching 100 recipe id/product id queries plus > 500 product id/recipe id queries (or hitting the db every time or loading > the records into a structure), I could cache 2 queries and query them as > appropriate. It would be much simpler and would save resources lost to all > other methods. > > Ding ding ding! > > At 03:09 PM 2/1/01 -0800, you wrote: > >I haven't thought of a kickass problem/solution that would need query a > >query ability so I'm happy that's it is there to use but not, stoked, at > >least not yet. =) > > > >Have not tested or even had the priv to touch 5.0 yet but isn't just query a > >query just a search option? So we can do a search for array values, structs, > >and now arrays which are in a way structs. Hmm..actually, I have yet to use > >structfind() with queries so I wouldn't know if that works already. > > > >Maybe with query a query you can isolate a range of records that fits a new > >condition on a existing query? but wouldn't that be a waste of ram and sql > >power to return a large query in the first place that you need to do sub > >queries on? > > > >Basically, I'm trying to find a good problem that would really need the > >feature and would speed up the performance while not wasting resources. > > > >Xing > > > > > > > So who's stoked about the Query a Query ability? Pretty damn cool eh? > > > > > > Michael Buffington > > > [EMAIL PROTECTED] > > > (714) 556-3890 x222 > > > http://www.price.com > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
No Subject
The images are in-line using the standard HTML image tag. I have never used this tag but am wondering if cfimpersonate would work to give the username/password? Linda McElroy Web Designer Sears Direct Response Jeffry Houser cc: Subject: Re: CFMail problem 02/02/01 11:20 AM Please respond to jeff Are you sending a link to the image, or are you attaching the image to the e-mail? If you are sending an html e-mail with an image tag that references an image sitting on a password protected site, that is probably the problem. I'm grasping for straws, since I'm not a Notes Administrator, but I thought that Notes turned all embedded objects into attachments. Are the images attached to the e-mail, as opposed to inline? [EMAIL PROTECTED] wrote: > I am having a problem with images showing in e-mail sent with CFMail, the > messages are fine but Lotus Notes just shows [IMAGE] where the images > should be. I wonder if the problem is that we have to log-on to the > website, we use WebTrends and needed the Authorized Username. Has anyone > encountered a similar problem, if so, is there a workaround? > > TIA, > Linda McElroy > Web Designer > Sears Direct Response > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've got the brains, you've got the looks, let's make lots of money Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help: WDDX deserialize problem
I'm sure this is a Friday problem and I'm just brain dead but I have no idea what is going wrong or what the message directs me to correct. Something is happening and I've no idea how to fix it or where to look. Would appreciate it if someone could point me in right direction. It is probably right under my nose but it has eluded me for longer than I care to say. Works fine: dump shows all info, no problem (fields that have NULL in them are showing up empty) #HTMLEditFormat(wddxPacket)# : also shows everything, no problem OK. Stick in a form. B! Error Diagnostic Information XML parsing error: not well-formed (error code 4, line 1, column 15, buffer offset 15) The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (50:1) to (53:20) in the template file /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm The specific sequence of files included or processed is: /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm . Date/Time: Fri Feb 02 15:32:13 2001 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 10.57.92.152 HTTP Referer: http://albwebdev2/cfapps/star/sync/sync_main_action.cfm Template: /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm Thanks, in advance, Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Brain Fart
| You can count the characters in JS to make sure it's under the limit but I
| don't know of any way to do it before submit.
Fire off your JS function every time they press a key using onkeyup="". I
would suggest doing it again on submit in case their browser doesn't support
onkeyup.
Todd Ashworth
Saber Corporation
(803) 327-0137 [111]
- Original Message -
From: "Jennifer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 2:55 PM
Subject: RE: Brain Fart
|
| JSFunctionName(formname)
| {
| if (formname.formfield.value.length > 256)
|{
| alert("Please enter at most 255 characters in the \"formfield\"
field.");
| formname.formfield.focus();
| return (false);
|}
| return (true);
| }
|
| Or something. Use at your own risk. I didn't test that.
|
| At 02:21 PM 2/2/01 -0500, you wrote:
| >len(form.specialrequest) returns the number of characters.
| >
| >If you want to automatically chop off at 255 rather than letting them
| >re-enter, then you'll want to use the Mid() function as well.
| >
| >What would be very nice (and I'd love to see an example from someone who
| >already knows how), would be to use JavaScript to alert and hopefully
stop
| >the user when they've typed in characer 256.
| >
| >Patricia Lee
| >
| >Cold Fusion Developer & Instructor, ACCD
| >Fig Leaf Software "We've Got you Covered"
| >
| >[EMAIL PROTECTED]202.797.5426
| >
| >
| >|-Original Message-
| >|From: Tony Gruen [mailto:[EMAIL PROTECTED]]
| >|Sent: Friday, February 02, 2001 2:03 PM
| >|To: CF-Talk
| >|Subject: OT: Brain Fart
| >|
| >|
| >|I am having a challenge trying to envision a solution to the following:
| >|
| >|Wherever I have a textarea field in my insert statement I
| >|strip commas and
| >|returns in this fashion:
| >|
| >|'#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#',
| >|
| >|Is there a way to check the number of characters that was
| >|entered when the
| >|form was submitted? I need to limit it to 255 - I have a specific group
| >|entering war and peace in this field and upon insert it is
| >|causing problems
| >|down the line when a data team member (internal) tries to
| >|download the form
| >|submissions out of the database for processing.
| >|
| >|Any thoughts, suggestions, ideas?
| >|
| >|Tony Gruen
| >|
| >|
| >|
| >
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query problem
> Will, > Are you using access? ID is a reserved word, I think. So, number one would > be to change the name of your field in the table. Also, is ID in members the > same as id in fields? If so, you can do something like this: > > SELECTm.email, m.id > FROMmembers m, main_details d > WHERE(d.body LIKE '%m.watch1%' > ORd.body LIKE '%m.watch2%' > ORd.body LIKE '%m.watch3%') > ANDd.id = m.id > > Make sense? Makes perfect sense, and thanks to Eric too - the only problem is d.id and m.id are entirely seperate and can't be joined. I see now that I need to join the tables - what is the thing to do, however, when there aren't any "joinable" fields? Thanks for the help, Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Brain Fart
You could do something like this: Untitled Todd Ashworth Saber Corporation (803) 327-0137 [111] - Original Message - From: "Patricia Lee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 2:21 PM Subject: RE: Brain Fart | len(form.specialrequest) returns the number of characters. | | If you want to automatically chop off at 255 rather than letting them | re-enter, then you'll want to use the Mid() function as well. | | What would be very nice (and I'd love to see an example from someone who | already knows how), would be to use JavaScript to alert and hopefully stop | the user when they've typed in characer 256. | | Patricia Lee | | Cold Fusion Developer & Instructor, ACCD | Fig Leaf Software "We've Got you Covered" | | [EMAIL PROTECTED]202.797.5426 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS and ISA on same server
Thanks Steve. I'm quite comfortable installing NICS and working with multiple NICs in a single computer. I'm not sure that's the route I ultimately want to take either, though. I'm leaning now toward putting a 3Com OfficeConnect Internet Firewall DMZ in. The DMZ port allows me to make my web/email server accessible from the outside world while protecting my internal computers. The firewall runs about $1,200 on the street, which makes it quite a bit cheaper than buying the full ISA license that I had originally been planning on anyway. Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 Amateurs practice until they get it right, Experts practice until they can't get it wrong. -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:29 PM To: Scott Brader Cc: [EMAIL PROTECTED] Subject: RE: IIS and ISA on same server That's a tough question. My first response would be that you should let someone with a little more security experience help you, or do it for you. The reason being, your one man company, to a large degree, relies on the stability and availability of the services that you provide. Adding to the complexity, each one of the services that you mentioned also have their own unique security requirements. If you are going to do it alone for now, you may be best served by starting with a caching proxy server that supports Network Address Translation (NAT). The market leaders in this field also provide a decent firewall component. It's not the same as running Firewall-1/Raptor/Gauntlet/etc. but, it should serve you nicely without overwhelming you. This will also allow you to use a private non-routable address space, like 192.168.0.0, to mask your backend machines, while providing a transparent mapping of services to internal IP and caching content to accelerate access to web content. Both of the following products are very good and should do everything that you mentioned. I still strongly recommend that, if you use such a product, you install it on a separate computer. Pay attention to the hardware requirements too. For instance, most people aren't used to having to install two network cards on one computer. WinRoute Pro: http://www.tinysoftware.com/winpro.php WinProxy: http://www.ositis.com/english/home/hm_smbs_home_en.asp As an added piece of advice, be careful if/when posting questions about security problems or detailing your security infrastructure. Security help/faq newsgroups and listservs are often perused by people looking for easy targets or who are casing a particular company/site. Be sure to mask real passwords, ports, IP addresses, etc. if you ever post details of your infrastructure. In moments of pressure caused by a non-working application it's easy to forget about security and post questions like, "My shopping cart security isn't working and people can get stuff for free! How can I stop this?" (signed [EMAIL PROTECTED]) Any nefarious sort, and some idly curious, will quickly go to "www.my_e_company.com/" and order all your inventory for free! This sort of thing happens more often than you'd think. Good luck, I hope this helps, Steve -Original Message- From: Scott Brader [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 11:15 AM To: [EMAIL PROTECTED] Subject: RE: IIS and ISA on same server Steve, Thanks for your response. At this point, the company is just me, so the load is really not going to be too high. I appreciate your input on separating the firewall functionality out, though. Do you have any recommendations of a SOHO firewall solution that would allow me to run my own mail/web server inside and allow me to access the Internet. I'm sorry to sound so ignorant, but I'm a developer not a networking expert. I appreciate any insight you can provide. Thanks, Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 Amateurs practice until they get it right, Experts practice until they can't get it wrong. -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 9:57 AM To: CF-Talk Subject: RE: IIS and ISA on same server The first thing that I will say, and this can't be stressed enough, do not run a firewall on the same box as a web server! Web, email, and application servers have always been problematic with regards to security. Their very nature is to share files, the exact opposite of what you want from a firewall. By building your firewall on top of these other services you immediately undermine the integrity of the tool that is meant to be your protection against attack. One of the most devastating network/host intrusions is the rooting of a firewall. Administrators
RE: cached queries vs. structures was(Re: ...BETA...!! (query a query))
To follow this up, queries and structures are both implemented as arrays in CF, so the performance difference should be negligible. Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com > -Original Message- > From: Cameron Childress [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 2:38 PM > To: CF-Talk > Subject: RE: cached queries vs. structures was(Re: ...BETA...!! (query a > query)) > > > > I'd like to see some statistics on cached queries vs. querying a > > structure. > > It would entirely depend on who you are planning on using your data. It's > like comparing apples and oranges. > > Incidentally, a query in CF can be treated like a structure already. You > can pull records out of a query using the following format > QueryName[ColumnName][RowNumber]. > > -Cameron > > > Cameron Childress > elliptIQ Inc. > p.770.460.7277.232 > f.770.460.0963 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Brain Fart
You can count the characters in JS to make sure it's under the limit but I
don't know of any way to do it before submit.
JSFunctionName(formname)
{
if (formname.formfield.value.length > 256)
{
alert("Please enter at most 255 characters in the \"formfield\" field.");
formname.formfield.focus();
return (false);
}
return (true);
}
Or something. Use at your own risk. I didn't test that.
At 02:21 PM 2/2/01 -0500, you wrote:
>len(form.specialrequest) returns the number of characters.
>
>If you want to automatically chop off at 255 rather than letting them
>re-enter, then you'll want to use the Mid() function as well.
>
>What would be very nice (and I'd love to see an example from someone who
>already knows how), would be to use JavaScript to alert and hopefully stop
>the user when they've typed in characer 256.
>
>Patricia Lee
>
>Cold Fusion Developer & Instructor, ACCD
>Fig Leaf Software "We've Got you Covered"
>
>[EMAIL PROTECTED]202.797.5426
>
>
>|-Original Message-
>|From: Tony Gruen [mailto:[EMAIL PROTECTED]]
>|Sent: Friday, February 02, 2001 2:03 PM
>|To: CF-Talk
>|Subject: OT: Brain Fart
>|
>|
>|I am having a challenge trying to envision a solution to the following:
>|
>|Wherever I have a textarea field in my insert statement I
>|strip commas and
>|returns in this fashion:
>|
>|'#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#',
>|
>|Is there a way to check the number of characters that was
>|entered when the
>|form was submitted? I need to limit it to 255 - I have a specific group
>|entering war and peace in this field and upon insert it is
>|causing problems
>|down the line when a data team member (internal) tries to
>|download the form
>|submissions out of the database for processing.
>|
>|Any thoughts, suggestions, ideas?
>|
>|Tony Gruen
>|
>|
>|
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Brain Fart
Patricia,
You could try using a variation on the following theme:
function checkLen(ff) {
if (ff.value.length > 255) {
ff.value = ff.value.slice(0, 255);
alert("You have overstepped the boundaries of your authority.");
}
}
Best,
Seva Petrov
Senior Developer
TheSquare.com
> -Original Message-
> From: Patricia Lee [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 2:22 PM
> To: CF-Talk
> Subject: RE: Brain Fart
>
>
> len(form.specialrequest) returns the number of characters.
>
> If you want to automatically chop off at 255 rather than letting them
> re-enter, then you'll want to use the Mid() function as well.
>
> What would be very nice (and I'd love to see an example from
> someone who
> already knows how), would be to use JavaScript to alert and
> hopefully stop
> the user when they've typed in characer 256.
>
> Patricia Lee
>
> Cold Fusion Developer & Instructor, ACCD
> Fig Leaf Software "We've Got you Covered"
>
> [EMAIL PROTECTED]202.797.5426
>
>
> |-Original Message-
> |From: Tony Gruen [mailto:[EMAIL PROTECTED]]
> |Sent: Friday, February 02, 2001 2:03 PM
> |To: CF-Talk
> |Subject: OT: Brain Fart
> |
> |
> |I am having a challenge trying to envision a solution to the
> following:
> |
> |Wherever I have a textarea field in my insert statement I
> |strip commas and
> |returns in this fashion:
> |
> |'#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#',
> |
> |Is there a way to check the number of characters that was
> |entered when the
> |form was submitted? I need to limit it to 255 - I have a
> specific group
> |entering war and peace in this field and upon insert it is
> |causing problems
> |down the line when a data team member (internal) tries to
> |download the form
> |submissions out of the database for processing.
> |
> |Any thoughts, suggestions, ideas?
> |
> |Tony Gruen
> |
> |
> |
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Brain Fart
Too many characters!!! Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com > -Original Message- > From: Tony Gruen [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 2:03 PM > To: CF-Talk > Subject: OT: Brain Fart > > > I am having a challenge trying to envision a solution to the following: > > Wherever I have a textarea field in my insert statement I strip commas and > returns in this fashion: > > '#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#', > > Is there a way to check the number of characters that was entered when the > form was submitted? I need to limit it to 255 - I have a specific group > entering war and peace in this field and upon insert it is > causing problems > down the line when a data team member (internal) tries to > download the form > submissions out of the database for processing. > > Any thoughts, suggestions, ideas? > > Tony Gruen > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do I caputure "onClick" event in Javascript when uisng type="image" in input tag on Netscape?
We used href to solve the problem To bad Netscape and IE don't just get along Thanks Mike - Original Message - From: Mike <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 12:54 PM Subject: How do I caputure "onClick" event in Javascript when uisng type="image" in input tag on Netscape? > How do I capture "onClick" event in JavaScript when using type="image" in > input tag on Netscape? > > > Thanks Mike > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfform & enable cab question?
Any of the java controls ie: CFTREE, CFSLIDER, CFTEXTBOX, etc. Dc - Original Message - From: "Emmet McGovern" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 14:15 Subject: cfform & enable cab question? > Does anyone know what specific functions of cfform require the allaire ..cab? > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Shopping Malls in CF
At 02:08 PM 2/2/01 -0500, you wrote: >Is there anyone here doing a Shopping Mall application? If so how are you >handling collections, shipping, taxes when people buy things from different >stores in the mall and check everything out in one cart and then try to ship >it multiple locations? > > >TIA, >Duane Tag each product with a field that indicates which store it came from so you can do back end summaries for distribution of collections and taxes. Tax calculation isn't affected by separate shipping locations because it is calculated for point of purchase. For the shipping to multiple locations, we let them set up separate shipping boxes, attach a shipping method and address to the box, drag the product(s) from the cart into the appropriate shipping box, then calculate shipping for all boxes and add it to the total. Judith Campbell Chief Technical Officer Digital Positions, Inc. [EMAIL PROTECTED] 404-351-9366 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Brain Fart
I don't have anything quite that special, but I do a two-step process: 1 - JavaScript onChange warning them of the 250 char limit and asking them to shorten the entry 2 - CF code Left(variable, 250) to chop it off if they ignore the warning. (Notice that the textarea is 5x50, so if they just fill the box without scrolling, they'll be ok.) Here's the JavaScript: Eric -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 11:22 AM To: CF-Talk Subject: RE: Brain Fart len(form.specialrequest) returns the number of characters. If you want to automatically chop off at 255 rather than letting them re-enter, then you'll want to use the Mid() function as well. What would be very nice (and I'd love to see an example from someone who already knows how), would be to use JavaScript to alert and hopefully stop the user when they've typed in characer 256. Patricia Lee Cold Fusion Developer & Instructor, ACCD Fig Leaf Software "We've Got you Covered" [EMAIL PROTECTED]202.797.5426 |-Original Message- |From: Tony Gruen [mailto:[EMAIL PROTECTED]] |Sent: Friday, February 02, 2001 2:03 PM |To: CF-Talk |Subject: OT: Brain Fart | | |I am having a challenge trying to envision a solution to the following: | |Wherever I have a textarea field in my insert statement I |strip commas and |returns in this fashion: | |'#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#', | |Is there a way to check the number of characters that was |entered when the |form was submitted? I need to limit it to 255 - I have a specific group |entering war and peace in this field and upon insert it is |causing problems |down the line when a data team member (internal) tries to |download the form |submissions out of the database for processing. | |Any thoughts, suggestions, ideas? | |Tony Gruen | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cached queries vs. structures was(Re: ...BETA...!! (query a query))
> I'd like to see some statistics on cached queries vs. querying a > structure. It would entirely depend on who you are planning on using your data. It's like comparing apples and oranges. Incidentally, a query in CF can be treated like a structure already. You can pull records out of a query using the following format QueryName[ColumnName][RowNumber]. -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfform & enable cab question?
Does anyone know what specific functions of cfform require the allaire .cab? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:RE: RE: RE: Request Scope
Thank you Jason and everyone else who has contributed. This has been very productive and I'm very appreciative of your time. Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:RE: RE: RE: Request Scope Author: [EMAIL PROTECTED] Date: 2/2/01 1:35 PM Carol, Your first example is correct. With CF 4.0 and up, the application and session scopes are ColdFusion structures (as are most other scopes). Structures organize data in a sort of hierarchy using name-value pairs. Structures can contain any other variable type, including other structures. The duplicate() function takes any variable and makes a copy of it into another variable name. This is why you can duplicate() the entire session scope. It will take the session scope (a structure) and copy all variables under it. It will dig down and get any nested structures, arrays, and queries as well. CAUTION: When using the duplicate() function on large queries, CF server may crash. It can cause very low-level errors (C code errors). Sometimes the only way to get CF working again is to do a complete reboot of the machine. This is not a problem when working with small queries. Complex data types can be tough to grasp at first. You can get a visual representation of them using a custom tag that outputs a representation of the data. It's available on the Developer Exchange by searching for "dump". It's the cf_dump tag. I've never used this version of it, but Spectra has a tag that does the same thing (the DevEx version is probably copied from Spectra, but I'm not sure), and it's a very useful utility. You can input any variable name and it will show you what's contained in it. In Spectra the variable types are color-coded: blue/purple = structure, red = query, green = array, black border = WDDX string. Hopefully this DevEx tag will use a similar color-coding scheme. Oh, and to answer the question about referring to request variables, something like this would work: #request.ses.sessionTimeout# #request.app.applicationName# #request.ses.userProfile.username# #request.app.aApplicationIDs[2]# OR: etc. HTH, Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com > -Original Message- > From: Carol Bluestein [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 12:20 PM > To: CF-Talk > Subject: Re:RE: RE: Request Scope > > > Jason, > Thank you. Thank you. Thank you. > That makes so much more sense. > > May I trouble you one more time for the code, and I'm sure this > is showing some > kind of difficulty on my part understanding complex structures: > > Do I set this code for EACH session and application variable or > does the code > cover all session/application variables ? > > > OR > > > > > > Depending on the above, how do I reference the request variable in a code? > > Thanks again, > Carol > > > This will make like so much easier. > > > > > > Carol L. Bluestein > Senior Programmer > NYS Office of Real Property > 518-486-6335 > [EMAIL PROTECTED] > > > Reply Separator > Subject:RE: RE: Request Scope > Author: [EMAIL PROTECTED] > Date: 2/2/01 11:30 AM > > Spectra uses the request scope extensively. It's a good place to put > thread-safe global variables. What you've heard about eliminating the need > for session, and application locks is true. You can copy all your session > and application variables to the request scope and not need to use CFLOCK > around each call to these variables. > > You would do something like this: > > > > > This code would go in your application.cfm file so those variables get > copied every time someone requests a page. > > You CANNOT use: > > > > > In most languages, including ColdFusion, when you set a variable > equal to a > complex data set (like a structure, query, array, etc.), it will create a > reference back to the complex data set. In other words, it's just > creating a > pointer to the original data in the session or application scope, > so you're > still not thread safe. > > Using the duplicate() function will make a complete copy of those > structures > (the session and application scopes are ColdFusion structures) into the > request scope and you will be accessing the copied data, not the original > data in in the shared scope. > > HTH, > > Jason > > > Jason Aden > Allaire Certified Developer > [EMAIL PROTECTED] > www.wwstudios.com > > > -Original Message- > > From: Carol Bluestein [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 02, 2001 10:25 AM > > To: CF-Talk > > Subject: Re:RE: Request Scope > > > > > > Is any one out there using the request variables extensively? > > > > I'd like to know more about the request scope and how to use it. > > I've found > > very little in my documentation (
RE: cached queries vs. structures was(Re: ...BETA...!! (query a query))
Also, you must take into account the fact that CF is not a DBMS, it has a mini-database engine in it, but it does not have an query optimization engine (like a SQL Server or an Oracle would have). So databases will usually process queries quicker than CF will. The real benefits are in eliminating some database activity (and database traffic) as well as being able to perform database operations not possible with straight database calls. --- Ben -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:19 PM To: CF-Talk Subject: cached queries vs. structures was(Re: ...BETA...!! (query a query)) I'd like to see some statistics on cached queries vs. querying a structure. It seems like using a cached query would have better performance if memory were unlimited, but at some point the amount of memory used to store the cached queries is going to bog down the server. I've got to imagine that the two methods have differing performance curves and at some point they are going to intersect. Cached queries will be faster up until the intersection but beyond that, structures would be faster. I would just be much happier about the implementation if I could query a query. Then I could avoid having to decide which other method is the worst in this case. At 10:31 AM 2/2/01 -0800, you wrote: >I think this example illustrates one use of query of a query is when the >cached queries contain de-normalized data. This is the same conclusion I >came to when I cached a database in RAM in a Structure and wrote queries >against the data in the Structure (which I later abandoned for cached >queries, which were faster than the Structure approach). > >best, paul > > >At 11:45 AM 2/2/01 -0600, you wrote: > >We have cached queries that hold information that is used on every page hit > >of the site. Every page returns a random record from the cached record set. > >Now, each of these records have links to products, and each record has > >several products associated with it. Ordinarily, the first link is > >displayed. However, in one section of the site, all of the products are > >displayed (sometimes these are recipe ingredients so let's assume that's > >the case). Below the section that lists the products is a section that has > >links to all recipes that contain that product. > > > >Now then (what does that phrase mean anyway?), I have cached queries that > >contain the recipes and the associated products but the query is run on the > >recipe id. However, to get the list of all recipes that contain a specified > >product, I'd have to use a significantly different query but one that > >contains all of the same fields, joined in a similar way. The only thing > >that changes is the search criteria: you are either searching by recipe id > >or you are searching by product id. In both cases, a lot of the same > >information is returned. > > > >Right now, this sucks. > > > >However, if I could load in a query of all recipe ids joined on the product > >ids and another list of the copy for the recipes joined on their recipe id > >(including the first product id), I could do this instead: > >1) display the copy linked to the recipe id where that needs to happen > >(every page of the site) by outputting a random record from the copy/recipe > >id set > >2) generate the list of ingredients by querying the recipe id/product id > >list for that recipe id > >3) generate the list of recipes by querying the recipe id/product id list > >for the product id > > > >That means that instead of caching 100 recipe id/product id queries plus > >500 product id/recipe id queries (or hitting the db every time or loading > >the records into a structure), I could cache 2 queries and query them as > >appropriate. It would be much simpler and would save resources lost to all > >other methods. > > > >Ding ding ding! Now announcing my newly updated website http://www.blivit.org/mr_urc/index.cfm Resume: http://www.blivit.org/mr_urc/resume.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
[OT] Test - please ignore
Test ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Brain Fart
Heath -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:03 PM To: CF-Talk Subject: OT: Brain Fart I am having a challenge trying to envision a solution to the following: Wherever I have a textarea field in my insert statement I strip commas and returns in this fashion: '#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#', Is there a way to check the number of characters that was entered when the form was submitted? I need to limit it to 255 - I have a specific group entering war and peace in this field and upon insert it is causing problems down the line when a data team member (internal) tries to download the form submissions out of the database for processing. Any thoughts, suggestions, ideas? Tony Gruen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Brain Fart
len(form.specialrequest) returns the number of characters. If you want to automatically chop off at 255 rather than letting them re-enter, then you'll want to use the Mid() function as well. What would be very nice (and I'd love to see an example from someone who already knows how), would be to use JavaScript to alert and hopefully stop the user when they've typed in characer 256. Patricia Lee Cold Fusion Developer & Instructor, ACCD Fig Leaf Software "We've Got you Covered" [EMAIL PROTECTED]202.797.5426 |-Original Message- |From: Tony Gruen [mailto:[EMAIL PROTECTED]] |Sent: Friday, February 02, 2001 2:03 PM |To: CF-Talk |Subject: OT: Brain Fart | | |I am having a challenge trying to envision a solution to the following: | |Wherever I have a textarea field in my insert statement I |strip commas and |returns in this fashion: | |'#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#', | |Is there a way to check the number of characters that was |entered when the |form was submitted? I need to limit it to 255 - I have a specific group |entering war and peace in this field and upon insert it is |causing problems |down the line when a data team member (internal) tries to |download the form |submissions out of the database for processing. | |Any thoughts, suggestions, ideas? | |Tony Gruen | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Shopping Malls in CF
Is there anyone here doing a Shopping Mall application? If so how are you handling collections, shipping, taxes when people buy things from different stores in the mall and check everything out in one cart and then try to ship it multiple locations? TIA, Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Brain Fart
I am having a challenge trying to envision a solution to the following: Wherever I have a textarea field in my insert statement I strip commas and returns in this fashion: '#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#', Is there a way to check the number of characters that was entered when the form was submitted? I need to limit it to 255 - I have a specific group entering war and peace in this field and upon insert it is causing problems down the line when a data team member (internal) tries to download the form submissions out of the database for processing. Any thoughts, suggestions, ideas? Tony Gruen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cached queries vs. structures was(Re: ...BETA...!! (query a query))
I'd like to see some statistics on cached queries vs. querying a structure. It seems like using a cached query would have better performance if memory were unlimited, but at some point the amount of memory used to store the cached queries is going to bog down the server. I've got to imagine that the two methods have differing performance curves and at some point they are going to intersect. Cached queries will be faster up until the intersection but beyond that, structures would be faster. I would just be much happier about the implementation if I could query a query. Then I could avoid having to decide which other method is the worst in this case. At 10:31 AM 2/2/01 -0800, you wrote: >I think this example illustrates one use of query of a query is when the >cached queries contain de-normalized data. This is the same conclusion I >came to when I cached a database in RAM in a Structure and wrote queries >against the data in the Structure (which I later abandoned for cached >queries, which were faster than the Structure approach). > >best, paul > > >At 11:45 AM 2/2/01 -0600, you wrote: > >We have cached queries that hold information that is used on every page hit > >of the site. Every page returns a random record from the cached record set. > >Now, each of these records have links to products, and each record has > >several products associated with it. Ordinarily, the first link is > >displayed. However, in one section of the site, all of the products are > >displayed (sometimes these are recipe ingredients so let's assume that's > >the case). Below the section that lists the products is a section that has > >links to all recipes that contain that product. > > > >Now then (what does that phrase mean anyway?), I have cached queries that > >contain the recipes and the associated products but the query is run on the > >recipe id. However, to get the list of all recipes that contain a specified > >product, I'd have to use a significantly different query but one that > >contains all of the same fields, joined in a similar way. The only thing > >that changes is the search criteria: you are either searching by recipe id > >or you are searching by product id. In both cases, a lot of the same > >information is returned. > > > >Right now, this sucks. > > > >However, if I could load in a query of all recipe ids joined on the product > >ids and another list of the copy for the recipes joined on their recipe id > >(including the first product id), I could do this instead: > >1) display the copy linked to the recipe id where that needs to happen > >(every page of the site) by outputting a random record from the copy/recipe > >id set > >2) generate the list of ingredients by querying the recipe id/product id > >list for that recipe id > >3) generate the list of recipes by querying the recipe id/product id list > >for the product id > > > >That means that instead of caching 100 recipe id/product id queries plus > >500 product id/recipe id queries (or hitting the db every time or loading > >the records into a structure), I could cache 2 queries and query them as > >appropriate. It would be much simpler and would save resources lost to all > >other methods. > > > >Ding ding ding! Now announcing my newly updated website http://www.blivit.org/mr_urc/index.cfm Resume: http://www.blivit.org/mr_urc/resume.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
> Yeah, I'd like to see them add a limit. Kind of like the 100 limit > for Cached queries, but let you add a limit in KB. It doesn't do much Just to let you know CF 4.5 does not have a query cache limit. --=@ greg @=-- - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 1:41 PM Subject: Re: The BETA IS OUT!!! (query a query) > On 2/2/01, Jim McAtee penned: > >Do we even know if this feature will allow you to query persistant queries > >(can it use a cached query?) or only queries from the current request? In > >CF currently, the query is in memory anyway, so adding the ability to run a > >query against it shouldn't really exact addtional memory requirements. > >Sounds like it could be an enormous memory hog if used as above. > > Yeah, I'd like to see them add a limit. Kind of like the 100 limit > for Cached queries, but let you add a limit in KB. It doesn't do much > good if you limit cached queries to 100 and then cache 5 MB queries > on a server with 512 KB of RAM. Granted, those would be some bitchin' > queries, but with the "query a query" option, I can see people > storing some mighty large ones. > > Sounds like a way cool thing, but will probably end up being a little > more problematic in a shared environment where the likelihood of > taxing the resources would be higher. > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Administrator not restarting itself???? Sending again, can ANY ONE HELP?
Yes to both. > -Original Message- > From: Dave Watts [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 12:27 PM > To: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > Subject: RE: CF Administrator not restarting itself Sending > again, can ANY ONE HELP? > > > From what i have read and have been told if you set the setting > > for RESTART at (HOWEVER MANY) unresponsive requests, > > then Cold Fusion Administrator is SUPPOSED To restart itself, > > after that many requests. We have NEVER had CF restart itself. > > We always have to do it manually. Any reason why this wouldn't work? > > It's an NT Server, running IIS. Any help or suggestion would be > > appreciated. > > Do you have the CF Executive service running? Do you also have the > "Timeout > requests after n seconds" option turned on (found on the "Settings" page > in > CF Administrator)? I think you need to have both on. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
There never was an upper limit of 100. CF Admin notwithstanding. best, paul At 01:41 PM 2/2/01 -0500, you wrote: >Yeah, I'd like to see them add a limit. Kind of like the 100 limit >for Cached queries, but let you add a limit in KB. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query problem
Will, Are you using access? ID is a reserved word, I think. So, number one would be to change the name of your field in the table. Also, is ID in members the same as id in fields? If so, you can do something like this: SELECTm.email, m.id FROMmembers m, main_details d WHERE(d.body LIKE '%m.watch1%' ORd.body LIKE '%m.watch2%' ORd.body LIKE '%m.watch3%') ANDd.id = m.id Make sense? -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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Request Scope
> Is any one out there using the request variables extensively? > > I'd like to know more about the request scope and how to use it. > I've found > very little in my documentation (4.0.1) and have searched the > allaire knowledge > base with no obvious results (a lot comes up but the titles lead > me to believe > they were not pertinent). I've heard that using request scope > variables can > help limit the "need" for session and/or application variables so that the > necessity of locking is minimized and in some cases eliminated. > I also admit > that I could have heard this out of context. > > Any clarification and information would be appreciated. The biggest use for the Request scope I have found is for using variables in the main template and in CF_ tags or CFModule calls Anything in the Request scope is visible from any CF code on the same template Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
On 2/2/01, Jim McAtee penned: >Do we even know if this feature will allow you to query persistant queries >(can it use a cached query?) or only queries from the current request? In >CF currently, the query is in memory anyway, so adding the ability to run a >query against it shouldn't really exact addtional memory requirements. >Sounds like it could be an enormous memory hog if used as above. Yeah, I'd like to see them add a limit. Kind of like the 100 limit for Cached queries, but let you add a limit in KB. It doesn't do much good if you limit cached queries to 100 and then cache 5 MB queries on a server with 512 KB of RAM. Granted, those would be some bitchin' queries, but with the "query a query" option, I can see people storing some mighty large ones. Sounds like a way cool thing, but will probably end up being a little more problematic in a shared environment where the likelihood of taxing the resources would be higher. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I caputure "onClick" event in Javascript when uisng type="image" in input tag on Netscape?
> How do I capture "onClick" event in JavaScript when using type="image" in > input tag on Netscape? > > Netscape doesn't support onClick on images, you'll have to put an A HREF around it and use Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: RE: Request Scope
Carol, Your first example is correct. With CF 4.0 and up, the application and session scopes are ColdFusion structures (as are most other scopes). Structures organize data in a sort of hierarchy using name-value pairs. Structures can contain any other variable type, including other structures. The duplicate() function takes any variable and makes a copy of it into another variable name. This is why you can duplicate() the entire session scope. It will take the session scope (a structure) and copy all variables under it. It will dig down and get any nested structures, arrays, and queries as well. CAUTION: When using the duplicate() function on large queries, CF server may crash. It can cause very low-level errors (C code errors). Sometimes the only way to get CF working again is to do a complete reboot of the machine. This is not a problem when working with small queries. Complex data types can be tough to grasp at first. You can get a visual representation of them using a custom tag that outputs a representation of the data. It's available on the Developer Exchange by searching for "dump". It's the cf_dump tag. I've never used this version of it, but Spectra has a tag that does the same thing (the DevEx version is probably copied from Spectra, but I'm not sure), and it's a very useful utility. You can input any variable name and it will show you what's contained in it. In Spectra the variable types are color-coded: blue/purple = structure, red = query, green = array, black border = WDDX string. Hopefully this DevEx tag will use a similar color-coding scheme. Oh, and to answer the question about referring to request variables, something like this would work: #request.ses.sessionTimeout# #request.app.applicationName# #request.ses.userProfile.username# #request.app.aApplicationIDs[2]# OR: etc. HTH, Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com > -Original Message- > From: Carol Bluestein [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 12:20 PM > To: CF-Talk > Subject: Re:RE: RE: Request Scope > > > Jason, > Thank you. Thank you. Thank you. > That makes so much more sense. > > May I trouble you one more time for the code, and I'm sure this > is showing some > kind of difficulty on my part understanding complex structures: > > Do I set this code for EACH session and application variable or > does the code > cover all session/application variables ? > > > OR > > > > > > Depending on the above, how do I reference the request variable in a code? > > Thanks again, > Carol > > > This will make like so much easier. > > > > > > Carol L. Bluestein > Senior Programmer > NYS Office of Real Property > 518-486-6335 > [EMAIL PROTECTED] > > > Reply Separator > Subject:RE: RE: Request Scope > Author: [EMAIL PROTECTED] > Date: 2/2/01 11:30 AM > > Spectra uses the request scope extensively. It's a good place to put > thread-safe global variables. What you've heard about eliminating the need > for session, and application locks is true. You can copy all your session > and application variables to the request scope and not need to use CFLOCK > around each call to these variables. > > You would do something like this: > > > > > This code would go in your application.cfm file so those variables get > copied every time someone requests a page. > > You CANNOT use: > > > > > In most languages, including ColdFusion, when you set a variable > equal to a > complex data set (like a structure, query, array, etc.), it will create a > reference back to the complex data set. In other words, it's just > creating a > pointer to the original data in the session or application scope, > so you're > still not thread safe. > > Using the duplicate() function will make a complete copy of those > structures > (the session and application scopes are ColdFusion structures) into the > request scope and you will be accessing the copied data, not the original > data in in the shared scope. > > HTH, > > Jason > > > Jason Aden > Allaire Certified Developer > [EMAIL PROTECTED] > www.wwstudios.com > > > -Original Message- > > From: Carol Bluestein [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 02, 2001 10:25 AM > > To: CF-Talk > > Subject: Re:RE: Request Scope > > > > > > Is any one out there using the request variables extensively? > > > > I'd like to know more about the request scope and how to use it. > > I've found > > very little in my documentation (4.0.1) and have searched the > > allaire knowledge > > base with no obvious results (a lot comes up but the titles lead > > me to believe > > they were not pertinent). I've heard that using request scope > > variables can > > help limit the "need" for session and/or application variables > so that the > > necessity of locking is minimized and in some cases eliminated. > > I al
Re: How do I caputure "onClick" event in Javascript when uisng type="image" in input tag on Netscape?
The onclick does not work as you'd expect when using form elements in netscape. What you can do is wrap a around it. Then call the onclick in it. At 12:54 PM 2/2/2001 -0800, you wrote: >How do I capture "onClick" event in JavaScript when using type="image" in >input tag on Netscape? > > >Thanks Mike > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
I think this example illustrates one use of query of a query is when the cached queries contain de-normalized data. This is the same conclusion I came to when I cached a database in RAM in a Structure and wrote queries against the data in the Structure (which I later abandoned for cached queries, which were faster than the Structure approach). best, paul At 11:45 AM 2/2/01 -0600, you wrote: >We have cached queries that hold information that is used on every page hit >of the site. Every page returns a random record from the cached record set. >Now, each of these records have links to products, and each record has >several products associated with it. Ordinarily, the first link is >displayed. However, in one section of the site, all of the products are >displayed (sometimes these are recipe ingredients so let's assume that's >the case). Below the section that lists the products is a section that has >links to all recipes that contain that product. > >Now then (what does that phrase mean anyway?), I have cached queries that >contain the recipes and the associated products but the query is run on the >recipe id. However, to get the list of all recipes that contain a specified >product, I'd have to use a significantly different query but one that >contains all of the same fields, joined in a similar way. The only thing >that changes is the search criteria: you are either searching by recipe id >or you are searching by product id. In both cases, a lot of the same >information is returned. > >Right now, this sucks. > >However, if I could load in a query of all recipe ids joined on the product >ids and another list of the copy for the recipes joined on their recipe id >(including the first product id), I could do this instead: >1) display the copy linked to the recipe id where that needs to happen >(every page of the site) by outputting a random record from the copy/recipe >id set >2) generate the list of ingredients by querying the recipe id/product id >list for that recipe id >3) generate the list of recipes by querying the recipe id/product id list >for the product id > >That means that instead of caching 100 recipe id/product id queries plus >500 product id/recipe id queries (or hitting the db every time or loading >the records into a structure), I could cache 2 queries and query them as >appropriate. It would be much simpler and would save resources lost to all >other methods. > >Ding ding ding! > >At 03:09 PM 2/1/01 -0800, you wrote: > >I haven't thought of a kickass problem/solution that would need query a > >query ability so I'm happy that's it is there to use but not, stoked, at > >least not yet. =) > > > >Have not tested or even had the priv to touch 5.0 yet but isn't just query a > >query just a search option? So we can do a search for array values, structs, > >and now arrays which are in a way structs. Hmm..actually, I have yet to use > >structfind() with queries so I wouldn't know if that works already. > > > >Maybe with query a query you can isolate a range of records that fits a new > >condition on a existing query? but wouldn't that be a waste of ram and sql > >power to return a large query in the first place that you need to do sub > >queries on? > > > >Basically, I'm trying to find a good problem that would really need the > >feature and would speed up the performance while not wasting resources. > > > >Xing > > > > > > > So who's stoked about the Query a Query ability? Pretty damn cool eh? > > > > > > Michael Buffington > > > [EMAIL PROTECTED] > > > (714) 556-3890 x222 > > > http://www.price.com > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
poll system
Hello, I need a voting/poll system for a internet site. I tried to use CF_iPoll v1.0 but I can't get it to work. Somehow its starts everytime the index.cfm which doens't exist. If I rename the polladmin.cfm to index.cfm then I get the admin only and it doesn't do anything. Who knows a good working poll system? greetings, Michel Goulmy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS and ISA on same server
That's a tough question. My first response would be that you should let someone with a little more security experience help you, or do it for you. The reason being, your one man company, to a large degree, relies on the stability and availability of the services that you provide. Adding to the complexity, each one of the services that you mentioned also have their own unique security requirements. If you are going to do it alone for now, you may be best served by starting with a caching proxy server that supports Network Address Translation (NAT). The market leaders in this field also provide a decent firewall component. It's not the same as running Firewall-1/Raptor/Gauntlet/etc. but, it should serve you nicely without overwhelming you. This will also allow you to use a private non-routable address space, like 192.168.0.0, to mask your backend machines, while providing a transparent mapping of services to internal IP and caching content to accelerate access to web content. Both of the following products are very good and should do everything that you mentioned. I still strongly recommend that, if you use such a product, you install it on a separate computer. Pay attention to the hardware requirements too. For instance, most people aren't used to having to install two network cards on one computer. WinRoute Pro: http://www.tinysoftware.com/winpro.php WinProxy: http://www.ositis.com/english/home/hm_smbs_home_en.asp As an added piece of advice, be careful if/when posting questions about security problems or detailing your security infrastructure. Security help/faq newsgroups and listservs are often perused by people looking for easy targets or who are casing a particular company/site. Be sure to mask real passwords, ports, IP addresses, etc. if you ever post details of your infrastructure. In moments of pressure caused by a non-working application it's easy to forget about security and post questions like, "My shopping cart security isn't working and people can get stuff for free! How can I stop this?" (signed [EMAIL PROTECTED]) Any nefarious sort, and some idly curious, will quickly go to "www.my_e_company.com/" and order all your inventory for free! This sort of thing happens more often than you'd think. Good luck, I hope this helps, Steve -Original Message- From: Scott Brader [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 11:15 AM To: [EMAIL PROTECTED] Subject: RE: IIS and ISA on same server Steve, Thanks for your response. At this point, the company is just me, so the load is really not going to be too high. I appreciate your input on separating the firewall functionality out, though. Do you have any recommendations of a SOHO firewall solution that would allow me to run my own mail/web server inside and allow me to access the Internet. I'm sorry to sound so ignorant, but I'm a developer not a networking expert. I appreciate any insight you can provide. Thanks, Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 Amateurs practice until they get it right, Experts practice until they can't get it wrong. -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 9:57 AM To: CF-Talk Subject: RE: IIS and ISA on same server The first thing that I will say, and this can't be stressed enough, do not run a firewall on the same box as a web server! Web, email, and application servers have always been problematic with regards to security. Their very nature is to share files, the exact opposite of what you want from a firewall. By building your firewall on top of these other services you immediately undermine the integrity of the tool that is meant to be your protection against attack. One of the most devastating network/host intrusions is the rooting of a firewall. Administrators often trust these boxes implicitly, which is not a good practice. Many networks are built with a single firewall on the outside perimeter to the Internet. The internal network is typically left wide-open, with the belief that the almighty firewall is holding off the marauding hordes. So, if the firewall is hacked, your whole organization is more likely to be at risk. With all of your core services running on one box it makes it much easier to mount a DoS attack against or find another vulnerability. There are many more issues involved, an email is too short a space. As for performance, I think you'd be killing the server. I don't know your current or expected loads for each service but, if you decide to continue down this route I'd really recommend having the full range of services load tested. You will need to be aware of the space requirements for all of the various log files that these services generate. Backups may be problematic with so many files open by users and processes. One application may require speci
RE: Query problem
You need to join the two tables. I'd recommend getting a good book on SQL (my favorite is "The Practical SQL Handbook" by Judith S. Bowman et. al.) You can't join the tables unless you've got a common column to join them on. SELECT m.email, d.body FROM members m, main_detail d WHERE m.ID = d.ID AND m.Watch1 etc Notice that you need the ID field in both tables so that SQL knows which records relate. You also need to include the WHERE m.ID = d.ID or you'll get way too many records! -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 9:34 AM To: CF-Talk Subject: Query problem Hi, I've got a complicated query I need to run involving just 2 tables, to be emailed to customers. One, members, contains user-preferences and details, and the other, main_details, contains content. I'm not sure how to approach this. In members, there are 4 fields - email, watch1, watch2 and watch3. In main_details I'm only concerned with fields ID and body. All I need to do is go through each record in members, and search watch1,2 and 3 in main_details.body (just a basic WHERE body like ...) If any results are returned, I'd then need to grab the ID and email in members, and send them out. Can anyone point me in the right direction? I've tried, tried and failed and failed again and again. Thanks Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ?
> > I don't know about an Allaire SNMP tag, they've traditionally > been very weak > in leveraging system/network management technologies. There are, > however, a > number of very nice COM objects, developed by various companies, that will > accomplish the task. You may even be able to make use of > CFX_TCPClient, it's > free, check the Allaire tag gallery. Actually, fyi, the cfx version is very outdated and buggy. The COM version (at v2.10 as of yesterday) is... more stable. http://www.intrafoundation.com/freeware.html. I would upload it to the Allaire Exchange but... the [ sentence heavily censored ] doesn't work. Can't upload. Can't even log in these days. So I don't bother with it anymore. :) --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do I caputure "onClick" event in Javascript when uisng type="image" in input tag on Netscape?
How do I capture "onClick" event in JavaScript when using type="image" in input tag on Netscape? Thanks Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: studio 4.5.2
Thomas Chiverton wrote: > Lets home Macrollaire will do something about that ! > :likes to thing they'll merge Studio into DreamWeaver as an alternative > 'HTML' source editor :-) Not even as a joke. I can feel an ulcer forming just thinking about it. Stronger integration between the two would be nice and maybe VMTL can move into DreamWeaver instead of writing dialogs in JavaScript but merging the two products would be a disaster. -- Or maybe, more accurately, it's (San Francisco) becoming the place that seems to be the techno-libertarian idea of the good polis: Singapore with better movies. Paulina Borsook in Salon Magazine ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The BETA IS OUT!!!
> > What link was that? The link on the download site is broken... > > No link. It was a figment of Philip's imagination. Chain link fence Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Question about CFFILE permissions
*thunks self in head* read next chapter in the Ben Forta bookthanks! Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: "Christopher Olive, CIO" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 9:15 AM Subject: RE: Question about CFFILE permissions > you could implement Advanced Security and create a "sandbox" for each user. > > chris olive, cio > cresco technologies > [EMAIL PROTECTED] > http://www.crescotech.com > > > > -Original Message- > From: Gregory Harris [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 12:17 PM > To: CF-Talk > Subject: Question about CFFILE permissions > > > Good morning people. I was thinking about Self Serve hosting today when I > got to wondering, how to people who do run serve hosting businesses (aka > Virtualscape, Fusionfx, etc.) prohibit others from using, say CFFILE and > CFDIRECTORY on other User's directories? That could get very messy when > people are hacking into other people's stuff on that same server, any ideas? > > > Gregory Harris > Web Developer > > The Stirling Bridge Group, LLC > *We Engineer Internet Business Solutions* > TEL: (949) 707-1534 FAX: (949) 707-1535 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: studio 4.5.2
Don't you mean Malaria (Macromedia + Allaire=Malaria)? I am also seeing lots of weird stuff with RDS and FTP. My main problems with RDS center around renaming and deleting files via their file management interface. FTP gives me messages all the time about timeouts... Having said that: in spite of any problems I have, I really do love CF Studio. And furthermore, when it works, RDS is simply amazing--what a BIG timesaver. And the improvements in CFS 4.52 where you RIGHT click on a tag and get "select tag" (unless you're right clicking on a style sheet in which case you get a short-cut to Top Style) are really great... Eron -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:15 PM To: CF-Talk Subject: RE: studio 4.5.2 > I just wish Allaire had taken the same attention to detail and > the same > urgency with fixing problems with Studio that they have with > the server products. Lets home Macrollaire will do something about that ! :likes to thing they'll merge Studio into DreamWeaver as an alternative 'HTML' source editor :-) Thomas Chiverton Office: 01565 757 909 Recovered from laptop crash ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Broswer Back clears Form
Yep, they are all SSL pages but a different form same browser also SSL does save the FORM input. Wierd stuff... -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED]] Just a guess but are you using secure pages for these forms? If so, IE by design sometimes does not cache the form contents when the user clicks the back button. Supposedly this is for security purposes. HTH, Stephen > In a form I am using some client side validation as well as server > side, when the user submits a populated form and the server side > validation finds an error (in this case using the CF > formname_required method), then user then clicks the back button the > form is cleared of the user input. Its only happening in a specific > template. Any ideas why this occurs or what to look for? > > Thanks,Adrian > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
We have cached queries that hold information that is used on every page hit of the site. Every page returns a random record from the cached record set. Now, each of these records have links to products, and each record has several products associated with it. Ordinarily, the first link is displayed. However, in one section of the site, all of the products are displayed (sometimes these are recipe ingredients so let's assume that's the case). Below the section that lists the products is a section that has links to all recipes that contain that product. Now then (what does that phrase mean anyway?), I have cached queries that contain the recipes and the associated products but the query is run on the recipe id. However, to get the list of all recipes that contain a specified product, I'd have to use a significantly different query but one that contains all of the same fields, joined in a similar way. The only thing that changes is the search criteria: you are either searching by recipe id or you are searching by product id. In both cases, a lot of the same information is returned. Right now, this sucks. However, if I could load in a query of all recipe ids joined on the product ids and another list of the copy for the recipes joined on their recipe id (including the first product id), I could do this instead: 1) display the copy linked to the recipe id where that needs to happen (every page of the site) by outputting a random record from the copy/recipe id set 2) generate the list of ingredients by querying the recipe id/product id list for that recipe id 3) generate the list of recipes by querying the recipe id/product id list for the product id That means that instead of caching 100 recipe id/product id queries plus 500 product id/recipe id queries (or hitting the db every time or loading the records into a structure), I could cache 2 queries and query them as appropriate. It would be much simpler and would save resources lost to all other methods. Ding ding ding! At 03:09 PM 2/1/01 -0800, you wrote: >I haven't thought of a kickass problem/solution that would need query a >query ability so I'm happy that's it is there to use but not, stoked, at >least not yet. =) > >Have not tested or even had the priv to touch 5.0 yet but isn't just query a >query just a search option? So we can do a search for array values, structs, >and now arrays which are in a way structs. Hmm..actually, I have yet to use >structfind() with queries so I wouldn't know if that works already. > >Maybe with query a query you can isolate a range of records that fits a new >condition on a existing query? but wouldn't that be a waste of ram and sql >power to return a large query in the first place that you need to do sub >queries on? > >Basically, I'm trying to find a good problem that would really need the >feature and would speed up the performance while not wasting resources. > >Xing > > > > So who's stoked about the Query a Query ability? Pretty damn cool eh? > > > > Michael Buffington > > [EMAIL PROTECTED] > > (714) 556-3890 x222 > > http://www.price.com > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query problem
Hi, I've got a complicated query I need to run involving just 2 tables, to be emailed to customers. One, members, contains user-preferences and details, and the other, main_details, contains content. I'm not sure how to approach this. In members, there are 4 fields - email, watch1, watch2 and watch3. In main_details I'm only concerned with fields ID and body. All I need to do is go through each record in members, and search watch1,2 and 3 in main_details.body (just a basic WHERE body like ...) If any results are returned, I'd then need to grab the ID and email in members, and send them out. Can anyone point me in the right direction? I've tried, tried and failed and failed again and again. Thanks Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: are forms cf collections?
> Subject: are forms cf collections? Yes, they're structures in CF 4.5.x. I'm not sure about in 4.0.x. I'd like to note that this kind of question is best answered by testing - you can do this in three lines of code: It's a structure! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:RE: RE: Request Scope
Jason, Thank you. Thank you. Thank you. That makes so much more sense. May I trouble you one more time for the code, and I'm sure this is showing some kind of difficulty on my part understanding complex structures: Do I set this code for EACH session and application variable or does the code cover all session/application variables ? OR Depending on the above, how do I reference the request variable in a code? Thanks again, Carol This will make like so much easier. Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:RE: RE: Request Scope Author: [EMAIL PROTECTED] Date: 2/2/01 11:30 AM Spectra uses the request scope extensively. It's a good place to put thread-safe global variables. What you've heard about eliminating the need for session, and application locks is true. You can copy all your session and application variables to the request scope and not need to use CFLOCK around each call to these variables. You would do something like this: This code would go in your application.cfm file so those variables get copied every time someone requests a page. You CANNOT use: In most languages, including ColdFusion, when you set a variable equal to a complex data set (like a structure, query, array, etc.), it will create a reference back to the complex data set. In other words, it's just creating a pointer to the original data in the session or application scope, so you're still not thread safe. Using the duplicate() function will make a complete copy of those structures (the session and application scopes are ColdFusion structures) into the request scope and you will be accessing the copied data, not the original data in in the shared scope. HTH, Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com > -Original Message- > From: Carol Bluestein [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 10:25 AM > To: CF-Talk > Subject: Re:RE: Request Scope > > > Is any one out there using the request variables extensively? > > I'd like to know more about the request scope and how to use it. > I've found > very little in my documentation (4.0.1) and have searched the > allaire knowledge > base with no obvious results (a lot comes up but the titles lead > me to believe > they were not pertinent). I've heard that using request scope > variables can > help limit the "need" for session and/or application variables so that the > necessity of locking is minimized and in some cases eliminated. > I also admit > that I could have heard this out of context. > > Any clarification and information would be appreciated. > > Thanks, in advance, > Carol > > > Carol L. Bluestein > Senior Programmer > NYS Office of Real Property > 518-486-6335 > [EMAIL PROTECTED] > > > Reply Separator > Subject:RE: Request Scope > Author: [EMAIL PROTECTED] > Date: 2/1/01 8:06 PM > > > The "Request" scope was available in CF 4.0 wasn't it? > > Yup, just tested on our 4.0.1 server and it worked perfectly > > Philip Arnold > Director > Certified ColdFusion Developer > ASP Multimedia Limited > T: +44 (0)20 8680 1133 > > "Websites for the real world" > > ** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > ** > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dates as long ints
Actually the TimeFormat format should be "HHmmss"... my booboo :) - Original Message - From: "Scott Weikert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 10:10 AM Subject: Re: dates as long ints > "hhMMSS")> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Question about CFFILE permissions
you could implement Advanced Security and create a "sandbox" for each user. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:17 PM To: CF-Talk Subject: Question about CFFILE permissions Good morning people. I was thinking about Self Serve hosting today when I got to wondering, how to people who do run serve hosting businesses (aka Virtualscape, Fusionfx, etc.) prohibit others from using, say CFFILE and CFDIRECTORY on other User's directories? That could get very messy when people are hacking into other people's stuff on that same server, any ideas? Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Administrator not restarting itself???? Sending again, can ANY ONE HELP?
> From what i have read and have been told if you set the setting > for RESTART at (HOWEVER MANY) unresponsive requests, > then Cold Fusion Administrator is SUPPOSED To restart itself, > after that many requests. We have NEVER had CF restart itself. > We always have to do it manually. Any reason why this wouldn't work? > It's an NT Server, running IIS. Any help or suggestion would be > appreciated. Do you have the CF Executive service running? Do you also have the "Timeout requests after n seconds" option turned on (found on the "Settings" page in CF Administrator)? I think you need to have both on. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: are forms cf collections?
the FORM scope is a structure in 4.5. is this what you're asking? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Duane Douglas [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:05 PM To: CF-Talk Subject: are forms cf collections? please let me know tia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
directory setup
Hi Everyone: I'm building a web site where a client logs into an account and enters transactions. Once a transaction is entered by a client, the client always has access to that transaction. The client can attach (upload) files to a transaction. I want a client to only see files attached to a transaction that the client can access. I don't want a client to be able to see files they don't have access to. A client is only shown files attached to their own transactions, but I don't want someone sneaking around. my Q is: what is the best way (easy and secure) to setup the directory and name the files? 2 thoughts are: 1. put all the files in the same directory and name them: File.t.xxx.doc where t is the transaction number and xxx is the document number for each file (001, 002, etc.) pros: easy to manage. cons: someone could guess a transaction and document number here that they should not see. 2. setup a separate directory for each client and name them: same as in #1 pros: easy to manage. cons: someone could guess a directory, transaction and document number here that they should not see. any suggestions? tia Sandy Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Request Scope
i tend to user REQUEST variables for things that are "constants" in an application/page. for example, DSNs, Title Text, and other things that tend not to change value over the life of an application. by making them request variables, you can still have the "change them in one place" ability (usually the application.cfm), but you do not have to worry about locking. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Carol Bluestein [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 10:25 AM To: CF-Talk Subject: Re:RE: Request Scope Is any one out there using the request variables extensively? I'd like to know more about the request scope and how to use it. I've found very little in my documentation (4.0.1) and have searched the allaire knowledge base with no obvious results (a lot comes up but the titles lead me to believe they were not pertinent). I've heard that using request scope variables can help limit the "need" for session and/or application variables so that the necessity of locking is minimized and in some cases eliminated. I also admit that I could have heard this out of context. Any clarification and information would be appreciated. Thanks, in advance, Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:RE: Request Scope Author: [EMAIL PROTECTED] Date: 2/1/01 8:06 PM > The "Request" scope was available in CF 4.0 wasn't it? Yup, just tested on our 4.0.1 server and it worked perfectly Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: studio 4.5.2
> I just wish Allaire had taken the same attention to detail and > the same > urgency with fixing problems with Studio that they have with > the server products. Lets home Macrollaire will do something about that ! :likes to thing they'll merge Studio into DreamWeaver as an alternative 'HTML' source editor :-) Thomas Chiverton Office: 01565 757 909 Recovered from laptop crash ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
> > Do you have an need to worry about current data? Because if you hold that > > large data set too long how long is it before it becomes outdated and > > invalid? or does it stay static? > > Simple answer: If that's true for your app, don't use this feature. OR... > every time you update the info in the DB, update your query object in RAM > too. > > Here's another example of how it could be helpful: > > Allaire's Support Forums, everyone's used this right? What if the search > results were stored in a query object which you could re-order by date, > author, subject, at will without making a round trip to the DB. You could > also do the "Get next 10 records" without going back to the db. Depending > on how much ram you have on your machine and how many users are on it, you > could probably browse the full message bodies without a round trip too. > > -Cameron Do we even know if this feature will allow you to query persistant queries (can it use a cached query?) or only queries from the current request? In CF currently, the query is in memory anyway, so adding the ability to run a query against it shouldn't really exact addtional memory requirements. Sounds like it could be an enormous memory hog if used as above. Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dates as long ints
Well... years have four digits... months, days, hours, minutes, seconds two digits... just make sure you use leading zeros... Give this a shot... I'm just making this up as I go :) Note the lack of "/"s and ":"s in the date/time format tags - just extract the raw digits... - Original Message - From: "j p" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 10:02 AM Subject: Re: dates as long ints > Thanks scott, but that doesn't answer the question of HOW to cast a date or > date/time value into the interget format. It has been discussed here before > - and that is the information I'm looking for. > > thanks again for your input. > > jp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
