Search results for query: *

Hello Everyone .. I was wondering whether there was a way to embed a file (.EX4) into a Powerpoint presentation - Mainly to transport it with the rest of a package so that users can use it while going through the presentation. The idea is not to run the file within the presentation, but merely...

Hi All .. I'm playing around with a program (not very good at it) and have written the below piece of code so far: All of the below code is added to my main form and therefore loads when the application is started. The code basically connects to a database and then dynamically creates a...

Hi there I have a column (varchar(255). This column contains either dates in the format dd/mm/yyyy, the string "TBD" or the string "Abandoned". I was wondering if there was a way to select all the data in this column but order the data so that the all the rows with dates are displayed first...

Hi there all .. I think I know what the answer to this question might be, but I'll ask anyway. Is there a plug-in, or a way to make VB6 Forms look a bit nicer? without converting to something like VB.NET? I know that VB6 probably IS very old by now but was wondering if there was something...

Hi there I was hoping someone could please help me. I have managed to write a bit of code that reads from one excel spreadsheet and then create a populate a new spreadsheet with this data. One of the columns in the source spreadsheet is a description column. This column could contain any...

Hi there I was hoping someone could help me as I'm struggling a bit pls .. I'm writing a little application that needs to copy certain columns' data from one xls file into another. I have the below so far: Say I have sheet1.xls and sheet2.xls (assume each file has only one worksheet). In...

Hi there I was wondering how I would do the below in SQL 2005. I have a column A in table TBL. Column A has the following values: 4h 7h 24h 100h I would like to work out the total number of hours in this column with a select statement. So my initial thoughts were somthing like this but I...

Hi there! I have a scenario where I am selecting from 2 tables: tbl_name and tbl_matched tbl_name has 2 columns: ID and NAME tbl_matched has 2 columns: ID and STATUS I would like to: "within one go" return the results of: ID, NAME, MATCHED, REJECTED The MATCHED and REJECTED will be...

Hi there .. A bit new to ASP o sorry for the experts out there who are reading this. I'm having trouble executing a sql 2000 proc through my asp/vbscript code. (Snippet below) .. Any ideas? I find it a bit hard to find out where I'm going wrong as I'm doing it in notepad ... are there any...

Hi All I was hoping you could give me some advice. I've written the little piece of code below in an attempt to update one row in my database which sits on my remote web server. I have saved the below code to a file called: test.html, but I dont get an error when I double click the file, but...

Hi there A really easy one (probably) sorry but I was wondering if I had a table with 5 rows in it .. how can I select all the columns but only for a specific row? FOR Example I need something like this. select * from tablename where rownum = 10? Possible? Thx S

Hi there .. I have a small problem which I'm sure would be easy for some of you to solve and any help would be greatly appreciated. I have a little Web Based Java Application which will insert some data into a column in a table in a SQL Server 2000 Database. The value could be anything "text...

Hi there could anyone please help me in getting my date in the format YYYY-MM-DD as none of the below appears to do it Thanks a lot S select convert(varchar, GetDate(), 100) as '100 Conversion', convert(varchar, GetDate(), 101) as '101 Conversion', convert(varchar, GetDate(), 102)...

Hi there I was hoping that someone could help me. I would like to do the following: I have a file called "test" which has the below lines in it: test test test test 2000 test test test 1000 test test test 2000 2000 2000 test test test test test I would like to run the sed command against...

Hi All ... My Script looks like this: ******************************************************** cat sanity.cfg | while read line do grep $line bigfile if [ "$?" -ne "1" ] then echo "Cannot find $line" fi done...

Hi there ... I'm having a problem with Business Objects XI R2 and was hoping that someone could assist or kindly give me some advice. When I try to launch the "Business Objects Enterprise .NET Administration Launch Pad" I.E returns a "The page cannot be displayed" Errror (also at the bottom of...

Hi All I have a little script (see below) which should rename all files and directories which match the pattern "bb". The problem however is that the script fails to rename some of the later directories as the script has already renamed some of the earlier directories which these directories...

Hi All Was wondering if you could help. Need to write a little ksh script that will loop through files in a directory and rename all the files or directories that contain the letter bbs in them. The script should rename these 3 letters to aaa. For example if I have the following files in the...

Hi there I'm trying to write a small script that will loop through all the files in a directory (for file in ls) and then to SFTP them one at a time onto my remote server. My SFTP Command looks like this: sftp user@server Very basic I know, I was wondering if there was a way to pass an extra...

A very silly questions, not an expert! In Oracle, or I suppose any SQL for that matter, are there certain statements that commit themselves or do I always have to commit a statement? I was told that statements like inserts and updates commit themselves where on the other hand a delete...