CFSTAT on NT
Guys, Is it possible to get CFSTAT to output to a file? I have tried: cfstat -n 1 cfstat.txt and it creates and empty text file. Any Ideas? Can you send any replies to me directly and to the list as i'm on the digest. Cheers --- Kev McCabe Intranet Team Leader Telephone: +44 (0) 20 7941 5502 Mobile: +44 (0) 7711 172 730 Mobex: 123 5502 --- ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT SQL Server
INT/NOT NULL/IDENTITY ~Simon Simon Horwith Macromedia Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 10: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
OT - Access Count() question
I'm implementing Joe Celko's nested set functionality to store an employee tree...the wrinkle is that I have several trees (representing different companies) stored in the same table...with a companyID identifier. Everything works great except for the count(*) included with each rowit's not coming up the way it should, and I'm not even sure exactly how it's messing up - some people who are on level 1 are listed at level 7, some at level 2, etc. I can't figure the pattern. (Here's my query) cfquery datasource=#dsn# name=get select child.userID, child.username, count(*) as thislevel, child.leftno, child.rightno from salesroles as parent, salesroles as child where child.companyID = #companyID# and child.leftno between parent.leftno and parent.rightno group by child.leftno, child.userID, child.username, child.rightno /cfquery (DB is currently in Access, but will move to SQL 2000 within a week - assuming I get it to work - so any wrinkles that differ between them would also be a great help.) I'm lostany help would be greatly appreciated! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long ~~ 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: Comparing value against a list of values
Let me get this right... You want to do a SQL list contains function on a field with a comma delimited list of values (csvList)? You want to return all the records that contain the value 1 (not 100 or 11) in a field (csvList) that contains comma delimited lists? Correct? I don't think that can be done in simple SQL. Maybe with a bit of SQL Magic. If anyone knows how to do this I would be very very interested! As a work around you could break your csvList field off to a relational table. Each value in the comma delimited list would get its own record with an id of the parent record. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 10:01 AM To: CF-Talk Subject: RE: Comparing value against a list of values Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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[2]: Re:Verity SQL
Michael, Hmmm... I think you may be right - however, the onthefly collection is not aptly named because in fact, the collection is just refreshed (based on the SQL query) every night and unless the db has been significantly modified, there's no reason to refesh it again throughout the day. As for maintaining it, couldn't I just have all the code for refreshing in some page that gets HTTP requested in Administrator's scheduled tasks? -J Reply Separator Subject:Re: Re:Verity SQL Author: [EMAIL PROTECTED] Date: 6/13/01 6:52 PM Won't work with multiple users seaching on the same time because of the collection on the fly creation latency - both trying to use OntheFlyCollection which is alright (for the first user) at second number 1 but it's not updated for second user (or first user, depending who run what and where first...) but If you can create a collection that will sure to be unique, again - ontheflyCollection, it might work, but will involve some major maintance.. again, I personally don't see any point nor success to this. Thanks, Michael - Original Message - From: Jason Blum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 4:52 PM Subject: Re:Verity SQL Steve! Finally something I can contribute to this wonderful list! I am in fact working right now on the code to do just this. I am assuming you already have a Verity collection with SomeName. Then you need to make a kind of on-the-fly collection out of a normal db query and call it Dbquery So on the search page, here is your Dbquery: !--Retrieve data from Db for onthefly collection-- cfquery name=GetSomeData datasource=YourDatasource SELECT Field1, Field2, Field3, Field4 FROM SomeTable /cfquery !-- Now convert this data into a collectionto be queried with GetResults next page-- CFINDEX ACTION=refresh COLLECTION=OntheFlyCollection KEY=Field1 URL=Field2 TYPE=custom TITLE=Field3 BODY=Field4 QUERY=GetSomeData Then on the search results page, cfsearch name = GetResults collection = SomeCollection, OntheFlyCollection criteria = #Form.Criteria# And that's it. Two things to note, you actually have to create a collection called OntheFlyCollection first, so that you can be refreshing it here on the search page. Also, notice that in the CFINDEX you are telling Verity which fields should be considered what Verity values, so Field2 is your URL for instance - kind of limiting, but don't forget you can make two custom tags! HOpe this helps - got it all from p.733 of Forta and http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm -Jason ___Reply Separator Subject:Verity SQL Author: [EMAIL PROTECTED] Date: 6/13/01 4:00 PM Is there any way to combine the results of a CFSEARCH and a standard SQL search into the same CFOUTPUT ... basically merge two queries? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSearch
How do I set it CF's Search using Verity for our Intranet site independent of our Internet search page? How would it access only files pertaining to the Intranet directory and not the Internet site. Thanks. Robert O. Webteam HWW ~~ 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: Verity SQL
Assuming we're talking about searching a database here, what I did (before I went to SQL Server Full Text) was to perform the Verity search to find a list of IDs whose records matched the Verity Search query, and then perform a standard SQL search, a la: CFQUERY ... standard SQL statements here WHERE ID IN (ValueList.VerityQueryName.IDcolumn) /CFQUERY to match the SQL requirements. It was not as fast as SQL7 full text on the same data. (Don't know about CF5 K2) best, paul At 06:48 PM 6/13/01 +0200, you wrote: Even if there would, It'll be inefficient because in order to use CFSEARCH you will need to rebuild the Verity Index to match the last SQL query, but if you don't plan to change the original SQL content (i.e - the first query result set) - you absolutly can do it. just create a new collection and index the result set - I think the whole process is called search... ;-) Thanks, Michael - Original Message - From: Steve Vosloo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 4:00 PM Subject: Verity SQL Is there any way to combine the results of a CFSEARCH and a standard SQL search into the same CFOUTPUT ... basically merge two queries? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:RE: Verity SQL
Hmmm... I don't know - because I have been able to do just what you are describing. My first suspicion is whether you are accidentally refreshing a different collection than that which you are searching? (Don't get me wrong - this is just what I did last week and spent all day mystified by it) The other two things I am thinking are did you just add data to existing columns or did you perhaps create a new column and then not tell CFINDEX about it or what to do with it? And then the third thought is are you joining tables? - because there was something in the book about indexing data from two tables which have a master-servant relationship (I know the word is not servant - just can't remember) -J Reply Separator Subject:RE: Verity SQL Author: [EMAIL PROTECTED] Date: 6/13/01 6:03 PM Hi Jason, Thanks for the help. This is a great solution - which I've already tried (also from pg 733 :-) ... but to no avail. Basically, I've inherited a database from an existing site and when I index the data everything works fine. Then when I add new records and re-index, they are not included. The query that I use to get the data I want to index has been tried in SQL query analyzer, and the new records show up - so they *should* be included in the indexing. I've tried absolutely everything - but nothing seems to work. So now I'm trying to combine my standard SQL query with another Verity query, without having to create a Verity collection from the database query. Dave Watts has suggested building a query object using the CF query functions, and populating the query by looping over the two source queries - but as he suggested, this may be too slow. DOH! -Original Message- From: Jason Blum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 4:52 PM To: CF-Talk Subject: Re:Verity SQL Steve! Finally something I can contribute to this wonderful list! I am in fact working right now on the code to do just this. I am assuming you already have a Verity collection with SomeName. Then you need to make a kind of on-the-fly collection out of a normal db query and call it Dbquery So on the search page, here is your Dbquery: !--Retrieve data from Db for onthefly collection-- cfquery name=GetSomeData datasource=YourDatasource SELECT Field1, Field2, Field3, Field4 FROM SomeTable /cfquery !-- Now convert this data into a collectionto be queried with GetResults next page-- CFINDEX ACTION=refresh COLLECTION=OntheFlyCollection KEY=Field1 URL=Field2 TYPE=custom TITLE=Field3 BODY=Field4 QUERY=GetSomeData Then on the search results page, cfsearch name = GetResults collection = SomeCollection, OntheFlyCollection criteria = #Form.Criteria# And that's it. Two things to note, you actually have to create a collection called OntheFlyCollection first, so that you can be refreshing it here on the search page. Also, notice that in the CFINDEX you are telling Verity which fields should be considered what Verity values, so Field2 is your URL for instance - kind of limiting, but don't forget you can make two custom tags! HOpe this helps - got it all from p.733 of Forta and http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm -Jason ___Reply Separator Subject:Verity SQL Author: [EMAIL PROTECTED] Date: 6/13/01 4:00 PM Is there any way to combine the results of a CFSEARCH and a standard SQL search into the same CFOUTPUT ... basically merge two queries? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setup HTTPS on local PC
Sandy, Check out www.equifaxsecure.com You can get an SSL certificate from them for $79 which is alot cheaper than Verisign. Dan Phillips www.cfxhosting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:16 PM To: CF-Talk Subject: RE: setup HTTPS on local PC Hi Duane: Where can I get an SSL key for my local PC? from a company like Verisign? thanks Sandy [EMAIL PROTECTED] To get the https protocal working locally you have to install an ssl key on your machine Duane Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Comparing value against a list of values
Dylan, Thanks for this suggestion. This doesn't do what is needed though I don't think. My trouble is I am comparing one list of values against another list of values. Take the following situation: 1. The string I want to compare against is this: 1,3,5 2. The field (FLD) I am comparing it against contains this value: 2,4,10 If I use IN, it would look like this: WHERE '2,4,10' IN('1,3,5') What I _WANT_ to do is this (in layman's terms): get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 = 10) OR (5 = 2 or 5 = 4 or 5 = 10) I'm comparing discrete values in the comparison list against discrete values in the the field value list. Only if one of the discrete values matches do I want to the record. Any ideas on how to accomplish this? Thanks for ideas! Paul Sinclair -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:01 AM To: CF-Talk Subject: RE: Comparing value against a list of values Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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
WYSIWYG editors
Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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
What is January in French? German? CF knows it already
I was having a conversation with Ben Forta about the UDF library project and he suggested I add a function that would print the locale version of a month. For example, the French (Standard) version of January. Well, I pinged him back and said that as far as I know, I'd have to manually enter the strings. It turns out CF does this for you. Check out the following example: CFSCRIPT function LSMonthAsString(month_number) { VAR d=CreateDate(2000, month_number, 1); return LSDateFormat(d, ); } /CFSCRIPT CFLOOP LIST=#Server.Coldfusion.SupportedLocales# INDEX=locale DELIMITERS=, CFSET SetLocale(locale) CFOUTPUT#locale#BR/CFOUTPUT CFLOOP INDEX=X FROM=1 TO=12 CFOUTPUT#LSMonthAsString(X)#BR/CFOUTPUT /CFLOOP P /CFLOOP This will loop through all the supported locales and return the name of each month. Maybe this is something everyone knew about it but it sure surprised the heck out of me. I knew CF had good locale functionality, but this rocks. Anyway, thanks go to Ben Forta for the idea. I'm going to be modifying this UDF and using it at www.cflib.org. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ 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: Body and Subject of my messages not arriving
Thanks Tim - Checked that and it is not checked. Any other ideas? This seems to only be effecting my mail from JS-Jive. -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:15 AM To: CF-Talk Subject: Re: Body and Subject of my messages not arriving Larry, I have seen this a lot when you set Word as your email editor. Try turning that option off in Mail Format options and see if that fixes it. (if that is the case) Tim P. - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 10:32 AM Subject: Body and Subject of my messages not arriving HELP Please - I know this sis for another list, however - I am receiving my messages from JS-Jive, but my subject and body are empty on all of them. Has anyone run into this before and is there a way for me to fix it? I am using Outlook 2000. Just started the other day. Thanks Larry Juncker Senior ColdFusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL VS ACCESS
I've learned to avoid using autonumber fields whenever possible. It makes the job of moving databases between platforms simple. At worst, I have to put the primary key constraints back on the index fields of each table - which is no big deal. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 4:02 AM To: CF-Talk Subject: RE: SQL VS ACCESS On 6/12/01, Norman Elton penned: Make sure all your fields that should be indexed are indexed. I think the upsizing wizard forgets about this. The upsizing wizard does a pretty good job of rebuilding the indexes and relationships. It's DTS that loses that stuff. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 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
CFForm File Upload and MacIntosh IE bug fix
Hello all! I have a cfform with a file upload field, so the enctype attribute has to be set to =multipart/form-data. cfform action=update.cfm method=POST enablecab=Yes name=new_newsletter enctype=multipart/form-data input type=hidden name=nlt_filename value=0 It works fine on PC IE browser, but when testing it on MacIntosh, none of the form fields are getting passed. I have tried using the trim() function in the update query, as well creating a hidden form field with the same field name and a value of 0. On the update page I have a script that checks if the value is 0, and if it is it sets the value to -1 (This was my interpretation of a 'solution' to this problem posted on a thread at Allaire.com, but I don't understand how it is supposed to work). script language=JavaScript if (new_newsletter.nlt_filename.value.length == 0){ new_newsletter.nlt_filename.value = '-1'; } /script Can anyone please help me and my comrads solve this problem? Gratefully Yours, Sutton ~~ 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: OT SQL Server (OK 1 More ?)
From the SQL BOL... Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer. It only takes up 4 bytes of space for storage. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 9:32 AM To: CF-Talk 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: Comparing value against a list of values
Paul, Thanks for this note. I realize the table design needs normalization and that is the long term solution. Right now I need a short-term fix until we can get around to redesigning the db. Unfortunately, we've got several tables with tens of thousands of records each that require normalization! I've been trying to figure out a simple way to extract the field contents from the non-normalized table and move the contents to a new, normalized table with a single record for each. Is there a good way to do this? Regards, Paul Sinclair -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:45 PM To: CF-Talk Subject: RE: Comparing value against a list of values Since the list is in a column in the database table, the IN below won't work. I believe you'll have to normalize your table, or better create another table. In the latter case, for example, assuming the list 10,11,21,100 is in a row with ID = 89, the new table for these data would be: 89 10 89 11 89 21 89 100 Then you would do a join between this new table and the old one to find the records of interest. best, paul At 08:00 AM 6/13/01 -0700, you wrote: Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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: OT SQL Server (OK 1 More ?)
I think a lot of people are going to reply on this but here goes... 4 is not the length but the amount of space that is allowed. If it where a varchar or char then yes, only 4 characters could be added. But it is 4 bytes and can store numbers from -2,147,483,647 to 2,147,483,647. I suppose that you might run into a problem if you have more than 2.1 billion records on that table. Mike Bruce Fig Leaf Software -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:32 PM To: CF-Talk 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: OT SQL Server WOW THIS LIST IS SLOW!
You're right. From now on we'll all assume that someone *else* answered your question and not bother. ^_^ -Gel -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] This list is a bit slow, no? about 3490853 peopls have answered pretty simple question... ~~ 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: Compacting .cfm files
While I agree with other posters on this thread that redesigning your form might be your best bet, there is some hope in the compression department... I worked up a tag a while ago that will GZIP page content and send it to the browser. The tag detects all browsers that are able to handle the GZIP encoded content and compresses for those browsers while sending uncompressed content to browsers than can't handle GZIP. I'm sure you'll find info on the tag if you search the list archives. There was a bit of lively discussion on-list as it was developed, and I drew from ideas of some folks who posted. (I tried to give credit where due in the tag, but if anyone thinks I blatently ripped off your idea, I'd be happy to ammend the credits. Just lemme know! ;-) I just submitted the tag (CF_GZipPage) to the Tag Gallery, and it should appear in a day or so. If you absolutely can't break your form into multiple pages, then this might be a solution. If you're in a hurry, email me directly ([EMAIL PROTECTED]), and I'll send you a copy of the tag I just submitted. Best regards, Zac Bedell -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 11:28 AM To: CF-Talk Subject: Compacting .cfm files Sorry if this is beating a dead horse. A search of the archives brought up similar questions, but didn't really approach a solution. I have a form that contains as many as 200 select boxes with about 6 options each and 200 more input boxes. I guess that there is some type of resource crunch (memory, widget handles, who knows) that causes the following error: when scrolling a large form, the select boxes begin to smear vertically. They become clumped together and function oddly (some still seem to work, although I can't tell what 'line' they belong to). It's in the project specs that I cannot break the form up... which throws out the 'display records 1-20 21-40' type solutions. The only thing I can think to do is tighten the cfm code up. Our shop is indent happy for readability. The indenting produces a LOT of whitespace (perhaps bloating the code as much as 100%). I've already added cfsetting tags to squash output on custom tags, queries, etc. But there is still a lot of whitespace in the other 'normal' code. Are there any utilities to obliterate whitespace in cfm files? Er, something along the lines of turning an indented file into a really long single string? Is there a code beautifier to do the opposite? Is this approach worthwhile? Thanks, Brian ~~ 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: Passing empty form var to SQL WHERE
Try this: cfquery datasource=datasource.mdb name=search Select * from products where type = '#form.type#' cfif len(finish1)AND finish1 = '#form.finish1#'/cfif cfif len(finish2)AND finish2 = '#form.finish2#'/cfif cfif len(finish3)AND system = '#form.system#' /cfif /cfquery Just make sure that the default (selected) option in the drop down has a value of (option value= selected(select one)/option) Original Message Follows From: Chad Gray [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Passing empty form var to SQL WHERE Date: Wed, 13 Jun 2001 12:45:45 -0400 html OK im making a search application where people can use pull down menus to select what to search on.br br In my action template im making a CFQUERY like this:br br lt;cfquery datasource=quot;datasource.mdbquot; name=quot;searchquot;gt;br Select *br from productsbr wherenbsp; type = '#form.type#' AND finish1 = '#form.finish1#' AND finish2 = '#form.finish2#' AND system = '#form.system#' br lt;/cfquerygt;br br My problem is if the person only selects one drop down from the form page and leaves the others blank then i get a SQL statement like this:br br font face=Courier New, Courierbsearch/b (Records=0, Time=47ms)br SQL = br Select *br from productsbr where x-tabnbsp;nbsp;/x-tabtype = 'laminate' AND finish1 = '' AND finish2 = '' AND system = ''br br /fontSo no records are found.nbsp; BTW I would like to use AND's not OR's so the search is narrowed, and not broadened.br br I have tried some lt;CFIFgt; statements to figure out if the user selected a drop down, but then i run into SQL problems where i have ANDs next to each other.br br font face=Courier New, Courierbsearch/b (Records=0, Time=47ms)br SQL = br Select *br from productsbr where x-tabnbsp;nbsp;/x-tabtype = 'laminate' AND AND AND /fontnbsp; br br Then i tried to put the AND SQL inside of the CFIFs, but then i run into problems where if the first one is not selected or the last one is not selected the AND's are all screwed up also.br br Any ideas how to make this SQL WHERE statement work for empty form variables?br br Thanks in advanced!br Chad/html ~~ 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: Comparing value against a list of values
Mark, Yep - I realize that SQL isn't set up to do this. I'm trying to do a work around using some kind of CF magic. Will get around to normalizing the db but until that is done, I'm hoping to find a workaround. Best, Paul -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 1:13 PM To: CF-Talk Subject: RE: Comparing value against a list of values Let me get this right... You want to do a SQL list contains function on a field with a comma delimited list of values (csvList)? You want to return all the records that contain the value 1 (not 100 or 11) in a field (csvList) that contains comma delimited lists? Correct? I don't think that can be done in simple SQL. Maybe with a bit of SQL Magic. If anyone knows how to do this I would be very very interested! As a work around you could break your csvList field off to a relational table. Each value in the comma delimited list would get its own record with an id of the parent record. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 10:01 AM To: CF-Talk Subject: RE: Comparing value against a list of values Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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
unbalanced in cfmail
anyone know what unbalanced error when running a cfmail tag from a query means? ~~ 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: Security in a multiple server environment
(b) The hosting company has a fetish for security and has closed off CFRegistry, CFFile, CFDirectory etc, so I can't imagine they'll let me use the registry for storing client variables. (I've asked but not had a reply yet) I'd hope they'd say no - you don't want to store variables there in any case. Therefore I'll need to be storing client variables in the SQLServer7 database - should I use the central datasource for it or my own datasource? Are there issues here I need to take into account? Not really. It doesn't make any difference that I've noticed. I prefer to have separate databases for application data, but there's nothing to stop you from using one database for both application data and client variables. ( c ) aside from these issues, if I just change all my session. scope variables to client scope, is that going to take care of most of the issues involved in keeping security and tracking users round the site? Or are there other matters I need to take into account now too? If you're storing lots of data in the session scope, you might run into problems when you use the client scope instead, because that means more traffic between the app server and the database server. If you're storing any complex objects, for example, you might think that you could simply convert them to WDDX, then store that in the client scope - and you can do that, but it may very well drag your performance down to an intolerable level. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cold Fusion, IE 5.5, IP Address URLs and CF Session Cookies
Has anyone run into the problem of CF 4.5.2 not setting the CF ID and CF Session cookies with IE 5.5 and a URL with an IP address instead of a domain name? We are running into that problem when we try to test our software using IE 5.5 and a IP address in the URL. IT works fine in IE 5.0 and Nutscrape. When we use the domain name (www.turbosquid.com) it works fine in IE 5.5 as well. I nailed this down because it is not setting Client variables in our database storage for the IE 5.5 clients when they use the IP address it access the site. The rest of the Cold Fusion behaves like the Client variables are set, but they are not. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. ~~ 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: CFSearch
How do I set it CF's Search using Verity for our Intranet site independent of our Internet search page? How would it access only files pertaining to the Intranet directory and not the Internet site. You can create as many separate collections as you need, or want. Each of these collections may contain the text of the files that you specify, or the resultsets from queries that you run. Then, you can build search interfaces that reference only the collections you want to use. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Session time out = never ? Bad?
Would it be bad to set a session timeout to 10 years in the future? I have a client that wants to never time out if he or his office workers are coming to the site from their office. I am thinking this would be bad. Possible server registry blot? I'm a little fuzzy on the whole good-bad thing. What do you mean bad? - Peter Venckman - Ghostbusters Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:53 AM To: CF-Talk Subject: Re: Re:Verity SQL Won't work with multiple users seaching on the same time because of the collection on the fly creation latency - both trying to use OntheFlyCollection which is alright (for the first user) at second number 1 but it's not updated for second user (or first user, depending who run what and where first...) but If you can create a collection that will sure to be unique, again - ontheflyCollection, it might work, but will involve some major maintance.. again, I personally don't see any point nor success to this. Thanks, Michael - Original Message - From: Jason Blum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 4:52 PM Subject: Re:Verity SQL Steve! Finally something I can contribute to this wonderful list! I am in fact working right now on the code to do just this. I am assuming you already have a Verity collection with SomeName. Then you need to make a kind of on-the-fly collection out of a normal db query and call it Dbquery So on the search page, here is your Dbquery: !--Retrieve data from Db for onthefly collection-- cfquery name=GetSomeData datasource=YourDatasource SELECT Field1, Field2, Field3, Field4 FROM SomeTable /cfquery !-- Now convert this data into a collectionto be queried with GetResults next page-- CFINDEX ACTION=refresh COLLECTION=OntheFlyCollection KEY=Field1 URL=Field2 TYPE=custom TITLE=Field3 BODY=Field4 QUERY=GetSomeData Then on the search results page, cfsearch name = GetResults collection = SomeCollection, OntheFlyCollection criteria = #Form.Criteria# And that's it. Two things to note, you actually have to create a collection called OntheFlyCollection first, so that you can be refreshing it here on the search page. Also, notice that in the CFINDEX you are telling Verity which fields should be considered what Verity values, so Field2 is your URL for instance - kind of limiting, but don't forget you can make two custom tags! HOpe this helps - got it all from p.733 of Forta and http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm -Jason ___Reply Separator Subject:Verity SQL Author: [EMAIL PROTECTED] Date: 6/13/01 4:00 PM Is there any way to combine the results of a CFSEARCH and a standard SQL search into the same CFOUTPUT ... basically merge two queries? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setup HTTPS on local PC
Do you have access to a WinNT/2K Server that has Certificate Services installed? If so, genrerate your own cert. For a local machine shouldn't be much of a problem. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 9:16 AM To: CF-Talk Subject: RE: setup HTTPS on local PC Hi Duane: Where can I get an SSL key for my local PC? from a company like Verisign? thanks Sandy [EMAIL PROTECTED] To get the https protocal working locally you have to install an ssl key on your machine Duane Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setup HTTPS on local PC
Yes, equifax is a great alternative. They have a fast turnaround as well. Verisign are a bunch of nazis. However, for a local machine, your webserver (er, SSL package) should be able to generate it's own certificate for your use. You don't need to buy anything. Check out www.equifaxsecure.com You can get an SSL certificate from them for $79 which is alot cheaper than Verisign. Dan Phillips www.cfxhosting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:16 PM To: CF-Talk Subject: RE: setup HTTPS on local PC Hi Duane: Where can I get an SSL key for my local PC? from a company like Verisign? thanks Sandy [EMAIL PROTECTED] To get the https protocal working locally you have to install an ssl key on your machine Duane Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Protect CF from SQL/Oracle errors?
Thanks for the reply. The problem isn't that the error message is passed to the user (it should be since this is the Development machine). The problem is that the errors are killing the CFserver. I can work to reduce the errors, of course, but errors are kind of expected on a Development machine. Maybe crashing and restarting is not unreasonable given the circumstances(?) thx Chris Norloff -- Original Message -- From: Paul Johnston [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 12 Jun 2001 16:58:38 +0100 I am not sure if what you want is something to stop CF being brought down (ie crashing) or it just returning errors. If it's just errors, try this: cftry cfcatch type=database ... do whatever you want in here ... /cfcatch /cftry Otherwise, check your Oracle and CF installs... Paul -Original Message- From: Chris Norloff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 12 June 2001 16:49 Subject: Protect CF from SQL/Oracle errors? I've got a Solaris server with CF 4.5.2 that's being brought down by multiple Oracle Error Code = 936 . missing expression errors in the SQL statements passed to Oracle. It's a Development box, so it's going to get lots of errors. Maybe the Developers could ease up on this, but I sure would like to protect the CF server. Any ideas? thx Chris Norloff ~~ 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: WYSIWYG editors
Check out www.siteobject.com They have a free editor and it is pretty cool Michael Bruce Fig Leaf Software -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:05 PM To: CF-Talk Subject: WYSIWYG editors Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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: Comparing value against a list of values
OK To simplify things let's say the search variable is named LookingFor and contains a single value (10) the rccords in the db contain: #SearchField --- --- 1 1,2,3,4,9,100 2 210,310,410 3 10,11,12 4 8,9,10 So, the query is: ... WHERE SearchField ='10' -- Match Only Element of field OR SearchField LIKE '10,%' -- Match Beginning Element of Field OR SearchField LIKE '%,10,%' -- Match Middle Element of Field OR SearchField LIKE '%,10' -- Match Last Element of Field OK, If that works, then if CF you must build a similar set of 4 tests for each list element in the LookingFor variable, by looping over it as a list: If yoy have a value in LookingFor of (1,10,100), cour CF-generated statement would look like this: ... WHERE SearchField ='0' -- Match Only Element of field OR SearchField LIKE '1,%' -- Match Beginning Element of Field OR SearchField LIKE '%,1,%, -- Match Middle Element of Field OR SearchField LIKE '%,1' -- Match Last Element of Field OR SearchField ='10'-- Match Only Element of field OR SearchField LIKE '10,%' -- Match Beginning Element of Field OR SearchField LIKE '%,10,%'-- Match Middle Element of Field OR SearchField LIKE '%,10' -- Match Last Element of Field OR SearchField ='100' -- Match Only Element of field OR SearchField LIKE '100,%' -- Match Beginning Element of Field OR SearchField LIKE '%,100,%' -- Match Middle Element of Field OR SearchField LIKE '%,100' -- Match Last Element of Field Now, all this garbage is the penalty you pay, again and again, for not having a normalized db... SearchField is not atomic. What I would suggest is that you add another child table to contain 1 record for each SearchField element. The search will be simple and fast (done entirely in the indexes). You can keep the composite field around if needed for other purposed (denormalized fields are acceptable if you use them as information fields don't need to search on them... This would would be a similar, practical, denormalization as carring the total in the order record, rather than computing the sum of all the line items. HTH Dick At 1:55 PM -0400 6/13/01, Paul Sinclair wrote: Dylan, Thanks for this suggestion. This doesn't do what is needed though I don't think. My trouble is I am comparing one list of values against another list of values. Take the following situation: 1. The string I want to compare against is this: 1,3,5 2. The field (FLD) I am comparing it against contains this value: 2,4,10 If I use IN, it would look like this: WHERE '2,4,10' IN('1,3,5') What I _WANT_ to do is this (in layman's terms): get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 = 10) OR (5 = 2 or 5 = 4 or 5 = 10) I'm comparing discrete values in the comparison list against discrete values in the the field value list. Only if one of the discrete values matches do I want to the record. Any ideas on how to accomplish this? Thanks for ideas! Paul Sinclair -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:01 AM To: CF-Talk Subject: RE: Comparing value against a list of values Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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: WYSIWYG editors
I really like ezEdit, but I paid for a version about a year ago (it's free now), and now they won't respond to my emails when I have trouble with the tag - they're working on a new version so they're not really supporting the old version (even though a lot of us paid for it). Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:05 PM To: CF-Talk Subject: WYSIWYG editors Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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
CF2001 early-bird discount ends Friday 6/15/01
The early bird discount on CF2001 ends Friday 6/15/01. That is just 3 days away... Sign up now! CF2001 is a ColdFusion info packed 2 day conference Saturday 7/28/01 and Sunday 7/29/01 http://www.cfconf.org/2001CF_Odyssey/ Get TeraTech upto CF full speed ahead warp factor nine with CF2001 - The Third Annual TeraTech ColdFusion Conference with MDCFUG and CPCUG. July 28th - 29th at NIH, Bethesda, MD Two days of ColdFusion Fun! Early Bird registration $129.00 After June 15th, registration will be $149.00 * Charlie Arehart Going from CF to Java * Matt Brown Future of CF Studio, UltraDev and the Macromedia community * Mark Chambers Flash and ColdFusion * Steve Drucker CF 5 js and DHTML tricks and tips * April Fleming Responsible Coding * Shlomy Gantz Cool CF debugging * Hal Helms XFB revealed * Matt Liotta CF on Linux * Steve Nelson The UN-Mythical Man Month * Robi Sen CF and big iron * Dave Watts Extreme TBA Seats are going fast... Please tell your ColdFusion friends so they can be there too! Thanks! Come learn CF info unavailable elsewhere in a fun way with CF 2001. Eleven famous CF speakers! Network with your CF friends in a relaxed enviroment. Get ready for fun and excitement -- ColdFusion style -- courtesy of TeraTech and MDCFUG Yes we are repeating the fun and learning from last year's CFUN2k! * CF Programming! * CF talk! * CF fun! Speaker bios are at http://www.cfconf.org/2001cf_odyssey/speakerbios.cfm Previous attendee quotes: - ... the CF community owes you a tremendous thanks for putting such a nigh calibur event together and then making sure that our collective thoughts are transmitted to the appropriate parties at Allaire. Happy New Year. I want to thank you for being such a great events sponsor. I have certainly learned things from your workshops that I would not have been able to learn anywhere else. CFUG bargin Registration fee: $149 ($129 before 6/15/01) Seating is limited - register now http://www.cfconf.org/2001cf_odyssey/ - CF Help -- Need expert ColdFusion, SQL and Access Programming? Project stuck and need help? Call TeraTech 800-447-9120 or email mailto:[EMAIL PROTECTED]. We will get you moving fast! - CF Help -- -- Michael Smith, TeraTech Inc - Tools for Programmers(tm) CF/ASP Web, VB, Telephony, Math, Access programming tools and consulting 12221 Parklawn Dr Ste 200, Rockville MD 20852 USA Please check out http://www.teratech.com/ - email mailto:[EMAIL PROTECTED], or call us for more information; in the USA at 1-800-447-9120, +1-301-881-1440 International, Fax 301-881-3586 Thanks! ~~ 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: Sending MP3's Through CF
Hmmm. Interesting. Didn't really consider that. How severe of a resource hit is it? Is CF working throughout the streaming of the song? Or just the beginning? Regardless, while it may take up threads, how severe of a CPU hit is it? It's not like CF is doing heavy computations. It's just passing along a file with a particular header. It's not really taking any amount of CPU. It's just that when your CF Server runs out of worker threads, it stops dead. The usual rule of thumb is no more than 8 worker threads per processor. So even if you've got a dual P-III Zeon 900MHz monster of a server, when user number 17 makes his request, he'll sit queued up waiting until one of the 16 worker threads is freed up. The CPUs would probably be idling at less than 5% at that point, but CF wouldn't be able to do any more work. Now... That scenario only applies if you're feeding the actual MP3 stream itself through CF. If you only feed the meta file, then you'd be okay. Winamp or whatever would just retrieve the meta file, disconnect from your CF Server, and *then* start getting the MP3 streams. Under that scenario, assuming your MP3 streams were coming from outside the CF Server somewhere, you could support thousands of users with no problems. As soon as you start involving CF for the actual streams, then you're in trouble. Thus, using ShoutCAST for the MP3 streams would be a GoodThing(tm)! ;-) If the CF Server in question is owned admin'd by you, you can certainly up the number of worker threads beyond 8 per processor, but I have no idea what kind of side effects you might see. In any case, the number of worker threads is the maximum number of users you could support. However... Let's say you set the number of threads to 100. If you've got 100 people listening to music, then nobody else could even view your web pages (assuming you use CF for them) since all the threads would be taken by MP3 streams. If you absolutely need to do this over an HTTP interface, then ASP might be a better option for you, tho you'd probably need Soft Artisans's SAFileUp COM component to access the binary files from the server's hard disk. ASP, at least, doesn't have a hard thread limit -- the ASP engine will spawn more threads as needed until all requests are handled *or* until the server is overloaded. In any case, neither ASP nor CF was intended to stream large files like this, and I can't imagine you could get them to do it reliably on anything but the smallest of scales. ShoutCAST servers can be had for nothing, and I thing they'd be a better solution. Failing that, I *think* Microsoft Media Services can be made to stream MP3's, so there's another option. I hope at least some of that is helpful. Feel free to pick my brain further. Best regards, Zac Bedell ~~ 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: Comparing value against a list of values
Just read my post... lotsa tipos, er, ah typos... Here's a better one OK To simplify things let's say the search variable is named LookingFor and contains a single value (10) the rccords in the db contain: #SearchField --- --- 1 1,2,3,4,9,100 2 210,310,410 3 10,11,12 4 8,9,10 5 10 6 2,10,200 Records 3, 4, 5, and 6 are matches So, the query is: ... WHERE SearchField ='10' -- Match Only Element of field OR SearchField LIKE '10,%' -- Match Beginning Element of Field OR SearchField LIKE '%,10,%' -- Match Middle Element of Field OR SearchField LIKE '%,10' -- Match Last Element of Field OK, If that works, then in CF you must build a similar set of 4 tests for each list element in the LookingFor variable, by looping over it as a list: If you have a value in LookingFor of (1,10,100), your CF-generated statement would look like this: ... WHERE SearchField ='1' -- Match Only Element of field OR SearchField LIKE '1,%' -- Match Beginning Element of Field OR SearchField LIKE '%,1,%, -- Match Middle Element of Field OR SearchField LIKE '%,1' -- Match Last Element of Field OR SearchField ='10'-- Match Only Element of field OR SearchField LIKE '10,%' -- Match Beginning Element of Field OR SearchField LIKE '%,10,%'-- Match Middle Element of Field OR SearchField LIKE '%,10' -- Match Last Element of Field OR SearchField ='100' -- Match Only Element of field OR SearchField LIKE '100,%' -- Match Beginning Element of Field OR SearchField LIKE '%,100,%' -- Match Middle Element of Field OR SearchField LIKE '%,100' -- Match Last Element of Field Now, all this garbage is the penalty you pay, again and again, for not having a normalized db... SearchField is not atomic. What I would suggest is that you add another child table to contain 1 record for each SearchField element. The search will be simple and fast (done entirely in the indexes). You can keep the composite field around if needed for other purposes(denormalized fields are acceptable if you use them as information fields don't need to search on them... This would would be a similar, practical, denormalization as carrying the total in the order record, rather than computing the sum of all the line items. HTH Dick At 1:55 PM -0400 6/13/01, Paul Sinclair wrote: Dylan, Thanks for this suggestion. This doesn't do what is needed though I don't think. My trouble is I am comparing one list of values against another list of values. Take the following situation: 1. The string I want to compare against is this: 1,3,5 2. The field (FLD) I am comparing it against contains this value: 2,4,10 If I use IN, it would look like this: WHERE '2,4,10' IN('1,3,5') What I _WANT_ to do is this (in layman's terms): get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 = 10) OR (5 = 2 or 5 = 4 or 5 = 10) I'm comparing discrete values in the comparison list against discrete values in the the field value list. Only if one of the discrete values matches do I want to the record. Any ideas on how to accomplish this? Thanks for ideas! Paul Sinclair -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:01 AM To: CF-Talk Subject: RE: Comparing value against a list of values Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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:
RE: Comparing value against a list of values
My understanding of your database (which might be wrong) is that you have unique records, each of which has a column with a comma-delimited list of numerals in it. The length of each list varies. The simplest solution is to create the small table I suggested: MainTableID ListElement 1 29 1 40 1 3141 2 80 2 121 3 35 3 99 3 1024 etc. You can populate this table using a ColdFusion query that gets the ID and IDList from each row, with a outer loop over the Query, and an inner loop over the List, with a CFQUERY inside inserting the current value of MainTableID ListElement into the table. HTH best, paul PS But I am probably missing something as another posting suggested you want to compare one list to another... At 02:44 PM 6/13/01 -0400, you wrote: Paul, Thanks for this note. I realize the table design needs normalization and that is the long term solution. Right now I need a short-term fix until we can get around to redesigning the db. Unfortunately, we've got several tables with tens of thousands of records each that require normalization! I've been trying to figure out a simple way to extract the field contents from the non-normalized table and move the contents to a new, normalized table with a single record for each. Is there a good way to do this? Regards, Paul Sinclair -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:45 PM To: CF-Talk Subject: RE: Comparing value against a list of values Since the list is in a column in the database table, the IN below won't work. I believe you'll have to normalize your table, or better create another table. In the latter case, for example, assuming the list 10,11,21,100 is in a row with ID = 89, the new table for these data would be: 89 10 89 11 89 21 89 100 Then you would do a join between this new table and the old one to find the records of interest. best, paul At 08:00 AM 6/13/01 -0700, you wrote: Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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: OT SQL Server (OK 1 More ?)
No, the 4 refers to 4 bytes required to store the value, not the number of characters in the value. The range that can be stored in an int is -2^31 to 2^31-1. Craig -Original Message- From: ibtoad [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:32 PM To: CF-Talk 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: SQL VS ACCESS
Great, but what happens when you wish to change the name of a field in a lookup table? Do you run update statements on EVERY foreign key field? Wouldn't it be easier to just change a value in the database? Further, requesting that user's supply indeces isn't the best way to work; user's have a tendancy to want to change the value of their indices from time to time. For example, If I have table a: CustomerID int AccountingIDchar CompanyName char And I want to change the accounting ID (for whatever reason), I'd be okay. However, if I were to omit the customerID field and stick with the Accounting ID Field, the change would be acceptable. Further, joins on integer fields work much faster than joins on character fields. The database has that much less to work with matching up. You are right though, autonumber fields can be a real pain. What you should usually do in a migration from access to sql server is first go into all of your tables, turn off autonumber, and leave the field as an integer field, when you upsize, go back in and revert to autonumber. -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:27 AM To: CF-Talk Subject: RE: SQL VS ACCESS I've learned to avoid using autonumber fields whenever possible. It makes the job of moving databases between platforms simple. At worst, I have to put the primary key constraints back on the index fields of each table - which is no big deal. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 4:02 AM To: CF-Talk Subject: RE: SQL VS ACCESS On 6/12/01, Norman Elton penned: Make sure all your fields that should be indexed are indexed. I think the upsizing wizard forgets about this. The upsizing wizard does a pretty good job of rebuilding the indexes and relationships. It's DTS that loses that stuff. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: unbalanced in cfmail
Nope. Can you post the full error message and the code that you think is throwing it? -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:27 PM To: CF-Talk Subject: unbalanced in cfmail anyone know what unbalanced error when running a cfmail tag from a query means? ~~ 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: unbalanced in cfmail
Missing or or even two of them I suspect. Gordon At 14:26 13/06/01 -0500 Alex said anyone know what unbalanced error when running a cfmail tag from a query means? ~~ 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: CFSTAT on NT
As long as CFSTAT is working in general from the command line, your batch file should be fine. It's probably just a matter of patience. :-) It will only write to the text file after it has ~4K of data stored up, which at 1 second intervals, takes about a minute or so. Deb -Original Message- From: McCabe, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:06 AM To: CF-Talk Subject: CFSTAT on NT Guys, Is it possible to get CFSTAT to output to a file? I have tried: cfstat -n 1 cfstat.txt and it creates and empty text file. Any Ideas? Can you send any replies to me directly and to the list as i'm on the digest. Cheers --- Kev McCabe Intranet Team Leader Telephone: +44 (0) 20 7941 5502 Mobile: +44 (0) 7711 172 730 Mobex: 123 5502 --- ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Comparing value against a list of values
Dude - bite the bullet and redesign the database. Seriously. I mean, why duck-tape a prop back on a plane when you know it's going to crash eventually anyway? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 10:56 AM To: CF-Talk Subject: RE: Comparing value against a list of values Dylan, Thanks for this suggestion. This doesn't do what is needed though I don't think. My trouble is I am comparing one list of values against another list of values. Take the following situation: 1. The string I want to compare against is this: 1,3,5 2. The field (FLD) I am comparing it against contains this value: 2,4,10 If I use IN, it would look like this: WHERE '2,4,10' IN('1,3,5') What I _WANT_ to do is this (in layman's terms): get all records where (1 = 2 or 1 = 4 or 1 = 10) OR (3 = 2 or 3 = 4 or 3 = 10) OR (5 = 2 or 5 = 4 or 5 = 10) I'm comparing discrete values in the comparison list against discrete values in the the field value list. Only if one of the discrete values matches do I want to the record. Any ideas on how to accomplish this? Thanks for ideas! Paul Sinclair -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:01 AM To: CF-Talk Subject: RE: Comparing value against a list of values Paul, You should use the IN operator in your WHERE clause. I'm not clear on your data structure from your post, but try something like the following (make sure the list is in parentheses); SELECT * FROM tbl WHERE csvList IN (10,11,21,100) -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:17 AM To: CF-Talk Subject: SQL: Comparing value against a list of values I have a table with a field that contains a comma delimited list of values, such as: 10,11,21,100 In doing a cfquery against the table, I want to select records where one or more of the values in this list of values matches a value in the WHERE clause of my sql query. For example: select * from tbl where csvList = '%1%' The problem is that the above select statement will select ANY record that has '1' in the field no matter what the true values in the field are (i.e., 1 is LIKE 10,11,21,100). How do I make the select query compare '1' against '10', and '1' against '11' and '1' against '21', and '1' against '100'. Thank you for help. Regards, Paul Sinclair ~~ 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: Session time out = never ? Bad?
I'm thinking: Impossible. I mean, I've heard of servers running for months at a time, but 10 years? Yeah RIGHT! HOWEVER, so long as all the session vars don't suck up the server's memory and crash it, I guess you're OK, right? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:51 PM To: CF-Talk Subject: Session time out = never ? Bad? Would it be bad to set a session timeout to 10 years in the future? I have a client that wants to never time out if he or his office workers are coming to the site from their office. I am thinking this would be bad. Possible server registry blot? I'm a little fuzzy on the whole good-bad thing. What do you mean bad? - Peter Venckman - Ghostbusters Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:53 AM To: CF-Talk Subject: Re: Re:Verity SQL Won't work with multiple users seaching on the same time because of the collection on the fly creation latency - both trying to use OntheFlyCollection which is alright (for the first user) at second number 1 but it's not updated for second user (or first user, depending who run what and where first...) but If you can create a collection that will sure to be unique, again - ontheflyCollection, it might work, but will involve some major maintance.. again, I personally don't see any point nor success to this. Thanks, Michael - Original Message - From: Jason Blum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 4:52 PM Subject: Re:Verity SQL Steve! Finally something I can contribute to this wonderful list! I am in fact working right now on the code to do just this. I am assuming you already have a Verity collection with SomeName. Then you need to make a kind of on-the-fly collection out of a normal db query and call it Dbquery So on the search page, here is your Dbquery: !--Retrieve data from Db for onthefly collection-- cfquery name=GetSomeData datasource=YourDatasource SELECT Field1, Field2, Field3, Field4 FROM SomeTable /cfquery !-- Now convert this data into a collectionto be queried with GetResults next page-- CFINDEX ACTION=refresh COLLECTION=OntheFlyCollection KEY=Field1 URL=Field2 TYPE=custom TITLE=Field3 BODY=Field4 QUERY=GetSomeData Then on the search results page, cfsearch name = GetResults collection = SomeCollection, OntheFlyCollection criteria = #Form.Criteria# And that's it. Two things to note, you actually have to create a collection called OntheFlyCollection first, so that you can be refreshing it here on the search page. Also, notice that in the CFINDEX you are telling Verity which fields should be considered what Verity values, so Field2 is your URL for instance - kind of limiting, but don't forget you can make two custom tags! HOpe this helps - got it all from p.733 of Forta and http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm -Jason ___Reply Separator Subject:Verity SQL Author: [EMAIL PROTECTED] Date: 6/13/01 4:00 PM Is there any way to combine the results of a CFSEARCH and a standard SQL search into the same CFOUTPUT ... basically merge two queries? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG editors
I think you meant http://www.siteobjects.com ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Michael Bruce [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 1:09 PM To: CF-Talk Subject: RE: WYSIWYG editors Check out www.siteobject.com They have a free editor and it is pretty cool Michael Bruce Fig Leaf Software -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:05 PM To: CF-Talk Subject: WYSIWYG editors Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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: OT: External Images in Flash
At 4:32 AM 6/13/1, Michael Lugassy wrote: Will it be possible to call a Movie via a URL but instead of specifying absolute name (like: mymovie.swf) to specify getmovie.cfm?parm1=value and on the getmovie.cfm page to use cfcontent to send the file automaticlly? Whew, I'm not sure... it sounds as if you're asking whether ColdFusion Server can return a SWF, which I don't think I see a scenario for... you could certainly invoke a template with query terms to have a new HTML or similar document returned... hmm, maybe you're think of a serverside redirect..? Sorry, I'm not sure of the full situation there. Taking a step backwards from it, I'd guess you may be asking How can I load movie clips into a SWF if their identity is determined only by actions taken by the visitor? If so, then it's pretty easy to handle that branching in the client itself, and construct URLs in the client rather than ask the server to construct the URLs. But as you can see, I may be looking at something very different than what you're looking at... sorry, I'm not sure of the design situation. jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ ~~ 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: WYSIWYG editors
Thanks Mike I like that one too but unfortunately they (ezedit) require IE 5 and our corp standard is IE 4. Im curious as to what hell would break loose if it was used with IE 4 but have no way of testing it at the moment. Sean Check out www.siteobject.com They have a free editor and it is pretty cool Michael Bruce Fig Leaf Software -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:05 PM To: CF-Talk Subject: WYSIWYG editors Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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: Macromedia misses its mark?
http://news.cnet.com/news/0-1006-200-5801563.html ~~ 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
URL Hacks
Having recently suffered (not too much fortunately) through an attempt of a hacker to corrupt a database by embedding sql in url paramaters I have put together a few tips on preventing these attacks from being successful. I realize that this is not new (I first heard of if at least 2 years ago) but sometimes a little reminder doesn't hurt because obviously the hackers are still out there. If anyone has any interest it is at: http://www.vawter.com/urlhack.cfm HTH Don Vawter ~~ 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: Body and Subject of my messages not arriving
I had the same problem for a while. It only seemed to occur if the message was HTML based (like the CNET news, etc). Not sure how I fixed it but I recently installed the latest service pack from officeupdate.microsoft.com and everything seems fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Larry Juncker Sent: Thursday, 14 June, 2001 12:32 AM To: CF-Talk Subject: Body and Subject of my messages not arriving HELP Please - I know this sis for another list, however - I am receiving my messages from JS-Jive, but my subject and body are empty on all of them. Has anyone run into this before and is there a way for me to fix it? I am using Outlook 2000. Just started the other day. Thanks Larry Juncker Senior ColdFusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG editors
Minh Hoang recently posted a tag called JS-Edit to the DevEx. Might be worth a look at: http://devex.allaire.com/developer/gallery/info.cfm?ID=8DAD85D3-5B05-11D5-8 3F600508B94F380method=Full -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sean McCarthy Sent: Thursday, 14 June, 2001 4:05 AM To: CF-Talk Subject: WYSIWYG editors Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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: What is January in French? German? CF knows it already
I just get this: Just in time compilation error Invalid parser construct found on line 10 at position 10. ColdFusion was looking at the following text: LSMonthAsString Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFSCRIPT tag occupying document position (9:1) to (9:10). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raymond Camden Sent: Thursday, 14 June, 2001 4:07 AM To: CF-Talk Subject: What is January in French? German? CF knows it already I was having a conversation with Ben Forta about the UDF library project and he suggested I add a function that would print the locale version of a month. For example, the French (Standard) version of January. Well, I pinged him back and said that as far as I know, I'd have to manually enter the strings. It turns out CF does this for you. Check out the following example: CFSCRIPT function LSMonthAsString(month_number) { VAR d=CreateDate(2000, month_number, 1); return LSDateFormat(d, ); } /CFSCRIPT CFLOOP LIST=#Server.Coldfusion.SupportedLocales# INDEX=locale DELIMITERS=, CFSET SetLocale(locale) CFOUTPUT#locale#BR/CFOUTPUT CFLOOP INDEX=X FROM=1 TO=12 CFOUTPUT#LSMonthAsString(X)#BR/CFOUTPUT /CFLOOP P /CFLOOP This will loop through all the supported locales and return the name of each month. Maybe this is something everyone knew about it but it sure surprised the heck out of me. I knew CF had good locale functionality, but this rocks. Anyway, thanks go to Ben Forta for the idea. I'm going to be modifying this UDF and using it at www.cflib.org. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ 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: WYSIWYG editors
Er, that should be http://www.siteobjects.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Bruce Sent: Thursday, 14 June, 2001 6:09 AM To: CF-Talk Subject: RE: WYSIWYG editors Check out www.siteobject.com They have a free editor and it is pretty cool Michael Bruce Fig Leaf Software -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:05 PM To: CF-Talk Subject: WYSIWYG editors Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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 VS ACCESS
Costas, Your point is well taken, but I never meant to imply that I would allow a primary key field to be anything other than a number (INT). The name of the primary key field doesn't matter, however I typically do what you do and prefix (or suffix) the primary key field name with ID. I setup one table in the database called KEYS. (Very simple: ID_KEY (INT) USED_DATETIME (date/time). Whenever I need a unique key, I call the following template: !-- begin act_global_get_key.cfm -- !--- this template generates a unique key which can be used in any table in the database --- cfsetting enablecfoutputonly=yes cftransaction cfquery name=max datasource=#session.dsn# SELECT max (ID_KEY) as maxid FROM KEYS /cfquery cfset ID_KEY = max.maxid+1 cfquery name=insert_key datasource=#session.dsn# INSERT INTO KEYS (ID_KEY, USED_DATETIME) VALUES (#id_key#, #CreateODBCDateTime(Now())#) /cfquery /cftransaction cfsetting enablecfoutputonly=no !-- end act_global_get_key.cfm -- If I was using Oracle as the DB, I would call a stored procedure to have the DB create a unique key for me. One of the benefits of this is that all numbers used for primary keys in all tables are unique. So you never have to worry about the scope (persay - that's not the right term for that) of the number because you know it could have only come from one of the tables in the system. The issue about joins is true as well. I'll RARELY join text fields. Your point about upsizing as an INT field and then changing it back to an INT PK SEED {n} field is also absolutely valid - if the database supports autonumbering. Last I checked, Oracle does not support autonumber fields. (I could be wrong about that.) ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:24 PM To: CF-Talk Subject: RE: SQL VS ACCESS Great, but what happens when you wish to change the name of a field in a lookup table? Do you run update statements on EVERY foreign key field? Wouldn't it be easier to just change a value in the database? Further, requesting that user's supply indeces isn't the best way to work; user's have a tendancy to want to change the value of their indices from time to time. For example, If I have table a: CustomerIDint AccountingID char CompanyName char And I want to change the accounting ID (for whatever reason), I'd be okay. However, if I were to omit the customerID field and stick with the Accounting ID Field, the change would be acceptable. Further, joins on integer fields work much faster than joins on character fields. The database has that much less to work with matching up. You are right though, autonumber fields can be a real pain. What you should usually do in a migration from access to sql server is first go into all of your tables, turn off autonumber, and leave the field as an integer field, when you upsize, go back in and revert to autonumber. -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:27 AM To: CF-Talk Subject: RE: SQL VS ACCESS I've learned to avoid using autonumber fields whenever possible. It makes the job of moving databases between platforms simple. At worst, I have to put the primary key constraints back on the index fields of each table - which is no big deal. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 4:02 AM To: CF-Talk Subject: RE: SQL VS ACCESS On 6/12/01, Norman Elton penned: Make sure all your fields that should be indexed are indexed. I think the upsizing wizard forgets about this. The upsizing wizard does a pretty good job of rebuilding the indexes and relationships. It's DTS that loses that stuff. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Re: Comparing value against a list of values
Paul, Question? Is this list a list if your identity field numbers? If that is the case read on otherwise LMK. Jeff Craig I had the same situation with about 200,000 record table. Of course the first identity number was 1 thru something like 400,000(after deletions):o)) The query was something like: select * from theTable where tableID in(select tableID from theTable where field like 'blah') If the tableid list in the in() statement happened to contain 1. One just happens to be contained in a lot of bigger numbers. My solution for that was to drop the tableid field. Reset the tableid field in SQL 7 with a seed value of 100. It gets a little tricker when you have a bunch of relational tables that are dependent on this identity. I had to go to all the related tables and add 100 to the tableid field in the related tables. ~~ 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 VS ACCESS
Concerning Oracle (and I don't have a lot of experience) you can set up autincrementing fields I don't remember the details because it has been about a year but select from dual or something similiar will get the next value. You can also reset the starting pt etc. - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 5:44 PM Subject: RE: SQL VS ACCESS Costas, Your point is well taken, but I never meant to imply that I would allow a primary key field to be anything other than a number (INT). The name of the primary key field doesn't matter, however I typically do what you do and prefix (or suffix) the primary key field name with ID. I setup one table in the database called KEYS. (Very simple: ID_KEY (INT) USED_DATETIME (date/time). Whenever I need a unique key, I call the following template: !-- begin act_global_get_key.cfm -- !--- this template generates a unique key which can be used in any table in the database --- cfsetting enablecfoutputonly=yes cftransaction cfquery name=max datasource=#session.dsn# SELECT max (ID_KEY) as maxid FROM KEYS /cfquery cfset ID_KEY = max.maxid+1 cfquery name=insert_key datasource=#session.dsn# INSERT INTO KEYS (ID_KEY, USED_DATETIME) VALUES (#id_key#, #CreateODBCDateTime(Now())#) /cfquery /cftransaction cfsetting enablecfoutputonly=no !-- end act_global_get_key.cfm -- If I was using Oracle as the DB, I would call a stored procedure to have the DB create a unique key for me. One of the benefits of this is that all numbers used for primary keys in all tables are unique. So you never have to worry about the scope (persay - that's not the right term for that) of the number because you know it could have only come from one of the tables in the system. The issue about joins is true as well. I'll RARELY join text fields. Your point about upsizing as an INT field and then changing it back to an INT PK SEED {n} field is also absolutely valid - if the database supports autonumbering. Last I checked, Oracle does not support autonumber fields. (I could be wrong about that.) ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:24 PM To: CF-Talk Subject: RE: SQL VS ACCESS Great, but what happens when you wish to change the name of a field in a lookup table? Do you run update statements on EVERY foreign key field? Wouldn't it be easier to just change a value in the database? Further, requesting that user's supply indeces isn't the best way to work; user's have a tendancy to want to change the value of their indices from time to time. For example, If I have table a: CustomerID int AccountingID char CompanyName char And I want to change the accounting ID (for whatever reason), I'd be okay. However, if I were to omit the customerID field and stick with the Accounting ID Field, the change would be acceptable. Further, joins on integer fields work much faster than joins on character fields. The database has that much less to work with matching up. You are right though, autonumber fields can be a real pain. What you should usually do in a migration from access to sql server is first go into all of your tables, turn off autonumber, and leave the field as an integer field, when you upsize, go back in and revert to autonumber. -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 11:27 AM To: CF-Talk Subject: RE: SQL VS ACCESS I've learned to avoid using autonumber fields whenever possible. It makes the job of moving databases between platforms simple. At worst, I have to put the primary key constraints back on the index fields of each table - which is no big deal. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 4:02 AM To: CF-Talk Subject: RE: SQL VS ACCESS On 6/12/01, Norman Elton penned: Make sure all your fields that should be indexed are indexed. I think the upsizing wizard forgets about this. The upsizing wizard does a pretty good job of rebuilding the indexes and relationships. It's DTS that
RE: What is January in French? German? CF knows it already
I just get this: Just in time compilation error Invalid parser construct found on line 10 at position 10. ColdFusion was looking at the following text: LSMonthAsString Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFSCRIPT tag occupying document position (9:1) to (9:10). My guess is that you're trying this on CF 4.5.x. Because LSMonthAsString is a user-defined function, it'll only work on CF 5. I haven't actually tried Ray's function myself, but I'm guessing that he has. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Reservation System
I know this is a bit bold, but a customers has asked me to knock up a site for him in a hurry. What he needs is a reservation system for his four rental properties. I was just wondering if any one has done anything similar and has some code I could plagiarize. Many thanks in advance Richard Y2K Internet Technologies ~~ 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: Comparing value against a list of values
Which database? SQL7 doesn't appear to have this problem. best, paul At 07:30 PM 6/13/01 -0500, you wrote: I had the same situation with about 200,000 record table. Of course the first identity number was 1 thru something like 400,000(after deletions):o)) The query was something like: select * from theTable where tableID in(select tableID from theTable where field like 'blah') If the tableid list in the in() statement happened to contain 1. One just happens to be contained in a lot of bigger numbers. ~~ 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: Comparing value against a list of values
Ooops. That won't work. Don't delete the old tableID field. Just add to the old tableID. Say the old ids went from 1 to 9,999 add 10,000 so that the new ids go from 10,001 to 19,999. Sorry I answered too quick. ~~ 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: What is January in French? German? CF knows it already
It's a UDF (User Defined Function), you must be using CF5. --- Ben -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 7:24 PM To: CF-Talk Subject: RE: What is January in French? German? CF knows it already I just get this: Just in time compilation error Invalid parser construct found on line 10 at position 10. ColdFusion was looking at the following text: LSMonthAsString Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFSCRIPT tag occupying document position (9:1) to (9:10). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raymond Camden Sent: Thursday, 14 June, 2001 4:07 AM To: CF-Talk Subject: What is January in French? German? CF knows it already I was having a conversation with Ben Forta about the UDF library project and he suggested I add a function that would print the locale version of a month. For example, the French (Standard) version of January. Well, I pinged him back and said that as far as I know, I'd have to manually enter the strings. It turns out CF does this for you. Check out the following example: CFSCRIPT function LSMonthAsString(month_number) { VAR d=CreateDate(2000, month_number, 1); return LSDateFormat(d, ); } /CFSCRIPT CFLOOP LIST=#Server.Coldfusion.SupportedLocales# INDEX=locale DELIMITERS=, CFSET SetLocale(locale) CFOUTPUT#locale#BR/CFOUTPUT CFLOOP INDEX=X FROM=1 TO=12 CFOUTPUT#LSMonthAsString(X)#BR/CFOUTPUT /CFLOOP P /CFLOOP This will loop through all the supported locales and return the name of each month. Maybe this is something everyone knew about it but it sure surprised the heck out of me. I knew CF had good locale functionality, but this rocks. Anyway, thanks go to Ben Forta for the idea. I'm going to be modifying this UDF and using it at www.cflib.org. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ 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: Reservation System
You're right. It is rather bold to ask someone to do something for you for free that you're going to profit off of. Have you considered slave labor? I hear in some countries that's still legal. Take my message lightly. I'm playing with you. But you might want to pass along the message to your boss. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: admin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 6:10 PM To: CF-Talk Subject: Reservation System I know this is a bit bold, but a customers has asked me to knock up a site for him in a hurry. What he needs is a reservation system for his four rental properties. I was just wondering if any one has done anything similar and has some code I could plagiarize. Many thanks in advance Richard Y2K Internet Technologies ~~ 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: WYSIWYG editors
Josh, We have never charged anything for ezEdit, other than custom integration contracts. You must be confused. Being the developer and sole supporter of this product, I don't recall ever being contacted by you. If you did indeed purchase our ezEdit product (http://www.siteobjects.com/examples/ezedit_scratchpad.cfm) I would like to know where you purchased it from. We strictly prohibit the resale of this this component in our license, and this would make me quite upset. You are though, correct in the fact that we are not supporting this product(ezEdit) anymore, I only have a finite amount of time and I am very busy working on version 2.0 (soEditor currently in beta). Please understand, this is a free product, and support really takes up a lot of time. soEditor is a much more solid product and our next beta release will really bring things together. I am happily accepting enhancement requests as well as taking care of any bug fixes in soEditor. So feel free to join the team. Information, downloads _support_ can be had here: http://forums.siteobjects.com On another note, if anyone is doing any SOAP/Webservice work, I would like to hear from you. I have some tags that I am finishing up that facilitates this, (much like soXML is for XML) and I need some informed testers, before I release it publicly. Happy Coding, Brett Suwyn mailto:[EMAIL PROTECTED] || -Original Message- || From: JoshMEagle [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, June 13, 2001 4:34 PM || To: CF-Talk || Subject: RE: WYSIWYG editors || || || I really like ezEdit, but I paid for a version about a || year ago (it's free now), and now they won't respond to || my emails when I have trouble with the tag - they're || working on a new version so they're not really supporting || the old version (even though a lot of us paid for it). || || Joshua Miller || Web Development || Eagle Technologies Group || Technology Solutions for the Next Generation || www.eagletgi.com || [EMAIL PROTECTED] || || -Original Message- || From: Sean McCarthy [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, June 13, 2001 2:05 PM || To: CF-Talk || Subject: WYSIWYG editors || || || Hi, || I am in search of a WYSIWYG editor that will allow a || user to enter a news article and have it display in HTML || format. I have looked at several different ones but am || looking for some feedback as to what is most preferred, || affordable (free), and easy for the user. || I have looked at EasyEdit |||| http://www.siteobjects.com/examples/ezedit_scrat || chpad.cfm || || I really liked the interface on this one but || it has to work with IE 4.0 and unfortunately this CF tag || needs at least IE 5.0. || ActiveEdit |||| http://www.cfdev.com/activedit2/executive.cfm || also looks || || good but is kinda awkward how you have to click the link || after updating to see your results. Thanks for your feedback. || || -Sean McCarthy || --- || HealthObjects || 410-895-0379 || ~~ 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: Reservation System
Here ya go, bud. It'll cost you $500 bucks. http://www.cfhosting.com/RentalGuide.cfm Rey Bango Team Allaire... - Original Message - From: admin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 9:09 PM Subject: Reservation System I know this is a bit bold, but a customers has asked me to knock up a site for him in a hurry. What he needs is a reservation system for his four rental properties. I was just wondering if any one has done anything similar and has some code I could plagiarize. Many thanks in advance Richard Y2K Internet Technologies ~~ 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
Mutiple Select
Need Help. I am looking for code to be able reselect the options on a multiple select form field for and edit page. Thank you for your time. It is appreciated. Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 ~~ 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: Mutiple Select
Please explain exactly what you're after. -David On Wednesday, June 13, 2001 7:31 PM, David Clay [SMTP:[EMAIL PROTECTED]] wrote: Need Help. I am looking for code to be able reselect the options on a multiple select form field for and edit page. ~~ 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: URL Hacks
Don, I can sympathize man. Check out the CF_Scriptkill tag in the Allaire developer's exchange. It should help out. Rey Bango Team Allaire... - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 7:10 PM Subject: URL Hacks Having recently suffered (not too much fortunately) through an attempt of a hacker to corrupt a database by embedding sql in url paramaters I have put together a few tips on preventing these attacks from being successful. I realize that this is not new (I first heard of if at least 2 years ago) but sometimes a little reminder doesn't hurt because obviously the hackers are still out there. If anyone has any interest it is at: http://www.vawter.com/urlhack.cfm HTH Don Vawter ~~ 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: Reservation System
Thanks Mark- Just trying to keep my job ! - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 6:51 PM Subject: RE: Reservation System You're right. It is rather bold to ask someone to do something for you for free that you're going to profit off of. Have you considered slave labor? I hear in some countries that's still legal. Take my message lightly. I'm playing with you. But you might want to pass along the message to your boss. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: admin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 6:10 PM To: CF-Talk Subject: Reservation System I know this is a bit bold, but a customers has asked me to knock up a site for him in a hurry. What he needs is a reservation system for his four rental properties. I was just wondering if any one has done anything similar and has some code I could plagiarize. Many thanks in advance Richard Y2K Internet Technologies ~~ 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: WYSIWYG editors
i think it just shows a textarea field - rather than a wysiwyg editor field. if you wanted to get into the code, I imagine you could swap something else for that case. Not sure what works though ... but I do know there are a few options ... In fact, you got me curious ... if I find the time, I'll try to post a list of different editors From: Sean McCarthy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: WYSIWYG editors Date: Wed, 13 Jun 2001 18:46:49 -0400 Thanks Mike I like that one too but unfortunately they (ezedit) require IE 5 and our corp standard is IE 4. Im curious as to what hell would break loose if it was used with IE 4 but have no way of testing it at the moment. Sean Check out www.siteobject.com They have a free editor and it is pretty cool Michael Bruce Fig Leaf Software -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:05 PM To: CF-Talk Subject: WYSIWYG editors Hi, I am in search of a WYSIWYG editor that will allow a user to enter a news article and have it display in HTML format. I have looked at several different ones but am looking for some feedback as to what is most preferred, affordable (free), and easy for the user. I have looked at EasyEdit http://www.siteobjects.com/examples/ezedit_scratchpad.cfm I really liked the interface on this one but it has to work with IE 4.0 and unfortunately this CF tag needs at least IE 5.0. ActiveEdit http://www.cfdev.com/activedit2/executive.cfm also looks good but is kinda awkward how you have to click the link after updating to see your results. Thanks for your feedback. -Sean McCarthy --- HealthObjects 410-895-0379 ~~ 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
Allaire Software Gets a Boost from Mozquito TechnologiesNew Xhtml-Fml Tags Bring Extensibility to Allaire's Homesite
http://www.xml.org/xml/newsreport_article.shtml?SMContentIndex=3SMContentSet=0 Very cool stuff, the future of web design I imagine. If not their product in particular, at least the technology behind it. Their site is very cool too, especially the tutorials. jon ~~ 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 4.5 on Win2K SBS ISA
On Wed, 13 Jun 2001 18:47:09 +0200, Michael Lugassy [EMAIL PROTECTED] wrote: I had a BIG ISSUE with cookies about a week ago. If the problem occurs in all of your pages (i.e - each page terminates the cookie) there must be something wrong with your application.cfm file. try deleting all rows in it (and I mean each row)! your problem maybe lie between a custom tag or code block. It's not the code... it's something to do with the firewall or proxy, or maybe CF. It's happening on old applications that were working on the old NT4 server, and have not been touched for months. K. Hi all, Our internal network was recently rebuilt with Win2k Small Business Server 2000. It seems that ISA is trashing cookies, with code that was previously working. I have a page that sets some client vars. In the Application.cfm cookies are set to on and storage to the database, which is set up and actually working fine. The client vars are visible on the page on which they are set, but when you move to another page they are undefined. There are no cflocations or other cookie crunching munsters... as I said, the code was working perfectly before the rebuild. Does anyone have any clues as to what this may be? A setting somewhere within CF or ISA? Our network admin (also the MD, LOL) has no clue what it could be, and the book is on order. But I need it running tomorrow to show a client! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists