i have a code like this;
scity= Request.Form("city")
' DB connection
dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
  sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=" & Server.MapPath("blood.mdb") & ";" & _
  "Persist Security Info=True"
Conn.Open(sConnection)

' count all records
allrecords = 0
set rs = conn.Execute "SELECT * FROM "& scity


other code is well working ...
but the statement
set rs = conn.Execute "SELECT * FROM "& scity

is giving the error as;
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/test/donors.asp, line 16, column 22
set rs = conn.Execute "SELECT * FROM "& scity
---------------------^


so i cannot get it.. i need help plz


shri

__________________
shri

Hi Shri

If scity is a string then try this code :

Set rs = conn.Execute "SELECT * FROM '" & scity & "'"

If it doesn't help , let me know :)

You need parenthesis:
set rs = conn.Execute("SELECT * FROM " & scity)

You probably also need the single quotes as Kati states.
That will be the next error you get after you fix the parenthesis if you don't fix it.


Woody Z http://www.learntoprogramnow.com