Back in February 2004 this topic was aired, and you replied that search parameters were not supported in ASPRunner. I am hoping that you may have been able to add this feature to the latest version of ASP?
I am trying to transfer a database from MS Access to a web-based searchable database for general reference, but not amendment or alteration by others, which will include lists of subscribers to certain music books between 1700 and 1820. Thus I need to include different search parameters, such as searching for specific subcribers' and printers' names, or all names within a certain county or book, or all names starting with [say] the first four letters, etc.
When trying to set up the copy of one table, I have written the SQL exactly as required:
select [BookID],
[BookRef],
[Full Name],
[FullTitle],
[Date]
From [B2 - Search for Book Reference by Composer/Compiler last name]
but get the message that there is an incorrect parameter and the SQL needs amending. (Too few parameters. Expected 1)
The missing parameter is, I think, probably the search command in the Access db [Search for Books by Composer's last name], which in fact is in a field shown in Access design view, but not on the resultant query form.
I am using the trial version of ASP with 4 days to run, but feel that the inability to search in this way is a major drawback, and one which would make me look elsewhere. Can you help please?
I was proposing to pick all the pages up in FrontPage 2003 so as to customise them. Is there no way that this method could be used to enable this sort of search?
Many thanks