Just make sure that the account that CF is running as, can access the share and you
are away...
L.
-Original Message-
From: Taz [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2003 16:04
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Help on Verity
> I presume this is for the same reason a
Yeah,
I noticed that.
The third one I sent should work though.
Spike
Stephen Milligan
Team Macromedia - ColdFusion
Co-author 'Reality Macromedia ColdFusion MX: Intranets and Content
Management'
http://spikefu.blogspot.com
> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTEC
And for those of you that care... This is how you do it:
SELECT DISTINCT Role.Rolename, a.userid
FROM Role LEFT OUTER JOIN
(
SELECT UserRole.Roleid, UserRole.Userid
FROM UserRole
WHERE UserRole.userid = 84
) as a ON Role.roleID = a.roleId
WHERE Role.ApplicationID = 39
You have t
Spike,
> um...
>
> I haven't been paying attention to this so far, but from
> reading the original email wouldn't this do it?
>
> SELECT roles.roleid, roles.rolename, users.roleid
> FROM roles LEFT OUTER JOIN users ON roles.roleid =
> users.roleid WHERE users.userid = 84
>
> Spike
Not quite.
It is with the soxml tag ... er siteobjects.com if I remember right
Taz
> Yep, but with CF45 its not really an option... :-(
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
And another one with the userid column instead of a second roleid
column.
sheesh!
SELECT roles.roleid, roles.rolename, userrole.userid
FROM roles LEFT OUTER JOIN userrole ON roles.roleid = userrole.roleid
WHERE userrole.userid = 84 OR userrole.userid IS NULL
Spike
Stephen Milligan
Team Macrome
Sorry,
Couple of typos in that.
Try this one:
SELECT roles.roleid, roles.rolename, userrole.roleid
FROM roles LEFT OUTER JOIN userrole ON roles.roleid = userrole.roleid
WHERE userrole.userid = 84 OR userrole.userid IS NULL
Spike
Stephen Milligan
Team Macromedia - ColdFusion
Co-author 'Reality
um...
I haven't been paying attention to this so far, but from reading the
original email wouldn't this do it?
SELECT roles.roleid, roles.rolename, users.roleid
FROM roles LEFT OUTER JOIN users ON roles.roleid = users.roleid
WHERE users.userid = 84
Spike
Stephen Milligan
Team Macromedia - ColdF
>
> SELECT role.roleid, role.rolename, userrole.userID
> FROM Role AS role
> INNER JOIN userrole AS userrole ON role.roleid =
> userrole.roleid WHERE role.applicationid = 39 AND userrole.userID = 84
>
It gives me what I could always get (read first email) which is everything
that links both, BU
>
> SELECT a.roleid, a.rolename, b.userid
> FROM role a
> LEFT JOIN userrole b
> ON a.roleid = b.roleid
> WHERE a.applicationid = 39
> OR b.userid = 84
>
> ?
>
Returns
147 Guest 77
145 Application Editor 55
146 User E
SELECT role.roleid, role.rolename, userrole.userID
FROM Role AS role
INNER JOIN userrole AS userrole ON role.roleid = userrole.roleid
WHERE role.applicationid = 39 AND userrole.userID = 84
try that. should only return results that have the same roleid and match the
other two criteria. hope thats
SELECT a.roleid, a.rolename, b.userid
FROM role a
LEFT JOIN userrole b
ON a.roleid = b.roleid
WHERE a.applicationid = 39
OR b.userid = 84
?
Its much easier when we can see exactly what the tables look like.
> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: 29
Okay... Full code:
SELECT roleid, rolename
FROM Role
WHERE applicationid = 39
Result:
Roleid Rolename
145 Application Editor
146 User Editor
147 Guest
148 Editor
149 Another Role
SELECT roleid, userid
FROM userrole
W
Haven't you tried LEFT OUTER joins?
Paolo
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 15:52
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] SQL: Completely half asleep
ok hang on,
how can you get this as the final result:
Fld1 Fld2 Fld4
145 val
use the Query functions, QueryNew, QuerySetCell etc, to construct a new
query based on your two queries.
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
-
ok hang on,
how can you get this as the final result:
Fld1 Fld2 Fld4
145 val1 vala
146 val2 valb
147 val3 NULL
148 val4 valc
149 val5 NULL
(ir fld4 to have multiple values) when you want fld4 = 84?
or perhaps I'm not understanding.
> -Original Message-
> From: Paul Johnston [mai
Ooops!
SQL 2K
> Can you you isNULL with mySQL?
>
> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 15:52
> To: [EMAIL PROTECTED]
> Subject: RE: [ cf-dev ] SQL: Completely half asleep
>
>
> > SELECT a.fld1, a.fld2, b.fl4
> > FROM tbl1 a
> >
Hi is there anyway to combine these two queries without using union? We
are on a version of MySQL that does not support UNION.
SELECT storySub.storyid, journoDetails.journoid, towns.town,
journoDetails.journoName, region.regionid
FROM storySub, towns LEFT JOIN journoTown ON towns.townid = jou
Can you you isNULL with mySQL?
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 15:52
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] SQL: Completely half asleep
> SELECT a.fld1, a.fld2, b.fl4
> FROM tbl1 a
> LEFT INNER JOIN tlb2 b
> ON a.
> SELECT a.fld1, a.fld2, b.fl4
> FROM tbl1 a
> LEFT INNER JOIN tlb2 b
> ON a.fld1 = b.fld1
> ORDER BY a.fld1
>
Doesn't work.. Problem is that I have criteria to match on both sides.
Remember I need to test what a.fld3 is and b.fld4 is
It's just a bit strange, because ths query is ea
SELECT a.fld1, a.fld2, b.fl4
FROM tbl1 a
LEFT INNER JOIN tlb2 b
ON a.fld1 = b.fld1
ORDER BY a.fld1
?
> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 15:26
> To: [EMAIL PROTECTED]
> Subject: [ cf-dev ] SQL: Completely half aslee
Yep, but with CF45 its not really an option... :-(
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 15:26
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Escaping commas in CSV
> ? use a double quotes for a comma seperated file?
>
> I am thinking t
Two tables, two selects:
SELECT fld1, fld2
FROM tbl1
WHERE fld3 = 39
SELECT fld1, fld4
FROM tbl2
WHERE fld4 = 84
This gives:
Fld1 fld2
145 val1
146 val2
147 val3
148 val4
149 val5
And
Fld1 fld4
145 vala
146 valb
148 valc
What I want is this table:
Fld1 Fld2 Fld4
145 val1 vala
146
> ? use a double quotes for a comma seperated file?
>
> I am thinking that using Flat files such as CSV is bad and I
> am looking into alternatives. All I will be doing it
> exporting data from SQL Server using CF either via inline SQL
> or SP and then providing a link for a user to download
either that or union the two outputs together ?
ALex
-Original Message-
From: Alex Skinner [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 15:15
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] SQL Headache
2 seperate queries used in an in statement ?
SELECT DISTINCT STORY ID,otherfiel
2 seperate queries used in an in statement ?
SELECT DISTINCT STORY ID,otherfields FROM allstories WHERE storyid IN
(select query for story joined against towns)
OR storyid IN (select query joined against region)
Yes I know its not all sql but you get the idea
Alex
-Original Message-
The problem I am having is that if I do it as a separate query then the
wrong story may get sent to the wrong journalist.
I am having trouble seeing the wood from the trees today. I'll try to
break it up into something simpler.
Cheers
Dave
At 14:02 1/29/2003 +, you wrote:
can you just d
? use a double quotes for a comma seperated file?
I am thinking that using Flat files such as CSV is bad and I am looking into
alternatives. All I will be doing it exporting data from SQL Server using
CF either via inline SQL or SP and then providing a link for a user to
download a readable for
> Nah, I didnt think so... what would your suggestions be of
> exporting data from a db into a user readable format? What
> approach would you take? Excel? CSV? etc...
When exporting from most db's you can specify field separators and also you
can specify field wrapping. When you export from m
double quotes is the usual qualifier for csv's...
-Original Message-
From: Douglas Humphris
Sent: 29 January 2003 14:20
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Escaping commas in CSV
You need to qualify the columns so that any comma inside a column is not mistaken for
a seperator
are you having trouble with an insert of content that someone has
written that be an arse. I think this has been covered again and again
in recent months, and as I recall this is not an easy thing to do first
of all how do you determine which commas to escape, if you get that far,
then y
>
> replace(list,",","","ALL")
>
Actually, having looked at the standard (apparently there is one!) you can
put commas in a csv field, so long as the record is wrapped in double
quotes, so:
So when creating the csv file, I would wrap each field that may have commas
in, with double quotes...
HT
You need to qualify the columns so that any comma inside a column is not mistaken for
a seperator.
This function might be useful, but watch you don't qualify the commas that don't
separate:
listqualify(list, qualifier, [delimiters], [elements])
HTH Doug
-Original Message-
From: Robert
Nah, I didnt think so... what would your suggestions be of exporting data
from a db into a user readable format? What approach would you take?
Excel? CSV? etc...
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 14:20
To: [EMAIL PROTECTED]
Subject: RE
> replace(list,",","","ALL")
That's not escaping it, that's just removing it!
How about URLEncoding any data? CSV was never meant to be a good storage
format, just a simple one. As far as I know, there is no way of doing a
standard escaping of data in CSV
Paul
> At 14:03 29/01/2003 +, you
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 14:14
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Escaping commas in CSV
replace(list,",","","ALL")
At 14:03 29/01/2003 +, you wrote:
>brain fart...
>
>Whats the best way to escape commas from da
replace(list,",","","ALL")
At 14:03 29/01/2003 +, you wrote:
brain fart...
Whats the best way to escape commas from data so it can be written safely to
a CSV file?
N
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
Fo
brain fart...
Whats the best way to escape commas from data so it can be written safely to
a CSV file?
N
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help,
can you just do a second query for the additional info you need?
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
-
Hi,
I am having a complete '4 hour sleep' foggy brain day today and I need to
get a query written and the fog is not helping:
I have the following situation: Journalists are linked to either towns
and/or regions and national options. Any one journo can be assigned to a
region and several t
yep, very strange... I couldn't be arsed with it so went to
www.p3ptoolbox.org..
-Original Message-
From: Peter Harrison [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 12:15
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Two Domains : Cookie problem
fails for me, didn't check why tho.
fails for me, didn't check why tho.
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 11:59
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Two Domains : Cookie problem
can anyone get to the address below? It seems to hang for me?
-O
hmmm...arse.
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 12:04
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Two Domains : Cookie problem
yes
At 11:58 29/01/2003 +, you wrote:
>can anyone get to the address below? It seems to hang for me?
>
>
yes
At 11:58 29/01/2003 +, you wrote:
can anyone get to the address below? It seems to hang for me?
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 11:00
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Two Domains : Cookie problem
www.w3c.org/p3p
can anyone get to the address below? It seems to hang for me?
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 11:00
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Two Domains : Cookie problem
www.w3c.org/p3p
At 10:52 29/01/2003 +, you wrote:
>Ric
in the second instance then ("it actually totally redirects you to .co.uk
in the UL"), surely the cookies wouldn't be an issue, as no cfm page
processing would even be done? assuming you're using the web server or dns
to redirect, and not some javascript, meta refresh or cflocation.
Duncan Cumm
jubbly...
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 11:00
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Two Domains : Cookie problem
www.w3c.org/p3p
At 10:52 29/01/2003 +, you wrote:
>Rich, can you give me some more info on this? Where ca
www.w3c.org/p3p
At 10:52 29/01/2003 +, you wrote:
Rich, can you give me some more info on this? Where can I get such a
policy?
Contact me OL if you need to.
Thanks
N
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 10:50
To: '[EMAIL PROTECTED]
Rich, can you give me some more info on this? Where can I get such a
policy?
Contact me OL if you need to.
Thanks
N
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 10:50
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Two Domains : Cookie problem
c
I have tried it with both and they both fail. I had it so when you went to
the .com it was actually loading the .co.uk site, but the URL stayed the
same and I have also tried it that when you goto .com it actually totally
redirects you to .co.uk in the UL.
N
-Original Message-
From: [EMA
create a digital p3p policy for the third party site. Then you'll be fine.
We had to send the compact policy in the headers from IIS, but you need a
p3p file there also.
> -Original Message-
> From: Robertson-Ravo, Neil (RX)
> [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 10:46
> To:
when you say the .com redirects to the .co.uk, do you mean if i go to
blah.com, it then changes the URL to blah.co.uk, or are you just pointing
the A records to the same IP address as the .co.uk?
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575
All,
We are having a cookie problem, and hopefully someone can give me an answer
on this, we have two domains registered for a site : one of them as a .co.uk
and one of them as a .com. The .co.uk is the standard URL for this site
and when you resolve the .com, it redirects to the .co.uk - simple
LOL :-) but we all know who would win
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 10:01
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Submit buttons
Right! Before blows get traded (and we don't want THAT do we!) I've sorted
it out by usin
Right! Before blows get traded (and we don't want THAT do we!) I've sorted
it out by using a type="Button" and a type="Submit" and changing specific
values when the button is clicked.
Thanks for everyone's help (even if they didn't always read the question
first - it's okay, everyone does it)
P
You cant do it with HTML
that is not the point
you misread the question
Two submit buttons on one form. One does one thing, one
another (surprisingly).
However, I've forgotten how to say which one is the default
if the user hits return...
Notice the problem is not making the buttons do di
> Just to throw this out into the mix we have a Java class (and
> UDF library) for validating email addresses at:
> http://www.cfdev.com/email/
>
> Besides checking syntax, and all valid TLD's it can also do a
> MX lookup
> (DNS) to validate that the domain is indeed valid. And if you
> want t
OK, you give me an alternative with HTML?
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2003 19:51
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Submit buttons
That is not what he asked is it.
> -Original Message-
> From: Robertson-Ravo, Ne
58 matches
Mail list logo
