Search results for query: *

I have a simple VBScript that looks for a file called test.txt replaces the "|" with a "," and names the file test2.txt. What I want to do is have the script look at any .txt files in the current directory, create the outputfile in a different directory and name it "ProcessedFile" with a...

I have an Access 2010 table that is linked to a SharePoint 2010 list. I am using this table as a datasource for a line of business application. the porblem I just found out is the LOB cannot use a linked table. So I was wondering how I could automate the copy of the data from the linked table to...

I have a client that has created an HR repository using WSS 3.0. He has created an employee list and manually enter some of the employees. The company's HR application is hosted off site, so the client is asking how to automate the daily import of a flat file to the HR list in SP. Is this...

I am trying to create a new connection with CR11 and a .csv file. While using the database expert I am able to create my source, but when i browse the data, i get nothing but invalid characters. I have gone through the steps multiple times so I am fairly sure i am doing it right. Any advice...

I have a report in version 11 that uses a .xls as it's data source. I would like to remove or supress rows based when certain specific data appears in that row. Also, if a certain row is blank, then i would also like to remove it from the details and any totals. Tried it with a formula in the...

Hi trying to create a simple formula that is applied based on certain group membership. Datasource is a .csv file. If memeber of group then apply formula otherwise ignore. Here is code so far: if {ReportExport_csv.cGroupName} StartsWith 'agent' then {ReportExport_csv.cBWPages} - 800 else...

I need to format a column and add "" around each value in the cloumn. I am thinking there must be some formula that would do this. Any help would be greatly appreciated

I have a SQL server 2005 table with a varvhar(50) column that is populated with values ranging from 01 to 9999. I would like to pad each row to 5 characters with leading 0's and then prepend the column with CP so that so that all data in that column is 7 characters in the following format...

I have the following simple SP running on an SQL 2005 Standard edition server.: CREATE proCEDURE dbo.sp_UPDATE_CLE_RECORDS AS UPDATE c SET Last_Name = m.MLNAME, First_Name = m.MFNAME, Middle_Name = m.MMNAME, Prefix = m.MPREFIX, Suffix = m.MSUFFIX FROM cle c, MEMBER M WHERE C.MID...

Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80040e4d. SQLSTATE: 42000, Native Error: 18456 Error state: 1, Severity: 14 Source: Microsoft OLE DB Provider for SQL Server Error message: Login failed for user 'NT AUTHORITY\SYSTEM'. Any help would be greatly...

I have a date parameter that accepts a start date and an end date. how do I embed the vlaues selected in a text object to display in the report header? ex: for the period: ?param1 to ?param2. Thanks, Lou

I have an application created in VB 2005 that executes the following code: Client.Execute("RunQuery(" & Handle1 & ",\QUERY SETS\System\SpecToFortis,Combo=" & Combo_Number & vbTab & "Coverage=" & Cov_ID & ")", 10000) The Combo_Number and Cov_ID are variables received from another application...

I have created a VB.net app that executes a query against an Oracle 10.2.0.3 database to retrieve valuse and enter them in to an SQL2005 standard ed db. i am getting an MS ODBC driver for Oracle error message ora-01652:unable to extend temp segment by 128 in tablespace TEMP". Here is the code...

I have a BAK file from a SQL2000 std ed, I am attempting to restore it to a 2005 system, I am getting the following error: system.data.sqlclient.sqlerror:directory lookup for the file C:\program Files\xx\cds.data.dat cannot find the specified path. One of my customers provided me with the BAK...

I have a customer that is looking to do phrase searching in Sharepoint 2003. The application is importing searchable PDFs and be able to search across multiple PDFs at once, and have the hits highlighted. I have installed the iFilter but that requires executing your search and opening the PDF...

I am trying to create a union join in SQL Server 2000 std ed. and do not have the same number of fields in each table, I am not sure of the syntax to add fields to the tables to make them equal. Also not sure if the field names are not the same for instance, Date vs date entered would that be an...

I am creating an entry level doument management system using Sharepoint Services 2003. There are 2 customer requests that I am not sure about. 1) When I scan and OCR a document can that document in .tif format and the corresponding text file(OCR results) be stored in SQL Server 2000 and the...

When I run a dbVerify I get the following error string: [MERANT][ODBC SQLBase driver][SQLBase]09617 IDX BKR CHECK Failure (IDX BKR): <index page corrupted> This statement is the first line in the file then the tables are checked, followed by the queries. Using the error utility gives no real...

I have the following formula to change the font color to red. It appears that values that are equal are also red. This is an SQL v2000 database with an ODBC connection If Sum ({@CurrentMonth})>Sum ({@CurrentMonthPriorYear})Then crRed else crBlack All of the values are currently single digit...

I have (3) RequiredFieldValidator controls on a web form 1 vaildating a name in a text field(txtName)rfvName 1 vaildating a e-mail address in a text field(txtEmail)rfvEmail 1 validating a country selection in a DropDownList(ddlCountry)rfvCountry initial value = <Select a country> All...