User Profile

Collapse

Profile Sidebar

Collapse
chelvan
chelvan
Last Activity: Apr 8 '19, 03:33 AM
Joined: Aug 25 '08
Location: Colombo 06, Srilanka
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • chelvan
    started a topic Need help with Access Query syntax
    in Access

    Need help with Access Query syntax

    hi all!
    i have the following query to run on ms access2000. once i run this query the data will be doubled. but i need it once. my problem is on where condition. there i have to check two different fields on table arjou (dtoacc, ctoacc) with glcode of the table glcode. any other ways?

    Code:
    SELECT   [DATE]
       , REFNO AS [REF NO]
       , orderno AS [ORDER NO]
       , fileno AS [FILE NO]
       , AMOUNT
    ...
    See more | Go to post
    Last edited by NeoPa; Dec 14 '11, 01:30 PM. Reason: Added mandatory [CODE] tags for you
    • chelvan
      replied to Sql Update Query
      in SQL Server
      i have done that.....
      by change to
      "update rptLastPurchase Rate set rptLastPurchase Rate.RATE=STOCK .RATE from rptLastPurchase Rate inner join STOCK on rptLastPurchase Rate.[id]=stock.[id]"
      See more | Go to post

        Leave a comment:

      • chelvan
        started a topic Sql Update Query
        in SQL Server

        Sql Update Query

        i have wrote the following sql, it works on ms access but not in sql server. say syntax error near inner. i could nt find out the error any help?

        UPDATE rptLastPurchase Rate INNER JOIN STOCK ON rptLastPurchase Rate.ID = STOCK.ID SET rptLastPurchase Rate.Rate = [stock].[rate]
        See more | Go to post
        • chelvan
          started a topic Find out the Html Tag?
          in Javascript

          Find out the Html Tag?

          my javascript variable read the following contents. now i want to find out the tags, with the name of "cv".

          is it possible?

          Code:
          <p><img src="E:11Che05L9V85AnImgSX-MASIMGchristmas_bells.gif" alt="11" width="313" height="313" /><input id="cv" name="cv" type="text" value="E:11Che05L9V85AnImgSX-MASIMGchristmas_bells.gif" /></p>
          ...
          See more | Go to post
          • chelvan
            replied to ession.bug_compat_42 error
            in PHP
            hi

            thanks. for your information. i try

            chelvaN
            See more | Go to post

              Leave a comment:

            • chelvan
              started a topic ession.bug_compat_42 error
              in PHP

              ession.bug_compat_42 error

              hi forums

              thanks for your valuable support.

              today i'm having the following message, after uploading my site, i;m doing registering my self. on finishing the following displays. .

              site url:- Get Go GLobal

              Warning: Unknown: Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a...
              See more | Go to post
              • chelvan
                replied to Flash Menu
                in Flash
                sorry for my long delay. some unhealthy.

                ok. i want to create menu bar by using Menu Bar component.

                thanks.
                chel-1
                See more | Go to post

                  Leave a comment:

                • chelvan
                  replied to counting rows
                  in PHP
                  define an array. its length limit by your database values (distinct). then increase the specific array element.then finally you able to get the result.

                  regards
                  chel-1
                  See more | Go to post

                    Leave a comment:

                  • chelvan
                    replied to ok... password protecting just one page
                    in PHP
                    hi
                    change your if condition. that means assign your posted values to the variable.

                    like this
                    Code:
                    if($variablename!=$_Post[variablename]){
//login form
}
else{
//password protected content

}
                    and remove 25th and 29th lines.

                    hope it will help you.

                    cheers
                    chel-1
                    See more | Go to post

                      Leave a comment:

                    • chelvan
                      replied to Passing Variable In Php pages
                      in PHP
                      so sorry 4 my late...!
                      then finally i go with session,


                      thanks to you all
                      chel-1
                      See more | Go to post

                        Leave a comment:

                      • chelvan
                        replied to page need refresh
                        in PHP
                        ok.
                        here i post one of my page.

                        myFriends.php

                        Code:
                        <?php
session_start();
$user_nom=$_SESSION['username'];
$refno=$_SESSION['refno'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
                        ...
                        See more | Go to post

                          Leave a comment:

                        • chelvan
                          started a topic page need refresh
                          in PHP

                          page need refresh

                          hi forums
                          on my site all the pages ask refresh to load. its happened randomly. that means some time the page display its body some time its not.

                          why?
                          any one know the reason?


                          thanks for u all

                          chel-1
                          See more | Go to post
                          • chelvan
                            replied to Query Error
                            in PHP
                            hi all

                            thanks all of your response.

                            please forgive me, i made a mad mistake on query on my where clause i checked different fields. now i correct that.


                            so much sorry. before post i tried to find nearly 2 days. but i couldn't. then finally i did.


                            any how thanks a lot.



                            regards
                            chelvan
                            See more | Go to post

                              Leave a comment:

                            • chelvan
                              started a topic Query Error
                              in PHP

                              Query Error

                              hi forums !
                              its me again.

                              here my code, that i struggles...

                              Code:
                                       $options=$_POST['options'];
		 $hf=$_POST['hf'];
		 $arr= count($options);
         if ($options){
            for ($i=0;$i<count($options);$i++){
			 $pos[$i]= strlen($options[$i]);
		        $name[$i]=substr($options[$i],0,$pos[$i]);
			echo  $name[$i];

		$sql_user=mysql_query("SELECT*FROM
                              ...
                              See more | Go to post
                              Last edited by chelvan; Oct 30 '08, 05:29 AM. Reason: insert missed statements
                              • chelvan
                                replied to Failed to insert data on mysql
                                in PHP
                                hi
                                i'm afraid on your if condition.

                                here you wish to check that the query was execute or not.

                                if so try like this
                                before insert count number of rows on your table
                                do the query
                                count number of rows again on your table

                                then check both counter value


                                regards
                                chel-1
                                See more | Go to post

                                  Leave a comment:

                                • chelvan
                                  replied to Error in Php Array
                                  in PHP
                                  hi
                                  just change your print statement like this, on out of the loop

                                  Code:
                                  print_r($pidarray);
                                  hope this time it will work

                                  chel-1
                                  See more | Go to post

                                    Leave a comment:

                                  • chelvan
                                    replied to Error in Php Array
                                    in PHP
                                    hi
                                    do u wish to print the numbers from 1 - 9. if so move your print statement in to your loop.

                                    hope that will work.

                                    regards
                                    chel-1
                                    See more | Go to post

                                      Leave a comment:

                                    • chelvan
                                      replied to upload image
                                      in PHP
                                      sorry! Atli

                                      regards
                                      chel-1...
                                      See more | Go to post

                                        Leave a comment:

                                      • chelvan
                                        replied to find error
                                        in PHP
                                        hi
                                        you missed the $sign on your printing array index.
                                        Code:
                                        print_r($pidarray[$j]);
                                        now you will get the result.

                                        regards
                                        chel-1
                                        See more | Go to post

                                          Leave a comment:

                                        • chelvan
                                          replied to Dividing up search results
                                          in PHP
                                          hi

                                          i think you have to set those variables, where you initialize the hyper links for previous , next , nums.

                                          so...
                                          it should like this
                                          Code:
                                          $prev = " <a href=\"$self?page=$page&somename=$variable\">[Prev]</a>
                                          then you need to get the somename using $_get['somename'] initialize to your where clause variable.


                                          try it.

                                          regards...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...