I am relatively new to ASP but am fairly familiar with PHP and ASP.NET and JavaScript.
My problem is this:
I have a drop down box which is populated from the database (Access), it sets the value to the ID of a hospital ward, and the text to the name of the ward.
I then use the ID to look up an email address for the manager of the ward from another table in the database. My un-optimised code is as follows: Code:
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
i have a formular using two text field. i want , when i finish writnig , moving to the next using " Enter " key.
View Replies View RelatedI have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.
I am having problems retreving the data from the boxes after the user has moved any of the data:
If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:
request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count
If i dont move the data i can retrieve it using: Code:
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
Anyone know how to create a drop down menu where the user can enter text
also?
If they do not want to choose an answer from the drop down menu, the
users can just enter their own answers in the drop down box. Anyone
know if this is possible?
I have a page with a drop down box and a text field. The drop down box selects a column from a table in my database. txtField is the drop down box and txtSearch is the text field.
The form method is post and the results are passed to the next page which has the query for the database as shown below. Anyone any ideas why I get no results from the query? It works in queryanalyzer so I assume its my asp thats wrong? Code:
I was wondering if someone could help me with finding out how to populate a drop-down box with values queried from a database.
Also, I was also wondering if someone could help me with figuring out a way to place field-values retrieved from a table into a text field. This would be for the purpose of editing a record that has previously been entered.
Placing the information in a texbox field so that the user can easily type over it seems like the best thing to do.
I want to write a asp script, basically, that has drop down box in the form, if user select Yes, on the same page, a hidden textarea will show up, if user select No,
then nothing happen.
so far, my code is unsuccessful, in addition, I also got syntax error on the response.write line anyone has idea. Code:
I am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.
All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!
I have a quick question regarding a text field for inserting record, I have a page which inserts various fields including area code an phone number for a new record, however I am curious if there is a way that I can either make the area code appear with brackets around it in the text field which is sent so that the user does not have to type it in each time.
I was thinking I could concantenate the value i send in each time with brackets but am not sure what the syntax would b for this. or perhaps there is another way of doing this?
i'm trying to figure out why i can not update a record if in the text box there is a ' anywhere in the field..
View Replies View RelatedOn the webpage, I want to display like this:
I use Response.write objRS("FieldName") to display the value of a record .I guess a number of chars is allowed to display a part of record.
I have an drop down box.I want a button next to it which says ADD.Once i click that button I get text box where i type my data and after submiting it,it gets added to the drop down box on the page and now i can select that data from the drop down box and proceed ahead with my order.
View Replies View Relatedhow to pass the selected value in dropdowm box into a textbox.for ur informations, all the data inside the dropdown box are retrieve from Access Database.i want to pass the data that is selected into a textbox, which already consist data from the database also. how to overwrite it with the data from the dropdown box?
View Replies View RelatedI am currently working on a project and i need to have drop down menus on a form which include data from tables in a database. There will be a number of drop down menus on this form as well as text boxes. I'm struggling with the code and need to know how to code a drop down menu that would include all the records from a drop down menu.
Is it possible to use all the values in the form, including the drop down menus to insert the values into a relational database. I'm assuming i would have to use variables to pass the information into the database using an SQL insert, but i am once again unsure how to code this.
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 Relatedi have a page which displays a list of events searched for by a particular date. we usually have a lot of events and i don't want the user to have scroll through all of them, especially if they're interested in a particular type of event.
i have created a dynamic drop down menu which consists of all the event types. how can i got about displaying the events returned by the query to a specific event for that date.
so for example, if some one searches for 03/08/2005, they will initially get a list of all events for that day. if they click on "Closed" from the drop down menu, it will display all the "Closed" events for 03/08/2005.
I have 2 tables Table_A and Table_B are linked together by TaID
Table_A
TaID - autonumber
Name
Address
Table_B
TbID - autonumber
TaID
Comments
here is my asp page
-------------------------
<%@ Language="VBScript" %>
<!-- #include file="connectionstring.asp" -->
<%
'declare variables
DIM ......
'Assign Variables
.......
Set Conn = Server.CreateObject("ADODB.Connection")
'database connection
Conn.provider = provider
Conn.ConnectionString = dbasepath
Conn.Open
'Sql statement to insert the data
sql = "insert into Table_A ( Name, Address) values (...*data from form*...)
' execute it
Conn.Execute(sql)
Response.Write "Data successfully inserted!"
Conn.Close
Set Conn = Nothing
--------------------------------------------
my question is I also need to insert the data to Table_B, but before that, I want to retrieve the Table_A.TaID first.
so if i do "select TaID from Table_A" and execute the sql how do I assign just the LAST record of TaID and assign to temp variable?
Do I allow to do that? if so, where should I put in the code above?
I want to display the contents of a field with a label if there is data in that field. If there isn't then I don't want the label to appear. I tried this:
<%If Venueinfo("email") = "" Then
Else%>Email: <a href="mailto:<%=Venueinfo("email")%>">Click to
email</a><br><%End If%>
But it doesn't seem to work. It seems to always display the label and link even though there is no data in that field.
wondering if you can do this in asp
<title>
<%
Response.Write Recordset (Title)
%>
</title>
I have a page where a user can submit a record for a new "applicant". After the user clicks Submit, I would like to send the user to a new page containg the "Applicant Number" which the user will need.
The applicant number is simply the autonumbering of the record in the table which is in a SQL Server db. How do I capture the record number(primary key) of the newly entered record in the table and send it to my new page?
I have 2 textboxes. In first text box i need to enter name, the second text box shud be automatically filled with the person'd id.
Both the name and id is coming from database. I tried using this code, but i'm getting error saying System.NullReferenceException: Object reference not set to an instance of an object. at line 1 Code:
I currently am trying to get a form to send its data to a text file. I use the code I have found in tutorial/help sites around the web, but when I try the code out, nothing happens.
When I click the "Submit" button on my form, I am sent to the .asp file and the code in that file is displayed in the browser. There is nothing written to the text file either.
The code I have in my test.asp file is:
i have 2 text box whom data are generated randomly, how can i get this data and pass it to a access database using ASP?
View Replies View RelatedOk i have a shopping cart got everything pretty much going but it didn't allow for quantities to be updated. So in my cart view i decided to add a quantity box so u could enter a new value and then click update to update that item.
However i don't know how to grab the value from the txt box.
I have the code working for all the db updates cause i tested it by hard coding it in. I just cant grab the value and pass it on from the txt box....
I am trying to pull data from a DB an export it to the user in a comma delimited text file.I found this.Do I need to save the actual textfile or is it possible to stream the text file out to the browser? If the answer is yes, how do I stream it after it is saved and delete it once it is saved by the user?
View Replies View Relatedi ve a problem thats regarding the data retrieval from database.I m storing data in the microsoft access database by writing query in the asp page..and the number of characters is exceeding 255.so the datatype that i ve chosen is memo...
but now when i want to retrieve the data on another page by writing query i cannot retrieve the whole data it is truncating and i can get only 255 characters
i have a table with sno, userid, name, age, level
where level means the type of grade a person has like A,B it may even be Numbers on a scale of 1 to 5
the sno is declared as a rowid datatype
if i want to update any record i have to give the existing userid ( primary key ) and even update the primary key if there are no duplicates (obviously)
so when the userid is entered i am selecting the rowid where userid = request("")
and storing that rowid value in a variable to perform update operation in the next few steps
i am getting a type mismatch when i am doing the assignment
is there somethin wrong in the code ( that i need to check again ) or that sort of assignment cant be done
( i am still tryin to get it right as i write this thread )
i have one more ques: does the rowid value remain constant that is when i do a delete operation on one row and then subsequently a update operation on another row in the same table will the rowid's get mixed up and mess up my data.
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
View Replies View RelatedIs this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I'm trying to include a value from a text file for the txRate variable in the code below. I tried using the include function as shown, but the double quotes are of course killing it. I don't want to use a data base to get this value, I just want the info from a text file. Can anyone suggest a solution? Code:
View Replies View Related