Re: SQL Runs in Access and not in ASP: 0x80040E10 Too few parameters

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Bob,
Thank you. Problem solved. The problems were the the " double quotes
instead of ' single quotes and the wildcard character. Please forgive
more delayed comprehension....

Regards,
OJ

.



Relevant Pages

  • Re: sql query ...wrong? in vb.net - please help
    ... use of # as the delimiter is not the complete answer - use of single quotes is the ... Thanks, Chris and Bob. ... I guess you can't expect to write a 1000 page reference book without a ... > This newsgroup is for users of Visual Basic and whatever ...
    (microsoft.public.vb.database)
  • Re: AfterUpdate Error Message
    ... Thanks Bob, that worked perfectly. ... > if the name has imbedded spaces, simply enclose the name in square brackets ... I've tried single quotes, double quotes, underlines between the ... >> End Sub ...
    (microsoft.public.access.forms)
  • Re: sql query ...wrong? in vb.net - please help
    ... Thanks, Chris and Bob. ... My VB.net book used single quotes and I just thought it was a VB.net thing. ... I guess you can't expect to write a 1000 page reference book without a ... > This newsgroup is for users of Visual Basic and whatever ...
    (microsoft.public.vb.database)
  • Re: Stored Procedure Problem
    ... string employeeName = 'myname' ... > Tell me you are using single quotes ... > Bob M. ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedure Problem
    ... Tell me you are using single quotes ... Bob M. ... > I create a stored procedure that returns top 5 records based on username ...
    (microsoft.public.sqlserver.programming)