The problem is that substring returns a string value and your != comparison
is against an integer.
There are two ways to fix this.
1.) Use the parseInt() function on the variable: parseInt(first_number) != 4
or
2.) Turn the integer 4 in to the character 4: first_number != '4'
HTH
Nate
Then your problem would be in the last check where your equality comparison
is '!=='. I'm not sure of the pattern for Discovery cards, but it's either
!= or == and not !==.
HTH,
Nate
-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27,
It might help you to debug if you were to label each of the error messages
differently so that you know which one is being triggered. Another thing you
might want to check is the order of operations on your comparisons for
Mastercard and American Express. I think that by adding a few parens
What ended up being the solution?
Nate
-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 2:27 PM
To: CF-Talk
Subject: SOLVED... OT Quick JS ?
Thanks for the help everyone it is appreciated.
Doug
This is way OT, but I'm dying to know what they delivered!!
Please tell.
Nate
-Original Message-
From: Sandy Clark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 8:45 PM
To: CF-Talk
Subject: WH
THis really sucks.
Went to DevCon - Took the
Use the mod function.
CFIF mynumber MOD 3 EQ 0
!--- it's a multiple ---
CFELSE
!--- it's not a multiple ---
/CFIF
-
Nate Smith,
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED]
www.doceus.com
Loop through the elements of the form and add the value of any field whose
name begins with Reg_. You may also want to put in some validation that
all the fields are numeric and do not contain any non-numeric characters.
function sumValues() {
var TheSum = 0;
for( var i=0;
want the column information. I'm not certain about any other servers.
SELECTname
FROM syscolumns
WHERE (id =(SELECT id
FROM sysobjects
WHERE name = 'TABLENAME'))
ORDER BY colorder
-
Nate Smith,
Lead Developer
Macromedia Coldfusion 5 Certified
The original poster wanted the columns in the order specified in the
database.
So your post of:
Or
Queryname.Columnlist
Jerry Staple
would not work. The only way to do that, to the best of my current
knowledge, is to query the system tables.
-
Nate Smith,
Lead Developer
Close but the index goes after the column name like this:
QueryName.ColumnName[QueryName.RecordCount]
-
Nate Smith
-Original Message-
From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 6:00 PM
To: CF-Talk
Subject: Getting Information from a RecordSet
I've read posts on the CF Studio beta 5 before and I was wondering if this
is a public beta. If so, where can it be downloaded? Thanks for in advance
for any info.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Rayna,
Assuming that all of your checkboxes have the same name, but different
values, this script will work.
function countChecked(TheForm)
{
var cChecked = 0;
for( var i=0;iTheForm.Item.length;i++ )
{
if( TheForm.Item[i].checked == true )
The problem is that your quoted value list shouldn't be quoted since it's an
integer field. Remove the quoted value list and you should have no problems.
HTH
-Nate
-Original Message-
From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 5:12 PM
To: CF-Talk
Ah... I see what the problem is. What you'll then want to do inside of the
SP is to declare a new variable varchar(5000) to hold sql code. Then you can
write the query code to the variable string and append the attributes passed
in from the SP call.
EXAMPLE:
CREATE PROCEDURE dbo.SP_DynamicSP
Ok... comment out the EXEC statement and change it to PRINT @DynSQL. Then
call this SP from QueryAnalyzer and see if the query looks correct.
-Nate
-Original Message-
From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 6:30 PM
To: CF-Talk
Subject: RE: Stored
Shawn,
That's really odd that it's not working for you.
Are you sure you're trying:
CFLOOP LIST=#form.FieldNames# INDEX=xField
You could always use the form struct that CF builds for you:
CFLOOP COLLECTION=#form# ITEM=xField
HTH
- Nate
-Original Message-
From:
If that is the case, then check your data type for the problematic field.
I'm not sure about Oracle, but on SQL 7 and 2k the type 'char' returns your
string padded to the length of the char field. Try using varchar if this is
the case. That or remember to use TRIM() all the time.
HTH
- Nate
It seems that you be better off using this:
cfquery name=qryGetApp datasource=ITDATA
SELECT *
FROMqryCHECKOUT
WHERE AppID IN (#form.appid#)
AND CheckIn IS NULL
ORDER BY AppName, AppVersion DESC
/cfquery
-Nate
-Original Message-
From: Jones, Becky [mailto:[EMAIL
Within ColdFusion, pick a type of quotes to surround text in. Then when you
want that quote to be included inline without ending the assignment, you can
either use the chr() function with the correct ascii value or you can double
the quote.
EXAMPLE:
CFSET sText = Jane said, Hello
or
CFSET sText
#/cfoutput
Output Output Output
DoubleQuote =
Thanks,
Jeff
-Original Message-
From: Nate Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 3:50 PM
To: CF-Talk
Subject: RE: Escaping question
Within ColdFusion, pick a type of quotes to surround
Look at the form dump at the bottom of the cfdebugging (if you have it
turned on in your CFSERVER). You'll notice that you can check for input's of
type image. For instance:
INPUT TYPE=image NAME=Process SRC=process.gif
You can then check for that particular button press using this code:
CFIF
[QueryName.CurrentRow MOD 2])#
-
Nate Smith,
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED]
www.doceus.com
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 2:39 PM
To: CF-Talk
() function--it'll just slow you down:
BGCOLOR=#stColor[QueryName.CurrentRow MOD 2]#
-Dan
-Original Message-
From: Nate Smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 3:17 PM
To: CF-Talk
Subject: RE: Alternating BG colors on a TD
By using the mod function
Cold Fusion is run on the server and has no access to JS variables which are
run on the users machine unless the JS variable is passed back to the server
through a url or form variable. So if you are using JS to pass data back to
CF you need a page submission.
Does that help?
-
Nate Smith
24 matches
Mail list logo