| | |
|
|
|
recordset error |
|---|
| message from -D- on 15 Jul 2004 |
I'm getting an error that says, expected ')' when trying to view my search
results.asp page.
(referring URL)
http://www.dwayneepps.com/test/rsimage.asp
Can anyone see where the syntax is wrong and how I can correct it? Thanks
for any help.
-D-
|
| cmbergin replied to -D- on 16 Jul 2004 |
The error may not be in your recordset. Can you go into your code and post the
line (plus the relevant block above and below) that is causing the error? DW's
line numbers match the line numbers reported by the browser in error messages.
|
| -D- replied to cmbergin on 16 Jul 2004 |
Here is the line of code for that error beginning at: "Recordset1.Source...etc.
Also included is the line above and below.
Case Exact
Recordset1.Source = ?SELECT * FROM tblProducts WHERE prod_number = ?? +
Replace (Recordset1__MMColParam, ???, ???) + ???
Case Ending
Is the problem related to using a single quote in the statement syntax?
-D-
|
|
Archived message: recordset error (Macromedia Dreamweaver Web Design)
