Modify Multiple MDB Table Designs
I've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: sync all MDB designs (and/or data) esignated to match one I've added some fields/tables to OR go into all designated MDBs and create new field(s) or table(s).
I've began writing something like this that right now just does part of (b) but I'd rather find something that is much more slick and complete.
View Replies
ADVERTISEMENT
I need a member login system for one of my web sites where only the members are allowed to read articles published.
View Replies
View Related
I want to do is search through a database based on what was selected on a form.It will be based on state, county, and category.Out of the search I just want one field out of the database, the email field. Now, at first I had one table to mess with so I was using this:
strSQL = "SELECT DISTINCT EMail FROM Info WHERE Category='" & category &"' AND State='" & state &"' AND County='" & county &"'"
the way the database is going to be set up now what I need to do is search through one table that will have all the states, counties, category, and UserID fields.Then it has the other table that will have a UserID field and an email field.So I guess it needs to go through the first table and depending on what state, cat, county were selected it will take that UserID and match it to the UserID in the email table and then pull the emails that match UserID.UserID? Would this use JOIN? UNION? How would this be done, to take the form info and search the one table and then depending on what userid matches the state, county, and category in that table it matches that userid to the userid in the email table and pulls the emails from the email field.
View Replies
View Related
Can i open a second table while another table is open within one database? I did attempt but i get this error. Code:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
View Replies
View Related
Basically I have the following SQL statement:
Quote: sqlConnect = "SELECT Users.User_ID, Users.Password, Users.Username, Event.Event_ID FROM Users LEFT JOIN Event ON Users.User_ID = Event.Admin_ID where Username = '" & Username & "'"
set rs= Server.CreateObject ("ADODB.Recordset")
rs.open sqlconnect, objconn, 3, 3
where username is an ASP variable of the username.
When I run this and I try to access a field from event I get an error i.e.
Quote: if rs("Event.Event_ID")<>")" then
session("admin")= rs("Event.Event_ID")
end if
Does anyone know what is wrong?!?!?! It doesn't seem to be able to pick up the fields from the event table?
View Replies
View Related
I'm trying to do a multiple count on different tables in my database, but it's not working. At the moment I have this SQL query, Code:
SELECT COUNT(*) AS articlecount, COUNT(*) AS faqcount
FROM article, faq;
This doesn't work though. If there are 2 articles, and 3 FAQs, it will still say 2 FAQs
Can anyone give me the proper SQL query, if possible?
View Replies
View Related
I am using a db to hold student data records. I currently display them in a roster based on their affiliation with a certain class. To edit a record I need to click the name of an individual, it opens an edit page, I make the changes, hit submit and return to the roster.
This is pretty standard stuff. What I would like to do is change one field of every record without opening each record individually. The idea comes from my Fantasy Fball league roster:
McNabb, Donovan QB PHI ActiveReserve
Droughns, Reuben RB DEN ActiveReserve
Johnson, Rudi RB CIN PIT ActiveReserve
...etc...
Where the example above says "ActiveReserve" is a pull down menu that lets me change who is playing week to week. I can then change each record, hit submit one time, and update the db. So how do they do it?
View Replies
View Related
Does anyone know how to insert multiple records in the same table at the same time. This is what I have. I have a form with 6 fields and they are name prod1 through to prod 6. The table is called related products.
Basically this table is related to the main table called prod_parent. tried looking on google and couldn't find anything.
View Replies
View Related
I already have this piece of code that inserts multiple rows of data into a single table at once. Code:
View Replies
View Related
I can trigger these events successfully if table only has one row:
Sub InputField_OnChange()
......
End Sub
But, these events cannot be fired if table has more than one row, why?
View Replies
View Related
How do I change the text between a carriage return and a colon ":" in a variable?
I am calling a memo field in a recordset and want to change the format of text (colour) between these two points. How can I do it?
View Replies
View Related
I want to erase a line (or modify a number) in a text file throught asp, how do I do that? I have noticed that there are three ways of opening files,
1=ForReading - Open a file for reading. You cannot write to this file.
2=ForWriting - Open a file for writing. (If open an existing file, it deletes everything)
8=ForAppending - Open a file and write to the end of the file.
How can I just skip a few lines and erase a destinated line or maybe change a word in a line. without using an brute force (copy the file back and forth...)?
View Replies
View Related
I've built an array like this and I've put it into an application:
Code:
If not isArray(Application("utenti"))thenDim online(1,4)online(0,0)=4 online(1,0)=1online(0,1)=5online(1,1)=1online(0,2)=7online(1,2)=1online(0,3)=9 online(1,3)=3online(0,4)=15online(1,4)=3application("utenti")=onlineEnd if
Now is it possible to modify some values in this application-array?For example trying to set the value in position 1,1 equal to 3 I wrote: application("utenti")(1,1)=3
or
Redim Preserve application("utenti")(1,1)
application("utenti")(1,1)=3
View Replies
View Related
I've developed a web app that generates documents (like word files, opendocument, excel etc) let's the user download it to their computer, edit it, and then upload the modified version, where it would be stored in a database.
I'm trying to find a way to let the user edit the file on-the-fly, and when saving it automatically update the database. That is, I'm looking for a way to automate the download-open-edit-save-upload cycle. Ideally, when clicking on a link, the user would choose to open the file with the apropiate application, and when saving it the database would be updated. So, any ideas?
View Replies
View Related
Does anyone know if there is a way of changing IIS settings using ASP specifically:
"The content where this content should come from" radio button property set on the Virtual Directory Tab (of a VD).
View Replies
View Related
I managed to find the problem with my script thanks to jmurray's help. However I am now left with a confusing puzzle and I cannot any information about a workaround.
The error I now get is:
Cannot modify or delete an object that was added using the COM+ Admin SDK
I know now the reason for this is because I changed the 'from' email address in my script. If I put it as 'service@safetouch.com' it works fine. If I change the address to ANYTHING else, I get the above error. Is this something that can be corrected through scripting? If not, any ideas where I should be looking?
View Replies
View Related
I have a databse in MS Excel which I would like to use it in ASP? I got instruction on how to open and display the Excel databes in ASP, but I cannot make it to modify/add/delete the records.
View Replies
View Related
any way to modify text content of a word document through ASP?
View Replies
View Related
I'm looking for a code already written if it is possible (as i need to do this soon)I have a database(access) and the users submit data from a asp page and it stores the values. Then it also allows the users to login to the web page using the data (username and password) inserted by the user.
What i want is that when the user logins, to be able to modify the inserted data..Perhaps the user wants to change the e-mail address. I tried doing some search in google but the results were no good.
View Replies
View Related
I would like to modify IE page setup before printing the window. But i want to do it without opening the FILE-> Page Setup window. In fact, i would like to remove the header and footer of pages beforeprinting them. but i want to do it using asp or vbscript and without any end user action.
View Replies
View Related
From the ASP application I am trying to 1) open a template 2) add data to a couple of fields (passed from order.asp to invoice.asp) 3) do a Save As so that the user can save to client.
I have this code working fine for a word document, but I am having touble with the XLT. Any suggestions?
View Replies
View Related
I have a program that will need to update a certain table entry repeatedly - so I want the transaction to take place without using up too much time or system resources. I basically want to update the field with the current time i.e. Now(). Let’s assume:
The table is called tblExample. The field is called LastTime.
I could do this very easily using record sets, but I understand that using pure SQL is much faster than using record sets. So, how would I update the field using only SQL?
View Replies
View Related
I created an asp page it looks different when looked from an 1024x768 than it looked on 800x600 resolution. how to control this?
View Replies
View Related
I manage to solve the last problem, but now I've encountered another one. I think there is something wrong with the UPDATE statement in this code. I am using Oracle 8i and Sun One ASP. Code:
View Replies
View Related
I have an Excel Template that is filled out in certain senarios. What I want to be able to do is access this existing Excel Template through a webpage, enter nessisary data into the template, and then e-mail these changes to certain people. The original Excel template needs to stay Unfilled out and unmodified once the process is complete. If saving a different copy to e-mail is nessisary that is ok. I have Created the Excel object on the server to be filled with database info from a query, but I'm not sure how to open an current excel document and then email that document onces it is filled out..
View Replies
View Related
I need to alter a dremweaver Update Record function but am a bit lost with it. I basically need to take the values from 3 drop downs that let you selct the date (day, month year). I've written a variavble that adds these together to make a date:
JJ_theDate = Request.Form(selectDay) & "-" & Request.Form(selectMonth) & "-" & Request.Form(selectYear)
but have no idea how/where to slot this in with Dreamwevers code (below) that does the SQL update.. Code:
View Replies
View Related
If anyone can guide me to change my basic data results link bar buttons (First, Next, Previous Last). I will like to use my custom arrow buttons but don't know how. The default buttons are generated by default with i create a query. Where do i go to modify these buttons, and what code do i use in the new buttons i will like to use....
View Replies
View Related
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
View Replies
View Related
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
View Replies
View Related
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
View Replies
View Related
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
View Replies
View Related
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
View Replies
View Related
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies
View Related
