Search results for query: *

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

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

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

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

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

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, " & _...

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

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

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

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

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

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

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

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

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

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

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

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

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

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