Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1932 | Replies: 4
 |
•
•
Join Date: Mar 2006
Posts: 14
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
Help with syntax error Hi guys,
Right now I develop a website that use Microsoft Access database. So, I've developed a database that store all my pics and videos. But when I tried to make a recordset (this is a command in Dreamweaver MX, as I use it to develop my web pages) to call the database, this error dialog window occured;
Microsoft ODBC Microsoft Access Driver
Syntax error in FROM clause
This never occured for other database I've developed before. So, can you figure it out whats wrong with it and how to fix it? Thanks in advanced.
Right now I develop a website that use Microsoft Access database. So, I've developed a database that store all my pics and videos. But when I tried to make a recordset (this is a command in Dreamweaver MX, as I use it to develop my web pages) to call the database, this error dialog window occured;
Microsoft ODBC Microsoft Access Driver
Syntax error in FROM clause
This never occured for other database I've developed before. So, can you figure it out whats wrong with it and how to fix it? Thanks in advanced.
•
•
Join Date: Aug 2005
Location: El Paso, TX
Posts: 225
Reputation:
Rep Power: 4
Solved Threads: 5
Posting Whiz in Training
That means you have an error on your SQL statement. What is the code in your application that you're using for the recordset??
•
•
Join Date: Mar 2006
Posts: 14
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
Do you mean this one?;
<a href="numdetails.asp?id=<%=(Recordset1.Fields.Item("id").Value)%>"><%=(Recordset1.Fields.Item("number").Value)%></a></font></div></td>
<a href="numdetails.asp?id=<%=(Recordset1.Fields.Item("id").Value)%>"><%=(Recordset1.Fields.Item("number").Value)%></a></font></div></td>
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
