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'. Code:
I need to pass a lot of QS variables to another page. Problem is, the form being submitted is dynamic, so I don't always know how many values I am going to be passing.
At work, we use Site Server Commerce Edition which has a nice function to pass all the QS variables ( mscsPage.URLShopperArgs() ), but it seems like this only works in the Commerce Sites because the object needed to make this function work is only available in SiteServer web sites.Is there a way to grab all the values from the QueryString and place them into a link or form? ....
to change the colors of a forum I am using request.querystring("cellcolor"). That works fine for my default.asp. Now I click on a topic and it links to topic.asp where the values of the query string are gone.
Which approach would you recommend? How can I store the values? The general idea is that I have got 5 main-navigation-links which point to 5 different forums, each with separate colors. So the query string can be hardcode in the HREF, but should remain if you click further in each forum.
How we can hide values of variables in our querystring those are readable in the address bar? is there any way we can encrypt the url and when it is required we can de-crypt it also like yahoo do?
how i could put multiple values on to a Query String and get them on the next ASP page. Currently on wy website, i know how to get one, but i am not sure how i am able to get more than one assigned to a specific variable.
How do I get all walues if my querystring is empty?
If I have a table with let's say 10 rows/records, (ID 1-10). I then have a recordset with request.querystring("id") and get the record having the id thats shown in the address bar ("..com?id=4" would get the record with the id 4). How do I get all records if the querystring is empty ("..com")
I need to pull values from another page to a form in my script. Basically i want to update an entry in my dbase and populate those current values to a form which is working fine for most of the form except the dropdownlist. Also i dont know if this is an issue but i have a "FOR" Script running in my dropdownlist constructed as follows:
<% For x = 0 to 1000%><option value="<%=x%>" selected="<%=Request.QueryString("CabN")%>"><%=x%></option><% Next%></Select>
As you can see i place the Request.Querystring object in my code but the dropdownlist doest recognise this and continues on until it reaches 1000 which at this point it stops. I want the drop downlist to reflect the same value as that which exsist already in the datebase for it. What am I doing wrong?
the above code works fine but throws validation errors.
the errors are
# olumn 81: cannot generate system identifier for general entity "id".
An entity reference was found in the document, but there is no reference by that name defined. Often this is caused by misspelling the reference name, unencoded ampersands, or by leaving off the trailing semicolon (;). The most common cause of this error is unencoded ampersands in URLs as described by the WDG in "Ampersands in URLs". Code:
For some reason,, the following recordset rs("w2itd1") will run fine when I'm looping it out on a page, but when I have it inside a sql statement, I get errors.
This will give me an error. The contents of this rs is a book title. Oddly enough, however, if I enter any other of the rs("fieldnames") that I have, in exactly the same fashion, I have no problem. There just seems to be an issue with the text coming thorugh. Can someone indicate what the problem could be?
I have a project that uses a frameset. On the pageload event one frame calls an ASP.Net page that watches a message queue. The other frame has a page that allows a user to submit queries. Through research I've discovered that IE allows only two connections to IIS from any one client at a time. This is okay since at any given time I can only have the AJAX thread and a page request.
I noticed a problem today. If I introduce a session variable in any of my server side code it causes every request to lock for 90 seconds before a response comes back. After studying this behavior I am stumped. Is there an extra thread being fired whenever session is used?
below is the code which is used for adding items and then displays the item which is working fine i have a problem when i display the item if the user press f5 or does refresh it increases the qty.
so if u look at the code i get the product details from a earlier page if the qty which i get is 2 and then i do a refresh on the page the qty becomes 4 is there any way to stop it Code:
how can I add a space between words in my formtomail script. i know that by putting & VbCrLf & it adds a line break but I need to be able to add a space.
i m using a simple form to cleect user info and i need to chech if the user left any spaces befor or between words and delete it for ex if the user pressed enter many times before typing the data in the text area.
it makes errors in my db so how can i check if there is spaces in the textarea ot text box and delete it?
that works fine but when I just do a simple Response.write(Var_Myname) I end up with something like:
'James'
I don't want these quotes, so the question is can I either correct the Response.write (don't really want to do that each time.or is there a way to ge the text boxes to do their bloody job propper.
I use breadcrumbs for navigation I have a folder called College Students in WWWRoot in college students i have a page called mainpage.shtml when i open the page like this www.abc.com/college students/mainpage.shtml i see the breadcrumbs like this Home >> College%20Students >> Students List but i want to see it like this Home >>College Students >> Students List Students List is the title of the page Can someone tell me how to get rid of those %20 that i see when i have spaces in my folder name
In my createpst.asp page I am trying to load in an array using the split function:
<% Dim arrVals arrVals = split(Request.Form ("pstfldr"), ",") Dim i For i=0 to UBound(arrVals) Response.Write arrVals(i) & "<br>" Next %>
However, the problem is that some of my values that are read in from myArray(i) in the first asp page can be more than one word. So, when I get to my second asp page and traverse through the loop, some of the values stored that contain more than one word only output the first word.
Even when I try using LTrim function, I have one variable that has two mysterious spaces in front of it when i pass it to the next page in a query string
I have written some code to query a database and create a hyperlink based on a value, however, if the value comprises of more than one word, the hyperlink only references the first part of the value. e.g. For instance, if the value retrieved is "the strokes", the hyperlink will only contain the word "the".
Below this code causes and error because there are spaces within the "". I can't change the name of the field, so I need to find out if there is away round this?
we never guarded againsts spaces in a new site we built. And while checking, a couple of users registered with spaces between their usernames. e.g. afrika 1 instead of afrika_1. Could there be downside to this?
I wanted to just use standard INPUT buttons and colourise them, but user's of my web app want to continue creating their own buttons and using these in css. Before I used straightforward images, but creating an image for each button was a mare. You see this is all to do with giving people the ability to change the look of the web app, in other words a skin, using nothing more than pics and css files.
My theory was that I create a div, span or whatever for the left hand side of the button and ref the image (in css) to be a 2px wide img that can have the curved left hand edge of the button.
I would then put a div, span or whatever next to this and the reference image would be a really long image (horizontally speaking) so that if the button text was long then this would keep moving to the right and accommodate basically any text length. Code:
Just a quick one, how can I add a space between words in my formtomail script. i know that by putting & VbCrLf& it adds a line break but I need to be able to add a space.
I have a db auto uploaded to me everyday. I am displaying information from the db, but some of the columns contain spaces. When I use a space in a select statement it obviously does not work. Is there some special syntax I need to allow for a column name that contains a space?