Search results for query: *

Dear all, I use odbc_connect() to connect to a MS SQL database. Of course with that function I have to provide the password as a parameter. Now our company policy says, I should not have the password in code anymore. Can anybody help? I have a windows server 2012 R2 with IIS and I already have...

Dear all, I use PHP 5.3 on an IIS. I had to copy my code from another server (which had PHP 4) to this one and I don't want to change the code as I have not enough time for it. So I'd like to hide all warning as I turned on register_globals in php.ini. PHP shows me the following warning: PHP...

Dear all, I use PHP 5.3.1 on an IIS Server. I'd like to use $GLOABALS["PATH_INFO"] which still works in PHP 5 although it is deprecated. In the php-ini file it turned on the register_globals option. So from PHP's point of view it should work. Nevertheless I get the error "Undefined index...

Hello! I have a Stored Process which I display in the SAS portal. When I display two or more proc reports or graphics there is always a horizontal line displayed between two of them. When I view the created HTML code there is <hr size="3">. How can I erase these horizontal lines? Best regards Eva

Hello! With a vbar I habe subgroup for the respond axis. Unfortunately by default the subgroup is ordered alphabetically. Yet I#d like to order it my way. How can I do this? My data is date phase price 2008/12/01 b 12 2008/12/01 c 56 2008/12/01 a 33 2008/12/02 b 34...

Hello! I have a report with ods destination pdf. Unfortunately it is too wide and so the page splits into two. So I'd like to squeeze everything onto one page. Does anybody know how to do this? Best regards Eva

Hi! I'd like to count how often a stored process has been accessed by the visitors on my application on the sas portal. Does anybody know how? I thought of writing a line in a file anytime somebody accesses the stored process. But because I have many visitors this would be a concurrent access...

Hello! I have a question on legends. I'd like to position my legend top right outside. Unfortunately it is positioned top center outside... Here's my code: goptions device=javaimg gunit=pt colors(red green yellow) ftext=arial xpixels=400 ypixels=400; legend1 position=(top right outside)...

Hello! I have a macro variable to which I'd like to assign a format: proc format; value $fmedium 'P' = 'Paper' 'F' = 'Fax' 'E' = 'Email'; run; The macro variable has for example the value P and should be displayed as Paper. Can anybody help? Best...

Hello! I have a proc report like this: PROC REPORT DATA=work.mydata; COLUMN my_numeric_field my_charcter_field, (field1 field2); define my_numeric_field / group ' '; define my_charcter_field / across ' '; define field1 / 'Caption1'; define field2 / 'Caption2'...

Hello! I'd like to create a pop up which has some text and two Buttons: "Cancel" (back to page from where the pop up was issued) and "Ok" (show next page). Unfortunately alert() has only the "Ok" Button and prompt() has an input field which I don't need. Best wishes Eva

Hello! How can I fix the first and last row of a table and make the rest inbetween scrollable. I need this as I have a very long table and don't want to use frames. Best regards, Eva

Hi there! I have a table with background color. It looks alright on screen. But the color isn't printed. (Yes I have a color printer ;-) ) I tried it with and without css. Doesn't make a difference. Here's the code with css: <table> <tr> <td style="background-color:#00FFFF">Mytext</td> </tr>...

Hello, I build a join like this: First I join a hold file with a DB2 table, then I Join the same Hold file with another Hold File: JOIN FIELD1 IN MYNAMES TO FIELD2 IN DB2TABLE AS J1 END JOIN FIELD3 IN MYNAMES TO ALL FIELD3 IN MYHOLD AS J2 END (FIELD1 and FIELD2, FIELD3 and FIELD4 have the...

Hello, I'd like to color some fields in my report. The cells of one column (MYFIELD in the example below) should be green, yellow, red depening on the value they contain: value <= 5 : green value > 5.01 and < 7.5 : yellow value >= 7.5 : red I did the red and green like this...

Hello! I'd like to join 4 tables with the following structure: |-------------------| |-------------------| | table1 | | table2 | |-------------------| |-------------------| | | |...

Hello! Due to security standards I'm no longer allowed to write the username and password for an odbc connection down in a php file (odbc_connect($dsn, "myUsername", "myPassword");). I was told that I should use either of the following options: 1.) the odbc dsn connection on the server (which...

Hello! I create a hold file from which I get a single row of data. I then use the -READ command to put the field values into one variable each. Unfortunately the field values are cut off in the variables. Can anybody help me? Here's the code: 1.) generate the hold file: TABLE FILE NAMES...

Hello! Is it possible to block a IE6 window for other applications than for the one which is currently active? The reason I ask this: We have a browser based application (we only use IE6 in our company no other browser). The user may work with it several hours during the day. During his work...

Hello! the function odbc_connect() needs user and password. Yet I'd like to connect to the database with the logged-in user but don't know how. Is it possible to connect with the username only? In the database I'd then legitimate the indvidual users. (I know the username, but not password of...