Search results for query: *

Hello, I have this MS access application which needs to retrieve multiple refcursors from an Oracle database and export this to a MS Excel workbook. Per refcursor a sheet needs to be used to place the contents of the refcursor. What I have so far is that I can retrieve the first refcursor...

Hi, Is it possible to create a sequence which will reset itself at the start of each month? Thanks, Tijs

Hi, Is the following possible: select * from table_x where field_x in (value_x, value_y, value_z) value_y doesn't exist in the table thus logically speaking the query would only return the results for value_x and value_z. Now my questions is, can I also retrieve a blank row for value_y via...

Hi, Is it possible to create a view based on the output of a stored procedure? this output will be a recordset This stored procedure will access a few tables, do some transformations on the data and this data should then be returned to Business Objects. Since Business Objects doesn't support...

For some reason I just keep on getting this error: Warning: Cannot modify header information - headers already sent by (output started at C:\devtools\xampp\htdocs\pp\xlsreport.php:1) in C:\devtools\xampp\htdocs\pp\xlsreport.php on line 3 This is the piece of code causing this: line 1:<?php...

Hi, My website was runing fine for a few months but no all of a sudden i get following error while accessing my database: Warning: main(DB.php): failed to open stream: No such file or directory in /home/w20998/public_html/test.php on line 5 Fatal error: main(): Failed opening required 'DB.php'...

Hi, I'm pretty new to php and I have this problem I just can't fix. On my local machine (apache, php 4.3.4 and mysql) i've created this dbConnect.php script which reads in the db parameters (username, pwd, ...) and creates a connection with the DB. In other scripts where i execute some...

Hi, Is it possible to display a specific cell from a MS Excel sheet in an HTML document without using a webserver? So whenever you update the value in Excel, it's automaticcaly updated in the HTML page. Thanks, Tijs

Hi there, I have an application running on SilverStream 4 with an Oracle9i database behind it. When I try to execute a callablestatement with setNull (eg. cstmt.setNull(14,Types.NULL);) I get the &quot;java.sql.SQLException: Invalid column type&quot; error message. When I change to setNull to...

Hi, Is it possible to change the src for an IFRAME with javascript? I'm trying stuff like: // javascript function redirect(){ document.testingframe.src=&quot;http;//www.mail.be&quot;; } // html <form onsubmit=&quot;redirect()&quot;> <input type=&quot;submit&quot...

Hi, I have this cgi script (perl) which has to retrieve an image from the database. This image is stored in a column of the blob datatype of a Mysql database (using DBI). Can I just do this by using a reguler select query? Once I have retrieve the blob from the database, how can I display it...

Hi, Is it possible to replace the new line character with the HTML tag <br>. For logging I'm printing the stackTrace of an exception to a log file. I'm also printing this to the browser. In the log file the stackTrace is displayed nicely, but in the browser it is displayed as one string. I'm...

Hi, I don't know if I should put this questions in the HTML forum or here, but i'll try here first. I have a problem with my charsets for French characters like é, è, ç, à, .... I have an HTML template which uses a form and a post method. I've set the charset of the page to...

Hi, is it posible to use mailto with parameters to open templates(writing paper) for MS Outlook. I'd like to use a specific html template that i will put on the server and which will be used as a mail template. I know you can use mailto:xxx@xxx.com?subject=testing&body=yourbodytext. Is there...

Hi, I'm trying to send a mail with mailx which has to send a fil attached and a message in the body. To do this I'm using the following line: (cat <message> ; cat <filename>| uuencode <filename> )| mailx -s&quot;<subject>&quot; <mail address> But what I end up with is always the same. I...

Hi, When can you call the ServletContext? - Can you call it in each method as long as you import the servlet classes. - Can you only call it in a doGet, doPost, init, ... - If you call it in another method than doGet, doPost,..., should these methods (doGet,..) be in the class or doesn't it...

Hi, I have a problem with the servletcontext. I get a nullpointer exception. At server startup I store some mail parameters in the servletcontext. I retrieve these parameters from several servlets. Except in this one (see code below, sorry if it's alot) I can't retrieve the parameters. Yet, I...

Hi, I have a problem with the servletcontext. At server startup I store some mail parameters in the servletcontext. I retrieve these parameters from several servlets. Except in this one (see code below) I can't retrieve the parameters. Yet, I do exactly the same as in all the others servlets...

Hi, I have a small script which just fades in random text and fades it out again. To do this I had to use the setTimeout funtion. I work with a frameset in which one frame holds the javescript with the fading, another one holds an input form. The problem I have is that my cursor in my first...

Hi, I have a small script which just fades in random text and fades it out again. To do this I had to use the setTimeout funtion. I work with a frameset in which one frame holds the javescript with the fading, another one holds an input form. The problem I have is that my cursor in my first...