I'm trying to have a user enter the quantity he wants to order in the text box and pass all the parameters to a sub called "add" on the same page. I can't figure out how to pass the quantity entered to the sub. Code:
my database has a table with a primary key that is both text and numeric (seems like a bad idea now but there's 1000s of records so too late to change it ((((
basically i want to pass this from one asp page to another using the ?ID=house_ID
house_ID being the offending key
the other end i pick it up using lngRecordNo = Request.QueryString("ID")
and then my sql statement is as follows ...
strSQL = "Select * FROM House WHERE House_ID LIKE " & lngRecordNo
but it doesn't work .... i'm getting the rather generic error message of Too few parameters expected 1.
anyone got any ideas
also if i want to use date in a where clause how do i format it i've tried < " # Now() # ";" but it doesn't like it because of the quote marks inside of the sql statment.
I hav an online learning system with a questionaire that emails relative people with the results and also outputs results at end. the input is into textareas and it is being passed via response.write<input type="hidden">
i.e all data is passed through each page to the last page. At the end only the last pages data is correct, all previous pages have only the first word.
i.e computers annoy me -on page 1
would be:
computers -by the time it gets to page 4 . Is their a restriction in VBScript for passing data more then once.
I have an asp page that allows cdont mailing of form field values to persons matching slected criterea in their profile.
Works good if the user goes straight from the form to the email-making asp.
Then the user asked for a proofreading screen and what seemed simple took a bad turn.
When I try to pass from the proof reading screen to the asp that actually sends the email I only get the first word. as soon as a blank is encountered in the text it thinks it it done. Code:
I have a date in a frame/page that i want to pass to another page. I can succefully pass a static value, i just can't pass a value from a text box.
I tried to make everything public. I believe that Me. may only refer to the page that is orginating the action. But how do I pass the text box. Can we assume since I can pass the static value, that the issue is how I grab the textbox value Code:
I have a string (holding a book title) that contains an apostrophe. This is generating an error when I try to pass it through sql into a table of orders. I retrieve it from the form with
title=request.form("title") I'm trying to pass it through with: '"&rs("title")&"'
This isn't working. I tried taking out the ' ' but that didn't help, nor did elmiminating the " " help eather. Can someone suggest what might be the problem?
I am trying to pass a value into the text field on selecting the option in a drop down. The code works if the 'For' loop is not included. What should I do to make it work inside the loop? Code:
I have this problem in controlling a the text in a Text Area. How can I do that for example the field size is 200, when it reaches 50 it automatically goes to the next line. Bcoz im having problem when viewing it in my report, it continuesly views in a strieght line and im having problem in printing.
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I have a form on asp page that pulls info from a DB when the page loads. It them puts the info into text boxes on the page that are editable by the user.
The only problem I have is say in the description text box it should read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP" .. It does this on all the text boxes? I can't seem to figure out why it is doing it. Here is the sample code:
I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.
I have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?
I need to click on a button and pass through a variable with a number associated to it to other form
That is. I know I can do something like this: <FORM action="http://somesite.com/prog/adduser" method="post"> <INPUT type="submit" value="Send"> <INPUT type="reset"> </FORM>but.. can I do something like this?<FORM action=http://somesite.com/prog/adduser?data=14 method="post"> <INPUT type="submit" value="Send"> <INPUT type="reset"> </FORM>
I have some code which I use server.Execute. In the included code for the server.execute, if I use a Request variable I get an error stating that I cannot use request after UPL but If I change all the variable names from request to upl, it tells me that UPL is not defined. It seems that the page is passing the form values for request but not UPL
I have got a news section which i am working on i can get all the news items to display the short description and title with the link to the full item but when i click on any of them it takes me to the very first record in the database. i have been told that the problem is with the ids not being passed through properly but im not sure.
I have a small problem.How can I pass value from form thru a few pages. I try with hidden field but my second page just validate and redirect to other one and when I use Request.Form("field") it's nothing coming back.
I am creating a simple news WAP site which uses a database. The database consists of three columns, storyid, storyheadline and story. The first page outputs the storyheadlines. When the user clicks on the headlines, they are taken to another page. The storyid is passed through the url (stored as storyno) and the next page loads the story which matches the headline. So basically, I need to know how to correct this:
SQL = "SELECT * FROM gmscwapstories WHERE storyid = <% Request.QueryString("storyno") %>"
I have a members only section of my site, which is protected and works fine, but i want to be able to alow the user to update their profile. Problem is, i don't have anything to pass in the url.
In the member record update section of the admin, i have the url, as it leads on from the chosen members id....eg...www.xxxx.com?id=2.......like that. But where the user updates their profile, it has nothing to send data from...eg...a form/recordset. Could this be done by storing it in a cookie or something?
I'm trying to display data from three tables. The main table has a Record number and the other table contain the same number. I need to pass the parameter value (record number) from the main table to the other tables (table2 and table3) and display there data on the same web page.
i can get the three recordsets open, but I can't select table2 and table3 by the record number from the main table. I also need to be able to move through the recordset one record at a time backward and forward.
I am trying to pass a value in a way that after a user has successfully logged in to an ASP app through a form, their login id would be passed to a welcome page.
for e.g. after their login they get to a page saying "Welcome User what would you like to do? " This is probably simple but I am new to ASP,so how can this be done ?
I'm trying to post variables using http to a site with a different domain and need my page to wait until it gets a returned value back and then insert that value returned into a database. Once I'm able to get the variable back i know how to get it into a database, just don't know how to have the page wait for the value returned.
I have a submit form that collects my values, and if my form action is "mailto" the values are passed, but if I try to pass to another asp page the values aren't sent and the asp doesn't execute.
I am trying to write a search application which will allow a database holding a text to be searched.
To search the text the user has to select the act, the scene, the character Right this is where it gets tricky!
The acts all have different scenes and the scenes all have different characters - so rather than try and attempt a very complicated linked combo box for the act, scene and character I figured a more sensible way of doing it would be to have the user enter the act they want to search on one page. The value of this would then be passed by form to the next page (to get the scene).
Based on the act selected a dropdown box is then populated with all the scenes for that particular act. Following on from this I then want to pass the scene selected together with the act selected on the previous page to the next page which will get the character. I can get the scene value passed through to the character page but not the act value as this is now a server side variable. Basically what I want to end up with is after the user has selected the character on the third page, I want to be able to use all this information to build an SQL search statement.
In case you are wondering why I decided to do it in this way, I initially tried the linked combo box method but found that if the user doesn't click the boxes in the correct order it causes problems with updating the box contents. Doing it this way I figured I can force the user to enter the information in the correct order. Code: