Recent content by iannorthwood

> Did you miss my post 13 Apr 07 4:45? No, but I knew that % is SQL Server's wildcard and thought that you'd assumed I was talking to SQL Server: PHV's response explicitly explained that it is used for ADO, too. Please accept my apologies. I guess this shows that it's important to be explicit in...

Aaaaaaaahhhhhhhhh.......All is clear now. Susbtituting % for * results in 2 records! Good work, thank you, PHV.

No, for now (don't ask...recalcitrant IT dept...) the ASP page talks to the exact same MDB. I have tried Exclusive access, closing the d/b in Access, closing Access altogether (even though the d/b is closed) - that shows how frustrated I am! :-)

> I took two different FAQ's and put them together > and was able to get it to work! :) How? It would serve this community better if you were to share your new-found knowledge. That way. somebody else with a similar issue could read your post and benefit in the same way.

I have a query which returns 2 records when executed in Access but, when run from my ASP page, I get -1 for RecordCount or, if I loop through the RS incrementing a counter, the counter is 0. In either case, it's basically saying that there were no records. The ASP page uses the following...

LOL...switched to ANSI-92, pasted in my query. Result? JOIN expression not supported :-) I'll just code in a conditional in my project so that, if the target is MDB, it'll use what I have now and, if it's SQL Server, use the "correct" syntax.

It *is* Access, you're right, but I want to keep the SQL generic so that I can migrate when the wasters in my client's IT department finally get me a SQL Server to migrate it to. Many thanks again for your help.

Strictly speaking, 'Fields' is a collection, not an object. You would use it to extract the contents of the recordset's, er, fields. Thus, the database being queries here would have fields called 'code' and 'shortname' and the statements shown would set values from teh contents of those fields...

Apologies: forget my comment about the number of records: a colleague had deleted the other 2. D'oh! Looks like the simple substitution of IN for = will work for me. Thanks again.

Wow! Awesomely quick response, thanks! However, the JOIN query results in an error message (even with your typos corrected): Syntax error (missing operator) in query expression 'T_Request.AppID = T_App.AppID INNER JOIN T_Vendor on T_App.AppVendorID = T_Vendor.VendorID' Replacing '=' with...

I have 3 tables: one holds details of task requests (T_Request), one holds application details (T_App) and the last holds application vendor details(T_Vendor), the last to avoid users trying to use non-standard or shortened names e.g. 'MS' instead of 'Microsoft' I'm trying to create a query on...

No. For as long as I can remember I've been promising the members of the club that our page will have a 'Statistics' page. I already did the easy stuff (most appearances, tallest, heaviest) but now I need help with the more complex queries.

I have a bunch of tables for my basketball club's d/b. I want to be able to interrogate them to build a web page showing player stats. For example, I want a table showing the top 5 scorers, top 5 3-point scorers, etc. What's got me foxed is how to join it all up and then sort it into the top 5...

Sorted... Dumb, dumb, DUMB Microsoft for insisting that the undo disk go where the VMC is, rather than where the VHD is AND not providing the user with a way to SAY where the VMC should go. Long & short, the VMC gets put into a sub-folder of 'My Documents\My Virtual Machines' (grrrrr....)...

BTW, I stumbled on an article elsewhere about creating a difference disk. I went through the steps to do that, using the Virtual Disk Wizard and got the same result.