SQL relaited question

[BarryMVS]

Hi all,

I keep getting the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.


This is the posted data:

POST Data:
check=4&jobtypeID=2&englist=Brian+Buist&cuSer1=Vir&cuSer2=Glas&date=16+Jul+2004&allday=True

And this is the transfer from the posted data to ASP variables:

cuSer1 = request.Form("cuSer1")
cuSer2 = request.Form("cuSer2")

This is the SQL statement that is causing the error:

cusSql = "SELECT * FROM Customers WHERE [Company Name] <> ' ' AND [Company Nmae] LIKE '%" & cuSer1 & "%' AND [Company Name] NOT LIKE '(CLOSED)%' AND [Company Name] NOT LIKE '(DUPLICATED)%' AND [Address Line 3] LIKE '%" & cuSer2 & "%' ORDER BY [Company Name];"
set cus1 = conn.Execute(cusSql)

Any ideas are most welcomed.

Thanks,

Barry

ICT Network Administrator
IT Services Manager

 

[shatch]

cusSql = "SELECT * FROM Customers WHERE [Company Name] <> ' ' AND [Company Nmae] LIKE '%" & cuSer1 & "%' AND [Company Name] NOT LIKE '(CLOSED)%' AND [Company Name] NOT LIKE '(DUPLICATED)%' AND [Address Line 3] LIKE '%" & cuSer2 & "%' ORDER BY [Company Name];"
set cus1 = conn.Execute(cusSql)

if this is a direct copy-paste you may want to address the spelling of Name highlighted above.

 

[BarryMVS]

DO'H!

I think I've been working on this code for too long. My eyes are starting to blur!

Thanks for the assistance. I'm going to take a break.

Cheers,

Barry

ICT Network Administrator
IT Services Manager

 

[shatch]

It happens to us all Enjoy your break!