Search results for query: *

I know this version is very old/outdated but our company continues to use old solutions. :) I'm tasked with documenting all open TCP ports by this tool. I've searched SAP's site and have turned up nothing in the way of ports and port ranges for all the various services for CR 8. Would...

What's a good way to break up the time values returned in your average BSD-styled ps? The format is generally dd-hh:mm:ss.ss. As you know, the days portion is not always populated if days haven't accumulated depending on the aspect of time we are looking at (ie, etime, cputime, etc.).

I have searched and read a few sites but I thought I would ask here from professional users for what exists as a good viewer of either csv or xls attachments. I can generate the reports in a number of formats but the users prefer a csv and/or xls format for easy manipulation of not incredibly...

Thank you very much lebisol for your ideas. I learned a couple new approaches if I can get my I.T. team to play ball with me. The policies they have placed on our development boxes are rather rigid and don't offer a whole lot in the way of work-arounds. :/

Using OpenRowSet to pull the data in yields the following error: Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must access this provider through a linked server. All the ideas and suggestions have been really good ones but having the IIS installation on a different server...

I'm currently evaluating the InterAKT product. Generating a basic upload/import page set is proving not to provide a solution for me. One of the developers has been working with me to resolve it so I have been looking elsewhere in between the developer feedback for alternate solutions...

Got a slight issue and would like a little insight in how some of you have approached it. I receive data via an uploaded CSV file and would like to select that data from that file and insert into a table of my complaints database. I currently have a DSNless connection to the CSV file that...

Due to the storm we are migrating our applications to another vendor's server for which we don't have full access. We weren't given the full path to our page directory. It's been a while so please forgive my ignorance but how can I determine the full path of an executing script?

I've recently taken over a database that has SQL server 6.5 compatibility set due to the nature of the vendor. I am to write a few scripts to dump some of the data for a 3rd party. This data, of course, needs to be fixed width text. Does anyone have any recommendations for a good string...

What's the easier approach for handling inserts where a duplicate record may exist? ASP/MSSQL are the language and db in use. I would like to display a pop-up indicating that a record already exists and list the keys attempted to be inserted.

Without additional coding, what are convenient methods for importing flat files with dates that are of the form yyyymmdd? I have customized import scripts to account for the different format but I was wondering if DTS had an "intelligent" operation for date data-type imports.

Failed to mention Access 97 is being used.

I have searched with some limited success but I would like to color code some values in a resulting report. If the value exceeds a maximum, then a particular color would be applied to that value. Anyone approach this idea before?

I guess for now I must use Q-Analyzer to get the output in the fixed width format I need. It is a bit annoying to work around the limitations of the tools.

Sad to say that the output from the scheduled job still truncates the blanks. Going to try a few other suggestions I found for preserving width.

I didn't even think to try to combine the fields. I'll give it a test.

I am implementing a stored procedure to dump a list of previous days work orders. The recipient of this lovely list of work orders is utilizing an older system of fixed length flat files for import and processing. Each row in the output file is 500 bytes and must be 500 bytes to be cosidered a...

I did a better search this time in Tek-Tips and found out my issue is really limited to Access 97. http://www.tek-tips.com/viewthread.cfm?qid=492699

I would like to eliminate the dash and replace with nothing in effect closing the resulting string up. Looking for a good update query method to performing the adjustments.

I have taken over a database that has some not-so-normalized data in a field that contains phone numbers. Some fields are all numeric and some have the dashes. What's a good method for removing the dash character? I have looked at a couple substring functions but I need something tiny and...