Inserting Data
I'm wondering if it's possible to create an instance of an ADO Recordset and add values to it by ASP ??
Ex :
I have 2 arrays :
arr1 = Array(1,"allo")
arr2 = Array(2,"bonjour")
Is it possible to add these 2 arrays into a Recordset to manipulate de data more easily?
If yes, could you provide me with a little example to see the synthax, because I tried almost everything and it didn't worked at all
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Before Inserting Data
I am trying to make a web-based front-end for one of our programs. I'm running into a problem. Here's a sample of one of our tables: Code: CaseNo ChargeCount ArrestCharge FiledCharge 123 1 13 13 123 2 14 14 199 1 03 03 The ChageCount column cannot have nulls and must be unique. is there a way when I'm adding a new charge, i can check to see if a chargecount exists? For example, if inserting a new record, it will first check if there is a chargecount, if there is not, it will make it 1. if there is a charge count, it will +1 to the existing chargecount
Error While Inserting Data
I'm currently tring to insert data into an access db using asp. I have a form which is found in a popup window and which contains the fields Name and Comment. When I click on the Submit button,I call a javascript function in order to redirect the user to the page that will save the name and comment. However,I am having an error like this:Field 'VoicesComment.Name' cannot be a zero-length string. The problem is that the value from the previous page in the popup window is not retrieved. I have tried retrieving the name entered and the page does not return anything. The code for the page that is supposed to save data is as follows: Code:
Data Inserting Issue
I have a website written in ASP with an MSSQL2000 backend. Recently I moved off of Windows 2000 Server running IIS5 to a Windows2003 Server running IIS6 with SP3. I transfered my sites data over an all is peachy except I cannot add any new data through the gui. I can edit existing data and delete existing data, but adding is a no go.
Inserting Data Into A Database
I'm having a probelm with inserting data into a database using asp but I can't see what i'm doing wrong. I get the page cannot be displayed error. Code:
Inserting Data :: The_connection_cannot_be_used_to_perform_this_operation
The code below is suppose to check to see if an order for a particular user already exist for that day. If it doesn't then it creates a new order number in the webordernum table and inserts the items requested into the weborderlist table. It the ordernum however does exist, it just adds the item to the list.... it gives me an error that reads: The_connection_cannot_be_used_to_perform_this_oper ation._It_is_either_closed_or_invalid_in_this_cont ext Line 14 (the rs.open line) Code: ....
Inserting Data Into A Database
I want to know how to search a database if a particular data is contained in it and then if the data is not there the page should go ahead to insert the data into the database and then redirect the user to another page but if the data is alraedy there it should go ahead a query another table where the user infomation where also stored.
Inserting Into DB When Data Contains Quotes
I have a form that inserts data into a database...wow, big surprise there, huh? Anywho, my problem is when a user types a word like can't or won't etc.. The single quote obviously throws off the SQL string. I looked through the forums to see if anyone else had similar problems and I found one. It was suggested to use a replace method upon inserting and then reversing that when reading data from the database. Code:
Blank Data Is Inserting In Db
i am creating a dynamic protofolio page in asp. in that page admin will fill up all the fields . i am giving u the html code here Code:
Inserting Data Into Sql Server
i am trying to insert utf-8 data into ms-sql server using asp. i created an input box from where other charater (like chinese,japnese) will be inputed and should store it in sql server.and it is inserting it as some junk characters in sql server. but When i tried to display it in browser it is not displaying properly. in asp page i wrote this session.codepage = 65001 response.charset = "utf-8" ' INserting goes here
Inserting Data From Sub Form
how can i insert data from a sub form to the fields in the parent form. I am currently to do a search from at the parent form by poping out a new form. When i got the search result, i will need to click on the selected search result and populate into the parent form fields without any refreshing process as it might reset my form.
Inserting Data/time To An Access Db
i have an access db with a "date/time" data type with a format of "Long format"; i want to add the date/time automatically in DB when a user submit a form. i tried using the xdate = formatdatetime("var",1) and putting that var in the DB, but i get an error can someone show me how to do it right?
Inserting Data Into Bit Field In An Sql Database
I have an ASP variable called IRNvar: If IRNvar(0,num) = "True" then IRNvar(0,num) = 1 else IRNvar(0,num) = 0 end if In my sql database I have a True/False field called VariantFlag which is a bit data type. The IRNvar value is numeric. I am trying to insert the 1 or 0 into the database so that the field shows true or false accordingly but I get a 'Type Mismatch' error. Here's the insert statement: SQL = "INSERT INTO Documents (CNID, DocumentPrefix, DocCategory, DocumentName, VariantFlag, PartNo, PartDesc, NewIssue, StatusID) VALUES ('" & CNID & "', '" & IRNprefix & "', '" & IRNcat & "', '" & IRNnumber & "', " & IRNvar & ", '" & PartNum & "', '" & IRNDesc(0,num) & "', 'A', '5')" Is there a way to convert the number to the right data type? Am I doing something wrong? I'm quite new to all this so it's probably something silly.
Inserting Data Into A Database Table
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:
Error Inserting Form Data Into Database
I am trying to insert data from a form into a database and i am getting the following error: Microsoft JET Database Engine error '80004005' Operation must use an updateable query. The code that i used can be seen below: Code:
Inserting Arabic Data Into Access Database
I am trying to save arabic data from asp and it's not being saved with right encoding. i tried with both code pages 1252 and 1256. each time i am getting different set of characters in db, but not as i am entering in asp page. when i retrieve arabic data from database and display in web pages it's showing correct text. i am using following code in asp side: ....
Call Store Procedure For Inserting Data
I am just wodering in asp program, if there is anybody writing store procedure for inserting data into database since there are so many parameters need to be passed into store procedure(assume there are many columns in the table). I need to insert data into two separate tables, the relation between these two tables is 1 row of data in table1 could have multiple rows in table2 related to table1, but if the data insertion into any one of the tables is failed, the transaction will roll back and no data will be remained in any of the tables. If this needs to be handled in asp program using transact sql, how do I implement it. If I need to it using store procedure, how do I pass the error or success signal to asp program from database.
Inserting Dynamic Text Box Data Into A Database
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.
Inserting Data To SQL Database And Sending Email At The Same Time?
I’m attempting to insert some basic information (name, address, details) to the sql database and send a notification email (at the same time). Right now, I can insert the information to the DB after I click submit, but how can I also receive an email? Please give some ideas how to do it.
Validating An Uploaded File Before Inserting Data In To Database
I am uploading a file using ASP code. After the user uploads the file, I would like to be able to open the file and check if the data is in a given format (comma separated) and also has all the data elements needed (i.e. all fields are there). Is there a parse routine in asp that would allow me to do this. The user can upload any type of file as long as I am able to parse it and determine if the data is of the aforemention type.
VBasic Text Field (phone Number) Calculating Data Before Inserting Into Access
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
ASP Inserting (')
There i seem to be having a problem when inserting certain characters into my access database using a form, mainly (') characters.
Inserting Into
I get the following error message Microsoft VBScript compilation error '800a03ee' Expected ')' /weblinkup/chat.asp, line 1775 oConn.Execute("INSERT into chat (username,nametext,roomname,type,priv,thetime,msg) VALUES ('" & username & "', '" & username & "', '" & Roomname & "', 'msg', '0', '" & now() & "', '" & username & " has just said " & emotetarget & "." ')") what the problem is with the code?
Bulk Inserting
I have an error as follows: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert. File 'c:mydata.csv' does not exist. My mydata.csv file is inside the directory i stated. But why does the server complains that the file is not fould? My codings: strSQL = "BULK INSERT NAME FROM 'c:mydata.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR = ' ')" Response.Write ("test") Set oRS = conn.Execute(strSQL)
Inserting Database
I had some Error when i write the update sqlp query Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /fyp/Quiz/updateQuiz.asp, line 21, column 77 SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")" Code: SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
Inserting Smilies
how do i design my site interface such that users can insert smilies along with text in the form field just like it is here on sitepoint...
Inserting Record
i've tested my code and it seems to send back an error, when i'm trying to insert a record into my db (sql server) Basically when I udpate one of the records it's fine ( I update at a certain "productID") But when I insert a new record it sends back an error telling me that my "productID" can't be a null value?Any ideas on how to fix this?
Inserting Apostrophes Into DB?
When I insert info into a DB from a form, it cuts the string off at the first apostrophe ("). How would I make it insert the data as-is, with the apostrophes? Here is the code used to insert the Data:
Inserting And Downloading
I am developing web pages , therein doing database connectivity using ASP with Microsoft Access.I want to insert a file (.opt/.pmopt) into a field 'OLE Object'. Also I want to display that file name in tabular form and a link to download that file.
Inserting Characters
Im doing a update page and noticed this error, whenever you want to write for example "can't, i've" it errors on submit, but characters like "." are okay. Why doesn't it like these characters and how can i make it like them? I need some extra code?
Inserting Into A Database
I have the folllowing page where a user can add a review to the website. So far the page works fine, but on the review rating section I know that the rating is between 0 - 5. But its posible for a user to enter 1000 if they wished, which still means the page works but the answer is too high. Also if they write text in the field it errors the page. How do i code this so that they can only enter a number between 0 and 5 and only a number and not text.
Inserting Link
I want to make a button just like here (when posting new thread) to insert hyperlink into text. For example when user is typing text into textarea I would like to have also a button that can enable users to post different links to other intenet pages. And I would also like to have button that makes the text bold (Actually those are buttons that appear on most forums when posting a new thread)
Problem In Inserting
I got a webpage in which I am cheking various checkbox values.Actually the problem that I am facing is that,I am not able to insert the contents in to the database. But no error is coming.What I am doing is that,when the user submits the form,using a retrun querystring,i am storing all the checked values in to an array.I am able to print this array with correct output.But whn i am trying to insert in to the database,it is not getting inserted.
Inserting Into A Table
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:
Inserting A Zero In A Table
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.
Inserting New Records To DB
I have created an online database for a school project, and everything WAS going fine until today. I created the add record page and for some reason, whenever i try to add the records to the database THIS error message comes up: Code:
Inserting Into A Databse
I have successfully pulled data from an LDAP server and now what I want to do is drop the data into a database table. The following is my code that will insert the data but that has problems.
Inserting A Date
I have a form that I submit to an oracle database. Along with the info from the form I want to insert the date it was submitted. How should I go about doing this? I am having problems because it is the wrong format? I am using a 'date' data type for the field. How can I convert the date into the correct format that will allow me to submit it, I have tried using to_char or to_date, but they give me an error?I tried using this to convert it, but it doesn't work, I am getting a syntax error?submit_date=to_date(date,'YYYY-MM-DD')
Inserting Records
what the best way to update a ms access database from an asp page is.I have a db with 3 different tables,these tables are bound to each other via the relationships. On my asp page,I want to create one page where the user would enter in information and hit submit.The problem I have though is that how do I have only one button that will update information from 3 or more tables all at once?
Inserting Record
I am trying to insert a record into an access database, to just one table, using an insert form created from dreamweaver.However when i open the page, enter the details and click submit, it re-directs me back to the same page, rather than the confirm one. The weird thing is, i created an identical page for to insert a record into another table in same database and it works fine. There is also a problem when trying to update/delete a record from the same table.
Inserting Character
How do I insert a space after every 4th character in a string?I'm presuming I somehow use the replace function?
Inserting NULL Value
How to do subj ?I tried: date1=NULL strSQL = "INSERT t (mydate) VALUES("&date1&")" i tried with ' ' and without, tried "''", i tried allmost all variations &because i cant put NULL, i have error in my main strSQL.
Inserting Date
i m reading data from a excel file and inserting its fields into access database, everything is fine but i m getting problem when i m insertin the data string into the date/time field of the aceess database,i have use the CDate function but it is not working.what should i do?
Inserting Asp To Other Page
is there a way to run an ASP script from an html page?the script is obviously written on an ASP page elsewhere but I want it run from HTML or SHTML.so they dont figure out the URL of my ASP page.
Inserting Text
I have encountered a problem when a user submits text which contains commas and quotation marks. Code: Function ChkString(string) If string = "" Then string = " " ChkString = Replace(string, "'", "''") End Function I am currently using the above code, but what i have realised is that i am losing whole text that does not get entered into the database, when i wrap commas and quotes around it.
Inserting XML Elements
I am aware of how to create elements, attributes on the fly with the Microsoft.XMLDOM however I was wondering if anyone had any examples of how you could extend this to insert the content created in to an existing node. Eg <root> <section> <- INSERT ELEMENT HERE -> </section </root>
Inserting New Record
I'm trying to create a form on an ASP web page which will contain information on students and I'm working in Macromedia Dreamweaver MX. When the user wants to insert a new record and when he opens the web page to do so the form should automatically show a new Incident Report Number. When inserting a new record For example: If the last record that was entered had an Incident No 13, the form must show number 14 by itself for the Incident Number field and the user should be able to enter the rest of the information of the student.
Inserting More Than One Records
I am working on a project, and now I am experiencing a problem to insert multiple records at a time. My form is designed so that a user can insert multiple input (in several text fields). What is the best strategy to handle this? the number of fields are created randomly (I will use innerHTML in Javascript to present text field randomly on my form). I have tried to use google using the following keyword: "inserting multiple records using ASP", but the result page did not satisfy me.
|
TRACKER
