Retrieving Form Data (part 2)
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig/default.asp
or
http://localhost/site/craig/test.asp
or
http://localhost/site/craig/roger.asp?dan=1
is there anyway of retrieving the word craig so to use it in the page, I just want the word Craig
This is because i could have other addresses that are for example
http://localhost/site/jon/default.asp
or
http://localhost/site/jon/test.asp
or
http://localhost/site/jon/roger.asp
where i need to retrieve the word jon
at the moment i use the code
strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "")
intStart = instrRev(strURL, "/") + 1
strName = mid(strURL, intStart)
this worked fine until new pages are added ie a page that isnt default.asp
Obviously i cant use strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "") because default.asp will change...
View Replies
ADVERTISEMENT
I have an asp page that shows dynamic data from the db, I only want to show
the first 3 letters / digits from the db on the ASP page.
View Replies
View Related
On one of the sections I have a text field called IMO where the user may input text. Beside the IMO text field I have a button that will submit the value found in the IMO field if any to another asp page namely get_vessel_fields.asp.
I don't get any errors but nothing happens when I click the button.
<FORM><input type="text" name="IMO"> 'THis is the IMO field in question there are other fields in this form
Dim strIMO
strIMO = IMO
<FORM><INPUT TYPE='button' VALUE='Pop' onClick='get_vessel_fields.asp?strIMO;return true;'></FORM>
'get_vessel_fields.asp will then process the value submitted
View Replies
View Related
Got an item master, think of it like an inventory: description, supplier, cost, unit of measure, etc.
There is an item_type field, which, when set to a particular value, REQUIRES that labor be also entered for this inventory item. I was going to just show/hide a part of the form, but the kicker is that more than 1 labor item can be entered for each inventory item.
View Replies
View Related
from the client side is possible to create a XMLHTTPREQUEST object to retrieve data ( in async way ) from web services, or simple from a asp page like this :
----- myasp.asp -----
<% response.write("<info>hello</info>") %>
----------------------
how can i accomplish this, but from the server side using ASP and ASP.Net ?
View Replies
View Related
I've created asp reports getting datas from Oracle. The server im using is 8i while client is 9i. Does Asp support oracle 9i. I mean while retrieving numeric datas from oracle it displays only 0. But if the same query is run in oracle to test it, it displays properly.
Do I have to download any patch or driver where IIS is compatible with oracle 9i. Any ideas whats wrong. Did u guyz understand what im trying to say. For ur better understanding Im sending a doc attachment.
View Replies
View Related
if there is two tables. for example
Table 1: IC No, Name
Table 2: IC, No, Address
IC No are primary keys
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
View Replies
View Related
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
View Replies
View Related
I have a search set up on my site to compare between two <select> values and the value in the data base, but not sure if I have the sql statment correct, my search returns all rows from the table, I want specific row that is between one form select and another... ie. below
for this particular example I want to know if the database AD_PRICE field is between <select name=price> and <select name=price1> and if so, return the only those rows, currently all rows are being returned... Code:
View Replies
View Related
does any one just help me with the an example of retrieving data from access data base?
View Replies
View Related
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
View Replies
View Related
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies
View Related
I have a comments form that when filled in posts the comments from a text field into a database.Due to a bit of duff coding (Doh!) the database was not getting updated and i lost 50 or so posts worth ofcomments.
Is there any way of retrieving the posted forms from theserver?The form uses the post method, with asp doing the work.
View Replies
View Related
Im having a bit of a trouble with this piece of code , basically what it does is allow a user to register with the site , then their deatails are added to a database , now what i want to do is RETRIEVE THE USERID value so that it can be passed to other ASp pages. when i run the register page i get this error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Code:
View Replies
View Related
I am having a slight problem. I have an asp page called custfeedback.asp. This page contains fields where the customer fills in name, email address comments etc. The form gets submitted to feedback_complete.asp, where a message is displayed thanking the user.
My problem is that the variables in custfeedback.asp are not "retaining" their values when the user is redirected to the feedback_complete.asp page. I know the asp is working, because I have the following line in that displays correctly:
<% Response.Write (now()) %>
I have no idea why the variables aren't retaining their values. Does any one perhaps have any idea how or why this is happening, and how to resolve this problem?
View Replies
View Related
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
View Replies
View Related
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
View Replies
View Related
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
View Replies
View Related
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
View Replies
View Related
I am trying to create a form where the user can check a box within a form and the address will fill in automatically from a previous address in the form, without submitting the form.
View Replies
View Related
I need to get some Request value from a Form... but this form is enctype="multipart/form-data" (to upload files) and I if I use the standard syntax Request("nameField") I don't get any value.
View Replies
View Related
strSQL = "SELECT user_name, password FROM [tblLogin] WHERE user_name = '" & Request.Form("user_name") & "' AND password = '" & Request.Form("password") & "';"
Is using AND the correct way to use 2 comparisons in the WHERE part of the SQL??
View Replies
View Related
I have a database table, that I need to sort by PART of the contents of a field (named rFieldName in the table):sample contents of this field are:Code:
qid_5_question_1
qid_12_question_5_0_1
qid_12_question_5_0_2
qid_12_question_5_1_1
qid_12_question_5_1_2
qid_12_question_5_2_1
qid_12_question_5_2_2
qid_12_question_5_3_1
qid_12_question_5_3_2
qid_6_question_2I need to sort his field by the value that appears AFTER the 3rd underscore, and if applicable BEFORE the 4th underscore
Is this possible - can you help please - I have no idea where to start on this as I've never had to try to do something like this before.
View Replies
View Related
I would like to use the last 10 characters of a Session object. Is this possible in active server pages. I am familiar with the user of Right$ in visual basic but I after trying serveral conatations I have had to give up.
View Replies
View Related
I have a form which dynamically loads questions and answers depending on dept.
So the form input type has a value field of the actual answer text which is pulled from the database.
Sometimes the form can be 5 questions, sometimes more and sometimes less. So after the user submits the form, I gather the static input (ie. name, address, email, etc..) but
1. how do I loop to Request.Form for the dynamically generated answers if I dont know how many there may be?
2. How do I then take that data and use it in my Insert statement?
The questions with each answer will automatically generate the imput name field with the qid (question ID) which could be 1-?
View Replies
View Related
i have this page that inserts a form data into database... the problem is that it wouldn't let me insert my content into the database because of syntax problem... more specifically if i have an apostrophe.. it wouldn't let me insert due to the restriction of my code... is there a way to rewrite my code below so that i can insert apostrophe.. right now if there are ' in my content the strSql will screw up...
strSql = "INSERT INTO Events (Title, Author, Content, SDate) VALUES ('"&strTitle&"','"&strAuthor&"','"&strContent&"','"&strDate&"')"
View Replies
View Related
Does anyone know of anything or any issues that may cause HTML form box (shopping cart) to reset or not keep its posted value?
out of approx 2000 users, only 15 are having this issue and the common thing between them is using Mac's (Different browsers but mostly IE5 and Safari. even made one install latest firefox) instead of PCs.
Now I know this goes against everything I ever knew about SERVER SIDE SCRIPTING, but im really reaching for straws.
View Replies
View Related
I am developing a program now. This program has a front page for user to select a project. After the user hit "submit" bttion, he will go to another page which has a top menu.
User can see different part of project information by clicking there. I hope no matter in which order the user click on the items in the top menu, it will show the record based on this project until he select a different project. To realize this function, should I use cookies, or there are better ways to do that? It will be very helpful if someone can provide some sample code here.
View Replies
View Related
I have this code...
If Request.Form("Name") = "" Then
Response.Redirect "error.asp"
End if
If the browser does a GET against this page, sometimes the Response.Redirect doesn't happen. It is as if there is form data being sent on a GET. Has anyone seen this before?
View Replies
View Related
i am working my site using asp html vb javascript and css.
When a user registers on my site i would like them have their own page. I was wondering how would i be able to have a page made automaticaly after that person is registered? I am very new to javascript so....
This is the page after the user is done filling out the form: Code:
View Replies
View Related
how do I get a reg exp to remove part of a string? -
I have: '/page/txtonly/index.asp' and I want to remove the '/txtonly' to end up with: '/bobby/index.asp'.
View Replies
View Related
is it possible to reload just one table row with out reloading the entire page? Or reloading just a table? i'm not thinking it's possible but if it is it's worth asking a qustion.
View Replies
View Related
I need to limit how much of a record is printed to screen. I just want text up to the first full stop.
View Replies
View Related