Re: OT SQL Server (OK 1 More ?)
That means 4 bytes. This will limit the number but more like around 30,000. I don't remember the exact number, anyone...? Derek - Original Message - From: "ibtoad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 13, 2001 9:32 AM Subject: RE: OT SQL Server (OK 1 More ?) > OK I got it. Now that I have the primary key set with datatype int, the > length is limited to 4. Is this correct and will this limit the table to > records? > > Thanks, > Rich > > -Original Message- > From: Craig Bowes [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 13, 2001 11:30 AM > To: CF-Talk > Subject: RE: OT SQL Server > > > You must set a field to be identity and not null. You can set its seed to > any number (start autonumbering at 1000 for example.) > > -Original Message- > From: ibtoad [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 13, 2001 9:37 AM > To: CF-Talk > Subject: OT SQL Server > > I have a simple question. How do you set the primary key field to > autonumber in SQL server? I have always used Access where this is a choice > but don't see how to do it with SQL Server 2000. > > Thanks, > Rich > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Mass mailing (typo corrections)
I am doing a project that is pretty much the same thing right now. The concerns I had about cfmail was that it serializes the mail queue so only one mail can go out at a time. That would not work for me because I'm sending out ten's of thousands of records. The other issue I have is that this is a service that we plan on selling to many of our clients so I wanted something quick and robust. This is not cfmail. The last real issue I had was deciding on what else to use if it wasn't going to be cfmail. I didn't want to use the aspmail stuff or the infusion products because they are so slanted towards either asp or cf. I chose to write the query and database login info to an xml file. Then I have a scheduled task that runs every couple minutes and calls a script. This script checks a text file that is also written along with the xml file. The text file holds the path of the xml file. If the text file has any entries then the script opens a network connection straight to my pickup queue for my exchange server and then calls a COM component that I'm still writing. The com component parses the xml file to get the database info, runs the query to get the email addresses then starts building smtp files that I send to the pickup folder for Exchange. I can also set the amount of files to send per xml file. This is the best that I could come up with. I can use this now with whatever language I want or even call it directly from other applications. As I said, I'm not quite done yet though! This is kind of an extreme example but necessary for what my company wanted to get out of the app. Derek - Original Message - From: "Jeff Green" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 3:33 PM Subject: RE: Mass mailing (typo corrections) > > Sorry all some typos :) here it is again > > Hi all, > > Im working on a project that is going to be sending mass emails, of an opt > in > list (so its not Spam, its requested Spam :). And im having concerns about > the reliability of cfmail. If anyone could post any experiences with > good/bad, fixes, workarounds, tags more reliable, basically anything that > has to do with mass emailing. > > Personally I haven't had any troubles with fail, but I haven't really tested > it with mass emailing either, so any insight is appreciated. > > TIA, > Jeff > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: setting values
Hey Ken, One good way to do this is instead of using an if...elseif...else for all 6 prices based on a,b,etc stick a little code at the top of your page to convert a, b, etc to a price. Like: select price from prices <...etc for a => whatever> You might still have to do some ifs but you will only have to do it once instead of again and again for every record. I think this is the jist of what you were asking, right? Let me know if you need some more code! Derek - Original Message - From: "Ken Ketsdever" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 18, 2001 6:31 PM Subject: setting values > Friday, May 18, 2001 5:14 PM > > > > I have a table that is dynamically populated from a db to show the item > number, description, price and image of products. > > Although there are several hundred items there are only about 6 prices. > > Rather than inputting the price of each item into the database, I would > prefer to put a letter designation then set the letter to equal a price. so > that when prices change I only have to reset the price once per price versus > changing all the prices in my database. > > I am pulling out #price# from a query. > > if I use prices as a , b, c, d, ... > > can I use some sort of set function to establish prices to be displayed > > so if an item has a price code of "a" in the database it will display $22.00 > > if it is "b" then it will display $26.00 > > etc... > Or does this need to be done via a cfif statement and if so how would I do > it > > > Thank you for any help you can provide > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dynamic form fields
Cami, I use the FORM structure that ColdFusion creates automatically when using forms. This is a structure that you can test to see if the appropriate name/value pairs are there. If you want a better explanation I can email you a copy of a presentation I gave at my local CFUG about processing dynamic forms. HTH, Derek - Original Message - From: "Cami Lawson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2001 1:55 PM Subject: Dynamic form fields > I have created a form and used names that are created dynamically based on > the SQL. How can I reference these forms on a processing page? > > > > > TIA, > cami > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Server 2000
Hello! I am in the process of planning my upgrade to SQL Server 2000 from SQL Server 7.0. I was wondering if anyone has noticed anything odd or difficult in respect to ColdFusion (4.5 and 5.0RC)? Any advice or even things you've noticed would be extremely helpful. Thanks, Derek Hamilton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Single User Mode
I was having this problem also and someone on a newsgroup said it might have something to do with having a maintenance plan that is trying to fix small problems (don't remember the exact terminology used with the maintenance plan but it's like the second or third window). I unchecked that option and never had the problem again. I also heard that it is a bug that was fixed in sp3. Do you have that installed? I didn't at the time but now do. Good luck! Derek - Original Message - From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 08, 2001 10:57 AM Subject: SQL 7.0 Single User Mode > Does any one know why a SQL 7.0 database would continually go into single > user mode? > > Brook Davies > Maracasmedia Inc. > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio and UltraDev Merging!
I hope this means that either they are just bundled (agreed that the language is a little unclear about this). But if they are actually merging, will we still be able to just purchase CF Studio if that is all we want? I've used Ultradev and frankly have no use for it. Derek - Original Message - From: "Stephen Moretti" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 03, 2001 10:34 AM Subject: RE: CF Studio and UltraDev Merging! > I'll say what I just said on the UK CFUG dev/chat list. > > > > > Read This: > > http://www.allaire.com/products/ColdFusion/productinformation/tools.cfm > > > > No where in that article does it say that it is one product. > > They are just packaged together in one box. > > Regards > > Stephen > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Search Engine
I was wondering if anyone has had a good experience with any search engine software for the Win2000 environment. We currently run Phantom on a MAC but that is dying a very quick death. TIA, Derek Hamilton Systems Developer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is CF still relevant?
I do agree with you on the bugs/fixes issue. In fact I have been testing CF 5.0b3 recently and found out that a custom tag we wrote does not work correctly with 5.0. If we can't get that tag to work that will be a big deal for us. But I have to rely on Allaire only because of the cfx environment and CF's processing. (I know, it could be written as a COM component but that wasn't my decision). My question is, are you trying to rationalize some other decision or something and just using CF for the mental validation? What's up? What are you doing that CF doesn't excel at as much as you would like? Derek Hamilton Systems Developer - Original Message - From: "Joseph Grossberg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 2:31 PM Subject: Re: Is CF still relevant? > You brought up and interesting point, and Neo will be a big boost to CF, > IMHO, and I'll be psyched when it arrives. But if someone knows Java, why > not just use JRun at that point? Also, Allaire doesn't seem to have a > concrete date for CF Server 5 release, much less Neo (a.k.a. version 6). > > However, while I think that some additional stuff CF does is good (e.g. > integration with Flash; I think the MM/Allaire merger is very > complimentary), it seems like it's just way behind on other things. I mean, > even Perl programmers can use OOP and XML if they want to, but it's not > necessary. With CF, you don't even have that option. ColdFusion just seems > like it's always a step (or more) behind the competing technologies. > > I also don't like the fact that we're basically depending on one vendor for > everything except a smattering of custom tags and minor third-party > applications. If something in Perl or Python doesn't work, someone fixes it > soon. If something in ASP or Java doesn't work, then MS or Sun fixes it (or > another company will sell it, because the market is large enough). But since > Allaire is solely responsible for CF Studio, CF Server, Spectra, JRun, etc., > it seems like we're putting all our eggs in one basket. Like, "Oh, your > upgrade to CF Server 4.5 broke your CFHTTP / CFFTP / CFMAIL tag? Well you > have to downgrade to 4.0 or just wait ... until ... whenever we finally > release 5.0 ... assuming it's fixed then." > > Like I said, I think CF has its plusses and minuses, but it just seems less > compelling to me by the month. > > Joe > > > >From: "Derek Hamilton" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: Re: Is CF still relevant? > >Date: Fri, 20 Apr 2001 13:40:36 -0700 > > > >A couple thoughts... > > > >Don't you think Neo/Java will enable CF to pull in other developers and let > >those of us that know Java expand what we would typically do with CF? > >Also, > >don't you think that Allaire now being Macromedia will enhance it's staying > >power and entice more developers to learn CF? > > > >At our company we use CF because it is fast to develop with. No other > >language we've found has been so fast AND powerful. > > > >Derek Hamilton > >Systems Developer > > > > > >- Original Message - > >From: "Joseph Grossberg" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Friday, April 20, 2001 12:27 PM > >Subject: Is CF still relevant? > > > > > > > Now, before you dismiss this as a troll, please let me elaborate. This > >isn't > > > so much an instigation or a whine as it is a call for us to take a step > >back > > > and reevalutate things periodically. > > > > > > Over the course of my career as a web programmer/developer, I have > >worked > > > with a variety of sever-side languages and technologies: ColdFusion, > >ASP, > > > JSP, PHP, Perl and Python. I like some more than others, but I'm not an > > > evangelist for any; they each have their uses. And I recognize some of > >CF's > > > strengths: easy to learn for people who know only tag-based HTML or > >don't > > > have significant programming experience; built-in admin tool; > >specialized > > > editor; comes with pre-built tags and web-based administrator. There are > > > also major flaws: broken/sketchy tags; no XML parsing; not OOP; > >relatively > > > small community; etc. > > > > > > Right now, I work at a web development firm that is primarily "a CF > >house" >
Re: Is CF still relevant?
A couple thoughts... Don't you think Neo/Java will enable CF to pull in other developers and let those of us that know Java expand what we would typically do with CF? Also, don't you think that Allaire now being Macromedia will enhance it's staying power and entice more developers to learn CF? At our company we use CF because it is fast to develop with. No other language we've found has been so fast AND powerful. Derek Hamilton Systems Developer - Original Message - From: "Joseph Grossberg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 12:27 PM Subject: Is CF still relevant? > Now, before you dismiss this as a troll, please let me elaborate. This isn't > so much an instigation or a whine as it is a call for us to take a step back > and reevalutate things periodically. > > Over the course of my career as a web programmer/developer, I have worked > with a variety of sever-side languages and technologies: ColdFusion, ASP, > JSP, PHP, Perl and Python. I like some more than others, but I'm not an > evangelist for any; they each have their uses. And I recognize some of CF's > strengths: easy to learn for people who know only tag-based HTML or don't > have significant programming experience; built-in admin tool; specialized > editor; comes with pre-built tags and web-based administrator. There are > also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively > small community; etc. > > Right now, I work at a web development firm that is primarily "a CF house" > (besides me). Our more senior programmers are looking at honing their CF > skills, while our less experienced webmasters are trying to learn > ColdFusion. But, I can't help but wonder whether they are wasting their > time. Would they be better off spending their time learning ASP, Java or > another non-CF solution? Why or why not? > > And how would we tell if and when it was time to give up CF and try > something else, as all but the most stubborn experts in also-ran languages > (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems > (Amiga) have resignedly done? > > Lastly, why do *you* still use CF? Is it because it's what you're best at, > and you don't want to try something new (where, temporarily, you'd be a > novice again)? Is it because your ccompany's legacy code is all in CF? Is it > because you genuinely think that ColdFusion is, generally speaking, the best > solution for web application development in 2001? > > Joe > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists