ASP Accessing Databases
Can ASP Apps read from a mySQL database?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Using Databases With ASP
I'm learning ASP with a database in Access (new to Access also). I have created my tables and all but I'm stuck on how to query the table. I'm familiar with sql statements, so I was wondering if you can access the database the same way as with php and mysql. I.E. Code: Select * From Table Where id = 5. Something like that, or will I need to use Code: objRS.Filter "ID = 5" I guess the main question is does Access accept SQL statements and if so can you give me some examples as to querying the database.
ASP And SQL Databases
I am working on ASP and SQL Databases. I have written the code . the program is very simple . its just an application form and u will be having upload and submit button . So after the data is being entered , the submit button code should be invoked and the data entered should be stored in the database.
Asp And Databases
I'm having Difficulty understanding the concept of retreiving information from a database upon user request. E.g i have an ASp page that has a form with 3 drop down boxes and a submit button. I want the next page to bring results from the database that meet the criteria set upon by the 3 drop down boxes. The DB is Access and its already got the information in it, i just want the correct information to come up in tables once the user has selected the choices in the drop down boxes.
Checkboxes And Databases
The problem I have is that I need to save the content of a form in a database, and I donw know how to save the content of a checkbox, can you give me an example of the code?
Multiple Databases
I need script or a link to a tutorial that will allow me to do the following. User enters username and password site checks the username and password against database1 if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens. I am new to this forum and really looking forward to being involved in the community.
Searching Databases
I'm trying to design a simple website with 2 dynamic searching functions. The first is the user enters text into a search box, clicks on the search button and then connects to a sql or access database and brings back those records that are LIKE the search phrase. It's my intention to then have a detailsview link on the searches so the user can drill through.I'm designing an online version of my catalog so that the user can browse by page. I also want the user to enter a page number and then click go and that would then take the user to the corresponding page in the catalog. I'm guessing I'll need to declare If 1 then open page1.html, if 2 then open page2.html. I know I'm close but not close enough and my knowledge has been well and truly stretched and I must have read and read my Dummies book about 20 times over the last week.
Access Databases
For my ICT (computers) project at college I'm using an Access database, and I now have a problem with that. Basically the way it works is that the user enters their details in a form page (here). This then does the usual thing; runs a script which inputs the data into a database and then displays a thank you message. the problem I'm having is that whenever I input punctuation into the form, it refuses to work; it comes back with a 500 server error. This is understandably quite irritating, as I'm setting up a mailing list that needs to incorporate a list of email addresses
MySQL Databases
My hosting account gives me a lot of MySQL databases but I usually just stick with MS SQL Server because it gives me fewer troubles.Now I want to challenge MySQL again. I use connString "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver; DATABASE=mybase; UID=myID;PASSWORD=myPwd; OPTION=3" And the conn and recordset objects connects smoothly with the database. I can even get the things i want out of it. But every time I try to update the database such as: rs("Content")="Cool" rs.update 'or names=array("Content") values=("Cool") rs.update names, values It just wouldn't work...why? Content field is a text field.
ASP And Relational Databases
What i need to do is build 2 tables below with the following fields: tblUsers id name address postcode tblShop id product Now i need to build a relation between the two id fields but what i relaly need to know is how to retreve the data in the tblUsers from the id in the tblShop through asp. This is like for a shop
Multiple Databases
I'm trying to pull information from two different databases, use it, and then put it back into a database. The program I am writing is one which will keep track of exempt employees' absences. At the end of the year, employees get to rollover the sick days that they do not use. Herein lies the problem. The information on how many sick days an employee is in an AD download on one server. The information on how many days that employee has taken this year is on another. I need to take that information do a little math, and then add those days into a different table on the same server that the absences came off of to keep track of their "sick bank". I would like to just Loop the information, but I cannot put recordsets inside recordsets and I cannot create a view from two separate servers, so I am at a stop sign. Can I just take all of the users and the amout of sick days they have and put them in a text file and then pull off of the text file? I'm not quit sure how to do this.
Three Databases Tables
How do you go about searching three tables at the same time? I'm using Dreamweaver MX, but I can also hand code it in if know one knows the dreamweaver method
Querying From Two Databases?
Given if tables A and B are in the same database, writing a query for them is relatively easy. But what if tables A and B are in different databases? Is it possible to query them together? If so, can anyone provide a generic example?
ASP & MS Access Databases
I have a search page with an access database in the background. When you type in a keyword, it brings the related article up. Is it possible for this to display a hyperlink??? When i choose hyperlink in the access field it displays thefollowing on the screen: Code:
Dates And Databases
Inserting into an Access database using the above script generates this error : Microsoft JET Database Engine error '80040e07' Syntax error in date in query expression '#20031021 20:36#'. Using SQL : UsersTable SET UpdateTime=#"& dbDate(Now())&"# ..... If YYYYMMDD hh:mm:ss is a universal date, why is it rejecting it? If I change it to YYYY/MM/DD hh:mm:ss it then becomes valid. Is this valid in all situations, or am I doing something wrong in the first step?
Multiple Databases And ASP
I need script or a link to a tutorial that will allow me to do the following. User enters username and password site checks the username and password against database1 if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens. I am new to this forum and really looking forward to being involved in the community.
Classes With Databases
I'd like to create a class file for a shopping cart that I'm working on but I'm not sure about how to use the database with it. Do I connect and open to the database inside the class or outside of the class and set the properties? I'm thinking that if I open and close the database with say a getItem() method and I have 15 items to get, I'll be opening and closing a connection 15 times. Isn't that bad?
Apostrophes In Databases
I have an apostrophe in an access database in a name. e.g. O'Brien. When I read this value back into some script the apostrophe seems to be terminating my script.Unless of course I have mis-understood what's going on Are there any rulesguidelines for this sort of data handling
Databases With Webpages
I have a website, of which i have a website of which i update now and again, however, i want to be able to insert data into a database and not the page it self, so when a visitor navigates my site, it will generate the page from the database. And also i want to use an Access Database Is this possible, if so, how.I can use ASP (of course) and Php however have little knowledge of either, little bit of HTML, and some VB programming.
Checkboxes And Databases
I want to collect user input. I have a collection of 30 checkboxes that I would like the user to pickout from. The information then will be recorded to a database somehow. Finally the user will be allowed to change the selection if required.Which is the best way to do this. Do I need to create 30 different fields in the database ?
Interactivity With Databases
i have started a project. It is a multiplayer text based online game. so far what i have got is a log in page that fully works and a logout page that fully works. what i am stuck on is once you have logged in i want the user to see their own individual stats. but no matter how i try i have only been able to show the entire tabel's data not just certain fields out of that 1 record.
ChiliASP And Databases
Can Chili handle Microsoft databases? I inherited a site with ASP, but my host uses Chili and the site is generating errors.
Moving Databases
I don't know anything about the ASP language. One of my client's would like me to host their website, already created with ASP. Down the road, I need to re-design the site and convert the back-end to PHP. However, suggest the best method of moving the entire site to my Windows 2000 server?
Errors Using Databases
i get this error when posting info in a form Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /register.asp, line 141 Browser Type: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) Page: POST 295 bytes to /register.asp
Vb Script And Databases
I want to store the login and logout time of user. HOw can it is possible if some one closes the window without clicking the logout.
Searching Databases
In a search form how does one stop the form from running when a certain character is entered. Such as "%" also even if i add 5 of the characters. I have been to a few sites and this goes and gets all the records.
List Of Databases
I am writing an Active Server Page application that will get all of the databases that a user can access. Is there a way I can do this with Active Server Pages? I also will provide the users with the option to change records, table structure, etc with this application. I will also be developing an asp.net (C#) project that will do the same thing. If anyone can provide code snippets.
Editing Databases
I can get the data from my database to be displayed in a table, but how can i get the data to be displayed in a way that it can be edited? Can i populate a form from the database? If i can, how would i go about it please?
ASP Pages & Databases
how to create one for a website, I have at present setup an access database (although there isn't anything in it yet), hosted it on my windows server, and it's now active, what I need to do now is to create a form that will call specific data from it and display that information in an asp page. I know not everyone likes DreamweaverMX 2004 for creating asp pages but for now until I get a hang of it I wish to use it, I am creating my pages using the ASP VBScript template from Dreamweaver, I have created a database connection within it (I believe it works). I need a quick lesson on how to create the form, retrieve the specific data and publish it on an asp webpage, I have purposely left the database empty for this lesson, another reason for leaving this database empty is because I have access to a ASP.Net Enterprice Manager through the ISP, there are many fields on this that I don't understand so if anyone knows how to fully use this it would be appreciated.
Arrays And Databases
I have an array and I need to be able to split the results into groups of 3 and insert into my database. The groups of three are user records. Here's an example of what the array looks like: 123456 Doe John 11223 Smith John I need to be able to take the first three, (userid, last name, first name), and insert them into their respective columns in the database, and then move onto the next three until it reaches the end. Anybody know how I can accomplish this?
ASP Vs. ASP.NET/Access Database Vs. SQL Databases
Currently I have a site running in ASP on Access databases. Should I make the switch to ASP.net/SQL? I don't know much about the two. Can someone tell me? Also, how easy would it be to convert ASP coding to ASP.net and Access DB's to SQL?
Convert Dates For Databases
This is a date conversion function that works with MS Access, MS SQL Server, or MySQL. It handles short dates (5/5/2005) and dates with timestamps (5/5/2005 23:59:59) that are usually generated with the now() function or dates from HTML forms. It also handles direct SQL queries and the .AddNew() recordset function. Example call using a direct SQL query which requires delimiters: Code:
Transfer Of Data Between Two Databases
Can you pleaseeee let me know if what I am attempting to do is possible? ....and how. I have a Access database at backend of my ASP site. Is there a way in which I can design a page which will pick up only the records modified/added today in one database and add those to another database? Is transfer of data between two databases possible?
Designing Relational Databases
I have an interview for job which requires following: 1.Modeling and Designing Relational Databases 2.Database applications for the web 3.Server side Programming using PHP 4.Macromedia Flash and Dynamic Data 5.Internet and Web Protocols 6.Installing Apache Web Server, PHP and MySQL 7.Authentication and Security 8.Integrating Streaming media into web development 9.Understanding Mobile Communications can anyone pls suggest me what Dynamic Data in point 4 means?Also what is Integrating Streaming Media of point 8?and when it says mobile communication.
How Do I Copy Tables Between Databases?
I wish to copy the contents of a table in one Access database to an identically-structured table in another Access database. Can anyone advise me of a simple way to do this in ASP (VBScript + ADO) ?
Databases File Access
Is there a way to upload a file first to a directory (which is have done) and then either upload it to a database or referance it within a database
Databases, Passwords, & Security
I need to tighten up security on my page... only thing is, I can't change file permissions. I have databases and normal files (.dat) that I don't want someone to be able to just type the URL to and be able to get into it all. For example, I have a database with usernames and passwords, but if someone found out/guessed the URL of the DB then they could open it all. how can I use Encrypt in Access so that if someone guessed the URL then they couldn't just open it? Basically, I know how to do that in Access... but what I don't know is what code to add to my ASP pages to decrypt/un-password protect it so I can open it. If it is possible to stop someone from having access to a file by just using global.asa.
Selecting Data From Two Databases
I am trying to write a SELECT query in ASP to retrieve information from two databases (that must be kept seperate :-(). I have managed it using Access using something similar to the code included below, which I have modified for ASP. Looking around this seems to not be possible in ASP, instead the general recommendation is to link tables??? I would prefer to do it using ASP. Code:
Syncronising Results From 2 Databases
Select multiple results from databaseB based on results from databaseA. Table A returns all ("contid") where session("userid") = rs("userid"). so the results are simple i.e. User has a reference to ("cont id") = 1, 3, 5, 6 but when I try to get all the details about each ("contid") 1, 3, 5, 6 from Table B it gets stuck after the first one. Code:
Selecting Random Records From 2 Different Databases
I have a tough question that i ca't get over it for all the day. I have two different news tables. I can't get any of them and list. Bu i want to do something different. I want to get both and randomize them and list them. for example, 1. news (from the 1st db) 2. news (from the 2nd db) etc. is that possible, because i couln't find any solution for this.
Asp : Compare Records In Two Access Databases
i've googeled to find a asp-script that can compare all the records in two different access databases the mdb's have exactly the same tables what i want is that (the output) all the differences comes in a html-table in a webpage can anybody help me, are give me a example ?
Comparing Arrays From Two Databases For Validation.
I have an ASP page where I build a table with specific links based upon an Array (array1) from a SQL Server Stored Procedure. Everything works. Now I am told I need to validate the Array(array1) from a table located in a different DB. I figure I can build another Array (array2) from another SP and then do a compare to build yet another Array (array3) that will be used to populate the table. The two tables are not the same except the second table will have the same "ID" for each record that is valid. I have been searching high and low for an example of the loop statement(s) I would need to do this. I can not find anything. Can this actually be done?
Reading Data From Multiple Databases
i have data in multiple access databases (not multiple tables within one database file) and was wondering if there is a way with ASP to display selected data on one webpage from these different databases?
ODBC To Multiple MySql Databases
The code below gives error when executing the sql, because ODBC can't connect to the second database (DB_ANA). Code: strConn = "driver={MYSQL ODBC 3.51 Driver}; " strConn = strConn & " server=localhost;port=3306;Option=16834; Database=db_cciaa;UID=ivmn;" Conn.Open strConn sql = "SELECT SC.COGNOME, NA.VIA FROM DB_CCIAA.TB_SELEZIONATE AS SC LEFT JOIN DB_ANA.TB_ANA AS NA ON (SC.COD_FISCALE = NA.CF)" set rsProva = conn.execute (sql) It seems to me incredible that I couldn't execute a join between different databases in MySql, also because it isn't possible to create links to different databases as in Access I do.
Searching Access Databases And Their Embedded Documents.
I've had a look and found a few items on searching a database but I need something a bit more complicated. I want to store documents in a database, I also want to have a web page view and pdf download of the documents available (easy enough if I just embed the URL of the locations). The problem is I want to also be able to provide a search page that allows the user to search the documents and the database (for authors, date etc) using the same page. So the question is what's the best way to start with the database and pdf docs and end up with a web view and search engine for it. The database is Access btw.
How To Enter Data In Multiple Databases On Login Basis
I am new user of ASP and as well as this forum, i want to make a web page, to enter data,in which , first user login page, then he enter data on his authorize database, database names are same as user login name. e.g if someone login as user xyz he must open xyz.mdb, and if other login as abc he must open only abc.mdb to enter data, and data entry page must validate fields such that numeric fields, text fields, numeric lenght, etc
|
TRACKER
