That's because IS is not a valid SQL keyword...
I've also notice that in SQL, if I do a:
SELECT *
FROM TableName
WHERE (FIELD1 LIKE 'yes')
it works, but
SELECT *
FROM TableName
WHERE (Field1 IS 'yes')
does not work...
~~~
This is actually very similar to some aspects of UML, except UML is in 2D :)
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: July 27, 2001 1:04 PM
To: CF-Talk
Subject: RE: Vote on ColdFusion Enhancements!
Hmm..well I had an idea for CFSTudio...that might have to
Try something like:
temp = parseInt(maxlimit, 10) - field.value.length;
countfield.value = temp;
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: July 26, 2001 8:36 AM
To: CF-Talk
Subject: Re: javascript driving me crazy
Thanks Larry and Kwang. Neither sugges
Hmm, try:
if (field.value.length > parseInt(maxlimit, 10)) // if too long...trim it!
If this doesn't work, blame Netscape!
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: July 25, 2001 3:11 PM
To: CF-Talk
Subject: OT: javascript driving me crazy
Hi folks,
I
Don't use *. Explicitly select the columns you need!! Gawd, I wish SQL
never had *. What a bane.
Use the attribute blockfactor in your cfquery.
Is the Name column indexed? If not, then you'll have horrendous performance
from the ORDER BY clause you have.
-Original Message-
From: Dav
Wrong, unfortunately. Brute force attack can still decode your message.
You're using simple transposition, which went the way of the dodo back in
WWII.
Also, if you're doing the decryption and encryption on your CF server,
what's to stop someone from taking the source code and decrypting at will
Think of it this way:
I give you a safe. I give you the plans to the safe. I give you all the
materials that the safe was made out of. Now then, I challenge you to open
the safe. A GOOD encryption scheme will give you all this information, and
you still will have a hell of a hard time decrypt
Oh yeah, storage of CC numbers is always a problem. Consider using an
encrption scheme such as RSA via GPG. It's a tad slow, but unless some gets
ahold of the Vendor's private key and passphrase, it's nearly impossible to
decrypt the information in a timely fashion. Whatever you do, don't use a
Just to add some more detail
Most of the time, as a courtesy to the customer, you'll want to pre-approve
the CC for the funds before shipping the order (which normally occurs
sometime after the Customer Order creation).
On the e-commerce project I worked on, we pre-approved the CC when the
C
I'd export one gigantic file, then use grep or some similar tool to split
the file into many little ones.
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: April 23, 2001 2:33 PM
To: CF-Talk
Subject: Re: SQL Server Export
This is what I resorted to doing. CF is extremely sl
Try this:
function checkYear() {
var frm = document.forms[0];
if (parseInt(frm.YearFrom[frm.YearFrom.selectedIndex].value) >
parseInt(frm.YearTo[frm.YearTo.selectedIndex].value)) {
alert("Your From Date must be less than your To Date.");
CF-Talk
Subject: RE: Any CF 5 hosts out there
Make sure you are going to:
http://www.cfm-resources.com/
and not
http://www.cfmresources.com
Rich
-Original Message-----
From: Kwang Suh [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 21, 2001 9:27 PM
To: CF-Talk
Subject: RE: Any CF 5 hosts out
Hmm, I can't seem to create a free account. I always get prompted for
authentication. Any ideas?
-Original Message-
From: Pablo Varando [mailto:[EMAIL PROTECTED]]
Sent: July 21, 2001 7:13 PM
To: CF-Talk
Subject: Re: Any CF 5 hosts out there
Check out:
http://www.cfm-resources.com
Pa
Well, here's my .02...
CF is scalable, both from the software side and the hardware side. PROPERLY
WRITTEN applications in CF should handle requests quite well from one
machine (eg. software) and from a cluster of machines (eg. hardware).
I would consider JSP/J2EE most scalable from a software
You are using ODBC date formats for OLE DB, which does not support ODBC date
formats.
You must use the native DB syntax for dates...
- Original Message -
From: "Randy Zeitman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 27, 2000 9:38 PM
Subject: OLEDB Cre
401 - 415 of 415 matches
Mail list logo