I use maix command to sent mails.
i can sent only plain text mails.
Unable to sent mails in html format.
while sending mails in html format, the received mail has the html code only. (17 Replies)
Hi all
I have a shell script that uses a stored proc to generate output from some tables and send the same in an e-mail using mailx command. Now I need to convert the output to excel format and send e-mail. How can I achieve this. Please help me in this regard, as it's very urgent and I have been... (5 Replies)
Hi,
I am using mailx command to send a mail with attachment. It's working fine, but with attachment I am getting one extra attachment like (ATT00131.txt). I have tried to use unix2dos command also. But still I am getting the extra attachment.
I am using the following code:
subject="temp... (5 Replies)
Hi All,
Can you please help me in solving this. I am facing some problem sending mails.
If I use like this, I am able to send mail the mail
echo "This is an automated e-mail; please do not reply." | mailx -s "Good Morning ." 'abc@xys.com'
But if I use like this, then I am unable to send... (1 Reply)
Hi
The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment .
cat Employee.sql
SET VERIFY OFF
SET PAGESIZE 200
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD... (0 Replies)
Hi,
i need to send emails to the mail ids i receive using the sql query .
SELECT L.ALARM_DEF,L.CRITERIA,L.DISTANCE_METRE,L.EMAIL,L.LAC_ID,L.LAST_CHECK,L.RANGE,
L.RESOURCE_MSISDN,LM.ADDRESS,LM.NAME FROM LANDMARK_ALARM_CONF l, LANDMARK lm
WHERE L.LANDMARK_ID=LM.LANDMARK_ID AND... (0 Replies)
Hi,
Our requirement is to send an attachment and content in a single mail. I am using the below command to send attachement.
---------------------
(uuencode $exp_file $exp_file) |mailx -s "$email_subject" $EmailRecipients
--------------------
I m not able to send any message in the... (4 Replies)
Hi,
I am using solaris 5.9 OS and I am facing an issues with mailx.
My SMTP port is configured to listen 6190 and not the default one which is 25. I can send mail to my inbox when i do it manually through the following steps
root@<dbname> # telnet 15.12.88.10 6190
Trying 15.12.88.10...... (0 Replies)
Hi All,
I am using mailx to send the mail. Due to some changes in the requirement, I need to send the mail to CC only (an Email id in CC), with no email ID in "TO" field. Can we do that? bcz I used -c flag only and got the message:":The flags you gave make no sense since you're not sending... (2 Replies)
Hi All,
I am trying to send a mail from linux server but could'nt able to send the mail.
I tried the below syntax's so far but no luck.
mail -s “Hello world” abc@xyz.com < /usr/g/txt.log
cat "txt.log" | mailx -s "Hello world" abc@xyz.com
mailx -s “Hello world” abc@xyz.com <... (2 Replies)
Discussion started by: scriptscript
2 Replies
LEARN ABOUT PHP
fbsql_query
FBSQL_QUERY(3) 1 FBSQL_QUERY(3)fbsql_query - Send a FrontBase querySYNOPSIS
resource fbsql_query (string $query, [resource $link_identifier], [int $batch_size])
DESCRIPTION
Sends a $query to the currently active database on the server.
If the query succeeds, you can call fbsql_num_rows(3) to find out how many rows were returned for a SELECT statement or
fbsql_affected_rows(3) to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.
PARAMETERS
o $query
- The SQL query to be executed.
Note
The query string shall always end with a semicolon.
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
o $batch_size
-
RETURN VALUES fbsql_query(3) returns TRUE (non-zero) or FALSE to indicate whether or not the query succeeded. A return value of TRUE means that the query
was legal and could be executed by the server. It does not indicate anything about the number of rows affected or returned. It is perfectly
possible for a query to succeed but affect no rows or return no rows.
For SELECT statements, fbsql_query(3) returns a new result identifier that you can pass to fbsql_result(3).
fbsql_query(3) will also fail and return FALSE if you don't have permission to access the table(s) referenced by the query.
EXAMPLES
The following query is syntactically invalid, so fbsql_query(3) fails and returns FALSE:
Example #1
fbsql_query(3) example
<?php
$result = fbsql_query("SELECT * WHERE 1=1")
or die ("Invalid query");
?>
The following query is semantically invalid if my_col is not a column in the table my_tbl, so fbsql_query(3) fails and returns FALSE:
Example #2
fbsql_query(3) example
<?php
$result = fbsql_query ("SELECT my_col FROM my_tbl;")
or die ("Invalid query");
?>
SEE ALSO fbsql_affected_rows(3), fbsql_db_query(3), fbsql_free_result(3), fbsql_result(3), fbsql_select_db(3), fbsql_connect(3).
PHP Documentation Group FBSQL_QUERY(3)