Search results for query: *

Excellent, thanks for the help. f.

Hi, I have a problem with a simple(!) pl/sql script that I'm using to update a small table of local employees (past & present) from another table of all current employees. The cursor query returns 160+ ids, the script then seems to loop ok, but no changes are being made - I have had it...

hi, I've a script which inserts (correctly) into several tables. I'm trying to get errors from dbi so that I can rollback, and then display a more user-friendly error message than the standard database error if something goes wrong (usually the form not filled out correctly). On an error my...

Hi, I've got a (fairly large) perl web-based application with an Oracle 9i back-end. The database has been hosted in the UK (with GMT time), but is about to be moved to Holland (CET time, so 1hr ahead). Every time we use systimestamp/sysdate it's one hour ahead, and it's producing wrong...

Hi, Thanks for that - if I were to take a copy of the data and recreate the table - I should be able to get numbers in the 500s again then? Thanks, Fraser

Hi, I have a problem with an auto-increment column - the auto increment number keeps inserting 32767 as the value, despite the largest value being around 500. This used to works - what's gone wrong? I've include sample data and table specification below. Thanks, Fraser mysql> select * from...

Hi, I have a query as follows (I've removed most of the selected fields for clarity): SELECT fixid, CASE WHEN result IS NULL THEN ' ' WHEN result = 'won' or result = 'lost' THEN CONCAT(result, ' by ', margin, ' ', resulttype) ELSE result END AS res, result, margin, resulttype FROM team...

Hi, I have a number of .pm files (all contained in ./lib) - this was one file, but I split it up as the number of subroutines was getting unmanagable. Each file contains methods that are used by subroutines in the other .pm files. Do I have to to put use a; use b; use c; etc... in all of my...

Thanks, I've toyed with both 2 and 3 (3 would be great *if* we could get the value back). re 2 - what if you have more than one concurrent user? Fraser

Hi, We're using perl dbi and oracle (via a proxy server). We have a number of tables where the primary key is a sequence. When we insert a row to one of these tables we need to find the value of the sequence inserted so we can use that in other queries. We've tried a few methods, but without...

Hi, I've changed the y-axis minimum to be 95% instead of 0%, but while the bottom of the graph is 95%, the bars are still drawing from zero (ie disappearing off down the bottom of the canvas, covering the labels). Does anyone know how to only draw the bars from y = 95? Thanks in advance...

Hi, Is it possible to do an outer join using a like condition? How about , for example, on (a.a like b.a or a.a like b.c)? Thanks in advance, Fraser

Thanks Jonsi but... I also need to be able to see more than one month on a time so I have January's 3 columns (columns 4 stacked, 1 column, 1 column), February's 3 columns (columns 4 stacked, 1 column, 1 column) etc... How would I do this? F

Hi, I'm trying to draw a bar chart with 6 series in each month. For each month of the chart I would like the first 4 series stacked in one bar and the next two series in different bars (on their own - not stacked). Is this combination possible of stacked bars/simple bars possible? Thanks in...

Hi, I'm trying to draw graphs in GD::Graph with some problems - I have two queries, the second of which produces the graph perfectly (for the last 39 days). The first query doesn't produce a graph. I can't see any difference (other than the number of rows returned - the second query doesn't...

Hi, The lines are (with username and password replaced): my $connect = q{username/password@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = MOON) (PROTOCOL = TCP)...

Hi, No the error module doesn't have anything to do with Log::Agent. Another mysterious happening is the error function is being called to display the error despite there being no call in the oracle script. Fraser

Hi, I'm migrating a tool from a postgres back-end to a oracle back-end. The perl script uses our own error.pm. The postgres script runs perfectly, but the oracle script fails to run with the error: Can't locate Log/Agent.pm in @INC ... at (eval 4) line 2. We can connect to the oracle...

Hi, I'm trying to write a shell script which logs in to postgres, executes a file filled with SQL commands (and in an ideal world would write output/errors to a file) and then exits postgres. I can't get the script to do anything else than log into the database. I'm new to unix, so apols if...

Hi, Got a script for a report that uses three bind variables. (Excerpts from the script are below) This first query to produce the headers for the csv file works ok, but the second query to display the data returns 'ORA-01008: not all variables bound', but not if I replace all :startDate...