SQL Multiple Reference Tables Question - Thanks

2003-03-01 Thread Adam Cantrell
James, Dina is correct - 'LEFT JOIN' is the same as 'LEFT OUTER JOIN' for most RDBMS's. Some will actually require LEFT OUTER JOIN, but I think that's rare these days. The LEFT/LEFT OUTER is more loose - it's like telling the DB: give me all the records in the left table, and then if there are

anybody ever done: every n day of the month for a year ...

2003-03-01 Thread Adam Cantrell
At least you and I learned something. What was I thinking with the dateAdd+4weeks thing, I've built calendars before and should know better ;) surry bout that. Adam. ~| Archives:

anybody ever done: every n day of the month for a year ...

2003-03-01 Thread Adam Cantrell
I know you're already well on your way with the UDF, but while watching a little TV tonight I figured I would toy around during the commercials just for sport. I was still able to fit the logic on one line within the loop - tee hee: !--- the day of week you want to use - using tuesday here---

anybody ever done: every n day of the month for a year ...

2003-03-01 Thread Adam Cantrell
went to paste this into another app and noticed that the first var should just be myDay, not myDayOfWeek. must have been messin with it last minute when I went to email it to you - it werks I swear ;) here it is again. !--- the day of week you want to use --- cfset myDay = 3 !--- the Nth

anybody ever done: every n day of the month for a year ...

2003-03-01 Thread Adam Cantrell
damm I didn't read this one yet - mine does the same crap! screw it, I'll toy with it tomorrow maybe -- pft ;P Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

preserving original filenames

2000-08-30 Thread Adam Cantrell
In a web-based message center that includes the ability to attach files - I'm trying to ensure the consistency of the filenames that were sent, in otherwords - I want it to be the same filename that appears in the recipients mailbox. This sometimes does not happen because the files are uploaded

RE: preserving original filenames

2000-08-30 Thread Adam Cantrell
There are two ideas I've used in the past to deal with filename uniqueness issues. One is to name the file itself using an arbitrary name, but store the "real" name in the database, and use that real name when pushing the file to somewhere else. That works well using CFCONTENT, of course.

RE: Looking for work in SLC/OGDEN/BRIGHAM UT area

2000-08-29 Thread Adam Cantrell
Currently telecommuting is not optional. Applicants will need to commute to either Ogden, or Brigham City UT hehe, resume's in the mail -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

RE: Using COM with CF

2000-08-24 Thread Adam Cantrell
http://www.cfm-resources.com/members/comet/ That site is devoted to making COM and CF work nicely together. It's not too detailed yet, but it has a public forum that I'm sure will get more traffic as time goes by and more people run into COM issues with CF. -Original Message- From:

RE: cfcontent uncertainty

2000-08-24 Thread Adam Cantrell
http://207.208.210.117/beta/transcriptioncenter/test2.cfm here is the code CFHEADER NAME="Content-Disposition" value="inline; filename=D:\Attachments\ACF116.doc" CFCONTENT TYPE="application/unknown"this is a test I don't know what the significance of using that cfcontent is, but I threw it in

RE: cfcontent uncertainty

2000-08-24 Thread Adam Cantrell
Excellent - it works, and I also understand now. There are a few weird things, but it's not a big deal. Like when they first click the link, it says they are downloading the template name, but when they click "save to disk" it sets it to the correct name. Also, if they click "open from current

RE: Using COM with CF

2000-08-24 Thread Adam Cantrell
- From: Adam Cantrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 7:31 AM To: [EMAIL PROTECTED] Subject: RE: Using COM with CF http://www.cfm-resources.com/members/comet/ That site is devoted to making COM and CF work nicely together. It's not too detailed

cfcontent uncertainty

2000-08-23 Thread Adam Cantrell
H, not to bug you all again on this subject, but could somebody please post some code of their use of the cfcontent tag? I'm trying to devise a plan to push files to a user's browser without exposing my directory structure to the world. Can't seem to accomplish this - they are all going to

OT: ftp server that auths from an odbc ds

2000-08-23 Thread Adam Cantrell
Does anybody know of an FTP server that can authenticate off of an ODBC datasource? Sorry, I know this isn't CF related, but I figured nobody knows more about odbc than a group of CF'ers. Adam. -- Archives:

RE: cfcontent uncertainty

2000-08-23 Thread Adam Cantrell
That first example that uses the cfheader is exactly what i need to happen on my site, and it doesn't work at all. I actually copied your code (modified the query of course) to a tee and it still doesn't do anything. I get a blank page. Your example works flawlessly - I just don't get it.

RE: Problem with CFFTP

2000-08-22 Thread Adam Cantrell
So how do you maintain directory security? I know you could only display the files you want that particular user to beable to download, but what's stopping them from guessing other filenames in their browser to see if they can get anybody elses files? I have resorted to pulling the files out

RE: Problem with CFFTP

2000-08-22 Thread Adam Cantrell
9:37 AM To: [EMAIL PROTECTED] Subject: Re: Problem with CFFTP What do you mean by "cfcontent worked correctly"? CFCONTENT allows you to serve files from anywhere on the server that CF has access to. The files do not have to be in the web root. DC - Original Message - From: &q

dl the file - don't parse it

2000-08-21 Thread Adam Cantrell
I have an attachment directory that is used as a temporary file repository for our web based massage center. My problem is - when I link the browser to the attachment, if it's a .cfm, .jpg, .gif, .htm, etc - the browser parses it (or the server does in the case of the .cfm). I know this is

managing remote files

2000-08-16 Thread Adam Cantrell
Hello, I recently discovered that it was not possible to access files on a mapped drive using the common cffile/cfdirectory tags. I have set up ftp and am accessing the directory structure via cfftp. It works great, but I have a few concerns: would it be bad to set the initial connection name

RE: managing remote files

2000-08-16 Thread Adam Cantrell
just read my last post - should have been more consise: is it possible to move a file on an ftp server using cfftp or even a COM object? I would prefer cfftp. -Original Message- From: Adam Cantrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 10:39 AM To: [EMAIL

black arrays, hairy arrays, skinny arrays

2000-06-29 Thread Adam Cantrell
arraysort(testarray[2], "numeric", "desc") So what this is doing is setting a two column array, each containing numbers in an ascending fashion. The arraysort function on the last line (which causes an error, hope you know what I'm attempting to do) is sorting t

Re: sort an array

2000-06-28 Thread Adam Cantrell
Dan - Original Message - From: "Adam Cantrell" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 27, 2000 6:30 PM Subject: sort an array I'm trying to sort an array by a certain column. The documentation in either of Forta's books only span about 2

Re: CFDIRECTORY NT error 5719

2000-06-28 Thread Adam Cantrell
I was having all sorts of domain authentication issues with sp4, sometimes we would not even be able to log on to the domain from our workstations. I upgraded to sp6 on all the workstations and I haven't seen a problem with domain stuff since. Check the service packs on both your domain

sort an array

2000-06-27 Thread Adam Cantrell
I'm trying to sort an array by a certain column. The documentation in either of Forta's books only span about 2 or 3 pages on working with arrays so I'm wondering if anybody out there can point me to some examples of working with these. I am having no problem with all of the other functions,

Re: Textarea formatting question

2000-06-27 Thread Adam Cantrell
I just did that last week. I was temporarily putting the #textbody# variable in pre tag, but this string works better for what I was doing #ReplaceNoCase("#textbody#", Chr(13), "br", "ALL")# but I still haven't figured out how to filter out any unwanted tags that could easily cause damage -

Re: break within a text area

2000-06-22 Thread Adam Cantrell
Excellent - thanks Dave. Do you know why it was to be set as a variable first? If I just type it within the textarea tag - it just gets displayed. Oh well - it works now. - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent:

outputting from two places

2000-06-22 Thread Adam Cantrell
I have a cfx tag that returns records and I also have a query that will be returning records. The records that are to be returned have the same type of information. How can I output these records together like they were pulled from the same query? They need to mesh completely - like sorting by

break within a text area

2000-06-22 Thread Adam Cantrell
Hi, does anybody know how to set a page break within a textarea tag? I think I have the syntax incorrect using Chr(13). -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit

Re: break within a text area

2000-06-22 Thread Adam Cantrell
a Think it's Chr(10) Chr(13) -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -Original Message- From: Adam Cantrell [mailto:[EMAIL PROTECTED]] Sen

Re: CFLOCK timing out - why?

2000-06-21 Thread Adam Cantrell
I believe that the syntax for the cflock tag in 4.5 is different - you can omit the type attribute. You just need the scope and the timout. - Original Message - From: "Anthony Israel-Davis" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 1:59 PM Subject: CFLOCK

Re: CFLOCK timing out - why?

2000-06-21 Thread Adam Cantrell
I've been having cf administrator do all of my read-only locking automatically in a blind attempt to somehow decrease the overhead of actual code that needs to be read and processed. Who knows - maybe this increases it, but I just find it more convenient. Have you done any benchmarks to see

textarea funness

2000-06-20 Thread Adam Cantrell
Hi, I'm trying to find some good reference material for working with text within a text area. My specific questions are related to using this tag in a web based message center atmosphere: - how do I throw a few page breaks in there on a reply to give room to type without having to make the user

Re: CF and IIS on Separate Boxes

2000-06-11 Thread Adam Cantrell
Whatever directory your 'cfdocs' are in - go to /Administering_ColdFusion_Server/03_Configuring_ColdFusion_Server/admin0325. htm#1052402 and it will explain 'distributed cold fusion'. I messed with it once, and I know you have to run an extra service 'cfdist.exe' that listens for cold fusion

date functions on email headers

2000-06-07 Thread Adam Cantrell
This is a multi-part message in MIME format. --=_NextPart_000_005F_01BFCF9E.44271E60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I sent this out yesterday but the list was 'broken'. Is there a = function that deals with dates

date function

2000-06-06 Thread Adam Cantrell
something wrong? I would like an output of = May 26 2000. I guess I could trim after the first whitespace and then = do formatting from there, but if anyone has a better suggestion I would = appreciate it. Adam Cantrell --=_NextPart_000_00C6_01BFCF09.72BC94C0 Content-Type: text/html;

web based email client : reinventing the wheel

2000-05-23 Thread Adam Cantrell
performer in regards to web messaging. If anyone could point me to or provide me with source code, it would be much appreciated. Adam Cantrell -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http

RE: web based email client : reinventing the wheel

2000-05-23 Thread Adam Cantrell
] +Subject: Re: web based email client : reinventing the wheel + + +You should have a look at iMS from Coolfusion.com + +~Justin MacCarthy + +- Original Message - +From: Adam Cantrell [EMAIL PROTECTED] +To: [EMAIL PROTECTED] +Sent: Tuesday, May 23, 2000 4:15 PM +Subject: web based email

RE: web based email client : reinventing the wheel

2000-05-23 Thread Adam Cantrell
to be running this on Linux or NT ? + + +- Original Message - +From: Adam Cantrell [EMAIL PROTECTED] +To: [EMAIL PROTECTED] +Sent: Tuesday, May 23, 2000 5:03 PM +Subject: RE: web based email client : reinventing the wheel + + + + I have seen the infusion mail server - it's an awesome product, and I