Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: iannorthwood
  • Order by date
  1. iannorthwood

    Different result in Access vs ASP page

    > 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...
  2. iannorthwood

    Different result in Access vs ASP page

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

    Different result in Access vs ASP page

    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! :-)
  4. iannorthwood

    Send form to email and DB

    > 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.
  5. iannorthwood

    Different result in Access vs ASP page

    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...
  6. iannorthwood

    Query syntax help required: JOIN? Sub-query? Which?

    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.
  7. iannorthwood

    Query syntax help required: JOIN? Sub-query? Which?

    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.
  8. iannorthwood

    ADODB objects

    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...
  9. iannorthwood

    Query syntax help required: JOIN? Sub-query? Which?

    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.
  10. iannorthwood

    Query syntax help required: JOIN? Sub-query? Which?

    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...
  11. iannorthwood

    Query syntax help required: JOIN? Sub-query? Which?

    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...
  12. iannorthwood

    Generic syntax for statistics

    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.
  13. iannorthwood

    Generic syntax for statistics

    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...
  14. iannorthwood

    Easiest way to re-use a VHD

    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....)...
  15. iannorthwood

    Easiest way to re-use a VHD

    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.
  16. iannorthwood

    Easiest way to re-use a VHD

    I have a number of staged builds created by someone else and want to add another stage "on top of" one of the others. As each package takes about a day and a half to install, I *REALLY* don't want to have to start at stage 1, when there HAS to be a way to start where I want i.e. with the last...
  17. iannorthwood

    The volume "USERS_BY_SURNAME" only has 99 MB of space left.

    Under intense time pressure to create a configuration for testing, I coped an existing VHD to a new name, created a new VPC and loaded it. The new VPC started happily enough but, after adding around 200Mb to it to begin the test, I now get the message above at the Ctrl-Alt-Del logon screen...
  18. iannorthwood

    Cookie problem

    I have implemented a JS cookie solution but have a problem. I use it as a record of the user preference for tooltips: clicking a form button toggles them on and off. That all works. I can toogle on/off to my heart's content. Here's the problem: the cookie which gets written if the page is...

Part and Inventory Search

Back
Top