04-06-2005
Question about perderabo's MIMETOOL script
Perderabo,
I copied the mimetool script and am running it on an HP-UX release 11i, and in most cases it works like a charm. But I ran into the following issue;
I extracted data from an Oracle database and formatted the results as a *.csv file so that the user can view it as an excel spreadsheet. It is a relatively large file, ~12000 records. After sending it via mimetool, the file has a control character embedded roughly every 687 records. The character will appear somewhere in the data, not nescessarily at the end of the record. The character looks like the trademark charcter (™)when viewed in excel. If I ftp the file to my pc rather than emailing it, there is no issue.
If you have any ideas on this, I would appreciate it.
Thanks,
Carl.
6 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
This is a follow-up re: this thread
As I mentioned, this script works very nicely, thanks again.
However, the ASCII data of the 'attached file' also shows below the body of the email message. Do you know of a way to 'disable' the attached text from showing? Although the file is attached,... (3 Replies)
Discussion started by: jwperry
3 Replies
2. Shell Programming and Scripting
Hi
I got this part of the script from the mimetool by Perderabo.
I have difficulty in decyphering the syntax specially lines 4,5 & 9.
Also the test condition in line 3.
Could someone help me on this please.
--------------------------------------
pwentry=$(grep "^$(logname):" /etc/paswd)... (2 Replies)
Discussion started by: chaandana
2 Replies
3. UNIX for Dummies Questions & Answers
Hi
I tried this date script https://www.unix.com/showthread.php?p=16559#post16559 but I am probably doing something wrong.
If i type:
datecalc -a 2006 05 01 + 5
I get following error message:
datecalc: Syntax error at line 207
If i look at line 207 i dont get it! But thats not surprising. ... (2 Replies)
Discussion started by: swissman24
2 Replies
4. Post Here to Contact Site Administrators and Moderators
Sorry Perderabo, really was only asking advice on where best to post, and if I should post.
Didn't intend for that missive to be posted. (0 Replies)
Discussion started by: keith.m
0 Replies
5. What is on Your Mind?
In an web based turn-based-strategy game I play (which until I am sure of the rules of this section of the forum, I'll not post a link to but is tiny and involves wars, warz even ;)), there is a player called Perderabo who has become rather powerful by the looks of things... Could this be one and... (2 Replies)
Discussion started by: Smiling Dragon
2 Replies
6. Shell Programming and Scripting
Hi,
First of all, thanks for all the awesome suggestions on this forum. This helps all the UNIX enthusiast like me.
Now, I had a similar requirement as mentioned in a very old post here:
Question about Perderabo's "Days Elapsed Between Two Dates"
But I am struggling what to change in the... (5 Replies)
Discussion started by: CleoBos
5 Replies
LEARN ABOUT PHP
oci_set_module_name
OCI_SET_MODULE_NAME(3) OCI_SET_MODULE_NAME(3)
oci_set_module_name - Sets the module name
SYNOPSIS
bool oci_set_module_name (resource $connection, string $module_name)
DESCRIPTION
Sets the module name for Oracle tracing.
The module name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
is executed.
The name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitoring such
as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $module_name
- User chosen string up to 48 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
EXAMPLES
Example #1
Setting the module name
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the module
oci_set_module_name($c, 'Home Page');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the
// modules in use:
sqlplus system/welcome
SQL> select module from v$session;
SEE ALSO
oci_set_action(3), oci_set_client_info(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_MODULE_NAME(3)