Recent content by daddio2005

Have a database table of makes: Rover, Nissan etc and a database table of car models with the make ID assosciated. Will have a dropdown for makes based on the makes table, database driven. Then when a selection is made for the make, i need the model dropdown to appear and populate itself...

How does this work in an ASP page? Surely the function is written in the ASP page but the SQL query is run on the database. How will this mix correctly? Thanks.

Basically the table contains page names and page content. Upon deciding on a keyword to search for, I want to return all page names that have that word in the content and ORDER IT BY DENSITY/RELEVANCE. Any ideas would be appreciated. thanks

Thanks for your reply. Ideally I was looking for a SQL statement that would do this query for me, is such a thing possible? Also not sure how to integrate the above function into results from a recordset? Cheers.

I have a table that contains a memo field which has lots of information in it. I wish to search through each row in that table and return of count of how many times a word occurs for each row. I know the COUNT() function counts the number of rows but I need to count the number of occurances in...

I do not think it is that simple as there maybe 15 entries for bookings for any one property and SOME of them are bound to conform to the statement you have suggested and therefore return the property ID. But the others that didnt match, contradict the availability!

Thanks for your reply but , I do not think this will work. Doesnt this look for the time scale to fit WITHIN the booking times?? I need it to look OUTSIDE the booking times, bearing in mind that the latest booking for a property may be 12/12/05 til 18/12/05 so we know it is free from the...

I need to be able to search through a database of property bookings and retreive all properties that are available within the date range specified. For example: Arrive: 7 Dec 2005 for 7 Nights. So availability of a property needs to be: 7 Dec - 14 Dec I assume I will have a table of...

Sorry but I have no idea how to run sp_who2 procedure in SQL Analyser! Can anyone show me step by step how to do this? The Updates statments are running within a ASP webpage as described above. Or if anyone would be willing to look at my code, it would much appreciated. Thanks

So is there anyway I can un-lock the row? I dont understand why this section of code works on another page but not this one! Would anyone allow me to e-mail them the peices of code and maybe you could have a look at it? It really doesnt mae sense to me! Thanks.

Hi I am running the following code to UPDATE a few rows in a table. The corresponding INSERT statement runs fine and many other UPDATE statements work fine so I know the permissions are OK. Any Ideas? It doesnt throw any errors up, just times out! strSQL = "select * from pages where page_id="...