Hello,
I downloaded the trial version to experiment with the product and for the most part this is very nice. I downloaded MySQL build a dbase and table. Installed a MySQL System DSN and had a test page up in no time.
Problem I am having is the search query strings being generated by ASP Runner are incorrect!
Here is the query:
select `rowid`, `client`, `item`, `instance`, `date` From `itemhistory` where (1=0 or `client` like '%rob%' or `item` like '%rob%' or `instance` like '%rob%' or `date` like '%rob%') date
The problem is that EXTRA "date" at the end of the string that is getting added somehow. If I run the same query without that I get the desired results.
select `rowid`, `client`, `item`, `instance`, `date` From `itemhistory` where (1=0 or `client` like '%rob%' or `item` like '%rob%' or `instance` like '%rob%' or `date` like '%rob%')
Any help would be appreciated I have played with the wizard for hours now and can't figure out what is causing that "date" to be tagged at the end of the string.
Thanks I am very interested in buying the product but if I can't get a simple table to be queried what is going to happen once I have multiple table relationships etc?
I figured it out. One of the first pages had an "order by" field and I put date there. After I removed that it worked great.