Insert string problem. Please help me

Discussion in 'Databases' started by opnsesame, May 26, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Why i cannot insert strings like <a>, </a>,......... etc. any string combination with a '<' and a '>' cannot be inserted into the database.
    Are you guys using some screen methords to restric these kind of strings in discountaps.net database,or am i wrong?
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    can you post the code?

    In addition,

    - what type of database are you trying to insert into?
    - What is the database field that you are trying to insert into.
    - are you seeing any error message? like invalid query or somehting.



    quote:Originally posted by opnsesame

    Why i cannot insert strings like <a>, </a>,......... etc. any string combination with a '<' and a '>' cannot be inserted into the database.
    Are you guys using some screen methords to restric these kind of strings in discountaps.net database,or am i wrong?
    </blockquote id="quote"></font id="quote">
     
  3. Bruce

    Bruce DiscountASP.NET Staff

    I think I found the problem that's causing the error.

    Check out this link for resolution

    http://www.asp.net/faq/RequestValidation.aspx


    quote:Originally posted by bruce

    What you are describing is very strange...

    Do you mind posting the code snippet that create the problem?

    I can do some testing from couple different servers.


    quote:Originally posted by opnsesame

    Well, I use the same code on my local machine it works perfact, i use same code on my local machine but database point to www.discountasp.net / sqlserver2000,it also works perfact , but when i upload my code onto www.discountasp.net and database point to www.discountasp.net / sqlserver2000, those code can only insert stings without '<' and '>' conbinations.
    any ideal?

    Thanks a lot.

    quote:Originally posted by bruce

    can you post the code?

    In addition,

    - what type of database are you trying to insert into?
    - What is the database field that you are trying to insert into.
    - are you seeing any error message? like invalid query or somehting.



    quote:Originally posted by opnsesame

    Why i cannot insert strings like <a>, </a>,......... etc. any string combination with a '<' and a '>' cannot be inserted into the database.
    Are you guys using some screen methords to restric these kind of strings in discountaps.net database,or am i wrong?
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
     
  4. Well, I use the same code on my local machine it works perfact, i use same code on my local machine but database point to www.discountasp.net / sqlserver2000,it also works perfact , but when i upload my code onto www.discountasp.net and database point to www.discountasp.net / sqlserver2000, those code can only insert stings without '<' and '>' conbinations.
    any ideal?

    Thanks a lot.

    quote:Originally posted by bruce

    can you post the code?

    In addition,

    - what type of database are you trying to insert into?
    - What is the database field that you are trying to insert into.
    - are you seeing any error message? like invalid query or somehting.



    quote:Originally posted by opnsesame

    Why i cannot insert strings like <a>, </a>,......... etc. any string combination with a '<' and a '>' cannot be inserted into the database.
    Are you guys using some screen methords to restric these kind of strings in discountaps.net database,or am i wrong?
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
     
  5. Bruce

    Bruce DiscountASP.NET Staff

    What you are describing is very strange...

    Do you mind posting the code snippet that create the problem?

    I can do some testing from couple different servers.


    quote:Originally posted by opnsesame

    Well, I use the same code on my local machine it works perfact, i use same code on my local machine but database point to www.discountasp.net / sqlserver2000,it also works perfact , but when i upload my code onto www.discountasp.net and database point to www.discountasp.net / sqlserver2000, those code can only insert stings without '<' and '>' conbinations.
    any ideal?

    Thanks a lot.

    quote:Originally posted by bruce

    can you post the code?

    In addition,

    - what type of database are you trying to insert into?
    - What is the database field that you are trying to insert into.
    - are you seeing any error message? like invalid query or somehting.



    quote:Originally posted by opnsesame

    Why i cannot insert strings like <a>, </a>,......... etc. any string combination with a '<' and a '>' cannot be inserted into the database.
    Are you guys using some screen methords to restric these kind of strings in discountaps.net database,or am i wrong?
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
     
  6. Hi Bruce,
    Thanks a lot , you gave me a great help . By the way , do you work for discountasp.net?
     
  7. Bruce

    Bruce DiscountASP.NET Staff

    MS sometimes does weird things... They keep saying that Framework 1.1 is backward compatible w/ Framework 1.0. The nasty thing is that Windows 2003 doesn't have Framework 1.0 installed.

    Yes. I work at discountasp. Hope you like our service.

    quote:Originally posted by opnsesame

    Hi Bruce,
    Thanks a lot , you gave me a great help . By the way , do you work for discountasp.net?
    </blockquote id="quote"></font id="quote">
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page