number of logins

2004-12-14 Thread Robert Orlini
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

RE: number of logins

2004-12-14 Thread Adkins, Randy
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

RE: number of logins

2004-12-14 Thread Adkins, Randy
] 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

RE: number of logins

2004-12-14 Thread Pascal Peters
- 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

RE: number of logins

2004-12-14 Thread Robert Orlini
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

RE: number of logins

2004-12-14 Thread Robert Orlini
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