Creating Database Fields Dynamically
I am using a repeated field to bring in to my page repeated records, and I have been able to retrieve values that are entered into text boxes that are associated with these repeated fields. I would like to post these values into a database, but I'm not sure how to set up my table as I know that each employee's values as well as number of fields will be different.
I thought about setting up two tables. One that houses the dynamic question and the other to house the answers, but I'm not sure if that will work. I could really use help as to the syntax to write a loop statement that will insert my returned variables and create the field names dynamically into my database table. I believe this is what i need to do.
View Replies
ADVERTISEMENT
I have been given the task to create a search page to search on of the tables in the sql database. I have been asked that the user should be able to search any field(which I
have done) but he should also be able to customise the form to display or hide any feilds in the results.
My table has about 20 feilds and different users wanting to you the search page will like to see different set of fields.
View Replies
View Related
I get all excited to to pump some data into these PDFs that some loan-sharks want to use on their intranet, and then I find that the Adobe Acrobat SDK doesn't support .NET (which they said they did); however, one may access a little "tip" from Adobe if one joins their dev community for the low annual fee of $195.00. Has anyone taken advantage of these features of Acrobad Pro 6.0 in .NET? I'm going to try, but some "tips".
View Replies
View Related
There are two files here.. TEST_CHART_RUN.HTM calls the second file. Please copy and paste these files as needed to htm and asp files.
View Replies
View Related
I am tryimg to create a RadioButtonList dynamically. My code below gives an "Index was out of range" error. Where am I going wrong?
Sub CreateRadioButtons(ByVal dr)
' Instantiate RadioButtonList
Dim DynamicRadioButtonList As New RadioButtonList
Dim t As Integer
t = 0
Do While dr.Read()
DynamicRadioButtonList.Items(t).Text = dr("PRO_en")
t = t + 1
Loop
'Add radio button
PlaceHolderGroup.Controls.Add(DynamicRadioButtonLi st)
End Sub
View Replies
View Related
Is it possible to create tabs dynamically using asp. eg .i m working on three projects. so when i open the portal, it will show me information of each project in three diff tabs with the name of project displayed on the tab. If tomorrow i ll be working on 2 or 4 projects it will display me only 2 or 4 tabs.
View Replies
View Related
I want to update Excel file when i update database.
View Replies
View Related
I am generating a series of tables in CSS. The tables should repeat
themselves for a number of times governed by a counter that is
calculated at runtime by the ASP code. The problem is that I have used
top margins to position the tables in the ASP page.
So the tables when repeated super-impose on the tables that are
already placed at that margin position. Can someone suggest me a
better way out to resolve this?
View Replies
View Related
my ASP code creates a form and an array of chekbox with this statement response.write "<input type='checkbox' name='chkProduct" & Cstr(counter) & "' value='delete'>" all goes well and i also have a button that points to a VBScript function passing one parameter the counter start value so i can loop throught the checkboxs on the client side and determine if checked or not.
Ok i can display my command "document.frmProductCart.chkProduct & (Cstr(counter)) & .checked" as a string in alert but cannot make it as a command like it should be, anyone got any pointers ?
View Replies
View Related
I need to implement the following functionality in asp. I have got an asp page which renders some html onto the browser.Now instead of rendering the html to the browser i should save that as an html file in server itself.
View Replies
View Related
I want to create an order form for prints online... I will have up to 200 prints to be selected. What I am thinking is that I will have an HTML Form that has all the 200 thumbnails with a check box next to them. They select the ones they want and push next. Then I would like it to create a set of options for each one they selected.
That basically says the image name then has a check box for 5x7, 8x10 and a text box for the amount for each... I do I create the page what creates these selections and how to I incorporate that into a mail form going to the next page?... it seems like a simple enough idea. Am wondering how the reality of it will be.
View Replies
View Related
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
View Replies
View Related
I am looking for an ASP script that let me to serach all database contents with only one textfield in search page. eg: I have a database with five columns for lessons: Mat, physics, geography, history and sport. Each field have numbers 1 thr 5. I want to search only those students have number eg:3. with entering the number in textfield in serach page. I have no problem in result page.
View Replies
View Related
Is their a way to check with asp-code if a database field is relational with another field (from another table)?
For example:
If fieldname = relational Then...
End If
View Replies
View Related
I'm trying to set up a quick if/then/else statement for when the database field returns no results. I'm not getting an error but when the field is EMPTY it still executes the ELSE statement.
<%
If rsOffice("FloorPlan") = Empty Then
Response.Write ("Not Available")
Else
Response.Write ("<a href=" _
& rsOffice("FloorPlan") _
& ">View</a>")
End If
%>
View Replies
View Related
At the moment in time I have a product database being displayed. I could do with including another column to the database which allows me to enter a specific quantity for that product line. All the quantitys fields need to be calculated to their specific product cost value.
Finally all the sub totals need to be calculated together to give a grand total, which will be displayed on another page.
View Replies
View Related
how to compare one Database field against another which both have a date and time in them (DateTime format) using VB in WebMatrix. or just comparing Database fields of DateTime aginst each other in VB.
View Replies
View Related
i'm having trouble finding the syntax of the create database..can some give me a link or something??
View Replies
View Related
i have a form with fields that contain data from a db. the fields can then be edited, and on the click of the "submit" button, the updated information is returned to the database, replacing the old. a bonus would be arrow buttons allowing navigation from one record to the next, with the information populating the form each time. i'm having a hard time with this.
View Replies
View Related
I'm trying to retrieve information from a field in a database, which contains data, some of which are the same. ex:
let's say the table is called "Person_info" and there are 5 rows of info with a different person's info.
let's say i want to display the info in the fields called "City" but there are duplicates ex:
Toronto
Vancouver
Toronto
New York
Atlanta
I'd like it to display all the cities in there on a web page, but, I don't want it to display the same city twice:
so it'll display this:
Toronto
Vancouver
New York
Atlanta
I just can't get it to work? it keeps displaying duplicates.
View Replies
View Related
This code has worked in the past on this same page, and for some reason it doesn't want to calculate the numbers anymore. Anyone see anything that is out of whack?
Basically I am taking the input numbers for each field and adding them up on one column, then taking the totals of all of those columns and adding it up to display as an overall total. Code:
View Replies
View Related
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.
There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.
View Replies
View Related
I have a an issue that I would love to solve. The below code adds 111111111111111111 to the field when I want it to sum the amount which in this case totals 18 and then add that total (18) to the field! Code:
View Replies
View Related
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
View Replies
View Related
I want to create a database and its tables and populate it through a web page, using ASP. The database is MySQL on win32 (4.10.13-nt) and the driver is MyOLEDB 3.0.
One thing, to set up the ole-db connection, it seems I have to specify a data source, which is an already existing database.
The Connection works and I actually can create the database, but the code for the table creation generates a 500 server error. The SQL itself is taken straight out of MySQLcc query window, so I know it's all good, syntactically.
(Also, regarding the connection, I can connect to and read from an existing database. It's the table creation that seems to be the trouble.)
I did a response.write to the page to make sure that the code coming out is what went in and that is the case. So, I guess one question is, what could be different about creating tables in a db that would fail, when "create database test_links;" and "use test_links;" both complete successfully (and the newly-created database shows up, just no tables in it).
To test the sql, i made three strings of SQL and executed each of them sequentially. The first two work, the third (table generation) fails.
A second question is, is there a way to capture any error message that might be generated at the MySQL end, rather than having the page bomb out; and then display the error. I tried using a RecordSet object, that didn't work, the page still crashes.
View Replies
View Related
Is it possible to create a database of any sort not only Access using nothing but code?
To this day I still create databases using Access on my hardrive then upgrade them and use code to modify them... would be very convinient if there was a way to just create with ASP code and edit from ASP as well...
View Replies
View Related
i have to do a code in ASP that including this code:
set c=server.createobject("adodb.connection")
c.open "dsn=MyDSN;"
c.execute "create table first_tables(Name char, Tel char)"
and i am geting that error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Text Driver] Cannot modify the design of
table 'first_tables'. It is in a read-only database.
/1.asp, line 4
what can i do?
View Replies
View Related
Does anyone know of a database system available in which users could establish a user name and password to register products, buy merchandise and access a message board? I have moderate asp skills, but have no idea how to write or where to purchase software to create this database.
View Replies
View Related
I have announcements down the left hand column of a site and want to display contact info if it is available - if it is entered into the database. So I only want to display a space plus the data if there is data in the field. Code:
View Replies
View Related
I need to create a chart/graph with the following data from my database:
Each record is opened and then closed at a later stage. I then calculate the time it took from when the record was entered to when it was closed.
Now i need a pie chart to display how many records was closed in certain times. for example 10 records was closed within the first 10 minutes, 2 in 20 minutes and so on.
this also is to happen for dates that the user entered. i.e a Weekly report and a monthly report.
Any advice and help will be appreciated. I found alot of examples of hardcoded graphs but none extracting data from database.
So first i need to count the records that fits each section of minutes and then use that data to draw my graph?
View Replies
View Related
I want to create a breadcrumb trail on a site, but instead of being
generated by cookies or a directory structure, it needs to be database
driven. My website details hundreds of products, each belonging to a
category. Each category can belong to a parent category, and so on.
My site will feature master/detail pages, and both need to feature a
trail, e.g.
Books > Hobbies > Sport > Football
The master page will list all items within the current category, and the
trail will allow the user to click to any parent category for a wider
listing.
The detail page will show the item detail, along with a full trail to
the category/parent categories it belongs to.
The category structure will grow over time, and different branches will
have different number of levels so it needs to be maintainable.
View Replies
View Related
I am tryin to create a database of users for my system,each user is given a username based on their own name(surname and first name), however if 2 users with the same or similar name enter their details they will be given the same username,for example john drew would return drewj as thier username, so would jack drew, when a new user is entering their details how do i check that the username generated for them does not already exist,i.e i need to compare the username generated for the new user with all usernames already held in the database,if the username does already exist i want to add a digit to the end of the username how is this done using asp?
View Replies
View Related
I have created a database connection function which I use to open my database connection and recordset and another to close it. Easy stuff I know. The problem is this.
I want to be able to create database conenctions and recordsets specifically when I call the function. For example Code:
View Replies
View Related
