471,896 Members | 1,175 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,896 software developers and data experts.

Querystring Values spaces causing errors

I am trying to update my table with a value passed though the
request.querystring method but as you can see from the sql statement below
it is causing errors.

In this case the name of the department as displayed is "Arts and
Entertainment" but it is giving me something strange when I try to use the
variable

update empprofile set department ='Arts%20%26%20Entertainment' where
employeenumber =219104
Microsoft JET Database Engine error '80004005'

You cannot add or change a record because a related record is required in
table 'Departments'.

/admin/updatedept.asp, line 32

Any solutions

Regards

Jas


Jul 19 '05 #1
4 2403

Replace (request.querystring ,"%20", " ")
"JP SIngh" <no**@none.com> schreef in bericht
news:%2****************@TK2MSFTNGP12.phx.gbl...
I am trying to update my table with a value passed though the
request.querystring method but as you can see from the sql statement below
it is causing errors.

In this case the name of the department as displayed is "Arts and
Entertainment" but it is giving me something strange when I try to use the variable

update empprofile set department ='Arts%20%26%20Entertainment' where
employeenumber =219104
Microsoft JET Database Engine error '80004005'

You cannot add or change a record because a related record is required in
table 'Departments'.

/admin/updatedept.asp, line 32

Any solutions

Regards

Jas

Jul 19 '05 #2
If you use post instead of get, you can avoid this error.

If you use id numbers instead of long, un-URL-friendly descriptions to
identify rows, you can avoid this error.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"JP SIngh" <no**@none.com> wrote in message
news:#M**************@TK2MSFTNGP12.phx.gbl...
I am trying to update my table with a value passed though the
request.querystring method but as you can see from the sql statement below
it is causing errors.

In this case the name of the department as displayed is "Arts and
Entertainment" but it is giving me something strange when I try to use the variable

update empprofile set department ='Arts%20%26%20Entertainment' where
employeenumber =219104
Microsoft JET Database Engine error '80004005'

You cannot add or change a record because a related record is required in
table 'Departments'.

/admin/updatedept.asp, line 32

Any solutions

Regards

Jas

Jul 19 '05 #3
Classic ASP Design Tips - QueryString
http://www.bullschmidt.com/devtip-querystring.asp

Example URL with a querystring:
http://www.mysite.com/mydir/mypg.asp...=hey&myvar2=ho

Because a variable might contain some odd characters like spaces, it's
usually a good idea to use Server.URLEncode when creating a querystring
from a variable:
<a href="http://www.mysite.com/mypage?id=<%=
Server.URLEncode(objRS("MyIDFldFromDB")) %>">objRS("MyIDFldFromDB")</a>

And in the page that is opened you can use Request.QueryString("id") to
get the value of id.

Best regards,
J. Paul Schmidt, Classic ASP Web Designer
http://www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Demo, ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #4
The error message is indicating that the database is designed in such a
way that a matching record must exist in the 'Departments' table.
Basically, you're trying to add a record to a table that has a specified
relationship to the 'Departments' table. The problem is not neccessarily
related to the querystring values, however it might be.

Double check that there is a record in the 'Departments' table for 'Arts
& Entertainment'. If a record doest exist, then the problem has to do
with the fact that the special characters are encoded.

'Arts%20%26%20Entertainment' is 'Arts and Entertainment' as far as HTML
is concerned. However, the same statement is
'Arts%20%26%20Entertainment' when it comes to the database. The DB is
seeing the string literally as it appears. So what you need to do is to
convert the encoded characters back to their text versions. I've never
dealt with this particular problem. Server.HTMLEncode() can be used to
encoded the characters initially, however I'm not familar with a means
to unencode them.

You shouldn't have to encode the string to begin with though.
?department=Arts & Entertainment
should work without any problems.*

David H
*In the event that this doesn't work and causes catastrophic results
including but not limited to the destruction of mankind, you're on your
own.

Secon

JP SIngh wrote:
I am trying to update my table with a value passed though the
request.querystring method but as you can see from the sql statement below
it is causing errors.

In this case the name of the department as displayed is "Arts and
Entertainment" but it is giving me something strange when I try to use the
variable

update empprofile set department ='Arts%20%26%20Entertainment' where
employeenumber =219104
Microsoft JET Database Engine error '80004005'

You cannot add or change a record because a related record is required in
table 'Departments'.

/admin/updatedept.asp, line 32

Any solutions

Regards

Jas


Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Raterus | last post: by
6 posts views Thread by John Grandy | last post: by
3 posts views Thread by Dariusz Tomon | last post: by
6 posts views Thread by duncan.welch | last post: by
4 posts views Thread by | last post: by
2 posts views Thread by Arch Stanton | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.