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: devRyan
  • Content: Threads
  • Order by date
  1. devRyan

    Using In Statement in Where Clause Filtering

    Hi All, I had a thread last year asking about how to do some more advanced filtering using the WHERE clause, as seen here: thread183-1366770. The result was the code here: Declare @Temp Table(UserName VarCHar(100), EyeColor VarChar(100), ShoeSize int) Insert Into @Temp Values('devRyan'...
  2. devRyan

    Parsing data rows to insert into a string

    Hi All, I was hoping you could help me with some questions I've got about SSIS/BID. I'm familiar with the workings of previous versions of DTS, but haven't yet dug into the newer implementation(SSIS/BID) in SS2005 so am having some difficulty determining how I need to go about getting done the...
  3. devRyan

    CreateTextFile with FSO

    Hi All, Was hoping I could get some quick help. I'm trying to use the FSO to create a file, but can't seem to get it to work. Could someone please tell me what I'm doing wrong? I've got the Windows Scripting Library is referenced, so it recognizes my objects. Mainly though, I don't know what...
  4. devRyan

    How do you export to Excel?

    Hi All, I was wondering if someone could tell me how to export data to excel. I've looked in the FAQ and can't seem to find anything there on the topic. All I need to do is a basic data dump, from a form. I've got a search form in my app that users can use to search through the records of the...
  5. devRyan

    Setting Combobox Selected Index

    Hi All, I have a form that contains a combobox dropdown for which I want to programmatically set the selected index. I've dug through the combobox properties and found no SelectedIndex, but have found the ListIndex, though whenever I try to set the ListIndex I get errors. What I have is a form...
  6. devRyan

    Run-time Error 3061 - Too Few Parameters. Expected 1

    Ok, new thread. :) Recap. Got the following SQL String which returns an error 3061, though the string is properly formed. strSQL = "SELECT lnkCourseEmployee.EmpCourseID, lnkCourseEmployee.CourseID, lnkCourseEmployee.EmpID, " & _...
  7. devRyan

    Listview and the Inteliprompt

    Hi All, I'm currently pplaying with the FAQ about Listviews(Loading Data) and have a question about the enviroments reaction to using the imported Listview activeX object. Should I be recieving inteliprompt help for this object? In the lines below, my listview object is available(prompted) to...
  8. devRyan

    Form OnLoad - ListBox SelectedIndexes

    Hi All, I've got a multiselect listbox on my form. I've figured of how to save the data from the form to the db, but I can't figure out how to reselect the items when the form loads at a later time. Does the form object have an OnLoad event that I could use to initialize my Listbox? What I...
  9. devRyan

    Schedule Batch Execution in 24 hours from Now()

    Hello All, I've got a rather large DTS App that I've been working on and I'm just about finished with it, with the exception of one problem. I need to schedule a batch execution at some point in the future, as part of my app. Here's the basics. I recieve excel and text files from various...
  10. devRyan

    Locating a DLL through its COM object

    Hi all, I've been tasked with moving all the sites on an old webserver over to a new server. In my preparation, I went through all the old ASP code that runs most of the sites on the box to find what COM Objects were used. As to be expected many used things like ADO, FSO, MSXML, and IXSSO, but...
  11. devRyan

    Locating a DLL through its COM object

    Hi all, I've been tasked with moving all the sites on an old webserver over to a new server. In my preparation, I went through all the old ASP code that runs most of the sites on the box to find what COM Objects were used. As to be expected many used things like ADO, FSO, MSXML, and IXSSO, but...
  12. devRyan

    How do you iInclude the ADO Enumerated Constants?

    Hi all, I'm working on a script in DTS in which I need access to the ADO Enumerated Constants Library, and can't figure out how to reference it. My background is mainly in programming in ASP, where this is done eitehr via #including an ADOVBS.inc file, or via use of a META tag. The latter...
  13. devRyan

    What flavor Unicode is used for flat file export?

    Ok, here's one more that I can't figure out. What flavor Unicode is used for flat file export? I would assume UTF-8, but I can't prove it. Here's my problem. I'm using DTS to export some table data into a plain text(.txt) file. I then upload this file on a clients web portal for use in one of...
  14. devRyan

    Import from .xls converts numerics to exponential form

    Hi All, I was hoping someone could help me find the answer to a problem I'm having with an Excel data import. I've got a field that is used for HR UserIDs, there is no rhyme or reason to the way these IDs are created, so some are numeric, some are alphanumeric. I dealt with a problem that on...
  15. devRyan

    FSO.MoveFile fails after already moving the file?

    Hi all, I'm using the FSO in some of my DTS scripts. Everything seems to work fine, except that at the completion of the packages, I always get an error message in the final step, where I archive my source file(even though the steps to actually archive the source file complete successfully)...
  16. devRyan

    Navigation Flickering on MouseOver?

    Hi all, I was hoping someone could help me with a problem I'm having with my navigation. Everytime I mouseOver any of the items they start flickering and become very difficult to actually click. I've tried searching for a solution, but haven't been able to find anything that sounds like this...
  17. devRyan

    WHERE clause as variable in StoredProc

    Hi all, I'm currently building a search engine function for a site I'm working on. The search form has 6 inputs that will serve as variables in my SQL statement(ie; userName, country, region, etc.). Any combination of these can be chosen at a time. In order to not have to build a method and...
  18. devRyan

    Simple listbox won't display

    Hi all, I'm having a problem getting a simple asp:listbox to display. I've got the following code: <asp:ListBox ID="lstTest" runat="server" Width="150px" SelectionMode="Multiple"> <asp:ListItem>Test1</asp:ListItem>...
  19. devRyan

    Simple asp:Listbox won't display

    Hi all, I'm having a problem getting a simple asp:listbox to display. I've got the following code: <asp:ListBox ID="lstTest" runat="server" Width="150px" SelectionMode="Multiple"> <asp:ListItem>Test1</asp:ListItem>...
  20. devRyan

    Virtual Directory Permissions

    Hi All, I have aa ASP site that is hosted to the Internet. In this site is a small search engine that customers can use to search for and access public customer information and related documents. Once a query is returned, the site's page logic determines which documents can be viewed as public...

Part and Inventory Search

Back
Top