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 RepliesIf 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?
I need to create a webpage with an HTML table that keeps track of certain data. I have created the table and hardcoded all the nonchanging cells.
The problem is the data I need to update the table with is FTP'd to a webshare in a .txt format. I need to take this file, parse it and update the table every morning at 745.
I have found ways to do it if the webpage receives a hit, but I still need it to do it on weekends and holidays when we are not in the office, because this file will be overwritten with the new data file the next day.
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:
I am using ASP to generate an HTML table from a database. I use FSO to output a file with an XLS extension then open it. I can set the column width and row height; I can set the font family, size, and weight. I know I can include formulas in a "cell".
What else can I do when I generate the table that will take effect when the file is opened in Excel? I'd like to do things like autofit and sorting. The client does allow Office Automation on the server so I can't write to Excel directly.
I am having trouble getting records to insert and update properly. This is not a consistent problem. It is intermittent. The page will allow me to correctly update 2 or 3 times generally, however after that it will double up the data in the insert and update.
Here is the code I am using. Code:
I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
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 RelatedI have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
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 RelatedI 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.
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?
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.
Can anyone direct me to a web page (tutorial) where there is an explanation on how to create a web page that connects to access database and I can enter data and update the table? I can create a page using visual Interdev that displays the table only.
View Replies View RelatedI have two table : order and orderdetail. I want to update these tables which one order can have many orderdetail.
Can someone give reference how to do it ? I want to make sure all update process have to be success or cancel the process and give some error message.
I'm trying to do a real simple(ha) exercise in asp/sql and am struggling.
I've included my code below for a better idea, but here's my dilemma. There's an html-table on my page that shows the contents of my sql table.
I have 2 textfields used to store a first name and a last name into a sql table. I have a button that when clicked should store the data in the textfields into the sql table, and then the html table that is on the page should show the change.
What actually happens is that the contents of the textfields are saved in the database, but empty spaces show up on the website's html-table. If you try to add another user, the previous entry will then show up, and so on. The database is always correct, but the html-page is always one behind. Code:
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.
I am making backoffice manager for web-data based application. I am
looking for universal technics(best technics) how to update multiple rows in
backoffice.
One of solutions i found it is going through each row and update with new
content. I am afraid for using long connection time for this process in case
table has a lot of records. I think the best way should be one which takes
minimum time for that.
I have an access database already uploaded at online-server. It has two tables which I want to update on daily basis. The most updated tables are at my local computer. And updated data need to add in uploaded database file.
I have tried to drop the tables from online database (I am successful to do this) and then I need to run a sql query to select all data from locally saved updated-table and paste them to uploaded database file. But this second task is not accomplished. Code:
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 RelatedI am doing a project for my HND for a football league and i am at the point where so far everything is goin good but i need to update the League table. For those that dont know how a league table works here it is:
For a Win you get 3 points
A loss u get 0
a Draw u get 1
Any goals u score go into you 'Goals for'
And any scored against you go in your 'Goals against".
Basically i already have some ASP files where the administrator of the system types in the results for games played now i need to update this league table depending on the results. I want to execute something like this:
If HomeScore is greater than AwayScore Then Add 1 to the played field, add 1 to the Wins field, add 3 to the Points field and for the goals for and against i thought it may look something like this:
For = for + "HomeScore'
Against = Against + "AwayScore"
I have absolutely no idea how to do this, i dont know whether to use an Insert statement or an update Statement.
What i am trying to do is Update data in a table with data in another table but i want to update 2 fields in the destination table with data from 1 field in another table.
These are the table i have and their fields:
*CUPFirstRound* - Table1
GameId
GameDate
Home
Away
HomeScore
AwayScore
Winner
There are 8 rows in this table, thereofre the GameID's go from 1 to 8 Code:
I'm trying to insert either a & character or & into my Access table
However, when I do so the character disappears (looks like a space).
If I manually enter a & character into Access it works fine.
I'm guessing there's some way to force these types of characters into
Access.
im using some wysiwug editor called htmlarea to add some articles to the DB through textarea (something like that we use to add threads) but when the html code contains a link for example it gives error coz of the the ("") in the html tags .. it's something like this Code:
View Replies View RelatedI 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:
1) I build a Html Table dynamically (Header Row, and then 2 rows with data
All 2 rows have 2 cells: cell(0) contains a delete button (ASP Button),
cell(1) contains a HTML Text box
2) On Form Load and get some data from a dataset and then from it's contents
build the page
At this point the page is rendered and 2 rows are displayed. There is an Add
button that a user can click to add another row to the table. This works fine
and the row is added.
Now if the user clicks the delete button in row 2 the form is posted back, I
rebuild the page, and then in the click event for the delete button remove
the row from the table and the dataset. All appears to be fine at this point.
Now if the user clicks the add button again another row is added, but this
time row 2's textbox has the wrong value. It appears to be related to the
view state. I think the view state somehow is not getting cleared when the
row is removed.
I need to populate a field with html formated text. I'm using a simple form field to do so.
When I use a textarea to return the record, it comes out formatted, but when I use a Response.Write command, it comes out as plain text. Anyone can tell me how to make the response.write publish formated text?
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.
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.
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
Can someone explain to me or give me an example of how I would insert a row into an html table.
I will explain more so you understand what I am talking about.
I'm a newbie working on a dynamic website using asp.
I want to insert records dynamically. There is a command button insert when this is selected I would like a row added to my html table so the administrator can add his records.
The records will also be automatically updated to the original mysql table.
How would I add this row to my html table when the insert button is selected
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies View RelatedOn the first ASP page I have a form (checkbox) with 20+ different categories. After the user clicks on a few of them, they all have to be transfered on the second ASP page in HTML table. My problem:
If user selects only three categories, they should represent themselves in three differenst columns in my html table(something like Column-Name). If he selects 4, - four differesnt columns in the same table, etc.
So the table has to be 'dynamic'. It should have the same number of categories that the user selected on the first page. Could it be done? After that I should populate every category from a recordset and I know now how to do that.