I am currently developing a coursework for uni that involves inserting some values into a Access database. I know how to do this, however I am trying to use different insert statements to insert data into different tables, however all the input field are on the same page. Code:
View RepliesI have a database class that I've been starting to use with my ASP apps and I was wondering about having too many database connections on one page. I'm beginning to write other classes that use the database class to reach into a table and pull data out.
Say for instance I have these classes:
Database
Users
News
Reviews
All of these classes have a method like getUserByID() or getNewsByID() but they are all using a private database object from the Database class.
Are they all using the same connection behind the scenes (underneath ASP) or are they all actually using separate connections? And if in fact they are using different connections then is there a common design patterns that alleviates the pressure by passing around the same DB object?
It makes me a bit uncomfortable to know that every class is creating a new Database object and a new connection on top of that; however, if you were pulling data from a MS SQL database for the users and an Access (ugh) database for the Reviews this would be necessary.
On everyone of my pages I have an a include page at the top and at the bottom of the page
one is the database connection and one is for the database disconnection.
is there anyway I can automaticly connected to the database using a string without adding it to every page ?
I checked in IIS and I can add a footer but not a header, or anyway using global.asa file
Is there a function or a script that I can use to monitor the connections to my SQL database. I want to see if any of my connection objects aren't closed (I have many ASP files and it's easy to forget to code something like this: PHP Code:
MyConn.Close
set MyConn = nothing
What happens if a connection wasn't closed?
I have a question on DB Connection. My ASP requires me to create 2 DB connections to 2 different database.
2004.mdb & Information.mdb. In this 2004.mdb, I have 12 tables(tbl1,tbl2...tbl12).
And in Information.mdb, I have a table called t_information. This table houses all the names of tables from 2004.mdb.
In my ASP page, there is a drop down list. As you can guess, this drop down list retrieves the values from table t_information that resides in Information.mdb.
When I select the table that I want to display & click the submit button, I will have to create connection to this 2004.mdb that has all the tables(tbl1..tbl12) and display the selected table. Am I right? So, to achieve the displaying of the selected data, I have to create connection to both 2004.mdb & Information.mdb right? Is that possible? I mean, can I really create/establish these 2 database connections on the same ASP page?
I really need advices on this people. Do hope to see replies here. And I understand that we can TableDef in Access? Can anyone explain to me what does TableDef do? And how to go about creating it?
Wondering about best practices as regarding database connections and usage (MS SQL). Was building a class to contain all of the methods and suddenly wondered if this was the best way? Using a sledgehammer to crack a walnut etc.... Code:
View Replies View RelatedI 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" + "'")"
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.
I have a problem with inserting the results of which radio button was selected into a database. I have the code for the text fields down with no problems. I guess my question is how to populate the yes/no fields in the access database.
View Replies View RelatedI am having trouble with someone else's code that worked when it was used last, but now it's not. I am new to ASP programming so I not too sure what's happening. Code:
View Replies View RelatedI have a table in access that contains to primary keys, they are both defined as numbers and I want to insert data into them in ASP:
I've tried a couple of statements as follows:
strADDIDQuery = "INSERT INTO [Jnct LP Obj] (LessonPlanID, ObjectivesID)VALUES " & strLessonPlanID , & strObjID
This tells me that an end of statement is expected:
and this:
strADDIDQuery = "INSERT INTO [Jnct LP Obj] (LessonPlanID, ObjectivesID)VALUES " & strLessonPlanID & "','" & strObjID & "')"
just doesn't work (page cannot be displayed)I'm sure it's a sytnax problem, something to do with integers? but I've searched loads of sites and can't find any that are using simliar code:
The values are pulled from a form as follows:
strLessonPlanID = cInt(request.Form("LPID"))
strObjID = cInt(request.Form("OBJID"))
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?
I have a page setup where a user can login and add news to a site.
I had to write a small function to eliminate any apostrophies or dashes in the SQL insert statemnet to prevent any errors or confusion.
My question is, is there an easier way to do this? ....
I have simple form that sends data to an access database. The action is listed below. Am i missing a connector somewhere? Code:
View Replies View RelatedAnyone there can help suggest to me where i can find out more about Inserting image into a database.
View Replies View RelatedI want to insert multiple records in my SQL database. I was wondering if this is the right way to do it: PHP Code:
set insertRecords = Server.CreateObject("ADODB.Recordset")
insertRecords.ActiveConnection = mlConn
For i = 0 To 5
insertRecords.Source = "INSERT INTO Info (Name, Age) VALUES (" & getName & ", 20)"
insertRecords.Open()
Next
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.
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 have a ASP/vbscript program that generates random passwords. The problem is I need to insert those passwords into an Access database of 327 clients. I have the random password program generating the 327 passwords, but have had no luck inserting them. Code:
View Replies View RelatedMy question is this: how do I get a value from a listbox to assign to a variable (elementary I know)? Code:
View Replies View RelatedI'm trying to put some text into the database using ADODB.Command object. Seems like a reasonable thing to do and I can do it. But in this instance my text is an HTML code which contains many quotes. But i have to save it as is into the database field.
I use:
INSERT INTO (f1, f2) VALUES (v1, v2) comand. But since my v2 contains some quotes in it, (many quotes), I get an error. (it works otherwise). Is there any way ?
I would like to know if there are any tutorials out there or websites that can explain more about this? can this be done in asp?
View Replies View RelatedI am struggling to store an image path to a mysql database and in the process copy the image from one folder to the folder I would like it to be copied to.
My code for the inserting the image path and data into the mysql db is below: ....
I made a 2 web surveys with identical code. Although the code is similar in both, values on the last page of one of the survey do not go in the database.
I have tried playing around (coz I really dont understand what the problem is), but nothing works. The same code works on the other survey with absolutely no problems.All thats there in my survey to insert values is
.Fields ("fieldname") = Request.value ("name of text box")
.update
Any suggestions? If someones willing to help me out quick, I will post my code.
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:
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: ....
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 Replies View RelatedDoes 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.
View Replies View Relatedhow to do a dnsless connection to an access database and then insert records. The database name is members and table name is member_info.
View Replies View RelatedI’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.
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.
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 ....
View Replies View Relatedhow to replace carriage return upon extracting text from Access file.
However I think it will be smarter to do it before (during) inserting text into acess file.
It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.
QUESTION:
What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code: