|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
HELP - HELP SQL select statement <Simple> |
|
From: |
John Sanders |
|
Date: |
2/24/2001 11:34:18 AM |
|
IP: |
24.28.165.215 |
I'm new to ASP and SQL. I receive an error on both of these lines. What is the problem?
Here is the error
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Creditor = AAFES/ DPP - MILITARY STAR)'.
Here are the two SQL statements
SQL = "SELECT * FROM Creditors WHERE (Creditor = " & Session("TheCreditorName") & ")"
SQL = "SELECT NewInterestRate, AcceptablePaymentFactor, MinimumPayment. * FROM Creditors WHERE (Creditor = " & Session("TheCreditorName") & ")"
Thank you very much
|
Follow Up - Re: HELP - HELP SQL select statement <Simple> - balamurugan 2/26/2001 5:47:23 AM
Follow Up - Re: HELP - HELP SQL select statement <Simple> - Kevin 2/26/2001 10:44:36 AM
Follow Up - Re: HELP - HELP SQL select statement <Simple> - Steve 3/12/2001 1:09:09 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
