it does not
give me the desired results on the number of logins. Its in an Access table
What am I coding wrong here?
Thanks.
Robert O.
HWW
cfquery name=Getcustomer datasource=test
Select * from test
Where 0 = 0
CFIF IsDefined(FORM.customer)
And customer LIKE
Is form.login a NUMERIC? If so, should it be:
And LOGIN #FORM.LOGIN#
Drop the single quotes
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 12:06 PM
To: CF-Talk
Subject: number of logins
The query below does not search the form.login
]
Sent: Tuesday, December 14, 2004 1:07 PM
To: CF-Talk
Subject: RE: number of logins
I get an Data type mismatch in criteria expression. error when I do
that though...
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 12:16 PM
To: CF-Talk
-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: 14 December 2004 19:07
To: CF-Talk
Subject: RE: number of logins
I get an Data type mismatch in criteria expression. error when I do
that
though...
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent
I get an Data type mismatch in criteria expression. error when I do that
though...
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 12:16 PM
To: CF-Talk
Subject: RE: number of logins
Is form.login a NUMERIC? If so, should
I converted the field to numeric, all fixed--still thanks for the advice Randy
and Pascal
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 1:36 PM
To: CF-Talk
Subject: RE: number of logins
Does the database field login a string
6 matches
Mail list logo