|
 |
access_asp thread: SELECT statement
Message #1 by "Stephanie" <stephanieweigel@y...> on Sat, 6 Apr 2002 20:19:27
|
|
This is suppsed to grab the customernumber and password off of my database
and I get an the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/loginconf.asp, line 11
and here is a part of my code....line 11 is the objrs.open line
intCusNum=Request.form("CustomerNumber")
strPass=Request.form("Password")
objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
& "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
any ideas?
Thanks!
Message #2 by Abdul Sami <abdul_sami_20@y...> on Sat, 6 Apr 2002 12:04:05 -0800 (PST)
|
|
Either table field or form field is not number type.
Check out data type and the value your are getting from the form
submited.
--- Stephanie <stephanieweigel@y...> wrote:
> This is suppsed to grab the customernumber and password off of
> my database
> and I get an the following error:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E07)
> Data type mismatch in criteria expression.
> /final/loginconf.asp, line 11
>
> and here is a part of my code....line 11 is the objrs.open line
>
> intCusNum=Request.form("CustomerNumber")
> strPass=Request.form("Password")
> objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" &
> intCusNum
> & "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
>
>
>
> any ideas?
>
> Thanks!
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
Message #3 by "Ethan Selzer" <ethanselzer@a...> on Sat, 6 Apr 2002 12:22:44 -0800
|
|
Hi Stephanie,
Try removing the single quotes from the intCusNum value. Like this:
"SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum & " AND
Password = '" & strPass & "'"
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 8:19 PM
To: Access ASP
Subject: [access_asp] SELECT statement
This is suppsed to grab the customernumber and password off of my database
and I get an the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/loginconf.asp, line 11
and here is a part of my code....line 11 is the objrs.open line
intCusNum=Request.form("CustomerNumber")
strPass=Request.form("Password")
objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
& "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
any ideas?
Thanks!
Message #4 by "Stephanie" <stephanieweigel@y...> on Sat, 6 Apr 2002 21:53:28
|
|
Thanks, I got that fixed by removing the single quote. I am having the
same problem on another page. On this page I am going to be updating users
information. This line is causing problems again:
objrs.open "Select * from Customer where CustomerNumber = '" & Session
("CustomerNumber") &"'", objconn, 3, 3, 1
I am getting the same error message as before. I tried removing the single
quotes and that caused even more problems, but I may have tried it
incorrectly.
any ideas now?
Thanks!
> Hi Stephanie,
Try removing the single quotes from the intCusNum value. Like this:
"SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum & " AND
Password = '" & strPass & "'"
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 8:19 PM
To: Access ASP
Subject: [access_asp] SELECT statement
This is suppsed to grab the customernumber and password off of my database
and I get an the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/loginconf.asp, line 11
and here is a part of my code....line 11 is the objrs.open line
intCusNum=Request.form("CustomerNumber")
strPass=Request.form("Password")
objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
& "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
any ideas?
Thanks!
Message #5 by Abdul Sami <abdul_sami_20@y...> on Sat, 6 Apr 2002 13:03:34 -0800 (PST)
|
|
try this
objrs.open "Select * from Customer where CustomerNumber = " &
Session ("CustomerNumber") , objconn, 3, 3, 1
--- Stephanie <stephanieweigel@y...> wrote:
> Thanks, I got that fixed by removing the single quote. I am
> having the
> same problem on another page. On this page I am going to be
> updating users
> information. This line is causing problems again:
>
> objrs.open "Select * from Customer where CustomerNumber = '" &
> Session
> ("CustomerNumber") &"'", objconn, 3, 3, 1
>
> I am getting the same error message as before. I tried removing
> the single
> quotes and that caused even more problems, but I may have tried
> it
> incorrectly.
>
> any ideas now?
>
> Thanks!
>
>
>
> > Hi Stephanie,
>
> Try removing the single quotes from the intCusNum value. Like
> this:
>
> "SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum &
> " AND
> Password = '" & strPass & "'"
>
> Ethan
>
> -----Original Message-----
> From: Stephanie [mailto:stephanieweigel@y...]
> Sent: Saturday, April 06, 2002 8:19 PM
> To: Access ASP
> Subject: [access_asp] SELECT statement
>
> This is suppsed to grab the customernumber and password off of
> my database
> and I get an the following error:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E07)
> Data type mismatch in criteria expression.
> /final/loginconf.asp, line 11
>
> and here is a part of my code....line 11 is the objrs.open line
>
> intCusNum=Request.form("CustomerNumber")
> strPass=Request.form("Password")
> objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" &
> intCusNum
> & "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
>
>
>
> any ideas?
>
> Thanks!
>
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
Message #6 by "Ethan Selzer" <ethanselzer@a...> on Sat, 6 Apr 2002 18:55:30 -0800
|
|
Hi Stephanie,
See if this does it.
objrs.open "Select * from Customer where CustomerNumber = " & Session
("CustomerNumber") &", objconn, 3, 3, 1
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 9:53 PM
To: Access ASP
Subject: [access_asp] RE: SELECT statement
Thanks, I got that fixed by removing the single quote. I am having the
same problem on another page. On this page I am going to be updating users
information. This line is causing problems again:
objrs.open "Select * from Customer where CustomerNumber = '" & Session
("CustomerNumber") &"'", objconn, 3, 3, 1
I am getting the same error message as before. I tried removing the single
quotes and that caused even more problems, but I may have tried it
incorrectly.
any ideas now?
Thanks!
> Hi Stephanie,
Try removing the single quotes from the intCusNum value. Like this:
"SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum & " AND
Password = '" & strPass & "'"
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 8:19 PM
To: Access ASP
Subject: [access_asp] SELECT statement
This is suppsed to grab the customernumber and password off of my database
and I get an the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/loginconf.asp, line 11
and here is a part of my code....line 11 is the objrs.open line
intCusNum=Request.form("CustomerNumber")
strPass=Request.form("Password")
objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
& "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
any ideas?
Thanks!
Message #7 by Stephanie Weigel <stephanieweigel@y...> on Mon, 8 Apr 2002 06:58:15 -0700 (PDT)
|
|
--0-1613418730-1018274295=:53988
Content-Type: text/plain; charset=us-ascii
Now, here is what I am getting when I type it like that:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/final/update.asp, line 8, column 62
objrs.open "Select * from Customer where CustomerNumber = & " Session("CustomerNumber") &" , objconn, 3, 3, 1
-------------------------------------------------------------^
any ideas?
Ethan Selzer <ethanselzer@a...> wrote: Hi Stephanie,
See if this does it.
objrs.open "Select * from Customer where CustomerNumber = " & Session
("CustomerNumber") &", objconn, 3, 3, 1
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 9:53 PM
To: Access ASP
Subject: [access_asp] RE: SELECT statement
Thanks, I got that fixed by removing the single quote. I am having the
same problem on another page. On this page I am going to be updating users
information. This line is causing problems again:
objrs.open "Select * from Customer where CustomerNumber = '" & Session
("CustomerNumber") &"'", objconn, 3, 3, 1
I am getting the same error message as before. I tried removing the single
quotes and that caused even more problems, but I may have tried it
incorrectly.
any ideas now?
Thanks!
> Hi Stephanie,
Try removing the single quotes from the intCusNum value. Like this:
"SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum & " AND
Password = '" & strPass & "'"
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 8:19 PM
To: Access ASP
Subject: [access_asp] SELECT statement
This is suppsed to grab the customernumber and password off of my database
and I get an the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/loginconf.asp, line 11
and here is a part of my code....line 11 is the objrs.open line
intCusNum=Request.form("CustomerNumber")
strPass=Request.form("Password")
objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
& "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
any ideas?
Thanks!
---------------------------------
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
Message #8 by Ping Li <pli@l...> on Mon, 8 Apr 2002 09:05:43 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1DF06.78EF6FC0
Content-Type: text/plain
Because you didn't give a ending double quotation marks. It won't work if
you put & inside double quotation marks. Also, you can use two single
quotation marks to replace a double quotation mark.
Try this:
objrs.open "Select * from Customer where CustomerNumber = " &
Session("CustomerNumber") & "''" , objconn, 3, 3, 1
Good luck,
Ping
-----Original Message-----
From: Stephanie Weigel [mailto:stephanieweigel@y...]
Sent: Monday, April 08, 2002 8:58 AM
To: Access ASP
Subject: [access_asp] RE: SELECT statement
Now, here is what I am getting when I type it like that:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/final/update.asp, line 8, column 62
objrs.open "Select * from Customer where CustomerNumber = & "
Session("CustomerNumber") &" , objconn, 3, 3, 1
-------------------------------------------------------------^
any ideas?
Ethan Selzer <ethanselzer@a...> wrote:
Hi Stephanie,
See if this does it.
objrs.open "Select * from Customer where CustomerNumber = " & Session
("CustomerNumber") &", objconn, 3, 3, 1
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 9:53 PM
To: Access ASP
Subject: [access_asp] RE: SELECT statement
Thanks, I got that fixed by removing the single quote. I am having the
same problem on another page. On this page I am going to be updating users
information. This line is causing problems again:
objrs.open "Select * from Customer where CustomerNumber = '" & Session
("CustomerNumber") &"'", objconn, 3, 3, 1
I am getting the same error message as before. I tried removing the single
quotes and that caused even more problems, but I may have tried it
incorrectly.
any ideas now?
Thanks!
> Hi Stephanie,
Try removing the single quotes from the intCusNum value. Like this:
"SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum & " AND
Password = '" & strPass & "'"
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 8:19 PM
To: Access ASP
Subject: [access_asp] SELECT statement
This is suppsed to grab the customernumber and password off of my database
and I get an the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/loginconf.asp, line 11
and here is a part of my code....line 11 is the objrs.open line
intCusNum=Request.form("CustomerNumber")
strPass=Request.form("Password")
objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
& "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
any ideas?
Thanks!
_____
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax --- Change your mail options
at http://p2p.wrox.com/manager.asp or
Message #9 by "Johnson, Israel" <IJohnson@R...> on Mon, 8 Apr 2002 10:08:11 -0400
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1DF06.D0F80EC0
Content-Type: text/plain
try reversing the quote and the amper sign around to:
objrs.open "Select * from Customer where CustomerNumber = " &
Session("CustomerNumber") &" , objconn, 3, 3, 1
-----Original Message-----
From: Stephanie Weigel [mailto:stephanieweigel@y...]
Sent: Monday, April 08, 2002 9:58 AM
To: Access ASP
Subject: [access_asp] RE: SELECT statement
Now, here is what I am getting when I type it like that:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/final/update.asp, line 8, column 62
objrs.open "Select * from Customer where CustomerNumber = & "
Session("CustomerNumber") &" , objconn, 3, 3, 1
-------------------------------------------------------------^
any ideas?
Ethan Selzer <ethanselzer@a...> wrote:
Hi Stephanie,
See if this does it.
objrs.open "Select * from Customer where CustomerNumber = " & Session
("CustomerNumber") &", objconn, 3, 3, 1
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 9:53 PM
To: Access ASP
Subject: [access_asp] RE: SELECT statement
Thanks, I got that fixed by removing the single quote. I am having the
same problem on another page. On this page I am going to be updating users
information. This line is causing problems again:
objrs.open "Select * from Customer where CustomerNumber = '" & Session
("CustomerNumber") &"'", objconn, 3, 3, 1
I am getting the same error message as before. I tried removing the single
quotes and that caused even more problems, but I may have tried it
incorrectly.
any ideas now?
Thanks!
> Hi Stephanie,
Try removing the single quotes from the intCusNum value. Like this:
"SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum & " AND
Password = '" & strPass & "'"
Ethan
-----Original Message-----
From: Stephanie [mailto:stephanieweigel@y...]
Sent: Saturday, April 06, 2002 8:19 PM
To: Access ASP
Subject: [access_asp] SELECT statement
This is suppsed to grab the customernumber and password off of my database
and I get an the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/loginconf.asp, line 11
and here is a part of my code....line 11 is the objrs.open line
intCusNum=Request.form("CustomerNumber")
strPass=Request.form("Password")
objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
& "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
any ideas?
Thanks!
_____
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax --- Change your mail options
at http://p2p.wrox.com/manager.asp or
Message #10 by "Paul Winter" <p.winter@s...> on Mon, 8 Apr 2002 15:08:16 +0100
|
|
Stephanie
possibly
objrs.open "Select * from Customer where CustomerNumber =" &
Session("CustomerNumber") " , objconn, 3, 3, 1
rather than
objrs.open "Select * from Customer where CustomerNumber = & "
Session("CustomerNumber") &" , objconn, 3, 3, 1
Paul
----- Original Message -----
From: "Stephanie Weigel" <stephanieweigel@y...>
To: "Access ASP" <access_asp@p...>
Sent: Monday, April 08, 2002 2:58 PM
Subject: [access_asp] RE: SELECT statement
>
> Now, here is what I am getting when I type it like that:
> Error Type:
> Microsoft VBScript compilation (0x800A0401)
> Expected end of statement
> /final/update.asp, line 8, column 62
> objrs.open "Select * from Customer where CustomerNumber = & "
Session("CustomerNumber") &" , objconn, 3, 3, 1
> -------------------------------------------------------------^
> any ideas?
>
> Ethan Selzer <ethanselzer@a...> wrote: Hi Stephanie,
>
> See if this does it.
>
> objrs.open "Select * from Customer where CustomerNumber = " & Session
> ("CustomerNumber") &", objconn, 3, 3, 1
>
> Ethan
>
> -----Original Message-----
> From: Stephanie [mailto:stephanieweigel@y...]
> Sent: Saturday, April 06, 2002 9:53 PM
> To: Access ASP
> Subject: [access_asp] RE: SELECT statement
>
> Thanks, I got that fixed by removing the single quote. I am having the
> same problem on another page. On this page I am going to be updating users
> information. This line is causing problems again:
>
> objrs.open "Select * from Customer where CustomerNumber = '" & Session
> ("CustomerNumber") &"'", objconn, 3, 3, 1
>
> I am getting the same error message as before. I tried removing the single
> quotes and that caused even more problems, but I may have tried it
> incorrectly.
>
> any ideas now?
>
> Thanks!
>
>
>
> > Hi Stephanie,
>
> Try removing the single quotes from the intCusNum value. Like this:
>
> "SELECT * FROM Customer WHERE CustomerNumber = " & intCusNum & " AND
> Password = '" & strPass & "'"
>
> Ethan
>
> -----Original Message-----
> From: Stephanie [mailto:stephanieweigel@y...]
> Sent: Saturday, April 06, 2002 8:19 PM
> To: Access ASP
> Subject: [access_asp] SELECT statement
>
> This is suppsed to grab the customernumber and password off of my database
> and I get an the following error:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E07)
> Data type mismatch in criteria expression.
> /final/loginconf.asp, line 11
>
> and here is a part of my code....line 11 is the objrs.open line
>
> intCusNum=Request.form("CustomerNumber")
> strPass=Request.form("Password")
> objrs.open "SELECT * FROM Customer WHERE CustomerNumber = '" & intCusNum
> & "' AND Password = '" & strPass & "'" , objconn, 3, 3, 1
>
>
>
> any ideas?
>
> Thanks!
>
>
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
>
>
|
|
|
View Cart
