RE: Searching a database
Verity works quite well for this... -Original Message- From: Greg Edmonds [mailto:[EMAIL PROTECTED] Sent: Friday, 10 February 2006 08:18 To: CF-Talk Subject: Searching a database Hello, I was hoping someone could give me some advice or recommendations on how they create search forms. Currently I have a very basic system, that works ok, but certainly could be better. I run the following query against what the user types in the search box: SELECT * FROM table WHERE field LIKE '%#form.variable#%' This seems to do ok, but has several limitations. In our database, we search the description field of a part number. Here is a specific example of someone searching the word "superdish": Searches for: super - returns everything. Searches for: super dish - returns nothing. Searches for: superdish - returns everything. If we change the description of the part to "super dish": Searches for: super - returns everything. Searches for: super dish - returns everything. Searches for: superdish - returns nothing. I was considering breaking apart the actual variable sent and doing an OR statement, but wanted to check here first to see if anyone has a better way. We are using SQL server and cold fusion MX 6.1. Getting ready to upgrade to 7.0 in the next few weeks. Any help would be greatly appreciated. I hope I have explained myself! Thanks, Greg ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232026 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: parsing a list
When you replace the tabs, add quote to delineate blocks of text. Otherwise, any commas are treated as list delineators. You could also use a different character other than a comma. The delimiter is able to be specified in the list functions. Eric -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, 10 February 2006 00:41 To: CF-Talk Subject: parsing a list I'm having trouble parsing a list. Clients exports a TAB file from filemaker pro, which is uploaded and I chang it to a txt file and replace the tabbed spaces with ",", so if i do cfloop (list) over it i get an output like this: Emmitt R,Barns, III, tim,Douglas,[EMAIL PROTECTED] Rick,Middletorn, Dennis,Drieml, David,Perky, Brian,Wells,[EMAIL PROTECTED] Now I only want the rows that have an email attached to them. Now I can do a listlen and check if it has something in the 3 position (email) and that the 3rd position is an email (see the first entry where the 3rd position is not an email), then if thats met then delete all the rows that dont have at least an email. and be ready to insert to db. any ideas? ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232025 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
Oh, *automated*, well, that's a different story. :) Dave Watts wrote: >>> One big problem with Access is that databases don't shrink >>> as data is deleted, and there's nothing in Access equivalent >>> to the database/file shrinking options that, for example, MS >>> SQL Server has. >> What about Compact/Repair Database? > > That's a bit hard to automate as part of a maintenance plan, since you have > to open the Access database exclusively to do this. In SQL Server, for > example, I could just use DBCC SHRINKDATABASE or DBCC SHRINKFILE without > taking everything offline. I could even enable automatic shrinking. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232024 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
It is very relevent to web developers in general...we sometimes lose site of the fact that each new technology and feature that we add in may close the door on some part of our audience. This isn't just an issue because of ADA or 508, but because accessibility issues are just part of doing good web development...many of the things you do to make a site "accessible" are the same things you do to make the site "search engine friendly"...and that new AJAX search function may block a whole group of customers from using part of your site. On 2/10/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > Wow, this article couldn't have had better timing... > > http://news.com.com/2100-1030_3-6038123.html?part=rss&tag=6038123&subj=news > > Basically, a guy in Cali is suing Target.com for it's ADA inaccessibility. > > Things like this make me somewhat happy. I mean, show this to a few of > our clients, and they may just decide to have us go through their site > and make it right. Cha-Ching! :) > > Although, not to be mean, but how does one buy, say, a table or curtains > or whatever when one can't see/feel/touch it? > > Anyways, somewhat OT, but also pretty relevant. Thought I'd point it out. > > Those of you in New England, beware the Nor'easter comin' tomorrow! > > Ray > > Jim Wright wrote: > > ok...that's it(put's hand over screen so Ken can't read what he's > > typing) > > > > On 2/10/06, Ken Ferguson <[EMAIL PROTECTED]> wrote: > >> Here Ray, check out this article. It might help: > >> > >> http://www.w3.org/WAI/GL/WCAG-PDF-TECHS-20010913/ > >> > >> > >> LOL, just thought maybe I'd try it again. > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232023 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS Access to large at 25MB?
> > One big problem with Access is that databases don't shrink > > as data is deleted, and there's nothing in Access equivalent > > to the database/file shrinking options that, for example, MS > > SQL Server has. > > What about Compact/Repair Database? That's a bit hard to automate as part of a maintenance plan, since you have to open the Access database exclusively to do this. In SQL Server, for example, I could just use DBCC SHRINKDATABASE or DBCC SHRINKFILE without taking everything offline. I could even enable automatic shrinking. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232022 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ADA compliance and PDF
> Has anyone worked with ADA Compliant web sites? Are PDF's > considered ADA Compliant? I seem to remember there being a > PDF reader out there, but I can't seem to find it anywhere. > > I am providing an educational site with the ability to upload ed. > resources in PDF format, but everything has to be 100% ADA compliant. > Now I'm thinking that I'm going to have to provide them with > a means to upload the same resource in HTML, because I can't > find any evidence that says PDF's are OK. That's gonna suck You need to go here: http://access.adobe.com/ Section 508 compliance isn't exactly the same as ADA compliance, but they both target the same sort of functionality. PDFs can be accessible, if they're done right. Acrobat itself has accessibility checking functionality built-in, and will let you tag your PDFs for screen reading and reflowing on non-standard devices such as PDAs. That said, this isn't something that can easily be automated, so you'd either have to check each PDF yourself, or trust your contributors to create accessible PDFs (good luck with that!) For end-user testing, you can run Acrobat's Accessibility Setup Assistant, which controls how documents appear on screen and how they'll print on a Braille printer. Interestingly, if you install Acrobat on a Tablet PC, it'll automatically launch the Accessibility Setup Assistant - touch screens are included in Tablet PC, and Acrobat considers this assistive technology. You can also have Acrobat read PDFs to you using MS Agent text-to-speech functionality. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
> One big problem with Access is that databases don't shrink as data is > deleted, and there's nothing in Access equivalent to the database/file > shrinking options that, for example, MS SQL Server has. What about Compact/Repair Database? So, you might end up > with a very large, very sparse database file with a few hundred rows of > actual data. Using Access as a storage location for CF Client variables will > often result in this problem. > > A bigger problem than sheer file size with Access is how it handles > concurrency - or doesn't handle it, to be more precise. Locks are placed on > tables in Access, so if you have a large Access table that everyone needs to > read, and someone's writing to it, everyone gets to wait. > > In the end, I think that your hosting company's requirement is probably a > good general rule, especially in a shared server environment. It might be > the case that your 750MB file works well enough for you, but if everyone on > that server did the same thing ... > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232020 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
> One big problem with Access is that databases don't shrink as data is > deleted, and there's nothing in Access equivalent to the database/file > shrinking options that, for example, MS SQL Server has. So, you might end up > with a very large, very sparse database file with a few hundred rows of > actual data. Using Access as a storage location for CF Client variables will > often result in this problem. True Daveand that's why we compacted/repaired (so you can shrink...just not auto-shrink) our 1.2 GB Access 97 DB every morning before the rest of the company showed up ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232019 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
Wow, this article couldn't have had better timing... http://news.com.com/2100-1030_3-6038123.html?part=rss&tag=6038123&subj=news Basically, a guy in Cali is suing Target.com for it's ADA inaccessibility. Things like this make me somewhat happy. I mean, show this to a few of our clients, and they may just decide to have us go through their site and make it right. Cha-Ching! :) Although, not to be mean, but how does one buy, say, a table or curtains or whatever when one can't see/feel/touch it? Anyways, somewhat OT, but also pretty relevant. Thought I'd point it out. Those of you in New England, beware the Nor'easter comin' tomorrow! Ray Jim Wright wrote: > ok...that's it(put's hand over screen so Ken can't read what he's typing) > > On 2/10/06, Ken Ferguson <[EMAIL PROTECTED]> wrote: >> Here Ray, check out this article. It might help: >> >> http://www.w3.org/WAI/GL/WCAG-PDF-TECHS-20010913/ >> >> >> LOL, just thought maybe I'd try it again. > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232018 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS Access to large at 25MB?
> I received the following email from our hosting company. I > have never heard of this before. Has any one? They actually > disabled our account based on this. > At work I am running one access database with 750MB (I know, > but...) without any issues. They are claiming that it is > using too much CPU resources and causing "CF ISSUES". > Thanks. > > Hello , > Our level two engineers have reviewed your database > (.mdb) which now stands at 19.5MB which is too large. > Our System Administrators have requested that you please > reduce your database down to 7MB or less, based on the > recommendations from Macromedia and Microsoft. In working > with them to improve the stability and performance of our > ColdFusion servers, they have informed us that MS Access > databases over 7MB cause the majority of the issue we see, > and Macromedia will no longer assist us in troubleshooting > issues when the size is large then 7MB. If you cannot compact > the database, we would ask that you move this database to MS > SQL, where large databases will not cause performance issues > for other users on your shared server. I've worked with Access databases around 2 GB (!) before. Access databases can be quite large and still work well. However, there are some problems with using Access as a database for a web application, and those problems may intensify as your database size increases. One big problem with Access is that databases don't shrink as data is deleted, and there's nothing in Access equivalent to the database/file shrinking options that, for example, MS SQL Server has. So, you might end up with a very large, very sparse database file with a few hundred rows of actual data. Using Access as a storage location for CF Client variables will often result in this problem. A bigger problem than sheer file size with Access is how it handles concurrency - or doesn't handle it, to be more precise. Locks are placed on tables in Access, so if you have a large Access table that everyone needs to read, and someone's writing to it, everyone gets to wait. In the end, I think that your hosting company's requirement is probably a good general rule, especially in a shared server environment. It might be the case that your 750MB file works well enough for you, but if everyone on that server did the same thing ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232017 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Storing Documents
> We've got two tables set up: > > search_table > :id > :metadata1 > :metadata2 > :metadataN > :file_type > :file_size > :file_id > > file_storage > :id > :image > > everything is stored in the database. The tables could have > been combined into one, but we thought it might slow down > performance if your having to deal with a blob object in all > of your queries. The way we have it set up, we can run > queries against the lightweight search_table and then > retrieve the document from the file_id => file_storage.id > relation. Also, given this technique, the file_storage table > could easily be moved to another database, another server, or > spread out to different databases. Actually, having the file in the same table as the other data shouldn't cause any problems. The database doesn't actually store the file in the database, it stores a pointer to a location outside of the table; the file itself is at that location. If you were storing some data that you accessed frequently, and other data that you accessed very infrequently, and all the data were stored within the tables rather than as LOBs, your table structure may actually provide some benefit. This is called a one-to-one relationship, and usually it's more trouble than it's worth. What will slow your queries down, on the other hand, is using a LOB-enabled datasource for queries that don't use LOBs. Or, at least, that used to degrade performance significantly - I haven't tested with the newest database drivers, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232016 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Suddenly...solitude is not so lonely... ;o) Rick > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > > Rick I've seen decisions made that have nothing to do with the > technology. Just > think about it..."hey if we can say in our marketing that we us > Oracle and .NET > those are things the general public have heard ofit'll make > us look big and > important" ;-) > > Heck I've seen a shiny ball f tin foli interest some of these foks ;-) > > I'm sure you've read Dilbert.it's much closer to reality than > you might > think ;-) > > Cheers > > Bryan Stevenson B.Comm. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232015 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
This looks completely arbitrary. I have an application with a 640Meg Acces file. Two of the tables contain more than 2 millions records, and it works like a charm. May be their problem is with their "level 2" engineers. Suggest level 3 or more ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232014 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Storing Documents
I don't think you would see any performance penalty if you don't SELECT the IMAGE field in a particular query. It would be worth some testing to be sure. However, I like the idea of a very small table that would hold only minimal information. On the other hand, I would put as much in the same table as the IMAGE field just to be safe. All of this information, and maybe some more, cannot really exist without the rest of the record. I would store: id origFileName contentType contentSubType fileSize binaryContent insertDateTime insertUserName comment M!ke -Original Message- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 3:31 PM To: CF-Talk Subject: Re: Storing Documents We've got two tables set up: search_table :id :metadata1 :metadata2 :metadataN :file_type :file_size :file_id file_storage :id :image everything is stored in the database. The tables could have been combined into one, but we thought it might slow down performance if your having to deal with a blob object in all of your queries. The way we have it set up, we can run queries against the lightweight search_table and then retrieve the document from the file_id => file_storage.id relation. Also, given this technique, the file_storage table could easily be moved to another database, another server, or spread out to different databases. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232013 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
If this is the same host (I'm 99.9% sure that it is, I've been in the same boat with mine, and the 7MB number is hard to duplicate by chance), they leave connections open by default. You have to explicitly turn off this option in their control panel if you don't want it. So, I'm doubting that is the issue, though it is a valid point. Russ wrote: > I wonder if access would be a problem if they didn't keep connections open. > I can see a problem if they have to read a 25mb file everytime there is a > request that comes in. That could cause some issues. > > > >> -Original Message- >> From: Jim Wright [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 10, 2006 4:40 PM >> To: CF-Talk >> Subject: Re: MS Access to large at 25MB? >> >> That 7MB limit seems pretty arbitrary...I've never seen anything like >> that from MACR or MSFT. Sounds kind of like they are trying to push >> their SQL Server add-on by coming up with "technical" roadblocks. As >> much bashing as Access gets, I ran many a system with databases much >> larger than that on it back in the day, with nary a peep. >> >> -- >> Jim Wright >> Wright Business Solutions >> [EMAIL PROTECTED] >> 919-417-2257 >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232012 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS Access to large at 25MB?
I wonder if access would be a problem if they didn't keep connections open. I can see a problem if they have to read a 25mb file everytime there is a request that comes in. That could cause some issues. > -Original Message- > From: Jim Wright [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 4:40 PM > To: CF-Talk > Subject: Re: MS Access to large at 25MB? > > That 7MB limit seems pretty arbitrary...I've never seen anything like > that from MACR or MSFT. Sounds kind of like they are trying to push > their SQL Server add-on by coming up with "technical" roadblocks. As > much bashing as Access gets, I ran many a system with databases much > larger than that on it back in the day, with nary a peep. > > -- > Jim Wright > Wright Business Solutions > [EMAIL PROTECTED] > 919-417-2257 > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232011 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
> And I've never seen any MM recommendation pertaining to CF and Access MDB > file size. Hummm. > > --- Ben Yep I'd have to cry foul on that one. Some ISPs I've dealt with just make stuff up that sounds officlial because they are either incompetent or it's an easy fix to a complex problem. I've personally run a 1.2 GB Access 97 DB on an intranet with CF 4.0 and 4.5 without any major problems (not that I reccommend this foolishness...hehe) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232010 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Some disclaimers: I'm no brainiac, I'm a pretty green programmer and from reading the posts on this list, I am sure 99% of the people who post to this list are smarter than I am. Having put the aforementioned disclosers on the table, I do not understand what MMAdobe could do to make Flex 2.0 more clear either as far as the pricing structure is concerned or the advantages it brings to the table for developers. In addition, I cannot for the life of me understand how the MMAdobe Labs could be more geared towards developers. I am sure there is plenty of marketing hype aimed at IT guys now and tons more to come, but right now MMAdobe is doing their very, very best to reach YOU the developer...especially YOU the ColdFusion developer. Flex will be cheap (or free if you don't want an IDE specifically designed for FLEX) and is essentially, AJAX or FLASH UI without the hacks, headaches, hassle and really steep learning curve. >>btw...I went to the labs site and couldn't even get the example apps to show...could be a problem on my end however...but don't see why... The examples now posted at MMAdobe Labs require the latest build (beta) of Flash player 8.5. I'm slow, it took me a little while to figure that out. Happy coding fellas, no harm or insult intended. Mark Fuqua ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232009 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Hallelujah! > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 4:43 PM > To: CF-Talk > Subject: Re: OT: ColdFusion and Flex > > > > Can I get an amen, then? ;o) > > > > Rick > > Amen Brother Rick! > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232008 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
> But, seriously, not ever having worked in a corporate > environment, (and hopefully will always keep it that way) > I would find it hard to believe that IT managers, > and others, wouldn't discuss the use of major technology > tools before taking such a leap...but again, what do I know, > I'm just the boss. ;o) (and a lowly developer...) > > Rick Rick I've seen decisions made that have nothing to do with the technology. Just think about it..."hey if we can say in our marketing that we us Oracle and .NET those are things the general public have heard ofit'll make us look big and important" ;-) Heck I've seen a shiny ball f tin foli interest some of these foks ;-) I'm sure you've read Dilbert.it's much closer to reality than you might think ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232007 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS Access to large at 25MB?
About 5 years ago when I worked for another company I was forced to Use MS Access and the database only was pushing 500MB in size. We had nightly scripts to export and import data that was in excess of 400-600k records. Now this is also ran with CF4.5 and ran just fine. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 4:40 PM To: CF-Talk Subject: Re: MS Access to large at 25MB? That 7MB limit seems pretty arbitrary...I've never seen anything like that from MACR or MSFT. Sounds kind of like they are trying to push their SQL Server add-on by coming up with "technical" roadblocks. As much bashing as Access gets, I ran many a system with databases much larger than that on it back in the day, with nary a peep. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232006 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Sounds like a problem with IT managers that don't do enough "looking before leaping"... If an IT manager could be convinced simply by "Marketing Speak" they wouldn't be working for me very long... Rick > -Original Message- > From: Ken Ferguson [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 4:30 PM > To: CF-Talk > Subject: Re: OT: ColdFusion and Flex > > > I'm not suggesting they don't "discuss" things with the devs at all. I'm > just saying that they see something that someone convinced them they > "must have" and they absolutely must have it. So then the marketing > department's job is to make IT mgrs believe they must have it... I have > seen technology changes in a couple different companies made in this > exact manner. > > --Ferg > > Rick Faircloth wrote: > > You're absolutely right, Ferg. I have *tremendous* pull over > > the decision maker in my company...because I'm the > > decision maker in this sole proprietor company! > > > > But, seriously, not ever having worked in a corporate > > environment, (and hopefully will always keep it that way) > > I would find it hard to believe that IT managers, > > and others, wouldn't discuss the use of major technology > > tools before taking such a leap...but again, what do I know, > > I'm just the boss. ;o) (and a lowly developer...) > > > > Rick > > > > > > > >> -Original Message- > >> From: Ken Ferguson [mailto:[EMAIL PROTECTED] > >> Sent: Friday, February 10, 2006 2:26 PM > >> To: CF-Talk > >> Subject: Re: OT: ColdFusion and Flex > >> > >> > >> While I agree with you guys that it would be nice to have a marketing > >> push aimed at informing and exciting developers, I'm not sure that it > >> would be a worthwhile investment on Adobe's part (or any software > >> company's, really); at least that's how I think they see it. > Developers > >> don't spend money and, in my experience, rarely affect how it > gets spent > >> in any significant way and on what technologies an organization will > >> use, (though many seem to mistakenly think they have a larger > impact on > >> both) . I think the developers who do end up affecting the way these > >> decisions are taken often dig to find the information they > need and are > >> only moderately inconvenienced by any lack of available low-level > >> information. In the end, I just don't think the marketing folks care > >> what anyone other than the aforementioned IT Manager types think. The > >> mindset seems, very often, to be one of: market straight to > the decision > >> maker and if you do your job right, he'll take care of the rest. > >> > >> Maybe I'm just rambling, but I've had this conversation with an > >> associate a number of times about a number of different companies. I'm > >> not speaking to whether this is negative or positive, but it does seem > >> to be the case. Also, I know that each of you out there > reading this are > >> all the exceptions to this and have tremendous pull on your > >> organization's decision making, so please don't feel insulted. : ) > >> > >> --Ferg > >> > >> Bryan Stevenson wrote: > >> > >>> preaching to the choir Rick ;-) > >>> > >>> Bryan Stevenson B.Comm. > >>> VP & Director of E-Commerce Development > >>> Electric Edge Systems Group Inc. > >>> phone: 250.480.0642 > >>> fax: 250.480.1264 > >>> cell: 250.920.8830 > >>> e-mail: [EMAIL PROTECTED] > >>> web: www.electricedgesystems.com > >>> > >>> > >>> > >> > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
> Can I get an amen, then? ;o) > > Rick Amen Brother Rick! Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232004 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
That 7MB limit seems pretty arbitrary...I've never seen anything like that from MACR or MSFT. Sounds kind of like they are trying to push their SQL Server add-on by coming up with "technical" roadblocks. As much bashing as Access gets, I ran many a system with databases much larger than that on it back in the day, with nary a peep. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
Those are keywords entered by users when the store a document in the system. Stuff like destroy date, attendees, meeting type, etc.. On 2/10/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > Is the metadata something that is keyed in or do you grab it from the file > somehow? > > On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > > > We've got two tables set up: > > > > search_table > > :id > > :metadata1 > > :metadata2 > > :metadataN > > :file_type > > :file_size > > :file_id > > > > file_storage > > :id > > :image > > > > everything is stored in the database. The tables could have been > > combined into one, but we thought it might slow down performance if > > your having to deal with a blob object in all of your queries. The > > way we have it set up, we can run queries against the lightweight > > search_table and then retrieve the document from the file_id => > > file_storage.id relation. Also, given this technique, the > > file_storage table could easily be moved to another database, another > > server, or spread out to different databases. > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: parsing a list
Use the one I did...it isn't tied to the 3rd position and spits out the emails as needed. #ListGetAt(i, emailPosition, "|")# To tweak it for names just do something like this: #record# If 1 and 2 are always first and last name you can pull them individually. I typed the above here in Google so you might have some errors. On 2/10/06, dave <[EMAIL PROTECTED]> wrote: > > ok it still doesnt work right. > If i go to output it into db I get errors that the 3 position is empty and > I still get records back like > ,Sanyer,[EMAIL PROTECTED] > John F,Kelly, Jr,[EMAIL PROTECTED] > which of course makes it error > > ~Dave the disruptor~ > I forgot what I was gunna put here, Will woulda stole it anyways! > > > From: James Holmes <[EMAIL PROTECTED]> > Sent: Friday, February 10, 2006 4:17 AM > To: CF-Talk > Subject: Re: parsing a list > > ROFL! > > 1) Download it > 2) Join the CFAJAX mailing list > 3) Ask questions there... ;-) > > On 2/10/06, dave wrote: > > > > > ok now teach me cfajax real quick like!! ;) > > -- > CFAJAX docs and other useful articles: > http://jr-holmes.coldfusionjournal.com/ > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232001 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Running IE7 concurrently
I just got this email from sitepoint, but it seems that you can run IE7 without having to trash your IE6 install >From the email: So, let's say you're curious and you'd like to take IE7 for a spin, but you're not ready to let it oust IE6 as your IE of choice -- can this be done? I'm no expert on the interplay of Microsoft components, but I did manage to get it going, and I'm happy to run you through the process I used to get it running on my XP system. 1. Download and save the beta EXE but don't run it. It's a self-extracting, self-installing ZIP file; we want to do this manually. 2. Create a new folder called 'IE7'. 3. Right-click on the EXE and scroll down to 'Extract to...' for Winzip. If you don't use Winzip, this process should work in your decompression software of choice. 4. Extract everything to your 'IE7' folder, making sure you keep the folder structure intact by keeping 'Use folder names' checked. 5. Open your 'IE7' folder, right-click inside the folder and scroll to 'New/Text Document. 6. Rename that file to 'iexplore.exe.local'. Make sure you're changing the file's format, not just renaming your text document to 'iexplore.exe.local.txt'. 7. That's it. Run 'iexplore.exe' in that folder -- do not run 'iesetup.exe', which will initiate the full install. -- "aeteti yeah, do you seeyea, ooohohohn neh I don wanta seh, yeh nah, I don wanna seh", Pearl Jam, "Yellow Ledbetter" ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232000 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
Is the metadata something that is keyed in or do you grab it from the file somehow? On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > We've got two tables set up: > > search_table > :id > :metadata1 > :metadata2 > :metadataN > :file_type > :file_size > :file_id > > file_storage > :id > :image > > everything is stored in the database. The tables could have been > combined into one, but we thought it might slow down performance if > your having to deal with a blob object in all of your queries. The > way we have it set up, we can run queries against the lightweight > search_table and then retrieve the document from the file_id => > file_storage.id relation. Also, given this technique, the > file_storage table could easily be moved to another database, another > server, or spread out to different databases. > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
We've got two tables set up: search_table :id :metadata1 :metadata2 :metadataN :file_type :file_size :file_id file_storage :id :image everything is stored in the database. The tables could have been combined into one, but we thought it might slow down performance if your having to deal with a blob object in all of your queries. The way we have it set up, we can run queries against the lightweight search_table and then retrieve the document from the file_id => file_storage.id relation. Also, given this technique, the file_storage table could easily be moved to another database, another server, or spread out to different databases. On 2/10/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Haven't worked with document storageso...if I understand correctly, > Zaphod, you're storing the pointer to a file on the server, and storing > the file as BLOB code...right? > > Rick > > > > -Original Message- > > From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] > > Sent: Friday, February 10, 2006 2:32 PM > > To: CF-Talk > > Subject: Re: Storing Documents > > > > > > We just recently set up a document management system using MS > > SqlServer. We ended up storing the documents inside the db. The way > > we structured it was to set up a table that had all of the meta data > > about the document along with a file id (int) that linked up with a > > file storage table that consisted of an id and a blob column. This > > way, we can run queries against the meta data without slowing down the > > system with large blob columns. > > > > So far, the performance has been suprisingly snappy. Also, security > > has been a lot easier to work into as we only have to secure one > > resource instead of both a database and a file system. Another > > additional benefit is that we've been able to share some documents on > > our extranet site without having to open another port for file sharing > > as all documents come from the db. > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231998 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
ok...that's it(put's hand over screen so Ken can't read what he's typing) On 2/10/06, Ken Ferguson <[EMAIL PROTECTED]> wrote: > Here Ray, check out this article. It might help: > > http://www.w3.org/WAI/GL/WCAG-PDF-TECHS-20010913/ > > > LOL, just thought maybe I'd try it again. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231997 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS Access to large at 25MB?
And I've never seen any MM recommendation pertaining to CF and Access MDB file size. Hummm. --- Ben -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 4:22 PM To: CF-Talk Subject: Re: MS Access to large at 25MB? Didn't see this beforebut I'm guessing you're on Intermedia? I've recently had to change hosts because of this seemingly arbitrary "rule" they put on their new Win2003 accounts. I know my DB shouldn't be on Access, but there's no reason that I have seen as to why it shouldn't work. Has been for 4 years now. We don't have the time to make huge changes to the four sites that are using Access right now, nor does the client want to pay for such a move. As they shouldn't. I really hate to dog on a host in a public forum, but they flat out refuse to make any adjustments, and I don't remember MM ever saying that M$ Access databases have to be under 7MB. Why hasn't any other host ever imposed this limit? Again, I'm not excusing the use of Access DB's, they shouldn't be used, but some "legacy" applications do, and they shouldn't have to be changes because some host wants to squeeze in a few more sites on one server. My 2 pence, Ray Joelle Tegwen wrote: > I'm going to say they're right. We've got a database at 29MB and we've > been dogging for a while. (We're migrating to MySQL). Maybe it's > partially an architecture issue, maybe it's a volume issue? I don't > know, but we've had this problem with Access and ASP (I can't imagine > CF is that different) Joelle > > I Rz wrote: > >> I received the following email from our hosting company. I have never >> heard of this before. Has any one? They actually disabled our account >> based on this. >> At work I am running one access database with 750MB (I know, but...) >> without any issues. They are claiming that it is using too much CPU >> resources and causing "CF ISSUES". >> Thanks. >> >> Hello , >> Our level two engineers have reviewed your database >> (.mdb) which now stands at 19.5MB which is too large. Our System >> Administrators have requested that you please reduce your database >> down to 7MB or less, based on the recommendations from Macromedia and >> Microsoft. In working with them to improve the stability and >> performance of our ColdFusion servers, they have informed us that MS >> Access databases over 7MB cause the majority of the issue we see, and >> Macromedia will no longer assist us in troubleshooting issues when >> the size is large then 7MB. If you cannot compact the database, we >> would ask that you move this database to MS SQL, where large >> databases will not cause performance issues for other users on your >> shared server. >> >> >> __ >> Do You Yahoo!? >> Tired of spam? Yahoo! Mail has the best spam protection around >> http://mail.yahoo.com >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
I'm not suggesting they don't "discuss" things with the devs at all. I'm just saying that they see something that someone convinced them they "must have" and they absolutely must have it. So then the marketing department's job is to make IT mgrs believe they must have it... I have seen technology changes in a couple different companies made in this exact manner. --Ferg Rick Faircloth wrote: > You're absolutely right, Ferg. I have *tremendous* pull over > the decision maker in my company...because I'm the > decision maker in this sole proprietor company! > > But, seriously, not ever having worked in a corporate > environment, (and hopefully will always keep it that way) > I would find it hard to believe that IT managers, > and others, wouldn't discuss the use of major technology > tools before taking such a leap...but again, what do I know, > I'm just the boss. ;o) (and a lowly developer...) > > Rick > > > >> -Original Message- >> From: Ken Ferguson [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 10, 2006 2:26 PM >> To: CF-Talk >> Subject: Re: OT: ColdFusion and Flex >> >> >> While I agree with you guys that it would be nice to have a marketing >> push aimed at informing and exciting developers, I'm not sure that it >> would be a worthwhile investment on Adobe's part (or any software >> company's, really); at least that's how I think they see it. Developers >> don't spend money and, in my experience, rarely affect how it gets spent >> in any significant way and on what technologies an organization will >> use, (though many seem to mistakenly think they have a larger impact on >> both) . I think the developers who do end up affecting the way these >> decisions are taken often dig to find the information they need and are >> only moderately inconvenienced by any lack of available low-level >> information. In the end, I just don't think the marketing folks care >> what anyone other than the aforementioned IT Manager types think. The >> mindset seems, very often, to be one of: market straight to the decision >> maker and if you do your job right, he'll take care of the rest. >> >> Maybe I'm just rambling, but I've had this conversation with an >> associate a number of times about a number of different companies. I'm >> not speaking to whether this is negative or positive, but it does seem >> to be the case. Also, I know that each of you out there reading this are >> all the exceptions to this and have tremendous pull on your >> organization's decision making, so please don't feel insulted. : ) >> >> --Ferg >> >> Bryan Stevenson wrote: >> >>> preaching to the choir Rick ;-) >>> >>> Bryan Stevenson B.Comm. >>> VP & Director of E-Commerce Development >>> Electric Edge Systems Group Inc. >>> phone: 250.480.0642 >>> fax: 250.480.1264 >>> cell: 250.920.8830 >>> e-mail: [EMAIL PROTECTED] >>> web: www.electricedgesystems.com >>> >>> >>> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231995 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
Didn't see this beforebut I'm guessing you're on Intermedia? I've recently had to change hosts because of this seemingly arbitrary "rule" they put on their new Win2003 accounts. I know my DB shouldn't be on Access, but there's no reason that I have seen as to why it shouldn't work. Has been for 4 years now. We don't have the time to make huge changes to the four sites that are using Access right now, nor does the client want to pay for such a move. As they shouldn't. I really hate to dog on a host in a public forum, but they flat out refuse to make any adjustments, and I don't remember MM ever saying that M$ Access databases have to be under 7MB. Why hasn't any other host ever imposed this limit? Again, I'm not excusing the use of Access DB's, they shouldn't be used, but some "legacy" applications do, and they shouldn't have to be changes because some host wants to squeeze in a few more sites on one server. My 2 pence, Ray Joelle Tegwen wrote: > I'm going to say they're right. We've got a database at 29MB and we've > been dogging for a while. (We're migrating to MySQL). Maybe it's > partially an architecture issue, maybe it's a volume issue? I don't > know, but we've had this problem with Access and ASP (I can't imagine CF > is that different) > Joelle > > I Rz wrote: > >> I received the following email from our hosting >> company. I have never heard of this before. Has any >> one? They actually disabled our account based on this. >> At work I am running one access database with 750MB (I >> know, but...) without any issues. They are claiming >> that it is using too much CPU resources and causing >> "CF ISSUES". >> Thanks. >> >> Hello , >> Our level two engineers have reviewed your database >> (.mdb) which now stands at 19.5MB which is too >> large. Our System Administrators have requested that >> you please reduce your database down to 7MB or less, >> based on the recommendations from Macromedia and >> Microsoft. In working with them to improve the >> stability and performance of our ColdFusion servers, >> they have informed us that MS Access databases over >> 7MB cause the majority of the issue we see, and >> Macromedia will no longer assist us in troubleshooting >> issues when the size is large then 7MB. If you cannot >> compact the database, we would ask that you move this >> database to MS SQL, where large databases will not >> cause performance issues for other users on your >> shared server. >> >> >> __ >> Do You Yahoo!? >> Tired of spam? Yahoo! Mail has the best spam protection around >> http://mail.yahoo.com >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231994 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
I wouldn't expect them to have a big polished ad and all that glitz while it's still a BETA product, now if it's that way after it's released then spank Adobe for poor marketing. I think we should be thanking them for publically giving us the "Adobe Labs" resource to mess around with long before the product is available. However, my beef with it its you can't see nor try out most of the examples or showcases without downloading and installing and running yourself. ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231993 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Storing Documents
Haven't worked with document storageso...if I understand correctly, Zaphod, you're storing the pointer to a file on the server, and storing the file as BLOB code...right? Rick > -Original Message- > From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 2:32 PM > To: CF-Talk > Subject: Re: Storing Documents > > > We just recently set up a document management system using MS > SqlServer. We ended up storing the documents inside the db. The way > we structured it was to set up a table that had all of the meta data > about the document along with a file id (int) that linked up with a > file storage table that consisted of an id and a blob column. This > way, we can run queries against the meta data without slowing down the > system with large blob columns. > > So far, the performance has been suprisingly snappy. Also, security > has been a lot easier to work into as we only have to secure one > resource instead of both a database and a file system. Another > additional benefit is that we've been able to share some documents on > our extranet site without having to open another port for file sharing > as all documents come from the db. > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231992 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
You're absolutely right, Ferg. I have *tremendous* pull over the decision maker in my company...because I'm the decision maker in this sole proprietor company! But, seriously, not ever having worked in a corporate environment, (and hopefully will always keep it that way) I would find it hard to believe that IT managers, and others, wouldn't discuss the use of major technology tools before taking such a leap...but again, what do I know, I'm just the boss. ;o) (and a lowly developer...) Rick > -Original Message- > From: Ken Ferguson [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 2:26 PM > To: CF-Talk > Subject: Re: OT: ColdFusion and Flex > > > While I agree with you guys that it would be nice to have a marketing > push aimed at informing and exciting developers, I'm not sure that it > would be a worthwhile investment on Adobe's part (or any software > company's, really); at least that's how I think they see it. Developers > don't spend money and, in my experience, rarely affect how it gets spent > in any significant way and on what technologies an organization will > use, (though many seem to mistakenly think they have a larger impact on > both) . I think the developers who do end up affecting the way these > decisions are taken often dig to find the information they need and are > only moderately inconvenienced by any lack of available low-level > information. In the end, I just don't think the marketing folks care > what anyone other than the aforementioned IT Manager types think. The > mindset seems, very often, to be one of: market straight to the decision > maker and if you do your job right, he'll take care of the rest. > > Maybe I'm just rambling, but I've had this conversation with an > associate a number of times about a number of different companies. I'm > not speaking to whether this is negative or positive, but it does seem > to be the case. Also, I know that each of you out there reading this are > all the exceptions to this and have tremendous pull on your > organization's decision making, so please don't feel insulted. : ) > > --Ferg > > Bryan Stevenson wrote: > > preaching to the choir Rick ;-) > > > > Bryan Stevenson B.Comm. > > VP & Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > phone: 250.480.0642 > > fax: 250.480.1264 > > cell: 250.920.8830 > > e-mail: [EMAIL PROTECTED] > > web: www.electricedgesystems.com > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231991 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MS Access to large at 25MB?
I'm going to say they're right. We've got a database at 29MB and we've been dogging for a while. (We're migrating to MySQL). Maybe it's partially an architecture issue, maybe it's a volume issue? I don't know, but we've had this problem with Access and ASP (I can't imagine CF is that different) Joelle I Rz wrote: >I received the following email from our hosting >company. I have never heard of this before. Has any >one? They actually disabled our account based on this. >At work I am running one access database with 750MB (I >know, but...) without any issues. They are claiming >that it is using too much CPU resources and causing >"CF ISSUES". >Thanks. > >Hello , >Our level two engineers have reviewed your database >(.mdb) which now stands at 19.5MB which is too >large. Our System Administrators have requested that >you please reduce your database down to 7MB or less, >based on the recommendations from Macromedia and >Microsoft. In working with them to improve the >stability and performance of our ColdFusion servers, >they have informed us that MS Access databases over >7MB cause the majority of the issue we see, and >Macromedia will no longer assist us in troubleshooting >issues when the size is large then 7MB. If you cannot >compact the database, we would ask that you move this >database to MS SQL, where large databases will not >cause performance issues for other users on your >shared server. > > >__ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231990 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
Here Ray, check out this article. It might help: http://www.w3.org/WAI/GL/WCAG-PDF-TECHS-20010913/ LOL, just thought maybe I'd try it again. In all seriousness though, Jim's right. You need to find out with what, exactly, you are supposed to be complying. It seems to me that Section 508 would be the ticket to satisfy the ADA, but I'm not sure. I've only ever worked specifically with straight 508 compliance. --Ferg Jim Wright wrote: > On 2/10/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > >> LOLyou guys cited the same article, I guess this must be the >> "definitive" answer. >> > > perhaps it is...but your question got me thinking, and I can't find > anything that says that following 508 guidelines will definitely have > you covered with the ADA...the ADA predated the internet, so it is > fuzzy in that area. anybody know? > > There are also the W3C accessiblity guidelines you could look at, > which I believe are generally tighter than 508...here is an article > over there regarding pdf... > > http://www.w3.org/WAI/GL/WCAG-PDF-TECHS-20010913/ > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231989 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SOLVED: RE: Can't use any browsers besides IE
Well I took a crash course in IIS and found that I had my site in a virtual directory. When I changed it to a physical directory it works on all browsers. Thanks for everyones help Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 2:17 PM To: CF-Talk Subject: OT:Can't use any browsers besides IE (was Homesite external browsers) OK, So this isnt a homesite thing this is a browsers thing. When i type the address in physically it doesnt show the web page in any browser except IE. I changed the subject just so that its understood its not a HS thing. Thanks, Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231988 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
You're right, Ian... I've seen sites use approaches with sections like "Flex and Develops" and "Flex and IT Managers", etc, used very effectively to address the marketing towards the view of a particular audience. That would be a wise way to go, because at some point, the IT manager has to come to the developers and discuss if it can be used effectively, with how much work, training, etc... If the developer is well-educated about a product and its requirements, as well as its potential uses, then the IT manager and developer can communicate very well about the product and more likely agree on its usefulness and value, which will likely lead to a purchase. Rick > -Original Message- > From: Ian Skinner [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 12:49 PM > To: CF-Talk > Subject: RE: OT: ColdFusion and Flex > > > Adobe should create demand for "what a product can do" not > for "the product" and market to everyone who has impact on the > use and benefits of the projects it be used for...IT managers, et > al, who will want to know what the end results of its use will > be, and developers who want to know what it takes to get the end > results... > > Rick > > Especially since we are talking about a marketing website, it > should be very easy to have a "for IT managers" section and a > "for developers" section. Probably in more "marketing" type language. > > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > - > | 1 | | > - Binary Soduko > | | | > - > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231987 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Can I get an amen, then? ;o) Rick > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 12:51 PM > To: CF-Talk > Subject: Re: OT: ColdFusion and Flex > > > preaching to the choir Rick ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231986 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
I'd build the system to be able to store binary content in either the database OR a filesystem. Conceptually it's no different, and it allows more deployment flexibility. It really depends on the *amount* of binary data your system intends to store. While it's nice to have all data packaged in one place, if you plan on scaling to terabytes of files, you'd be crazy to physically store them in the database itself. The filesystem locations and paths should be private to your application, meaning you treat the filesystem as an extension to the database (and thus NO ONE EVER touches the filesystem where the content resides). -Dave Ross >I have never stored actual documents in SQL Server. I have stored the name >and location and put the document into a directory on the file server. >However, a new "contracts" application I am working on is very document >heavy, mainly for storage... not much retrieval will be done. > >Currently when a new contract comes to be, a directory is created for the >contract and a slew of sub directories are also created over the life of the >contract. Sometimes the sub directories are standard across contracts and >some times they are not. Sub directories can get pretty deep in terms of >nesting. > >It seems it would be much easier (conceptually) to store the documents >directly in the database and let the structure of the database dictate the >"hierarchy" and relationships instead of creating a new directory for each >contract and trying to figure out which subdirectories are needed or already >exist, etc. > >When needed, the documents would be accessed via the application... however >this would restrict direct access to the document outside the system. >Anyway, has anyone taken the approach of storing documents directly in a SQL >DB, and if so, how was performance etc... > >Thanks! > >Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
On 2/10/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > LOLyou guys cited the same article, I guess this must be the > "definitive" answer. perhaps it is...but your question got me thinking, and I can't find anything that says that following 508 guidelines will definitely have you covered with the ADA...the ADA predated the internet, so it is fuzzy in that area. anybody know? There are also the W3C accessiblity guidelines you could look at, which I believe are generally tighter than 508...here is an article over there regarding pdf... http://www.w3.org/WAI/GL/WCAG-PDF-TECHS-20010913/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
MS Access to large at 25MB?
I received the following email from our hosting company. I have never heard of this before. Has any one? They actually disabled our account based on this. At work I am running one access database with 750MB (I know, but...) without any issues. They are claiming that it is using too much CPU resources and causing "CF ISSUES". Thanks. Hello , Our level two engineers have reviewed your database (.mdb) which now stands at 19.5MB which is too large. Our System Administrators have requested that you please reduce your database down to 7MB or less, based on the recommendations from Macromedia and Microsoft. In working with them to improve the stability and performance of our ColdFusion servers, they have informed us that MS Access databases over 7MB cause the majority of the issue we see, and Macromedia will no longer assist us in troubleshooting issues when the size is large then 7MB. If you cannot compact the database, we would ask that you move this database to MS SQL, where large databases will not cause performance issues for other users on your shared server. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
LOLyou guys cited the same article, I guess this must be the "definitive" answer. Jim Wright wrote: > I'm not sure here but does ADA Compliant = Section 508 Compliant, > because searching for information on 508 compliance gets you more > hits...here is one... > http://www.planetpdf.com/enterprise/article.asp?ContentID=6119 > > > On 2/10/06, Ray Champagne <[EMAIL PROTECTED]> wrote: >> Has anyone worked with ADA Compliant web sites? Are PDF's considered >> ADA Compliant? I seem to remember there being a PDF reader out there, >> but I can't seem to find it anywhere. >> >> I am providing an educational site with the ability to upload ed. >> resources in PDF format, but everything has to be 100% ADA compliant. >> Now I'm thinking that I'm going to have to provide them with a means to >> upload the same resource in HTML, because I can't find any evidence that >> says PDF's are OK. That's gonna suck >> >> Ray >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231982 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
Thanks, Jim, Ken. I'm going to pass these articles along and see where this takes us. At first glance they *seem* to be saying the same thing. Thanks! Ray Ken Ferguson wrote: > Ray, > > Check out this article. Maybe there's some help in there for you. I > worked on a bunch of sites that demanded 508 compliance and we were able > to use pdf files, but they had to be carefully crafted to ensure the > files were compliant. > http://www.planetpdf.com/enterprise/article.asp?ContentID=6119 > > --Ferg > > Ray Champagne wrote: >> Has anyone worked with ADA Compliant web sites? Are PDF's considered >> ADA Compliant? I seem to remember there being a PDF reader out there, >> but I can't seem to find it anywhere. >> >> I am providing an educational site with the ability to upload ed. >> resources in PDF format, but everything has to be 100% ADA compliant. >> Now I'm thinking that I'm going to have to provide them with a means to >> upload the same resource in HTML, because I can't find any evidence that >> says PDF's are OK. That's gonna suck >> >> Ray >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: parsing a list
lol oh hell I only did a "mass marketing campain" ONCE!! haha And needless to say I got more business from it than I could ever handle and am still turning business down from it. On the other hand is Will, who as usual tries to make fun of it, yet not only did Will "try" and copy what I did(no way imagine that!!!), I had to give him the code, the message and how to get the email addresses and how to do it (and i learned it from a 3rd grader). And I only did it once, Will has done it several times and still only has ONE, yes thats a big fat 1 client.. nuff said ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! From: "Bobby Hartsfield" <[EMAIL PROTECTED]> Sent: Friday, February 10, 2006 7:33 AM To: CF-Talk Subject: RE: parsing a list What does he care... he just sends spam to them anyway. ;-) ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 5:02 AM To: CF-Talk Subject: Re: parsing a list > And yes Will, I got the advil cause of u! I'm just hoping these emails you're posting 10 times apiece are all fake, cause they're gonna get scooped up by the harvesters. LOL!! :) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231980 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: parsing a list
ok it still doesnt work right. If i go to output it into db I get errors that the 3 position is empty and I still get records back like ,Sanyer,[EMAIL PROTECTED] John F,Kelly, Jr,[EMAIL PROTECTED] which of course makes it error ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! From: James Holmes <[EMAIL PROTECTED]> Sent: Friday, February 10, 2006 4:17 AM To: CF-Talk Subject: Re: parsing a list ROFL! 1) Download it 2) Join the CFAJAX mailing list 3) Ask questions there... ;-) On 2/10/06, dave wrote: > > ok now teach me cfajax real quick like!! ;) -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231979 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
Ray, Check out this article. Maybe there's some help in there for you. I worked on a bunch of sites that demanded 508 compliance and we were able to use pdf files, but they had to be carefully crafted to ensure the files were compliant. http://www.planetpdf.com/enterprise/article.asp?ContentID=6119 --Ferg Ray Champagne wrote: > Has anyone worked with ADA Compliant web sites? Are PDF's considered > ADA Compliant? I seem to remember there being a PDF reader out there, > but I can't seem to find it anywhere. > > I am providing an educational site with the ability to upload ed. > resources in PDF format, but everything has to be 100% ADA compliant. > Now I'm thinking that I'm going to have to provide them with a means to > upload the same resource in HTML, because I can't find any evidence that > says PDF's are OK. That's gonna suck > > Ray > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231978 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ADA compliance and PDF
I'm not sure here but does ADA Compliant = Section 508 Compliant, because searching for information on 508 compliance gets you more hits...here is one... http://www.planetpdf.com/enterprise/article.asp?ContentID=6119 On 2/10/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > Has anyone worked with ADA Compliant web sites? Are PDF's considered > ADA Compliant? I seem to remember there being a PDF reader out there, > but I can't seem to find it anywhere. > > I am providing an educational site with the ability to upload ed. > resources in PDF format, but everything has to be 100% ADA compliant. > Now I'm thinking that I'm going to have to provide them with a means to > upload the same resource in HTML, because I can't find any evidence that > says PDF's are OK. That's gonna suck > > Ray > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231977 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flash Chart and Javascript Menu
If you could send me a link to view your issue, I'll try to help you find a solution. Cheers, Kevin -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: February 10, 2006 7:40 AM To: CF-Talk Subject: Flash Chart and Javascript Menu Hi folks When using a flash cfchart, my javascript menu at the top of the screen is "hidden" by the chart. I have found a reference to this on Macromedia's message boards, with a post that states the answer to the problem lies here: http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=196&; threadid=1004407. However, there are problems with that page that will not allow me to view it. Does anyone here know of a work around for this, or a property on the chart I am not setting that will keep the chart "behind" the javascript menu? I had this problem with flash forms, but was able to set "wmode=transparent" to solve that problem. Is there a similar solution for flash charts? Thanks for your help Steve --- --- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231976 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
For reference, here is my user.cfc thus far: INSERT INTO users( userRole_ID, userFirstName, userLastName, userEmail, userPassword) VALUES( "#arguments.userRole_ID#", "#arguments.userFirstName#", "#arguments.userLastName#", "#arguments.userEmail#", "#arguments.userPassword#", "#arguments.userMailingList_ID#") SELECT MAX(userID) as new_userID FROM users WHERE userEmail = #arguments.userEmail# ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
Deanna Schneider wrote: > Well, you could have some object aggregation. So, for example, the user CFC > could have an instance of the newsletterManager cfc. So, if a new user is > created, and they've requested access to certain newsletters, you'd just run > the functions from within the user cfc. Or, if you instantiate a user as an > object, there should be a "getId()" function that can be called once it's > been instantiated. Then, use that id in a separate call to the newsletter > cfc. I am learning Java at my local community college and I was thinking that instantiating an object of the user.cfc might help avoid potential race conditions, but this stuff, including what you have mentioned, is a bit over my head. I would definately need some help understanding all of this. Thanks, Aaron ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
Could all of this be avoided if I just used the createUUID() function to insert a userID into my users table instead of using autonumber? I am starting this thing from scratch, so I could removed the auto_increment from the userID if I have to. I am assuming that I would then pass the UUID to both the insertUser method in the users component and the insertSubscriber method in the newsletter component. Is that correct? The waters are a little muddy for me... -Aaron On 2/10/06, Aaron Roberson <[EMAIL PROTECTED]> wrote: > Mike, > > I will look into that. I thought as long as I wrapped the insert user > query and the select user query (with the max() function) in a > cftransaction tag that I would eliminate race conditions and therefore > would return the correct userID. Is that incorrect? > > About getting the userID to the newsletter component, I am thinking > maybe I should invoke the insertUser method from within my > insertSubscriber method, but I don't know how that would work because > I am not that advanced at CFC's. > > Thanks, > Aaron > > On 2/10/06, Mike Soultanian <[EMAIL PROTECTED]> wrote: > > remember, max may not give you what you want, especially if another user > > inserts a record just in between the time when you insert your record > > and then poll for the max id. > > > > I'm not sure if mysql supports nextval (like oracle), but you might want > > to do something like this instead: > > > > http://jamesthornton.com/software/coldfusion/nextval.html > > > > enjoy, > > Mike > > > > Aaron Roberson wrote: > > > Thanks for the link! > > > > > > Actually, I do know how to get the unique ID with the MAX() function in > > > SQL. > > > > > > I guess my real question is how do I pass the unique ID from one > > > method in the users component into another method in the newsletter > > > component? Can anyone help with that? > > > > > > -Aaron > > > > > > On 2/10/06, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > > >>> I am running MySQL 4.0.25 remotely on my production server and 4.1.12 > > >>> on my local box. > > >> I can't help you with the CFC's but you mihgt look into this page for > > >> some help > > >> http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html > > >> Hatton > > >> > > >> > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231973 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
ADA compliance and PDF
Has anyone worked with ADA Compliant web sites? Are PDF's considered ADA Compliant? I seem to remember there being a PDF reader out there, but I can't seem to find it anywhere. I am providing an educational site with the ability to upload ed. resources in PDF format, but everything has to be 100% ADA compliant. Now I'm thinking that I'm going to have to provide them with a means to upload the same resource in HTML, because I can't find any evidence that says PDF's are OK. That's gonna suck Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231972 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
I'm currently working on a real estate done in RubyOnRails that stores property photos in tables. So far it doesn't seem too terribly different than mssql. On 2/10/06, Ryan Guill <[EMAIL PROTECTED]> wrote: > Has anyone done this in MySql? > > On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > We just recently set up a document management system using MS > > SqlServer. We ended up storing the documents inside the db. The way > > we structured it was to set up a table that had all of the meta data > > about the document along with a file id (int) that linked up with a > > file storage table that consisted of an id and a blob column. This > > way, we can run queries against the meta data without slowing down the > > system with large blob columns. > > > > So far, the performance has been suprisingly snappy. Also, security > > has been a lot easier to work into as we only have to secure one > > resource instead of both a database and a file system. Another > > additional benefit is that we've been able to share some documents on > > our extranet site without having to open another port for file sharing > > as all documents come from the db. > > > > > > > > On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > > I have never stored actual documents in SQL Server. I have stored the name > > > and location and put the document into a directory on the file server. > > > However, a new "contracts" application I am working on is very document > > > heavy, mainly for storage... not much retrieval will be done. > > > > > > Currently when a new contract comes to be, a directory is created for the > > > contract and a slew of sub directories are also created over the life of > > > the > > > contract. Sometimes the sub directories are standard across contracts and > > > some times they are not. Sub directories can get pretty deep in terms of > > > nesting. > > > > > > It seems it would be much easier (conceptually) to store the documents > > > directly in the database and let the structure of the database dictate the > > > "hierarchy" and relationships instead of creating a new directory for each > > > contract and trying to figure out which subdirectories are needed or > > > already > > > exist, etc. > > > > > > When needed, the documents would be accessed via the application... > > > however > > > this would restrict direct access to the document outside the system. > > > Anyway, has anyone taken the approach of storing documents directly in a > > > SQL > > > DB, and if so, how was performance etc... > > > > > > Thanks! > > > > > > Tango > > > > > > > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
Mike, I will look into that. I thought as long as I wrapped the insert user query and the select user query (with the max() function) in a cftransaction tag that I would eliminate race conditions and therefore would return the correct userID. Is that incorrect? About getting the userID to the newsletter component, I am thinking maybe I should invoke the insertUser method from within my insertSubscriber method, but I don't know how that would work because I am not that advanced at CFC's. Thanks, Aaron On 2/10/06, Mike Soultanian <[EMAIL PROTECTED]> wrote: > remember, max may not give you what you want, especially if another user > inserts a record just in between the time when you insert your record > and then poll for the max id. > > I'm not sure if mysql supports nextval (like oracle), but you might want > to do something like this instead: > > http://jamesthornton.com/software/coldfusion/nextval.html > > enjoy, > Mike > > Aaron Roberson wrote: > > Thanks for the link! > > > > Actually, I do know how to get the unique ID with the MAX() function in SQL. > > > > I guess my real question is how do I pass the unique ID from one > > method in the users component into another method in the newsletter > > component? Can anyone help with that? > > > > -Aaron > > > > On 2/10/06, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > >>> I am running MySQL 4.0.25 remotely on my production server and 4.1.12 > >>> on my local box. > >> I can't help you with the CFC's but you mihgt look into this page for some > >> help > >> http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html > >> Hatton > >> > >> > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231970 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
Well, you could have some object aggregation. So, for example, the user CFC could have an instance of the newsletterManager cfc. So, if a new user is created, and they've requested access to certain newsletters, you'd just run the functions from within the user cfc. Or, if you instantiate a user as an object, there should be a "getId()" function that can be called once it's been instantiated. Then, use that id in a separate call to the newsletter cfc. On 2/10/06, Aaron Roberson <[EMAIL PROTECTED]> wrote: > > Thanks for the link! > > Actually, I do know how to get the unique ID with the MAX() function in > SQL. > > I guess my real question is how do I pass the unique ID from one > method in the users component into another method in the newsletter > component? Can anyone help with that? > > - ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231969 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
remember, max may not give you what you want, especially if another user inserts a record just in between the time when you insert your record and then poll for the max id. I'm not sure if mysql supports nextval (like oracle), but you might want to do something like this instead: http://jamesthornton.com/software/coldfusion/nextval.html enjoy, Mike Aaron Roberson wrote: > Thanks for the link! > > Actually, I do know how to get the unique ID with the MAX() function in SQL. > > I guess my real question is how do I pass the unique ID from one > method in the users component into another method in the newsletter > component? Can anyone help with that? > > -Aaron > > On 2/10/06, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: >>> I am running MySQL 4.0.25 remotely on my production server and 4.1.12 >>> on my local box. >> I can't help you with the CFC's but you mihgt look into this page for some >> help >> http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html >> Hatton >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231968 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
Has anyone done this in MySql? On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > We just recently set up a document management system using MS > SqlServer. We ended up storing the documents inside the db. The way > we structured it was to set up a table that had all of the meta data > about the document along with a file id (int) that linked up with a > file storage table that consisted of an id and a blob column. This > way, we can run queries against the meta data without slowing down the > system with large blob columns. > > So far, the performance has been suprisingly snappy. Also, security > has been a lot easier to work into as we only have to secure one > resource instead of both a database and a file system. Another > additional benefit is that we've been able to share some documents on > our extranet site without having to open another port for file sharing > as all documents come from the db. > > > > On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > I have never stored actual documents in SQL Server. I have stored the name > > and location and put the document into a directory on the file server. > > However, a new "contracts" application I am working on is very document > > heavy, mainly for storage... not much retrieval will be done. > > > > Currently when a new contract comes to be, a directory is created for the > > contract and a slew of sub directories are also created over the life of the > > contract. Sometimes the sub directories are standard across contracts and > > some times they are not. Sub directories can get pretty deep in terms of > > nesting. > > > > It seems it would be much easier (conceptually) to store the documents > > directly in the database and let the structure of the database dictate the > > "hierarchy" and relationships instead of creating a new directory for each > > contract and trying to figure out which subdirectories are needed or already > > exist, etc. > > > > When needed, the documents would be accessed via the application... however > > this would restrict direct access to the document outside the system. > > Anyway, has anyone taken the approach of storing documents directly in a SQL > > DB, and if so, how was performance etc... > > > > Thanks! > > > > Tango > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231967 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
I would keep in mind the relative size of your database backups. Storing all of those documents as BLOBs is going to make you have a pretty large backup...and of course you want to back up the documents, too...but if the rest of the database is transactional in nature, and the documents are there more for history or reference, then having them in the database may cause unneeded strain in the case of a restore. On the other hand, having them in the database makes keeping it easy to keep everything in synch. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231966 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
We just recently set up a document management system using MS SqlServer. We ended up storing the documents inside the db. The way we structured it was to set up a table that had all of the meta data about the document along with a file id (int) that linked up with a file storage table that consisted of an id and a blob column. This way, we can run queries against the meta data without slowing down the system with large blob columns. So far, the performance has been suprisingly snappy. Also, security has been a lot easier to work into as we only have to secure one resource instead of both a database and a file system. Another additional benefit is that we've been able to share some documents on our extranet site without having to open another port for file sharing as all documents come from the db. On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > I have never stored actual documents in SQL Server. I have stored the name > and location and put the document into a directory on the file server. > However, a new "contracts" application I am working on is very document > heavy, mainly for storage... not much retrieval will be done. > > Currently when a new contract comes to be, a directory is created for the > contract and a slew of sub directories are also created over the life of the > contract. Sometimes the sub directories are standard across contracts and > some times they are not. Sub directories can get pretty deep in terms of > nesting. > > It seems it would be much easier (conceptually) to store the documents > directly in the database and let the structure of the database dictate the > "hierarchy" and relationships instead of creating a new directory for each > contract and trying to figure out which subdirectories are needed or already > exist, etc. > > When needed, the documents would be accessed via the application... however > this would restrict direct access to the document outside the system. > Anyway, has anyone taken the approach of storing documents directly in a SQL > DB, and if so, how was performance etc... > > Thanks! > > Tango > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231965 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
I agree, I was looking through the links on the lab site for Flex 2 last night and slowly working through one of the PDFs that came with it. So far I am thinking to myself things like "wonder if it could be used for task abc and if so what would I all need to have to do that" Now I have yet to go through all the videos, maybe some of those will answer my ponderings. On 2/10/06, Ian Skinner <[EMAIL PROTECTED]> wrote: > > > When I'm looking at it, I'm going "what do I need to do what I need to > do?" And some clearer, more concrete examples of application that can and > can not be done at each level would be helpful. > > My $.02 > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231964 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
While I agree with you guys that it would be nice to have a marketing push aimed at informing and exciting developers, I'm not sure that it would be a worthwhile investment on Adobe's part (or any software company's, really); at least that's how I think they see it. Developers don't spend money and, in my experience, rarely affect how it gets spent in any significant way and on what technologies an organization will use, (though many seem to mistakenly think they have a larger impact on both) . I think the developers who do end up affecting the way these decisions are taken often dig to find the information they need and are only moderately inconvenienced by any lack of available low-level information. In the end, I just don't think the marketing folks care what anyone other than the aforementioned IT Manager types think. The mindset seems, very often, to be one of: market straight to the decision maker and if you do your job right, he'll take care of the rest. Maybe I'm just rambling, but I've had this conversation with an associate a number of times about a number of different companies. I'm not speaking to whether this is negative or positive, but it does seem to be the case. Also, I know that each of you out there reading this are all the exceptions to this and have tremendous pull on your organization's decision making, so please don't feel insulted. : ) --Ferg Bryan Stevenson wrote: > preaching to the choir Rick ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231963 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT:Can't use any browsers besides IE (was Homesite external browsers)
OK, So this isnt a homesite thing this is a browsers thing. When i type the address in physically it doesnt show the web page in any browser except IE. I changed the subject just so that its understood its not a HS thing. Thanks, Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231962 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Homesite 5.5 and external browsers (one more thing)
To be honest I dont know anything about IIS. It was on XP Pro when i bought it. Would that hinder other browsers except IE to work? Phil Well, hinder might be a bit strong, but they would react differently. Only a browser with an IE core can provide the response to an integrated windows security response automatically. The others will generate a user login dialog for the user to proved login information. Which sounded like it could have been what you described. You just need to open the IIS manager, right click on the website, click on properties, and look under the directory security. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231961 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CSS formatting in cfdocument PDF
Sandra Clark wrote: > > My suggestion is not to try to make things look exact, but to aim for > creating a PDF document that is clear and readable. That's what I did in the production version of the document, I just changed the padding to 0. Works for me. I was just wondering what the heck was going on. Thanks! Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231960 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Homesite 5.5 and external browsers (one more thing)
To be honest I dont know anything about IIS. It was on XP Pro when i bought it. Would that hinder other browsers except IE to work? Phil -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 6:34 PM To: CF-Talk Subject: RE: Homesite 5.5 and external browsers (one more thing) Do you have "integrated windows" authentication set in the directory security setting of the IIS properties of the website? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231959 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
Thanks for the link! Actually, I do know how to get the unique ID with the MAX() function in SQL. I guess my real question is how do I pass the unique ID from one method in the users component into another method in the newsletter component? Can anyone help with that? -Aaron On 2/10/06, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > > I am running MySQL 4.0.25 remotely on my production server and 4.1.12 > > on my local box. > > I can't help you with the CFC's but you mihgt look into this page for some > help > http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html > Hatton > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231958 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
> I am running MySQL 4.0.25 remotely on my production server and 4.1.12 > on my local box. I can't help you with the CFC's but you mihgt look into this page for some help http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231957 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS formatting in cfdocument PDF
One other thing, if you are creating stylesheets just for PDF's, remember that in this case you are dealing with a known size (8 1/2 x 11 usually) and that you should be using absolute values. Points for font sizes, in(ches) for placement (.15in is legal). Set your body up as body { width: 8in; height: 10.5in; margin: .25in; } That will give you a 1/4 inch margin around your body when it prints. Sandy Clark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 10:31 AM To: CF-Talk Subject: Re: CSS formatting in cfdocument PDF stupid me changed the padding to 0 on the PDF and forgot to change it back so if you looked at it and it looked normal, that's my fault :) Rick Root wrote: > Take a look at this: > > http://www.it.dev.duke.edu/policy.cfm (a PDF document) > > and this: > > http://www.it.dev.duke.edu/policy.html (the HTML version) > > Both versions have 10 point padding above the ordered list list items: > > #policy ol li { > padding-top: 10px; > } > > However, in the PDF version, the padding is not applied to the bullets > (ie, the roman numericals, letters, etc) > > What's up with that? Is that a cfdocument bug? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231956 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Storing Documents
DBs are getting really good at handling large binary objects. Many large software packages store content in BLOBs. If I were you, I would plan on storing the files in a DB table. The next version of our intranet will do just that as well. It is much easier to keep things synched if you don't have to worry a file with a matching "pointer" record in a DB. M!ke -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 10:34 AM To: CF-Talk Subject: Storing Documents I have never stored actual documents in SQL Server. I have stored the name and location and put the document into a directory on the file server. However, a new "contracts" application I am working on is very document heavy, mainly for storage... not much retrieval will be done. Currently when a new contract comes to be, a directory is created for the contract and a slew of sub directories are also created over the life of the contract. Sometimes the sub directories are standard across contracts and some times they are not. Sub directories can get pretty deep in terms of nesting. It seems it would be much easier (conceptually) to store the documents directly in the database and let the structure of the database dictate the "hierarchy" and relationships instead of creating a new directory for each contract and trying to figure out which subdirectories are needed or already exist, etc. When needed, the documents would be accessed via the application... however this would restrict direct access to the document outside the system. Anyway, has anyone taken the approach of storing documents directly in a SQL DB, and if so, how was performance etc... Thanks! Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231955 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS formatting in cfdocument PDF
Its not CFDocument, its the way PDF handles CSS. For instance I can't get a to float at all. What I do (using FB makes it easy) is to set up a call to a PDF style sheet when I am sending something to a rather than the site style sheet. I'm more easily able to play around with making something look right in Acrobat than trying to get the same CSS working in both Acrobat and HTML. Trying to do the same thing in both is a losing proposition. My suggestion is not to try to make things look exact, but to aim for creating a PDF document that is clear and readable. Hope that helps Sandy Clark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 10:31 AM To: CF-Talk Subject: Re: CSS formatting in cfdocument PDF stupid me changed the padding to 0 on the PDF and forgot to change it back so if you looked at it and it looked normal, that's my fault :) Rick Root wrote: > Take a look at this: > > http://www.it.dev.duke.edu/policy.cfm (a PDF document) > > and this: > > http://www.it.dev.duke.edu/policy.html (the HTML version) > > Both versions have 10 point padding above the ordered list list items: > > #policy ol li { > padding-top: 10px; > } > > However, in the PDF version, the padding is not applied to the bullets > (ie, the roman numericals, letters, etc) > > What's up with that? Is that a cfdocument bug? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231954 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
No problem, I am running MySQL 4.0.25 remotely on my production server and 4.1.12 on my local box. I have designed part of my newsletter component, here it is thus far: INSERT INTO NewsUsers ( user_ID, newsCat_ID, newsusersActive) VALUES ( "#arguments.userID#", #arguments.newscatID#, 1) UPDATE NewsUsers ( newsusersActive) VALUES ( #newsusersActive#) WHERE user_ID = #arguments.userID# AND newscat_ID = #arguments.newscat_ID# As you can see, I added an "newusersActive" field to my NewsUsers table as well. -Aaron On 2/10/06, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > On 2/10/06, Aaron Roberson <[EMAIL PROTECTED]> wrote: > > I have three tables: Users, NewsUsers (linking table), NewsCategories > > > How do I insert a new user in the user table, retrieve the newly > > created userID and insert it into the newsUsers linking table, and > > insert the newscatID into the newsUsers linking table as well? All of > > this will be done with CFC's and I'm not sure If I should have a > > seperate CFC for users and another for newsletters. > > What database engine are you using to run this, MSSQL, MySQL, Access > or something else? The reason I ask is simple, some functions work in > some engines and not on others. > > Hatton > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231953 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help Coding Database Interactions
On 2/10/06, Aaron Roberson <[EMAIL PROTECTED]> wrote: > I have three tables: Users, NewsUsers (linking table), NewsCategories > How do I insert a new user in the user table, retrieve the newly > created userID and insert it into the newsUsers linking table, and > insert the newscatID into the newsUsers linking table as well? All of > this will be done with CFC's and I'm not sure If I should have a > seperate CFC for users and another for newsletters. What database engine are you using to run this, MSSQL, MySQL, Access or something else? The reason I ask is simple, some functions work in some engines and not on others. Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231952 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Invalid CGI variables not generating errors
Yep this is because CGI vars come from the web server, and CF will poll the server for any Cgi variables it doesn't "know" about. When you dump the CGI scope you're only seeing ones CF knows should exist, not necessarily the ones that do. For instance, on Apache you can access system environment variables using the CGI scope - CGI.systemroot on windows, for example. Requesting one that truly doesn't exist will just return an empty string, as people have noticed :) ~k -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 8:41 AM To: CF-Talk Subject: Re: Invalid CGI variables not generating errors so I guess all those instances where I verify the existence of a CGI variable are pointless! I often do this: ... Guess I can change that to ... Crazy. Rick Nathan Strutz wrote: > Yes, it's been like this for a long time. #cgi.qwertyuiop# will just > return an empty string. Why? I don't know exactly, but I do know it is > fairly expected, and only works with the CGI scope. > > -nathan strutz > http://www.dopefly.com/ > > > On 2/10/06, Rick Root <[EMAIL PROTECTED]> wrote: > >>I was having some issues solving a problem today and eventually I >>realized it was because I spelled a CGI variable. >> >>On my system (CFMX 7 on Windows), the following does not generate an >>exception, as I would think that it should: >> >>#CGI.FAHRVERNUGEN# >> >>The behavior is the same on CFMX7 for Linux and Bluedragon 6.2JX on Linux. >> >>Makes me think they planned it that way... but why? >> >>Rick >> >> > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231951 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfdocument and permission to print
On 2/10/06, Ben Forta <[EMAIL PROTECTED]> wrote: > The default is all permissions allowed. If you specify any permission then > just the specified are allowed and not others. So, specify a permission > other than allowprint and print won't be allowed. Intuitive, huh? ;-) Completely :) So looking at the list of choices, AllowPrinting AllowModifyContents AllowCopy AllowModifyAnnotations AllowFillIn AllowScreenReaders AllowAssembly AllowDegradedPrinting I'm guessing that to enable *only* viewing, that AllowScreenReaders is my best bet? All the rest seem to open cut/paste as an option. > --- Ben > > > -Original Message- > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 12:56 PM > To: CF-Talk > Subject: cfdocument and permission to print > > Folks, > > I haven't used for anything fancy and was wondering if for a > dynamically generated PDF page (well, any page) there's a way to prevent it > from being printed/saved. I see the permissions attribute for PDF, but it > seems to *allow* instead of remove behavior, though I'm unclear about the > defaults for a dynamically generated PDF. Or for Flashpaper for that matter > > I'd like something like > > > content to be viewed but not (easily) printed > > As an aside, the current "protection" for the page is a javsacript to > disable the printscreen button. Yeah. So a best attempt is fine. > > -- -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Need Help Coding Database Interactions
I have three tables: Users, NewsUsers (linking table), NewsCategories Users userID (pk) userFirst userLast userEmail userPassword NewsUsers user_ID (fk) newscat_ID (fk) NewsCategories newscatID (pk) newscatTitle How do I insert a new user in the user table, retrieve the newly created userID and insert it into the newsUsers linking table, and insert the newscatID into the newsUsers linking table as well? All of this will be done with CFC's and I'm not sure If I should have a seperate CFC for users and another for newsletters. Thanks for the Help! Aaron ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231949 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfdocument and permission to print
The default is all permissions allowed. If you specify any permission then just the specified are allowed and not others. So, specify a permission other than allowprint and print won't be allowed. Intuitive, huh? ;-) --- Ben -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 12:56 PM To: CF-Talk Subject: cfdocument and permission to print Folks, I haven't used for anything fancy and was wondering if for a dynamically generated PDF page (well, any page) there's a way to prevent it from being printed/saved. I see the permissions attribute for PDF, but it seems to *allow* instead of remove behavior, though I'm unclear about the defaults for a dynamically generated PDF. Or for Flashpaper for that matter I'd like something like content to be viewed but not (easily) printed As an aside, the current "protection" for the page is a javsacript to disable the printscreen button. Yeah. So a best attempt is fine. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231948 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
I would say store documents in the file system as you normally would and store the document heirarchy in the database. I had a similar situation while building a school content management system where different courses could have several documents, images videos etc associated with them. what we end up doing was to save every document saved with a name as UUID in one folder and let the database handle relationship among them. just my 0.02 cents On 2/10/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I have stored docs in Oracle. It simplified matters for us because we > had an enterprise-level database and a clustered server environment; > having to sync portions of the filesystem would have added unwanted > complexity to the system. > > I suppose how you store your contracts depends upon what you need to > do with them. Do users need to have regular access to them? Is it > for archival purposes? Do the docs need to be searchable? > > Since it seems like you need this more for archival purposes, I would > personally store them in the database, assuming your disk space and > backup capacity would cover it. That way, you have much tighter > control over who accesses the documents, which I would assume would be > a concern. > > You'll probably get a dozen answers on this, all different. > > Pete > > On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > I have never stored actual documents in SQL Server. I have stored the > name > > and location and put the document into a directory on the file server. > > However, a new "contracts" application I am working on is very document > > heavy, mainly for storage... not much retrieval will be done. > > > > Currently when a new contract comes to be, a directory is created for > the > > contract and a slew of sub directories are also created over the life of > the > > contract. Sometimes the sub directories are standard across contracts > and > > some times they are not. Sub directories can get pretty deep in terms of > > nesting. > > > > It seems it would be much easier (conceptually) to store the documents > > directly in the database and let the structure of the database dictate > the > > "hierarchy" and relationships instead of creating a new directory for > each > > contract and trying to figure out which subdirectories are needed or > already > > exist, etc. > > > > When needed, the documents would be accessed via the application... > however > > this would restrict direct access to the document outside the system. > > Anyway, has anyone taken the approach of storing documents directly in a > SQL > > DB, and if so, how was performance etc... > > > > Thanks! > > > > Tango > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231947 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfdocument and permission to print
Folks, I haven't used for anything fancy and was wondering if for a dynamically generated PDF page (well, any page) there's a way to prevent it from being printed/saved. I see the permissions attribute for PDF, but it seems to *allow* instead of remove behavior, though I'm unclear about the defaults for a dynamically generated PDF. Or for Flashpaper for that matter I'd like something like content to be viewed but not (easily) printed As an aside, the current "protection" for the page is a javsacript to disable the printscreen button. Yeah. So a best attempt is fine. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231946 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
preaching to the choir Rick ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231945 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Adobe should create demand for "what a product can do" not for "the product" and market to everyone who has impact on the use and benefits of the projects it be used for...IT managers, et al, who will want to know what the end results of its use will be, and developers who want to know what it takes to get the end results... Rick Especially since we are talking about a marketing website, it should be very easy to have a "for IT managers" section and a "for developers" section. Probably in more "marketing" type language. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Well...that's a great weakness in marketing...imho... I'm meeting with a client to advise him on his website and marketing through it and email and one of my questions will be...who is your current marketing target? Businesses? Consumers? And my advice will be to market as much as possible to both. Adobe should create demand for "what a product can do" not for "the product" and market to everyone who has impact on the use and benefits of the projects it be used for...IT managers, et al, who will want to know what the end results of its use will be, and developers who want to know what it takes to get the end results... Rick > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 12:37 PM > To: CF-Talk > Subject: Re: OT: ColdFusion and Flex > > > > The whole "Flex" message right now just seems like a hard sell > for something > > that nobody has convinced me that I need. > > > > Sure. It's sweet. Looks cool. But like I said, the website and > the "message" > > are really just hyper-filled with marketing, and not enough > meat for me to > > sink my teeth into. > > I feel your pain Jeff ;-) > > but I ask. > > Do you think they are marketing to developers or IT managers on > up the food > chain? I'd say IT managers et al.and we all know that IT > managers et al do > not care as much about the "meat" as we dothey are sold more > on promises of > greatness as opposed to concrete info IMHO. > > Trying to add some Friday Focus... > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231943 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
I have stored docs in Oracle. It simplified matters for us because we had an enterprise-level database and a clustered server environment; having to sync portions of the filesystem would have added unwanted complexity to the system. I suppose how you store your contracts depends upon what you need to do with them. Do users need to have regular access to them? Is it for archival purposes? Do the docs need to be searchable? Since it seems like you need this more for archival purposes, I would personally store them in the database, assuming your disk space and backup capacity would cover it. That way, you have much tighter control over who accesses the documents, which I would assume would be a concern. You'll probably get a dozen answers on this, all different. Pete On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > I have never stored actual documents in SQL Server. I have stored the name > and location and put the document into a directory on the file server. > However, a new "contracts" application I am working on is very document > heavy, mainly for storage... not much retrieval will be done. > > Currently when a new contract comes to be, a directory is created for the > contract and a slew of sub directories are also created over the life of the > contract. Sometimes the sub directories are standard across contracts and > some times they are not. Sub directories can get pretty deep in terms of > nesting. > > It seems it would be much easier (conceptually) to store the documents > directly in the database and let the structure of the database dictate the > "hierarchy" and relationships instead of creating a new directory for each > contract and trying to figure out which subdirectories are needed or already > exist, etc. > > When needed, the documents would be accessed via the application... however > this would restrict direct access to the document outside the system. > Anyway, has anyone taken the approach of storing documents directly in a SQL > DB, and if so, how was performance etc... > > Thanks! > > Tango > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231942 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
> The whole "Flex" message right now just seems like a hard sell for something > that nobody has convinced me that I need. > > Sure. It's sweet. Looks cool. But like I said, the website and the "message" > are really just hyper-filled with marketing, and not enough meat for me to > sink my teeth into. I feel your pain Jeff ;-) but I ask. Do you think they are marketing to developers or IT managers on up the food chain? I'd say IT managers et al.and we all know that IT managers et al do not care as much about the "meat" as we dothey are sold more on promises of greatness as opposed to concrete info IMHO. Trying to add some Friday Focus... Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231941 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ColdFusion and Flex
I'm in 100% agreement with both. It's not that the message isn't "getting out there". It's "what the heck is this, and what do I need in order to do this stuff, and how do I proceed going forward if I'm a CF developer who's interested in following this?" The whole "Flex" message right now just seems like a hard sell for something that nobody has convinced me that I need. Sure. It's sweet. Looks cool. But like I said, the website and the "message" are really just hyper-filled with marketing, and not enough meat for me to sink my teeth into. > Here! Here! > > Show me the goods! > > (Not the goods Adobe will make money on, > but the goods that I can make money on!) > > btw...I went to the labs site and couldn't even > get the example apps to show...could be a problem > on my end however...but don't see why... > > Rick > > > > Clearly a lot of people aren't seeing the messages so I'd be > > > interested to hear opinions as to why this message isn't getting > > > out there... > > > > > > One thing that might help with folks like me, are some more > > concrete examples. Looking at Sean's post here, he used language > > like "most" application would not need the full Flex server and > > such. But what does "most" mean? > > > > When I'm looking at it, I'm going "what do I need to do what I > > need to do?" And some clearer, more concrete examples of > > application that can and can not be done at each level would be helpful. > > > > My $.02 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231940 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Finding empty locations
Can you reconfigure your database to contain all three addresses? So each product is listed as being on 3.15.7 or 1.2.78? -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 10:04 AM To: CF-Talk Subject: Finding empty locations Our warehouse has stock arranged in a way that makes it very easy to find. If I ask someone to get the title from 03.28.07 they just have to go to isle 3 then walk down it to bay 28 and get the product from shelf 7. Simple. I now need to write a query that can tell me where in the warehouse there is an empty location and this is more complex than it should be. The only way I can think is to have three nested loops (one for each of isle, bay and shelf) to generate a location and then query the database to see if there is any stock in it. The problem is that this could easily lead to thousands of queries being run and that is going to cause performance problems. IE: SELECT * FROM Stock WHERE location = #location# Can anyone think of a better way? -- Jay ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231939 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Here! Here! Show me the goods! (Not the goods Adobe will make money on, but the goods that I can make money on!) btw...I went to the labs site and couldn't even get the example apps to show...could be a problem on my end however...but don't see why... Rick > -Original Message- > From: Ian Skinner [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 12:05 PM > To: CF-Talk > Subject: RE: OT: ColdFusion and Flex > > > > Clearly a lot of people aren't seeing the messages so I'd be > interested to hear opinions as to why this message isn't getting > out there... > > > One thing that might help with folks like me, are some more > concrete examples. Looking at Sean's post here, he used language > like "most" application would not need the full Flex server and > such. But what does "most" mean? > > When I'm looking at it, I'm going "what do I need to do what I > need to do?" And some clearer, more concrete examples of > application that can and can not be done at each level would be helpful. > > My $.02 > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > - > | 1 | | > - Binary Soduko > | | | > - > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231938 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Clearly a lot of people aren't seeing the messages so I'd be interested to hear opinions as to why this message isn't getting out there... One thing that might help with folks like me, are some more concrete examples. Looking at Sean's post here, he used language like "most" application would not need the full Flex server and such. But what does "most" mean? When I'm looking at it, I'm going "what do I need to do what I need to do?" And some clearer, more concrete examples of application that can and can not be done at each level would be helpful. My $.02 -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231937 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Finding empty locations
I have considered this. There may be empty locations referenced in the database with 0 stock values for old sold out products so the query would need modifying a little to more like... SELECT l.locationName FROM locations l LEFT JOIN stock s ON (l.locationName = s.location) GROUP BY locationName HAVING if(isnull(sum(s.stock)),0,sum(s.stock)) = 0 I really wanted to avoid having a table full of locations though. This is still the lesser of two evils though compared to 3 nested loops! > James, > Sometimes you can make use of a reference table to do > something like this...you can populate it with your nested > loop initially (you should only need to change this table if > something about your warehouse layout changes), but then just > do the query as a join... > > SELECT a.* FROM StockLocations a LEFT JOIN Stock b ON > a.location = b.location WHERE b.location IS NULL -jim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231936 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Storing Documents
I recommend storing each contract in its own directory, as you might have had it until now, and let the database be used for organizing the metadata (including hierarchy stuff) on top of the file system. Then you leverage the best of both worlds. That's my $0.02 dov -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 11:34 AM To: CF-Talk Subject: Storing Documents I have never stored actual documents in SQL Server. I have stored the name and location and put the document into a directory on the file server. However, a new "contracts" application I am working on is very document heavy, mainly for storage... not much retrieval will be done. Currently when a new contract comes to be, a directory is created for the contract and a slew of sub directories are also created over the life of the contract. Sometimes the sub directories are standard across contracts and some times they are not. Sub directories can get pretty deep in terms of nesting. It seems it would be much easier (conceptually) to store the documents directly in the database and let the structure of the database dictate the "hierarchy" and relationships instead of creating a new directory for each contract and trying to figure out which subdirectories are needed or already exist, etc. When needed, the documents would be accessed via the application... however this would restrict direct access to the document outside the system. Anyway, has anyone taken the approach of storing documents directly in a SQL DB, and if so, how was performance etc... Thanks! Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PDF forms and barcodes
> Bryan, > > Yep, I am still trying to get my hands around the various Adobe products and > their flavors, but I think this is what you want: > http://www.adobe.com/products/server/barcodedpaperforms/indepth.html > > You can create a 2d barcode that contains the XML associated with the data > in a form. As a user moves from field to field in a form making changes, > you'll see the barcode change. And when done you can scan the barcode to > extract the data. > > --- Ben Thanks Benyou are once again living up to your rep ;-)!! Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231934 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Invalid CGI variables not generating errors
so I guess all those instances where I verify the existence of a CGI variable are pointless! I often do this: ... Guess I can change that to ... Crazy. Rick Nathan Strutz wrote: > Yes, it's been like this for a long time. #cgi.qwertyuiop# will just > return an empty string. Why? I don't know exactly, but I do know it is > fairly expected, and only works with the CGI scope. > > -nathan strutz > http://www.dopefly.com/ > > > On 2/10/06, Rick Root <[EMAIL PROTECTED]> wrote: > >>I was having some issues solving a problem today and eventually I >>realized it was because I spelled a CGI variable. >> >>On my system (CFMX 7 on Windows), the following does not generate an >>exception, as I would think that it should: >> >>#CGI.FAHRVERNUGEN# >> >>The behavior is the same on CFMX7 for Linux and Bluedragon 6.2JX on Linux. >> >>Makes me think they planned it that way... but why? >> >>Rick >> >> > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231933 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfschedule
This is the first time I've used cfschedule. I'm in a shared hosting environment so I can do very little checking to see if I did this right or whatever the problem might be. I'm creating a new scheduled task. I can create it using update, but I cannot run it. When I run it, I receive the error, "Connection Failure: Status code unavailable" but when I update it (which in this case creates it), I receive no error. I just want it to run another file that does a batch up updates. Also, if I create it using update, will it just run or do I have to do a run command? When my shared host server goes down will it clear out the tasks and if so I have to 'update' it again? I want this to run once immediately and then at midnight each night. thanks for any help! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231932 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Storing Documents
I have never stored actual documents in SQL Server. I have stored the name and location and put the document into a directory on the file server. However, a new "contracts" application I am working on is very document heavy, mainly for storage... not much retrieval will be done. Currently when a new contract comes to be, a directory is created for the contract and a slew of sub directories are also created over the life of the contract. Sometimes the sub directories are standard across contracts and some times they are not. Sub directories can get pretty deep in terms of nesting. It seems it would be much easier (conceptually) to store the documents directly in the database and let the structure of the database dictate the "hierarchy" and relationships instead of creating a new directory for each contract and trying to figure out which subdirectories are needed or already exist, etc. When needed, the documents would be accessed via the application... however this would restrict direct access to the document outside the system. Anyway, has anyone taken the approach of storing documents directly in a SQL DB, and if so, how was performance etc... Thanks! Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231931 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Invalid CGI variables not generating errors
Yes, it's been like this for a long time. #cgi.qwertyuiop# will just return an empty string. Why? I don't know exactly, but I do know it is fairly expected, and only works with the CGI scope. -nathan strutz http://www.dopefly.com/ On 2/10/06, Rick Root <[EMAIL PROTECTED]> wrote: > I was having some issues solving a problem today and eventually I > realized it was because I spelled a CGI variable. > > On my system (CFMX 7 on Windows), the following does not generate an > exception, as I would think that it should: > > #CGI.FAHRVERNUGEN# > > The behavior is the same on CFMX7 for Linux and Bluedragon 6.2JX on Linux. > > Makes me think they planned it that way... but why? > > Rick > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231930 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Finding empty locations
In the database create a table for Isle, Bay, Shelf, and Product. Isle_ID Isle_Status Bay_ID Isle_ID Bay_Status Shelf_ID Bay_ID Shelf_Status Product_ID Shelf_ID Populate those tables with rows for every possible Isle,Bay, and shelf in the warehouse. Then you can do a single query: SELECT Isle_ID, Bay_ID,Product_ID FROM Isle I,Bay B,Shelf S WHERE 0=0 AND I.Isle_ID=B.Isle_ID AND S.Bay_ID=B.Bay_ID AND Shelf_ID NOT IN ( SELECT Distinct Shelf_ID FROM Product ) -Brandon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 8:04 AM To: CF-Talk Subject: Finding empty locations Our warehouse has stock arranged in a way that makes it very easy to find. If I ask someone to get the title from 03.28.07 they just have to go to isle 3 then walk down it to bay 28 and get the product from shelf 7. Simple. I now need to write a query that can tell me where in the warehouse there is an empty location and this is more complex than it should be. The only way I can think is to have three nested loops (one for each of isle, bay and shelf) to generate a location and then query the database to see if there is any stock in it. The problem is that this could easily lead to thousands of queries being run and that is going to cause performance problems. IE: SELECT * FROM Stock WHERE location = #location# Can anyone think of a better way? -- Jay ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231929 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Finding empty locations
James, Sometimes you can make use of a reference table to do something like this...you can populate it with your nested loop initially (you should only need to change this table if something about your warehouse layout changes), but then just do the query as a join... SELECT a.* FROM StockLocations a LEFT JOIN Stock b ON a.location = b.location WHERE b.location IS NULL -jim On 2/10/06, James Smith <[EMAIL PROTECTED]> wrote: > Our warehouse has stock arranged in a way that makes it very easy to find. > If I ask someone to get the title from 03.28.07 they just have to go to isle > 3 then walk down it to bay 28 and get the product from shelf 7. Simple. > > I now need to write a query that can tell me where in the warehouse there is > an empty location and this is more complex than it should be. The only way > I can think is to have three nested loops (one for each of isle, bay and > shelf) to generate a location and then query the database to see if there is > any stock in it. The problem is that this could easily lead to thousands of > queries being run and that is going to cause performance problems. > > IE: > > > > > > > SELECT * FROM Stock WHERE location = #location# > > > > > > Can anyone think of a better way? > > -- > Jay > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231928 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Finding empty locations
Whats in the database if theres no stock at a location? No record for that location? select distinct location from stock There is no stock at #location# -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 10 February 2006 16:04 To: CF-Talk Subject: Finding empty locations Our warehouse has stock arranged in a way that makes it very easy to find. If I ask someone to get the title from 03.28.07 they just have to go to isle 3 then walk down it to bay 28 and get the product from shelf 7. Simple. I now need to write a query that can tell me where in the warehouse there is an empty location and this is more complex than it should be. The only way I can think is to have three nested loops (one for each of isle, bay and shelf) to generate a location and then query the database to see if there is any stock in it. The problem is that this could easily lead to thousands of queries being run and that is going to cause performance problems. IE: SELECT * FROM Stock WHERE location = #location# Can anyone think of a better way? -- Jay ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231927 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54