I have a quick question regarding a text field for inserting record, I have a page which inserts various fields including area code an phone number for a new record, however I am curious if there is a way that I can either make the area code appear with brackets around it in the text field which is sent so that the user does not have to type it in each time.
I was thinking I could concantenate the value i send in each time with brackets but am not sure what the syntax would b for this. or perhaps there is another way of doing this?
I have a table (MSSQL 2000 server) with a column called "Content" whose datatype is text. Now I'm trying to insert data into the table using a stored procedure. What is the ADO constant that I should use to insert value into that column? Code:
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?
am trying to get my ASP page to write session variables into an Access database. However I'm getting error messages. I'm not sure if I used the right syntax (using double " for example) Can anyone see a problem:
ive created a database using access, and ive successfully created a ole db connection to a webpage using dreamweaver. i can view records without any problems but when i try to add a record tothe database from a webpage form i get the following error msg
Microsoft JET Database Engine (0x80040E14) Syntax error in INSERT INTO statement. /guitarguide/guestbook.asp, line 115,
the field names in the database table start with txt_ e.g. txt_name, txt_email etc.
need to retrieve a record from a table (tblBookingForm) in one database and insert it into a table (tblNetServ) in another database on the same server,leaving the original record in place.Cant get my head round it though, doesn't seem to want to connect to 2 databases at the same time.
I want to submit a record to my db via a simple form but return the user to the same page upon submission ie place a form on index.asp and the form action="index.asp".
My logic isn't quite right, can someone guide me in the right direction? This is what I have, upon submitting the details the page just reloads and the record is not inserted.
<form method="post" action="index.asp">Name<br><input type="text" name="Name" id="name"><br>Email<br><input type="text" name="Email" id="email"><br><input type="submit" name="submit" value="submit"></form> <% If Request.Form("submit") = "submit" then call MailList End If %>
I am inserting a record into a table to hold information about photos and what to create a folder with the same name as the primary key value of the inserted record. Eg if I have a table (tblAlbum) with two fields (albumID, albumName) and run an insert statement 'INSERT INTO tblAlbum (albumName) VALUES ('test album')`.
I want to then create a folder with the new value for albumID. How do I retrieve this new value just created?
I am using Dreamweaver to create the insert record code for an access database. When it adds the code, I can not see the page on the website. If I remove the code the page works fine. I'm not sure what is going on?
i have an access database that has an autonumber as the keyfield. how do i add a record with the autonumber left out so it is put in automatically by the database. i have this at present as my sql statement but dont know what to put in for the autonumber:
Just a quick question more about the flow of an asp page. IF I have code as below: -
MyDBConnection.Execute "Insert Record Into A Table" MyRecordset.Open "Retreive the same record from the table"
Is there any chance that the connection process (Inserting the record) will not have completed by the time I try to retrieve the record. I.E. will the asp page wait for the insert to complete before continuing to open it (the next command in the page).
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
I want to insert a record into a DB and then immediately recall what the ID is. I have heard that there is a way to do this with SQL Server (although I haven't done it yet). Unfortunately this is for Access.
I've done some workarounds for this in the past but want to know if there are better ways. What I've done in the past is to recall the file name or something from the FORM collection against the DB (assuming this file is unique).
Using aspupload, if the overwrite attribute is set for FALSE I can use that as a way to better ensure the file name is unique as it renames the file if it is not unique. The problem is I need to to this without aspupload now.
I had thought of recalling the last record ID from the DB on the FORM side and putting it in a hidden field but this seems risky. Any suggestions?
I have to compare 2 tables: orderA and orderB, if the record exists in both table orderB and orderA, just do a update to the quantity field in orderB (add orderA.quantity to orderB.quantity). Otherwise a new record has to be insert into orderB.
Do I have to loop through the recordset of orderB, then use select statement to see whether the record exists in orderA or not, and determine whether to update/insert record? I am using Access database. I just afraid that looping through each record in recordset (maybe >=30 record each time) would make the transaction getting slow (or even hang??). Can I do this in one SQL statement?
Can someone point me in the right direction on this? There are 3 fields in the DB: model, rma, bagqty. If the values on a certain row are I530, 1108, 50 and a user goes to input the same data I dont want the insert to be allowed and force a new insert.
I dont need someone to do this for nor do I want that, just need a push in the right direction.
I have a database in which I have to on a daily basis enter the information for that day. I would like to update this on a bi-hourly basis to prevent any possible data loss.
Using INSERT INTO, I create a new table line. Using UPDATE, I get an error on the inital creation of the table line.I am really unsure how to check to see if that line exists or if there is an easier way around this.
Is it possible to use CDONTS to send an email and INSERT a record to a database, once a form has been submitted. They work individually but I cant get the scripts to work together.
I'm having a trouble to insert data into the database. I can't understand what do I do wrong. I've got 2 pages , one is html with user registration form and another one is asp with the following code:
A page displays the Product literature that a customer can request to receive by postal mail by clicking a check box. The literature selections are created by a dynamic record set based upon what the company enters into the Literature table (currently 10 selections). The checkbox form tags are:
LiteratureID is the Access autonumber primary key field. I can use the LiteratureName in the "name" attribute if it is easier.
The form processing page needs to Insert each selection into its own record in another table. This "requested" table also inserts the database ID for the customer that is created after first inserting the customer contact info. In other words the "requested" table needs to record the customer autonumbered db ID and each selected checkbox value.
when I try to save this text with "&" character , it saves only the first part of the text , for example : aaa&bbb , the result is only aaa . realy dont know how to solve it .
I was performing some testing on my forms and in the comments section of the form, I copied and pasted a large amount of text. All of the text appeared on my confirmation page that I have that shows all of the submitted information. Once I hit submit on the confirm page so that the INSERT will occur, only about 1/4 of the text that was entered shows up on my "Submission Confirmation" page.
The text insert appears in the database, but only the 1/4 of the text that was entered. I'm using the "text" datatype and the length is set to 16. Can anyone think of why only a portion of my text is being displayed and then inserted into the table?
On the webpage, I want to display like this: I use Response.write objRS("FieldName") to display the value of a record .I guess a number of chars is allowed to display a part of record.
I am trying to create an application feature for an inventory database and I am wondering about the most efficient way to process the updates. Here's the background information: Code:
vMessageText = "This is a test just to see if it will blow up on a large comment. Just testing again. Don't mind me."
Can I put this into my database field or is it too much and if not, how do I solve this issue. I need to be able to post messages and input for large fields.
I am relatively new to ASP but am fairly familiar with PHP and ASP.NET and JavaScript.
My problem is this:
I have a drop down box which is populated from the database (Access), it sets the value to the ID of a hospital ward, and the text to the name of the ward.
I then use the ID to look up an email address for the manager of the ward from another table in the database. My un-optimised code is as follows: Code:
I'm using DreamWeaver MX 2004. I'm wondering is there a way to have 2 (or 3) submit buttons in the one form, each one to insert the record & then redirect to different pages, depending on which button is clicked?
I'm thinking about submitting all forms to one page & have that redirect based on a URL/ Form parameter. Just curious as to other methods.