RE: E-mail Marketing/Tracking Software
Personally I would go for the AdminProTools app, the UI is far more professionalbut is a matter of choice. _ From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 30 June 2004 22:34 To: CF-Talk Subject: RE: E-mail Marketing/Tracking Software Actually we've got a product called MagnetMail that does that already http://www.realmagnet.com -Original Message- From: Buddy Langston [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:30 PM To: CF-Talk Subject: Re: E-mail Marketing/Tracking Software I just finished writing a basic version that only tracks clickthroughs and views on an email. Your welcome to use it. Here's the url... http://216.27.17.100/temp/et.zip - Buddy >I¹m looking for pre-written application to start a permission based e-mail >campaign. Is there anything that already exists written in coldfusion? I >need to be able to track email after it¹s been sent (has e-mail been opened, >how many times viewed, etc.). > >Any suggestions would be much appreciated > >BZaccheo _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
In need of CFX_ImageInfo and CFX_ImageInfoMX
Hi All, I'm in urgent need of the ImageInfo and ImageInfoMX CFXs which are normally available from the following page: http://www.intrafoundation.com/CFX_ImageInfoMX.asp The trouble is that the download page at www.intrafoundation.com is currently not working. If anyone has any recent copies of either CFX_ImageInfo or CFX_ImageInfoMX, or knows where I could source them, I'd greatly appreciate it if they could contact me at this email address ([EMAIL PROTECTED]). If you have the files, please just attach them if that's convenient for you. I've already checked the tag library / developer exchange at macromedia.com, and unfortunately they only have an out of date copy of the superceded, non-MX version. Thanks! -- Daniel Kirkwood Software Development & Client Support Catalyst Communications and Training Pty Ltd Phone 02 9877 6233 Fax 02 98775531 PO Box 1000 Meadowbank NSW 2114 http://www.catalyst-train.com.au [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Absolute positioning in word (WAS: CSS layer positioning)
Hi Samuel, Firstly I have to say your original documents on serving word were most helpful. Now back to my problem, if I position a table in an absolute position on the page in word then save it as a doc file it works fine, however it is a binary file and therefore useless as a source of information. If I save it as an HTML document as you suggest it immediately moves the table into a relative position and looses its absolute position, this is also no good :-( A text box does seem to keep it's position ok, but generates so much html code it is hard to tell which bits I need and which I don't, is there any good documentation anywhere on this? -- Jay > -Original Message- > From: Samuel Neff [mailto:[EMAIL PROTECTED] > Sent: 30 June 2004 20:29 > To: CF-Talk > Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) > > Save it as HTML then you'll see all the HTML needed to > generate the same word doc. > > Sam > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 30, 2004 3:00 PM > To: CF-Talk > Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) > > > John, when you open a *binary* word doc in notepad, you will > stand witness > to a mountain of gibberish or am I missing something here? > > -mike > > > > "Burns, John D" <[EMAIL PROTECTED]> > 06/30/2004 02:39 PM > Please respond to cf-talk > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > Subject:RE: Absolute positioning in word > (WAS: CSS layer > positioning) > > The other option for creating word formatted docs (if it's > the same type > of doc over and over...ie. Labels) is to create the doc in > word the way > you want it, open the doc in a text editor so you can see all the > formatting and make a cf page that creates something with the > exact same > formatting and save it to a file with the extension .doc. > > John > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMail Sanity Check
On Wed, 30 Jun 2004 17:10:08 +0100, Paul Vernon <[EMAIL PROTECTED]> wrote: > It's probably not a great idea to set the proprietary Microsoft mailer > headers if you aren't sending a mail from a Microsoft application. This is a > well known spammers technique and can get your mails blocked by content > filters that can spot the difference... We sent out a small batch of newsletters manually from Outlook 2003 the other day, and got SpamAssassin bounces telling us the message was blocked for "pretending" to be from Outlook. They *were* from bloody Outlook! I don't know, maybe older versions of SpamAssassin don't recognise the Outlook 2003 x-mailer. It's very frustrating. -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Absolute positioning in word (WAS: CSS layer positioning)
Found part of the problem, I needed to expand on the tag to include the following two lines in addition to the two you mention in your article. xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" > -Original Message- > From: James Smith [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 10:15 > To: CF-Talk > Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) > > Hi Samuel, > > Firstly I have to say your original documents on serving word > were most helpful. > > Now back to my problem, if I position a table in an absolute > position on the page in word then save it as a doc file it > works fine, however it is a binary file and therefore useless > as a source of information. If I save it as an HTML document > as you suggest it immediately moves the table into a relative > position and looses its absolute position, this is also no good :-( > > A text box does seem to keep it's position ok, but generates > so much html code it is hard to tell which bits I need and > which I don't, is there any good documentation anywhere on this? > > -- > Jay > > > -Original Message- > > From: Samuel Neff [mailto:[EMAIL PROTECTED] > > Sent: 30 June 2004 20:29 > > To: CF-Talk > > Subject: RE: Absolute positioning in word (WAS: CSS layer > positioning) > > > > Save it as HTML then you'll see all the HTML needed to generate the > > same word doc. > > > > Sam > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, June 30, 2004 3:00 PM > > To: CF-Talk > > Subject: RE: Absolute positioning in word (WAS: CSS layer > positioning) > > > > > > John, when you open a *binary* word doc in notepad, you will stand > > witness to a mountain of gibberish or am I missing > something here? > > > > -mike > > > > > > > > "Burns, John D" <[EMAIL PROTECTED]> > > 06/30/2004 02:39 PM > > Please respond to cf-talk > > > > To: CF-Talk <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Absolute positioning in word > > (WAS: CSS layer > > positioning) > > > > The other option for creating word formatted docs (if it's the same > > type of doc over and over...ie. Labels) is to create the > doc in word > > the way you want it, open the doc in a text editor so you > can see all > > the formatting and make a cf page that creates something with the > > exact same formatting and save it to a file with the extension .doc. > > > > John > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFINPUT pattern question - Thank you!!
Look at Ben's book. It's very good for beginners. Also http://www.regular-expressions.info/ I also want to point out that the solution also validates $0.00 . If you want to avoid this, it's a bit more complex: ^\$([1-9]\.\d{2}|0\.([1-9]\d|0[1-9]))$ Pascal > -Original Message- > From: Mystic [mailto:[EMAIL PROTECTED] > Sent: donderdag 1 juli 2004 2:57 > To: CF-Talk > Subject: Re: CFINPUT pattern question - Thank you!! > > Thanks! > > Can you also point me to where I can get a list of what each > symbol and char means? Like what you did for me but all of > the possible options. :-) Or even a good tutorial or site > that I can learn the whole regex from. > > Thanks again, > Kevin > - Original Message - > From: Matthew Walker > A regex to match that is: ^\$[0-9]\.[0-9]{2}$ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to do this join? (MySQL 4.0 can't do subqueries...)
> Hi, all. > > I've tried for hours to figure this out, but can't get it... > > 3 tables... > > Newsletter_Series, Newsletter_Subscribers, Newsletter_Subscriptions > > I need to run a query to get all Newsletter_Series > which don't have Subscriptions for a particular Subscriber... > > Primary Key Relationships: > > - Newsletter_Series.Series_ID / Newsletter_Subscriptions.Series_ID > - Newsletter_Subscriptions.Subscriber_ID / > Newsletter_Subscribers.Subscriber_ID > > > Can't do subqueries (aaargh!), so I'm left with a join. > > Something like, > > > > Select newsletter_series.Series_ID, > newsletter_series.Series_Title, > from newsletter_series > > left join > > newsletter_subscriptions, newsletter_subscribers > on (newsletter_subscriptions.Subscriber_ID <> > '#CurrentSubscriber.Subscriber_ID#' > and newsletter_subscription.Series_ID <> > newsletter_series.Series_ID) > where newsletter_series.Series_ID is null > > Try something like this (not tested): SLECT newsletter_series.Series_ID, Newsletter_Subscribers.Subscriber_ID FROM newsletter_series LEFT JOIN newsletter_subscriptions ON newsletter_series.series_id = Newsletter_Subscriptions.Series_ID LEFT JOIN Newsletter_Subscribers ON Newsletter_Subscribers.Subscriber_ID = Newsletter_Subscriptions.Subscriber_ID WHERE newsletter_subscriptions.Subscriber_ID IS NULL AND Newsletter_Subscribers.subscriber_name = 'mike' AND Newsletter_Series.Series_ID = 100 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GMAIL Invite - First request gets it
On Wed, 30 Jun 2004 17:47:29 -0400, Ray Champagne <[EMAIL PROTECTED]> wrote: > > You've got it half right. I guess they offer 1 GB of space too. I dunno > really what the big deal is about that unless you really have a use for > that much space. I'll stick to mine, thank you very much My 2 cents: GMail's filtering (with some regex support), labels (virtual folders), and snappy interface are all reasons to switch from Hotmail, Yahoo, etc. There's also auto-complete for the addresses, threading (collapsible), keyboard shortcuts, and a very cool spell-checker. It's obviously not a full fledged email client (The Bat! is my choice there), but for a web interface it's very impressive. -- Ubqtous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GMAIL Invite - First request gets it
check out Kay's blog entry on http://kay.smoljak.com/ about Gmail, jb. On Thu, 1 Jul 2004 07:06:02 -0400, Ubqtous <[EMAIL PROTECTED]> wrote: > > On Wed, 30 Jun 2004 17:47:29 -0400, Ray Champagne <[EMAIL PROTECTED]> wrote: > > > > You've got it half right. I guess they offer 1 GB of space too. I dunno > > really what the big deal is about that unless you really have a use for > > that much space. I'll stick to mine, thank you very much > > My 2 cents: GMail's filtering (with some regex support), labels > (virtual folders), and snappy interface are all reasons to switch from > Hotmail, Yahoo, etc. There's also auto-complete for the addresses, > threading (collapsible), keyboard shortcuts, and a very cool > spell-checker. > > It's obviously not a full fledged email client (The Bat! is my choice > there), but for a web interface it's very impressive. > > -- > Ubqtous > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GMAIL Invite - First request gets it
Please send 1 GMail account for me, ok? Email spectrum post.com Thanx >hullo, > >your email address is rastafari and you're out [of something that grows on >god's green earth] and you will have more in a day or so [more what, pray >tell?] > >'twas a little joke ;) ;) > >-mike (ok, i'll stop wondering and get back to work!) > > > > > >[EMAIL PROTECTED] >06/30/2004 03:44 PM >Please respond to cf-talk > > >To: CF-Talk <[EMAIL PROTECTED]> >cc: >Subject:RE: GMAIL Invite - First request gets it > > >Tony Weeg makes me wonder just a little bit > > > >[EMAIL PROTECTED] > >are mine... > >im out for today, but should havemore in a day or so. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GMAIL Invite - First request gets it
On Thu, 1 Jul 2004 12:18:53 +0100, John Beynon <[EMAIL PROTECTED]> wrote: > > check out Kay's blog entry on http://kay.smoljak.com/ about Gmail, I certainly agree that it's fast, but I wouldn't say it's better than a non-web client like The Bat!. But then again, the applications for each is different enough in my case that the comparison is moot. I pretty much use GMail just for 'public' correspondence, i.e., newsletters, discussion lists, etc. that carry a higher risk of my address getting harvested. I can't wait to start getting some spam at this address so I can see how GMail handles it ;) -- Ubqtous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: In need of CFX_ImageInfo and CFX_ImageInfoMX
What features are you looking for in thatI mageInfo tag set? Do you need *that* product or do you need the features? If (at the moment) you're only looking for the width and height you might want to consider the Alagad Image Component (http://www.alagad.com/index.cfm/name-aic). Within the next few weeks this will support retreiving and setting more extended image metadata too. Doug Hughes On Thu, 01 Jul 2004 18:45:36 +1000, Daniel Kirkwood <[EMAIL PROTECTED]> wrote: > > Hi All, > > I'm in urgent need of the ImageInfo and ImageInfoMX CFXs which are > normally available from the following page: > > http://www.intrafoundation.com/CFX_ImageInfoMX.asp > > The trouble is that the download page at www.intrafoundation.com is > currently not working. > > If anyone has any recent copies of either CFX_ImageInfo or > CFX_ImageInfoMX, or knows where I could source them, I'd greatly > appreciate it if they could contact me at this email address > ([EMAIL PROTECTED]). If you have the files, please just > attach them if that's convenient for you. > > I've already checked the tag library / developer exchange at > macromedia.com, and unfortunately they only have an out of date copy of > the superceded, non-MX version. > > Thanks! > > -- > Daniel Kirkwood > Software Development & Client Support > Catalyst Communications and Training Pty Ltd > > Phone 02 9877 6233 Fax 02 98775531 > PO Box 1000 Meadowbank NSW 2114 > http://www.catalyst-train.com.au > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: In need of CFX_ImageInfo and CFX_ImageInfoMX
Hey Dan, I'd check out the Alagad image component at www.alagad.com. Does a lot more than imageInfo, and it's dirt cheap. (Full Disclosure: I have no stake in the Alagad component or the site. I just sit next to the guy who wrote it.) -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Apple Spotlight - Search Method?
Dick, To answer your first question, the Dublin Core metadata set is explained in detail here: http://dublincore.org , but the short answer is: it is a data model for information about a media asset (like an image, video clip, audio clip, etc.). The way Apple does its searches with Spotlight sounds like a synchronous search method. How easy is it to duplicate that in a web environment without too much load on the server? This KWIC concept sounds cool. Any place I could find more info? George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: In need of CFX_ImageInfo and CFX_ImageInfoMX
Doug, Have you tried the executing the java with MX to do image manipulation? Someone posted it here last year right when I happened to need it. I was able to replace the imagemagick I was using. I was resizing images, but I'm sure it will give you the dimensions also. Greg -Original Message- From: Doug Hughes [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 8:39 AM To: CF-Talk Subject: Re: In need of CFX_ImageInfo and CFX_ImageInfoMX What features are you looking for in thatI mageInfo tag set? Do you need *that* product or do you need the features? If (at the moment) you're only looking for the width and height you might want to consider the Alagad Image Component (http://www.alagad.com/index.cfm/name-aic). Within the next few weeks this will support retreiving and setting more extended image metadata too. Doug Hughes On Thu, 01 Jul 2004 18:45:36 +1000, Daniel Kirkwood <[EMAIL PROTECTED]> wrote: > > Hi All, > > I'm in urgent need of the ImageInfo and ImageInfoMX CFXs which are > normally available from the following page: > > http://www.intrafoundation.com/CFX_ImageInfoMX.asp > > The trouble is that the download page at www.intrafoundation.com is > currently not working. > > If anyone has any recent copies of either CFX_ImageInfo or > CFX_ImageInfoMX, or knows where I could source them, I'd greatly > appreciate it if they could contact me at this email address > ([EMAIL PROTECTED]). If you have the files, please just > attach them if that's convenient for you. > > I've already checked the tag library / developer exchange at > macromedia.com, and unfortunately they only have an out of date copy of > the superceded, non-MX version. > > Thanks! > > -- > Daniel Kirkwood > Software Development & Client Support > Catalyst Communications and Training Pty Ltd > > Phone 02 9877 6233 Fax 02 98775531 > PO Box 1000 Meadowbank NSW 2114 > http://www.catalyst-train.com.au > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
IIS 5.0/NTLM Authentication
Greetings all. 2 Questions: 1) Is there a way to capture 401 authentication errors from within CF? I'm assuming that the request never gets to CF if a 401 is thrown. I know I could create an intermediate template to trap all of the data from the HTTP request and then do a CFHTTP to the protected file and inspect the returned CFHTTP struct. Any ideas on how to do this by making the HTTP request directly to the protected file? 2) Anywway to use basic HTTP authentication with IIS and not have the user credentials be stored in the NT user database? Thanks much! -- Alex Sherwood PHS Collection Agency THE COLLECTORS P: 813-283-4579 F: 301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GMAIL Invite - First request gets it
On Thu, 1 Jul 2004 08:32:48 -0400, Ubqtous <[EMAIL PROTECTED]> wrote: > I certainly agree that it's fast, but I wouldn't say it's better than > a non-web client like The Bat!. But then again, the applications for > each is different enough in my case that the comparison is moot. I've used a number of different webmail clients over the years, but Gmail is the first that actually feels as responsive as a desktop app. It's made me realise how crap Outlook's search capabilities are. I'm actually thinking of exporting certain client emails from Outlook to a database and writing a CF app to allow members of my team to search through them on our intranet. Has anyone tried anything like this before? My last experience with Outlook's database export was a couple of versions ago, and it didn't export the message date which made it kind of pointless. I wonder if that's been improved... -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Finding good developers
Much much better! I thought I was losing my sense of humor! Good one! LOL Ray At 12:16 AM 7/1/2004, you wrote: >Ray, the entire joke follows -- it is one I told to a potential >employer -- didn't get the job, but we both enjoyed the joke. > >Dick > > Have you heard the one about the girl who comes home from school and > says: > > "Daddy, what's a faux pas? They explained it in school today, but I > really don't understand!" > > "Well, Honey, maybe it would be easier if I show you an example." > > "Do you remember a few weeks ago, the Reverend came to the house?" > > "Yes, Daddy, is that a faux pas?" > > "No Honey! But, do you remember when we we walking in the garden, the > Reverend pricked a finger on a rose bush?" > > "Yes, Daddy, is that a faux pas?" > > "No Honey! But do you remember when the Reverend came to the house > last Thursday, for Thanksgiving dinner?". > >..."Yes, Daddy, is that a faux pas?" > >"No, Honey! But, do you remember when we were sitting down to dinner, >and the Reverend was about to say Grace". > >"You said:" "Reverend, How's your prick?" > >"I said: Jsus Christ!' > >"And your Mother dropped the turkey"... > > . "And that's three of 'em" > > > > >On Jun 30, 2004, at 3:38 PM, Ray Champagne wrote: > > > Am I missing something or did that joke end without a punch line? > > > > At 06:35 PM 6/30/2004, you wrote: > > >On Jun 30, 2004, at 12:35 PM, George Abraham wrote: > > > > > > > A joke! It's people like you that I hate when I get interviewed! > > > > Though I agree it tells the interviewer a lot, so can my internet > > > > browsing cache! > > > > > >If you are going to be part of a team... > > > > > >Dick > > > > > >Have you heard the one about the girl who comes home from school and > > >says: > > > > > >"Daddy, what's a faux pas? They explained it in school today, but I > > >really don't understand!" > > > > > >"Well, Honey, maybe it would be easier if I show you an example." > > > > > >"Do you remember a few weeks ago, the Reverend came to the house?" > > > > > >"Yes, Daddy, is that a faux pas?" > > > > > >"No Honey! But, do you remember when we we walking in the garden, > > the > > >Reverend pricked a finger on a rose bush?" > > > > > >"Yes, Daddy, is that a faux pas?" > > > > > >"No Honey! But do you remember when the Reverend came to the house > > >last Thursday, for Thanksgiving dinner?". > > > > > > > > >. "And that's three of 'em" > > > > > >"In times like these, it helps to recall that > > >there have always been times like these." > > >- Paul Harvey - > > > > > > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Finding good developers
Internet job sites are definitely the way to go, especially when hiring computer programmers. As for the interview, i personally loathe the idea of giving structured "tests" or projects to job applicants and using the results as a basis for apptitude evaluation. A good interviewer can learn more in a 30 minute informal discussion with someone than from any test. This is especially true with Cold Fusion, who's relative ease-of-use puts a higher premium (in my opinion) on a developer's creativity, ingenuity, and overall personality. Hey, one only need to look at the characters on this list too see what I mean :) Brian - Original Message - From: B G To: CF-Talk Sent: Wednesday, June 30, 2004 4:37 PM Subject: RE: Finding good developers Thanks all for the suggestions. In my experience, my best candidates have been those with whom I've been able to have good discussions with. My interviews are very informal. As one suggestion noted, though someone might not know what MVC stands for, if they can articulate work they've done that results in a certain method, then they probably can produce good code. On sourcing though, other than a site like Craigslist, what have been your best sources for candidates? Newspaper ads? Monster.com? Other job sites? Recruiters? >From: "Burns, John D" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Finding good developers >Date: Wed, 30 Jun 2004 16:48:41 -0400 > >One final addition and then I'll shut up... > >I've been asked by a previous employer what I am most excited about >learning or what new CF functionality am I currently playing >with/learning/using that excites me. This will let you know if the >person is attempting to grow and learn or if they're just someone who >has been doing it for years and sometimes if they "know it all". I >personally value someone who is trying to learn as much as they can (and >seems to retain most of it) over someone who is really good at something >that is out of touch with new trends and technologies. > >John Burns > >-Original Message- >From: Whittingham, P [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 30, 2004 4:11 PM >To: CF-Talk >Subject: RE: Finding good developers > >If you are looking for example for a Cold Fusion developer, find years >of experience in html/css/_javascript_/dhtml and Cold Fusion along with >lots of sqlstored procedures. Then ask several questions from easy to >hard questions on those areas, giving your staff to help create the >questions. They will at least get an idea of the potential applicate. >Also, graphic tools (Photoshop/Fireworks) questions might be good also. >Asking for their previous work might be hard for the applicate, since >his/her work might be the property of his current employer. I've been >involved on both side over the last 25 years and a 'good' developer can >sometimes 'sense' a another good one. > >- Pat > > > > >From: B G [mailto:[EMAIL PROTECTED] >Sent: Wed 6/30/2004 1:24 PM >To: CF-Talk >Subject: OT: Finding good developers > > >Not to say that this list isn't stocked with good developers! > >But...As my department is growing my need to find good staff is >increasing. >I need to find good resources for both full-time positions and temporary >contract/project based openings. My experience with headhunters has >been very consistent. They're pushy and they don't really care about my >staffing needs as long as I place someone. Can anyone offer some advice >on companies that offer staffing solutions or other similar resources? >Any thoughts on this are greatly appreciated. For local info I am >located in Chicago. > >Thanks! > >BG > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
TreeMenu for Fusebox/CF site
Hello All I had a question regarding JS menus and CF. I am looking for a collapsible menu that stays open during use. The type that I am looking for is where the menu would have a "+" sign to the left of it to display that there is sub-content then clicking on the word would expose the sub-menu slightly indented and content of the next sub level. This tree really only needs to be text/css based and not image based. I am looking for something that will work well with different browsers, is simple enough that I could write some coldfusion around it so that I can have my client add menu items dynamically and does not require frames. Does anyone know of a menu that I can use? I have found many but none that I was particularly fond of, not even at Milonic. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Absolute positioning in word (WAS: CSS layer positioning)
As I say in my presentation, not everything that can be done in Word can be recreated through HTML->Word. This appears to be one of those cases. When I create a Word doc with an absolutely positioned table and try to save it as HTML I get this error message from Word "Tables with text wrapping and framed objects will become aligned with the beginning of the paragraph." Sam -- Blog: http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 5:15 AM To: CF-Talk Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) Hi Samuel, Firstly I have to say your original documents on serving word were most helpful. Now back to my problem, if I position a table in an absolute position on the page in word then save it as a doc file it works fine, however it is a binary file and therefore useless as a source of information. If I save it as an HTML document as you suggest it immediately moves the table into a relative position and looses its absolute position, this is also no good :-( A text box does seem to keep it's position ok, but generates so much html code it is hard to tell which bits I need and which I don't, is there any good documentation anywhere on this? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to do this join? (MySQL 4.0 can't do subqueries...)
MySql now supports subqueries: http://dev.mysql.com/doc/mysql/en/Subqueries.html To see how to rewrite some subquery SQL as joins, go to http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html SELECT newsletter_series.Series_ID, newsletter_series.Series_Title FROM newsletter_series LEFT JOIN newsletter_subscriptions ON newsletter_series.Series_ID = newsletter_subscription.Series_ID AND newsletter_subscriptions.Subscriber_ID = '#CurrentSubscriber.Subscriber_ID#' WHERE newsletter_subscriptions.Subscriber_ID IS NULL --- Neculai Macarie <[EMAIL PROTECTED]> wrote: > > Hi, all. > > > > I've tried for hours to figure this out, but can't > get it... > > > > 3 tables... > > > > Newsletter_Series, Newsletter_Subscribers, > Newsletter_Subscriptions > > > > I need to run a query to get all Newsletter_Series > > which don't have Subscriptions for a particular > Subscriber... > > > > Primary Key Relationships: > > > > - Newsletter_Series.Series_ID / > Newsletter_Subscriptions.Series_ID > > - Newsletter_Subscriptions.Subscriber_ID / > > Newsletter_Subscribers.Subscriber_ID > > > > > > Can't do subqueries (aaargh!), so I'm left with a > join. > > > > Something like, > > > > > > > > Select newsletter_series.Series_ID, > > newsletter_series.Series_Title, > > from newsletter_series > > > > left join > > > > newsletter_subscriptions, > newsletter_subscribers > > on (newsletter_subscriptions.Subscriber_ID <> > > '#CurrentSubscriber.Subscriber_ID#' > > and newsletter_subscription.Series_ID <> > > newsletter_series.Series_ID) > > where newsletter_series.Series_ID is null > > > > > = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: IIS 5.0/NTLM Authentication
You may want to have a look at iAuth. It allows you to dynamically process authentication requests using ColdFusion. The latest version also supports BlueDragon. http://www.coolfusion.com/products/iAuth/index.cfm Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Alexander Sherwood To: CF-Talk Sent: Thursday, July 01, 2004 8:59 AM Subject: IIS 5.0/NTLM Authentication Greetings all. 2 Questions: 1) Is there a way to capture 401 authentication errors from within CF? I'm assuming that the request never gets to CF if a 401 is thrown. I know I could create an intermediate template to trap all of the data from the HTTP request and then do a CFHTTP to the protected file and inspect the returned CFHTTP struct. Any ideas on how to do this by making the HTTP request directly to the protected file? 2) Anywway to use basic HTTP authentication with IIS and not have the user credentials be stored in the NT user database? Thanks much! -- Alex Sherwood PHS Collection Agency THE COLLECTORS P: 813-283-4579 F: 301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> I have found many but none that I was particularly fond of, not even at > Milonic. > I wrote this a few months ago, I never distributed it because it miss some basic docs: http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm It works with IE 5.5+, Mozilla and Safari The code output is pretty clean, both for HTML and _javascript_. There are no images, all the fancy stuff is done with CSS. If you want to customize it some decent CSS knowledge could be required. You can download a zip here: http://www.cleaner-drive.ch/_menu_test/tree/tmt_treeMenu.zip Hope it could help Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: TreeMenu for Fusebox/CF site
I've had good luck with Tigra Tree Menu. Using a modified Joe Celko/Steve Nelson tree-structure. (Fusebox 3). Let me know if you'd like some code. Greg -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:01 AM To: CF-Talk Subject: TreeMenu for Fusebox/CF site Hello All I had a question regarding JS menus and CF. I am looking for a collapsible menu that stays open during use. The type that I am looking for is where the menu would have a "+" sign to the left of it to display that there is sub-content then clicking on the word would expose the sub-menu slightly indented and content of the next sub level. This tree really only needs to be text/css based and not image based. I am looking for something that will work well with different browsers, is simple enough that I could write some coldfusion around it so that I can have my client add menu items dynamically and does not require frames. Does anyone know of a menu that I can use? I have found many but none that I was particularly fond of, not even at Milonic. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
On Thu, 1 Jul 2004 09:00:33 -0400, Mickael <[EMAIL PROTECTED]> wrote: > I had a question regarding JS menus and CF. I am looking for a collapsible menu that > stays open during use. The type that I am looking for is where the menu would have > a "+" sign to the left of it to display that there is sub-content then clicking on the word > would expose the sub-menu slightly indented and content of the next sub level. This > tree really only needs to be text/css based and not image based. I bookmarked this one, but haven't ever actually used it. Looks like it might fit though? http://gazingus.org/html/menuExpandable.html -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Which to use as primary key?
Hi, I'm wondering from a performance perspective as well as a practical perspective the best way to set up primary keys and indexes in a table which will be used to drive a data entry/edit/retrieval-reporting application. I've got four columns that can be used as the primary key. I also have a uniqueIdentifier field (I'm using SQL Server) that I generally use as a primary key for my tables because it's so easy. It seems like it would be four times as much work whenever I utilized the four fields that make up the primary key rather than just using the uniqueIdentifier, regardless of what scope I place them in (URL, Form, etc.) or how I use them (where clause, procparams, etc.). Instead of using the uniqueIdentifier as key, could/should I create the primary key based on the aforementioned four columns? If so, would the uniqueIdentifier field have any use, or should I just get rid of it? I guess I could break my options down this way: 1. Use the four columns as the primary key and pass those through the application for use in where clauses, etc 2. Use the four columns as the primary key and pass those through the application for use in where clauses, etc. Also add a uniqueIdentifier field and place an index on it (but don't use it?). 3. Use the four columns as the primary key. Add a uniqueIdentifier field with an index on it and pass it through the application for use in where clauses, etc 4. Forget about the four columns as a primary key. Make the uniqueIdentifier field the primary key and pass it through the system. Any ideas on the best route to take (and why) would be greatly appreciated. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> I wrote this a few months ago, I never distributed it because it miss some > basic docs: > http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm > BTW A crude readme is visible here: http://www.cleaner-drive.ch/_menu_test/tree/readme.htm Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
Massimo, This really looks clean! George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
On Thu, 1 Jul 2004 15:21:39 +0200, Massimo Foti <[EMAIL PROTECTED]> wrote: > I wrote this a few months ago, I never distributed it because it miss some > basic docs: > http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm Wow, that's awesome! Massimo, you're just too talented :) -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
You can only have 1 primary key. and usually it is the unique identifier. however, those 4 columns can possibly be foreign keys. I am not sure what your exact schema is, i am just generalizing. - Original Message - From: Peterson, Andrew S. To: CF-Talk Sent: Thursday, July 01, 2004 8:30 AM Subject: OT: Which to use as primary key? Hi, I'm wondering from a performance perspective as well as a practical perspective the best way to set up primary keys and indexes in a table which will be used to drive a data entry/edit/retrieval-reporting application. I've got four columns that can be used as the primary key. I also have a uniqueIdentifier field (I'm using SQL Server) that I generally use as a primary key for my tables because it's so easy. It seems like it would be four times as much work whenever I utilized the four fields that make up the primary key rather than just using the uniqueIdentifier, regardless of what scope I place them in (URL, Form, etc.) or how I use them (where clause, procparams, etc.). Instead of using the uniqueIdentifier as key, could/should I create the primary key based on the aforementioned four columns? If so, would the uniqueIdentifier field have any use, or should I just get rid of it? I guess I could break my options down this way: 1. Use the four columns as the primary key and pass those through the application for use in where clauses, etc 2. Use the four columns as the primary key and pass those through the application for use in where clauses, etc. Also add a uniqueIdentifier field and place an index on it (but don't use it?). 3. Use the four columns as the primary key. Add a uniqueIdentifier field with an index on it and pass it through the application for use in where clauses, etc 4. Forget about the four columns as a primary key. Make the uniqueIdentifier field the primary key and pass it through the system. Any ideas on the best route to take (and why) would be greatly appreciated. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
I believe he means that the combination of those four columns creates a unique identifier that can be used as the primary key, much as FirstName + MiddleName + LastName + DateOfBirth would go a long way to uniquely identifying you. - Original Message - From: "brobborb" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 01, 2004 9:28 AM Subject: Re: Which to use as primary key? > You can only have 1 primary key. and usually it is the unique identifier. however, those 4 columns can possibly be foreign keys. I am not sure what your exact schema is, i am just generalizing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DreamWeaver Weirdness (VERY LONG)
Hi, I created the file locally (just copied & pasted what you provided) and didn't seem to have any problems viewing the source with DMX 2004 (7.0.1) on Win XP. If you email me the file off-list, I can take a look at it as well. Best regards, Michael Wilson From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 6:42 PM To: CF-Talk Subject: DreamWeaver Weirdness (VERY LONG) Anybody have any idea why this is happening. I have a file that when I open it in DreamWeaver, it is truncated the middle is missing. But if I open the same file with notepad, HomeSite or Beyond Compare it is fine. The entire file exists. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Which to use as primary key?
As noted you can in theory you only have 1 PK, but you could use a series of columns as a compound key to act as a PK (assuming they are unique) _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 July 2004 14:29 To: CF-Talk Subject: Re: Which to use as primary key? You can only have 1 primary key. and usually it is the unique identifier. however, those 4 columns can possibly be foreign keys. I am not sure what your exact schema is, i am just generalizing. - Original Message - From: Peterson, Andrew S. To: CF-Talk Sent: Thursday, July 01, 2004 8:30 AM Subject: OT: Which to use as primary key? Hi, I'm wondering from a performance perspective as well as a practical perspective the best way to set up primary keys and indexes in a table which will be used to drive a data entry/edit/retrieval-reporting application. I've got four columns that can be used as the primary key. I also have a uniqueIdentifier field (I'm using SQL Server) that I generally use as a primary key for my tables because it's so easy. It seems like it would be four times as much work whenever I utilized the four fields that make up the primary key rather than just using the uniqueIdentifier, regardless of what scope I place them in (URL, Form, etc.) or how I use them (where clause, procparams, etc.). Instead of using the uniqueIdentifier as key, could/should I create the primary key based on the aforementioned four columns? If so, would the uniqueIdentifier field have any use, or should I just get rid of it? I guess I could break my options down this way: 1. Use the four columns as the primary key and pass those through the application for use in where clauses, etc 2. Use the four columns as the primary key and pass those through the application for use in where clauses, etc. Also add a uniqueIdentifier field and place an index on it (but don't use it?). 3. Use the four columns as the primary key. Add a uniqueIdentifier field with an index on it and pass it through the application for use in where clauses, etc 4. Forget about the four columns as a primary key. Make the uniqueIdentifier field the primary key and pass it through the system. Any ideas on the best route to take (and why) would be greatly appreciated. Sincerely, Andrew _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
BUT...I was always under the impression that primary keys should never be ties to any other data in your database, no matter how unique they may seem. That being said, I agree that key would be pretty hard to duplicate. However, it could happen Ray At 09:56 AM 7/1/2004, you wrote: >I believe he means that the combination of those four columns creates a >unique identifier that can be used as the primary key, much as FirstName + >MiddleName + LastName + DateOfBirth would go a long way to uniquely >identifying you. > > >- Original Message - >From: "brobborb" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, July 01, 2004 9:28 AM >Subject: Re: Which to use as primary key? > > > > You can only have 1 primary key. and usually it is the unique identifier. >however, those 4 columns can possibly be foreign keys. I am not sure what >your exact schema is, i am just generalizing. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: What would you do?
I have tables. First a members table with one record per member. Second table is a demographics table which the members can have 5 or more records. I have an application that requires that I crunch down the members demographics to a single line along with there personal contact information from the first table. So after crunching I have a record set of approximately 450,000 member records. On a daily basis members renew their membership, join or expire, so a daily nightly batch job is ran to update, insert these records. There are instances where the contact information is updated and instances were demographics are deleted as well. What I need to do is update the crunch down data on a daily basis but I do not want to run the extract on a daily basis and replicate. I mean the easy way to do this would to set up a job that deletes the crunched data on the main server and reextract that on a daily basis then replicate the changes but that would replicate every inserted record on the table. Plus doing 450,000 delete would be transaction intensive since you can not truncate a table setup for replication. Also I would be replicating across a wireless network which would be a bit harsh as well. So my idea is this, I set up a trigger that captures all insert, updates and deletes. I then write only the unique identifier to a holding table so I can tell which members has had something done to their account. I will also put a column in this table called uprec and default it to 0. Then after the nightly batch is ran I will run a stored proc that will query the holding table and select each distinct unique id and uprec = 0. Crunch the data to the application table by updating or inserting the new records or changed records then mark the uprec value from 0 to 1 for all the entries for that unique id in the holding table. Then run replication on the table to the application server across the wireless. Then delete from the holding table all records with a uprec of 1. Any other suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
Only one primary key constraint is allowed, but there's nothing stopping you from slapping a unique constraint on multiple columns. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
Oh. why not just make it an Int field with an increment value of 1 :) makes thigns alot simpler - Original Message - From: Todd To: CF-Talk Sent: Thursday, July 01, 2004 8:56 AM Subject: Re: Which to use as primary key? I believe he means that the combination of those four columns creates a unique identifier that can be used as the primary key, much as FirstName + MiddleName + LastName + DateOfBirth would go a long way to uniquely identifying you. - Original Message - From: "brobborb" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 01, 2004 9:28 AM Subject: Re: Which to use as primary key? > You can only have 1 primary key. and usually it is the unique identifier. however, those 4 columns can possibly be foreign keys. I am not sure what your exact schema is, i am just generalizing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
I never knew this was possible. even then, under what circumstances would someone do it that way? - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Thursday, July 01, 2004 8:56 AM Subject: RE: Which to use as primary key? As noted you can in theory you only have 1 PK, but you could use a series of columns as a compound key to act as a PK (assuming they are unique) _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 July 2004 14:29 To: CF-Talk Subject: Re: Which to use as primary key? You can only have 1 primary key. and usually it is the unique identifier. however, those 4 columns can possibly be foreign keys. I am not sure what your exact schema is, i am just generalizing. - Original Message - From: Peterson, Andrew S. To: CF-Talk Sent: Thursday, July 01, 2004 8:30 AM Subject: OT: Which to use as primary key? Hi, I'm wondering from a performance perspective as well as a practical perspective the best way to set up primary keys and indexes in a table which will be used to drive a data entry/edit/retrieval-reporting application. I've got four columns that can be used as the primary key. I also have a uniqueIdentifier field (I'm using SQL Server) that I generally use as a primary key for my tables because it's so easy. It seems like it would be four times as much work whenever I utilized the four fields that make up the primary key rather than just using the uniqueIdentifier, regardless of what scope I place them in (URL, Form, etc.) or how I use them (where clause, procparams, etc.). Instead of using the uniqueIdentifier as key, could/should I create the primary key based on the aforementioned four columns? If so, would the uniqueIdentifier field have any use, or should I just get rid of it? I guess I could break my options down this way: 1. Use the four columns as the primary key and pass those through the application for use in where clauses, etc 2. Use the four columns as the primary key and pass those through the application for use in where clauses, etc. Also add a uniqueIdentifier field and place an index on it (but don't use it?). 3. Use the four columns as the primary key. Add a uniqueIdentifier field with an index on it and pass it through the application for use in where clauses, etc 4. Forget about the four columns as a primary key. Make the uniqueIdentifier field the primary key and pass it through the system. Any ideas on the best route to take (and why) would be greatly appreciated. Sincerely, Andrew _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Which to use as primary key?
-Original Message- From: Todd [mailto:[EMAIL PROTECTED] >> I believe he means that the combination of those >> four columns creates a >> unique identifier that can be used as the primary >> key, much as FirstName + MiddleName + LastName >> + DateOfBirth would go a long way to uniquely >> identifying you. That's correct, Todd. Thanks for replying. My table looks like this right now, with a PK on four columns, and an index on the uniqueIdentifier: CREATE TABLE [LHF_Header] ( [Agency_No] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Fund_No] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Quarter] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Fiscal_Year] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SubmitDate] [datetime] NULL , [unSubmitDate] [datetime] NULL , [lastUpdateUser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [submittedBy] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Comments] [char] (180) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ID] uniqueidentifier ROWGUIDCOL NULL CONSTRAINT [DF_LHF_Header_ID] DEFAULT (newid()), CONSTRAINT [PK_LHF_Header] PRIMARY KEY CLUSTERED ( [Agency_No], [Fund_No], [Quarter], [Fiscal_Year] ) ON [PRIMARY] ) ON [PRIMARY] GO Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Which to use as primary key?
> I never knew this was possible. even then, under what > circumstances would someone do it that way? How about in a link/join table. USER --USER_ID (PK) --USER_NAME ROLE --ROLE_ID (PK) --ROLE_NAME USER_ROLE_LINK --USER_ID (PK) --ROLE_ID (PK) In the USER_ROLE_LINK table you can use the combination of USER_ID and ROLE_ID as the PK or add another column and make that the PK but be sure to add a unique constraint on the USER_ID and ROLE_ID. It has applications... Especially if a table has a PK made up of many columns and you don't want to pass all of them around for updates and deletes, etc... Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Which to use as primary key?
Someone would use multiple columns as a primary key when you have a cross-ref table that represents the many-to-many join between two tables and both fields in the xref table are foreign keys to the other two tables. For example: Users (UserId, ...) Groups(GroupId, ...) Users_Groups (UserId, GroupId) In the Users_Groups table the PK can be (UserId, GroupId). One can add a separate single-field identifier and add a unique constraint on UserId/GroupId that is not a PK, but since this is just an xref then there is really no need for a separate single-field identifier. As far as I can recall any other use of compound PK means the person putting together the database doesn't understand normalization and doesn't care about performance. (sorry guys, but if you're seriously using FirstName, LastName, DOB, whatever fields as a compound PK, then you really need to hire a dba to work with you). Best regards, Sam -- Blog: http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:56 AM To: CF-Talk Subject: Re: Which to use as primary key? I never knew this was possible. even then, under what circumstances would someone do it that way? - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Thursday, July 01, 2004 8:56 AM Subject: RE: Which to use as primary key? As noted you can in theory you only have 1 PK, but you could use a series of columns as a compound key to act as a PK (assuming they are unique) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: What would you do?
Would there be a way to build a view that is the "crunched" data? -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: What would you do?
yes I think I could -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:19 AM To: CF-Talk Subject: Re: OT: What would you do? Would there be a way to build a view that is the "crunched" data? -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> Massimo, > This really looks clean! > > George > Thanks George. Assembling something clean was my main goal. I have to admit that targeting only modern browsers (no NN 4, no IE 4) really helps. Leveraging CSS was also a main factor, since it helps to minimize the amount of _javascript_ required. The end results should be easier to manage and customize, at least, I hope so :-)) Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> > http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm > > Wow, that's awesome! Massimo, you're just too talented :) > Thanks Kay. We server-side programmers often forget that proper client-side code (both XHTML, CSS and _javascript_) can make the difference. Sure, dealing with different browsers and platforms can be frustrating, but nowdays you can target only latest generation browsers and achieve cool things with much less hassle than in the past. As for me, in the late nineties I spend a lot of time working with cutting-edge DHTML for IE 4 and NN 4 (it was HTML based contents, but not on the Web). This gave me a good fountation of _javascript_ and CSS. Compared to those pioneering days, DHTML is now much more pleasant :-))) Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: What would you do?
Actually when I run the extract I include validation after I select the data to kick out bogus records. Unfortunately we have a bunch of records that have become duplicate data or the CSR bunked the data and I do not want those in my set of data. The way I extract this now is through a stored proc in which I run a curser to select out the data, assign to variables and if certain pieces of data are bunk I right he unquie id to an error table with an error message and the bunk vlue so the I can run a report to the CSR for data clean up through the application, else I right the data to the application table. take about 110 minutes to run, but the data is accurate. The old process taht some joker wrote took about 10 hours. -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:19 AM To: CF-Talk Subject: Re: OT: What would you do? Would there be a way to build a view that is the "crunched" data? -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: What would you do?
Might be an easier way to go, depending how often the data is updated. - Original Message - From: Eric Creese <[EMAIL PROTECTED]> Date: Thu, 1 Jul 2004 09:17:36 -0500 Subject: RE: OT: What would you do? To: CF-Talk <[EMAIL PROTECTED]> yes I think I could -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:19 AM To: CF-Talk Subject: Re: OT: What would you do? Would there be a way to build a view that is the "crunched" data? -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Which to use as primary key?
Peterson, Andrew S. wrote: > > I've got four columns that can be used as the primary key. I also have a > uniqueIdentifier field (I'm using SQL Server) that I generally use as a > primary key for my tables because it's so easy. It seems like it would > be four times as much work whenever I utilized the four fields that make > up the primary key rather than just using the uniqueIdentifier, > regardless of what scope I place them in (URL, Form, etc.) or how I use > them (where clause, procparams, etc.). > > Instead of using the uniqueIdentifier as key, could/should I create the > primary key based on the aforementioned four columns? You could. Whether you should depends on many issues, the most important one being that often a (combination of) field(s) which appears to be suitably unique and unchangeable at a first glance does not qualify when scrutinized more closely. Then there is the performance issue and the 'more code' issue. What is the actual content of the 4 fields you think qualify? > If so, would the > uniqueIdentifier field have any use, or should I just get rid of it? If you go that way, get rid of it. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: E-mail Marketing/Tracking Software
Sorry, the correct address is http://216.27.17.100/et.zip > I just finished writing a basic version that only tracks clickthroughs > and views on an email. Your welcome to use it. Here's the url... > > http://216.27.17.100/temp/et.zip > > - Buddy > > >I¹m looking for pre-written application to start a permission based > e-mail > >campaign. Is there anything that already exists written in > coldfusion? I > >need to be able to track email after it¹s been sent (has e-mail been > opened, > >how many times viewed, etc.). > > > >Any suggestions would be much appreciated > > >BZaccheo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
GMAIL - Anyone have an extra?
If anyone has an extra invite, I need one for my wife. Her email is [EMAIL PROTECTED] I got only one invite so far and it failed when my wife received it. It gave the error "page has expired". Have you heard of this? -Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
Looks nice, Mass. I'm currently working on a set of custom tags providing a tree control, accordian pane, and a tabbed navigation pane - done them before in css etc., but I'd like to see them abstracted into the CF world. I'll post when/where they're available. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: What would you do?
data is updated all day long as well as the nightly update which is very important. but i need only to update the application table once a day, preferably after the night batch run. -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:25 AM To: CF-Talk Subject: Re: OT: What would you do? Might be an easier way to go, depending how often the data is updated. - Original Message - From: Eric Creese <[EMAIL PROTECTED]> Date: Thu, 1 Jul 2004 09:17:36 -0500 Subject: RE: OT: What would you do? To: CF-Talk <[EMAIL PROTECTED]> yes I think I could -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:19 AM To: CF-Talk Subject: Re: OT: What would you do? Would there be a way to build a view that is the "crunched" data? -joe _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [cftalk] GMAIL - Anyone have an extra?
I would love one too if anybody is willing to part with one! I am dying to check out the nifty interface, especially the spell checker! [EMAIL PROTECTED] Thank you, kind person! Dan. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 15:27 To: CF-Talk Subject: [cftalk] GMAIL - Anyone have an extra? If anyone has an extra invite, I need one for my wife. Her email is [EMAIL PROTECTED] I got only one invite so far and it failed when my wife received it. It gave the error "page has expired". Have you heard of this? -Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HTML2PDF
CF_HTML2PDF like seems a great tool. Anybody use it with CSS? It's possible? Anymore ideas, apps, tools to do that? Thanx for your time. >Figured it out... The directory is named cfusionMX not cfusion hahaha.. I >wish I had access to the server so I can see these things for myself! >Thanks for all the help. > >-Original Message- >From: Hamm, Greg [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 01, 2003 1:44 PM >To: CF-Talk >Subject: RE: HTML2PDF > > >Can you run HTMLDOC in a GUI mode? > >Greg Hamm >Partner >Coreillia Development >[EMAIL PROTECTED] >http://www.coreillia.com > > > >-Original Message- >From: Clint [mailto:[EMAIL PROTECTED] >Sent: May 1, 2003 1:43 PM >To: CF-Talk >Subject: Re: HTML2PDF > >nope. I am running HTML doc 1.8.8 with no issues and I am all out of ideas. > >Clint >- Original Message - >From: "Tim Do" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, May 01, 2003 3:34 PM >Subject: RE: HTML2PDF > > >> I created a folder called htmldoc and put it in.. there same thing.. >Also >it >the >the >parameters >a >CFML >3. CF >to [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Finding good developers
It depends though. If the test is simple enough, it shouldn't be too big a deal. It just makes sure that they understand basic syntax and concepts. I have to agree though, that actual conversation will uncover a lot more about what an interviewee actually knows as long as the interviewer fully understands everything that is said--don't let the candidate get awaywith any BS. On Thu, 1 Jul 2004 08:13:51 -0500, G <[EMAIL PROTECTED]> wrote: > > Internet job sites are definitely the way to go, especially when hiring computer programmers. > > As for the interview, i personally loathe the idea of giving structured "tests" or projects to job applicants and using the results as a basis for apptitude evaluation. A good interviewer can learn more in a 30 minute informal discussion with someone than from any test. This is especially true with Cold Fusion, who's relative ease-of-use puts a higher premium (in my opinion) on a developer's creativity, ingenuity, and overall personality. > > Hey, one only need to look at the characters on this list too see what I mean :) > > Brian > > - Original Message - > From: B G > To: CF-Talk > Sent: Wednesday, June 30, 2004 4:37 PM > Subject: RE: Finding good developers > > Thanks all for the suggestions. In my experience, my best candidates have > been those with whom I've been able to have good discussions with. My > interviews are very informal. As one suggestion noted, though someone might > not know what MVC stands for, if they can articulate work they've done that > results in a certain method, then they probably can produce good code. > > On sourcing though, other than a site like Craigslist, what have been your > best sources for candidates? Newspaper ads? Monster.com? Other job sites? > Recruiters? > > >From: "Burns, John D" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: RE: Finding good developers > >Date: Wed, 30 Jun 2004 16:48:41 -0400 > > > >One final addition and then I'll shut up... > > > >I've been asked by a previous employer what I am most excited about > >learning or what new CF functionality am I currently playing > >with/learning/using that excites me. This will let you know if the > >person is attempting to grow and learn or if they're just someone who > >has been doing it for years and sometimes if they "know it all". I > >personally value someone who is trying to learn as much as they can (and > >seems to retain most of it) over someone who is really good at something > >that is out of touch with new trends and technologies. > > > >John Burns > > > >-Original Message- > >From: Whittingham, P [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, June 30, 2004 4:11 PM > >To: CF-Talk > >Subject: RE: Finding good developers > > > >If you are looking for example for a Cold Fusion developer, find years > >of experience in html/css/_javascript_/dhtml and Cold Fusion along with > >lots of sqlstored procedures. Then ask several questions from easy to > >hard questions on those areas, giving your staff to help create the > >questions. They will at least get an idea of the potential applicate. > >Also, graphic tools (Photoshop/Fireworks) questions might be good also. > >Asking for their previous work might be hard for the applicate, since > >his/her work might be the property of his current employer. I've been > >involved on both side over the last 25 years and a 'good' developer can > >sometimes 'sense' a another good one. > > > >- Pat > > > > > > > > > >From: B G [mailto:[EMAIL PROTECTED] > >Sent: Wed 6/30/2004 1:24 PM > >To: CF-Talk > >Subject: OT: Finding good developers > > > > > >Not to say that this list isn't stocked with good developers! > > > >But...As my department is growing my need to find good staff is > >increasing. > >I need to find good resources for both full-time positions and temporary > >contract/project based openings. My experience with headhunters has > >been very consistent. They're pushy and they don't really care about my > >staffing needs as long as I place someone. Can anyone offer some advice > >on companies that offer staffing solutions or other similar resources? > >Any thoughts on this are greatly appreciated. For local info I am > >located in Chicago. > > > >Thanks! > > > >BG > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
Massimo, Very very very nice. I presume since you sent out a download link that you don't mind people using it. Correct? Doug Massimo Foti wrote: >>I have found many but none that I was particularly fond of, not even at >>Milonic. >> >> >> >I wrote this a few months ago, I never distributed it because it miss some >basic docs: >http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm > >It works with IE 5.5+, Mozilla and Safari > >The code output is pretty clean, both for HTML and _javascript_. There are no >images, all the fancy stuff is done with CSS. If you want to customize it >some decent CSS knowledge could be required. > >You can download a zip here: >http://www.cleaner-drive.ch/_menu_test/tree/tmt_treeMenu.zip > >Hope it could help > > >Massimo Foti >http://www.massimocorner.com > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> Looks nice, Mass. > > I'm currently working on a set of custom tags providing a tree > control, accordian pane, and a tabbed navigation pane - done them > before in css etc., but I'd like to see them abstracted into the CF > world. I'll post when/where they're available. > Thanks. I wrote this too: http://www.cleaner-drive.ch/_menu_test/expand/sample.cfm Here the potential for customization is almost endless. Once again, it miss all the docs and would really benefit from more practical examples... Anyway, it's available here: http://www.cleaner-drive.ch/_menu_test/expand/tmt_expandMenu.zip Once again, focus is on clean code and CSS for customization. It works on IE 5+, Mozilla and Safari Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> Massimo, > > Very very very nice. Thanks > I presume since you sent out a download link that you don't mind people > using it. Correct? Sure, just use it as you see fit. Only don't redistribute it without contacting me first. Actually, if you manage to make something cool with it I would be glad to take a look. Thanks Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
Massimo, That menu is great! Just what I was loooking for. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
Ditto for http://www.cleaner-drive.ch/_menu_test/expand/sample.cfm Doug Doug James wrote: >Massimo, > >Very very very nice. > >I presume since you sent out a download link that you don't mind people >using it. Correct? > >Doug > >Massimo Foti wrote: > > > >>>I have found many but none that I was particularly fond of, not even at >>>Milonic. >>> >>> >>> >>> >>> >>I wrote this a few months ago, I never distributed it because it miss some >>basic docs: >>http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm >> >>It works with IE 5.5+, Mozilla and Safari >> >>The code output is pretty clean, both for HTML and _javascript_. There are no >>images, all the fancy stuff is done with CSS. If you want to customize it >>some decent CSS knowledge could be required. >> >>You can download a zip here: >>http://www.cleaner-drive.ch/_menu_test/tree/tmt_treeMenu.zip >> >>Hope it could help >> >> >>Massimo Foti >>http://www.massimocorner.com >> >> >> > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Ben in Boston?
I am planning on going tonight. Should be fun. Ben -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 3:52 PM To: CF-Talk Subject: Ben in Boston? Any of you guys/girls here from Boston? Will you be attending Boston CFUG meeting tomorrow night? I hear that Ben will be in the hizzouse... Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HTML2PDF
Check out this article at CFDJ, on using FOP to generate PDF's: http://www.sys-con.com/story/?storyid=44771&DE=1 -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Ben in Boston?
Original Message: > From: Michael Dinowitz > She really means DON'T MISS IT! The NYCFUG meeting went for about 3 > hours and let me say that Ben covered items in Blackstone that were > not covered at CFUN, not covered in the world wide meeting, just plain > not covered before. So, spill it! What new things did he cover? Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
On Thursday 01 Jul 2004 14:00 pm, Mickael wrote: > Does anyone know of a menu that I can use? I have found many but none that > I was particularly fond of, not even at Milonic. Did you look at the blueshoes (.org iirc) tree ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to do this join? (MySQL 4.0 can't do subqueries...)
Newsletter_Series which don't have Subscriptions for a particular Subscriber... SELECT newsletter_series.Series_ID, newsletter_series.Series_Title FROM newsletter_series WHERE newsletter_subscriptions.Subscriber_ID = '#CurrentSubscriber.Subscriber_ID#' AND newsletter_subscription.Series_ID is null I believe this query will solve your problem. Can you send your table desctriptions? Also, If there is no subscription, I am assuming the newsletter_subscription.Series_ID would be null. Ryan Duckworth Macromedia Coldfusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66207 (913) 754-4272 -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 9:40 PM To: CF-Talk Subject: How to do this join? (MySQL 4.0 can't do subqueries...) Hi, all. I've tried for hours to figure this out, but can't get it... 3 tables... Newsletter_Series, Newsletter_Subscribers, Newsletter_Subscriptions I need to run a query to get all Newsletter_Series which don't have Subscriptions for a particular Subscriber... Primary Key Relationships: - Newsletter_Series.Series_ID / Newsletter_Subscriptions.Series_ID - Newsletter_Subscriptions.Subscriber_ID / Newsletter_Subscribers.Subscriber_ID Can't do subqueries (aaargh!), so I'm left with a join. Something like, Select newsletter_series.Series_ID, newsletter_series.Series_Title, from newsletter_series left join newsletter_subscriptions, newsletter_subscribers on (newsletter_subscriptions.Subscriber_ID <> '#CurrentSubscriber.Subscriber_ID#' and newsletter_subscription.Series_ID <> newsletter_series.Series_ID) where newsletter_series.Series_ID is null I've tried a lot of variations and read the documentation, but can't get the results... Help, anyone? Rick Rick Faircloth WhiteStoneMedia.com -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.253 / Virus Database: 263.3.8 - Release Date: 6/30/2004 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> Ditto for http://www.cleaner-drive.ch/_menu_test/expand/sample.cfm > > Doug > Sure, same for this. I plan to package both menus (polus another one that still has to take shape) with examples and docs. Any help would be appreciated, especially on the docs side, since english isn't my mother tongue; so writing docs is quite painstaking. In case you want to contact me directely, use: [EMAIL PROTECTED] Since I will be out of the office for a few weeks starting from Saturday. Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Regex or ???
Okay, not sure if this is going to be a RegEx question or what... easier that I explain what I'm doing and get suggestions based on the final result needed: I've been building an application that has a few pages here and there that export to Excel (using CFContent). I have now been told that they want to have the ability to export 99% of the site to Excel. In order to do this I built a page that basically runs a CFHTTP to the requested page, passing some special variables to bypass the security. In addition those variables are looked for by other pages and certian content is excluded from the export. However I am running into an issue in that many of the reports have formfields built in... select boxes, input boxes and textareas. I want to replace these with the selected value or default value from the code so that the formfield does not display on the Excel page. Is this something that I would use RegEx for? The logic I want to implement (loosely) is: If a text input box is found, replace it with the text contained in the "value" attribute. If a checkbox, radio, hidden or password input box is found, remove it. If a select is found, replace it with the display of the selected option. If a textarea is found, replace it with the conents of the textarea. I know that I can do this by using a condition loop and a lot of searching but is there a better way that it can be done? Thanks! Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX_updater folder. Can I remove it?
I was just looking for a few MB to free up on the web server and I see that the "F:\CFusionMX\CFMX_updater" folder is about 120 MB. Can this be removed? Is it needed after the update is run? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
Massimo, Just one question how do you prevent the titles from Wrapping? Similar to nowrap. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
I'd have a problem with this because of the issue of changing names (ie a woman gets married,etc) I don't think a primary key should involve data that could change. My $.02 Marlon On Thu, 1 Jul 2004 09:56:23 -0400, Todd <[EMAIL PROTECTED]> wrote: > > I believe he means that the combination of those four columns creates a > unique identifier that can be used as the primary key, much as FirstName + > MiddleName + LastName + DateOfBirth would go a long way to uniquely > identifying you. > > > - Original Message - > From: "brobborb" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, July 01, 2004 9:28 AM > Subject: Re: Which to use as primary key? > > > You can only have 1 primary key. and usually it is the unique identifier. > however, those 4 columns can possibly be foreign keys. I am not sure what > your exact schema is, i am just generalizing. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which to use as primary key?
I wasn't seriously suggesting anyone actually use such data for a primary key. It was just an example of how 4 columns could be used in conjunction to make some sort of 'unique' identifier. :) - Original Message - From: "Marlon Moyer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 01, 2004 11:16 AM Subject: Re: Which to use as primary key? > I'd have a problem with this because of the issue of changing names > (ie a woman gets married,etc) I don't think a primary key should > involve data that could change. > > My $.02 > > Marlon > > > On Thu, 1 Jul 2004 09:56:23 -0400, Todd <[EMAIL PROTECTED]> wrote: > > > > I believe he means that the combination of those four columns creates a > > unique identifier that can be used as the primary key, much as FirstName + > > MiddleName + LastName + DateOfBirth would go a long way to uniquely > > identifying you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> Massimo, > > Just one question how do you prevent the titles from Wrapping? > Similar to nowrap. > You should use CSS for that. Open the .css file and change: .tmtTree li { border-bottom: 1px solid #00; margin-top: 0.4em; } With this one: .tmtTree li { border-bottom: 1px solid #00; margin-top: 0.4em; white-space: nowrap; } Now that you made me think about it, it could make sense to have this one on by default... You see, sharing always help :-) Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> Now that you made me think about it, it could make sense to have this one on > by default... > You see, sharing always help :-) > A true programmer has no problem using open knowledge and design from others in his work. Distributed processing works for brains as well as computers. - Unknown :-))) Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
Please disreard my last post, I figured it out. Great menu! >Massimo, > >Just one question how do you prevent the titles from Wrapping? Similar to nowrap. > >Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Creating a boolean search
Appreciate being pointed toward previous threads or a tag or UDF - I've been searching and can't find this- I've got a data table with half a dozen columns: Category,SubCategory,ProductName,ShortDescription,LongDescription I need to create a query based on a search form that will allow the visitor to put in multiple words, and check an "AND" or "OR" option for a more advanced search than an exact match. I'm confused about the query syntax on this complex a process, though I understand this is "boolean" stuff. It's just that with multiple words AND multiple columns, I can only envision a truly ugly query if I were to write it with lots of CFIFs, and in the past I've gotten lost at this level. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DreamWeaver Weirdness (VERY LONG)
On Jun 30, 2004, at 6:42 PM, Ian Skinner wrote: > Anybody have any idea why this is happening. I have a file that when > I open it in DreamWeaver, it is truncated the middle is missing. But > if I open the same file with notepad, HomeSite or Beyond Compare it is > fine. Maybe there's an error in the file itself, a random null character or EOL or something? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to do this join? (MySQL 4.0 can't do subqueries...)
Thanks for the help... Haven't been able to get it to work, yet...but I'm still trying. One problem, I believe, is the last line of your SQL: "and Newsletter_Series.Series_ID = 100" I know that 100 is not to be taken literally, but the problem is in defining the Series_ID at all. The query is supposed to identify *all* Series_ID's, not one specific Series_ID. With or without that line, however, I have haven't been able to get the left joins to work. I'll keep trying... Rick -Original Message- From: Neculai Macarie [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 6:21 AM To: CF-Talk Subject: Re: How to do this join? (MySQL 4.0 can't do subqueries...) > Hi, all. > > I've tried for hours to figure this out, but can't get it... > > 3 tables... > > Newsletter_Series, Newsletter_Subscribers, Newsletter_Subscriptions > > I need to run a query to get all Newsletter_Series > which don't have Subscriptions for a particular Subscriber... > > Primary Key Relationships: > > - Newsletter_Series.Series_ID / Newsletter_Subscriptions.Series_ID > - Newsletter_Subscriptions.Subscriber_ID / > Newsletter_Subscribers.Subscriber_ID > > > Can't do subqueries (aaargh!), so I'm left with a join. > > Something like, > > > > Select newsletter_series.Series_ID, > newsletter_series.Series_Title, > from newsletter_series > > left join > > newsletter_subscriptions, newsletter_subscribers > on (newsletter_subscriptions.Subscriber_ID <> > '#CurrentSubscriber.Subscriber_ID#' > and newsletter_subscription.Series_ID <> > newsletter_series.Series_ID) > where newsletter_series.Series_ID is null > > Try something like this (not tested): SLECT newsletter_series.Series_ID, Newsletter_Subscribers.Subscriber_ID FROM newsletter_series LEFT JOIN newsletter_subscriptions ON newsletter_series.series_id = Newsletter_Subscriptions.Series_ID LEFT JOIN Newsletter_Subscribers ON Newsletter_Subscribers.Subscriber_ID = Newsletter_Subscriptions.Subscriber_ID WHERE newsletter_subscriptions.Subscriber_ID IS NULL AND Newsletter_Subscribers.subscriber_name = 'mike' AND Newsletter_Series.Series_ID = 100 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX_updater folder. Can I remove it?
> I was just looking for a few MB to free up on the web server > and I see that the "F:\CFusionMX\CFMX_updater" folder is > about 120 MB. Can this be removed? Is it needed after the > update is run? That's just a backup of your files from before the update. You can safely delete it. However, you should probably upgrade to CFMX 6.1 if you can. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Email Regex with weird results
All: I've been using a regex found on this list to validate email addresses. I've now run into a problem with the regex that I can't solve. Any help would be greatly appreciated. The email address is not required so the field can either be left blank or must contain a valid email address. The regex validation code follows: (REFindNoCase("^[a-zA-Z]([[:alnum:]\-_]+\.?)*@([[:alnum:]\-_]+\.)+[a-zA-Z]{2 ,4}$", FORM.Email) EQ 0)> Email address is invalid The email address is of the form "[EMAIL PROTECTED]" (that is, the domain contains a dash). If I remove the dash from the domain, the address validates. However, the dash should be valid. Looking at the regex, doesn't the ([[:alnum:]\-_]+\.) portion after the @ symbol allow for dashes? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX_updater folder. Can I remove it?
Hey Dave thanks for the info. All of my servers are running CF MX 6.1. Any idea if this is the back up files for CF 5 OR CF 6? Both? Thanks! Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 11:03 AM To: CF-Talk Subject: RE: CFMX_updater folder. Can I remove it? > I was just looking for a few MB to free up on the web server > and I see that the "F:\CFusionMX\CFMX_updater" folder is > about 120 MB. Can this be removed? Is it needed after the > update is run? That's just a backup of your files from before the update. You can safely delete it. However, you should probably upgrade to CFMX 6.1 if you can. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Ben in Boston?
I'll be there -- Tom Jordahl Macromedia Server Development -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 2:22 AM To: CF-Talk Subject: RE: Ben in Boston? I'll definitely be there as usual. For those of you that don't come regularly we also generally (even when Ben's not there) have at least two or three MM engineers at every meetings (remember that most of the CF team is still in the Boston area). they won't break their contracts, but sometimes they'll drop heavy hints. ;^) Jim Davis From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 3:52 PM To: CF-Talk Subject: Ben in Boston? Any of you guys/girls here from Boston? Will you be attending Boston CFUG meeting tomorrow night? I hear that Ben will be in the hizzouse... Ray _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Email Regex with weird results
The - needs to be the very last character in the class. This is because the - in any other postion indicates a range of chars. so \-_ is saying \]^_ (which is the \ character to the _ character in the ascii table) Jerry Johnson >>> [EMAIL PROTECTED] 07/01/04 11:56AM >>> All: I've been using a regex found on this list to validate email addresses. I've now run into a problem with the regex that I can't solve. Any help would be greatly appreciated. The email address is not required so the field can either be left blank or must contain a valid email address. The regex validation code follows: (REFindNoCase("^[a-zA-Z]([[:alnum:]\-_]+\.?)*@([[:alnum:]\-_]+\.)+[a-zA-Z]{2 ,4}$", FORM.Email) EQ 0)> Email address is invalid The email address is of the form "[EMAIL PROTECTED]" (that is, the domain contains a dash). If I remove the dash from the domain, the address validates. However, the dash should be valid. Looking at the regex, doesn't the ([[:alnum:]\-_]+\.) portion after the @ symbol allow for dashes? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Email Regex with weird results
\- means no dashes! Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> > http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm Massimo very cool. does it handle BIDI? i've been looking for a tree that understands BIDI for quite a while. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Ben in Boston?
So the bigger question is anybody going out for 'libations at a local bar' afterwords? I live in NH and usually have to catch the train (when I make the meetings, only been to a handful), but tonight might be a different story Ray At 12:02 PM 7/1/2004, you wrote: > > >I'll be there > > > >-- >Tom Jordahl >Macromedia Server Development > >-Original Message- >From: Jim Davis [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 01, 2004 2:22 AM >To: CF-Talk >Subject: RE: Ben in Boston? > > > >I'll definitely be there as usual. > >For those of you that don't come regularly we also generally (even when >Ben's not there) have at least two or three MM engineers at every meetings >(remember that most of the CF team is still in the Boston area). they won't >break their contracts, but sometimes they'll drop heavy hints. ;^) > >Jim Davis > >From: Ray Champagne [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 30, 2004 3:52 PM >To: CF-Talk >Subject: Ben in Boston? > >Any of you guys/girls here from Boston? Will you be attending Boston CFUG >meeting tomorrow night? I hear that Ben will be in the hizzouse... > >Ray > > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX_updater folder. Can I remove it?
> All of my servers are running CF MX 6.1. Any idea if this is > the back up files for CF 5 OR CF 6? Both? Those would be backup files from when you installed an updater to CFMX 6.0. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: TreeMenu for Fusebox/CF site
> > > http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm > > Massimo > > very cool. does it handle BIDI? i've been looking for a tree that > understands BIDI for quite a while. > I have no idea, sorry. I never tried BIDI until now. The XHMTL and CSS code should, at least in theory, works with BIDI as well. You could give it a try... In case you get stuck feel free to contact me directely at: [EMAIL PROTECTED] Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Email Regex with weird results
I use function IsEmail(str) { var sInvalidCharsPattern = "[^[:alnum:[EMAIL PROTECTED]']"; var sFormatPattern = "([a-z0-9][-._a-z0-9]*)[EMAIL PROTECTED]([a-z0-9][-_a-z0-9]*\.)+[a-z]{2,7}"; var sStrippedEmail = REReplaceNoCase(Trim(str), sInvalidCharsPattern, "", "ALL"); str = Trim(str); if (Len(str) EQ Len(sStrippedEmail)) return IIF(REFindNoCase(sFormatPattern, str) EQ 1, true, false); else return false; } which allowed the - HTH Mike On Thu, 1 Jul 2004 11:56:23 -0400, Mosh Teitelbaum <[EMAIL PROTECTED]> wrote: > All: > > I've been using a regex found on this list to validate email addresses. > I've now run into a problem with the regex that I can't solve. Any help > would be greatly appreciated. > > The email address is not required so the field can either be left blank or > must contain a valid email address. The regex validation code follows: > > > (REFindNoCase("^[a-zA-Z]([[:alnum:]\-_]+\.?)*@([[:alnum:]\-_]+\.)+[a-zA-Z]{2 > ,4}$", FORM.Email) EQ 0)> > Email address is invalid > > > The email address is of the form "[EMAIL PROTECTED]" (that is, the domain > contains a dash). If I remove the dash from the domain, the address > validates. However, the dash should be valid. > > Looking at the regex, doesn't the ([[:alnum:]\-_]+\.) portion after the @ > symbol allow for dashes? > > TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Service Patch2 and ColdFusion?
Hey guys... Has anyone downloaded and installed the New Service patch 2 for Win XP? Can be found here: http://v5.windowsupdate.microsoft.com/en/default.asp I have installed it on a test system and have found several issues with its new security features it seems to have strict Active Content filtering now. I was wondering if there are any issues with ColdFusion or anything else that you guys may have run into. I'm trying to make sure our Intranet site stay working when this thing is released. Does anyone know of a site or list that address all the various issues? Neal Bailey Internet Marketing Manager E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GMAIL Invite - First request gets it
Kay Smoljak wrrote: > I'm actually thinking of exporting certain client emails from Outlook > to a database and writing a CF app to allow members of my team to > search through them on our intranet. Has anyone tried anything like > this before? Yes. My Outlook 2003 will create and export directly to an Access database using just Outlook's export routine. Should be duck soup to do a search app from there. In fact, I'd *love* to get hold of a copy of that app if you're inclined to share. :-) -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
sot: login box
I've done this before once or twice, but for the life of me can't figure out how or where, so here goes: I'd like to display some text in an input type="password" box for a login form. Once the user begins to type in their password, it should revert to the normal behavior of replacing the text with stars. In other words, right now I have a form where the value of the username field is "username" and the value of the password field is "password" This second field, though, shows up as stars as it is a password field. I have some _javascript_ that clears the value of the username field onFocus so the user can enter their username. I'd like to do the same with the password field. I have some gmail invites left if anyone is interested and can help me jog my memory :-) Thanks, Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Email Regex with weird results
Jerry (and everyone else): Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Jerry Johnson [mailto:[EMAIL PROTECTED] wrote: > The - needs to be the very last character in the class. > This is because the - in any other postion indicates a range of chars. > so \-_ is saying \]^_ (which is the \ character to the _ character in > the ascii table) > > Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Ben in Boston?
I blogged my notes from Ben's presentation in Philly on Tuesday night if anyone is interested: http://www.fus.net/2004/06/good-things-from-macromedia.html Matt - Original Message - From: Scott Brady <[EMAIL PROTECTED]> Date: Thu, 1 Jul 2004 07:53:30 -0700 Subject: Re: Ben in Boston? To: CF-Talk <[EMAIL PROTECTED]> Original Message: > From: Michael Dinowitz > She really means DON'T MISS IT! The NYCFUG meeting went for about 3 > hours and let me say that Ben covered items in Blackstone that were > not covered at CFUN, not covered in the world wide meeting, just plain > not covered before. So, spill it! What new things did he cover? Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: xForms and CF
Ben Forta gave a peek into the next version of Blackstone last night (June 30, 2004) at the NYCFUG meeting and I think XForms integration would be a great addition. It may be incorporated into the next version of CF. XForms is something that you can do now, but its implementation is tedious. I believe XForms relies heavily on XPath, something well worth learning, but I haven't looked into it, yet. It looks very exciting. From what Ben demo'd and I can't wait to see what it will do for simplifying html form maintenance. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to do this join? (MySQL 4.0 can't do subqueries...)
Thanks for the reply... Yes, MySQL does now support subqueries, but not the production version. I won't be going to 4.1 until it's in production, so I'm still using 4.0.x, which doesn't support subqueries. And, the first thing I did was to consult the MySQL documentation on the precise pages your refer to, but I couldn't make my query work from the examples given... Your query below worked...I tried almost the exact same version, but I don't think I tried the WHERE clause that you used...and it's the last line that gives trouble logically... "WHERE newsletter_subscriptions.Subscriber_ID IS NULL" I've got to just sit and ponder the logic of the that statement in relation to the join. I use joins very seldom, so they give me fits every time I have to use one... But that's enough rambling! Thanks for the solution! Rick -Original Message- From: I-Lin Kuo [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 9:20 AM To: CF-Talk Subject: Re: How to do this join? (MySQL 4.0 can't do subqueries...) MySql now supports subqueries: http://dev.mysql.com/doc/mysql/en/Subqueries.html To see how to rewrite some subquery SQL as joins, go to http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html SELECT newsletter_series.Series_ID, newsletter_series.Series_Title FROM newsletter_series LEFT JOIN newsletter_subscriptions ON newsletter_series.Series_ID = newsletter_subscription.Series_ID AND newsletter_subscriptions.Subscriber_ID = '#CurrentSubscriber.Subscriber_ID#' WHERE newsletter_subscriptions.Subscriber_ID IS NULL --- Neculai Macarie <[EMAIL PROTECTED]> wrote: > > Hi, all. > > > > I've tried for hours to figure this out, but can't > get it... > > > > 3 tables... > > > > Newsletter_Series, Newsletter_Subscribers, > Newsletter_Subscriptions > > > > I need to run a query to get all Newsletter_Series > > which don't have Subscriptions for a particular > Subscriber... > > > > Primary Key Relationships: > > > > - Newsletter_Series.Series_ID / > Newsletter_Subscriptions.Series_ID > > - Newsletter_Subscriptions.Subscriber_ID / > > Newsletter_Subscribers.Subscriber_ID > > > > > > Can't do subqueries (aaargh!), so I'm left with a > join. > > > > Something like, > > > > > > > > Select newsletter_series.Series_ID, > > newsletter_series.Series_Title, > > from newsletter_series > > > > left join > > > > newsletter_subscriptions, > newsletter_subscribers > > on (newsletter_subscriptions.Subscriber_ID <> > > '#CurrentSubscriber.Subscriber_ID#' > > and newsletter_subscription.Series_ID <> > > newsletter_series.Series_ID) > > where newsletter_series.Series_ID is null > > > > > = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Apple Spotlight - Search Method?
On Jul 1, 2004, at 5:54 AM, George Abraham wrote: > This KWIC concept sounds cool. Any place I could find more info? > I got curious, so I googled for KWIC -- one thing lead to another. Here is an overall demonstration of the concept: http://coronet.iicm.edu/wbtmaster/courses/kwic_intro_start9.htm Hit the right arrow (upper right corner) to start the demo 1) I forgot that the early KWIC indexes published at IBM were done before widespread use of hard disks (a 10 meg drive cost about $13,000 per month) -- so KWIC (or any) indexing the full text of documents was impractical -- instead they prepared KWIC indexes of document titles. 2) Kwic indexing was developed by Hans Peter Lunn -- who went to work for IBM http://web.utk.edu/~jgantt/hanspeterluhn.html 3) As the computing industry advanced, a more general form of a KWIC index, called a concordance, became something of a CS Class exercise. http://www.cs.wm.edu/~noonan/cs312/homework/concordance/ 4) Further advances made it practical to provide KWICK/Concordance indexing of the full text of documents http://www.georgetown.edu/faculty/ballc/corpora/tutorial3.html 5) Today, several institutions, including Stanford University and Amazon.com use KWIC indexing to augment Full text searches. What appears to happen is this: a) A keyword search is performed title, author, bio, as well as the content of the documents (using boolean logic, stemming, synonyms, whatever) b) For any hits found in the full-text content are extracted along with a given amount of leading and training words. A quick index is then dynamically generated on the extracted lines. c) the extracted text snippets are presented with the keywords highlighted (bold color) as a more detailed subindex of the particular document. http://www.infotoday.com/newsbreaks/nb031103-1.shtml http://highwire.stanford.edu/inthepress/asbmb/asbmb_2003feb.dtl First of all, this really isn't a KWIC index -- all it is is a text snippet with the hit words highlighted. Second the "KWIC" index only appears if the keywords do not all appear in the title/author/bio Third the "KWIC" index is subordinate to, and relative to a single document -- you do not get the advantage of seeing the results of all the documents "In Context" What I think would be much more useful would a composite KWIC index of all the hits (with a link to the doc). Apple's search technology (kind of) uses KWIC-type indexing in iTunes -- they just don't rearrange the text nor highlight the hit words -- the just display the text "as-is". Based on my experience of finding things with KWIC, I think modern search techniques are missing something by not fully exploiting the KWIC way of presenting results -- it is ugly, but a human can very quickly scan the (KWIC Formatted) context of all the matches to find what he seeks. HTH Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Regex or ???
On Jul 1, 2004, at 7:59 AM, C. Hatton Humphrey wrote: > If a text input box is found, replace it with the text contained in > the "value" attribute. > If a checkbox, radio, hidden or password input box is found, remove > it. > If a select is found, replace it with the display of the selected > option. > If a textarea is found, replace it with the conents of the textarea. > > I know that I can do this by using a condition loop and a lot of > searching but is there a better way that it can be done? Regexps are a good choice. A good regexp engine (CFMX's or Java's?) can easily outperform any conditionals you could write. Best to not get too fancy -- just write 4 successive regexps that process the text HTH Dick "In times like these, it helps to recall that there have always been times like these." - Paul Harvey - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to do this join? (MySQL 4.0 can't do subqueries...)
Thanks for the reply, Ryan... I-Lin provided a query solution using a left join. I tried your query, but it didn't return the correct results. Tried changing the "AND newsletter_subscription.Series_ID is null" to "AND newsletter_subscription.Subscriber_ID is null", like was included as part of the join query that I-Lin proposed, but that didn't help. Thanks for your help, however... It's times like these that I am thankful for CF-Talk... I'm going to see if I can't make at least a small donation to Mike, every time I get a solution from this list that I couldn't solve. Imagine...if everyone did that, Mike could make a lot more... :o) Rick -Original Message- From: Ryan Duckworth [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:56 AM To: CF-Talk Subject: RE: How to do this join? (MySQL 4.0 can't do subqueries...) Newsletter_Series which don't have Subscriptions for a particular Subscriber... SELECT newsletter_series.Series_ID, newsletter_series.Series_Title FROM newsletter_series WHERE newsletter_subscriptions.Subscriber_ID = '#CurrentSubscriber.Subscriber_ID#' AND newsletter_subscription.Series_ID is null I believe this query will solve your problem. Can you send your table desctriptions? Also, If there is no subscription, I am assuming the newsletter_subscription.Series_ID would be null. Ryan Duckworth Macromedia Coldfusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66207 (913) 754-4272 -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 9:40 PM To: CF-Talk Subject: How to do this join? (MySQL 4.0 can't do subqueries...) Hi, all. I've tried for hours to figure this out, but can't get it... 3 tables... Newsletter_Series, Newsletter_Subscribers, Newsletter_Subscriptions I need to run a query to get all Newsletter_Series which don't have Subscriptions for a particular Subscriber... Primary Key Relationships: - Newsletter_Series.Series_ID / Newsletter_Subscriptions.Series_ID - Newsletter_Subscriptions.Subscriber_ID / Newsletter_Subscribers.Subscriber_ID Can't do subqueries (aaargh!), so I'm left with a join. Something like, Select newsletter_series.Series_ID, newsletter_series.Series_Title, from newsletter_series left join newsletter_subscriptions, newsletter_subscribers on (newsletter_subscriptions.Subscriber_ID <> '#CurrentSubscriber.Subscriber_ID#' and newsletter_subscription.Series_ID <> newsletter_series.Series_ID) where newsletter_series.Series_ID is null I've tried a lot of variations and read the documentation, but can't get the results... Help, anyone? Rick Rick Faircloth WhiteStoneMedia.com -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.253 / Virus Database: 263.3.8 - Release Date: 6/30/2004 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Apple Spotlight - Search Method?
All right!!! Reading for the next 2-3 days!! Thanks a bunch for the legwork Dick! George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]