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
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:
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---
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
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:
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
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.
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
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:
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
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
-
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
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
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:
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.
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
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
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
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
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
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
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
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
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,
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 -
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:
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
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
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
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
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
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
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
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
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;
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
]
+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
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
38 matches
Mail list logo