Insert string problem. Please help me [Archive]

View Full Version : Insert string problem. Please help me

opnsesame

05-26-2003, 06:41 AM

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?

bruce

05-26-2003, 09:41 AM

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.

[b]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">

bruce

05-27-2003, 01:10 AM

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

Check out this link for resolution

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

[b]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.

[b]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.

[b]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.

[b]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">
</blockquote id="quote">
</blockquote id="quote">
</blockquote id="quote">

opnsesame

05-27-2003, 08:16 AM

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.

[b]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.

[b]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">
</blockquote id="quote">

bruce

05-27-2003, 09:52 AM

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.

[b]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.

[b]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.

[b]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">
</blockquote id="quote">
</blockquote id="quote">

opnsesame

05-28-2003, 07:49 AM

Hi Bruce,
Thanks a lot , you gave me a great help . By the way , do you work for discountasp.net?

bruce

05-28-2003, 09:35 AM

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.

[b]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">