Re: CFM based page with a lookup button not being seen in my wireless palm III
Boris, I guess that you got it working. One minor comment: when validating the form, don't report only the first missing field. Report all of the missing fields, so that the user can correct all omissions at once. -David YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
usage
Which of these would be faster? It's much easier to slap a at the beginning of the block, but i remember reading that with a cfoutput, the cf server must "inspect" each <> to see if it's CF code. On the other hand, it removes the need to switch between CF and HTML "mode". Am I making any sense? Name #dbquery.name# Address #dbquery.address# . for a few more db fields OR Name #dbquery.name# for the rest of the fields Mike Chiu [EMAIL PROTECTED] http://yoyoman.insync.net "No one who believes in him will be put to shame." (Romans 10:11) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Another speed issue
I know that for displaying the output of a dbquery with multiple rows, I have to write However, if I know that it's only going to have one record, works just fine. Would there be any reason why it'd be beneficial to use in this one record case? Mike Chiu [EMAIL PROTECTED] http://yoyoman.insync.net "No one who believes in him will be put to shame." (Romans 10:11) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: usage
On 8/6/00, Michael Chiu penned: >Which of these would be faster? It's much easier to slap a at >the beginning of the block, but i remember reading that with a cfoutput, >the cf server must "inspect" each <> to see if it's CF code. On the other >hand, it removes the need to switch between CF and HTML "mode". Although I've read (on this list) that the larger the block of code inside cfoutputs, the more evaluation ColdFusion has to do, personal testing has shown absolutely no difference in the execution time of the page. Yet, I generally wrap only the necessary code anyway. CF has to execute all CF tags no matter if they're inside a cfoutput or not. Now, whether it inspects everything inside of <> or simply looks for http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF-Cluster with different OS ?
Is it possible to cluster an NT based CF (one machine) with a Linux based CF (another machine) ? Uwe -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Afraid of long CFOUTPUT...
> Before I go ahead with at the top of the page and > at the bottom of the page and a whole 'lotta page > in between... > > I am afraid that running some other CF tags inside a CFOUTPUT > might cause trouble. Is there *anything* that might get hurt by being > inside a CFOUTPUT? All other CF tags will function regardless of it they are wrapped in a CFOUTPUT or not. However, there are three reasons why I would recommend you NOT do this: 1) Wrapping the whole page in a CFOUTPUT puts a greater load on CF. From a performance standpoint you are better off using multiple CFOUTPUT blocks around small bits of code. 2) If you have any explicit color definitions (like ), CF will error out because of the '#' character. To get around this you need to double up the hash mark (like ). However, if down the road you remove the CFOUTPUT then your color codes will be incorrect again. 3) Finally, it just seems like better programming practice to only CFOUTPUT blocks of code with variables in them. If your whole page is data driven, then one big CFOUTPUT might make sense. However, if only one section of the page actually uses any variables, then only wrap that one section in the CFOUTPUT. It will make code maintenance much easier. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with updating a database
Hi! I did something exactly like this for a project recently. In my case it was a list of employees, each employee belonging to a certain department. There was a Search Function where the person could search by Employee ID, Employee Name, or by Department. Searching by Department of course produced a list of employees for editing. The user could then click a checkbox next to the employees they actually wished to edit, whcih then launched them into an Edit page. This edit page contains a single form, with each Employee (in you're case product) in its own row for editing, with one submit button at the end of them all. What I did was make the employee ID part of the control name, as someone has already pointed out to you. That gets around the problem of each box having the same id. Then to update and insert the data, you have to use a CFQUERY with an SQL INSERT INTO statement or an UPDATE statement with a CFLOOP. I can't recall the exact code now, but on Monday I can surely send it to you, and post to the list. This is exactly the code you are looking for. This list is an invaluable resource, as I got tons of help here whilst doing that project :-) Please send me an email on monday asking for the files, as I am a bit absent minded and working toward yet another deadline, and will quite possibly forget to send them. ;-P -Gel - Original Message - From: Chris Farrugia <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> > Good day, > > I am creating the site for my computer store, where a user will be able to > custom configure a new PC. Currently I am stuck creating an administration > page where I can update the prices in my database. The table has fields > (ProductID, CategoryID (Hard Drive, Motherboard, etc), Description, Price, > Weight). I want on the admin page for there to be all of the products > listed in form text boxes. If I want to edit one, I can change the content > of that text box and then hit the submit button and it edits the database. > The problem I'm running into is that I can't name the form fields the same > thing because then it won't know which to edit... Can anybody explain how I > would do this? I am very new to coldfusion. Thank you for the help. > > Sincerely, > Chris Farrugia -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help with updating a database
That would be a huge help. I've been stuck on this for about 3 days now... I'm new to coldfusion and just do not understand how it is done. Thank you very much for the help! -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 06, 2000 9:50 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Help with updating a database Hi! I did something exactly like this for a project recently. In my case it was a list of employees, each employee belonging to a certain department. There was a Search Function where the person could search by Employee ID, Employee Name, or by Department. Searching by Department of course produced a list of employees for editing. The user could then click a checkbox next to the employees they actually wished to edit, whcih then launched them into an Edit page. This edit page contains a single form, with each Employee (in you're case product) in its own row for editing, with one submit button at the end of them all. What I did was make the employee ID part of the control name, as someone has already pointed out to you. That gets around the problem of each box having the same id. Then to update and insert the data, you have to use a CFQUERY with an SQL INSERT INTO statement or an UPDATE statement with a CFLOOP. I can't recall the exact code now, but on Monday I can surely send it to you, and post to the list. This is exactly the code you are looking for. This list is an invaluable resource, as I got tons of help here whilst doing that project :-) Please send me an email on monday asking for the files, as I am a bit absent minded and working toward yet another deadline, and will quite possibly forget to send them. ;-P -Gel - Original Message - From: Chris Farrugia <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> > Good day, > > I am creating the site for my computer store, where a user will be able to > custom configure a new PC. Currently I am stuck creating an administration > page where I can update the prices in my database. The table has fields > (ProductID, CategoryID (Hard Drive, Motherboard, etc), Description, Price, > Weight). I want on the admin page for there to be all of the products > listed in form text boxes. If I want to edit one, I can change the content > of that text box and then hit the submit button and it edits the database. > The problem I'm running into is that I can't name the form fields the same > thing because then it won't know which to edit... Can anybody explain how I > would do this? I am very new to coldfusion. Thank you for the help. > > Sincerely, > Chris Farrugia -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help with updating a database
Well, I don't think I really explained it clearly... There are about 20 categories of product, each containing about 20 products (at the most). So the first screen they see is a pulldown for the category. The second page, once the category is submitted, contains those 20 products for editing. That part I can do... its actually changing the database that I can not. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 06, 2000 12:32 AM To: [EMAIL PROTECTED] Subject: Re: Help with updating a database Chris If I understand, what you propose to do is to update all your products with a single page/form. This may be practical for a very small product line (say 10-20 products), As your product line grows you will continuously need to update your page & program... and performance will get worse and worse. Consider what your program will be for, say, 100 or 1,000 products. At that time you will probably have someone else (less qualified/familiar with your system) doing the updates. It could take minutes just to load the page! It could become an impediment to updating your product database & thus have a negative affect on sales. In the long, run you would be better off with: some sort of product search to drill-down to the specific single product you wish to update. an update page/form that deals with only one product at a time. Most commonly this is done with a search frame for the drill-down, and an update frame for the selected product. It is simple, straight forward, fast and will work, unchanged for tens or millions of products. HTH Dick At 11:39 PM -0400 8/5/00, Chris Farrugia wrote: >Good day, > >I am creating the site for my computer store, where a user will be able to >custom configure a new PC. Currently I am stuck creating an administration >page where I can update the prices in my database. The table has fields >(ProductID, CategoryID (Hard Drive, Motherboard, etc), Description, Price, >Weight). I want on the admin page for there to be all of the products >listed in form text boxes. If I want to edit one, I can change the content >of that text box and then hit the submit button and it edits the database. >The problem I'm running into is that I can't name the form fields the same >thing because then it won't know which to edit... Can anybody explain how I >would do this? I am very new to coldfusion. Thank you for the help. > >Sincerely, >Chris Farrugia > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with updating a database
On 8/5/00, Chris Farrugia penned: >Good day, > >I am creating the site for my computer store, where a user will be able to >custom configure a new PC. Currently I am stuck creating an administration >page where I can update the prices in my database. The table has fields >(ProductID, CategoryID (Hard Drive, Motherboard, etc), Description, Price, >Weight). I want on the admin page for there to be all of the products >listed in form text boxes. If I want to edit one, I can change the content >of that text box and then hit the submit button and it edits the database. >The problem I'm running into is that I can't name the form fields the same >thing because then it won't know which to edit... Can anybody explain how I >would do this? I am very new to coldfusion. Thank you for the help. > >Sincerely, >Chris Farrugia I'm not sure if I'm reading this right, but are you trying to show all the fields for all the products on one page? If so, every time you edit something ColdFusion will have to update every field of every product. You are much better off having a page listing all of the products in a select menu, choosing the product you want to edit and then showing the update form for that product only. At this point you simply have a hidden form field and then pass that along to the update query with the rest of the form fields. Then you only have to update the fields for that product rather than updating every field for every product even if you're only changing one field. UPDATE Products SET Hard Drive = '#Form.HardDrive#', Motherboard = '#Form.Motherboard#', Description = '#Form.Description#', Price = #Form.Price#, Weight = #Form.Weight# WHERE ProductID = #Form.ProductID# -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help with updating a database
On 8/6/00, Chris Farrugia penned: >Well, I don't think I really explained it clearly... There are about 20 >categories of product, each containing about 20 products (at the most). So >the first screen they see is a pulldown for the category. The second page, >once the category is submitted, contains those 20 products for editing. >That part I can do... its actually changing the database that I can not. Again. Update one record at a time. Do a select query on the categories and products and group the output by category showing all the products under each category in it's own select menu. Go here for an example: http://www.twcreations.net/ezcart/admin/ Login: test password: test Click on Edit Products when you get in. If you need a hand with the code, I'll be glad to help. It's really easy actually. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Buffer Overload
> I hope you don't count the web server as another "major" program :-) No, which is a good thing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: designing error message pages
> I am wondering how I go about designing my own error message > pages so that when a cf error occurs the system outputs my pre > designed page to the user rather than it displaying a cf server > generated message which is totally meaningless to the person > viewing the internet site. You have several alternatives if you're using CF 4.5.1: 1. Site-wide error handling (new to CF 4.5.x) You can specify a single page to which any unhandled error will be redirected. Within that page, you can put whatever CFML you want. You specify the page location in CF Administrator. 2. The CFERROR tag (since CF 1.x) You can put a CFERROR tag with the TYPE="REQUEST" attribute on each page for which you want to redirect errors. Typically, you'd do this in application.cfm, of course. The page to which you redirect can't have any CFML in it, other than the error variables themselves (which are listed in the documentation). The site-wide error handler will override this, as this is the most primitive and limited error response. 3. The CFERROR tag with TYPE="EXCEPTION" (new to CF 4.5.x) You can redirect unhandled exceptions to a specific page, which can have any CFML code in it that you want, including CFCATCH variables. This is a pretty nifty option. 4. Exception handling with CFTRY and CFCATCH (new to CF 4.0.x) You can wrap specific problem code blocks within exception handlers to TRY the code and CATCH any exceptions. This is an appropriate thing to do when you have a specific run-time problem with a high likelihood of occurrence, and when there's something you specifically want to do in response to that particular problem. All of these are listed in one place or another within the documentation. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Dynamic Variable Problems
> I am having problems with a setting a dynamic variable. I'm > trying to set TempArray[1].GroupAccess[1] to some value. It > is an array inside a struct, inside an array (whew!) > > I can execute... > > > > ...just fine. But if I try... > > > > > ... I get an error message saying that the variable name is illegal! Keep in mind that the syntax you're using for setting dynamic variables is unsupported; you should probably use the SetVariable function instead - it's a lot less likely to accidentally disappear in future versions of CF. Besides that, though, there's a bigger problem, which would prevent you from using SetVariable in this case as well. That problem is that a member of an array isn't exactly the same as a "variable" from CF's perspective. The array itself is a variable, but if for example you attempt to check for an array member's existence using IsDefined, you'll get an error there as well. Instead, you could do something like this: Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Stored procedures vs other methods
Hello all, I was wondering if it was faster to execute a query in cold fusion as a stored procedure in oracle rather than just executing a query in cold fusion. Any opinions, comments would be welcome. Thanks in advance, Brandon Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Breaking Sessions
On 8/4/00, Erika Foster penned: >I know this has been discussed over and over again, but how do I break off >sessions so that I can FTP a new version of my datasource? > >I've tried breaking the connection with a broken query... its not working. > >Any ideas? That should work. Always does for me. Sometimes I'll have to hit the broken query twice. Make sure you're specifying the right datasource in the broken query. Probably stupid to say, but... -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Afraid of long CFOUTPUT...
There's no easy answer to this. My pages are somewhere in between those two cases. There are many variables (50?) on a page so it would be a mess of #var# text #var# etc... I think that way CF would be burdened by processing many tags. The other war CF would be burdened by scanning for #s. 6 of one, half-dozen of the other... At 10:36 AM 8/6/00 -0400, Seth Petry-Johnson wrote: >> Before I go ahead with at the top of the page and >> at the bottom of the page and a whole 'lotta page >> in between... >> >> I am afraid that running some other CF tags inside a CFOUTPUT >> might cause trouble. Is there *anything* that might get hurt by being >> inside a CFOUTPUT? > >All other CF tags will function regardless of it they are wrapped in a >CFOUTPUT or not. However, there are three reasons why I would recommend you >NOT do this: > >1) Wrapping the whole page in a CFOUTPUT puts a greater load on CF. From a >performance standpoint you are better off using multiple CFOUTPUT blocks >around small bits of code. > >2) If you have any explicit color definitions (like ), >CF will error out because of the '#' character. To get around this you need >to double up the hash mark (like ). However, if down >the road you remove the CFOUTPUT then your color codes will be incorrect >again. > >3) Finally, it just seems like better programming practice to only CFOUTPUT >blocks of code with variables in them. If your whole page is data driven, >then one big CFOUTPUT might make sense. However, if only one section of the >page actually uses any variables, then only wrap that one section in the >CFOUTPUT. It will make code maintenance much easier. > >Regards, >Seth Petry-Johnson >Argo Enterprise and Associates > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Stored procedures vs other methods
> Hello all, > > I was wondering if it was faster to execute a query in cold fusion as a > stored procedure in oracle rather than just executing a query in cold > fusion I have experienced a slightly better performance with stored procedures. Alexander Apartsev just me design [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help finding a shopping cart!
Hi all, Does anyone know of a shopping cart application built in cold fusion that allows purchasing of a whole category, not just individual products? An example would be like the photodisc or eyewire websites, where you can purchase a whole collection or you individual images. TIA Perry -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Mysterious Crashing Problem
Hi Folks, I've been experiencing a problem lately with a ColdFusion 4.5 appliction running on a hosted/shared server. Every now and then (every couple of days) when I go to open a particular page ColdFusion bogs down and eventually hangs altogether. The page in question is a javascript popup window. It does a query with 5 tables joined together to retrieve a pricelist and then displays the list using CFOUTPUT with the GROUP parameter. The only other thing that's "unusual" is that it uses the dollarformat function. I am requesting the logs from our hosting provider and I have asked them to update from MDAC 2.1 to MDAC 2.5. Can anyone think of anything else to try here? Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFLOCK presentation
I have it, it isn't showing 4.5 lock. Now where does it even mention scope in there. Bob Everland -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 11:45 PM To: [EMAIL PROTECTED] Subject: RE: CFLOCK presentation In addition to Jeremy's reference list, I'd also recommend Danesh's new book "Mastering Coldfusion 4.5" too. It has a fairly lucid presentation on using CFLock and also offers a different twist on the rest of CF than Ben's books. Chris Montgomery [EMAIL PROTECTED] Web Development & Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 >-Original Message- >From: Angél Stewart [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 03, 2000 9:04 AM >To: [EMAIL PROTECTED] >Subject: Re: CFLOCK presentation > > It seems I need to do a lot more reading and research. Is there >anything after Ben Forta's books to read on CF?? > >-Gel > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Structs contained within the application scope?
I've started experimenting a bit with using structs in application variables and have noticed something odd, although it may be expected behavior... Say I set up a struct called "test", and then stored it inside an application variable called "application.test". Now I want to copy the entire application scope into a local variable so I can manipulate it without worrying about locking it all over the place: Now, I should be able to now call all the "application.whatever" variables with the syntax "app.whatever". This technique actually works just great with simple values, but not with structs stored in the application scope. When I try to access "app.test", I get the error: "Symbol App.test is in a scope that contains data shared across threads and cannot be accessed without an active lock" (I have Full checking turned on in the CFAdmin), which means that the test struct was not actually copied. Instead, a pointer to the original struct inside the application struct was created. I can get around this problem by manually copying the struct like so (but it's a pain in the rear): So my question is... Shouldn't the StructCopy() function copy the entire struct, and any other structs stored inside it? Has anyone else run into this experience, or is it considered expected behavior when copying structs which contain other structs? Did that make sense? -Cameron Cameron Childress McRae Communications p. 770-460-7277 x.232 f. 770-460-0963 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dave Watts is the man!
I was really worrying about this one :) Thanks! Norman Elton -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 06, 2000 2:16 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Dynamic Variable Problems > I am having problems with a setting a dynamic variable. I'm > trying to set TempArray[1].GroupAccess[1] to some value. It > is an array inside a struct, inside an array (whew!) > > I can execute... > > > > ...just fine. But if I try... > > > > > ... I get an error message saying that the variable name is illegal! Keep in mind that the syntax you're using for setting dynamic variables is unsupported; you should probably use the SetVariable function instead - it's a lot less likely to accidentally disappear in future versions of CF. Besides that, though, there's a bigger problem, which would prevent you from using SetVariable in this case as well. That problem is that a member of an array isn't exactly the same as a "variable" from CF's perspective. The array itself is a variable, but if for example you attempt to check for an array member's existence using IsDefined, you'll get an error there as well. Instead, you could do something like this: Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Security gotchas with dynamic SQL statements?
I'm reasonably sure it would stop them. The only thing I wonder is if there's a bit of SQL they could put in there that would make it go excrutiatingly slow... thoughts? Possibly they could try putting new table names in there to guess how your database is structured. Maybe an array of conditions, where each condition is individually made safe, and then you loop them with ands or ors in between? David Cummins Seth Petry-Johnson wrote: > > > It looks to me like a malicious user could stick damned near anything in > there, > > unfortunately. > > > > If you're only going to put a single condition in there, I reckon the > easiest > > way to solve the problem would be to strip all spaces out of their string. > > No can do, since there is already a situation where I pass in multiple > conditions. > > If I just dropped (or aborted upon the discovery of) the semi color > character, would that effectively prevent users from "chaining" commands > together? I'm not interested in preventing malformed SQL statements (a > CFCATCH block will catch DB errors), I'm just interested in preventing users > from exploiting this system. > > Thanks for the thoughts, > Seth > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Structs contained within the application scope?
> I've started experimenting a bit with using structs in > application variables and have noticed something odd, although > it may be expected behavior... > > Say I set up a struct called "test", and then stored it inside > an application variable called "application.test". Now I want > to copy the entire application scope into a local variable so I > can manipulate it without worrying about locking it all over the > place: > > > > Now, I should be able to now call all the "application.whatever" > variables with the syntax "app.whatever". This technique actually > works just great with simple values, but not with structs stored in > the application scope. When I try to access "app.test", I get the > error: "Symbol App.test is in a scope that contains data shared > across threads and cannot be accessed without an active lock" (I > have Full checking turned on in the CFAdmin), which means that the > test struct was not actually copied. Instead, a pointer to the > original struct inside the application struct was created. > > I can get around this problem by manually copying the struct > like so (but it's a pain in the rear): > > > > So my question is... Shouldn't the StructCopy() function copy the > entire struct, and any other structs stored inside it? Has anyone > else run into this experience, or is it considered expected behavior > when copying structs which contain other structs? This is expected behavior with StructCopy; it only copies "one level deep". If you want to make a complete duplicate, no matter how many nested data containers you have, use the Duplicate function introduced in CF 4.5.1, which makes a "deep copy". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Structs contained within the application scope?
> This is expected behavior with StructCopy; it only copies "one > level deep". > If you want to make a complete duplicate, no matter how many nested data > containers you have, use the Duplicate function introduced in CF 4.5.1, > which makes a "deep copy". Perfect! Solved! Guess I need to re-read the release notes for 4.5.1... Too bad some of those last minute additions don't make it into the cfdocs! -Cameron Cameron Childress McRae Communications p. 770-460-7277 x.232 f. 770-460-0963 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help finding a shopping cart!
On 8/6/00, perry penned: >Hi all, > >Does anyone know of a shopping cart application built in cold fusion that >allows purchasing of a whole category, not just individual products? > >An example would be like the photodisc or eyewire websites, where you can >purchase a whole collection or you individual images. I don't see why you couldn't just take about any program out there and put entire categories in as separate products. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Banner Advertising and Login
1. I'm going to be opening a site very soon that will be selling banner advertising. I've been looking around and am looking for something fairly simple that will let my clients log in and see the status of their banners, etc.. the features everyone needs! :-) I've looked at dreambanner, and fuseads.. I'm not sure which is better.. one is cheaper obviously, dreambanner looks a little easier to use, but fuseads looks more full-featured... what do you guys think? what have you had experience with? which was easier to setup? 2. How do I password protect my database so that only I can read/write data to it? I'm using access 2k baby. Also if I'm storing credit card numbers in it as TEXT, any precautions to take? What are my options for security other then password. thanks and let me know. jigga man jake -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
2 inputs in one column
This is a multi-part message in MIME format. --=_NextPart_000_0079_01BFFFCA.6D6E8720 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello All,=20 =20 I have been researching a way to input a timestamp into the same = position as I input a text note. I know how to generate the timestamp..I = am not clear on how to input 2 items in 1 db cell. It is probably = rather straightforward but I would appreciate a point in the right = direction. Thanks, Mike --=_NextPart_000_0079_01BFFFCA.6D6E8720 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello All, I have been researching a way to input = a timestamp=20 into the same position as I input a text note. I know how to generate = the=20 timestamp..I am not clear on how to input 2 items in 1 db cell. = It is=20 probably rather straightforward but I would appreciate a point in the = right=20 direction. Thanks, Mike --=_NextPart_000_0079_01BFFFCA.6D6E8720-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with updating a database
Well, I have numerous categories such as Hard Drive, MOtherboard, etc. So on the first page, they choose the category they want to edit. If they choose motherboard, it will show them maybe 10 motherboards. Every part of the database is in an input field so they can go through and edit every price. In this industry as you know, prices are changing constantly. It would be so tedious to edit these prices one by one. Thats why I want to do it this way. If I can get a list of 20 CPU's and edit all the prices and click submit, it would really speed up this arduous task. > On 8/5/00, Chris Farrugia penned: > >Good day, > > > >I am creating the site for my computer store, where a user will be able to > >custom configure a new PC. Currently I am stuck creating an administration > >page where I can update the prices in my database. The table has fields > >(ProductID, CategoryID (Hard Drive, Motherboard, etc), Description, Price, > >Weight). I want on the admin page for there to be all of the products > >listed in form text boxes. If I want to edit one, I can change the content > >of that text box and then hit the submit button and it edits the database. > >The problem I'm running into is that I can't name the form fields the same > >thing because then it won't know which to edit... Can anybody explain how I > >would do this? I am very new to coldfusion. Thank you for the help. > > > >Sincerely, > >Chris Farrugia > > I'm not sure if I'm reading this right, but are you trying to show > all the fields for all the products on one page? If so, every time > you edit something ColdFusion will have to update every field of > every product. You are much better off having a page listing all of > the products in a select menu, choosing the product you want to edit > and then showing the update form for that product only. At this point > you simply have a hidden form field name="ProductID" value="#GetProduct.ProductID#"> and then pass that > along to the update query with the rest of the form fields. Then you > only have to update the fields for that product rather than updating > every field for every product even if you're only changing one field. > > > UPDATE Products > SET Hard Drive = '#Form.HardDrive#', > Motherboard = '#Form.Motherboard#', > Description = '#Form.Description#', > Price = #Form.Price#, > Weight = #Form.Weight# > WHERE ProductID = #Form.ProductID# > > > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFLOCK presentation
--=_7257365==_.ALT Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable scope pp 451, 457, 505, 766, 139-141 cflock 4.5 pp 483 At 07:38 AM 7/08/00 , you wrote: >I have it, it isn't showing 4.5 lock. Now where does it even mention scope >in there. > >Bob Everland > >-Original Message- >From: Chris Montgomery [mailto:[EMAIL PROTECTED]] >Sent: Friday, August 04, 2000 11:45 PM >To: [EMAIL PROTECTED] >Subject: RE: CFLOCK presentation > > >In addition to Jeremy's reference list, I'd also recommend Danesh's new >book "Mastering Coldfusion 4.5" too. It has a fairly lucid presentation >on using CFLock and also offers a different twist on the rest of CF than >Ben's books. > >Chris Montgomery [EMAIL PROTECTED] > >Web Development & Consulting http://www.astutia.com >Allaire Consulting Partner >210-490-3249/888-745-7603Fax 210-490-4692 > > >-Original Message- > >From: Ang=E9l Stewart [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, August 03, 2000 9:04 AM > >To: [EMAIL PROTECTED] > >Subject: Re: CFLOCK presentation > > > > > It seems I need to do a lot more reading and research. Is there > >anything after Ben Forta's books to read on CF?? > > > >-Gel > > > >---= - >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_talk= or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > >---= --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit=20 >http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_talk= or=20 >send a message to [EMAIL PROTECTED] with 'unsubscribe' in= =20 >the body. Seamus Campbell BookBusiness - Netinfo www.bookbusiness.com.au [EMAIL PROTECTED] ph 02 6297 4883 fax 02 6297 8464 mob 0416 055 171 In the Book Business? You need BookBusiness!=20 --=_7257365==_.ALT Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable scope pp 451, 457, 505, 766, 139-141 cflock 4.5 pp 483 At 07:38 AM 7/08/00 , you wrote: I have it, it isn't showing 4.5 lock. Now where does it even mention scope in there. Bob Everland -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]"= eudora=3D"autourl">mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 11:45 PM To: [EMAIL PROTECTED] Subject: RE: CFLOCK presentation In addition to Jeremy's reference list, I'd also recommend Danesh's new book "Mastering Coldfusion 4.5" too. It has a fairly lucid presentation on using CFLock and also offers a different twist on the rest of CF than Ben's books. Chris Montgomery = [EMAIL PROTECTED] Web Development & Consulting http://www.astutia.com/"= eudora=3D"autourl">http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603 Fax 210-490-4692 >-Original Message- >From: Ang=E9l Stewart [mailto:[EMAIL PROTECTED]"= eudora=3D"autourl">mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 03, 2000 9:04 AM >To: [EMAIL PROTECTED] >Subject: Re: CFLOCK presentation >> It seems I need to do a lot more reading and research. Is=20 there >anything after Ben Forta's books to read on CF?? > >-Gel > = -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/"= eudora=3D"autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dl= ists/cf_talk" eudora=3D"autourl">http://www.houseoffusion.com/index.cfm?side= bar=3Dlists&body=3Dlists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe'= in the body. = -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/"= eudora=3D"autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dl= ists/cf_talk"= eudora=3D"autourl">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&a= mp;body=3Dlists/cf_talk or send a message to= [EMAIL PROTECTED] with 'unsubscribe' in the body.= Seamus Campbell BookBusiness - Netinfo http://www.bookbusiness.com.au/"= EUDORA=3DAUTOURL>www.bookbusiness.com.au &= nbsp; [EMAIL PROTECTED] ph 02 6297 4883 fax 02 6297 8464 mob 0416= 055 171 In the Book Business? You need BookBusiness! --=_7257365==_.ALT-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=l
Re: 2 inputs in one column
On 8/6/00, penned: >I have been researching a way to input a timestamp into the same = >position as I input a text note. I know how to generate the timestamp..I = >am not clear on how to input 2 items in 1 db cell. It is probably = >rather straightforward but I would appreciate a point in the right = >direction. I always use something like this as a timestamp: As far as inserting, just put two variables in the same the value: INSERT INTO (somefield) VALUES ('#mytimestamp##form.field#') Of course, you can enter the values however you like, not necessarily run together: '#mytimestamp#: #form.field#' '#mytimestamp#-#form.field#' '#mytimestamp#, #form.field#' '#mytimestamp# #form.field#' etc. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with updating a database
From: <[EMAIL PROTECTED]> > Well, I have numerous categories such as Hard Drive, MOtherboard, etc. So > on the first page, they choose the category they want to edit. If they > choose motherboard, it will show them maybe 10 motherboards. Every part of > the database is in an input field so they can go through and edit every > price. In this industry as you know, prices are changing constantly. It > would be so tedious to edit these prices one by one. Thats why I want to > do it this way. If I can get a list of 20 CPU's and edit all the prices > and click submit, it would really speed up this arduous task. > > You don't need to do data updates with a form. Forms that pull up a whole record and are designed to allow editing of any/all fields are fine when the focus of what you are doing needs a whole record display. However, when updating things like price lists I have found that batch processing a change list is easier. Sometimes the changes come prepared in a readable file format so the processing is simple (the ideal situation). What you might consider doing is; 1. produce the changes list - lots of different ways, but make sure each line comprises a key field that uniquely identifies the item that is being updated 2. process the change list as a batch - i.e. read a text file line by line, read a delimited list, query a changes db - whatever format you use in 1. You can update only the fields referenced in the line. While in your particular situation there may be good reasons to do whole record updates, the batch update method has a few virtues: a. it's quicker b. depending on method used to produce the changes list you can retain a statistically useful history c. data entry is simpler in that you don't have to navigate a form and the underlying code should be a lot simpler and easier to maintain d. if your source of new prices is machine readable your effort is much more efficient e. you don't have to do a whole record update - just the fields that actually have changed Hope this stimulates your thinking. Pan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with updating a database
On 8/6/00, [EMAIL PROTECTED] penned: >Well, I have numerous categories such as Hard Drive, MOtherboard, etc. So >on the first page, they choose the category they want to edit. If they >choose motherboard, it will show them maybe 10 motherboards. Every part of >the database is in an input field so they can go through and edit every >price. In this industry as you know, prices are changing constantly. It >would be so tedious to edit these prices one by one. Thats why I want to >do it this way. If I can get a list of 20 CPU's and edit all the prices >and click submit, it would really speed up this arduous task. Oh. :) Well that should be easy also. I would still do a form for editing entire items one by one, but I do understand the price thing. Do this query when you select a category to change prices on: SELECT ProductID, ProductName, Price FROM Categories, Products Where CategoryID = #CategoryID# and Categories.CategoryID = Products.CategoryID Then output your form fields like this, using a hidden input field to pass the product id of each item in the same order. Keep in mind you can't use cfform because it won't allow duplicate field names. #ProductName# Then loop through the form.prices list that's passed adding 1 for every loop to pick up the right ProductID for each price. Be sure you don't pass any commas with your prices if something is over 1,000 or 1,000.00 will become 2 list items, 1 and 000.00. That's why I stripped them out of the form value above. UPDATE products SET Price = #thisprice# WHERE ProductID = #listgetat(form.ProductIDs, row)# HTH -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Spectra/Coldfusion problems and any work arounds please:-)
I came across a small problem while trying to install spectra, as everyone knows spectra can be hard to get going and I think I know why. When I installed CF Enterprise I never used the IsAuthenticated tags, now these are failling within CF. I have followed the advice on the article for spectra to no avail, I then came across the article for Security Policies failing and discovered that this fix is for non-networked servers. I am having this problem on 2 servers and both belong to a network of comnputers, is there a fix for this that can get me going I am in desperate needs to solve this problem:-) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Advice Needed
Spectra uses something like your objects approach. There are some serious pros and cons. . . At 02:25 PM 5/08/00 -0400, you wrote: >I am beginning work on a suite of small projects, which all feed off of a >central database. I have an idea rolling around in my mind as to the DB >design, but am not sure whether to go ahead with it. I'm trying to stay away >from zillions of small tables, each representing something different, so >here's what I came up with: > >Break everything down into "objects". Every user is an object. Every message >board is an object. Every message on a board is an object. These can all be >stored together in one table. > >Every object has a "type", such as USER, MESSAGEBOARD, MESSAGE, etc. These >too can be stored in one table. > >Every type of object has a list of attributes available to it. This table >would show that an object of type USER has attributes FIRSTNAME, LASTNAME, >PASSWORD, etc. > >The last table contains the actual data for the attributes defined above. It >shows that a particular user's LastName is 'Smith'. The next record in this >table could specify that a particular message was written at 11:30 PM. > >Now the question: Am I insane? Has anyone tried something like this before? >It is definitely an experiment in DB normalization, but I don't want to work >on it for 3 weeks, then find myself swamped. > >Hopefully this makes sense. Any foresight you may have would definitely be >appreciated. > >Norman Elton >Information Technology >College of William & Mary > >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with updating a database
I should have mentioned, if you want to make the update query that much quicker, you could just tab through the price fields and either change them or enter 0 if it's the same. then just wrap around the update query: UPDATE products SET Price = #thisprice# WHERE ProductID = #listgetat(form.ProductIDs, row)# -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help finding a shopping cart!
Dreamtank has a shopping cart like this. Call Tony Rennert at 310-260-1597 or email him at [EMAIL PROTECTED] Their's is used for web content photo cd's - Original Message - From: "perry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 06, 2000 12:40 PM Subject: Help finding a shopping cart! > Hi all, > > Does anyone know of a shopping cart application built in cold fusion that > allows purchasing of a whole category, not just individual products? > > An example would be like the photodisc or eyewire websites, where you can > purchase a whole collection or you individual images. > > TIA > > Perry > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Spectra/Coldfusion problems and any work arounds please:-)
Where did you see the article on Security Policies failing? My CF Administrator has a policy related error each time I try to implement advanced security, and what with the search function on Allaire being a bit dodgy, I've never got around to investigating it. David Cummins "Scott, Andrew" wrote: > > I came across a small problem while trying to install spectra, as everyone > knows spectra can be hard to get going and I think I know why. When I > installed CF Enterprise I never used the IsAuthenticated tags, now these are > failling within CF. I have followed the advice on the article for spectra to > no avail, I then came across the article for Security Policies failing and > discovered that this fix is for non-networked servers. > > I am having this problem on 2 servers and both belong to a network of > comnputers, is there a fix for this that can get me going I am in desperate > needs to solve this problem:-) > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Spectra/Coldfusion problems and any work arounds please:-)
I did a search for it on the knowledgebase I don't recall the exact KB article number. -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 12:54 To: [EMAIL PROTECTED] Subject: Re: Spectra/Coldfusion problems and any work arounds please:-) Where did you see the article on Security Policies failing? My CF Administrator has a policy related error each time I try to implement advanced security, and what with the search function on Allaire being a bit dodgy, I've never got around to investigating it. David Cummins "Scott, Andrew" wrote: > > I came across a small problem while trying to install spectra, as everyone > knows spectra can be hard to get going and I think I know why. When I > installed CF Enterprise I never used the IsAuthenticated tags, now these are > failling within CF. I have followed the advice on the article for spectra to > no avail, I then came across the article for Security Policies failing and > discovered that this fix is for non-networked servers. > > I am having this problem on 2 servers and both belong to a network of > comnputers, is there a fix for this that can get me going I am in desperate > needs to solve this problem:-) > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Spectra/Coldfusion problems and any work arounds please:-)
http://www.allaire.com/Handlers/index.cfm?ID=14378&Method=Full I think you're talking about that one. == I did a search for it on the knowledgebase I don't recall the exact KB article number. -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 12:54 To: [EMAIL PROTECTED] Subject: Re: Spectra/Coldfusion problems and any work arounds please:-) Where did you see the article on Security Policies failing? My CF Administrator has a policy related error each time I try to implement advanced security, and what with the search function on Allaire being a bit dodgy, I've never got around to investigating it. David Cummins "Scott, Andrew" wrote: > > I came across a small problem while trying to install spectra, as everyone > knows spectra can be hard to get going and I think I know why. When I > installed CF Enterprise I never used the IsAuthenticated tags, now these are > failling within CF. I have followed the advice on the article for spectra to > no avail, I then came across the article for Security Policies failing and > discovered that this fix is for non-networked servers. > > I am having this problem on 2 servers and both belong to a network of > comnputers, is there a fix for this that can get me going I am in desperate > needs to solve this problem:-) > -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Spectra/Coldfusion problems and any work arounds please:-)
Yeah that is one of them, there is also another one on Security Policies as well which I read. I have tried everything that the KB's have asked and still can't get Spectra to work. Why is this so Allaire, why is it so hard to get Spectra to work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 13:58 To: [EMAIL PROTECTED] Subject: Re: Spectra/Coldfusion problems and any work arounds please:-) http://www.allaire.com/Handlers/index.cfm?ID=14378&Method=Full I think you're talking about that one. == I did a search for it on the knowledgebase I don't recall the exact KB article number. -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 12:54 To: [EMAIL PROTECTED] Subject: Re: Spectra/Coldfusion problems and any work arounds please:-) Where did you see the article on Security Policies failing? My CF Administrator has a policy related error each time I try to implement advanced security, and what with the search function on Allaire being a bit dodgy, I've never got around to investigating it. David Cummins "Scott, Andrew" wrote: > > I came across a small problem while trying to install spectra, as everyone > knows spectra can be hard to get going and I think I know why. When I > installed CF Enterprise I never used the IsAuthenticated tags, now these are > failling within CF. I have followed the advice on the article for spectra to > no avail, I then came across the article for Security Policies failing and > discovered that this fix is for non-networked servers. > > I am having this problem on 2 servers and both belong to a network of > comnputers, is there a fix for this that can get me going I am in desperate > needs to solve this problem:-) > -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Spectra/Coldfusion problems and any work arounds please:-)
You may want to explain a bit more about this: I had a similiar problem. Let me start from the beginning. - I ran win2k on a 192 mb ram with 6.0 gb compaq laptop. I also had a cf 4.5 enterprise server on my laptop which was important to the spectra functionality. -Turns out I needed a win2k advanced server to run. So i had to erase everything and install that win2k advanced server. -My CF 4.5's advanced security settings did not even work at that point. I even had reset the decimal from the old one to 15360 in the regedit program so the siteminder wouldn't timeout too quickly for access to make the changes. -You may want to test the advanced security settings by seeing if you could add security context, rule, policies, etc. If that does not work, that may mean you need to upsize your database (from access to sql server) . However that happened to me, I decided to go ahead and skip this part by installing the spectra. it worked for me so I haven't upsized the DB yet. There are some parts I may have missed but if you could describe what you're doing and what's happening in detail. I'd be happy to try and help you. Rob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Spectra/Coldfusion problems and any work arounds please:-)
Ok here is the problem, I am running W2K and Windows Nt 4.0 on two machines. Both are running CF Enterpise with Advanced Security Installed. Now before even installing Spectra I can not create user policies or contexts I am always getting a Security Policy Error when I attempt, so of course when I install spectra I get the dreaded security test failed CF Authenticate Error. I am at a loss to explain this, everything is from a fresh install. So there has to be a reason why this is not installing and being used correctly Both machibes belong to a network of computers, both on sperate networks and both with the same problems.. Anyone got the answer I need:-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:43 To: [EMAIL PROTECTED] Subject: Re: Spectra/Coldfusion problems and any work arounds please:-) You may want to explain a bit more about this: I had a similiar problem. Let me start from the beginning. - I ran win2k on a 192 mb ram with 6.0 gb compaq laptop. I also had a cf 4.5 enterprise server on my laptop which was important to the spectra functionality. -Turns out I needed a win2k advanced server to run. So i had to erase everything and install that win2k advanced server. -My CF 4.5's advanced security settings did not even work at that point. I even had reset the decimal from the old one to 15360 in the regedit program so the siteminder wouldn't timeout too quickly for access to make the changes. -You may want to test the advanced security settings by seeing if you could add security context, rule, policies, etc. If that does not work, that may mean you need to upsize your database (from access to sql server) . However that happened to me, I decided to go ahead and skip this part by installing the spectra. it worked for me so I haven't upsized the DB yet. There are some parts I may have missed but if you could describe what you're doing and what's happening in detail. I'd be happy to try and help you. Rob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Spectra/Coldfusion problems and any work arounds please:-)
Few things come to mind: (I'm assuming you are running them on Win2k Advanced Server and NT 4.0 Server, not the professional and workstation , respectively) 1. did you set the decimal value to 15360 in the HKEY_LOCAL_MACHINE\SOFTWARE\Netegrity\SiteMinder\CurrentVersion\Database (regedit) or at least at your server machine. If that doesn't work, try this: 2. Upsize your database from Access to SQL Server 7.0 for policy store. this following note is written by Raymond Camden: Your best bet is to upsize. Here is a URL on how to upsize to SQL Server: http://www.allaire.com/Handlers/index.cfm?ID=14566&Method=Full Warning - you must be -very- careful when upsizing. If you run into problems, try the following two urls, they both detail various logging features you can turn on to help debug adv. sec. problems. I can say from experience that this process can be a bit frustrating at times, but I think Allaire knows this and is working on making it rock solid. Once you get it there, your good to go! http://www.allaire.com/Handlers/index.cfm?ID=14588&Method=Full http://www.allaire.com/Handlers/index.cfm?ID=11432&Method=Full Keep me posted- Rob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ADO vs. ODBC
Check out http://dev.aylo.com/FusionADO/ And to answer your question, yes the tag (if your query is a select statement) goes through the ado recordset to convert it into a cf query recordset. This extra conversion layer makes the tag slower than cfquery from the overhead incurred, but we plan on focusing the tag to return an enhanced structure of the recordset (fieldnames, datatype, et. al.) w00t, Aymeric. - Original Message - From: "Patrick Maddox" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 04, 2000 10:28 AM Subject: Re: ADO vs. ODBC > Any benchmarks? Any resources to go to to read up on the differences? Do > I have to convert ADO outputs to cfquery? > > Thanks again. > > Patrick Maddox > [EMAIL PROTECTED] > > > - Original Message - > From: Aymeric Grassart <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, August 04, 2000 10:29 AM > Subject: Re: ADO vs. ODBC > > > > - Original Message - > > From: "Patrick Maddox" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, August 04, 2000 9:07 AM > > Subject: ADO vs. ODBC > > > > > > > I am working on a project to where the client wants a CF database > > > application, however, they are > > > requesting that I do a ADO connection to the database(sql 7) vs. the > > typical > > > ODBC connection that I am > > > used to doing. > > > > > > Does anyone have info on the differences between the two connection > types. > > > What's faster, better etc. > > > > ADO is faster than CFQUERY, the only problem is that converting the > > recordset into CF query's makes it 10 times slower ; but other than that, > it > > should work. > > I have an alpha version of CF_ADO custom tag, if you'd like a copy, let me > > know. > > > > blah, > > Aymeric > > > > > and where I might go to get some additional info on this. The site will > > not > > > get huge volumes of hits, maybe > > > 200 hits on the database at any moment at the very most. > > > > > > Thank you. > > > > > > > > > *** > > > Patrick Maddox > > > Terralogic, Inc. > > > 540-213-2447 > > > [EMAIL PROTECTED] > > > > > > > -- > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFFILE problem on linux
Hi there, I'm trying to get CFFILE working on a linux box. ColdFusion is running as a user called coldfusion which has group write privileges to my HTML directory. If I log in as the coldfusion user I can create directories and files in the HTML directory OK. However, when I try to do a into that same directory I get a permissions error. I am not running advanced security. What is going on? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Filemaker connection
Chris - The table has to be *open* already (preferably on another machine or it'll be well slow) and we've had problems with Filemaker server - so use the Client instead. HTH, ask if it doesn't -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: 05 August 2000 00:38 To: [EMAIL PROTECTED] Subject: Filemaker connection I need to read some data from a filemaker 5 table. I've got the filemaker odbc stuff installed. I've configured the DSN. When I try to query from the database though, I get this error: ODBC Error Code = S0002 (Base table not found) [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Invalid database name. I know that the datasource is being seen, the database is named stuff.fp5 (and I've tried using stuff.fp5 as the name of the database as well...). My cfquery is: select ID from stuff Anyone else had luck querying a filemaker 5 table from cf (4.5.1) c -- Chris Lott -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
crystal reports and CF
Can anyone tell me how the licensing of Crystal Reports and CF works? I have documentation which implies that a version of Crystal comes with CF but I have scanned the disks for CF Server and CF Studio versions 4.0 and 4.5 but I cannot see it. It doesnt seem to have installed by default. Am I incorrect in assuming that it was bundled as part of CF at one stage? Regards Phil Palmer Technical Director Engage Technology Pty Ltd e [EMAIL PROTECTED] p 0414 353 246 w www.engagetechnology.com.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.