Hello all,
I have a client requesting that the full text searches using verity on his
site not be case sensitive. I looked over the ColdFusion documentation but
couldn't find any specific information on case sensitivity in Verity at all,
but when doing searches on the site it certainly is case sen
Thanks, Baz & Josh, too!
Rick
> -Original Message-
> From: Baz [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 19, 2006 9:55 PM
> To: CF-Talk
> Subject: RE: How would I write this query...
>
>
> SELECT *
> FROM XYZ
> WHERE ColumnName like 'A%'
>
>
~~~
Thanks, James!
Rick
> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 19, 2006 9:54 PM
> To: CF-Talk
> Subject: Re: How would I write this query...
>
>
> WHERE companynamecolumn
> LIKE
>
Perfect...thanks, Charlie...
Rick
> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 19, 2006 9:52 PM
> To: CF-Talk
> Subject: Re: How would I write this query...
>
>
> WHERE
> companyName LIKE '#form.companyName#%'
>
> the LIKE is simi
I'd bet money that the issue was a pre-mx one. If you remember in CF 5,
there was the issue of locking of memory variables and corruption of them if
not done. This is not a case in MX so it should not be a problem. Actually,
this is a plug for CFObjective and CFUnited where there will be people
Would that be ...
WHERE CompanyName LIKE '#form.CompanyName#%'
-- Josh
- Original Message -
From: "Rick Faircloth" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Sunday, February 19, 2006 6:43 PM
Subject: How would I write this query...
> What I'm after would be a list
> of the company n
SELECT *
FROM XYZ
WHERE ColumnName like 'A%'
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 19, 2006 9:43 PM
To: CF-Talk
Subject: How would I write this query...
What I'm after would be a list
of the company names that
match the letters in the
WHERE companynamecolumn
LIKE
On 2/20/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> What I'm after would be a list
> of the company names that
> match the letters in the form field
> that start with the first letter of
> the company name...not with the
> form field letters just anywhere in the
>
Thanks guys,
Why is it frowned upon by the way? I've heard such talk before, that's why I
ask, but I'm not sure of the reasons.
Baz
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 19, 2006 5:41 PM
To: CF-Talk
Subject: RE: SERVER scope
If as you
WHERE
companyName LIKE '#form.companyName#%'
the LIKE is similar to 'contains'. the % is a wildcard character, so
putting it at the end of the string means any string that starts with
#form.companyName#.
On 2/19/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> What I'm after would be a list
What I'm after would be a list
of the company names that
match the letters in the form field
that start with the first letter of
the company name...not with the
form field letters just anywhere in the
name...
E.g
Search for the letter "A" would bring up
Allstate
AIM
Not:
Hartford
Allstate
Wal-Mart is one of the most widely shopped at stores on the planet but
that's just because there are so many of them out there ;-)
PHPBB may get hacked occasionally but it's because its widely used and well
known... not to mention, anyone can see the source. Usually, the hacks
happen because peopl
ok, well i think i got it going using the built in server, but when i
attempt to connect to port 8500. i get a connection refused error.. is
the port locked down.. or does that mean the bloody thing isn't
running.. ?
On 2/19/06, Paul Scoffield II <[EMAIL PROTECTED]> wrote:
> i have a s/n for it..
I'd be worried about the reverse situation - PHPBB is one of the most
hacked web apps on the planet.
On 2/20/06, Rick Root <[EMAIL PROTECTED]> wrote:
> In an effort to do something different with my chat app, I thought it'd
> be cool to "integrate" with an EXTERNAL third party app - phpBB.
>
> I r
If as you say this library is "server wide" then I say go for it :) But make
sure and check to see if it already exists and only instantiate it once -
othewise whats' the point?
-mark
-Original Message-
From: Baz [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 19, 2006 4:25 PM
To: CF-Ta
I do, but it's usually frowned upon (for no logical reason). Just make sure
you check if the var exists first before adding it to avoid unnecessary
writing to the server scope, but even that is nothing to worry about as
there is no 'real' storage difference between the server, application and
s
Hi,
I have a CFC that I use across all applications. It's basically a global UDF
library that stores no data.
Is it ok to store this CFC in the SERVER scope rather than the application
scope? Is using a named lock for this ok:
Cheers,
Baz
~
Dave Watts wrote:
>>
>> I have mentioned the emailaddress i-need-a-gf @ vandieten .
>> net in the body of an email on this list once. Just once. I
>> think it was quoted one more time in an answer. Now, several
>> years later, I get about 20 spam messages to that address
>> every day.
>
> Yes
Michael Dinowitz wrote:
> For personal mail this might be an effective option, but can you see the
> firestorm if list mail was slowed down? :)
Nobody notices a 10 or 15 second slowdown (you can go full speed
after that).
> As for adding it on a personal level (or mail server one), is there an
For personal mail this might be an effective option, but can you see the
firestorm if list mail was slowed down? :)
As for adding it on a personal level (or mail server one), is there any good
instructions?
> Use greylisting, no hacking or banning needed, it is a purely
> technical process.
>
>
Michael Dinowitz wrote:
>>
>> It takes more than "anyone" it takes numerous "someones". One spam
>> report to spamcop doesn't cause you to get blacklisted.
> I can easily 'hack' this process and ban anyone I choose. This is one of the
> reasons I don't use any RBL for my spam checker.
Use grey
>> This is one of the reasons I don't use any RBL for my spam checker. I
>> wrote it myself and let me tell you that while it takes a few moments to
>> review some of the subjects, my success rate is 100% blocked with the
>> only mistakes coming from people who send mail without a subject. (red
> I would move bl.spamcop.net and dsn.rfc-ignorant.org from
> blocking spam to adding points in SpamAssassin and instead add
> greylisting: http://www.greylisting.org/
I second the greylisting recommendation. We recently implemented it, and
it's provided a significant improvement.
> I have menti
Rick Root wrote:
> Jochem van Dieten wrote:
>>> Spamcop listed houseoffusion because of some DNS/hostname configuration
>>> issues.
>> SCBL does not work that way. SCBL lists IP addresses based on
>> spam reports: http://www.spamcop.net/fom-serve/cache/297.html
>
> Actually, Spamcop *DOES* work
In an effort to do something different with my chat app, I thought it'd
be cool to "integrate" with an EXTERNAL third party app - phpBB.
I run a little blog... www.thecaniac.com (I'm a big fan of the Carolina
Hurricanes hockey club). I'm also a heavy participant in the
organizations official m
On 2/20/06, Snake <[EMAIL PROTECTED]> wrote:
> Login with enterprise manager, look at the tables.
> Who doe sit say is the owner of the tables, DBO or a specific user.
> If it is a specific user, then that means the tables were created as that
> user, and thus why you have to prefix all queries wit
Michael Dinowitz wrote:
>
> Yes, a month ago. So why are they having problems now?
Or rather, Friday night, they're not "now".. but a good question
nonetheless.
> This is one of the reasons I don't use any RBL for my spam checker. I wrote
> it myself and let me tell you that while it takes a fe
On 2/20/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> > If I delete the user first, the site will stop working completely and
> > all hell will break loose, no?
>
> does it work now? do you have backups? if you do, take the db off-line &
> drop the user from the db (not from the logins) then try a
>Actually, Spamcop *DOES* work that way sometimes, and in this particular
>case, it did. House of Fusion was blacklisted because of DNS and
>hostname issues, as Michael has already pointed out.
Yes, a month ago. So why are they having problems now?
>When I looked up the IP address, it said it w
Jochem van Dieten wrote:
>
>> Spamcop listed houseoffusion because of some DNS/hostname configuration
>> issues.
>
> SCBL does not work that way. SCBL lists IP addresses based on
> spam reports: http://www.spamcop.net/fom-serve/cache/297.html
Actually, Spamcop *DOES* work that way sometimes, a
Rick Root wrote:
>
> My mail server, which isn't particularly large, has blocked over 32,000
> incoming connections via various RBLs
>
> dsn.rfc-ignorant.org list.dsbl.org relays.ordb.org bl.spamcop.net
> sbl-xbl.spamhaus.org.
I would move bl.spamcop.net and dsn.rfc-ignorant.org from
blocking
Ian Buzer wrote:
>
> It looks like someone's trying to test to see if the form is vulnerable to
> having headers injected into it. In fact, on one of the attempts, he did
> manage to override the subject of the email.
>
> Does anyone know if cfmail is vulnerable to this kind of thing?
Not to t
Rick Root wrote:
> Jochem van Dieten wrote:
>> If the spamcop RBL routinely lists legitimate hosts, why do you
>> use it?
>
> The answer is obvious.
>
> *ALL* RBL lists contain some legitimate hosts from time to time. IMO.
Some: yes. From time to time: yes. Routinely: no.
> Spamcop listed ho
for what it's worth, I hate spam. And spam blocking/filtering is a
necessary evil, unfortunately. The harder you try to block spam, the
more likely you are to not see legitimate email.
My mail server, which isn't particularly large, has blocked over 32,000
incoming connections via various RBL
It is not vulnerable - except that you will get these annoying probes from
time to time :)
I have a blog on this top with lots of additional insight in the comments at
the bottom.
http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=email%20injection
This follow up references a function for
A little over a month ago I made a DNS config change from 64.118.74.245 to
46.118.74.249 but forgot to set the mail server to say
mail.houseoffusion.com rather than houseoffusion.com. I fixed it really fast
when I saw a spamcop block but to this day I still see people blocked due to
spamcop des
i have a s/n for it.. but, i just installed it as a dev version to start...
Upon initial startup, I get:
.snip.
ColdFusion MX 7 not started, will retry connector 2 more time(s)
ColdFusion MX 7 not started, will retry connector 1 more time(s)
The connector wizard has not been able to contac
Jochem van Dieten wrote:
>
> If the spamcop RBL routinely lists legitimate hosts, why do you
> use it?
The answer is obvious.
*ALL* RBL lists contain some legitimate hosts from time to time. IMO.
Spamcop listed houseoffusion because of some DNS/hostname configuration
issues. I guess the mai
Login with enterprise manager, look at the tables.
Who doe sit say is the owner of the tables, DBO or a specific user.
If it is a specific user, then that means the tables were created as that
user, and thus why you have to prefix all queries with that user name.
Russ
~~
Kay Smoljak wrote:
> Actually, I logged in with my Windows user and tried it anyway... and got:
i guess you're in the admin group on that server. i wouldn't have
expected that.
> Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 47
> The proposed new database owner is alread
Kay Smoljak wrote:
> I don't have the SA password on that box... I have my own login to the
> server (not administrator). If I open Query Analyser and log in with
> Windows authentication that won't work, will it?
no.
~|
Message
On 2/20/06, Kay Smoljak <[EMAIL PROTECTED]> wrote:
> I don't have the SA password on that box... I have my own login to the
> server (not administrator). If I open Query Analyser and log in with
> Windows authentication that won't work, will it?
>
> > EXEC sp_changedbowner 'that_user_name'
Actuall
On 2/20/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> lets try kicking it where the sun don't shine:
>
> login as SA w/query analyzer & connect to that db
I don't have the SA password on that box... I have my own login to the
server (not administrator). If I open Query Analyser and log in with
Wi
Kay Smoljak wrote:
> Through Query Analyzer using that user/pass, I cannot query the table
then that user cannot be in the DBO for that database.
> Is there a chance that something like this could happen if the
> database was had to be restored from a backup? The client didn't reply
> when I aske
On 2/19/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> if you can only access that table using a user name as a qualifier then
> that user's not the DBO. can you query the unqualified table using query
> analyzer using that user/password?
Through Query Analyzer using that user/pass, I cannot query
At 09:44 AM 2/19/2006, Jochem van Dieten wrote:
> > 2- If the user enters a dot with no numbers, e.g., "na.", the letters
> > get stripped (which is good) but the dot does not, and it creates an
> > error similar to the one quoted above. Any way of detecting such
> > instances of dots with no numb
Kay Smoljak wrote:
> Been through that - the dbo role has the user in question listed first
> on both servers.
> I'm really stuck!
if you can only access that table using a user name as a qualifier then
that user's not the DBO. can you query the unqualified table using query
analyzer using that
On 2/19/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> not really. while that table might "belong" to that user name (as seen
> in EM), if they aren't the DBO you'll always *have* to supply the user
> name when accessing the table. pop open that user or the roles in that
> db & see what's what.
Be
Kay Smoljak wrote:
> Is there anything else it could be?
not really. while that table might "belong" to that user name (as seen
in EM), if they aren't the DBO you'll always *have* to supply the user
name when accessing the table. pop open that user or the roles in that
db & see what's what.
~~
Roberto Perez wrote:
>
> On further testing, this is what is happening: the two characters
> included in the regex below, the forward slash "/" and the dot "." do
> not get stripped:
>
> #rereplace(FORM.GPA, '[^0-9/.]', '', 'all')#
>
> So my questions are:
> 1- Does the forward slash perform a
Roberto Perez wrote:
>
> I've done more testing, and I have it now where the only character
> that does not get stripped is the forward slash "/".
>
Jochem
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232842
At 08:56 AM 2/19/2006, I myself wrote:
>I have it now where the only character
>that does not get stripped is the forward slash "/". The error I get
>is this one:
>
>[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
>Microsoft Access Driver] Syntax error (missing operator) in query
>exp
No, there is no other code. I will try to install CF again. Thanks for ur
help.
Artur
-Original Message-
From: Andrew Stevens [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 19, 2006 1:41 PM
To: CF-Talk
Subject: RE: Problems with invoking a Webservice
Is there any more code besides wh
At 10:04 PM 2/14/2006, Charlie Griefer wrote:
> > - if there are only spaces, it throws an error;
> > - if there is text (e.g., "n/a"), it throws an error.
>
>"it" throws an error? what is "it"? the regex? the query? what
>is the error?
I've done more testing, and I have it now where the on
> trust the sql server box. that table is owned by that db user which is not the
> DBO and/or the DSN is setup w/another user.
Well, I'm remote-desktopped into the live box right now, I'm staring
at both the CF Administrator DSN setup screen AND the database table
listing in Enterprise Manager and
Is there any more code besides what you have already posted? As it's not
reproducible here, I guess the problem lies in your setup.
-Original Message-
From: Artur Kordowski [mailto:[EMAIL PROTECTED]
Sent: Sunday, 19 February 2006 9:47 PM
To: CF-Talk
Subject: RE: Problems with invoking a
Kay Smoljak wrote:
> up the dbo user owning all tables. The DSN set up in the CF
obviously not.
>
> SELECT *
> FROM [db_user].sometable
>
trust the sql server box. that table is owned by that db user which is not the
DBO and/or the DSN is setup w/another user.
~~
This goes beyond my understanding of SQL Server (2000, Standard
Edition, SP3, running on windows 2003 with CFMX 7 and FarCry 3 if that
matters at all).
I have a dev box set up which is as close to identical to my client's
server as I can make it. On both servers, the FarCry database is set
up the
This is just a warning and does not effect CF in any way.
I have same warning on Debian Linux but my CF installation works without any
problem.
I have first installed 30 day trial and activated my serial later. But it is
always same.
Here is a simple tutorial CF on Debian.
http://www.howtoforge
>Deleting them ensures the stubs are re-generated from the WSDL.
Ok, understand.
But even if I delete this folder the error is still there. What can I do?
Any help is appreciate.
Artur
-Original Message-
From: Andrew Stevens [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 19, 2006 2:21
Rick Root wrote:
> I'm not getting any cf-talk email again, started sometime last night.
>
> Here's an entry from my smtp server's log file
>
> @400043f75bc5074da2f4 rblsmtpd: 64.118.74.249 pid 19425: 451 Blocked
> - see http://www.spamcop.net/bl.shtml?64.118.74.249
>
> Looks like the s
Furthermore, I'd expect a license warning for a developer edition; is
this a licenced install or just a dev version?
On 2/19/06, Andrew Stevens <[EMAIL PROTECTED]> wrote:
> It is 'just' a warning, is your server not working?
>
--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionj
Hello,
Just got a bunch of emails in my inbox this morning that had been sent from a
contact form on one of my web sites. They all contained content a bit like this:
deeper
xxContent-Type: multipart/alternative; boundary=e00c35d22e0dba33a15957f33286efe8
MIME-Version: 1.0
Subject: idee is that a
It is 'just' a warning, is your server not working?
-Original Message-
From: Paul Scoffield II [mailto:[EMAIL PROTECTED]
Sent: Sunday, 19 February 2006 7:23 PM
To: CF-Talk
Subject: Re: cfmx on kubuntu
naw.. that's not it.. i don't have a license.properties in that directory...
On 2/18/0
naw.. that's not it.. i don't have a license.properties in that directory...
On 2/18/06, Andrew Stevens <[EMAIL PROTECTED]> wrote:
> Could be this...
> http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=cf8f287b&pss=rs
> s_coldfusion_cf8f287b
>
> -Original Message-
> From: Paul S
65 matches
Mail list logo