I hv two seperate webpages that need to write to completely unrelated tables that reside in one database. The purpose for this is so that I can re-use old page code AND not have to create a new database to hold information from the second webpage. At the moment, I'm not sure if the error is in my code or in the database setup.
The first table and first webpage interact perfectly. Data can be written and retrieved. A new table was added to that database, then the webpage was copied and the code was changed to point to the new table. This forms the second page and table. Both tables are in the same db. The problem is, no data gets written to the new table nor reflects on the webpage.
I am creating ASP Pages linked to an Access 2003 database and Dreamweaver MX2004 I have several product pages two of which have detail pages when I create the record sets with a filter on the product type and test these they show the correct records from the database.
But when I try to view the webpages through my localhost server by calling the default page this page is ok then I have a dropdown menu to select the product pages I get the following error message This page cannot be displayed error Line 15 of the product page the error is [RSXXX.ActiveConnection = MM_XXXX_STRING] I also get the message that the database is already in use.
Can you link to the same database with several product pages by creating there own recordsets and filtering the records you want to appear on thet particular page and the respective detail page, or will this not work.
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.
The data for our bookings is held in an Access database and I can manipulate the date format as much as I like in Access but it doesn't make any difference to what appears in my webpage. Code:
I know VB5/VBA very well but have not used VB to create web pages but need to do so. Can someone explain the purposes and differences between VBScript and VB.NET to create web pages?
Also where do Visual Web Developer Express Edition and Microsoft Frontpage fit into the picture? It seems there are a bewildering array of choices in creating websites using Microsoft tools.
I am doing a research on a project for my website. there is a web page which runs on a server other then my own server and i want to get some(not all) of the contents of that page and show it on my own page. Is there a way to do it with asp or asp.net?
I am wondering if it's possible to simulate the Multiple Document Interface in ASP/ASP.NET webpages? Maybe using DIV layers? I am trying to create the little document windows in an application, but in a webpage. I need dragging, overlap, focusing, resizing capabilites. Also must be able to encapsulate another DIV layer within this DIV layer. Is this possible? Does anyone know a library (already-made) div/layer MDI windows for webpages?
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
I have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:
I need some help with a SQL statement. I currently have which works:
strSQL = "SELECT * FROM mstJobs WHERE JobStatus = True"
I need to query against a second table but I am not sure of the correct syntax of the statement for adding another table.. somthing like this i would imagine... ????
strSQL = "SELECT * FROM mstJobs.pmdata WHERE JobStatus = True AND WHERE WeekEnding IN tblSuperInput.pmdata = strThursday"
I have a form in my HTML page and I require a number of checkboxes. These are to be dynamically generated from an Access database. The code below will work but it will only create a single row. How can I include the <TR> tag inside the loop - I'd probably want 4 cells per row
I am trying to list data from the DB from three different tables. The first table is creditors, the second is statements and the third is payments. I don't know much about inner joins and I'm not even sure that's what I need to do. The first section on the page is detailed information about the creditor.
Below that is a section for a summary of all statements from that creditor. Below the statements section is a section for listing payments from that creditor. The 'creditors' table has a field of "credID" as well as the tables "statements" and "payments".
The "statements" table has a "StatementID" field and the "payments" table has a field of payID. What is the best way to list the statements and payments from a particular creditor?
Ithe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.
I dont even know if ASP is the right language to be doing this, but what I am basically trying to complete is a way for a dropdown box to come, and depending on what they select data will go into a table. For instance, the dropdown will what type of taxpayer they are and if they select individual, the offered services will appear in the table.
I have an application that creates online quizzes, each quiz has a results table generated by ASP on MS SQL Sever.
What I want to do is compare the SQL structure / code of the table I am about to create with the SQL structure / code of an existing table (previously created in ASP) to see if they are the same.
So how can I get the SQL structure of a table that already exists in my database into an ASP page?
Each table contains the fields: ID(autonumber),Title, Artist, Description, DiscNo, and TrackNo. The second of the two contains an additional field: Price.
How would I make an asp page in which a person enters DiscNo and Price into a form and the code would read all the fields of that record from table1 and then add those and the Price into table2?
strSQL = "SELECT x.CountryId, x.CountryName, y.SiteId, y.SiteName, z.LocationId, z.Level FROM TableCountry AS x" strSQL = strSQL & " INNER JOIN TableSite AS y ON (x.CountryId = y.CountryId)" strSQL = strSQL & " INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)"
Error Type:
Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression '(x.CountryId = y.CountryId) INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)'. /system1.asp, line 21
i have an sql query that needs to join 3 tables to get the desired answercouldnt think of a better way )
Code:
SELECT * FROM Sold INNER JOIN Serial INNER JOIN TempSerial ON Serial.SerialNo=TempSerial.SerialNo ON Sold.SoldID=Serial.SoldID WHERE Sold.CustomerCode='"&customer&"';"
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
I've a (classic) ASP web page that has several tables on it that have identical columns (headings).
When these tables are displayed they of course have different widths, based upon the amount of text within each column.
I have been asked to make all tables have identical column widths.
What I thought I would do would be to have some sort of column-width counter that counted the maximum number of characters in column A in all tables, and another for column B in all tables. From this I would have to come up with some algorithm (not yet done) to turn the number of characters into a column width (based upon font family and font size chosen).
This value would then be put into a programmatically generated style sheet. However, a quick prototype shows that the style sheet appears to be ignored if it's at the end of the document (even if in a <head/> tag) and the aforementioned algorithm would appear to be rather complicated.... Code:
I have this page with a drop down box which loads the itemnumbers dynamically. However, I want it to NOT load the numbers that already exist in the weborderlist. What can I do to my SQL statement to make this work?
Code:
SELECT (SELECT img_inv.item_num from img_inv, weborderlist WHERE img_inv.item_num <> weborderlist.item_num and weborderlist.orderid= '1') as test
Okay, I have a db that contains 1 table. it has some house info and stuff in it, but I want the updates and news and stuff on my site to be dynamic.
So should I make a new table inside my DB and use that alongside the house info table? What would be the best way to accomplish this, and if possible, do u have to set a recordset up for EACH table?
I am trying to delete records from a MS-Access DB table using the following query:
strSQL=DELETE FROM MyTable WHERE [id]=CInt(Request.QueryString("delete")) con.Execute strSQL
When I run the app on my local IIS 5.1 server (on WinXP SP2), records get deleted without any problems but when I upload the same file (which has the above DELETE query) to the actual remote server, then ASP generates the following error:
Could not delete from specified tables.
I have gone through numerous posts & articles to resolve the issue but unfortunately the error still persists. The only apprehension that comes to my mind is could permissions to the directory which houses the MS-Access DB table be the cause of this error.
Actually in the remote server, the Access DB table resides in a directory named "db" (without the quotes). When I view the permissions that IUSR_MachineName has for this "db" directory (through the web browser - the hosting service has given this option), then I find that IUSR_MachineName has only the Read permission but when I try to set this directory's Write & Modify permissions for IUSR_MachineName, then I am not being allowed to do so. So could this be the cause of the error?
I have a MSAccess 2000 mdb where 2 tables must be connected with a fieldname "book_spoke". This is what I have so far. Is it right? The purpose is to find within the search result all the book_spoke s and link with the proper url for each book_spoke. Code:
if there was any site with a public domain example of how league tables (such as football/soccer tables) could be maintained using ASP and Access databases.
