Inserting Table To Format Dynamic List
I have an .asp page that contains a drop down menu, that when a selection is made, reformats the page to one of 22 different .asp pages. When clicked, the drop-down disappears and the options from it are formatted as a list on the left hand side of the page.
I need to format this so the list is in 3 columns, with the secection bold. I think I need about 4 if..then statements, but I've never done this before...here's the specific code, the code for the drop-down is first, then the code for the "quick link" list: Code:
View Replies
ADVERTISEMENT
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
Any suggestions on where to start?
View Replies
View Related
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies
View Related
My question is this: how do I get a value from a listbox to assign to a variable (elementary I know)? Code:
View Replies
View Related
I'm having problems inserting into a table in an oracle database. I am reading in variables from a ASP form and trying to enter these into the database. however only numbers will insert, even though I can print out the string variables on the ASP page. IF I inclose a string value in the insert statement it works ok so there is nothing wrong with my SQL code. Code:
View Replies
View Related
I am right now calculating distance between 2 zip codes and storing them in a table along with extra information like a persons name and address and stuff like that.
For some reason for distance "0" ..doesnt get inserted in my table..? What do i need to do in my code so that "0" distance + information gets in the table since i need that info to be displayed later for people to make calls to those people with 0 distances.
View Replies
View Related
my database is access and i'm trying to insert data from a form into the table's fields in the same order they are written in the form without explicitly having to mention the fields' names.
e.g. (this is the prototype of what i want to do)
for x=1 to request.form.count()-1
insert into table1(fields(x)) values (request.form.item(x))
execute the sql
next
does anyone have an idea of the right syntax for this?
View Replies
View Related
I'm trying to insert a table to format a list of options on a dynamic page using VBscript.
The page currently displays the links in a list when the user chooses one from the drop
down menu. I would like the links to be in three columns, rather than the default
vertical list.
View Replies
View Related
i have really only been exposed to getting data from aSQL database and displaying it.I want to include a page in my application (like a form in Access i guess)with various text boxes and drop-downs + tick boxes.Then i want to click a submit button that inserts the data (providing is valid) into a SQL Server table.
I have had a search in google but nothing seems to explain this in its most
basic terms (errorchecking and inserting).Could anyone give me an example of this or some background about this functionality.
View Replies
View Related
I'm trying to insert into a table with foreign keys. The statement works in query analyzer but not when I do it in asp to insert the data from a form. Code:
View Replies
View Related
i am trying to use the 'Insert into' sql query to insert data in an asp file but having some errors...this is the eror i got from the browser..
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/AddConfirm.asp, line 46, column 36
sql="INSERT INTO tblMembers VALUES("8"," & DateJoined & "",""& Title& "",""& LastName& "",""&FirstName& "",""& DOB & "",""& AddressUnit&"""
this is the code i have in my asp file....
Code:
View Replies
View Related
If I am attempting to add multiple products to an existing Customer-Products
linking table do I do this via an Insert or Update?
The first time I enter a customer in the database I would obviously do an
INSERT into the Customer-products linking table.
But, the second time I wish to ADD new products as well as possibly
overwrite existing ones......
I am getting twisted what the correct approach is?
View Replies
View Related
inserting dynamic page code in .html page? i.e. i would like to insert a code which will display links. where my homepage link extension is .html. if it is .asp it would have been very easy. and also i would have worked fine. but now the problem is the homepage index file extension is .html.
so if i insert the code it is not displaying the links. i tried inserting the code in a separate file and saved as file.inc and gave the link from home page <!--#include file="file.inc"--> but still the link is not showing and not working.
View Replies
View Related
Does anyone know how I can insert daynamic text box data into a SQL Server database? I have text boxes that are being generated dynamically and I want each of those values inserted into the database that hold the results. I'm not sure how to write my loop statement.
View Replies
View Related
if it is possible to insert and update records in a database from the data that is in an HTML table? I have a program that converts data to an HTML table and would like to be able to insert/update records to the database on the webserver.
View Replies
View Related
Not sure if this is an asp question i think its more of an html question but not too sure how to change the font of the drop down list here is the code, any ideas on where i should but the <font> tag? Code:
<td width="27"> </div></td>
<td width="40"><span class="hotsubtitle">Account Name:</span></td>
<td width="42"><select name="Account_Name" class="relatedLinkTitle">
<option>ALL</option><%=Request.Querystring ("Account_Name")%>
View Replies
View Related
Would someone be able to explain the sql image field to me. I was reading about it a little but dont really understand.
I would like to have word documents that can be indexed and searched and i heard the image field with an accompanying char field with the file extension would be the trick. how would i actually get binary files into the image field?
I wanted to write an asp script so users could enter .doc that they could query. I understand basic asp sql inserts.
View Replies
View Related
I have 2 radio buttons: A and B. I also have a menu/list/dropdown.
When 'A' is selected, I want the menu/list/dropdown to fill up with all values from a database WHERE column = A (for example) and the same to apply when I choose B... I want the menu/list/dropdown to fill up with all values from a database WHERE column = B.
View Replies
View Related
I have a dynamic list box in which I am calling data from my database too and having when the user submits the form it takes a value and submits it into one column of my table but i need one select to submit a value into that column and a value into another column at the same time depending on what they picked from the drop down list.
there are four options in the list and each one has a different Type value and also a DES value that both need to be submited into two different columns depending on what is picked.
View Replies
View Related
I have a form I'm building in Dreamweaver. On my form I have a drop down list that is populated by a table in my Access Database. I won't to add a second drop down list but have the contents of it vary by what I select in my first drop down list. Let me explain further. Lets say I have a database of Movies. And The name of the movies are in a table and that table is used to populate my first drop down list. Now I have another table that has the actors in the movies. I have a junction table to make them relate in my database.....now how can I select a movie in the first drop down list...and the actors from that movie popluate the second drop down list?
View Replies
View Related
I am working on a page to display providers of services in my SQL Server 2000 Database. Visitors to the page choose a category and type then a dynamic list of available services that meet the specified criteria is displayed in a select field. My problem comes in with this list.
You can choose multiple services from the list. I want to then use the chosen services and a payment type to query a different table and display providers that meet the criteria specified. I am using the following code to read the choices from the select field. Code:
View Replies
View Related
I'm trying to build a asp dynamic list were you can select a option in the first list and depeding on that value the second list will change to match. For instance I choose a customer in the first list, the second list then has to give all the codes from that customer. The list is variabel, as the value;s are from a database.
If tried some stuff with ASP and Javascript, but the page reloads after selecting one option, but because it reloads, it delete's the text that is written in the rest of the form.
View Replies
View Related
I hope this is the right group. I am very new to ASP so this is
probably a stupid question. I have some vbscript that query's AD and
populates a recordset. I know the recorset contains the information I
want by doing a Response.write. I am having problems dynamically
creating a drop down list from the data in the recordset. The drop down
is created but it is empty. Code:
View Replies
View Related
I need advice how to reduce the size of my drop down list which is created dynamically using a field from my database. If you visit this link you'll see as the box is too long it's knocked out the whole look of the page. Other than shortening the names of the businesses, is there anything else I can do?
My concern is that next year sometime after this site has gone live, it will be maintained with a content manager by people with no IT expertise.
View Replies
View Related
i want to retrieve the value from Mircrosoft Access database into the drop down list..it works.. so its dynamically..
but the problem is.. how could i redirect from the dynamic drop down list to other page.actually this page mostly like a search page.
View Replies
View Related
I have an form/application that requires several pages of steps to be completed. On page4 (income school info) I have a dynamic drop down list that builds itself from the database based on member names that the person has entered on the previous pages. When the person filling out the form gets to the end they have the chance to edit their data if something is wrong on page5a.
When they click on the edit icon the member name is passed back to page4 in the querystring. Based on what the member name is in the querystring, I want the dynamically built drop down list to select whatever name is in the querystring. Code:
View Replies
View Related
I could not solve for the past 3 days. I am try to build a website using ASP and VBscript. I am still a newbie to it.Let's get to the problem. What I am trying to do is to have multiple dropdown list. Each list menu ( except the 1st) dependes on the choice made in the one above.
I am using dreamweaver, it did generate a the form and everything and I was able to filter the results. The problem is that I don't know HOW TO REFRESH THE LIST. In other words, I can't figure out how to change the list menu options when the choices above change. I have tried to find some tutorial about it, but all I found was with JavaScript and I don't wanna mix VBS with JS.
View Replies
View Related
I have a web tool written in ASP. One of the feature is dynamic drop down list which updates a drop down list as another drop down list is changed.I uses javascript to reload the same page to update the drop down list.Everything works fine on the webpage using desktop/laptop.
However, it doesn't work on my mobile device(i.e. one drop down list doesn't get updated as another drop down is changed)how to make it works on mobile device? Should I integrate ASP with another technology,. WAP maybe?
View Replies
View Related
Does anyone know how to make it so that when someone clicks on certain menu item on one list it automatically updates a second list with values.For example,if i click the Make of a car in one list, i want the second list to automatically update with the relative Models.
I've seen it done on various sites such as www.autotrader.co.uk but can't think how its done. So far i'm populating the first list dynamically with a database but don't know what the next step is to get the second one to do it.
View Replies
View Related
I have a set of dynamic dependent list boxes that are populted from a database. When I select the first box the second box is populetd with the correct items. If the first item is the desired selection another option has to be selected and then the first item has to be reselected for the list to work properly to update the next dynamic list box. To include the --Select-- in the second and third list box table would add several thousand rows to the table. If I added the --Select-- in the table it would add several thousand rows to the database.
View Replies
View Related
I currently have an "Add customer" page on my site. On this page you can choose multiple "brands" from a list box. (These brands are dynamic and come from a seperate table in my db). These brands are split up into an array and each added as a row to a database table.
Now I am working on a "Modify customer" page. It has all the same fields as my Add page except that the fields are already filled in with information from the db. I can't seem to figure out how to have my list box have multiple items selected when you first come to the page.
View Replies
View Related
Desire: Build dynamic page using SQL database. The page is just a list of Form Number/ Form Name. I am using an SQL database which comprises: Dept. Number/ Form Number/ Form Name. The form number is a concatination of the dept. number and form number (Dept=10, form=100, form number on WEB page list =10100). These forms are in Word and Excel format.
I use the following ASP code to display the form list and it works fine: Code:
View Replies
View Related
I've tried doing this tutorial on Macromedia's site, but can't get it to work.
http://www.macromedia.com/cfusion/kn...fm?id=tn_19117
I'm using VBscript server side script.
View Replies
View Related
