User Profile

Collapse

Profile Sidebar

Collapse
asivakrupa
asivakrupa
Last Activity: Apr 22 '09, 09:50 AM
Joined: Apr 8 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • asivakrupa
    replied to Problem inserting ' in DB using PHP
    in PHP
    Hi,

    I am not able to understand the backtick character.. Can you please explain me the same.?

    Thanks in advance.
    See more | Go to post

      Leave a comment:

    • asivakrupa
      replied to Problem inserting ' in DB using PHP
      in PHP
      Hi,

      I tried using " " for the fields. If you execute the following in SQL Query analyzer it works!!!

      Code:
      select "competitor_name" from Competitor
      But in PHP you are going to include the above query as a string. So here the problem arises.

      Code:
      $query="select "competitor_name" from Competitor";
      In the above code,...
      See more | Go to post

        Leave a comment:

      • asivakrupa
        replied to Problem inserting ' in DB using PHP
        in PHP
        What do you mean by a back tick? Can you please explain me.?

        Thanks in advance.
        See more | Go to post

          Leave a comment:

        • asivakrupa
          replied to Problem inserting ' in DB using PHP
          in PHP
          hi,

          Can you post any samples which use that back slashes for my reference?

          Thanks in advance.
          See more | Go to post

            Leave a comment:

          • asivakrupa
            replied to Problem inserting ' in DB using PHP
            in PHP
            Actually the field is a comments field where the user will give his input. It can also contain the single quote( ' ) which is the apostrophe character.

            So you mean to say I should use back slash.. Ok...I will try out..
            See more | Go to post

              Leave a comment:

            • asivakrupa
              started a topic Problem inserting ' in DB using PHP
              in PHP

              Problem inserting ' in DB using PHP

              Hi,

              I am creating a tool with PHP as front end and SQL Server as back end. I have some values to be inserted into the DB which contains the character ( ' ) i.e single quote.

              I had errors when i tried to insert such values into the DB. So I used the replace() fn to replace a single single quote ( ' ) by two single quotes ( '' ). I was successful in it also. Values got inserted successfully.

              But the problem...
              See more | Go to post
              • asivakrupa
                replied to Problem inserting ' and ; in DB
                in SQL Server
                Hi,

                The value I am trying to retrieve is a'b'c. I used the replace() fn by replacing ( ' ) with ( '' ) at the time of insertion into the DB.

                This is the error that i get when i try to retrieve the value from the DB. The query is as follows:
                select name from Table1; (the value of name here is a'b'c)
                Incorrect syntax near '='. (severity 15)

                Please help me out.
                Thanks in advance.
                See more | Go to post

                  Leave a comment:

                • asivakrupa
                  replied to Problem inserting ' and ; in DB
                  in SQL Server
                  Yeah i found out this jus nw. I am able to insert the value but while retrieving the same from the DB i get lot of errors. Do u have any idea abt ths?
                  See more | Go to post

                    Leave a comment:

                  • asivakrupa
                    replied to Problem inserting ' and ; in DB
                    in SQL Server
                    I don understand what you have given. Please explain me more on this issue.
                    See more | Go to post

                      Leave a comment:

                    • asivakrupa
                      started a topic Problem inserting ' and ; in DB
                      in SQL Server

                      Problem inserting ' and ; in DB

                      Hi,

                      I am inserting a comments value i.e a field which contains comments into a DB which is provided by the user as input.

                      If the value for the field contains quotes (both " and ') as well as semi colon (;), the results in an error.

                      Please help me include these special characters into the DB.

                      Thanks in advance.
                      See more | Go to post
                      • asivakrupa
                        started a topic Validation for multiple select list box
                        in Javascript

                        Validation for multiple select list box

                        Hi,
                        I am using a multiple select list box.

                        I use an array to retrieve the values that are selected by the user.

                        Code:
                        <select name="competitor[]">
                        When I try to validate the list box if the user does not select anything, I get errors. The error deals with the array declared.

                        I am using PHP and the validation is done in Javascript. Please help out.
                        ...
                        See more | Go to post
                        • asivakrupa
                          replied to Number Validation
                          in Javascript
                          That worked out.
                          Yeah thanks.
                          See more | Go to post

                            Leave a comment:

                          • asivakrupa
                            started a topic Number Validation
                            in Javascript

                            Number Validation

                            Hi,

                            I need to check whether the user has entered a numeric value or not in a text box using Javascript. What function can be used for this?

                            Thanks in advance.

                            Regards,
                            Sivakrupa
                            See more | Go to post
                            • asivakrupa
                              started a topic Problem with query
                              in SQL Server

                              Problem with query

                              Hi,

                              I need a query in SQL Sever which will select the records based on the date of creation.The query is,

                              List the opportunity name where the date of creation is before 3 weeks.

                              I do not know to create a SQL query for this. Pls do help me out with this.
                              Thanks in advance.
                              Sivakrupa Arulmani.
                              See more | Go to post
                              No activity results to display
                              Show More
                              Working...