I got an answer in freenode irc, if someone is interested :
A refcursor variable is a string that globaly references a portal/container of the query that stores the cursor. So :
execute 'update '||table_name|| ' set var=val where current of '||quote_ident( cursor::text) ;
vituko
Last Activity: Oct 31 '09, 12:51 PM
Joined: Dec 8 '06
Location: Spain, Galiza, Ferrol
-
it's up of the driver, try another : postgresql sdbc is a native one for open office, odbc, jdbc...
The odbc package has two drivers : ANSI and Unicode
I tried odbc and sdbc and both workerd for me with an UTF-8 dbLeave a comment:
-
I think you should group the variables in well formed html blocks, or just use one variable :
toCode:document.write ('<scr') ; document.write ('ipt>...</scr') ; document.write ('ipt>') ;
I have no IE 6Code:document.write ('<scr'+'ipt>...</scr'+'ipt>') ;Leave a comment:
-
plpgsql update cursor where current of with dynamic query
plpgsql (postgresql 8.3 but I can upgrade)
I can open a cursor with a dynamic query (table / column variable) :
-open cursor for execute '...' ;
But if I want do updates...
- execute 'update ...' where current of cursor ??
Mmm I don't find the way.
Another approach :
-execute 'declare cursor ...' +with hold -for update :(
-execute 'update ... where current of cursor'... -
Thanks for your reply.
It's a good idea, but I feel surer when I have all the history while scrolling in my term, I prefer avoid ncurses interfaces,... And the colored interface is good but I want my logs also colored both in console mode (tail -f, cat, grep,...) and in plain text / other formats (xml...). Any way there should be a gnu tool that simply piping could process ansi outputs and export it. I didn't found.
Reallly...Leave a comment:
-
I know two libraries that come as php module packages at least in Debian: gd and imagemagick. I've always worked with gd because my first hosting only allowed it, it's cool. imagemagick seems to have more features...
If you search in google : php gd text, the firest results page will be enough.
Php online doc it's very good, there are many examples, the fourth link "http://php.about.com/od/advancedphp/ss/gd_library_2.ht m"...Leave a comment:
-
Ok, in bash it works. And googling it should also work in ksh... try echoing $PS1. Ksh sounds nice (associative arrays, floats,...), but bash is the default shell in most distros, you can try usermod -s to set bash as your login shell...Leave a comment:
-
Filtering ansi control sequences...
Hi, I'm trying to write an interactive bash script. I'm using some ansi control sequences : format (color, blink,...) and cursor position, to make things easier for the administrator (also me). But now I've realized that if I want to log directly the output to a file, this file becomes more difficult to parse. Ok, I can remove relatively easily format sequences throw regexp, but cursor position movements are not so easy to "translate" .... -
In BASH, the prompt is defined throw two variables : $PS1 (static) and $PROMPT_COMMAND (dynamic)... Man bash and search for prompting, prompt_command, ... No idea about kshLeave a comment:
-
I think I've found a possible solution with the runkit extension : runkit_method_a dd (using a temporary and externally created method). Like aggregate_metho ds in php4...
Any better solution?
Thanks anyway!Leave a comment:
-
In the first case you use the full path (../Flash/dack_lightgray. swf), and in the second one (with the script), only the file name (dack_lightgray .swf, I've already said it you).
The six first arguments of the constructor seem needed...
Use the js console, firebug...
I've seen it working by googling... good luck!!
In Spain it's time to go home, I'll look tomorrowLeave a comment:
-
1 - swfobject_sourc e.js, you didn't give me the whole url.
2 - I understand that you're inserting twice the flash object :
- line 28 : embeded in the html main page
- line 38 : I imagine that it uses a class declared in the imported script. But you give no path, only the file name :
var so = new SWFObject("dack _lightgray.swf" , "mymovie", "#EADBBF");
so.write("flash content");...Leave a comment:
-
I heard (I've never tried) that you have to create the object by a script (js) loaded in an external file (<script src="..."></script>).
Let me know if it works, please.Leave a comment:
-
$last_num = preg_replace ('/^.* (\d+) [^ ]*$/s', '\\1', $string) ;Leave a comment:
-
vituko started a topic Migrating OOP php4 -> 5 - $this re-assign - Recreating an instance scope outsidein PHPMigrating OOP php4 -> 5 - $this re-assign - Recreating an instance scope outside
Hi, I have another problem migrating to php5.
An important piece of my "web kernel" is a system of include / require throw exceptions :
Instead of : require $x
I do : trigger_error ('INC_'.$x...)
Error_handler :
...
$this = $errcontext ["this"] ; //Error!!!!!
include $x ;
...
It allows me to decide some things, to find dinamically... -
instead of
[PHP] echo $result;[/PHP]
do [PHP]$string .= $result ;[/PHP]
and then
[PHP] echo "There Are ".$NumOfResults ." result(s).";
echo $string ;[/PHP]
You can also control the output buffer (obstart / obgetclean / ...)Leave a comment:
-
If you work with apache (if not, I don't know), you can use the module mod_rewrite. The most important directives are : RewriteEngine on, RewriteCond ... and RewriteRule ... , it works with regular expressions and is one of the most powerfull apache tools for me...Leave a comment:
-
Look these functions : number_format or sprintf at php.net, for exampleLeave a comment:
-
<option selected="selec ted" value="Applicat ion Inventory">Appl ication Inventory</option>
selected="selec ted"!!!! The option which has this attribute would be the selected by default.
Any way if you want to simulate an event :
createEventObje ct / createEvent and dispatchEvent / fireEventLeave a comment:
-
Cool, I've never worked with xsl. Interesting approach.Leave a comment:
No activity results to display
Leave a comment: