I have used it when the need arises to write a big longwinded proposal. But
generally I'm too lazy to do those things, and we have a new CRM guy to do
things like that now :-)
It's easier than doing it from scratch though and looks professional.
Russ
-Original Message-
From: Jennifer
Mike Soultanian wrote:
As far as the single quotes, I think I remember that I needed to use
single quotes when using Oracle. I'm guessing double quotes are used
for SQL?
Single quotes are used to delimit strings, double quotes are used
to delimit identifiers.
Jochem
Man I love my job. Proposals for me go something like this:
1) Department: We need a system to do this
2) Me: OK, this is how we are doing it *hands over specs doc*
On 1/8/06, Snake [EMAIL PROTECTED] wrote:
I have used it when the need arises to write a big longwinded proposal. But
generally
One benefit is in spam scoring. For example, Mdaemon (mail
server I use) allows point scoring of spam. As well as other
point modifiers, it can be selected that is there is no SPF
for the incoming email, or the SPF record says the email is
not originating from a valid mail server points
OK, so seems SPF isnt going to get me anything. What about adding the dul
blacklist from sorbs? I'm trying to stop viruses, and it seems they all come
from DHCP addresses.
If I added the DHCP address to my spam filter, wouldnt i be able to block those?
Also, if I do that, will I still be able
right, it is full text indexing, but I thought that's what this thread
was about since I'd never consider verity and sql indexing to be even
slightly on par with eachother. I guess I read it wrong.
On 1/7/06, Paul Hastings [EMAIL PROTECTED] wrote:
Zaphod Beeblebrox wrote:
really? I'm using
SPF does help in scoring spam, I use it myself and it works alongside other
anti spam measures just fine.
I'm not sure why you are talking about DHCP addresses as these are only used
on an internal network and not across the internet. DHCP addresses are
issued on request from an address pool by
I'm not sure why you are talking about DHCP addresses as
these are only used on an internal network and not across
the internet. DHCP addresses are issued on request from an
address pool by a DHCP server, typically on the Class A, B,
C reserved IP ranges (10.x.x.x, 172.16.x.x and
Jennifer Gavin-Wear wrote:
SPF does help in scoring spam, I use it myself and it works alongside other
anti spam measures just fine.
I'm not sure why you are talking about DHCP addresses as these are only used
on an internal network and not across the internet.
DHCP, or a tunneled variant
I just had this weird problem again today that I get every so often.
I modify my SQL database, add some new tables or columns to an existing
table, but CF cannot find them.
I have to restart CF before it can see the changes I have made. Sometimes
even restarting CF doesn't fix it.
The queries
Snake wrote:
I modify my SQL database, add some new tables or columns to an existing
table, but CF cannot find them.
I have to restart CF before it can see the changes I have made. Sometimes
even restarting CF doesn't fix it.
The queries themselves are not being cached, as they pickup new
I've seen it when query paraming before. I added a line break to my SQL and
it fixed it.
Although your problem sounds like it might be different.
Ade
-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 08 January 2006 18:22
To: CF-Talk
Subject: Database schema caching
I
Oh and I should have said, you'll likely be getting this because you have
SELECT *, if you have the column names the SQL will be different and will
force a new recompile.
Ade
-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 08 January 2006 18:22
To: CF-Talk
Subject:
I'm authenticating a user on site A (username,password), but then want
automatically pass the db vars (name, studentID(UUID), courseName) to a
second, unrelated site, not on my server, so this second site can let them
in.
After authentication I've tried:
1) cflocation, but that displays all the
Hi Mark,
You might want to make the form action page on your site set the field names
again and then use a second submit with on body load event which processes
the form of hidden fields to the form action page of the second site to
process the request.
Casey Dougall
www.LakeGeorge.com
I've been testing out Alagad Image Component and I'm having a strange
problem.
Here is my setup:
http://www.twilighted.com/clayto/design/alagad/pixelcolor.cfm
As you can see, when you click on the image it returns the color. Strangely
though, if you click too far to the right it returns this
I've been testing out Alagad Image Component and it's been great. However,
I'm having one peculiar problem.
Here is my setup:
http://www.twilighted.com/clayto/design/alagad/pixelcolor.cfm
As you can see, when you click on the image, it returns the coordinates of
the click in the URL, and Alagad
You might want to make the form action page on your site set the field
names again and then use a second submit with on body load event which
processes the form of hidden fields to the form action page of the second
site to process the request.
Yes, I originally thought of that, though I'm not
Hi Dave,
Absolutely, that's why I said, In situations where your IP address will
vary because you are getting it
from a DHCP pool then it's impossible to do any authentication against the
IP address unless you allow/block the whole DHCP range.
Jenny
-Original Message-
From: Dave Watts
I'll have to kick the people who wrote my TPC/IP manual then, and as of when
I did sample tests for MCSE they also have the Class addresses wrong!
Whether you control the DHCP server or not you would still have to delecare
the IP address range in firewall and mail server configs.
Jenny
thanks Ade, explains a problem I've had for a while :-)
Jenny
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 08 January 2006 18:31
To: CF-Talk
Subject: RE: Database schema caching
Oh and I should have said, you'll likely be getting this because you have
SELECT *,
Whether you control the DHCP server or not you would still
have to delecare the IP address range in firewall and mail
server configs.
If you control the DHCP server, you can create reservations which will
always provide the same IP address to a specific MAC address. So you needn't
filter the
Absolutely, that's why I said, In situations where your IP
address will vary because you are getting it from a DHCP pool
then it's impossible to do any authentication against the
IP address unless you allow/block the whole DHCP range.
OK, I may have misunderstood you. I was simply
It's an error in the CFC.
Search for this line:
cfif arguments.y LT 0 OR arguments.x GTE getHeight()
Replace with:
cfif arguments.y LT 0 OR arguments.y GTE getHeight()
-Original Message-
From: Michael Clayton [mailto:[EMAIL PROTECTED]
Sent: Monday, 9 January 2006 10:16 a.m.
To:
Re-reading what I said I did start off wrong .. :-)
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 08 January 2006 21:35
To: CF-Talk
Subject: RE: SPF? How to use?
Absolutely, that's why I said, In situations where your IP
address will vary because you are
Jennifer Gavin-Wear wrote:
I'll have to kick the people who wrote my TPC/IP manual then, and as of when
I did sample tests for MCSE they also have the Class addresses wrong!
Makes you wonder if there isn't some truth to all the jokes about
Minesweeper Consultants and Solitaire Experts :)
Makes you wonder if there isn't some truth to all the jokes about
Minesweeper Consultants and Solitaire Experts :)
Actually, I find the MCSE tests to be pretty challenging. But then again,
I'm terrible with Minesweeper.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf
Is this the best way to do this:
cftransaction
cfquery name=InsertAddress datasource=#DSN#
INSERT INTO Address (City)
VALUES (cfqueryparam value=#City# cfsqltype=cf_sql_integer /)
/cfquery
cfquery name=getInsertedID datasource=#DSN#
SELECT MAX(AddressID) as MaxID
Oh, that's another thing I forgot to mention. When I open the CFC, it's
completely garbled. ø¶ç~z¢PMÂ6ͨpWÃSÃ
X]Mi°ZÂæ!r7æ`ÃJè0 that
kind of
thing. Could that have anything to do with it using java?
On 1/8/06, Matthew Walker [EMAIL PROTECTED] wrote:
It's an error in the CFC.
It's only 100% reliable if you use a serializable transaction, as far
as I remember. This is certainly the case with Oracle.
There is an extensive thread on this in the archives somewhere.
On 1/9/06, Baz [EMAIL PROTECTED] wrote:
Is this the best way to do this:
cftransaction
cfquery
What I usually do is have a column that just holds a specific
timestamp or uuid of some sorts. I create a variable to hold the
timestamp or uuid right before the insert query, then I select against
the table looking for that timestamp or uuid. If you are using a db
that stores a pretty detailed
If you have a CFC within another CFC you could save it as either:
1. variables.InsideCFC OR
2. this.InsideCFC
I am fully aware the differences between the 2 scopes and I'm sure most
people would say that it is better to save it in the variables scope.
However I see a lot of people
Oops, forgot to change the subject before...
If you have a CFC within another CFC you could save it as either:
1. variables.InsideCFC OR
2. this.InsideCFC
I am fully aware the differences between the 2 scopes and I'm sure most
people would say that it is better to save it in the
James, in which cases is it not 100% reliable? Are the CF-Talk archives
searchable?
Ryan, your method seems ideal... but I think it would take me a month to do
it... what DB datatype is your UUID?
Cheers,
Baz
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Sunday,
What if someone were to insert another city just before the SELECT
statement executed?
Mike
Baz wrote:
James, in which cases is it not 100% reliable? Are the CF-Talk archives
searchable?
On 1/9/06, Baz [EMAIL PROTECTED] wrote:
Is this the best way to do this:
cftransaction
cfquery
It's not quite the same, because if it's in the THIS scope it can be
modified (changed, deleted, generally messed up) by code outside the
CFC. Also, using a getter method makes it possible to do other things
before returning the object (e.g. security checks).
On 1/9/06, Baz [EMAIL PROTECTED]
Good information, but I don't make the connection between that and my
scrambled CFC. Maybe I'm daft. :)
On 1/8/06, Baz [EMAIL PROTECTED] wrote:
If you have a CFC within another CFC you could save it as either:
1. variables.InsideCFC OR
2. this.InsideCFC
I am fully aware the
(This is based on Oracle defaults; ymmv with MySql). It's essentially
what Mike said, but only if the other insert is committed first. It's
like this:
1) My transaction is started
2) My INSERT is done
3) Someone else's transaction starts
4) Their INSERT is done
5) Their SELECT is done
6) Their
I'm going to be using SQL Server and I wanted something like Oracle's
sequences. I found this:
http://jamesthornton.com/software/coldfusion/nextval.html
Mike
James Holmes wrote:
(This is based on Oracle defaults; ymmv with MySql). It's essentially
what Mike said, but only if the other
yes, this topic has been beaten to death. All posts here have links
at the bottom, one of which is to the archives
http://www.houseoffusion.com/cf_lists/threads.cfm/4
With Oracle all you need is a sequence defined and use it. No trans
is needed, the sequence always gives a unique value.
other
Oh, that's another thing I forgot to mention. When I open
the CFC, it's completely garbled. øöç~
zâPMÃâ6èpWÃÂSÃâ¦X]MiðZÚæ!r7æ`Ãâ¢Jè0 that
kind of
thing. Could that have anything to do with it using java?
I suspect that it's encrypted.
Dave
Just a string for the uuid.
On 1/8/06, Baz [EMAIL PROTECTED] wrote:
James, in which cases is it not 100% reliable? Are the CF-Talk archives
searchable?
Ryan, your method seems ideal... but I think it would take me a month to do
it... what DB datatype is your UUID?
Cheers,
Baz
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: 08 January 2006 22:22
To: CF-Talk
Subject: Re: SPF? How to use?
Jennifer Gavin-Wear wrote:
I'll have to kick the people who wrote my TPC/IP manual then, and as of
when
I did sample tests for MCSE they also have
Well I scored 99% on tcp/ip and did level 2 Minesweeper in 9 seconds .. sad
sad sad (on both counts), lol
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 08 January 2006 23:37
To: CF-Talk
Subject: RE: SPF? How to use?
Makes you wonder if there isn't some truth to
If you used THIS, some other bit of code could do:
cfset OutsideCFC.InsideCFC =
and completely overwrite the CFC at any time with no warning. Using a getter
method and a private instance variable prevents this.
On 1/8/06, James Holmes [EMAIL PROTECTED] wrote:
It's not quite the same,
This should insert your record and return the new primary key as 'newid'
cfquery NAME='myqry'
Insert into address (city) Values (cfqueryparam value=#City#
cfsqltype=cf_sql_integer /); Select LAST_INSERT_ID() as newid;
/cfquery
Primary keys that you control would probably be the better solution
Brian, that's the correct answer - thanks.
Baz
-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 08, 2006 10:08 PM
To: CF-Talk
Subject: Re: THIS or that
If you used THIS, some other bit of code could do:
cfset OutsideCFC.InsideCFC =
and completely
James,
CFTransaction doesn't take care of that?
Baz
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 08, 2006 8:39 PM
To: CF-Talk
Subject: Re: Get last inserted ID
(This is based on Oracle defaults; ymmv with MySql). It's essentially
what Mike
Not without the serializable isolation level, no.
On 1/9/06, Baz [EMAIL PROTECTED] wrote:
James,
CFTransaction doesn't take care of that?
--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/
~|
Howdy, I'm new to Coldfusion - and am looking at the product for work,
where we have a trial version of verity Ultraseek. I know that
coldfusion has a component of Verity and I have set up collection,
searched on this, and am generally happy with the results - Except it
won't open the files! I
Folks,
While I realize that I can use the java collections API (or Jakarta
commons if need be) to get data structures like a stack,
priorityqueue, or linked list -- I seem to remember that there was a
CF implementation of at least some of those standard data structures
that came across the list
What does cftransaction do then?
The livedocs say that it can be used to group multiple queries that use
CFQUERY into one business event. How do other events occur in between one
event?
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 08, 2006
Using UUIDs does seem good but they are quite unfriendly. For example lets
say you have ORDERS... It's much easier to tell your colleague to look into
OrderID: 155000 rather than OrderID: hagfhdvklchjcvadj...
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent:
What does cftransaction do then?
The livedocs say that it can be used to group multiple
queries that use CFQUERY into one business event. How do
other events occur in between one event?
Transactions are a bit complicated, and can be used to achieve different
sorts of results.
One thing
It happens because Oracle and most other DBs do not default to
serializable transactions; Oracle, for example, defaults to read
committed, which means that your transaction can read other committed
data even if it happened during your transaction (although in Oracle
this level does provide
Thanks for the info guys - all this makes me really sad... I remember
researching this a long, long time ago and was recommended using
cftransaction - so I did - for EVERY insert for all my apps. Now it seems I
have major changes ahead of me...
If I don't post for a while you'll know why...
Baz
You can just modify your cftransaction tags to use the serializable
isolation level if you want, but do some load testing first because
there will be locks-a-plenty if you do...
On 1/9/06, Baz [EMAIL PROTECTED] wrote:
Thanks for the info guys - all this makes me really sad... I remember
So James, just this: cftransaction isolation=SERIALIZABLE
And problem solved?
I will load test as you suggest, but I don't think it should be a problem -
inserts are so rare relative to everything else...
Thanks!
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent:
What is the most powerful search facility in 10g - Oracle Text
http://www.oracle.com/technology/products/text/index.html or Oracle
Ultra Search ???
http://www.oracle.com/technology/products/ultrasearch/index.html
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
59 matches
Mail list logo