Hi,
I'm not sure if I understand at all what you want to do.
If you mean that you want to do a different type of search depending on the user's selection, it can be easier than that:
Just give a value to each search type in that dropdown combo. Lets say, Street would have value 1, Country...
There is a great community site/forums page called www.webhostingtalk.com.
There you can ask for hosting, but also you can do a "Search" and try looking host names you hear about there or in Google, so you can see user experiences. Is a well moderated site, not allowing ADs, and all...
Remember that in ASP there are not constant values defined, so adLockOptimistic means nothing for the server.
But anyway, you could also check if the SQL string is well defined. You could do something like:
Response.Write(mySQL)
Response.End
That way you debug the string. Also you can check...
Hello there,
I had a similar problem with that. Try this:
lConection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & ("data\yourdb.mdb")
This way you get directly to the root fonder of your site. No security...
System files in Access? Didn't hear of it before. I knew about them in SQL Server. Well if this is the case, how can I check it out?
And on another side... how did all that data finish on my database's system files? One is supposed to have password, and the other, although is "open"...
Hi,
I'm the webmaster of an Online game fan-site, and I got some features that use MS Access databases to store things, such as game auctions or the site forums.
Yesterday I needed to check some data in one of the databases, so I downloaded the MDB file. Then I realized that Office 2000 was...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.