RE: number of logins
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 value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still 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 '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187574 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: number of logins
Does the database field login a string or numeric type? If it is String, then by using the symbol indicates That you are doing a numeric comparative.. What does LOGIN field contain? What is the user entering as form.login? -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] 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 Subject: RE: number of logins 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 value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still 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 '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187594 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: number of logins
Then it looks like you are storing numerical data in a text field. What is login in your table and in your form??? What do you use it for?? Did you enable debugging to see the actual query? Oh, and about what you are doing wrong: you are not using cfqueryparam ;) Pascal -Original Message- 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: Tuesday, December 14, 2004 12:16 PM To: CF-Talk Subject: RE: number of logins 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 value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still 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 '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 Subject: RE: number of logins 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 value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still 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 '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: number of logins
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 or numeric type? If it is String, then by using the symbol indicates That you are doing a numeric comparative.. What does LOGIN field contain? What is the user entering as form.login? -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] 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 Subject: RE: number of logins 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 value correctly. I tried either isdefined or just checking with a NEQ to , but it does not display logins greater than a value I submit. I checked the logic on the bottom of the page (see below) and it seems correct. I even added a trim, but still 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 '#FORM.customer#%' /CFIF cfif Form.login NEQ And login '#FORM.login#' /cfif !--- cfif IsDefined(Form.login) And login '#trim(FORM.login)#' /cfif --- ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54