error 2147217900

additional note: I selected "date" as to order by.
Thanks

Hi,
it sounds like something is wrong with ORDER BY clause.
Make sure you are not entering ORDER BY clause manually on the Step 4 of 12 in ASPRunnerPro. Use Change ... button for this purpose.

After choosing through the change, I am getting in the children table an updated error: "... Syntax error in ORDER BY clause." I didn't touch the sql code that was entered automatically to the text box after selecting date as to order by.

The SQL query that is going with the error: select [case_ID], [log_ID], [date], [action], [remark] From [log_activity] ORDER BY [date] ASC where [case_ID] = 22

Another disquieting and important issue: the problem I have had that the updated asprunnerpro version supposed to solve returned: I get again in the master table in the status bar the error: "Unterminated string constant" on part of the pages.
Please advise.
Thanks a lot

Orit,
make sure you running the latest ASPRunnerPro upadate that takes care of both issues: http://www.asprunner.com/files/asprunnerpro31a.exe
If this doesn't help zip and send me your ASP files for investigation.

Thanks, the problems were solved - when using the default template.
When I use a modified template, I still get an error. When I use the default template, and make the updates on the files that were created - it's OK. Do you have any idea?
Thanks a lot

Orit,
you need to recreate template using the latest update to solve the issue.

OK, Thanks.
One more problem: the "Advanced Search" doesn't work, it replies me all the records on each search. any solution?
Thanks

Orit,
you can modify include/..._variables.asp file to display SQL statement on the Web page.
Change

vDebug = False

to

vDebug = True

Proceed to advanced search to print search SQL statement on the top of page. Post this statement here.

After doing what explained, going to the main page first, I see the SQL statement (select [ID], [TSE name], [Customer Name], [Tier], [Latest Status], [Status Date and time], [Date + Time], [Method], [Type], [Severity], [Contact], [Product], [Description], [Corrective Action], [Escalated to R&D], [Date Escalated], [BUG / RMA Number], [RT ID] From [CRM] ORDER BY [ID] ASC)
from there - on the Advanced Search page: nothing.

entering serach parameter and clicking the search button brings me to the page with all the records with the SQL statement: select [ID], [TSE name], [Customer Name], [Tier], [Latest Status], [Status Date and time], [Date + Time], [Method], [Type], [Severity], [Contact], [Product], [Description], [Corrective Action], [Escalated to R&D], [Date Escalated], [BUG / RMA Number], [RT ID] From [CRM]
Please advise.
Thanks a lot

Hi,
in files you've sent me Advanced Search works fine.

If you've changed something there, send current version to support@xlinesoft.com.

Sent zip of the updated application to your e-mail.
Thanks