User Profile

Collapse

Profile Sidebar

Collapse
hitendrap
hitendrap
Last Activity: Jan 2 '20, 01:26 PM
Joined: Sep 24 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • hitendrap
    replied to php mail() not working
    in PHP
    Not necessary as far as the SMTP server allows without authentication.

    and headers are optional in mail() function.

    avoid writing words like test, example in mails even the addresses,
    coz' some popular Mailing servers like Gmail, Yahoo may put your test mail in Spam OR even block the mail.
    See more | Go to post

    Leave a comment:


  • hitendrap
    replied to Wildcards in DB2 SQL
    in DB2
    Ofcourse DB2 supports wildcard chars,

    use % with LIKE clause in case to CHAR datatype

    for eg. SELECT * FROM your_table WHERE your_column LIKE '%1234%'

    this will search matches for substring 1234 anywhere in the string & you will get result as desired:
    1234
    1234AB
    1234ABCD
    AB1234CD
    See more | Go to post

    Leave a comment:


  • hitendrap
    replied to Identifying through many columns
    in DB2
    What I've understood is that
    you have displayed the values in column "CONCATENAT E" by actually contatenating the character values in other columns right ?
    & suppose the value of row1 & column 7 changes from A to B then the value will automatically change to B in the "CONCATENAT E" column

    Still may answer is the same, CREATE a VIEW.

    Plz. read how to create a view & more important...
    See more | Go to post

    Leave a comment:


  • hitendrap
    replied to Identifying through many columns
    in DB2
    The solution is very simple, you must create a VIEW for that table !!!,
    whatever query you are firing to get the above result (shown in screenshot), just type that in CREATE VIEW statement !
    See more | Go to post

    Leave a comment:


  • hitendrap
    replied to php mail() not working
    in PHP
    Remember that DNS server is not a mailing server (you need to get the IP of mail server from ur network admin, the DNS server contains the MX record for the mail server)

    Make sure you also ask for the port number once you get thr mail serevr IP and set the configuration in PHP.INI

    while your mailing program is being executed, just watch the freesmtpserver window, it shows the recipients e-mail address with hourglass icon...
    See more | Go to post

    Leave a comment:


  • hitendrap
    replied to trim function
    Code:
    function trimStr(value)
    {
    	return value.replace(/^\s+|\s+$/g, '')
    }
    See more | Go to post
    Last edited by Dormilich; Feb 5 '10, 01:31 PM. Reason: Please use [code] tags when posting code

    Leave a comment:


  • hitendrap
    replied to php mail() not working
    in PHP
    wasco, you need to set up a real mailing server in order to send a real mail,
    read more about mail() function on php.net ,
    if you are on windows, try to use free smtp server http://www.softstack.com/freesmtp.html

    if you are lucky mail will be sent !!!

    also read abt setting up Gmail as SMTP server
    See more | Go to post

    Leave a comment:


  • hitendrap
    replied to stop listing of directory using url
    in PHP
    For Linux if the .htaccess doesnt work'

    then just put that code in httpd.conf file normally found @ /wwwroot/conf the Apache Installation directory

    Or edit the directory tags folln' code worked for me applies to all directories
    Code:
    <Directory />
        Options FollowSymLinks
        AllowOverride None
        Order deny,allow
        Deny from all
    </Directory>

    ...
    See more | Go to post

    Leave a comment:


  • FOR : error code 10065

    If u are getting: SQL30081N Protocol specific error code(s): "10065", "*", "*". SQLSTATE=08001

    If you are using Linux server , turn off your firewall service & check if you can connect to database remotely through

    client
    to stop firewall type this command on bash : $ etc/init.d/iptables stop

    If now you can connect remotely...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...