Cedric,
I didn't examine the query too well in the first place. The outer join doesn't work because of the filter on the table you want nulls in. I would suggest a UNION instead of an outer join. I'm not sure it's the most efficient solution though.
SELECT Q.QueueID, XUQ.AccessID,
Pascal Peters wrote:
SELECT Q.QueueID, XUQ.AccessID, Q.QueueName
FROM Queues Q
JOIN SecurityXrefUserQueues XUQ
ON XUQ.QueueID = Q.QueueID
WHERE XUQ.UserID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#url.uid#
UNION
SELECT Q.QueueID, NULL AS AccessID, Q.QueueName
FROM Queues Q
WHERE
I'm looking for a tutorial that would explain how to send HTML e-Newsletters. I am particular interesting in finding out how include graphics in the message. Any advice would be useful.
Dwayne Cole, MS in MIS, MBA
Florida AM University
Certified Advanced ColdFusion Developer
850-591-0212
Dwayne,
On Sunday, November 16, 2003, 9:00:58 AM, you wrote:
DC I'm looking for a tutorial that would explain how to send HTML
DC e-Newsletters. I am particular interesting in finding out how
DC include graphics in the message. Any advice would be useful.
All you need to do is code the images
Hello
I have a rather large page of code which ive been working on, and I get the
following error:
This _expression_ must have a constant value.
It doesn¹t give me a line number, or a code snippet, just that text.
As I said I have a lot of code (1000+ lines) and I cant quite tie down the
I have written an application that allows a user to log in.
When the user logs in I run the following code...
I first check to see if the user exisits. If so...
CFIF CheckUser.RecordCount GREATER THAN 0
CFSET Session.LoggedIn = True
CFELSE
CFSET Session.LoggedIn = False
/cfif
Then I set some
That might help:
http://www.easycfm.com/tutorials/pdf_output.cfm?tutorial_id=14'
Uwe
DC
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Jochem,
Thanks, that worked like a champ. I had a solution using 2 queries, but that
wasn't really elegant. This should be much better. Thanks!
Cedric
Subject: JOIN help
From: Jochem van Dieten [EMAIL PROTECTED]
Date: Sun, 16 Nov 2003 13:53:17 +0100
Thread:
To add another bit to this:
You can do the same thing as ubqtous referenced for images to your style
sheet call.Won't work on any kind of web mail, but not sure what your
project requirements are.Best used when you know your recipients are
using mail clients that can handle this (i.e. Outlook
Hey everyone,
Very soon I'll need to set up a system that will let users download files. The users will need to be logged in, so I'll be checking for a username and password before I let them download the file. The part I'm not sure about is protecting the file itself. I want the file to be
The part I'm not sure about is protecting the file itself. I want the
file to be protected so no one can brows to it by http.
Jeff,
A bit of pseudo code for you.
cfif loggedin IS true
cfcontent reset=yes
cfheader name=Content-Disposition
What you need is cfcontent tag. Set standard security in application.cfm file. Once user is logged in create a page under application.cfm control called download.cfm. In that file place cfcontent tag set for the file you wish user to get. User selects what he wants from index.cfm and gets
Use CFContent to pass the file to the user, but have it behind a login
type thing - then you can check that the user has rights to the relevant
file
With CFContent you can place the files anywhere on the hard disk, so
they can be nowhere near the browsable area
-Original Message-
From:
Jeremy Brodie wrote:
Larry,
Some of the critical questions to help you in your search.
1) Do you need to search locally from a CD/DVD or from a server?
2) In what file format is the manual (PDF, word docs, etc)
3) What will you use as your user interface for searching the manual
(flash,
If you put the downloadable files into the web root, then they're not at all
protectable by CF.
Downloadable files need to be placed somewhere off the web root.
-Original Message-
From: Paul Vernon [mailto:[EMAIL PROTECTED]
Sent: November 16, 2003 10:41 AM
To: CF-Talk
Subject: RE:
I've got an existing site for a large, day festival.The system has
three types of identification:
1) SessionID - ID stored in a non-persistent cookie.We store
clickstreams (page visits), for example linked to the SessionID.
2) ClientID - ID stored in a persistent cookie.We store, for
example,
Howdy,
What's the best way to compensate for time on a server in a hosted
environment when the time is set to a different time than a user's local
time zone? Ex: client is in Central Time, server is on Eastern Time (one
hour ahead); client wants everything to reflect local time.
Thanks.
--
Chris Montgomery wrote:
What's the best way to compensate for time on a server in a hosted
environment when the time is set to a different time than a user's local
time zone? Ex: client is in Central Time, server is on Eastern Time (one
hour ahead); client wants everything to reflect local
there is a great little cfc @ cfczone.org that paul hastings
whipped up that does some timezone work.best way, is to use
_javascript_ to get the time of the browser, set that timezone
offset as a cookie on the users browser, then access that
with the cookie. whatever you call it variable name in
Does that work in SQL 2000?
I've always used _javascript_ at logon to determine the time zone of the
user's computer.I then store the time zone offset in a cookie or
session/client variable.I then use a UDF to convert the time from the
SQL server to that user's local time.
If there was a way
Hi all,
We have just moved from Windows to Linux, and CF5 to MX.This move brought a whole host of unpleasant issues with it, mostly having to do with our download process.
1.Does anyone know of a really good zip tag that works with Linux?I loved Ben Forta's cfx_zip on Windows, but can't find one
i have site director3 and for some reason on my console
this is the error i get, when trying to load my order manager...
what does this mean?ihave cfabort at line 1.what gives?
thanks.
tony
Error Occurred While Processing Request
The system has attempted to use an undefined value, which usually
i have site director3 and for some reason on my console
this is the error i get, when trying to load my order manager...
what does this mean?ihave cfabort at line 1.what gives?
I have no idea, but I'd guess that the error is occurring in
Application.cfm.
Dave Watts, CTO, Fig Leaf Software
yeah, i thought the same, but on any other page
request, no error like that, ive actually narrowed it
down to some code in some cfcase tags, its weird...
tony
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:27 PM
To: CF-Talk
Subject: RE:
Weegs, I sure hope you got the monitor in one eye and an NFL game in the
other :-)
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:24 PM
To: CF-Talk
Subject: RE: weird one! help :)
yeah, i thought the same, but on any other page
request, no error like that,
If you want to it directly from SQL you can create a function and call
that from your sql query
create function localtime (@gmtdate datetime, @timezoneoffset int)
returns datetime
As begin
declare @localtime datetime
select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate)
return
but of course ;)
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:34 PM
To: CF-Talk
Subject: RE: weird one! help :)
Weegs, I sure hope you got the monitor in one eye and an NFL game in the
other :-)
_
From: Tony Weeg
but how are you going to *KNOW* the persons local time?
_javascript_ is the only way.
-Original Message-
From: Tim [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:35 PM
To: CF-Talk
Subject: RE: Compensating for Server Time
If you want to it directly from SQL you can create
read on tony, sorry, i see you were just explaining the way to the sql
in one shot :)
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:38 PM
To: CF-Talk
Subject: RE: Compensating for Server Time
but how are you going to *KNOW* the
Yes you can detect their time zone everytime they login or what I've
done in the past is to build it in to the users profile, so that the
user has the ability to select the time zone their in when they
create/update their profile.
-Original Message-
From: Tony Weeg [mailto:[EMAIL
sure, but just getting it from their browser time is the best way, if
you let them input it, they can mess it up, user error, one more thing
to tech support.
either way is fine, but somethign that is easy to abstract from a dumb
customer is always nice!
tony
-Original Message-
From: Tim
You guys are fantastic. I just talked to the crummy isp for the site and it looks like it may take some work to get them to allow me to use the cfcontent tag, but they are considering it. Looks like it is the way to go.
I'll report back if I can get them to switch it back on.
Thanks!!!
[Todays
Thats why I love hostmysite.com for my CF hosting needs.. They allow the
tags!
_
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 5:00 PM
To: CF-Talk
Subject: Re:Ideas needed! Password protect a file download.
You guys are fantastic. I just talked to the crummy
Sunday, November 16, 2003, 2:55:11 PM, Jochem van Dieten wrote:
I use the AT TIME ZONE functionality from SQL, it even
compensates for daylight savings time...
Thanks Jochem, Tony, Tim, Novak, et. al.
I'll look into your recommendations.
I should have clarified the situation a bit more,
Howdy Tony,
Sunday, November 16, 2003, 3:49:51 PM, Tony Weeg wrote:
there is a great little cfc @ cfczone.org
Ooops, forgot to mention: this is on CF5/Windows. I'll take a look at
the CFC anyway, might give me some good tips.
--
Chris Montgomery
Airtight Web
Looks like LocalTime() at cflib.org might be just what the doctor
ordered ( http://www.cflib.org/udf.cfm?ID=719 ). Gonna give it a try.
--
Chris Montgomery
Airtight Web Serviceshttp://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-2415
[Todays Threads]
Sunday, November 16, 2003, 6:14:47 PM, Chris Montgomery wrote:
LocalTime() at cflib.org
This UDF uses cffunction, which I guess is an MX tag. I converted Chad
Jackson's UDF to be compatible with CF5 (in case anyone else wants it).
Note that the offset is for Central Daylight Time (-6).
!---
Hey all,
I recently did something really dumb - I had a really small SQL server
database that I was using for a home project, and, during an upgrade fiasco
(long story), I deleted it by mistake.Now... I see that the .MDF and .LDF
files still exist in my MSSQL7/data folder, and I would like to
I recently did something really dumb - I had a really small
SQL server database that I was using for a home project, and,
during an upgrade fiasco (long story), I deleted it by mistake.
Now... I see that the .MDF and .LDF files still exist in my
MSSQL7/data folder, and I would like to
Open Enterprise Manager and right click the Databases folder. Choose attach
database from the all tasks menu. A new window will open which will allow
you to select the MDF file and attach the database.
chris
_
From: Robyn Follen [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003
Ah, perfect. This worked!
Thanks
-Robyn
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:42 PM
To: CF-Talk
Subject: RE: SQL server question
I recently did something really dumb - I had a really small
SQL server database that I was
I have never come across this in a ColdFusion.One way you can try to
pinpoint the error is to place cfabort statement at say, line 50. Run your
code and if you don't get an error, place the cfabort on line 100 and run
the code.Keep doing this until you get closer to the error.
Do you have any
i always use
Im here (#timeFormat(now(),'hh:mm:ss')# !
cfabort
and place it before trouble points, or after them to see
if they are really, trouble points.stepping through
the code, its the easiest way i can see for myself to debug, unless
i know *exactly* where the code is wrong, of course.
assuming that it is within
cfoutput/cfoutput tags, that is ;)
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 10:24 PM
To: CF-Talk
Subject: RE: Very vague error message
i always use
Im here (#timeFormat(now(),'hh:mm:ss')# !
cfabort
How about cftrace?
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 10:24 PM
To: CF-Talk
Subject: RE: Very vague error message
i always use
Im here (#timeFormat(now(),'hh:mm:ss')# !
cfabort
and place it before trouble points, or after them to see
if they are
how about it?
never used it :)
tw
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 10:33 PM
To: CF-Talk
Subject: RE: Very vague error message
How about cftrace?
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday,
Weegs, how did the test go?
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 10:37 PM
To: CF-Talk
Subject: RE: Very vague error message
how about it?
never used it :)
tw
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent:
taking it @ max on the 20th :)
studying while working tonight!!
tw
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 10:42 PM
To: CF-Talk
Subject: RE: Very vague error message
Weegs, how did the test go?
_
From: Tony Weeg
Cool. I wish I wasn't up Managerial accounting homework is not as much
fun as Cold Fusion Coding :-)
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 10:42 PM
To: CF-Talk
Subject: RE: Very vague error message
taking it @ max on the 20th :)
studying while
I'm attempting to setup a credit card gateway (Worldpay - select pro, java)
which requires some servlets to operate.Basically I'm having trouble
setting them up to run on the version of JRun that comes with CFMX, can
anyone offer a basic tutorial on what/how i have to configure on the server
to
Heya Will,
Are you running Enterprise or Standard? Unless you are running
Enterprise, then you can't use the included JRUN server to serve
anything but Cold Fusion templates... or thats what I understand
anyway...
What problem are you having, are they license violation errors?
bye
Monday,
Hi all,
Need some help with inserting rows into a 2d array. As an example I populate
an array with values cityName and LocationID from a query. I then need to
insert a new ROW between row 4 and row 5. In essence shifting rows 5 and
below down one row. I'd thought of appending to the array, then
1000+ lines of code in a single CF template seems a bit excessive for
starters.
Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609
Tel: (02) 62115927
Michael S.
HodgdonTo: CF-Talk [EMAIL PROTECTED]
53 matches
Mail list logo
