Coldfusion - Form submission somehow different on mobile?
up vote
0
down vote
favorite
So I have a very strange problem. I have a simple form setup to collect email / password. On the submission page I run these through a query to check if the user exists. This all works fine on desktop, but using it on mobile results in the query always returning 0 for record count.
<form action="test2.cfm" method="post">
<input type="hidden" name="lang" value="EN">
Email Address : <input type="text" name="strEmail" style="width: 200px;">
Password : <input type="password" name="strPassword" style="width: 200px;">
<br /><input type="submit" value="LOGIN"></td>
</form>
<cfquery name="getParticipant" datasource="#request.dbDSN#" username="#request.dbUsername#" password="#request.dbPassword#">
SELECT * FROM mytable
WHERE email = <cfqueryparam value="#FORM.strEmail#" cfsqltype="CF_SQL_VARCHAR">
AND password = <cfqueryparam value="#FORM.strPassword#" cfsqltype="CF_SQL_VARCHAR">
</cfquery>
<cfoutput>
record count: #getParticipant.recordCount#
</cfoutput>
As I've stated this code works fine when an existing user attempts to login on a desktop computer. The EXACT same code returns 0 when a login is attempted on mobile.
What is going on???
forms mobile coldfusion
asked Nov 9 at 15:13
user1110562
181420
add a comment |
up vote
0
down vote
favorite
So I have a very strange problem. I have a simple form setup to collect email / password. On the submission page I run these through a query to check if the user exists. This all works fine on desktop, but using it on mobile results in the query always returning 0 for record count.
<form action="test2.cfm" method="post">
<input type="hidden" name="lang" value="EN">
Email Address : <input type="text" name="strEmail" style="width: 200px;">
Password : <input type="password" name="strPassword" style="width: 200px;">
<br /><input type="submit" value="LOGIN"></td>
</form>
<cfquery name="getParticipant" datasource="#request.dbDSN#" username="#request.dbUsername#" password="#request.dbPassword#">
SELECT * FROM mytable
WHERE email = <cfqueryparam value="#FORM.strEmail#" cfsqltype="CF_SQL_VARCHAR">
AND password = <cfqueryparam value="#FORM.strPassword#" cfsqltype="CF_SQL_VARCHAR">
</cfquery>
<cfoutput>
record count: #getParticipant.recordCount#
</cfoutput>
As I've stated this code works fine when an existing user attempts to login on a desktop computer. The EXACT same code returns 0 when a login is attempted on mobile.
What is going on???
forms mobile coldfusion
asked Nov 9 at 15:13
user1110562
181420
I don't see any obvious reason the results would be different, unless maybe the application has mobile specific code not mentioned above? Log in as the same user from the desktop and mobile, and compare the values being passed to the action page. (Side note, passwords shouldn't be stored in plain text - should be hashed)
– Ageax
Nov 9 at 15:26
@Ageax The passed values appear to be exactly the same on desktop and mobile. I've gone so far as to setup a test page with JUST this code to ensure nothing else is getting in the way, and the behaviour is the same.
– user1110562
Nov 9 at 15:56
4
1. Do a<cfdump>of form. Just to see if anything interesting happens. 2. Usetrim()3. OT: on the email, use atype="email". That has nothing to do with your problem, but it may make for a better UI experience. 4. What version of CF are you using?
– James A Mohler
Nov 9 at 16:45
4
@user1110562 - Not sure how you checked it, but don't just rely on eyeballing it. Dump both values, lengths, etc.. The length checks will help determine it it's a white space issue.. Also, do a dump of the two queries and check the values.
– Ageax
Nov 9 at 18:27
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
So I have a very strange problem. I have a simple form setup to collect email / password. On the submission page I run these through a query to check if the user exists. This all works fine on desktop, but using it on mobile results in the query always returning 0 for record count.
<form action="test2.cfm" method="post">
<input type="hidden" name="lang" value="EN">
Email Address : <input type="text" name="strEmail" style="width: 200px;">
Password : <input type="password" name="strPassword" style="width: 200px;">
<br /><input type="submit" value="LOGIN"></td>
</form>
<cfquery name="getParticipant" datasource="#request.dbDSN#" username="#request.dbUsername#" password="#request.dbPassword#">
SELECT * FROM mytable
WHERE email = <cfqueryparam value="#FORM.strEmail#" cfsqltype="CF_SQL_VARCHAR">
AND password = <cfqueryparam value="#FORM.strPassword#" cfsqltype="CF_SQL_VARCHAR">
</cfquery>
<cfoutput>
record count: #getParticipant.recordCount#
</cfoutput>
As I've stated this code works fine when an existing user attempts to login on a desktop computer. The EXACT same code returns 0 when a login is attempted on mobile.
What is going on???
forms mobile coldfusion
asked Nov 9 at 15:13
user1110562
181420
So I have a very strange problem. I have a simple form setup to collect email / password. On the submission page I run these through a query to check if the user exists. This all works fine on desktop, but using it on mobile results in the query always returning 0 for record count.
<form action="test2.cfm" method="post">
<input type="hidden" name="lang" value="EN">
Email Address : <input type="text" name="strEmail" style="width: 200px;">
Password : <input type="password" name="strPassword" style="width: 200px;">
<br /><input type="submit" value="LOGIN"></td>
</form>
<cfquery name="getParticipant" datasource="#request.dbDSN#" username="#request.dbUsername#" password="#request.dbPassword#">
SELECT * FROM mytable
WHERE email = <cfqueryparam value="#FORM.strEmail#" cfsqltype="CF_SQL_VARCHAR">
AND password = <cfqueryparam value="#FORM.strPassword#" cfsqltype="CF_SQL_VARCHAR">
</cfquery>
<cfoutput>
record count: #getParticipant.recordCount#
</cfoutput>
As I've stated this code works fine when an existing user attempts to login on a desktop computer. The EXACT same code returns 0 when a login is attempted on mobile.
What is going on???
forms mobile coldfusion
forms mobile coldfusion
asked Nov 9 at 15:13
user1110562
181420
asked Nov 9 at 15:13
user1110562
181420
asked Nov 9 at 15:13
user1110562
181420
asked Nov 9 at 15:13
user1110562
181420
asked Nov 9 at 15:13
user1110562
181420
181420
I don't see any obvious reason the results would be different, unless maybe the application has mobile specific code not mentioned above? Log in as the same user from the desktop and mobile, and compare the values being passed to the action page. (Side note, passwords shouldn't be stored in plain text - should be hashed)
– Ageax
Nov 9 at 15:26
@Ageax The passed values appear to be exactly the same on desktop and mobile. I've gone so far as to setup a test page with JUST this code to ensure nothing else is getting in the way, and the behaviour is the same.
– user1110562
Nov 9 at 15:56
4
1. Do a<cfdump>of form. Just to see if anything interesting happens. 2. Usetrim()3. OT: on the email, use atype="email". That has nothing to do with your problem, but it may make for a better UI experience. 4. What version of CF are you using?
– James A Mohler
Nov 9 at 16:45
4
@user1110562 - Not sure how you checked it, but don't just rely on eyeballing it. Dump both values, lengths, etc.. The length checks will help determine it it's a white space issue.. Also, do a dump of the two queries and check the values.
– Ageax
Nov 9 at 18:27
add a comment |
I don't see any obvious reason the results would be different, unless maybe the application has mobile specific code not mentioned above? Log in as the same user from the desktop and mobile, and compare the values being passed to the action page. (Side note, passwords shouldn't be stored in plain text - should be hashed)
– Ageax
Nov 9 at 15:26
@Ageax The passed values appear to be exactly the same on desktop and mobile. I've gone so far as to setup a test page with JUST this code to ensure nothing else is getting in the way, and the behaviour is the same.
– user1110562
Nov 9 at 15:56
4
1. Do a<cfdump>of form. Just to see if anything interesting happens. 2. Usetrim()3. OT: on the email, use atype="email". That has nothing to do with your problem, but it may make for a better UI experience. 4. What version of CF are you using?
– James A Mohler
Nov 9 at 16:45
4
@user1110562 - Not sure how you checked it, but don't just rely on eyeballing it. Dump both values, lengths, etc.. The length checks will help determine it it's a white space issue.. Also, do a dump of the two queries and check the values.
– Ageax
Nov 9 at 18:27
I don't see any obvious reason the results would be different, unless maybe the application has mobile specific code not mentioned above? Log in as the same user from the desktop and mobile, and compare the values being passed to the action page. (Side note, passwords shouldn't be stored in plain text - should be hashed)
– Ageax
Nov 9 at 15:26
I don't see any obvious reason the results would be different, unless maybe the application has mobile specific code not mentioned above? Log in as the same user from the desktop and mobile, and compare the values being passed to the action page. (Side note, passwords shouldn't be stored in plain text - should be hashed)
– Ageax
Nov 9 at 15:26
@Ageax The passed values appear to be exactly the same on desktop and mobile. I've gone so far as to setup a test page with JUST this code to ensure nothing else is getting in the way, and the behaviour is the same.
– user1110562
Nov 9 at 15:56
@Ageax The passed values appear to be exactly the same on desktop and mobile. I've gone so far as to setup a test page with JUST this code to ensure nothing else is getting in the way, and the behaviour is the same.
– user1110562
Nov 9 at 15:56
4
4
1. Do a
<cfdump> of form. Just to see if anything interesting happens. 2. Use trim() 3. OT: on the email, use a type="email". That has nothing to do with your problem, but it may make for a better UI experience. 4. What version of CF are you using?– James A Mohler
Nov 9 at 16:45
1. Do a
<cfdump> of form. Just to see if anything interesting happens. 2. Use trim() 3. OT: on the email, use a type="email". That has nothing to do with your problem, but it may make for a better UI experience. 4. What version of CF are you using?– James A Mohler
Nov 9 at 16:45
4
4
@user1110562 - Not sure how you checked it, but don't just rely on eyeballing it. Dump both values, lengths, etc.. The length checks will help determine it it's a white space issue.. Also, do a dump of the two queries and check the values.
– Ageax
Nov 9 at 18:27
@user1110562 - Not sure how you checked it, but don't just rely on eyeballing it. Dump both values, lengths, etc.. The length checks will help determine it it's a white space issue.. Also, do a dump of the two queries and check the values.
– Ageax
Nov 9 at 18:27
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53228401%2fcoldfusion-form-submission-somehow-different-on-mobile%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I don't see any obvious reason the results would be different, unless maybe the application has mobile specific code not mentioned above? Log in as the same user from the desktop and mobile, and compare the values being passed to the action page. (Side note, passwords shouldn't be stored in plain text - should be hashed)
– Ageax
Nov 9 at 15:26
@Ageax The passed values appear to be exactly the same on desktop and mobile. I've gone so far as to setup a test page with JUST this code to ensure nothing else is getting in the way, and the behaviour is the same.
– user1110562
Nov 9 at 15:56
4
1. Do a
<cfdump>of form. Just to see if anything interesting happens. 2. Usetrim()3. OT: on the email, use atype="email". That has nothing to do with your problem, but it may make for a better UI experience. 4. What version of CF are you using?– James A Mohler
Nov 9 at 16:45
4
@user1110562 - Not sure how you checked it, but don't just rely on eyeballing it. Dump both values, lengths, etc.. The length checks will help determine it it's a white space issue.. Also, do a dump of the two queries and check the values.
– Ageax
Nov 9 at 18:27