I have the following code that pulls a record based on a form submittal then populates a form with the fields so the record can be updated. My problem is in my query line more than likely in my keyset types and what not. Code:
View RepliesI'm trying to populate a dropdown box with the results of a query. There is current code that does this but it populates with team name whereas I want division name.
The database is set up as:
League - connected to - Division - connected to Team
I want to be able to have someone choose a league and then on the next
page populate a dropdown with all the divisions in that league.
Here is the working code:
Can one form be set up to populate two or three tables? If so, how?
View Replies View RelatedI started this db 8 months ago but left it for 5 months. Now I am back and trying to get in the swing of things again. My question? Can I design one form that will populate two tables, and if so, how? (Simple answers please. I am only partially literate in programming chit chat)
View Replies View RelatedI need to populate an array with two columns of data from a database eg Firstname and second name and sorte alphabetically. So both of these columns go in to one array, I found this code.
View Replies View RelatedI have a form to edit my database. I coded the post form fine. But I have never had to pull from the database and populate checkboxes (The ones check on the post form). I have no idea where to start. Here is the code from the post form: Code:
View Replies View RelatedI am trying query the data from db and populate in the web form's textbox field. so far I cannot put that record into the text field box. anyone has idea on that, below is my sample code:
View Replies View Relatedin a text field e.g.
<INPUT TYPE="text" NAME="Homepage Email Address" SIZE="25">
How would I pre populate that text box so that when a user opens the page there is already text in that box?
what is code for populating a list menu with data from a database. also the default(first) option in the list should be "ALL".
View Replies View RelatedThe code that i have presenting allows me to view the database entries and to choose what i want to edit and then to do an update. Its not allowing me to save my new changes back to the database. Code:
View Replies View RelatedI am trying to have a web page list the contents of my database table. I have been trying for ever and cannot find what I am doing wrong.
Here is my code: (I hope it is not a mess I am new too this)I have included comments to walk myself through this. Code:
I have two columns in my microsoft access database.
1st column is company_logo (jpg image)
2nd column is company_name (text)
I want to build a form, a dropdown box which I would populate with the help of a sql statement from my database. The both columns from up there are associated.
When the user clicks on that dropdown box, I need that company_logo and company_name to be shown one beside another. It should list all the companies availible (taken from that sql statement or recordset).
Does anyone knows if this could be done?
Maybe I should stick just with the textual part?
when the user clicks on the edit account_details link, a web-based form page opens with text fields like account_no, account_name, date, type etc.
the design i want to implement is when the user enters the account_no field on the form & goes to the next field, the remaining fields on the form should be auto populated with the respective data for that account_no from the Oracle database.
Next the user can edit any of the form fields & save it back to the db.
how can i view an ASP pages on my computer that contains some data from a DB. i can view the ASP files with no problems but when it comes to some pages with a DB content it doest appear.
should i download SQL server or MySQL..?
We have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)
We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)
We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.
(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
I need to select the data where the data ID is equal to the variable supplied in the submitted form. Below is the line of code I used for the radio select and the code to do the SQL search on it. I get the following error using this code:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/MyWeb/CheckIn.asp, line 93
The items are listed by ID 1-X.
<input type=""radio"" name=""CheckIn"" value=x.value>Check In<br>
Dim junk
junk=request.form("CheckIn")
'If Session("UserType") = "User" Or Session("UserType") = "Admin" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
Set rs=Server.CreateObject("ADODB.recordset")
'in below, WHERE id = Request.Form("CheckIn")
SQL = "SELECT * FROM CompsIn WHERE ID = junk"
rs.OPEN SQL, Conn, 3, 3
rs.OPEN SQL, Conn, 3, 3 = Line 93
I have 2 databases, one i write two when i submit the form, that works fine. The other holds contact info. I need for when the Company Initials are typed in(form CSN) that the Pace Administrator info fills automatically(PAName and PAPhone). Code:
View Replies View RelatedHow can I get this line to work? I am trying to get the results entered in a form to be part of my query. I am able to get the form results but I get a error stating Syntax error (missing operator) in query expression 'Assignee = Tom Jones'.Below is the line where the error occurs
Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")
I am trying to use form input (like text from a texbox) in a SQL query. So that way a person can enter a value in a textbox and hit a button to check for that value in a database. I have the connection to the database working fine its just passing that form value into the SQL string. I wish the SQL query would work like this:
SQLCommand = "SELECT * FROM dahliaSchedule WHERE scheduleDate= " & txtDateValue
where scheduleDate = (a value from the textbox from the form.)
i have written some asp code on onclick of one button ,purpose is doing those work without submitting main form ,I am not getting working as files are not getting uploaded on web server any syntex error ? do u think this is write way to do so or suggest and modify code:
View Replies View RelatedI have this code that retrieves the logged in users info. What I also need it to do is to display other records in the database that match the logged in users custnumber. Code:
View Replies View Relatedi'm confused about perfoming insert, update and delete operations in a database. I know that to only use SELECT statement you would create a recordset and use it but for all other you need to use Command or Connection Object.
I'm confused because in some books/articles they create and open a connection and perform insert/update using that. in others they say to use Command object instead. which one do u use when?, why?.
I wish draw data from a MySQL Database using ASP.
The Code I have so far:
<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>
and in the asp page code:
116. <%=rsDaySummary.fields("PageViews")%>
This is obviously wrong as it returns this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116
Any pointers would be appreciated.
The following code works fine doing a query in the db and return the data with the link ...mes.asp?month=X (where X is a month and mes.asp is the name of the file that this code is in...)
I have a ID column in the database and would like to know how to catch data from ID.. i have tried without success, dunno why but the code comes with a error in the line "rs.Open sqlStr, data_source"... Code:
i have this shopping cart i'm working on and it keeps giving me this error and the original code is on the bottom. Code:
View Replies View RelatedI am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
im using ajax to load different pages of code into containers on one page.. i have checked my code.. and things SEEM to be named correctly.. and i know the db is workin because it populates the drop downs properly.
so if you could do this form me.. choose the first radio.. 'london postcode' and proceed from there.. when you click the get quote that error comes up.
I am trying to create a xml tree using sql server 2000 and asp 3.0 i am looking for a code for it .
View Replies View RelatedI need to know the syntax to achieve the following.
<%
Dim Year_Value_Num = 1999
Year_Value_Num = 1999
rsUsage.Open "Select AuthorLastName,ReceptorName,Year from TblAuthorInfo where Year > Year_Value_Num ", strConn
%>
The database access works fine otherwise But if i attempt the above code i get the error.
i try to get data form access with asp. The select contains 2 Subselects. If i set this SQl statement in Access it works. But if i set this in ASP it doesn't. Why??? There is no error. It's completly the same statement.
View Replies View RelatedI want to add two buttons to my page, which direct to and send query information to different result pages.
View Replies View Related