date:20040701

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)

2004-07-01 Thread James Smith

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!!

2004-07-01 Thread Pascal Peters

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...)

2004-07-01 Thread Neculai Macarie

> 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

2004-07-01 Thread Ubqtous

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

2004-07-01 Thread John Beynon

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

2004-07-01 Thread Spectrum Web

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

2004-07-01 Thread Ubqtous

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

2004-07-01 Thread Doug Hughes

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?

2004-07-01 Thread George Abraham

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

2004-07-01 Thread Greg Luce

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

2004-07-01 Thread Alexander Sherwood

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

2004-07-01 Thread Ray Champagne

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

2004-07-01 Thread G

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

2004-07-01 Thread Mickael

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)

2004-07-01 Thread Samuel Neff

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...)

2004-07-01 Thread I-Lin Kuo

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

2004-07-01 Thread Howie Hamlin

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

2004-07-01 Thread Greg Luce

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?

2004-07-01 Thread Peterson, Andrew S.

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

2004-07-01 Thread George Abraham

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?

2004-07-01 Thread brobborb

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?

2004-07-01 Thread Todd

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)

2004-07-01 Thread Michael Wilson

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?

2004-07-01 Thread Robertson-Ravo, Neil (RX)

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?

2004-07-01 Thread Ray Champagne

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?

2004-07-01 Thread brobborb

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?

2004-07-01 Thread brobborb

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,

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?

2004-07-01 Thread Peterson, Andrew S.

-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?

2004-07-01 Thread Tangorre, Michael

> 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?

2004-07-01 Thread Samuel Neff

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?

2004-07-01 Thread Jochem van Dieten

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

2004-07-01 Thread Buddy Langston

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?

2004-07-01 Thread Frank Mamone

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?

2004-07-01 Thread Daniel Mackey

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

2004-07-01 Thread Spectrum Web

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

2004-07-01 Thread Paul Kenney

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

2004-07-01 Thread Doug James

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

2004-07-01 Thread Mickael Elmalem

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

2004-07-01 Thread Doug James

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?

2004-07-01 Thread Ben Densmore

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?

2004-07-01 Thread Scott Brady

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

2004-07-01 Thread Thomas Chiverton

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...)

2004-07-01 Thread Ryan Duckworth

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 ???

2004-07-01 Thread C. Hatton Humphrey

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?

2004-07-01 Thread Mark W. Breneman

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

2004-07-01 Thread Mickael Elmalem

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?

2004-07-01 Thread Marlon Moyer

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?

2004-07-01 Thread Todd

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

2004-07-01 Thread Mickael Elmalem

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

2004-07-01 Thread Alan Bleiweiss

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)

2004-07-01 Thread Damien McKenna

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...)

2004-07-01 Thread Rick Faircloth

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?

2004-07-01 Thread Dave Watts

> 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

2004-07-01 Thread Mosh Teitelbaum

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?

2004-07-01 Thread Mark W. Breneman

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?

2004-07-01 Thread Tom Jordahl

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

2004-07-01 Thread Jerry Johnson

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

2004-07-01 Thread Paul Vernon

\- means no dashes!

 
Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: TreeMenu for Fusebox/CF site

2004-07-01 Thread Paul Hastings

> > 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?

2004-07-01 Thread Ray Champagne

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?

2004-07-01 Thread Dave Watts

> 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