Multiple Record Inserts

currently working on an app that lets users register their career history details with us.The form that captures data has 7 fields which are repeated four times. i.e. the user can enter up to four past employers, four job titles etc. Currently there are four instances of each field which all share the same name (four fields named Employer, four fields named Jobtitle etc...).

I'm guessing the best way to write all the info back to the Database is to split the form data into an array and then use a Looping or For i = 0 to whatever..... type structure but i can't figure out how it should be done or if this is even the right way to do it.

View Replies


ADVERTISEMENT

Multiple Insert Record

i want to insert some records to Access Database using the checkbox.i've try all the example i've found but it does't work.it's like checking our yahoomail.but i want all the tick checkbox insert to database

View Replies View Related

Multiple Record Delete

I have written an events diary for a client .. and they wish to have a system of multiple deletes so they simply use a check box to select the items to delete and then hit a button to remove the selected records form the database. as all iget is scripting errors. Is there a simple way to do this?

Someone advised me to use an IN statement to Delete multiple records, but all I get is :

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID In ()'.

I have followed several different tutorials but I get the same outcome! It doesn't seem to like the IN statement.... any ideas anyone ???

View Replies View Related

Multiple Record Insert

I am trying to insert multiple records into Access DB from a form. Code:

View Replies View Related

Execute Two Inserts

How do I execute two consecutive insert statements against an oracle database here is the insert that was result of a response.write ...

View Replies View Related

How To Retrieve Multiple Images For A Record

In my Access database I have multiple images for some of the records. What is the best way to retrieve and display the multiple images. I am storing the images in a folder and only the path in the DB. Some of them have just 1 image, some 2, some 3 and so on. I have the record ID # and the image name same, for eg. if the record id is R01 then the image name would be R01.jpg if there is only 1 image otherwise R01a.jpg, R01b.jpg, R01c.jpg etc. Is there any way I can open the folder and check for the name and list the image file names as a link to display the images if the ID name and image name matches.

View Replies View Related

Submitting Multiple Record IDs Via A Form.

We have a facility on our intranet where users can log problems, comments &
suggestions about the site to a DB.

I'm building a page that lists the outstanding entries, and allows use to
mark any number of entries as being 'done'

That is, we have a number of rows, with the last field in each row being a
checkbox to indicate the entry has been dealt with. At the end, there is an
Update button which submits the form.

The question is.. how to handle this...?

The best solution I have thought of so far is to use the record ID as the ID
for each checkbox. Then to Split() the resulting Request.Form into an array,
loop through the array picking out the record IDs.

It's not a bad solution, but I figured this must be a fairly common
procedure and that somebody might have a slicker way of doing it...

View Replies View Related

Inserts HTML Line Breaks

If i'am writing a post in a "textarea" and i use the ENTER (newline) on my keyboard it comes as a line break <br> in my post on the forum.PHP uses "nl2br", but what is the ASP solution for this?

View Replies View Related

Inserts HTML Line Breaks

I have some text in my database with paragraphs in it.When I display that info from the database on my website using asp, it shows with out the paragraphs.Is there a function that will Inserts HTML line breaks before all newlines in a string?

View Replies View Related

Use Value In Query String To Produce Multiple Record Sets

I have taken over a website that was done in Frontpage and I am trying to move away from it. I am having problems with page 1 where I have a link that passes a single value to page 2 in the query string.

On page 2 I want to use that value in the query string to produce mulitple record sets. This actually works when using the fpblib.inc. Is there a way of doing this without having to use Frontpage coding.

View Replies View Related

Parses And Excel File And Inserts The Data In An Access Table

I have created a script that parses and excel file and inserts the data in an Access table. The script works perfectly fine, however I also need to extract a column comments via my script.Column comment is like a tool tip for any given column and therefore it occurs only on mouse hover, not in the actual column data.

View Replies View Related

0x80004005 Error, Cannot Add Or Change A Record Because A Related Record Is...

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:

View Replies View Related

Insert Record Goto Last Record

I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?

View Replies View Related

Record Numbers Against Record Problem...

I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.

Ship Date: 04/06/04

Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx

Ship Date: 11/07/04

Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx

What I want is:

Ship Date: 04/06/04

1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx

Ship Date: 11/07/04

1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx

How can I get these numbers printed againsts the records ?

View Replies View Related

SQL Server - Update/Insert Multiple Cols Into Multiple Tables

Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.

I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.

If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.

View Replies View Related

Searching Multiple Memo Fields In Multiple Tables In Access

I have a search option on my website, which should perform a search on 4 fields, as follows:

tblNews
headline
content

tblDatabank
filename
description

It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.

I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?

View Replies View Related

How To Update Multiple Records With Different Multiple Value

i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.

based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.

View Replies View Related

Record Set

I want to download record set from my SQL database as csv format but in ZIP file .I can download as a csv file now ..But i can't put that in zip file and download.

View Replies View Related

Record

how to deal with multiple recordsets on the same page?
It's gotta be something small and clear so I could understand.
Somewhere I've read that multiple recordsets are not allowed when using Microsoft Access Database?

View Replies View Related

Set Record

I am looking to
have some sort of SQL Trigger maybe? I have a field called 'dateActivated' and 'isActive'I'm looking to somehow say when dateActivated + 6 months then set isActive = false. I want this to
be automatic. I am using ASP/VBScript if this somehow matters.

View Replies View Related

Add More Than 1 Record At Once ?

I have a form on an asp page which is used to add additional users to
the DB, i.e. adding a UserID (PK on table), Password & Email.

The companies are allowed a max of 3 users. If the company only has
the default 1 user and wishes to add another 1 or 2, then the form
displays the current user details, not in text boxes as this is not an
adit data form. The additional user/s can be entered into 1/2 rows of
text boxes, user 2 & 3.

If they decide to add 2 new users, how do I add the additional 2
records to my db table on submit ? Code:

View Replies View Related

Record Set

i am tryin to run a search on a db and am using a like statement which works fine but i want to select what it finds and also the next 9 records any idea on how to do this

View Replies View Related

Second Last Record?

Is there any way to change the following code so that when it's the second last record in the set it doesn't put UNION ALL at the end? Basically, is there a way of saying:

if SecondLastRecord then

I don't know how many records there will be, so I can't count down from 7 or anything.

Code:

View Replies View Related

Add New Record From Asp To Sql

Every time I try to ADD a new record from my asp page to SQL table, I got this error:

Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_Cancelled_Classes'. Cannot insert duplicate key in object 'Cancelled_Classes'

Here is the Insert statement:

Sql="INSERT INTO Cancelled_Classes (yrtr, cou_id, cancell_date, Message)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("yrtr") & "'," sql=sql & "'" & Request.Form("cou_id") & "'," sql=sql & "'" & Request.Form("cancell_date") & "'," sql=sql & "'" & Request.Form("note") & "')" '

conData.Execute sql

View Replies View Related

Record Set

I had a problem that happen once only but i do not want it to repeat
again. It happen when i retrieve data from my database. The process
can't complete and show error 14, Out of string space. I suspect the
recordset object had reach it limit that why it generate that error
message but what can i do to prevent this from happening

View Replies View Related

Add New Record

I have a siple script where I add a new row in a table which has also a autonumber field. Adding the new row I am trying to get this value of the autonumber field and put it in session, but can not seem to figure out how. I tryed to open a new recordset and pull it out but does not find the record I just added.

View Replies View Related

Record Set In My Sql

The only database connection I have ever made using ASP is to an SQL2000 Server. I was just wondering if someone could provide me with a nice simple script opening a connection and recordset to a MySQL database and providing a valid connection string.

View Replies View Related

Add Record

Trying to learn a little asp and am trying to have my form (when the submit button is pressed) put the value in a field in my database. it worked the first time, I typed in the word testing and clicked submit.

now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here. Code:

If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If

View Replies View Related

Record Is The First In A Record Set

I'm looping through a record set and want to treat the first record differently. I've got a counter that I check to determine if its the first iteration through the loop, but I was wondering if there is recordset property that would indicate the record's position in the record set.

View Replies View Related

Get Record From Db

now i got all my data in my sql db table (fsearch) . now i want to take the value from the db to display it on the browser in the form of a table .

View Replies View Related

Using Record Set Twice

i need to use the same record set in my page twice. some optimization issue [img]images/smilies/biggrin.gif[/img][img]images/smilies/biggrin.gif[/img]. i have arecord set like this

Code:

set newsrs=createOBject("ADODB.recordSet" )
newsrs.Open newssql,cnn,3,3
and i wanna use this twice in the same page
Code:
do while not newsrs.eof
newsrs.movenext
loop
can any body tell me how? coz when i do it the second isnot working [img]images/smilies/rolleyes.gif[/img]

View Replies View Related

Using One Value From A Record Set

I run a query like

SQLSelect ="Select Number,Type,Description,Retainage_Percent from table_name1"

this returns a value for number. then I would like to run another query on another db

SQLSelect2 ="Select Number, Text from table_name2 where table_name2.Number = table_name1.Number

View Replies View Related

Can't Add Different Record

I didnt know what to title this, so please bear with me. Trying to learn a little asp and am trying to have my form when the submit button is pressed put the value in a field in my database.

it worked the first time, I typed in the word testing and clicked submit. now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here.

Code:

If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved