|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 13th, 2000, 02:16 PM
|
|||
|
|||
|
asp
<i><b>Originally posted by : </b></i><br />Whenever I run this code it tells me there is a syntax error in the from clause. Could anyone please advise me why this is so, and how to correct it? The database is Access 97.<br /><br /><br /><%@ LANGUAGE="VBSCRIPT" %><br /><html><br /><head><br /><title>Directory Search Results</title><br /></head><br /><body bgcolor="#FFFFFF"><br /><b><i><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif" size="4">Directory Search Results</font></i></b><br><br><br /><br /><br /><br /><%<br /> Dim myconn<br /> <br /> <br /> set myconn=server.createobject("adodb.recordset")<br /> myconn.open "SELECT * FROM group;", "DSN=Business"<br /> myconn.movefirst<br /><br /> response.write "Next line is a simple write of data:<br>"<br /> response.write myconn("BusinessName") & "<br><br>"<br /><br /> <br /> myconn.close<br /> set myconn=nothing<br /> <br />%><br />
|
|
#2
July 14th, 2000, 05:51 PM
|
|||
|
|||
|
<i><b>Originally posted by : lana (lana.makarova@kline.com)</b></i><br />To me- you have an error in the sql statement, it should be "select * from group".<br />Sorry if this won't help.<br /><br /><br />------------<br /> at 7/13/2000 11:16:52 AM<br /><br />Whenever I run this code it tells me there is a syntax error in the from clause. Could anyone please advise me why this is so, and how to correct it? The database is Access 97.<br /><br /><br /><%@ LANGUAGE="VBSCRIPT" %><br /><html><br /><head><br /><title>Directory Search Results</title><br /></head><br /><body bgcolor="#FFFFFF"><br /><b><i><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif" size="4">Directory Search Results</font></i></b><br><br><br /><br /><br /><br /><%<br /> Dim myconn<br /> <br /> <br /> set myconn=server.createobject("adodb.recordset")<br /> myconn.open "SELECT * FROM group;", "DSN=Business"<br /> myconn.movefirst<br /><br /> response.write "Next line is a simple write of data:<br>"<br /> response.write myconn("BusinessName") & "<br><br>"<br /><br /> <br /> myconn.close<br /> set myconn=nothing<br /> <br />%><br />
|
|
| Viewing: ASP Free Forums > Programming > ASP Development > asp |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
