2. ASPRunnerPro General questions
  3. ASP Error happened
This topic is locked

ASP Error happened

 		7/30/2003 6:41:24 PM
ASPRunnerPro General questions
author

what does this mean?
ASP error happened
Technical information

Error number -2147217900

Error description Closing delimiter not found for the string beginning at position 225 in the command. The string begins with: ')}.

URL /Status/Status_edit.asp

SQL query insert into [Status] (SocialSecurityNumber, Current, PastDue, BankRupt, CourtFiled, Collection, Can'tLocate, PaidOff, Chargeoff, Notes) values (987456321, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'Paying on time')
thanks
500056 7/30/2003

Never mind I got it going
admin 7/31/2003

Ken,
you have single quote in field name (Can'tLocate) that breakes SQL statement execution. You can remove this character from the field name or download latest update ( updated on July 31th ) here:

http://www.asprunner.com/files/asprun22.exe
Best regards,

Sergey Kornilov
500057 7/31/2003

Thanks for your reply, I already figured it out.

I just want to say this product works great.

I have spent the last 3 weeks trying to find

a way to put a database online with ASP pages

and this thing did it in less than 2 hours WOW!!!!