Search results for query: *

I'm getting the above error in a query. How can I 'trap' this error, and basically ignore it? Many thanks, Mark

Hi - I need to be able to change the name of the Worksheet, ideally by reference to the content of another cell. EG: =SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$D$2:$D$201)/SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$C$2:$C$201) In the above...

I have to plug my laptop into various different client offices. Each one requires a different set of IP/Router/DNS settings. At the moment I manually change them each time. What a bore! Can I store muptiple IP settings, and switch between them on the fly? Many thanks for any help. Mark Lewis...

I have a problem. My web developer insists that their Websphere v3.5 can only produce referer logs seperate to the main web logs. In my (limited!) experiance, a web log is typically: User IP| Date/time| GET statement| refering page/key words The seperate referer logs I am getting from...

I need to access a Windows system via Terminal services from an office of Mac's It seems you can get software to do this for OS-X, but these Mac's are all on OS-9. I can't find any TS software for OS-9. Does anyone know how this can be done? Many thanks, Mark

I'm having trouble with DIV/0 errors. I can't filter this out in the HAVING clause as the whole role row will go, and there is data in other columns I need. Someone suggested using DECODE, which seemed a good idea, but I can't get the syntax right for this query. The particular statement that...

I thought I could use 'as' to name a column, and then use the column name in calculations. This would be particualry useful for aggregated functions. But I can't get it to work - I get 'invalid column name' error (on Oracle 8i). If anyone has any suggestions, that would be great! Thanks, Mark...

I thought I could use 'as' to name a column, and then use the column name in calculations. This would be particualry useful for aggregated functions. But I can't get it to work - I get 'invalid column name' error (on Oracle 8i). If anyone has any suggestions, that would be great! Thanks, Mark...

I was trying to set up a peer-to-peer to share files at home last night, and changed my Network Indentity from a domain to a Workgroup (which is what Help said I needed to do). This didn't help me to share the files, but has completely messed up my laptop by creating a new user and locking me...

Well, weird to me! I'm running a fairly long SQL query (10 joined tables/views - details below). A similar query has run successfully before, but after adding another view, I get: ORA-01114: IO error writing block to file 11 (block # 1044482) ORA-27069: skgfdisp: attempt to do I/O beyond...

I need to access data in Oracle8i (on NT) from Sybase (on Unix). I've been told this can't be done. Really? Does anyone know how to do it? Thanks, Mark, London

Can anyone tell me what is wrong here: Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.1 - Produ JServer Release 8.1.7.2.1 - Production SQL> CREATE TABLE ml_tst_tmp ( 2 ACC_ID NUMBER(16) NOT NULL, 3 CUST_ID NUMBER(16), 4 CUSTOMER_NAME VARCHAR(30), 5 TITLE...

I have a table which (simplified) has CustomerID PerdioNo (YYYYMM) Amount and therefore has multiple rows per CustomerID, if they have activity on several periods. I would like to transform this into 1 row per CustomerID, with: CustomerID, 1999Amount, 2000Amount, 2001Amount I have been able...