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!

  • Congratulations Chriss Miller 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: *

  1. dlongnecker

    Importing properties of table besides data

    AA- Thank you for the tips; however, that results in an ever-so-clear Microsoft error: "Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server." I, unfortunately, do not have access to the event viewer at this time (sa doesn't give everything (^_^)), but will look through...
  2. dlongnecker

    Importing properties of table besides data

    Rather than create a new topic, I'll reopen this one as the problem is the same. Environment: SQL Server 2000 SP3a Windows Server 2003 Enterprise When exporting from one SQL Server to another using the Import/Export functionality in Enterprise Manager, the data transfers; however, the data...
  3. dlongnecker

    SPS 2003 - Searching - Hiding Document Lists

    ChaserNL- Yeah, that's the page I anticipated, however, as stated above, the templates will affect all sites in the portal. Our hundreds of other sites would be quite upset if we change how the search pages filter information. I'll give it a shot on a development server and see how it works...
  4. dlongnecker

    SPS 2003 - Searching - Hiding Document Lists

    ChaserNL/Thomas2000- To catch a few things: Yeah, SPS2003 = SharePoint Portal Server. ;) Sorry about that. Just used to SPS over time. I've hunted around on how to edit the search results page to no avail (hence why I posted), so far... I'll keep looking. Everytime I hit the results page...
  5. dlongnecker

    SPS 2003 - Searching - Hiding Document Lists

    Is there a way to hide the "List Items" from being searched in a specific site? In one of our sites, there the document library structure has folders that are very close to the names of the documents they contain. When searching for a document, it displays all of the "list items" first and...
  6. dlongnecker

    Looping Through Record "Categories" Based on Another Table

    Okay... I'd like to thank my personal hero, steven290, lol... Here is the final code. I tweaked it a bit to avoid the whole "record doesn't exist, blowing up" issue. I still need to clean up the variables and such and place comments... but the functionality is there and, so far, works quite...
  7. dlongnecker

    Looping Through Record "Categories" Based on Another Table

    ... grr... it's the CSTR function. The one time I don't preview... I can't type. (T_T) --- David R. Longnecker Web Developer CCNA, MCSA, Network+, A+ Management Information Services Wichita Public Schools, USD 259
  8. dlongnecker

    Looping Through Record "Categories" Based on Another Table

    ... I'm not sure why this matters... it's all varchar in the database... but... [code if rows(2,i)=[hightlight]cstr[/highlight](rs2("disc_id")) then [/code] ...fixed the problem... with that oddity. --- David R. Longnecker Web Developer CCNA, MCSA, Network+, A+ Management Information Services...
  9. dlongnecker

    Looping Through Record "Categories" Based on Another Table

    Okay... I appreciate everyone bearing with me... I verbatium used Steven's code (pointing to the right tables)... <% set rs = cipconnect.execute("select * from plans_Section6 where cip_id = '" & cip_id & "'") if not rs.eof then rows = rs.getrows() end if set rs2 =...
  10. dlongnecker

    Looping Through Record &quot;Categories&quot; Based on Another Table

    bslintx - *stares blankly and confused, slightly drooling* LOL... No worries... just my already confused, sorta burned mind was even more confused. Thanks though. ^_~ --- David R. Longnecker Web Developer CCNA, MCSA, Network+, A+ Management Information Services Wichita Public Schools, USD 259
  11. dlongnecker

    Looping Through Record &quot;Categories&quot; Based on Another Table

    Okay, bit of tweaking and I get Section 6 - Strategies Reading ID: 11 | Target: 1 | Focus: 1 Math ID: 11 | Target: 1 | Focus: 1 Writing ID: 13 | Target: 2 | Focus: 2 *dance* Okay... now... to make this semi-more painful... this is what I originally planned on doing (though without...
  12. dlongnecker

    Looping Through Record &quot;Categories&quot; Based on Another Table

    Let me do a bit of research on the GetRows function; I'm not as familiar with using some of the ADODB commands (ack, learning curve. ^_~). --- David R. Longnecker Web Developer CCNA, MCSA, Network+, A+ Management Information Services Wichita Public Schools, USD 259
  13. dlongnecker

    Looping Through Record &quot;Categories&quot; Based on Another Table

    Steven290 - Okay, that makes sense, my question; however, is once I have those in order... how can I tell the code to group those into the correct section headings? Not only do I need Reading to all be grouped together, I would like there to be a heading called "Reading" above that (I have a...
  14. dlongnecker

    Looping Through Record &quot;Categories&quot; Based on Another Table

    bslintx - See the latest post. Those are just pseudo recreations; however, the key fields are the same. --- David R. Longnecker Web Developer CCNA, MCSA, Network+, A+ Management Information Services Wichita Public Schools, USD 259
  15. dlongnecker

    Looping Through Record &quot;Categories&quot; Based on Another Table

    Sheco - ROFL... I'm a techie... not a curriculum. My only comment - "I'm glad I've already graduated..." Here's the basic structure: tblDisc disc_id disc_name 1 reading 2 mathematics 3 writing ... tblSection6 id disc_id target_id focus_id ... 1 1...
  16. dlongnecker

    Looping Through Record &quot;Categories&quot; Based on Another Table

    I'll try to draw this out the best I can. I have two tables, discipline (reading, math, writing, etc) and the actual information table. I want to do a loop through the information table that looks all of the records, determines the dicipline and "groups" them together when it displays...
  17. dlongnecker

    Active Directory Query Works on IIS6, not IIS5

    One additional observation: I've noticed that the issue is fixed on the Windows 2000 boxes with 1) Windows 2000 Admin Pack installed and 2) a query of AD with ADUC or another tool since bootup. It's like the computer has to establish a connection before the ASP pages and see it. Just...
  18. dlongnecker

    Active Directory Query Works on IIS6, not IIS5

    After developing for quite some time on IIS 5.1 (Windows XP)/MDAC 2.8, I started moving my webs over to a Windows 2000 Advanced Server/MDAC 2.8; however, those pages that queried Active Directory gave me the evil '80004005' error (Unknown error). I've moved a few to a 2003 Server and they work...
  19. dlongnecker

    modifying sharepoint

    Hmmm... I've seen that when I've edited the page via the Browser and forgot to close FrontPage, but that's with FP2003. Until I upgraded to 2003, I had a lot of quirky (techie term) issues with FP2002 and SPS 2003 (given you're running 2003). When you say QuickLaunch, do you mean the...
  20. dlongnecker

    Select Case Through a Range?

    Tarwn- Yep, your solution with the MoveNext in the wrong spot was right--sorry for the long delay... finally managed to figure that out on my own while roamin' mobile. I still ran into a few other issues (not the NA issue), but rewrote it: strSQL = "" strSQL = "SELECT language_percentile...

Part and Inventory Search

Back
Top